Holt McDougal Online classes File Details

Column

Field Name

Required

Instruction

Max. Field Length

Valid Values

Sample Entries

A

TEACHER_USERNAME

Y

Enter the username of the teacher associated with this class.

5–75

A–Z, a–z, 0–9, and *symbols acceptable

Note: Spaces are not allowed.

*See Supported Symbols for complete list.

wbteach2

B

CLASS_ID

Y

Enter the unique class identification number.

Note:

●      It is critical that this value be unique across all classes in the district.

●      HMH recommends that you add the OrgId to the entries for this CLASS_ID field (123_1111111) as well as the CLASS_NAME field (Alg 1 111111111) to best support classes that may move from org A to org B. If you do not do this, you may encounter situations in which a class cannot be created at a new org because that class already exists (active or inactive) at the original org.

1–40

A–Z, a–z, 0–9, spaces, and *symbols acceptable

*See Supported Symbols for complete list.

MySchool-2016-Y8 C4_12345678

C

CLASS_NAME

Y

Enter the class name.

TIP: For best results, we strongly recommend reviewing the Class Name Tips provided below this table.

Note:

●      If changing a class roster or product list, but not changing the class name, then leave blank. This value should be entered only one time for each TEACHER_USERNAME + CLASS_ID combination.

●      For each teacher, class name must be unique across all schools.

●      HMH recommends that you add the OrgId to the entries for this CLASS_NAME field (Alg 1 111111111) as well as the CLASS_ID field (123_1111111) to best support classes that may move from org A to org B. If you do not do this, you may encounter situations in which a class cannot be created at a new org because that class already exists (active or inactive) at the original org.

1–75

A–Z, a–z, 0–9, spaces, and *symbols acceptable

*See Supported Symbols for complete list.

17-18 Algebra 1 12345678

D

CLASS_PERIOD

Y

If period structures are used for classes, enter the class period.

If period structures are not used for classes, enter 1.

Note: If changing a class roster or product list, but not changing the class name, then leave blank. This value should be entered only one time for each TEACHER_USERNAME + CLASS_ID combination.

1–20

A–Z, a–z, 0–9, spaces, and *symbols acceptable

*See Supported Symbols for complete list.

KOMalley_12

E

GRADE

Y

Enter the grade associated with the class.

Note:

●      Only one grade can be entered for each class; if class consists of multiple grades, enter the grade that best represents the class such as the median grade of the students in the class.

To help determine the most representative grade for a class, do the following:

1.    Obtain the course/class grade if available and accurate.

2.    Map the course code to a grade level, if applicable.

3.    Use the SQL sample code file provided here to find the median grade level of students in the class. (Click link to open SQL code file.)

●      If changing a class roster or product list, but not changing the class name, then leave blank. This value should be entered only one time for each TEACHER_USERNAME + CLASS_ID combination.

2

PK = Pre Kindergarten

K = Kindergarten

1 = Grade 1

2 = Grade 2

3 = Grade 3

4 = Grade 4

5 = Grade 5

6 = Grade 6

7 = Grade 7

8 = Grade 8

9 = Grade 9

10 = Grade 10

11 = Grade 11

12 = Grade 12

10

F

STUDENT_USERNAME

Y

Enter the student usernames to be added or removed from the class roster.

Note: If not adding or removing student accounts from the class roster, leave blank.

5–75

A–Z, a–z, 0–9, and *symbols acceptable

Note: Spaces are not allowed.

*See Supported Symbols for complete list.

John.Doe@DistrictA.ca.usd

G

ACTIVATE

N

Specify whether the student account is being added or removed from the class roster by entering "A" for activate (add) or "I" for inactivate (remove).

Note:

●      If not adding or removing student accounts from the class, leave blank.

●      Inactivating student accounts in this import file removes the student from the class roster; it does not inactivate the student's Holt McDougal Online account. To inactivate a student's account, you must include the student account in the user.csv file and enter an "I" in the Activate field (column Q) of that file.

●      Click to learn how to inactivate (remove)HMO classes.

1

A = Activate

I = Inactivate

A

H

ISBN

N

Enter the 10 or 13 character ISBN product codes to identify the products to be added or removed from the class product list.

See Locate ISBN Codes for details.

Note:

●      Multiple values must be entered on separate rows. On each additional row added, keep the CLASS_NAME, GRADE, AND CLASS_PERIOD fields empty.

●      Leading zeros must be preserved by preceding the number with an apostrophe ('). See Retain Leading Zeros for more details.

●      Leaving this field empty allows you to activate products using the HMO platform. See Activate Products for details.

13

A–Z and 0–9 acceptable

9284618003976

I

UPDATE

Y

For each row, enter the word "New" or "Update" to specify the purpose of this row in the import file.

●      New indicates that this row contains the addition of a student or product (ISBN) to the class.

●      Update indicates that this row contains the removal of a student or product (ISBN) from the class or a change to a class detail, such as CLASS_NAME, GRADE, OR CLASS_PERIOD.

Note: A separate row must be used for each addition or update; for example, you cannot update a class name and add a new student on the same row.

6

New

Update

New

J

REMOVE_PRODUCT

N

Enter a "Y" to remove the product identified in column H (ISBN) from the class product list.

If a product is being added or no product is being affected, leave the field blank.

1

Y = Remove product

leave blank = Add product or no product changes