Grade: 3
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)