Connect to LearningLocation database RGVPDRA-DASQL which provides daily learning location (i.e, remote or in-person) for every student on ever day

Connect to LearningLocation database RGVPDRA-DASQL which provides daily learning location (i.e, remote or in-person) for every student on ever day

get_learning_location()

Value

a tbl_sql SQL Server object.

Details

The learning location of a student on a given is determined by calculating a 30-day average ("days" includes only days attended) in each location (remote vs in-person). 75% of those 30 days at home leads to an att_category of remote, 75% of those 30 days at home leads to an att_category of at-home, and all other cases are coded mixed.

Examples

# This attaches to the school db with \code{conn_LearningLocation} connection
if (FALSE) {
att_type <- get_learning_location()
}