Complete Teaching Manual: Data Analytics with
Mobile Phone
This manual covers both Section A (Theory & Objective) and Section B (Application & Analysis).
Section A: Theory & Objective
Lesson Objectives
1 Understand basic concepts in data analytics.
2 Identify common mobile apps used for data analytics.
3 Differentiate between types of data and their uses.
4 Recall definitions of key analytics terms (data cleaning, visualization, etc.).
5 Prepare for objective and short-answer exam questions.
Objective Questions (MCQs)
Data Analytics can best be defined as:
A. Collecting data only
B. Cleaning, analyzing, and interpreting data
C. Designing phone apps
D. Storing files in the cloud
Answer: B
Which of the following apps is NOT commonly used for mobile data analytics?
A. Google Sheets
B. Power BI Mobile
C. Microsoft Excel Mobile
D. Adobe Photoshop
Answer: D
The main advantage of using Google Sheets on mobile is:
A. It works offline only
B. It supports real-time collaboration and cloud storage
C. It replaces SQL servers
D. It is only for drawing charts
Answer: B
Which type of data is collected from surveys and forms?
A. Structured data
B. Unstructured data
C. Random data
D. Metadata
Answer: A
Data visualization refers to:
A. Cleaning data
B. Using charts and graphs to represent data
C. Writing SQL queries
D. Installing mobile apps
Answer: B
Short Notes
Big Data: Large and complex datasets; mobile devices can only process smaller samples.
Data Cleaning: Process of removing duplicates, handling missing values, and correcting errors.
Possible on Excel Mobile.
Visualization: Graphical representation of data. Tools: Google Sheets chart builder, Power BI
Mobile.
Cloud Storage: Enables saving datasets online for easy mobile access. Examples: Google Drive,
OneDrive.
SQL Mobile Apps: Apps like DBeaver Mobile and SQLite Editor allow basic SQL queries on
phone.
Section B: Application & Analysis
Lesson Objectives
1 Understand the role of mobile devices in data analytics.
2 Learn how to use mobile apps like Google Sheets, Excel Mobile, and SQL clients.
3 Perform basic statistical analysis (mean, median, mode) on mobile.
4 Differentiate between mobile and desktop data visualization.
5 Practice dataset cleaning and analysis using mobile apps.
6 Identify challenges and solutions in mobile data analytics.
Exam-Style Questions & Explanations
Q1: Explain the role of mobile applications in data collection and analysis.
Give three examples.
Mobile applications make data analytics accessible without a laptop. Examples: (1) Google Forms +
Sheets for survey data collection and analysis, (2) Excel Mobile for calculations and pivot tables, (3)
Power BI Mobile for dashboard viewing and insights. Exam Tip: Always mention app name +
function + example dataset.
Q2: With the aid of screenshots (or descriptions), show how Google Sheets
can be used to perform basic statistical analysis (mean, median, mode).
In Google Sheets Mobile: Enter dataset in a column, then use functions =AVERAGE(A1:A10),
=MEDIAN(A1:A10), =MODE(A1:A10). These give central tendencies. Exam Tip: Write formulas
clearly and mention how they are typed on mobile.
Q3: Differentiate between data visualization on desktop vs. mobile. Mention
two mobile-friendly visualization tools.
On desktop, advanced visualizations (like Tableau) are common; on mobile, visualizations are
simplified. Tools: Google Sheets chart builder, Power BI Mobile. Exam Tip: State 1 limitation of
mobile (smaller screen, fewer customizations).
Q4: A sales dataset of fifty entries is given. Explain how you would clean and
analyze it using Microsoft Excel mobile app.
Steps: (1) Import dataset into Excel Mobile, (2) Remove duplicates via 'Data' → 'Remove
Duplicates', (3) Handle missing values by replacing or deleting, (4) Use 'Insert' → 'Charts' for
visualization, (5) Summarize using AutoSum for totals. Exam Tip: Mention both cleaning + analysis
steps.
Q5: What challenges exist in doing full-scale data analytics with a mobile
phone, and what solutions can overcome them?
Challenges: Limited processing power, small screen, fewer features. Solutions: Use cloud services
(Google Sheets, OneDrive), external keyboards, syncing data with desktops later. Exam Tip:
Always write at least two challenges and two solutions.
Revision Summary
• Mobile phones can perform data analytics using lightweight apps.
• Google Sheets and Excel Mobile support basic statistical functions.
• Visualization is possible but limited; Power BI Mobile is useful.
• Data cleaning is essential before analysis.
• Challenges exist, but cloud storage and syncing help overcome them.
Practice Questions
1 List four advantages of performing analytics on mobile devices.
2 Explain with steps how to calculate mean and median in Excel Mobile.
3 What is the difference between Google Sheets and Power BI Mobile in visualization?
4 How would you clean a dataset of 100 names with duplicates on your phone?
5 Mention three challenges and two solutions of mobile data analytics.
