Course Grade Distribution Report
This article covers how to run and interpret the Course Grade Distribution report on the Course Grade Distribution dashboard.
This user guide assumes basic knowledge of Data Warehouse. View the Data Warehouse Basics guides for more information.
What does this report show?
The Course Grade Distribution report shows a summary of the course grade distribution for the college and then a breakdown of the course grade distribution and SOQ data by course and section. Users can view data for a single term.
1. Log in to the CSUF Data Warehouse (OBIEE).
2. Click on Dashboards and select Course Grade Distribution.
- Click on the Dashboards menu in the CSUF Data Warehouse.
- Select Course Grade Distribution.
3. Click the Course Grade Distribution tab on the Course Grade Distribution dashboard.
Report Overview
By default, the Course Grade Distribution report will show the previous term and all of the college(s), department(s) and/or courses you have permission to view.
When you access the report, your personal settings for the report (page) appear. If you have not set up your personal settings, the system defaults will automatically populate.
View the Grading Symbols Chart for more detail about all of the grading symbols used on the Course Grade Distribution dashboard reports.
Report Filters
The first section of the report contains the available filters. Utilize the filters to narrow down your report results or find specific values.
Filter Descriptions
| Filter | Description |
|---|---|
| College | The academic college(s) for which you wish to view data; users will only see colleges that they have permission to view. |
| Academic Organization | The CSUF academic organization for which you wish to view data; users will only see academic organizations that they have permission to view. |
| Course | The title of the course (e.g., Child Development) for which you wish to view data. |
| Term Descr | The academic term (e.g., Fall 2018) for which you wish to view data. |
| Subject | The course subject (e.g., HUSR) for which you wish to view data. |
| Catalog Number | The course catalog number (e.g., 101A) for which you wish to view data. |
| Class Number | The ID number assigned to a specific section of a course (i.e. 13741) for which you wish to view data. |
Report Parameters
Use the drop-down menu above each table to change the data you see in the results charts and tables.
Available Parameters
| Name | Description |
|---|---|
| Count | Shows the count of enrolled students who earned each grade. |
| Percentage | Shows the percentage of the enrolled students who earned each grade. |
Reading the Tables
Course Grade Distribution Summary Table
The Course Grade Distribution Report College Summary table shows the overall grade distribution for the college(s) selected by the percentage or count of enrolled students who earned each grade.
| Column | Description |
|---|---|
| GPA | The average GPA for all students enrolled in courses in the specified college for the term selected. |
| Enroll Count | The total number of students enrolled in courses in the specified college for the term selected. |
| Academic Group | The academic college or course grouping. |
| Grading Symbol Columns (e.g. A+ through RD) |
The percentage or count of students enrolled in the selected college who received the grade listed in the column header for the term selected (e.g., the percentage of enrolled students who received an A+ in an ARTS course in Fall 2015 or the number of enrolled students who received a C+ in an HHD course in Fall 2015). |
Course Grade Distribution Report Table
The Course Grade Distribution Report table shows the grade distribution for each section of each course and the Student Opinion Questionnaire (SOQ) results for each section of each course.
You can click on the Primary Faculty name to view the course grade distribution information for all sections of all courses that faculty member taught for the selected term.
| Column |
Description |
|---|---|
| Subject | The course subject (e.g., HUSR). |
| Catalog Number | The course catalog number (e.g., 101A). |
| Course | The title of the course (e.g. Child Development). |
| Max Units | The maximum number of units a student can earn for the course. |
| Section | The course section number (e.g. 01). |
| Class Number | The ID number assigned to a specific section of a course (e.g. 13741). |
| Primary Faculty | The primary instructor granted the ability to assign and approve grades for the course. |
| GPA | The average GPA for all students enrolled in the course section for the term selected. |
| Enroll Count | The total number of students enrolled in the course section for the term selected. |
| Grading Symbol Columns (e.g. A+ through RD) |
The percentage or count of students enrolled in the selected course section who received the grade listed in the column header for the term selected (e.g., the percentage or number of enrolled students who received an A+ in CAS 101 in Fall 2015). |
| SOQ: Instructor Name | The name of the instructor listed on the Student Opinion Questionnaire (SOQ) that students completed for the course. |
| SOQ: Mean | The mean of the responses on the SOQ. |
| SOQ: Type | The type of SOQ that the students completed: paper or online. |
| SOQ: Deviation | The standard deviation of the responses on the SOQ. |
| SOQ: Total Reps | The total number of responses received for all questions from all students who completed an SOQ for this course. |
| SOQ: A through E | The percentage of students who rated the instructor at each data point on the Likert scale on the SOQ. Typically A reflects a higher/positive rating and E is a low/negative rating. |
Need More Help?
For technical assistance with the Data Warehouse, please contact the IT Help Desk at [email protected] or 657-278-7777.
For questions about getting access to the Data Warehouse or how to use the reports, please contact IT Training at [email protected] or 657-278-5647.