Scheme of Work: Data Analytics with Mobile Phone
This scheme of work is designed for a 12-week course on Data Analytics using mobile phones. It
combines theory (Section A) and application (Section B) to help students learn data analytics
without a laptop.
Week 1
• Introduction to Data Analytics
• Importance of data in today’s world
• Types of data (structured vs. unstructured)
• Assignment: Identify five examples of data you generate daily.
Week 2
• Mobile phones as tools for data analytics
• Overview of Google Sheets, Excel Mobile, Power BI Mobile
• Practical: Install and explore these apps.
Week 3
• Data Collection Methods (forms, surveys, logs)
• Using Google Forms + Sheets on mobile for survey data
• Practical: Create a simple survey form.
Week 4
• Data Cleaning Basics
• Removing duplicates, handling missing values (Excel Mobile & Sheets)
• Practical: Clean a small dataset ([Link]).
Week 5
• Basic Statistical Functions on Mobile
• Mean, Median, Mode in Google Sheets / Excel Mobile
• Practical: Calculate averages from a dataset.
Week 6
• Data Visualization on Mobile
• Creating charts in Google Sheets & Power BI Mobile
• Practical: Build a bar chart of class scores.
Week 7
• Introduction to SQL on Mobile
• Using SQLite/DBeaver Mobile to query datasets
• Practical: SELECT, WHERE, and basic filtering.
Week 8
• Intermediate Analysis on Mobile
• Pivot tables in Excel Mobile
• Grouping and summarizing data
• Practical: Analyze sales_data.csv.
Week 9
• Challenges of Mobile Analytics
• Limitations (processing power, screen size, features)
• Solutions (cloud storage, syncing, hybrid workflows)
• Class discussion.
Week 10
• Case Study: Mobile Analytics in Business & Education
• Real-world applications (marketing, finance, school records)
• Practical: Students create a simple project proposal.
Week 11
• Revision of Section A (MCQs & Short Notes)
• Group quiz using Kahoot/Google Forms.
Week 12
• Revision of Section B (Application & Analysis)
• Mock Exam (covering both theory & practical)
• Project Presentation by students.
