data warehouse - student success reports · data in the data warehouse is refreshed nightly;...

79
Data Warehouse User Guide Student Success Reports Last Revised: 8/1/14 Last Revised: 8/1/14 Page 1 of 79

Upload: truongngoc

Post on 09-Dec-2018

214 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Data Warehouse User Guide Student Success Reports

Last Revised: 8/1/14

Last Revised: 8/1/14 Page 1 of 79

Page 2: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

REVISION CONTROL

Document Title: Data Warehouse Student Success Reports User Guide Author: IT Training & Support File Reference: UG-Data_Warehouse_Student_Success.docx

Revision History

Revision Date Revised By Summary of Revisions Section(s) Revised 11/15/13 Lori Arthur-

Carmichael Updated guide with 11g instance updates Click here to enter

Revision Date

2/24/14 Lori Arthur-Carmichael

Added 2-Dimensional Detail report; added Freshman Program participation dimension for reports.

8/1/14 Lori Arthur-Carmichael

Updated guide with additional 11g instance updates and formatting changes

Review / Approval History

Review Date Reviewed By Action (Reviewed, Recommended or Approved) 04/15/13 Joe Luzzi, Afshin

Karimi, Edward Sullivan

Approved

11/15/13 Joe Luzzi, Afshin Karimi, Edward Sullivan

Approved

8/1/14 Joe Luzzi, Afshin Karimi, Edward Sullivan

Approved

Last Revised: 8/1/14 Page 2 of 79

Page 3: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Table of Contents Page

1.0 Student Success Dashboard Overview ......................................................................................................................... 4

Important Information About These Reports ...................................................................................................................... 4

Available Reports .............................................................................................................................................................. 4

Accessing the Student Success Reports ........................................................................................................................... 6

2.0 Cohort Comparison ......................................................................................................................................................... 7

Running the Report ........................................................................................................................................................... 7

Reading the Chart ............................................................................................................................................................. 9

Reading the Table ........................................................................................................................................................... 10

3.0 Cohort Comparison – College ...................................................................................................................................... 11

Running the Report ......................................................................................................................................................... 11

Reading the Chart ........................................................................................................................................................... 13

Reading the Table ........................................................................................................................................................... 15

4.0 Cohort Comparison – Ethnicity .................................................................................................................................... 16

Running the Report ......................................................................................................................................................... 16

Reading the Chart ........................................................................................................................................................... 18

Reading the Table ........................................................................................................................................................... 20

5.0 Cohort Comparison – Parent Education...................................................................................................................... 21

Running the Report ......................................................................................................................................................... 21

Reading the Chart ........................................................................................................................................................... 23

Reading the Table ........................................................................................................................................................... 25

6.0 First-Time Freshman Cohorts – Detail ......................................................................................................................... 26

Running the Report ......................................................................................................................................................... 26

Reading the Charts ......................................................................................................................................................... 28

Reading the Tables ......................................................................................................................................................... 38

7.0 New Transfer Cohorts – Detail ..................................................................................................................................... 49

Running the Report ......................................................................................................................................................... 49

Reading the Charts ......................................................................................................................................................... 51

Reading the Tables ......................................................................................................................................................... 62

8.0 2-Dimensional Detail ..................................................................................................................................................... 73

Running the Report ......................................................................................................................................................... 73

Reading the Charts ......................................................................................................................................................... 75

Reading the Tables ......................................................................................................................................................... 77

9.0 Student Search .............................................................................................................................................................. 79

Running the Report ......................................................................................................................................................... 79

Last Revised: 8/1/14 Page 3 of 79

Page 4: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

1.0 Student Success Dashboard Overview

This user guide assumes basic knowledge of Data Warehouse. User guides and tutorials on the basic features of Data Warehouse are available at the IT Training website: http://www.fullerton.edu/ittraining/peoplesoft/dw.

Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night unless otherwise indicated.

Important Information About These Reports The Student Success reports allow users to view graduation rates for cohorts of first-time full-time freshmen and new undergraduate transfers. Additionally users can view these graduation rates for a specific college, ethnicity, parent education level, underrepresented status, EOP participation, or prior institution type. Detail for each cohort (degree count, enrolled count, and not graduated & not enrolled count) is also available.

If you have any questions about the data that you are viewing on these reports, please contact Institutional Research & Analytical Studies at (657)278-4205 or visit their website: http://www.fullerton.edu/analyticalstudies.

Available Reports The following reports are currently available for the Student Success dashboard:

• Cohort Comparison: The Cohort Comparison report shows charts and tables with a comparison of cohorts from fall 2004 – present on values such as initial cohort size, degree count, % graduated, enrolled count, % enrolled & not graduated, not graduated & not enrolled count, and % not graduated & not enrolled. Users can choose to see this information for first-time full-time freshman cohorts or for new undergraduate transfer cohorts.

• Cohort Comparison - College: The Cohort Comparison - College report shows charts and tables with a comparison of cohorts from fall 2004 – present on values such as initial cohort size, degree count, % graduated, enrolled count, % enrolled & not graduated, not graduated & not enrolled count, and % not graduated & not enrolled. These values are broken down by academic college. Users can choose to see this information for first-time full-time freshman cohorts or for new undergraduate transfer cohorts. Users can also specify that they want to see this information for all academic colleges or for a specific college.

• Cohort Comparison - Ethnicity: The Cohort Comparison - Ethnicity report shows charts and tables with a comparison of cohorts from fall 2004 – present on values such as initial cohort size, degree count, % graduated, enrolled count, % enrolled & not graduated, not graduated & not enrolled count, and % not graduated & not enrolled. These values are broken down by student ethnicity. Users can choose to see this information for first-time full-time freshman cohorts or for new undergraduate transfer cohorts. Users can also specify that they want to see this information for all ethnicities or a specific ethnicity.

• Cohort Comparison – Parent Education: The Cohort Comparison – Parent Education report shows charts

and tables with a comparison of cohorts from fall 2004 – present on values such as initial cohort size, degree count, % graduated, enrolled count, % enrolled & not graduated, not graduated & not enrolled count, and % not graduated & not enrolled. These values are broken down by level of parent education. Users can choose to see this information for first-time full-time freshman cohorts or for new undergraduate transfer cohorts.

Last Revised: 8/1/14 Page 4 of 79

Page 5: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Users can also specify that they want to see this information for all levels of parent education or for a specific level of parent education.

