Lab+Day+to+work+on+Graphing+Project

The following is your lab assignment for Friday, November 19th:

Using your data collection sheet do the following:

Go to the following website: Pie Charts: [] Look at one day of data and divide what you did into categories. For example: sleep, school. homework, excericse, eating, watching tv. Then type in each category and enter in how many hours you did each activity. You can enter in 1/2 hours just enter .5. Once you have completed the pie chart, have me look at it and pass it off.

Next go to: Bar Chart: [] Once there change the labels to the days of the week. You will be recording how many hours of sleep you had each night for 7 nights. Next change the number of rows to match the longest night's sleep. Then create the bars for each day. Finally, have me pass it off when you are finished.

Excel Assignment: Open up the following document:

1. You will first need to enter in the amount of sleep you had for 7 nights.

2. The worksheet should compute for you the following, just make sure that they are correct: Mean: the average Median: the middle value when arranged in order from low to high. Mode: the value that appears the most.

3. Finally you will need to create 3 different charts with the data. Simply highlight or select the data that you have entered in on hours of sleep and then click on the INSERT tab, then click on the type on the following charts: Column Chart Scatter Chart Area Chart

You are welcome to experiment with the other charts available as well.

If you finish all of the above then you may go to the following website and choose to work on any activity in the 6-8 or 9-12 grade range: []