

Title

Recording data onto a spreadsheet that was colected from classmates. 


Background

Massachusetts Curriculum Frameworks Technology
G35: 1.11 Demonstrate an understanding of the spreadsheet as a tool to record, organize, and graph information.
G35: 1.12 Identify and explain terms and concepts related to spreadsheets (i.e., cell, column, row, values, labels, chart, graph).
G35: 1.13 Enter/edit data in spreadsheets and perform calculations using simple formulas (+, , *, /), observing the changes that occur.
G35: 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. 

