Science Education Resource Center at Carleton College
Serc: Salmon Use of Geomorphically Restored Streams at Point Reyes Nat. Seashore
A lesson plan with an accompanying PowerPoint learning module for students where they learn about coho salmon and a repair done to a culvert in Point Reyes National Seashore. The repair was intended to help the salmon make their journey...
Science Education Resource Center at Carleton College
Serc: Yellowstone! A National Park on a Hot Spot
A lesson plan with an accompanying PowerPoint learning module for students where they learn about the volcanic features of Yellowstone National Park. They use spreadsheets to make various calculations, such as the volume of material...
Science Education Resource Center at Carleton College
Serc: The Digital Divide: A Data Analysis Activity Using Subtotals
A lesson plan that includes a PowerPoint learning module for students. The purpose of the lesson plan is to teach how to use Excel to analyze a large amount of data, in this case from the US Census. The example being used is the...
Georgia State University
Georgia State University: Creating Spreadsheets Using Ms Excel
This Georgia State University site gives in outline form the basic principles of using spreadsheet software. At the end of the outlines, specific uses for spreadsheets in recordkeeping are suggested.
Science Education Resource Center at Carleton College
Serc: The "Perfect" Date: Ranking and Rating Decisions With a Spreadsheet
A lesson plan that includes a PowerPoint learning module for students. The purpose of the lesson is to use spreadsheets to explore a rating and ranking method for choosing someone to date. They look at the problems that arise when...
Other
Nearpod: Spreadsheets: Using Formulas
In this lesson on spreadsheets, students explore the different parts of a spreadsheet and use equations within spreadsheets to learn about their applications.
BBC
Bbc Bitesize: Spreadsheets
Spreadsheets are used to store information and data. Once we have our information in a spreadsheet we can run powerful calculations, make graphs and charts and analyse patterns.
Science Education Resource Center at Carleton College
Serc: Using Microsoft Excel to Explore Gravity Forces and Accelerations
Students will learn about the force of gravity and the factors that affect it, and use and analyze the universal gravitation equation using Excel spreadsheets.
Science Education Resource Center at Carleton College
Serc: Take a Deep Breath on the Appalachian Trail
A lesson plan that includes a PowerPoint learning module for students. They will examine spreadsheet data on air quality in Great Smoky National Parks, and solve problems using ratio and proportion. The exercises will help them to...
Science Education Resource Center at Carleton College
Serc: Simple vs. Compound Interest Spreadsheeting the Difference
A lesson plan that includes a PowerPoint learning module for students. The goal of the instructional activity is to learn the difference between simple and compound interest and to use the functions in Excel to perform the calculations...
Google
Google for Education: Data Aggregation and Decomposition (Python)
Students learn how to use and analyze data to draw conclusions about information collected from classmates. Then they use computational thinking by collecting and aggregating data onto a spreadsheet, identifying patterns in their data,...
Google
Google for Education: Sorting the World's Cities (Python)
The second of two similar lessons where students learn how a Python program can organize and sort data. When taught in conjunction with Sorting the World's Cities with Excel, students make the connection between writing a program and...
PBS
Pbs Teachers: Sports and Math: Batting Averages and More
Set up a spreadsheet using a computer or graphing calculator, and perform calculations using columns. Calculate percentages and solve a system of equations regarding baseball statistics.
Utah Education Network
Uen: Design Your Own Bedroom
Many students dream of designing their ideal bedroom. In this exercise, students will be required to limit their designs by size (as a specific volume) and price (a specific amount). They must design the floor plan, including furniture...
Other
Making a Word Find With Microsoft Excel
Teachers and students can create a word find using Excel. It will help them learn to manipulate columns and rows and format and lock cells. This plan is based upon 10 word or phrases on any topic.
Science Education Resource Center at Carleton College
Serc: Creating a Household Budget
In this Spreadsheets Across the Curriculum PowerPoint module, students create a household budget by tracking their expenditures over a month-long period. Students use Microsoft Excel to create a spreadsheet to track their own...
Microsoft
Microsoft Education Lesson Plan: Candy Is Dandy
Explore color distribution of M&M candies using this detailed lesson plan. An engaging integrated lesson that requires understanding of spreadsheets and formulas, and logical reasoning. Links to related websites.
Goodwill
Gcf Global: Excel Formulas: Functions
A function is a predefined formula that performs calculations using specific values in a particular order. All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and...
Goodwill
Gcf Global: Excel Formulas: Simple Formulas
One of the most powerful features in Excel is the ability to calculate numerical information using formulas. Just like a calculator, Excel can add, subtract, multiply, and divide. In this lesson, we'll show you how to use cell references...
Goodwill
Gcf Global: Excel Formulas: Complex Formulas
A simple formula is a mathematical expression with one operator, such as 7+9. A complex formula has more than one mathematical operator, such as 5+2*8. When there is more than one operation in a formula, the order of operations tells...
University of Waterloo (Canada)
Wired Math: Organizing Data Grade 7 [Pdf]
A collection of worksheets that focus on data analysis and organizing data. Includes detailed examples, colorful visuals, and a link to a related game. Acrobat Reader required.
National Council of Teachers of Mathematics
The Math Forum: How to Make a Bar Graph
Site contains specific directions for making bar graphs using a Claris Works spreadsheet file.
Other
Classroom Tech: Technology Integration
This site offers a variety of ways to bring technology into your classroom. Content includes "50 Ways to Use Technology in the Classroom," filled with learning ideas and activities, as well as a guide for lesson planning and a lesson...
TeachEngineering
Teach Engineering: Energy Perspectives
Students utilize data tables culled from the US DOE Energy Information Agency to create graphs that illustrate what types of energy we use and how we use it. An MS Excel workbook with several spreadsheets of data is provided. Students...