glimpse(BoomTruck_TestData)
## Rows: 2,337
## Columns: 195
## $ CourseName               <chr> "Boom Truck Crane", "Boom Truck Crane", "Boom~
## $ FormID                   <dbl> 2560263, 2560263, 2560263, 2560263, 2560265, ~
## $ `Last name`              <chr> "Aponte", "Wesley", "Bates", "Rice", "Spina",~
## $ `First name`             <chr> "Roberto", "Jonah", "Aaron", "Charles", "Will~
## $ Institution              <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N~
## $ Department               <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N~
## $ `Email address`          <chr> "roberto.aponte@abcsupply.com", "jonwesle@sou~
## $ State                    <chr> "Finished", "Finished", "Finished", "Finished~
## $ `Assessment start time`  <chr> "March 19 2021  10:39 AM", "August 25 2021  1~
## $ Completed                <chr> "March 19 2021  11:15 AM", "August 25 2021  2~
## $ Hours                    <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, N~
## $ Minutes                  <dbl> 36, 37, 40, 41, 41, 44, 44, 47, 48, 54, 57, 5~
## $ Seconds                  <dbl> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 10,~
## $ Grade                    <dbl> 56, 52, 53, 57, 54, 56, 54, 52, 55, 57, 53, 5~
## $ `ASMTEN00MBLCRN-0001`    <dbl> 1, 1, 1, 1, NA, 1, 1, 1, 1, NA, NA, NA, NA, N~
## $ `ASMTEN00MBLCRN-0009`    <dbl> NA, NA, NA, NA, NA, 1, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0012`    <dbl> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NA, 0, 1, 0, 0,~
## $ `ASMTEN00MBLCRN-0017`    <dbl> NA, NA, NA, NA, NA, 1, 1, 1, 1, NA, NA, NA, N~
## $ `ASMTEN00MBLCRN-0020`    <dbl> 1, 1, 1, 1, NA, 1, NA, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0022`    <dbl> NA, NA, NA, NA, 1, 1, 1, 1, 1, 1, NA, 1, 0, 1~
## $ `ASMTEN00MBLCRN-0023`    <dbl> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NA, 1, 1, 1, 0,~
## $ `ASMTEN00MBLCRN-0027`    <dbl> 1, 1, 1, 1, NA, 1, NA, NA, NA, 1, NA, 1, 1, 0~
## $ `ASMTEN00MBLCRN-0029`    <dbl> NA, NA, NA, NA, NA, 1, 1, 1, 1, NA, NA, NA, N~
## $ `ASMTEN00MBLCRN-0032`    <dbl> NA, NA, NA, NA, 1, 1, 1, 1, 1, 1, NA, 1, 1, 1~
## $ `ASMTEN00MBLCRN-0033`    <dbl> 1, 1, 1, 1, NA, 1, NA, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0034`    <dbl> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NA, 1, 1, 1, 1,~
## $ `ASMTEN00MBLCRN-0035`    <dbl> 1, 0, 0, 1, 1, 1, 1, 1, 1, 1, NA, 1, 1, 0, 0,~
## $ `ASMTEN00MBLCRN-0037`    <dbl> 1, 1, 1, 0, 1, 0, 0, 0, 0, 1, NA, 1, 0, 1, 0,~
## $ `ASMTEN00MBLCRN-0043`    <dbl> 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, NA, 1, 0, 1, 0,~
## $ `ASMTEN00MBLCRN-0048`    <dbl> 1, 1, 1, 1, 1, 1, NA, NA, NA, NA, NA, NA, NA,~
## $ `ASMTEN00MBLCRN-0049`    <dbl> NA, NA, NA, NA, 1, 1, NA, NA, NA, 1, NA, 0, 1~
## $ `ASMTEN00MBLCRN-0053`    <dbl> 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, NA, 1, 1, 0, 0,~
## $ `ASMTEN00MBLCRN-0054`    <dbl> NA, NA, NA, NA, NA, 1, 1, 1, 1, 1, NA, 1, 0, ~
## $ `ASMTEN00MBLCRN-0055`    <dbl> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NA, 0, 1, 1, 1,~
## $ `ASMTEN00MBLCRN-0062`    <dbl> NA, NA, NA, NA, NA, 0, 1, 1, 1, NA, NA, NA, N~
## $ `ASMTEN00MBLCRN-0064`    <dbl> 1, 1, 1, 1, NA, 1, NA, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0072`    <dbl> NA, NA, NA, NA, 1, 1, NA, NA, NA, 1, NA, 1, 1~
## $ `ASMTEN00MBLCRN-0164`    <dbl> NA, NA, NA, NA, NA, 1, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0177`    <dbl> NA, NA, NA, NA, NA, 1, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0179`    <dbl> NA, NA, NA, NA, NA, 1, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0215`    <dbl> NA, NA, NA, NA, NA, 1, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0217`    <dbl> 1, 1, 1, 1, 0, 1, 1, 0, 1, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0223`    <dbl> NA, NA, NA, NA, 1, 1, NA, NA, NA, 1, NA, 1, 1~
## $ `ASMTEN00MBLCRN-0226`    <dbl> NA, NA, NA, NA, 1, 1, NA, NA, NA, 1, NA, 1, 1~
## $ `ASMTEN00MBLCRN-0231`    <dbl> 1, 1, 1, 1, 1, 1, 1, 1, 1, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0233`    <dbl> 1, 1, 1, 1, 1, 1, NA, NA, NA, NA, NA, NA, NA,~
## $ `ASMTEN00MBLCRN-0260`    <dbl> NA, NA, NA, NA, NA, 1, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0269`    <dbl> 1, 1, 1, 1, 0, 1, 1, 0, 1, 0, NA, 1, 1, 1, 0,~
## $ `ASMTEN00MBLCRN-0276-03` <dbl> 1, 0, 1, 1, NA, 1, NA, NA, NA, 1, NA, 1, 1, 0~
## $ `ASMTEN00MBLCRN-0278`    <dbl> 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, NA, 1, 1, 0, 0,~
## $ `ASMTEN00MBLCRN-0282`    <dbl> 0, 1, 1, 0, NA, 1, NA, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0283`    <dbl> 1, 1, 0, 1, 1, 1, 1, 1, 0, 0, NA, 1, 1, 1, 1,~
## $ `ASMTEN00MBLCRN-0286`    <dbl> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NA, 1, 1, 1, 1,~
## $ `ASMTEN00MBLCRN-0290`    <dbl> NA, NA, NA, NA, NA, 1, NA, NA, NA, 1, NA, 1, ~
## $ `ASMTEN00MBLCRN-0291`    <dbl> NA, NA, NA, NA, NA, 1, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0294`    <dbl> NA, NA, NA, NA, NA, 1, 1, 1, 1, NA, NA, NA, N~
## $ `ASMTEN00MBLCRN-0298`    <dbl> NA, NA, NA, NA, NA, 1, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0302`    <dbl> 1, 1, 1, 1, NA, 1, NA, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0303`    <dbl> NA, NA, NA, NA, 1, 1, NA, NA, NA, NA, NA, NA,~
## $ `ASMTEN00MBLCRN-0307`    <dbl> 1, 1, 1, 1, NA, 1, NA, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0312`    <dbl> NA, NA, NA, NA, NA, 1, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0315`    <dbl> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NA, 1, 1, 1, 0,~
## $ `ASMTEN00MBLCRN-0317`    <dbl> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NA, 0, 1, 1, 0,~
## $ `ASMTEN00MBLCRN-0318`    <dbl> 1, 1, 1, 1, 1, 1, NA, NA, NA, 1, NA, 1, 1, 1,~
## $ `ASMTEN00MBLCRN-0319`    <dbl> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NA, 1, 1, 0, 0,~
## $ `ASMTEN00MBLCRN-0320`    <dbl> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NA, 1, 1, 1, 0,~
## $ `ASMTEN00MBLCRN-0328`    <dbl> 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, NA, 1, 1, 1, 1,~
## $ `ASMTEN00MBLCRN-0329`    <dbl> NA, NA, NA, NA, NA, 1, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0336`    <dbl> NA, NA, NA, NA, 0, 1, NA, NA, NA, NA, NA, NA,~
## $ `ASMTEN00MBLCRN-0343`    <dbl> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NA, 1, 1, 1, 1,~
## $ `ASMTEN00MBLCRN-0345`    <dbl> NA, NA, NA, NA, 1, 0, NA, NA, NA, 1, NA, 0, 1~
## $ `ASMTEN00MBLCRN-0349`    <dbl> 1, 1, 0, 1, NA, 1, 1, 1, 1, NA, NA, NA, NA, N~
## $ `ASMTEN00MBLCRN-0353`    <dbl> 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, NA, 1, 1, 0, 0,~
## $ `ASMTEN00MBLCRN-0355`    <dbl> 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, NA, 1, 1, 1, 0,~
## $ `ASMTEN00MBLCRN-0003`    <dbl> 1, 1, 1, 1, NA, NA, 1, 1, 0, NA, NA, NA, NA, ~
## $ `ASMTEN00MBLCRN-0014`    <dbl> 1, 0, 1, 1, 1, NA, 1, 1, 1, 1, NA, 1, 1, 1, 1~
## $ `ASMTEN00MBLCRN-0028`    <dbl> 1, 1, 1, 1, 1, NA, NA, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0042`    <dbl> 1, 0, 1, 1, NA, NA, NA, NA, NA, NA, NA, NA, N~
## $ `ASMTEN00MBLCRN-0050`    <dbl> 1, 1, 1, 1, NA, NA, NA, NA, NA, 1, NA, 1, 1, ~
## $ `ASMTEN00MBLCRN-0057-02` <dbl> 1, 1, 1, 1, NA, NA, NA, NA, NA, NA, NA, NA, N~
## $ `ASMTEN00MBLCRN-0059`    <dbl> 1, 1, 1, 1, NA, NA, NA, NA, NA, NA, NA, NA, N~
## $ `ASMTEN00MBLCRN-0068`    <dbl> 0, 1, 0, 1, NA, NA, NA, NA, NA, NA, NA, NA, N~
## $ `ASMTEN00MBLCRN-0071`    <dbl> 1, 1, 1, 1, NA, NA, 1, 1, 1, NA, NA, NA, NA, ~
## $ `ASMTEN00MBLCRN-0173`    <dbl> 1, 1, 0, 1, NA, NA, NA, NA, NA, 1, NA, 0, 1, ~
## $ `ASMTEN00MBLCRN-0176`    <dbl> 1, 1, 1, 1, 1, NA, 1, 1, 1, NA, NA, NA, NA, N~
## $ `ASMTEN00MBLCRN-0180`    <dbl> 1, 1, 1, 1, NA, NA, NA, NA, NA, NA, NA, NA, N~
## $ `ASMTEN00MBLCRN-0219`    <dbl> 1, 1, 1, 1, 1, NA, 0, 0, 1, 1, NA, 1, 1, 1, 1~
## $ `ASMTEN00MBLCRN-0221`    <dbl> 1, 1, 1, 1, NA, NA, 1, 1, 1, 1, NA, 1, 1, 1, ~
## $ `ASMTEN00MBLCRN-0229`    <dbl> 1, 1, 1, 1, NA, NA, 1, 1, 1, 1, NA, 1, 0, 1, ~
## $ `ASMTEN00MBLCRN-0266`    <dbl> 1, 1, 1, 1, 1, NA, 1, 1, 1, NA, NA, NA, NA, N~
## $ `ASMTEN00MBLCRN-0267`    <dbl> 1, 1, 1, 1, 1, NA, NA, NA, NA, 1, NA, 0, 1, 1~
## $ `ASMTEN00MBLCRN-0284`    <dbl> 0, 0, 1, 1, NA, NA, NA, NA, NA, 1, NA, 1, 1, ~
## $ `ASMTEN00MBLCRN-0309`    <dbl> 1, 0, 1, 1, 1, NA, NA, NA, NA, 1, NA, 0, 1, 1~
## $ `ASMTEN00MBLCRN-0313`    <dbl> 0, 0, 1, 1, NA, NA, NA, NA, NA, NA, NA, NA, N~
## $ `ASMTEN00MBLCRN-0323`    <dbl> 1, 1, 1, 1, NA, NA, 1, 1, 1, 1, NA, 1, 1, 1, ~
## $ `ASMTEN00MBLCRN-0333`    <dbl> 1, 1, 1, 1, 1, NA, NA, NA, NA, 1, NA, 1, 1, 1~
## $ `ASMTEN00MBLCRN-0334`    <dbl> 1, 1, 1, 1, NA, NA, 1, 1, 1, 1, NA, 1, 1, 1, ~
## $ `ASMTEN00MBLCRN-0337`    <dbl> 1, 1, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, N~
## $ `ASMTEN00MBLCRN-0338`    <dbl> 1, 1, 1, 1, NA, NA, 0, 1, 1, 1, NA, 1, 1, 0, ~
## $ `ASMTEN00MBLCRN-0002`    <dbl> NA, NA, NA, NA, 1, NA, 1, 1, 1, NA, NA, NA, N~
## $ `ASMTEN00MBLCRN-0008`    <dbl> NA, NA, NA, NA, NA, NA, 1, 1, 1, NA, NA, NA, ~
## $ `ASMTEN00MBLCRN-0026`    <dbl> NA, NA, NA, NA, NA, NA, 1, 1, 1, NA, NA, NA, ~
## $ `ASMTEN00MBLCRN-0041`    <dbl> NA, NA, NA, NA, 1, NA, 1, 1, 1, NA, NA, NA, N~
## $ `ASMTEN00MBLCRN-0045`    <dbl> NA, NA, NA, NA, 1, NA, 1, 1, 1, 1, NA, 1, 1, ~
## $ `ASMTEN00MBLCRN-0063`    <dbl> NA, NA, NA, NA, NA, NA, 1, 1, 1, 1, NA, 1, 1,~
## $ `ASMTEN00MBLCRN-0167`    <dbl> NA, NA, NA, NA, NA, NA, 1, 1, 1, NA, NA, NA, ~
## $ `ASMTEN00MBLCRN-0175`    <dbl> NA, NA, NA, NA, NA, NA, 0, 0, 1, 1, NA, 0, 0,~
## $ `ASMTEN00MBLCRN-0235`    <dbl> NA, NA, NA, NA, NA, NA, 0, 0, 1, 1, NA, 1, 1,~
## $ `ASMTEN00MBLCRN-0261`    <dbl> NA, NA, NA, NA, 0, NA, 0, 0, 0, 1, NA, 1, 1, ~
## $ `ASMTEN00MBLCRN-0270`    <dbl> NA, NA, NA, NA, NA, NA, 1, 1, 1, 1, NA, 1, 1,~
## $ `ASMTEN00MBLCRN-0275-03` <dbl> NA, NA, NA, NA, 0, NA, 1, 1, 1, NA, NA, NA, N~
## $ `ASMTEN00MBLCRN-0304`    <dbl> NA, NA, NA, NA, 1, NA, 1, 1, 1, 1, NA, 1, 1, ~
## $ `ASMTEN00MBLCRN-0310`    <dbl> NA, NA, NA, NA, NA, NA, 1, 1, 1, NA, NA, NA, ~
## $ `ASMTEN00MBLCRN-0311`    <dbl> NA, NA, NA, NA, NA, NA, 1, 1, 1, NA, NA, NA, ~
## $ `ASMTEN00MBLCRN-0322`    <dbl> NA, NA, NA, NA, NA, NA, 1, 1, 1, NA, NA, NA, ~
## $ `ASMTEN00MBLCRN-0332`    <dbl> NA, NA, NA, NA, 1, NA, 1, 0, 1, NA, NA, NA, N~
## $ `ASMTEN00MBLCRN-0344`    <dbl> NA, NA, NA, NA, NA, NA, 1, 1, 1, 1, NA, 1, 1,~
## $ `ASMTEN00MBLCRN-0039`    <dbl> NA, NA, NA, NA, 1, NA, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0046`    <dbl> NA, NA, NA, NA, 1, NA, NA, NA, NA, 1, NA, 1, ~
## $ `ASMTEN00MBLCRN-0067`    <dbl> NA, NA, NA, NA, 0, NA, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0070`    <dbl> NA, NA, NA, NA, 1, NA, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0172`    <dbl> NA, NA, NA, NA, 1, NA, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0178`    <dbl> NA, NA, NA, NA, 1, NA, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0263`    <dbl> NA, NA, NA, NA, 1, NA, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0316`    <dbl> NA, NA, NA, NA, 1, NA, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0331`    <dbl> NA, NA, NA, NA, 1, NA, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0335`    <dbl> NA, NA, NA, NA, 1, NA, NA, NA, NA, NA, NA, NA~
## $ `ASMTEN00MBLCRN-0339`    <dbl> NA, NA, NA, NA, 1, NA, NA, NA, NA, NA, NA, NA~
## $ ASMTEN00MBLCRN0001       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0003       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0005       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0009       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0012       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0017       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0018       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 0, NA~
## $ ASMTEN00MBLCRN0020       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0023       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0027       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0028       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0035       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0036       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0037       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 0, NA~
## $ ASMTEN00MBLCRN0043       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0046       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0050       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0053       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0055       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN005702     <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0058       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0063       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0065       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0071       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0173       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0175       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 0, NA~
## $ ASMTEN00MBLCRN0180       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0215       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0217       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0223       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0226       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0231       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0232       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0265       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0267       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0269       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 0, NA~
## $ ASMTEN00MBLCRN027503     <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0278       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 0, NA~
## $ ASMTEN00MBLCRN0283       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0286       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0290       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0291       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0294       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0302       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0309       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0311       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0315       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0317       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0318       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0319       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 0, NA~
## $ ASMTEN00MBLCRN0320       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0322       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 0, NA~
## $ ASMTEN00MBLCRN032703     <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0328       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0333       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0339       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0343       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0349       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0353       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ ASMTEN00MBLCRN0355       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA~
## $ `ASMTEN00MBLCRN-0005`    <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA, 1,~
## $ `ASMTEN00MBLCRN-0036`    <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA, 1,~
## $ `ASMTEN00MBLCRN-0065`    <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA, 1,~
## $ `ASMTEN00MBLCRN-0171`    <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA, 1,~
## $ `ASMTEN00MBLCRN-0285`    <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA, 1,~
## $ `ASMTEN00MBLCRN-0321`    <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, 1, NA, 1,~
## $ Name                     <chr> "Table1", "Table1", "Table1", "Table1", "Tabl~
kable(head(BoomTruck_TestData[,1:20], format = "simple", digits = 2, align = "c"))
CourseName FormID Last name First name Institution Department Email address State Assessment start time Completed Hours Minutes Seconds Grade ASMTEN00MBLCRN-0001 ASMTEN00MBLCRN-0009 ASMTEN00MBLCRN-0012 ASMTEN00MBLCRN-0017 ASMTEN00MBLCRN-0020 ASMTEN00MBLCRN-0022
Boom Truck Crane 2560263 Aponte Roberto NA NA Finished March 19 2021 10:39 AM March 19 2021 11:15 AM NA 36 1 56 1 NA 1 NA 1 NA
Boom Truck Crane 2560263 Wesley Jonah NA NA Finished August 25 2021 1:27 PM August 25 2021 2:04 PM NA 37 1 52 1 NA 1 NA 1 NA
Boom Truck Crane 2560263 Bates Aaron NA NA Finished May 14 2021 8:42 AM May 14 2021 9:22 AM NA 40 1 53 1 NA 1 NA 1 NA
Boom Truck Crane 2560263 Rice Charles NA NA Finished April 30 2021 10:59 AM April 30 2021 11:40 AM NA 41 1 57 1 NA 1 NA 1 NA
Boom Truck Crane 2560265 Spina William NA NA Finished July 22 2021 8:56 AM July 22 2021 9:37 AM NA 41 1 54 NA NA 1 NA NA 1
Boom Truck Crane 2560262 Hampton Joshua NA NA Finished June 18 2021 2:38 PM June 18 2021 3:22 PM NA 44 1 56 1 1 1 1 1 1 
# The following code assumes that a dataframe is in a specified format. The format is wide data wherein the rows are test takers and columns are test items. For certain scoring algorithms or scaling approaches such as IRT the dataframe cannot have cells with not entries; requires a complete, square dataframe with no missing values.


