Curated OER
Ancient Peoples of the Middle East
This is an excellent multidisciplinary lesson designed by Scientific American. It provides three creative activities--designing a garden, studying hieroglyphics, and writing poetry--relevant to the ancient peoples of the Middle East....
Curated OER
Journalism
Learners insert raw data about Ad sales into an Excel chart. They use raw data in a letter to local businesses by using the Mail Merge program. They represent data using tables and graphs.
Curated OER
Pets Galore!
Fourth graders conduct a class survey on the number of pets that the 4th grade owns and they record that data in their math notebooks. They make a bar graph displaying the results using a spreadsheet through Microsoft Excel.
Curated OER
Technology - Data Collection
Students collect and analyze data from the United States Census Bureau. Using spreadsheet technology, students explore their results and make preductions about income groups. Students compute the mean, median and mode. They create...
Curated OER
Predicting Temperature: An Internet/Excel Learning Experience
Third graders use the Internet (www.weather.com) to find the high temperature for our locale and the high temperature for another city around the world. They keep track of the temperature in these two locations for 10 days.
Curated OER
Marvelous Math -- Colorful Fractions
Students begin the lesson by discovering that a fraction is one part of a whole. In groups, they practice reducting larger fractions into small fractions and discovering they are equal. They use blocks to identify the relationship...
Curated OER
Slopey Math
Students identify the slope of a line and use it to solve real life problems. In this algebra lesson, students write linear equations in slope intercept form and make a correlation to its relation to the real world. They use the slope an...
Curated OER
Math for the Frontier
Students explore the concept of inflation. In this inflation activity, students compile a list of necessities they would need to take with them if they were moving to a new state next month. Students compare their list with that of a...
PBL Pathways
College Costs 2
What is the financial benefit for attending a community college for the first two years before transferring to a four-year college? The second part of the educational lesson asks young scholars to explore this question through data...
PBL Pathways
Potassium-Argon Dating
Find the age of a fictional sample of rocks using a genuine approach. A well-designed lesson asks young mathematicians to use exponential modeling to analyze half-life. As a project-based learning activity, scholars communicate...
Curated OER
Using Averages to Create Graphs Through Excel
Sixth graders create and use a spreadsheet to make graphs which will be used to analyze Progress Report and Final Report Card grades. They practice finding the mean, median, mode, and range of a data set. Students also incorporate column...
Curated OER
Interest Calculation and Spreadsheets
Students, while in the computer lab working on a spreadsheet program, calculate interest and accumulated value of a savings plan. They follow specific directives on how to create their spreadsheets. At the end of the lesson they print...
Space Awareness
Navigation in the Ancient Mediterranean and Beyond
Ancient texts, like Homer's Odyssey, mentions navigating ships by observing constellations. Pupils learn about the link between history and astronomy as they relate to navigation in the Bronze Age. Scholars complete two hands-on...
Curated OER
Integers
In this integers activity, students solve and complete 8 various types of word problems. First, they read each problem and determine from the information what they are looking for. Then, students determine the operations necessary to...
Curated OER
Don't Lose Your Load!
Students create graphs using collected data. In this algebra lesson, students use spreadsheet in Excel to create graphs to interpret their data and make predictions. They rewrite word problems using algebraic expressions.
Curated OER
Food for Thought
Third graders conduct a survey of their class' favorite foods voting on 3-4 favorites overall. They then go to the computer lab and examine how to produce a horizontal bar graph by graphing the favorite foods of the class.
Curated OER
Are You My Little Peanut?
Fourth graders explore the mass and length of peanuts by pretending to parent a peanut. In this mode, median and range lesson students graph their measurements and then use them to find the mode, median and range. Students discuss peanut...
Curated OER
The Candy Color Caper
Learners explore the concept of probability. They calculate the probability of an event happening and graph their results. Students determine the probability of winning a sweepstakes. They construct a bar graph to represent all the...
Curated OER
Learning Inference
Making inferences can be a tricky proposition for middle schoolers. In the lesson presented here, pupils practice the skill of drawing a conclusion and making a judgment - which are what making an inference is all about! There are five...
National Research Center for Career and Technical Education
Depreciation (Double Declining)
Have you ever been told that your new car begins to lose its value as soon as you drive it off the lot? Aspiring accountants take on the concepts of depreciation and book value through an easy-to-deliver career and technology lesson. The...
Curated OER
Graphing
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.
Curated OER
Divisibility Rules
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...
Curated OER
You mean college costs that much?
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.
Curated OER
Using a Spreadsheet
Learners 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.