Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Request No.2016-38
Date of Request6.13.16
RequesterJennifer Coleman
CAI Program Manager
Application(s)Standard
Section / Page

Education

Steering Hearing Date6.16.16
Proposed Change to Download FileYes
Proposed Change to Residency LogicN/A
JIRA

Jira Legacy
serverJIRA (cccnext.jira.com)
serverIda79f1fc5-1ea0-3960-95ec-ad67852870f1
keyOPENAPPLY-3225

Table of Contents


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

 

#DescriptionNotes/Comments
1Add 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?"

IF applicant has a Only display IF user's HS Ed Level = "enrolled in Attending HS (or lower grade) and college at same time" then display new Yes/No question, " AND "high school country = United States" THEN display new "Have you completed the 11th grade?" Yes or No. (Note: This logic triggers firstto determine if the Special K12 high school applicant has completed 11th grade and therefore should answer the subsequent questions or not.)

If they say "No" to 11th grade question - DO NOT DISPLAY any of the HS Transcript questions -

" question and require a response.

  • If response = "No" - DO NOT DISPLAY any of the HS Transcript questions. This student is too young and their data is not being collected.
  • If they say response = "Yes" to 11th grade question - THEN DISPLAY Question #1: Grade Point Average, Question #2: Highest English Course Taken; and Question #4: Highest Math Course Taken and require responses to each question. (The conditional corresponding "grade received" questions are conditional based on the answers to the grade fields will be conditional) and continue with following logicwhether the user selects, "None of the Above /Don't Know" to preceding questions.  
  • NOTE: This conditional boolean question is not downloadable.
New as of 7/6/16
4Develop 7 new downloadable data fields with conditions, validation, hover help (where appropriate), format/length, .
  • grade_point_average (varchar 5)
  • highest_english_course (integer)
  • highest_english_grade (varchar 2)
  • highest_math_course_taken (integer)
  • highest_math_taken_grade (varchar 2)
  • highest_math_course_passed (integer)
  • highest_math_passed_grade (varchar 2)

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)?"
Additional Text: "Enter a value between 0.00 and 4.00. If you are still in high school, this is tp"

Display question and require a response ONLY if users have the following High School Ed Levels:

  • Received high school diploma from US high school
  • Passed a high school equivalency test
  • Received a Certificate of California High School Proficiency;

AND

  • HS Country = United States

OR Appears if

  • HS Ed Level = "Will be attending high school (or lower grade) and college at the same time";

AND

  • HS Country = United States

AND

  • "Have you completed 11th grade?" is YES.

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
Add hyperlinks under "unweighted grade point average" and "cumulative unweighted grade point average" and display Help Box Text with following text:

Unweighted / Cumulative 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. 

 
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?  
Additional text: "If you are currently enrolled in high school, this would typically be in 11th grade or earlier."

Conditions: Display and require a response if:

  • Question #1 "Grade Point Average" is displayed (conditions are the same for displaying Questions 1, 2, and 4).
  • If the user selects "None of the Above / Don't Know", then DO NOT display question #3 "What grade did you receive?" 

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?"
Conditions: Display ONLY if response to Question #2 is NOT "None of the above / Don't know". 
This is a downloadable data field which will be added to the Download Client, Report Center, Rules, and Student Profile Service. 

 
8

Add New Question #4: Highest Math Course Taken

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

Conditions: Display question and require a response IF:

  • Question #1 "Grade Point Average" is displayed (conditions are the same for displaying Questions 1, 2, and 4).
  • If the user selects "None of the Above / Don't Know", then DO NOT display question #5, "What grade did you receive?"
  • If the user selects ANY OTHER RESPONSE besides "None of the Above / Don't Know", then display question #5.
  • If the user selects "None of the Above / Don't Know", then DO NOT display questions #6 or #7. End section with question #4.

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

  • If the student selects "None of the Above / Don''t Know" in question #4, then DO NOT display question #5, #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.
  • If the student selects a grade of A, A-, B+, B, B-, C+, C, C-, or P" then DO NOT display question #6 or #7.
  • If the student selects a grade of "D, F, or NP" then display question #6 and require a response AND display question #7 and require a response.

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:

  • student selects any response OTHER THAN "None of the Above / Don't Know" in question #4

DO NOT DISPLAY

  • If the student selects "None of the Above / Don't Know" in question #4 THEN - DO NOT DISPLAY questions #5, #6, or #7 ;
  • If the student selects (response option for) grade = A, A-, B+, B, B-, C+, C, C-, or P, THEN DO NOT display question #6 or #7.
 
 Add New Question #6: What was the highest math course you completed in high school? 
