Study guide
6.2 Extracting, Sorting & Synthesizing Data
NYS Court Officer-Trainee Exam Study Guide Exam
Track your progress as you read
Finished sections get a check mark.
1 About the Exam & Study Plan
About the NYS Court Officer-Trainee Exam Exam Day Experience & Mental Prep Creating Your Custom Study Plan
2 Remembering Facts and Information
2.1 Incident Study Protocol & Memory Strategies 2.2 Retaining Physical Descriptions & Details 2.3 Memorizing Event Sequences & Spatial Layouts 2.4 Timelines and Numerical Detail Recall
3 Reading, Understanding & Interpreting Written Material
3.1 Identifying Main Ideas & Details in Passages 3.2 Interpreting Sequence in Procedural Texts 3.3 Courtroom Vocabulary-in-Context 3.4 Cloze-Style (Missing-Word) Passages
4 Applying Facts and Information to Given Situations
4.1 Rule-to-Scenario Mapping Principles 4.2 Applying Provided Policies: Worked Examples 4.3 Multi-Rule Scenarios & Constraint Stacking 4.4 Outside-Knowledge Traps & Distractors
5 Clerical Checking
5.1 Alphanumeric Checking Strategies & Pitfalls 5.2 Scanning & Comparison Techniques 5.3 Clerical Speed and Accuracy Drills
6 Court Record Keeping
6.1 Multi-Table Data Integration & Key Matching 6.2 Extracting, Sorting & Synthesizing Data 6.3 Compiling Reports & Finding Log Discrepancies
6.2 Extracting, Sorting & Synthesizing Data
Key Takeaways Explain This Topic AI
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.
Last updated: July 2026
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.