• First-Time Freshman Cohorts - Detail: The First-Time Freshman Cohorts - Detail report shows charts and

tables with a comparison of cohorts from fall 2004 – present on values such as college, size, degree count, % graduated, enrolled count (current term), % enrolled & not graduated, not graduated & not enrolled count, and % not graduated & not enrolled. Users can specify for which cohorts they wish to see this information and to view numbers by college (latest), college (entry), gender, ethnicity, underrepresented status, prior institution type, parent education level, EOP participation, or Freshman Programs participation.

• New Transfer Cohorts - Detail: The New Transfer Cohorts - Detail report shows charts and tables with a

comparison of new undergraduate transfer student cohorts from fall 2004 – present on values such as college, size, degree count, % graduated, enrolled count (current term), % enrolled & not graduated, not graduated & not enrolled count, and % not graduated & not enrolled. Users can specify for which cohorts they wish to see this information and to view numbers by college (latest), gender, ethnicity, underrepresented status, prior institution type, parent education level, college (entry), cohort summary, EOP Participation, or full-time/part-time status for their first term.

• 2-Dimensional Detail: The 2-Dimensional Detail report shows charts and tables with a comparison of

cohorts from fall 2004 – present on values such as initial cohort size, degree count, % graduated, enrolled count, % enrolled & not graduated, not graduated & not enrolled count, and % not graduated & not enrolled. Users can choose to see this information for first-time full-time freshman cohorts or for new undergraduate transfer cohorts. Users can also specify two dimensions on which to view the data from among the following: cohort summary, gender, ethnicity, underrepresented status, prior institution type, parent education, college (latest), college (entry), EOP participation, and Freshman Programs participation.

• Student Search: The Student Search report allows users to enter the Campus-Wide ID (CWID) of one or more students to view detail information on those students including name, cohort, initial enrollment type, last enrolled term, degree term (if graduated), email, phone number, cell phone number, major at entry, major (latest), gender, ethnicity, underrepresented status, parent education level, units earned, units attempted (current term), units attempted (future term) group qual, cumulative GPA, degree candidate term, degree checkout consideration term & status, academic standing, EOP participation, freshman programs participation, degree audit program, degree audit run date and degree audit status.

Last Revised: 8/1/14 Page 5 of 79

Page 6: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Accessing the Student Success Reports Processing Steps Screen Shots Step 1: From the Data Warehouse homepage, click on the Dashboards menu.

Step 2: In the CSU Reports section, select Student Success.

Last Revised: 8/1/14 Page 6 of 79

Page 7: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

2.0 Cohort Comparison

The Cohort Comparison report shows charts and tables with a comparison of cohorts from fall 2004 – present on values such as initial cohort size, degree count, % graduated, enrolled count, % enrolled & not graduated, not graduated & not enrolled count, and % not graduated & not enrolled. Users can choose to see this information for first-time full-time freshman cohorts or for new undergraduate transfer cohorts.

Processing Steps Screen Shots

Running the Report Step 1: On the Student Success dashboard, click on the Cohort Comparison tab.

Step 2: The report will automatically run with your personal settings if you have set them up. If you have not set up your personal settings, the report will run for first-time full-time freshman cohorts from fall 2004-present.

Step 3: To change the enrollment type, use the drop-down menu to make a selection.

Last Revised: 8/1/14 Page 7 of 79

Page 8: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots Step 4: Click Apply to run the report.

For more information on how to use filters in Data Warehouse, view the Data Warehouse Filtering user guide or web tutorial.

Step 5: The updated report appears.

Last Revised: 8/1/14 Page 8 of 79

Page 9: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Reading the Chart The Cohort Comparison chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Hover your mouse over the chart and a pop-up will appear giving you the specific value for that point on the chart.

Last Revised: 8/1/14 Page 9 of 79

Page 10: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Reading the Table The Cohort Comparison table shows the detailed counts that are summarized in the Cohort Comparison chart.

These counts are current as of today.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

Enrollment Type Description The type of students in the cohort: either first-time full-time freshman or new undergraduate transfer.

Initial Cohort Size The number of students initially in the cohort.

Graduated Count The number of students in the cohort who have graduated.

% Graduated The percentage of students in the cohort who have graduated.

Enrolled Count The number of students in the cohort who are enrolled in the current term.

% Enrolled & Not Graduated The percentage of students in the cohort who are enrolled in the current term and have not graduated.

Not Graduated Not Enrolled Count The number of students in the cohort who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 10 of 79

Page 11: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

3.0 Cohort Comparison – College

The Cohort Comparison - College report shows charts and tables with a comparison of cohorts from fall 2004 – present on values such as initial cohort size, degree count, % graduated, enrolled count, % enrolled & not graduated, not graduated & not enrolled count, and % not graduated & not enrolled. These values are broken down by academic college. Users can choose to see this information for first-time full-time freshman cohorts or for new undergraduate transfer cohorts. Users can also specify that they want to see this information for all academic colleges or for a specific college.

Processing Steps Screen Shots

Running the Report Step 1: On the Student Success dashboard, click on the Cohort Comparison – College tab.

Step 2: The report will automatically run with your personal settings if you have set them up. If you have not set up your personal settings, the report will run for first-time full-time freshman cohorts from fall 2004-present for all academic colleges.

Step 3: To change the enrollment type, use the drop-down menu to make a selection.

Last Revised: 8/1/14 Page 11 of 79

Page 12: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots Step 4: To select a specific academic college, use the drop-down menu to make a selection.

Step 5: Click Apply to run the report.

For more information on how to use filters in Data Warehouse, view the Data Warehouse Filtering user guide or web tutorial.

Step 6: The updated report appears.

Last Revised: 8/1/14 Page 12 of 79

Page 13: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Reading the Chart The Cohort Comparison – College chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left for the college(s) you selected in the filters at the top of the page. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

This chart will show you the exact same data as the Cohort Comparison chart unless you select a specific college from the drop-down menu.

Last Revised: 8/1/14 Page 13 of 79

Page 14: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots Hover your mouse over the chart and a pop-up will appear giving you the specific value for that point on the chart.

Last Revised: 8/1/14 Page 14 of 79

Page 15: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Reading the Table The Cohort Comparison – College table shows the detailed counts that are summarized in the chart.

These counts are current as of today.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

