SEE
THINK
EXPLORE
MARVEL
🔒

Facilitator Access Only

These notes are for course facilitators and research team members only.

📊 Research Data Collection — Google Sheets Overview

The research spreadsheet has 13 tabs. Every tab includes the full 10-field student identity block (matric, name, gender, age, mykid, home_state, class, school_code, phone, email) so data from any tab can be analysed independently or joined by matric number.

TabTriggered byKey columns (beyond identity)
Student_RegRegistration form submissionregistered_at
Pre_TestPre-test survey completiontest_type, submitted_iso, score, Q1–Q50
Post_TestPost-test survey completiontest_type, submitted_iso, score, Q1–Q50
Act_1–Act_10Each step's activity page submissionstep, submitted_iso, cal_confidence, cal_predicted, cal_reflection, t1_score_pct, t2_attempts, refl2_text, t3_attempts, t4_attempts, concept_q1–q5, concept_score_pct, concept_passed, concept_attempts, jr1–jr5, post_confidence, post_actual, post_r1, post_r2, calibration_index
⚠️

Before collecting real data: run clearAllDataSheets() in the Google Apps Script editor to wipe any test rows and reset all 13 tabs. Headers are recreated automatically on the first live submission.