MCSL - 229

Solved assignment MCA_NEW

3rd semester

Cloud and Data Science Lab

By × RUPESH BHANDARI
30th April, 2025 (for January
session)
Last date of Submission
31st October, 2025 (for July
session)

Standing in a queue isn’t just about waiting; it’s about Decipline

...respect and fairness.
Course Code : MCSL-229
Course Title : Cloud and Data Science Lab
Assignment Number : MCA_NEW(III)/L-229/Assign/2025
Maximum Marks : 100
Weightage : 30%
Last Dates for Submission : 30th April, 2025 (for January session)
31st October, 2025 (for July session)

The assignment has two sections. Answer all the questions. Each section is for 20 marks. The
lab record of the Cloud Computing Lab and Data Science lab carries 20 Marks each. The
remaining 20 marks are for viva voce. You may use illustrations, diagrams and screenshots to
enhance the explanation. Please go through the guidelines regarding assignments given in the
MCA(New) Programme Guide for the format of the presentation. If any assumptions are made,
please state them.

SECTION-I: Cloud Computing Lab

Q1: (4+3+3 = 10 Marks)

(a) Use Google Docs to create a document containing the schedule of MCS-229 practical counselling
sessions. Store it on Google Drive and share it with five friends who can view and Comment on it.

(b) Use Google Sheets and create a spreadsheet containing the yearly Salary details of 10 employees of a
university under the headings – employee name, yearly basic salary, DA percentage, Provident fund
deductions, Income Tax deduction, and net salary. You may use the following formulas for making the
spreadsheet:
DA amount = DA percentage * yearly basic salary
Provident fund = 8% of yearly basic salary
Income Tax deduction is computed as:
For yearly basic salary < 5,00,000 tax =0
For yearly basic salary >= 5,00,000 but <10,00,000
tax = 20% of (yearly basic salary – 5,00,000)
For yearly basic salary >= 10,00,000
tax = 1,00,000 + 30% of (yearly basic salary – 10,00,000)
Net Salary = yearly basic salary + DA amount – Provident fund – tax

(c) Use Google Slides and prepare nine slides on the topic “Platform as a Service (PaaS)” in a group of
three students by sharing the Google Slides in your group in edit mode. Every group member should
make three slides each and contribute to the slides of other members of her/his group.

Q2: (5 Marks)

Explore JustCloud file storage solutions and cloud storage on AWS. Use only the trial versions.

Q3: (5 Marks)

Use Google App Engine to write a program to multiply two matrices. Deploy it on the Google cloud.

11
 SECTION-II: Data Science Lab

Q1: (2+2+4+2 = 10 Marks)

The height of 50 students of class X was measured in centimeters. The following table shows this data.
Perform the tasks (i) to (iv) using R programming.

156 155 163 151 141 160 151 131 170 163
165 160 158 168 158 154 162 166 171 141
161 159 158 156 149 145 168 171 165 145
166 167 169 156 164 146 155 164 168 172
156 163 167 157 155 145 171 164 166 195

(i) Find the minimum and maximum height.

(ii) Find the percentage of students whose height is between 160 and 170 Centimeters.
(iii) Create and draw the frequency distribution with the help of a relevant graph.
(iv) Find the outlier of the data.

Q2: (10 Marks)

An organisation collected the following data of its employees: “years in employment” and “employee's salary”.
Use R programming to fit a linear regression line to predict the effect of years in employment on the
employee’s salary. Also, predict the salary of an employee who is employed for 11 years.

Employee Number Years in Employment Employee Monthly salary

in thousand Rs
1 10 149
2 8 120
3 12 150
4 7 110
5 6 100
6 5 90
7 9 130
8 8 110
9 3 80
10 4 85

12
The assignment has two sections. Answer all the questions. Each
section is for 20 marks. The lab record of the Cloud Computing Lab
and Data Science lab carries 20 Marks each. The remaining 20
marks are for viva voce. You may use illustrations, diagrams and
screenshots to enhance the explanation. Please go through the
guidelines regarding assignments given in the MCA(New)
Programme Guide for the format of the presentation. If any
assumptions are made,please state them.

SECTION-I: Cloud Computing Lab

Q:1]

(a) Use Google Docs to create a document

containing the schedule of MCS-229 practical
counselling sessions. Store it on Google Drive and
share it with five friends who can view and
Comment on it.

Ans :
Step 1: Open Google Docs

●​ Open your web browser and go to Google Docs.

●​ Click on Blank Document to create a new
document.
●​ At the top, type a title:
"MCS-229 Practical Counselling Schedule"

1
 -​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

d) Below the title, add a brief description (optional),

such as:

This document contains the schedule for the

MCS-229 practical counselling sessions.

Step : 2 Mention important detailed Notice

✅ Mention Practical centre Adress & detailed

information about adminstrator

✅ Mention schedule time & date

✅ Mention the approval signature of Director.
2
 -​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

Step : 3 ) Store it on Google Drive

✅ Name the file of Google drive where you want to

save the document. And move this file to that path.

3
 -​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

✅ You will receive pop-up notification of file has

been saved successfully.

-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

