Csv file formatting – Smart Technologies 2011 User Manual

Page 39

Advertising
background image

For more information, see CSV file formatting below.

g

To import a class list from a CSV file

1. Start Teacher Tools. See Starting Teacher Tools on page 23.

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 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.

CSV file formatting

Tips for formatting CSV files for importing class lists

The following is the general format you should use for CSV files:

The order of the columns isn't important, but the first row must contain the column headings

identifying what's in each column.

l

You must have a column with the heading ID Number.

o

You must put a single space between ID and Number.

o

In place of ID Number, you can use ID, Student ID or Number.

o

If you don't use a correct column name for the ID Number, the software is unable to

import the list.

C H A P T E R 2

Getting started

33

Advertising