SSRA Course Grade Dashboard
- Hennadii Balashov
- Shashank Rao Gujja
- Kevin Meleedy
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 → FIRST_GEN_IND | First generation status | DFW by First Generation |
| Pell Recipient | SID → SID_FINANCIALAID → FUND_CODE | Pell grant award status | DFW for Pell Recipients |
Filter Panels
Filters are listed on top panel of the report.
Notes:
- Click the down arrow to select from options in the filters and narrow down your results.
- To deselect an item, click on the option again.
- Some filters are radio buttons and you can select only one item. The items in these filters are indicated as round buttons.
- Some filters allow multiple selections. To select multiple values in a filter, hold the Ctrl key as you check the square boxes
.
- Filters for the report may not have Blank as an option.
Data Panel
This panel displays the filtered results. To work with data in this panel:
- Select an individual row in the table to highlight the item/row. Select it again to return to the full table view.
- You can sort the data by column values, if the sorting is available for that column. Hover your mouse over the last row item in the column header and if a small black triangle appears
, you can sort that column in ascending or descending order by clicking on your mouse.
Options for the Data Panel
Export Data to Excel
To export the data results to Excel, hover your mouse over the upper right hand side corner of the data table and a horizontal menu bar 
will pop up. Click the 
in the top right corner .
A drop down menu will appear with 'Export data' as one of the options. Select Export Data to work with the data in Excel.
Note : The exported data in Excel may not look exactly like the screen.
Focus Mode
To see the data in Focus Mode, hover your mouse over the upper right hand side corner of the data table and a horizontal menu bar will pop up. Click the option for Focus Mode 
It allows the visual to take the entire space in the report canvas. Full screen mode will persist until you exit out or click on 
on the top left hand side.
When in Focus Mode, click the in the top right corner and a drop down menu will appear with the following options:
You can export data, or see the data in a table by selecting the appropriate option.
Spotlight
Spotlight causes all other visuals on the page to fade so the selected visual is highlighted. To highlight a visual, click on more action and select 
Drill Up and Drill Down
If the visual has the hierarchy, the 
menu will appear when you hover on the top left side of the visual. Turn on drill down first by selecting the downward arrow. The grey background 
lets you know that drill down is active. Selecting 
will expand another level of hierarchy. Selecting the double arrow 
drill-down icon takes you to the next level in the hierarchy. Selecting 
will take you one level up in hierarchy. The arrows will be greyed out if the option is not available.
Reset to Default
If you have made any changes, such as implementing filters or sorting the table, you have the ability to return the sorting and filtering to the report creator's default view. Click the Reset to Default image above the report in the Report Header: 
To be added...