SSRA Course Grade Dashboard
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)
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
Data Element | Data Source (underlying data field) | Description | Report Pages |
Term | SID → SID_COURSES_TAKEN → TERMID | Term such as Fall 2020 or Spring 2018 | All 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 Title | SID → SID_INSTRUCTIONAL_ACTIVITY → COURSE_TITLE | Course titles such as INTRO TO ECONOMETRICS | DFW by Course Section |
Midterm Grade | PROD → SFRSTCR → SFRSTCR_GRDE_CODE_MID | Midterm grade assigned to a student in a given course | Midterm vs Final Grade |
Final Grade | SID → SID_COURSES_TAKEN → GRADE_AWARDED | Final grade assigned to a student in a given course | All Pages |
Section Modality | SID → 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 Site | SID → SID_INSTRUCTIONAL_ACTIVITY → DELIVERY_METHD_IND | Groups of course modality, such as On Campus, Off Campus, or High Flex | DFW by Section Modality |
Course Campus | SID → SID_COURSES_TAKEN → CAMPUS_F | Campus associated with the course | All Pages |
Course College | SID → SID_COURSES_TAKEN → GLOBAL_COLLEGE | College associated with the course | All Pages |
Course Department | SID → SID_COURSES_TAKEN → GLOBAL_DEPT | Department associated with the course | Not Used |
Course Level | SID → SID_COURSES_TAKEN → CRS_NBR | Course Level follows BOG definitions: The first digit reflects course level: | All Pages |
Student Campus | SID → SID_ENROLLMENTS → HOMECAMPUS | The Campus at the time of Enrollment | All Pages |
Student College | SID → SID_ENROLLMENTS → GLOBAL_COLLEGE | The Global College at the time of Enrollment | All Pages |
Student Department | SID → SID_ENROLLMENTS → GLOBAL_DEPT | The Global Department at the time of Enrollment | Not Used |
Student Level | SID → SID_ENROLLMENTS → STU_CLASS_LEVEL | Student class level description | Not Used |
Student Level Detail | SID → SID_ENROLLMENTS → STU_CLASS_LEVEL | Not Used | |
Gender | SID → SID_ENROLLMENTS → GENDER | The Gender at the time of Enrollment | DFW by Gender |
Race Ethnicity | SID → SID_ENROLLMENTS → ETHNIC | The 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 Generation | SID → SID_ENROLLMENTS &r |