Using codes powerschool student information system

Pdf File 417.57 KByte, 28 Pages

Using Codes PowerSchool Student Information System Advanced Training

Document Properties

Using Codes

Copyright

? 2002 Apple Computer, Inc. All rights reserved. This document is the property of Apple Computer, Inc. and is for reference only. It is not to be reproduced or distributed in any way without the express written consent of Apple Computer, Inc. Other brands and names are the property of their

respective owners.

Owner

Technical Communication and Documentation

Last Updated

7/25/2002

Version

3.0

Please send comments, suggestions, or requests for this user guide to manuals@. Your feedback is appreciated.

Introduction

? 2002 Apple Computer, Inc. All rights reserved.

2

Using Codes

Contents

Introduction .............................................................................................................................. 4 Use Search Codes.................................................................................................................... 4 Use Codes in Reports and on Custom Pages ........................................................................ 8

Master List of Codes............................................................................................................. 8 Use Static Codes ............................................................................................................ 8 Use Derived Codes....................................................................................................... 13

Code Operators.................................................................................................................. 19 Use Character Code Operators .................................................................................... 19 Use Date Format Code Operators ................................................................................ 20 Use Decimal Code Operators ....................................................................................... 21 Use Phone Number Code Operators ............................................................................ 21 Use Miscellaneous Extracting Code Operators............................................................. 22 Use If/Then Code Operators......................................................................................... 22

Class Roster Codes............................................................................................................ 22 GPA Codes ........................................................................................................................ 25 Cumulative GPA Codes...................................................................................................... 26

Use GPA Codes for Specific Years and Terms............................................................. 26 Use Current GPA Codes............................................................................................... 27 Use Weighted GPAs by Credit Type Codes.................................................................. 28

Introduction

? 2002 Apple Computer, Inc. All rights reserved.

3

Using Codes

Introduction

PowerSchool Student Information System (SIS) codes are short programming expressions you can include in student searches, reports, and on custom pages you create.

Codes can contain PowerSchool SIS fields and operators. For example, if you insert the PowerSchool SIS code ^(lastfirst;uppercase) in the body of a report, the system prints each student's last name and first name in all capital letters (such as SMITH, JOHN), regardless of how the name actually appears in the lastfirst field in PowerSchool SIS.

There are two main types of PowerSchool SIS codes: static and derived. Static codes search for or display information you store in your PowerSchool SIS database, such as your school's name. Derived codes display live data, such as the current time, on your request.

The following sections describe the codes you can use to search for students and the codes you can insert in reports, export files, and on custom pages.

Note: The PowerSchool Knowledgebase also contains all of the codes in this document. To access the knowledgebase, go to . Enter your username and password and click Knowledgebase. In the Search field, enter Codes.

Use Search Codes

In your daily use of PowerSchool SIS, you might need to select a group of students who have something in common. For example, assume you want a list of all students who are currently receiving a failing grade in any class. You can enter a search code in the Search Students field

on the PowerSchool SIS Home page to search for students currently receiving a failing grade.

Before you use search codes in the Search Students field, you should be familiar with the comparators you include in each search:

Comparator Means

For example

=

Equals

To find students whose first name is Jennifer, enter first_name = Jennifer.

<

Is less than

To find students who are in a grade level less than 3, enter grade_level < 3.

>

Is greater than

To find students who are in a grade level greater than 9, enter grade_level > 9.

Introduction

? 2002 Apple Computer, Inc. All rights reserved.

4

Using Codes

Comparator <= >= #

in

contains !contain @

Means Is less than or equal to

Is greater than or equal to

Does not equal

The value is present in the field.

The value is contained in the field. The value is not contained in the field. Wildcard

For example

To find students whose grade level is less than or equal to 4, enter grade_level <= 4.

To find students whose grade level is greater than or equal to 9, enter grade_level >= 9.

To find students who belong to a specific activity, such as the basketball team, enter Basketball#.

The system literally searches for any students whose basketball field does not equal blank.

To find students in the ninth or tenth grade, enter grade_level in 9,10.

Note: If you want to search for more than one value in a field, separate each value with a comma (,).

To find students who live on Main Street, enter mailing_street contains Main Street.

To find all students who do not live on Main Street, enter mailing_street !contain Main Street.

To find all students whose first name starts with Jen (Jenn, Jennifer, Jenny, Jennie) enter first_name = Jen@.

To use a search code to search for students: 1. On the Home page, locate the Search Students field:

Use Search Codes

? 2002 Apple Computer, Inc. All rights reserved.

5

Using Codes

2. To search for students, enter any of the codes listed in the following table in the Search Students field:

Result

Code

Description/Function

Birthdays (today)

*birthday = today

Finds all students whose birthday is today, matching only month and day.

Birthdays (date) *birthday = 5/1

Finds all students whose birthday is May 1.

Birthdays (month)

*birthday >= 5/1/99; *birthday <= 5/31/99

Finds all students whose birthday is in the month of May.

Active Students *as_of = 9/15/98

Finds all students who were active on that date. A student is active if he or she enrolled in your school on or before the date you enter, or exited on or after the date you enter.

Students not enrolled in a period

*not_enrolled_in_period =1

Finds students who are not currently enrolled in a Period 1 course.

Students in a course

*enrolled_in = 9500

Finds students who enrolled in Course 9500 in the current term.

Use Search Codes

? 2002 Apple Computer, Inc. All rights reserved.

6