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 |
|---|---|
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) |
|---|---|---|
Faculty |
| Combination of the primary instructor’s last, first, and middle name. |
Course Title |
| The course title |
Subject |
| Combination of the course subject and course number |
CRN |
| CRN |
Grades & Registration Codes (30 Columns) | Grades: Registration Codes: | 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 |
| A total containing the sum of all passing grades per CRN |
Total Enrolled |
| 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
...