College Description The code for the academic college that the student’s major is in. • ARTS = College of the Arts • CBE = College of Business & Economics • COMM = College of Communications • ECS = College of Engineering & Computer Science • EDUC = College of Education • H&SS = College of Humanities & Social Sciences • HHD = College of Health & Human Development • NSM = College of Natural Science & Math • OTHER = Undeclared or unknown

Enrollment Type Description The type of students in the cohort: either first-time full-time freshman or new undergraduate transfer.

Initial Cohort Size The number of students initially in the cohort for the specified college.

Graduated Count The number of students in the cohort for the specified college who have graduated.

% Graduated The percentage of students in the cohort for the specified college who have graduated.

Enrolled, not Graduated Count The number of students in the cohort for the specified college who are enrolled in the current term.

% Enrolled & Not Graduated The percentage of students in the cohort for the specified college who are enrolled in the current term and have not graduated.

Not Graduated Not Enrolled Count The number of students in the cohort for the specified college who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified college who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 15 of 79

Page 16: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

4.0 Cohort Comparison – Ethnicity

The Cohort Comparison - Ethnicity report shows charts and tables with a comparison of cohorts from fall 2004 – present on values such as initial cohort size, degree count, % graduated, enrolled count, % enrolled & not graduated, not graduated & not enrolled count, and % not graduated & not enrolled. These values are broken down by student ethnicity. Users can choose to see this information for first-time full-time freshman cohorts or for new undergraduate transfer cohorts. Users can also specify that they want to see this information for all ethnicities or a specific ethnicity.

Processing Steps Screen Shots

Running the Report Step 1: On the Student Success dashboard, click on the Cohort Comparison – Ethnicity tab.

Step 2: The report will automatically run with your personal settings if you have set them up. If you have not set up your personal settings, the report will run for first-time full-time freshman cohorts from fall 2004-present for all ethnicities.

Step 3: To change the enrollment type, use the drop-down menu to make a selection.

Last Revised: 8/1/14 Page 16 of 79

Page 17: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots Step 4: To select a specific ethnicity, use the drop-down menu to make a selection.

Step 5: Click Apply to run the report.

For more information on how to use filters in Data Warehouse, view the Data Warehouse Filtering user guide or web tutorial.

Step 6: The updated report appears.

Last Revised: 8/1/14 Page 17 of 79

Page 18: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Reading the Chart The Cohort Comparison – Ethnicity chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left for the ethnicity or ethnicities you selected in the filters at the top of the page. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

This chart will show you the exact same data as the Cohort Comparison chart unless you select a specific ethnicity from the drop-down menu.

Last Revised: 8/1/14 Page 18 of 79

Page 19: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots Hover your mouse over the chart and a pop-up will appear giving you the specific value for that point on the chart.

Last Revised: 8/1/14 Page 19 of 79

Page 20: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Reading the Table The Cohort Comparison – Ethnicity table shows the detailed counts that are summarized in the chart.

These counts are current as of today.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

Ethnicity The reported ethnic group of the students in the cohort.

Enrollment Type Description The type of students in the cohort: either first-time full-time freshman or new undergraduate transfer.

Initial Cohort Size The number of students initially in the cohort for the specified ethnicity.

Graduated Count The number of students in the cohort for the specified ethnicity who have graduated.

% Graduated The percentage of students in the cohort for the specified ethnicity who have graduated.

Enrolled, not Graduated Count The number of students in the cohort for the specified ethnicity who are enrolled in the current term.

% Enrolled & Not Graduated The percentage of students in the cohort for the specified ethnicity who are enrolled in the current term and have not graduated.

Not Graduated Not Enrolled Count The number of students in the cohort for the specified ethnicity who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified ethnicity who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 20 of 79

Page 21: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

5.0 Cohort Comparison – Parent Education

The Cohort Comparison – Parent Education report shows charts and tables with a comparison of cohorts from fall 2004 – present on values such as initial cohort size, degree count, % graduated, enrolled count, % enrolled & not graduated, not graduated & not enrolled count, and % not graduated & not enrolled. These values are broken down by level of parent education. Users can choose to see this information for first-time full-time freshman cohorts or for new undergraduate transfer cohorts. Users can also specify that they want to see this information for all levels of parent education or for a specific level of parent education.

Processing Steps Screen Shots

Running the Report Step 1: On the Student Success dashboard, click on the Cohort Comparison – Parent Education tab.

Step 2: The report will automatically run with your personal settings if you have set them up. If you have not set up your personal settings, the report will run for first-time full-time freshman cohorts from fall 2004-present for all levels of parent education.

Step 3: To change the enrollment type, use the drop-down menu to make a selection.

Last Revised: 8/1/14 Page 21 of 79

Page 22: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots Step 4: To select a specific level of parent education, use the drop-down menu to make a selection.

Step 5: Click Apply to run the report.

For more information on how to use filters in Data Warehouse, view the Data Warehouse Filtering user guide or web tutorial.

Step 6: The updated report appears.

Last Revised: 8/1/14 Page 22 of 79

Page 23: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Reading the Chart The Cohort Comparison – Parent Education chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left for the level(s) of parent education you selected in the filters at the top of the page. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

This chart will show you the exact same data as the Cohort Comparison chart unless you select a specific level of parent education from the drop-down menu.

Last Revised: 8/1/14 Page 23 of 79

Page 24: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots Hover your mouse over the chart and a pop-up will appear giving you the specific value for that point on the chart.

Last Revised: 8/1/14 Page 24 of 79

Page 25: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Reading the Table The Cohort Comparison – Parent Education table shows the detailed counts that are summarized in the chart.

These counts are current as of today.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

Parent Education The highest level of education completed by the students’ parents.

Enrollment Type Description The type of students in the cohort: either first-time full-time freshman or new undergraduate transfer.

Initial Cohort Size The number of students initially in the cohort for the specified level of parent education.

Graduated Count The number of students in the cohort for the specified level of parent education who have graduated.

% Graduated The percentage of students in the cohort for the specified level of parent education who have graduated.

Enrolled, not Graduated Count The number of students in the cohort for the specified level of parent education who are enrolled in the current term.

% Enrolled & Not Graduated The percentage of students in the cohort for the specified level of parent education who are enrolled in the current term and have not graduated.

Not Graduated Not Enrolled Count The number of students in the cohort for the specified level of parent education who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified level of parent education who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 25 of 79

Page 26: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

