Sections with GPA <= 2.0 Report
This article covers how to run and interpret the Sections with GPA <= 2.0 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 Sections with GPA < = 2.0 report is similar to the Course Grade Distribution report but only includes sections where the average GPA for the section was less than 2.0.
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 Sections with GPA
Report Overview
By default, the 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 Table
The Sections with GPA < = 2.0 table shows the course grade distribution and the Student Opinion Questionnaire (SOQ) results for each course section with an average GPA of less than or equal to 2.0 for the term selected.
| Column |
Description |
|---|---|
| Term Desc | The academic term (e.g., Fall 2018). |
| Subject | The course subject (e.g., HUSR). |
| Catalog Number | The course catalog number (e.g., 101A). |
| Section |
The course section number (e.g. 01). |
| Max Units | The maximum number of units a student can earn for the course. |
| Instructor Name | 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: 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.