Part One
Spreadsheets can be used in a variety of subjects to help students organize data.
Examples:
Prior to conducting this lesson, my students will survey classmates about their favorites (colors, foods, animals, etc.). Each student will then record their results on a printed spreadsheet and create a bar graph using pencil, paper, crayons, markers, etc. I feel it is important for 4th graders to first learn some new concepts concretely.
Then, I will have my students conduct a similar survey with a different theme and organize data on a spreadsheet. I may modify this assignment by having my students fill out a spreadsheet electronically using Excel. After completing the spreadsheet, my students will fill out the graphing information on the website provided and create a bar graph.
Using a spreadsheet to convert your current age to your age on the different planets is a fun and challenging concept. I would use this as an enrichment activity with advanced students. Students will work together and need my guidance.
This coin toss activity is hands-on and integrates spreadsheets into math. I would conduct this lesson by having students work either independently or in pair. Each student will toss a coin 10-20 times and record their results on a spreadsheet. After recording results, students will create a bar graph and compare their results with a classmate. Create the bar graph reinforces what the students have learned about graphing and provides a visual aide.
Here is another example resulting in a bar graph. However, this assignment will be a little bit more extensive than the initial “Making Bar Graphs” assignment. I could use this lesson with low, medium, and high groups, with some differentiation.
Part Two
Topic: Comparing Planets
Goals:
As a result of this lesson, students will be able to compare and contrast the distances from the sun, lengths of orbit, numbers of moons and temperatures of the eight planets.
As a result of this lesson, students will be able organize data using a spreadsheet.
Description:
Students will work in groups of 2-3 and research all eight planets. Each group will need to identify the planets’ distance from the sun, length of orbit, number of moons, and temperatures. Students will keep track of the information using the spreadsheet below. (This assignment is based off of a Planet Jigsaw I developed for 501. Here is that link: Planet Jigsaw.)
Students will use the following websites to find information for this assignment: