Curated OER
Solving Polynomial Equations
Students demonstrate how to use spreadsheets as a tool for analyzing, visualizing and solving mathematical problems. Students obtain fundamental grasp of cubic equations and other polynomial equations.
Curated OER
Spreadsheet Function Machine
Students create a spreadsheet to analyze functions. In this algebra lesson plan, students use spreadsheets to find the intersection of systems of equations. They identify the dependent and independent function as it relates to a line.
Curated OER
Graphing Favorite Holidays
Young scholars create spreadsheets and bar graphs based on results of survey of favorite holidays.
Curated OER
Finding Mean, Mode and Median in the Computer Lab
Students create spreadsheets which will display and figure mean, median, and mode of a set of numbers.
Curated OER
What Temperature Is It?
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...
Curated OER
Touring the Regions of the United States
Fifth graders explore the regions of the United States. They use maps, research on the Internet and use measurements and estimations. Students create a presentation using spreadsheets and publishing software.
Curated OER
And the Survey Says...
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...
Curated OER
Putting Your Money to Work
Students create a collect data on expenses. In this algebra lesson plan, students create a spreadsheet to solve scientific equations. They incorporate math, science and technology in this lesson plan.
Curated OER
Graphs! Graphs! Graphs!
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.
Curated OER
I'm in the Money - Practical Money Skills
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.
Curated OER
Linear Regression (and Best Fit)
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.
Curated OER
Tiling a Patio
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...
Curated OER
Class of 2000 - Student Loans
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...
Curated OER
Electronic Spreadsheets & Iditarod 2000
Students use the Internet for gathering information for Iditarod race journals. They use a spreadsheet program for entering data and making charts for showing changes in speeds achieved over a period of four weeks in timed writings in...
Curated OER
Cars: Math, Research, Economics, Loans
Young scholars investigate what the purchasing of a car entails. They explore car criteria and financing options.
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...
Curated OER
Discovering Pi
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.
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.
Curated OER
Iditarod
For this Iditarod worksheet, young scholars complete word problems about fractions, money, and more, based on the Iditarod race. Students complete 10 problems.
Curated OER
Buying Cars/Financing Cars Compound Interest
Provide a real world context in which exponential functions are used to determine a eal world phenomena such as compound interest and exponential growth. This activity should be taught after students have mastered the laws of exponents...
Curated OER
Conversation Heart Graphing
Sixth graders review the different types of graphs (bar, line, pictograph) They predict the data set they can garner several boxes of conversation hearts. Students record their data using an Excel spreadsheet. They create a graph based...
Statistics Education Web
Walk the Line
How confident are you? Explore the meaning of a confidence interval using class collected data. Learners analyze data and follow the steps to determine a 95 percent confidence interval. They then interpret the meaning of the confidence...
Curated OER
Flavorful Spreadsheets
Students create a spreadsheet which includes a bar graph. They sort and classify information and use the average function on a spreadsheet. They research Skittles candy and summarize their findings on a spreadsheet.
Curated OER
Spreadsheet Activity
Students create a spreadsheet to match a given sample. This includes adjusting column width and row height, changing alignment, changing size and style of print, changing number format.