+
Lesson Plan
Bowland

Speed Cameras

For Teachers 6th - 9th
Do speed cameras help reduce accidents? Scholars investigate this question using a series of spreadsheet activities. Along the way, they learn about randomness, probability, and statistical analysis.
+
Lesson Plan
Curated OER

Using Spreadsheets and Graphs

For Teachers 3rd
Third graders explore mathematics by utilizing computers. In this graphing lesson, 3rd graders gather class data based on a particular topic such as the "favorite candy" of the class. Students utilize this information and computers to...
+
Lesson Plan
Curated OER

The Viewing Tube

For Teachers 5th - 8th
Looking for an excellent lesson plan that incorporates math, science, and technology? Groups of three students use a viewing tube to perform an experiment, and discover how to organize their data into an Excel spreadsheet.  This is a...
+
Lesson Plan
Curated OER

What Color Are Your Skittles?

For Teachers 7th - 10th
Students create spreadsheets and manipulate data. They collect data, create appropriate graphs and use percentages to describe quantities. Students compare and contrast data. They use spreadsheets to generate a pie chart.
+
Lesson Plan
Curated OER

Crispy Cookie Class Fundraiser

For Teachers 7th
Seventh graders see the relationship of math and the real world application by manufacturing a product for making a profit. They create a food product from a recipe, record their sales and analyze and report their gross profit.
+
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

Level III: Technology Integration

For Teachers 4th
Fourth graders prepare two spreadsheets each with an embedded line graph that displays data about the growth of the bitter rot fungus on apples and on petri dishes that were stored in the refrigerator and the classroom. They prepare a...
+
Lesson Plan
Curated OER

Macbeth Madness

For Teachers 10th - Higher Ed
Students research Macbeth online and complete computer and graphing activities for the play. In this Macbeth activities lesson, students research Macbeth and bookmark the URL's. Students complete activities for the topic on spreadsheets...
+
Lesson Plan
Curated OER

Graphing Favorite Holidays

For Teachers 1st - 3rd
Students create spreadsheets and bar graphs based on results of survey of favorite holidays.
+
Lesson Plan
Curated OER

Touring the Regions of the United States

For Teachers 5th
Fifth graders explore the regions of the United States. They use maps, research on the Internet and use measurements and estimations. Students create a presentation using spreadsheets and publishing software.
+
Lesson Plan
Curated OER

Cars: Math, Research, Economics, Loans

For Teachers 11th - Higher Ed
Students investigate what the purchasing of a car entails. They explore car criteria and financing options.
+
Lesson Plan
Curated OER

Dino-Myte Spreadsheet

For Teachers 4th - 8th
Do your learners like dinosaurs and theme parks? An ambitious activity 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...
+
Unit Plan
Intel

Pedal Power

For Students 8th - 12th Standards
Show your classes the importance of mathematics in something as simple as bicycle design. The final lesson in the six-part STEM series has each group research a different aspect of the bicycle. Learners use mathematical formulas, linear...
+
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

Topic 6: Evaluating and Presenting Results

For Teachers 8th - 9th
Students construct spreadsheets from raw data. In this spreadsheet construction lesson, students compile data into Microsoft Excel. Students familiarize themselves with entering and presenting data in a spreadsheet.
+
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

Time Management

For Teachers 6th - 9th
Students plot activities for a 24 hour day. They record their information on a spread sheet program. Students list categories they use and write equations for cells that add cells of each category together. Students create a pie chart of...
+
Lesson Plan
Curated OER

Publisher Brochures

For Teachers 7th - 8th
Students create brochures on subjects they are studying in Publisher. In this nonfiction writing lesson, students use Publisher to create a brochure telling all the main ideas of a topic they are studying. Students use text boxes, fonts...
+
Lesson Plan
Curated OER

American History Through Architectural Masterpieces: Monticello

For Teachers 3rd - 5th
Students examine the life of Thomas Jefferson, explore great American landmark Monticello, discover relationships between climate, geographical factors, and time as to what kind of architecture was used, conduct research online, write a...
+
Lesson Plan
Curated OER

Million Dollar House

For Teachers 4th
Fourth graders use a combination of calculators and spread sheet software to furnish their own million dollar horse without going over the specified amount of a million. The goal being to create a house that came to the exact amount of...
+
Lesson Plan
Curated OER

How Much Is It?

For Teachers 6th - 8th
Students explore foreign currencies. In this foreign currencies lesson plan, students simulate travel to another country and determine the value of the US dollar compared to other countries. Students use a conversion table and search...
+
Lesson Plan
Curated OER

The Ultimate Vacation

For Teachers 9th - 12th
Students use research skills to solve a problem. They research information needed to plan a vacation. Students create a letter, a flyer, an itinerary, an activity list, cost spreadsheet, a reference page, table of contents and a title page.
+
Lesson Plan
Curated OER

The Snack Bar

For Teachers 6th
Sixth graders complete a purchase order. In this ratios and patterns instructional activity, 6th graders work in groups to complete a purchase order for a grand opening of the school snack bar. Students use rations to figure out the need...
+
Lesson Plan
Curated OER

Box Folding: Predict, Analyze and Measure

For Teachers 10th - 11th
Students predict the shape of a geometric figure in 3D. In this geometry lesson, students construct 3D shapes to perfect their knowledge of measuring and predicting. This assignment is also available as an online interactive lesson.