Export (Enterprise)

The Export area allows you to export a CSV file of a user, course, section, course enrollment, gradebook, and attendance information.

For a successful export, users should have a Unique User ID, courses should have a course code, and sections should have a section code or section school code in Schoology.

1. Click Tools.
2. Select School Management from the drop-down menu.
3. Click Export from the navigation menu.

Export Users

The Users tab provides the ability to export users.

1. Select the Fields (types of information) to export. Each field will export a column of user information, which you may filter as needed.

   Name	Description
   Schoology User ID	The unique user ID assigned by Schoology
   Unique User ID	The Unique ID field in Schoology, which is often a student ID assigned in the SIS
   SIS User ID	The SIS user ID may be used for organizations that have imported PowerSchool Learning content only.
   School NID	The unique school ID assigned by Schoology
   School Title	The name of the main school the user is affiliated with
   Additional Schools	The NIDs of additional schools the user is affiliated with
   Name Prefix	The user's honorific or prefix (ex. Mr., Mrs., Dr.)
   First Name	The user's first name
   First Name (preferred)	The user's preferred first name
   Last Name	The user's last name
   Role	The user's role within Schoology (ex. Student, Parent, Teacher)
   Username	The username assigned by the district
   Email	The user's email address
   Position/Job Title	The user's position, as displayed on their profile
   Graduation Year	The user's graduation date
   Birthday	The user's birthday
   Gender	The user's gender
   Bio	The user's bio information, as displayed on their profile
   Subjects Taught	The subject(s) the user teaches
   Levels Taught	The level(s) the user teaches
   Phone Number	The user's phone number
   Website	The user's website
   Interests	The user's interests, as displayed on their profile
   Activities	The user's activities, as displayed on their profile

2. Click Next.
3. Click Export.

Export Courses

Use the Courses tab to export your school's course information. To export, courses should have a course code, and sections should have a section code or section school code in Schoology.

1. Select the grading period(s) associated with the courses to export.
   • Select Active—Selecting this option will select all current grading periods at your school. Current grading periods are grading periods that have started, but not yet ended.
2. Select the course(s) to export. If there are more than 500 courses associated with the selected grading period(s), Schoology will automatically export a CSV file of all courses.
   • Select All—Selecting this option will select all of the listed courses.

3. Select the course information to export.

   Name	Description
   Course Name	The name of the course in Schoology
   Department Code	The name of the department in Schoology
   Course Code	The code associated with the course (ex. MATH-101)
   Course Description	The description of the course
   Credits	The number of credits the course is worth
   Course NID	The unique ID number assigned by Schoology
   School ID	The unique ID number assigned by Schoology
   School Title	The name of the school

4. Click Export.

Export Sections

Use the Sections tab to export your school's course sections. Courses should have a course code to export sections, and sections should have a section code or section school code in Schoology.

1. Select the grading period(s) associated with the sections to export.
   • Select Active: Selecting this option will select all current grading periods at your school. Current grading periods are grading periods that have started, but not yet ended.
2. Select the section(s) to export. If there are more than 500 courses associated with the selected grading period(s), Schoology will automatically export a CSV file of all courses.
   • Select All: Selecting this option will select all of the listed sections.

3. Select the section information to export.

   Name	Description
   Course Name	The name of the course in Schoology
   Course Code	The code associated with the course (ex. MATH-101)
   Department Code	The name of the department in Schoology
   Course Description	The description of the course
   Credits	The number of credits the course is worth
   Section Name	The name of the section in Schoology
   Section Code	The code associated with each section can be re-used for different grading periods
   Section School Code	The section school code that is unique to that specific class, school, and term
   Section Description	The description of the section
   Location	The location of the section as listed under Information
   Meeting Days	The days of the week the section meets as listed under Information (1=Monday, 2=Tuesday, etc.)
   Weighted Grading Categories	The number of weighted grading categories applied to the section
   Final Grading Scale ID	The ID number that is associated with the final grading scale, which is the same across sections with the same scale
   School ID	The unique school ID as assigned by Schoology
   School Title	The name of the school
   Section NID	The unique section ID as assigned by Schoology

4. Click Export.

Export Course Enrollments

Use the Course Enrollments tab to export your school's course enrollments. To export course enrollments, users should have a Unique User ID, courses should have a course code, and sections should have a section code or section school code in Schoology.

