Quest_CPS_07_Specs

College Prep Scholarship 07 Specs

NOTE: Unless otherwise specified, removed fields/tables should be retained in the DB schema as they may be used in the College Match 07 application.

Wizard Specs

The Wizard will replicate the functionality and interface of the CM Wizard. There will be a few changes for the CPS, but the changes will be kept minimal.

The main sections of the Wizard will be:

Personal Information
Household Information
School Information
Essays
College Match

Personal Information

The Personal Information section will replicate the questions, interface, and logic of the Personal Information section from the College Match application.

The following changes will be made to the Personal Information section:

Personal Information

Remove 'Telephone at mailing Address'
Remove 'Country of family origin'
The 'Year of high school graduation' options should be: 2007, 2008, 2009
Ethincity: migrate back CPS 06 options. The migration mapping is:
- African American, Black --- Black/African American
- Native American, Alaska Native --- American Indian/Alaska Native
- Asian American --- Other Asian American
- Asian, including Indian Subcontinent --- South Asian/Indian
- Hispanic, Latino --- Latin American/Latino
- Mexican American, Chicano --- Mexican American/Chicano
- Native Hawaiian, Pacific Islander --- Ethnic Hawaiian
- Puerto Rican --- Puerto Rican American
- White or Caucasian --- White/Non-minority American
- Other --- Unknown/Other
- Decline to State --- Decline to State

Additional Information

Remove '... relatives who are alumni/ae at any of our partner colleges/universities ...'
Remove 'Please list any of your family members or relatives who are presently employed at any of our partner colleges/universities'
Add 'Fastweb' as an option to the 'How did you heard about QuestBridge?'
For the sophmore referrals, the 'Year of Graduation' options should be: 2009, 2010, 2011
Add quest 'Have either of your parents/guardians graduated from a non-US-based four-year college?'. The value options are: Yes, No, Don't know
Add quest 'Have either of your parents/guardians graduated from a US-based four-year college?'. The value options are: Yes, No, Don't know
Migrate the 'Have either of your parents/guardians graduated from a four-year college?' question to 'Have either of your parents/guardians graduated from a non-US-based four-year college?'
Remove 'Have either of your parents/guardians graduated from a four-year college?'.
Remove 'Will you be applying for financial aid'
Remove 'Will ou be on your parent's health insurance plan'

Educational / Career Interests

Add 'MIT' and 'Yale University' to the list of colleges 'you are interested in attending'
Add question 'Please select your career goals'. The custom value options are: Artist, Architect, Business, Doctor, Economist, Engineer, Foreign Service, Journalist, Lawyer, Nurse, Professor, Politician, Scientist, Religious Official, Teacher, Other. When the user check's the 'Other' box, a textfield should appear where the user can enter a description.
For 'are you interested in attending' question, change the label of the 'Does not matter' option to 'Any of the above'.
Add 'What are your career goals and how did you come to choose them?'. Place a 50 word limit on the answer.

Extracurricular Information

Place character limit of 128 characters on 'Activity'
Place character limit of 255 characteres on 'Positions held, honors won, ...'
Place word limit of 50 words on 'What are your hobbies?'
Place character limit of 128 on 'Are you intersted in participating in either of the following in college?'
Remove '12' and 'PS' from 'Grade Level or post-secondary'
Remove 'List and describe your activities including summer jobs ...'
Remove 'Hobbies' question

Work Experience

Place character limit of 128 characters on 'Specific nature of work'
Place character limit of 128 characters on 'Employer'
Need to store user's answer to 'Check if summer job only' question
Place word limit of 50 words on 'To what use have you put your earnings?'

Household Information

The Household Information section will replicate the questions, interface, and logic of the Household Information section from the College Match application.

The following changes will be made to the Household Information section:

Household Information

Parent/Guardian Detail

Break up the questions into multiple sections (This is an UI change, Quest is responsible for it).
In the title for the section, please add relationship. The title currently states 'Parent/Guardian Detail: FIRST_NAME LAST_NAME'. It should read like 'Parent/Guardian Detail: FIRST_NAME LAST_NAME (Relationship: RELATIONSHIP). The 'RELATIONSHIP' should be carried over from the 'Household Information' form.
Add 'How long has this person been in the U.S.?'. The options are: Less than 3 years, 3 to 5 years, 5 to 10 years, 10 to 20 years, More than 20 years.

