You can find the responses to the questionnaire in an Excel workbook called Project3Data.xls This starting file can be found in my /home/samba/fac-staff/mleblanc/universal/public/ folder, which is available via the tempest/phoenix server. You should copy this file to your area and rename it to Project3YOURNAME.xls

This workbook already has four worksheets contained in it: Introduction, Analysis, Raw Data, and Workspace.

• The Introduction worksheet explains the questionnaire and the format of the data (read this carefully!)
• The Analysis worksheet will hold the tables, charts and graphs that you will generate
• The Raw Data worksheet holds the results of the questionnaire
• The Workspace worksheet will hold any copies of the different sorts of the data that you need to create in order to do the analysis.

On your Analysis Worksheet, you should create a table like the one below and enter formulas in the appropriate cells to complete the table.

After you have the calculated the values, compare the average of each category to the number of students who ranked the category first. You should notice something interesting.

In addition to building a table and pie chart for the entire sample, you should also build similar (additional!) tables and pie charts which show how various groups ranked each category first:

1. What are the percentages of each category ranked first for BOYS vs. GIRLS (use a bar graph for this case).
1. What are the percentages of each category ranked first for Rural Girls vs. Urban Girls
1. What are the percentages of each category ranked first for those whose goal is to Make Good Grades vs. those whose goal is to Be Popular vs. those whose goal is to Be Good in Sports

NOTE: You will need to sort the data according to the various criteria. Be very careful to copy the data to the Workspace worksheet and sort different copies of the data. Otherwise, your previous tables may be incorrect. For example, if you have sorted the data by Gender to create the tables for Boys and Girls, and then you INCORRECTLY sort the same copy of the data for the Urban and Rural tables, then your Boys and Girls tables will no longer be accurate. This can really make you sad.

In your Project folder of the WWW folder on the www3(tempest/phoenix) web server, you should create a file called project3.html that contains your analysis of the data. You should link to this page from your homepage.

In addition, on your project3.html, you should explain the questionnaire and explain any discrepancies in the data or why the data is as you expected. For example, you should compare the responses of boys and girls and point out any surprising results or explain why the results are just what you expected. You should also look for similarities among the groups and try to explain why you think they may exist (e.g. look at the groups that ranked Money and Grades roughly equal. How could you predict that from these groups?)

Keep in mind that people who view your web page may know nothing about this assignment, so you will want to be sure that your page is completely self-contained and can stand on its own without your spreadsheet.

In addition to your explanations, this HTML page should contain all eight of your tables and the corresponding pie/bar charts.

You should put a copy of your Excel workbook in my drop box in the Excel Project Goes Here folder found at:

AppleShare - ACC/ResNet Services - AC Server - Guest - Course Materials — Computer Science - LeBlanc — Universal Machine

Name your file Project3YourLastName.xls (please! Include your last name in your excel filename).