Rita+Ploetz's+Lesson+Plan

Lesson Plan Number 1

__ Date __ : August 3, 2010

__ Teacher’s Name __ : Rita Ploetz

__ Grade Level __ : Grades 3-5

__ Subject __ : Computers and Math

__ Topic __ : Graphs and Spreadsheets (Create a Graph and Excel)

__ Lesson Summary __ :

This lesson will provide students with a hands-on learning experience in the process of collecting, analyzing, and interpreting data. Create a Graph and Excel will be used to complete this process.

__ Goals (Learning Objectives) __ :

The learning objectives will be communicated to students through the teacher’s demonstrations and handouts.

To collect data. To analyze data. To interpret data. To create graphs.

Students will be allowed to personalize this learning experience by sharing their results verbally and in writing. They will also be selecting a graphic and/or photo that relates to the Excel portion of the assignment. Students’ work will be printed in Create a Graph and Excel.

__ Create a Graph __

Students are to:

Count, sort, and classify M & Ms by color. Record the data. Create and print a pie chart. Analyze and interpret the data. Share the results verbally with your teacher and peers.

__ Excel __

Repeat the same steps as were listed under the Create a Graph section. Create a spreadsheet with gridlines. Select, copy, and paste a graphic and/or photo that relates to the M & M theme in your spreadsheet. Key the results of your analysis and interpretation of the data in your spreadsheet. Key how you will use your knowledge of Create a Graph and Excel in a future project. Select one of the listed project ideas below or share an original project idea with your teacher.

Piggy Bank Coins T-shirt Colors Time Management Print your spreadsheet with your pie chart, graphic and/or photo, and keyed responses.

__ NETS __ : Item 1, 2, 3, 4, and 6.


 * Strategies that Create the Learning Environment **

√ Setting Objectives √ Providing Feedback 1. Rubric created in RubiStar. Reinforcing Effort √ Providing Recognition
 * 1) Personalize.
 * 2) Pause, Prompt, and Praise.
 * 3) Concrete symbol of recognition: certificate.


 * Procedure/Brief Description: **

Students will be asked to complete the following items:

Key the results of your analysis and interpretation of the data in your Excel spreadsheet.

Key in your Excel spreadsheet how you will use your knowledge of Create a Graph and Excel in a future project.

Students will also watch a video from Sesame Street about counting during a pinball animation.


 * Strategies that Help Students Acquire & Integrate New Knowledge **

Cues, Questions, & Advance Organizers √ Summarizing Note taking √ Nonlinguistic Representation Students will watch the Sesame Street video: 12 and Pinball Animation []

Cooperative Learning


 * Procedure/Brief Description **

Students will have access to various newspapers and magazines to locate and share examples of recorded data with and without graphs. They will be asked to compare and contrast their M & M results with the examples that were found in newspapers and/or magazines.


 * Strategies that Help Students Practice, Review, & Apply Existing Knowledge **

√ Homework & Practice 1. Students will have access to various newspapers and magazines. They are to locate and share examples of recorded data with and without graphs. √ Identifying Similarities & Differences 1. Students will compare and contrast their M & M results with the examples that were found in newspapers and/or magazines. Generating & Testing Hypotheses (problem-solving, invention experimental inquiry, historical investigation, decision-making, systems analysis)


 * Procedure/Brief Description: **

The web resources were used to help create this lesson. Students’ work will be assessed by a rubric created in Rubistar.

Type Web
 * Resources: **

[]

[]

Title:

Using Graphs to Investigate Candy Color Distribution What Colors Are Your Skittles?

Specific Info: These resources were used to help create this lesson.

Location: Refer to the above website addresses.


 * Assessment Methods: **

True/False Multiple choice Essay Performance Constructed communication Personal communication √ Product/project graded by rubric 1. Rubric created in RubiStar. Other:


 * Technology Used: **

None Brainstorming/idea mapping software Calculators Clickers Collaborative application (Ex. Wiki) Communication tool (Ex. Skype) √ Data collection tools Diagnostic/prescriptive system (Ex. Accelerated Reader) Display tools (Ex. Elmo) Interactive whiteboard Educational games Multimedia (creating) √ Multimedia (watching) √ Spreadsheet Virtual manipulative Web-based research Word processing Other: