In this assignment you will address the problem of how to resolve the problem of low 6-year graduation rate at CSUDH. The 6-year graduation rate of CSUDH has been less than 50% in past decade. You need to watch lecture video, read slides and page #276-279 (based on the 4th edition) related to the statistical tools of six sigma in the textbook carefully before you start working on this assignment.

Step 1: You need to interview 10 students and ask them what are the potential reasons (as many as possible) that CSUDH students cannot complete their bachelor degree in six years. Then, summarize the results in the check Sheet in Excel worksheet as follows. Please refer to Figure 8.7 in slide #31 and textbook. Check Sheet

Reason

#1

#2

#3

#4

#5

#6

#7

#8

#9

#10

Totals

% of Total

(Reason1)

V

V

V

V

V

5

(Reason2)

V

V

V

V

V

5

Step 2: Sort the reasons based on the numbers in the last column % of Total from the highest to lowest. Then, plot Pareto Chart by inserting bar chart into Excel worksheet (% of Total as Y axis and reasons as X axis). Please refer to Figure 8.8 in slide#32 and textbook.

Step 3: Conduct a cause-effect analysis on the problem of low 6-year graduation rate based on the information from step 1. Categorize the reasons into 3-5 categories and list reasons as branches under each category. Please refer to Figure 8.9 in slide#34 and textbook.

Step 4: Write a report outlining your suggestions for how to increase the 6-year graduation rate at CSUDH.