2016-38: Add Data Fields to Support Multiple Measures for Assessment Placement

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).

Proposed Technical Specifications 

The following technical specifications pertain to the Standard Application only. 

High School Transcript Information Section

1. 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 first question depending on conditional criteria detailed below, otherwise do not display section..
   
   
   1. 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
      
      If response is "Yes" then, display Question #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.
      
       
   2. Condition 2: 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) IF: 
      
      High School Education Level is one of the following:

• • • Received high school diploma from US high school OR
    • 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?

1. Question Text:  "Have you completed the 11th grade?"
2. 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. 
3. Format/Length:  Boolean
4. Type:  NOT downloadable (TBD, this may change but will pitch to committee as a non-downloadable field).

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.

Display new Y/N boolean question to ensure they have completed 11th grade, which is the earliest grade of completion requirement for displaying the new High School Transcript information section.  

Question #1:  Grade Point Average

1.  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 High School Transcript Information section (two conditions listed 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). NOTE: 

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.

1. 1.  Hyperlink under:  "unweighted high school GPA" in the onscreen question text;
   2.  Hyperlink under:  "cumulative unweighted GPA" in the Additional text. 
   3. 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.
       

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." 

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: 

• ONLY 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

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.
  
  

Data Values/Response Options:

=  A

= A-

= B+

= B

= B-

= C+

= C

= C-

= P

= D

= F

= NP

[Branch Logic, IF user selects = D, F, or NP in Question #5: highest math course TAKEN grade,  THEN display question #6 and require a response.  Else, if user selects any response higher than a P or 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 C- or better 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:

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

Question #7. Highest Math Course Passed Grade

Data Field:  highest_math_passed_grade

Condition: ONLY display if question #6 is displayed and require a response. 

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 for the highest math course you passed with a C- (or Pass) grade or better."

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.