Cumulative labels

[CherylB28]

This year my counselors would like cumulative labels to go on the student folder. Can any one help with the format.  : : 

[PS_AM1]

Hi @CherylB28,

Thank you for reaching out for assistance through the Community!  Would you provide the product in which you are using, please?

[PatriciaC34]

HI there! so I use the following fields in Power School

<b><i><font size="+1">^(Last_Name), ^(First_name)</b></i></font size>
ID.^(Student_Number) SSN.^(SSN)
Birthdate:^(DOB)

Go to print out address labels and create your own by adding the fields above. If you need further assistance, I can give you step by step on hoe to do this.

Patty Correa

[BethM16]

We have a format set up under our Print Labels feature--do you have that option?

[Lchesser]

Hi Patty,

Can you give me step by step instructions on printing address labels for all students?

[PatriciaC34]

Hi there! Sure thing... from the Start page, select the grade level or All in which you want to print out labels for. On the right hand side, select the "Select Functions" arrow pointing down, it will give you a drop down list in which you can select what you need. In this case, select "Printing Mailing Labels" towards the mid-bottom of the list. Once in there, you have the option to do your own mailing layout or use what your district already has, up to you! Once completed, hit the Submit button on your right hand side. This will go into what's called the "Report Queue" once the report has run and shows completed, it will give you a status of  "Complete", click on "view" next to it and it will pull for you in PDF format and it will be ready to print. Hope this instructions are helpful.

Best to you!

Patty Correa

[simsa]

Do you have step-by-step instructions for creating and printing cumulative folder labels (including courses and final grade averages?

[Brandiwhaley]

Could you please give step by step on how to print permanent record labels that have the yearly attendance and the yearly average per subject for each student? also would like the label to say Promoted on it

[CindyOp]

@Pageb009, @Brandiwhaley, @blairjohnson

It looks like this thread was in our PowerSchool Learning forum. Is that the product you are asking about? If not, I would be happy to move this to the correct forum where you may get a quicker response from other members. 

To assist you further, would you please provide more information about the type of labels you are looking to print (label sheets, form list transcripts, single page, etc)

We welcome others to respond and share their experiences as well.

[blairjohnson]

What can be added to this field to have grades, promoted, etc. added so it can go on the cumulative folder?

[simsa]

Hi there. Did you ever receive any help with this matter? My school would like to use cumulative labels (to include courses and final grade averages) as we have in the past just as your school wanted. I've tried to create them using mailing labels in PowerSchool SIS but "transcript" items are not included in the fields provided. Please help!

[Pageb009]

Hello CherylB28, Did you ever get a template for the cumulative labels? If so, would you mind sharing? 

Thanks, 

Britney

[angela_howard]

@Pageb009, I am working on a cumulative folder printout (not label).  It has the student name, grade, school year, student number, school name, courses, grades for S1, S2, and YR.  (This can be edited to include attendance.) The problem with creating labels is you cannot put a transcript object on a label (I've tried every way imaginable!)  I have this information condensed down to about 3.5 inches by 2.5 - 3 inches.  However, the transcript object is set up to print one transcript per page.  I have not yet come up with a way to print multiple students on one page.  We are in the process of verifying grades for Q4.  Once grades are posted, I will be able to finish tweaking the layout.  Hopefully I will be able to get multiple students on a page soon.

Have you come up with anything since your post?  Thank you!

[toriley]

Is there a formula that we can use to create this?

[angela_howard]

I am actually working on this today.  As soon as I finish tweaking the format, I will post it here.  You can then download it and edit it to display what you need to show. 

[angela_howard]

I have attached the file I am using for cumulative folder labels.  (The actual template is in the zip file.)  I had to make a separate template for each grade, Kindergarten through 12th Grade.  The only difference in each file is Object numbers 25 and 26.  Object number 25 prints "Promoted to:" and the next scheduled grade.  I used a decode statement to change, for example, 11 to 11th Grade.  For graduating seniors, Object number 25 prints "Graduated:" and the date of graduation.  Object number 26 is the Transcript List 2.  In order to get the grades for the current year only, I had to use the field "Restrict to Grade Levels".  In this example I chose restrict from 11 to 11.  I hope this helps you guys!

Things you need to know:

The template creates a pdf file with ONE LABEL PER PAGE.  When printing, you have the option to print multiple pages per sheet.  I chose this option using 2 across and 4 down.  This puts 8 labels on a sheet.  These are the labels:  Avery Printable Blank Shipping Labels, 2.5" x 4", White, 200 Labels, Laser Printer, Permanent Adhesive (5816).  You may have to adjust the settings to get the labels to print correctly.

I had to be very creative to get everything to show up on the labels (and transcripts and report cards).  That is why there are two year columns.  All year-long classes will print the yearly average in the first year column.  Any semester 1 only classes will print the S1 average again in the first year column.  Any semester 2 only classes will print the S2 average again in the second year column.  To get the system to do this, I had to manually add year grades to the historical grades for that class.  Semester 1 (and year-long) classes are coded Y1; semester 2 classes are coded Y2.  (I know this is not feasible for large school districts.  I have only about 300 students total.) For those who need credit hours, you may be able to change the last column to display hours earned.

I have also attached a printout.  I truly hope this template helps someone!  Good luck!!!

Disclaimer:  I am not a programmer.  This was a long and tedious process resulting in a template that may not work for everyone.  Please take it and adapt it as needed.

[ladueb]

Hi Angela! 

Did you create this template for object reports or mailing labels? 

Thanks! 

[angela_howard]

It is an object report. You cannot put a transcript object on a mailing label.

[angela_howard]

Here is a sample of the finished product and the labels I used (Amazon).