Session #4 - Numerical Data Manipulation

In Class Objectives

During this session you will learn how-to do the following:

  1. During this session you will learn the following:

  2. Enter data into a spreadsheet.

  3. Manipulate data in a spreadsheet.

  4. Create charts and tables using the data you have entered.

  5. Format spreadsheets, tables, and charts.

  6. Manipulate your data using formulas.

  7. Link information in Excel worksheets with Microsoft Word documents.

Assignment

For this assignment you will collect data on yourself and 4 friends about the amount of time using a computer. You will enter data into a spreadsheet and compute some statistics. You will also produce summary graphs and write a short paragraph about your results. You will e-mail your MVS Instructor your results.


Data Collection/ Computations/ Questions

Estimate the number of hours per week (7 days) you spend doing the following five activities on the computer.
  • E-mailing
  • Surfing the World Wide Web (WWW)
  • Reading news or sports
  • Shopping
  • Doing Research/Homework

  1. Write down your totals and then email 4 friends and ask for their responses to these questions. (You might want to use other students in your MVS110 class.)

  2. Create an Excel spreadsheet named "MVS110L.OOC4.xls" displaying the results of your data collection on the 5 subjects (you plus 4 others). [Hint: Column 1 would contain subject ID (i.e., 1, 2, 3, etc.); column 2 the email data; column 3 the WWW data; etc.; name this work sheet "WebStats"]

  3. Name cell A7 "Means". Compute the average time for each activity in row 7 (B7:F7).

  4. Name cell 8A "Percent Total Time". In cells 8 B, C, D, E, and F compute the percent of time comprised by each activity.

  5. Name cell 9A "Total Time on Computer, hr". In cell 9B compute the total time spent on the computer.

  6. Name cell 10A “Average Time on Computer, hr”. In cell 10B compute the average time, across all activities spent on the computer.

  7. Create a bar (column) graph displaying the average times for each of the five activities (columns). Save this chart on a separate work sheet called "Bar Graph".

  8. Create a pie chart showing the percentage of time online comprised by each activity. Save this chart on a separate sheet called "Pie Chart".

  9. Create a bivariate scatter diagram showing the relationship between e-mailing versus surfing the WWW. Save this figure on a separate sheet called “Scatter Graph”.

  10. Create a word document ("MVS110L.Assig.4.doc"). Explain your findings by answering the following questions:
    1. Which activity displays the greatest computer time.
    2. What is the average total time spent on the computer.
    3. What is the total time spent on the computer.
    4. What is the relationship between email activity and WWW surfing activity – explain this relationship by referring to the bivariate scatter plot you created (display this plot in your word document.)

Assignment

  • E-mail your MVS 110 Instructor your Excel spreadsheet (with the subject heading "MVS110L.Assig.4") containing 4 worksheets (webstats; bar graph; pie chart; scatter graph) and your MSWord document (MVS110L.Assig.4.doc).

  • In the body of the e-mail in a short paragraph answer the four questions in number 10 above. Also, in a short paragraph explain what you are sending and what you learned from this assignment.

Support

DATA MANIPULATION AND PROCESSING (USING EXCEL) (document)

pcstatscopy.xls (excel spreadsheet)

Grading Guidelines


Send e-mail containing:

  1. Excel spreadsheet containing 4 worksheets (see below)
  2. MSWord document (see below)
  3. In the body of the email there should be an explanation of what you learned in this assignment.

1 point

1 point

1 point

1 point

Excel spreadsheet attachment with 4 worksheets (webstats; bar graph; pie chart; scatter graph)

  1. Webstats: data for 5 subjects by 5 columns with averages, total time, percent time use
  2. Bar graph: bar graph showing 5 bars with labels
  3. Pie chart: pie showing 5 parts with labels
  4. Scatter graph: bivariate scatter of email v WWW with labels

1 point

0.5 pts
0.5 pts

0.5 pts
0.5 pts
MSWord document attachment that contains, in paragraph format, a discussion of 3 questions (activity with the greatest amount of time on the computer; average total time spent on the computer; total time spent on the computer; explain relationship between email activity and WWW surfing (show bivariate graph on page). 3 points

Links