CSV – stands for comma-separated values. CSV files store data (numbers and text) in plain text. Each line of the file is a data record. Each record consists of one or more fields, separated by commas.
CSV files can be opened and edited using any spreadsheet editing software (ie. Excel). It is important when creating a CSV file to not include commas as these are used to separate the values.
After selecting your CSV file for importing, the program will prompt you to select the layout of your file. Class names , student names, students usernames and passwords will be highlighted by their coded colour. Select the layout that matches up with your CSV file. If the value don’t match up, the classes and students won’t be imported correctly.
Below are 5 small examples of how the classes and students will be highlighted depending on your information is organized.
Option 1: Classes in rows. Class names followed by student names.
Option 2: Classes in rows. Class names followed by student names, student usernames and student passwords.
Option 3: Classes in rows. Class names followed by class usernames, then student names, student usernames and student passwords.
Option 4: Classes in columns. Teacher names followed by the names of their students.
Option 5: Classes in columns. Teacher names followed by student names, student usernames and student passwords.