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 plan 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...
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...
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.
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
Alabama Learning Exchange

Alex: Comparing Two Fossil Localities

For Teachers 6th - 8th
During this lesson middle schoolers go on a field trip to locate fossils. Students investigate their findings and identify them using resources from the Internet. They then videoconference to compare/contrast their hypotheses with those...
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...
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...
Activity
Other

Current Electoral Vote Predictor

For Students 9th - 10th
This website is dedicated to tracking the electoral vote by examining the state-by-state polls. The data appears as a map, spreadsheets and table. As new state polls are released, the maps, spreadsheets, and tables will be updated.
Article
LD Online

Ld Online: 10 Tips for Software Selection for Math Instruction

For Teachers Pre-K - 1st
Article at LD Online provides 10 tips to guide teachers and parents in selecting instructional math software. The focus is on instructional software such as concept development, drill and practice, tutorial and simulation software rather...
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.
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
PBS

Pbs Teachers: Sports and Math: Batting Averages and More

For Teachers 9th - 10th Standards
Set up a spreadsheet using a computer or graphing calculator, and perform calculations using columns. Calculate percentages and solve a system of equations regarding baseball statistics.
Website
Other

Classroom Tech: Technology Integration

For Teachers 9th - 10th
This site offers a variety of ways to bring technology into your classroom. Content includes "50 Ways to Use Technology in the Classroom," filled with learning ideas and activities, as well as a guide for lesson planning and a lesson...

Other popular searches