IGNOU MCSL 65 SOLVED ASSIGNMENT

Included:

MCSL 065 (January 2026 - July 2026) - ENGLISH

Course Code :

MCSL-065

Course Title

: :

Data Science Lab

Assignment Number

: :

MSCDSA(I)/L-065/Lab_Assign/26

Maximum Marks

: :

100

Weightage

: :

30%

Last Date of Submission :

30th April, 2026 (for January session) 31 October, 2026 (for July session)

There are two Sections in this assignment carrying a total of 40 marks. Your Lab Record will carry 40 Marks. Rest 20 marks are for viva voce. You may use illustrations and diagrams to enhance the explanations. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation. Submit the screenshots along with the coding and documentation.

Dataset: To attempt the problems given in this assignment, refer to the Dataset: Students' Exam Scores

given below: 

Student_ID	Student_Name	Physics	Chemistry	Maths	English
S01	Rahul	78	72	85	80
S02	Ananya	88	91	90	86
S03	Amit	65	69	70	72
S04	Neha	92	89	94	90
S05	Karan	55	60	58	62
S06	Priya	81	85	88	84
S07	Rohit	70	68	75	73
S08	Simran	90	92	89	91
S09	Arjun	60	65	63	67
S10	Pooja	85	88	90	87

SECTION-1 DATA SCIENCE LAB-GUI TOOLS

(20 Marks)

EXCEL BASED PROBLEM:

1. Use Excel to perform following tasks:

(6 Marks)

a. Create a Histogram for Maths marks

b. Plot a Line Chart for Maths scores against Student_ID.

c. Calculate average marks for each subject, and Create a Bar Chart comparing subject-wise average scores.

d. Using average marks, create a Pie Chart showing percentage contribution of each subject.

e. Use data analysis toolpak to perform following:

i. Generate descriptive statistics

ii. Perform a two-sample t-test to check whether there is a significant difference between the marks of Physics and Chemistry.

iii. Perform an F-test to compare the variance of marks in Maths&English

iv. Calculate Pearson Correlation Coefficient between

Maths and Physics

Maths and Chemistry 

TABLEAU BASED PROBLEM:

(7 Marks)

2. Use Tableau to perform following tasks:

a. Save the above data given in Dataset: Students' Exam Scores in an excel file or CSV file, save it, and perform following:

Import the Students' Exam Scores dataset into Tableau.

Verify data types for each subject.

Rename fields appropriately (if required).

b. Create a Bar Chart showing average marks for:

Physics

Chemistry

Maths

English

Label axes and add chart title.

c. Create a Line Chart showing Maths scores across students. (Use Student_ID on X-axis.)

d.

Create a Pie Chart showing percentage contribution of each subject based on average marks.

(Display percentage labels.)

e. Create a Table View displaying: Average, Minimum, Maximum, and Standard Deviation. (For all four subjects).

f. Now, create a single dashboard that includes:

i. Bar Chart (Subject-wise Average)

ii. Line Chart (Maths Trend)

iii. Pie Chart (Subject Contribution)

iv. Summary Statistics Table 

POWER BI BASED PROBLEM:

(7 Marks)

3. Use Power BI to perform following tasks:

a. Save the above data given in Dataset: Students' Exam Scores in an excel file or CSV file, save it, and perform following:

Import the Students' Exam Scores dataset into Power BI.

Verify data types for each subject.

Rename fields appropriately (if required).

b. Create a Bar Chart showing average marks for:

Physics

Chemistry

Maths

English

Identify the subject with the highest and lowest average score.

c. Create a Line Chart showing Maths scores across students. (Use Student_ID on X-axis.)

d. Create a Pie Chart showing percentage contribution of each subject based on average marks.

(Display percentage labels.) 

e. Create the following DAX measures: Average, Minimum, Maximum, and Standard Deviation.

(For all four subjects).

f. Create a Table View displaying: Average, Minimum, Maximum, and Standard Deviation. (For all four subjects).

g.

Now, create a single dashboard that includes:

i. Bar Chart (Subject-wise Average)

ii. Line Chart (Maths Trend)

iii. Pie Chart (Subject Contribution)

iv. Summary Statistics Table

SECTION-2 DATA SCIENCE LAB-PROGRAMMING BASED

(20 Marks)

PYTHON PROGRAMMING BASED PROBLEM:

(10 Marks)

4. Use Python programming language to perform the tasks given below:

Note: Save the above data given in Dataset: Students' Exam Scores in a CSV file (students_scores.csv), save it, and Now Write a program in Python to perform following tasks:

a) Read students_scores.csv into a panda DataFrame. and Display:

First 5 rows

Column names

Data types

