Help?
PLEASE MATCH YOUR ASSIGNMENT QUESTIONS ACCORDING TO YOUR SESSION
IGNOU MCSL-229 (January 2025 – July 2025) Assignment Questions
SECTION-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.
IGNOU MCSL-229 (January 2024 – July 2024) Assignment Questions
PART-I: Cloud Computing Lab
Q1: (a) Use Google Docs to create your Curriculum Vitae document. Store it on Google Drive and share it with two friends who can view and comment on it.
(b) Use Google Sheets and create a spreadsheet containing the marks of 10 students under the headings – student name, phone, and marks out of 100 in 5 different subjects. Find the students’ grades in each subject using the formula below. Also, compute the Cumulative Grade Point Average for each student.
Cumulative Grade Point Average = Average of Grade Points of all the subjects.
Grade Points: A-5; B-4; C-3; D-4; E-1.
The Grades are computed as:
If marks >= 75 Grade = A;
If marks <75 and marks >= 60 Grade = B;
If marks <60 and marks >= 50 Grade = C;
If marks <50 and marks >= 40 Grade = D;
If marks <40 Grade = E;
(c) Use Google Slides and prepare nine slides on the topic “Software as a Service (SaaS)” 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: Write the steps of installing Oracle Virtual Box on a laptop. Also, describe the features of the Oracle Virtual Box.
Q3: Use Google App Engine and write a Google app engine program to validate users using username and password and deploy it to Google Cloud.
PART-II: Data Science Lab
Q4: The weights of 50 adults aged 20-35 years, measured in Kilograms, are given below. Perform the tasks (i) to (iv) using R programming.
(i) Find the minimum and maximum weight.
(ii) Find the percentage of adults whose weight is between 65 and 75 Kilograms.
(iii)Create and draw the frequency distribution with the help of a relevant graph.
(iv)Find the outlier of the data.
Q5: The following data were collected on students’ Mathematics and Physics scores. Use R programming to fit a linear regression line to predict the effect of Mathematics scores on the Physics scores of a student. Also, predict the Physics score of a student whose Mathematics score is 80.