1. Select the grading period(s) associated with the sections whose enrollment to export.
   • Select Active: Selecting this option will select all current grading periods at your school. Current grading periods are grading periods that have started, but not yet ended.
2. Select the section(s) to export. If there are more than 500 courses associated with the selected grading period(s), Schoology will automatically export a CSV file of all courses.
   • Select All: Selecting this option will select all of the listed sections.

3. Select the user information to export.

   Name	Description
   Unique User ID	The Unique ID field in Schoology, which is often a student ID assigned in the SIS
   First Name	The first name of the enrolled member
   Last Name	The last name of the enrolled member
   Email	The email address of the enrolled member
   Course Name	The name of the course in Schoology
   Course Code	The code associated with the course (ex. MATH-101)
   Section Name	The name of the section in Schoology
   Section Code	The code associated with each section can be re-used for different grading periods
   Section School Code	The section school code that is unique to that specific class, school, and term
   SIS Section School Code	The section school code in your organization's SIS, if you use cross-listing
   Enrollment Type (1=Admin/2=Member)	The enrollment type of each account within each course
   Status	The current status of the enrollment
   School ID	The unique school ID as registered in Schoology
   School Title	The name of the school

4. Click Export.

Export Gradebook

Use the Gradebook tab to export your school's grades. Grades are calculated in this export as Gradebook as CSV.

• To export gradebook information, users should have a Unique User ID, courses should have a course code, and sections should have a section code or section school code in Schoology.
• Exported gradebooks do not include unpublished items in the Overall or Grading Period grade. However, each unpublished grade item is included in rows in the report.

There are several important factors in how grades are calculated in this format:

1. Choose to export by School or Individual Users.
2. Select the grading period(s) associated with the sections whose grades to export.
   • Select Active: Selecting this option will select all current grading periods at your school. Current grading periods are grading periods that have started, but not yet ended.
3. Select the section(s) to export. If there are more than 500 courses associated with the selected grading period(s), Schoology will automatically export a CSV file of all courses.
   • Select All: Selecting this option will select all of the listed sections.

4. Select the user information to export.

   Name	Description
   Unique User ID	The Unique ID field in Schoology, which is often a student ID assigned in the SIS
   School ID	The unique school ID as registered in Schoology
   School Title	The name of the school
   First Name	The first name of the enrolled member
   Last Name	The last name of the enrolled member
   Email	The email address of the enrolled member
   Position/Job Title	The position of the enrolled member, as displayed on their profile
   Role	The enrolled member's role within Schoology (ex. Student, Parent, Teacher)
   Course Name	The name of the course in Schoology
   Course Code	The code associated with the course (ex. MATH-101)
   Department Code	The name of the department in Schoology
   Section Name	The name of the section within Schoology
   Section Code	The code associated with each section can be re-used for different grading periods
   Section School Code	The section school code that is unique to that specific class, school, and term
   SIS Section School Code	The section school code in your organization's SIS, if you use cross-listing
   Grading Period	The grading period associated with the graded item
   Titles	The names of the grading periods and graded items
   Due Dates	The due date for the graded item (if applicable)
   Max Points	The maximum amount of points available for the grading period or graded item
   Grades	The number of points awarded
   Letter Grades	The letter grade for the number of points awarded
   Comments	All comments made per graded item

5. On the next screen, choose Grade Items or Midterm/Final, Overall Grades.
6. Click Export.

Export Attendance

Use the Attendance tab to export your school's attendance. The export can only include present records that have attendance comments, it cannot include present records without comments.

1. Choose to export by School or Individual Users.
2. Select the grading period associated with the courses to export.
   • Select Active: Selecting this option will select all current grading periods at your school. Current grading periods are grading periods that have started, but not yet ended.
3. Select the section(s) to export. If there are more than 500 courses associated with the selected grading period(s), Schoology will automatically export a CSV file of all courses.
   • Select All: Selecting this option selects all of the listed sections.
   • Add date range: Selecting this option enables you to select the date range of the attendance you would like to export.

4. Select the attendance records to export.

5. Select the user information to export.

6. Click Export. The CSV file will list marked attendance (Absent, Late, or Excused) by course section, which you may filter as needed.

   
   

If you are using Schoology in a double-byte language, such as Japanese, Chinese, or Korean, you may have to change the encoding of the CSV file to correctly display the characters.

Auto-Export

Use the Auto-Export tab to use the auto-export tool.