Data Source | Snowflake (Invoke) |
|---|---|
Job/Process Source (Refresh Interval) | N/A |
Functional User(s) | Velia Rodriguez |
Report Owner | Richard Lubben |
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.
*Ungradable data source is from SSBSECT.SSBSECT_GRADABLE_IND
🔘 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
Academic
| Version | Date | Comment |
|---|---|---|
| Current Version (v. 4) | Apr 13, 2023 17:32 | 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