Printing Certificates for Celebration Assemblies

 

 

 

 

 

 

 

 




With the end of term upon us, it is useful to know how to easily prepare for a celebration assembly.  Instructions are given below, to produce:

  • Milestone Certificates (Bronze, Silver, Gold and Platinum for total number of housepoints)
  • Attendance Certificates (it is appreciated that these are awarded before the term is fully completed)

Attendance Achievements will be awarded to all students with 95% and above attendance once the term has ended.

 

I will ask the office to print all of these for your year group.  If you wish for anything different, please let me know as soon as possible.

 

 

 

How to print Milestone Certificates

  • Hover over “Downloads” and click on “Milestone certificates”
  • Change “Print from” and “Print to” as required
  • Choose the “Year” (or select a “Tutor group”)

  You may have to do one tutor group at a time due to limits on the number you can print in one go

  • Change “Milestone” to just print “Bronze Award (40 points)” etc.
  • Other settings:

A screenshot of a computer Description automatically generated

  • Click on “Next step”
  • Click on “Download XXX certificates”
  • It is recommend to save the download and send to the office for printing or print to pdf and send to the office for printing
  • Please ask for certificates to be printed A5 size on white card

 

How to print Attendance Certificates

  • Go to KEY DOCUMENTS/Tutoring and open “Attendance Certificate Data”
  • Save this file to your N: drive (mailmerge will not use a online file as a data source)

 

  • Open the “Attendance Monster”
  • Filter on your Year Group
  • Filter on Attendance Award winners (see columns at the far right of spreadsheet)

  (Filter on “between 95% and 99.99%”)

  • Copy the relevant data (Columns E-H and then Column WP, WQ or WR) into “Attendance Certificate data”
  • Click Save

 

  • Go to KEY DOCUMENTS/Tutoring and open “Attendance Certificate 95”
  • Edit the certificate if required (e.g. Term numbers and signature)
  • Click Mailings à Select Recipients à Use an Existing List…
  • Select your saved data file and click OK when prompted
  • Click Finish & Merge àPrint Documents… à OK
  • Print your certificates as a pdf and send to the office for printing
  • Please ask for certificates to be printed A5 size on white card

 

100% certificates are printed in the same way, using “Attendance Certificate 100”