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.
Curated OER
Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions
Learners improve data entry in a spreadsheet.
Curated OER
Sales Spreadsheet
Young scholars use Excel spreadsheets to organize purchases, discounts, sales prices, and sales tax. Students follow step by step instructions and enter formulas as well as use the auto sum feature to calculate required calculations.
Curated OER
Electronic Hydrology Lesson Plan - Revised
Students use Excel spreadsheets. They predict time and height of peak flow on river
Howard Hughes Medical Institute
Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation
If you've always wanted to know more about spreadsheets, here's a perfect resource for you. A self-paced tutorial introduces how to autofill and copy formulas in a Google sheet or Excel spreadsheet. It also shows users how to find range,...
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
Break Even Analysis and Budgeting
Young scholars analyze the use of break even charts in business planning. They examine the purpose and nature of budgets. They explore price elasticity and how to use Excel spreadsheets to manipulate financial information.
Howard Hughes Medical Institute
Measuring Biodiversity in Gorongosa
Take your biology class' understanding of biodiversity to a whole new level! Ecology scholars use data to calculate three different diversity indices based on the organisms in the Gorongosa National Park. The four-part activity uses an...
Curated OER
Chaucer's Characters in The General Prologue
Twelfth graders explore the characters in The General Prologue. They describe the characters and their occupations and their lands of origin. Students organize the characters using Excel spreadsheets.
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
Spreadsheet formulas
Learners, while in the computer lab, practice using formulas, print options, functions and adjusting column widths while interacting with a spreadsheet program. They modify and use spreadsheets, after being given a scenario, to solve...
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
Buying a Car
Eighth graders create spreadsheets to calculate payments. They create a list of items they would like to purchase that require monthly payments. They simulate buying a car and create a spreadsheet to determine the amount of the monthly...
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.
Pingry School
The Water Lab – Spreadsheet Simulation
More than 70 percent of people and 90 percent of businesses use spreadsheets regularly. While many courses overlook the important skill, the simple water lab focuses on entering spreadsheet data, formatting it, and printing plots based...
Curated OER
Fraction Strips on Excel
Sixth graders create three different sets of fraction strips using Excel by following a packet of instructions that taper off as the students gain confidence in their knowledge of Excel. They copy and paste the strips into Word so that...
Curated OER
Super Spreadsheets
Young scholars discover information about each of the fifty states in the United States. In groups, they create a spreadsheet organizing the information to show to the class. They discover different ways to display the data and...
Curated OER
Introduction to Spreadsheets
Sixth graders utilize Excel or other spreadsheet software to create both text and numerical valued columns to produce a Christmas or birthday wish list. They study the difference between text and numerical values for column use and...
Curated OER
Exploring Careers
Seventh graders investigate their career aptitudes and interests through a scavenger hunt. They display their choices in Excel spreadsheets.
Curated OER
Holiday Cards using Publisher
Learners create a holiday card using technology. In this technology instructional activity, students use Publisher templates to create a holiday card. Learners organize, design, and edit their card.
Curated OER
Graphically Speaking
Students discover the links between population and Congressional representation. In this government lesson, students research population statistics and create spreadsheets that compare population to the number of Congress members per state.
Curated OER
What's Playing Tonight?
Students collect data and visually represent it. They conduct a survey of favorite movies. Using a spreadsheet, students organize the data and create bar and circle graphs. Students answer statistical questions regarding the data.
Curated OER
A Comparison Study of Water Vapor Data to Precipitation over North America
Students use NASA satellite data to compare water vapor over the United States. In this data analysis instructional activity students use an Excel spreadsheet to map their data.
Curated OER
Creating Climographs
Students use satellite data to compare precipitation and surface temperatures on different islands. In this satellite lesson students create graphs and explain the differences between weather and climate.