SEE ATACHMENTSOverview See the Practice Lab section below for an overview of the Practice Lab system. Labs are i

SEE ATACHMENTSOverview See the Practice Lab section below for an overview of the Practice Lab system. Labs are included within the course to supplement the weekly readings with hands-on practice. The lab activities in this course are designed to provide class members practical exposure to Microsoft (MS) Excel and MS Project. Output from the labs are posted in the same week’s interactive assignment, due on Friday (day 4). Be sure to give yourself plenty of time to complete your lab portion of the course and do not wait until the last moment to complete your work! Projects and programs help an organization meet their objectives, and it is therefore important that an organization choose projects and programs that align with its strategic plan. In Chapter 2 of the textbook, Schwalbe (2016) reviews a variety of tools used in project selection. One of these tools, the weighted scoring model (WSM), will be used in this assignment. However, instead of using this tool to evaluate how an organization’s strategic plan aligns with various proposed projects, you will be using this tool to evaluate how your short- and long-term goals align with the various jobs and careers you are considering.


Title of Your Scoring Model
Name: Barbara Garcia
Date: 2/14/2019
Overview: Write your overview here.
choice 1
choice 2
choice 3
choice 4
Criteria Elements
Weight
given to
choice
Weighted Scores
0,00
0,00
0,00
0,00
0,00
1) Explain the results of the weighted scoring model and the decision you would make based only on
results of this model.
2) Explain how the job choice aligns with your career objectives.
3) Based on the results of the weighted scoring model, identify at least two things you will need to do
in order to accomplish your career goals.
References for sources used in this Assignment
Ver. 1.1 – syg-8.15.16
Frank Smith Birthday Meal Choice According to the Weighted Average
Name: Frank Smith
Date: 12/1/2016
Overview: Members of the Smith Family like different foods. It is Frank’s 45th birthday and we need to
determine the menu for Frank’s birthday dinner. Frank and his wife Sally have two young children, and will be
taken into consideration. Some preference will also be given to nutritious and heathy food, and meals that are
good the next day (Frank likes leftovers).
Criteria elements
How much Frank will like meal
How much Sally will like meal
How much kids will like meal
Good leftovers
Nutrition/health
Weighted Scores
Weight
given to
choice
0,35
0,25
0,15
0,18
0,07
1,00
Steak and Chicken Pot
Potatos
Pie
99
20
81
95
25
70,65
85
5
80
60
15
54,85
Sushi
Tofu Turkey
Meal
74
90
72
15
70
66,80
2
98
25
15
95
38,30
1) According to the weighed scoring model created, the family will be having steak and potatoes for Frank’s
birthday dinner.
However, now I am wondering if having leftovers should be weighed at 18%. I may decrease the weight there,
add atmosphere of restaurant and create another model.
2) This assignment helped me reevaluate what I thought I wanted and what was important when choosing my
birthday meal. Being able to look at the scores individually and the total weighted average for each choice
helped me evaluate my choices.
I also learned how to do weighted averages in MS Excel.
3) It took some extra time for me to figure out how to make the table visually appealing spreadsheet that prints
on one page. Then I watched the my learning video on tables and realized it was easy. Now I can create nice
looking tables at work.
Sources used in Assignment
Vigar, D. (2013). How to create a weighted factor model. Retrieved from

LearningByVideos (2013, December 23). Microsoft Excel for Beginners #09 – Tables [Video file]. Retrieved from

Note that these are only examples — the answers do not address the questions in your assignment.
n your assignment.
Practice Labs Overview Document with Visual Aids
Practice Labs does not have an auto save function so you must manually save your work. Saving your
work in Practice Labs is a multi-step procedure that includes finding and saving files in Internet Explorer.
Please periodically save your work. Saving your work using the document name plus the date and time
will allow you to see that you have saved the latest version correctly and find the latest version easily.
Your file is not saved until you see it in my files. Do not log out of the system until you see your file here.
–If doing the MS Excel project in Practice Labs you will need to download the files to your PC. Here are
the directions for that. Note you can only download files from Practice Labs, no files can be uploaded.
Weighted Scoring Model- Week 1- Lab
This course utilizes the Practice Labs technology. This platform allows for you to
interact with full-versions of various software, servers, and application components
without downloading anything to your personal computer. The platform is cloud-based
and web-browser accessible. Directions for each of your course activities are shown on
the desktop area within the lab system.
Overview
See the Practice Lab section below for an overview of the Practice Lab system.
Labs are included within the course to supplement the weekly readings with hands-on
practice. The lab activities in this course are designed to provide class members
practical exposure to Microsoft (MS) Excel and MS Project. Output from the labs are
posted in the same week’s interactive assignment, due on Friday (day 4). Be sure to
give yourself plenty of time to complete your lab portion of the course and do not wait
until the last moment to complete your work!
Projects and programs help an organization meet their objectives, and it is therefore
important that an organization choose projects and programs that align with its strategic
plan. In Chapter 2 of the textbook, Schwalbe (2016) reviews a variety of tools used in
project selection. One of these tools, the weighted scoring model (WSM), will be used in
this assignment. However, instead of using this tool to evaluate how an organization’s
strategic plan aligns with various proposed projects, you will be using this tool to
evaluate how your short- and long-term goals align with the various jobs and careers
you are considering.
Prior to completing this exercise, review Chapter 2, pages 50 to 52 in the course
textbook (Schwalbe, 2016) and the Vigar (2013) video in the Required Resources (as
well as any that you would like from the Recommended Resources) for an example of
the weighted scoring model and how it is used. If you are new to Excel, you may also
wish to utilize the extensive help systems present within your own version of Excel
(2007 or above), Excel O365, or the version of Excel in the Practice Labs. (Links to an
external site.)Links to an external site. for this course. You can also search YouTube
using the phrase ‘how to use Excel’ for videos that can help you become more familiar
with the tool. This week’s laboratory activity must be completed and saved as a
Microsoft Excel spreadsheet (.xls, or .xlsx), which will be posted in the Weighted
Scoring Model interactive assignment this week. Use the template provided for this
exercise. No title page is needed.
Instructions:
a. Open the assignment template within your version of Microsoft Excel. Fill out your
name, date, and write a two- or three-sentence overview for this assignment
(individualized scope statement for this project).
b. Choose at least four potential careers or jobs that interest you (now, after you
graduate, or in the future).
c. Choose five criteria that are important to you when choosing a job/career. When
choosing your criteria, consider your short- and long-term strategic objectives.
d. Choose the weight you want to give each decision criteria. The weight of all the
categories together need to equal 100%.
e. Rate each job/career on your given categories.
f. Calculate the weighted average in the Excel template provided. Formulas are
already in the template.
g. Write answers for the following three notes for your table:
o Explain the results of the weighted scoring model and the decisions that would
be made if only the weighted scoring model was
o Explain how this choice aligns with your career objectives.
o Identify at least two things you’ll need to do in order to accomplish your career
goals.
h. Check your spreadsheet to ensure it is something you would be proud to hand to a
project sponsor. This means
o The spreadsheet stands on its own, meaning an outside person can read and
understand the choices you are considering and the choice you’ve made.
o The sheet is error free. Remember in Microsoft (MS) Excel you need to manually
check for spelling and grammar.
o The spreadsheet looks professional when printed (do a print preview to check).
o Save your Excel Spreadsheet using your last name, course week, and today’s
date (for example 2016.11.15 Wk1 Smith) to a location on your computer’s hard
drive.

Purchase answer to see full
attachment