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
A Line Graph of the Ocean Floor
Learners develop a spreadsheet and import the information into a line graph. In this spreadsheet and line graph instructional activity, students develop a spreadsheet of ocean depths. They import the information into a word processed...
Curated OER
BRIDGING THE GENERATION GAP
High schoolers create a hypothesis about the attitudinal differences between generations, test their hypothesis with a survey, chart their findings, and present their answers to the class.
Curated OER
Code Crackers Math Game
Students, through this math game, are provided with opportunities to work with math operations and simple algebraic equations. They create a spreadsheet-based "rule machine."
Curated OER
How Much Is It?
Learners explore foreign currencies. In this foreign currencies lesson, students simulate travel to another country and determine the value of the US dollar compared to other countries. Learners use a conversion table and search Internet...
Curated OER
Kindergarten Class Favorites
Students discuss their favorite foods, a list of four favorite food are compiled on the board or a chart. They each vote for their favorite food and the data is entered onto a spread sheet and a graph is created while the students watch...
Curated OER
Microsoft Office Excel
Middle schoolers use Microsoft Office Excel. In this technology lesson plan, students enter data on a spreadsheet using Excel. This programs tallies data and presents it using graphs.
Curated OER
What's your favorite physical fitness activity?
Fourth graders engage in a class discussion where they create a list of their favorite physical fitness activities. They tally the numbers on the board and use Microsoft Excel to create a spreadsheet and graph of the activities.
Curated OER
Basic Excel
Students explore basic Excel spreadsheets. In this spreadsheet lesson plan, students enter Alaska weather information and perform calculations. Students title the columns on the spreadsheet and format the cells. ...
Curated OER
Correlation of Variables by Graphing
Middle and high schoolers use a spreadsheet to graph data. In this graphing lesson, learners determine how two parameters are correlated. They create a scatter plot graph using a computer spreadsheet.
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
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.
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.
Curated OER
Information Shuffle
Gather some information, print it onto sentence strips, and then have your class physically shuffle the cards to better understand the importance of organizational patterns in writing. Middle school learners examine information for a...
Curated OER
Pedestrian Safety for Students
Students create a spreadsheet. For this spreadsheet lesson, 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
A Healthy Heart
Sixth graders create a spreadsheet using specific data. A speaker comes to discuss the heart, and the difference between anaerobic and aerobic activity. They make posters to encourage a healthy heart lifestyle.
Curated OER
The Expenditure Sheet
Students differentiate between expenditure and income. In this algebra lesson, students create a spreadsheet labeling the date, item and amount as they track their expenses. They format the cells of the spreadsheet to do all the...
Curated OER
Super Spreadsheets
Young scholars discover information about each of the fifty states in the United States. In groups, they create a spreadsheet organizing the information to show to the class. They discover different ways to display the data and...
Curated OER
PLANNING A DIVERSIFIED INVESTMENT PORTFOLIO
Twelfth graders research stocks and how to read and interpret financial data. They choose 5 companies to invest in and track their performance over 10 weeks. They create a spreadsheet which shows the results.
Curated OER
Escape Velocity
Sixth graders create/use spreadsheets to solve real-world problems, explore patterns, make predictions, select/explain most appropriate types of graph to display data, use information to create product, and have basic understanding of...
ESL Kid Stuff
Daily Routines & Times of the Day
What time do you eat breakfast? Or go to school? Language learners practice crafting and answering questions about their daily routines.
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...
Curated OER
Integers in the Weather
Middle schoolers engage in a clever lesson that combines meteorology with mathematical thinking. They use integers in relation to high and low temperatures that they record. They use a spreadsheet of weather data, a computer, and gain...
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...