Dynamic Class List Implementation Guide

Overview

Instead of requiring each teacher to manually create and manage each class list on their own, many organizations opt to build centrally managed class lists, typically generated by a scheduled export from the district's Student Information System (SIS).

The first file is the Teacher file. It should contain only three columns of data, listed in specific order by row, separated by commas:

Teacher name, Class ID, Class Name.

The Teacher name can be either their Network Login Name, their Machine Name, or in Windows environments with Active Directory, their Teacher Name. The Class ID number can be any numeric identifier, it just needs to be unique for each class.

The second file is a Student file. The Student file needs to include only two columns of data, listed in specific order by row, separated by commas: ClassID and Student Name.

The Student Name can again be their Login Name, their Machine Name, or in Windows environments with Active Directory, their Student Name.

Depending on the method chosen to export the data for the Teacher or Student name, each of the two files must be named as follows (case sensitive):

“ClassesByTeacherLoginName.csv”, “StudentsForClassByLoginName.csv”

“ClassesByTeacherMachineName.csv” “StudentsForClassByMachineName.csv”

“ClassesByTeacherADName.csv” “StudentsForClassByADName.csv”

Dynamic Class List Examples

ClassesByTeacherLoginName.csv

teacher login name

unique class ID

class display name

teacher login name = the local device login name that the teacher is using to login to their device (e.g. jsmith)

unique class ID = a numeric, unique identifier for each class list (e.g. HS-201B)

class display name = a friendly name or description for the class list (e.g. Eng Lang Arts 201 B)

NOTE: The unique class ID field can contain a combination of data to make it unique for each class list. For example, combine a School ID (HS), a Course ID (201), and a Section ID (B) together for one unique ID (HS-201B).

StudentsForClassByLoginName.csv

unique class ID

student login name

unique class ID = must match the unique class ID used in the "ClassesByTeacher" CSV file (e.g. HS-201B)

student login name = the local device login name that the student is using to login to their device (e.g. jsmith)

Dynamic Class Lists Enhanced Display Format

The enhanced display format is an optional format that allows LanSchool to display the School, Course, Period and full student name when displaying each class list in the Teacher Console.

Enhanced Display Format Teacher CSV File

To do this, format the unique class ID field using the following pattern:

teacher login name	course ID\|\|school ID\|\|period ID	class display name
jsmith	201B\|\|HS\|\|2	Eng Lang Arts

Using the above example, the unique class ID would be HS-201B (School ID-Class ID). Be sure to use the |*| delimiter.

NOTE: The Period ID field is for display purpose only and is not used as part of the unique class ID.

Enhanced Display Format Student CSV File

To do this, insert a second field in the CSV for student display name as described below:

unique class ID	student display name	student login name
HS-201B	Jason Smith	jsmith

NOTE: If using the Enhanced Display Format described above in the “ClassesByTeacher” CSV file, the unique class ID must be formatted as school ID-course ID (note the hyphen).

For downloadable version of this guide: LanSchool Dynamic Class List Implementation Guide

For downloadable example of dynamic class lists: Dynamic Class List Samples