Step : 4 ) Share file with 5 friends who can view &

comment on it.

4
Now, we need to list all five email addresses of our
friends and adjust their access permissions to either
Viewer or Commenter. Since Google Docs allows
setting permissions for one role at a time, we will
need to configure these settings separately for each
recipient.

✅ Viewer
-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

✅ Commentator.
-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

5
(b) Use Google Sheets and create a spreadsheet
containing the yearly Salary details of 10 employees
of a university under the headings – employee
name, yearly basic salary, DA percentage, Provident
fund deductions, Income Tax deduction, and net
salary. You may use the following formulas for
making the spreadsheet.

DA amount = DA percentage * yearly basic salary

Provident fund = 8% of yearly basic salary

6
Income Tax deduction is computed as:

For yearly basic salary < 5,00,000 tax =0

For yearly basic salary >= 5,00,000 but <10,00,000

tax = 20% of (yearly basic salary – 5,00,000)

For yearly basic salary >= 10,00,000

tax = 1,00,000 + 30% of (yearly basic salary –

10,00,000)

Net Salary = yearly basic salary + DA amount –

Provident fund – tax

Ans :

Step : 1

Open Google Sheets : Start by opening a new

Google Sheets document.

Step : 2

Set Up Headers: In the first row, set up the following

headers:

7
A1: Employee Name

B1: Yearly Basic Salary

C1: DA Percentage

D1: Provident Fund Deductions

E1: Income Tax Deduction

F1: Net Salary

Step : 3

Input Employee Data: Enter the details for 10

employees under the respective columns (A, B, and
C).

Calculate DA% Amount: In cell C2, enter the formula

to calculate the DA amount:

Given

DA amount = DA percentage * yearly basic salary

Drag this formula down to apply it to all employees.

8
Calculate Provident Fund Deductions: In cell D2,
enter the formula to calculate the Provident Fund:

Given :

Provident fund = 8% of yearly basic salary

Calculate Income Tax Deduction: In cell F2, enter the

formula to calculate the Income Tax based on the
given conditions:

Given

For yearly basic salary < 5,00,000 tax =0

For yearly basic salary >= 5,00,000 but <10,00,000

tax = 20% of (yearly basic salary – 5,00,000)

For yearly basic salary >= 10,00,000

tax = 1,00,000 + 30% of (yearly basic salary –

10,00,000)

-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

9
Drag ;
-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

Calculate Net Salary: In cell G2, enter the formula to

calculate the Net Salary:

Given ;

10
Net Salary = yearly basic salary + DA amount –
Provident fund – tax
-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

Goggle sheets view :

-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

11
 -​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

Print pdf :

-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

12
(c ) Use Google Slides and prepare nine slides on
the topic “Platform as a Service (PaaS)” in a group
of three students by sharing the Google Slides in
your group in edit mode. Every group member
should make three slides each and contribute to the
slides of other members of her/his group.

Ans :

Step 1: Create a New Google Slides Presentation

●​ Go to Google Slides.
●​ Click on Blank Presentation to create a new
slide deck.
●​ Rename the presentation as “Platform as a
Service (PaaS)”.

Step 2: Structure the Slides

Create a total of 9 slides, divided equally among the

three group members (3 slides each).

Step : 3 Create your own 3 slides

13
Slide : 1
-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

Slide : 2

-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

Slide : 3
-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

14
Step 4 : Share the Presentation in Edit Mode

●​ Click on Share (top-right corner).

●​ Enter the email addresses of your group

members.

●​ Set their access to Editor so they can make

changes

●​ Click Send or copy the shareable link and share

it via email or chat.

15
 ●​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

Slide 4 :
-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

Slide 5 :
-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

16
Slide 6 :

-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

Slide 7 :
-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

17
Slide 8 :
-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

Slide : 9

18
 -​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

Q : 2 ] Explore JustCloud file storage solutions and

cloud storage on AWS. Use only the trial versions.

Ans :

Exploring JustCloud and AWS cloud storage

solutions using their trial versions can provide
valuable insights into their features and usability.
Here's a step-by-step guide to help you explore
these platforms:

JustCloud File Storage Solutions

19
Sign Up for JustCloud Trial:

●​ Visit the JustCloud website.

●​ Sign up for a free trial account. You may need to

provide payment information, but you should
not be charged during the trial period.

Install JustCloud Application:

●​ Download and install the JustCloud application

on your computer or mobile device.

●​ Log in using your trial account credentials.

Explore Features:

●​ File Synchronization: Upload files to JustCloud

and see how they sync across devices.

●​ Backup Options: Explore the backup settings to

understand how you can schedule automatic
backups.

●​ File Sharing: Test the file-sharing features by

sharing a file or folder with another user.

20
 ●​ Storage Limits: Check the storage limits and
performance during the trial period.

User Interface and Experience:

✅ Ultimate back-up space

✅ Automated Backup
-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

✅ Backup app your device

✅ Access your files anywhere
-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

21
✅ Share files with friends
-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

AWS Solutions

Visit AWS portal & sign-up

-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

22
Sign-up on AWS
-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - -

