Department evaluation guide

Take combined results into a spreadsheet

Public evaluation · Current availability

Authorized department staff can download combined CSV files from their reporting workspace. A CSV is a plain-text table that most spreadsheet tools can read. This guide is public; department downloads require an authorized account.

Download an example file

This teaching file has all 92 columns and 14 example rows. It combines sample programs, scopes, and periods to show the format. It is invented, not measured activity. Actual files depend on the selected program and report. A file with suppressed results may contain only a privacy notice.

Download Demonstration CSV

Every row is labeled as invented demonstration data. There are no participant records. Use it to inspect the structure, not to report department performance or assume compatibility with your software.

What a file looks like

Invented example for explanation only. This excerpt uses a subset of the actual columns. It is not measured activity or an official report. A full file includes the fields listed below; different programs produce different row types.

record_type,program_id,period_start,period_end,topic,starts,completions,responses,correct,sample_status
summary,knowledge,2026-10-01,2026-10-07,,100,75,750,600,
daily_trend,knowledge,2026-10-01,2026-10-07,,30,20,200,160,Recorded result
topic,knowledge,2026-10-01,2026-10-07,Smoke Alarms,,,100,80,Recorded result
question,knowledge,2026-10-01,2026-10-07,Smoke Alarms,,,30,24,Recorded result

What each row represents

For activity reporting, quiz attempts can finish within 2 hours, other games within 4 hours total, and Home Safety Survey sessions within 30 days. Finishes are attributed to the original start date and QR code or link. Recent starts may still be in progress.

Row type	Meaning
`privacy_notice`	Explains suppression when small-sample results cannot be provided.
`data_quality_notice`	Explains limitations in historical activity.
`summary`	Program and scope totals.
`daily_trend`	Activity grouped by reporting day.
`campaign`	Activity attributed to an approved campaign.
`survey_topic_status`	Survey responses grouped by topic and guidance status.
`survey_answer_distribution`	Combined selections for each survey answer option.
`difficulty`	Quiz outcomes grouped by learning path or difficulty.
`topic`	Quiz answers grouped by topic.
`question`	Question wording and combined answer-option performance.
`scenario_aggregate`	Combined scenario events, actions, outcomes, timing, and interaction context.
`usage`	Named aggregate program-usage measures.

Importing and interpreting the file

Files use UTF-8 text, comma-separated columns, and quoted values. Spreadsheet-sensitive text is escaped to prevent formula execution.
Filter by program, scope, period, and row type before you calculate totals. Summary, daily, and topic rows can describe the same activity. Adding them together would count it more than once.
Blank cells can mean not applicable, unavailable, a zero denominator, or privacy suppression. Read the row type, sample status, and notices. Do not replace every blank with zero.
Aggregate exports do not contain participant names, contact information, browser identifiers, or individual response histories. Question wording and combined answer counts can be included.
Your IT team must check field mapping and import support in your department’s software. A downloadable CSV does not establish a direct system integration.

Field reference

Columns below follow the current exporter’s order. Fields only populated by a particular program or row type remain blank elsewhere. Timing totals use milliseconds; count fields describe recorded observations.

