Excel Assignment
General Instructions:
• Deadline: Section A: May 19, Section B and C: May 29, 2009
• Email your file OR use GSpace to upload your file to our class Gmail account
– please name them as "section_number_name_type" with underlines between each word.
– You can produce the document using Excel 2003 or 2007, but please save it as “.xls”
• Give me printouts (leave them in my mailbox) if you want feedback in writing.
• Points will be taken off for late assignments!
Guidelines for Excel Assignment
| Elements | Weights |
| Contents Complete | 60% |
| list 10 name, 5 criteria min. score | 10 |
| percentage for each criterion | 5 |
| 函數 functions (sum [for the total scores], average [of each subject]) | 10 |
| average score (using formula) of each student | 10 |
| grade conversion to letters (use a formula) | 15 |
| rank by sorting (need to apply a formula, not manually) | 10 |
| Format | 10% |
| title (centered) | 5 |
| borderline | 5 |
| Graphs | 30% |
| pie chart | 15 |
| bar graph | 15 |
Instruction for drawing the graphs:
|
Pie Chart: Display % of the different grades with a Pie Chart (i.e., % of people who got 甲,乙,丙,丁, etc.)
Bar Graph: compare grades of 3-5 students with a bar graph
nnKey in their grades for 3-5 subjects n (e.g., Compare the grades of Chinese, English, Math, Art, Geography subjects of Student A, B, and C) |