Try free version by adding Credit/ debit card

-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

23
Explore free tier
-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

Trying Billing Dashboard in Free tier

-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

24
Q : 3 ] Use Google App Engine to write a program to
multiply two matrices. Deploy it on the Google
cloud.

Ans :

Step : 1 ] Login

-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

Step : 2 ] Use free trial & add payment method

-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

25
Step : 3 ] Start new project
-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - -

write a program to multiply two matrices

<!DOCTYPE html>

26
<html lang="en">

<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width,
initial-scale=1.0">
<title>Document</title>
</head>

<body>
<?php

$matrix1 = [
[1, 2, 3],
[4, 5, 6]
];
$matrix2 = [
[7, 8],
[9, 10],
[11, 12]
];

//make a function to multiply two matrices

function multiplyMatrices($matrix1, $matrix2)
{
//identify their rows and columns and their index value
$row1 = count($matrix1);
$col1 = count($matrix1[0]);
$row2 = count($matrix2);
$col2 = count($matrix2[0]);

//checking now of column in first column is equal to second

matrix first row
if ($col1 != $row2) {
echo "Matrix multiplication is not possible. The number of
columns of Matrix 1 must be equal to the number of rows of Matrix
2.\n";
return null;
}

// Initialize the result matrix with zeros

$result = array_fill(0, $row1, array_fill(0, $col2, 0));

27
 //initialize i, j, & k

for ($i = 0; $i < $row1; $i++) {

for ($j = 0; $j < $col2; $j++) {
for ($k = 0; $k < $col1; $k++) {

//multiply elements with their index value

$result[$i][$j] += $matrix1[$i][$k] *
$matrix2[$k][$j];
}
}
}

return $result;
}

// Multiply the matrices (function call)

$result = multiplyMatrices($matrix1, $matrix2);

// Display the result

if ($result !== null) {
echo "Resultant Matrix after multiplication: <br>";
foreach ($result as $row) {
echo implode(" ", $row) . "<br>";
}
}
?>
</body>

</html>

Output:
-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - - ✂

28
Deploy it on the Google cloud.

✅ Click on Manage all project

-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - - - ✂

✅ Click on Compute Engine

29
 -​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - -

- -

✅ Don't forget to enable billing

-​ - - - - - - ✂ - - - - - -✂ - - - - - - - - -✂ - - - - - - - -

30
SECTION-II: Data Science Lab

Q:1]

Ans :
# Given height data
heights <- c(156, 155, 163, 151, 141, 160, 151, 131, 170, 163,
165, 160, 158, 168, 158, 154, 162, 166, 171, 141,
161, 159, 158, 156, 149, 145, 168, 171, 165, 145,
166, 167, 169, 156, 164, 146, 155, 164, 168, 172,
156, 163, 167, 157, 155, 145, 171, 164, 166, 195)

# (i) Find the minimum and maximum height

min_height <- min(heights)
max_height <- max(heights)

cat("Minimum height:", min_height, "\n")

cat("Maximum height:", max_height, "\n")

# (ii) Find the percentage of students whose height is between 160 and
170 cm

31
count_160_170 <- sum(heights >= 160 & heights <= 170)
percentage_160_170 <- (count_160_170 / length(heights)) * 100

cat("Percentage of students with height between 160 and 170 cm:",

percentage_160_170, "%\n")

# (iii) Create and draw the frequency distribution with a histogram

hist(heights, breaks=5, col="lightblue", main="Height Distribution",
xlab="Height (cm)", ylab="Frequency")

# (iv) Find the outlier of the data

boxplot(heights, main="Boxplot of Heights", col="lightgreen",
ylab="Height (cm)")
outliers <- boxplot.stats(heights)$out
cat("Outliers in the data:", outliers, "\n")

Explanation:

●​ Find min & max height: Uses min() and max().

●​ Percentage between 160-170 cm: Counts values
in this range and computes percentage.

●​ Frequency distribution: Uses hist() to create a

histogram.

●​ Find outliers: Uses boxplot.stats() to detect

outliers.

32
Ans : Here is the R program to fit a linear regression
model and predict the salary for an employee with
11 years of employment:

# Data
years <- c(10, 8, 12, 7, 6, 5, 9, 8, 3, 4)
salary <- c(149, 120, 150, 110, 100, 90, 130, 110, 80, 85)

# Create a linear regression model

model <- lm(salary ~ years)

# Summary of the model

summary(model)

# Predict salary for 11 years of employment

predicted_salary <- predict(model, data.frame(years = 11))

33
cat("Predicted salary for 11 years of employment:", predicted_salary,
"thousand Rs\n")

# Plot the data and regression line

plot(years, salary, main="Years vs Salary Regression", xlab="Years in
Employment", ylab="Salary (in thousand Rs)", pch=16, col="blue")
abline(model, col="red")

Explanation:

●​ Define data: years (years in employment) and

salary (employee salary).
●​ Create a regression model: lm(salary ~ years).
●​ Get model summary: summary(model).
●​ Predict salary for 11 years: predict(model,
data.frame(years = 11)).
●​ Plot the regression line: plot() and abline().

End

34