Create an Evaluation Matrix Chart in MS Excel comparing 3 technology careers for
each criterion.


What should be in the matrix:
 Three technology careers from Chapter 8. (i.e. system analysis, software engineer, help
desk technician) to evaluate.
 Three criteria (all students must use these criteria).  
A.
o Salary – Look up the criteria for each of your careers/professions on the Bureau of
Labor and Statistics Occupational Outlook Handbook at https://www.bls.gov/ooh/ and
ONet  https://www.onetonline.org/.  You may use other sources of information.    B. o Job Responsibilities Look up the criteria for each of your careers/professions on the Bureau of Labor and Statistics Occupational Outlook Handbook at https://www.bls.gov/ooh/ and ONet  https://www.onetonline.org/.  You may use other
sources of information.  

o Career Outlook (what percentage of jobs will be available in the future) – Look up the
criteria for each of your careers/professions on the Bureau of Labor and Statistics
Occupational Outlook Handbook at https://www.bls.gov/ooh/ and
O*Net  https://www.onetonline.org/.  You may use other sources of information. 
 Formulas in each cell – Use the videos in the Video Resource folder to learn how to
create a excel worksheet, formulas, and chart in addition to Evaluation Matrix Example
Criteria file in the section below.
 
Submitting the Assignment:
Create 2 Excel worksheets.   

  1. The first is your Excel matrix chart with formulas to calculate weighted scores and
    totals using a mixed cell reference. You will see which career scored best with the raw
    scores and which career scored best with the weighted scores. Divide 100 points
    among the criteria with the highest number of points going to the criteria most important
    to you.
  2. The second is a chart of your results from the matrix.  The chart may be the style of
    your choice. It must give good information about the data in your worksheet with your
    matrix. Name each worksheet in the workbook appropriately. Submit your file with both
    worksheets into the Blackboard assignment.
      
    An example of the matrix is in this section labeled Evaluation Matrix Tutorial as an
    attachment.  Watch videos in the video reference folder for guidance below.  Additional
    Resources available under GCFLearnFree.org section.
    Do not forget to record your sources/references in APA format.  
  3. Your graded on having all of the required information:
  4.  Three technology careers 
  5.  Three criteria   
  6. A.
  7. o Salary – Look up the criteria for each of your careers/professions on the Bureau of
  8. Labor and Statistics Occupational Outlook Handbook at https://www.bls.gov/ooh/ and
  9. ONet  https://www.onetonline.org/.  You may use other sources of information.    B. o Job Responsibilities Look up the criteria for each of your careers/professions on the Bureau of Labor and Statistics Occupational Outlook Handbook at https://www.bls.gov/ooh/ and ONet  https://www.onetonline.org/.  You may use other
  10. sources of information.  
  11. o Career Outlook (what percentage of jobs will be available in the future) – Look up the
  12. criteria for each of your careers/professions on the Bureau of Labor and Statistics
  13. Occupational Outlook Handbook at https://www.bls.gov/ooh/ and
  14. O*Net  https://www.onetonline.org/.  You may use other sources of information. 
  15.  Formulas in each cell
You can also get the answer to this paper securely, anonymously. The paper shall be original with an accompanying originality report.