Grade Distribution

Owned by Michael Citi, created
Last updated: Nov 29, 2023 by Jordan Lamb
1 min read

Data Source

Snowflake (Invoke)

Job/Process Source (Refresh Interval)

Day-old Data ingestion into Snowflake.

Functional User(s)

Velia Rodriguez

Constituent(s)

Richard Lubben

Report Owner

Arianna Kennedy

Data Domain(s)

Academic

Contains PII

No

What It’s Used For

Detailed grade distribution breakdown by CRN (and related fields) for a given term, division, and/or department. Any course that has been deemed ungradable* has been filtered out of the results.

Options

Options

Description

Options

Description

Term

Selectable terms ranging from the current term to past terms as early as Fall 2000.

Division

‘All’ or any specific division that the user wishes to filter the report data. Options are populated by the selected term.

Department

‘All’ or any specific department that the user wishes to filter the report data. Options are populated by the selected term.

Results

Field Name

Data Source/Logic

Description (sample)

Field Name

Data Source/Logic

Description (sample)

Faculty

SPRIDEN.SPRIDEN_LAST_NAME

SPRIDEN.SPRIDEN_FIRST_NAME

SPRIDEN.SPRIDEN_MI

Combination of the primary instructor’s last, first, and middle name.

Course Title

SCBCRSE.SCBCRSE_TITLE

The course title

Subject

SSBSECT.SSBSECT_SUBJ_CODE

SSBSECT.SSBSECT_CRSE_NUMB

Combination of the course subject and course number

CRN

SSBSECT.SSBSECT_CRN

CRN

Grades & Registration Codes (30 Columns)

Grades: SHRGRDE.SHRGRDE_CODE

Registration Codes: SFRSTCR.SFRSTCR_RSTS_CODE

This includes all standard grades including their + and - designations, pass/no-pass, incompletes (with grade), and specific registration codes.

A+, A, A-, … IB+, IB, IB-… P, NP… DR, W

Total Passed

SHRGRDE.SHRGRDE_PASSED_IND

A total containing the sum of all passing grades per CRN

Total Enrolled

SHRGRDE.SHRGRDE_ATTEMPTED_IND

A total containing the sum of all enrolled students per CRN, regardless of final grade outcome.

Report Domain

*Ungradable data source is determined by SSBSECT.SSBSECT_GRADABLE_IND per CRN

 

Version Date Comment
Current Version (v. 9) Nov 29, 2023 19:25 Jordan Lamb
v. 8 Apr 13, 2023 18:27 Michael Citi
v. 7 Apr 13, 2023 18:22 Michael Citi
v. 6 Apr 13, 2023 18:19 Michael Citi
v. 5 Apr 13, 2023 17:47 Michael Citi
v. 4 Apr 13, 2023 17:32 Michael Citi
v. 3 Apr 13, 2023 17:30 Michael Citi
v. 2 Apr 13, 2023 17:15 Michael Citi
v. 1 Apr 13, 2023 16:20 Michael Citi