The Survey Data Loader tool is a lightweight web application enabling end users to easily map and upload survey data flat files to an Ed-Fi ODS. Supported use cases include any surveys administered at the district, school, or classroom level that leverage Google Forms, Microsoft forms, Typeform, or other survey platforms that output response results in a standard, tidy (each row represents one survey response; each column represents one item response or survey response property (e.g. completion time)) spreadsheet format. Within the application, users load survey metadata and question metadata to their Ed-Fi ODS before uploading survey responses. Surveys can be loaded without manual field mapping or bootstrap configuration outside of simple user prompts within the UI. An admin module allows data/IT admins to pre-configure secure ODS connections, enabling business users to engage with the application without deep technical knowledge or familiarity with the Ed-Fi data model.
A preview of the application can be accessed here (https://r.northallegheny.org/surveyLoaderDemo/). Preview users are welcome to try uploading their own sample data to their own sample ODS (e.g. Populated Template/Grand Bend dataset); for obvious reasons, do not send actual student data through the demo application.