Radford University
How Is Your Gender Represented?
Does the media shape people's views on gender? Scholars use data on gender portrayal in magazines to explore the idea. They use a spreadsheet program to create bar graphs and perform a chi-square test. They also use provided data to...
Radford University
Real World Data
Make math class feel more real by using real-world data. Scholars research or collect data on several different topics, such as nutrition, the motion of moving objects, cooling curves, and daylight hours. They create scatter plots using...
Curated OER
Sweet Data
Young scholars 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 lesson, 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...
Curated OER
Graphing Iron Data
Students apply a data set to create a graph show how iron ore impacts an ecosystem. They explain how the iron effects the distribution and abundance of phytoplankton in coastal ecosystems using spreadsheet software.
Curated OER
What's Up With My Class
Learners 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 the...
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
First Grade Shoe Sizes
Third graders collect shoe size data from classmates in their room and another third grade. They predict what the most common shoe size will be. They place the data in an spreadsheet on the computer. They design a graph using the...
Curated OER
What's Playing Tonight?
Students collect data and visually represent it. They conduct a survey of favorite movies. Using a spreadsheet, students organize the data and create bar and circle graphs. Students answer statistical questions regarding the data.
Curated OER
Growing a Seed
Seeing how seeds grow into plants is such an enjoyable for students! They plant lima bean seeds and take pictures to record the growth of their plants. Students write in a journal to describe their daily observations of their plants, and...
Curated OER
Graphing Your Favorite Pizza Topping
Fifth graders can survey the students just in their classroom, the grade level, or other grade levels. Upon finishing the surveys and compiling the data, the students can input their results in an Excel template or create their own...
Curated OER
Reading & Using a Nutrition Label
Students discover the importance of healthy eating. Using food nutrition labels, they read and examine the nutritional value. Students collect the data on a spreadsheet and create a graph. They analyze the media influences on product...
Curated OER
MAISA and the REMC Association of Michigan
Learners complete online research to study geography's impact on weather. In this geography and weather lesson, students research weather in their city for ten days using an online website. Learners bookmark the site, enter data into a...
Curated OER
The Hot Dog Stand
Students run a computer simulation. They collect data as they work and use the data to create an annual report for their business. Several different simulations could be used for this project. It is desirable for students to do this...
Curated OER
Investigating Properties of Water: Temperature
Investigate how temperature affects the density of water and stratification that occurs in bodies of water when temperatures vary. Water of differing temperatures is given different colors to see the layers that form. The lesson is meant...
Curated OER
Curious Clouds
Second graders explore clouds. They read The Cloud Book by Tomie dePola. Students sort the cloud pictures into three categories. Students create a graph using the cloud pictures. They use Excel to create a bar graph.
Curated OER
Data Lesson Vital Information
Students prepare and collect data and use excel and create a graph. They collect data about the number of pattern blocks that are put on tables. Students then record that data in Excel.