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.

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

## 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)
view raw act2sat.R hosted with ❤ by GitHub
// 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.

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)