Direct Database Access (DDA) Process For Fixing Stored Grades

When a student is transferred out prior to the storing of term grades, or if a student is taking a course at another school not designated as there home school in Powerschool, their grades can be missed in the normal Store Grades process. In this case, use the following steps to store grades that got missed during the mass Grade Store process. (Note: This process will not delete a students current course registration, which would otherwise occur by transferring out and re-enrolling them into their previous school.)

1. On the Start Page, search for the student in question.
2. Switch to the Direct Database Access (DDA) site. (Note: the "Current Records in Selection" should show "1" representing the select student)
3. Select Student(1) table, if not already selected.
4. Select Table View.
5. Search for SchoolID (Note: the current ID in the field is the students current home school. Take note of this before moving to step 6.)
6. Change the SchoolID to the ID of the school where the course was taken. (Ex. If a student's home school is LPO (1045), but the course was taken at SHS (202), then the School ID should be changed to 202.)
7. Select Submit.
8. Switch back to Powerschool SIS.
9. Select the former school or school where course was taken from the School select menu on the Start Page.
10. Search for and select student.
11. Go to page Store Grades page. (School Management > Academics > Store Grades)
12. At this point you must be very careful with the settings you will choose. (IF YOU ARE UNSURE DO NOT CONTINUE WITHOUT ASSISTANCE.)
13. Leave the default settings for "Which Grades" and "Exclude/Include Class Enrollments."
14. Skip down to "Additional Filter Options", and check the box next to "Store grades for currently selected (1) students only"
15. Unless you are entering more than one grades, you should enter the course.section number for the course in the "Request that grades be stored only for a specific section" field. (Note: this is preferable, faster, and limits the possibility of massive human errors.)
16. Next, in the Class by term length section, select the "Yes" next to "Show all terms?" (This will show previews terms for the year.)
17. In the term(s) you are going to store a grade, select the appropriate option from the Store column drop down menu.
18. Unless you know that student is not receiving full credit, enter "100" in the "% of course credit" column.
19. In the "Options for classes enrolled at other schools" section, select "This school only" from the drop down menu.
20. Leave all other settings as is.
21. Select Submit (Upon submission, Powerschool will present a running log of the process. After the process has been successful, go the student's historical grades (Academic Records > Historical Course Grades) to see if the grade(s) and credits have been stored properly.)
22. Once the grades and credits have been store, switch back to the DDA. The student should still be selected, if not search for them again.
23. Select View Table.
24. Search for SchoolID
25. Change the SchoolID back to the ID of the student current school.
26. Select Submit.
27. Switch back to Powerschool SIS and verify that student is now active at his current school of enrollment.

Note: in some cases, you'll be creating a duplicate stored grade for course that were previous manually entered into historical grades. You will need to delete the prior duplicate. Be sure to select the correct one, otherwise you will need go through the Store Grade process again. A good way of telling the difference is to compare the "Associated section" field on the course details screen. Usually, the one you want to delete will say "none".