Skip to content

Instantly share code, notes, and snippets.

@Btibert3

Btibert3/act2sat.R

Last active October 13, 2015 00:28
Download ZIP

Revisions

  1. Btibert3 revised this gist May 11, 2015. 1 changed file with 26 additions and 28 deletions.
    54 changes: 26 additions & 28 deletions tableau-concordance
    View file
    Original file line number Diff line number Diff line change
    @@ -1,32 +1,30 @@
    // Concordance chart is found http://www.act.org/aap/concordance/pdf/reference.pdf
    // Need the 0 because NULLs get lost
    IF [ZAVUADM_ACTC_SCORE] = 36 THEN 1600
    ELSEIF [ZAVUADM_ACTC_SCORE] = 35 THEN 1560
    ELSEIF [ZAVUADM_ACTC_SCORE] = 34 THEN 1510
    ELSEIF [ZAVUADM_ACTC_SCORE] = 33 THEN 1460
    ELSEIF [ZAVUADM_ACTC_SCORE] = 32 THEN 1420
    ELSEIF [ZAVUADM_ACTC_SCORE] = 31 THEN 1380
    ELSEIF [ZAVUADM_ACTC_SCORE] = 30 THEN 1340
    ELSEIF [ZAVUADM_ACTC_SCORE] = 29 THEN 1300
    ELSEIF [ZAVUADM_ACTC_SCORE] = 28 THEN 1260
    ELSEIF [ZAVUADM_ACTC_SCORE] = 27 THEN 1220
    ELSEIF [ZAVUADM_ACTC_SCORE] = 26 THEN 1190
    ELSEIF [ZAVUADM_ACTC_SCORE] = 25 THEN 1150
    ELSEIF [ZAVUADM_ACTC_SCORE] = 24 THEN 1110
    ELSEIF [ZAVUADM_ACTC_SCORE] = 23 THEN 1070
    ELSEIF [ZAVUADM_ACTC_SCORE] = 22 THEN 1030
    ELSEIF [ZAVUADM_ACTC_SCORE] = 21 THEN 990
    ELSEIF [ZAVUADM_ACTC_SCORE] = 20 THEN 950
    ELSEIF [ZAVUADM_ACTC_SCORE] = 19 THEN 910
    ELSEIF [ZAVUADM_ACTC_SCORE] = 18 THEN 870
    ELSEIF [ZAVUADM_ACTC_SCORE] = 17 THEN 830
    ELSEIF [ZAVUADM_ACTC_SCORE] = 16 THEN 790
    ELSEIF [ZAVUADM_ACTC_SCORE] = 15 THEN 740
    ELSEIF [ZAVUADM_ACTC_SCORE] = 14 THEN 690
    ELSEIF [ZAVUADM_ACTC_SCORE] = 13 THEN 640
    ELSEIF [ZAVUADM_ACTC_SCORE] = 12 THEN 590
    ELSEIF [ZAVUADM_ACTC_SCORE] = 11 THEN 530
    ELSE 0
    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]
  2. Btibert3 revised this gist Mar 8, 2014. 1 changed file with 33 additions and 0 deletions.
    33 changes: 33 additions & 0 deletions tableau-concordance
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,33 @@
    // Concordance chart is found http://www.act.org/aap/concordance/pdf/reference.pdf
    // Need the 0 because NULLs get lost
    IF [ZAVUADM_ACTC_SCORE] = 36 THEN 1600
    ELSEIF [ZAVUADM_ACTC_SCORE] = 35 THEN 1560
    ELSEIF [ZAVUADM_ACTC_SCORE] = 34 THEN 1510
    ELSEIF [ZAVUADM_ACTC_SCORE] = 33 THEN 1460
    ELSEIF [ZAVUADM_ACTC_SCORE] = 32 THEN 1420
    ELSEIF [ZAVUADM_ACTC_SCORE] = 31 THEN 1380
    ELSEIF [ZAVUADM_ACTC_SCORE] = 30 THEN 1340
    ELSEIF [ZAVUADM_ACTC_SCORE] = 29 THEN 1300
    ELSEIF [ZAVUADM_ACTC_SCORE] = 28 THEN 1260
    ELSEIF [ZAVUADM_ACTC_SCORE] = 27 THEN 1220
    ELSEIF [ZAVUADM_ACTC_SCORE] = 26 THEN 1190
    ELSEIF [ZAVUADM_ACTC_SCORE] = 25 THEN 1150
    ELSEIF [ZAVUADM_ACTC_SCORE] = 24 THEN 1110
    ELSEIF [ZAVUADM_ACTC_SCORE] = 23 THEN 1070
    ELSEIF [ZAVUADM_ACTC_SCORE] = 22 THEN 1030
    ELSEIF [ZAVUADM_ACTC_SCORE] = 21 THEN 990
    ELSEIF [ZAVUADM_ACTC_SCORE] = 20 THEN 950
    ELSEIF [ZAVUADM_ACTC_SCORE] = 19 THEN 910
    ELSEIF [ZAVUADM_ACTC_SCORE] = 18 THEN 870
    ELSEIF [ZAVUADM_ACTC_SCORE] = 17 THEN 830
    ELSEIF [ZAVUADM_ACTC_SCORE] = 16 THEN 790
    ELSEIF [ZAVUADM_ACTC_SCORE] = 15 THEN 740
    ELSEIF [ZAVUADM_ACTC_SCORE] = 14 THEN 690
    ELSEIF [ZAVUADM_ACTC_SCORE] = 13 THEN 640
    ELSEIF [ZAVUADM_ACTC_SCORE] = 12 THEN 590
    ELSEIF [ZAVUADM_ACTC_SCORE] = 11 THEN 530
    ELSE 0
    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])))
  3. Btibert3 created this gist Nov 19, 2012.
    7 changes: 7 additions & 0 deletions act2sat.R
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,7 @@
    ## 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)