ACT to SAT M+V Concordance Chart in R
[This article was first published on Data Twirling » R, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.
For those of who work in Enrollment Management and routinely analyze higher ed data, I wanted to share an easy way to convert ACT to equivalent SAT M+V scores in R. I am dynamically building a dataset that uses the concordance chart located here. Simply, use this data frame and merge it onto your existing data (?merge) to calculate the “best standardized test score” for a given recruit, applicant, etc.
If you aren’t using R, give it a shot, it’s worth the effort and undoubtedly you will begin to find SAS and SPSS are too much work.
Let’s save the debate on the validity of standardized tests for another day…….
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
## act to sat concordance chart | |
## http://www.act.org/aap/concordance/pdf/reference.pdf | |
act <- (36:11) | |
sat <- c(1600, 1560, 1510, 1460, 1420, 1380, 1340, 1300, 1260, 1220, 1190, | |
1150, 1110, 1070, 1030, 990, 950, 910, 870, 830, 790, 740, 690, 640, | |
590, 530) | |
act2sat <- data.frame(act, sat) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// Concordance chart is found http://www.act.org/aap/concordance/pdf/reference.pdf | |
IF [ZAVUADM_SACT_SCORE] = 36 THEN 1600 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 35 THEN 1560 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 34 THEN 1510 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 33 THEN 1460 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 32 THEN 1420 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 31 THEN 1380 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 30 THEN 1340 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 29 THEN 1300 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 28 THEN 1260 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 27 THEN 1220 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 26 THEN 1190 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 25 THEN 1150 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 24 THEN 1110 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 23 THEN 1070 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 22 THEN 1030 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 21 THEN 990 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 20 THEN 950 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 19 THEN 910 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 18 THEN 870 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 17 THEN 830 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 16 THEN 790 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 15 THEN 740 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 14 THEN 690 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 13 THEN 640 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 12 THEN 590 | |
ELSEIF [ZAVUADM_SACT_SCORE] = 11 THEN 530 | |
END | |
//the calc above is saved as [ACT 2 SAT] | |
IIF(MAX([ACT 2 SAT], ZN([ZAVUADM_HIGH_SATC])) = 0, NULL, MAX([ACT 2 SAT], ZN([ZAVUADM_HIGH_SATC]))) |
To leave a comment for the author, please follow the link and comment on their blog: Data Twirling » R.
R-bloggers.com offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.