Lesson Plan
Curated OER

Discovering Pi

For Teachers 9th - 11th
Define terminology related to a circle. Practice accuracy in measuring and then create a spreadsheet based on data collected from solving for parts of a circle. Groups can have fun analyzing their data as it relates to Pi.
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
1
1
Curated OER

What Makes Our Community Special?

For Teachers 3rd - 12th
Explore websites, complete research, and use technological tools to create a final multimedia presentation on what makes a community special. Learners of all ages work with a partner to research an interesting aspect of their community,...
Activity
Education Development Center

Interpreting Statistical Measures—Class Scores

For Students 9th - 12th Standards
Explore the effect of outliers through an analysis of mean, median, and standard deviation. Your classes examine and compare these measures for two groups. They must make sense of a group that has a higher mean but lower median compared...
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
Young scholars create spreadsheets and bar graphs based on results of survey of favorite holidays.
Lesson Plan
Curated OER

Graphs! Graphs! Graphs!

For Teachers 6th - 8th
Students practice making charts and graphs from data on spreadsheets. Individually, they create a graph representing the latest information on voter registration. They answer questions and analyze the data to end the lesson.
Lesson Plan
Curated OER

Finding Mean, Mode and Median in the Computer Lab

For Teachers 5th - 12th
Students create spreadsheets which will display and figure mean, median, and mode of a set of numbers.
Lesson Plan
Curated OER

Polygons and Plane Figures

For Teachers 4th - 6th
Students choose a polygon to define and describe, and use Power Point and the Internet to present their polygon.
Lesson Plan
Curated OER

I'm in the Money - Practical Money Skills

For Teachers 3rd - 6th
Students make a budget and utilize math skills to keep a record of what they spend. They use technology and spreadsheets to help them keep track of their money.
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

A Christmas Project

For Teachers 7th
Seventh graders publish a letter and spreadsheet using the computer. They build a three-dimesnsional object with construction paper and develop a Christmas object using coordinates on a graph. Students compose a response in their journals.
Lesson Plan
Curated OER

What Temperature Is It?

For Teachers 3rd - 5th
Students use the internet to research information on the average maximum and minimum temperature for a city in their state. They create spreadsheets and enter data to analyze the information, focusing on averages, maximums, minimums and...
Lesson Plan
Curated OER

Harry Potter Research Project

For Teachers 4th - 5th
Students work together to complete a research project on Harry Potter. They write a research question and develop a survey to give to their classmates. Using the results, they create a graph and draw conclusions about the data collected.
Lesson Plan
Curated OER

And the Survey Says...

For Teachers 7th - 8th
Students use technology to input, retrieve, organize, manipulate, evaluate, and communicate information; apply appropriate technologies to critical thinking, creative expression, and decision-making skills. They collect and explore data...
Lesson Plan
Curated OER

The Snack Bar

For Teachers 6th
Sixth graders complete a purchase order. In this ratios and patterns lesson, 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 and quantity...
Lesson Plan
Curated OER

Tiling a Patio

For Teachers 5th
Fifth graders practice, with spreadsheets, to demonstrate how to determine the number of tiles needed to create a patio. They use pictures and gathered data to determine a pattern that can be used to solve problems. Students create a...
Lesson Plan
Curated OER

Scale Basketball

For Teachers 9th - 12th
Students understand that a spreadsheet can be used to find the best scale to use in a model. They place the distances of the planets of the solar system to the Sun in one column of the spreadsheet. Students try different scales so that...
Lesson Plan
Curated OER

Fast Food Fun

For Teachers 4th - 6th
Students use technology to input, retrieve, organize, manipulate, evaluate, and communicate information to find calories and fat in a typical fast food meal. They decide which fast food restaurant you would like to visit and click on...
Lesson Plan
Curated OER

Survey Says...

For Teachers 3rd - 7th
Students practice taking surveys to answer different questions about radio.  In this communications lesson, students brainstorm to create questions they can ask strangers about how often they listen to their radio.  Students...
Lesson Plan
Curated OER

Checking Test Comparability/Scattergrams

For Teachers 7th - 12th
Students construct a scattergram graph. In this statistics lesson plan, students graph data by hand and using a spreadsheet program. They establish lines of best fit and draw conclusions using their graphs.
Lesson Plan
Curated OER

Class of 2000 - Student Loans

For Teachers 10th - 12th
Students determine how they will finance their postsecondary education. In this student loan lesson, students create spreadsheets that help them budget their first year of college. Students identify methods to fund the budgets and...
Lesson Plan
Curated OER

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

For Teachers 7th - 12th
Learners improve data entry in a spreadsheet.
Lesson Plan
Curated OER

Linear Regression (and Best Fit)

For Teachers 9th - 12th
Students explore notions of relationships between two variables. They use discussion, games, worksheets, spreadsheets to consider relationships such as: height vs. shoe size, cricket chirping vs. temperature.