Use the following procedure to create class lists for classes that don’t use LE clickers.

To create a class list in an Excel spreadsheet

1. Open the Excel spreadsheet that contains your students’ names.

2. Insert a blank row at the top of the spreadsheet if it doesn’t already have one.

3. Type ID Number in the first cell (A1).

4. Type First Name in the first cell of the second column (B1).

5. Type Last Name in the first cell of the third column (C1).

6. Move the first and last names into the columns directly below the headings.

7. In column A, type a unique 1 to 15 digit ID number for each student.

   Example 

   	A	B	C
   1	ID Number	First Name	Last name
   2	1234	David	Jones
   3	6789	Jane	Doe
   4	5678	John	Swartz
   5	3456	Mary	Smith

8. Save the spreadsheet.

Creating class lists for LE mode

Use the following procedure to create class lists for classes that use LE clickers.

To create a class list in an Excel spreadsheet

1. Open the Excel spreadsheet that contains your students’ names.

2. Insert a blank row at the top of the spreadsheet if it doesn’t already have one.

3. Type ID Number in the first cell (A1).

4. Type Clicker ID in the first cell of the second column (B1).

5. Type First Name in the first cell of the third column (C1).

6. Type Last Name in the first cell of the fourth column (D1).

7. Move the first and last names into the columns directly below the headings.

8. In column A, type a unique 1 to 15 digit ID number for each student.

9. In column B, type a unique clicker ID from 1 to 199 for each student’s clicker.

   Example 

   	A	B	C	D
   1	ID Number	Clicker ID	First Name	Last name
   2	12345	1	David	Jones
   3	67890	2	Jane	Doe
   4	56789	3	John	Swartz
   5	34567	4	Mary	Smith

   Notes 

   • The clicker ID must match the ID programmed into the student’s clicker. See Assigning clicker IDs.

   • If you don’t include a Clicker ID column in the spreadsheet, SMART Response software inserts sequential Clicker IDs into the class list. You must then match the clicker IDs to the clickers either by editing the class list or by re-programming the clickers.

10. Save the spreadsheet.

Importing the class list

To import a class list from an Excel spreadsheet

1. Start Teacher Tools. See Starting Teacher Tools.

   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 the Import button at the top of the window, and then select Students.

   The Import dialog box appears.

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

7. Select Microsoft Excel from the Import from list, and then click Next.

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.