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.
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: 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: 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 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...
Other
Laus Dnet: Grade 5 Excel Lesson Plan
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...
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: 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: 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...
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...
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...
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 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.
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...
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.