- Username
- Password
forgot?

iRubric: MS Excel Level 1 rubric

edit print share Copy to my rubrics Bookmark test run assess... delete Do more...
MS Excel Level 1 MS Excel Level 1 Students are asked to recreate an Excel spreadsheet. Project tests students ability to create a spreadsheet, correctly use relative and absolute references, TODAY function, AVERAGE function, SUM, COUNT, and their ability to use colour, borders and shading to make it attractive and easy to read. Rubric Code: P7BB7C By mlgeismar Ready to use Public Rubric Subject: Computers Type: Project Grade Levels: (none)

MS EXCEL PROJECT 1
	Not Quite Yet 0 pts	Basic 2 pts	Competent 3 pts	Exemplary 4 pts	Score (N/A)
ACCURACY	Not Quite Yet Integrity of the data is lost. There are at least 5 errors.	Basic Some data and labels have been entered correctly. There are between 3 and 4 errors.	Competent Most data and labels have been entered correctly. There are no more than 2 errors.	Exemplary All data and labels have been entered correctly. The spreadsheet has perfect integrity. There are 0 errors.	Score
CREATE BAR CHART	Not Quite Yet The BAR CHART function was not created or labeled correctly.	Basic It was not labels but did not contain the right cell information.	Competent BAR CHART was labeled and formatted; however, it was not attractive and did not make the information easy to locate and/or read.	Exemplary BAR CHART was labeled and formatted appropriately making it attractive, easy to locate and read.	Score
HEADER	Not Quite Yet There was no header or the header did not contain all the correct information as per the instructions.	Basic The header contained LITTLE of the correct information as per the instructions.	Competent The header contained MOST of all the correct information as per the instructions.	Exemplary The header contained all the correct information as per the instructions.	Score
APPEARANCE	Not Quite Yet Colour, format and shading have not been used.	Basic Colour, format and shading techniques have been used; hoever, they make the viewing of the spreadsheet challenging and therefore distract from the data.	Competent Colour, format and shading techniques have been used; however, they do not optimize the viewing of the spreadsheet.	Exemplary The use of colour, format and shading enhance the spreadsheet making it easy to read and attractive to the eye.	Score