6.0 First-Time Freshman Cohorts – Detail

The First-Time Freshman Cohorts - Detail report shows charts and tables with a comparison of cohorts from fall 2004 – present on values such as college, size, degree count, % graduated, enrolled count (current term), % enrolled & not graduated, not graduated & not enrolled count, and % not graduated & not enrolled. Users can specify for which cohorts they wish to see this information and to view numbers by college (latest), college (entry), gender, ethnicity, underrepresented status, prior institution type, parent education level, EOP participation, or Freshman Program participation.

Processing Steps Screen Shots

Running the Report Step 1: On the Student Success dashboard, click on the First-Time Freshman Cohorts – Detail tab.

Step 2: The report will automatically run with your personal settings if you have set them up. If you have not set up your personal settings, the report will run for fall cohorts of first-time freshman from fall 2006 – fall 2011.

Last Revised: 8/1/14 Page 26 of 79

Page 27: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots Step 3: To add/remove cohorts from the report, click on the Cohort Description drop-down menu. Place a checkmark next to each cohort you wish to include in your report. Un-check any cohorts you want to remove from your report.

Step 4: Once you have selected all of the cohorts you want to include on the report, click Apply to run the report.

For more information on how to use filters in Data Warehouse, view the Data Warehouse Filtering user guide or web tutorial.

Step 5: The updated report appears.

Last Revised: 8/1/14 Page 27 of 79

Page 28: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Reading the Charts The default setting for the charts (and tables below) is by College (latest). Use the View Numbers By drop-down menu above the chart to view the chart and table broken down by Cohort Summary, Gender, Ethnicity, Underrepresented Status, Prior Institution Type, Parent Education, College (entry), or EOP Participation.

Hover your mouse over the chart and a pop-up will appear giving you the specific value for that point on the chart.

Last Revised: 8/1/14 Page 28 of 79

Page 29: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Cohort Summary Chart The First-Time Freshman Cohorts Summary chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Last Revised: 8/1/14 Page 29 of 79

Page 30: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Gender Chart The First-Time Freshman Cohorts by Gender chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left for each gender. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Last Revised: 8/1/14 Page 30 of 79

Page 31: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Ethnicity Chart The First-Time Freshman Cohorts by Ethnicity chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left for each ethnicity. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Last Revised: 8/1/14 Page 31 of 79

Page 32: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Underrepresented Status Chart The First-Time Freshman Cohorts by Underrepresented Status chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left based on underrepresented status (either yes or no). The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Last Revised: 8/1/14 Page 32 of 79

Page 33: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Prior Institution Type Chart The First-Time Freshman Cohorts by Prior Institution Type chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left for the type of institution that the student came from prior to attending CSUF. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Last Revised: 8/1/14 Page 33 of 79

Page 34: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Parent Education Chart The First-Time Freshman Cohorts by Parent Education chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left for the level of parent education. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Last Revised: 8/1/14 Page 34 of 79

Page 35: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

College (Latest) Chart The First-Time Freshman Cohorts by College (Latest) chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left for the college that the student’s current major is in. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Last Revised: 8/1/14 Page 35 of 79

Page 36: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

College (Entry) Chart The First-Time Freshman Cohorts by College (Entry) chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left for the college that the student’s initial major was in. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Last Revised: 8/1/14 Page 36 of 79

Page 37: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

EOP Participation Chart The First-Time Freshman Cohorts by EOP Participation chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left for the EOP Participation status. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Last Revised: 8/1/14 Page 37 of 79

Page 38: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Freshman Prog Participation Chart The First-Time Freshman Cohorts by Freshman Programs Participation chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left for the Freshman Programs Participation status. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Reading the Tables The default setting for the tables (and the charts above) is by College (Latest). Use the View Numbers By drop-down menu above the chart to view the chart and table broken down by Cohort Summary, Gender, Ethnicity, Underrepresented Status, Prior Institution Type, Parent Education, College (entry), or EOP Participation.

These counts are current as of today.

Last Revised: 8/1/14 Page 38 of 79

Page 39: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Cohort Summary Table

Users can click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the fa07 row would bring up a list of all students who were first-time freshmen in Fall 2007 who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

Size The number of students in the cohort.

Degree Count The number of students in the cohort who have been awarded a degree.

% Graduated The percentage of students in the cohort who have graduated.

Enrolled Count The number of students in the cohort who are enrolled in the current term.

% Enrolled The percentage of students in the cohort who are enrolled in the current term.

Not Graduated & Not Enrolled Count

The number of students in the cohort who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 39 of 79

Page 40: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Gender Table

Users can click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the Women row for Fall 2007 would bring up a list of all female students who were first-time freshmen in Fall 2007 who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

Gender The gender of the students.

Size The number of students in the cohort for the specified gender.

Degree Count The number of students in the cohort for the specified gender who have been awarded a degree.

% Graduated The percentage of students in the cohort for the specified gender who have graduated.

Enrolled Count The number of students in the cohort for the specified gender who are enrolled in the current term.

% Enrolled The percentage of students in the cohort for the specified gender who are enrolled in the current term.

Not Graduated & Not Enrolled Count

The number of students in the cohort for the specified gender who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified gender who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 40 of 79

Page 41: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Ethnicity Table

Users can click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the American Indian row for Fall 2007 would bring up a list of all students who identify as the American Indian ethnicity who were first-time freshmen in Fall 2007 who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

Ethnicity The reported ethnic group of the students in the cohort.

Size The number of students in the cohort for the specified ethnicity.

Degree Count The number of students in the cohort for the specified ethnicity who have been awarded a degree.

% Graduated The percentage of students in the cohort for the specified ethnicity who have graduated.

Enrolled Count The number of students in the cohort for the specified ethnicity who are enrolled in the current term.

% Enrolled The percentage of students in the cohort for the specified ethnicity who are enrolled in the current term.

Not Graduated & Not Enrolled Count

The number of students in the cohort for the specified ethnicity who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified ethnicity who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 41 of 79

Page 42: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Underrepresented Status Table

Users can click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the Yes row in the Underrepresented Status column for Fall 2007 would bring up a list of all students categorized as underrepresented who were first-time freshmen in Fall 2007 who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

Underrepresented Status The underrepresented status of the students: yes indicates the students are members of an underrepresented group; no indicates that .the students are not members of an underrepresented group.

