Skip to main content

iRubric: Microsoft Office Assessment rubric

edit print share Copy to my rubrics Bookmark test run assess... delete Do more...
Microsoft Office Assessment Microsoft Office Assessment Measurement of the completion of software applications assignments using Word, Excel, and Access. Rubric Code: K24B565 By garypool Ready to use Public Rubric Subject: Business Type: (Other) Grade Levels: (none)

Software Assignments 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
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
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.
Access Section
Access Activity 1 10 pts Included required elements as defined in the columns and PC Applications Project Worksheet.	Poor Created a database without completing at least 70% of the following: converting to Access 2003, appropriate file and folder organization, Appropriate creation of relationships, appropriate relationship options, appropriate indexing used, new table created, appropriate fields added to new table, appropriate records added to table, appropriate column and cell formatting.	Fair Created a database completing at least 70% of the following: converting to Access 2003, appropriate file and folder organization, Appropriate creation of relationships, appropriate relationship options, appropriate indexing used, new table created, appropriate fields added to new table, appropriate records added to table, appropriate column and cell formatting.	Good Created a database completing at least 80% of the following: converting to Access 2003, appropriate file and folder organization, Appropriate creation of relationships, appropriate relationship options, appropriate indexing used, new table created, appropriate fields added to new table, appropriate records added to table, appropriate column and cell formatting.	Excellent Created a database completing at least 95% of the following: converting to Access 2003, appropriate file and folder organization, Appropriate creation of relationships, appropriate relationship options, appropriate indexing used, new table created, appropriate fields added to new table, appropriate records added to table, appropriate column and cell formatting.
Access Activity 2 10 pts Included required elements as defined in the columns and PC Applications Project Worksheet.	Poor Created a database without completing at least 70% of the following: appropriate deletion of duplicated fields, appropriate explanations, Appropriate use of Table Analyzer, appropriate table splitting, appropriate table naming, appropriate primary key selection, appropriate relationships.	Fair Created a database completing at least 70% of the following: appropriate deletion of duplicated fields, appropriate explanations, Appropriate use of Table Analyzer, appropriate table splitting, appropriate table naming, appropriate primary key selection, appropriate relationships.	Good Created a database completing at least 70% of the following: appropriate deletion of duplicated fields, appropriate explanations, Appropriate use of Table Analyzer, appropriate table splitting, appropriate table naming, appropriate primary key selection, appropriate relationships.	Excellent Created a database completing at least 70% of the following: appropriate deletion of duplicated fields, appropriate explanations, Appropriate use of Table Analyzer, appropriate table splitting, appropriate table naming, appropriate primary key selection, appropriate relationships.
Access Activity 3 10 pts Included required elements as defined in the columns and PC Applications Project Worksheet.	Poor Created a database without completing at least 70% of the following: Accurate creation of Excel linked table, creation of query, creation of data access page, Appropriate formatting, creation of web page, creation of PivotTable, creation of data access page with Pivot table, appropriate formatting of second web page, creation of 2nd web page, XML file creation.	Fair Created a database completing at least 70% of the following: Accurate creation of Excel linked table, creation of query, creation of data access page, Appropriate formatting, creation of web page, creation of PivotTable, creation of data access page with Pivot table, appropriate formatting of second web page, creation of 2nd web page, XML file creation.	Good Created a database completing at least 80% of the following: Accurate creation of Excel linked table, creation of query, creation of data access page, Appropriate formatting, creation of web page, creation of PivotTable, creation of data access page with Pivot table, appropriate formatting of second web page, creation of 2nd web page, XML file creation.	Excellent Created a database completing at least 95% of the following: Accurate creation of Excel linked table, creation of query, creation of data access page, Appropriate formatting, creation of web page, creation of PivotTable, creation of data access page with Pivot table, appropriate formatting of second web page, creation of 2nd web page, XML file creation.
Access Activity 4 10 pts Included required elements as defined in the columns and PC Applications Project Worksheet.	Poor Created a database without completing at least 70% of the following: Accurate password creation, 4 macros created, Custom form created, Appropriate formatting and element use in form, assigning a startup form	Fair Created a database completing at least 70% of the following: Accurate password creation, 4 macros created, Custom form created, Appropriate formatting and element use in form, assigning a startup form	Good Created a database completing at least 80% of the following: Accurate password creation, 4 macros created, Custom form created, Appropriate formatting and element use in form, assigning a startup form	Excellent Created a database completing at least 95% of the following: Accurate password creation, 4 macros created, Custom form created, Appropriate formatting and element use in form, assigning a startup form

Keywords:

Word, Excel, and Access

Subjects:

Types:

Discuss this rubric

You may also be interested in:

More rubrics by this author

More Business rubrics

More Assignment rubrics

Do more with this rubric:

Preview

Preview

Preview this rubric.

Edit

Edit

Modify this rubric.

Copy

Copy

Make a copy of this rubric and begin editing the copy.

Print

Print

Show a printable version of this rubric.

Categorize

Categorize

Add this rubric to multiple categories.

Bookmark

Bookmark

Bookmark this rubric for future reference.

Assess

Test run

Test run

Test this rubric or perform an ad-hoc assessment.

Grade

Grade

Build a gradebook to assess students.

Collaborate

Apply this rubric to any object and invite others to assess.

Share

Publish

Publish

Link, embed, and showcase your rubrics on your website.

Email

Email

Email this rubric to a friend.

Discuss

Discuss

Discuss this rubric with other members.

Do more with rubrics than ever imagined possible.

Only with iRubric^tm.

n67