Page Comparison

Column

width	5%

Image RemovedWork In Progress

Section

Column

width	95%

Panel

borderColor	#006747
bgColor	#F4F5F7

Student Credit Hours (SCH) Dashboard

These reports provide SCH information at a glance as well as detail level across the benchmarks by semester. The historical data is available for the past 10 years and is at the Final bench. The data for all the benches is available for past 5 year. These reports enable leadership to visualize, slice and dice the data and facilitate with strategic planning.

Data Source: SID
Refresh schedule: Data is refreshed every benchmark. The “Data Refreshed” field on the bottom right of the page indicates when the data was extracted from SID. The "Data Updated" field on the top of the report indicates when the report was published. These two dates are often different.

Panel

titleColor	white
titleBGColor	#006747
title	Report pages

Quick Facts → This tab displays the SCH information at a glance for any given term. summary of SCH and FTE for the selected academic year. This tab only shows data for one academic year at a time. To view the data for specific semesters, use the Semester filter.
College Level → This tab displays the summary of SCH information for any given term for any collegeand FTE by College at a Glance for a selected academic year. To see the college data at a detail level, click on the "Details" button at the bottom of the tab.
- College Detail → Provides the detailed information for 5 terms for the college selected in the Parent tab. This tab also shows the difference in SCH numbers from the previous semester. Changing the College filter on this tab will also change the College on the Parent page. Detail Page 1→ This tab shows the SCH Trends by College for 3 years of data. To go back to Parent page, click on the back arrow at the bottom of the tab.
- Detail Page 2→ This tab shows the SCH by College by Semester for 5 years of data. Right click on the headers to expand to next level or drill up to previous level. To go back to Parent page, click on the back arrow at the bottom of the tab.
Three Five Year Trend → Provides a This tab shows the summary of SCH by course level and student type for a given semester for 5 years. Clicking on "SCH" will provide more information on SCH.Five Year Term SCH → Detailed level information for Lower Level, Upper Level, Grad I and Grad II for five years. To Five Year Trend of SCH and FTE for 5 years of data. To see the data at a detail level, click on the "Details" button at the bottom of the tab. Department Level → This tab displays the summary of SCH information for any given term for any college. To see the college
- Detail Page 1→ This tab shows the SCH by Campus by Level for 5 years data. To view only SCH/FTE or both , use the "SCH", "FTE", or "SCH and FTE" buttons. To go back to Parent page, click on the back arrow at the bottom of the tab.
Ten Year Trend → This report displays the ten year trends of student student credit hours for course level. This tab has three unique filters "Academic Year", "Course Level" and "Student Type".
- Right click on the headers to expand to next level or drill up to previous level.
Ten Year Trend → This tab shows the Ten Year Trend of SCH for 10 years of data by course level. To see the data at a detail level, click on the "Details" button at the bottom of the tab.
- DepartmentDetail → Provides the detailed information for 5 terms for the college selected in the Parent tab. This tab also shows the difference in SCH numbers from the previous semester. Changing the College filter on this tab will also change the College on the Parent page. Detail Page 1→ This tab shows the Ten Year Trend of SCH and FTE by Level and shows Percentage of Level Total SCH by Level.
- Detail Page 2→ This tab shows the Ten Year Trend of SCH and FTE by Level and shows the Change from Prior Year.
  The "Diff SCH" column shows the difference in SCH from the previous year for that level. The calculation is (SCH for the year - SCH for the previous year).

The "%Diff SCH" column shows the percentage difference in SCH from the previous year for that level. The calculation is (SCH for the year - SCH for the previous year)/SCH for the previous year.

To go back to Parent page, click

on

the back arrow at the bottom of the tab

Semester Trend → This tab .

To go back to Parent page, click on the back arrow at the bottom of the tab.

shows the SCH Trend by Semester for 3 years of data for each semester - Summer, Fall and Spring by course level group.
Department Level → This tab shows the Five Year Trend of SCH and FTE by Department. This tab shows data for only one college at a time.

Panel

titleColor	white
titleBGColor	#006747
title	Glossary

Data Element

Data Source (underlying data field)

Description

Report Pages

Benchmark

Academic Year

SID → SID_

COURSES_TAKEN→ BENCHBenchmark such as Preliminary or Final

TERMID→ TERMID

Term such as Summer, Fall

All Pages

Term

Semester

SID → SID_

TERMID→

TERMID → TERMID

Term

Semester such as Fall

2020

, Spring or

Spring 2018

Summer	All Pages
Campus	SID → SID_COURSES_TAKEN→ CAMPUS_F	The Funding Campus

at

of the

time of Enrollment

course	All Pages
College	SID → SID_COURSES_TAKEN → GLOBAL_COLLEGE	The Global College

at

funding the

time of Enrollment

course	All Pages
Department	SID →SID_COURSES_TAKEN → GLOBAL_DEPT	The Global

Department at the time of Enrollment

Department funding the course

All Pages

Ethnicity

Course Level Group

SID → SID

_PERSON_DEMO→ETHNICThe Ethnicity at the time of Enrollment

_COURSES_TAKEN → CRS_LEVEL_GROUP

Course level group such as Undergraduate or Graduate

All Pages

Gender

Course Level

SID → SID

→ SID

_COURSES_

PERSON

TAKEN → CRS_

DEMO→ GENDERThe Gender at the time of Enrollment

LEVEL

Course level such as Lower, Upper, Grad I (Masters) and Grad II (Doctoral)

All Pages

Semester

Instructional Method

SID → SID_

TERMID → MONTHSemester such as Fall, Spring or Summer

INSTRUCTIONAL_ACTIVITY→ DELIVERY_METHD_IND

Delivery Method such as Hybrid, Online, Traditional
All Distance Learning and Partial Distance Learning has been combined as Online

All Pages

Student Level

CIP	SID → SID_

COURSES

CIP_

TAKEN → STU_CLASS_LEVELStudent level such as Undergraduate or Graduate

TITLES→ CIP_CRS

Course CIP

All Pages

Student Type

CIP Title

SID → SID_

COURSES_TAKEN → STU_RECENT_ADM_TYPStudent Type such as FTIC or Masters

CIP_TITLES→ CIPTITLE

Title for each CIP

All Pages

Instructional Method

Budget Entity

SID → SID_

INSTRUCTIONAL

COURSES_

ACTIVITY→DELIVERY

TAKEN→ BE_

METHD

CD_

INDOnline Enrollment

CRS

Funded by Budget Entity - E&G, Auxiliary and Health

All Pages

CIP

SCH	SID → SID_COURSES_

CIP

TAKEN→STU_

Titles→ CIP

SECTN_

CRSCourse CIP

CRED

Student Credit Hours

All Pages

Course Level

FTE

SID → SID

→SID

_COURSES_

TAKEN → CRS

TAKEN→STU_

LEVEL

SECTN_

CLASSLower Level, Upper Level, Grad I and Grad II

CRED

If the Course is an Undergraduate Level Course then FTE=SCH/30;

If the Course is an Graduate Level Course then FTE=SCH/24;

All Pages

Panel

titleColor	white
titleBGColor	#006747
title	Tips

Filter Panels

Filters are listed on top or on side 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 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...

Versions Compared

Old Version 4

New Version Current

Key

Part of Student Success Hub

maintained by Student Success Research and Analytics

Student Credit Hours (SCH) 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