Data Formulas Teacher Resources

Investigate the growth rates of alien animals. Pupils study fictional animals from another planet to determine how much they grow per year. The investigators plot the growth of their animals over a period of time and then compare...

Students research Macbeth online and complete computer and graphing activities for the play. For this Macbeth activities lesson, students research Macbeth and bookmark the URL's. Students complete activities for the topic on spreadsheets...

Learners enter data regarding the height of classmates into a spreadsheet. Formulas will also be entered to find the median, mean, and mode of the data.

Sixth graders create and edit spreadsheet documents using all data types, formulas and functions, and chart information. They collect and organize data that be portrayed in a graph that they create using EXCEL.

Fifth graders use data from an Excel document to analyze and predict trends in batting averages.

Students develop a spreadsheet containing formulas and find summaries for them.  In this investigative lesson students choose a topic, investigate it and use MS Excel to sort data. 

Students plan and organize a theme to spend one million dollars. They select a theme, research prices of items on the Internet, organize the information into a spreadsheet, write an introductory paragraph, and create a final project.

Seventh graders discuss water issues and its affect on salmon population. They recreate a sampling river with fish (cheddar) and scoop them to tag them (which means they exchange them for pretzel fish.) They complete a spreadsheet to...

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...

Functions require an input in order to get an output, which explains why the answer always has at least two parts. After only three multi-part questions, the teacher can analyze pupils' strengths and weaknesses when it comes to...

Students create charts and graphs using a spreadsheet. They chart the number of each gift given day by day from the song, "The Twelve Days of Christmas." They create a bar graph and a circle graph from their data on the spreadsheet.

Students master the gathering, averaging and graphing of data. They practice conversion to metric measures. They gain fluency in the use of technology tools for math operations.

Students examine different types of spears that have been discovered from various civilizations. In groups, they calculate the answers to various word problems and enter their information on a spreadsheet. They use the data in other...

Students create a spreadsheet that they will use to plan a small party or outing. They calculate expenses and stay within a budget amount for their party.

Students gather data about the weather in Nome, Alaska. In this Nome Temperature lesson, students create an excel graph to explore the weather trends in Nome.  Students will find the average weather and add a trend line to their graph.

Eighth graders prepare for a field trip to Washington, DC by researching landmark, monument, or building in Washington. They use the information in small groups to design a multimedia presentation. They include a spreadsheet that shows...

Learn how to calculate the length and midsegments of triangles. Students differentiate between similar and congruent triangles. They create a spreadsheet with their findings.

How do you create a residual plot? Work as a class and in small groups through the activity in order to learn how to build a residual plot. The activity builds upon previous learning on calculating residuals and serves as a...

When told to describe a line, do your pupils list its color, length, and which side is high or low? Use a learning exercise that engages scholars to properly label line graphs. It then requests two applied reasoning answers.

The class braids irrational numbers, Pythagoras, and perimeter together. The mini-assessment requires scholars to use irrational numbers and the Pythagorean Theorem to find perimeters of rugs. The rugs are rectangular, triangular,...

Simulate C-14 decay using M&M and Reese's Pieces candies. In this scatter-plot lesson, young scholars perform an experiment to simulate the half life of C-14. Information is plotted on a scatter-plot. Students answer four...

Students track and record how much time they spend on each activity. In this spreadsheet lesson, students apply different functions using Microsoft excel to format cells and calculate the sum of their total time spent each day. They...

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...

Fifth graders collect temperature readings over a period of time, enter the information into a spreadsheet and choose the appropriate graph to display the results.