Scribd
Upload
3 views3 pages

Problem Based Assignment II Data Analytics BCA

The document outlines a Problem Based Assignment II for an Introduction to Data Analytics course, detailing various tasks related to data preprocessing, exploratory data analysis, and visualization. It includes specific problems with associated datasets, course outcomes, and Bloom's Taxonomy mappings for each task. The assignment is graded on a scale from 0 to 5 marks based on the quality of understanding and application of data analytics techniques.

Uploaded by

saquibkk203
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views3 pages

Problem Based Assignment II Data Analytics BCA

The document outlines a Problem Based Assignment II for an Introduction to Data Analytics course, detailing various tasks related to data preprocessing, exploratory data analysis, and visualization. It includes specific problems with associated datasets, course outcomes, and Bloom's Taxonomy mappings for each task. The assignment is graded on a scale from 0 to 5 marks based on the quality of understanding and application of data analytics techniques.

Uploaded by

saquibkk203
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Problem Based Assignment II

Subject: Introduction of Data Analytics (BCA0503)


Activity Marks: 05
Course Outcomes (CO) Mapping

• CO1: Understand and apply data preprocessing techniques.

• CO2: Perform exploratory data analysis (EDA) and gain insights.

• CO3: Apply data cleaning, wrangling, encoding, and transformation methods.

• CO4: Conduct statistical analysis (descriptive stats, hypothesis testing, ANOVA).

• CO5: Create effective visualizations and interactive dashboards.

Bloom’s Taxonomy (BL) Mapping

• Remembering (R) → Basic data loading, inspection

• Understanding (U) → Interpret domain knowledge, EDA insights

• Applying (A) → Implement preprocessing, encoding, visualization techniques

• Analysing (An) → Outlier detection, correlation analysis, hypothesis testing

• Evaluating (E) → Draw conclusions and generate insights

• Creating (C) → Build visualizations, dashboards, engineered features

Assignment Problems & Mapping

Problem 1: Data Preprocessing & Analysis

Dataset: Customer_Data.csv

Tasks: Missing values, outliers, encoding, standardization/normalization

CO: CO1, CO3

BL: Applying, Analysing

Problem 2: Understanding Domain & Dataset

Dataset: Hospital_Data.csv

• Tasks: Domain research, EDA, correlation analysis

• CO: CO2

• BL: Understanding, Analysing, Evaluating

Problem 3: Cleaning & Preparing Data


Dataset: Employee_Data.csv

• Tasks: Missing values, wrangling, merging, encoding, outliers

• CO: CO1, CO3

• BL: Applying, Analysing

Problem 4: Analysing & Summarizing Data

Dataset: Sales_Data.csv

• Tasks: Joins, grouping, descriptive stats, correlation, ANOVA

• CO: CO4

• BL: Analysing, Evaluating

Problem 5: Data Preprocessing (Advanced)

• Tasks: Handle imbalance (SMOTE, under sampling), transformation, feature


engineering

• CO: CO1, CO3

• BL: Applying, Creating

Problem 6: Data Analysis

• Tasks: EDA, hypothesis testing, correlation

• CO: CO4

• BL: Analysing, Evaluating

Problem 7: Data Visualization

• Tasks: Distributions, relationships, interactive dashboard

• CO: CO5

• BL: Applying, Creating

Rubrics Total Marks: 05

Score Range Overall Performance Description

5 Marks (Excellent) Demonstrates full understanding and correct application of


preprocessing, EDA, analysis, and visualization with insightful
interpretation.

3–4 Marks (Good) Performs most tasks correctly; minor gaps in analysis or
visualization; insights moderately clear.
1–2 Marks (Needs Incomplete or incorrect preprocessing/statistical steps; limited
Improvement) insights or unclear presentation.

0 Marks (Not Missing or irrelevant submission.


Attempted)

You might also like