D28 fx Human Resources A B D E F G H I L M N P a R S T U V Answers: a b(# of employees) b($) c(#) c($) Average Salary Gender Clearance M M N Birth Date 03/04/61 04/29/67 08/22/58 08/20/70 02/04/69 N F F N M S 12/22/58 F S F C M S M N F TS M S F TS . Last Name Department Title Salary Grundies Marketing CSR $ 38,900.00 Gomez Marketing CSR $ 43,500.00 Flintsteel Marketing Staff $ 34,500.00 Andretti Marketing CSR $ 42,500.00 Manispour Engineering Security Engineer $ 45,600.00 Kurzweil Management Manager $ 63,000.00 Grabowski Management Manager $ 75,700.00 Van Horn Management Manager $ 66,500.00 Lambros CSR $ 41,000.00 English Management Manager $ 56,400.00 Rothrock Engineering Security Engineer $53,300.00 Cushner Management Staff $ 32,000.00 Pacioli Marketing Staff $ 42,300.00 Chang Engineering Security Engineer $ 46,540.00 Mehta Engineering Security Engineer $ 65,000.00 Detweiler Engineering Security Engineer $ 56,700.00 Yamamoto Engineering Security Engineer $ 49,600.00 Zumkowski Engineering Staff $ 33,000.00 Leonard Engineering Security Engineer $ 59,800.00 Gates Engineering Security Engineer $ 66,300.00 Goldstein Engineering Security Engineer $ 51,000.00 Stonesifer Engineering Security Engineer $ 64,300.00 Paterno Marketing Staff $ 32,000.00 Bednarczyk Engineering Security Engineer $ 56,700.00 Ortega-Molina Engineering Security Engineer $ 46,000.00 Kartashev Human Resources Staff $ 38,000.00 Rovik Human Resources Manager $ 43,000.00 2 ID First Name 3 1009 Kevin 1016 Oscar 1032 Hillary 1042 Maria 1119 Sharad 3 1173 Roberta 1355 Barbara 0 1441 James 1 1614 Artie 2 1851 Melinda 3 2002 Edgar 4 2042 Hillary 5 2105 Luca 6 2122 Yuan 7 2344 Nemesha 8 2451 Francine 9 2678 Koshi 0 2733 John 1 2768 Phyllis 2 2896 Samuel 3 2956 Michael 4 3015 Patti 5 3043 Joseph 6 3117 Frederich 7 3210 Carmen 8 3314 Svetlana 9 4006 Alice 0 1 Hire Date 12/24/89 02/16/90 03/21/90 03/21/90 10/13/90 06/16/92 10/13/92 12/18/92 05/16/93 10/01/93 02/08/94 08/26/94 08/26/95 09/05/95 10/01/95 10/10/95 11/16/95 04/18/96 12/13/96 01/28/97 04/11/97 07/06/98 07/06/98 05/14/99 09/16/99 11/05/01 12/01/01 S TS M F S Table: Q3. Securelt, Inc., is a small computer security contractor that provides computer security analysis, design, and software implementation for commercial clients. Almost all of Securell's work requires access to classified material or confidential company documents. Consequently, all of the security personnel have clearances of either Secret or Top Secret. Some have even higher clearances for work that involves so-called black box security work. You have been provided with a sample worksheet, Employee Data, to assist Securell with producing several worksheet summaries. Convert the data in the Employee database, and use table-based calculation to find out a. How many female employees are in the engineering department and classified as secret (S) b. How many male Security Engineer are in the engineering department, and find out the total salary for this group c. How many employees with the title of security engineer have a salary higher than the average employee salary? Find out the total salary for this group F 04/10/65 02/03/58 07/13/70 02/14/56 03/21/70 05/06/61 05/06/70 03/04/64 02/12/65 04/29/70 01/24/63 12/12/72 07/02/70 04/10/74 03/07/63 03/10/66 03/10/68 05/27/70 03/28/52 05/03/82 01/26/55 S F S M TS F TS M S M TS F S . N S M F S F N M S Paste 2 3 4 5 D28 fx Human Resources A B D E F G H I L M N P a R S T U V Answers: a b(# of employees) b($) c(#) c($) Average Salary Gender Clearance M M N Birth Date 03/04/61 04/29/67 08/22/58 08/20/70 02/04/69 N F F N M S 12/22/58 F S F C M S M N F TS M S F TS . Last Name Department Title Salary Grundies Marketing CSR $ 38,900.00 Gomez Marketing CSR $ 43,500.00 Flintsteel Marketing Staff $ 34,500.00 Andretti Marketing CSR $ 42,500.00 Manispour Engineering Security Engineer $ 45,600.00 Kurzweil Management Manager $ 63,000.00 Grabowski Management Manager $ 75,700.00 Van Horn Management Manager $ 66,500.00 Lambros CSR $ 41,000.00 English Management Manager $ 56,400.00 Rothrock Engineering Security Engineer $53,300.00 Cushner Management Staff $ 32,000.00 Pacioli Marketing Staff $ 42,300.00 Chang Engineering Security Engineer $ 46,540.00 Mehta Engineering Security Engineer $ 65,000.00 Detweiler Engineering Security Engineer $ 56,700.00 Yamamoto Engineering Security Engineer $ 49,600.00 Zumkowski Engineering Staff $ 33,000.00 Leonard Engineering Security Engineer $ 59,800.00 Gates Engineering Security Engineer $ 66,300.00 Goldstein Engineering Security Engineer $ 51,000.00 Stonesifer Engineering Security Engineer $ 64,300.00 Paterno Marketing Staff $ 32,000.00 Bednarczyk Engineering Security Engineer $ 56,700.00 Ortega-Molina Engineering Security Engineer $ 46,000.00 Kartashev Human Resources Staff $ 38,000.00 Rovik Human Resources Manager $ 43,000.00 2 ID First Name 3 1009 Kevin 1016 Oscar 1032 Hillary 1042 Maria 1119 Sharad 3 1173 Roberta 1355 Barbara 0 1441 James 1 1614 Artie 2 1851 Melinda 3 2002 Edgar 4 2042 Hillary 5 2105 Luca 6 2122 Yuan 7 2344 Nemesha 8 2451 Francine 9 2678 Koshi 0 2733 John 1 2768 Phyllis 2 2896 Samuel 3 2956 Michael 4 3015 Patti 5 3043 Joseph 6 3117 Frederich 7 3210 Carmen 8 3314 Svetlana 9 4006 Alice 0 1 Hire Date 12/24/89 02/16/90 03/21/90 03/21/90 10/13/90 06/16/92 10/13/92 12/18/92 05/16/93 10/01/93 02/08/94 08/26/94 08/26/95 09/05/95 10/01/95 10/10/95 11/16/95 04/18/96 12/13/96 01/28/97 04/11/97 07/06/98 07/06/98 05/14/99 09/16/99 11/05/01 12/01/01 S TS M F S Table: Q3. Securelt, Inc., is a small computer security contractor that provides computer security analysis, design, and software implementation for commercial clients. Almost all of Securell's work requires access to classified material or confidential company documents. Consequently, all of the security personnel have clearances of either Secret or Top Secret. Some have even higher clearances for work that involves so-called black box security work. You have been provided with a sample worksheet, Employee Data, to assist Securell with producing several worksheet summaries. Convert the data in the Employee database, and use table-based calculation to find out a. How many female employees are in the engineering department and classified as secret (S) b. How many male Security Engineer are in the engineering department, and find out the total salary for this group c. How many employees with the title of security engineer have a salary higher than the average employee salary? Find out the total salary for this group F 04/10/65 02/03/58 07/13/70 02/14/56 03/21/70 05/06/61 05/06/70 03/04/64 02/12/65 04/29/70 01/24/63 12/12/72 07/02/70 04/10/74 03/07/63 03/10/66 03/10/68 05/27/70 03/28/52 05/03/82 01/26/55 S F S M TS F TS M S M TS F S . N S M F S F N M S Paste 2 3 4 5