Module 3 Assignment-Managing KPI's
abparsley
PerformanceReviewStudent1.xlsxRaw Data
| Name | Hire Status | Hire Date | Review Due Date | Actual Review Date | Status | Gender | Department |
| Robert | 1 | 1/3/19 | 4/10/19 | Male | Accounting | ||
| Mary | 2 | 1/3/19 | 7/25/19 | Female | Accounting | ||
| James | 3 | 1/8/19 | 1/8/20 | Male | Accounting | ||
| William | 2 | 1/10/19 | 7/14/19 | Male | Accounting | ||
| Margaret | 2 | 1/12/19 | 8/9/19 | Female | Accounting | ||
| Doris | 2 | 1/21/19 | 7/16/19 | Female | Accounting | ||
| Mildred | 2 | 1/22/19 | 8/5/19 | Female | Accounting | ||
| Frances | 1 | 1/24/19 | 4/24/19 | Female | Accounting | ||
| Paul | 3 | 2/1/19 | 2/14/20 | Male | Accounting | ||
| Marie | 2 | 2/2/19 | 8/24/19 | Female | Accounting | ||
| Alice | 3 | 2/3/19 | 1/29/20 | Female | Accounting | ||
| Kenneth | 2 | 2/10/19 | 8/26/19 | Male | Accounting | ||
| Albert | 3 | 2/15/19 | 2/13/20 | Male | Accounting | ||
| Eugene | 3 | 2/23/19 | 2/23/20 | Male | Accounting | ||
| Eleanor | 2 | 3/16/19 | 9/11/19 | Female | Accounting | ||
| Gladys | 3 | 3/20/19 | 3/19/20 | Female | Accounting | ||
| Annie | 2 | 3/22/19 | 9/15/19 | Female | Accounting | ||
| Josephine | 1 | 3/26/19 | 8/5/19 | Female | Accounting | ||
| Edna | 1 | 3/31/19 | 6/26/19 | Female | Accounting | ||
| Ernest | 1 | 4/13/19 | 7/12/19 | Male | Accounting | ||
| Gloria | 1 | 4/16/19 | 7/15/19 | Female | Accounting | ||
| Anthony | 2 | 4/18/19 | 10/11/19 | Male | Accounting | ||
| Phyllis | 3 | 4/21/19 | 5/1/20 | Female | Accounting | ||
| Gerald | 1 | 4/25/19 | 7/24/19 | Male | Accounting | ||
| Marion | 3 | 4/30/19 | 5/23/20 | Male | Accounting | ||
| Billy | 3 | 5/1/19 | 4/30/20 | Male | Accounting | ||
| Melvin | 3 | 5/2/19 | 5/25/20 | Male | Accounting | ||
| Warren | 2 | 5/6/19 | 11/6/19 | Male | Accounting | ||
| Esther | 1 | 5/7/19 | 8/5/19 | Female | Accounting | ||
| Leroy | 3 | 5/8/19 | 5/28/20 | Male | Accounting | ||
| Beatrice | 1 | 5/10/19 | 8/7/19 | Female | Accounting | ||
| Lloyd | 1 | 5/21/19 | 9/17/19 | Male | Accounting | ||
| Julia | 1 | 5/28/19 | 9/17/19 | Female | Accounting | ||
| Marian | 2 | 5/31/19 | 12/18/19 | Female | Accounting | ||
| Wayne | 2 | 6/7/19 | 12/8/19 | Male | Accounting | ||
| Audrey | 2 | 6/8/19 | 12/1/19 | Female | Accounting | ||
| Ida | 1 | 6/17/19 | 9/15/19 | Female | Accounting | ||
| Anne | 1 | 6/19/19 | 9/14/19 | Female | Accounting | ||
| Milton | 2 | 6/20/19 | 12/30/19 | Male | Accounting | ||
| Marilyn | 2 | 6/20/19 | 1/14/20 | Female | Accounting | ||
| Pearl | 2 | 7/2/19 | 1/10/20 | Female | Accounting | ||
| Vera | 2 | 7/5/19 | 1/2/20 | Female | Accounting | ||
| Roger | 3 | 7/6/19 | 7/19/20 | Male | Accounting | ||
| Benjamin | 3 | 7/8/19 | 7/7/20 | Male | Accounting | ||
| Arnold | 1 | 7/17/19 | 10/15/19 | Male | Accounting | ||
| Rosemary | 2 | 8/10/19 | 2/16/20 | Female | Accounting | ||
| Curtis | 1 | 8/19/19 | 11/17/19 | Male | Accounting | ||
| Wilbur | 1 | 8/30/19 | 12/2/19 | Male | Accounting | ||
| Leslie | 3 | 9/8/19 | 10/7/20 | Male | Accounting | ||
| Jimmie | 2 | 9/16/19 | 5/1/20 | Male | Accounting | ||
| Christine | 2 | 9/16/19 | 3/9/20 | Female | Accounting | ||
| Sidney | 2 | 9/20/19 | 3/24/20 | Male | Accounting | ||
| Opal | 1 | 9/27/19 | 1/10/20 | Female | Accounting | ||
| Bobby | 1 | 9/28/19 | 12/26/19 | Male | Accounting | ||
| Nicholas | 1 | 9/30/19 | 1/11/20 | Male | Accounting | ||
| Harriet | 2 | 9/30/19 | 3/28/20 | Female | Accounting | ||
| Rosa | 1 | 9/30/19 | 1/8/20 | Female | Accounting | ||
| Bruce | 1 | 10/3/19 | 1/1/20 | Male | Accounting | ||
| Eunice | 3 | 10/4/19 | 10/3/20 | Female | Accounting | ||
| Rudolph | 3 | 10/7/19 | 10/12/20 | Male | Accounting | ||
| Emily | 3 | 10/10/19 | 10/9/20 | Female | Accounting | ||
| Beulah | 2 | 10/13/19 | 4/8/20 | Female | Accounting | ||
| Hilda | 1 | 10/22/19 | 1/20/20 | Female | Accounting | ||
| Steve | 3 | 10/24/19 | 11/5/20 | Male | Accounting | ||
| Anita | 2 | 10/24/19 | 4/19/20 | Female | Accounting | ||
| Johnny | 2 | 10/25/19 | 6/1/20 | Male | Accounting | ||
| Alberta | 3 | 10/30/19 | 10/25/20 | Female | Accounting | ||
| Keith | 3 | 11/2/19 | 11/24/20 | Male | Accounting | ||
| Ben | 3 | 11/9/19 | 11/4/20 | Male | Accounting | ||
| Lula | 2 | 11/10/19 | 5/26/20 | Female | Accounting | ||
| Tony | 3 | 11/13/19 | 11/17/20 | Male | Accounting | ||
| Nathaniel | 2 | 11/17/19 | 5/21/20 | Male | Accounting | ||
| Ada | 3 | 11/20/19 | 11/17/20 | Female | Accounting | ||
| Lola | 1 | 11/29/19 | 3/17/20 | Female | Accounting | ||
| Clayton | 1 | 12/3/19 | 2/26/20 | Male | Accounting | ||
| Mike | 2 | 12/15/19 | 6/18/20 | Male | Accounting | ||
| Sally | 2 | 12/16/19 | 6/25/20 | Female | Accounting | ||
| Bennie | 2 | 12/19/19 | 6/11/20 | Male | Accounting | ||
| Olga | 2 | 12/19/19 | 7/1/20 | Female | Accounting | ||
| Caroline | 3 | 12/21/19 | 12/20/20 | Female | Accounting | ||
| Laverne | 3 | 12/24/19 | 1/10/21 | Female | Accounting | ||
| Sophie | 1 | 12/27/19 | 4/2/20 | Female | Accounting | ||
| Dorothy | 3 | 1/8/19 | 1/2/20 | Female | Engineering | ||
| Joseph | 2 | 1/15/19 | 7/10/19 | Male | Engineering | ||
| Richard | 3 | 1/21/19 | 1/20/20 | Male | Engineering | ||
| Evelyn | 1 | 1/29/19 | 4/26/19 | Female | Engineering | ||
| Shirley | 2 | 2/7/19 | 8/2/19 | Female | Engineering | ||
| Florence | 3 | 2/19/19 | 2/15/20 | Female | Engineering | ||
| Martha | 2 | 2/22/19 | 8/14/19 | Female | Engineering | ||
| Rose | 3 | 2/23/19 | 2/18/20 | Female | Engineering | ||
| Howard | 1 | 3/5/19 | 5/28/19 | Male | Engineering | ||
| Louise | 1 | 3/6/19 | 5/30/19 | Female | Engineering | ||
| Catherine | 1 | 3/7/19 | 6/4/19 | Female | Engineering | ||
| Willie | 3 | 3/11/19 | 3/4/20 | Male | Engineering | ||
| Ruby | 2 | 3/13/19 | 9/7/19 | Female | Engineering | ||
| Patricia | 3 | 3/19/19 | 3/11/20 | Female | Engineering | ||
| Fred | 3 | 3/24/19 | 3/20/20 | Male | Engineering | ||
| Francis | 1 | 3/27/19 | 6/19/19 | Male | Engineering | ||
| Lucille | 3 | 4/11/19 | 4/7/20 | Female | Engineering | ||
| Alfred | 1 | 4/16/19 | 7/14/19 | Male | Engineering | ||
| Daniel | 1 | 4/27/19 | 7/25/19 | Male | Engineering | ||
| June | 3 | 4/27/19 | 4/19/20 | Female | Engineering | ||
| Samuel | 1 | 4/28/19 | 7/23/19 | Male | Engineering | ||
| Dolores | 1 | 5/1/19 | 7/27/19 | Female | Engineering | ||
| Lorraine | 3 | 5/4/19 | 4/28/20 | Female | Engineering | ||
| Russell | 1 | 5/10/19 | 8/8/19 | Male | Engineering | ||
| Leo | 3 | 5/13/19 | 5/5/20 | Male | Engineering | ||
| Jane | 3 | 5/15/19 | 5/9/20 | Female | Engineering | ||
| Edwin | 3 | 5/16/19 | 5/11/20 | Male | Engineering | ||
| Geraldine | 3 | 5/16/19 | 5/15/20 | Female | Engineering | ||
| Joyce | 3 | 5/22/19 | 5/15/20 | Female | Engineering | ||
| Nancy | 3 | 5/24/19 | 5/21/20 | Female | Engineering | ||
| Gertrude | 1 | 5/26/19 | 8/24/19 | Female | Engineering | ||
| Katherine | 1 | 5/26/19 | 8/20/19 | Female | Engineering | ||
| Elsie | 1 | 5/27/19 | 8/22/19 | Female | Engineering | ||
| Herman | 1 | 5/29/19 | 8/27/19 | Male | Engineering | ||
| Clyde | 3 | 5/30/19 | 5/26/20 | Male | Engineering | ||
| Gordon | 3 | 6/9/19 | 6/2/20 | Male | Engineering | ||
| Lewis | 2 | 6/12/19 | 12/5/19 | Male | Engineering | ||
| Wanda | 2 | 6/12/19 | 12/3/19 | Female | Engineering | ||
| Glenn | 3 | 6/14/19 | 6/7/20 | Male | Engineering | ||
| Martin | 3 | 6/19/19 | 6/13/20 | Male | Engineering | ||
| Lee | 3 | 6/22/19 | 6/18/20 | Male | Engineering | ||
| Dale | 2 | 6/26/19 | 12/23/19 | Male | Engineering | ||
| Viola | 1 | 6/29/19 | 9/27/19 | Female | Engineering | ||
| Bill | 1 | 7/1/19 | 9/27/19 | Male | Engineering | ||
| Alma | 1 | 7/8/19 | 9/30/19 | Female | Engineering | ||
| Allen | 3 | 7/15/19 | 7/11/20 | Male | Engineering | ||
| Nellie | 2 | 7/15/19 | 1/5/20 | Female | Engineering | ||
| Jessie | 2 | 7/20/19 | 1/16/20 | Male | Engineering | ||
| Oscar | 3 | 7/26/19 | 7/22/20 | Male | Engineering | ||
| Johnnie | 2 | 8/6/19 | 1/26/20 | Male | Engineering | ||
| Eddie | 3 | 8/12/19 | 8/8/20 | Male | Engineering | ||
| Maurice | 3 | 8/18/19 | 8/17/20 | Male | Engineering | ||
| Virgil | 2 | 8/26/19 | 2/21/20 | Male | Engineering | ||
| Geneva | 2 | 8/28/19 | 2/24/20 | Female | Engineering | ||
| Stephen | 1 | 9/1/19 | 11/28/19 | Male | Engineering | ||
| Lena | 1 | 9/8/19 | 11/30/19 | Female | Engineering | ||
| Mae | 3 | 9/10/19 | 9/9/20 | Female | Engineering | ||
| Maria | 1 | 9/14/19 | 12/9/19 | Female | Engineering | ||
| Morris | 3 | 9/23/19 | 9/22/20 | Male | Engineering | ||
| Bob | 3 | 9/28/19 | 9/24/20 | Male | Engineering | ||
| Junior | 3 | 10/5/19 | 10/1/20 | Male | Engineering | ||
| Wesley | 3 | 10/6/19 | 10/3/20 | Male | Engineering | ||
| Jeanette | 1 | 10/6/19 | 12/30/19 | Female | Engineering | ||
| Alexander | 1 | 10/10/19 | 1/2/20 | Male | Engineering | ||
| Billie | 3 | 10/13/19 | 10/11/20 | Male | Engineering | ||
| Willis | 2 | 10/21/19 | 4/16/20 | Male | Engineering | ||
| Delores | 2 | 11/4/19 | 4/25/20 | Female | Engineering | ||
| Irvin | 2 | 11/17/19 | 5/10/20 | Male | Engineering | ||
| Jimmy | 2 | 11/17/19 | 5/12/20 | Male | Engineering | ||
| Lyle | 1 | 11/17/19 | 2/9/20 | Male | Engineering | ||
| Constance | 2 | 11/17/19 | 5/12/20 | Female | Engineering | ||
| Madeline | 3 | 11/17/19 | 11/16/20 | Female | Engineering | ||
| Rachel | 3 | 12/5/19 | 11/28/20 | Female | Engineering | ||
| Alex | 3 | 12/9/19 | 12/6/20 | Male | Engineering | ||
| Flora | 1 | 12/11/19 | 3/10/20 | Female | Engineering | ||
| Marcella | 2 | 12/17/19 | 7/3/20 | Female | Engineering | ||
| Matthew | 1 | 12/21/19 | 4/9/20 | Male | Engineering | ||
| George | 1 | 1/13/19 | 4/13/19 | Male | HR | ||
| Virginia | 2 | 1/16/19 | 7/16/19 | Female | HR | ||
| Frank | 1 | 1/29/19 | 4/29/19 | Male | HR | ||
| Marjorie | 3 | 2/14/19 | 3/6/20 | Female | HR | ||
| David | 3 | 2/19/19 | 2/19/20 | Male | HR | ||
| Lillian | 1 | 3/2/19 | 6/20/19 | Female | HR | ||
| Carl | 3 | 3/7/19 | 3/5/20 | Male | HR | ||
| Earl | 2 | 3/20/19 | 9/14/19 | Male | HR | ||
| Roy | 3 | 3/21/19 | 3/26/20 | Male | HR | ||
| Joe | 1 | 3/27/19 | 8/4/19 | Male | HR | ||
| Thelma | 1 | 3/27/19 | 7/5/19 | Female | HR | ||
| Pauline | 2 | 4/7/19 | 10/12/19 | Female | HR | ||
| Stanley | 1 | 4/20/19 | 7/28/19 | Male | HR | ||
| Grace | 3 | 4/25/19 | 4/24/20 | Female | HR | ||
| Rita | 1 | 5/3/19 | 8/13/19 | Female | HR | ||
| Andrew | 1 | 5/15/19 | 8/12/19 | Male | HR | ||
| Peter | 3 | 5/18/19 | 6/1/20 | Male | HR | ||
| Emma | 1 | 5/18/19 | 8/16/19 | Female | HR | ||
| Sarah | 3 | 5/18/19 | 5/24/20 | Female | HR | ||
| Clifford | 3 | 5/27/19 | 5/22/20 | Male | HR | ||
| Philip | 2 | 6/1/19 | 12/6/19 | Male | HR | ||
| Bertha | 2 | 6/2/19 | 11/27/19 | Female | HR | ||
| Willie | 1 | 6/4/19 | 9/6/19 | Male | HR | ||
| Vincent | 1 | 6/8/19 | 9/7/19 | Male | HR | ||
| Elaine | 3 | 6/18/19 | 6/17/20 | Female | HR | ||
| Cecil | 1 | 6/27/19 | 9/23/19 | Male | HR | ||
| Kathleen | 1 | 6/27/19 | 10/12/19 | Female | HR | ||
| Wallace | 3 | 7/9/19 | 7/9/20 | Male | HR | ||
| Sam | 2 | 7/14/19 | 1/19/20 | Male | HR | ||
| Edgar | 2 | 7/23/19 | 1/16/20 | Male | HR | ||
| Jeanne | 3 | 7/23/19 | 7/22/20 | Female | HR | ||
| Gene | 1 | 7/29/19 | 10/27/19 | Male | HR | ||
| Jerry | 1 | 8/1/19 | 12/10/19 | Male | HR | ||
| Douglas | 2 | 8/4/19 | 1/31/20 | Male | HR | ||
| Mattie | 1 | 8/15/19 | 12/10/19 | Female | HR | ||
| Everett | 2 | 8/16/19 | 2/12/20 | Male | HR | ||
| Margie | 1 | 8/16/19 | 11/30/19 | Female | HR | ||
| Genevieve | 2 | 8/19/19 | 2/15/20 | Female | HR | ||
| Janet | 3 | 8/24/19 | 8/23/20 | Female | HR | ||
| Jerome | 1 | 9/5/19 | 1/9/20 | Male | HR | ||
| Carolyn | 1 | 9/9/19 | 12/6/19 | Female | HR | ||
| Jose | 1 | 9/15/19 | 2/2/20 | Male | HR | ||
| Marguerite | 2 | 9/24/19 | 4/10/20 | Female | HR | ||
| Loretta | 2 | 9/28/19 | 4/14/20 | Female | HR | ||
| Carrie | 1 | 10/10/19 | 1/3/20 | Female | HR | ||
| Dora | 2 | 10/16/19 | 4/13/20 | Female | HR | ||
| Horace | 2 | 10/17/19 | 4/14/20 | Male | HR | ||
| Julius | 1 | 10/31/19 | 2/25/20 | Male | HR | ||
| Oliver | 1 | 11/4/19 | 2/13/20 | Male | HR | ||
| Dewey | 3 | 11/11/19 | 11/8/20 | Male | HR | ||
| Verna | 1 | 11/12/19 | 2/11/20 | Female | HR | ||
| Marshall | 1 | 11/17/19 | 3/6/20 | Male | HR | ||
| Guy | 2 | 11/19/19 | 5/17/20 | Male | HR | ||
| Salvatore | 1 | 11/19/19 | 2/23/20 | Male | HR | ||
| Billie | 1 | 11/29/19 | 2/27/20 | Male | HR | ||
| Phillip | 3 | 12/2/19 | 12/10/20 | Male | HR | ||
| Otis | 3 | 12/5/19 | 12/16/20 | Male | HR | ||
| Archie | 2 | 12/7/19 | 5/31/20 | Male | HR | ||
| Mable | 2 | 12/8/19 | 6/24/20 | Female | HR | ||
| Daisy | 3 | 12/14/19 | 12/13/20 | Female | HR | ||
| Jacob | 3 | 12/16/19 | 12/15/20 | Male | HR | ||
| Clifton | 1 | 12/17/19 | 3/14/20 | Male | HR | ||
| Bette | 2 | 12/18/19 | 6/12/20 | Female | HR | ||
| Clinton | 2 | 12/26/19 | 6/19/20 | Male | HR | ||
| Dennis | 3 | 12/28/19 | 12/26/20 | Male | HR | ||
| Rebecca | 2 | 12/29/19 | 7/9/20 | Female | HR | ||
| Charles | 3 | 1/12/19 | 1/8/20 | Male | Marketing | ||
| Ruth | 3 | 1/14/19 | 1/25/20 | Female | Marketing | ||
| Donald | 3 | 1/24/19 | 1/21/20 | Male | Marketing | ||
| Thomas | 2 | 1/26/19 | 8/3/19 | Male | Marketing | ||
| Harold | 2 | 1/29/19 | 7/28/19 | Male | Marketing | ||
| Walter | 2 | 2/3/19 | 8/3/19 | Male | Marketing | ||
| Arthur | 2 | 2/13/19 | 8/11/19 | Male | Marketing | ||
| Irene | 2 | 2/13/19 | 8/12/19 | Female | Marketing | ||
| Harry | 1 | 2/21/19 | 5/22/19 | Male | Marketing | ||
| Ralph | 2 | 2/26/19 | 9/7/19 | Male | Marketing | ||
| Clarence | 3 | 3/17/19 | 3/12/20 | Male | Marketing | ||
| Lawrence | 3 | 3/31/19 | 4/22/20 | Male | Marketing | ||
| Norma | 3 | 3/31/19 | 4/14/20 | Female | Marketing | ||
| Herbert | 3 | 4/5/19 | 4/4/20 | Male | Marketing | ||
| Leonard | 3 | 4/8/19 | 4/24/20 | Male | Marketing | ||
| Ethel | 1 | 4/19/19 | 7/18/19 | Female | Marketing | ||
| Norman | 2 | 4/24/19 | 11/3/19 | Male | Marketing | ||
| Hazel | 3 | 4/26/19 | 4/25/20 | Female | Marketing | ||
| Bernice | 3 | 4/29/19 | 4/25/20 | Female | Marketing | ||
| Marvin | 2 | 5/4/19 | 11/23/19 | Male | Marketing | ||
| Michael | 2 | 5/6/19 | 11/15/19 | Male | Marketing | ||
| Ann | 2 | 5/6/19 | 11/1/19 | Female | Marketing | ||
| Juanita | 1 | 5/12/19 | 9/8/19 | Female | Marketing | ||
| Floyd | 3 | 5/20/19 | 5/19/20 | Male | Marketing | ||
| Joan | 3 | 5/21/19 | 6/30/20 | Female | Marketing | ||
| Ray | 3 | 5/22/19 | 6/1/20 | Male | Marketing | ||
| Frederick | 2 | 5/24/19 | 11/20/19 | Male | Marketing | ||
| Vernon | 2 | 5/27/19 | 11/26/19 | Male | Marketing | ||
| Wilma | 3 | 5/30/19 | 5/31/20 | Female | Marketing | ||
| Chester | 2 | 5/31/19 | 11/26/19 | Male | Marketing | ||
| Alvin | 1 | 6/4/19 | 8/28/19 | Male | Marketing | ||
| Lester | 2 | 6/4/19 | 12/18/19 | Male | Marketing | ||
| Theresa | 3 | 6/8/19 | 6/20/20 | Female | Marketing | ||
| Vivian | 2 | 6/10/19 | 12/12/19 | Female | Marketing | ||
| Laura | 3 | 6/13/19 | 7/10/20 | Female | Marketing | ||
| Charlotte | 1 | 6/14/19 | 9/9/19 | Female | Marketing | ||
| Calvin | 3 | 6/18/19 | 6/16/20 | Male | Marketing | ||
| Kathryn | 1 | 6/25/19 | 10/12/19 | Female | Marketing | ||
| Jesse | 2 | 6/26/19 | 1/27/20 | Male | Marketing | ||
| Victor | 1 | 7/7/19 | 10/6/19 | Male | Marketing | ||
| Myrtle | 2 | 7/7/19 | 1/9/20 | Female | Marketing | ||
| Ronald | 3 | 7/12/19 | 7/26/20 | Male | Marketing | ||
| Violet | 1 | 7/13/19 | 10/12/19 | Female | Marketing | ||
| Ella | 1 | 7/16/19 | 10/14/19 | Female | Marketing | ||
| Lillie | 3 | 7/18/19 | 8/8/20 | Female | Marketing | ||
| Gilbert | 2 | 7/21/19 | 1/17/20 | Male | Marketing | ||
| Ellen | 2 | 7/29/19 | 1/25/20 | Female | Marketing | ||
| Minnie | 2 | 8/3/19 | 2/9/20 | Female | Marketing | ||
| Sylvia | 2 | 8/6/19 | 2/14/20 | Female | Marketing | ||
| Leona | 3 | 8/9/19 | 9/1/20 | Female | Marketing | ||
| Marion | 2 | 8/22/19 | 3/14/20 | Male | Marketing | ||
| Manuel | 3 | 8/31/19 | 9/17/20 | Male | Marketing | ||
| Georgia | 1 | 8/31/19 | 11/29/19 | Female | Marketing | ||
| Homer | 3 | 9/8/19 | 9/7/20 | Male | Marketing | ||
| Hugh | 1 | 9/24/19 | 12/23/19 | Male | Marketing | ||
| Luther | 3 | 10/1/19 | 10/20/20 | Male | Marketing | ||
| Muriel | 2 | 10/3/19 | 4/8/20 | Female | Marketing | ||
| Franklin | 3 | 10/12/19 | 10/11/20 | Male | Marketing | ||
| Patrick | 2 | 10/23/19 | 5/4/20 | Male | Marketing | ||
| Jacqueline | 3 | 10/26/19 | 10/25/20 | Female | Marketing | ||
| Dean | 1 | 10/29/19 | 1/26/20 | Male | Marketing | ||
| Fannie | 2 | 11/6/19 | 5/4/20 | Female | Marketing | ||
| Hattie | 3 | 11/8/19 | 11/7/20 | Female | Marketing | ||
| Alton | 1 | 11/9/19 | 2/7/20 | Male | Marketing | ||
| Dan | 2 | 11/10/19 | 5/4/20 | Male | Marketing | ||
| Ervin | 2 | 11/13/19 | 5/11/20 | Male | Marketing | ||
| Cora | 3 | 11/13/19 | 11/8/20 | Female | Marketing | ||
| Edmund | 2 | 11/17/19 | 5/14/20 | Male | Marketing | ||
| Jay | 1 | 11/17/19 | 2/15/20 | Male | Marketing | ||
| Larry | 3 | 11/19/19 | 12/18/20 | Male | Marketing | ||
| Leland | 2 | 11/19/19 | 6/12/20 | Male | Marketing | ||
| Delbert | 1 | 11/24/19 | 2/19/20 | Male | Marketing | ||
| Rosie | 1 | 12/3/19 | 3/14/20 | Female | Marketing | ||
| Erma | 1 | 12/4/19 | 3/3/20 | Female | Marketing | ||
| Angelo | 3 | 12/13/19 | 12/11/20 | Male | Marketing | ||
| Duane | 1 | 12/23/19 | 3/22/20 | Male | Marketing | ||
| John | 2 | 1/5/19 | 7/1/19 | Male | Supply Chain | ||
| Helen | 1 | 1/8/19 | 4/8/19 | Female | Supply Chain | ||
| Betty | 3 | 1/11/19 | 1/6/20 | Female | Supply Chain | ||
| Edward | 3 | 1/22/19 | 1/18/20 | Male | Supply Chain | ||
| Elizabeth | 2 | 1/27/19 | 7/23/19 | Female | Supply Chain | ||
| Anna | 1 | 1/31/19 | 4/26/19 | Female | Supply Chain | ||
| Raymond | 3 | 2/2/19 | 1/30/20 | Male | Supply Chain | ||
| Jean | 3 | 2/5/19 | 2/5/20 | Female | Supply Chain | ||
| Jack | 2 | 2/6/19 | 8/5/19 | Male | Supply Chain | ||
| Henry | 3 | 2/9/19 | 2/9/20 | Male | Supply Chain | ||
| Barbara | 1 | 2/10/19 | 5/10/19 | Female | Supply Chain | ||
| Lois | 2 | 2/21/19 | 8/17/19 | Female | Supply Chain | ||
| Louis | 3 | 3/14/19 | 3/10/20 | Male | Supply Chain | ||
| Edith | 2 | 4/14/19 | 10/9/19 | Female | Supply Chain | ||
| Bernard | 2 | 4/30/19 | 10/26/19 | Male | Supply Chain | ||
| Clara | 3 | 5/14/19 | 5/8/20 | Female | Supply Chain | ||
| Elmer | 3 | 5/17/19 | 5/16/20 | Male | Supply Chain | ||
| Theodore | 1 | 5/26/19 | 8/21/19 | Male | Supply Chain | ||
| Agnes | 1 | 5/30/19 | 8/23/19 | Female | Supply Chain | ||
| Eva | 1 | 6/4/19 | 9/2/19 | Female | Supply Chain | ||
| Leon | 3 | 6/10/19 | 6/27/20 | Male | Supply Chain | ||
| Charlie | 1 | 6/14/19 | 9/10/19 | Male | Supply Chain | ||
| Maxine | 3 | 6/26/19 | 7/24/20 | Female | Supply Chain | ||
| Harvey | 2 | 7/4/19 | 12/31/19 | Male | Supply Chain | ||
| Bessie | 3 | 7/6/19 | 7/5/20 | Female | Supply Chain | ||
| Beverly | 2 | 7/12/19 | 1/8/20 | Female | Supply Chain | ||
| Willard | 1 | 7/18/19 | 10/20/19 | Male | Supply Chain | ||
| Eileen | 3 | 7/25/19 | 7/19/20 | Female | Supply Chain | ||
| Lucy | 3 | 7/30/19 | 8/21/20 | Female | Supply Chain | ||
| Claude | 2 | 8/7/19 | 1/29/20 | Male | Supply Chain | ||
| Donna | 1 | 8/7/19 | 10/31/19 | Female | Supply Chain | ||
| Don | 3 | 8/10/19 | 8/9/20 | Male | Supply Chain | ||
| Roland | 1 | 8/13/19 | 11/23/19 | Male | Supply Chain | ||
| Stella | 2 | 8/13/19 | 2/17/20 | Female | Supply Chain | ||
| Mabel | 1 | 8/21/19 | 12/19/19 | Female | Supply Chain | ||
| Bonnie | 3 | 9/1/19 | 8/31/20 | Female | Supply Chain | ||
| Carol | 1 | 9/4/19 | 12/2/19 | Female | Supply Chain | ||
| Velma | 2 | 9/7/19 | 3/10/20 | Female | Supply Chain | ||
| Glen | 2 | 9/9/19 | 3/7/20 | Male | Supply Chain | ||
| Jessie | 2 | 9/10/19 | 4/10/20 | Male | Supply Chain | ||
| Jennie | 1 | 9/10/19 | 12/9/19 | Female | Supply Chain | ||
| Hubert | 3 | 9/13/19 | 9/12/20 | Male | Supply Chain | ||
| Arlene | 1 | 9/19/19 | 12/17/19 | Female | Supply Chain | ||
| Peggy | 1 | 9/22/19 | 12/18/19 | Female | Supply Chain | ||
| Max | 1 | 9/27/19 | 1/23/20 | Male | Supply Chain | ||
| Sara | 3 | 9/28/19 | 10/11/20 | Female | Supply Chain | ||
| Blanche | 3 | 10/7/19 | 10/4/20 | Female | Supply Chain | ||
| Irving | 3 | 10/13/19 | 10/12/20 | Male | Supply Chain | ||
| Tom | 1 | 10/13/19 | 1/26/20 | Male | Supply Chain | ||
| Roberta | 2 | 10/17/19 | 4/11/20 | Female | Supply Chain | ||
| Naomi | 2 | 10/24/19 | 4/18/20 | Female | Supply Chain | ||
| Inez | 2 | 11/1/19 | 4/29/20 | Female | Supply Chain | ||
| Earnest | 2 | 11/7/19 | 5/3/20 | Male | Supply Chain | ||
| Jim | 3 | 11/11/19 | 11/7/20 | Male | Supply Chain | ||
| Emil | 3 | 11/12/19 | 11/11/20 | Male | Supply Chain | ||
| Ira | 1 | 11/13/19 | 2/11/20 | Male | Supply Chain | ||
| Lowell | 3 | 11/13/19 | 11/9/20 | Male | Supply Chain | ||
| Ivan | 3 | 11/17/19 | 11/16/20 | Male | Supply Chain | ||
| Merle | 3 | 11/17/19 | 12/11/20 | Male | Supply Chain | ||
| Miriam | 3 | 11/19/19 | 11/15/20 | Female | Supply Chain | ||
| Orville | 1 | 11/21/19 | 3/2/20 | Male | Supply Chain | ||
| Claire | 2 | 11/24/19 | 5/17/20 | Female | Supply Chain | ||
| Mamie | 2 | 11/24/19 | 5/19/20 | Female | Supply Chain | ||
| Wilbert | 2 | 12/28/19 | 6/22/20 | Male | Supply Chain | ||
| Nora | 2 | 12/28/19 | 6/22/20 | Female | Supply Chain |
Review Cycle
| Hire Status | Review Cycle Days |
| 1 | 90 |
| 2 | 180 |
| 3 | 365 |
Instructions
| Determine the Review Due date based on the employees hire date and status |
| Based on the actual review date compared to the due date, identify the status as "On Time" or "Late" |
| Create (4) Pivot Charts & Pivot Tables for the following KPIs (Place on a new sheet titled "Analysis") |
| Number of On Time and Number of Late per each Department |
| Number of On Time and Number late by Gender, include data labels, Hide Field Buttons: See Sample |
| Number of On Time and Number Late by department and by Gender |
| Percent On Time and Late within each department by Gender: See Sample |
| In a two page Word paper, summarize your findings. At a minimum include: |
| Which departments are performing well and which are not. |
| Within each department, does there appear to be a discrepancy between male & female. |
| Include at least one graphic pasted into your Word file. |
| For the departments not performing well, what actions would you recommend to get their |
| Performance reviews completed on time? |
| CAUTION: If you state that you would pay managers more or give them a bonus for doing the job |
| they are already being paid to do, I WILL GIVE YOU AN "F" ON THIS ASSIGNMENT. Find another |
| way to incentivize your managers. |
| Alternate: |
| On at least 4 PowerPoint slides summarize your findings. At a minimum include: |
| Which departments are performing well and which are not. |
| Within each department, does there appear to be a discrepancy between male & female. |
| Include at least all 4 graphic pasted into your PowerPoint file. |
| For the departments not performing well, what actions would you recommend to get their |
| Performance reviews completed on time? |
| CAUTION: If you state that you would pay managers more or give them a bonus for doing the job |
| they are already being paid to do, I WILL GIVE YOU AN "F" ON THIS ASSIGNMENT. Find another |
| way to incentivize your managers. |