Size The number of students in the cohort for the specified underrepresented status.

Degree Count The number of students in the cohort for the specified underrepresented status who have been awarded a degree.

% Graduated The percentage of students in the cohort for the specified underrepresented status who have graduated.

Enrolled Count The number of students in the cohort for the specified underrepresented status who are enrolled in the current term.

% Enrolled The percentage of students in the cohort for the specified underrepresented status who are enrolled in the current term.

Not Graduated & Not Enrolled Count

The number of students in the cohort for the specified underrepresented status who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified underrepresented status who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 42 of 79

Page 43: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Prior Institution Type Table

Users can click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the CA Public HS row for Fall 2007 would bring up a list of all students who came from a public high school in California who were first-time freshmen in Fall 2007 who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

Prior Institution Type The type of institution that the student attended prior to attending CSUF.

Size The number of students in the cohort for the specified prior institution type.

Degree Count The number of students in the cohort for the specified prior institution type who have been awarded a degree.

% Graduated The percentage of students in the cohort for the specified prior institution type who have graduated.

Enrolled Count The number of students in the cohort for the specified prior institution type who are enrolled in the current term.

% Enrolled The percentage of students in the cohort for the specified prior institution type who are enrolled in the current term.

Not Graduated & Not Enrolled Count

The number of students in the cohort for the specified prior institution type who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified prior institution type who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 43 of 79

Page 44: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Parent Education Table

Users can click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the Parent Attended Some College row for Fall 2007 would bring up a list of all students whose parents completed some college who were first-time freshmen in Fall 2007 who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

Parent Education The highest level of education completed by the students’ parents.

Size The number of students in the cohort for the specified level of parent education.

Degree Count The number of students in the cohort for the specified level of parent education who have been awarded a degree.

% Graduated The percentage of students in the cohort for the specified level of parent education who have graduated.

Enrolled Count The number of students in the cohort for the specified level of parent education who are enrolled in the current term.

% Enrolled The percentage of students in the cohort for the specified level of parent education who are enrolled in the current term.

Not Graduated & Not Enrolled Count

The number of students in the cohort for the specified level of parent education who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified level of parent education who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 44 of 79

Page 45: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

College (Latest) Table

Users can click on a college to view the breakdown by major or click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the Arts row for Fall 2007 would bring up a list of all students who were first-time freshmen in Fall 2007 with current majors in the College of the Arts who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

College (latest) The code for the academic college that the student’s major is currently in. • ARTS = College of the Arts • CBE = College of Business & Economics • COM = College of Communications • ECS = College of Engineering & Computer Science • HSS = College of Humanities & Social Sciences • HHD = College of Health & Human Development • MISC = Undeclared or unknown • NSM = College of Natural Science & Math

Size The number of students in the cohort for the specified academic college.

Degree Count The number of students in the cohort for the specified college who have been awarded a degree.

% Graduated The percentage of students in the cohort for the specified college who have graduated.

Enrolled Count The number of students in the cohort for the specified college who are enrolled in the current term.

% Enrolled The percentage of students in the cohort for the specified college who are enrolled in the current term.

Not Graduated & Not Enrolled Count

The number of students in the cohort for the specified college who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified college who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 45 of 79

Page 46: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

College (Entry) Table

Users can click on a college to view the breakdown by major or click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the Arts row for Fall 2007 would bring up a list of all students who were first-time freshmen in Fall 2007 who entered CSUF with majors in the College of the Arts who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

College (entry) The code for the academic college that the student’s major upon entering CSUF is in. • ARTS = College of the Arts • CBE = College of Business & Economics • COMM = College of Communications • ECS = College of Engineering & Computer Science • H&SS = College of Humanities & Social Sciences • HHD = College of Health & Human Development • NSM = College of Natural Science & Math • OTHER = Undeclared or unknown

Size The number of students in the cohort for the specified academic college.

Degree Count The number of students in the cohort for the specified college who have been awarded a degree.

% Graduated The percentage of students in the cohort for the specified college who have graduated.

Enrolled Count The number of students in the cohort for the specified college who are enrolled in the current term.

% Enrolled The percentage of students in the cohort for the specified college who are enrolled in the current term.

Not Graduated & Not Enrolled Count

The number of students in the cohort for the specified college who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified college who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 46 of 79

Page 47: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

EOP Participation Table

Users can click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the Yes row in the EOP Participation column for Fall 2007 would bring up a list of all students who participated in the EOP program who were first-time freshmen in Fall 2007 who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

EOP Participation The EOP Participation status of the students: yes indicates the students participated in the EOP program; no indicates that .the students did not participate in the EOP program.

Size The number of students in the cohort for the specified EOP Participation status.

Degree Count The number of students in the cohort for the specified EOP Participation status who have been awarded a degree.

% Graduated The percentage of students in the cohort for the specified EOP Participation status who have graduated.

Enrolled Count The number of students in the cohort for the specified EOP Participation status who are enrolled in the current term.

% Enrolled The percentage of students in the cohort for the specified EOP Participation status who are enrolled in the current term.

Not Graduated & Not Enrolled Count

The number of students in the cohort for the specified EOP Participation status who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified EOP Participation status who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 47 of 79

Page 48: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Freshman Prog Participation Table

Users can click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the Yes row in the Freshman Prog Participation column for Fall 2007 would bring up a list of all students who participated in Freshman Programs who were first-time freshmen in Fall 2007 who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

Freshman Prog Participation The Freshman Programs Participation status of the students: yes indicates the students participated in Freshman Programs; no indicates that .the students did not participate in the Freshman Programs.

Size The number of students in the cohort for the specified Freshman Programs Participation status.

Degree Count The number of students in the cohort for the specified Freshman Programs Participation status who have been awarded a degree.

% Graduated The percentage of students in the cohort for the specified Freshman Programs Participation status who have graduated.

Enrolled Count The number of students in the cohort for the specified Freshman Programs Participation status who are enrolled in the current term.

% Enrolled The percentage of students in the cohort for the specified Freshman Programs Participation status who are enrolled in the current term.

Not Graduated & Not Enrolled Count

The number of students in the cohort for the specified Freshman Programs Participation status who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified Freshman Programs Participation status who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 48 of 79

Page 49: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

7.0 New Transfer Cohorts – Detail

