Interactive
Goodwill

Gcf Global: Excel Formulas

For Students 9th - 10th
In this interactive tutorial, learn how to create formulas to solve real-world problems.
Handout
Science Struck

Science Struck: How to Calculate Percentage Increase

For Students 5th - 8th
Explains and demonstrates how to calculate the percentage increase from year to year and how to calculate it using an Excel spreadsheet.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M2: L2: Shortcuts Anyone? Calculate With Functions

For Students 9th - 10th
In Module 2 Lesson 2 of this course on spreadsheets, students learn how to use the built-in functions in Excel so that they don't have to retype a formula each time they use it. Includes slideshow tutorials.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M2: L5: Show Me Your Skills: Practice Skills

For Students 9th - 10th
In Module 2 Lesson 5 of this course on spreadsheets, students review what they have learned in the previous four lessons about formulas, functions, and manipulating a spreadsheet. Content is stored in the Resources section. Practice...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M3: L2: In the Library: Calculate With Functions

For Students 9th - 10th
In Module 3 Lesson 2 of this course on spreadsheets, students learn about naming cells and cell ranges and how a name moves with the range it is attached to. Names can also be used in constructing absolute cell reference formulas....
Lesson Plan
Other

Personal: Let's Go Shopping

For Teachers 9th - 10th
This personal site provides a student activity that allows learners to practice spreadsheet skills in inputting data and creating function formulas. The activity is based on the collection and comparison of shopping receipts using max,...
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...