+
Online Course
Other

Learning Link Finders: Filtering an Excel Database

For Students 9th - 10th
This course will teach you to filter an existing Microsoft Excel database and extract records meeting your criteria. It will cover Data Form Searches, AutoFiltering, Filtering to Match a Selection, and Advanced Filters. A Live Database...
+
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...
+
Website
Other

Function X: Microsoft Excel Tutorial

For Students 9th - 10th
This site offers tutorials and examples on how to use Microsoft Excel applications and experiment with it.
+
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.
+
Lesson Plan
Other

Laus Dnet: Grade 5 Excel Lesson Plan

For Teachers 3rd - 5th
In this online lesson, 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 will be the...
+
Professional Doc
Other

Microsoft: Template Gallery for Teachers

For Teachers K - 1st
This Microsoft site provides a wealth of Office templates to be used by teachers. Such templates include attendance records in Excel, essay tests in Word, seat assignments in PowerPoint, and much more.
+
Handout
Computer Hope

Computer Hope: Tips Relating to Microsoft Excel

For Students 9th - 10th
A listing of various tips that can be used with Microsoft Excel. Find out ways to work better and more efficiently with this spreadsheet program.
+
Lesson Plan
Council for Economic Education

Econ Ed Link: Using an Excel Checkbook

For Teachers 9th - 10th
Learners will use a spreadsheet to enter checkbook transactions and reconcile.
+
Website
Other

Jan's Web Work: Jan's Illustrated Computer Literacy 101

For Students 9th - 10th
Illustrated and interactive web tutorial that guides learners through to achieving strong, basic computer knowledge. The tutorial is broken into chapters with interactive quizzes.
+
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M1: L2: Ethical and Efficient Use of Computers

For Students 9th - 10th
In Module 1 Lesson 2 of this course, students are introduced to issues related to copyright, public domain, and licensing agreements. They will also learn about industry certification for this course on spreadsheet applications.
+
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...
+
Website
Goodwill

Gcf Global: Excel 2016

For Students 9th - 10th
A website with 33 links plus a quiz on how to use Microsoft Excel 2016. Topics include Excel 2016 Basics, Working with Cells and Sheets, Formulas and Functions, Working with Data, Doing More with Excel, and Extras.
+
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.
+
Activity
Other

Lt Technologies: Creating Pictographs With Excel

For Students 3rd - 8th
Concise set of directions teaching how to create a basic pictograph using Microsoft Excel.
+
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.