Class Set Up
So, you have a teachers account and you want to create student accounts and attach them to your account?
You can go to SET UP on the dashboard or click this link to go to the setup page: Set Up page →
This is a quick guide to explain the setup page and how to add students as well as attempt to demystify .csv
. (If, like me, you found the Wikipedia pages unhelpful: CSV and TSV wikipedia pages.)
Adding students
There are 3 ways to add students on the setup page:
- Import a spreadsheet (or other file) that is saved as a
.csv
,.tsv
or even.txt
filetype. - Copy the contents of a spreadsheet and PASTE it manually into the page.
- Individually add students in NEW (not recommended for groups)
Headings
Whether you are choosing a file or copy/pasting from a open spreadsheet, your columns of data must have certain headings. (See line 1 in the image)
1. Headings: name, class, email, password
For any of the spreadsheets to work the columns need specific headings (in any order) to work
Note that not all columns need to be there, you could simply have on column of email addresses.
2. name:
You can have the whole student name in one column or have last name and first name at the head of two columns. They will combine automatically as name.
first name | last name | → | name |
Peter | Kobi | → | Peter Kobi |
Dean | Older | → | Dean Older |
3. email:
The email is the only necessary heading, all others are optional (even name).
If students have the same email ending as your account, i.e.@myschool.com
, you can simply have the first part and it will be automatically added on...
email (name/code/ID/label) | → | |
a.battin
| → | a.battin@myschool.com
|
andre.b
| → | andre.b@myschool.com
|
14678
| → | 14678@myschool.com
|
4. password:
A password column can be added. Students can't reset their own passwords. For them to choose their own leave it blank and the password they enter on their first log in will be their Code Avengers password.
To reset a password add an existing email and select the "Modify passwords of existing students" box to over-write their old password with the new password. You can do this with classes as well, change the course code for next years students or wholesale restart everyones passwords, any new data attached to an email address will over-write the old data.
5. class:
You can add a class code to keep track of your groups. Classes will automatically hyphenate spaces CS 1
→ CS-1
Here is what a .cvs
file that you might upload looks like.
Adding data manually
You can click anywhere on the generated table to edit cell of data, you can copy/drag information into new cells (watch video) and you can delete a student or add a student.
This way you can easily add a password of class code without having to make it inside the spreadsheet.
You might not want to add class and password to your C.S.V file (spreadsheet), these can be quickly added on the set up page by inputting your password into one box and clicking on the blue tile and dragging it down to copy and paste it into the others.
Set Up Accounts
Once you are happy with the content click CREATE ACCOUNTS.
A page will appear with our website, the student email, password and name.
You can RIGHT CLICK and SAVE this as a PDF for future reference or
RIGHT CLICK and PRINT it to give to students as information slips.
C.S.V
If you have a spreadsheet with the students names and email on it, it can be saved or exported as a .csv
or .tsv
file.
What C.S.V means
We can save data in tables and spreadsheets as comma-separated values (C.S.V). This turns a table into text. which means that the table rows are saved as new lines and the table columns are separated by commas instead of table borders.
last name, first name, email,
Battin, Amy, a.battin@gmail.com,
Beck, Andre, andre.b@gmail.com,
A tab-separated values (T.S.V) file does a similar thing, but the columns are separated from each other by a tab stop character.
Exporting CSV files
If you are a New Zealand teacher there are links below on how to download .csv
files from common student management systems.
KAMAR: export student lists
Kamar has a easy way of exporting class lists, they automatically come out as .csv
files.
Follow the link below to see how to export files in Kamar
Export files in KAMAR →
MUSAC: export student lists
"MUSAC offers two SMS programs - Student Manager and also an online SMS - Edge.
In Student Manager the user can go to Utilities>Import or Export Student Data>Export selected data>the user can then give the export design a name and select the relevant fields from Student Details>Personal ie Surname, Firstname, Student email, Class etc as required.
You can then filter for the required students and select to export to a comma or tab delimited file format (CSV or TSV).
In MUSAC Edge users can create a Filterable list and select the required fields (the student name is included by default) and then Export the Details:"
*
content courtesy of MUSAC 2016
Other
To learn to export student lists from another student management system like eTAP, PCSchool, or Assembly visit their site or ask an expert colleague for help.
- download
- new file
- upload media
- rename
- delete
Run Ctrl+Enter
Check Ctrl+Shift+Enter
Reset Ctrl+Backspace
Redo Ctrl+Y
Cut Ctrl+X
Copy Ctrl+C
Paste Ctrl+V
Find Ctrl+F
Find & replace Ctrl+F+F