Links for K-12 Teachers | Assessment Assistance | On-Line Practice Modules | Daily Dose of the Web

Using Microsoft Excel to Analyze Classroom Data

Page copy protected against web site content infringement by Copyscape. Do not copy content from the page. Plagiarism will be detected by Copyscape.

Before you can accomplish this task, you must be familiar with entering and editing data into a Microsoft Excel Workbook. You must also be able to format data in a cell and use Excel to produce a chart or graph.

I need help entering data in an Excel worksheet.

I need help editing and formatting data in an Excel worksheet.

I need help making a chart in an Excel worksheet.

If you do not need assistance with either of those skills, you are ready to get on with your task.

Your task will be to use Microsoft Excel to produce three documents:
Documents
Example
1

One worksheet showing the results of a simple survey, accompanied by a simple chart
  • Survey classmates on some favorite: candy, cola, TV show or ice cream.
2

One worksheet analyzing data from a science experiment
  • Calculate resting heart rate and determine the effect of exercise
3

One or more worksheets accompanied by at least one graph analyzing a set of data, and supporting a prediction.

  • Analyze the distribution of colors in a bag of M&M's and predict colors in an unopened bag

Use the following modules to assist you in creating the three documents outlined in the Task statement.


 Enter text in the search box
Search the Internet4Classrooms site


Visitors since November 2000
Click for Memphis, Tennessee Forecast
Memphis, TN
Internet4Classrooms is a collaborative effort by Susan Brooks and Bill Byles