b) Generate descriptive statistics, For each subject (Physics, Chemistry, Maths, English), compute:

Mean

Median

Mode

Minimum

Maximum

Range

Variance 

Standard Deviation

c) Create a new column Total = sum of 4 subjects; also Also, Create Percentage = (Total/400)* 100

Find:

Topper (max Total)

Lowest scorer (min Total)

d) Plot a scatter diagram and histogram of Maths scores and interpret whether scores are concentrated or spread out.

e) Compute average marks of each subject, and plot a bar chart of subject-wise averages

f) Plot a line chart of Total marks vs Student_ID, andIdentify performance variations (ups/downs).

 

Q: How will I receive the PDF?
A: Immediately after payment, the download link will appear.

Q: Is this hand-written or typed?
A: This is a professional typed computer PDF. You can use it as a reference for your handwritten submission.

Details

• Latest IGNOU Solved Assignment
• IGNOU MCSL 65 2026 Solved Assignment
• IGNOU 2026 Solved Assignment
• IGNOU MSCDSA Master of Science (M.Sc.) (Data Science and Analytics) (ODL) 2026 Solved Assignment
• IGNOU MCSL 65 Data Science Lab 2026 Solved Assignment

Looking for IGNOU MCSL 65 Solved Assignment 2026. You are on the Right Website. We provide Help book of Solved Assignment of MSCDSA MCSL 65 - Data Science Labof year 2026 of very low price.
If you want this Help Book of IGNOU MCSL 65 2026 Simply Call Us @ 9199852182 / 9852900088 or you can whatsApp Us @ 9199852182
 

IGNOU MSCDSA Assignments Jan - July 2026 - IGNOU University has uploaded its current session Assignment of the MSCDSA Programme for the session year 2026. Students of the MSCDSA Programme can now download Assignment questions from this page. Candidates have to compulsory download those assignments to get a permit of attending the Term End Exam of the IGNOU MSCDSA Programme.

Download a PDF soft copy of IGNOU MCSL 65 Data Science Lab MSCDSA Latest Solved Assignment for Session January 2026 - December 2026 in English Language.

If you are searching out Ignou MSCDSA  MCSL 65 solved assignment? So this platform is the high-quality platform for Ignou MSCDSA  MCSL 65 solved assignment. Solved Assignment Soft Copy & Hard Copy. We will try to solve all the problems related to your Assignment. All the questions were answered as per the guidelines. The goal of IGNOU Solution is democratizing higher education by taking education to the doorsteps of the learners and providing access to high quality material. Get the solved assignment for MCSL 65 Data Science Lab course offered by IGNOU for the year 2026.Are you a student of high IGNOU looking for high quality and accurate IGNOU MCSL 65 Solved Assignment 2026 English Medium? 

Students who are searching for IGNOU Master of Science (M.Sc.) (Data Science and Analytics) (ODL) (MSCDSA) Solved Assignments 2026 at low cost. We provide all Solved Assignments, Project reports for Masters & Bachelor students for IGNOU. Get better grades with our assignments! ensuring that our IGNOU Master of Science (M.Sc.) (Data Science and Analytics) (ODL) Solved Assignment meet the highest standards of quality and accuracy.Here you will find some assignment solutions for IGNOU MSCDSA Courses that you can download and look at. All assignments provided here have been solved.IGNOU MCSL 65 SOLVED ASSIGNMENT 2026. Title Name MCSL 65 English Solved Assignment 2026. Service Type Solved Assignment (Soft copy/PDF).

Are you an IGNOU student who wants to download IGNOU Solved Assignment 2024? IGNOU  Solved Assignment 2023-24 Session. IGNOU Solved Assignment and In this post, we will provide you with all solved assignments.

If you’ve arrived at this page, you’re looking for a free PDF download of the IGNOU MSCDSA Solved Assignment 2026. MSCDSA is for Master of Science (M.Sc.) (Data Science and Analytics) (ODL).

IGNOU solved assignments are a set of questions or tasks that students must complete and submit to their respective study centers. The solved assignments are provided by IGNOU Academy and must be completed by the students themselves.

Course Name	Master of Science (M.Sc.) (Data Science and Analytics) (ODL)
Course Code	MSCDSA
Programm	Courses
Language	English

 

 

 

IGNOU MCSL 65 Solved Assignment	ignou assignment 2026,   2026 MCSL 65
IGNOU MCSL 65 Assignment	ignou solved assignment MCSL 65
MCSL 65 Assignment 2026	solved assignment MCSL 65
MCSL 65 Assignment 2026	assignment of ignou MCSL 65
Download IGNOU MCSL 65 Solved Assignment 2026	ignou assignments MCSL 65
Ignou result MCSL 65	Ignou Assignment Solution MCSL 65