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.
Thank you for the opportunity to help you with your question!
Designing the worksheet this way –
separating the data gathered per HBCU – makes data manipulation and hence, information
analysis a bit difficult. Hence, I suggest that Dr. Karl Ware integrates
everything into one single worksheet AND adding a column for the HBCU that the
30 Florida residents and prelaw students went or going to. This way it is easy
to compare which HBCU is preferred, which HBCU ‘gives’ higher GPAs, etc.
Please let me know if you need any clarification. I'm always happy to answer your questions.