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

Virtual Field Trip

For Teachers 5th - 7th
Are we there yet?  Young trip planners learn about their state and plan a trip. They will select sites to see in three cities in their state, and record associated costs in a spreadsheet. While this was originally designed as a...
Lesson Plan
Curated OER

Don't Settle for a Byte... Get the Megabyte on Technology

For Teachers 4th - 12th
Students use word processing, presentation, and spreadsheet software. In this multi-day computer software usage lesson, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint to...
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

Student News And Weather Channel

For Teachers 5th
Fabulous! Your 5th graders should love this project. As an ongoing lesson throughout the year students use temperature probes to record outside temperature and then document their data using spreadsheets. They use their weather data and...
Lesson Plan
Curated OER

Bounce With Me

For Teachers 9th - 10th
How many practice lay-ups do you think Michael Jordan has done in his lifetime? Too many to count, but he had to start somewhere! Practice is the key to getting better in any activity. Look through this basketball lesson as there are...
Lesson Plan
Curated OER

All Aboard!

For Teachers 9th - 12th
Students research the history and background of snowboarding as well as the two main types of competition; the Giant Slalom and the Halfpipe. They find the schedule of past and future events and plot the locations of as many of these...
Lesson Plan
Curated OER

Measuring Rainfall and Relationships Between pH, Alkalinity and Suspended Solids in the Pago River

For Teachers 11th
Eleventh graders test the pH and alkalinity of Pago River. In this ecology instructional activity, 11th graders collect data and use spreadsheet to graph results. They analyze and share their findings with the class.
Lesson Plan
1
1
California Academy of Science

Optimal and Sustainable: Renewable Energy Revamp

For Teachers 6th - 10th Standards
More than 100 cities around the world have shifted from fossil fuels to renewable energy sources. Scholars investigate a city wanting to make this switch, but needs help determining how to make the shift. Groups consider all options,...
Lesson Plan
Curated OER

Graphing Favorite Colors

For Teachers 3rd
Third graders collect data and insert it into ClarisWorks to create a spreadsheet/graph of their favorite color. They interpret the data together.
Lesson Plan
Curated OER

Fabulous Fossils

For Teachers 7th
Seventh graders investigate how fossils are formed and discuss how scientists determine the appearance of ancient plants and animals. They make fossils of everyday objects for others to identify. They make spreadsheets to display fossil...
Lesson Plan
Curated OER

Paper Tower Challenge

For Teachers 2nd - 5th
Student explore the challenge of building a tower using paper. They build their tower using paper and record the height of their tower. Students collect and record the heights of other towers and use that data to create a spreadsheet.
Lesson Plan
Curated OER

Learning and Population Information - Where I Live

For Teachers 4th - 5th
Students study their county populations in a multimedia presentation format. In this populations lesson, students work in groups of 3 to research the county populations in their state. Students chart their results in an Excel document...
Lesson Plan
Curated OER

How to Make a Chili Dog

For Teachers 3rd - 6th
Students practice sequencing skills. They discuss what makes a hotdog and the proper sequence for performing the task. Using computer technology, students create a multimedia show that deomonstrates the basic directions for making a...
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
Kenan Fellows

Saving Those Who Save Us: Exploring the Use of Sensors with Data Visualization

For Teachers 9th - 12th Standards
Sensor technology is amazingly accurate and useful. Combining the sensor technology and mathematical knowledge, scholars design experiments to answer a question they have developed. Questions may focus on light sensing, temperature...
Lesson Plan
Curated OER

There's No Accountin with Ledgers

For Teachers 10th
Tenth graders create and maintain a ledger, write an essay for the process, and learn to keep financial accounts through the ledger. In this ledger lesson, 10th graders define an accounting ledger and create one for the money they've...
Lesson Plan
Curated OER

My Community

For Teachers 1st
First graders design a Powerpoint presentation to reflect information about their community.  In this community instructional activity, 1st graders create slides to explain the weather, geography and other information about the city.
Lesson Plan
Curated OER

Earth Energy Budget Pre Lab

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

Reaching the Solar System

For Teachers 3rd - 5th
Students sing the Rap of the Solar System, view pictures of the planets, and calculate their weights and ages on all the planets and the sun. They create a presentation comparing themselves with a planet or object in the solar system.
Lesson Plan
Curated OER

Wings and Othe Things

For Teachers 3rd - 6th
Students work in groups that are engaged in different activities at different times. They watch the video "Madagascar" and collect data pertaining to the Fish Eagle's arm spam. They work together to perform mathematical computations...
Lesson Plan
Curated OER

Graphing Weights and Measures

For Teachers 4th - 6th
Students practice gathering, averaging, and graphing data. They practice converting measurements to the metric system. Students graph their results and present them to the class.
Lesson Plan
Curated OER

Dream Vacation

For Teachers 9th - 12th
Learners research cities, states, or countries using the internet and other resources to learn about a vacation spot. They make a final presentation of their findings in forms other than a written report.