Curated OER
Pedestrian Safety for Students
Students create a spreadsheet. In this spreadsheet lesson plan, students take the responses they received from a pedestrian safety survey to create their spreadsheet. Then they turn this information into a graph.
Curated OER
Math Operations/Formulas
Students discuss the ways spreadsheets can help them solve story problems. In groups, they must set up a spreadsheet with the correct formulas based off of different scenerios using the correct order of operations. To end the lesson,...
Curated OER
Break Even Analysis and Budgeting
Students analyze the use of break even charts in business planning. They examine the purpose and nature of budgets. They explore price elasticity and how to use Excel spreadsheets to manipulate financial information.
Curated OER
Three Squirrels and a Pile of Nuts
Learners solve word problems using a spreadsheet, strategies, and algebraic variables. They disuss the given problem, which can be printed, write the unknowns, and employ the strategies into a spreadsheet. Students then use Microsoft...
Curated OER
State Economy Chart
Fifth graders create a 3D Pie graph using the Chart Wizard in Excel to represent their assigned states' data. They discuss the similarities and differences between states, and form a hypothesis on the relationship between location and...
Curated OER
What Do Plants Need to Grow?
Fourth graders control variables to determine the effect on plant growth. They collect information by observing and measuring and construct simple graphs, tables, maps and charts to organize, examine and evaluate information.
Curated OER
Aerospace Engineering
Twelfth graders examine the physics of rocket flight. They build and launch model rockets to measure their performances.
Curated OER
Survival of the Fittest – Battling Beetles
Students explore natural selection. For this genetic adaptation lesson, students discover why certain traits continue and some traits disappear. Students discover how species evolve and change. Resources are provided.
Curated OER
Earth Energy Budget Pre Lab
Students explore energy by conducting an in class experiment. In this climate change lesson, students conduct a water vapor experiment in a soda bottle. Students utilize graphs and charts to analyze the results of the experiment and help...
Space Awareness
The Climate in Numbers and Graphs
Weather versus climate: weather relates to short time periods while climate averages the weather of a period of many years. Scholars learn about average temperature and precipitation in various climate zones and then apply statistics...
Curated OER
Favorite Foods at Thanksgiving
Fourth graders study different types of graphs as a means of displaying information. They survey others to find their favorite Thanksgiving food and then graph the results using different types of graphs.
Curated OER
Weather, Weather, Everywhere!
Sixth graders collect weather data to compare temperatures around the world. Using the Internet, learners collect data, put it into spreadsheets, and analyze and graph the results. An interesting way to cover the topic of weather.
Curated OER
Build a Black History Database/Timeline
Young scholars research famous people and events in Black History then break the biographies and events down into specific information related to dates in history. They
Curated OER
Enhancing Writing Through Technology
Students participate in a class survey of their favorite activity to do in the snow and organize the results in a graph. They write a paragraph about the graph using language from a class-developed word web and include both an opening...
Curated OER
Charting Seasonal Changes
Students research the Earth's patterns of rotation and revolution, create a chart and graph of these patterns and use them to explain the causes of night and day and summer and winter.
Curated OER
Checking County Numbers
Students use their county's information page to gather information about their community. Using the information, they create graphs from the tables provided and interpret the data. They write a paragraph showing their interpretation of...
Curated OER
Lucky Number
Students use data from simulations to make theoretical generalizations. They discuss possible relationships between several given events and gain understanding about their own mathematical intuition about likelihood.
Curated OER
Asthma "Outbreak" Exercise
Students investigate numerical data on a possible asthma epidemic. Using statistical information, students graph and figure ratios of the epidemic. They evaluate the mortality rate from severe smog in the 1950's in London.
Curated OER
Interpreting and creating tables
Students observe examples and discuss how to interpret them. They then
brainstorm examples of possible questions students could use to create a table. They take time to formulate a question and collect data.