Skip to main content
iRubric: Microsoft Office Assessment rubric

iRubric: Microsoft Office Assessment rubric

find rubric

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

Powered by iRubric 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



Discuss this rubric




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

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 iRubrictm.


Copyright © 2024 Reazon Systems, Inc.  All rights reserved.
n60