The New Transfer Cohorts - Detail report shows charts and tables with a comparison of new undergraduate transfer student cohorts from fall 2004 – present on values such as college, size, degree count, % graduated, enrolled count (current term), % enrolled & not graduated, not graduated & not enrolled count, and % not graduated & not enrolled. Users can specify for which cohorts they wish to see this information and to view numbers by college (latest), gender, ethnicity, underrepresented status, prior institution type, parent education level, college (entry), cohort summary, EOP Participation, or full-time/part-time status for their first term.

Processing Steps Screen Shots

Running the Report Step 1: On the Student Success dashboard, click on the New Transfer Cohorts – Detail tab.

Step 2: The report will automatically run with your personal settings if you have set them up. If you have not set up your personal settings, the report will run for fall and spring cohorts of new transfers from fall 2009 – fall 2012.

Last Revised: 8/1/14 Page 49 of 79

Page 50: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots Step 3: To add/remove cohorts from the report, click on the Cohort Description drop-down menu. Place a checkmark next to each cohort you wish to include in your report. Un-check any cohorts you want to remove from your report.

Step 4: Once you have selected all of the cohorts you want to include on the report, click Apply to run the report.

For more information on how to use filters in Data Warehouse, view the Data Warehouse Filtering user guide or web tutorial.

Step 6: The updated report appears.

Last Revised: 8/1/14 Page 50 of 79

Page 51: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Reading the Charts The default setting for the charts (and tables below) is by College (latest). Use the View Numbers By drop-down menu above the chart to view the chart and table broken down by Gender, Ethnicity, Underrepresented Status, Prior Institution Type, Parent Education, College (entry), Cohort Summary, EOP Participation, or FT/PT (1st Term).

Hover your mouse over the chart and a pop-up will appear giving you the specific value for that point on the chart.

Last Revised: 8/1/14 Page 51 of 79

Page 52: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

College (Latest) Chart The New Undergraduate Transfer Cohorts by College (Latest) chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left for the college that the student’s current major is in. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Last Revised: 8/1/14 Page 52 of 79

Page 53: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Gender Chart The New Undergraduate Transfer Cohorts by Gender chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left for each gender. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Last Revised: 8/1/14 Page 53 of 79

Page 54: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Ethnicity Chart The New Undergraduate Transfer Cohorts by Ethnicity chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left for each ethnicity. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Last Revised: 8/1/14 Page 54 of 79

Page 55: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Underrepresented Status Chart The New Undergraduate Transfer Cohorts by Underrepresented Status chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left based on underrepresented status (either yes or no). The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Last Revised: 8/1/14 Page 55 of 79

Page 56: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Prior Institution Type Chart The New Undergraduate Transfer Cohorts by Prior Institution Type chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left for the type of institution that the student came from prior to attending CSUF. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Last Revised: 8/1/14 Page 56 of 79

Page 57: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Parent Education Chart The New Undergraduate Transfer Cohorts by Parent Education chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left for the level of parent education. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Last Revised: 8/1/14 Page 57 of 79

Page 58: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

College (Entry) Chart The New Undergraduate Transfer Cohorts by College (Entry) chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left for the college that the student’s initial major was in. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Last Revised: 8/1/14 Page 58 of 79

Page 59: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Cohort Summary Chart The New Undergraduate Transfer Cohorts Summary chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Last Revised: 8/1/14 Page 59 of 79

Page 60: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

EOP Participation Chart The New Undergraduate Transfer Cohorts by EOP Participation chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left for the EOP Participation status. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Last Revised: 8/1/14 Page 60 of 79

Page 61: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

FT/PT (1st Term) Chart The New Undergraduate Transfer Cohorts by FT/PT (1st Term) chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left for the enrollment type (either full-time or part-time) for the first term. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Last Revised: 8/1/14 Page 61 of 79

Page 62: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Reading the Tables The default setting for the tables (and the charts above) is by College (Latest). Use the View Numbers By drop-down menu above the chart to view the chart and table broken down by Gender, Ethnicity, Underrepresented Status, Prior Institution Type, Parent Education, College (entry), Cohort Summary, EOP Participation, or FT/PT (1st Term).

These counts are current as of today.

Last Revised: 8/1/14 Page 62 of 79

Page 63: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

College (Latest) Table

Users can click on a college to view the breakdown by major or click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the Arts row for Fall 2005 would bring up a list of all undergraduate students who were new transfer students in Fall 2005 with current majors in the College of the Arts who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

College (latest) The code for the academic college that the student’s major is currently in. • ARTS = College of the Arts • CBE = College of Business & Economics • COM = College of Communications • ECS = College of Engineering & Computer Science • H&SS = College of Humanities & Social Sciences • HHD = College of Health & Human Development • MISC = Undeclared or Unknown • NSM = College of Natural Science & Math

Size The number of students in the cohort for the specified academic college.

Degree Count (as of today) The number of students in the cohort for the specified college who have been awarded a degree as of today.

% Graduated The percentage of students in the cohort for the specified college who have graduated.

Enrolled Count (current term) The number of students in the cohort for the specified college who are enrolled in the current term.

% Enrolled & Not Graduated The percentage of students in the cohort for the specified college who are enrolled in the current term and have not graduated.

Not Graduated & Not Enrolled Count

The number of students in the cohort for the specified college who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified college who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 63 of 79

Page 64: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Gender Table

Users can click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the Women row for Fall 2005 would bring up a list of all female undergraduate students who were new transfer students in Fall 2005 who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

Gender The gender of the students.

Size The number of students in the cohort for the specified gender.

Degree Count (as of today) The number of students in the cohort for the specified gender who have been awarded a degree as of today.

% Graduated The percentage of students in the cohort for the specified gender who have graduated.

Enrolled Count (current term) The number of students in the cohort for the specified gender who are enrolled in the current term.

% Enrolled & Not Graduated The percentage of students in the cohort for the specified gender who are enrolled in the current term and have not graduated.

Not Graduated & Not Enrolled Count

The number of students in the cohort for the specified gender who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified gender who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 64 of 79

Page 65: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Ethnicity Table

Users can click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the American Indian row for Fall 2005 would bring up a list of all undergraduate students who identify as the American Indian ethnicity who were new transfer students in Fall 2005 who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

Ethnicity The reported ethnic group of the students in the cohort.

Size The number of students in the cohort for the specified ethnicity.

Degree Count (as of today) The number of students in the cohort for the specified ethnicity who have been awarded a degree as of today.

