Objects on an Object Report
You can create many types of objects to include on an object report. You can create multiple objects on each object report and create the objects in any order. However, it is ideal for the objects to be listed on the Object Report page in order from top to bottom and from left to right. For example, give a logo placed in the upper-left corner of the report the label of "A Logo," then give a horizontal line placed in the middle of the page the label "B line." In this example, the picture object for the logo would be listed first, followed by the line object.
To enhance the appearance of the object report, you can format many objects. Prior to adding objects to an object report, you must first create set up the object report parameters. For more information about creating a new object report or editing an existing object report, refer to Object Reports.
When you create an object, you define where you want it to appear on a page and on which page of the report you want it to appear. To do this, define the coordinates of each object you create in inches on an X (horizontal) and Y (vertical) axis. You can use a ruler and a piece of paper to determine the coordinates of each object you create.
Use the Print Reports option on the Group Functions page to print a custom report for the selected students. For information about creating reports, refer to Custom Reports. For information about printing an object report or any type of report, refer to Run, Print, and Save Reports.
Text Objects
Text objects are boxes that contain text. Specify if you want the box to be framed or unframed. Within a text object, you can include two types of text:
Constant text, such as a title (for example, Official Transcript). The same title appears for all students.
Variable text, such as PowerSchool field names or codes (for example, mailing_address). Different information appears for different students.
For example, you can include the constant text Name: just before variable text first_name and last_name fields.
Create Text Objects
Navigate to the Object Reports page.
Click the name of the object report to which you want to add this object.
Click Text.
Use the following table to enter information in the fields:
Field | Description |
|---|---|
Object Label | Enter a name for the object. |
Text | Enter an unlimited amount of text to include in the text object. In addition to standard text, you can include HTML tags, PowerSchool fields, and PowerSchool data codes. Text does not automatically wrap to the next line. To insert a break, use the HTML <p> tag. To insert a PowerSchool field into this field:
For example, to include each student's name on the report and center the information, create the following text object: <center>^(first_name) ^(last_name)</center> To include a tab, indicate the tab type and the number of inches from the left side of the page. Tab types include:
Create tab leaders by using characters such as the underscore (_) for a solid line or a period (.) for a dotted line. Include tab leader characters at the end of the tab tag. For example, <tabd 3.5 _> aligns a list of monetary amounts by their decimal places with a solid tab leader at 3.5 inches from the left side of the page. To include a data code, use the following format: ^(*data code) For example, to include each student's cumulative GPA, enter: ^(*gpa) If you are adding database extension fields, enter the extension field name using the format [extension name].[fieldname]. After you save this object, the system changes the carets (^) in front of the field names and data codes to tildes (~). |
Position | Enter the number of inches from the left margin that the text object should appear horizontally (X) and vertically (Y). For example, enter 4.25 in the X field and 1 in the Y field to place the object horizontally centered on an 8.5-inch page and vertically one inch from the top of the page. |
Max Width | Enter the maximum number of inches wide you want this text object to print (optional). To allow the text object to print the entire width of the page, enter 0. If you do not define a maximum width, the system defaults to the page width. |
Max Height | Enter the maximum number of inches high you want this text object to print. To allow the text object to print the entire length of the page, enter 0. |
Font | Choose the font of the text. The system setup determines the default font. Then, select the style of the font. |
Style | Select any combination of these checkboxes to determine any additional styles for the text in the Text field:
|
Size | Enter the font size of the text in points. One point equals 1/72 of an inch. |
Line Height | Enter the height of the line in points. One point equals 1/72 of an inch. The line height determines the amount of space for each line of text in the object. For example, if you increase the line height, you create more space or padding between each line of text. |
Color | Enter the name of the color in which you want all text in the text object to print. To view a list of color names, click Color. A color palette appears. Copy the name of the color you want and paste it into the Color field. If you want the text to be black, leave this field blank. |
Tint | To adjust the tint of the color of the text, enter a percentage. Otherwise, leave this field blank. |
Rotation | Enter the number of degrees to rotate the text object on the page of the report. |
Frame Width | To have the report surround the text object with a line frame, enter the number of points wide you want the frame to print. One point equals 1/72 of an inch. If you do not want the text object to print with a frame, leave this field blank. |
Frame Padding | If you entered a frame width, enter the amount of space in points between the text object and the frame. One point equals 1/72 of an inch. For example, to have the text object print in the center of the frame, you need to adjust the padding. |
Frame Radius | If you entered a frame width, enter a number of inches to print the frame with rounded corners. The higher the number, the more rounded the frame. |
Special | Select the Move to next record after printing this text checkbox if this text object is the last object the report prints before printing a new record. Deselect the checkbox if this is the last object on the page (the last record to be printed), such as a footer. If the text object is a footer or any other object that should be printed last, deselect the checkbox. Also, the order of objects is determined by the object layer (lower layers are listed first) and alphabetically by object name. By either placing the footer object at a lower layer or altering its name so that it falls before other objects that may repeat (such as a list of students), the report should print correctly. |
Page | Do one of the following:
As of PowerSchool 11.0.4.0, only numeric values may be entered in the Page field. If an alphanumeric value was entered before PowerSchool 11.0.4.0, that value will be honored, and the text object will continue to appear on the first page of the report. |
Layer | If you want this object to appear behind or in front of another object, choose the layer placement. Choose the highest number to place the object in front of all other layers. |
Click Submit to save the text object. If the text object does not print correctly, edit it by clicking the object name on the Object Report page and repeating the procedure.
For example, assume a student does not have a Social Security number. By default, the text box prints one blank space, then prints the birth date text directly next to it (SS# BIRTH DATE: 9/2/1984). If this causes alignment concerns in your text box, you can use the <TABTO (inches)> HTML tag in your text object. Within the tag, before the text you want to print in a specific space, enter the number of inches from the left margin that you want to print the text. For example, if a student does not have a Social Security number, but you still want the birth date to print 2.25 inches from the left margin, you can enter: SS# ^(ssn)<TABTO 2.25>^BIRTH DATE: ^(dob).
Line Objects
Create line objects to include horizontal and vertical lines on your object report. Lines can separate information and make it easier to read. For each line you create, you define the location, thickness, and number of times it appears.
Define line objects as if they were printing on a graph. For each line, you define the X and Y coordinates in inches. The X coordinate is the horizontal point from the left margin at which you want the line to print. The Y coordinate is the vertical point from the top margin at which you want the line to print.
If the line is horizontal, the numbers you enter for the starting and ending Y points are the same. If the line is vertical, the numbers you enter for the starting and ending X points are the same.
Create Line Objects
Navigate to the Object Reports page.
Click the name of the object report to which you want to add this object.
Click Line.
Use the following table to enter information in the fields:
Field | Description |
|---|---|
Object Label | Enter a name for the line object. |
Starting point (X,Y) | Enter the number of inches on the page to indicate the point at which you want the report to start the line horizontally (X) and vertically (Y). |
Ending point (X,Y) | Enter the number of inches on the page to indicate the point at which you want the report to end the line horizontally (X) and vertically (Y). |
Width | Enter the width of the line in pixels. A pixel is a single point in a graphic image. |
Color | Enter the name of the color in which you want the line to print. To view a list of color names, click Color. Copy the name of the color you want and paste it into the Color field. If you want the line to be black, leave this field blank. |
Tint | To tint the color of the line, enter a percentage. The higher the number, the darker the tint. Otherwise, leave this field blank. |
Repeat | If you want the line to print more than one time, enter information in the following fields:
Otherwise, leave these fields blank. |
Line Style | Select one of the options to indicate the style of the line. |
Page | Do one of the following:
As of PowerSchool 11.0.4.0, only numeric values may be entered in the Page field. If an alphanumeric value was entered prior to PowerSchool 11.0.4.0, that value will be honored and the line object will continue to appear on the first page of the report. |
Layer | If you want this object to appear behind or in front of another object, choose the layer placement. Choose the highest number to place the object in front of all other layers. |
Click Submit.
Box Objects
Create box objects to include in your object report. These objects frame or shade information on the report.
Create Box Objects
Navigate to the Object Reports page.
Click the name of the object report to which you want to add this object.
Click Box.
Use the following table to enter information in the fields:
Field | Description |
|---|---|
Object Label | Enter a name for the box object. |
Coordinates | To determine where the box prints on the page, enter the number of inches from the start, top, end, and bottom margins you want the box to print. The start side and end side are determined by the direction of the language used in the report. |
Line width (frame) | To print a frame around the box, define the width of the line and the percentage the line is shaded in points. One point equals 1/72 of an inch. |
Line Color | Enter the name of the color in which you want the line that prints around the box to print. To view a list of color names, click Color. Copy the name of the color you want and paste it into the Color field. If you want the line to be black, leave this field blank. |
Line Tint | To tint the color of the line, enter a percentage. Otherwise, leave this field blank. |
Corner Radius | Enter a number to indicate how round you want the corners of the box to be in inches. The greater the number, the rounder the corners. |
Fill Color | To shade or color inside the box, enter the name of the color. To view a list of color names, click Color. Copy the name of the color you want and paste it into the Color field. To view a list of color names, click the field name Color. |
Fill Tint | To tint the fill color of the box, enter a percentage. Otherwise, leave this field blank. |
Repeat | If you want the box to print repeatedly, define information in the following fields:
|
Rotation | To rotate the box on the report, enter the number of degrees you want it to rotate. |
Line Style | Select one of the options to indicate the style of the line that surrounds the box object. |
Page | Do one of the following:
As of PowerSchool 11.0.4.0, only numeric values may be entered in the Page field. If an alphanumeric value was entered before PowerSchool 11.0.4.0, that value will be honored, and the box object will continue to appear on the first page of the report. |
Layer | If you want this object to appear behind or in front of another object, choose the layer placement. Choose the highest number to place the object in front of all other layers. |
Click Submit.
Circle Objects
Create circle objects to include in your object report. These objects can encircle information or images on the report.
Create Circle Objects
Navigate to the Object Reports page.
Click the name of the object report to which you want to add this object.
Click Circle.
Use the following table to enter information in the fields:
Field | Description |
|---|---|
Object Label | Enter a name for the circle object. |
Center Point | Enter the number of inches from the left margin you want the center point of the circle to print horizontally (X) and vertically (Y). |
Radius | Enter the circle's radius, or the distance from the center of the circle to its edge. |
Line Width | To print a frame around the circle, define the width of the line. |
Line Color | Enter the name of the color in which you want the line around the circle to print. To view a list of color names, click Color. If you want the line to be black, leave this field blank. |
Line Tint | To tint the line, enter a percentage. Otherwise, leave this field blank. |
Fill Color | To shade or color inside the circle, enter the name of the color. To view a list of color names, click Color. |
Fill Tint | To tint the fill color of the circle, enter a percentage. Otherwise, leave this field blank. |
Starburst Points | To create a starburst circle, enter the number of points on the star. For example, you might create a starburst as a "seal" for a perfect attendance certificate. |
Starburst Radius | If you entered starburst points, enter the radius of the starburst in inches. |
Repeat | If you want the circle to print repeatedly, define information in the following fields:
|
Rotation | To rotate the circle on the report, enter the number of degrees you want it to rotate. |
Line Style | Select one of the options to indicate the style of the line that surrounds the circle object. |
Page | Do one of the following:
As of PowerSchool 11.0.4.0, only numeric values may be entered in the Page field. If an alphanumeric value was entered before PowerSchool 11.0.4.0, that value will be honored, and the circle object will continue to appear on the first page of the report. |
Layer | If you want this object to appear behind or in front of another object, choose the layer placement. |
Click Submit to save the circle object.
Transcript Objects
Create transcript objects to include a list of students historical grades and the courses in which students received the grades on your object report. By default, within a transcript object, the system lists historical grade information in chronological order and displays the most recent first.
The option to create Legacy Transcript List objects is no longer available. However, existing legacy transcript list objects may be used for object reports. Use the new Transcript object for object reports going forward. To create new transcript objects, use Transcript, which is also available on the Object Reports page.
If a course appears but is not desired on a report card or transcript-based object report, change the course preferences to Exclude on Report Cards/Transcripts. For more information, refer to New Courses.
Add a Transcript Object
Navigate to the Object Reports page.
Click the name of the object report to which you want to add a transcript object.
Under New Object, click Transcript.
Use the following table to enter information in the fields:
Field | Description |
|---|---|
Define the box that contains the transcript course listing | Enter the coordinates of the box in which the transcript information prints. Use inches as the unit of measurement. Determine how many inches from the top left of the page you want the transcript object to print. Indicate the start, top, end, and bottom coordinates of the transcript object. The start side and end side are determined by the direction of the language used in the report. |
If listing overflows this object, start a new column with these margins | If the listing requires more room on the report, enter the coordinates of the box in which the overflow transcript information prints. Use inches as the unit of measurement. Determine how many inches from the top left of the page you want the overflow transcript object to print. Indicate the start, top, end, and bottom coordinates of the transcript object. The start side and end side are determined by the direction of the language used in the report. |
Term/school name font | Choose the font in which the term and school information prints. |
Size, line height, style | In the first field, enter the size of the font. In the second field, enter the height of each line in the object in points. One point equals 1/72 of an inch. The height determines the space between each line in the transcript. Select any combination of these checkboxes to determine any additional styles for the text:
|
Term/school displays | Choose whether to print the year, the school name, or both. |
Course listing font | Choose the font in which the transcript information prints. |
Size, line height, style | In the first field, enter the size of the font. In the second field, enter the height of each line in the object. One point equals 1/72 of an inch. The height determines the space between each line in the transcript. Select any combination of these checkboxes to determine any additional styles for the text:
|
Cell padding | Enter a number, in points, to determine the distance between the horizontal and vertical borders of the cell and its contents. One point equals 1/72 of an inch. |
Columns | Specify the following for each column: In the Term field, enter the store codes (terms) you want to include in the transcript. The report prints historical grade information for only the term columns you define, such as S1 and S2. From the Field menu, select one of the following fields to include in the column:
In the Other Field/Text/Format, enter any additional field or text you want to print next to each course. If you enter a PowerSchool field name, use the following format: ^(field name). For example, to include the possible credit a student could earn in each course, you can include the potential credit field. In the Width field, enter the width, in inches, of each term column. From the Align menu, select whether to align the data to the left, center, or right of the column. |
Include only historical grades from these grade levels | To print historical grades for only certain grade levels in the transcript, enter the range of grade levels. Otherwise, leave these fields blank. |
Restrict to this credit type | To print only courses with a specific credit type in this transcript object, enter the credit type. By default, within a transcript, the system sorts course information chronologically, displaying the most recent courses first. If you would rather sort the transcript by courses with the same credit type (courses within the same subject, such as English, Mathematics, and Science), enter the credit type here. Then, you can create a transcript object for each credit type. Otherwise, leave this field blank. When using this option to filter grades by credit type, the Transcript Object will only include historical grades that meet one of the following criteria:
|
Exclude blank grades? | Select the checkbox if you do not want to display courses for which the student did not receive a grade. For example, if your school schedules lunch as a course on student schedules, select the checkbox to not print lunch on student transcripts. |
Include current grades? | Select the checkbox to include grades for the current term in the transcript. Otherwise, deselect the checkbox. |
Current school only? | Select the checkbox to include grades for only the current school in the transcript. Otherwise, deselect the checkbox. |
Override "Exclude from Transcripts" Historical Grade setting? | If the Exclude from Transcripts? setting on the Edit Stored Grades page is set to Exclude, you can use this checkbox to override that setting. Select the checkbox to include stored grades for the current term in the transcript. Otherwise, deselect the checkbox. |
Sort grades by | Determine the sort order of the grades in the transcript:
|
Page | Do one of the following:
As of PowerSchool 11.0.4.0, only numeric values may be entered in the Page field. If an alphanumeric value was entered before PowerSchool 11.0.4.0, that value will be honored, and the transcript object will continue to appear on the first page of the report. |
Layer | If you want this object to appear behind or in front of another object, choose the layer placement. Choose the highest number to place the object in front of all other layers. |
Click Submit.
Edit a Transcript Object
Navigate to the Object Reports page.
Click the name of the object report for which you want to edit a transcript object.
In the Object Type column, click Transcript of the transcript object you want to edit.
Edit information as needed.
Click Submit.
Delete a Transcript Object
Navigate to the Object Reports page.
Click the name of the object report for which you want to delete a transcript object.
In the Object Type column, click Transcript of the transcript object you want to delete.
Click Delete.
Click Confirm Delete.
Fee List Objects
Include fee list objects on object reports. For example, include a fee list object to display course fee information per student.
Fee search codes are designed for searches only. For more information, refer to Search for Students by Fees or Transactions.
Use Fee List Objects
Navigate to the Object Reports page.
Click the name of the object report to which you want to add this object.
Click Fee List.
Enter the name of the fee list object in the Object Label field.
Use the following table to enter List Settings information:
Field | Description |
|---|---|
Only these fee categories | Select the fee categories by which you want to limit your report parameters. Only those fee categories for your school appear. |
Only these departments | Select the departments by which you want to limit your report parameters. Only those departments for your school appear. |
Only fees assessed for courses in these groups | Select the groups by which you want to limit your report parameters. Only those groups for your school appear. |
Only fees assessed during | Choose the date range by which you want to limit your query:
If you select the Date Range, enter the beginning and ending dates in the fields using the format mm/dd/yyyy or mm-dd-yyyy. If you do not use this format, an alert appears. If you submit the date with an incorrect format, the date field is submitted as a blank entry. |
Only fees whose current balance is | Select the type of balance by which you want to limit your report parameters. Choose one of the following:
|
Only transactions conducted during | Choose the date range by which you want to limit your query:
If you select the Date Range or Specify a Run Time, enter the beginning and ending dates in the fields using the format mm/dd/yyyy or mm-dd-yyyy. If you do not use this format, an alert appears. If you submit the date with an incorrect format, the date field is submitted as a blank entry. |
Only transactions paid via | Select the payment methods by which you want to limit your report parameters. Only those payment methods for your school appear. |
Only transactions which are | Select the type of transaction by which you want to limit your report parameters. Choose one of the following:
|
Use the following table to enter Table Settings information:
Field | Description |
|---|---|
Column title font | Choose the style of font you want the column title to appear in. The system setup determines the default font. If selecting a font other than the default, you may also select the formatting you want to use. For example, choose Bold to bold the column title font. |
Size, line height, size | Enter the column title font size and line height in points. One point equals 1/72 of an inch. Select any combination of these checkboxes to determine any additional styles for the text:
|
Column Title Background Color, Tint | Enter the name of the color in which you want the background of the column title to appear. To view a list of color names, click Color. Copy the name of the color you want and paste it into the Color field. Otherwise, leave this field blank. To tint the color, enter a percentage. Otherwise, leave this field blank. |
Print column titles on | Choose which pages you want column titles to appear:
|
Print subtotal row on | Choose whether or not you want the subtotal row to appear:
|
Subtotal row label | If you selected to print a subtotal row on the last page of line items, enter the heading you want to appear. Then, choose the row in which you want the heading to appear. |
Print grand total row on | Choose whether or not you want the grand total row to appear:
|
Grand total row label | If you selected to print a grand total row on the last page of this fee list, enter the heading you want to appear. Then, choose the column in which you want the heading to appear. |
Coordinates | To determine where the table prints on the page, enter the number of inches from the start, top, end, and bottom margins you want the table to print. The start side and end side are determined by the direction of the language used in the report. |
Rule width | Enter the thickness in points of the vertical and horizontal lines on the report, as well as the outline of the entire report. One point equals 1/72 of an inch. |
Cell padding | Enter the width of each cell and the amount of space from all sides of the cells to the text in points. One point equals 1/72 of an inch. |
Use the following table to enter Line Item Settings information:
Field | Description |
|---|---|
Font | Choose the style of font you want the column title to appear in. The system setup determines the default font. If selecting a font other than the default, you may also select the formatting you want to use. For example, choose Bold to bold the column title font. |
Size, line height, style | Enter the column title font size and line height in points. One point equals 1/72 of an inch. Select any combination of these checkboxes to determine any additional styles for the text:
|
Even row background color, tint | Enter the name of the color in which you want the backgrounds of the even rows to appear. To view a list of color names, click Color. A color palette appears. Copy the name of the color you want and paste it into the Color field. Otherwise, leave this field blank. To tint the color, enter a percentage. Otherwise, leave this field blank. |
Odd row background color, tint | Enter the name of the color in which you want the backgrounds of the odd rows to appear. To view a list of color names, click Color. A color palette appears. Copy the name of the color you want and paste it into the Color field. Otherwise, leave this field blank. To tint the color, enter a percentage. Otherwise, leave this field blank. |
Currency format | Choose the format by which you want currency to appear. |
Group line items by | Choose the way in which you want line items to be grouped:
|
Use the following table to enter information for each column you want to include:
Field | Description |
|---|---|
Width | Enter the width of the column in inches. |
Title | Enter the text you want to appear as the heading for the column. |
Title alignment | Choose the column title justification:
|
Data Source | Choose the type of data you want to include in this column:
If you selected a data source of Static Text or Field Value, enter the static text or field value you want to display in the next field. |
Specific fee type | Choose the fee type. For more information about fee types, refer to Fee Types. |
Data alignment | Choose the data justification:
|
Include in | Select one of the checkboxes:
|
Use the following table to enter Page Item Settings information:
Field | Description |
|---|---|
Split line items to multiple pages | Select one of the following checkboxes to group information by page based on your selection:
|
Page | Do one of the following:
As of PowerSchool 11.0.4.0, only numeric values may be entered in the Page field. If an alphanumeric value was entered before PowerSchool 11.0.4.0, that value will be honored, and the fee list object will continue to appear on the first page of the report. |
Layer | If you want this object to appear behind or in front of another object, choose the layer placement. Choose the highest number to place the object in front of all other layers. |
Click Submit.
Picture Objects
Use picture objects to include in your object report. For example, include on transcripts a picture of your school's logo. Before creating a picture object, you must add the picture to your PowerSchool system.
Use Picture Objects
Navigate to the Object Reports page.
Click the name of the object report to which you want to add this object.
Click Picture.
Use the following table to enter information in the fields:
Field | Description |
|---|---|
Object Label | Enter a name for the picture object. |
Picture | Choose an available picture. To print the appropriate student or teacher photos, choose Student Photo or Teacher Photo. If a student or teacher record does not include an uploaded photo, nothing will appear on the report where this object is positioned. |
Coordinates | Enter the number of inches you want the picture to print from the start, top, end, and bottom margins. The start side and end side are determined by the direction of the language used in the report. |
Scaling Option | To shrink or stretch the picture to fit within the specified coordinates, choose a scale. Scaling can distort the display of the pictures. |
Rotation | To rotate the picture on the report, enter the number of degrees you want to rotate it. |
Repeat | If you want the picture to print repeatedly, define information in the following fields:
|
Page | Do one of the following:
As of PowerSchool 11.0.4.0, only numeric values may be entered in the Page field. If an alphanumeric value was entered before PowerSchool 11.0.4.0, that value will be honored, and the picture object will continue to appear on the first page of the report. |
Layer | If you want this object to appear behind or in front of another object, choose the layer placement. Choose the highest number to place the object in front of all other layers. |
Click Submit.
QR Code Objects
Use the QR code object to embed a QR code in an object report. The QR Code Content is read when the QR code is scanned.
Sequence Objects
Include sequence objects to print a numbered sequence on an object report. The sequence object is designed to mimic a counter on a preprinted form. For example, use a sequence object on a scheduling form to track each form by its number in the sequence. Use only numbers for a sequence object, and use a maximum of one sequence object per object report.
Use Sequence Objects
Navigate to the Object Reports page.
Click the name of the object report to which you want to add this object.
Click Sequence.
Use the following table to enter information in the fields:
Field | Description |
|---|---|
Object Label | Enter a name for the sequence object. |
Position | Enter the position of the sequence object for the X (horizontal) and Y (vertical) axes. |
Font | Choose a font for the sequence object. |
Style | Select any combination of the following checkboxes to determine the style of the font:
Otherwise, do not select any checkboxes. |
Size | Enter the font size in points. One point equals 1/72 of an inch. |
Starting Number | Enter the first number in the sequence object. |
Count Forward? | Select the checkbox if the sequence is in ascending order, such as 1, 2, and 3. To use descending order, deselect the checkbox. |
Format String | This is used to format the printed output of the sequence object. For example, if you enter a starting number of 10 and a format string of 00000, the first item prints as 00010. |
Color | Enter the name of the color in which you want all text in the sequence object to print. To view a list of color names, click Color. A color palette appears. Copy the name of the color you want and paste it into the Color field. If you want the text to be black, leave this field blank. |
Tint | Enter a percentage to determine the shade of the sequence list object. If you enter 100%, the object is black. If you enter 0%, the object is white. Therefore, you can enter percentages between 100 and 0 to create a darker or lighter object. |
Page | Do one of the following:
As of PowerSchool 11.0.4.0, only numeric values may be entered in the Page field. If an alphanumeric value was entered before PowerSchool 11.0.4.0, that value will be honored, and the sequence object will continue to appear on the first page of the report. |
Layer | If you want this object to appear behind or in front of another object, choose the layer placement. Choose the highest number to place the object in front of all other layers. |
Click Submit.
Standards Objects
Create standard objects to include standard grades for each course.
Add a Standard Object
Navigate to the Object Reports page.
Click the name of the object report to which you want to add a standard object.
Under New Object, click Standard.
Use the following table to enter information in the fields:
Field | Description |
|---|---|
Define the box that contains the standard course listing | Enter the coordinates of the box in which the standard information prints. Use inches as the unit of measurement. Determine how many inches from the top left of the page you want the standard object to print. Indicate the start, top, end, and bottom coordinates of the standard object. The start side and end side are determined by the direction of the language used in the report. |
If the listing overflows this object, start a new column with these margins | If the listing requires more room on the report on the same page, enter the coordinates of the box in which the overflow standard information prints. Use inches as the unit of measurement. Determine how many inches from the top left of the page you want the overflow standard object to print. Indicate the start, top, end, and bottom coordinates of the standard object. The start side and end side are determined by the direction of the language used in the report. |
Term/school name font | Choose the font in which the term and school information prints. Click on the font link to view a list of available font examples. |
Size, line height, style | Enter the information for the term/school name to display on the report. In the first field, enter the size of the font. In the second field, enter the height of each line in the object in points. One point equals 1/72 of an inch. The height determines the space between each line in the standard. Select any combination of these checkboxes to determine any additional styles for the text:
|
Term/school displays | Choose whether to print the year abbreviation, the school name, both the school name and year abbreviation, or to leave this information off the report. |
Course listing font | Choose the font in which the standard information prints. Click on the font link to view a list of available font examples. |
Size, line height, style | Enter the information for the course listing on the report. In the first field, enter the size of the font. In the second field, enter the height of each line in the object. One point equals 1/72 of an inch. The height determines the space between each line in the standard. Select any combination of these checkboxes to determine any additional styles for the text:
|
Cell padding | Enter a number, in points, to determine the distance between the horizontal and vertical borders of the cell and its contents. One point equals 1/72 of an inch. |
Horizontal Separator Width | Enter the pixel width of the separator border between rows. Here is an example of the conversion from pixels to point-sized for the border: 1 px = 0.75 point |
Horizontal Separator Color | Enter the color you want for the separator border between rows. Leave the field blank to use a black border. To use a named color, click on the Horizontal Separator Color link to view a list of the colors available. You can copy a color name from the page and paste it into the Horizontal Separator Color field. You can also enter an HTML color code directly in the field. Be sure to include the # symbol in the HTML color code when you enter it in the field. |
Horizontal Separator Tint | If you want the separator border to be a gradient of the color you selected, enter the percentage. The lower the number, the lighter the color will appear. |
Horizontal Separator Line Style | Select the line style for the separator border. |
Columns | Specify the following for each column: In the Term field, enter the store codes (terms) you want to include in the standard. The report prints historical grade information for only the term columns you define, such as S1 and S2. The first six columns are pre-populated with the most commonly used objects. It is important to first list the course name, followed by the Start a New Line field. The items after the new line will repeat within the course name. For example, it will list a single course, then all of the standards assigned to that course. The new line helps to differentiate the spacing of the standards and the course name itself. This allows the standards to appear all under the same course. To change or add new fields, from the Field menu, select one of the following fields to include in the column:
In the Other Field/Text/Format, enter any additional field or text you want to print next to each course. If you enter a PowerSchool field name, use the following format: ^(field name). For example, to include the possible credit a student could earn in each course, you can include the potential credit field. In the Width field, enter the width, in inches, of each term column. From the Align menu, select whether to align the data to the left, center, or right of the column. For special formatting around course names and/or standard names, you can hard-code the course names or the standard name in the report. Then, in the Standards object, do not include a row for the course name, or don't include the standard name in the object. To check the alignment of the special formatting, run the report once with the standard name included, then remove it when the alignment is verified. |
Include only standard grades from these grade levels | To print standard grades for only certain grade levels in the standard, enter the range of grade levels. Otherwise, leave these fields blank. |
Exclude Standards with No Grades? | Select the checkbox if you do not want to display courses for which the student did not receive a grade. For example, if your school schedules lunch as a course on student schedules, select the checkbox to not print lunch on student standards. |
Filter to Specific Standards | Use the fields to filter the report to specific standards.
For example, enter history, math, and language arts. |
Show Additional Data (Usually Excluded) | Select the checkbox next to the filter option you want included in the report. |
Current school only? | Select the checkbox to include grades for only the current school in the standard. Otherwise, deselect the checkbox. |
Current year only? | Select the checkbox to include grades for only the current year in the standard. Otherwise, deselect the checkbox. |
Sort courses by | Use this pop-up menu to determine the sort order of the courses in the standard grades listing:
|
Sort standards by | Use this pop-up menu to determine the sort order of the standards:
|
Page | Do one of the following:
As of PowerSchool 11.0.4.0, only numeric values may be entered in the Page field. If an alphanumeric value was entered before PowerSchool 11.0.4.0, that value will be honored, and the standard object will continue to appear on the first page of the report. |
Layer | If you want this object to appear behind or in front of another object, choose the layer placement. Choose the highest number to place the object in front of all other layers. |
Click Submit.
Note: The Course Name and Standards name fields are not required to be printed by this object. Some customers may want to hard-code those on the report to include special formatting, grid lines, and other items. This is especially useful when using multiple standard objects on the report and using the filters to limit which standards appear in each area. In that case, you can hard-code the names on the report and remove them from this object. Be sure to test the alignment first by including the standards or course names from the object to line up the report, then remove them once you have correctly lined up the objects.
Edit a Standard Object
Navigate to the Object Reports page.
Click the name of the object report for which you want to edit a standard object.
In the Object Type column, click Standard of the standard object you want to edit.
Edit information as needed.
Click Submit.
Delete a Standard Object
Navigate to the Object Reports page.
Click the name of the object report for which you want to delete a standard object.
In the Object Type column, click Standard of the standard object you want to delete.
Click Delete.
Click Confirm Delete.
Click Back to return to the Object Report [Report Name] page.
Standard Object Filter Examples
Report Type | Filter Field | Data Entry |
|---|---|---|
Elementary Report Card | Only include standards with these identifiers | Enter MATH1.1.1, MATH1.1.2, MATH1.1.3, MATH1.1.4, MATH1.1.5, MATH1.1.6, MATH1.1.7 to view these exact standards on the report. |
Middle School/High School Report Card | None | To display each student's full schedule and standards for their classes, do not include filters. |
Life Science Standard | Only include standards starting with the following text | Enter Life Science, and select Standard Name to view only that standard on the report. |
Export report as a template
Navigate to the Object Reports page.
Click the name of the object report you want to export as a template.
The selected report is downloaded in a PST format.
Duplicate report
Navigate to the Object Reports page.
Click the name of the object report you want to duplicate.
You can change the name of the new report.
Click Submit.
Object Reports With Standards Grades
Object reports can display standards scores. Use the following list of codes to generate object reports with standards grades.
Current Standard
~(*std.[which];[identifier])
For example:
~(*std.avg;LA11.2.3)
~(*std.transhigh;M12.4.5)
~(*std.num;FL3)
Calculated Standard
~(*std.[which];[identifier];[request1]{;[request2]})
For example:
~(*std.transavg;LA11.2.3;8/1/2000;7/30/2001)
~(*std.avg;SC3.5.12;Q1,Q2)
~(*std.high;FL2.5;2,3,4;S1)
~(*std.num;FA5.12;1999)
Stored Standard
~(*std.stored.[which];[identifier];[storecode]{;[request]})
For example:
~(*std.stored.transavg;LA11.2.3;S1)
~(*std.stored.avg;SC3.5.12;Q4)
~(*std.stored.high;FL2.5;T1;1999)
~(*std.stored.num;FA5.12;S2;11)
For which the following can have 'score' suffixed (for example, averagescore):
transhigh (translatedhigh)
trans (transavg, translatedavg, translatedaverage)
num (number, number, numberof)
avg (average)
high
note (comment)
Standard Info
name
desc (description)
level
course (coursenumber, course_number)
subj (subject, subjectarea)
type
id (identifier)
alignmentid (alignidentifier, alignid)
listparent
calcparent (calculationparent)
conv (convscale, conversionscale)
For example:
~(*std.info.name;LA11.2.3)
~(*std.info.desc;SC3.5.12)
~(*std.info.type;FL2.5)
Standard Info codes allow the parameter modification codes (for example, ;uppercase); however, the report codes do not.
Object Reports With Test Tags
Use test tags to include student test results in outputs. An output is a PDF file (such as an object report), an export, or an HTML page. For example, use the test tag when creating an object report text object. Enter the appropriate tags and supporting text in the Text field.
Test tags typically include several parameters to limit and format what appears on the report. For example, use the following test tag on a progress report to display a student's midterm test score:
~(tests;name=midterm;score=total;which=current)
You can also use the test tag inside an IF tag, which is a tag used to evaluate a given condition. For example, use an IF tag to display the statement "This student may wish to retake the ACT" on students' Graduation Progress pages if they earn ACT composite scores of less than 25.
In addition, you can add formats to the result of the test tag. The following is an example of a test tag that includes a type value, result value, and format string:
~(tests;name=ACT;score=math;which=last;type=num;result=value;format=##0.00)
The first three parameters refine the selection, and the next three parameters determine its presentation. If a student's last math ACT score was 23.14285, the result would be 23.14.
See the following table for parameter information.
Parameter | Examples | Notes |
|---|---|---|
NAME | ACT SAT | No default. NAME and SCORE are dependent upon tests defined on your PowerSchool system. |
SCORE | MATH ENGLISH SCIENCE COMPOSITE | No default. |
WHICH | FIRST LAST BEST CURRENT term TERMID GRADE | The default is LAST. |
TYPE | NUM PERCENT ALPHA | The default is NUM. |
RESULT | VALUE SUM AVG DATE COUNT MIN MAX | The default is SUM. |
FORMAT | [Format string] |
Some parameters are not compatible with others. For example, you cannot have a RESULT of SUM with a TYPE of ALPHA. Various combinations are detailed in the table below.
For example, the WHICH parameter TERM.CURRENT includes multiple tests. The RESULT parameter could meaningfully be set to SUM, AVG, COUNT, MIN, and MAX. A RESULT parameter of VALUE would not be meaningful and would return nothing.
See the following table to determine parameter compatibility; X indicates valid usage.
Which/Result | SUM | AVG | COUNT | MIN | MAX | VALUE |
|---|---|---|---|---|---|---|
FIRST | X | X | X | X | ||
LAST | X | X | X | X | ||
BEST | X | X | X | X | ||
TERM.CURRENT | X | X | X | X | X | |
TERM.id | X | X | X | X | X | |
DATES.mmddyy.mmddyy | X | X | X | X | X | |
GRADE.number | X | X | X | X | X | |
TYPE | ||||||
NUM | X | X | X | X | X | X |
PERCENT | X | X | X | X | X | X |
ALPHA | X | X |