Aeries

If you are new to Aeries and would like to understand queries or it you would like a refresher, these videos will add value to the time spent watching and the productivity when returning to your task.

• Query Fields and Functions Overview (Length - 12:49)
  • Query Overview
    • Layout of Query Screen (0:48)
    • How Queries Are Built (1:31)
    • Printing a Query (8:25)
    • Modifying an Existing Query (9:58)
    • Spend a Query to a Spreadsheet (11:14)

• Query Fields and Functions (Length - 20:30)
  • Query Fields and Functions
    • Overview of Fields and Function (0:01)
    • Review of fields (18:58)

• Query Sorting (Length - 13:30)
  • Help line (1:05)
  • Simple Sort by fields (1:10)
  • Sort with group by fields (3:15) ex: list students with all 2nd graders, then all 3rd graders
  • Run report (4:15)
  • Run report with page break by groups fields (5:22)
  • Run report with title and header (8:15)
  • Run report by field in descending (reverse) sort order (9:15)
  • Diff between CS and web versions of Aeries sorts (12:32)

• Query Multiple Sorting (Length - 13:07)
  • Sorting by with multiple fields (0:21)
  • Sorting with 2 groupings (1:58) ex: sort by all 2nd grade females, then 2nd grade males, then 3rd, etc
  • Change order of sorting/grouping (5:40)
  • Sort groups by descending (reverse) sort order (6:48)
  • Sort within multiple groups by descending (reverse) sort order (8:36)
  • Run report (11:51)

• Query Simple Conditions (Length - 13:34)
  • Purpose (0:19)
  • Sequence (1:15)
  • Components (2:00)
  • Component Constant (3:39)
  • Comparison (4:25)
  • Does not equal (6:25)
  • Contains (8:00)
  • Does not contain (9:10)
  • Help Line query reminder (11:12)

• Query Multiple Conditions (Length - 7:26)
  • Purpose (0:20)
  • Linking (0:40)
  • Setting up Query and Adding conditions (0:55)
  • Adding a second condition (1:45)
  • “AND” Inclusive Condition (2:20)
  • “OR” Exclusive Condition (3:07)
  • Error (3:25)
  • Inclusive vs. Exclusive (4:47)
  • Complete Conditions (5:43)

• Query Complex Conditions (Length - 8:39)
  • Query Complex Conditions (AKA If/And/Or Statements)
    • If statements 
    • And statements 
    • Or statements (1:03)
    • Parentheses (4:46)
    • Keep statement (6:40)
    • Keep/Skip history (8: 01)