NYC Information Ordering and Visualization 5 — Questions and Answers
Question 1: A city department tracks monthly service requests using a dual-axis chart: bars show total requests (left axis) and a line shows average resolution days (right axis). In June, the bars are the tallest but the line is at its lowest point. What can be concluded?
- June had the most requests and the slowest resolution time
- June had the most requests and the fastest resolution time (Correct answer)
- June had the fewest requests but the most resolution days
- The chart is inconsistent and the data should be re-verified
Correct answer: June had the most requests and the fastest resolution time
The tallest bars mean highest request volume, and the lowest line means fewest average resolution days — both extremes in June indicate high volume handled quickly.
Question 2: An employee must sort the following mixed list in the order: symbols first, then numbers, then letters — all ascending within each group. List: B, 3, #, A, 1, @. What is the correct order?
- #, @, 1, 3, A, B (Correct answer)
- @, #, 1, 3, A, B
- #, @, 3, 1, B, A
- 1, 3, #, @, A, B
Correct answer: #, @, 1, 3, A, B
Symbols ascending (# before @), then numbers ascending (1, 3), then letters ascending (A, B).
Question 3: A Gantt chart is used in a city construction project. What specific type of information does a Gantt chart most effectively communicate?
- The budget breakdown for each project phase
- The overlap and duration of project tasks over time (Correct answer)
- The organizational hierarchy of the project team
- The geographic boundaries of the construction zone
Correct answer: The overlap and duration of project tasks over time
Gantt charts are specifically designed to show task durations and scheduling overlaps across a project timeline.
Question 4: A clerk notices that in a sorted alphabetical list, the name 'MacDonald' appears after 'Mabry' but before 'Madison.' Is this placement correct?
- Yes, because 'Mac' sorts as written, placing it between 'Mab' and 'Mad' (Correct answer)
- No, 'MacDonald' should be filed as 'Mc' and placed after all 'Ma' names
- No, 'MacDonald' should be filed under 'D' for Donald
- Yes, but only if the department follows a numeric-first rule
Correct answer: Yes, because 'Mac' sorts as written, placing it between 'Mab' and 'Mad'
Under standard letter-by-letter alphabetizing, 'Mac' is sorted exactly as written — M-A-C — which places it between 'Mab' and 'Mad.'
Question 5: A heat map of NYC 311 complaints displays borough neighborhoods colored from light yellow (few complaints) to dark red (many complaints). A supervisor notices that three neighborhoods in Brooklyn appear dark red. What action is most directly supported by this visualization?
- Redrawing the map using a bar chart for better accuracy
- Targeting those three Brooklyn neighborhoods for increased service or investigation (Correct answer)
- Concluding that all Brooklyn neighborhoods have high complaint rates
- Archiving the map because the color scale is subjective
Correct answer: Targeting those three Brooklyn neighborhoods for increased service or investigation
Heat maps highlight geographic hotspots, directly indicating where resources or attention should be concentrated.
Question 6: A form requires an employee to enter dates in MM/DD/YYYY format. An employee submits '8/5/26' for August 5, 2026. What is wrong with this entry?
- The month should be written as 'August' not '8'
- The month and day are not zero-padded, and the year is abbreviated (Correct answer)
- The day and month are transposed
- Nothing is wrong; '8/5/26' is an acceptable format
Correct answer: The month and day are not zero-padded, and the year is abbreviated
The required format MM/DD/YYYY needs two-digit month (08), two-digit day (05), and four-digit year (2026), making the correct entry 08/05/2026.
Question 7: An analyst compares two precincts using side-by-side bar charts over 12 months. Precinct A's bars are consistently taller than Precinct B's. In October, Precinct B's bar is taller. What is the MOST appropriate interpretation?
- Precinct B is now permanently outperforming Precinct A
- October represents an anomaly for Precinct B that warrants further investigation (Correct answer)
- The charts must be combined into a single chart to be meaningful
- Precinct A's data for October is missing and should be re-entered
Correct answer: October represents an anomaly for Precinct B that warrants further investigation
A single reversal in an otherwise consistent pattern is an anomaly that should be investigated before drawing lasting conclusions.
NYC Information Ordering and Visualization 5
A city department tracks monthly service requests using a dual-axis chart: bars show total requests (left axis) and a line shows average resolution days (right axis).
In June, the bars are the tallest but the line is at its lowest point.
What can be concluded?