Operations Management homework help

Operations Management homework help. Instructions from Q1 to Q5
The instructions shown below was written by one of my students. I think her instructions may be helpful
for you to complete the assignment, so I share them with you. Forgive her typos and grammar mistakes,
if any. Use the instructions after you finish the “Response” and “Summary” Excel worksheets.
When you finish your Summary. here are the instructions for Q1:
• Create another workbook (click the +) next to Summary. Rename it to: Q1InstrKnow
• Click Insert on the top bar
• Click the Pivot Table (left side); make your Pivot Table is not disable.
• While the pop-up box appeared or Create Pivot Table, click your Response workbook.
• Highlight from Survey Respondent to Attended a Seminar Before, all the way to O289. it means
that the entire dataset from Response workbook excluding the title is being copied to the Pivot
Table. See instructions.
• Click ok in the pop up box or Create Pivot Table or enter in your keyboard.
• Now, you will see the PIVOT TABLE FIELDS on the right side of your Q1 workbook.
• From the Q1 under PIVOT TABLE FIELDS, click the following: Course No, place it under Filter
(drag it) Question 6 to Columns, Instruction ID to Rows, Questions 6 (again) to Values, but scroll
down to change to COUNT. please check the instructions if this is make sense.
• Save it.
Here are the instructions for Q2:
• First, create a UniqueClassSize workbook.
• Copy the Response workbook. there are many ways to do this: I like to right click the Response,
select: Move or Copy, mark: Create a Copy, then you can select where you want to place the
copy, Or you can copy like this: click + (next to Q1) to open a new workbook, then, from the
Response workbook, highlight the entire column and row, right click it and go to the new
workbook, paste it.
• Now that you have the copy of the Response Workbook. rename it to UniqueClassSize
• Highlight all the data which means, from Survey to O289
• Click the DATA on the top bar ribbon
• look for SORT
• click SORT, the box will appear, sort by: Course No. Click Ok or Enter.
• Then click the DATA again, Click the Remove Duplicates. Please follow page 13.
• FYI: only click these: Course No, Location, Instruction ID, Class Size, Seminar End Date. enter
• You should have only 28 entries.
Now, you can create a Q2:
• Click a new workbook (+) next to UniqueClassSize
• Rename it Q2 CrsPopularity
• Click Pivot Table, same process as Q1 but go to UniqueClassSize (not the Response). This is the
purpose why we created the UniqueClassSize workbook.
• Now, in your Q2, you should see the PIVOTS TABLE FIELDS on the right side of your Q2
workbook.
• Row: Course No
• Values: Class Size, but edit it to SUM
• Next, create a chart.
• click the pie chart on the top ribbon
• select chart 1 for regular pie but this is exploded pie because you can move the pie itself.
• Add description: title or whatever you want.
• In order to place a title, click the pie, then on the top, there is a DESIGN
• on the left side, there is ADD CHART ELEMENT. click the little arrow to show options: Chart title,
Axis Legend, etc (you can use this particular instruction in Q5 later)
• Save it
• Please edit to make the SUM OF CLASS SIZE in percentage as, % of Grand Total
• It states in the instruction, must to place it on Percentage:
• What is the popularity of Perry Seminar Courses? (Of the total number of students who have
taken classes, give the percentages of the popularity of each course (in terms of the number of
enrolled students) in comparison to all courses combined. Create a pie chart showing the
percentage of offerings for each course as compared to the total courses offered.
Q3: Create another workbook. Rename as state above or see instruction page 14
• Click Pivot Table on the top ( same instruction as Q1) go to Response.
• Copy the entire Data from Survey Respondent to O289
• Enter or OK
• Now, you are in your Q3, In your PIVOT TABLE FIELDS, Click this: questions 2 place it to Rows,
Question 4 place it to Column, again, Question 4 place it to Values, but change it to Count.
• Save it.
• Must to answer the question in the instruction:
• Please edit your Pivot Chart to answer this question.
• How many respondents who have taken a seminar course with another company
(Respondents who answered “Yes”, coded as “2”, on survey question #2) agreed or
strongly agreed (answered 4 or 5 on survey question #4) that they would take another
course with Perry Seminars?
Q4: page 14
• Same process, create another workbook, by clicking the + next to Q3
• Click the Pivot Table on the top
• Go to RESPONSE to copy the information, from Survey Respondent to O289 ( the entire data)
then, enter
• In your Q4, under PIVOT TABLE FIELDS choose these: Instructor ID under Row; Questions 7
under Column; again, Question 7 under Value, but change it to Count (right click the little arrow,
click Value Field Settings, and under Show Value as: % Row Total
• Create a Chart using 100% Sacked Column
• Click the Column or the recommended, then select the 3rd one. (make sure it is 100% Stacked
Column)
• Add title/description (same instruction as previous), by clicking the chart go to DESIGN on the
top, then go to the left side, click ADD CHART ELEMENT.
• Note: you must get the instruction from the PIVOT TABLE FIELDS in order to have a correct
Column.
• Save it.
Q5:
• Same process, Create workbook, next to Q4. rename it to Q5CrsUsefulness
• Same process as earlier, click Pivot on the top ribbon, copy the Response
• In your Q5, under the PIVOT TABLE FIELDS: Filter is Class size; Column is Quesion5; Row is
Course No; Values, is also question 5 but it should be COUNT (at this time, you should know how
to change it, if not, please check the previous instructions)
• create a chart. CLUSTERED 3-D BAR)
• These are under the ADD CHART ELEMENT
• Add TITLE (you should now this now, if not, please check the previous instructions)
• USE Chart Style2, by clicking the chart, then the Design on the top, it should be the style 2
• Legend Keys and primary vertical gridlines, and major/minor gridlines are also under Add Chart
Element (this was in previous instructions)
• this is on page 14
• since the instruction is only asking for Agreed, and Disagreed, in your Pivot Table,
edit the Column Labels, only the code for Agree and Disagree.
• Save it.

Operations Management homework help

Get Your Custom Essay Written From Scratch
We have worked on a similar problem. If you need help click order now button and submit your assignment instructions.
Just from $13/Page
Order Now