% Graduated The percentage of students in the cohort for the specified ethnicity who have graduated.

Enrolled Count (current term) The number of students in the cohort for the specified ethnicity who are enrolled in the current term.

% Enrolled & Not Graduated The percentage of students in the cohort for the specified ethnicity who are enrolled in the current term and have not graduated.

Not Graduated & Not Enrolled Count

The number of students in the cohort for the specified ethnicity who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified ethnicity who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 65 of 79

Page 66: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Underrepresented Status Table

Users can click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the Yes row in the Underrepresented Status column for Fall 2005 would bring up a list of all undergraduate students categorized as an underrepresented ethnicity who were new transfer students in Fall 2005 who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

Underrepresented Status The underrepresented status of the students: yes indicates the students are members of an underrepresented group; no indicates that .the students are not members of an underrepresented group.

Size The number of students in the cohort for the specified underrepresented status.

Degree Count (as of today) The number of students in the cohort for the specified underrepresented status who have been awarded a degree as of today.

% Graduated The percentage of students in the cohort for the specified underrepresented status who have graduated.

Enrolled Count (current term) The number of students in the cohort for the specified underrepresented status who are enrolled in the current term.

% Enrolled & Not Graduated The percentage of students in the cohort for the specified underrepresented status who are enrolled in the current term and have not graduated.

Not Graduated & Not Enrolled Count

The number of students in the cohort for the specified underrepresented status who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified underrepresented status who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 66 of 79

Page 67: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Prior Institution Type Table

Users can click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the CA Community College row for Fall 2005 would bring up a list of all undergraduate students who transferred from a community college in California who were new transfer students in Fall 2005 who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

Prior Institution Type The type of institution that the student attended prior to attending CSUF.

Size The number of students in the cohort for the specified prior institution type.

Degree Count (as of today) The number of students in the cohort for the specified prior institution type who have been awarded a degree as of today.

% Graduated The percentage of students in the cohort for the specified prior institution type who have graduated.

Enrolled Count (current term) The number of students in the cohort for the specified prior institution type who are enrolled in the current term.

% Enrolled & Not Graduated The percentage of students in the cohort for the specified prior institution type who are enrolled in the current term and have not graduated.

Not Graduated & Not Enrolled Count

The number of students in the cohort for the specified prior institution type who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified prior institution type who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 67 of 79

Page 68: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Parent Education Table

Users can click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the Parent Attended Some College row for Fall 2005 would bring up a list of all undergraduate students whose parents completed some college who were new transfer students in Fall 2005 who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

Parent Education The highest level of education completed by the students’ parents.

Size The number of students in the cohort for the specified level of parent education.

Degree Count (as of today) The number of students in the cohort for the specified level of parent education who have been awarded a degree as of today.

% Graduated The percentage of students in the cohort for the specified level of parent education who have graduated.

Enrolled Count (current term) The number of students in the cohort for the specified level of parent education who are enrolled in the current term.

% Enrolled & Not Graduated The percentage of students in the cohort for the specified level of parent education who are enrolled in the current term and have not graduated.

Not Graduated & Not Enrolled Count

The number of students in the cohort for the specified level of parent education who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified level of parent education who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 68 of 79

Page 69: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

College (Entry) Table

Users can click on a college to view the breakdown by major or click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the Arts row for Fall 2005 would bring up a list of all undergraduate students who were new transfer students in Fall 2005 who entered CSUF with majors in the College of the Arts who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

College (entry) The code for the academic college that the student’s major upon entering CSUF is in. • ARTS = College of the Arts • CBE = College of Business & Economics • COMM = College of Communications • ECS = College of Engineering & Computer Science • H&SS = College of Humanities & Social Sciences • HHD = College of Health & Human Development • NSM = College of Natural Science & Math • OTHER = Undeclared or unknown

Size The number of students in the cohort for the specified academic college.

Degree Count (as of today) The number of students in the cohort for the specified college who have been awarded a degree as of today.

% Graduated The percentage of students in the cohort for the specified college who have graduated.

Enrolled Count (current term) The number of students in the cohort for the specified college who are enrolled in the current term.

% Enrolled & Not Graduated The percentage of students in the cohort for the specified college who are enrolled in the current term and have not graduated.

Not Graduated & Not Enrolled Count

The number of students in the cohort for the specified college who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified college who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 69 of 79

Page 70: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Cohort Summary Table

Users can click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the Arts row for Fall 2005 would bring up a list of all undergraduate students who were new transfer students in Fall 2005 who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

Size The number of students in the cohort.

Degree Count (as of today) The number of students in the cohort who have been awarded a degree as of today.

% Graduated The percentage of students in the cohort who have graduated.

Enrolled Count (current term) The number of students in the cohort who are enrolled in the current term.

% Enrolled & Not Graduated The percentage of students in the cohort who are enrolled in the current term and have not graduated.

Not Graduated & Not Enrolled Count

The number of students in the cohort who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 70 of 79

Page 71: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

EOP Participation Table

Users can click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the Yes row for Fall 2005 would bring up a list of all undergraduate students who participated in the EOP program who were new transfer students in Fall 2005 who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

EOP Participation The EOP Participation status of the students: yes indicates the students participated in the EOP program; no indicates that .the students did not participate in the EOP program.

Size The number of students in the cohort for the specified EOP Participation status.

Degree Count (as of today) The number of students in the cohort for the specified EOP Participation status who have been awarded a degree as of today.

% Graduated The percentage of students in the cohort for the specified EOP Participation status who have graduated.

Enrolled Count (current term) The number of students in the cohort for the specified EOP Participation status who are enrolled in the current term.

% Enrolled & Not Graduated The percentage of students in the cohort for the specified EOP Participation status who are enrolled in the current term.

Not Graduated & Not Enrolled Count

The number of students in the cohort for the specified EOP Participation status who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified EOP Participation status who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 71 of 79

Page 72: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

FT/PT (1st Term) Table

Users can click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the Full Time row for Fall 2005 would bring up a list of all undergraduate students who started their first term at CSUF as full-time students who were new transfer students in Fall 2005 who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

FT/PT (1st Term) The enrollment type of the student during their first term at CSUF.

Size The number of students in the cohort for the specified enrollment type.

Degree Count (as of today) The number of students in the cohort for the specified enrollment type who have been awarded a degree as of today.

