iRubric: Microsoft Excel Assessment Rubric

edit print share Copy to my rubrics Bookmark test run assess... delete Do more...

Microsoft Excel Assessment Rubric

This assessment evaluates learners’ foundational proficiency in Microsoft Excel, focusing on accurate data entry, formatting, formula application, and basic data analysis through charts, sorting, and filtering. The rubric measures both technical accuracy and the clarity of spreadsheet presentation.

Rubric Code: B25X338

By OBEDMOBISA

Ready to use

Public Rubric

Subject: Computers

Type: Assessment

Grade Levels: Undergraduate

Microsoft Excel Assessment Rubric
	Poor 1 pts	Fair 2 pts	Good 3 pts	Excellent 4 pts
Data entry	Poor Missing or mostly innaccurate	Fair Several entry errors	Good Few errors	Excellent Fully accurate and complete
Cell formatting	Poor Default format & messy layout	Fair Some formatting applied but not uniform	Good Neatly formatted with minor issues	Excellent consistent styling that enhances clarity
Basic formula usage	Poor Formulas incorrect or missing	Fair Formulas attempted but error prone	Good Correct formulas with minor issues	Excellent Advanced formulas used with accuracy
Cell references	Poor No or incorrect use of references	Fair Some correct use but inconsistent	Good Mostly correct use of absolute and relative references	Excellent Clear and accurate use of references
Chart creation	Poor Poorly constructed chart	Fair Chart present but lacks clarity	Good Clear chart with some formatting issues	Excellent Well-labelled, formatted and supports data insight
Sorting and filtering	Poor Not used or misapplied	Fair Attempts sorting or filtering	Good Used correctly with minimal issues	Excellent Effficiently organizes filters and data
Sheet organization	Poor Layout confusing or inconsistent	Fair Basic structure with room for improvement	Good Logical layout and naming	Excellent Organized, clean and well-labelled sheets
Error checking	Poor Uncorrected mistakes	Fair Some errors overlooked	Good Few minor errors	Excellent Thorough checking no visible mistakes
File name and saving	Poor Incorrectly named or lost	Fair File named but not per instruction	Good Named and saved appropriately	Excellent Saved with precise naming and format