BoomTruck_TestData_Scored <- BoomTruck_TestData %>%
  mutate(NumCorrect = rowSums(select(.,starts_with("ASMTEN")), na.rm = TRUE)) #select the columns that start with "ASMTEN" then calculate row sums and declare that there are missing data (NAs). Because there are 1s and 0s rows sums will calculate a number correct score. We can use this for subsequent purposes such as creating a scaled score or determination of pass/fail.
BoomTruck_TestData_Scored <- BoomTruck_TestData_Scored %>% 
  relocate('NumCorrect', .after = 'Grade') #simple relocation of the created variable to a specification column location.

Grade_NumCorrect_Difference <- BoomTruck_TestData_Scored$Grade - BoomTruck_TestData_Scored$NumCorrect #quick check that the NumCorrect variable matches the Grade variable which is considered to be the true score.



scaledcut <- 80 #known value of the scaled cut score from an external document
rawcut <- 70 #known value of the raw cut score from an external document
totalquestions <- 60 #known value of the number of questions for a given test/assessment. This could be identified alternatively as a generic function such as rowSums(!is.na(BoomTruck_TestData_Scored[15:194])), but this requires the user to declare which columns are the items. This becomes a slight problem when creating new variables and moving them around with relocate() for example.
totalcorrectanswers <- BoomTruck_TestData_Scored$NumCorrect #known value that can be calculated with a simple rowSums() or gathered if it is already provided such as is the case with the example dataframe. 


