You need to understand how to send your assignments

Welcome!Please read this page (in particular) very carefully.InstructionsYou need to understand how to send your assignments (deliverables)to your instructor. The tabs (bottom of each sheet) in thisdocument contain all of the deliverables expected of you.If you need help along the way, look for these special cells that have a red indicatorin the corner. It looks like the "Read me" box to the right:Read meSimply slide your cursor over the red-cornered cell and you will get more information.The format for all of the deliverables is the same:The ‘objective’ is in black font. It describes what you are doing the particular deliverable.The next segment is in green font. These are your instructions.The blue font is the data (where applicable) that you will need to complete the deliverable.SoftwareWe are using Excel software for the projects. You may use other softwareto complete your projects, but please ‘report’ your answers in the Excel formatdescribed below.You may complete your assignments with any version of Excel software.All assignments can easily be completed with a basic copy of Excel.There is also an Add-In feature which is available for Excel that can be helpful,although it is not required. The Add-In feature comes free with each Excel package,although it may not be currently loaded into your copy of Excel.Following are the simple instruction for loading the Excel Add-ins for both Excel 2003and Excel 2007. (Slide your cursor over the red-cornered cells to read)Excel 2003Excel Novice – Please readExcel 2007Project Assignment Submission Timeline (Suggested)Project charter (target week 3 or sooner)Baseline sigma (week 4 or sooner)SIPOC (week 5 or sooner)Pareto chart (week 6 or sooner)Expected Variation (week 7 or sooner)Stem & leaf (week 8 or sooner)Scatter diagram (week 10 or sooner)DOE (week 11 or sooner)Control chart (XmR) ( week 12 or sooner)Pp Ppk (week 13 or sooner)How to submit an AssignmentIn response to customers like you, we have added a peach-colored boxfor each deliverable. We have done this to make it clear (and consistent) theareas of the project that will be reviewed to your instructor.Project:Deliverable:Student last name:Healthcare Project 2016Improve phase – gen. sol.JohnsonWhat is the control chart telling you?There is a point out of control atsubgroup #15. I would try to figureout why that happened. We wouldalso recalculate the control limitsbecause there is evidence the processhas changed.What is the average of subgroup 1?What is the average of subgroup 2?What is the average of subgroup 3?What is the average of subgroup 4?What is the average of subgroup 5?What is the average of subgroup 6?What is the average of subgroup 7?What is the average of subgroup 8?2234232225232927Read this!To send each assignment to your instructor:Click-and-hold the LEFT mouse button at the TOP-LEFT corner of thepeach-colored box, then while holding down on that button, drag tothe LOWER-RIGHT corner of the box. This will highlight the entirepeach-colored box. Release the mouse button. Do a CTRL-C. This willcopy what has been highlighted.Go to your Villanova website and follow this sequence:1. COURSE MENU2. CLASS ROSTER3. Click on your instructor’s email envelope icon4. Type "Check My Work – ASSIGNMENT NAME – PROJECT NAME" in the SUBJECT box.5. Click once inside of the message box6. Do a CTRL-V. This will paste your deliverable into this box.Don’t be concerned if after you paste it, the appearance of the text is out ofalignment. It will straighten out after you hit SEND.7. SEND Check your SENT ITEMS folder afterward to see how it straightened out.VERY IMPORTANT!! Be sure to submit your assignments for grading as you completeeach one and following the submission scheduled posted on the message board – DONOT WAIT UNTIL THE END OF THE COURSE TO SEND THEM ALL IN. NOTE THAT THEENTIRE PROJECT MUST BE 100% CORRECT BY ONE WEEK BEFORE THE END OFCLASS OR YOU WILL FAIL THE PROJECT AND THE COURSE. This means that you mustsubmit ALL of your assignments far enough in advance of the project completiondeadline to allow time for all necessary corrections to be made. Following thesubmission schedule is the best way to ensure that you have enough time to finish theproject by the completion deadline – failure to meet the submission due dates can resultin failing the course. Very few assignments are correct on the first submission and manyrequire multiple rework attempts, so don’t procrastinate!This spreadsheet tab provides illustrations of adding the DATA ANALYSIS capability to your Excel software.If you see Data Analysis already listed under the Tools tab, you are set. If you do not see Data Analysisfollow the instructions in the Green tab.Excel 2003 instructionsExcel 2003 or earlier versions of Excel exampleThis spreadsheet tab provides illustrations of adding the DATA ANALYSIS capability to your 2007 Excel software.If you see Data Analysis already listed under the DATA tab, you are set. If you do not see Data Analysisfollow the instructions in the Green tab.Excel 2007 instructionsExcel 2007 exampleHealthcare ProjectA recent report from the Centers for Disease Control and Prevention indicates that over the pastdecade trips to emergency departments (ED) rose 20 percent, while the number of availableemergency centers fell by 15 percent. Another study from the American Hospital Associationindicated that 62 percent of hospitals feel they are at, or over operating capacity. That numberjumps to 90 percent when considering Level 1 Trauma Centers and larger (300+ beds) hospitals.These statistics are frighteningly familiar to many hospitals and patients. The pressures aremounting, and a faltering economy has swelled the ranks of uninsured — people who oftenrely on the local ED for primary care. Countless emergency departments are literally on lifesupport as they try to cope with capacity issues and workforce shortages. Preparing for orresponding to emerging threats such as bioterrorism and SARS only increases the strain onthe system. In hospitals across the U.S., EDs face a similar story of delaysand dissatisfaction…from both patients and clinicians.Not all the news is bad, however. Some hospitals are finding new ways to overcome thechallenges and create safer, more efficient environments. Through a combination of SixSigma and Lean, hospitals are targeting critical aspects of patient flow, patient access,service-cycle time, and admission/discharge processes. A growing number of hospitalsare taking steps to identify and remove bottlenecks or inefficiencies in the system.As a result, they are seeing a positive impact on patients, staff, and the bottom line.By using the principles you have learned in the Six Sigma Black Belt course we want todecrease ‘door to doctor time’ in our ER to hopefully reduce the number of people who gettired of waiting and leave without treatment. In fact, last year of the 43,800 patients awaitingtreatment, 7.2% left without treatment–essentially because they were dissatisfied with the wait time.The nation’s emergency care network must remain strong — not only to maintain its ability toserve basic community needs, but also to ensure it will have the necessary capacity andprocesses in place to respond quickly during a crisis.The deadline for having all project deliverables 100% correct is 7 days prior to the end of the courseObjective:A problem statement needs to be developed.There needs to be a business case so that management will buy-in to having the teamworking on the project. The scope of the project also needs to be decided upon. This isimportant to ensure a likely successful completion. If the scope is too broad, asuccess may not be realized for years, or may not happen at all.Instructions for you:Create a project charter based"Create a charter?"upon the information in the introduction. (see "The project" tab)In reality, you would fill in a charter with team members’ names, stake holders, etc. Weare not interested in those details for this simulation, but we do want to see what youcome up with for four (4) items: Problem statement, business case, goal and project scope.How to submit an AssignmentProject:Deliverable:Student last name:Healthcare 2016Project charterSchaabWhat is the business case? (Use no more than 2 sentences.)Our ED is experiencing increased patient volumes, staffing challenges andlimited capacity. Long delays are negatively impacting the patient experienceand causing patients to leave without being seen, thusly moving us toimprove targeted ED metrics.What is the problem statement? (Use no more than 2 sentences.)In 2015, out of 43,800 patients that entered the ED, 7.2% left without beingseen due to long wait times. This negatively impacts our bottom line andaffects our ability to serve basic community needs and leaving us vunerablein times of crisis."Business Case?""Problem Statement"What is your project scope? (This is not your goal statement! Use one sentence.)The scope will encompass registration process, triage process, ED flowprocess, lab process and discharge process."The project scope?"Read this!To send each assignment to your instructor:Click-and-hold the LEFT mouse button at the TOP-LEFT corner of thepeach-colored box, then while holding down on that button, drag tothe LOWER-RIGHT corner of the box. This will highlight the entirepeach-colored box. Release the mouse button. Do a CTRL-C. This willcopy what has been highlighted.Go to your Villanova website and follow this sequence:1. COURSE MENU2. CLASS ROSTER3. Click on your instructor’s email envelope icon4. Type "Check My Work – Charter" in the SUBJECT box.5. Click once inside of the message box6. Do a CTRL-V. This will paste your deliverable into this box.Don’t be concerned if after you paste it, the appearance of the text is out ofalignment. It will straighten out after you hit SEND.7. SEND Check your SENT ITEMS folder afterward to see how it straightened out.Please ‘hand-in’ your assignments throughout the course.DO NOT SAVE THEM FOR THE END.The deadline for having all project deliverables 100% correctis 7 days prior to the end of the course.Objective:We want you to determine the baseline sigma level with the Motorola 1.5 sigma shift.Note: You will need to refer to the tab entitled "The Project" for this deliverable.Instructions for you:Calculate the PPM / DPMO and determine the baseline sigma level with the Motorola shift.How to submit an AssignmentProject:Healthcare 2016Deliverable:Baseline SigmaStudent last name:SchaabWhat is the baseline sigma? (Approximately)Read this!To send each assignment to your instructor:Click-and-hold the LEFT mouse button at the TOP-LEFT corner of thepeach-colored box, then while holding down on that button, drag tothe LOWER-RIGHT corner of the box. This will highlight the entirepeach-colored box. Release the mouse button. Do a CTRL-C. This willcopy what has been highlighted.Go to your Villanova website and follow this sequence:1. COURSE MENU2. CLASS ROSTER3. Click on your instructor’s email envelope icon4. Type "Check My Work – Baseline Sigma" in the SUBJECT box.5. Click once inside of the message box6. Do a CTRL-V. This will paste your deliverable into this box.Don’t be concerned if after you paste it, the appearance of the text is out ofalignment. It will straighten out after you hit SEND.7. SEND Check your SENT ITEMS folder afterward to see how it straightened out.Please ‘hand-in’ your assignments throughout the course.DO NOT SAVE THEM FOR THE END.The deadline for having all project deliverables 100% correctis 7 days prior to the end of the course.Objective:We want to view the process from a high level in order to see the major process elements.SIPOC – Suppliers, Inputs, Process, Outputs, CustomersInstructions for you:Create a SIPOC map of the process based upon the healthcare case study write-up (found at"The project" tab). Feel free to use your imagination in doing this piece of the project.Draw upon your own experience from visiting an Emergency Department to come up withthe ‘suppliers’, ‘inputs’, ‘process’, ‘outputs’, and ‘customers.’ Note: Normally theSIPOC map is constructed horizontally. When mailing this deliverable to your instructor,it formats better vertically.How to submit an AssignmentProject:Deliverable:Student last name:Suppliers:(Name 3)Inputs:(Name 3)Process Step 1:Process Step 2:Process Step 3:Process Step 4:Process Step 5:Outputs:(Name 3)Customers:(Name 3)Healthcare 2016SIPOCYour LAST name hereType suppliers hereType suppliers hereType suppliers hereType inputs hereType inputs hereType inputs hereStep 1Step 2Step 3Step 4Step 5Type outputs hereType outputs hereType outputs hereType customers hereType customers hereType customers hereRead this!To send each assignment to your instructor:Click-and-hold the LEFT mouse button at the TOP-LEFT corner of thepeach-colored box, then while holding down on that button, drag tothe LOWER-RIGHT corner of the box. This will highlight the entirepeach-colored box. Release the mouse button. Do a CTRL-C. This willcopy what has been highlighted.Go to your Villanova website and follow this sequence:1.2.3.4.5.6.COURSE MENUCLASS ROSTERClick on your instructor’s email envelope iconType "Check My Work – SIPOC" in the SUBJECT box.Click once inside of the message boxDo a CTRL-V. This will paste your deliverable into this box.Don’t be concerned if after you paste it, the appearance of the text is out ofalignment. It will straighten out after you hit SEND.7. SEND Check your SENT ITEMS folder afterward to see how it straightened out.Please ‘hand-in’ your assignments throughout the course.DO NOT SAVE THEM FOR THE END.The deadline for having all project deliverables 100% correctis 7 days prior to the end of the course.Objective:As stated in the problem, patients are leaving the emergencydepartment before being seen by a doctor for a variety of reasons.The American Medical Association released findings from astudy (blue font far below) that addressed the following questionof people who left ER’s without treatment:"Why did you leave the ER without waiting for treatment?"You need to determine the "biggest contributor" to the problem of people leaving without treatment.One tool to accomplish this is the Pareto ChartInstructions for you:Using the data in blue below construct a Pareto chart (see your online textbook reading assignment for more).We realize that you could simply pick the two or three process components without actually creatingthe Pareto Chart, but we want you to actually create the Pareto Chart because in reality managementlikes to see simple charts where they don’t have to analyze the data to see the picture. That is why thePareto Chart is used in the first place.SAMPLENotice: The shaded section below has a practice problem intended to help you with this assignment.If you want to skip this hypothetical problem, you can.Hypothetical problem (This is NOT the project data which is why this is separated in a shaded box)Just to show you how this works, let’s say the responses were as follows:Let’s say that data reveals the following counts for beach-related injuries for the month of July.Injury categories# of incidentsCuts from broken glass12This green area is just for practice.The project is below in blue.Surf boarding injuries37Fishing related injuries41Jelly fish stings45This is a hypothetical exampleSkim boarding accidents29You will be doing this using differentHit with flying toy79data for your project, but this is merelySprained ankle43showing you how to do it.Jet Ski accidents34Burns from grills52Misc.22The first thing you would have to do is sort the data from the largest count of injuries to the smallest.It would look like this after sorting.Then, you would create a cumulative percentage column. Click once on any of thecumulative percentages to see the formula.Injury categories# of incidentsCumulative %Hit with flying toy7920%How did you get 20?Burns from grills5233%How did you get 33?Jelly fish stings4545%Sprained ankle4356%Fishing related injuries4166%Surf boarding injuries3775%Jet ski accidents3484%Skim boarding accidents2991%Misc.2297%Cuts from broken glass12100%394..Back to the project itself…Data:Reasons for leaving:Got tired of waitingNot necessaryToo many people waitingDoctor treatmentStaff treatmentEnvironmentElsewhereIgnored meToo expensiveHad to go / ran out of timeTotal choosingthis response6443221111Cumulative %Create a Pareto chart in Excel 2003Create a Pareto chart in Excel 2007YOU DO NOT NEED TO SEND THE ACTUAL PARETO CHART.Project:Healthcare 2016Deliverable:Pareto ChartStudent last name:Your LAST name hereWhich ONE issue should your team focus on first, based upon what the Pareto Chartis telling you, and why?Type your response here.How to submit an AssignmentRead this!To send each assignment to your instructor:Click-and-hold the LEFT mouse button at the TOP-LEFT corner of thepeach-colored box, then while holding down on that button, drag tothe LOWER-RIGHT corner of the box. This will highlight the entirepeach-colored box. Release the mouse button. Do a CTRL-C. This willcopy what has been highlighted.Go to your Villanova website and follow this sequence:1. COURSE MENU2. CLASS ROSTER3. Click on your instructor’s email envelope icon4. Type "Check My Work – Pareto Analysis" in the SUBJECT box.5. Click once inside of the message box6. Do a CTRL-V. This will paste your deliverable into this box.Don’t be concerned if after you paste it, the appearance of the text is out ofalignment. It will straighten out after you hit SEND.7. SEND Check your SENT ITEMS folder afterward to see how it straightened out.Please ‘hand-in’ your assignments throughout the course.DO NOT SAVE THEM FOR THE END.The deadline for having all project deliverables 100% correctis 7 days prior to the end of the course.Objective:Your boss wants to know the limits of expected variation. You know there is another shipmentcoming in next week and based upon this week’s run, and assuming that the process is normally distributed,you can calculate/predict the limits of expected variation by calculating the mean and standard deviationfor this data and then using the properties of the normal distribution to estimate the limits of the expected variation.Expected variationInstructions for you:1. Calculate the average for each.2. Calculate the standard deviation for each.3. From these calculations, determine the range of expected variation.You can complete this assignment by hand as taught in the lecture, oryou can use Excel, or you may use a calculator orother software. We explain the fundamentals of thecalculations, so that you learn the mechanics and the meaningof standard deviation. This approach gives you anunderstanding of standard deviation, which then allowsyou to be flexible in the tools that you use.4. Create a histogram from this data. Use theappropriate number of cells to represent the data.Hint: There is a ‘rules of thumb’ cell choice tablein the HISTOGRAM (part I) section of your workbook.5. By looking at the histogram, is the process approximately normallydistributed? Is there obvious assignable-cause variation?Use Excel 2003 to find mean and Standard DeviationUse Excel 2007 to find mean and Standard DeviationHistograms in Excel 2003Histograms in Excel 2007More on Bin RangesData:Data for ‘Wait Times’ for last month242718112227172317517282417821262317311827222717402218171828How to submit an AssignmentYOU DO NOT NEED TO SUBMIT A HISTOGRAM FOR THIS DELIVERABLEProject:Healthcare 2016Deliverable:Expected VariationHow do I determine if it’sStudent last name:approximately normal?Your last name hereMean:Standard deviation:Is the data approximately bell shaped?What is the lowest point of expected variation?What is the upper point of expected variation?Yes or NoROUND ALL FINAL RESULTS TO6 DECIMAL PLACES.HelpHelpRead this!To send each assignment to your instructor:Click-and-hold the LEFT mouse button at the TOP-LEFT corner of thepeach-colored box, then while holding down on that button, drag tothe LOWER-RIGHT corner of the box. This will highlight the entirepeach-colored box. Release the mouse button. Do a CTRL-C. This willcopy what has been highlighted.Go to your Villanova website and follow this sequence:1. COURSE MENU2. CLASS ROSTER3. Click on your instructor’s email envelope icon4. Type "Check My Work – Expected Variation" in the SUBJECT box.5. Click once inside of the message box6. Do a CTRL-V. This will paste your deliverable into this box.Don’t be concerned if after you paste it, the appearance of the text is out ofalignment. It will straighten out after you hit SEND.7. SEND Check your SENT ITEMS folder afterward to see how it straightened out.Please ‘hand-in’ your assignments throughout the course.DO NOT SAVE THEM FOR THE END.The deadline forhaving all project deliverables 100% correctis 7 days prior to the end of the course.Objective:The team wants to know if there is an obvious reasonfor wait times being longer than what is acceptable.One of the team members suggested using a stem-and-leafdiagram to get a visualization of the variation in wait times.Wait times were recorded for the past 70 days.By looking at the numbers below, can you tell if there isassignable-cause variation? Unless you havea graphing function in your head, it is difficult to tell. So,that is the question. "Is there assignable-causevariation that can be realized from the 70 data values listed?"Your job is to answer that question. You could usea histogram (among other tools) to answer that question, butyour sponsor wants to keep the actual raw datawhen reviewing the tool of choice. So, you will be usinga stem-and-leaf diagram so that the raw data can bepreserved. Construct a stem-and-leaf fromthe data. Is the process approximately normally distributed? If not, whatshape do you see and what should we do about this?Instructions for you:1.2.3.4.Construct a stem-and-leaf diagramAnswer the question: "Is there process approximately normally distributed?"What is the stem-and-leaf diagram telling you?What would you recommend?Data:I’m lostWait times (last 10 weeks)1616173747324821187515171347114738172049191626176515174816444845504963172210185114806494847485246484720714750954720503521464820641644825158How to submit an AssignmentHelpful tip – Sorting – Excel 2007Helpful tip – Sorting – Excel 2003Project:Healthcare 2016Deliverable:Stem & LeafStudent last name:Your last name here9876543210Is it reasonably normally distributed?Yes or NoIf it is not normal, what shape isit? (Use the correct term for thisshape, not a description.)Based on this analysis, what isthe next thing you would do?Type your recommendation here."What’s the purpose of the red line?"Read this!To send each assignment to your instructor:Click-and-hold the LEFT mouse button at the TOP-LEFT corner of thepeach-colored box, then while holding down on that button, drag tothe LOWER-RIGHT corner of the box. This will highlight the entirepeach-colored box. Release the mouse button. Do a CTRL-C. This willcopy what has been highlighted.Go to your Villanova website and follow this sequence:1. COURSE MENU2. CLASS ROSTER3. Click on your instructor’s email envelope icon4. Type "Check My Work – Stem and Leaf" in the SUBJECT box.5. Click once inside of the message box6. Do a CTRL-V. This will paste your deliverable into this box.Don’t be concerned if after you paste it, the appearance of the text is out ofalignment. It will straighten out after you hit SEND.7. SEND Check your SENT ITEMS folder afterward to see how it straightened out.Please ‘hand-in’ your assignments throughout the course.DO NOT SAVE THEM FOR THE END.The deadline for having all project deliverables 100% correctis 7 days prior to the end of the course.Objective:The team is certain there is a correlation between the volume of patients and the number of patients who"Leave Without Treatment" (LWT). If there really IS correlation with the set of data,the attention will be directed to d…