Sibling Information

Break up the questions into multiple sections (This is an UI change, Quest is responsible for it).
Remove 'Current year in school'
Remove 'Which country is the college located in?'
Remove 'Year of college completion'
Remove 'Area of concentration'
Remove 'Name of professional or graduate school'
Remove 'Degree received in professional or graduate school'
Remove 'Year in which graduate degree was received'
Remove 'College attending or attended (if any)'

Household Income

Place character limit of 128 characters on 'Job Description'

Noncustodial Waiver

Remove the 'Noncustodial Waiver' form. It is not part of CPS '07.

School Information

High School Information

Allow user to 'Delete School'. The 'Delete' link should remove the school from the user's list. We should only remove the relationship between the user and the school, we should leave the school information in the database.
List all High Schools entered by the user. Each listing should have a 'Edit' and 'Delete' link. When user clicks on 'Edit', the form below the listing appears with information of the school. There will only be 1 editable school information shown at a time.
The 'Add another High School' functions as same as before. It displays an empty form where the user can enter school information.
The 'Save & Add another' button will save the school information and reload the 'High School Information' form so the user can enter another High School.

Other School Information

Allow user to 'Delete School'. The 'Delete' link should remove the school from the user's list. We should only remove the relationship between the user and the school, we should leave the school information in the database.
List all 'Other Schools' entered by the user. Each listing should have a 'Edit' and 'Delete' link. When user clicks on 'Edit', the form below the listing appears with information of the school. There will only be 1 editable school information shown at a time.
The 'Add another School' functions as same as before. It displays an empty form where the user can enter school information.
Place a word limit of 50 words for 'School Description'
The 'Save & Add another' button will save the school information and reload the 'School Information' form so the user can enter another School.

Academic Information

Place word limit of 50 words for 'extenuating circumstances' question
Place character limit of 128 characters for 'Honor title or description' question
Add Term System question (moved up from Transcript level)

Transcript

Suppress 12th Grade Transcript form for CPS (we will bring it back for CM, so leave supporting code/tpl in place).
Remove 'Term System' question from '9th Grade Transcript', '10th Grade Transcript', '11th Grade Transcript'
Remove '1st Term Grade', '2nd Term Grade', '3rd Term Grade', '4th Term Grade'
Add 'Grade' question for each course. The 'Grade' question should work exactly as how the '1st Term Grade' question worked in CM.
- For the 'Did any school you attended throughout high school use a grading system other than A-B-C-D-F?', if the user entered 'No' then the 'Grade' question should show a drop-down menu with the options 'A+', 'A', 'A-', 'B+', 'B', 'B-', 'C+', 'C', 'C-', 'D+', 'D', 'D-', 'Pass', 'Fail'.
- For the 'Did any school you attended throughout high school use a grading system other than A-B-C-D-F?', if the user entered 'Yes' then the 'Grade' question should show a text box.
Add 'Grading Period' question (column) (quest_transcript_course.grade_period_id) for each course. The option should be a drop-down. The options included are dependent on the value of quest_student.term_system_id (set on Academic form). The logic for displaying the drop-down is listed in the mockups under 'Engineer's Notes'. Since the options need to be filtered, we'll just put them in the code, rather than in an option_group in the DB.
'Grading Period' is a required question for any populated course "row" - UNLESS the student's Term System is "Other". In this case the entire column is hidden.
Place character limit of 128 characters on 'Course Title'
User should be able to add up to 20 courses.

Testing Information

Move the 'How do you plan to study' question from 'Additional Information' to 'Testing Information'
Add 'PSAT' test.
- Please refer to the mockups for additional information
Add 'Pre-ACT (PLAN)' test
- Please refer to the mockups for additional information
Add 'Physics C' to the 'Subject' drop-down for 'AP Tests'
Remove 'Physics A' from the 'Subject' drop-down for 'AP Tests'
Spelling correction: In 'AP Tests' in the 'Subject' drop-down' the option that currently reads 'Latin: Vergin' should read 'Latin: Vergil'

Recommendations