# Scoring algorithm for meeting or exceeding the cut score based on raw scores
Pass_Algo <- scaledcut + (100 - scaledcut) *
    (totalcorrectanswers - ((rawcut/100) * totalquestions)) /
    (totalquestions - ((rawcut/100) * totalquestions))


# Scoring algorithm for failing to meet or exceed the cut score based on raw scores
Fail_Algo <- scaledcut * (((totalcorrectanswers/totalquestions)*100)/
                            rawcut)

#Transform raw scores to reporting scores based on the value of the NumCorrect vector
#42 is .70 (raw cut) * 60 questions

BoomTruck_TestData_Scored <- BoomTruck_TestData_Scored %>%
  mutate(Reporting_Score = ifelse(NumCorrect >= 42, Pass_Algo, Fail_Algo)) %>%
  relocate(Reporting_Score, .after = NumCorrect)

write.csv(BoomTruck_TestData_Scored,"BoomTruckCrane_ScaledScores.csv") #write the csv (to save the example)
CourseName FormID Last name First name Institution Department Email address State Assessment start time Completed Hours Minutes Seconds Grade NumCorrect Reporting_Score ASMTEN00MBLCRN-0001 ASMTEN00MBLCRN-0009 ASMTEN00MBLCRN-0012 ASMTEN00MBLCRN-0017 ASMTEN00MBLCRN-0020 ASMTEN00MBLCRN-0022 ASMTEN00MBLCRN-0023 ASMTEN00MBLCRN-0027 ASMTEN00MBLCRN-0029 ASMTEN00MBLCRN-0032 ASMTEN00MBLCRN-0033 ASMTEN00MBLCRN-0034 ASMTEN00MBLCRN-0035 ASMTEN00MBLCRN-0037 ASMTEN00MBLCRN-0043 ASMTEN00MBLCRN-0048 ASMTEN00MBLCRN-0049 ASMTEN00MBLCRN-0053 ASMTEN00MBLCRN-0054 ASMTEN00MBLCRN-0055 ASMTEN00MBLCRN-0062 ASMTEN00MBLCRN-0064 ASMTEN00MBLCRN-0072 ASMTEN00MBLCRN-0164 ASMTEN00MBLCRN-0177 ASMTEN00MBLCRN-0179 ASMTEN00MBLCRN-0215 ASMTEN00MBLCRN-0217 ASMTEN00MBLCRN-0223 ASMTEN00MBLCRN-0226 ASMTEN00MBLCRN-0231 ASMTEN00MBLCRN-0233 ASMTEN00MBLCRN-0260 ASMTEN00MBLCRN-0269 ASMTEN00MBLCRN-0276-03 ASMTEN00MBLCRN-0278 ASMTEN00MBLCRN-0282 ASMTEN00MBLCRN-0283 ASMTEN00MBLCRN-0286 ASMTEN00MBLCRN-0290 ASMTEN00MBLCRN-0291 ASMTEN00MBLCRN-0294 ASMTEN00MBLCRN-0298 ASMTEN00MBLCRN-0302 ASMTEN00MBLCRN-0303 ASMTEN00MBLCRN-0307 ASMTEN00MBLCRN-0312 ASMTEN00MBLCRN-0315 ASMTEN00MBLCRN-0317 ASMTEN00MBLCRN-0318 ASMTEN00MBLCRN-0319 ASMTEN00MBLCRN-0320 ASMTEN00MBLCRN-0328 ASMTEN00MBLCRN-0329 ASMTEN00MBLCRN-0336 ASMTEN00MBLCRN-0343 ASMTEN00MBLCRN-0345 ASMTEN00MBLCRN-0349 ASMTEN00MBLCRN-0353 ASMTEN00MBLCRN-0355 ASMTEN00MBLCRN-0003 ASMTEN00MBLCRN-0014 ASMTEN00MBLCRN-0028 ASMTEN00MBLCRN-0042 ASMTEN00MBLCRN-0050 ASMTEN00MBLCRN-0057-02 ASMTEN00MBLCRN-0059 ASMTEN00MBLCRN-0068 ASMTEN00MBLCRN-0071 ASMTEN00MBLCRN-0173 ASMTEN00MBLCRN-0176 ASMTEN00MBLCRN-0180 ASMTEN00MBLCRN-0219 ASMTEN00MBLCRN-0221 ASMTEN00MBLCRN-0229 ASMTEN00MBLCRN-0266 ASMTEN00MBLCRN-0267 ASMTEN00MBLCRN-0284 ASMTEN00MBLCRN-0309 ASMTEN00MBLCRN-0313 ASMTEN00MBLCRN-0323 ASMTEN00MBLCRN-0333 ASMTEN00MBLCRN-0334 ASMTEN00MBLCRN-0337 ASMTEN00MBLCRN-0338 ASMTEN00MBLCRN-0002 ASMTEN00MBLCRN-0008 ASMTEN00MBLCRN-0026 ASMTEN00MBLCRN-0041 ASMTEN00MBLCRN-0045 ASMTEN00MBLCRN-0063 ASMTEN00MBLCRN-0167 ASMTEN00MBLCRN-0175 ASMTEN00MBLCRN-0235 ASMTEN00MBLCRN-0261 ASMTEN00MBLCRN-0270 ASMTEN00MBLCRN-0275-03 ASMTEN00MBLCRN-0304 ASMTEN00MBLCRN-0310 ASMTEN00MBLCRN-0311 ASMTEN00MBLCRN-0322 ASMTEN00MBLCRN-0332 ASMTEN00MBLCRN-0344 ASMTEN00MBLCRN-0039 ASMTEN00MBLCRN-0046 ASMTEN00MBLCRN-0067 ASMTEN00MBLCRN-0070 ASMTEN00MBLCRN-0172 ASMTEN00MBLCRN-0178 ASMTEN00MBLCRN-0263 ASMTEN00MBLCRN-0316 ASMTEN00MBLCRN-0331 ASMTEN00MBLCRN-0335 ASMTEN00MBLCRN-0339 ASMTEN00MBLCRN0001 ASMTEN00MBLCRN0003 ASMTEN00MBLCRN0005 ASMTEN00MBLCRN0009 ASMTEN00MBLCRN0012 ASMTEN00MBLCRN0017 ASMTEN00MBLCRN0018 ASMTEN00MBLCRN0020 ASMTEN00MBLCRN0023 ASMTEN00MBLCRN0027 ASMTEN00MBLCRN0028 ASMTEN00MBLCRN0035 ASMTEN00MBLCRN0036 ASMTEN00MBLCRN0037 ASMTEN00MBLCRN0043 ASMTEN00MBLCRN0046 ASMTEN00MBLCRN0050 ASMTEN00MBLCRN0053 ASMTEN00MBLCRN0055 ASMTEN00MBLCRN005702 ASMTEN00MBLCRN0058 ASMTEN00MBLCRN0063 ASMTEN00MBLCRN0065 ASMTEN00MBLCRN0071 ASMTEN00MBLCRN0173 ASMTEN00MBLCRN0175 ASMTEN00MBLCRN0180 ASMTEN00MBLCRN0215 ASMTEN00MBLCRN0217 ASMTEN00MBLCRN0223 ASMTEN00MBLCRN0226 ASMTEN00MBLCRN0231 ASMTEN00MBLCRN0232 ASMTEN00MBLCRN0265 ASMTEN00MBLCRN0267 ASMTEN00MBLCRN0269 ASMTEN00MBLCRN027503 ASMTEN00MBLCRN0278 ASMTEN00MBLCRN0283 ASMTEN00MBLCRN0286 ASMTEN00MBLCRN0290 ASMTEN00MBLCRN0291 ASMTEN00MBLCRN0294 ASMTEN00MBLCRN0302 ASMTEN00MBLCRN0309 ASMTEN00MBLCRN0311 ASMTEN00MBLCRN0315 ASMTEN00MBLCRN0317 ASMTEN00MBLCRN0318 ASMTEN00MBLCRN0319 ASMTEN00MBLCRN0320 ASMTEN00MBLCRN0322 ASMTEN00MBLCRN032703 ASMTEN00MBLCRN0328 ASMTEN00MBLCRN0333 ASMTEN00MBLCRN0339 ASMTEN00MBLCRN0343 ASMTEN00MBLCRN0349 ASMTEN00MBLCRN0353 ASMTEN00MBLCRN0355 ASMTEN00MBLCRN-0005 ASMTEN00MBLCRN-0036 ASMTEN00MBLCRN-0065 ASMTEN00MBLCRN-0171 ASMTEN00MBLCRN-0285 ASMTEN00MBLCRN-0321 Name
Boom Truck Crane 2560263 Aponte Roberto NA NA Finished March 19 2021 10:39 AM March 19 2021 11:15 AM NA 36 1 56 56 95.55556 1 NA 1 NA 1 NA 1 1 NA NA 1 1 1 1 1 1 NA 1 NA 1 NA 1 NA NA NA NA NA 1 NA NA 1 1 NA 1 1 1 0 1 1 NA NA NA NA 1 NA 1 NA 1 1 1 1 1 1 NA NA 1 NA 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 0 1 0 1 1 1 1 1 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Table1
Boom Truck Crane 2560263 Wesley Jonah NA NA Finished August 25 2021 1:27 PM August 25 2021 2:04 PM NA 37 1 52 52 91.11111 1 NA 1 NA 1 NA 1 1 NA NA 1 1 0 1 1 1 NA 1 NA 1 NA 1 NA NA NA NA NA 1 NA NA 1 1 NA 1 0 1 1 1 1 NA NA NA NA 1 NA 1 NA 1 1 1 1 1 1 NA NA 1 NA 1 1 0 1 0 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 1 1 1 1 1 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Table1
Boom Truck Crane 2560263 Bates Aaron NA NA Finished May 14 2021 8:42 AM May 14 2021 9:22 AM NA 40 1 53 53 92.22222 1 NA 1 NA 1 NA 1 1 NA NA 1 1 0 1 1 1 NA 1 NA 1 NA 1 NA NA NA NA NA 1 NA NA 1 1 NA 1 1 0 1 0 1 NA NA NA NA 1 NA 1 NA 1 1 1 1 1 1 NA NA 1 NA 0 1 1 1 1 1 1 1 1 1 0 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Table1
Boom Truck Crane 2560263 Rice Charles NA NA Finished April 30 2021 10:59 AM April 30 2021 11:40 AM NA 41 1 57 57 96.66667 1 NA 1 NA 1 NA 1 1 NA NA 1 1 1 0 1 1 NA 1 NA 1 NA 1 NA NA NA NA NA 1 NA NA 1 1 NA 1 1 1 0 1 1 NA NA NA NA 1 NA 1 NA 1 1 1 1 1 1 NA NA 1 NA 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Table1
Boom Truck Crane 2560265 Spina William NA NA Finished July 22 2021 8:56 AM July 22 2021 9:37 AM NA 41 1 54 54 93.33333 NA NA 1 NA NA 1 1 NA NA 1 NA 1 1 1 1 1 1 1 NA 1 NA NA 1 NA NA NA NA 0 1 1 1 1 NA 0 NA 1 NA 1 1 NA NA NA NA NA 1 NA NA 1 1 1 1 1 1 NA 0 1 1 NA 1 1 NA 1 1 NA NA NA NA NA NA NA 1 NA 1 NA NA 1 1 NA 1 NA NA 1 NA NA NA 1 NA NA 1 1 NA NA NA NA 0 NA 0 1 NA NA NA 1 NA 1 1 0 1 1 1 1 1 1 1 1 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Table4
Boom Truck Crane 2560262 Hampton Joshua NA NA Finished June 18 2021 2:38 PM June 18 2021 3:22 PM NA 44 1 56 56 95.55556 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 0 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Table2 
BoomTruck_TestData_Scored_short <- BoomTruck_TestData_Scored[1:5,] #shorten the df for example purposes

