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 instructional activity, students use a spreadsheet program to create a budget with credit and debit columns.  There are step-by-step...
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

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

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

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...
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...
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 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 lesson plan, students develop a spreadsheet of ocean depths. They import the information into a word processed document. They...
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

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
High schoolers 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

A Birthday Basket for Tia

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

Creating a Newscast on the Cold War

For Teachers 5th - 7th
Students 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.  Students create a...
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 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

Don't Settle for a Byte... Get the Megabyte on Technology

For Teachers 4th - 12th
Students use word processing, presentation, and spreadsheet software. In this multi-day computer software usage lesson, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint to...
Lesson Plan
Curated OER

A "Capital" Idea

For Teachers 8th
Eighth graders prepare for a field trip to Washington, DC by researching landmark, monument, or building in Washington. They use the information in small groups to design a multimedia presentation. They include a spreadsheet that shows...
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

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

Volcano Spreadsheet and Graph

For Teachers 4th
Fourth graders use data from volcanoes to organize a spreadsheet and make a graph.
Unit Plan
1
1
Curated OER

Build Your Dream Science Lab

For Teachers 6th - 8th Standards
Would your ideal science lab be filled with bubbling beakers and zapping Tesla coils? Or would it contain state-of-the-art computer technology and data analysis? Dream big with an innovative lesson that connects math and language...
Lesson Plan
Curated OER

Create A Business and A Life

For Teachers 9th - 12th
Students look through a phone book and pick a business they think they would enjoy. They brainstorm ideas about the needs of a business. They set their prices to payback their investment into the new business.
Lesson Plan
Curated OER

Writing a Personal Narrative

For Teachers 3rd - 5th
Students complete a variety of computer file pre-writing activities to help them prepare for writing a personal narrative. They focus on including a beginning, middle and end to their narrative. They make a class book.