Lesson Plan
Curated OER

A Power Point Slide Show for Third Graders

For Teachers 3rd
Third graders explore PowerPoint.  In this technology lesson, 3rd graders select a topic of interest and follow a guided lesson researching their topic.  Students complete storyboards, introductions, table of contents and...
Lesson Plan
Curated OER

Pumped Up Gas Prices

For Teachers 3rd - 6th
Students calculate gas prices. In this transportation lesson, students tally the mileage and gas costs of their car for one months. They figure out how much was spent on gas and create a graph showing average gas prices over time. 
Lesson Plan
Curated OER

Let's Keep Track of Grades

For Teachers 7th - 8th
Students participate in a technology project. This lesson is a hands-on spreadsheet project where students are responsible for keeping track of their grades for class. The students learn to enter data into a spreadsheet, create...
Lesson Plan
Curated OER

Earth Energy Budget Pre Lab

For Teachers 4th - 7th
Students explore energy by conducting an in class experiment. In this climate change lesson plan, students conduct a water vapor experiment in a soda bottle. Students utilize graphs and charts to analyze the results of the experiment and...
Lesson Plan
Curated OER

Who is Coming to Our House?

For Teachers 9th - 12th
Young scholars examine waves of immigration that affected the development of the United States, appreciate variety of countries of origin of immigrants, analyze immigration data, discern patterns in data and communicate finding to...
Lesson Plan
Curated OER

Great Online Art Sites

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

Don't Print Homework-Email It!

For Teachers 4th - 12th
Students practice emailing their homework. In this technology lesson, students review how to type an email address correctly and how to send it to the correct address. Students complete their homework and send it to their teacher.
Lesson Plan
Curated OER

What Do Plants Need to Grow?

For Teachers 4th
Fourth graders control variables to determine the effect on plant growth. They collect information by observing and measuring and construct simple graphs, tables, maps and charts to organize, examine and evaluate information.
Lesson Plan
Curated OER

Visit My Class Wikis

For Teachers 4th - 7th
Students visit the links on the blog site to learn about class wikis. In this technology integration lesson, students visit the links to view class wikis.
Lesson Plan
Curated OER

Collisions Lesson

For Teachers 10th
Tenth graders explore the role that collisions and near collisions of galaxies play in determining the shape of galaxies. They model the collision of disk shaped and spherically shaped galaxies.
Lesson Plan
Curated OER

Tell Me a Story

For Teachers 10th
Tenth graders read short story, "The Storyteller" by Saki, and expand on concept of stories for students by reading and evaluating several popular students's stories as well as writing their own original students's stories.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Using Microsoft Excel to Explore Gravity Forces and Accelerations

For Teachers 9th - 10th
Students will learn about the force of gravity and the factors that affect it, and use and analyze the universal gravitation equation using Excel spreadsheets.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: The Digital Divide: A Data Analysis Activity Using Subtotals

For Teachers 10th - 12th
A lesson plan that includes a PowerPoint learning module for students. The purpose of the lesson is to teach how to use Excel to analyze a large amount of data, in this case from the US Census. The example being used is the accessibility...
Lesson Plan
Other

Laus Dnet: Grade 5 Excel Lesson Plan

For Teachers 3rd - 5th
In this online instructional activity, students will survey students in their school to determine their favorite type of hand-held ice cream. Before performing the survey, students will make predictions about which ice creams they think...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Creating a Household Budget

For Teachers 9th - 10th
In this Spreadsheets Across the Curriculum PowerPoint module, students create a household budget by tracking their expenditures over a month-long period. Students use Microsoft Excel to create a spreadsheet to track their own...
Lesson Plan
Other

Personal: Let's Go Shopping

For Teachers 9th - 10th
This personal site provides a student activity that allows learners to practice spreadsheet skills in inputting data and creating function formulas. The activity is based on the collection and comparison of shopping receipts using max,...
Lesson Plan
Google

Google for Education: Sorting the World's Cities (Python)

For Teachers 9th - 10th
The second of two similar lessons where students learn how a Python program can organize and sort data. When taught in conjunction with Sorting the World's Cities with Excel, students make the connection between writing a program and...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Simple vs. Compound Interest Spreadsheeting the Difference

For Teachers 9th - 10th
A lesson plan that includes a PowerPoint learning module for students. The goal of the lesson is to learn the difference between simple and compound interest and to use the functions in Excel to perform the calculations and graph the data.