• How do I calculate and reconcile my Attendance Data in PowerSchool for Arizona?

    Introduction This article explains how to calculate non limited ADM in PowerSchool. In Arizona a student’s ADM may be limited, or reduced, if they attend multiple schools in the same year. To learn more about limiting or to check actual limited ADM for students, please see this article: Understanding Limiting…

  • How do I manage CALPADS Course data in PowerSchool?

    Management of Fall 2 data can be broadly categorized into three steps. Prior to Census Day, you should have completed Steps 1 (Fall 2 Data) & 2 (Staff Info) and should validate that the course data is complete and ready for CALPADS upload. The following steps will guide you to…

  • How do I manage CALPADS Staff data in Aeries?

    Complete Staff Data Entry Into Aeries Management of Fall 2 data can be broadly categorized into three steps. By now, you should have a list of all of the staff members that are to be reported through CALPADS.  Staff data can be broadly categorized into three types: Step 1: Staff Ethnicity/Race…

  • How do I Mass Add Student Related data in Aeries?

    Step 1: Locating “Mass Add Student Related data”. From the Home Page > type “MASS” in the Filter Pages field on the left menu bar. Then select Mass Add Student Related Data (Functions). Step 2: Select “Create New”. Step 3: Target Table for Programs From the “Target Table” > click…

  • How do I manage CALPADS Fall 2 Data preparation?

    Management of Fall 2 data can be broadly categorized into three steps: Before you start with the population of this data, it is important that you understand who is supposed to be reported to CALPADS in the first place.  If staff members are not going to be uploaded to CALPADS,…

  • How do I manage CALPADS Staff data in PowerSchool?

    Complete Staff Data Entry Into PowerSchool Management of Fall 2 data can be broadly categorized into three steps. By now, you should have a list of all of the staff members that are to be reported through CALPADS.  Staff data can be broadly categorized into three types: Step a:  Staff…

  • How do I manage CALPADS Student Information data in PowerSchool?

    Student information can be broadly categorized into two types: Once you have selected a student or group of students, you can systematically follow the section below to access the exact student information that you need. Part 1:  General Demographics To navigate to Demographics, from the Home Page > Type the…

  • How do I lookup EL information in CALPADS individually?

    When a new student enters your school, it is likely that your primary sources of information include the students cumulative file and enrollment documents.  But what if you need historical information that is not included in those sources.  In California, we can use the CALPADS system to retrieve this information…

  • How to Enroll New Student Data in PowerSchool for SLDS – Vermont State Reporting

    Purpose This article will guide you through the student data fields collected during Vermont State Reporting submissions. Along with local practices, this may be used as a supplement when entering a new student into PowerSchool. Step 1 of 2: Enroll New Student Navigate to the correct page if you follow…

  • New York State Reporting: Attendance Codes (SFTP)

    This extract contains data related to state-defined attendance codes in your SIS. The following fields are included on this extract: District Code District Office > District (Setup) > District Information Field name: [Pref]NY_BEDS_CODE, [S_NY_SCH_X]DistrictLocationCode Note: Charter and Nonpublic schools enter District Code after select the checkbox with the label “Select…

  • New York State Reporting: Assessment ACC MOD Fact Extract (SFTP)

    The Assessment ACC MOD Fact extracts contains data related to students’ assessment accommodations and modifications. The following fields are included on this extract: District Code District Office > District (Setup) > District Information Field name: [Pref]NY_BEDS_CODE, [S_NY_SCH_X]DistrictLocationCode Note: Charter and Nonpublic schools enter District Code after select the checkbox with…

  • How Do I Lock Reporting Terms In PowerSchool?

    Purpose In our experience, the most common reason PowerSchool Administrators may want to lock reporting terms is to maintain the integrity of To-Be-Stored grades.  Locking the Reporting Terms ensures that grades are up-to-date, stable and complete in PowerSchool leading up to the moment when grades are permanently stored as historical…

  • PowerSchool Data Access Tags (DATs) | Report and Export Codes

    Below is a list of Data Access Tags that have been used by our team in PowerSchool servers and have been known to work with some version of PowerSchool(which is always changing!). These codes can be used in certain reports and exports such as: If you need additional help, you…

  • How do I run Parent and Student Portal Access Statistics in PowerSchool?

    If you have setup the Parent and Student Portals for your PowerSchool site, you may want to routinely check the statistics on the usage of those portals throughout the year. The following steps outline a quick procedure to run the Parental Access Statistics in PowerSchool. Step 1: Navigate to System Reports…

  • How can I determine perfect attendance in PowerSchool?

    If you want a quick way to determine which students have perfect attendance, there are two ways to use the Quick Export feature to do so, but it all depends on how you determine what perfect attendance is.  In this article we take two approaches: Perfect Attendance Method #1:  A…

  • How do I import test scores into PowerSchool?

    In this page, you will learn how to import test scores into PowerSchool.  For the purposes of this walkthrough, an ACT upload is used but the same would apply to any test. Step 1:  Populate the test import template Start by downloading the Import Test Scores Template here:  The header…

  • End of year (EOY): Data Backup and Storage in PowerSchool

     End of Year (EOY): Data Backup and Storage When a server is rolled over at the end of the EOY process, data from the current year is archived and the server is cleared for a new academic year. Once the EOY roll over is complete, data and reports from historical…

  • How do I lookup Direct Certification information in CALPADS?

    When a new student enters your school and is uploaded to CALPADS, they are automatically looked up in the California Department of Social Services (CDSS) data to see if a student qualifies for free meals under the NSLP guidelines.  This process is typically refreshed once a month.  The results are…

  • How do I print the Daily Attendance Summary Report in Infinite Campus?

    In order to reconcile the signed weekly teacher rosters to the monthly reports we use a helpful report called the Daily Attendance Summary Report.  Ideally, if this is printed at the same time as the weekly teacher rosters and the monthly attendance, the risk of discrepancies between these reports is…

  • How do I check if teachers have taken attendance in Infinite Campus?

    Making sure that teachers take attendance in a timely manner is an important part in maintaining the integrity and completeness of attendance data. In Infinite Campus, there is a simple screen that will help admins stay on top of this process in an easy to view real-time report. To view…

  • How do I serve a meal in PowerLunch? (Quicksale)

    In this article, we will review how to serve a meal using the Quicksale function in PowerLunch.  We use the Quicksale because it requires the fewest number of keystrokes to complete. Serving a meal Step 1:  Login to PowerSchool and navigate to the PowerLunch page. Step 2:  Serve the meal that…

  • How do I setup the Daily Bulletin in PowerSchool?

    The Daily Bulletin is a great tool for schools to use to communicate information across the school or district.  If you wish to setup a Daily Bulletin for the school, make sure to setup the Daily Bulletin at the school level.  If you want all schools in the server to…

  • How do I manage Immunizations in PowerSchool?

    Entering dosage information Immunizations are managed under the student record found under the “Health” section of Information. It is here that you can submit dosage dates. Want to make changes to the immunization information? If you wish to make changes to the dosage information, changes can be made by navigating…

  • How do I exit a No-Show student in Aeries that was expected to return?

    This article will explain how to properly exit a student in Aeries.NET that is a no show. Before we start changing things, we need to be very clear about the type of student it was that did not show up. Returning student no-show: This student attended the school in previous…

  • How do I check that attendance was taken for all periods in PowerSchool?

    In this article, we will review a quick and easy way to check to see if attendance was completely taken for a specific school day.  This will help attendance clerks everywhere to work closely with teachers to take accurate and timely attendance by being responsive and engaging when they know…

  • How do I create the NWEA Roster File Template from PowerSchool?

    If your NWEA testing period is coming up and you require an up-to-date import file from your PowerSchool data, this is the article for you!  We will walk through the step by step process of creating the Combined Import.csv file.  This walk through assumes that you are exporting information for…

  • How do I create a class roster in PowerSchool?

    Class Rosters are a useful tool that can be used in many different ways.  Some of the ways that we see schools use them are: Designing and Running Class Rosters Class rosters can be found by navigating from the PowerSchool Home Page > Data and Reporting > Reports > System…

  • How do I print a simple student schedule in PowerSchool?

    Whether it is before the start of the school year or not, it is incredibly helpful to have the ability to print a student schedule in .pdf form for giving to students, parents, teachers, or even for the scheduling staff to ensure that all of your students are scheduled. Creating…

  • How do I store grades at the end of the term in PowerSchool? (Basic)

    The term is over and you are ready to store grades in PowerSchool.  That probably means a few things: 1) If you are storing grades, then you are using PowerTeacher Gradebook or PowerTeacher Pro where each course section is assigned a grade for the reporting term.  This is in contrast…

  • How do I view Ethnicity & Race counts in PowerSchool using Enrollment Summary?

    In this article, we will review the Enrollment Summary feature of PowerSchool and how to determine the number of students that are in your school separated by Ethnicity and Race Groups. To start, from the PowerSchool home screen select School Enrollment > Enrollment Summary. You will then be asked to…

  • How do I enroll a student into a course section in PowerSchool?

    When you are ready to enroll a student into a course section in PowerSchool, you can do so using the following steps provided that: Step 1:  Select your student > Courses and Programs > Modify Course Schedule Step 2:  Enter the course section enrollment attributes by: a) Enter the Effective…

  • How do I download a list of lunch transactions from PowerLunch in PowerSchool?

    If your school uses PowerLunch to track the distribution of Breakfast and Lunch for your students, there is a way to download the transaction list for further analysis in Excel that goes beyond the built-in PowerLunch reports.  Doing this requires the extraction of raw data directly from a PowerSchool table….

  • How do I run a summary report of our ADA for a specific month in PowerSchool?

    The 20 day ADA attendance reports that feed into reports that go to the CDE as First Principal Apportionment (P-1 ADA), Second Principal Apportionment (P2 ADA), and Annual Apportionment (Annual ADA) are used as key metrics for a significant portions of school funding. ADA = The total days of student…

  • How do I print current report cards for a specific teacher in PowerSchool?

    In order to print report cards for a specific teacher, you will follow the process just as you would for printing any type of report in PowerSchool: Step 1:  From start page > People > Staff > Teacher Schedules. Step 2:  You should see a list of your teachers on…

  • How do I export Free/Reduced Lunch Status information from PowerSchool?

    To extract a list of Free and Reduced Meal Program (FRMP) / National School Lunch Program (NSLP) status’ into a tab delimited text file, we will follow a simple two step process: Step 1: Select the students that you wish to export Selecting students is easy. You can make this…

  • How do I export English Learner information from PowerSchool?

    To extract a list of student English Learner information into a tab delimited text file, we will follow a simple two step process: Step 1: Select the students that you wish to export Selecting students is easy. You can make this selection from the start page using queries or click…

  • How do I manage English Learner information for CALPADS in PowerSchool?

    Language Coordinators may use a variety of different systems to be able to determine the English Learner status of students.  Even though PowerSchool may not be your primary student management system for English Learners, it does require the most up to date information in it as PowerSchool is the master…

  • How do I add a new teacher or staff member to PowerSchool? (Quick Version)

    This article will walk you through how to create a new teacher/staff member in PowerSchool with the fewest amount of steps.  This article is not meant to be an detailed walkthrough of every teacher/staff field, but rather to get the reader up and running fast! Before adding a new teacher/staff…

  • How do I make a Student Query or Selection in PowerSchool? (Intermediate)

    Now that you can click through to any student you like, now we can take a more direct and powerful approach by using the search bar of the home screen.  In this article we will handle some of the most basic queries.  If you are looking for more advanced queries,…

  • How do I make a Student Query or Selection in PowerSchool? (Beginner)

    One of the fundamental functions that any PowerSchool User must learn is how to make a select individual as well as groups of students in PowerSchool to perform functions or run reports.  Everything starts with selecting a student and as any PowerSchool session starts with the home page, that is…

  • How do I export Student Data in PowerSchool using Quick Export?

    To extract a list of student information into a tab delimited text file, we will follow a simple two step process: Step 1: Select the students that you wish to export Selecting students is easy. You can make this selection from the start page using queries or click on the…

  • How do I export Test Scores from PowerSchool?

    To extract a list of student test scores into a tab delimited text file, we will follow a simple two step process: Step 1: Select the students that you wish to export Selecting students is easy. You can make this selection from the start page using queries or click on…

  • How do I export GPA from PowerSchool for a specific term?

    To extract a list of student GPA’s into a tab delimited text file, we will follow a simple two step process: Step 1:  Select the students that you wish to export You can make a selection of students from the Start Page using queries or click on the groups that…