Assignment Brief

Data Science
Academic Year 2025

Unit Information:
Foundation Diploma in Business & IT
Qualification: (SCQF Level 6 – Equivalent to A Level)

J8LW 46
Unit Code & Title: Data Science

Assignment 1
LO1 - Task A: Report (Individual)
Assignment Title:
LO2 - Task B: Report (Individual)
LO3 - Task C: Report (Individual)

Total Marks: 100

Results Reporting: Assignment 1 Task A: 30%
Assignment 1 Task B: 30%
Assignment 1 Task C: 40%

Date of Issue: 08-05-2026 Due Date: 10-07-2026

To be Filled by the Student

Student USN:
College Name & Site: JAIN College
Tutor:
Date Due:
Date of Submission:

*All work must be submitted on or before the due date. If an extension of time to submit work
is required, a Mitigating Circumstance Form must be submitted.
Has an extension been approved? Yes No
If yes, please provide the new submission date ….…/.…. /……., and affix appropriate evidence.

First Marker: Second Marker:

Refer: Yes / No
Agreed Mark:

J8LW 46_ Data Science_SCQF Level 6_JAIN College Foundation Diploma in Business & IT
General Guidelines for Assessment

1. Attach a title page to your assignment. Use the previous page as your cover sheet and
ensure that you fill in the details correctly.
2. All assignment work should be prepared using word processing software and should
be organized and clearly structured

Word Processing Guidance

1. Use a font type that makes it easy for your examiner to read, for example, Arial or
Times New Roman.
2. Use 1.5-line line spacing. Left-justify all paragraphs.
3. Ensure that all headings are consistent in terms of size and font style.
4. Use the footer function to insert your Student USN, Name, Unit Code, Unit Title,
and Page Number on each page
5. Use the spell check and grammar check functions to check your assignment.

Assignment Submission

1. Ensure that you give yourself enough time to complete the assignment by the due date.
You must take responsibility for managing your own time effectively.
2. Submit an electronic version uploaded to the student learning management system on
or before the stated deadline.
3. Submissions received up to 72 hours after the deadline will be penalised in line with
JAIN College's Late Submission Policy. Thereafter, submissions will not be accepted.
4. If you are unable to hand in your assignment on time and have valid reasons, such as
illness, you may apply (in writing) for an extension under the terms of the JAIN
COLLEGE Mitigating Circumstances Policy.
5. Non-submission of work without a valid reason will lead to an automatic REFERRAL.
You will then be asked to complete an alternative assignment. Your work will be
capped at a PASS.

Declaration of Authenticity

1. Exercise meticulous care when incorporating the work or ideas of others into your
assignment. Ensure that all sources are accurately acknowledged using the Harvard
referencing system, both within the text and in the bibliography. Failure to provide
proper attribution may result in an investigation and potential penalties for
plagiarism, in accordance with the JAIN College Malpractice Policy

J8LW 46_ Data Science_SCQF Level 6_JAIN College Foundation Diploma in Business & IT
 Statement of Originality and Student Declaration

I hereby declare that I fully understand the concept of plagiarism, which includes the use of
another individual’s work and its presentation as my own without proper and accurate
attribution of sources. I further acknowledge my awareness of what constitutes copying or the
use of another’s work without appropriate academic acknowledgement.

1. I know that plagiarism is a punishable offence because it constitutes theft, and the
consequences of plagiarism as outlined in the Malpractice Policy.
2. I understand JAIN College's plagiarism, ghost writing and copying policy.
3. I declare that all work presented by me for every aspect of this assignment is my own,
and where I have made use of another’s work, I have rightly attributed the source.
4. I acknowledge that the attachment of this document, signed or not, constitutes my
agreement to the above.
5. I understand that my assignment will not be considered as submitted if this declaration
is not included.

Student’s Signature: …………………………… Date: ………………

J8LW 46_ Data Science_SCQF Level 6_JAIN College Foundation Diploma in Business & IT
 Assignment 1: Data Science

The assessment measures the attainment of learning outcomes through one summative
task.

Task A – Summative Assessment

LO1: Describe the applications of data science.

1.1 Application and Problem Solving (7 Marks)

 Task 1.1.1: (5 Marks)

Scenario: A fitness studio owner notices that while many people sign up for a "New
Year’s Resolution" membership in January, almost 40% stop coming by March. The
owner decides to use Data Science to improve member retention.

Question: Match the Studio Owner’s actions to the correct Step in Solving a Problem
Studio Owner’s Action Data Science Step
A. The owner creates a line graph
showing "Class Attendance" vs. "Months
1. Data Cleaning
since Joining" to show stakeholders how
quickly people quit.
B. The owner exports check-in logs,
member age data, and survey responses 2. Interpret and Make Decision
from the studio's database.
C. The owner notices some check-in
times are missing or listed as "00:00" and
3. Data Collection
fixes these errors to ensure the stats are
accurate.
D. By looking at the trends, the owner
discovers that members who attend at
4. Data Visualization
least two Yoga classes in their first month
are 80% more likely to stay.
E. Based on the findings, the owner
launches a "New Member Yoga
5. Analyzing the Data
Challenge" to keep people engaged
during their first 30 days.

