Survey+Worksheet+and+Excel+Project

Review how to use EXCEL at these places:


 * [|The Basics of Excel]

[|Good step by step instructions on different functions]

[|How to make Graphs in EXCEL] **

Open the Survey Worksheet below to begin your project. Be sure to save your document to your folder on the server.

After you have entered your data on the Survey Worksheet, do the following: 1. Copy/paste all of your sheet on to a NEW DOCUMENT. Label the tab at the bottom of this sheet "Survey Results" 2. Save this document with the name "Survey Results" to your folder on the server. 3. Create a new page for each category of your survey (for example, Wake Up Time, Bedtime, Favorite Color etc.), and label each page accordingly on the tab at the bottom of each page. Also add the name of your page to the header on each page. You will have made 7 new pages. Your spreadsheet will have 8 pages total. 4. On your original page, highlight the data for each category separately and copy/paste it on the corresponding page that you just created. 5. On each page, highlight your data, and click on the Chart Wizard Icon in your toolbar. Follow the instructions until you have a chart that best represents your data. 6. Do this for each page of your spreadsheet. Try different charts to see what you like best. You will be graded on the following rubric:
 * || SUPER JOB! (3) || ADEQUATE, BUT PAY ATTENTION TO DETAILS (2) || INCOMPLETE (1) ||
 * ** Document Sheet ** || Includes all assigned sections.

Thorough and accurate descriptions. || Requirements are not complete. Most of the assigned sections are there, but missing 1 or more requirements. || Many sections are missing. Descriptions are missing or not written thoroughly. || included
 * ** Worksheet Design and Formatting ** || All labels and values are

Appropriate title and subtitle added

All column headings included

Width of columns and rows appropriate

Title merged and centered

Includes shading, bolding and other enhancements

Worksheets are appropriately named.

No spelling errors || Design and formatting is somewhat complete, but hard to read.

Titles are not merged and centered

Bold, shading or other enhancements are not consistent.

Fewer than 2 spelling errors

Worksheets are not named correctly.

Column headings are not consistent. || Missing labels and values

Width of columns and rows inconsistent.

Missing titles

No enhancements such as bold, shading.

2 or more spelling errors

Worksheets are not named.

Column headings are missing. ||
 * ** Formulas and Graphing ** || Formulas are accurate. Graphs and charts are accurate and easy to read. || Most formulas are correct.

Charts are inconsistent in labels, title, legend or sized inaccurately. || More than two formulas are not correct.

Charts are missing labels, title, legend or sized inaccurately. ||

Grading Scale: 8-9=A 7=B 6=C