Lesson Plans and Worksheets
Browse by Subject
Spreadsheet Teacher Resources
Find Spreadsheet educational ideas and activities
Sixth graders explore uses of the become familiar with spreadsheets in real life situations by analyzing data using hands-on application. They develop flexibility in solving problems by selecting strategies and using mental computation, estimation, etc. Students modify/create and use spreadsheets to solve problems, make decisions, etc.
Students discover spreadsheet applications using Quattro Pro. They demonstrate basic knowledge and application of hardware, software, and Internet use. They recognize and appreciate the value of recording keeping, data input and data analysis using spreadsheet functions and mathematical calculations.
Second graders complete a spreadsheet and make a column graph in the computer lab. They compare the average monthly low temperature in January for their city/state to another city/state's average monthly low temperature in January. Students observe and record weather changes over time.
Fourth graders prepare two spreadsheets each with an embedded line graph that displays data about the growth of the bitter rot fungus on apples and on petri dishes that were stored in the refrigerator and the classroom. They prepare a spreadsheet with an embedded bar graph that displays data that shows the length of the apple peeling of each student in the class.
Students participate in a technology project. This lesson is a hands-on spreadsheet project where students are responsible for keeping track of their grades for class. The students learn to enter data into a spreadsheet, create formulas to calculate the values, and constantly save and retrieve the information.
Eighth graders prepare for a field trip to Washington, DC by researching landmark, monument, or building in Washington. They use the information in small groups to design a multimedia presentation. They include a spreadsheet that shows the economics of the field trip to convince others that it is a worthwhile trip. They design a new American landmark.
Young scholars calculate how much it costs to buy a used car and finance it through a bank. They select a car from the newspaper, conduct Internet research on current auto loan interest information for four different states, and create a spreadsheet to organize the information.
Students ride bicycles or skateboards and determine their average speed. In this physics lesson, students travel to a park and are timed while riding bicycles or skateboards over a variety of courses. They complete an spreadsheet by entering formulas and making calculations.