User's Manual

27 | CHAPTER 4 – MANAGING CLASS LISTS
3. In the first cell (A1), type ID Number.
4. In the first cell of the second column (B1), type First Name.
5. In the first cell of the third column (C1), type Last Name.
6. Move the first and last names into columns B and C, directly below the headings.
7. Type a unique ID number from 1 to 15 digits for each student into column A, and
then save the spreadsheet.
To import a class list from
Microsoft Excel software
1. Click the SMART Response icon in the notification area, and then select the icon
under Teacher Tools.
2. Click ...switch to Gradebook view if you aren’t already in Gradebook view, and
then click Add a Class in the Gradebook area on the left.
3. Type a name for your class, optionally add other details to the Class Information
boxes, and then click Add.
After a short delay, the new class’s window appears, and the class name appears
in the Gradebook area.
4. Click the Students tab at the top of the window.
5. Click the Import button at the top of the window, or click Add students to your
class below Next steps.
6. Select Students from the drop-down list.
The Import dialog box appears.
7. Select the class into which you want to import the student list, and then click Next.
8. Select Microsoft Excel from the Import from list, and then click Next.
9. Browse to and select the XLS file containing the student list, and then click Open.
The student list information appears in the table. You can now edit each student’s
properties as required.
Importing Class Lists from a CSV File
If you use a database or spreadsheet program to maintain student lists, you may be
able to export the student list as a comma separated value (CSV) file. Refer to your
software’s Help system or user’s guide for procedures.
After exporting your student 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 in this
example.