Lesson Plan
Curated OER

Create a Budget

For Teachers 6th - 7th
Students develop a budget spreadsheet to manage finances for their business.  In this finance lesson, students use a spreadsheet program to create a budget with credit and debit columns.  There are step-by-step directions for...
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

Graphing Our Marbles

For Teachers K
Students collect information pertaining to marble colors found in their bag; then creating a spreadsheet in order to make a chart representing their findings using Microsoft Excel. Students will present their results to small groups.
Lesson Plan
Curated OER

Student News And Weather Channel

For Teachers 5th
Fabulous! Your 5th graders should love this project. As an ongoing lesson throughout the year students use temperature probes to record outside temperature and then document their data using spreadsheets. They use their weather data and...
Lesson Plan
Curated OER

Graphing Favorite Fruit

For Teachers 3rd
Third graders take poll and sort data, enter the data to create a spreadsheet and create bar and pie graphs.
Lesson Plan
Curated OER

Analyzing Discrete and Continuous Data in a Spreadsheet

For Teachers 6th - 12th Standards
You are what you eat! Your statisticians keep a log of what they eat from anywhere between a day to more than a week, keeping track of a variety of nutritional information using a spreadsheet. After analyzing their own data, individuals...
Lesson Plan
Curated OER

Build Your Dream Bedroom

For Teachers 7th Standards
Designers measure their own rooms and produce a scale drawing. They use the Internet to visit sites to find the costs of purchasing new carpet, paint, or anything else they would like to add to their room. Using a $1500 budget, they will...
Lesson Plan
Curated OER

Making a Spreadsheet

For Teachers 5th - 8th
Students explore spreadsheet software.  In this personal finance and computer technology lesson, students develop a vacation spreadsheet on the computer.  Students represent hotel, food, transportation, and entertainment costs...
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.
Activity
PBL Pathways

Do Homework?

For Teachers 10th - Higher Ed Standards
To complete homework or not to complete homework ... that is the question. Decide whether it makes a difference on finals by doing homework. Individuals create a scatter plot and find a line of best fit for data on the percent of...
Lesson Plan
Curated OER

A Fishy Tale

For Teachers 8th
Eighth graders do a research project on a particular species of Atlantic seafood and record and graph information pertaining to commercial landings of that species of seafood. They use a website and an Appleworks spreadsheet.
Lesson Plan
Curated OER

PowerPoint Project for Creating a New Business

For Teachers 9th - 12th
Students create a mock new business for which they design a PowerPoint presentation. They include company information, financial statements, graphs, advertising and management promotion pages in the final presentation.
Lesson Plan
Curated OER

Creating a Newscast on the Cold War

For Teachers 5th - 7th
Learners research the events of a specific year of the Cold War. In this Cold War lesson, students investigate the causes of the Cold War and highlight the events of a particular year.  Learners create a...
Lesson Plan
Curated OER

Creating a Bar Graph Using a Spreadsheet: Dice Rolling Probabilities

For Teachers 10th
Tenth graders explore the concept of spreadsheets. They create a simple spreadsheet and chart from given data. Students perform basic formatting procedures on their chart. They use spreadsheet functions to perform calculations.
Lesson Plan
Curated OER

Creating a Nutrition Table in MicroSoftExcel

For Teachers 6th - 8th
Pupils access the internet to find Nutritional information from a restaurant of their choice and compile their information into an excel spreadsheet.
Lesson Plan
Curated OER

A Line Graph of the Ocean Floor

For Teachers 4th - 5th
Students develop a spreadsheet and import the information into a line graph. In this spreadsheet and line graph instructional activity, students develop a spreadsheet of ocean depths. They import the information into a word processed...
Lesson Plan
Curated OER

How Much Is It?

For Teachers 6th - 8th
Learners explore foreign currencies. In this foreign currencies lesson, students simulate travel to another country and determine the value of the US dollar compared to other countries. Learners use a conversion table and search Internet...
Lesson Plan
Curated OER

Microsoft Office Excel

For Teachers 6th - 8th
Students use Microsoft Office Excel. In this technology lesson, students enter data on a spreadsheet using Excel. This programs tallies data and presents it using graphs. 
Unit Plan
Intel

Composting: Why Bother?

For Teachers 8th - 10th Standards
The first STEM lesson in a group of 10 explores composting. After discussing how to make a better tomorrow, classes are challenged to track garbage in their communities, visit a local waste management facility, and conduct a survey...
Lesson Plan
Curated OER

A Healthy Heart

For Teachers 6th
Sixth graders create a spreadsheet using specific data. A speaker comes to discuss the heart, and the difference between anaerobic and aerobic activity. They make posters to encourage a healthy heart lifestyle.
Lesson Plan
Curated OER

Super Spreadsheets

For Teachers 6th - 8th
Young scholars discover information about each of the fifty states in the United States. In groups, they create a spreadsheet organizing the information to show to the class. They discover different ways to display the data and...
Lesson Plan
Curated OER

PLANNING A DIVERSIFIED INVESTMENT PORTFOLIO

For Teachers 12th
Twelfth graders research stocks and how to read and interpret financial data. They choose 5 companies to invest in and track their performance over 10 weeks. They create a spreadsheet which shows the results.
Lesson Plan
Curated OER

A Birthday Basket for Tia

For Teachers Pre-K
Students practice reading and math skills using technology.  In this main idea lesson, students retell the important events of A Birthday for Tia in sequence using Kid Pix.  Students create a bar graph using The Graph Club...
Lesson Plan
Curated OER

Graphing Favorite Colors

For Teachers 3rd
Third graders collect data and insert it into ClarisWorks to create a spreadsheet/graph of their favorite color. They interpret the data together.

Other popular searches