Export
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.
Click Tools.
Select School Management from the drop-down menu.
Click Export from the navigation menu.
Export users
The Users tab provides the ability to export users.
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
Click Next.
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.
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.
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.
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
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.
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.
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.
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
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.
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.
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.
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
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:
Gradebook as CSV | |
|---|---|
Overall / Grading Period Grade | Overall or Grading Period grade calculations are included in the report. |
Hidden or Unpublished Materials | Included in the report but not included in Overall or Grading Period grade calculations. |
Factors | Items with a factor are multiplied by that factor and then included in the final score. |
Weighted Categories | Impact grade calculations. |
Choose to export by School or Individual Users.
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.
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.
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
On the next screen, choose Grade Items or Midterm/Final, Overall Grades.
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.
Choose to export by School or Individual Users.
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.
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.
Select the attendance records to export.
Select the user information to export.
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.