Importing Files

Importing raw survey data

Once you have opened a project, you can import new learning events from CSV-files exported from LERTs. More about LERTs, check LERT Instructions.

To get started, click “Add files” from top navigation bar. As of now, you’re given two choices: “CCSVE Files (.csv)”, and “Import Wizard”. Both open the file importing window, but the first one sets selections automatically. This is the one you should use for files exported from Google Forms surveys via ‘Custom CSV Export’ add-on. More about this under LERT Instructions.

Once you have selected a file to be imported, in addition to the importing settings, click “Confirm and Import”.

Importing Wizard instructions (for future)

The ‘Importing Wizard’ has some settings it allows you to change regarding file import. All options need to be set before importing.

First, you should select the survey tool used to generate the importable CSV-file. Then you should select what was used as a delimiter for data within the file, in addition to the encoding used. After you’ve set these, you can click “Add file” button to search for the file you’d wish to import. “Reload file”-button is used to refresh read data, if you were to make changes to “Survey Tool”, “Delimiter”, or “Encoding” after the file has already been selected. Changing encoding manually can be useful when the read data has wrongly shown characters in it.

After this, the list below should be populated by lines extracted from the file. You should select every line you would like to import. You should select only lines with actual data, the survey answers. This means that you should unselect title row, and every other non-response line.

Lastly, you select the used survey template version. This selection impacts on how the information from survey should be parsed, since the survey template may have received updates at some point, that may break the data parsing used by the Teacher Tool. The version should show in the survey form template. For example, the version is shown in Google Forms template file name and within the survey’s first section.

Once you’ve done these things, you’re free to click “Confirm and Import” to finish importing the file’s contents into current project. Remember to save after import by clicking “Save changes” below top navigation bar, or by clicking CTRL + S (or CMD + S).