/
SSRA Course Grade Dashboard

SSRA Course Grade Dashboard

Part of Student Success Hub

maintained by Student Success Research and Analytics


Course Grades Dashboard

This dashboard was designed to equip stakeholders and key decision makers with comprehensive, accessible, actionable, and timely data regarding student academic performance and achievement across USF courses; the data are disaggregated by various demographic student characteristics.

Data Source: SID, Banner
Refresh schedule: (Pending)

Report pages

The report is primarily filtered by selecting either course unit funded campus/college or student homecampus/college from drop-down menus at the top part of the dashboard. After making an appropriate selection, tables and charts will display grades awarded counts.

Dashboard has the following pages:

  • Final Grades Distribution
  • DFW Rate by Campus/College
  • Midterm vs Final Grade
  • DFW by Student Type
  • DFW by Gender
  • DFW by Race/Ethnicity
  • DFW by First Generation
  • DFW for Pell Recipients
  • DFW by Section Modality
  • DFW by Course Section
Glossary

Data Element

Data Source (underlying data field)

Description

Report Pages

TermSID → SID_COURSES_TAKEN → TERMIDTerm such as Fall 2020 or Spring 2018All Pages
Course Section

SID → SID_COURSES_TAKEN → CRS_PREFIX

SID → SID_COURSES_TAKEN → CRS_NBR

SID → SID_COURSES_TAKEN → CRS_SECTN_NBR

SID → SID_COURSES_TAKEN → CRS_SECTN_TYP_PRI

Specific course sections represented by combination of subject prefix, course number, section number, and section type; for example, ECO-4421-002-C

DFW by Course Section

Course TitleSID → SID_INSTRUCTIONAL_ACTIVITY → COURSE_TITLECourse titles such as INTRO TO ECONOMETRICS

DFW by Course Section

Midterm GradePROD → SFRSTCR → SFRSTCR_GRDE_CODE_MIDMidterm grade assigned to a student in a given course

Midterm vs Final Grade

Final GradeSID → SID_COURSES_TAKEN → GRADE_AWARDEDFinal grade assigned to a student in a given courseAll Pages
Section ModalitySID → SID_INSTRUCTIONAL_ACTIVITY → DELIVERY_METHD_IND

AD: Full Distance Learning Course - 100% of the direct instruction of the course is delivered using some form of technology when the student and instructor are separated by time, space, or both. All special course components (exams, internships, practica, clinicals, labs, etc) that cannot be completed online can be completed off-campus.

PD: Primarily Distance Learning Course - 80-99% of the direct instruction of the course is delivered using some form of technology when the student and instructor are separated by time, space, or both. There is a requirement for the student to attend campus or another explicit geographic location for a portion of the course.

CL: Primarily Classroom Course - Less than 50% of the direct instruction of the course is delivered using some form of technology when the student and instructor are separated by time, space or both. This designation can include activities that do not occur in a classroom (ie, labs, internships, practica, clinicals, labs, etc).

HB: Hybrid Course - 50-79% of the direct instruction of the course is delivered using some form of technology when the student and instructor are separated by time, space or both.

DFW by Section Modality

Course SiteSID → SID_INSTRUCTIONAL_ACTIVITY → DELIVERY_METHD_INDGroups of course modality, such as On Campus, Off Campus, or High FlexDFW by Section Modality
Course CampusSID → SID_COURSES_TAKEN → CAMPUS_FCampus associated with the courseAll Pages
Course CollegeSID → SID_COURSES_TAKEN → GLOBAL_COLLEGECollege associated with the courseAll Pages
Course DepartmentSID → SID_COURSES_TAKEN → GLOBAL_DEPTDepartment associated with the courseNot Used
Course LevelSID → SID_COURSES_TAKEN → CRS_NBR

Course Level follows BOG definitions:

The first digit reflects course level:
0 - Indicates remedial level courses
1,2 - Indicates lower level
3,4 - Indicates upper level
5,6,7,8,9 - Indicates graduate level courses

All Pages
Student CampusSID → SID_ENROLLMENTS → HOMECAMPUSThe Campus at the time of EnrollmentAll Pages
Student CollegeSID → SID_ENROLLMENTS → GLOBAL_COLLEGEThe Global College at the time of EnrollmentAll Pages
Student DepartmentSID → SID_ENROLLMENTS → GLOBAL_DEPTThe Global Department at the time of EnrollmentNot Used
Student LevelSID → SID_ENROLLMENTS → STU_CLASS_LEVEL

Student class level description

Not Used
Student Level DetailSID → SID_ENROLLMENTS → STU_CLASS_LEVEL
Not Used
GenderSID → SID_ENROLLMENTS → GENDERThe Gender at the time of Enrollment

DFW by Gender

Race EthnicitySID → SID_ENROLLMENTS → ETHNICThe Ethnicity at the time of Enrollment

DFW by Race/Ethnicity

Student Type

SID → SID_ENROLLMENTS → STU_CLASS_LEVEL

SID → SID_ENROLLMENTS → STU_RECENT_ADM_TYP

SID → SID_ENROLLMENTS → DEG_LEVEL_SOUGHT

SID → SID_ENROLLMENTS → IPEDS_GRADSTU_FLG

Student Type such as FTIC or Masters

DFW by Student Type

First GenerationSID → SID_ENROLLMENTS &r