Smart Technologies 2011 - Manual (Page 38)

8. Browse to and select the .xls or .xlsx file containing the class list, and then click Open.
After a short delay, the names and IDs from the spreadsheet appear in the Students page. You
can now edit each student's properties, as required.
Importing a class list from a CSV file
If you use a database or spreadsheet program to maintain class lists, you may be able to export class
lists as comma separated values (CSV) files. Refer to your database or spreadsheet program's Help
or user's guide for more information.
Creating class lists for all modes except LE
Use the following procedure to create class lists for classes that don't use LE clickers.
g To create a class list in CSV format
After exporting your class list as a CSV file, format your file in a text editor so that the first three
values are ID Number, First Name and Last Name as shown below.
E X A M P L E
ID Number,First Name,Last Name,
12345,John,Doe,
54321,Jane,Doe,
56789,Bob,Jones,
98765,Barb,White
For more information, see CSV file formatting on the next page.
Creating class lists for LE mode
Use the following procedure to create class lists for classes that use LE clickers.
g To create a class list in CSV format
After exporting your class list as a CSV file, format your file in a text editor so that the first four values
are ID Number, Clicker ID, First Name and Last Name as shown below.
E X A M P L E
ID Number,Clicker ID,First Name,Last Name,
12345,1,John,Doe,
54321,2,Jane,Doe,
56789,3,Bob,Jones,
98765,4,Barb,White
C H A P T E R 2
Getting started
32