Problem / Issue
The Common Assessment Initiative (CAI) is requesting the addition of a series of new data field questions to the CCCApply Standard Application for the purpose of collecting aggregate data (multiple measures)in support of assessment placement for the CCC Assess program. The CCCAssess pilot program includes 40 California Community Colleges; testing with pilot cohort begins on September 20, 2016. Implementation of these new data fields is needed as part of the Apply September 2016 release.
NOTE: This onscreen and data download change warrants a 60 day notification to colleges. Communication will begin in mid-July and the changes will need to roll to Pilot 30 days prior to release.
Proposed Solution
This change only pertains to the CCCApply Standard Application only.
Add a new section to the Education page called, "High School Transcript Information", which will include 7 new downloadable data field questions asking students for GPA and highest English and Math courses taken and passed, and their respective grades, at the time of application. The section should appear below the "Last HS Attended" section only if the student meets conditional criteria. CAI is only interested - at this time - in data pertaining to "high school course and grade information". The data fields will consist of one text input field (GPA) with validation for number format (must be 0.00 - 4.00), and four "menu" fields. The questions and data fields will be added to the Download Client and will be available in the Student Profile Service, Application Rules, and the Report Center.
User Stories
- As a college transfer counselor, I need to collect specific high school transcript information from students who have graduated from high school, or equivalent, or are still in high school, in the United States, for the purposes of assessing placement testing through the CCCAssess program (a project of the CCC Technology Center).
- As a college assessment placement counselor, I need to ensure "High School Transcript Information" is available in the Download Client so it can be imported to the CCC Report Center for research and analysis.
- As a CCC researcher, I need to be able to run reports on the "High School Transcript Information" in the CCC Report Center.
- As a product manager/program manager of the Common Assessment Initiative (CAI), I need to ensure the "High School Transcript Information data is available in the Student Profile Service.
Requirements Summary
See data specifications for these new data fields attached (to JIRA ticket).
# | Description | Notes/Comments |
---|---|---|
1 | Add New "High School Transcript Information" Section on Education Page Add new conditional section to the Education page labeled "High School Transcript Information" which only displays if the applicant is currently in high school (or lower grade), has completed high school (or equivalent), and attended high school in the US. | Based on High School Ed Level, Attended HS in US. |
2 | Add New Boolean Question: "Have you completed 11th grade?" Only display IF user's HS Ed Level = "Attending HS (or lower grade) and college at same time" AND "high school country = United States" THEN display new "Have you completed the 11th grade?" question and require a response.
| New as of 7/6/16 |
4 | Develop 7 new downloadable data fields with conditions, validation, hover help (where appropriate), format/length, .
Each question and corresponding data field is specified separately, including data element details, conditions, validations, error messages, Pop-Up Help (grade poiint average), and Hover Help (grade point average). | |
5 | Add New Question #1: Grade Point Average Question: "What was your unweighted high school GPA (grade point average)?" Display question and require a response ONLY if users have the following High School Ed Levels:
AND
OR Appears if
AND
AND
This is a downloadable data field which will be added to the Download Client, Report Center, Rules, and Student Profile Service. | |
9 | Add Help Pop-Up Box to Question #1: Grade Point Average Unweighted / Cumulative Grade Point Average | |
10 | Add Hover Help to Question #1: "Grade Point Average" text input field only. No translation to Spanish due to accessibility restriction. "Enter your unweighted or cumulative high school grade point average. Must be a value between 0.00 and 4.00." | |
7 | Add New Question #2: Highest English Course Question Text: "What was the highest English course you completed in high school? Conditions: Display and require a response if:
This is a downloadable data field which will be added to the Download Client, Report Center, Rules, and Student Profile Service. | |
Add New Question #3: Highest English Course Grade Question Text: "What grade did you receive?" | ||
8 | Add New Question #4: Highest Math Course Taken Question Text: "What was the highest math course you took in high school? Conditions: Display question and require a response IF:
This is a downloadable data field which will be added to the Download Client, Report Center, Rules, and Student Profile Service. Conditions for Questions #4: Highest Math Course Taken
This is a downloadable data field which will be added to the Download Client, Report Center, Rules, and Student Profile Service. | |
Add New Question #5: What grade did you receive? Question Text: "What grade did you receive?" Conditions: Display and require a response IF:
DO NOT DISPLAY
| ||
Add New Question #6: What was the highest math course you completed in high school? | ||
9 | Add Help Pop-Up Box in Question #1: Grade Point Average Add hyperlinks under "unweighted grade point average" and "cumulative unweighted grade point average" and display Help Box Text (see below). | |
10 | Add Hover Help to Question #1: "Grade Point Average" text input field only. No translation to Spanish. (see below). | |
11 | Review Application Page: Add "High School Transcript Information" section and all questions to the Review Application page. | |
12 | Submitted Applicatons View PDF Page: Add new data fields to the "Submitted Application PDF" for the Standard Application only. | |
13 | Download Client: Add all 7 new data fields to Download Client. | |
14 | Database: Add all 7 new data fields to Standard Application submitted applications database for Rules (Administrator) and Report Center. | |
15 | Profile Service: Ensure all 7 new data fields are available to the Student Profile Service (What does that look like as far as requirements?) | |
16 | Data Dictionary: Update Specs: The Standard Application Data Dictionary will be updated to include a summary of the section and specific data field specifications. | See proposed Specs attached |
Proposed Technical Specifications
The following technical specifications pertain to the Standard Application only.
Conditions for New High School Transcript Information Section
- Add new section to the Education page in the Standard Applicationn for: "High School Transcript Information" between the Last High School Attended section and the College Education Level section and display "question" depending on conditional criteria detailed below, otherwise do not display section..
- Condition 1: Concurrent Enrollment User has Completed 11th Grade
Display "High School Transcript Information" section with new Yes/No boolean question, "Have you completed the 11th grade?" and require a response ONLY IF:
High School Education Level = "Attending high school (or lower grade) and college at the same time"
AND
High school Country = United States
AND
Response to new boolean question, "Have you completed 11th grade?" is YES.
- Condition 2: US High School Graduates or Equivalent
Display "High School Transcript Information" section with Question #1: Grade Point Average (and DO NOT display boolean 11th grade question above) ONLY IF:
High School Education Level is one of the following:
- Condition 1: Concurrent Enrollment User has Completed 11th Grade
- Received high school diploma from US high school
- Passed a high school equivalency test
- Received a Certificate of California High School Proficiency;
AND
High School Country <hs_country> is “United States”
THEN, display new "High School Transcript Information" section with Questions #1, #2, and #4 always.
ELSE, DO NOT DISPLAY NEW SECTION or any section questions.
Add new boolean question: "Have you completed the 11th grade?
- Question Text: "Have you completed the 11th grade?"
- Condition: ONLY display this question IF 1) High School Education Level = "attending high school (or lower grade) and college at the same time" AND 2) "hs_country = United States", ELSE do not display this question before displaying Question #1: Grade Point Average.
- Format/Length: Boolean
- Type: NOT downloadable (TBD, this may change but will pitch to committee as a non-downloadable field).
- Response Options: Yes or No
- Error Validation: Required response, else error message, "You must indicate if you have completed 11th grade or not."
Display Logic:
- If response is "Yes" then, display Questions #1: Grade Point Average, Question #2, and Question #4.
- If response is "No" then, DO NOT display any subsquent questions in High school Transcript Information section and skip to "College Education Level" section.
NOTES: This question is being added to differentiate between the users who should see and answer Question #1: Grade Point Average, and those who should not. If the user should not answer Question #1, then DO NOT DISPLAY any of the High School Transcript section questions to them.
Display new Y/N boolean question to ensure the concurrent enrollee has completed 11th grade, which is the earliest grade of completion requirement for displaying the new High School Transcript information section.
Screenshot:
Question #1: Grade Point Average
- Add new downloadable data field and onscreen question #1: Grade Point Average" to High School Transcript Information section.
2. Display If user meets criteria for either condition outlined in High School Transcript Information section above.
a. Data element name: grade_point_average
b. Conditions: Display If student meets either condition listed above for the High School Transcript Information section and require a response. (see conditions above).
c. Format Type/Length: Varchar 5
c. Values: text input
d. Question Text: "What was your unweighted high school GPA (grade point average)? Please enter a value between 0.00 and 4.00."
e. Additional text: "If you are still in high school, enter your cumulative unweighted GPA as of the end of 11th grade."
f. Help Pop-Up Text: Add one new Help Pop-Up Text Box to this question. There are two (2) hyperlinks that trigger the same Help Pop-Up Box.
- Hyperlink under: "unweighted high school GPA" in the onscreen question text;
- Hyperlink under: "cumulative unweighted GPA" in the Additional text.
- Text:
High School Transcript: Grade Point Average
You may want to refer to your high school transcript to answer this question.
Cumulative GPA: This is the running total of your GPA that includes all of your high school coursework.
Unweighted GPA: Typically, transcripts will show both a weighted and unweighted GPA. The unweighted GPA has a maximum value of 4.0 and does not assign extra points or “weight” to classes that are more difficult such as AP or Honors classes.
g. Hover Help: Add English hover help to the <grade_point_average> input text field with the following text:
"Enter a numeric value between 0.00 and 4.00 that indicates your unweighted or cumulative unweighted high school grade point average."
h. Field Error Validation:
Patty needs to work with Josh on these validations.
1. Client side validation:
- Must be a numeric value between 0.00 - 4.00, else error message, "You must enter a value between 0.00 and 4.00. Please try again."
2. Server validation:
- Must be a numeric value between 0.00-4.00. Ensure highest number entered is 4.00.
- Must be a numeric value between 0.00-4.00. Ensure highest number entered is 4.00.
i. Page Error Validation:
Patty needs to work with Josh on these validations.
- Required response, else error message, "You must enter your unweighted high school GPA (grade point average). Please enter a numeric value between 0.00 - 4.00."
- Must not be 0.00 or higher than 4.00, else error message, "You must enter a value between 0.00 and 4.00. Please try again."
Screenshot:
Question #2: Highest English Course
Data Field: highest_english_course
Condition: Always display If user meets either condition for High School Transcript Information listed above.
Question Text: "What was the highest English course you took in high school?
Additional text: "If you are currently enrolled in high school, this would typically be in 11th grade or earlier."
Data values/Response Options:
1 = 12th grade Advanced Placement (AP) English Composition or Literature
2 = 12th grade Honors English Composition or Literature
3 = 12th grade English Composition or Literature
4 = 11th grade Advanced Placement (AP) English Composition or Literature
5 = 11th grade Honors English Composition or Literature
6 = 11th grade English Composition or Literature
7 = 10th grade (or lower) English Composition or Literature
8 = None of the Above / Don’t Know
Field Error Validation:
Page Error Validation: Required response if displayed on screen, else error message, "You must select the highest English course you took in high school."
Branching Logic: If the student selects "None of the Above / Don't Know" then DO NOT show the question #3 "What grade did you receive?" Otherwise display question #3.
Question #3: Highest English Course Grade
"What grade did you receive?"
Data Field: highest_english_grade
Condition:
- Display if the student selects any response OTHER THAN "None of the Above / Don't Know" in question #2,
- Therefore, DO NOT Display If student selects "None of the Above / Don't Know". Skip to question #4.
Question Text: "What grade did you receive?"
Data Values/Response Options:
⎯ A
⎯ A-
⎯ B+
⎯ B
⎯ B-
⎯ C+
⎯ C
⎯ C-
⎯ P
⎯ D
⎯ F
⎯ NP
Page Error Validations: Required if response to "Highest English Course Taken" is NOT "None of the Above / Don't Know", else error message, "You must select the grade you received for the highest English course you took in high school."
DISPLAY Logic: Always display question #4 - "What was the highest math course you took in high school?" and require a response.
- Always display question #4 IF the student meets criteria for either of the two conditions in "High School Transcript Information" section listed above,
Question #4: Highest Math Course Taken
Data Field: highest_math_course_taken
Condition: Always Display and require a response IF criteria is met for either condition listed in "High School Transcript Information" section listed above.
Question Text: "What was the highest math course you took in high school?
Additional Text: "If you are currently enrolled in high school, this would typically be in 11th grade or earlier."
Data Values/Response Options:
1 = Pre-algebra or lower
2 ⎯ Algebra 1
3 ⎯ Geometry
4 ⎯ Algebra 2
5 ⎯ Trigonometry
6 ⎯ Pre-calculus
7 ⎯ Calculus
8 ⎯ Statistics
9 = Integrated Math 1
10 = Integrated Math 2
11 = Integrated Math 3
12 - Integrated Math 4
13 - None of the Above / Don't Know
Page error validation: Required response, else error message, "You must select the highest math course you took in high school."
Branching Logic: ONLY display Question #5, "What grade did you receive?" IF user selects any response OTHER THAN "None of the Above / Don't Know" in Question #4.
If they choose "None of the Above / Don't Know" in Question #4, then DO NOT SHOW question #5, #6 or #7 ,
Question #5: Highest Math Taken Grade
"What grade did you receive?"
Data Field: highest_math_taken_grade
Condition:
- Display UNLESS the student selects "None of the Above / Don''t Know" in question #4, then DO NOT display this question #5, or #6 or #7.
- If the student selects any response OTHER than "None of the Above..." then display qustion #5 "What grade did you receive?" and require a response.
Question Text: "What grade did you receive?"
Data Values/Response Options:
= A
= A-
= B+
= B
= B-
= C+
= C
= C-
= P
= D
= F
= NP
Page Error Validation: Required response, else error message, "You must select the grade you received in the highest math class you took in high school."
Branch Logic:
- IF user selects = D, F, or NP, THEN display question #6 and require a response.
- Else, if user selects any response higher than a P, C- or better, DO NOT DISPLAY questions #6 or #7.
Question #6. Highest Math Course Passed
Data Field: highest_math_passed
Condition: ONLY display if the student selects a grade of "D, F, or NP" in question #5.
Question Text: "What was the highest math course that you passed with a Pass, C-, or better grade, in high school?"
This sentence may be changed or removed: Additional Text: If you are currently enrolled in high school, this would typically be in 11th grade or earlier."
Data Values/Response Options:
- = Pre-Algebra (or lower)
- = Algebra 1
- = Geometry
- = Algebra 2
- = Trigonometry
- = Pre-calculus
- = Calculus
- = Statistics
- = Integrated Math 1
- = Integrated Math 2
- = Integrated Math 3
- - Integrated Math 4
Page error validation: Required response, else error message, "You must select the highest math course you passed with a Pass, C-, or better grade, in high school?"
Question #7. Highest Math Course Passed Grade
Data Field: highest_math_passed_grade
Condition: ONLY display if question #6 is displayed .
Question Text: “What grade did you receive?”
Data Values/Response Options:
= A
= A-
= B+
= B
= B-
= C+
= C
= C-
= P
Page Error Validation: Required response if Question #6 is displayed,else error message, "You must select the grade you received in the highest math course you passed with a Pass, C-, or better grade, in high school."
Supporting Documentation
This is the original set of questions I received from the CAI team. Don't go by this - questions and conditions have changed.