1. Parent/Guardian Questionnaire (19 questions across 5 sections)
2. Student Questionnaire (6 questions)

• Parent Questionnaire (P1-P19): All 19 questions across all 5 sections - demographics, medical history, diet (each of the 5 diet items as separate columns), lifestyle, physical development, and consent
• Student Questionnaire (S1-S6): All 6 questions including outdoor play, screen time, body changes, menarche, health notes, and assent

• Dropdown validation on all coded fields (1/0 for Yes/No, 1-5 for education, 1-4 for income, etc.)
• Age validation locks entries to 10-15 years
• Missing value codes: 9 for categorical fields, 99 for age/continuous fields
• The SPSS Syntax sheet gives you one-click variable labelling after import

1. Data Entry - Your main working sheet. Enter one row per student/participant. Has 200 pre-numbered rows with dropdown menus and input validation to reduce errors.
2. SPSS Codebook - Lists all 39 variables with their exact SPSS variable names, data types, value labels, and missing value codes. Use this as your reference.
3. Value Codes - A simple quick-reference card showing what number to enter for each answer (e.g. 1=Yes, 0=No, 1=Urban, 2=Semiurban, etc.). Keep this open on screen while entering data.
4. SPSS Syntax - Copy and paste this into the SPSS Syntax Editor after importing, and it will automatically assign all variable labels, value labels, and missing value codes.
5. Instructions - Step-by-step guide on how to enter data and how to export to SPSS.

1. Download the file and open in Excel
2. Go to the Data Entry sheet and start entering from row 4
3. When done, import into SPSS using File > Import Data > Excel
4. Paste the syntax from the SPSS Syntax sheet and run it

• Descriptive statistics for all variables
• Chi-square tests for each risk factor vs precocious puberty
• Odds ratios for risk factors
• Independent samples t-tests for continuous variables
• Binary logistic regression for independent predictors
• Pearson/Spearman correlations
• How to report each result correctly

• Column F (School Name) now has a dropdown with exactly these 3 options:
  • 1 - Benchmark International School, Manjeri
  • 2 - GHSS Girls Manjeri
  • 3 - GHSS Irumbuzhi
• The number prefix (1, 2, 3) makes it easy to code in SPSS - just note the first digit when entering into SPSS
• SPSS Codebook updated - School_Name now shows all 3 value labels
• Value Codes sheet updated - school codes added at the bottom
• SPSS Syntax updated - School_Name value labels included so SPSS will label them automatically after import

• Column G (Residence) is now fully automatic - you never need to type in it
• As soon as you select a school from the dropdown in column F, column G fills itself:

• Column G cells are coloured green so data entry staff know not to edit them manually
• The subtitle bar reminds users: "GREEN columns = auto-filled (do not edit manually)"
• Value Codes, SPSS Codebook, and Data Cleaning Checklist all updated to reflect this

• Column E (Grade/Standard) now has a dropdown with only 6, 7, 8, 9
• Any value outside these four will be rejected with an error message: "Only Standards 6, 7, 8 or 9 are allowed"
• SPSS Codebook updated - Grade now shows value labels 6=Standard 6, 7=Standard 7, 8=Standard 8, 9=Standard 9
• Value Codes sheet updated with the same
• Missing code remains 99 for Grade if not recorded

• Date of Entry column removed - the sheet now starts directly with ID, then Child Name
• Age (column C) is now a dropdown with only these options: 10, 11, 12, 13, 14, 15
• Any value outside this range is blocked with an error message
• SPSS Codebook updated - Date_Entry variable removed, Age updated to show dropdown values
• SPSS Syntax updated - Date_Entry label removed

• Residence (col F) now correctly reads from School (col E)
• Formula: =IF(E4="", "", IF(ISNUMBER(SEARCH("Irumbuzhi", E4)), 2, 1))

Sheet 1 - "Validation Report" (red tab)

• Status column turns GREEN when no issues
• AMBER for warnings/checks needed
• RED for errors requiring action

Sheet 2 - "Row Error Flags" (orange tab)