MCSL-229 Solved Assignment 2025

Description

MCSL-229 Solved Assignment 2025 Available

Sectin-I: Cloud Computing Lab
Q1:
(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: Explore JustCloud file storage solutions and cloud storage on AWS. Use only the trial versions.
Q3:Use Google App Engine to write a program to multiply two matrices. Deploy it on the Google cloud.

Section-II: Data Science Lab
Q1:
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.
(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: 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