Lesson Plan : TPACK

Lesson Plan (Fishell_LP.pdf)

A.     CONTENT:  The lesson will cover Microsoft Office Web Apps which provide many of the same elements as the features of Microsoft Office 2010 suite.  OneNote is also an Office Web App but will not be covered in this lesson.

The Microsoft Word Web App is a simplified version of Microsoft Word 2010.   It enables users to create and apply basic formatting to documents, insert objects such as tables, pictures, and links, and display documents in different views. The Microsoft Excel Web App is a simplified version of Microsoft Excel 2010.  It enables users to create and apply basic formatting to workbooks, insert objects such as tables and links, and perform mathematical and comparison operations on the data in the workbook. The Microsoft PowerPoint Web App is a simplified version of Microsoft PowerPoint 2010.  It enables the users to create presentations using a variety of themes, layouts, and graphics such as pictures and SmartArt.

Big idea? Students will realize that they can access, edit, and share Word documents, Excel spreadsheets, and PowerPoint presentations from virtually anywhere and anytime.  Learners will understand how they can collaborate online with others who may not have Microsoft Office installed in their computers.  

Standards?  This lesson is geared towards adult learners and although this lesson may not address a specific state or national standard, the lesson still satisfies the learning needs of adults through the consideration of the concept of andragogy while teaching the lesson with technology. 

B.     PEDAGOGY:  It is crucial to consider the andragogical learning theory when creating this lesson.  There are six assumptions of andragogy that needed to be addressed in the lesson:

1. Adults need to know why they should learn something.  The teacher needs to find out student’s expectations and how they might use the lesson in accomplishing their career or personal   goals.
2. The Learner’s Self-concept.  The teacher creates activities that will guide the learners to become self-directed and responsible for their own learning.
3. The Role of the Learner’s Experience. The teacher helps adult learners realize that their knowledge and previous experience in using Microsoft Office 2010 can be give them a better understanding of the lesson.
4. A Student’s Readiness to Learn. The teacher emphasizes the relevance of learning the lesson in order to become more efficient in solving real-life tasks or problems at work or in their daily lifestyle.
5. The Student’s Orientation to Learning. Through project-based learning, the teacher keeps the learners engaged through hands-on activities using real-life case studies to help them achieve a higher level of understanding.
6. Students’ Motivation to Learn. Learning takes place through intrinsic motivation.  Completing the assigned tasks may help motivate students to complete more complicated projects. 

C.    Content & Pedagogy:  Understanding the andragogy theory helps me become perceptive to the adults’ learning needs as I teach them the significance of learning collaborative tools like Office Web Apps.  Students will receive a better learning experience since they are accustomed to the interface that is similar to Word, Excel, and PowerPoint 2010. After completing the lesson, the students will realize that I am the facilitator of their learning and that their learning experience will assist them in keeping pace with their evolving learning needs as they meet the demands of today’s workplace.

 

D.    Technology: I will be using SkyDrive, a cloud computing technology, in my lesson to incorporate the concepts of online collaboration and file sharing using Office Web Apps.  SkyDrive is a “cloud” data storage service and is used to support and run Office Web Apps.   Students will be able to learn how to manage files in the “cloud” using SkyDrive. The major benefit of the “cloud” is the ability of my students to collaborate and share files with other students using web-based applications called Office Web Apps.  SkyDrive enables students to transfer their Office 2010 knowledge and skills when using Office Web Apps.  File management using SkyDrive brings about student confidence of having the files available anytime and anywhere.

E.     Technology & Pedagogy:   SkyDrive allows students to intuitively perform and complete the activities in the lesson.  Activities are used to build students’ self-esteem and sense of accomplishment when student understanding is aligned with the current technology advances.

F.     Technology & Content:  SkyDrive has a simple interface which enables students to learn the concept of using a “cloud” platform.  The lesson on Office Web Apps will allow students to further understand the use of an office productivity suite for file sharing and/or online collaboration.  File sharing and online collaboration encourage students to help each other work toward a common goal and to motivate students by giving them more options in accomplishing the learning activities. 

G.    Assessment:  To evaluate if the learning objectives have been met, the students will be assessed on their completed hands-on projects. All completed projects will be accessed and stored in SkyDrive.  The projects involve tasks such as:

        - creating and updating a document, presentation, and workbook using Microsoft Office Web Apps. 
        - sharing their files with selected others, or with everyone.
        - viewing and editing shared files simultaneously.