{"id":112,"date":"2012-09-20T14:57:50","date_gmt":"2012-09-20T14:57:50","guid":{"rendered":"http:\/\/psws.glenbard.org\/index.php\/2012\/09\/20\/understanding-advanced-searches\/"},"modified":"2016-02-05T10:29:04","modified_gmt":"2016-02-05T16:29:04","slug":"understanding-advanced-searches","status":"publish","type":"post","link":"https:\/\/docs.glenbard.org\/index.php\/ps-2\/admin-ps\/powerschool-tips\/understanding-advanced-searches\/","title":{"rendered":"Understanding Advanced Searches"},"content":{"rendered":"

Although searching for a last name like Smith is useful there are many other ways to search in PowerSchool. This article is the starting point for learning about advanced searching. There are also many specific articles regarding searching for students with specific credits, GPAs, courses, etc.<\/p>\n

To perform advanced searching there are three important ideas to understand:<\/p>\n

    \n
  1. PowerSchool Fields<\/strong>: The individual data points in PowerSchool<\/li>\n
  2. Search Operators<\/strong>: The technique used for the search (exact match, partial match, values less than, etc<\/li>\n
  3. Excluded Student Groups<\/strong>: Some groups are excluded from searches by default.<\/li>\n<\/ol>\n

    An advanced search is structured like the following:<\/p>\n

    A PowerSchool Field Name \u00a0\u00a0\u00a0\u00a0\u00a0+ \u00a0\u00a0\u00a0a Search Operator \u00a0\u00a0\u00a0+ \u00a0\u00a0\u00a0your input<\/p>\n

    ||\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ||\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ||<\/p>\n

    grade_level\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 9<\/p>\n

     <\/p>\n

    Each of these three key ideas used for searching in PowerSchool are listed in detail below:<\/p>\n

    PowerSchool Fields: Each point of data captured in PowerSchool is called a field. i.e. A student\u2019s last name, first name, age, grade level, and activity participation are all separate points of data that Glenbard has recorded and are each separate fields in PowerSchool.<\/p>\n

      \n
    1. To find a field name that you do not know click on the View Field List link.\"\"<\/a><\/li>\n
    2. Clicking the View Field List link will bring up a list of each student field in PowerSchool.\"\"<\/a><\/li>\n
    3. Scroll through the list or to find a field quicker use your internet browser\u2019s Find option.\n
        \n
      1. Typically, press Ctrl-F on a PC or Command-F on a Mac. Or go to your browser\u2019s Edit menu and click Find.<\/li>\n
      2. In Firefox, a small find window will pop up at the bottom of your browser.\"\"<\/a><\/li>\n
      3. In the Find search window, type in part of the title of the field that you need to use.\n
          \n
        1. Example: If you know you need to find IEP students but don\u2019t know the name of the PowerSchool field, type IEP.<\/li>\n
        2. \u00a0Example: If you know you need to look-up students by first name but don\u2019t know the name of the field, type first.<\/li>\n<\/ol>\n<\/li>\n
        3. \u00a0Click the Next or Find button depending on your browser.<\/li>\n
        4. \u00a0Your browser will highlight the first place that it finds the word that you typed in. Such as IEP. See figure 2.2.6<\/li>\n
        5. \u00a0Click Next and your browser will find the next place that your text is listed.<\/li>\n
        6. \u00a0Continue clicking Next until you find the field that you need.<\/li>\n
        7. Click on the name of the field that you need to use.<\/li>\n
        8. The field name has now been added to your search bar.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

          Example: Finding for IEP<\/p>\n

            \n
          1. \n
              \n
            1. When typing \u201cIEP\u201d into the Find window, \u201cgrd9_IL_IEP\u201d is the first PowerSchool listed in window.<\/li>\n
            2. Unless you are specifically looking for grade 9 IEPs, move on and click Next.<\/li>\n
            3. Upon clicking Next, \u201cIEP_Date\u201d comes up next in the window.<\/li>\n
            4. Unless you are specifically looking for IEP dates, move on and click Next.<\/li>\n
            5. Upon clicking Next, \u201cIL_IEP\u201d comes up next in the window.<\/li>\n
            6. Stop here. This is the IEP participation that is reported to the Illinois State Board of Education.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

              Important Note: When looking through the field list, there are a few common prefixes to field names that help give away their purpose in PowerSchool:<\/p>\n

                \n
              • Fields starting with \u201cgc_\u201d are Glenbard clubs such as \u201cgc_fashion_club.\u201d<\/li>\n
              • Fields starting with \u201ca_\u201d are Glenbard sports such as \u201ca_bgolf\u201d or Boys Golf.<\/li>\n
              • Fields starting with \u201cIL_\u201d are state reporting fields such as \u201cIL_homeless.\u201d<\/li>\n<\/ul>\n

                Search Operators: A search operator is an instruction given to PowerSchool to tell it how to evaluate a particular point of data or field. i.e. One operator is \u201c<=\u201d. Using a <= sign can allow to search for students grades 10 and below (grade_level <= 10).<\/p>\n

                Search Operators<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
                Operator<\/td>\nMeaning<\/td>\nExample Usage<\/td>\nExample Explained<\/td>\n<\/tr>\n
                =<\/td>\nEquals<\/td>\nFirst_name = John<\/td>\nFinds all students named John<\/td>\n<\/tr>\n
                <<\/td>\nIs less than<\/td>\nGrade_level < 10<\/td>\nFinds all students grade 9 and below<\/td>\n<\/tr>\n
                ><\/td>\nIs greater than<\/td>\nGraduation_year > 2012<\/td>\nFinds all students graduating in 2013 and later<\/td>\n<\/tr>\n
                <=<\/td>\nIs less than or equal to<\/td>\nGrade_level <= 10<\/td>\nFinds all students grade 10 and below<\/td>\n<\/tr>\n
                >=<\/td>\nIs greater than or equal to<\/td>\nGraduation_year >= 2012<\/td>\nFinds all students graduating in 2012 and later<\/td>\n<\/tr>\n
                #<\/td>\nDoes not equal<\/td>\nFirst_name # John<\/td>\nFinds all students named anything other than John<\/td>\n<\/tr>\n
                In<\/td>\nIs present in a list of values<\/td>\nFirst_name in John, Jane, Jim<\/td>\nFinds all students named John, Jane, Jim<\/td>\n<\/tr>\n
                Contains<\/td>\nA field contains a given value<\/td>\nMailing_street contains First<\/td>\nFinds all students living on First Ave, First St, First Blvd, etc.<\/td>\n<\/tr>\n
                !contain<\/td>\nA field does not contain a given value<\/td>\nMailing_street !contain ave<\/td>\nFinds students that do not have \u201cave\u201d anywhere in their street address. \u00a0 This would exclude anyone living on an avenue as well as anyone on Dave Street.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                 <\/p>\n

                Excluded Student Groups: Different settings may exclude students from your search.<\/p>\n

                Inactive Students<\/p>\n

                  \n
                • By default, all searches will only return active students.<\/li>\n
                • If the slash symbol \u201c\/\u201d is added at the beginning of a search, inactive students will also be found by the search.<\/li>\n<\/ul>\n
                    \n
                  • Example:\n
                      \n
                    • Searching for \u201cstudent_number = 10012345\u201d will only return the student with the matching ID, if the student is currently active at Glenbard.<\/li>\n
                    • Searching for \u201c\/student_number = 10012345\u201d will return the student with the matching ID whether the student is currently active at Glenbard or inactive.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

                      Other Schools<\/p>\n

                        \n
                      • Refer to Know How to Switch Between District and Schools and determine if you are in district mode or viewing PowerSchool as one of the individual high schools.<\/li>\n
                      • If you are currently in district mode, your search will return any student.<\/li>\n
                      • If you are currently under a particular high school, your search will only return students from that school.<\/li>\n<\/ul>\n
                          \n
                        • Example:\n
                            \n
                          • Student 10012345 transferred from East to West.<\/li>\n
                          • If an East administrator searches for the student, the student will NOT be found.<\/li>\n
                          • If a West administrator searches for the student, the student WILL be found.<\/li>\n
                          • If a district user searches for the student while using the district setting, the student WILL be found.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/div>","protected":false},"excerpt":{"rendered":"

                            Although searching for a last name like Smith is useful […]<\/p>\n","protected":false},"author":1,"featured_media":109,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[94],"tags":[187,124],"class_list":["post-112","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powerschool-tips","tag-beginners-1","tag-searching"],"acf":[],"_links":{"self":[{"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts\/112","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=112"}],"version-history":[{"count":2,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts\/112\/revisions"}],"predecessor-version":[{"id":1955,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/posts\/112\/revisions\/1955"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/media\/109"}],"wp:attachment":[{"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/media?parent=112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/categories?post=112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.glenbard.org\/index.php\/wp-json\/wp\/v2\/tags?post=112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}