Curated OER
State Economy Chart
Fifth graders research and record statistics on the economy of an assigned state. They create a spreadsheet in Excel to report the data and a 3D Pie graph using the Chart Wizard in Excel to represent their states' data.
Curated OER
Heat of an Unknown Metal
Eighth graders complete labs to find the specific heat of many different types of substances, and use characteristic property to identify an unknown metal. CBL be used to determine energy lost or gained, and students complete a...
Curated OER
Modeling Mitosis and Meiosis
Students construct and manipulate models of mitosis and meiosis and compare/contrast them. They create the models using index cards and yarn, interpret diagrams and photographs, and summarize written descriptions.
Curated OER
Exploring Careers
Seventh graders investigate their career aptitudes and interests through a scavenger hunt. They display their choices in Excel spreadsheets.
Alabama Learning Exchange
Watch That Plant Grow
Middle schoolers examine the growth of marigolds in a greenhouse environment. They chart data in spreadsheets showing plant growth over time and under a number of conditions. They record measures of plant height and greenhouse temperature.
Curated OER
Time Management
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...
Curated OER
Sales Spreadsheet
Young scholars use Excel spreadsheets to organize purchases, discounts, sales prices, and sales tax. Students follow step by step instructions and enter formulas as well as use the auto sum feature to calculate required calculations.
Curated OER
Money Math: Lessons for Life
Students develop a budget for a college student using all of the influences that the student would have. In this budgeting lesson plan, students use real life examples to create a budget spreadsheet. Students read and study...
Curated OER
Where the Buffalo Roam
Students lear about energy, energy efficiency and consumption. They measure energy use, graph the date, write a letter then design and present a PowerPoint on the topic.
Curated OER
Simple Harmonic Motion with Dr. DAQ
Young scholars study the work and accomplishment of Galileo. In this physics lesson, students calculate the period of a pendulum's using a mathematical equation. They explain the different factors affecting its period.
Curated OER
Hunter Fred's Quest for Dinner
Learners solve problems using trigonometric functions, specifically a problem about a tree stand. Pupils try to maximize the distance of hunting sight given certain restrictions. They use the Pythagorean Theorem, sine, cosine, and...
Curated OER
Polluting the Environment
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...
Curated OER
Pythagorean Theorem Spreadsheet
Studetns use a spreadsheet to organize data on the sides of a triangle. They use the Pythagorean Theorem and the If then spreadsheet function to decide whether the three sides determine a right triangle. Young scholars work individual...
Curated OER
A Holiday Card in KidPix
Students create a holiday card using computer software. In this computer card making lesson, students design an original holiday card using a variety of tools. Students navigate the software utilizing various tools.
Curated OER
Publisher Brochures
Students create brochures on subjects they are studying in Publisher. In this nonfiction writing instructional activity, students use Publisher to create a brochure telling all the main ideas of a topic they are studying. Students use...
Curated OER
Elbow Room - Exploring Population Density
In this population worksheet, students click on the links and research the internet about population, land, and government. Students answer 16 short answer questions including making spreadsheets.
Curated OER
Piecewise Linear Functions and Excel
In this linear function worksheet, students use Excel worksheets to solve piecewise linear functions. They plot functions and produce piecewise linear functions. This six-page worksheet contains detailed instructions on how to use...
Curated OER
Making a Travel Brochure of a Louisiana Parish
Although the attachments for this travel brochure project are no longer linked, you can still use the idea here and create your own assignment sheet and rubric. Learners choose a parish in Louisiana (or a city in your state) to research,...
Curated OER
Graphing With a Spreadsheet
Fourth graders review how to create bar, line and circle graphs. Using jelly beans, they collect data and present it in a bar graph form. They enter the same data into a spreadsheet and watch as the program creates the same graph. They...
Curated OER
World Education Statistics
Students use a spreadsheet from The Digest of Education Statistics and convert the statistics to percentages, and create a chart of their new data. Students discuss their findings about the disparities in educational spending among...
Federal Reserve Bank
Expense Tracking
Where does all your money go? Individuals keep a record of the money they spend over the course of 30 days. They then categorize where they are spending their money and write an essay detailing their findings.
Code.org
Cleaning Data
"Clean the data!" "I did not know it was dirty." Introduce your class to the process of cleaning data so that it can analyze it. Groups work through a guide that demonstrates the common ways to filter and sort data. Pairs then...
EngageNY
Normal Distributions (part 2)
From z-scores to probability. Learners put together the concepts from the previous lessons to determine the probability of a given range of outcomes. They make predictions and interpret them in the context of the problem.
NASA
Measuring Dark Energy
You're only 10 minutes late? Do you know how much the universe has expanded in those 10 minutes? Scholars graph supernovae based on their redshift and see if the results verify Hubble's Law. If it does confirm it, the universe is...