{"id":573,"date":"2013-04-10T19:42:20","date_gmt":"2013-04-10T19:42:20","guid":{"rendered":"http:\/\/psws.glenbard.org\/index.php\/2013\/04\/10\/adding-test-scores\/"},"modified":"2025-01-29T07:32:12","modified_gmt":"2025-01-29T13:32:12","slug":"adding-test-scores","status":"publish","type":"post","link":"https:\/\/docs.glenbard.org\/index.php\/ps-2\/admin-ps\/general-admin-ps\/adding-test-scores\/","title":{"rendered":"Adding Test Scores"},"content":{"rendered":"<div class=\"nolwrap\"><p>There are two ways to add test scores into PowerSchool, manually or an import. When adding many scores, importing is the best method, but takes time and care. Adding one off or adjusting scores can be done though the manual method.<\/p>\n<h1 id=\"manually-adding-test-scores\">Manually Adding Test Scores<\/h1>\n<ol>\n<li>Log into PowerSchool Administrator<\/li>\n<li>Select the student<\/li>\n<li>Click on\u00a0<strong>Test Results<\/strong>\u00a0from the left menu<\/li>\n<li>Select the test the scores are a part of<\/li>\n<li>Click\u00a0<strong>Submit<\/strong><\/li>\n<li>Enter the date of the test\n<ul>\n<li>For test dates other then MAP and AP tests, the actual test date can be used.<\/li>\n<li><span style=\"line-height: 1.3em;\">The test dates for MAP must be one of the below where YYYY is the four digit year\u00a0<\/span>\n<ul>\n<li>For Fall \u00a0 \u00a0 10\/01\/YYYY<\/li>\n<li>For Winter 01\/01\/YYYY<\/li>\n<li>For Spring 05\/01\/YYYY<\/li>\n<\/ul>\n<\/li>\n<li>For AP Tests use 05\/01\/YYYY<\/li>\n<\/ul>\n<\/li>\n<li>Enter the semester it was taken<\/li>\n<li>Enter the grade level of the student at the time the test was taken<\/li>\n<li>The next screen will show all the possible scores available<\/li>\n<li>Enter the score in the <b>Numeric\u00a0<\/b>column that corresponds to that score\n<ul>\n<li>Do not enter information in the Alpha and Percent columns<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h1 id=\"importing-scores\">Importing Scores<\/h1>\n<p>Importing test scores is different then a normal import. \u00a0For each test, one of the below templates must be used. \u00a0Also once a test is imported, test scores cannot be add, updated, or changes via an import; they must be done by hand, manually. \u00a0The import templates are to be opened using Excel<\/p>\n<p>Importing scores is a two step process. Step one is enter the data into the proper template below. \u00a0Step two is to send the template to the school data personal, who can then import the data. \u00a0If the data is not enter correctly in step one, the data personal are not responsible for data being importing incorrectly.<\/p>\n<h3 id=\"using-the-import-template\">Using the Import Template<\/h3>\n<p>The staff member in charge of creating the file to be imported into PowerSchool must use the appropriate template below.<\/p>\n<ol>\n<li>Decide which test will be imported<\/li>\n<li>Download the appropriate template below<\/li>\n<li>Open the template in Excel\n<ul>\n<li>For more information on opening the template in Excel Please go here\u00a0<a href=\"index.php?option=com_content&amp;view=article&amp;id=72:exporting-from-powerschool-to-excel&amp;catid=59:powerschool-tips&amp;Itemid=170\">Opening File in Excel<\/a><\/li>\n<\/ul>\n<\/li>\n<li>All fields in the template are required\n<ul>\n<li>If a score is unavailable, leave that score empty. \u00a0Do not enter a zero or anything<\/li>\n<li>For test dates other then MAP, the actual test date can be used.<\/li>\n<li><span style=\"line-height: 1.3em;\">The test dates for MAP must be one of the below where YYYY is the four digit year\u00a0<\/span>\n<ul>\n<li>For Fall \u00a0 \u00a0 10\/01\/YYYY<\/li>\n<li>For Winter 01\/01\/YYYY<\/li>\n<li>For Spring 05\/01\/YYYY<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li>Once the file is finished, create a Web Help Desk ticket with the attachment with the problem type of student data request\n<ul>\n<li>Remember that once scores are imported the only way to change, update, or delete scores is by individual students manually<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h3 id=\"importing-test-score\">Importing Test Score<\/h3>\n<p>In the building, only data personal are allowed to import data into PowerSchool. \u00a0Test scores follow a similar process to import test scores are import demographics. \u00a0The only difference is that there is one more step involved. \u00a0As with every import into PowerSchool, always either test the import on the test server or import only the first several line, check the import, and then import the remainder of the file<\/p>\n<ol>\n<li>Review the file and verify that everything is filled in properly\n<ul>\n<li>If the file is incorrect, notify the person creating the file that something is out of place. \u00a0Be specific.<\/li>\n<\/ul>\n<\/li>\n<li>Log into PowerSchool<\/li>\n<li>Click on\u00a0<strong>Special Function<\/strong>&gt;<strong>Importing &amp; Exporting<\/strong>&gt;<strong>Quick Import<\/strong><\/li>\n<li>For\u00a0<strong>Table<\/strong> choose\u00a0<strong>Test Results<\/strong><\/li>\n<li>Choose the file<\/li>\n<li>Check the checkbox\u00a0<strong>Suggest field map<\/strong><\/li>\n<li>Click<b>\u00a0Submit<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-560 size-thumbnail\" style=\"vertical-align: middle;\" src=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/Quick_Import-1-150x150.png\" alt=\"Quick Import Start\" width=\"150\" height=\"150\" \/><\/b><\/li>\n<li>Choose the proper test<img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-561\" src=\"\/wp-content\/uploads\/2013\/04\/Select_Test-1.png\" alt=\"Select Test\" width=\"186\" height=\"49\" srcset=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/Select_Test-1.png 689w, https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/Select_Test-1-300x79.png 300w\" sizes=\"auto, (max-width: 186px) 100vw, 186px\" \/><\/li>\n<li>Make sure the settings look like the settings in the table below<\/li>\n<li>Click\u00a0<strong>Submit<\/strong><\/li>\n<\/ol>\n<table style=\"height: 2145px;\" border=\"0\" width=\"600\">\n<tbody>\n<tr>\n<th>Test<\/th>\n<th>Import Template<\/th>\n<th>Import Settings<\/th>\n<\/tr>\n<tr>\n<td>ACT<\/td>\n<td>\u00a0<a href=\"\/wp-content\/uploads\/2013\/04\/ACT%20Score%20Template.txt\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2013\/04\/txt.png\" alt=\"\" width=\"32\" height=\"32\" border=\"0\" \/><\/a><a href=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2017\/03\/ACT-Score-Template.txt\" target=\"_blank\" rel=\"noopener noreferrer\">ACT-Score-Template<\/a><\/td>\n<td>\u00a0<a href=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/ACTImport.png\" data-rel=\"lightbox-image-0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-3370\" src=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/ACTImport-300x255.png\" alt=\"ACTImport\" width=\"300\" height=\"255\" srcset=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/ACTImport-300x255.png 300w, https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/ACTImport-768x652.png 768w, https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/ACTImport.png 884w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>Explore<\/td>\n<td>\u00a0<a href=\"\/wp-content\/uploads\/2013\/04\/Explorer%20Score%20Template.txt\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2013\/04\/txt.png\" alt=\"\" width=\"32\" height=\"32\" border=\"0\" \/><\/a><a href=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2017\/03\/Explorer-Score-Template.txt\" target=\"_blank\" rel=\"noopener noreferrer\">Explorer Score Template<\/a><\/td>\n<td><a href=\"\/wp-content\/uploads\/2013\/04\/ExploreImportSettings.png\" data-rel=\"lightbox-image-1\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"\/wp-content\/uploads\/2013\/04\/ExploreImportSettings.png\" alt=\"Explore ImportSettings\" width=\"302\" height=\"249\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>MAP<\/td>\n<td>\u00a0<a href=\"\/wp-content\/uploads\/2013\/04\/MAP%20Score%20Template.txt\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2013\/04\/txt.png\" alt=\"\" width=\"32\" height=\"32\" border=\"0\" \/><\/a><a href=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2017\/03\/MAP-Score-Template.txt\" target=\"_blank\" rel=\"noopener noreferrer\">MAP Score Template<\/a><\/td>\n<td>\u00a0<a href=\"\/wp-content\/uploads\/2013\/04\/MAPImportSettings.png\" data-rel=\"lightbox-image-2\" data-rl_title=\"\" data-rl_caption=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" title=\"\" src=\"\/wp-content\/uploads\/2013\/04\/MAPImportSettings.png\" alt=\"MAP Import Settings\" width=\"315\" height=\"205\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>PLAN<\/td>\n<td>\u00a0<a href=\"\/wp-content\/uploads\/2013\/04\/PLAN%20Score%20Template.txt\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2013\/04\/txt.png\" alt=\"\" width=\"32\" height=\"32\" border=\"0\" \/><\/a><a href=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2017\/03\/PLAN-Score-Template.txt\" target=\"_blank\" rel=\"noopener noreferrer\">PLAN Score Template<\/a><\/td>\n<td><a href=\"\/wp-content\/uploads\/2013\/04\/PLANImportSettings.png\" data-rel=\"lightbox-image-3\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"\/wp-content\/uploads\/2013\/04\/PLANImportSettings.png\" alt=\"PLAN Import Settings\" width=\"325\" height=\"294\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>PSAE<\/td>\n<td>\u00a0<a href=\"\/wp-content\/uploads\/2013\/04\/PSAE%20Score%20Template.txt\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2013\/04\/txt.png\" alt=\"\" width=\"32\" height=\"32\" border=\"0\" \/><\/a><a href=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2017\/03\/PSAE-Score-Template.txt\" target=\"_blank\" rel=\"noopener noreferrer\">PSAE Score Template<\/a><\/td>\n<td><a href=\"\/wp-content\/uploads\/2013\/04\/PSAEImportSettings-1.png\" data-rel=\"lightbox-image-4\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"\/wp-content\/uploads\/2013\/04\/PSAEImportSettings-1.png\" alt=\"PSAE Import Settings\" width=\"321\" height=\"225\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>\u00a0ACCESS<\/td>\n<td><a href=\"\/wp-content\/uploads\/2013\/04\/PSAE%20Score%20Template.txt\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/uploads\/2013\/04\/txt.png\" alt=\"\" width=\"32\" height=\"32\" border=\"0\" \/><\/a>\u00a0<a href=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/AccessTemplate.txt\" target=\"_blank\" rel=\"noopener noreferrer\">Access Score Template<\/a><\/td>\n<td>\u00a0<a href=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/AccessSetup-1.png\" data-rel=\"lightbox-image-5\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3839 size-large\" src=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/AccessSetup-1-1024x662.png\" alt=\"\" width=\"720\" height=\"465\" srcset=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/AccessSetup-1-1024x662.png 1024w, https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/AccessSetup-1-300x194.png 300w, https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/AccessSetup-1-768x496.png 768w, https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/AccessSetup-1.png 1855w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>SAT<\/td>\n<td><a href=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/SAT-Template.txt\" target=\"_blank\" rel=\"noopener noreferrer\">SAT\u00a0Score Template<\/a><\/td>\n<td>\u00a0<a href=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/SAT_template.png\" data-rel=\"lightbox-image-6\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3888 size-medium\" src=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/SAT_template-300x211.png\" alt=\"\" width=\"300\" height=\"211\" srcset=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/SAT_template-300x211.png 300w, https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/SAT_template-768x541.png 768w, https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/SAT_template.png 834w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>PSAT 8\/9PSAT\/NMSQT<\/td>\n<td><a href=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/PSAT-Template.txt\" target=\"_blank\" rel=\"noopener noreferrer\">PSAT Score Template<\/a><\/td>\n<td>\u00a0<a href=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/psatImport.png\" data-rel=\"lightbox-image-7\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4157 \" src=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/psatImport.png\" alt=\"\" width=\"336\" height=\"300\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>AP Test<\/td>\n<td><a href=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2025\/01\/AP-Template-1.txt\">AP Test Template<\/a><\/td>\n<td>\u00a0<a href=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/APTestIMport.png\" data-rel=\"lightbox-image-8\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3929 size-medium\" src=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/APTestIMport-151x300.png\" alt=\"\" width=\"151\" height=\"300\" srcset=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/APTestIMport-151x300.png 151w, https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/APTestIMport-768x1523.png 768w, https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/APTestIMport-516x1024.png 516w, https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/APTestIMport.png 869w\" sizes=\"auto, (max-width: 151px) 100vw, 151px\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>AAPPLTest<\/td>\n<td><a href=\"\/wp-content\/uploads\/2019\/10\/AAPPL-Template.txt\" target=\"_blank\" rel=\"noopener noreferrer\">AAPPL Test Template<\/a><\/td>\n<td>\u00a0<a href=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/AAPPL.png\" data-rel=\"lightbox-image-9\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4215 size-full\" src=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/AAPPL.png\" alt=\"\" width=\"1306\" height=\"841\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>DLM<\/p>\n<p style=\"font-size: small;\">Put in the score of 9 for missing\/not tested stores<\/p>\n<\/td>\n<td><a href=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2019\/10\/DLM-Template.txt\" target=\"_blank\" rel=\"noopener noreferrer\">DML Test Template<\/a><\/td>\n<td>\u00a0<a href=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/DLM.png\" data-rel=\"lightbox-image-10\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4224 size-full\" src=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/DLM.png\" alt=\"\" width=\"1628\" height=\"885\" \/><\/a><\/td>\n<\/tr>\n<tr>\n<td>STAMP<\/p>\n<p style=\"font-size: small;\">If Listening and Speaking have non-numeric values use the column ending in .3<\/p>\n<\/td>\n<td><a href=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/STAMPTemplate.txt\" target=\"_blank\" rel=\"noopener noreferrer\">STAMP Test Template<\/a><\/td>\n<td>\u00a0<a href=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/DLM.png\" data-rel=\"lightbox-image-11\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-4224 size-full\" src=\"https:\/\/docs.glenbard.org\/wp-content\/uploads\/2013\/04\/DLM.png\" alt=\"\" width=\"1628\" height=\"885\" data-wp-editing=\"1\" \/><\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>There are two ways to add test scores into PowerSchool, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":560,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[100],"tags":[342,343,345,344],"class_list":["post-573","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-general-admin-ps","tag-excel","tag-importing","tag-test-results","tag-test-scores"],"acf":[],"_links":{"self":[{"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts\/573","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=573"}],"version-history":[{"count":32,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts\/573\/revisions"}],"predecessor-version":[{"id":6556,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts\/573\/revisions\/6556"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/media\/560"}],"wp:attachment":[{"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/media?parent=573"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/categories?post=573"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/tags?post=573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}