Offsite Visit Forms

These reports enable you to populate County Standard Forms for Offsite Visits directly from Sims .net. In addition, the Financial Reconciliation can be populated and calculated as the formulas are embedded.

Prior to downloading the reports please ensure you have:

• read the instructions for Downloading and Importing Report Files located above this table
• download and read the instructions opposite prior to attempting to use these reports.
  

You will now be able to download the correct set of reports for your school.

Should you only be at the initial stages of costing your trip, then you should use this spreadsheet.

Modifications were made to the OV8 form in May 2010 and this file contains just those two reports. Please delete from the Group Folder old copies of the OV8 - OV Form Reg OV8 - Priority & Medical Contacts and OV Group OV8 - Priority & Medical Contacts. Please note that Sims .net will not populate the newly created 'Other Relevant Information' column.

Instructions for Using Offsite Visit Forms & Financial Trip Reconciliation (Pink Book)

• Word 2003, 90kb/4 pages, 17/05/2010, offsite_visit_instructions
  reconciliation_pinkbook.doc

OV Forms & Documents Reg

• RptDef file, 344kb, 21/04/2011, ov_forms_reg_v6.rpt.def
• RptDef file, 37kb, 25/08/2009, pink_book_reg.RptDef

OV Forms and Documents Group

• RptDef file, 314kb, 17/05/2010, ov_forms_group_v5.RptDef
• RptDef file, 68kb, 21/11/2011, pink_book_group.RptDef

School Journey Reconciliation (Pink Book)

• Excel 2003, 136kb/ 1 sheet, 25/08/2009, school_journey_reconciliation
  _pinkbook_v3.xls

• RptDef file, 147kb, 17/05/2010,

  ov8_data_protection_compliant

  .RptDef

SITSS - County Exclusion Letters and Form X1 for Permanent Exclusions

From the 1st September 2009 all schools will return all Fixed Period and Lunchtime Exclusions electronically.

PLEASE NOTE: This documentation was updated in October 2011.
Both instructional documents, S1215 Completion and Submission of Electronic Exclusions and S1217 Installing the Exclusion Sender MUST be completed. The reports referred to in the documents are shown opposite.

Please note
All schools MUST have the latest version of the Exclusions Sender (October 2011) installed. If you have a previous version then this should be uninstalled prior to installing the new version. Please refer to document S1217 for instructions.

• Acrobat pdf, 513kb/14 pages, 18/10/2011, s1217_installing_exclusion_sender.pdf

• Executable, 463kb, 21/12/2011, exclusion_sender_dec_11.msi

• Acrobat pdf, 793kb/25 pages, 18/10/2011, s1215_completion_submission_electronic_exclusions.pdf

• RptDef file, 35kb, 10/02/2011, hcc_electronic_exclusions.RptDef
• RptDef file, 189kb, 18/10/2011, hcc_exclusion_letters_and X1_form_oct11.RptDef

SITSS - Exclusion Comparision

These reports will allow you to compare reasons for exclusion year on year, term by term. Double click on the sheet tab and insert the Term - Autumn, Spring or Summer - to which the data relates prior to printing. The Pivot Field Data List has been left visible to enable greater manipulation of the data.

• RptDef file, 30kb, 21/11/2006, Exclusions Term Comparison Chart.RptDef

Behaviour Reports

This collection of reports will enable behaviour, achievement and detention data to be extracted and analysed in various formats. Please view the report catalogue prior to reporting as this shows the output of each report.

• Word 2003, 816kb/12 pages, 13/09/2011, report_catalogue.doc

• RptDef file, 4mb, 14/11/2011, behaviour_reports_2011_002.RptDef

Data Collection and Record Sheets with Medical Information

These reports files contain Data Collection and Record Sheets with Medical Notes and Medical Conditions. Please read the document for an explanation of the reports. A blank Data Collection sheet is also available for download Click Here.
These new versions supersede any previous SITSS Data Collection and Record Sheets you may have imported and have been updated to include the Privacy Notice 2010.

