Grades Tracking Worksheet

BUS 221 CAI1:  Grades Tracking Worksheet – Design Document

The purpose of this assignment is to document the requirements and design considerations for a Grades Tracking Worksheet to be created and maintained in MS Excel 2016.  Your document should be completed in MS Word, be no more than 3 pages, and consider at least the following areas:

1. OVERVIEW:  What will this worksheet allow you to do?  How do you envision using this tool and what would you like to get out of designing, maintaining and revising this worksheet during the semester?  NOTE:  This type of information can also be contained within your Grades Tracking Worksheet as a separate tab (i.e., worksheet) called “About”

1. STRUCTURE:  What is the layout of the worksheet?  How many tabs (i.e., worksheets) will there be?  If more than one, what are the labels?  Will it contain data tables, graphs or other items?

1. SCALABILITY:  Does the worksheet need to be scalable (i.e., able to grow; useful beyond just the first version)?  If yes, how will that be addressed in your design?

1. DESIGN and CONTENT:
   
   
   1. INPUT:  What data / information will be included?  What is the source of that data?  How will the data be input into the worksheet?
   
   
   2. OUTPUT:  Will you print, use online only, need to share with others?
   
   
   3. FUNCTIONALITY:  What functions and formulas will the worksheet require?  What functionality would you like but don’t know if it exists in MS Excel?
   
   

1. TESTING:  How will you test the functions, formulas, etc. to validate that the data and results are correct?

1. AUTOMATION:  What calculations can be automated and which ones will require editing?

1. FORMATTING:  What MS Excel formatting options will you use to help analyze and highlight data?

1. SECURITY:  How will you protect this file from misuse or lost information?

Grading Rubric: