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.
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.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Using Microsoft Excel to Explore Gravity Forces and Accelerations

For Teachers 9th - 10th
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.
Activity
Other

Making a Word Find With Microsoft Excel

For Teachers 9th - 10th
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.
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
Other

The Excel Addict

For Students 9th - 10th
The Excel Addict offers free tips, tutorials, newsletters, and more relating to the spreadsheet and database program, Microsoft Excel.
Lesson Plan
Other

Laus Dnet: Grade 5 Excel Lesson Plan

For Teachers 3rd - 5th
In this online instructional activity, students will survey students in their school to determine their favorite type of hand-held ice cream. Before performing the survey, students will make predictions about which ice creams they think...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Creating a Household Budget

For Teachers 9th - 10th
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...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: The Digital Divide: A Data Analysis Activity Using Subtotals

For Teachers 10th - 12th
A lesson plan that includes a PowerPoint learning module for students. The purpose of the lesson 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 accessibility...
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...
Lesson Plan
Google

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

For Teachers 9th - 10th
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...
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
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 Mole in Chemistry: Determining the Number of Atoms in Everyday Items

For Teachers 9th - 10th
Students explore the concept of the mole as a measure of quantity. They build spreadsheets that allow them to convert between moles, grams, and atomic mass units for given quantities of everyday items, elements, and simple chemical...
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...
Activity
TeachEngineering

Teach Engineering: Energy Perspectives

For Teachers 9th - 10th
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...
Interactive
University of Oregon

Magnet Lab: University of Oregon Virtual Laboratory

For Students 9th - 10th
The collection of interactive physics applets offered by the University of Oregon is an excellent resource for students. The applets are grouped in broad subject areas including astrophysics, energy and environment, mechanics and...
Activity
University of Waterloo (Canada)

Wired Math: Organizing Data Grade 7 [Pdf]

For Students 6th - 8th
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.

Other popular searches