Data Source | Snowflake (Invoke) |
|---|---|
Job/Process Source (Refresh Interval) | Day-old Data ingestion into Snowflake. |
Functional User(s) | Velia Rodriguez |
Stakeholder(s) | Richard Lubben |
Report Owner | Arianna Kennedy |
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
| Version | Date | Comment |
|---|---|---|
| Current Version (v. 7) | Apr 13, 2023 18:22 | Michael Citi |
| 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 |
0 Comments