Keywords: Final Grades, Published Aliases: Final Grades As the school year ends, we have some recommended steps to finalize and export grades from your Schoology courses: Check to make sure all grades are published You may have set some of your materials to Unpublished throughout the school year to prevent students from accessing those items. Unpublishing an item also removes the item from students' final grade report that is visible to them in Schoology. If you have unpublished an item to prevent students from accessing it, but you want the received grades for that item to factor into the student's calculated overall grade, you must re-publish the material(s). Use the Bulk Edit tool to see all of your materials at a glance, and to modify materials in bulk: Go to your course. Click Gradebook. Click the vertical three dots in the upper right corner of the gradebook. Select Bulk Edit from the drop-down menu. In your list of materials, published items are indicated by a checkmark in the second column (denoted by the green dot). Check the boxes in this column to publish materials and add them to the final grade calculation. In the above screenshot, Chapter 4 Quiz is Published and students' scores on this quiz are included in their final grade. Chapter 4 Lab Report is unpublished and is not factored into their final grades. Overriding Final Grades If needed, you can add a grade override column to replace the calculated overall score for students in a course. This automatically hides the calculated score for students and lets you enter a custom score using the new column. To override the calculated overall grade: Click Courses in the header and select your course in the drop-down menu. Click Gradebook in the left menu of the course. Click Grade Setup. Check Override calculated overall grade. Click Save. Read this help article for more information about Final Grade Settings Export Your Gradebook You can export a course gradebook in two formats: CSV CSV for import into other system To export your course gradebook: Click Courses in the header. Click on the course that has the Gradebook you want to export. Click on Gradebook in the course profile menu. Click the three dot icon in the upper right corner of the Gradebook. Select Export.

keywords: PowerSchool, import, student photos, photographs, upload aliases: PowerSchool, PowerSchool Admin, PowerTeacher Pro This guide provides step-by-step instructions on how to import student photos into PowerSchool. It includes detailed instructions on navigating Google Drive, downloading and renaming files, formatting data, and uploading photos into PowerSchool. By following this guide, users can easily import student photos into PowerSchool for efficient management and organization. 1. Navigate to Google Drive. Click on the "Shared Drives" tab, and double-click "PSD Staff & Student Images". If this Drive is not yet shared with you, please ask the Technology Admin Secretary to share it with you. 2. Double-click the Google Drive Folder where the photos that need to uploaded live. For this example, we are using the 2023-2024 school year. 3. Double-click on the school where the photos that need to be uploaded live. For this example, we are using Artondale Elementary. 4. Download both the .zip fie and the associated .txt map file. In most cases, we will only ever download/upload the student versions. You don't have to open the folder or the file to download, you can just click the download button that appears on the right when you hover over the link. 5. Open your "Downloads" Folder 6. "Rename" the map file. Please follow the convention "XXX2023.txt" where XXX is the school abbreviation. In this example, the name of the file should be "AES2023.txt". 7. Open the map file, and copy all of the data to your clipboard. 8. Open up the Map File Formatting file, and paste the the data from the map file into it. 9. Click on "Where the Magic Happens" and press "Run it!" 10. Click on the "PowerSchool" tab, and copy the contents to your clipboard. 11. Open up the map file again, select all, and then paste the contents from the "PowerSchool" tab into it. Save and close it. 12. Open up PowerSchool, and select the school that you are uploading photos to. For this example, we are uploading for Artondale Elementary. 13. Click the "Data and Reporting" link 14. Click on "Data Management" and then "Student and Staff Photos" 15. Click "Import Pictures" 16. Set Group to "Students" and Mapping Type to "Student/Staff Number". Then upload both the mapping file and the .zip folder accordingly. 17. Click "Upload" Made with Scribe

Tracks can be used to narrow down searches. The Powerschool Database Administrator has three tracks set up for elementary and high schools. Middle school students are all currently track A. Forward slash (/) is needed to pull up any inactive pre-registered or transferred-out students Track A = Most students at each school will fall into this track Track= B for Elementary Schools = PK Track= B for High Schools = CTP Track= C for High Schools = Fresh Start Enroll_status=0 is an active student /Enroll_status=-1 is pre-registered student /Enroll_status=2 is transferred out student /Enroll_status=3 is graduated student Graduated students are moved to graduated students school after graduation. Enrtrydate>9/5/2023 will give you active students who enrolled after 9/5/2023 /Entrydate>9/5/2024 will give you active and inactive students who enrolled after 9/5/2023 For more information about PowerSchool searching, view this link: https://ps.powerschool-docs.com/pssis-admin/23.12/about-searching