Part 1: Given the Professor\'s needs, summarize how he can consolidate this data

Question

Part 1: Given the Professor's needs, summarize how he can consolidate this data to output average GPA, minimum, and maximum GPA

Part 2: Partition the diversity of females, males, Fluent Languages, and Veterans

Part 3: Display the ethnicity groups in the context of law specialty to promote diversity and inclusion in column charts.

Question 4. 4. (TCO 5) Dr. Karl Ware is a Professor of Business Law at DeVry/ Keller University and has recruited "30" Florida Residents and Prelaw Students from "3" Florida Historically Black Colleges and Universities (HBCUs) to get GPA, Veteran Status, Major, Demographic Data (such as Ethnic Background, Sex, Fluent Languages, and Law Specialty Interest: Forensics, Criminal, Family, etc. He currently has the data saved in a Microsoft Excel workbook with data from each HBCU on a separate worksheet.

Part 1: Given the Professor's needs, summarize how he can consolidate this data to output average GPA, minimum, and maximum GPA

Part 2: Partition the diversity of females, males, Fluent Languages, and Veterans

Part 3: Display the ethnicity groups in the context of law specialty to promote diversity and inclusion in column charts.

Explanation / Answer

Given Information :

Dr. Karl Ware = Professor of Business Law at DeVry/ Keller University

Task : Recruited "30" Florida Residents and Pre law Students

Name of the college & University : "3" Florida Historically Black Colleges and Universities (HBCUs)

Following aspects are important from student point of view :

GPA

Veteran Status

Major

Demographic Data (such as Ethnic Background, Sex,

Fluent Languages,

Law Specialty Interest

Forensics, Criminal

Family,

Following is the model of spreadsheet.

Part 1: Given the Professor's needs, summarize how he can consolidate this data to output average GPA, minimum, and maximum GPA

Part 2: Partition the diversity of females, males, Fluent Languages, and Veterans

Part 3: Display the ethnicity groups in the context of law specialty to promote diversity and inclusion in column charts.

Now all above information which is feed in speardsheet this information is helpful for follwing points.

1 ) To know details about the recruited candidate

2) Backgroundof students

3) % of Male & Female

4) Location wise details

5) Sutabilty of the candidate for desired profile

Sperad Sheet Data For 30 Recruited Students Sr.No Student Name GPA Veteran Status Major Demographic Data Fluent Languages, Law Specialty Interest Forensics Criminal Family Ethnic Background Sex 1 A 2 B 3 C 4 D 5 E 6 F 7 G 8 H 9 I 10 J 11 K 12 L 13 M 14 N 15 O 16 P 17 Q 18 R 19 S 20 T 21 U 22 V 23 W 24 X 25 Y 26 Z 27 AA 28 AB 29 AC 30 AD

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---