6.2 Extracting, Sorting & Synthesizing Data
Key Takeaways
- Filtering filters lists to include only data matching specific logic, where AND narrows results and OR expands them.
- Sorting requires ordering data chronologically, alphabetically, or numerically in either ascending or descending sequences.
- Chronological sorting has traps like PM/AM, where noon (12:00 PM) is midday and 12:30 PM is earlier than 1:00 PM.
- Multi-level sorting applies a primary sort first, and then uses a secondary sort to resolve ties within matching groups.
Extracting, Sorting & Synthesizing Data
Once court records are integrated, the next administrative step is to organize and extract subsets of data based on specific operational needs. In a courthouse, schedules change rapidly, and security officers must filter and re-sort lists to allocate personnel, prepare holding cells, and plan transport routes.
On the NYS Court Officer-Trainee Exam, you will be tested on your ability to apply conditional filtering rules and execute multi-level sorting routines on lists of court cases, defendants, or officers. Since you will not have access to computer software or calculators during the exam, you must master the manual techniques for processing these lists quickly and accurately.
Filtering Data Lists Using Conditional Logic
Filtering is the process of selecting only the records that meet a specified set of criteria, while excluding all others. On the exam, these criteria are defined using logical operators: AND, OR, and NOT.
1. The AND Operator (Intersection)
The AND operator requires that every listed condition is satisfied for a record to be selected.
- Example: "Filter for defendants who are 'In Custody' AND have a 'Felony' severity level."
- Result: Only records that meet both criteria are kept. This narrows your search and decreases the number of matching records.
2. The OR Operator (Union)
The OR operator requires that at least one of the listed conditions is satisfied.
- Example: "Filter for cases scheduled in 'Part 3A' OR presided over by 'Hon. J. Rivera'."
- Result: Any record that meets either condition (or both) is selected. This expands your search and increases the number of matching records.
3. The NOT Operator (Exclusion)
The NOT operator excludes any records that meet the specified condition.
- Example: "Filter for all cases where Custody Status is NOT 'In Custody'."
- Result: All records where the defendant is out on bail are kept.
Systematic Elimination Technique
Under exam pressure, do not try to filter the list mentally. Use your pencil to physically draw a line through rows that fail to meet the criteria on your test booklet (or note their IDs on scratch paper). For example, if a query requires Custody = In Custody, immediately scan that column and cross out all rows showing Out on Bail. This prevents you from accidentally extracting data from the wrong row in subsequent steps.
Sorting Data: Chronological, Alphabetical, and Numerical Rules
Sorting is the process of arranging data in a specific order. You must understand the precise conventions for ordering different types of data:
| Data Type | Ascending Order (Low to High / A to Z) | Descending Order (High to Low / Z to A) |
|---|---|---|
| Alphabetical | A, B, C ... Z (e.g., Adams, Brown, Chen) | Z, Y, X ... A (e.g., Chen, Brown, Adams) |
| Numerical | 1, 2, 3 ... 100 | 100 ... 3, 2, 1 |
| Chronological | Earliest time/date to Latest time/date | Latest time/date to Earliest time/date |
Chronological Sorting Traps: AM vs. PM
A common error on the exam involves sorting times when standard 12-hour formatting is used.
- The 12:00 PM Trap: In standard chronological order, 12:00 PM (noon) occurs after 11:59 AM, but 12:00 AM (midnight) starts the day. Furthermore, 12:30 PM is earlier than 1:00 PM.
- Correct Ascending Order: 09:30 AM -> 10:15 AM -> 11:00 AM -> 12:00 PM -> 12:30 PM -> 01:30 PM -> 02:15 PM.
- Always check the "AM" and "PM" designations carefully. Many candidates see "1:30" and sort it before "10:15" because the number 1 is smaller than 10, overlooking the AM/PM difference.
Multi-Level Sorting (Secondary Sorting)
In complex scenarios, you will be asked to sort a list using more than one field. This is known as multi-level sorting. The rules are applied sequentially:
- Primary Sort: Sort the entire list by the first specified field (e.g., Courtroom ascending).
- Secondary Sort: For any records that have the same value in the primary field, sort them by the second specified field (e.g., Hearing Time ascending).
- Tertiary Sort (if applicable): If records are still tied, sort them by the third field (e.g., Last Name alphabetical).
Case Study: Executing a Multi-Level Sort
Let's apply a multi-level sort to the unsorted daily docket below. Sort Criteria: Primary = Courtroom (Ascending); Secondary = Hearing Time (Ascending).
Unsorted Table 6.2A
| Case ID | Defendant Last Name | Courtroom | Hearing Time |
|---|---|---|---|
| Case-1 | Smith | Part 3A | 11:00 AM |
| Case-2 | Davis | Part 2B | 02:15 PM |
| Case-3 | Vance | Part 3A | 09:30 AM |
| Case-4 | Chen | Part 2B | 10:15 AM |
| Case-5 | Miller | Part 4C | 01:30 PM |
Step 1: Execute the Primary Sort (Courtroom Ascending)
First, group and order the rows by Courtroom. The alphabetical order of courtrooms is Part 2B, then Part 3A, then Part 4C.
- Part 2B Group: Case-2, Case-4
- Part 3A Group: Case-1, Case-3
- Part 4C Group: Case-5
Step 2: Execute the Secondary Sort (Hearing Time Ascending)
Now, look within each group and sort them chronologically by time.
- Within the Part 2B Group: Case-4 is at 10:15 AM and Case-2 is at 02:15 PM. Since 10:15 AM is earlier, the sorted order is:
- Case-4 (Chen - Part 2B - 10:15 AM)
- Case-2 (Davis - Part 2B - 02:15 PM)
- Within the Part 3A Group: Case-3 is at 09:30 AM and Case-1 is at 11:00 AM. Since 09:30 AM is earlier, the sorted order is: 3. Case-3 (Vance - Part 3A - 09:30 AM) 4. Case-1 (Smith - Part 3A - 11:00 AM)
- Within the Part 4C Group: Only Case-5 exists, so it remains in place: 5. Case-5 (Miller - Part 4C - 01:30 PM)
Final Sorted Table
- Case-4 (Chen)
- Case-2 (Davis)
- Case-3 (Vance)
- Case-1 (Smith)
- Case-5 (Miller)
Quick Elimination Strategy
On multiple-choice questions, you rarely need to sort the entire table. Focus on the extremes. Identify which record must be first and which must be last. Scan the options and eliminate any that do not place those specific records at the beginning or end. This strategy can save up to 45 seconds per question.
Using Table 6.2A, if the daily docket is sorted by Courtroom (Ascending) as the primary sort, and then by Defendant Last Name (Alphabetical, A-Z) as the secondary sort, who is the third defendant in the sorted list?
Using Table 6.1A, Table 6.1B, and Table 6.1C from Section 6.1, we want to find all defendants who meet the following filtering criteria: the defendant's case severity is 'Felony' AND the defendant's custody status is 'In Custody' AND the assigned transport officer is NOT 'Officer Ramirez'. Which defendant matches these criteria?