Title: Chapter 5 Excel Project
Course: Special Topics in Computer Programming (TEMPLATE) > Section: Competency Modules

Chapter 5 introduced the concept of a "Requirements Traceability Matrix", which is a technique to break down the elements of a product and identify which test(s) are used to verify the proper performance of the features of the product.  Please watch the short YouTube video on Requirements Traceability Matrix at the following URL: https://www.youtube.com/watch?v=cm-cSW66Isc

Your assignment is to modify the attached Excel file to make it a "Requirements Traceability Matrix" for finding a new job.  The column headings are basically still 100% applicable.  The "Test Case" column should contain some sort of a decision or metric to determine if the potential job satisfies the listed requirement.  The row labels (1.x.y, etc) will be used to specify the various job requirements that you decide to utilize in your analysis.  You will need to determine 1.x (first level) of importance of measurable job requirements, and then under those you will have 1.x.y to describe the elements (y) of measurable requirement (x).  Make sure that your analysis makes sense and shows thoughtful "functional decomposition" of a decision method to select a new job.

Be sure to multiply the score for each item times a weight for each item, then summarize that column to determe a "score" for your job selection.

Take your time, and have some fun with this assignment.  When you are finished submit your completed Excel file via the assignment link.  Your submission will be graded for clarity and organization.

Attached Files: | - AUT Requirements Fig 5-5.xlsx