Average GPA Reports (SYSIF123) This database produces two average GPA reports for students REG/SCH at a specified campus for the current semester. Students with CUM GPA of 0 are excluded. The total number of students is printed at the end of both reports. Report 1: By Major, lists the semester classification, average CUM GPA and the number of students in the semester classification. Report 2: By Campus and Semester Classification, lists the college, semester classification, average CUM GPA within semester classification, average CUM GPA by college and total students in semester classification and college. STEP 1: - Running The Queries Simply run the queries one at a time in the order that they appear by double clicking, queries #1 through #5. While running these queries, you will be prompted by an input box to enter the campus criteria in the 2 character format (e.g., SL, BK, UP). Continue to select Yes, when prompted, as you work through queries #1 - #5. STEP 2: - Viewing Reports After running your last query (#5) select the Reports button under Objects. Simply highlight each report and select the Preview button, at the top of the database window, to view the details. Enter your campus code, when prompted, then print your report from the preview screen. REPORT 1 - BY MAJOR:   REPORT 2 - BY CAMPUS AND SEMESTER CLASSIFICATION:   Click on Download Here to download this MS Access database.

Printer friendly view