Lesson Planning

Lesson Planning Waynesburg University Pre-Instructional Planning: The thought process that leads to the development of quality, meaningful lesson plans Guiding questions that will provide the framework for the lesson. (Respond to each question.) Who will you be teaching? (Identify student grade level as well as academic functioning level and specific needs of individual students)

Will be teaching teachers at the high school level. Who (if anybody) will assist with the presentation of this lesson, and what will their role be?

No one will be assisting. What is the long range goal(s) that is tied to this lesson?

The long range goal is to incorporate use of Microsoft Excel in teaching math in high school classrooms. What is the specific learning objective(s) for this lesson?

The learning objective is to use a powerful spreadsheet program such as Microsoft Excel to do calculations for teaching students math. What prerequisite skills/knowledge will students need to effectively access and participate in this lesson?

Basic computer skills. When within the stages of learning will this lesson be presented? (Is it a learning acquisition lesson, learning fluency lesson, learning maintenance lesson, or learning generalization lesson?)

This is a learning generalization lesson. When will this lesson be completed? (Will it be a one-day lesson or a multiple day lesson?) This will take three days. Where should this lesson be presented to ensure maximum student access and participation? (computer lab, classroom, science lab…) AND

This will take place in a computer lab. what materials will be needed?

Computer with Microsoft Office installed. Why are you planning to teach this lesson? Why must this information/skill be presented to the students?

This lesson was planned because math instructors wanted knowledge of using Excel spreadsheet calculations to teach students math. How does this lesson relate to the PA Academic Standards?

NA

How does this lesson relate to the previous lesson? How does this lesson relate to future lessons?

NA How will you determine if students have met the lesson objective? (Think assessment)

Students will create their own spreadsheet in Excel and present it to the class. How should this lesson be presented to ensure maximum student access and participation? (lecture, whole group activities, small group activities, cooperative learning groups…)

Students will give a demonstration on their spreadsheet.

Lesson Planning Waynesburg University Writing the lesson plan: Translating thoughts into a plan of action _____________________________________________ Pennsylvania Academic Standard(s) addressed during this lesson: (Provide Standard number and statement)

NA Lesson Objective(s) (Stated in observable and measurable terms)

The instructor will be able to create a spreadsheet that calculates the average, median, mode, count, maximum, minimum, and sum of a range of numbers. Assessment Plan (What will be done to determine if lesson objectives have been met?)

Students will create their own spreadsheet and test it by presenting it to the class. Materials:

Computer, lab, Microsoft Excel software. Inclusion Techniques for Students with Special Needs:

Computers with special software or hardware. Enrichment Techniques:

NA

Lesson Differentiation (What modifications/accommodations will be made to ensure that ALL students have access to and are able to participate in the lesson): Handouts and/or video, website references.

Lesson Presentation Introduction/Motivational Activities/Anticipatory Set:

Show examples in Microsoft Excel of what can be done in the

classroom with the software. Detailed Teaching Sequence: (Provide sufficient detail that would enable a substitute to effectively present this lesson. Bulleted statements are preferred)

1. 2. 3. 4. 5. 6. 7.

Show users basic Excel features. Where to find certain things and each grouping in the ribbon. Create a blank spreadsheet and name it. Start by entering text and formatting. Overview of formulas. Create the input portion and lock all other cells. Create and format the cells that will contain the formulas and answers. Save and test the spreadsheet.

Guided Practice/Independent Practice/Assessment Activities

Users will be making a spreadsheet that calculates the average, median, mode, count, maximum, minimum and sum of a range of numbers input by students.

Closure:

Students will fill out a survey to grade my instruction.

Lesson Planning Waynesburg University Writing the lesson plan: Translating thoughts into a plan of action _____________________________________________ Pennsylvania Academic Standard(s) addressed during this lesson: (Provide Standard number and statement)

NA Lesson Objective(s) (Stated in observable and measurable terms)

The instructor will be able to create presentation to provide information on their spreadsheet and its use in the classroom. Assessment Plan (What will be done to determine if lesson objectives have been met?)

Students will create their own presentation and present it to the class. Materials:

Computer, lab, Microsoft PowerPoint software. Inclusion Techniques for Students with Special Needs:

Computers with special software or hardware. Enrichment Techniques:

NA

Lesson Differentiation (What modifications/accommodations will be made to ensure that ALL students have access to and are able To participate in the lesson): Handouts and/or video, website references.

Lesson Presentation Introduction/Motivational Activities/Anticipatory Set:

Show sample Microsoft PowerPoint presentations from examples and from YouTube of all that can be included in a presentation and the power it can have on an audience or class. Detailed Teaching Sequence: (Provide sufficient detail that would enable a substitute to effectively present this lesson. Bulleted statements are preferred)

1. 2. 3. 4. 5. 6.

Quick overview of Microsoft PowerPoint. Naming and saving the presentation. Creating and formatting the presentation. Inserting graphics. Saving the final product. Viewing the presentation.

Guided Practice/Independent Practice/Assessment Activities

Users will create a PowerPoint presentation and insert the Excel spreadsheet along with the steps in creating the spreadsheet so they may present to an audience.

Closure:

Students will fill out a survey to grade my instruction.

Lesson Planning Waynesburg University Writing the lesson plan: Translating thoughts into a plan of action _____________________________________________ Pennsylvania Academic Standard(s) addressed during this lesson: (Provide Standard number and statement)

NA Lesson Objective(s) (Stated in observable and measurable terms)

The instructor will be able to embed a spreadsheet that calculates the average, median, mode, count, maximum, minimum, and sum of a range of numbers into a Microsoft Word document. Assessment Plan (What will be done to determine if lesson objectives have been met?)

Students will create their own document and present it to the class. Materials:

Computer, lab, Microsoft Word software. Inclusion Techniques for Students with Special Needs:

Computers with special software or hardware. Enrichment Techniques:

NA

Lesson Differentiation (What modifications/accommodations will be made to ensure that ALL students have access to and are able to participate in the lesson): Handouts and/or video, website references.

Lesson Presentation Introduction/Motivational Activities/Anticipatory Set:

Show sample Microsoft Word documents from examples found on the internet or produced personally.

Detailed Teaching Sequence: (Provide sufficient detail that would enable a substitute to effectively present this lesson. Bulleted statements are preferred)

1. 2. 3.

Quick overview of Microsoft Word. Naming and saving the document. Creating and formatting the document.

4. 5. 6.

Inserting graphics. Saving the final product. Viewing the document.

Guided Practice/Independent Practice/Assessment Activities

Users will create a Word document and insert the Excel spreadsheet along with the steps in creating the spreadsheet so they may present to an audience.

Closure:

Students will fill out a survey to grade my instruction.