Engrade
Create an OpenSSH Keyfile on Windows
Acquire puttygen.exe from http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html
Step 1: Click the Generate Button
Follow the instructions for moving the mouse around to generate a secure key.
The screen should now look something like this:
Copy the text in the top field (Public key for pasting...) and send this to Engrade.
Now click on the Conversionts menu item and choose Export OpenSSH Key.
Click Yes to the dialog that says "Are you sure you want to save this key without a passphrase to protect it?"
Choose a filename and path to save it.
Save it to a filename such as d:\genesis\engrade.openssh.
In the Core -> Scheduler screen for Engrade, enter this full filename in the Open SSH Kefile field.
Engrade Export Task
Overview
This task exports School District, Student, Teacher, and Course information for all sections and classes currently in session. The file is in comma-separated values (CSV) format.
Setup
- Federal LEA Code field must be filled in (Setup -> Districts -> Select District). Use the "Click to lookup code" link and fill in this field with the NCES District ID value.
- Federal School Code field must be filled in (Setup -> Schools - Select School). Use the "Click to find code" link and fill in this field with the NCES School ID value.
- Engrade Class Subject Code Mappings. These mappings should be entered into the THIRDPARTYSUBJCODE codes table. (Setup -> Codes -> THIRDPARTYSUBJCODE)
Code | Description |
1 | English/Language Arts |
5 | Science |
12 | Math |
18 | Religion |
19 | Business & Economics |
25 | Music |
26 | Art |
27 | Theatre |
36 | Government & Politics |
38 | Dance |
39 | Computer Science |
40 | Geography |
41 | PE & Health |
42 | Foreign Language |
43 | Engrade |
44 | History |
48 | CTE |
60 | Social Studies |
99 | Other |
4. Third Party Class Subject Code field needs to be filled in with the appropriate Engrade mapping for each course in the school. This field is a drop down menu found on Scheduling -> Curriculum -> Select Course .
Options
Options include selecting one or more schools to include in the Export.
Output
Column | Notes |
districtcode | NCES District ID |
districtname |
|
schoolcode | NCES School ID |
schoolname |
|
schoolyear |
|
schoolgradingperiod | Default value: 1 |
schoolgradingperiodstartdate | School Start Date |
schoolgradingperiodenddate | School End Date |
period |
|
teachercode |
|
teachername |
|
teacheremailaddress |
|
classcode |
|
classname |
|
classgradelevel |
|
classsubjectcode | Engrade Mapping |
classsubjectname |
|
studentcode |
|
studentfirstname |
|
studentmiddlename |
|
studentlastname |
|
studentphone |
|
studentemailaddress |
|
studentgender |
|
studentethnicity |
|
studentdateofbirth |
|
studentaddress1 |
|
studentaddress2 |
|
studentaddresscity |
|
studentaddressstate |
|
studentaddresszip |
|
guardianphone |
|
studentgradelevel |
|
sourcestudentusername |
|
projectedgraduationdate |
|
sourceteacherusername |
|
teacherpersonaltitleprefix |
|
teacherfirstname |
|
teacherlastname |
|
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article