Spreadsheet Teacher Resources
Find Spreadsheet educational ideas and activities
Showing 81 - 100 of 3,169 resources
Create a Budget
Students develop a budget spreadsheet to manage finances for their business. In this finance lesson plan, students use a spreadsheet program to create a budget with credit and debit columns. There are step-by-step directions for creating a spreadsheet on Microsoft Works.
6th - 7th Social Studies & History
A Line Graph of the Ocean Floor
Students develop a spreadsheet and import the information into a line graph. In this spreadsheet and line graph instructional activity, students develop a spreadsheet of ocean depths. They import the information into a word processed document.
4th - 5th Social Studies & History
circulation System: The River of Life-ID: 8305
Ninth graders analyze and interpret data. In this Algebra I lesson, 9th graders investigate the relationship between the mass of a person and that person’s volume of blood. Students enter date into a spreadsheet, plot the data, determine the regression equations, and use the equation to answer questions.
What Color Are Your Skittles?
Students create a spreadsheet to chart the different colors found in a package of Skittles. They tally the amounts of different colors, enter data into a spreadsheet, create a pie graph illustrating the percentage of colors found in the bag of candy, and explore the Skittles website.
5th - 6th Math
Lucky Charms Graphs
Lucky Charms cereal, yummy! Well, first is an activity about counting and shapes in which your young mathematicians sort, count, and tally the shapes of Lucky Charms. They individually sort and tally small bags of the cereal and answer the question at the bottom of the tally sheet.
K - 2nd Math CCSS: Designed
Becoming a Wise Consumer: Comparison Shopping
Helping adolescents make sound financial choices with effective, accurate cost comparisons is especially important considering how much marketing is directed their way. Make use of varied technology to keep them engaged: text polling, podcast, online ad shopping, interactive games, and online assessment.
7th - 12th Math CCSS: Designed
Students use Excel spreadsheet to determine the amount of ingredients needed, cost of each ingredients, and the cost per serving when cooking a meal. Students conduct an Internet Recipe search finding recipes for an appetizer, main course, and desert and create spreadsheets for each recipe.
9th - 12th Science
Students discover the links between population and Congressional representation. In this government instructional activity, students research population statistics and create spreadsheets that compare population to the number of Congress members per state.
4th - 6th Social Studies & History
In this geography worksheet, students identify how to manipulate data on a range of endangered species. They create a bar graph of endangered animals from Africa, Asia, Australia, North America, or South America. Students use a spreadsheet on the computer to do this activity.
9th - 12th 21st Century Skills
Level III: Technology Integration
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.
4th Technology & Engineering
European Currency Conversions to U.S. Dollars
The use of spreadsheets is quite common when displaying mathematical data. In this currency lesson, learners enter data into a European Currency spreadsheet, and interpret the data to answer questions found on a worksheet which is embedded in the plan.
What Are Your Stats?
While playing an online tic-tac-toe game, students will record their results on the provided spreadsheet. After playing and recording, students will convert their results into fractions, decimals, and percentages. This is a great activity to complete to show the relationship between the three forms of numbers.
5th - 7th Math
"Living in the Limelight The Universal Dream"
Students, using Leo's Lyrics, investigate common themes in popular music. They create a Microsoft Excel spreadsheet that analyzes their findings along with a 200 word paragraph stating their observations, conclusions and hypotheses about popular music.
9th - 12th 21st Century Skills
Historical Population Changes in the US
Students conduct research on historical population changes in the U.S. They conduct Internet research on the Historical Census Data Browser, create a bar graph and data table using a spreadsheet program, and display and interpret their graphs.
9th - 12th Social Studies & History