| Export Data |
|
On the page in Admin Mode, admins can export data files for Grades & Schedules, Attendance, Students, and Transcripts (see below). The export format is:
Grades & Schedules This data file is designed to import report card grades into a 3rd party SIS or to analyze grades in Excel or other software. You can select which grading periods and which students to export. Also you may optionally exclude grades if the teacher has not locked their final grades yet (see Report Cards). Columns:
StudentID
LastName FirstName SchoolCode — customizable CourseCode — customizable SectCode — customizable Subject — course title Period — customizable Teacher — name TeacherCode — customizable Term — customizable, like Q1, S1, or numbers Standard — for standards-based grading only Objective — for standards-based grading only Mark — letter grade Percent — if applicable Comment — text, not comment codes Attendance This data file is designed to import attendance into a 3rd party SIS. Columns:
Date — YYYY-MM-DD format
StudentID SchoolCode — customizable CourseCode — customizable SectCode — customizable Period — customizable Roll — custom codes, like P, A, T, Exc Students This data file exports all student names, ID's, contact info, demographics, and special programs for all students in the district or just your school. Data fields are the same as for Importing.
Note: While SnapGrades allows an unlimited number of parents/contacts per students, you can only export the first four. This data file is designed to import transcript grades and GPA's into Excel or a 3rd party database for statistical analysis. Columns:
StudentID
LastName FirstName MiddleName SchoolName SchoolCode GradClass — year of high school graduation Term — any string, like "2009-2010 Semester 1" CourseCode CourseTitle GradeRaw — original grade, like B+ GradeMark — optionally the grade without +/- signs, like B Pass — "Pass" or "Fail" AttemptCredits — attempted credits for all classes PassCredits — credits for passing classes AttemptGPA — grade point average of all classes PassGPA — grade point average of only passing classes Comment1 Comment2 This contains three different types of rows. Your software must read the data in the term and course columns in each row to determine the type of information:
Grades for specific courses (have course columns)
Subtotal credits & GPA's for each term (course is blank) Cumulative credits & GPA's (term equals "Cumulative"; course is blank) Teachers may export the following in Gradebook Mode: Assignments
Export assignments to a spreadsheet so you may update grades in Excel while offline, then re-import the spreadsheet when back online. This is not intended for importing into other software. See Import/Export Assignments. Export your gradebooks as PDF or HTML files to turn in electronic copies at the end of the year.
Ad Hoc Reporting
You may export all the data above to import into your own database, which you may then use for ad hoc reporting. (For performance reasons, you may not query our database directly, because a badly constructed query could slow down the whole system.) If nothing downloads, make sure your browser is not blocking downloads. For Internet Explorer, in the "Tools" menu select "Internet Options...". Click the "Security" tab and click the "Custom Level" button. Scroll to find "Downloads" > "Automatic prompting for file downloads" and select "Enable". If Internet Explorer asks, "Do you want to view only the webpage content that was delivered securely?" select "No". (Interent Explorer has a bug when it tries to download encrypted files, so we export our files without encryption, which causes that security prompt.)
Or try Firefox instead, since that's much more stable and handles security better than Internet Explorer. |
