Lesson Plan
Curated OER

Basic Excel

For Teachers 1st - 4th
Learners explore basic Excel spreadsheets.  In this spreadsheet lesson plan, students enter Alaska weather information and  perform calculations. Learners title the columns on the spreadsheet and format the cells. ...
Lesson Plan
Curated OER

Basic Algebra and Computers: Spreadsheets, Charts, and Simple Line Graphs

For Teachers 5th - 12th
Students, while in the computer lab, assess how to use Microsoft Excel as a "graphing calculator." They view visual representations of line graphs in a Cartesian plane while incorporating basic skills for using Excel productively.
Lesson Plan
Curated OER

Interest Calculation and Spreadsheets

For Teachers 5th - 12th
Students, while in the computer lab working on a spreadsheet program, calculate interest and accumulated value of a savings plan. They follow specific directives on how to create their spreadsheets. At the end of the lesson they print...
Lesson Plan
American Institutes for Research

Digital Smiles

For Teachers 4th - 6th
Explore metric measurement, recording data, and creating an electronic spreadsheet displaying results with your math class. Scholars will measure the length of their smiles, record the measurements, and represent the results on an...
Lesson Plan
1
1
Earth Watch Institute

Entering Local Groundhog Data in an Excel Spreadsheet

For Teachers 4th
Here is a cross-curricular ecology and technology instructional activity; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the...
Lesson Plan
Curated OER

Building Arrays Using Excel Spreadsheets

For Teachers 3rd - 5th
Students create arrays using Microsoft Excel. In this technology-based math lesson, students expand their knowledge of multiplication by creating arrays on the computer using a spreadsheet program such as Microsoft Excel.
Lesson Plan
Curated OER

Temperature High and Lows

For Teachers 5th - 8th
Students gather high and low temperature readings through email. In this temperature graphing lesson, students use a spreadsheet to input data for a graph. students interpret the graphs to compare and contrast the data from different...
Lesson Plan
Curated OER

The Solar Cycle

For Teachers 7th - 12th
Students research the solar cycle. In this Science lesson, students use the internet to investigate the solar cycle. Students produce a spreadsheet and graph from the information collected.
Lesson Plan
Curated OER

Electronic Spreadsheets & Iditarod 2000

For Teachers 6th - 8th
Students use the Internet for gathering information for Iditarod race journals. They use a spreadsheet program for entering data and making charts for showing changes in speeds achieved over a period of four weeks in timed writings in...
Lesson Plan
Curated OER

Holiday Cards using Publisher

For Teachers 2nd - 6th
Students create a holiday card using technology. In this technology instructional activity, students use Publisher templates to create a holiday card. Students organize, design, and edit their card.
Lesson Plan
Curated OER

Using Computer for Statistical Analysis

For Teachers 6th - 12th
Students examine the use for spreadsheets in analyzing data. They make spreadsheets that display and calculate a given data set such as temperature change.
Lesson Plan
Curated OER

Great Graphing

For Teachers 7th - 8th
Learners collect data, use a computer spreadsheet program to create various graphs, and compare the graphs. They state the findings of each graph in writing and decide which graph type best represents the data.
Lesson Plan
Curated OER

How Much Is It?

For Teachers 6th - 8th
Middle schoolers explore foreign currencies. In this foreign currencies instructional activity, students simulate travel to another country and determine the value of the US dollar compared to other countries. Middle schoolers use a...
Lesson Plan
Curated OER

Finding Mean, Mode and Median in the Computer Lab

For Teachers 5th - 12th
Learners create spreadsheets which will display and figure mean, median, and mode of a set of numbers.
Lesson Plan
Curated OER

Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions

For Teachers 7th - 12th
Students improve data entry in a spreadsheet.
Lesson Plan
Curated OER

Dino-Myte Spreadsheet

For Teachers 4th - 8th
Do your learners like dinosaurs and theme parks? An ambitious lesson invites learners to put together a plan for supplying dinosaurs for a new theme park. Pupils work together in groups to come up with their plan, which must include a...
Lesson Plan
Curated OER

Phenomenal Weather-Related Statistics

For Teachers 8th
Eighth graders research, collect and interpret data about weather statistics. They record that data on spreadsheets. they create Powerpoint presentations on their individual or group research.
Lesson Plan
Curated OER

A Holiday Card in KidPix

For Teachers K - 3rd
Students create a holiday card using computer software.  In this computer card making lesson, students design an original holiday card using a variety of tools.  Students navigate the software utilizing various tools.
Lesson Plan
Curated OER

EXCEL It!

For Teachers 5th - 8th
Students surf the Web gathering information about graphs. The data collected is incorporated into an Excel spreadsheet and graphs of varying nature generated to further enhance student understanding.
Lesson Plan
Curated OER

Holiday Flier in Publisher

For Teachers 2nd - 5th
Students use Publisher in this lesson to make a holiday flier. In this technology lesson, students create a holiday flier. Students choose fonts, use clipart, use grammar and spelling check, and save to their work to a flash drive or...
Lesson Plan
Curated OER

Indegenous Cultures Magazine in Publisher

For Teachers 4th
Fourth graders use Publisher to create their own magazine. In this online magazine lesson, 4th graders follow the instructions to create a magazine using text, pictures, and colors within the Publisher system.
Lesson Plan
Curated OER

Reading + Keyboarding= Success

For Teachers 3rd - 8th
Students practice their keyboarding skills. In this typing lesson, students use interesting stories to practice their skills. They practice throughout the semester and then monitor their improvement.
Lesson Plan
Curated OER

Home, Home in the City

For Teachers 7th - 9th
Pupils create a spreadsheet that organizes housing information in the Houston area. They write a formula to determine the average price of homes in the Houston area.
Lesson Plan
Curated OER

Graphing With Second Graders

For Teachers 2nd
Second graders sort M & M's and then enter the data into a spreadsheet in order to create a simple graph. After printing the spreadsheet generated graph, have students compare the printed graph with their paper graph.