Indian-kids-screen-time-excel

Exploratory data analysis and dashboard design in Excel to uncover patterns in screen time usage among Indian children, including gender, age, devices, and location trends.

Problem Statement

Screen time affects children’s health, behavior, and daily routines.
In this project, I aimed to answer: Do boys and girls, or kids from different backgrounds, spend screen time differently?

Dataset

Indian Kids Screen Time Dataset on Kaggle (https://www.kaggle.com/datasets/ankushpanday2/indian-kids-screentime-2025)

Project Files

1. "Indian_Kids_Screen_Time -- Analysis.xlsx"

This file contains the full analysis, including:

• Raw dataset
• Gender-based screen time comparison
• Age-wise trends
• Device usage insights
• Exceeded time limit patterns
• All exploratory questions asked

2. "Indian_Kids_Screen_Time -- Dashboard.xlsx"

This file contains a clean, presentation-ready dashboard:

• Key metrics (Total students, Avg screen time, % exceeding)
• Highlight charts from each analysis section

Key Questions Answered

• Do boys and girls spend different amounts of time on screens?
• Are urban or rural kids more likely to exceed limits?
• What is the most commonly used device?
• Does the educational vs recreational screen use change with age or gender?

Tools Used

• Microsoft Excel
• Pivot Tables & Charts
• Basic Formulas
• Dashboard Design Techniques

Why This Project?

This is part of my journey to break into data science.
It shows I can:

• Ask relevant questions from a dataset
• Use Excel to explore and visualize data
• Communicate insights clearly