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 |
|
|
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 |
|
|
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 |
|
|
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.