Curated OER
Basic Excel
Students explore basic Excel spreadsheets. In this spreadsheet lesson plan, students enter Alaska weather information and perform calculations. Students title the columns on the spreadsheet and format the cells. ...
Earth Watch Institute
Entering Local Groundhog Data in an Excel Spreadsheet
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
Howard Hughes Medical Institute
Spreadsheet Tutorial 1: Formulae, Functions, and Averages
Spread your knowledge of spreadsheets. The first of five tutorials in the Spreadsheet Data Analysis unit introduces the basics of spreadsheets. It shows future data analysts how to organize and format tables, and how to use functions to...
Curated OER
Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs
Students, while in the computer lab, assess how to use Microsoft Excel as a "graphing calculator." They view visual representations of line graphs in a Cartesian plane while incorporating basic skills for using Excel productively.
Curated OER
Interest Calculation and Spreadsheets
Students, while in the computer lab working on a spreadsheet program, calculate interest and accumulated value of a savings plan. They follow specific directives on how to create their spreadsheets. At the end of the lesson they print...
Curated OER
Weather, Weather, Everywhere!
Sixth graders collect weather data to compare temperatures around the world. Using the Internet, learners collect data, put it into spreadsheets, and analyze and graph the results. An interesting way to cover the topic of weather.
Curated OER
Solving Polynomial Equations
Students demonstrate how to use spreadsheets as a tool for analyzing, visualizing and solving mathematical problems. Students obtain fundamental grasp of cubic equations and other polynomial equations.
Curated OER
Simple Bar Graphs Using Excel
Students create original survey questions, and develop a bar graph of the data on paper. They input the survey data using two variables onto an Excel bar graph spreadsheet.
Bowland
Speed Cameras
Do speed cameras help reduce accidents? Scholars investigate this question using a series of spreadsheet activities. Along the way, they learn about randomness, probability, and statistical analysis.
Council for Economic Education
Loan Amortization - Mortgage
When you buy a home for $100,000, you pay $100,000—right? On the list of important things for individuals to understand, the lesson presents the concept of interest rates and loan amortization using spreadsheets and online sources....
Curated OER
Fast Food Survey Using Bar Graphs
Second graders create a bar graph to pictorically represent the data collected from a survey of students. They use Excel to electronically create the graphs and data tallies. They then interpret their data using sentences to explain.
Curated OER
State Economy Chart
Fifth graders research and record statistics on the economy of an assigned state. They create a spreadsheet in Excel to report the data and a 3D Pie graph using the Chart Wizard in Excel to represent their states' data.
Curated OER
I'm in the Money - Practical Money Skills
Students make a budget and utilize math skills to keep a record of what they spend. They use technology and spreadsheets to help them keep track of their money.
Curated OER
Just Graph It!
Fourth graders evaluate various graphs for the best way to reflect statistical data. They use a spreadsheet to organize data and generate varied graphic representations. They select the graph they feel best shows their results.
Curated OER
Great Graphing
Students collect data, use a computer spreadsheet program to create various graphs, and compare the graphs. They state the findings of each graph in writing and decide which graph type best represents the data.
Curated OER
Fast Food Survey Using Bar Graphs
Second graders conduct survey and sort data according to categories, construct bar graph with intervals of 1, and write a few sentences about their graphs.
Curated OER
A Teeny Tiny Book: My Friends
For this mini book worksheet, students cut apart and complete a teeny tiny book with names of friends and their phone numbers.