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 |
Chart 1: Display % of the different grades with a Pie Chart (i.e., % of people who got 甲,乙,丙,丁, etc)
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)
|