J8LW 46_ Data Science_SCQF Level 6_JAIN College Foundation Diploma in Business & IT
  Task 1.1.2: (2 Marks)
Identify two practical applications of Data Science used in everyday life. Briefly
explain how data-driven insights in these applications provide value to the consumer.

1.2 Ethics and Bias (6 Marks)

 Task 1.2.1: (3 Marks)

Scenario: A private health insurance provider offers a free "Wellness App" that
rewards users for tracking their daily steps. Unknown to the users, the app also collects
metadata about their shopping habits and social media activity. The insurer uses an AI
to analyze this data to predict which users are at high risk for chronic diseases and
preemptively increases their premiums or denies coverage - based on these hidden
"health scores".

Question: Is this ethical? Justify

 Task 1.2.2: (3 Marks)

Scenario: A multinational corporation wants to determine if its employees prefer
working from home or returning to the office full-time. Instead of only surveying the
Software Engineering team (who can work entirely online) or the Security and
Maintenance staff (who must be on-site), the HR department uses a computer to
randomly select 15 employees from every single department in the company -
including HR, Sales, IT, Janitorial, and Executive roles. These selected employees are
then interviewed about their preferences.

Question: Is there a data bias? Justify

1.3 Analytics Types (10 Marks)

 Task 1.3: (10 Marks)

Read the following five statements. For each scenario, identify whether it represents
Descriptive Analytics or Predictive Analytics. Provide a brief (one-sentence)
justification for your choice

a) A streaming service analyzes the most-watched genres of the past year to create an
"End of Year" report for its subscribers
b) A real estate website uses current market trends and house features to estimate
what a specific property will sell for in six months
c) A manufacturing plant monitors its equipment sensors to determine the total
number of hours a machine was idle during the morning shift
d) An airline reviews flight logs from the previous decade to calculate the percentage
of flights that were delayed due to mechanical issues
e) A bank analyzes a customer’s spending habits and credit history to assign a score
indicating how likely they are to respond to a new loan offer

J8LW 46_ Data Science_SCQF Level 6_JAIN College Foundation Diploma in Business & IT
1.4 Data Security (7 Marks)

 Task 1.4.1: (4 Marks)

Scenario: An e-commerce company stores customer credit card details in its database.
To enhance security, the IT department decides to implement two specific techniques:
A. They display only the last four digits of the card number to customer service
representatives (e.g., XXX-XX-1234)
B. They replace the actual card number in their internal processing system with a
unique, non-exploitable string like eyJzdWIiOiIxMjMtND...

Question:
1. Identify and define the two specific techniques being used in (A) and (B)
2. Additionally, explain why the company should follow the 3-2-1 backup rule to
ensure data resiliency

 Task 1.4.2: (3 Marks)

Determine whether the following statements are True or False based on the data
security guidelines. If a statement is false, briefly explain why.
a) Role-Based Access Control (RBAC) assigns permissions based on individual
user identities rather than their specific job functions
b) Under Zero Trust Architecture, every request is continuously authenticated,
regardless of whether it originates from inside or outside the network
c) Multi-Factor Authentication (MFA) is a process that relies solely on a single
strong password to prevent hackers from accessing a system

J8LW 46_ Data Science_SCQF Level 6_JAIN College Foundation Diploma in Business & IT
Task B – Summative Assessment

LO2: Explain techniques in analyzing a dataset

2.1 Data Architecture (10 Marks)

 Task 2.1.1: (6 Marks)

Categorize the following into Nominal, Ordinal, Discrete, or Continuous Data and
justify your answer
1. The types of residential housing (e.g., Townhouse, Apartment)
2. The count of petals on a daisy (e.g., 21 petals, 34 petals)
3. The shirt sizes available in a clothing store (e.g., Small, Medium, Large, Extra
Large)
4. The precise volume of water in a hydration bladder (e.g., 1.75 liters)
5. The blood type of a patient (e.g., A+, B-, O+)
6. The speed of a car captured by a radar gun (e.g., 104.2 km/h)

 Task 2.1.2: (4 Marks)

Use this unstructured data to populate the structured table below
“On Sat 14th May 2021, 15,134 fans watched Northway play Green United. Northway
won 3-1"
date number_fans northway_goals green_united_goals

2.2 Data Preparation (10 Marks)

 Task 2.2.1: (4 Marks)

Discuss the concept of Data Cleaning and provide a practical example to demonstrate
its necessity

 Task 2.2.2: (6 Marks)

Analyse the following scenarios and identify whether each represents "Data Capture",
"Data Cleaning", or "Data M anipulation". Provide a brief reason for your choice.
1. A mobile app prompts a user to enter their email address and phone number during
sign-up
2. A programmer writes a script to combine a "Product Names" table with a "Price
List" table using a common Product ID
3. An analyst finds several records where the "City" field is blank and fills them in
based on the provided Zip Code
4. A system calculates the average temperature for the month of July using thousands
of individual hourly sensor readings

