Create an Evaluation Matrix Chart in Excel

Reference no: EM132851587

Evaluation Matrix and Chart

Instructions for Assignment

Create an Evaluation Matrix Chart in Excel that will let you compare the 3 careers/positions at technology companies' side by side on each criterion.

What should be in the matrix are the 3 technology careers/positions (i.e., system analysis, software engineer, help desk technician) to evaluate, the 5 criteria to be used, and how you personally weigh each criterion. Divide 100 points among the criteria, with the highest number of points going to the criteria that is most important to you.

An example of the matrix is in this section as an attachment. Watch videos below for guidance. Additional Resources available under GCFLearnFree.org section.

All Students must use these criteria in your chart. See Below.
2. Salary
3. Education/Certification
4. Career Outlook (what percentage of jobs will be available in the future)
5. Duties
6. Work Schedule

Based on your research, rate each career on each criterion (on a scale of 1 to 100). Again, refer to the presentation about creating an evaluation matrix if needed. After you have rated your careers, create Excel formulas to calculate weighted scores using a mixed cell reference. This will enable you to see which career scored best with the raw scores and then which career scored best with the weighted scores.

Create a Chart

Create an Excel chart worksheet. The chart may be the style of your choice. It must give good information about the data in your worksheet. Name each worksheet in the workbook appropriately. Submit your file with both worksheets into the Blackboard assignment for this phase.

Learn how an evaluation matrix is constructed. One of the most important parts is developing criteria that will be used in your evaluation. This presentation has some blank slides for you to practice coming up with criteria for various decisions (not the one that is the focus of your research project).

Attachment:- Evaluation Matrix and Chart.rar

Reference no: EM132851587

Questions Cloud

Develop a confidence interval for the proportion of viewers : Pharmaceutical companies promote their prescription drugs using television advertising. In a survey of 75 randomly sampled television viewers

Develop a disaster recovery plan for an organization : Develop a disaster recovery plan for an organization. There are many different templates available online for you to use as reference and guidance

Contradictory pressures on managerial job performance : Post three or more real life examples of "contradictory pressures" on managerial job performance.

How do develope a swot analysis for anomally detection : How do Develope a SWOT analysis for Anomally Detection as it pertains to Data Analysis. You do expect a complete and detailed SWOT analysis.

Create an Evaluation Matrix Chart in Excel : Create an Evaluation Matrix Chart in Excel that will let you compare the 3 careers/positions at technology companies' side by side on each criterion

Research list of sniffers and other network analysis tools : Research the list of sniffers and other network analysis tools. Write a proposal in which you describe the capabilities of each tool.

Identify tools to add to a forensics toolkit : Network Traffic Analysis Tool, Describe the capabilities of several sniffers and other network analysis tools. Identify tools to add to a forensics toolkit.

What does the software do : What does the software do? What are it's major features? What kind of training is required? How much does the software cost?

Identify the organization critical data infrastructure asset : Identify the organization's critical data infrastructure assets (i.e., network, telecom, utilities, applications, computers and client data categories).

User Account

All Pages