Field	Definition
`record_type`	The kind of aggregate row; see the list below.
`data_classification`	Department aggregate data or demonstration-only classification.
`program_id`	Canonical program identifier.
`program_name`	Program display name.
`game_id`	Activity package identifier.
`program_model`	Program model, such as quiz, survey, or scenario.
`program_status`	Program release status carried by the report.
`analytics_contract_version`	Version of the program’s analytics contract.
`period_start`	First date of the reporting period, YYYY-MM-DD.
`period_end`	Last date of the reporting period, YYYY-MM-DD.
`scope`	The reporting scope carried by the selected report.
`date`	Date of a daily trend row, YYYY-MM-DD.
`name`	Row label: department, campaign, topic, question, or notice, depending on row type.
`topic`	Topic identifier or label for the row.
`question_id`	Question identifier in the maintained bank.
`difficulty`	Recorded question difficulty or learning-path label.
`question_text`	Full wording of the reported question.
`correct_answer`	Correct answer text for a quiz question; not a survey judgment.
`page_views`	Recorded page-view count.
`estimated_devices`	Department-scoped browser-profile estimate, not a count of identified people.
`sessions`	Recorded session count.
`loads`	Recorded game-load count.
`starts`	Recorded activity-start count.
`completions`	Recorded completion count.
`completion_rate_percent`	Completions ÷ starts × 100; blank when no denominator is available.
`passes`	Recorded passing quiz outcomes.
`not_passed`	Recorded nonpassing quiz outcomes.
`pass_rate_percent`	Passes ÷ (passes + not_passed) × 100.
`presented`	Recorded question-presentation count.
`responses`	Recorded answer total; interpretation varies by program model.
`correct`	Recorded correct quiz answers; blank for survey summaries.
`incorrect`	Recorded missed quiz answers; blank for survey summaries.
`correct_rate_percent`	Correct ÷ quiz responses × 100; not a survey score.
`option_1_text`	Text of the numbered quiz answer choice.
`option_1_selections`	Aggregate count selecting the numbered quiz answer choice.
`option_2_text`	Text of the numbered quiz answer choice.
`option_2_selections`	Aggregate count selecting the numbered quiz answer choice.
`option_3_text`	Text of the numbered quiz answer choice.
`option_3_selections`	Aggregate count selecting the numbered quiz answer choice.
`average_response_seconds`	Average recorded question-response duration in seconds; narration can affect timing.
`average_score_out_of_10`	Average recorded quiz score out of ten, when available.
`response_code`	Structured survey answer code.
`response_label`	Human-readable survey answer label.
`guidance_status`	Educational survey guidance classification; not inspection compliance.
`response_count`	Aggregate count for a structured survey answer or guidance status.
`event_type`	Scenario event category.
`scenario_id`	Scenario identifier.
`step_id`	Scenario step identifier.
`category`	Scenario category carried by the aggregate.
`event_count`	Aggregate observation count for event; the applicable row and program determine its scope.
`success_count`	Aggregate observation count for success; the applicable row and program determine its scope.
`safe_outcome_count`	Aggregate observation count for safe outcome; the applicable row and program determine its scope.
`first_attempt_success_count`	Aggregate observation count for first attempt success; the applicable row and program determine its scope.
`attempts_total`	Cumulative aggregate total for attempts; not a participant-level record.
`retries_total`	Cumulative aggregate total for retries; not a participant-level record.
`help_opens_total`	Cumulative aggregate total for help opens; not a participant-level record.
`elapsed_ms_total`	Sum of recorded durations in milliseconds; divide by the matching count to calculate a mean.
`elapsed_count`	Aggregate observation count for elapsed; the applicable row and program determine its scope.
`response_time_ms_total`	Sum of recorded durations in milliseconds; divide by the matching count to calculate a mean.
`response_time_count`	Aggregate observation count for response time; the applicable row and program determine its scope.
`effective_ms_total`	Sum of recorded durations in milliseconds; divide by the matching count to calculate a mean.
`suboptimal_ms_total`	Sum of recorded durations in milliseconds; divide by the matching count to calculate a mean.
`ineffective_ms_total`	Sum of recorded durations in milliseconds; divide by the matching count to calculate a mean.
`completed_scenarios_total`	Cumulative aggregate total for completed scenarios; not a participant-level record.
`keyboard_count`	Aggregate observation count for keyboard; the applicable row and program determine its scope.
`pointer_count`	Aggregate observation count for pointer; the applicable row and program determine its scope.
`touch_count`	Aggregate observation count for touch; the applicable row and program determine its scope.
`experience_completed_count`	Aggregate observation count for experience completed; the applicable row and program determine its scope.
`pass_practice_completed_count`	Aggregate observation count for pass practice completed; the applicable row and program determine its scope.
`guided_pass_completed_count`	Aggregate observation count for guided pass completed; the applicable row and program determine its scope.
`final_pass_completed_count`	Aggregate observation count for final pass completed; the applicable row and program determine its scope.
`full_sequence_completed_count`	Aggregate observation count for full sequence completed; the applicable row and program determine its scope.
`use_extinguisher_count`	Aggregate observation count for use extinguisher; the applicable row and program determine its scope.
`evacuate_count`	Aggregate observation count for evacuate; the applicable row and program determine its scope.
`use_lid_count`	Aggregate observation count for use lid; the applicable row and program determine its scope.
`coverage_segments_total`	Cumulative aggregate total for coverage segments; not a participant-level record.
`coverage_segments_count`	Aggregate observation count for coverage segments; the applicable row and program determine its scope.
`capacity_used_percent_total`	Cumulative aggregate total for capacity used percent; not a participant-level record.
`capacity_used_percent_count`	Aggregate observation count for capacity used percent; the applicable row and program determine its scope.
`portrait_count`	Aggregate observation count for portrait; the applicable row and program determine its scope.
`landscape_count`	Aggregate observation count for landscape; the applicable row and program determine its scope.
`extra_small_viewport_count`	Aggregate observation count for extra small viewport; the applicable row and program determine its scope.
`small_viewport_count`	Aggregate observation count for small viewport; the applicable row and program determine its scope.
`medium_viewport_count`	Aggregate observation count for medium viewport; the applicable row and program determine its scope.
`large_viewport_count`	Aggregate observation count for large viewport; the applicable row and program determine its scope.
`setting_enabled_count`	Aggregate observation count for setting enabled; the applicable row and program determine its scope.
`setting_disabled_count`	Aggregate observation count for setting disabled; the applicable row and program determine its scope.
`metric_name`	Name of an aggregate usage measure.
`metric_value`	Value of the named usage measure.
`unit`	Unit for the named usage measure.
`sample_status`	Small-sample status for the applicable row; preserve this when importing.
`notes`	Privacy, classification, timing, or data-quality explanation.

Read privacy thresholds and reporting limits · Understand available and future integration options

Basic compatibility for IT review

A2C3 runs in a browser; residents do not need to install a mobile app. Programs support compatible modern browsers on phones, tablets, and computers, with program-specific input and orientation limitations described on the Accessibility page. Hosting geography and any contractual data-residency requirement should be confirmed during department review before approval.

Review accessibility features and limitations