Faculty Grade Distribution Multi Term Report

This article covers how to run and interpret the Faculty Grade Distribution Multi Term 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 Faculty Grade Distribution Multi Term report shows a breakdown of the course grade distribution and SOQ data by instructor and then course/section for multiple terms.

Accessing the Report

1. Log in to the CSUF Data Warehouse (OBIEE).

2. Click on Dashboards and select Course Grade Distribution.

Dashboard select
  1. Click on the Dashboards menu in the CSUF Data Warehouse.
  2. Select Course Grade Distribution.

3. Click the Faculty Grade Distribution Multi Term tab on the Course Grade Distribution dashboard.

Faculty Grade Distribution Multi Term select

Report Overview

By default, the Faculty Grade Distribution Multi Term report will show the previous two similar terms (e.g. Fall 2015 and Fall 2014 or Spring 2015 and Spring 2014) 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.

Faculty Grade Distribution Multi Term Report Overview

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(s) (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.
Instructor The primary instructor granted the ability to assign and approve grades for the course for which you wish to view data.

Report Parameters

Use the drop-down menu above the table to change the data you see in the results charts and tables.

Faculty Grade Distribution Multi Term  Report Parameters

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 Faculty Grade Distribution Report Multi Term table shows each faculty member and the grade distribution and the Student Opinion Questionnaire (SOQ) results for each course section that they taught during the terms selected.

You can click on a Class Number to view the detail for that specific class number along with a chart of the grade distribution.

Available Columns

Column Description
Primary Faculty The primary instructor granted the ability to assign and approve grades for the course.
Term Desc The academic terms selected for the report.
Class Number The ID number assigned to a specific section of a course (e.g. 13741).
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 name of the instructor listed on the Student Opinion Questionnaire (SOQ) that students completed 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 helpdesk@fullerton.edu or 657-278-7777.

For questions about getting access to the Data Warehouse or how to use the reports, please contact IT Training at ittraining@fullerton.edu or 657-278-5647.