{"id":717,"date":"2013-09-24T19:42:08","date_gmt":"2013-09-24T19:42:08","guid":{"rendered":"http:\/\/psws.glenbard.org\/index.php\/2013\/09\/24\/junior-high-grades\/"},"modified":"2025-09-30T07:50:34","modified_gmt":"2025-09-30T12:50:34","slug":"junior-high-grades","status":"publish","type":"post","link":"https:\/\/docs.glenbard.org\/index.php\/ps-2\/admin-ps\/grades\/junior-high-grades\/","title":{"rendered":"Junior High Grades"},"content":{"rendered":"<div class=\"nolwrap\"><p>Freshman Math and Foreign prerequisite grades from middle school are imported into PowerSchool in the fall of each year for classes taken the prior year.<\/p>\n<p><a href=\"\/wp-content\/uploads\/2013\/09\/jr%20high%20grade%20import%20template.xls\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-221\" src=\"\/wp-content\/uploads\/2012\/10\/xls.png\" alt=\"\" width=\"32\" height=\"32\" border=\"0\" \/><span title=\"jr high grade import template.xls\">jr high grade import template.xls<\/span><\/a><\/p>\n<p>Via Web Help Desk, the school registrar will send technology a spreadsheet with grades containing the following fields:<\/p>\n<ul>\n<li>Student_number<\/li>\n<li>Course_name<\/li>\n<li>Credit_Type<\/li>\n<li>Excludefromclassrank<\/li>\n<li>excludefromgpa<\/li>\n<li>Excludefromhonorroll<\/li>\n<li>Earnedcrhrs<\/li>\n<li>potentialcrhrs<\/li>\n<li>gpa_addedvalue<\/li>\n<li>Gpa_Points<\/li>\n<li>Grade<\/li>\n<li>Gradescale_Name<\/li>\n<li>Grade_Level<\/li>\n<li>Storecode (S1,S2)<\/li>\n<li>Year (2016-2017)<\/li>\n<\/ul>\n<p>Technology will need to update the spreadsheet in the following ways:<\/p>\n<ul>\n<li>Add a SchoolName column = Junior High School<\/li>\n<li>Change Year to term id and update accordingly<\/li>\n<li>Perform a data quality check and look for outliers<\/li>\n<li>Save as tab delimited<\/li>\n<li>After import remove Course Numbers<\/li>\n<\/ul>\n<p>Run an import to historical grades to the school.\u00a0 Consider importing to test first to ensure no errors will be encountered in Production.<\/p>\n\n\n<p><\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Freshman Math and Foreign prerequisite grades from middle school are [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[92],"tags":[207],"class_list":["post-717","post","type-post","status-publish","format-standard","hentry","category-grades","tag-grades"],"acf":[],"_links":{"self":[{"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts\/717","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/comments?post=717"}],"version-history":[{"count":5,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts\/717\/revisions"}],"predecessor-version":[{"id":6665,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts\/717\/revisions\/6665"}],"wp:attachment":[{"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/media?parent=717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/categories?post=717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/tags?post=717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}