Data Formulas Teacher Resources

Find Data Formulas educational ideas and activities

Showing 1 - 20 of 560 resources
Students practice using a spreadsheet as a graphing and statistical tool. They review concepts of mean, median and range. They create their own rows and columns and enter formulas.
Students examine the functions and uses of spreadsheets. They view and discuss a PowerPoint presentation, produce a spreadsheet that computes basic math functions, and graph their spreadsheet data.
Students are introduced to spreadsheets and assess how to enter numbers, labels and simple data into a spreadsheet and how to use the data to calculate totals. They are also introduced to spreadsheet software that enables them to explore mathematical and scientific models.
Students utilize a spreadsheet to explore a mathematical model and to formulate answers to 'what if..?' questions. They assess how changes in a spreadsheet affects the results and identity of simple rules within math and statistics.
Collect and graph data using Microsoft Excel with your math class. They will make predictions about the number of each colored candy in a bag of M&M's, then sort, classify, count, and record the actual data before using Excel to create a graph of the data.
Learners graph and analyze data using a spreadsheet.
Middle schoolers use the Internet for gathering information for Iditarod race journals. They use a spreadsheet program for entering data and making charts for showing changes in speeds achieved over a period of four weeks in timed writings in keyboarding.
Students, while in the computer lab, practice using formulas, print options, functions and adjusting column widths while interacting with a spreadsheet program. They modify and use spreadsheets, after being given a scenario, to solve problems as well.
Students investigate which brand of chocolate chip cookies contains the most chocolate. They analyze and compare data using Microsoft Word and Microsoft Excel. They communicate the results with Microsoft PowerPoint.
Students solve problems using fractions and percents. In this algebra instructional activity, students create a spreadsheet using formulas to solve decimals, fractions and percents. They graph their results and make predictions.
Second graders solve a story problem using a spreadsheet after voting.
Third graders explore the basic content of a spreadsheet.  In this spreadsheet lesson, 3rd graders complete a presentation on the information in a spreadsheet and answer questions about that content.
Students collect data on investments and draw conclusions. In this algebra lesson, students analyze exponential graphs as they relate to money. They discuss the cause of an account balance being high or low.
Students participate in a technology project. This lesson is a hands-on spreadsheet project where students are responsible for keeping track of their grades for class. The students learn to enter data into a spreadsheet, create formulas to calculate the values, and constantly save and retrieve the information.
Do your learners like dinosaurs and theme parks? An ambitious lesson invites learners to put together a plan for supplying dinosaurs for a new theme park. Pupils work together in groups to come up with their plan, which must include a spreadsheet that has information on cost, size, and weight of the dinosaurs. They must also produce a document which describes their plan.
Fourth graders predict colors of M&Ms and collect data after opening the bag. They graph their data on a grid and draw conclusions about the color distribution and numbers of candies in bags. Theycreate a spreadsheet on the computer and enter their data.
Students enter data from the Olympic games into a spreadsheet.  In this data analysis lesson, students work on making an accurate spreadsheet with the correct information by entering their information into a spreadsheet from a provided website. 
Fourth graders use a teacher made spreadsheet to explore how calculations work. Then student teams work together to create their own store order form on a spreadsheet. They play a simulated game show where students shop at each others stores.
Students create graphs in Excel.  In this spreadsheet instructional activity, students input data into spreadsheet cells then use the graphing feature of the Excel program to produce colorful graphs of the data.  The directions to create the graph are listed in a step-by-step format.

Browse by Subject


Data Formulas