These requirements are in the process of being fleshed and documented. Once the Product Owner approves these requirements, the macro can be removed.
This is a high-priority change request coming from the Chancellor's Office to revise, expand, and add conditional formatting to the Race & Ethnicity section in both CCCApply and the International Application. See Change Request 2018-18: Expand Race & Ethnicity Section with New Categories
Current Problem and Business Need
We need to expand the number of ethnicity categories collected on incoming students. There is a business need to expand the categories of ethnicity that are collected via CCCApply and in the International application. The current Student Equity Plan (SEP) guidelines, however, do not include all ethnic groups that are relevant for distinct and diverse local communities served by the 114 colleges. For example, State Center College has a sizable Hmong population in its service area. However, their ability to conduct research, identify equity gaps, and direct resources in ways that will effectively close those gaps has been impeded because “Hmong” is not an ethnicity category that is collected on the standard application. We need to expand the ethnicity group data collected via the standard CCC application (CCCApply) and make that data available via the statewide MIS.
Supporting Documentation (from SSSP Memo)
Excerpts on Student Success and Support Program re Student Equity SEC. 6. Article 1.5 (commencing with Section 78220) is added to Chapter 2 of Part 48 of Division 7 of Title 3 of the Education Code, to read:
Article 1.5. Student Equity Plans 78220.
(a) As a condition for receiving Student Success and Support Program funding, and in order to ensure equal educational opportunities and to promote student success for all students, regardless of race, gender, age, disability, or economic circumstances, the governing board of each community college district shall maintain a student equity plan that includes all of the following for each community college in the community college district:
(1) Campus-based research as to the extent of student equity by gender and for each of the following categories of students:
(A) Current or former foster youth.
(B) Students with disabilities.
(C) Low-income students.
(D) Veterans.
(E) Students in the following ethnic and racial categories, as they are defined by the United States Census Bureau for the 2010 Census for reporting purposes:
(i) American Indian or Alaska Native.
(ii) Asian.
(iii) Black or African American.
(iv) Hispanic or Latino.
(v) Native Hawaiian or other Pacific Islander.
(vi) White.
(vii) Some other race.
(viii) More than one race.
Ethnicity/Ancestry Expansion Proposal
Steering Committee Change Request
/wiki/spaces/PD/pages/640221194
Current CCCApply and International Application Race/Ethnicity Design and Functionality
CCCApply and the International application collects ethnicity information by first asking applicants if they are Hispanic or Latino. Respondents who select “Yes” then see an expanded set of more specific options to choose from. From there, applicants are asked what their race is and they are given limited high level categories to choose from.
CCCApply Application Today
International Application Today
Current Database Values
Race Group (race_group):
01: Hispanic, Latino - (From ‘Are you Hispanic / Latino?’
drop-down menu selection)
02: Mexican, Mexican-American, Chicano
03: Central American
04: South American
05: Hispanic: Other
Race Ethnicity (race_ethnicity):
06: Asian: Indian
07: Asian: Chinese
08: Asian: Japanese
09: Asian: Korean
10: Asian: Laotian
11: Asian: Cambodian
12: Asian: Vietnamese
13: Asian: Filipino
14: Asian: Other
15: Black or African American
16: American Indian / Alaskan Native
17: Pacific Islander: Guamanian
18: Pacific Islander: Hawaiian
19: Pacific Islander: Samoan
20: Pacific Islander: Other
21: White
Functional Mock Up for New Design and Functionality
Attached is a functional excel mockup for how this new layout and functionality should be in both the CCCApply and International Application.
Requirements for New Design and Functionality - Race/Ethnicity Section
Section 1 Requirements - Hispanic/Latino Section
- The first section should ask the following question: "Are you Hispanic or Latino?"
- If user clicks on the checkbox, then the box next to Hispanic or Latino should become automatically checked and the subgroup list expands and becomes visible to display 19 subcategories (race_ethnicity).
- If user does not click on the checkbox, then the box next to Hispanic or Latino should not systematically expand and the user should not see the 19 subcategories race_ethnicity).
Ethnic Group (race_group) | Associated Subgroup (race_ethnicity) |
---|---|
Hispanic or Latino - New DB Value of 100 |
|
Section 2 Requirements
- The following instructions should fall below the Hispanic/Latino Section.
- Check all of the ethnicity and ancestry groups that you identify with. When you select a major ethnicity group, you will have the option to select more specific ancestry groups. Select all that apply and then click on the button that says "Continue".
- The system should then show the following ethnic groups with a checkbox next to each group:
- Asian
American Indian or Alaska Native
- Black or African American
- Native Hawaiian or Other Pacific Islander
- Middle Eastern or North African
- White
- Applicants who select one or more of the Ethnic Groups should then see the subset of more detailed associated subgroups. Multiethnic applicants are able to select as many ethnic groups and ethnic subgroups as needed. When a box is checked an accordion expansion should reveal the associated subgroups. When a box is unchecked, the accordion expansion should roll up to no longer show the subgroups.
- The following table shows a breakdown of the subgroups tied to each ethnic group, as well as the DB value associated in parenthesis.
Ethnic Group (race_group) | Associated Subgroup (race_ethnicity) |
---|---|
Asian - New DB Value of 200 |
|
American Indian or Alaska Native - New DB Value of 300 |
|
Black or African American - New DB Value of 500 |
|
Native Hawaiian or Other Pacific Islander - New DB Value of 600 |
|
Middle Eastern or North African - New DB Value of 700 |
|
White - New DB Value of 800 |
|
In Progress Application Mapping Requirements
Current Database Values | Should Map To |
---|---|
01: Hispanic, Latino - (From ‘Are you Hispanic / Latino?’) | If there is an in progress application and the student has chosen the DV value of race_group 01, then map to new DB value of race_group of 100. |
02: Mexican, Mexican-American, Chicano | If there is an in progress application and the student has chosen the DV value of race_group 02, then map to new DB value of race_group 100 and no mapping for race_ethnicity. |
03: Central American | If there is an in progress application and the student has chosen the DV value of race_group 03, then map to new DB value of race_group 100 and no mapping for race_ethnicity. |
04: South American | If there is an in progress application and the student has chosen the DV value of race_group 04, then map to new DB value of race_group 100 and no mapping for race_ethnicity. |
05: Hispanic: Other | If there is an in progress application and the student has chosen the DV value of race_group 05, then map to new DB value of race_group 100 and no mapping for race_ethnicity. |
06: Asian: Indian | If there is an in progress application and the student has chosen the DV value of race_ethnicity 06, then map to new DB value of race_group 200 and map to race_ethnicity DB value of 06. |
07: Asian: Chinese | If there is an in progress application and the student has chosen the DV value of race_ethnicity 07, then map to new DB value of race_group 200 and map to race_ethnicity DB value of 07. |
08: Asian: Japanese | If there is an in progress application and the student has chosen the DV value of race_ethnicity 08, then map to new DB value of race_group 200 and map to race_ethnicity DB value of 08. |
09: Asian: Korean | If there is an in progress application and the student has chosen the DV value of race_ethnicity 09, then map to new DB value of race_group 200 and map to race_ethnicity DB value of 09. |
10: Asian: Laotian | If there is an in progress application and the student has chosen the DV value of race_ethnicity 10, then map to new DB value of race_group 200 and map to race_ethnicity DB value of 10. |
11: Asian: Cambodian | If there is an in progress application and the student has chosen the DV value of race_ethnicity 11, then map to new DB value of race_group 200 and map to race_ethnicity DB value of 11. |
12: Asian: Vietnamese | If there is an in progress application and the student has chosen the DV value of race_ethnicity 12, then map to new DB value of race_group 200 and map to race_ethnicity DB value of 12. |
13: Asian: Filipino | If there is an in progress application and the student has chosen the DV value of race_ethnicity 13, then map to new DB value of race_group 200 and map to race_ethnicity DB value of 013. |
14: Asian: Other | If there is an in progress application and the student has chosen the DV value of race_ethnicity 14, then map to new DB value of race_group 200 and map to race_ethnicity DB value of 14. |
15: Black or African American | If there is an in progress application and the student has chosen the DV value of race_ethnicity 15, then it should be mapped to DB value of race_group 500 and map to race_ethnicity DB value of 15. |
16: American Indian / Alaskan Native | If there is an in progress application and the student has chosen the DV value of race_ethnicity 16, then it should be mapped to DB value of race_group 300, no mapping race_ethnicity. |
17: Pacific Islander: Guamanian | If there is an in progress application and the student has chosen the DV value of race_ethnicity 17, then it should be mapped to DB value of race_group 600 and map to race_ethnicity DB value of 17. |
18: Pacific Islander: Hawaiian | If there is an in progress application and the student has chosen the DV value of race_ethnicity 18, then it should be mapped to DB value of race_group 600 and map to race_ethnicity DB value of 18. |
19: Pacific Islander: Samoan | If there is an in progress application and the student has chosen the DV value of race_ethnicity 19, then it should be mapped to DB value of race_group 600 and map to race_ethnicity DB value of 19. |
20: Pacific Islander: Other | If there is an in progress application and the student has chosen the DV value of race_ethnicity 20, then it should be mapped to DB value of race_group 600 and map to race_ethnicity DB value of 20. |
21: White | If there is an in progress application and the student has chosen the DV value of race_ethnicity 21, then it should be mapped to DB value of race_group 800 and no mapping to race_ethnicity. |
- Requirements above apply to both the Apply and international applications.
- Data Dictionary for both Apply and International applications should be updated to reflect new Database values and mappings.
- No changes to the current DB size limit.
Release Information To Colleges
- The system does not store names; maps to numerical values. DB is a text field which has unlimited length. When we store the choice user makes, we save code value - no names are stored.
- Colleges will need to absorb the new options and replace their DLC jar file for the categories added to the response options for the Race & Ethnicity download field(s).
- No changed are needed to the Download client from Unicon's side. Colleges will need to adjust their format file. If a college is using a fix width columns, they may need to adjust based on a student selecting multiple groups and ethnicities.