At the end of each trimester, CA students' NWEA scores are exported from the on-line NWEA data base into ETO. This tranfer can easily be done by following these steps:
To obtain this list:
To be completed
If you have never used the laycUtils and laycca packages before, uncomment, and run the following 2 lines of code:
# devtools::install_github('thelayc/laycUtils', build_vignettes = TRUE) # devtools::install_github('thelayc/laycca', build_vignettes = TRUE) library(laycUtils) library(laycca) nwea <- load_csv("./path/to/nwea_scores.csv") # Edit the path to your .csv file as needed eto <- load_csv("./path/to/students_list.csv") # Edit the path to your .csv file as needed
The nwea dataset should have the following structure and column names:
library(laycUtils) library(laycca) data(nwea_scores) nwea <- nwea_scores dplyr::tbl_df(nwea) rm(nwea_scores)
The eto dataset should have the following structure and column names:
data(students_list) eto <- students_list dplyr::tbl_df(eto) rm(students_list)
nwea <- clean_nwea(nwea) eto <- clean_roster(eto)
Since the 2 datasets don't share a common ID, we will create a custom id based on students' first and last name.
# Create custom id nwea$custom_id <- create_id(nwea, var = c("StudentLastName", "StudentFirstName")) eto$custom_id <- create_id(eto, var = c("lname", "fname")) nwea$custom_id # Merge df <- fuzzy_join(x = nwea, y = eto, by = 'custom_id') head(df)
table(df$match_status)
df <- format_nwea(df) head(df)
The export_nwea()
will automatically save the dataset in the active working directory, and name it.
export_nwea(df)
ETO doesn't support .csv files. It is necessary to open the newly created .csv file, and save it as an .xls file before finalizing the upload in ETO.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.