Lesson Plan
Google

Google for Education: Applyng Discrete and Continuous Data in a Spreadsheet

For Teachers 9th - 10th
Students collect data in a spreadsheet and learn to use various functions and analysis tools to better see patterns in their eating habits.
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.
Lesson Plan
Alabama Learning Exchange

Alex: Creating a Payroll Spreadsheet

For Teachers 9th - 10th
Spreadsheet software allows you to calculate numbers arranged in rows and columns for specific financial tasks. This activity allows students to create an "Employee Work/Pay Schedule" spreadsheet to reinforce spreadsheet skills. Students...
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.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: The "Perfect" Date: Ranking and Rating Decisions With a Spreadsheet

For Teachers 9th - 10th
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...
Lesson Plan
PBS

Pbs: Personal Spending Spreadsheet

For Teachers 10th - 12th
This activity helps students create their own personal spending plan.
Activity
Georgia State University

Georgia State University: Creating Spreadsheets Using Ms Excel

For Students 9th - 10th
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.
Lesson Plan
Google

Google for Education: Patterns in the Periodic Table

For Teachers 9th - 10th
Students study trends in the periodic table of elements, supplemented by the use of spreadsheet functions. The spreadsheet functions presented can be used on any data set.
Lesson Plan
Google

Google for Education: Energy Analysis

For Teachers 9th - 10th
Students collect data on energy production and consumption around the world. They input the data into a spreadsheet and use spreadsheet functions to analyze it. Finally, they upload the data into a fusion table to create a visualization.
Unit Plan
Google

Google for Education: Sorting Data

For Teachers 9th - 10th
In this example students use data collected from their class and learn to sort it before calculating the mean, median, and mode. Additionally, students learn how to use spreadsheet functions to sort based on different criteria, leading...
Lesson Plan
Google

Google for Education: Sorting the World's Cities (Excel)

For Teachers 9th - 10th
Young scholars learn to organize, sort, and display data in a Microsoft Excel spreadsheet using latitude data for 120 major world cities.
Lesson Plan
Google

Google for Education: Sorting the World's Cities (Python)

For Teachers 9th - 10th
The second of two similar lessons where young scholars 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...
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.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Cycles of the Sun and Moon

For Teachers 9th - 10th
Students download sunrise and sunset data along with moon phase data, and graph these data sets together in a spreadsheet in order to visualize the cycles of the seasons and the moon.
Lesson Plan
Other

Tonya Skinner Business Ed Lesson Plans: Grocery Shopping

For Teachers 9th - 10th
This personal site provides a student activity that allows learners to plan a class party while organizing the budget details in a spreadsheet program. Learners will demonstrate computer skills in inputting data, formatting data, and...
Lesson Plan
Utah Education Network

Uen: Design Your Own Bedroom

For Teachers 6th - 8th
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...
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.
Lesson Plan
Council for Economic Education

Econ Ed Link: Loan Amortization Mortgage

For Teachers 9th - 10th
How to amortize a loan using an Excel spreadsheet.
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...
Activity
National Council of Teachers of Mathematics

The Math Forum: How to Make a Bar Graph

For Students 9th - 10th
Site contains specific directions for making bar graphs using a Claris Works spreadsheet file.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Know Your Neighbors: Researching the Planets

For Teachers 5th - 8th
Learners will study planets and moons in our solar system by working online and other resources. This lesson has students working together to generate a spreadsheet of data found. Learners will use this information to describe why Earth...
Website
Other

The University of Arizona: Study Finance: Getting Started With Excel

For Students 9th - 10th
A great tutorial that takes you through all the steps you need for mastering the Microsoft Excel spreadsheet application.
Primary
Other

A Practical Approach to Customer Financial Statement Analysis

For Students 9th - 10th
This site describes how to analyze the financial statements of a customer. The concepts can be applied by a business to its own financial statements. Scroll down in the document until you reach the section that describes the different...

Other popular searches