Part 1 – Reviews

In reviewing the four following links, I was able to peruse the different links found inside each. I chose these four because I could see many activities and ideas I could use in my fourth grade class. I have shown below just some of what I can use from these sources.

Integrating Google Tools 4 Teachers--A wonderful resource list of ideas on the use of forms and spreadsheets in the classroom (and for administrators, too!) is found here. At the top of the list is “6 ways to collect data using a Google form.” I found this part especially helpful when I was creating my own lesson (found below). "#2- Have students create surveys using Google forms and display on own computer; students travel from machine to machine to fill out the survey" is a time saver and sounds like a fun way to collect data.
This list of helpful tips saves time for the teacher and the student when collecting data, which eventually will end up on a spreadsheet.

LT Technologies, Inc - Spreadsheet Resources – This resource list on spreadsheets includes lesson ideas, standards, and tutorials. I clicked on Elementary then on Group Graphing. Here there are a plethora of ideas for the elementary classroom. I especially like the “Making Things More Interesting …” section. Here I can see my class creating some of the same polls and graphs created in the examples. Students could create graphs with many variables such as favorite foods in the 5 different fourth grade classes, and then compare the 5 classes. Higher-level students can compare and contrast their findings by making their own surveys, spreadsheets, and graphs.

Spreadsheet Activities – This is a resource list of many elementary level spreadsheet lesson ideas. I clicked on Spreadsheet lesson ideas for Everyday Math since this is the math program my school uses. Then I clicked on How Much Tax Would You Pay? This lesson teaches some essential functions of spreadsheets and I can see using this “real world” lesson in my fourth grade class.

Database for Activities – This is a database from Australia of many primary level lessons, activities, and tutorials. I could definitely use this quick reference site to help me plan my lessons fast. One idea I loved was inspired from this conversion chart. Students could create a spreadsheet that will automatically convert measurements,
(ie: 95 meters = ? millimeters).

Part 2 – Lesson Framework- 4th grade

What’s Your Head Size?

This lesson is an introductory lesson on creating the landmarks mean, median, and mode in a spreadsheet. It also reviews the previous concepts maximum and minimum.

  • Students will learn the functions =SUM, =MODE, and =AVERAGE, and they will learn how to find median in a list of data.
  • Students will in turn learn to create their own survey question and create their own Google forms for their classmates to fill out.
  • Students will learn to create their own spreadsheets so data collected will automatically calculate, sum, mean, mode, median, maximum, and minimum.

Collecting Data
During the instruction portion, students will meet in the computer lab in pairs and enter their head size, to the closest half cm, into the Google form that is already created. The form is shown below. Our rows will be the student's name so we know that everyone has participated, and the only column we will have is head circumference in cm.

(Later- For collecting data for the Activity *found below even further*, students will rotate around the lab, going to every student’s computer to enter information on individual Google forms).

big head.png

After students fill out the Google form above, a lesson will follow showing students how their data is automatically entered onto the Google spreadsheet, seen below. Instruction will proceed on how to enter the functions =SUM, =MODE, and =AVERAGE in the correct cells. Students will learn how to calculate median as shown in the spreadsheet below. They already know minimum and maximum, and this will be reviewed.

Later, after all students have had instruction on the three new functions, students, in pairs or individually, will create their own Google forms, asking for data so they can practice their new skills on their own spreadsheets.

Display all of the surveys and spreadsheets created by students.