Lesson Plan
Curated OER

Lemonade Business

For Teachers 12th
Twelfth graders use all features of Microsoft Excel and Microsoft Power Point to create charts and graphs. They use charts and graphs to make a Power Point Presentation.
Lesson Plan
Curated OER

The Iditarod Adventure

For Teachers 9th - 12th
Students use the internet to follow the Alaskan Iditarod race as well as perform research. This project-based activity will result in students creating many desktop publishing documents.
Lesson Plan
Curated OER

Small Business

For Teachers 6th - 12th
Students simulate owning and running a small business by playing Lemonade Stands. They play the game for three weeks, then work with a partner to produce a Power Point presentation which would be given to a Board of Directors showing...
Lesson Plan
Curated OER

Giving'Em The Business

For Teachers 1st - 2nd
Students work in groups of 4-5 to form a business, create, market & sell their product, and track their expenses and profits. They experience the roles of producer, distributor, and consumer of goods. They collect, organize and...
Lesson Plan
Curated OER

Polluting the Environment

For Teachers 4th
Fourth graders construct mini-ecosystem, pollute the ecosystem, observe, collect, and record data on the effects of these pollutants on their ecosystem, organize data on spreadsheets, create graphs, and design presentations to share with...
Lesson Plan
Curated OER

Catholic Schools in the Community

For Teachers 3rd - 4th
Students are provided with a multimedia Power Point presentation that explains the educational opportunities that are available at the St. Mary Catholic School. They are presented with all facts along with the community as a whole and...
Worksheet
Curated OER

The Big Bang-Hubble's Law

For Students 7th - 9th
For this Hubble's law worksheet, students use data for galaxies which include their distance and speed. Students make a graph to show the distance to each galaxy and the speed of each galaxy. They use their graph to answer 4 questions...
Lesson Plan
Curated OER

Acid Rain in our State

For Teachers 6th - 12th
Students conduct internet research on acid rain, a serious environmental problem. They examine the pH levels of rainwater for their state, collect data from their community and investigate the causes and solutions for acid rain.
Lesson Plan
Curated OER

Geometric Sequences and Series

For Teachers 9th - 12th Standards
Learn to calculate the nth term of a sequence defined by an algebraic expression. They examine geometric sequences and series, relate geometric sequences to their explicit forms, find the partial sums of a sequence in a table, and...
Lesson Plan
Curated OER

Excel temperature Graphs

For Teachers 4th - 6th
Students gather data about the weather in Nome, Alaska. In this Nome Temperature instructional activity, students create an excel graph to explore the weather trends in Nome.  Students will find the average weather and add a trend...
Lesson Plan
Curated OER

Using Tables to Solve Linear Functions

For Teachers 9th - 12th Standards
Oh that intercept! Budding algebra masters solve linear equations from standard to intercept form. They identify the slope and y-intercept to help graph the lines, an then create coordinate pairs using a table of values. Great TI tips...
Lesson Plan
Curated OER

Number and Algebra: Again and Again

For Teachers 5th - 9th
Students use a given spreadsheet to investigate an iterative process by changing the variables. They design their own spreadsheet to investigate the iterative process.
Lesson Plan
Curated OER

Measuring "pHacts" about Acid Rain

For Teachers 6th
Sixth graders gather and graph information regarding the pH of rain. Working cooperatively with an internet partner, 6th graders gather and record information about the pH of the rain in their local area. They graph this information...
Lesson Plan
Curated OER

Rouge River Data

For Teachers 3rd - 5th
Students participate in using Excel sofware in order to create graphs. They create the graphs using data that they gathered during the Rouge River Field Trip they attended. The produce bar graphs from the excel spreadsheets.
Lesson Plan
Curated OER

Open Door, Closed Door Lesson Plan: Discrimination in Immigration And Migration

For Teachers 6th - 8th
Students read The Northern Migration and research immigration policies of different nations for the past and the present. They create a bulletin board or spreadsheet using their information.
Lesson Plan
Curated OER

Topic 6: Evaluating and Presenting Results

For Teachers 8th - 9th
Students construct spreadsheets from raw data. In this spreadsheet construction instructional activity, students compile data into Microsoft Excel. Students familiarize themselves with entering and presenting data in a spreadsheet.
Lesson Plan
Curated OER

Graphing Data on Ellis Island

For Teachers 3rd
Third graders use data to make a bar graph. In this graphing and social studies lesson, 3rd graders use data about where Ellis Island immigrants came from to complete a bar graph on Microsoft Excel.
Lesson Plan
Curated OER

Peopling the New World -- An Archaeological Exercise in Excel

For Teachers 6th - 8th
Students examine different types of spears that have been discovered from various civilizations. In groups, they calculate the answers to various word problems and enter their information on a spreadsheet. They use the data in other...
Lesson Plan
Curated OER

Who's Going to the Convention?

For Teachers 9th - 12th
High schoolers practice planning budgets as they create a budget for ten employees of a company to attend a professional convention. They use the Internet, and spreadsheet software to complete their assignment.
Lesson Plan
Curated OER

Trends in Precipitation

For Teachers 8th
Eighth graders study about precipitation and graph the information. They look for patterns in a scatter graph and make inferences based on what they see. They need to see a relationship between location and the amount of precipitation.
Lesson Plan
Curated OER

The Breathtaking Nature of the Urban Explosion, Part 2

For Teachers 9th - 12th
Students explore ozone levels. They measure the concentrations of ground-level ozone in the atmosphere. Students observe changes in the concentrations of ozone over time. Students complete a data sheet to record ozone readings over a...
Lesson Plan
Curated OER

Personal Budgeting Project

For Teachers 8th - 11th
Students create an Excel spreadsheet of a personal budget by estimating their possible income and monthly expenses from a worksheet. They group together to create a family unit and use the personal budget sheets to plan a family budget.
Lesson Plan
Curated OER

Investigation of Hooke's Law Lab

For Teachers 11th - 12th
Students determine the spring constant by conducting an investigation. In this physics lesson, students collect data and create a graph of force vs. displacement. They compare the results of two different methods to find spring constant.
Lesson Plan
Curated OER

Canadian Cities

For Teachers 5th
Fifth graders gather population data on twelve cities in Canada. They present the information on a spreadsheet and sort the data on two different types of graphs. They create a generalization for the data that they collected.