Setting Up SMART Response > Creating a Class List >

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.

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 in this example.

Use these tips to format your CSV file.

To import a class list from a CSV file

1. Start Teacher Tools in Gradebook view.

Teacher Tools appears.

2. Click Add a Class in the Gradebook area on the left.

3. Type a name for your class, add any optional 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 Import at the top of the window, and then select Students.

The Import dialog box appears.

6. Select the class you want to import the list into, and then click Next.

7. Select Comma Separated Values (CSV) from the Import from: list, and then click Next.

8. Browse to and select the CSV file containing the class list, and then click Open.

After a short delay, the names and IDs from your CSV file appear in the Students page. You can now edit each student's properties, as required.