+
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Simple vs. Compound Interest Spreadsheeting the Difference

For Teachers 9th - 10th
A lesson plan that includes a PowerPoint learning module for students. The goal of the lesson is to learn the difference between simple and compound interest and to use the functions in Excel to perform the calculations and graph the data.
+
Website
Teachnology

Teachnology: Spreadsheet Guide for Teachers

For Teachers 9th - 10th
A Spreadsheet is a wonderful tool with applications well beyond simple calculations. This site provides a collection of lesson plans, tutorials and worksheets that help bring spreadsheets into the classroom.
+
Interactive
Goodwill

Gcf Global: Google Sheets

For Students 9th - 10th
In this tutorial, learn how to use the powerful tools in Google Sheets for organizing, visualizing, and calculating data in a spreadsheet.
+
Interactive
Goodwill

Gcf Global: Excel Formulas

For Students 9th - 10th
In this interactive tutorial, learn how to create formulas to solve real-world problems.
+
Interactive
Goodwill

Gcf Global: Excel Tips

For Students 9th - 10th
Learn these Excel tips and tricks so you can do more with this popular spreadsheet program.
+
Activity
BBC

Bbc Bitesize: Spreadsheets

For Students 9th - 10th
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.
+
Unit Plan
Goodwill

Gcf Global: Excel Formulas: Functions

For Students 9th - 10th
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...
+
Unit Plan
Goodwill

Gcf Global: Excel Formulas: Complex Formulas

For Students 9th - 10th
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...
+
Unit Plan
Goodwill

Gcf Global: Excel Formulas: Simple Formulas

For Students 9th - 10th
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...
+
Handout
National Council of Teachers of Mathematics

The Math Forum: Spreadsheet Basics

For Students 9th - 10th
A simple introduction on how to create a spreadsheet.