WEEK2
qkiii123
ch05ex02.xlsxEmployees
| Employee ID | Last Name | First Name | Undergraduate Degree | Advanced Degree | Years Exp | Skills |
| A321 | Alverez | Hernando | BS Computer Science | 4 | 1, 2, 4 | |
| B195 | Barton | Alice | BS Management | MBA | 1 | 1, 5 |
| B130 | Boston | Matt | BS Computer Science | MS Computer Science | 3 | 4, 5 |
| C427 | Cary | Jane | BS Computer Science | MS Computer Science | 5 | 1, 5 |
| C013 | Cox | Amanda | BS Accounting | 3 | 2, 5 | |
| F430 | Francis | Tom | BS Logistics | 2 | 4, 5 | |
| J045 | Johns | Carl | BS Mathematics | 2 | 2, 5 | |
| J342 | Johnson | Sally | BS Education | 7 | 3, 4 | |
| M432 | Morgan | Thomas | BS Mathematics | 7 | 4 | |
| N541 | Nottingham | Henry | BS Mathematics | 3 | 1, 2 | |
| P549 | Palmer | James | BS Electical Engineering | 5 | 2, 4 | |
| R430 | Randal | Joyce | BS Economics | MBA | 2 | 5, 6 |
| S0343 | Soloman | Robert | BS Computer Science | 6 | 2 | |
| T078 | Thornton | Robert | BS History | 4 | 3 | |
| T871 | Trenton | Mary | BS Mathematics | MS Mathematics | 3 | 2, 4 |
| U039 | Underwood | Frank | BS Accounting | 2 | 4, 5 | |
| V321 | Victor | Albert | BS Computer Science | MS Computer Science | 3 | 1, 3 |
| W821 | Watson | Helen | BS Computer Science | 8 | 2 | |
| Y326 | Yee | Han | BS Accounting | MS Accounting | 6 | 5 |
Projects
| Project ID | Client | Project Type | Years Exp | Basic Skills | Add'l Skills | Preferred Degree |
| P036 | JM Logistics Inc. | 1 | 4 | 1 | 4 | BS CS or Math |
| P037 | Jefferson Automotive | 4 | 5 | 4, 5 | 1 | MBA |
| P038 | World-wide Sourcing | 2, 4 | 5 | 2 | 4 | BS Acctg or MBA |
| P039 | Solar Systems | 2 | 2 | 2 | BS Math, BS CS, BS Acctg | |
| P040 | Robert's Heating Supply | 3 | 2 | 3 | none | |
| P041 | Casual Dining, Inc. | 2 | 3 | 2 | 1 | BS CS |
| P042 | US Brokerage | 1, 2 | 5 | 1, 2 | 5 | BS CS, BS Math, or MBA |
| P043 | Computer Chips, Inc. | 4 | 3 | 4, 5 | 1 | none |
| P044 | Southeast Region Youth Ministries | 1, 4 | 4 | 2 | 1 | BS CS, BS Math |
| P045 | Huston Power Co. | 1 | 5 | 1 | none | |
| P046 | Helen's Clothiers | 4 | 3 | 4 | 1 | BS CS, BS Acctg, BS Math |
| P047 | McMasters Printing | 3 | 2 | 3 | none | |
| P048 | United Grocers | 4 | 5 | 1, 4 | 5 | MBA |
| P049 | Shelby County Women's Shelter | 1 | 2 | 1 | 5 | none |
| P050 | National Distributors | 1, 3 | 5 | 1, 3 | 2 | BS Acctg |
Skills
| Skill ID | Description |
| 1 | Database management |
| 2 | Business intelligence |
| 3 | Web design |
| 4 | ERP systems |
| 5 | Project management |
