If/then statements for calculated questions
Vanessa at CalAlumni would like to use if/then statements as a calculated question. They use calculated questions to estimate financial need, but use more advanced calculations than what is available in AW today. For example they might say "If the applicant earns X and family size is Y, then score is Z." They're currently downloading the data, calculating in excel, and then re-uploading to the system.
-
Deleted User
- Jul 31 2018
- Shipped
| Client Name "shard name" | calalumni, mtroyal, oregonstate |
| Functional Unit | Questions |
Related Enhancements
The way this was described to me was something like this:
They have a maximum financial need score of 20, and they subtract from that score an amount that is determined by their family income/family size ratio times some multiplier.
They just want to be able to add their own integers to calculated questions. Like:
20 - (2.5 X (Income field divided by Family size field).
So the 20 and the 2.5 are numbers they would put in there - they are not coming from a particular application question or import field.
Mount Royal University could use if/then statements similar to the Oregon State University example above. From Micco:
This sometimes extends beyond numerical values. They ask applicants about their living situation, and assign a value for financial need based on their response. So if a student chooses "Single", they're assigned one amount and if a student chooses "Married with children", they're assigned another amount. They need that non-numeric value to be translated into a number to be used in their calculated question.
Micco mentioned that Oregon State University could use this as well. They have a state level "FAFSA" for undocumented students called ORSA. They don't want their reviewers to be biased based on if the applicant has a FAFSA or ORSA field, so they use calculated questions to add these fields together (since they can't have both a FAFSA and an ORSA, one of the fields will always be 0) and then they present that amount to the reviewer. However, the dollar amounts don't really mean anything to the reviewers. OSU will code the dollar amount to something more meaningful to the reviewers. For example, anything between $1,000 and $5,000 is a 5. The ranges change year over year, but a 5 will always mean the same thing to a reviewer. OSU would like to use if/then statements to show the coded number to the reviewers (if between $1,000 and $5,000, then show 5).