Lesson Plan
Curated OER

Research a State in the United States

For Teachers 6th - 8th
Learners research one state of the United States of their choice. Using the internet, they gather as much information about the state as possible along with appropriate images. They present their findings to the class in the form of a...
Lesson Plan
Curated OER

Graphing Grazy Crayons

For Teachers 2nd
Children create crazy crayons they made to sort and construct a floor bar graph. Then, using technology resources, they make a simple bar graph to compare the top four colors produced. Students will then interpret the printed graph by...
Lesson Plan
Curated OER

Determination of the percentage of Acetic Acid in Vinegar

For Teachers 10th - 12th
Young scholars determine the concentration of acetic acid when the concentration of the base with which is titrated is known. They investigate how to weigh a sample using the balance, measure volumes using graduated cylinder, explore...
Lesson Plan
Curated OER

Fraction Strips on Excel

For Teachers 6th
Sixth graders create three different sets of fraction strips using Excel by following a packet of instructions that taper off as the students gain confidence in their knowledge of Excel. They copy and paste the strips into Word so that...
Lesson Plan
Curated OER

Bringing Young Architects to Surface

For Teachers 7th - 9th
Learners work in pairs to design a building. In this architecture lesson, students take on the role of head architect to design and construct a 3-D scale model a building for a client. Learners' goal is to meet the...
Lesson Plan
Curated OER

Bubble Gum Chemistry

For Teachers 8th - 10th
Students explore the concept of graphing data. In this graphing data lesson, students determine the percentage of sugar in bubble gum. Students graph type of gum vs. sugar percentage. Students create a table of their data.
Lesson Plan
Curated OER

ABC's of Banking

For Teachers 9th - 10th
Students explore the concept of managing money. In this managing money lesson plan, students discuss how to write checks and keep an accurate check registry. Students discuss the importance and uses of debit cards and deposit forms.
Lesson Plan
Curated OER

Embracing Diversity

For Teachers 9th
Ninth graders discover that the amount surveyed affects the results and conclusions drawn from a survey. In this sampling lesson students explore the concept that a valid conclusion require a large number of entries.  Students...
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

SolidWorks for Sheet metal

For Teachers Higher Ed
Students practice using the different tools on the Sheet Metal toolbar. In this engineering lesson, students create a sketch given a set of procedures to follow.
Lesson Plan
Other

Nearpod: Spreadsheets: Using Formulas

For Teachers 9th - 10th
In this lesson on spreadsheets, students explore the different parts of a spreadsheet and use equations within spreadsheets to learn about their applications.
Lesson Plan
Other

Technology for Learners: A Fun Way to Start Learning About Spreadsheets

For Teachers 9th - 10th
A fun way to start learning about spreadsheets.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Salmon Use of Geomorphically Restored Streams at Point Reyes Nat. Seashore

For Teachers 9th - 10th
A lesson plan with an accompanying PowerPoint learning module for learners where they learn about coho salmon and a repair done to a culvert in Point Reyes National Seashore. The repair was intended to help the salmon make their journey...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Yellowstone! A National Park on a Hot Spot

For Teachers 9th - 10th
A lesson plan with an accompanying PowerPoint learning module for students where they learn about the volcanic features of Yellowstone National Park. They use spreadsheets to make various calculations, such as the volume of material...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: The "Perfect" Date: Ranking and Rating Decisions With a Spreadsheet

For Teachers 9th - 10th
A lesson plan that includes a PowerPoint learning module for students. The purpose of the lesson is to use spreadsheets to explore a rating and ranking method for choosing someone to date. They look at the problems that arise when...
Lesson Plan
National Council of Teachers of Mathematics

The Math Forum: A Collection of Secondary Math Units

For Teachers 9th - 10th Standards
Teachers of grades 9-12 can explore these seven math units for their classes. Data collection and analysis, problem solving with spreadsheets, and linear transformation are just a few of the topics covered here.
Lesson Plan
Microsoft

Microsoft Education Lesson Plan: Candy Is Dandy

For Teachers 3rd - 8th
Explore color distribution of M&M candies using this detailed lesson plan. An engaging integrated lesson plan that requires understanding of spreadsheets and formulas, and logical reasoning. Links to related websites.
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
NC State University

North Carolina State University: Spreadsheets in Science

For Teachers 3rd - 5th
Intriguing lesson from North Carolina State University using a spreadsheet to solve real world science problems. Contains downloadable files for student activities.
Lesson Plan
Google

Google for Education: Working With Large Tables of Data

For Teachers 9th - 10th
Students work with large tables of GPS data and sort, manipulate, and visualize the data so it can be easily understood.
Lesson Plan
Google

Google for Education: Data Aggregation and Decomposition (Python)

For Teachers 9th - 10th
Students learn how to use and analyze data to draw conclusions about information collected from classmates. Then they use computational thinking by collecting and aggregating data onto a spreadsheet, identifying patterns in their data,...
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
NASA

Nasa: Sea Surface Temperature Trends of the Gulf Stream

For Teachers 9th - 10th
Learners investigate changes in the surface temperatures of the Gulf Stream over the course of the seasons using data collected by NASA's satellites. The data is inputted into a spreadsheet and graphed.
Lesson Plan
National Council of Teachers of Mathematics

The Math Forum: Seventh Grade Mathematics: Data Sense

For Teachers 6th - 8th
This site has some interesting ways to collect and evaluate data. There are some activities about note taking, spreadsheets, surveys, and a cool bridge construction project. Teachers may want to use this site as a resource for some...

Other popular searches