Page Comparison

Section

Image Removed

Work In Progress

Column

width	5%

Column

width	95%

Panel

borderColor	#006747
bgColor	#F4F5F7

Academic Program Review (Student Data) Dashboard

These reports were designed specifically for the Academic Program Review process, which is primarily managed by the Institutional Effectiveness. The dashboard provides enrollment and degrees awarded information by CIP Code and Program Level,

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: Data are refreshed annually; every summer, dashboard is updated to reflect the data from the last five years up to and including the most recent academic year. The “Data Refreshed” field on the bottom right of the page indicates when the data was extracted from SID. (Pending)

Panel

titleColor	white
titleBGColor	#006747
title	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

Enrollment

Quick Facts

By Student Level & Gender

By

:

Final Grades Distribution
DFW Rate by Campus/College
Midterm vs Final Grade
DFW by Student Type
DFW by Gender
DFW by Race/Ethnicity
By Student Classification
By Enrollment Type & Nationality
Degrees
- Quick Facts
- By Race/Ethnicity
DFW by First Generation
DFW for Pell Recipients
DFW by Section Modality
DFW by Course Section

Panel

titleColor	white
titleBGColor	#006747
title	Glossary

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: 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 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

Panel

titleColor	white
titleBGColor	#006747
title	Tips

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 Image Removed 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 Image Modified on the top left hand side.
When in Focus Mode, click the Image Modified in the top right corner and a drop down menu will appear with the following options:

Image Modified

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 Image Modified and select Image Modified

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 Image Modified lets you know that drill down is active. Selecting will expand another level of hierarchy. Selecting the double arrow icon for drill all levels at once drill-down icon takes you to the next level in the hierarchy. Selecting Image Modified 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:

Panel

titleColor	white
titleBGColor	#006747
title	You Might Also Be Interested In...

To be added...

Versions Compared

Old Version 2

New Version Current

Key

Part of Student Success Hub

maintained by Student Success Research and Analytics

Academic Program Review (Student Data) Dashboard

Course Grades Dashboard

Filter Panels

Data Panel

Options for the Data Panel

Export Data to Excel

Focus Mode

Spotlight

Drill Up and Drill Down

Reset to Default