Practice Module 5 – Access (Data Analytics)

Provide an analysis and summary that compares the average number of students enrolled for classes taught by Conor Horn and Naomi Russell vs. all other professors. (It is important to note that the number of students enrolled is different than the MaxEnrollment field in the Class table.) To calculate the average actual enrollment, you must first determine the total number of students enrolled for Conor Horn and Naomi Russell classes and all other professors’ classes, and then calculate the average across all Conor Horn and Naomi Russell classes and the average across all other professors’ classes.

Provide an analysis and summary that computes the grade point average between students from OH vs. students from IN for the graduation years of 2024 and 2027. This data will be used to assess the overall improvements made since the creation of Crammer Academy. You will need to determine the total number of credits accumulated for both graduation years and the total number of grade points accumulated for both graduation years. To calculate grade points, you must take the point value for a grade and multiply it by the number of credits for the given course. The point values are as follows: A=4, B=3, C=2, D=1, F=0.

Provide an analysis and summary that gives a comparison of the percentage of required classes taken by PY students with the percentage of required classes taken by SQL, EXL, and ACS students across all semesters. To calculate this percentage for each major, you must first determine the number of classes taken by students enrolled in that major, then use this number for each semester to determine the percentage of those classes that are required.