Lesson Plan
Curated OER

Basic Excel

For Teachers 1st - 4th
Students explore basic Excel spreadsheets.  In this spreadsheet lesson plan, students enter Alaska weather information and  perform calculations. Students title the columns on the spreadsheet and format the cells. ...
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
Curated OER

Building Arrays Using Excel Spreadsheets

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

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

For Teachers 5th - 12th
Young scholars, 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
1
1
Earth Watch Institute

Entering Local Groundhog Data in an Excel Spreadsheet

For Teachers 4th
Here is a cross-curricular ecology and technology lesson plan; 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 groundhog...
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

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

Electronic Spreadsheets & Iditarod 2000

For Teachers 6th - 8th
Young scholars 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...
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

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

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

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

Great Graphing

For Teachers 7th - 8th
Students 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

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

How Much Is It?

For Teachers 6th - 8th
Students 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. Students use a conversion table and...
Lesson Plan
Curated OER

Home, Home in the City

For Teachers 7th - 9th
Students 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.
Lesson Plan
Curated OER

Chart/Graph

For Teachers 3rd - 8th
Students create a class survey, place the data in a spreadsheet and graph the information.
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

A Holiday Card in KidPix

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

Great Online Art Sites

For Teachers K - 8th
Learners complete an online study of art websites. In this art and technology lesson, students explore the links and try the activities to learn about art online.
Lesson Plan
Curated OER

Holiday Cards using Publisher

For Teachers 2nd - 6th
Students create a holiday card using technology. In this technology lesson, students use Publisher templates to create a holiday card. Students organize, design, and edit their card.
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...