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.
Curated OER
Create Your Geometry Crossword
Students learn how to identify cell addresses, format cell contents, add pop-up comments to a cell, and also apply conditional formatting. They use clues and words to make a geometry crossword puzzle pertaining to geometrical shapes.
Curated OER
Building A Portfolio
Students gather images that are part of portfolio to be shared throughout the course of one school year. They complete written reflections based upon the images that are attained. The primary sources for the images is using a digital...
Curated OER
There's No Accounting for Good Journals
Tenth graders create journals on their spending habits. In this money-management lesson plan, 10th graders create and keep journals of their personal income and expenditures. Students learn to use Excel to create a spreadsheet for their...
Curated OER
Rock Creek Water Quality
Ninth graders test water in a local creek using chemical kits and probes. They take GPS readings and digital photos. They calculate the Water Quality Index and create a spreadsheet of the test data.
Curated OER
Rock Creek Water Quality
Ninth graders test water in a local creek using chemical kits and probes. They take GPS readings and digital photographs. They calculate the Water Quality Index and create a spreadsheet.
Curated OER
Putting Your Money to Work
Pupils create a collect data on expenses. In this algebra instructional activity, students create a spreadsheet to solve scientific equations. They incorporate math, science and technology in this instructional activity.
Curated OER
Buying My First Car Worksheet 3
In this math worksheet, students create a spreadsheet for the different costs of the purchase of a car and use the information to answer 3 questions.
Concord Consortium
Boards I
Learners create patterns in a table to mimic the function of an electronic spreadsheet. The result is a table that creates an addition table for decimals in intervals of one-tenth. While creating the pattern, pupils must thoroughly...
University of Missouri
Money Math
Young mathematicians put their skills to the test in the real world during this four-lesson consumer math unit. Whether they are learning how compound interest can make them millionaires, calculating the cost of remodeling...
Curated OER
Sunrise, Sunset
What locations on Earth get the longest number of hours of daylight in the summer? Hint: It's not the equator! Use real-world sunrise and sunset data to develop trigonometric models that can be used to estimate the number of hours of...
Teach Engineering
Energy Perspectives
The data says ... the resource is great to use. Using Microsoft Excel, pupils analyze data from the US Department of Energy in the fifth lesson of a 25-part Energy Systems and Solutions unit. Each group looks at a different data set and...
EngageNY
Sampling Variability in the Sample Mean (part 2)
Reduce variability for more accurate statistics. Through simulation, learners examine sample data and calculate a sample mean. They understand that increasing the number of samples creates results that are more representative of the...
Curated OER
A Mathematical Model of the Sun
In this mathematical model of the sun worksheet, students read about the way scientists use the sun's radius and mass to determine a mathematical model of the sun using the volume of a sphere, and the relationship between density, volume...
Curated OER
Credit Cards: The Good, the Bad, and the ugly
Learners study how dangerous credit cards can be. They see why it is important to pay off credit card bills as soon as they can. They use MS Excel to display and understand the data. They fill out questions using the data from their...
Curated OER
Magic Number
Students create addition sentences. They review number lines and how to jump between numbers to solve equations. They play the "Magic Number" game by using a spreadsheet and guessing numbers. They discuss how they found the magic numbers.
Curated OER
Do You Measure Up?
Students measure their height and then they will input the information into a spreadsheet. After the data is entered, students will use the material gathered to create a bar graph showing the heights of people in their class.
Curated OER
What's Up With My Class
Middle schoolers collect data about their class and they use Excel spreadsheet to display their tables and graphs about the class. They answer survey questions and collect their data. Students create a graph of their choice to display...
Curated OER
Look Into My Eyes!
Students explore collecting, analyzing, and graphing information. They collect data on the various eye colors of their classmates. Students tally the results and create a graph.
Curated OER
The Price is Right
Students, through various activities, explore online databases. Using the internet, students explore the distributors websites. They collect specific information on selected products. An spreadsheet with price comparisons is developed....
Curated OER
Excel Lesson Plan Coin Statistics
Second graders determine the difference between making a prediction and determining actual information. They design a spreadsheet for a coin flipping activity on which they include their predictions and what actual happens when they flip...
Curated OER
And the Winner Is...
Third graders participate in an election project. They collect data to create a spreadsheet from which a graph is generated.
Curated OER
Spreadsheet Activity
Young scholars 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.
Curated OER
Sorting
Students examine how sorting is the process of putting things into an orderly sequence based on some key value. In this lesson students create a spreadsheet with 26 rows of data, then sort those rows by different values.