Data Collection and Record Sheets

• Word2003, 27kb/1 page, 22/12/2005, data_collection.doc

SITSS Data Collection and Record Sheets

• RptDef file, 232kb, 24/11/2009, dc_recordsheets7122.RptDef

Alternative Data Collection Sheets

These alternative reports, found in the Data Collection Focus in the Report Browse, should run more quickly. They can also be run directly from a Student record by clicking the link for Data Collection Sheets in the Links panel. However, not all fields are currently available to include in these reports (e.g. First Langage is missing).

• RptDef file, 157kb, 24/11/2009, dcsheets_dcfocus.RptDef

SITSS Class Lists

These are class (reg group) lists sorted alphabetically and by DOB, with a blank column, and will appear in the Group Focus (apart from the Excel versions which are found in the Student focus). These new versions use the Preferred Forename if one exists.

• RptDef file, 109kb, 10/01/2007, classlists_jan07.RptDef

Class Lists with Contact Details

This file contains class lists with address and contact information. It contains 3 reports:

• SITSS - Class + Address + Contact Pr 1 gives details of contacts with priority 1 only.

• SITSS - Class List + Contact Details lets you specify the contacts' priority

• SITSS - Whole School Contact List gives contact and address information for the WHOLE school in alphabetical order.

All of these reports will appear in the Group Focus.

• RptDef file, 89kb, 10/01/2007, class_contact_lists_jan07.RptDef

Mailing Point Reports

This file contains 3 reports

• SITSS - Class List by Mailing Point gives you a list by reg group of those pupils who are the mailing point for their family (provided you have set the mailing point for oldest or youngest child), and is found in the Group Focus.

• SITSS - Mailing Point Check lists any pupils that may have been missed when mailing points were set, and is found in the Student Focus.

• SITSS - Class and Mailing Point Numbers is a handy report to keep by the photocopier as it lists totals and mailing point numbers for each reg group, and is found in the Group Focus.

• RptDef file, 25kb, 10/01/2007, mailing_pt_jan07.RptDef

SITSS - Weekly Reading Record

This gives class lists with 5 blank columns headed Monday to Friday, which could be used as a tick sheet, and is found in the Group Focus.

• RptDef file, 10kb, 10/01/2007, weekly_reading.RptDef

Class List with Medical Information

This lists by registration group those children who have either dietary needs or a medical condition or a medical note.

• RptDef file, 19kb, 07/03/2007, class_list_and_medical.RptDef

Class List for Register

Some schools have asked for a simplified class list with address information for the registers. This report, found in the Student Focus, lists names with home address and telephone no. plus the Parental Salutation. Each class should fit onto just one page

• RptDef file, 29kb, 25/10/2006, class_register.RptDef

HCC – CLA Caring Authority Return
This return will inform HCC of all CLA on the school roll to enable funding to be allocated.

• RptDef file, 25kb, 15/09/2011, hcc_cla_caring_authority_return.RptDef

• Acrobat pdf, 631kb/9 pages, 15/09/2011, hcc_cla_caring_authority_return.pdf

New National Child Measurement Programme
This report will populate the official NCMP template with pupil data from SIMS.

• RptDef file, 19kb, 01/11/2010, ncmp_template.RptDef

Contact Checking Reports

This file contains 6 reports (all in the Student and Contract Focuses) that will help you check a whole series of issues regarding contacts, addresses, parental responsibility and correspondence. Please see the document alongside for a complete explanation of what each report does, and what to do when issues are identified.

• RptDef file, 525kb, 31/03/2010, contact_checks.RptDef

• Word 2003, 320kb/20 pages, 31/03/2010, s1049_contact_checking_reports.doc

Census Contact Checking Reports

• RptDef file, 38kb, 25/11/2008, sitss_census_contact_checking_report.RptDef

Certificates