J8LW 46_ Data Science_SCQF Level 6_JAIN College Foundation Diploma in Business & IT
2.3 Descriptive Statistics (5 Marks)

 Task 2.3: (5 Marks)

You are provided with a raw dataset representing Monthly salaries of 10 employees (in
USD). Perform the following tasks using a Jupyter Notebook. Once completed, take a
clear screenshot of the code and the resulting output, and provide as answer.
 Dataset:
𝑑𝑎𝑡𝑎 = [2500, 2700, 2700, 2800, 3000, 3100, 3200, 3500, 4000, 12000]

 Tasks:
1. Create a Pandas DataFrame using the dataset provided above with
column name "Salary"
2. Calculate the Mean, Median, and Mode of the salaries

2.4 Visualization Principles (5 Marks)

 Task 2.4: (5 Marks)

You are working as a data analyst for a new streaming service, "StreamPulse." The
marketing department wants to visualize the growth of their Premium Subscribers over
the first 8 months of their launch year to identify growth patterns.
 Data: Monthly Premium Subscriber counts (in thousands)
data = {
'Month': ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug'],
'Subscribers': [10.5, 12.2, 15.8, 14.0, 18.5, 22.1, 26.3, 30.0]
}

 Question: Using the Seaborn library, create a line plot to visualize the
subscriber growth. The code must meet the following requirements:
1. Use the 𝑠𝑛𝑠. 𝑙𝑖𝑛𝑒𝑝𝑙𝑜𝑡() function to map Month to the x-axis and
Subscribers to the y-axis
2. Add markers (like dots) to the line to highlight each specific month’s
data point
3. Provide a clear and descriptive Title for the chart
4. Ensure both the X-axis and Y-axis have readable labels (e.g., "Month of
2026" and "Subscribers (in Thousands)")
 Note: Perform the above task using Jupyter Notebook. Once completed, take a
clear screenshot of the code and the resulting output, and provide as answer

J8LW 46_ Data Science_SCQF Level 6_JAIN College Foundation Diploma in Business & IT
Task C – Summative Assessment

LO3: Analyse data to extract insights

In this task, a common scenario is provided which is applicable for all the questions that
follow:

Scenario: You are a Data Analyst for a restaurant. You need to analyze tipping patterns to
help the waitstaff understand their earnings and customer behavior.

Note: Perform the below tasks using Jupyter Notebook. Once completed, take a clear
screenshot of the code and the resulting output, and provide as answer

3.1 Planning and Bias Check (10 Marks)

 Task 3.1: (10 Marks)

 Load the dataset into a Pandas DataFrame using following URL
[Link]
 Display the top 10 and bottom 10 rows of the data
 Check for missing values in the dataset
 Check for any duplicate rows

3.2 Data Wrangling (15 Marks)

 Task 3.2: (15 Marks)

 Remove the duplicate rows
 If there are missing values in the 𝑡𝑜𝑡𝑎𝑙_𝑏𝑖𝑙𝑙 column, fill them with the average
(mean) bill amount
 Create a new column named 𝑡𝑖𝑝_𝑝𝑒𝑟𝑐𝑒𝑛𝑡𝑎𝑔𝑒 using the below formula
 Formula: (tip / total_bill) * 100

3.3 Analysis and Calculation (5 Marks)

 Task 3.3: (5 Marks)

 Find the average tip amount given by Male vs. Female customers (Group by
sex)
 Identify the maximum total bill amount in the dataset

J8LW 46_ Data Science_SCQF Level 6_JAIN College Foundation Diploma in Business & IT
3.4 Visualization and Reporting (10 Marks)

 Task 3.4: (10 Marks)

 Using Seaborn, create a Scatter Plot showing the relationship between
𝑡𝑜𝑡𝑎𝑙_𝑏𝑖𝑙𝑙 (x-axis) and 𝑡𝑖𝑝 (y-axis)
 Color the points based on whether the customer was a "Smoker" or "Non-
smoker" (using the ℎ𝑢𝑒 parameter)
 Based on the scatter plot and analysis, should the restaurant focus on attracting
larger groups or higher-spending individuals to increase tips? Do smokers tip
more than non-smokers? Justify your answer using the data

J8LW 46_ Data Science_SCQF Level 6_JAIN College Foundation Diploma in Business & IT
 Marking Criteria

Learning Task Assessment Marking Criteria Marks

Outcome

1.1
Application and Problem Solving 7

1.2 Ethics and Bias 6

LO1
1.3
Analytics Types 10

1.4
Data Security 7

Data Architecture 10
2.1

2.2 Data Preparation 10

LO2
2.3 Descriptive Statistics 5

2.4 Visualization Principles 5

3.1 Planning and Bias Check 10

3.2 Data Wrangling 15

LO3
3.3 Analysis and Calculation 5

3.4 Visualization and Reporting 10

The minimum marks required to pass this assignment is 40%

J8LW 46_ Data Science_SCQF Level 6_JAIN College Foundation Diploma in Business & IT