Lesson Plan
Curated OER

Code Crackers

For Teachers 6th - 8th
Students work in teams creating and posing math rules and trying to guess them using a formula controlled worksheet they create with Excel. Student pairs take turns to see who can crack the other's code the fastest.
Lesson Plan
Curated OER

Computer Science: Pendulum

For Teachers 7th - 9th
Pupils investigate the basic properties of pendulums as a function of spreadsheets. Working in groups, they measure the period for a pendulum at six different lengths and record the results. They prepare a file using Microsoft Excel and...
Lesson Plan
Curated OER

Ict Activity 22

For Teachers 6th - 8th
Students use Excel to solve quadratic equations by trial and improvement. They enter formulas and try different solutions to improve their solutions more quickly. Afterwards, they report the solutions to different levels of accuracy.
Lesson Plan
Curated OER

Divisibility Rules

For Teachers 8th
Eighth graders explore Excel and discover rules of divisibility for the numbers 2, 3, 4, 5, 6, 9, and 10; students examine multiples of 2 using pencil/ paper, then create a chart in Excel that will allow them to more easily see patterns...
Lesson Plan
Curated OER

You mean college costs that much?

For Teachers 7th
Seventh graders collect, organize, and analyze data as they research colleges on the Internet. They graph their collected data on a line graph and use a spreadsheet on Microsoft Excel in order to organize the data.
Lesson Plan
Curated OER

Skyscraper Capers

For Teachers 5th - 8th
Pupils discuss skyscrapers and listen as the teacher introduces the project. They use the Internet to perform research on one skyscraper. Students use information they gather to create a brochure of their building . They create an Excel...
Lesson Plan
Curated OER

Graphing

For Teachers 5th
Fifth graders create graphs based on climate in South Carolina. They read and interpret information in a chart and construct a graphy from the information in the chart. They create a spreadsheet using Excel and publish 2 graphs.
Lesson Plan
Curated OER

Virtual Field Trip

For Teachers 4th - 6th
Students calculate gasoline cost per mile on a virtual field trip. They calculate the gasoline costs and travel time for each of the 2 routes, and record on a data sheet. They use Excel to create data tables for mileage, gasoline...
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

Daily Time Ratios

For Teachers 7th - 9th
Students track and record how much time they spend on each activity. In this spreadsheet instructional activity, students apply different functions using Microsoft excel to format cells and calculate the sum of their total time...
Lesson Plan
Curated OER

Using a Spreadsheet

For Teachers 8th - 10th
Students create a spreadsheet to analyze data. In this technology lesson, students develop and use an Excel spreadsheet to log their data. They solve real life word problems as they set it up using the spreadsheet.
Lesson Plan
Curated OER

Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions

For Teachers 7th - 12th
Students improve data entry in a spreadsheet.
Worksheet
Curated OER

Modeling the Keeling Curve with Excel

For Students 9th - 12th
In this modeling the Keeling Curve worksheet, students use given data beginning in 1960 to create a mathematical model for the changes in atmospheric carbon dioxide over time. Students manipulate the equation to predict the carbon...
Lesson Plan
Curated OER

World Population Activity II: Excel

For Teachers 11th - Higher Ed
Students import UNEP World population data/projections from either the World Population Prospects: The 2002 Revision Population Database - UN Population Division or a text file. They graph this data by itself, and then along with...
Lesson Plan
Curated OER

A Guinea Pig Makes An Excellent Classroom Pet

For Teachers 3rd
Third graders live alongside guinea pigs. In this biology lesson plan, 3rd graders gain direct knowledge of the guinea pig's behavior and determine if it will make a good classroom pet.
Lesson Plan
Curated OER

US Historical Climate: Excel Statistical

For Teachers 11th - Higher Ed
Learners import US Historical Climate Network mean temperature data into Excel from a station of their choice. They are guided through the activity on how to use Excel for statistical calculations, graphing, and linear trend estimates.
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

Pledge of Excellence

For Teachers 1st
First graders discuss their prior knowledge of The Golden Rule and compare it to their school's Pledge of Excellence. They discuss the five parts to the pledge and discuss how to be a caring friend, how to do their personal best, how to...
Lesson Plan
Curated OER

Careers

For Teachers 8th
Eighth graders research careers on the computer to determine which career they are interested in. They create a spreadsheet using the Excel program and calculate the budget for their desired lifestyle and determine if this income is...
Lesson Plan
Curated OER

Traffic Problem- Solved Using Microsoft Excel

For Teachers 9th - 12th
Students relate algebra to real life scenario. In this algebra lesson, students design a plan to help traffic flow smoothly using velocity and speed. This assignment is done using Microsoft Excel.
Fill-in-the-blank

Nikola Tesla documentary student worksheet

For Teachers 9th - 12th
Shared ResourcePBS documentary: Tesla - Master of Lightning; this worksheet will keep the students engaged while watching this excellent documentary about Tesla. The documentary can be found on Netflix or YouTube. It will take two class periods to...
Lesson Plan
Curated OER

Torn Paper Collage Books

For Teachers 4th - 12th
An excellent lesson on bookmaking awaits your students! This simple, and easy-to-implement plan should provide you with some excellent student-made products that you'll be proud to send home with them. The instructions are clear, and the...
PPT
Curated OER

South Carolina Jeopardy

For Teachers 4th - 5th
One of the better PowerPoints I've come across is a "Jeopardy"-style game whose focus is South Carolina. Some excellent photographs and maps make the slides especially good. The "Final Jeopardy" clue is especially challenging. An...
PPT
Curated OER

English as Second Language Intermediate Level

For Teachers 3rd - Higher Ed
Here is an excellent PowerPoint designed for teachers of English as a Second Language. This presentation could be used by instructors from mid-elementary level all of the way to adult education; depending upon the language skill level of...

Other popular searches