Curated OER
Experiment-Using Formulas and Spreadsheets
In this Algebra I worksheet, 9th graders track information relating to a sporting event and create a spreadsheet and appropriate formulas used to track data. The one page worksheet contains the assignment and...
Curated OER
Probability Using M & M's
Middle schoolers develop an understanding of probability by sorting bags of M & M's by color and recording the results in percents. The data is entered onto a spreasdsheet and graphed.
Curated OER
Dino-Myte Spreadsheet
Do your learners like dinosaurs and theme parks? An ambitious lesson plan 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...
Student Handouts
Blank Monthly Calendar
Don't have time to fiddle with spreadsheets or tables? Here's a printable calendar that you can quickly print and use for any month of the year!
Curated OER
Introduction to Limits
High schoolers practice using graphing calculators and spreadsheets as they explore numeric limits using sequences and functions. They complete a sequencing worksheet, and determine which sequence corresponds to story a story called...
Curated OER
Penny Pushing
Fifth graders use an Excel spreadsheet to show them how to enter the amount of pennies they bring each week to school for a fundraising project. They count their pennies each Friday and enter the total amount in the correct columns. In...
Curated OER
Discovering Pi
Sixth graders measure circumference and diameter to the nearest eighth of an inch, record measurements on a spreadsheet, and use the internet to complete a "scavenger hunt" of facts concerning pi.
Curated OER
The Hot Dog Stand
Students run a computer simulation. They collect data as they work and use the data to create an annual report for their business. Several different simulations could be used for this project. It is desirable for students to do this...
Curated OER
ExplorA-Pond: 6th Grade Area and Random Number Tables
Sixth graders estimate surface area of a pond using a random number table.
Curated OER
Shoe Showdown
Third graders use rulers to measure their shoe size in inches and centimeters. They then enter the class shoe measurements into an excel data base and graph the results of both to make the comparison.
Curated OER
Excel Lesson
Fifth graders will perform exercises and write the number of each exercise performed on the collection data sheet. They survey eight of their classmates for their exercise data and write that data on the collection data sheet. They then...
Curated OER
What's Playing Tonight?
Students collect data and visually represent it. They conduct a survey of favorite movies. Using a spreadsheet, students organize the data and create bar and circle graphs. Students answer statistical questions regarding the data.
Curated OER
Two-Variable Linear Inequalities
Here is an engaging lesson plan on solving equations with two variables. Have the class rewrite linear equations in the slope intercept form, y=mx + b. They graph the lines using the slope and y-intercepts.
Curated OER
Drawing One and Two Playing Cards With Replacement
Math whizzes use data from simulations to make theoretical generalizations and discuss possible relationships between several given events. They use a simple card game to generate data to be analyzed.
Curated OER
A Fishy Tale
Eighth graders do a research project on a particular species of Atlantic seafood and record and graph information pertaining to commercial landings of that species of seafood. They use a website and an Appleworks spreadsheet.
Curated OER
"Reality Math: Fact or Fiction"
Students investigate the use of math in everyday life. They investigate several occupations and pay scales. They complete spreadsheets that show how monthly bills can be organized using technology. They use word processing software to...
Curated OER
Excel Lesson
Students explore data and Excel spreadsheets. They collect data about political candidates. Students enter the data into a chart on Excel. They create a graph using the data and Excel.
Curated OER
How Much Sport Is Good For YOu
Young scholars using spreadsheets, devise a weekly exercise timetable for a fitness fanatic and a realistic one for themselves. Students chart out the number of calories used by doing different sports. Young scholars plan out a healthy...
Curated OER
Sportsround
Pupils devise a plan to help get kids more active by encouraging them to participate in sports. Student, using spreadsheets, devise a weekly exercise timetable for a fitness fanatic and a realistic one of themselves.
Curated OER
Newspaper
Eighth graders, in groups, create a newspaper using topics from an assigned chapter. They use ClarisWorks word processing, insert graphics, and create graphs using spreadsheets.
Curated OER
The Solar Cycle
Students research the solar cycle. In this Science lesson, students use the internet to investigate the solar cycle. Students produce a spreadsheet and graph from the information collected.
Curated OER
Backyard Birds: Who's Who Out There?
Young scholars practice techniques of field observation and data-gathering while studying local bird population, describe ecosystem as complex combination of elements, which can affect or be affected by each other, and determine effects...
Curated OER
Mmm, Mmm, M&M's
Here is another version of the classic M&M math lesson. In this one, upper graders utilize the ClarisWorks Spreadsheet program in order to document the data they come up with from their bags of M&M's. After making their initial...