ÌÇÐÄVlog

Column NameÌý

Required?Ìý

DescriptionÌý

StudentÌýGUIDÌý

Required to update an existing studentÌý

TheÌýStudentÌýGUID is a system-generated ID that is unique to each ÌÇÐÄVlog user. This ID is generated in the following format: abcd1234-ef56-gh78-ij90-klmnop123456

To update a student or affiliate an existing student to a class, you must provide the Student GUID along with the other user details. If you start with an export of existing students, this field will be populated for you.ÌýÌýÌý

If you are using the import to create new students, leave this field blank.Ìý

StudentÌýIDÌý

•ÌýRequired to create a new studentÌý

•ÌýRequired to updateÌýaÌýstudent who does not already have aÌýStudentÌýIDÌý

Enter an alphanumeric Student ID that is unique to the student. Student IDs must be between 2 to 255 characters in length.Ìý

Some examples include:Ìý

• Student ID
• SIS ID
• State-issued ID Ìý
• TEA ID*

This field is required to ensure that user accounts are not duplicated.ÌýIf you are not sure of which ID to use, check with your school administrator.Ìý

*Texas users: It is recommended that the 10-digit Texas Education Agency (TEA) number be assigned to student profiles.

First NameÌý

Required to create a new studentÌý

Enter the student's first name. 255 characters max.Ìý

Non-acceptable values: Parentheses/Round Brackets ( )

Last NameÌý

Required to create a new studentÌý

Enter the student's last name.Ìý255 characters max. Ìý

Non-acceptable values: Parentheses/Round Brackets ( )

Grade LevelÌý

Not required, but recommended for all studentsÌý

Enter the student's grade level.Ìý

Acceptable valuesÌýare:ÌýPK, K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, OtherÌý

EmailÌý

Not required, but recommended for all studentsÌý

Enter the student's school-provided email address. The email address must be unique for each student.Ìý

If possible, we recommend providing an email address for student accounts to avoid duplication.Ìý

UsernameÌý

Not required. The system will auto-generate a username if this field is left blank.Ìý

You can choose custom usernames for students, or you can leave the column blank to have the system auto-generate their usernames.

If you decide to set custom usernames, you must meet these requirements:Ìý

• Minimum of 3 characters
• Alphanumeric
• Accepted special characters: % & ! ^ $ @ ( ) ~ # _
• No spaces

A recommended best practice is to set students’ email addresses as their usernames. ThisÌýensures each student has aÌýconsistent and unique username, and it will be easy for them to remember.Ìý

PasswordÌý

Not required. The system will auto-generate a temporary password if this field is left blank.Ìý

If you are using the import to create new student accounts, you can choose a custom, permanent password for the student’s account or leave the password field blank to have the system generate a temporary password for the account.Ìý

The temporary password will expire after 90 days or when it’s initially used, and the student will be required to set their own permanent custom password once they log in to their account.

If you decide to set custom passwords, they must be a minimum of 9 characters and contain the following:Ìý
Ìý

• 1 upper-case letter
• 1 lower-case letter
• 1 number
• It cannot have 5Ìýor more consecutive repeatable case-insensitive characters.
• The password cannot exactly match the username and email address.

If you use the import to update existing students and leave the password field blank, the students’ current passwords will be unaffected. However, if you do enter a password when updating existing student accounts, it will be set as a temporary password and the system will prompt them to set a new permanent password.

Permanent passwords are not stored anywhere in ÌÇÐÄVlog systems for security reasons. If you wish to retain a record of the permanent passwords you’ve created, you’ll need to save the import file locally to your device.ÌýÌý
Ìý

Class GUIDÌý

TheÌýClass GUID is a system-generated ID that is unique to each ÌÇÐÄVlog class. This ID is generated in the following format:Ìýabcd1234-ef56-gh78-ij90-klmnop123456Ìý

To update an existing class or affiliate students to your class, you must provide the Class GUID along with the other class details. You can view Class GUIDs by exporting existing classes.ÌýÌý

If you are using the import to createÌýnewÌýclasses,Ìýleave this field blank.Ìý

Class IDÌý

•ÌýRequired to create a new classÌý

•ÌýRequired to update an existing class that does not already have a Class ID.Ìý

•ÌýNot required if classes are not being created/updated through the import process.

Enter an alphanumeric Class ID that is unique to the class. Class IDs must be between 2ÌýtoÌý255 characters in length.Ìý

For example, this could be the class ID generated by your SIS.

If rostering to an existing class and the class export does not contain a Class ID, create one.

Class NameÌý

Enter a class name; this will be visible to students.

If you have multiple sections which use the same product, you can use the Class Name to differentiate between the sections. For example, if Mrs. Smith has 3 English classes, she can identify them as: Smith English Period 1, Smith English Period 2, and Smith English Period 3.Ìý

Note: Parentheses cannot be used within a class name.

Class Grade LevelÌý

Enter a grade level for the class.Ìý

Acceptable valuesÌýare:  PK, K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, OtherÌý

If multiple grade levels apply to a class, you can select one of the applicable grade levels, or you can selectÌýOther.Ìý

Class Start DateÌý

Enter the start date of the class in MM/DD/YYYY formatÌý

Note:ÌýIn some cases, Excel may auto-abbreviate the dateÌýi.e.Ìý'03/05/2021' becomes '3/5/21.' This will not interfere with the upload.Ìý

Future-dated class start datesÌý- students will not see the class untilÌýthree daysÌýbefore the start date.

Class End DateÌý

Enter the end date of the class in MM/DD/YYYY formatÌý

Note: In some cases, Excel may auto-abbreviate the dateÌýi.e.Ìý'03/05/2021' becomes '3/5/21.' This will not interfere with the upload.Ìý

Master CodeÌý

Enter the 16-digit Master Code for the product the class will use. You can include or omit the dashes in each code.Ìý

Assign students the Master Code for the Student Edition.ÌýThe Student Edition will automaticallyÌýbeÌýassigned toÌýyour teacher account. If you have not yet redeemed the corresponding Teacher Edition, then the Teacher Edition will also be assigned to you.Ìý

Your Organization Administrator can locate the correct master codes and resource codes for you to assign content.Ìý

These Master Codes can be used to assign both ConnectED and Open Learning products.Ìý

In addition to entering the Master Code, some content requires a Resource Code to be entered into the import to ensure students are assigned to the proper course (such as ALEKS and Redbird). They will need to be entered into the Master Code column in the following format: XXXX-XXXX-XXXX-XXXX:rrrr (MASTERCODE:resourcecode)