get_learning_location: Connect to 'LearningLocation' database 'RGVPDRA-DASQL' which...

In idea-analytics/ideadata: Tools and Utilities for accessing IDEA's Data Warehouse

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

Description

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

Usage

get_learning_location()

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.

Value

a ⁠tbl_sql SQL Server⁠ object.

Examples

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

## End(Not run)

idea-analytics/ideadata documentation built on Feb. 1, 2024, 5:40 a.m.