Excel Criteria and Grading Rubric

Only those Excel products that are related to classroom instruction, professional development, or job requirements will be acceptable for Academy purposes.

 

Data Entry

o Title and Project purpose identifiable

o Complete and accurate

o Heading and labels clearly identified

Chart

o Title identifies what the chart displays

o Labels are appropriate

o Chart type appropriate for displayed data

Formula and data manipulation

o Appropriate use of formulas

Formatting: Include at least 3 of any of the following:

o Word Art

o Autoshape

o Colored text or cells

o Clip art

o Graphics inserted into the chart

o Hyperlink

o Other

Printed product

o Page setup appropriate to the size and layout of the data (Print preview)

o Data manipulated by resizing to make the “best fit”

Component/Criteria

2 points 3 points
Data entry Missing one component All components included
Chart Missing one component All components included
Formula and data manipulation 1 formula 2 or more formulas
Formatting Includes less than 3 Includes at least 3
Printed Product Missing one component All components included

Excel Component

Number of Points Earned Comments
Data entry    
Chart    
Formula and data manipulation    
Formatting    
Printed Product    
Total (15 possible points)