+
Lesson Plan
Curated OER

Collect the Weather Lesson Plan

For Teachers 3rd - 8th
Students explore the weather. In this weather spreadsheet instructional activity, students keep track of weather patterns as they use instruments and resources to chart the data the collect in spreadsheet form.
+
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.
+
Worksheet
Curated OER

Data Handling

For Students 6th
For this data handling worksheet, 6th graders solve and complete 4 various types of problems. First, they draw a bar chart to represent the information provided in the table shown. Then, students show beneath the table how to work out...
+
Worksheet
Curated OER

Flow Charts and Inverses

For Students 9th - 12th
In this flow chart and inverse activity, high schoolers evaluate 6 equations and answer 12 questions. Students are asked to complete the flow chart and also its inverse; the outlines of both are provided.
+
Organizer
Curated OER

Database

For Students 6th - 8th
In this technology worksheet, students examine the graphics in order to see how the information is organized for a database. They use the sheet as a reference for making database entries.
+
Worksheet
Curated OER

Spreadsheet Page 2

For Students 6th - 8th
In this technology worksheet, students examine the definitions. The words are used in order to match the them with the bullet points.
+
Lesson Plan
Curated OER

Mythology Spreadsheet

For Teachers 4th - 8th
Students read a large variety of myths and discuss the characters and their attributes found in mythology. Then they identify and learn to set up an appropriate spreadsheet program. Students also enter the data to the class spreadsheet...
+
Lesson Plan
Curated OER

Graphing

For Teachers 5th - 12th
Young scholars gather statistical information on a chosen topic and place it into a spreadsheet. Using th Excel chart wizard, students create tables, graphs and charts of their information. They interpret the data and share it with the...
+
Lesson Plan
Curated OER

Word Processing

For Teachers 9th - Higher Ed
Pupils insert and delete columns and rows, change lines, borders, and fill in styles, as well as change cells, rows, columns, and table formatting. Then, students calsulate sums for rows and columns and enter their formulas in order to...
+
Lesson Plan
Curated OER

Computer Technology - Big Stepper Block Buster

For Teachers 9th - 12th
Students use their document processing, spreadsheet, and/or electronic presentation skills to complete a cross curricular project during the semester (or trimester, etc.,) in which they are enrolled in the Computer Technology course.
+
Lesson Plan
Curated OER

Using Excel to Draw a Best Fit Line

For Teachers 6th - 8th
Young scholars create line graphs for given data in Microsoft Excel. Students follow step by step instructions on how to create their graph, including how to create a trend line. Young scholars print graphs without trend lines and...
+
Lesson Plan
Curated OER

Loving Literature

For Teachers 1st
First graders, after having "Are You My Mother?" by P.D. Eastman read to them, participate in group discussions or independentally work to analyze a spreadsheet to identify essential elements in the story and graph their data. In...
+
Lesson Plan
Curated OER

Three Squirrels and a Pile of Nuts

For Teachers 6th - 8th
Learners solve story problems using a spreadsheet in combination with various problem-solving strategies. Working in teams of three, students create attempt to solve a story problem using three different methods; using manipulative,...
+
Lesson Plan
Curated OER

Tasty Tech Activity With Excel

For Teachers 3rd - 8th
Students are introduce to basic Excel skills, rank their opinions of menu items from fast food restaurants, add their answers to the spreadsheet, and then create a simple graph of the results.
+
Lesson Plan
Curated OER

Circles and Stars

For Teachers 3rd - 4th
Students solve multiplication problems utilizing virtual manipulatives, express multiplication problems in form of expressions, enter data into a spreadsheet and analyze results, and play game Circles and Stars.
+
Lesson Plan
Curated OER

Made Round To Go Round

For Teachers 2nd - 3rd
In this lesson students investigate what it would cost to furnish one room of their choice by shopping on the Internet. Both Australian and American dollars are to be given for each item to demonstrate the difference between two...
+
Lesson Plan
Curated OER

Math: Football Fever Fun

For Teachers 5th - 8th
Students compile statistics from high school or other football team and construct a spreadsheet on which to record their findings. Using Chart Wizard to analyze the data, they construct charts and graphs for a visual display of the...
+
Lesson Plan
Curated OER

Finding Mean, Mode and Median in the Computer Lab

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

Where Will You Go?

For Teachers 5th
Fifth graders participate in a WebQuest in which they calculate mileage and cost per person for a trip to an amusement park. They explore various websites, and produce an Excel spreadsheet.
+
Lesson Plan
Curated OER

Creating a "Concrete" Spreadsheet

For Teachers 10th - 11th
Students create a spreadsheet that calculate the amount of concrete needed to pour various concrete forms.
+
Lesson Plan
Curated OER

How Would You Spend a Million Dollars?

For Teachers 5th - 8th
Students plan and organize a theme to spend one million dollars. They select a theme, research prices of items on the Internet, organize the information into a spreadsheet, write an introductory paragraph, and create a final project.
+
Lesson Plan
Curated OER

Spreadsheet Budget Project

For Teachers 8th
Eighth graders record all the food they eat for one week, compute the costs for all of this food, and display the different categories on a spreadsheet and then convert to a chart.
+
Lesson Plan
Curated OER

Should Voting in the United States be Mandatory? Research Activity

For Teachers 8th
Eighth graders research how many voters actually vote in the U.S. and nine other nations. They create a spreadsheet using this information and write a persuasive essay.
+
Lesson Plan
Curated OER

Volcano Spreadsheet and Graph

For Teachers 4th
Fourth graders use data from volcanoes to organize a spreadsheet and make a graph.