Curated OER
Height and Weight
Third graders explore their height and weight. They measure the heights and weights of their peers. Students record their data using an Excel spreadsheet. They create a graph to compare the data and analyze it for a correlation between...
Curated OER
Heartbeat Project
Students enter information about their heartbeats into a spreadsheet. They construct data displays and calculate statistics. They describe and justify their conclusions from the data collected.
Curated OER
Is the Rainbow Fair?
Third graders perform statistical calculations. Given a bag of Skittles, 3rd graders sort and collect data regarding the colors included in their bag. Using spreadsheet software, students create a bar graph of the information collected....
Curated OER
Louisville's Best Field Day Park
Students create a survey to hand out to determine the best field day park. Using their local area, they select five parks, if possible, that meet the criteria and calculate the distance and estimated time travel. They use this...
Curated OER
Favorite Apple Graph
First graders record their favorite type of apple in the form of a graph. They each try one slice of a Red Delicious, Golden Delicious, and Granny Smith apple, select their favorite type, and create a class graph using the data collected.
Curated OER
Spreadsheet Graphs
Students create graphs using information from spreadsheets. They select a topic from the following choices: website use, digital cameras, spreadsheets, calculators or educational software. They tally the class results and create an...
Curated OER
Creating a Bar Graph with a Graphing Program
Students use the S'COOL data base to create a bar graph.
Curated OER
Using Averages to Create Graphs Through Excel
Sixth graders create and use a spreadsheet to make graphs which will be used to analyze Progress Report and Final Report Card grades. They practice finding the mean, median, mode, and range of a data set. Students also incorporate column...
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
Create your own plane.
Students create and or modify a plane to have the longest duration and/or flight distance, then record the flight and distance and repeat the activity for three flights Using calculators, students find the average of their three flights.
Curated OER
Creating Literacy Centers Using Technology
Students create two literacy (reading and/or writing) centers to implement in an elementary classroom. Students review examples of educational software and determine the best potential centers to use in elementary classroom. Two centers...
Curated OER
Three Squirrels and a Pile of Nuts
Students solve story problems using a spreadsheet in combination with various problem-solving strategies. Working in teams of three, students create attempt to solve a story problem using three different methods; using manipulative,...
Curated OER
Great Graphing
Students collect data, use a computer spreadsheet program to create various graphs, and compare the graphs. They state the findings of each graph in writing and decide which graph type best represents the data.
Curated OER
Technobiz
Students examine candy preferences to create a plan in order to improve candy sales. In this technobiz lesson plan, students build spreadsheet and organizational skills by graphing and calculating data. Students are introduced to...
Curated OER
Graphing the Past Using Today's Technology
Eighth graders research statistical data regarding their current social studies unit. They write questions about the measures of central tendency, collect and analyze the data, insert the data into a spreadsheet, and generate graphs.
Curated OER
Sweet Data
Students input data about the colors of their serving of M&M candies onto a spreadsheet. They create charts and graphs based on this information.
Curated OER
School Yard Waste
Fourth graders examine the types of garbage that they collect on the playground. They collect the information in a spreadsheet and create a graph that displays the number of types of trash found. They design and monitor a playground...
Curated OER
Penny Pushing
Fifth graders use an Excel spreadsheet to show them how to enter the amount of pennies they bring each week to school for a fundraising project. They count their pennies each Friday and enter the total amount in the correct columns. In...
Curated OER
Multiplication Tables Using Microsoft Excel
Eighth graders are introduced to Microsoft Excel as a computer application software program. They create multiplication tables in Microsoft Excel. Students work in small groups. They discuss the $ (anchor) function in Microsoft Excel.
Curated OER
What's Your Shoe Size? Linear Regression with MS Excel
Learners collect and analyze data. In this statistics instructional activity, pupils create a liner model of their data and analyze it using central tendencies. They find the linear regression using a spreadsheet.
Curated OER
Mmm, Mmm, M&M's
Here is another version of the classic M&M math lesson. In this one, upper graders utilize the ClarisWorks Spreadsheet program in order to document the data they come up with from their bags of M&M's. After making their initial...
Curated OER
"who Lives in Your House?"
Fourth graders collect data about the people and animals living in their homes, and the students' shoe sizes. They work in groups to enter the information into a database from which they create graphs. They analyze the data to find the...
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
Apple Adjectives
Study different apple varieties and use appropriate adjectives to describe them. Learners alphabetize both the apple names and the adjectives before creating spreadsheet, bar, and pie graphs. A mix of language arts, technology, and...