Ocean Protector Game Analytics

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	ID_User	ID_Generated	Playthrough_Count	Stage_Key	Substage_Key	Substage_String	Character_Role	Duration (s)	# Completed Decisions	# Best Decisions	Current_Score_Percent	Choice_String	Final_Outcome	Time_Stamp

2	0	426980	1	s01_new_information_start	user_lesson_01	intro_statement	not_yet_selected	15.81	0	0			FALSE	8/27/2023 16:04:29
3	0	426980	1	s01_new_information_start	user_lesson_04	intro_humans	not_yet_selected	27.88	0	0			FALSE	8/27/2023 16:06:33
4	0	426980	1	s01_new_information_start	user_lesson_06	oceans_are_good	not_yet_selected	10.62	0	0			FALSE	8/27/2023 16:06:55
5	0	426980	1	s01_new_information_start	user_lesson_07	OA_intro	not_yet_selected	29.78	0	0			FALSE	8/27/2023 16:07:25
6	0	426980	1	s01_new_information_start	user_lesson_08	CO2_intro	not_yet_selected	5.41	0	0			FALSE	8/27/2023 16:07:31
7	0	426980	1	s01_new_information_start	user_lesson_09	ocean_absorb_CO2	not_yet_selected	9.35	0	0			FALSE	8/27/2023 16:07:40
8	0	426980	1	s01_new_information_start	user_lesson_10a	nutrient_oa_intro	not_yet_selected	9.00	0	0			FALSE	8/27/2023 16:07:49
9	0	426980	1	s01_new_information_start	user_lesson_11	nutrient_runoff	not_yet_selected	6.91	0	0			FALSE	8/27/2023 16:07:56
10	0	426980	1	s01_new_information_start	user_lesson_12	algal_bloom	not_yet_selected	7.86	0	0			FALSE	8/27/2023 16:08:04
11	0	426980	1	s01_new_information_start	user_lesson_13	oa_history_intro	not_yet_selected	7.63	0	0			FALSE	8/27/2023 16:08:11
12	0	426980	1	s01_new_information_start	user_lesson_14	pH_scale	not_yet_selected	34.79	0	0			FALSE	8/27/2023 16:08:46
13	0	426980	1	s01_new_information_start	user_lesson_15a	pH_intro	not_yet_selected	3.71	0	0			FALSE	8/27/2023 16:08:50
14	0	426980	1	s01_new_information_start	user_lesson_15c	pH_history	not_yet_selected	42.42	0	0			FALSE	8/27/2023 16:09:41
15	0	426980	1	s01_new_information_start	user_lesson_16a	oa_affects_intro	not_yet_selected	30.39	0	0			FALSE	8/27/2023 16:10:11
16	0	426980	1	s01_new_information_start	user_lesson_18	recap_prep	not_yet_selected	53.59	0	0			FALSE	8/27/2023 16:12:22
17	0	426980	1	s02_decisions_quiz	decision_quiz_01	fossil_fuels	not_yet_selected	6.79	0	0		carbon_dioxide	FALSE	8/27/2023 16:12:29
18	0	426980	1	s02_decisions_quiz	decision_quiz_02	CO2_to_OA	not_yet_selected	17.98	0	0		TRUE	FALSE	8/27/2023 16:13:24
19	0	426980	1	s02_decisions_quiz	decision_quiz_03	other_OA_cause	not_yet_selected	9.78	0	0		excess_noise	FALSE	8/27/2023 16:13:34
20	0	426980	1	s02_decisions_quiz	decision_quiz_03	other_OA_cause	not_yet_selected	24.07	0	0		excess_nutrients	FALSE	8/27/2023 16:13:58
21	0	426980	1	s02_decisions_quiz	decision_quiz_04	lower_pH_equals	not_yet_selected	5.21	0	0		less_acidic	FALSE	8/27/2023 16:14:03
22	0	426980	1	s02_decisions_quiz	decision_quiz_04	lower_pH_equals	not_yet_selected	6.94	0	0		more_acidic	FALSE	8/27/2023 16:14:10
23	0	426980	1	s02_decisions_quiz	decision_quiz_05	oa_harms_who	not_yet_selected	8.92	0	0		all_major_life	FALSE	8/27/2023 16:14:19
24	0	426980	1	s02_decisions_quiz	decision_quiz_06	can_reduce_OA	not_yet_selected	5.66	0	0		TRUE	FALSE	8/27/2023 16:14:25
25	0	426980	1	s03_new_information_middle	user_lesson_19	review_summary	not_yet_selected	4.84	0	0			FALSE	8/27/2023 16:14:29
26	0	426980	1	s03_new_information_middle	user_lesson_20	role_prep	not_yet_selected	4.17	0	0			FALSE	8/27/2023 16:14:34
27	0	426980	1	s04_decisions_character_choose	decision_character_01	choose_character	role_captain	12.09	0	0		choose_captain	FALSE	8/27/2023 16:14:46
28	0	426980	1	s05_decisions_character_role	decision_role_01a	personal_boat	role_captain	15.54	1	1	100.00%	less_fuel	FALSE	8/27/2023 16:15:02
29	0	426980	1	s05_decisions_character_role	decision_role_01d	review_choice_outcome	role_captain	7.30	1	1	100.00%		FALSE	8/27/2023 16:15:46
30	0	426980	1	s05_decisions_character_role	decision_role_02a	phytoplankton_choice	role_captain	19.20	2	1	50.00%	no_change	FALSE	8/27/2023 16:16:05
31	0	426980	1	s05_decisions_character_role	decision_role_02d	review_choice_outcome	role_captain	1.45	2	1	50.00%		FALSE	8/27/2023 16:16:25
32	0	426980	1	s05_decisions_character_role	decision_role_03a	personal_waste	role_captain	16.13	3	2	66.67%	landfill	FALSE	8/27/2023 16:16:41
33	0	426980	1	s05_decisions_character_role	decision_role_03d	review_choice_outcome	role_captain	1.89	3	2	66.67%		FALSE	8/27/2023 16:17:10
34	0	426980	1	s05_decisions_character_role	decision_role_04a	coral_reefs	role_captain	23.81	4	2	50.00%	artificial_barieers	FALSE	8/27/2023 16:17:34
35	0	426980	1	s05_decisions_character_role	decision_role_04d	review_choice_outcome	role_captain	1.45	4	2	50.00%		FALSE	8/27/2023 16:18:22
36	0	426980	1	s05_decisions_character_role	decision_role_05a	city_money_1	role_captain	115.89	5	3	60.00%	less_exhaust	FALSE	8/27/2023 16:20:18
37	0	426980	1	s05_decisions_character_role	decision_role_05d	review_choice_outcome	role_captain	1.35	5	3	60.00%		FALSE	8/27/2023 16:21:13
38	0	426980	1	s05_decisions_character_role	decision_role_06a	farmers	role_captain	15.81	6	4	66.67%	renewables_upgrade	FALSE	8/27/2023 16:21:29
39	0	426980	1	s05_decisions_character_role	decision_role_06d	review_choice_outcome	role_captain	0.77	6	4	66.67%		FALSE	8/27/2023 16:21:50
40	0	426980	1	s05_decisions_character_role	decision_role_07a	community_water	role_captain	9.98	7	5	71.43%	conserve_water	FALSE	8/27/2023 16:22:00
41	0	426980	1	s05_decisions_character_role	decision_role_07d	review_choice_outcome	role_captain	0.88	7	5	71.43%		FALSE	8/27/2023 16:22:27
42	0	426980	1	s05_decisions_character_role	decision_role_08a	city_money_2	role_captain	5.84	8	6	75.00%	sell_local	FALSE	8/27/2023 16:22:33
43	0	426980	1	s05_decisions_character_role	decision_role_08d	review_choice_outcome	role_captain	1.45	8	6	75.00%		FALSE	8/27/2023 16:22:55
44	0	426980	1	s05_decisions_character_role	decision_role_09a	community_transportation	role_captain	7.43	9	7	77.78%	carpool	FALSE	8/27/2023 16:23:03
45	0	426980	1	s05_decisions_character_role	decision_role_09d	review_choice_outcome	role_captain	0.74	9	7	77.78%		TRUE	8/27/2023 16:23:26
46	0	426980	1	s06_new_information_end	user_lesson_21a	review_final_debrief	role_captain	4.11	9	7	77.78%		FALSE	8/27/2023 16:23:31
47	0	426980	1	s06_new_information_end	user_lesson_21b	review_reminder	role_captain	1.22	9	7	77.78%		FALSE	8/27/2023 16:23:32
48	0	426980	1	s06_new_information_end	user_lesson_22	end_game_option	role_captain	12.19	9	7	77.78%	review_outcomes	FALSE	8/27/2023 16:23:44
49	0	426980	1	s06_new_information_end	user_lesson_22	end_game_option	role_captain	8.35	9	7	77.78%	go_to_NOAA	FALSE	8/27/2023 16:23:52
50	0	426980	1	s06_new_information_end	user_lesson_22	end_game_option	role_captain	2.35	9	7	77.78%	replay_game_start	FALSE	8/27/2023 16:23:54
51	0	426980	2	s01_new_information_start	user_lesson_18	recap_prep	not_yet_selected	1.00	0	0			FALSE	8/27/2023 16:24:00
52	0	426980	2	s02_decisions_quiz	decision_quiz_01	fossil_fuels	not_yet_selected	3.62	0	0		carbon_dioxide	FALSE	8/27/2023 16:24:03
53	0	426980	2	s02_decisions_quiz	decision_quiz_02	CO2_to_OA	not_yet_selected	2.72	0	0		TRUE	FALSE	8/27/2023 16:24:06
54	0	426980	2	s02_decisions_quiz	decision_quiz_03	other_OA_cause	not_yet_selected	2.62	0	0		excess_nutrients	FALSE	8/27/2023 16:24:09
55	0	426980	2	s02_decisions_quiz	decision_quiz_04	lower_pH_equals	not_yet_selected	4.67	0	0		more_acidic	FALSE	8/27/2023 16:24:13
56	0	426980	2	s02_decisions_quiz	decision_quiz_05	oa_harms_who	not_yet_selected	2.99	0	0		all_major_life	FALSE	8/27/2023 16:24:16
57	0	426980	2	s02_decisions_quiz	decision_quiz_06	can_reduce_OA	not_yet_selected	2.74	0	0		TRUE	FALSE	8/27/2023 16:24:19
58	0	426980	2	s03_new_information_middle	user_lesson_19	review_summary	not_yet_selected	1.23	0	0			FALSE	8/27/2023 16:24:20
59	0	426980	2	s03_new_information_middle	user_lesson_20	role_prep	not_yet_selected	0.60	0	0			FALSE	8/27/2023 16:24:21
60	0	426980	2	s04_decisions_character_choose	decision_character_01	choose_character	role_guide	9.67	0	0		choose_guide	FALSE	8/27/2023 16:24:31
61	0	426980	2	s05_decisions_character_role	decision_role_01a	personal_boat	role_guide	12.05	1	0	0.00%	no_change	FALSE	8/27/2023 16:24:43
62	0	426980	2	s05_decisions_character_role	decision_role_01d	review_choice_outcome	role_guide	1.62	1	0	0.00%		FALSE	8/27/2023 16:26:11
63	0	426980	2	s05_decisions_character_role	decision_role_02a	phytoplankton_choice	role_guide	9.85	2	0	0.00%	artificial_nets	FALSE	8/27/2023 16:26:21
64	0	426980	2	s05_decisions_character_role	decision_role_02d	review_choice_outcome	role_guide	1.69	2	0	0.00%		FALSE	8/27/2023 16:27:01
65	0	426980	2	s05_decisions_character_role	decision_role_03a	personal_waste	role_guide	41.62	3	0	0.00%	burning	FALSE	8/27/2023 16:27:42
66	0	426980	2	s05_decisions_character_role	decision_role_03d	review_choice_outcome	role_guide	1.74	3	0	0.00%		FALSE	8/27/2023 16:28:26
67	0	426980	2	s05_decisions_character_role	decision_role_04a	coral_reefs	role_guide	5.78	4	0	0.00%	artificial_barieers	FALSE	8/27/2023 16:28:32
68	0	426980	2	s05_decisions_character_role	decision_role_04d	review_choice_outcome	role_guide	1.47	4	0	0.00%		FALSE	8/27/2023 16:29:19
69	0	426980	2	s05_decisions_character_role	decision_role_05a	city_money_1	role_guide	11.24	5	0	0.00%	parking_lots	FALSE	8/27/2023 16:29:30
70	0	426980	2	s05_decisions_character_role	decision_role_05d	review_choice_outcome	role_guide	1.25	5	0	0.00%		FALSE	8/27/2023 16:30:30
71	0	426980	2	s05_decisions_character_role	decision_role_06a	farmers	role_guide	7.80	6	0	0.00%	more_tractors	FALSE	8/27/2023 16:30:38
72	0	426980	2	s05_decisions_character_role	decision_role_06d	review_choice_outcome	role_guide	0.22	6	0	0.00%		FALSE	8/27/2023 16:31:09
73	0	426980	2	s05_decisions_character_role	decision_role_07a	community_water	role_guide	12.72	7	0	0.00%	more_energy	FALSE	8/27/2023 16:31:21
74	0	426980	2	s05_decisions_character_role	decision_role_07d	review_choice_outcome	role_guide	0.87	7	0	0.00%		FALSE	8/27/2023 16:32:12
75	0	426980	2	s05_decisions_character_role	decision_role_08a	city_money_2	role_guide	7.71	8	0	0.00%	sell_far	FALSE	8/27/2023 16:32:20
76	0	426980	2	s05_decisions_character_role	decision_role_08d	review_choice_outcome	role_guide	1.15	8	0	0.00%		FALSE	8/27/2023 16:32:49
77	0	426980	2	s05_decisions_character_role	decision_role_09a	community_transportation	role_guide	7.95	9	0	0.00%	more_taxis	FALSE	8/27/2023 16:32:57
78	0	426980	2	s05_decisions_character_role	decision_role_09d	review_choice_outcome	role_guide	1.00	9	0	0.00%		TRUE	8/27/2023 16:33:17
79	0	426980	2	s06_new_information_end	user_lesson_21a	review_final_debrief	role_guide	29.62	9	0	0.00%		FALSE	8/27/2023 16:33:46
80	0	426980	2	s06_new_information_end	user_lesson_21b	review_reminder	role_guide	1.54	9	0	0.00%		FALSE	8/27/2023 16:33:48
81	0	426980	2	s06_new_information_end	user_lesson_22	end_game_option	role_guide	2.27	9	0	0.00%	replay_game_start	FALSE	8/27/2023 16:33:50
82	0	426980	3	s01_new_information_start	user_lesson_18	recap_prep	not_yet_selected	0.70	0	0			FALSE	8/27/2023 16:33:53
83	0	426980	3	s02_decisions_quiz	decision_quiz_01	fossil_fuels	not_yet_selected	2.52	0	0		carbon_dioxide	FALSE	8/27/2023 16:33:55
84	0	426980	3	s02_decisions_quiz	decision_quiz_02	CO2_to_OA	not_yet_selected	2.44	0	0		TRUE	FALSE	8/27/2023 16:33:58
85	0	426980	3	s02_decisions_quiz	decision_quiz_03	other_OA_cause	not_yet_selected	2.22	0	0		excess_nutrients	FALSE	8/27/2023 16:34:00
86	0	426980	3	s02_decisions_quiz	decision_quiz_04	lower_pH_equals	not_yet_selected	3.27	0	0		more_acidic	FALSE	8/27/2023 16:34:03
87	0	426980	3	s02_decisions_quiz	decision_quiz_05	oa_harms_who	not_yet_selected	2.67	0	0		all_major_life	FALSE	8/27/2023 16:34:06
88	0	426980	3	s02_decisions_quiz	decision_quiz_06	can_reduce_OA	not_yet_selected	1.95	0	0		TRUE	FALSE	8/27/2023 16:34:08
89	0	426980	3	s03_new_information_middle	user_lesson_19	review_summary	not_yet_selected	1.186000109	0	0			FALSE	8/27/2023 16:34:09
90	0	426980	3	s03_new_information_middle	user_lesson_20	role_prep	not_yet_selected	0.6840000153	0	0			FALSE	8/27/2023 16:34:10
91	0	426980	3	s04_decisions_character_choose	decision_character_01	choose_character	role_ranger	2.905999899	0	0		choose_ranger	FALSE	8/27/2023 16:34:13
92	0	426980	3	s05_decisions_character_role	decision_role_01a	personal_boat	role_ranger	6.243999958	1	1	100.00%	less_fuel	FALSE	8/27/2023 16:34:20
93	0	426980	3	s05_decisions_character_role	decision_role_01a	personal_boat	role_ranger	11.03500009	1	1	100.00%	less_fuel	FALSE	8/27/2023 16:34:48
94	0	426980	3	s05_decisions_character_role	decision_role_01d	review_choice_outcome	role_ranger	0.7509999275	1	1	100.00%		FALSE	8/27/2023 16:35:09
95	0	426980	3	s05_decisions_character_role	decision_role_02a	phytoplankton_choice	role_ranger	10.70000005	2	2	100.00%	help_fish	FALSE	8/27/2023 16:35:20
96	0	426980	3	s05_decisions_character_role	decision_role_02d	review_choice_outcome	role_ranger	0.7019999027	2	2	100.00%		FALSE	8/27/2023 16:35:39
97	0	426980	3	s05_decisions_character_role	decision_role_03a	personal_waste	role_ranger	5.960000038	3	3	100.00%	landfill	FALSE	8/27/2023 16:35:45
98	0	426980	3	s05_decisions_character_role	decision_role_03d	review_choice_outcome	role_ranger	0.8349997997	3	3	100.00%		FALSE	8/27/2023 16:36:07
99	0	426980	3	s05_decisions_character_role	decision_role_04a	coral_reefs	role_ranger	12.03800011	4	4	100.00%	protect	FALSE	8/27/2023 16:36:20
100	0	426980	3	s05_decisions_character_role	decision_role_04d	review_choice_outcome	role_ranger	0.8849999905	4	4	100.00%		FALSE	8/27/2023 16:36:51