How Do I Export Rosters to a Third-Party Gradebook?

Schoolmaster for Windows/Macintosh systems that have licensed the Classroom Module can export class rosters and associated biographical information to third-party electronic gradebooks that can import tab delimited text files in the format described below.

The Schoolmaster export program (Utility, Import/Export, Export Classroom Rosters) creates several ASCII text files that contain teacher, roster, report card, and comment information. The third-party gradebook may import some or all of the information outlined in the file formats below, depending on the scope of the product. Consult your gradebook documentation or contact the manufacturer's technical support department for details about the steps required for the actual import of the data into the third-party gradebook.

Before Exporting

• Acquire the Schoolmaster Classroom Module licensed for an appropriate number of teacher/users.
• In the Schoolmaster User File, identify appropriate teachers as Classroom Users (Setup, General, Users, select name, choose Task, Toggle Classroom User).
• Establish courses, sections, and student schedules in Schoolmaster.

After Exporting

Ensure that teachers do not edit Schoolmaster course, section, instructor, and student identification numbers while using their Gradebooks; this information is crucial to importing marks back into Schoolmaster.

Export File Formats

Teachers (TEACHERS.RXP)

1. Instructor ID
2. Last Name
3. Middle Name
4. First Name
5. Grade Level

Classes/Sections (CLASSES.RXP)

1. E = Elementary Class
   S = Secondary Course-Section
2. Instructor ID
3. Class Code or Course-Section ID
4. Class or Section Title
5. Period
6. Term Code (if a course-section)
7. Elementary Report Card Layout Code (if an elementary class)
8. Standards Report Card Layout Code

Rosters (ROSTER###.RXP where ### is the Instructor ID)

1. Class Code or Course-Section ID
2. Student ID
3. Last Name
4. Middle Name
5. First Name
6. Gender
7. Grade Level
8. Birthdate
9. Home Phone
10. Street Address
11. Street Address Line 2
12. Zip Code
13. Parent/Guardian Name

Elementary Report Card Layouts (ELAYOUT.RXP)

1. Code
2. Title

Elementary Report Card Subjects (ESUBJECT.RXP)

1. Subject ID
2. Elementary Report Card Layout Code
3. Title -- Subject Titles containing tabs, line feeds (lf), and carriage returns (cr) would compromise the integrity of the tab delimited file format. If these characters are encountered, they are exported as the following: tab = ASCII character 167; lf (line feed) = ASCII character 176; cr (carriage return) = ASCII character 177.
4. A = Alpha
   N = Numeric
   C = for Comment
   N = Narrative

Standards Report Card Layouts (SLAYOUT.RXP)

1. Code
2. Title

Standards Report Card Subjects (SSUBJECT.RXP)

1. Subject ID
2. Standards Report Card Layout Code
3. Standards Code (blank if this a comment, narrative, or non-standard mark)
4. Title -- Subject Titles containing tabs, line feeds (lf), and carriage returns (cr) would compromise the integrity of the tab delimited file format. If these characters are encountered, they are exported as the following: tab = ASCII character 167; lf (line feed) = ASCII character 176; cr (carriage return) = ASCII character 177.
5. A = Alpha
   N = Numeric
   C = Comment
   N = Narrative

Comments (COMMENTS.RXP)

1. Code
2. Text