9Add 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). 
 
10Add Hover Help to Question #1: "Grade Point Average" text input field only. No translation to Spanish. (see below). 
11Review Application Page: Add "High School Transcript Information" section and all questions to the Review Application page. 
12Submitted Applicatons View PDF Page: Add new data fields to the "Submitted Application PDF" for the Standard Application only. 
13Download Client: Add all 7 new data fields to Download Client. 
14Database: Add all 7 new data fields to Standard Application submitted applications database for Rules (Administrator) and Report Center. 
15Profile Service: Ensure all 7 new data fields are available to the Student Profile Service (What does that look like as far as requirements?) 
16Data 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

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 IF the student meets the following conditional criteria; and display first question depending on conditional criteria detailed below, otherwise do not display section..

    1. Condition 1: Concurrent Enrollment if user User has completed Completed 11th grade: 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 IF: 
      (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 Grade Point Average question only.Questions #1, #2, and #4 always. 

ELSE, DO NOT DISPLAY NEW SECTION or any section questions.

Conditional Boolean Question:

Add new boolean question: "Have you completed the 11th grade?

  1. Display new Y/N boolean question before the "Grade Point Average" question to sub-set of conditional users who are still in high school or lower grade per their HS Ed Level AND HS Country = US. 
  2. Question Text:  "Have you completed the 11th grade?"
  3. Condition:  ONLY display this question IF 1) High School Education Level = "Question Text:  "Have you completed the 11th grade?"
  4. 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. 
  5. Format/Length:  Boolean
  6. 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 can answer the should see and answer Question #1: Grade Point Average question , and those who cannotshould not. If the user should not answer Question #1: Grade Point Average, then they do not see or answer , then DO NOT DISPLAY any of the subsequent 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" question and downloadable data field to High School Transcript Information section.

2.  Display new downloadable data question: Grade Point AverageIf 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 criteria either condition listed above for the High School Transcript Information section above, then always display the "Grade Point Average" question and require a response. (see conditions above).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." 

    NOTE:  Ensure Help pop-up hyperlink is added under "unweighted high school GPA" and triggers the Help Pop-Up box, specified below.

e. Additional text:  "If you are still in high school, enter your cumulative unweighted GPA

 

as of the end of

11th grade. If you have not completed

11th grade

, you must enter 0

.

00.

"

 

f. Help Pop-Up Text: Add one new Help Pop-Up Text Box to

the "Grade Point Average"

this question. There are two (2) hyperlinks that trigger

this single

the same Help Pop-Up Box.

    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" <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. If you have not completed 12th grade, enter your 11th grade." 

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, or enter 0.00 if you are in 10th grade or lower".
    • Must not be 0.00 if High School Education Level is not "Enrolled in high school (or lower grade) and college at the same time".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:  If the Grade Point Average question is NOT 0.00 - then always display Question #2: Highest English Course Always display If user meets either condition for High School Transcript Information listed above.

Question Text:  "What was the highest English course you completed 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 next 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 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" then DO NOT display question #3.  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

DISPLAY Logic:  Always display question #4 - "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.

  • If the student enters any value other than 0.00 in the "Grade Point Average" question field, then display Question 4 and require a response.
  • If the student selects "None of the Above / Don''t Know" in question #4, then DO NOT display question #5, #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.
  • If the student selects a grade of A, A-, B+, B, B-, C+, C, C-, or P" then DO NOT display question #6 or #7.
  • If the student selects a grade of "D, F, or NP" then display question #6 and require a response AND display question #7 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 "Question #1: Grade Point Average" (appears  on screen).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"
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

't Know

 

Branching Logic: ONLY display Question #5, "What grade did you receive?"
Data Field: highest_math_taken_grade 

Condition

If the student selects

IF user selects any response OTHER THAN "None of the Above / Don

'

't Know" in

question #4, then DO NOT display question #5, #6 or #7

Question #4.
If

the student selects any response OTHER than

they choose "None of the Above

..." then display qustion #5

/ Don't Know" in Question #4, then DO NOT SHOW question #5, #6 or #7 ,

 


Question #5: Highest Math Taken Grade

If

"What grade did you receive?"

and require a response.



Data Field: highest_math_taken_grade 

Condition

  • Display UNLESS the student selects a grade of A, A-, B+, B, B-, C+, C, C-, or P" "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 a grade of "D, F, or NP" then display question #6 any response OTHER than "None of the Above..." then display qustion #5 "What grade did you receive?" and require a response AND display question #7 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 ONLY display if the student selected 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 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

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.

View file
nameSelfReportedDataGuide_6.13.16 (1).docx
height250