🏴 Vexillology Quiz Results
This repository contains data extracted from a Google Sheet tracking performance on world flags and U.S. state flags quizzes.
The dataset provides raw scores, aggregated country statistics, and U.S. state breakdowns — perfect for analytics, visualization, or improving your flag knowledge.
📁 File Overview
| File | Description | 
|---|---|
| Vexillology | Source spreadsheet containing all quiz data, structured across three sheets: Scores,Countries, andStates | 
🧾 Sheet Descriptions
1. 📊 Scores
Detailed results per country code, including correct and incorrect answers.
- Rows: 306
- Columns: 6
| Column | Description | 
|---|---|
| Code | ISO-style country code (e.g. adfor Andorra) | 
| Country | Full country name | 
| Correct | Number of correct identifications | 
| Incorrect | Number of incorrect guesses | 
| Total | Total attempts (Correct + Incorrect) | 
| Percent | Percentage of correct answers | 
Sample:
| Code | Country | Correct | Incorrect | Total | Percent | 
|---|---|---|---|---|---|
| ad | Andorra | 0 | 1 | 1 | 0 | 
| ae | United Arab Emirates | 0 | 0 | 0 | 0 | 
| af | Afghanistan | 0 | 0 | 0 | 0 | 
| ag | Antigua and Barbuda | 0 | 0 | 0 | 0 | 
| ai | Anguilla | 0 | 1 | 1 | 0 | 
2. 🌍 Countries
Aggregated stats by country. Useful for leaderboards, accuracy rankings, and identifying knowledge gaps.
- Rows: 119
- Columns: 3
| Column | Description | 
|---|---|
| Country | Full country name | 
| Total | Total number of attempts | 
| Percent | Overall accuracy percentage | 
Sample:
| Country | Total | Percent | 
|---|---|---|
| Andorra | 1 | 0 | 
| Anguilla | 1 | 0 | 
| Albania | 1 | 100 | 
| Angola | 2 | 100 | 
| Bosnia and Herzegovina | 1 | 0 | 
3. 🇺🇸 States
Breakdown of quiz performance for U.S. state flags, ranked by total attempts and accuracy.
- Rows: 50
- Columns: 3
| Column | Description | 
|---|---|
| Country | U.S. state name | 
| Total | Number of attempts | 
| Percent | Accuracy rate | 
Sample:
| Country | Total | Percent | 
|---|---|---|
| Alaska | 8 | 87.5 | 
| Alabama | 10 | 90 | 
| Arkansas | 8 | 100 | 
| Arizona | 4 | 75 | 
| California | 13 | 100 | 
📈 Potential Uses
- Data Visualization: Import into Tableau, Google Data Studio, or custom dashboards to visualize flag recognition trends.
- Learning Analytics: Identify which flags are most commonly missed and tailor study sessions accordingly.
- Leaderboard Generation: Use the CountriesandStatessheets to rank performance by accuracy or attempt count.
- Educational Insights: Track improvement over time by periodically updating the Scores sheet.
🛠 Suggested Next Steps
- Convert to CSV for easier programmatic access.
- Add timestamp data for time-based analysis.
- Build a small React or Svelte dashboard to explore trends interactively.
- Integrate with a quiz app to automate data updates.
👤 Author
Jordan Rhea
EdTech Consultant • Data Nerd • Flag Enthusiast

