Subject: Computer
Title-
 Recording data onto a spreadsheet that was colected from classmates.
Background-
 Massachusetts Curriculum Frameworks- Technology G3-5: 1.11 Demonstrate an understanding of the spreadsheet as a tool to record, organize, and graph information. G3-5: 1.12 Identify and explain terms and concepts related to spreadsheets (i.e., cell, column, row, values, labels, chart, graph). G3-5: 1.13 Enter/edit data in spreadsheets and perform calculations using simple formulas (+, -, *, /), observing the changes that occur. G3-5: 3.7 Use spreadsheets and other applications to make predictions, solve problems, and draw conclusions.

Expected Outcome Of This Lesson Plan-
 1.To input data collected onto a spreadsheet. 2.To sucessfully use the average and sum key. 3.To work with classmates to collect data.
Teacher Objectives-
 1. Students will collect data from their classmates. 2. The studnets will organize the data onto a spreadsheet. 3. The studentsuse the sum and average function key.
Resources-
 Microsoft Excel, Computer Workstation. paper, pencil, clipboard, Smartboard, flash drive (or SyncronEyes), pre made spreadsheet “Last Night, How Long Did You…” Spreadsheet for modeling
Teaching Methods-

1. Lesson Introduction-

 1.First we will brainstorm how the students would organize lots of data collected from their classmates. 2.Next, I would display an Excel spreadsheet. 3.Last, we would discuss how it could be helpful. 4. Students will be given a copy of the rubric used for grading this activitiy.

2. Lesson Progression-

 1. I would start the class by displaying the attached spreadsheet “Last Night, How Long Did You…” on my Smart Board. 2. I would explain to my students that we are going to collect data on how much time we spent doing homework and free reading the night before. 3. I would model how to insert the data by using myself as the first student. I would then have students insert in minutes how much time they spent doing each activity. As we add more students to the spreadsheet I would guide students to realize that the times are being added up at the bottom of the spreadsheet. 4. I would then model how to use the average function to determine the average time spent on homework and free reading.

3. Guided Practice-

 1. I would have students work in small groups of two or three to decide what they would like their spreadsheet to represent. 2. I would give them the guidelines of “Last Night, How Long Did You…” and create a small list of activities that they could collect data for. For example, talk on the phone, watch TV, play sports, etc.

4. Student Practice-

 1. I would have the students use the spreadsheet provided as a template to create their own spreadsheet. 2. I would have each small group rotate around the room visiting the other group’s workstation to fill in their portion of the data. 3. Once all the data is in I would have the students use the function keys to get the totals and average of each column.

5. Learner Accommodations-

 1. I would pair students according to computer skill and ability ensuring that each group will have at lease one student with high ability 2.I would make all acommodation requred according to a students IEP or 504

6. Assessment-

 1.I would have students share their results on the SmartBoard using SynchronEyes or saving it onto a flash drive. 2. I would encourage classmates to ask questions about the results from their data.

7. Lesson Closure-

 1.I would have students discuss with their group what they have learned from this project 2.Groups would then share one thing they have learned with the class.
Measuring Student Progress-
 1.Students will be evaluated using a rubric.
 The teacher will complete the rubric and write comments about each students progress.

This Lesson Plan is available at (www.teacherjet.com)