Gibbon Education Limited

Queries

The list below shows the 91 Query Builder queries curently included in the Gibbon Value Added License.

Activities

  • Activities Attendance Status Today
  • Activities by Staff
  • Activity Choices in Current Year
  • Activity Enrolment by Activity
  • Activity Enrolment Overview For Current Year
  • Activity Overview Including Days & Staff

Applications

  • Applicants With Year Group & Status By School Year
  • Application Frequency by Year and Month
  • Application Mailing & Phone Summary
  • Applications By DOB
  • Applications in Current Year
  • Class Attendance as Percentage
  • Language Choices in Next Year's Applications

Assessment

  • All "Final" External Assessment Results
  • Complete Markbook Column Count by Class in the Current Term
  • External Assessment Overview
  • External Assessment Results by Year Group
  • Formal Assessment Results By Student
  • GCSE Target Grades For Students In A Year Group
  • Internal Assessment Results In The Current Year
  • Internal Assessment Results In The Current Year - Completion Check
  • Markbook Column Count by Student in Current Year
  • Markbook Entries for Whole School Over Past Month
  • Markbook Entries for Year Group
  • Markbook Entries for Year Group (All Historic)
  • Markbook EOY for Last Year
  • Student Likes By Roll Group
  • Subject Selections for Year Group

Attendance

  • School Days Present Between Two Dates by Student
  • Self-Registration Failure Count By Student

Behaviour

  • Behaviour Records by Year Group

Data Checks

  • Students Without Photos
  • Students/Staff Without House

Emergency

  • Parent Emails By Student Transport

Family Contacts For Last Graduating Cohort

  • Students & Families

Individual Needs

  • Individual Needs by Roll Group
  • Individual Needs Notes
  • Students With Language Information

Library

  • All Current Library Loans
  • Inventory Replacement Cost & Schedule
  • Overdue Library Loans

Miscellaneous

  • All Staff
  • Form Group Transition From Last To This Year
  • Number of Years Students Have Been In School

Planner

  • Homework Count by Student for Last Week
  • Homework Details by Student for Last Week
  • Planner Entries In Current Year
  • Weekly Planner Summary Email Non-Confirm Count

School Admin

  • List All Facilities

Staff

  • Staff Initials

Students & Families

  • Active Student Count by Family & Parent
  • All Active Parents
  • All Active Parents Linked To Enroled & Active Students
  • All Current Students With First Year In School
  • Alumni From Last 5 Years
  • Citizenship Frequency
  • Contact Priority 1 Parent Email for Students With Privacy Required
  • Family Overview
  • Female Student Emails in Class by Teacher Username
  • Length of Stay
  • Medical Conditions For All Students
  • Parent Contact Details by Student in Current Year
  • Parental Email & Personal Data By Roll Group
  • Parental Telephone List
  • Sibling List In Current Year - All Students
  • Sibling List In Current Year - Only Siblings
  • Student Agreements For Whole School
  • Student Day Type by Roll Group
  • Student Enrolment Count By Term
  • Student Leavers By End Date In Past Year
  • Student Privacy Visual Overview
  • Student Start & End Summary
  • Student Transport
  • Students By House
  • Students With No Family
  • Students with Username by Roll Group
  • Vehicle Registrations
  • Whole School Mailing List

Timetable

  • Complete Student Timetable Output
  • Complete Timetable Output
  • Course/Class Selections in Current Year
  • Facility Usage Summary
  • Number Of Classes Per Year By Class
  • Teacher Email Addresses By Student
  • Teachers Of Courses and Classes in Current Year
  • Timetable Day Occurrences Count In Current Year

User Admin

  • All Current Users with Primary Role Category and Email
  • Role Count For Active Users
  • Roll Group Student Count For All School Years
  • User Roles Listed By Role
  • Users with Duplicate Email Address