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
A Birthday Basket for Tia
Students practice reading and math skills using technology. In this main idea lesson, students retell the important events of A Birthday for Tia in sequence using Kid Pix. Students create a bar graph using The Graph Club...
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
Weather Watchers
Students practice using objective and quantitative means to describe and compare the weather. They compile weather conditions and create a spreadsheet to record their findings.
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.
Alabama Learning Exchange
Find a Pattern Using Children's Literature
Sixth graders listen to Demi's, On Grain of Rice: A Mathematical Folktale. They use the problem solving strategy of finding a pattern to determine the number of rice Rani will receive after 30 days. They create a spreadsheet which...
Curated OER
Snow Cover By Latitude
Students create graphs comparing the amount of snow cover along selected latitudes using data sets from a NASA website. They create a spreadsheet and a bar graph on the computer, and analyze the data.
Curated OER
The Dangers of Being Obese/Overweight
Third graders determine if they are eating healthy. In this healthy living lesson, 3rd graders watch a video titled Happy Health and review the food pyramid. Students create a spreadsheet where they list their food intake for the week...
Curated OER
Graphing Favorite Colors
Third graders collect data and insert it into ClarisWorks to create a spreadsheet/graph of their favorite color. They interpret the data together.
Curated OER
Historical Population Changes in the US
Students conduct research on historical population changes in the U.S. They conduct Internet research on the Historical Census Data Browser, create a bar graph and data table using a spreadsheet program, and display and interpret their...
Curated OER
All The Bell & Whistles
Young adults are so eager to get that first cell phone. And, cell phones have so many cool extras! Learners conduct real-life research to determine which cell phone carrier offers the best deals on things like wall paper, ringtones, and...
Curated OER
Forces of Flight - Lift
Students design and test paper airplanes to understand the concept of lift and how it affects flight. This technology-based Science lesson plan is excellent for use with upper-elementary and middle-level learners and uses spreadsheet...
Curated OER
How Credit Card Interest Works
Students experiment with an Excel spreadsheet model that demonstrates the effects of interest on payments. They calculate actual costs, interest paid, and time necessary to pay off credit purchases and draw conclusions about the...
Curated OER
How Tolerant Are Kids in Your School?
Students graph results of a survey about attitudes and tolerance in their school. They discuss the social climate of their school. Students complete a questionnaire, and tabulate the raw data from their class. They create a bar graph...
Curated OER
Counting Coins
Second graders identify a quarter, dime, penny, nickel, and dime. They match the coin with it's monetary value, collect data on excel spreadsheet, and create a graph in Excel. Students participate in group activities.
Curated OER
What Goes Up Must Come Down!!
Fifth graders look at actual sunrise and sunset times for their hometown to determine a pattern in the amount of daylight. They collect their data in Excel and create a chart to help them identify the pattern, then write an explanation...
Curated OER
"Living in the Limelight The Universal Dream"
Students, using Leo's Lyrics, investigate common themes in popular music. They create a Microsoft Excel spreadsheet that analyzes their findings along with a 200 word paragraph stating their observations, conclusions and hypotheses about...
Curated OER
Thinking Outside the Box
Now this lesson sounds fun! Young scholars throw a ball, film it as it soars through the air, and use a spreadsheet to collect data. A scatterplot is created to produce a quadratic regression equation, an equation in vertex form, and an...
Howard Hughes Medical Institute
Lesson 8: WildCam Gorongosa Data Analysis
How do scientists analyze data to get a specific answer to a question? The final chapter in an eight-part series of activities centered around Gorongosa National Park encourages scholars to dig deeper into the scientific process. After...
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...
Curated OER
Does Humidity Affect Cloud Formation?
Students use S'COOL data to identify factors that affect cloud formation. They find a data set using the S'COOL database , and use Excel to manipulate the data. Student isolate relevant data, create meaningful graphs from a spreadsheet,...
Curated OER
A Comparison Study of Water Vapor Data to Precipitation over North America
Students use NASA satellite data to compare water vapor over the United States. In this data analysis instructional activity students use an Excel spreadsheet to map their data.