The student is required to enter at least 1 recommender. The student can enter up to 3 recommenders.
A contact record, and a relationship record between the recommender and the student should be created for each recommender. However, unlike CM '06, we will NOT create Drupal User records for recommenders.
List all Recommenders entered by the user. Each listing should have a 'Edit' and 'Delete' link. When user clicks on 'Edit', the form below the listing appears with information about the recommender. There will only be 1 editable recommender shown at a time. This "add" form is displayed automatically when there are no saved recommenders.
Allow user to 'Delete Recommender'. The 'Delete' link should remove the recommender from the student's list. We should only remove the relationship between the student and the recommender, we should leave the recommender information in the database.
The 'Save & Add Another' button will save the recommender information and redisplay the 'Add Recommender' form so the user can enter another recommender.
The 'Recommender relationship to you' should be used to create the appropriate relationship between student's contact record and recommender's contact record. Like CM '06, there are only two types of relationships: teacher and counselor.

Issues:
- Assuming we do duplicate matching on recommender contact records, a recommender may be linked to multiple students. Given that the "Delete Recommender" will only delete the relationship, this is probably ok, although students may wind up altering each others recommender info. Alternatively, we could disable dupe check/matching for this functionality. (Quest: we will apply the same rule as we do High School. the latest entry overrides previous information)

Essays

Two essays for the CPS, both are required
Remove 'Short Answers', 'Extracurricular Essay', 'Experience that excites you', 'Biographical Essay', and 'Optional Essay'.
Add 'Personal Statement'. The 'Personal Statement' essay has 3 options.
Add 'Short Answer' essay.
Add 'Spell Check' for each essay. An open source version of a javascript spellcheck can be downloaded at: http://me.eae.net/stuff/litespellchecker/litedemo.html (it requires pspell). another option: http://spellerpages.sourceforge.net/

Issues:
- Need to investigate spell-checking solution above (and probably check for other options).

College Match (College Ranking)

Scholarship Award Ranking

This is a new form. It wasn't there in CPS '06 or CM '06. This is basically taking the Scholarship ranking question that were there in CPS '06 and moving it to its own form.

Please refer to the mockups for the questions and the format.

College Match Ranking

Same as the CM '06 form.

Submit Application

Same as CM. No Changes.

Recommender Specs

There will be NO online recommendations. Students will register recommenders online but no online recommendations will be submitted. All recommendations will be faxed in.
When a student registers recommenders, we will create a contact record for the recommender, similar to how the process works currently. We do not have a 'verified' process for recommender. So when a student registers a recommender, the recommender is by default verified.

Email verification of student accounts

When a student creates an account, we will send an email to the student and prompt the student to click on a link to activate the account. Only after the account has been activated (Drupal user.status flag = 1) will the student be able to access the 'My Locker' page. They will also need to be assigned the Student role. Quest may also want check that they haven't submitted an application in a prior year. (Need to discuss how to implement it. Paras is going to research existing Drupal/modules that implement this functionality. Else, we could potentially adapt the verify process used for Recommenders in CM '06.)

Data Archive and Migration Plan

Starting with CPS '07, Quest will have two CiviCRM databases:

Application Processing for Current Year - This database will be used to collect and process current year applicants (2007 in this case). It will be initialized with the current CiviCRM and Quest Schemas for the year, and contained only fixed data plus Quest staff user accounts. It will NOT contain contact or user account records from prior yearly cycles.

Alumni Database - This database will contain contact records and user accounts for all prior cycle students who have completed the application process for either CPS or CM. It will also contain contact and user records for recommenders related to these students if the recommenders have completed a recommendation. At the completion of each year's processing cycles, we will add students and recommenders to who have met these criteria.

The quest-specific table data (student record, tests, etc.) will NOT be copied to the alumni DB. However, a copy of the students' completed application in PDF format will be attached to each student's contact record (as a custom field). This will allow quick reference to additional info captured on the student.

We also need to add/maintain custom fields which record the "status" of each student with record to CPS and CM processing (e.g. Winner, Matched to Princeton, etc.) as well as the year of each application.

Quest may also choose keep a separate "snapshot" system (archive of complete production DB and "legacy" code) for each year (2006 initially).

Reader Requirements

(TBD)

Locker Requirements

(TBD)