iRubric: Microsoft Office Assessment rubric

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

Microsoft Office Assessment

Measurement of the completion of software applications assignments using Word and Excel.

Rubric Code: P59CW2

By rexann

Draft

Public Rubric

Subject: Computers

Type: Assessment

Grade Levels: Undergraduate

Software Assignments 100 % Definition of assessing student work on software applications
	Poor Failed to adequately complete the assignment. 1 pts	Fair Completed the assignment with 70% ... 2 pts	Good Completed the assignment at 80% or better. 3 pts	Excellent Completed the assignment at 95% or better. 4 pts
Word Section 50 %
Word Activity 1 10 pts Included required elements as defined in the columns and PC Applications Project Worksheet.	Poor Created the memo without features such as: Set tabs, balanced columns, Accurate spelling, Appropriate file name, appropriate memo format	Fair Created the memo with 70% of features such as: Set tabs, balanced columns, Accurate spelling, Appropriate file name, appropriate memo format	Good Created the memo with 80% of features such as: Set tabs, balanced columns, Accurate spelling, Appropriate file name, appropriate memo format	Excellent Complete the memo with 95%of features such as: Set tabs, balanced columns, Accurate spelling, Appropriate file name, appropriate memo format
Word Activity 2 10 pts Included required elements as defined in the columns and PC Applications Project Worksheet.	Poor Created the table without completing at least 70% of the following: Appropriate table format,Accurate spelling, Appropriate file name, Appropriate cell formatting	Fair Created the table with completing 70% to 80% of the following: Appropriate table format,Accurate spelling, Appropriate file name, Appropriate cell formatting	Good Created the table with completing over 80% of the following: Appropriate table format,Accurate spelling, Appropriate file name, Appropriate cell formatting	Excellent Created the table with completing 95% of the following: Appropriate table format,Accurate spelling, Appropriate file name, Appropriate cell formatting
Word Activity 3 10 pts Included required elements as defined in the columns and PC Applications Project Worksheet.	Poor Created the chart without completing at least 70% of the following: Appropriate chart format,Accurate legend, Appropriate file name, Appropriate labeling	Fair Created the chart completing at least 70% of the following: Appropriate chart format,Accurate legend, Appropriate file name, Appropriate labeling	Good Created the chart completing at least 80% of the following: Appropriate chart format,Accurate legend, Appropriate file name, Appropriate labeling	Excellent Created the chart completing at least 95% of the following: Appropriate chart format,Accurate legend, Appropriate file name, Appropriate labeling
Word Activity 4 10 pts Included required elements as defined in the columns and PC Applications Project Worksheet.	Poor Created the form without completing at least 70% of the following: Appropriate layout,Accurate spelling, Appropriate file name, Appropriate form fields, Useability	Fair Created the form completing at least 70% of the following: Appropriate layout,Accurate spelling, Appropriate file name, Appropriate form fields, Useability	Good Created the form completing at least 80% of the following: Appropriate layout,Accurate spelling, Appropriate file name, Appropriate form fields, Useability	Excellent Created the form completing at least 95% of the following: Appropriate layout,Accurate spelling, Appropriate file name, Appropriate form fields, Usability
Excel Section 50 %
Excel Acitivity 1 10 pts Included required elements as defined in the columns and PC Applications Project Worksheet.	Poor Failed to create an Excel spreadsheet with at least 70% of the following: PivotTable with sums of salaries by department and by hire date, Appropriate formatting, Accurate web page, Pivot Chart report, Appropriate file names, Appropriate header, Appropriate footer, Appropriate tab naming.	Fair Create an Excel spreadsheet with at least 70% of the following: PivotTable with sums of salaries by department and by hire date, Appropriate formatting, Accurate web page, Pivot Chart report, Appropriate file names, Appropriate header, Appropriate footer, Appropriate tab naming.	Good Create an Excel spreadsheet with at least 80% of the following: PivotTable with sums of salaries by department and by hire date, Appropriate formatting, Accurate web page, Pivot Chart report, Appropriate file names, Appropriate header, Appropriate footer, Appropriate tab naming.	Excellent Create an Excel spreadsheet with at least 95% of the following: PivotTable with sums of salaries by department and by hire date, Appropriate formatting, Accurate web page, Pivot Chart report, Appropriate file names, Appropriate header, Appropriate footer, Appropriate tab naming.
Excel Activity 2 10 pts Included required elements as defined in the columns and PC Applications Project Worksheet.	Poor Failed to create an Excel spreadsheet with at least 70% of the following: Total Salaries function, SumIF function, Appropriate labels, Projected Salary Costs formula, Sum function, Accurate use of Goal Seek, Insertion of Note, Evidence of 3 Scenarios, Appropriate Formatting, Use of custom header and footer.	Fair Create an Excel spreadsheet with at least 70% of the following: Total Salaries function, SumIF function, Appropriate labels, Projected Salary Costs formula, Sum function, Accurate use of Goal Seek, Insertion of Note, Evidence of 3 Scenarios, Appropriate Formatting, Use of custom header and footer.	Good Create an Excel spreadsheet with at least 80% of the following: Total Salaries function, SumIF function, Appropriate labels, Projected Salary Costs formula, Sum function, Accurate use of Goal Seek, Insertion of Note, Evidence of 3 Scenarios, Appropriate Formatting, Use of custom header and footer.	Excellent Create an Excel spreadsheet with at least 95% of the following: Total Salaries function, SumIF function, Appropriate labels, Projected Salary Costs formula, Sum function, Accurate use of Goal Seek, Insertion of Note, Evidence of 3 Scenarios, Appropriate Formatting, Use of custom header and footer.
Excel Activity 3 10 pts Included required elements as defined in the columns and PC Applications Project Worksheet.	Poor Failed to create an Excel spreadsheet with at least 70% of the following: Macro for sorting by department, Macro for softing by year of hire, Macro for sorting by employee number, Appropriate macro names, Appropriate buttons and labels.	Fair Create an Excel spreadsheet with at least 70% of the following: Macro for sorting by department, Macro for softing by year of hire, Macro for sorting by employee number, Appropriate macro names, Appropriate buttons and labels.	Good Create an Excel spreadsheet with at least 80% of the following: Macro for sorting by department, Macro for softing by year of hire, Macro for sorting by employee number, Appropriate macro names, Appropriate buttons and labels.	Excellent Create an Excel spreadsheet with at least 95% of the following: Macro for sorting by department, Macro for softing by year of hire, Macro for sorting by employee number, Appropriate macro names, Appropriate buttons and labels.

Keywords:

Word, Excell

Subjects:

Types:

Discuss this rubric