toJSON(BoomTruck_TestData_Scored_short,dataframe = "rows", pretty = TRUE) #create example JSON code, potentially useful, potentially not.
## [
##   {
##     "CourseName": "Boom Truck Crane",
##     "FormID": 2560263,
##     "Last name": "Aponte",
##     "First name": "Roberto",
##     "Email address": "roberto.aponte@abcsupply.com",
##     "State": "Finished",
##     "Assessment start time": "March 19 2021  10:39 AM",
##     "Completed": "March 19 2021  11:15 AM",
##     "Minutes": 36,
##     "Seconds": 1,
##     "Grade": 56,
##     "NumCorrect": 56,
##     "Reporting_Score": 95.5556,
##     "ASMTEN00MBLCRN-0001": 1,
##     "ASMTEN00MBLCRN-0012": 1,
##     "ASMTEN00MBLCRN-0020": 1,
##     "ASMTEN00MBLCRN-0023": 1,
##     "ASMTEN00MBLCRN-0027": 1,
##     "ASMTEN00MBLCRN-0033": 1,
##     "ASMTEN00MBLCRN-0034": 1,
##     "ASMTEN00MBLCRN-0035": 1,
##     "ASMTEN00MBLCRN-0037": 1,
##     "ASMTEN00MBLCRN-0043": 1,
##     "ASMTEN00MBLCRN-0048": 1,
##     "ASMTEN00MBLCRN-0053": 1,
##     "ASMTEN00MBLCRN-0055": 1,
##     "ASMTEN00MBLCRN-0064": 1,
##     "ASMTEN00MBLCRN-0217": 1,
##     "ASMTEN00MBLCRN-0231": 1,
##     "ASMTEN00MBLCRN-0233": 1,
##     "ASMTEN00MBLCRN-0269": 1,
##     "ASMTEN00MBLCRN-0276-03": 1,
##     "ASMTEN00MBLCRN-0278": 1,
##     "ASMTEN00MBLCRN-0282": 0,
##     "ASMTEN00MBLCRN-0283": 1,
##     "ASMTEN00MBLCRN-0286": 1,
##     "ASMTEN00MBLCRN-0302": 1,
##     "ASMTEN00MBLCRN-0307": 1,
##     "ASMTEN00MBLCRN-0315": 1,
##     "ASMTEN00MBLCRN-0317": 1,
##     "ASMTEN00MBLCRN-0318": 1,
##     "ASMTEN00MBLCRN-0319": 1,
##     "ASMTEN00MBLCRN-0320": 1,
##     "ASMTEN00MBLCRN-0328": 1,
##     "ASMTEN00MBLCRN-0343": 1,
##     "ASMTEN00MBLCRN-0349": 1,
##     "ASMTEN00MBLCRN-0353": 1,
##     "ASMTEN00MBLCRN-0355": 1,
##     "ASMTEN00MBLCRN-0003": 1,
##     "ASMTEN00MBLCRN-0014": 1,
##     "ASMTEN00MBLCRN-0028": 1,
##     "ASMTEN00MBLCRN-0042": 1,
##     "ASMTEN00MBLCRN-0050": 1,
##     "ASMTEN00MBLCRN-0057-02": 1,
##     "ASMTEN00MBLCRN-0059": 1,
##     "ASMTEN00MBLCRN-0068": 0,
##     "ASMTEN00MBLCRN-0071": 1,
##     "ASMTEN00MBLCRN-0173": 1,
##     "ASMTEN00MBLCRN-0176": 1,
##     "ASMTEN00MBLCRN-0180": 1,
##     "ASMTEN00MBLCRN-0219": 1,
##     "ASMTEN00MBLCRN-0221": 1,
##     "ASMTEN00MBLCRN-0229": 1,
##     "ASMTEN00MBLCRN-0266": 1,
##     "ASMTEN00MBLCRN-0267": 1,
##     "ASMTEN00MBLCRN-0284": 0,
##     "ASMTEN00MBLCRN-0309": 1,
##     "ASMTEN00MBLCRN-0313": 0,
##     "ASMTEN00MBLCRN-0323": 1,
##     "ASMTEN00MBLCRN-0333": 1,
##     "ASMTEN00MBLCRN-0334": 1,
##     "ASMTEN00MBLCRN-0337": 1,
##     "ASMTEN00MBLCRN-0338": 1,
##     "Name": "Table1"
##   },
##   {
##     "CourseName": "Boom Truck Crane",
##     "FormID": 2560263,
##     "Last name": "Wesley",
##     "First name": "Jonah",
##     "Email address": "jonwesle@southernco.com",
##     "State": "Finished",
##     "Assessment start time": "August 25 2021  1:27 PM",
##     "Completed": "August 25 2021  2:04 PM",
##     "Minutes": 37,
##     "Seconds": 1,
##     "Grade": 52,
##     "NumCorrect": 52,
##     "Reporting_Score": 91.1111,
##     "ASMTEN00MBLCRN-0001": 1,
##     "ASMTEN00MBLCRN-0012": 1,
##     "ASMTEN00MBLCRN-0020": 1,
##     "ASMTEN00MBLCRN-0023": 1,
##     "ASMTEN00MBLCRN-0027": 1,
##     "ASMTEN00MBLCRN-0033": 1,
##     "ASMTEN00MBLCRN-0034": 1,
##     "ASMTEN00MBLCRN-0035": 0,
##     "ASMTEN00MBLCRN-0037": 1,
##     "ASMTEN00MBLCRN-0043": 1,
##     "ASMTEN00MBLCRN-0048": 1,
##     "ASMTEN00MBLCRN-0053": 1,
##     "ASMTEN00MBLCRN-0055": 1,
##     "ASMTEN00MBLCRN-0064": 1,
##     "ASMTEN00MBLCRN-0217": 1,
##     "ASMTEN00MBLCRN-0231": 1,
##     "ASMTEN00MBLCRN-0233": 1,
##     "ASMTEN00MBLCRN-0269": 1,
##     "ASMTEN00MBLCRN-0276-03": 0,
##     "ASMTEN00MBLCRN-0278": 1,
##     "ASMTEN00MBLCRN-0282": 1,
##     "ASMTEN00MBLCRN-0283": 1,
##     "ASMTEN00MBLCRN-0286": 1,
##     "ASMTEN00MBLCRN-0302": 1,
##     "ASMTEN00MBLCRN-0307": 1,
##     "ASMTEN00MBLCRN-0315": 1,
##     "ASMTEN00MBLCRN-0317": 1,
##     "ASMTEN00MBLCRN-0318": 1,
##     "ASMTEN00MBLCRN-0319": 1,
##     "ASMTEN00MBLCRN-0320": 1,
##     "ASMTEN00MBLCRN-0328": 1,
##     "ASMTEN00MBLCRN-0343": 1,
##     "ASMTEN00MBLCRN-0349": 1,
##     "ASMTEN00MBLCRN-0353": 1,
##     "ASMTEN00MBLCRN-0355": 0,
##     "ASMTEN00MBLCRN-0003": 1,
##     "ASMTEN00MBLCRN-0014": 0,
##     "ASMTEN00MBLCRN-0028": 1,
##     "ASMTEN00MBLCRN-0042": 0,
##     "ASMTEN00MBLCRN-0050": 1,
##     "ASMTEN00MBLCRN-0057-02": 1,
##     "ASMTEN00MBLCRN-0059": 1,
##     "ASMTEN00MBLCRN-0068": 1,
##     "ASMTEN00MBLCRN-0071": 1,
##     "ASMTEN00MBLCRN-0173": 1,
##     "ASMTEN00MBLCRN-0176": 1,
##     "ASMTEN00MBLCRN-0180": 1,
##     "ASMTEN00MBLCRN-0219": 1,
##     "ASMTEN00MBLCRN-0221": 1,
##     "ASMTEN00MBLCRN-0229": 1,
##     "ASMTEN00MBLCRN-0266": 1,
##     "ASMTEN00MBLCRN-0267": 1,
##     "ASMTEN00MBLCRN-0284": 0,
##     "ASMTEN00MBLCRN-0309": 0,
##     "ASMTEN00MBLCRN-0313": 0,
##     "ASMTEN00MBLCRN-0323": 1,
##     "ASMTEN00MBLCRN-0333": 1,
##     "ASMTEN00MBLCRN-0334": 1,
##     "ASMTEN00MBLCRN-0337": 1,
##     "ASMTEN00MBLCRN-0338": 1,
##     "Name": "Table1"
##   },
##   {
##     "CourseName": "Boom Truck Crane",
##     "FormID": 2560263,
##     "Last name": "Bates",
##     "First name": "Aaron",
##     "Email address": "hunter.bates243@gmail.com",
##     "State": "Finished",
##     "Assessment start time": "May 14 2021  8:42 AM",
##     "Completed": "May 14 2021  9:22 AM",
##     "Minutes": 40,
##     "Seconds": 1,
##     "Grade": 53,
##     "NumCorrect": 53,
##     "Reporting_Score": 92.2222,
##     "ASMTEN00MBLCRN-0001": 1,
##     "ASMTEN00MBLCRN-0012": 1,
##     "ASMTEN00MBLCRN-0020": 1,
##     "ASMTEN00MBLCRN-0023": 1,
##     "ASMTEN00MBLCRN-0027": 1,
##     "ASMTEN00MBLCRN-0033": 1,
##     "ASMTEN00MBLCRN-0034": 1,
##     "ASMTEN00MBLCRN-0035": 0,
##     "ASMTEN00MBLCRN-0037": 1,
##     "ASMTEN00MBLCRN-0043": 1,
##     "ASMTEN00MBLCRN-0048": 1,
##     "ASMTEN00MBLCRN-0053": 1,
##     "ASMTEN00MBLCRN-0055": 1,
##     "ASMTEN00MBLCRN-0064": 1,
##     "ASMTEN00MBLCRN-0217": 1,
##     "ASMTEN00MBLCRN-0231": 1,
##     "ASMTEN00MBLCRN-0233": 1,
##     "ASMTEN00MBLCRN-0269": 1,
##     "ASMTEN00MBLCRN-0276-03": 1,
##     "ASMTEN00MBLCRN-0278": 0,
##     "ASMTEN00MBLCRN-0282": 1,
##     "ASMTEN00MBLCRN-0283": 0,
##     "ASMTEN00MBLCRN-0286": 1,
##     "ASMTEN00MBLCRN-0302": 1,
##     "ASMTEN00MBLCRN-0307": 1,
##     "ASMTEN00MBLCRN-0315": 1,
##     "ASMTEN00MBLCRN-0317": 1,
##     "ASMTEN00MBLCRN-0318": 1,
##     "ASMTEN00MBLCRN-0319": 1,
##     "ASMTEN00MBLCRN-0320": 1,
##     "ASMTEN00MBLCRN-0328": 1,
##     "ASMTEN00MBLCRN-0343": 1,
##     "ASMTEN00MBLCRN-0349": 0,
##     "ASMTEN00MBLCRN-0353": 1,
##     "ASMTEN00MBLCRN-0355": 1,
##     "ASMTEN00MBLCRN-0003": 1,
##     "ASMTEN00MBLCRN-0014": 1,
##     "ASMTEN00MBLCRN-0028": 1,
##     "ASMTEN00MBLCRN-0042": 1,
##     "ASMTEN00MBLCRN-0050": 1,
##     "ASMTEN00MBLCRN-0057-02": 1,
##     "ASMTEN00MBLCRN-0059": 1,
##     "ASMTEN00MBLCRN-0068": 0,
##     "ASMTEN00MBLCRN-0071": 1,
##     "ASMTEN00MBLCRN-0173": 0,
##     "ASMTEN00MBLCRN-0176": 1,
##     "ASMTEN00MBLCRN-0180": 1,
##     "ASMTEN00MBLCRN-0219": 1,
##     "ASMTEN00MBLCRN-0221": 1,
##     "ASMTEN00MBLCRN-0229": 1,
##     "ASMTEN00MBLCRN-0266": 1,
##     "ASMTEN00MBLCRN-0267": 1,
##     "ASMTEN00MBLCRN-0284": 1,
##     "ASMTEN00MBLCRN-0309": 1,
##     "ASMTEN00MBLCRN-0313": 1,
##     "ASMTEN00MBLCRN-0323": 1,
##     "ASMTEN00MBLCRN-0333": 1,
##     "ASMTEN00MBLCRN-0334": 1,
##     "ASMTEN00MBLCRN-0337": 0,
##     "ASMTEN00MBLCRN-0338": 1,
##     "Name": "Table1"
##   },
##   {
##     "CourseName": "Boom Truck Crane",
##     "FormID": 2560263,
##     "Last name": "Rice",
##     "First name": "Charles",
##     "Email address": "charlie@oakservices.com",
##     "State": "Finished",
##     "Assessment start time": "April 30 2021  10:59 AM",
##     "Completed": "April 30 2021  11:40 AM",
##     "Minutes": 41,
##     "Seconds": 1,
##     "Grade": 57,
##     "NumCorrect": 57,
##     "Reporting_Score": 96.6667,
##     "ASMTEN00MBLCRN-0001": 1,
##     "ASMTEN00MBLCRN-0012": 1,
##     "ASMTEN00MBLCRN-0020": 1,
##     "ASMTEN00MBLCRN-0023": 1,
##     "ASMTEN00MBLCRN-0027": 1,
##     "ASMTEN00MBLCRN-0033": 1,
##     "ASMTEN00MBLCRN-0034": 1,
##     "ASMTEN00MBLCRN-0035": 1,
##     "ASMTEN00MBLCRN-0037": 0,
##     "ASMTEN00MBLCRN-0043": 1,
##     "ASMTEN00MBLCRN-0048": 1,
##     "ASMTEN00MBLCRN-0053": 1,
##     "ASMTEN00MBLCRN-0055": 1,
##     "ASMTEN00MBLCRN-0064": 1,
##     "ASMTEN00MBLCRN-0217": 1,
##     "ASMTEN00MBLCRN-0231": 1,
##     "ASMTEN00MBLCRN-0233": 1,
##     "ASMTEN00MBLCRN-0269": 1,
##     "ASMTEN00MBLCRN-0276-03": 1,
##     "ASMTEN00MBLCRN-0278": 1,
##     "ASMTEN00MBLCRN-0282": 0,
##     "ASMTEN00MBLCRN-0283": 1,
##     "ASMTEN00MBLCRN-0286": 1,
##     "ASMTEN00MBLCRN-0302": 1,
##     "ASMTEN00MBLCRN-0307": 1,
##     "ASMTEN00MBLCRN-0315": 1,
##     "ASMTEN00MBLCRN-0317": 1,
##     "ASMTEN00MBLCRN-0318": 1,
##     "ASMTEN00MBLCRN-0319": 1,
##     "ASMTEN00MBLCRN-0320": 1,
##     "ASMTEN00MBLCRN-0328": 1,
##     "ASMTEN00MBLCRN-0343": 1,
##     "ASMTEN00MBLCRN-0349": 1,
##     "ASMTEN00MBLCRN-0353": 1,
##     "ASMTEN00MBLCRN-0355": 1,
##     "ASMTEN00MBLCRN-0003": 1,
##     "ASMTEN00MBLCRN-0014": 1,
##     "ASMTEN00MBLCRN-0028": 1,
##     "ASMTEN00MBLCRN-0042": 1,
##     "ASMTEN00MBLCRN-0050": 1,
##     "ASMTEN00MBLCRN-0057-02": 1,
##     "ASMTEN00MBLCRN-0059": 1,
##     "ASMTEN00MBLCRN-0068": 1,
##     "ASMTEN00MBLCRN-0071": 1,
##     "ASMTEN00MBLCRN-0173": 1,
##     "ASMTEN00MBLCRN-0176": 1,
##     "ASMTEN00MBLCRN-0180": 1,
##     "ASMTEN00MBLCRN-0219": 1,
##     "ASMTEN00MBLCRN-0221": 1,
##     "ASMTEN00MBLCRN-0229": 1,
##     "ASMTEN00MBLCRN-0266": 1,
##     "ASMTEN00MBLCRN-0267": 1,
##     "ASMTEN00MBLCRN-0284": 1,
##     "ASMTEN00MBLCRN-0309": 1,
##     "ASMTEN00MBLCRN-0313": 1,
##     "ASMTEN00MBLCRN-0323": 1,
##     "ASMTEN00MBLCRN-0333": 1,
##     "ASMTEN00MBLCRN-0334": 1,
##     "ASMTEN00MBLCRN-0337": 0,
##     "ASMTEN00MBLCRN-0338": 1,
##     "Name": "Table1"
##   },
##   {
##     "CourseName": "Boom Truck Crane",
##     "FormID": 2560265,
##     "Last name": "Spina",
##     "First name": "William",
##     "Email address": "aspina21@gmail.com",
##     "State": "Finished",
##     "Assessment start time": "July 22 2021  8:56 AM",
##     "Completed": "July 22 2021  9:37 AM",
##     "Minutes": 41,
##     "Seconds": 1,
##     "Grade": 54,
##     "NumCorrect": 54,
##     "Reporting_Score": 93.3333,
##     "ASMTEN00MBLCRN-0012": 1,
##     "ASMTEN00MBLCRN-0022": 1,
##     "ASMTEN00MBLCRN-0023": 1,
##     "ASMTEN00MBLCRN-0032": 1,
##     "ASMTEN00MBLCRN-0034": 1,
##     "ASMTEN00MBLCRN-0035": 1,
##     "ASMTEN00MBLCRN-0037": 1,
##     "ASMTEN00MBLCRN-0043": 1,
##     "ASMTEN00MBLCRN-0048": 1,
##     "ASMTEN00MBLCRN-0049": 1,
##     "ASMTEN00MBLCRN-0053": 1,
##     "ASMTEN00MBLCRN-0055": 1,
##     "ASMTEN00MBLCRN-0072": 1,
##     "ASMTEN00MBLCRN-0217": 0,
##     "ASMTEN00MBLCRN-0223": 1,
##     "ASMTEN00MBLCRN-0226": 1,
##     "ASMTEN00MBLCRN-0231": 1,
##     "ASMTEN00MBLCRN-0233": 1,
##     "ASMTEN00MBLCRN-0269": 0,
##     "ASMTEN00MBLCRN-0278": 1,
##     "ASMTEN00MBLCRN-0283": 1,
##     "ASMTEN00MBLCRN-0286": 1,
##     "ASMTEN00MBLCRN-0303": 1,
##     "ASMTEN00MBLCRN-0315": 1,
##     "ASMTEN00MBLCRN-0317": 1,
##     "ASMTEN00MBLCRN-0318": 1,
##     "ASMTEN00MBLCRN-0319": 1,
##     "ASMTEN00MBLCRN-0320": 1,
##     "ASMTEN00MBLCRN-0328": 1,
##     "ASMTEN00MBLCRN-0336": 0,
##     "ASMTEN00MBLCRN-0343": 1,
##     "ASMTEN00MBLCRN-0345": 1,
##     "ASMTEN00MBLCRN-0353": 1,
##     "ASMTEN00MBLCRN-0355": 1,
##     "ASMTEN00MBLCRN-0014": 1,
##     "ASMTEN00MBLCRN-0028": 1,
##     "ASMTEN00MBLCRN-0176": 1,
##     "ASMTEN00MBLCRN-0219": 1,
##     "ASMTEN00MBLCRN-0266": 1,
##     "ASMTEN00MBLCRN-0267": 1,
##     "ASMTEN00MBLCRN-0309": 1,
##     "ASMTEN00MBLCRN-0333": 1,
##     "ASMTEN00MBLCRN-0002": 1,
##     "ASMTEN00MBLCRN-0041": 1,
##     "ASMTEN00MBLCRN-0045": 1,
##     "ASMTEN00MBLCRN-0261": 0,
##     "ASMTEN00MBLCRN-0275-03": 0,
##     "ASMTEN00MBLCRN-0304": 1,
##     "ASMTEN00MBLCRN-0332": 1,
##     "ASMTEN00MBLCRN-0039": 1,
##     "ASMTEN00MBLCRN-0046": 1,
##     "ASMTEN00MBLCRN-0067": 0,
##     "ASMTEN00MBLCRN-0070": 1,
##     "ASMTEN00MBLCRN-0172": 1,
##     "ASMTEN00MBLCRN-0178": 1,
##     "ASMTEN00MBLCRN-0263": 1,
##     "ASMTEN00MBLCRN-0316": 1,
##     "ASMTEN00MBLCRN-0331": 1,
##     "ASMTEN00MBLCRN-0335": 1,
##     "ASMTEN00MBLCRN-0339": 1,
##     "Name": "Table4"
##   }
## ]