Lesson Plans and Worksheets
Browse by Subject
- Data Formulas
-
Related Topics
Featured Testimonial
I'm a Special Education teacher that collaborates with science most of the day. I've found lots of hands on and wonderful ideas for teaching science that I can use incorporating all of our students. There are so many that I was able to use all year long last year and still finding more this year. Love this site...
- Diane W., Teacher
- Lexington, KY
- 09-16-10

Data Formulas Teacher Resources
Find teacher approved Data Formulas educational resource ideas and activities
Title
Resource Type
Views
Grade
Rating
This thirteen page data analysis worksheet contains a number of interesting problems regarding statistics. The activities cover the concepts of average measurements, standard deviation, box and whisker plots, quartiles, frequency distributions, and lines of best fit.
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 enter data and formulas into spreadsheet software in order to calculate the area of a rectangle, and copy and paste the formula to other cells in the spreadsheet software in order to calculate the area of other rectangles.
Learners examine data analysis. They conduct a randomized sample, input data into a spreadsheet, create histograms, boxplots, scatter plots, number summaries, and line graphs, and compute the standard deviation using a calculator and computer.
Explore metric measurement, recording data, and creating an electronic spreadsheet displaying results with your math class. Scholars will measure the length of their smiles, record the measurements, and represent the results on an electronic spreadsheet. They finish by writing an account of the activity including digital pictures.
Learners investigate elapsed time. They construct an obstacle course and take turns racing robots through the course. In addition, they track data and hypothesize about improving the race time. Once the analysis of the data is complete, they present their findings to the class.
Using a 2002 California Gray David recall vote as an example, young statisticians identify sources of bias in samples and find ways of reducing and eliminating sampling bias. They consider ways to select random samples from a population, and also look at different ways to represent data.
Students download information from a NASA website into a database. They transfer it to a spreadsheet by completing the information and analyze the information. They determine temperature averages, mode, and graph the results. They write a summary for the graphed information.
Young data gathers analyze real-world data by applying appropriate formulas for measures of central tendency and organizing data in a quality display, using appropriate technology.
Second graders solve a story problem using a spreadsheet after voting.