% Graduated The percentage of students in the cohort for the specified enrollment type who have graduated.

Enrolled Count (current term) The number of students in the cohort for the specified enrollment type who are enrolled in the current term.

% Enrolled & Not Graduated The percentage of students in the cohort for the specified enrollment type who are enrolled in the current term.

Not Graduated & Not Enrolled Count

The number of students in the cohort for the specified enrollment type who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified enrollment type who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 72 of 79

Page 73: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

8.0 2-Dimensional Detail

The 2-Dimensional Detail report shows charts and tables with a comparison of cohorts from fall 2004 – present on values such as initial cohort size, degree count, % graduated, enrolled count, % enrolled & not graduated, not graduated & not enrolled count, and % not graduated & not enrolled. Users can choose to see this information for first-time full-time freshman cohorts or for new undergraduate transfer cohorts. Users can also specify two dimensions on which to view the data from among the following: cohort summary, gender, ethnicity, underrepresented status, prior institution type, parent education, college (latest), college (entry), EOP participation, and Freshman Programs participation.

Processing Steps Screen Shots

Running the Report Step 1: On the Student Success dashboard, click on the 2-Dimensional Detail tab.

Step 2: The report will automatically run with your personal settings if you have set them up. If you have not set up your personal settings, the report will run for fall and spring cohorts of new transfers from fall 2009 – fall 2012.

Last Revised: 8/1/14 Page 73 of 79

Page 74: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots Step 3: To change the enrollment type, use the drop-down menu to make a selection.

Step 4: To add/remove cohorts from the report, click on the Cohort Description drop-down menu. Place a checkmark next to each cohort you wish to include in your report. Un-check any cohorts you want to remove from your report.

Step 5: The updated report appears.

For more information on how to use filters in Data Warehouse, view the Data Warehouse Filtering user guide or web tutorial.

Last Revised: 8/1/14 Page 74 of 79

Page 75: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Reading the Charts The default setting for the charts (and tables below) is by Ethnicity and Gender. Use the Dimension 1 and Dimension 2 drop-down menus to view the chart broken down by two of the following: Cohort Summary, Gender, Ethnicity, Underrepresented Status, Prior Institution Type, Parent Education, College (latest), College (entry), Cohort Summary, EOP Participation, Freshman Programs participation, and FT/PT (1st Term).

Once you have made your selections, you will be viewing the chart on two dimensions. For example, the chart on the right shows all new undergraduate transfer students in the Fall 2007 and Fall 2008 cohorts by ethnicity and by gender.

Hover your mouse over the chart and a pop-up will appear giving you the specific value for that point on the chart.

Last Revised: 8/1/14 Page 75 of 79

Page 76: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

2-Dimensional Chart The 2-Dimensional chart shows the percentage graduated versus percentage enrolled versus percentage not graduated & not enrolled for each cohort listed on the y-axis on the left for the two dimensions that you selected. The legend on the right indicates what each color represents on the chart: green for percentage graduated in that cohort, blue for percentage enrolled & not graduated in that cohort, and red for percentage not graduated & not enrolled in that cohort. The chart also provides markers at the 80% and 50%.

Last Revised: 8/1/14 Page 76 of 79

Page 77: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

Processing Steps Screen Shots

Reading the Tables The default setting for the tables (and the charts above) is by by Ethnicity and Gender. Use the Dimension 1 and Dimension 2 drop-down menus to view the chart broken down by two of the following: Cohort Summary, Gender, Ethnicity, Underrepresented Status, Prior Institution Type, Parent Education, College (latest), College (entry), Cohort Summary, EOP Participation, Freshman Programs participation, and FT/PT (1st Term).

These counts are current as of today.

Last Revised: 8/1/14 Page 77 of 79

Page 78: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

2-Dimensional Table

The sample below is an example of one pairing of dimensions; the data on your report will vary depending on which dimensions you select.

Users can click on a count to view information on the specific students who are a part of that count. For example, clicking on the number of students in the Not Graduated & Not Enrolled Count column for the American Indian Women row for Fall 2007 would bring up a list of all undergraduate students who identify as American Indian and as women who were new transfer students in Fall 2007 who have not graduated and are not currently enrolled in classes.

Field Description Cohort Description The catalog year for the cohort. i.e. fa04 = students whose catalog year is fall 2004.

Dimension 1 The first dimension you selected above; in this example the identified ethnicity for the student.

Dimension 2 The second dimension you selected above; in this example the identified gender for the student.

Size The number of students in the cohort for the specified dimensions.

Degree Count (as of today) The number of students in the cohort for the specified dimensions who have been awarded a degree as of today.

% Graduated The percentage of students in the cohort for the specified dimensions who have graduated.

Enrolled Count (current term) The number of students in the cohort for the specified dimensions who are enrolled in the current term.

% Enrolled & Not Graduated The percentage of students in the cohort for the specified dimensions who are enrolled in the current term.

Not Graduated & Not Enrolled Count

The number of students in the cohort for the specified dimensions who have not graduated and are not enrolled in the current term.

% Not Graduated & Not Enrolled The percentage of students in the cohort for the specified dimensions who have not graduated and are not enrolled in the current term.

Last Revised: 8/1/14 Page 78 of 79

Page 79: Data Warehouse - Student Success Reports · Data in the Data Warehouse is refreshed nightly; therefore all Data Warehouse reports reflect numbers/information as of the previous night

9.0 Student Search

The Student Search report allows users to enter the Campus-Wide ID (CWID) of one or more students to view detail information on those students including name, cohort, initial enrollment type, last enrolled term, degree term (if graduated), email, phone number, cell phone number, major at entry, major (latest), gender, ethnicity, underrepresented status, parent education level, units earned, units attempted (current term), units attempted (future term) group qual, cumulative GPA, degree candidate term, degree checkout consideration term & status, academic standing, EOP participation, freshman programs participation, degree audit program, degree audit run date and degree audit status.

Remember that only students from Fall 2004 – present will be found using this search.

Processing Steps Screen Shots

Running the Report Step 1: On the Student Success dashboard, click on the Student Search tab.

Step 2: Type one or more CWIDs into the CWID field. Then click Apply.

Separate multiple CWIDs with a semicolon.

Step 3: The student’s or students’ information appears. Be sure to scroll all the way to the right to view all of the relevant information.

Last Revised: 8/1/14 Page 79 of 79