Easy Data Mining

Overseer Admin provides a rich suite of filters, constraints and other data mining tools such as groups for selecting highly specific subsets of children, adults, families or organizations for the purpose of generating mailing labels, printing reports or simply browsing and editing data.

Filters

The term filter is used within Overseer as a criterion for selecting a subset of an entity (e.g. “Families of students” is a subset of “All Families”).  Many filters are available to select subsets of children, adults, families, students, teachers, classes, organizations.  For example, the following filters are provided for selecting a subset of children.  Note that many of these involve a secondary selection (e.g. “Students in grade: 7”).

• (All children)
• (All prospects)
• (All students)
• (Deceased children)
• Children attending school:
• Children in division:
• Children in family:
• Children in grade:
• Children in group:
• Children of families in group:
• Children of parents in group:
• Clientele of organizations in group:
• Clientele of organization:
• Prospects in division:
• Prospects in grade:
• Prospects in group:
• Prospects of families in group:
• School attended is in group:
• Students in class:
• Students in division:
• Students in family:
• Students in grade:
• Students in group:
• Students in homeroom:
• Students of families in group:

Constraints

The term constraint is used within Overseer to indicate a mandatory condition to be satisfied, in addition to any filter which may be active, as a criterion for selecting a subset of an entity (e.g. “Females Only” is an additional constraint on the filter “Students in grade: 7” which could be applied to a list of children).  Although only one filter can be used at a time, it is possible to have more than one constraint in use simultaneously.  When multiple constraints are specified, all of them must be satisfied simultaneously by all selected members.

• Specific substring (e.g. street name) in address
• City
• State/Province
• Country
• ZIP/Postal Code (or prefix thereof)
• Range of Mail Status
• Range of age
• Range of Dates of Birth (year, month and day)
• Range of Birthdays (month and day)
• Attendance Period, Status (Absent, Absent or Excused, Enrolled, Excused, Late, Not Enrolled, Present, Present or Excused) and Range of Days or Times
• Gender (Males only, Females only, or both)

Groups

A group within Overseer is a named collection of adults, children, families and/or organizations.  It may represent any convenient group within the local school or school community (e.g. “School Band” or “Volunteers for lunch-room duty”).

When used with filters and constraints, one or more groups may be combined in complex ways to enable rapid selection of persons, families or organizations based on criteria for inclusion or exclusion to meet fairly advanced selection criteria, ending up with a list of names which could be printed as a titled report for some custom purpose.

Members may also be added to a group manually, so that precise selections of persons, families or organizations may be made, and assigned to a group, then referenced by the appropriate filter (e.g. “Adults in group: Volunteers for lunch-room duty”) prior to viewing, editing or printing.

Download the Overseer Database Overview for additional information about the filters and constraints available for various entities managed by Overseer.