This file contains 2 reports that produce certificates - one for good attendance and one for birthdays. Both are found in the Student Focus.
(Many thanks to Traci at Broom Barns JMI School for the original reports)

• RptDef file, 32kb, 07/03/2007, certificates.RptDef

Tick Grid Reports

These are a new type of report which have a similar look to the Students Bulk update screen, in that they are a grid with ticks (hence the name!). They work with either Excel 2002 (XP) or 2003, not NOT with Excel 2000. You may wish to organise these reports into a Category (see instructions for using Categories under Documents to download above). They are all found in the Student Focus.

• RptDef file, 865kb, 07/03/2007, tick_grids.RptDef

Population Analysis reports

Population analysis by year or reg group with totals

• RptDef file, 58kb, 18/07/05, popanalysisrep.RptDef

Ofsted Report

This has been updated to include more data to analyse.

This is an analysis report which you may find useful for Ofsted. Please read the document below for information on how to use the report.

• RptDef file, 8kb, 07/03/2007, ofsted.RptDef

• Acrobat pdf, 167kb/2 pages, 19/08/05, ofsted_rep.pdf

SITSS - Leavers' Ethnic and Cultural Info Report

This can be used to show ethnic/cultural information for pupils who have left, and is found in the Student Focus.

• RptDef file, 8.2kb, 29/09/2006, leavers_ethnicity.RptDef

Photo Reports

This file contains 3 reports:
SITSS - Class Photos, found in the Student Focus, which works for Reg groups
SITSS - Class Photos, found in the Group Focus, which also works for Reg groups but sets all photos at the same size
SITSS - Teacher Class Photos, found in the Group Focus, which works for teaching classes and prompts for teacher name as well as class name

• RptDef file, 70kb, 05/11/2007, photos.RptDef

House Lists

This contains 2 reports: SITSS - Class List with Houses and SITSS - House List, both found in the Group Focus.

• RptDef file, 21kb, 10/01/2007, house.RptDef

SITSS - School Roll Book

This report, found in the Student Focus, lists details required by the DCSF for a School Roll Book. It has a filter for Admission Date (not admission number as with the Capita version).

• RptDef file, 24kb, 20/03/2009, roll_book.RptDef

Name Badges

Many schools have requested labels with names or names and reg groups. Choose the file with the correct Avery code for your labels. All of these reports will appear in the Student Focus.

• RptDef file, 35kb, 24/08/2006, badges_l7159.RptDef

• RptDef file, 34kb, 24/08/2006, badges_l7160.RptDef

• RptDef file, 33kb, 24/08/2006, badges_l7162.RptDef

• RptDef file, 32kb, 24/08/2006, badges_l7163.RptDef

• RptDef file, 33kb, 24/08/2006, badges_l7161.RptDef

SITSS - Address Analysis

This report, found in the Student Focus, allows you to analyse numbers of pupils in different postcodes, towns or counties. Once in the Analysis window, change the row to Postcode, Town or County as required. To print the results, click the Copy to Excel button to put the information in an Excel spreadsheet.

• RptDef file, 8.2kb, 24/08/2006, address_analysis.RptDef

SITSS - Weekly Diary

This report, found in the Diary Focus, allows you to print out a list of events for a particular week. You will be prompted to enter a date range - enter the date of the Monday and the date of the Friday of the required week

• RptDef file, 29kb, 29/11/2006, week_diary.RptDef

Mode of Travel Reports

This file contains 4 reports:

SITSS - Modes of Travel Grid and SITSS - Modes of Travel Grid by Reg which are tick grids with Grand Totals, and SITSS - Modes of Travel Numbers which gives a summary of the numbers for each type of travel. These 3 reports are all in the Student Focus.

SITSS - Modes of Travel List gives a list of names for each type of travel and is found in the Group Focus.

• RptDef file, 88kb, 10/01/2007, modes_travel.RptDef

Reports for Parents' Evenings

