Team Assignment Process Improvement

MSD P18711 | Beth’s Favorite TeamMadeline Galvin | Ann Brautigam | Joseph YeiterSubsystem Level Prep

Agenda

● Test Plans● Problem & Solution Process● Satisfaction Survey Results ● Spring Assignment Results ● MSD I Post Mortem● Project Plan● Next Steps

Satisfaction Survey Results

● Respondents:○ 8 MSD II students○ 43 MSD I students

●● Willing to switch sections

for a different project:○ 23 total students

●● Switched after initial teams

were announced:○ 4 total students

Satisfaction Survey Results

Spring Assignment Results

See handout

Example Matrix - Top5

Issues Encountered

● Survey○ Make a drop down for proposed team names○ Possibly switch to just using team number for output instead of name

● Standardize whether there is a “P” in front of project number or not● Handling students who have not filled out any skills, interests, or top choices

● Limit how many skills student can fill out

Problem & Solution Process

Bug tracker

MSD I Post Mortem

Issues Encountered Rating 1-5 1:No Issues, 5; Major Issues

Norms & ValuesPunctuality 1 No issuesOnline Availability 1 No issuesTimely Responses 1 No issuesThoroughness of work 1 No issuesWork Accuracy 1 No issues

Commitment 2A lot of brainstorming occurs, sometimes not followed through completely; not detrimental to the team

Project Planning 1 No issues

● Team Norms & Values Review

● Gemba Experience

Important NotesSignificantly less complex to create Spring assignments due to lack of multiple sections Student survey can be changed to improve outputSIS data taken after enrolment closed to avoid any student misses Sum of students in each major did not match sum of majors in each project

Deliverables for Demo 1 ● Completed Excel Macros to format student and project data

○ Stardizing all inputs, completing missing data○ Scale macros file up○ Automate the file, minimal user input needed after copying survey output over

● Automated calculation of student scores ● Draft of Python code to be used for optimization ● Updated EE skills list and review of other discipline skills

Questions ● Should Qualtrics be used for PRP data collection? ● Updates on Capstone Design Conference due dates?● Use of team name or team number from start ?

ID Risk Category Probability Impact Importance Mitigation Plan Resource

1The new process produces team assignments which are worse than if they were created using the original manual process Technical 3 9 27

Adequate testing of process on old data sets as well as simulated data sets and comparison of results with results of manual process Madeline

2 Team members are not equipped with the necessary Computer Engineering skills required for this system Resource 3 3 9

Team will engage current CE students and/or professors as subject matter experts Joe

3Confidential student information stored on SIS or in survey results is exposed Societal 1 3 3 Correct access levels required for use of system Lissa

4 System is not responsive to last minute issues in the Team Assignment process Technical 3 3 9

Live testing of system performed during Team Assignment process for the upcoming Spring semester Madeline

5 Lack of data sets available to test the new process due to changes made to the student survey Resource 3 3 9

Simulation data sets will be created using the new survey template Madeline

6MSD office is unwilling/unable to properly use system as intended or is unwilling/unable to maintain the system to be used year to year Societal 1 9 9

Proper training manuals for use, maintenance, and troubleshooting will be developed and shared with the MSD office Lissa

7 Team members are unable to translate code developed for system Technical 1 3 3

Detailed comments and instructions will be included in all code developed by team members Joe

8Using SIS to gather private student information Technical 1 1 1

Communicating with SIS API for possible solutions or including corresponding questions in student survey Lissa

9 The system is not able to run for the Spring Semester Technical 3 1 3

Team will be able to create team assignments with the system manually following logic or code Joe

73