Gibbon Education Limited

Queries

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

Activities

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

Admissions

  • Applicants With Year Group & Status By School Year
  • Application Frequency by Year and Month
  • Application Mailing & Phone Summary
  • Applications By DOB
  • Applications in Specified Year
  • Language Choices in Next Year's Applications
  • Left Students with Departure Reasons
  • Total Applications and Acceptances

Alumni

  • Registered Alumni Email Addresses

Assessment

  • All "Final" External Assessment Results
  • Complete Markbook Column Count by Class in the Current Term
  • Export All Markbook Columns In Current Year
  • 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 - Completion Check
  • Internal Assessment Results In The Specified Year
  • Markbook Column Count by Student in Specified 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

ATL

  • ATL Check
  • ATL Result Dump for Current School Year

Attendance

  • Attendance Taking Count by Student
  • Class Attendance as Percentage
  • Delete Absence Data By Student
  • Lateness Count in Last Week by Student
  • School Days Present Between Two Dates by Student
  • Self-Registration Failure Count By Student

Badges

  • Badges Granted Count Since Specified Date
  • Badges Granted In The Specified Year

Behaviour

  • Behaviour Records by Year Group

Data Checks

  • Students Without Photos
  • Students/Staff Without House

Emergency

  • Parent Emails By Student Transport

Finance

  • Invoice Payments Made Today

Free Learning

  • All Free Learning Enrolment in the Current Year
  • All Free Learning Units
  • Exemplar Work By Specified School Year
  • Free Learning Course Completion Percentage by Student
  • Free Learning Engagement by Student
  • Free Learning Teacher Engagements
  • Mean Wait Time By Class Teacher In Specified School Year
  • Mean Wait Time By School Mentor In Specified School Year
  • Outstanding Free Learning Assessment
  • School Mentor Discussion Entries
  • Unit Completion By Student In Specified Year
  • Unit Completion Count By Student And Specified School Year
  • Unit Count by Author
  • Units by Author
  • Units With Blocks
  • Units Without Minimum Year Group Set

Individual Needs

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

Library

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

Meet The Teacher

  • Missing Parent Login Codes

Miscellaneous

  • 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
  • Outcomes
  • Planner Entries In Current Year
  • Planner Time Cap Usage by Year Group
  • Weekly Planner Summary Email Non-Confirm Count

School Admin

  • List All Facilities

Staff

  • All Staff
  • Staff Initials

Students

  • Update Student Start Dates

Students & Families

  • Active Student Count by Family & Parent
  • All Active Parents
  • All Active Parents Linked To Enroled & Active Students
  • All Current Students - Master List
  • All Current Students With First Year In School
  • Alumni From Last 5 Years
  • Citizenship Frequency
  • Clear All Student Transport Details
  • Contact Priority 1 Parent Email for Students With Privacy Required
  • Family Contacts For Last Graduating Cohort
  • 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
  • Parent Logins Between Specified Dates
  • Parental Email & Personal Data By Form Group
  • Parental Telephone List
  • Primary Home Language Frequency
  • Sibling List In Current Year - All Students
  • Sibling List In Current Year - Only Siblings
  • Student Agreements For Whole School
  • Student Day Type by Form 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 No Form Group
  • Students with Username by Form Group
  • Students with Username by Year Group
  • Students Without Logins Between Specified Dates
  • Vehicle Registrations
  • Whole School Mailing List

System Admin

  • Completed Database Migrations

Timetable

  • Complete Student Timetable Output
  • Complete Timetable Output
  • Course Selection Results in Given Year
  • Course/Class Selections in Current Year
  • Courses in the Specified Year
  • Facility Usage Summary
  • Number Of Classes Per Year By Class
  • Subject Selections for Year Group
  • Teacher Email Addresses By Student
  • Teacher Student Count in a Given School Year
  • Teachers Of Courses and Classes in Current Year
  • Timetable Day Occurrences Count In Specified Year

User Admin

  • All Current Users with Primary Role Category and Email
  • All Personal Documents by Type
  • Form Group Student Count For All School Years
  • Role Count For Active Users
  • Students with Personal Documents Expiring/Expired
  • User Roles Listed By Role
  • Users with Duplicate Email Address