These two reports may help secondary schools with Parent/Teacher consultations evenings.
SITSS - Teacher List for Parents Evening (found in the Student Focus) gives a page per student with a list of subjects and teachers, plus a blank column to enter appointment times.
SITSS - Teachers for a Year Group (found in the Staff Focus) lists all teachers with their classes for a specified year group.

• RptDef file, 25kb, 01/02/2007, teacher_lists.RptDef

Catholic Education Services Report

This report give a breakdown of numbers of Catholic pupils by year and gender.

• RptDef file, 27kb, 20/03/2009, catholics.RptDef

SITSS Results Reports

This reports download contains the report definition for three SIMS .net reports that have been designed by SITSS to show students results. There is one for Key Stage Results, one for Examination Results and one that shows all results held in Assessment Manager for a named student.

• RptDef file, 24kb, 21/02/06, sitss_result_report.RptDef

SITSS - New Intake for Year 7

• RptDef file, 4.2kb, 13/02/2007, year7_intake.RptDef

SITSS - % Attendance Vulnerable Groups

This report will give you some indication of the % attendance for all year groups and some vulnerable groups between a specified date range. You must ensure that you enter the same date range for each of the date filters. However, unlike the built in reports in Attendance, this report does not take into account missing marks, and only includes students on roll on the effective date it is run for: i.e. students who may have been on roll for part of the date range selected, but who left before the effective date, are not included.

• RptDef file, 122kb, 23/06/2010, secondary_attendance_vulnerable_groups.RptDef

Applicant Data Collection and Record Sheets

for use after the November upgrade only
(found in the Application Focus)

• RptDef file, 177kb, 19/12/06, applicant_dcsheets.RptDef

Applicant Labels

for use after the November upgrade only (found in the Application Focus)

• RptDef file, 47kb, 19/12/2006, applicant_labels.RptDef

SITSS - EWN1 Form

This report generates an EWN1 form for leavers, which is required by your Attendance Improvement Officer. Please read the document before running the report, as it describes how to use the report and also gives the addresses of the Educational Welfare Offices.

• Word2003, 83kb, 04/05/2007, w023_ewn1_form.doc
• RptDef file, 19kb, 11/11/2009, ewn1.RptDef

SITSS - Absence Sessions in a Date Range

This report is designed to helps schools complete the Persistent Absence Data Collection.

• RptDef file, 32kb, 18/01/2007, absence.RptDef

SITSS - % Attendance Vulnerable Groups

This Excel report will give you some indication of the % attendance for all year groups and some vulnerable groups between a specified date range. You must ensure that you enter the same date range for each of the date filters. However, unlike the built in reports in Attendance, this report does not take into account missing marks, and only includes students on roll on the effective date it is run for: i.e. students who may have been on roll for part of the date range selected, but who left before the effective date, are not included. The second sheet (Student Data) in the report allows you to identify students with a percentage attendance below a selected number, and will also allow you to filter your groups even further, e.g. Summer Born White British Boys.

• RptDef file, 117kb, 07/07/2010, primary_attendance_vulnerable_groups.RptDef
• RptDef file, 117kb, 07/07/2010, secondary_attendance_vulnerable_groups.RptDef

HCC Penalty Notice

Penalty notices can be issued in cases of unauthorised absence. The pupil's absence must have been unauthorised for at least 21 sessions in the previous and/or current term.

This document will guide you through the process of producing the Hertfordshire County Council's required application form, FPN2 - Application for a Penalty Notice to be issued, using Sims .net reporting. Information held within your Sims .net database will populate the pupil's basic details section and the necessary Certificate of Attendance.

Please print the pdf document in the box to the right for instructions on how to download, import and use the required Sims .net reports.

• Acrobat pdf, 572kb/13 pages, 05/10/2010, hcc_penalty_notice_application_using_sims_net.pdf

• RptDef file, 272kb, 05/04/2011, hcc_penalty_notice_application.RptDef