Export Data Index  

On the screen in Admin Mode, admins can export data files for Grades & Schedules, Attendance, Students, and Transcripts (see below). The export format is:

•  CSV (comma-delimited) or TXT (tab-delimited)
•  Unix carriage returns
•  Header row
•  UTF-8 character set (this matters only if your data has accented characters like in "Renée")

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). Note: Grades are not exported for teachers with free accounts; they must have a paid account or active trial. Columns:

StudentID
LastName
FirstName
SchoolCode — customizable
CourseCode — customizable
SectCode — customizable
Subject — course title
Period — customizable
Teacher — name (main teacher only, not co-teachers)
StaffCode — 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 contains 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 Jupiter allows an unlimited number of parents/contacts per students, you can only export the first four.

Standards

This data file contains all the standards and objectives from your Setup Standards screen. Note: To import these standards into another district, you must copy and paste one standard at a time; you cannot import all the standards at once.

Transcripts

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"; the last row is labeled "Cumulative"
CourseCode
CourseTitle
GradeRaw — original grade, like B+
GradeMark — optionally the grade without +/- signs, like B
Pass — "Pass" or "Fail"
AttemptCredits
EarnCredits
WeightedGPA — grade point average, extra for Honors/AP, includes all courses
UnweightedGPA — grade point average, no extra for Honors/AP, includes only courses designated for college application
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.

Gradebook as PDF/HTML

Export your gradebooks as PDF or HTML files to turn in electronic copies at the end of the year.

1.  Click the "Print" tab, then click "". (You won't actually print on paper, but you need this report.)
2.  From the menus select "All classes/subjects" and "All assignments".
3.  Windows Internet Explorer: If you have PDF creation software like Adobe Acrobat (not Reader) or PrimoPDF, use it. Otherwise Internet Explorer has too many bugs and limitations, so you'll need to use a different browser. (Exporting a PRN file either crashes or there is no software to read the file, and the Save As option saves the login screen instead of the report.)
Windows Firefox: From the File menu select "Save Page As...", then set the menu at the bottom to "web page, complete" and enter a descriptive file name with an .htm or .html extension, like "Jones 2009-2010 1st semester.html". When you turn in the file, also turn in the folder that is created with it, e.g., "Jones 2009-2010 1st semester_files".
Mac OS X: Click the "Print" button, then click the "PDF" button and select "Save as PDF...".
4.  Repeat these steps for each grading period for 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.)


Troubleshooting

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". (Internet 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.


See also: Integrate with Other Software