1 Don't edit Yellow color cells in both sheets

2 Don't change the format

3 Only when taking print out you can change the format but don't save it.
4 For any queries related to changing the format to be discussed with IQAC
 ANAND INSTITUTE OF HIGHER TECHNOLOGY, Kazhipattur, Chennai-603 103.
LESSON PLAN - THEORY
DEPARTMENT OF ARTIFICIAL INTELLIGENCE AND DATA SCIENCE

Name of the Subject Data Exploration and Visualization Regulation 2021

Subject Code AD3301 Year/Sem II / 3
Academic Year 2024-2025 ODD Batch A
Course Objectives
To outline an overview of exploratory data analysis.
To implement data visualization using Matplotlib.
To perform univariate data exploration and analysis.
To apply bivariate data exploration and analysis.
To use Data exploration and visualization techniques for multivariate and time series data.
Course Outcomes
At the end of the course the students would be able to
CO1: Understand the fundamentals of exploratory data analysis.
CO2: Implement the data visualization using Matplotlib.
CO3 : Perform univariate data exploration and analysis.
CO4 : Apply bivariate data exploration and analysis.
CO5 : Use Data exploration and visualization techniques for multivariate and time series data.
Blooms Level
Level 1 (L1): Remembering Level 4 (L4): Analysing
Level 2 (L2): Understanding Level 5 (L5): Evaluating
Level 3 (L3): Applying Level 6 (L6): Creating
Lesson Plan

Mode of Teaching
T/R* Periods Tentative Date Blooms Level
Sl.No. Topic(s) (BB/PPT/GL/ Pedagogical activities CO PO & PSO
Book Required of Completion (L1 - L6)
etc.)

UNIT - I EXPLORATORY DATA ANALYSIS 10

PO1 - PO4,PO9 - PO12,

1 EDA fundamentals – Understanding data science T1, R1 1 12/8/2024 BB CO1
L1,L2,L3 PSO1 - PSO3
Significance of EDA-Making sense of data PO1 - PO4,PO9 - PO12,
2 T1, R1 1 13/8/2024 BB CO1
L1,L2 PSO1 - PSO4
PO1 - PO4,PO9 - PO12,
3 Comparing EDA with classical and Bayesian analysis T1, R1 1 14/8/2024 BB CO1
L1,L2,L4 PSO1 - PSO5

AIHT/IQAC/LPT/01
 PO1 - PO4,PO9 - PO12,
4 Software tools for EDA T1, R1 1 17/8/24 BB CO1
L1,L2 PSO1 - PSO6
Visual Aids for PO1 - PO4,PO9 - PO12,
5 T1, R1 1 19/8/24 BB CO1
EDA L1,L2,L5 PSO1 - PSO7
PO1 - PO4,PO9 - PO12,
6 Data transformation techniques-merging database, reshaping and pivoting T1, R1 1 20/8/2024 BB CO1
L1,L2 PSO1 - PSO8
reshaping and pivoting, Transformation PO1 - PO4,PO9 - PO12,
7 T1, R1 1 21/8/2024 BB CO1
techniques L1,L2,L6 PSO1 - PSO9
PO1 - PO4,PO9 - PO12,
8 Grouping Datasets - data aggregation T1, R1 1 22/8/2024 BB CO1
L1,L2 PSO1 - PSO10
PO1 - PO4,PO9 - PO12,
9 Pivot tables and cross-tabulations. T1, R1 1 23/8/2024 BB CO1
L1,L2 PSO1 - PSO11

10 Unit Test 1 27/8/2024

UNIT - II VISUALIZING USING MATPLOTLIB 10

PO1 - PO5,PO9 - PO12,

11 Importing Matplotlib – Simple line plots T2,R2 1 28/8/2024 BB CO2
L1,L2, L3 PSO1 - PSO3
PO1 - PO5,PO9 - PO12,
12 Simple scatter plots – visualizing errors T2,R2 1 29/8/2024 BB CO2
L1,L2, L3 PSO1 - PSO4
PO1 - PO5,PO9 - PO12,
13 density and contour plots T2,R2 1 29/8/2024 BB CO2
L1,L2, L3, L4 PSO1 - PSO5
PO1 - PO5,PO9 - PO12,
14 Histograms – legends T2,R2 1 31/8/2024 BB CO2
L1,L2 PSO1 - PSO6
PO1 - PO5,PO9 - PO12,
15 colors – subplots T2,R2 1 2/9/2024 BB CO2
L1,L2, L3, L4 PSO1 - PSO7
PO1 - PO5,PO9 - PO12,
16 text and annotation – customization T2,R2 1 3/9/2024 BB CO2
L1,L2, L3 PSO1 - PSO8
PO1 - PO5,PO9 - PO12,
17 three dimensional plotting T2,R2 1 4/9/2024 BB CO2
L1,L2, L3, L4 PSO1 - PSO9
PO1 - PO5,PO9 - PO12,
18 Geographic Data with Basemap T2,R2 1 5/9/2024 BB CO2
L1,L2, L3, L4 PSO1 - PSO10
PO1 - PO5,PO9 - PO12,
19 Visualization with Seaborn. T2,R2 1 5/9/2024 BB CO2
L1,L2 PSO1 - PSO11

20 Unit Test 1 6/9/2024

UNIT - III UNIVARIATE ANALYSIS 10

PO1 - PO5,PO9 - PO12,

21 Introduction to Single variable T3,R3 1 9/9/2024 BB CO3
L1,L2 PSO1 - PSO3
PO1 - PO5,PO9 - PO12,
22 Distributions T3,R3 1 10/9/2024 BB CO3
L1,L2 PSO1 - PSO4
PO1 - PO5,PO9 - PO12,
23 Variables T3,R3 1 11/9/2024 BB CO3
L1,L2, L3 PSO1 - PSO5
PO1 - PO5,PO9 - PO12,
24 Numerical Summaries of Level T3,R3 1 12/9/2024 BB CO3
L1,L2, L3, L4 PSO1 - PSO6

AIHT/IQAC/LPT/01
 PO1 - PO5,PO9 - PO12,
25 Spread T3,R3 1 12/9/2024 BB CO3
L1,L2 PSO1 - PSO7
PO1 - PO5,PO9 - PO12,
26 Scaling T3,R3 1 14/9/2024 BB CO3
L2, L3, L4 PSO1 - PSO8
PO1 - PO5,PO9 - PO12,
27 Standardizing T3,R3 1 16/9/2024 BB CO3
L1,L2, L3 PSO1 - PSO9
PO1 - PO5,PO9 - PO12,
28 Inequality T3,R3 1 17/9/2024 BB CO3
L1,L2, L3 PSO1 - PSO10
PO1 - PO5,PO9 - PO12,
29 Smoothing Time Series T3,R3 1 18/9/2024 BB CO3
L1,L2, L3, L4 PSO1 - PSO11

30 Unit Test 1 19/9/2024

UNIT - IV BIVARIATE ANALYSIS 10

PO1 - PO4,PO9 - PO12,

31 Relationships between Two Variables T3,R3 2 23/9/24 24/9/24 BB CO4
L2, L3 PSO1 - PSO3
PO1 - PO4,PO9 - PO12,
32 Percentage Tables T3,R3 1 25/9/2024 BB CO4
L2, L3 PSO1 - PSO4
PO1 - PO4,PO9 - PO12,
33 Analyzing Contingency Tables T3,R3 2 26/9/2024 BB CO4
L2, L3 PSO1 - PSO5
PO1 - PO4,PO9 - PO12,
34 Handling Several Batches T3,R3 1 28/9/2024 BB CO4
L2, L3, L4 PSO1 - PSO6
PO1 - PO4,PO9 - PO12,
35 Scatterplots T3,R3 1 28/9/2024 BB CO4
L2, L3, L5 PSO1 - PSO7
PO1 - PO4,PO9 - PO12,
36 Resistant Lines T3,R3 1 30/9/2024 BB CO4
L2, L3, L6 PSO1 - PSO8
PO1 - PO4,PO9 - PO12,
37 Transformations. T3,R3 1 1/10/2024 BB CO4
L1, L2 PSO1 - PSO9

38 Unit Test 1 3/10/2024

UNIT - V MULTIVARIATE AND TIME SERIES ANALYSIS 10

PO1 - PO5,PO9 - PO12,

39 Introducing a Third Variable T3,R3 1 7/10/2024 BB CO5
L1,L2, L3 PSO1 - PSO3
PO1 - PO5,PO9 - PO12,
40 Causal Explanations T3,R3 1 8/10/2024 BB CO5
L1,L2, L3 PSO1 - PSO4
Three-Variable Contingency Tables and PO1 - PO5,PO9 - PO12,
41 T3,R3 1 9/10/2024 BB CO5
Beyond L1,L2, L3 PSO1 - PSO5
PO1 - PO5,PO9 - PO12,
42 Longitudinal Data T3,R3 1 10/10/2024 BB CO5
L1, L2 PSO1 - PSO6
PO1 - PO5,PO9 - PO12,
43 Fundamentals of TSA T3,R3 1 10/10/2024 BB CO5
L1, L2 PSO1 - PSO7
PO1 - PO5,PO9 - PO12,
44 Characteristics of time series data T3,R3 1 14/10/2024 BB CO5
L1, L2 PSO1 - PSO8
PO1 - PO5,PO9 - PO12,
45 Data Cleaning T3,R3 1 15/10/2024 BB CO5
L1, L2 PSO1 - PSO9

AIHT/IQAC/LPT/01
 PO1 - PO5,PO9 - PO12,
46 Time-based indexing T3,R3 1 16/10/2024 BB CO5
L1,L2, L3 PSO1 - PSO10
PO1 - PO5,PO9 - PO12,
47 Visualizing – Grouping – Resampling T3,R3 1 17/10/2024 BB CO5
L1,L2, L4 PSO1 - PSO11

48 Unit Test 1 21/10/2024

Content Beyond the Syllabus Planned

1 Exploratory Data Analysis (EDA)

2 R Tool

Text Books

1 Suresh Kumar Mukhiya, Usman Ahmed, “Hands-On Exploratory Data Analysis with Python”, Packt Publishing, 2020.

2 Jake Vander Plas, "Python Data Science Handbook: Essential Tools for Working with Data", Oreilly, 1st Edition, 2016.

3 Catherine Marsh, Jane Elliott, “Exploring Data: An Introduction to Data Analysis for Social Scientists”, Wiley Publications, 2nd Edition, 2008.

Reference Books

1 Eric Pimpler, Data Visualization and Exploration with R, GeoSpatial Training service, 2017.

2 Claus O. Wilke, “Fundamentals of Data Visualization”, O’reilly publications, 2019.

3 Matthew O. Ward, Georges Grinstein, Daniel Keim, “Interactive Data Visualization: Foundations, Techniques, and Applications”, 2nd Edition, CRC press, 2015.

Website / URL References

1 https://www.google.com/url?sa=t&source=web&rct=j&opi=89978449&url=https://books.google.com/books/about/Hands_On_Exploratory_Data_Analysis_with.html%3Fi
2 https://www.google.com/url?sa=t&source=web&rct=j&opi=89978449&url=https://www.academia.edu/41754867/Python_Data_Science_Handbook&ved=2ahUKEwifhcD8
3 https://www.google.com/url?sa=t&source=web&rct=j&opi=89978449&url=https://books.google.com.gi/books%3Fid%3DqAcXIgxMF98C%26printsec%3Dfrontcover&ved=

CO PO Mapping

PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PO11 PO12 PSO1 PSO2 PSO3 PSO4

CO1 3 1 3 3 - - - - 2 3 3 3 2 2 2 -

CO2 2 2 2 1 1 - - - 3 2 3 1 3 1 3 -

CO3 2 1 2 1 1 - - - 3 2 1 2 2 2 1 -

CO4 2 2 2 1 - - - - 1 2 1 3 1 3 2 -

CO5 3 1 1 2 1 - - - 3 2 1 2 2 2 3 -

Avg 2 1 2 2 1 - - - 2 2 2 2 2 2 2 -

Assignments planned Units

Assignment -1 2

Assignment -2 4

AIHT/IQAC/LPT/01
 Assignment -3 5

Academic Calendar (Proposed Date)

MT I: 18/9/2024

MT II: 15/10/2024

Model Examination: 7/11/24

*Kindly sign with date

Name & Sign of Faculty in charge:

Head of the Department:

Principal:

AIHT/IQAC/LPT/01
 ANAND INSTITUTE OF HIGHER TECHNOLOGY, Kazhipattur, Chennai-603 103.
LESSON PLAN - THEORY

ANAND INSTITUTE OF HIGHER TECHNOLOGY, Kazhipattur, Chennai-603 103.

LESSON PLAN - THEORY
DEPARTMENT OF COMPUTER SCIENCE AND BUSINESS SYSTEMS

Name of the Subject Data Exploration and Visualization Regulation 2021

Subject Code AD3301 Year/Sem II / 3
Academic Year 2024-2025 ODD Batch A
Course Objectives
To outline an overview of exploratory data analysis.
To implement data visualization using Matplotlib.
To perform univariate data exploration and analysis.
To apply bivariate data exploration and analysis.
To use Data exploration and visualization techniques for multivariate and time series data.
Course Outcomes
At the end of the course the students would be able to
CO1: Understand the fundamentals of exploratory data analysis.
CO2: Implement the data visualization using Matplotlib.
CO3 : Perform univariate data exploration and analysis.
CO4 : Apply bivariate data exploration and analysis.
CO5 : Use Data exploration and visualization techniques for multivariate and time series data.

Lesson Plan

T/R* Periods Tentative Date of Actual Date of

Sl.No. Topic(s) Book Required Completion Completion
Periods Taken Remarks

UNIT - I EXPLORATORY DATA ANALYSIS 10 0

1 EDA fundamentals – Understanding data science T1, R1 1 12/8/2024 12/8/2024 8

2 Significance of EDA-Making sense of data T1, R1 1 13/8/2024 13/8/2024 8

3 Comparing EDA with classical and Bayesian analysis T1, R1 1 14/8/2024

4 Software tools for EDA T1, R1 1 17/8/24

Visual Aids for
5 T1, R1 1 19/8/24
EDA
6 Data transformation techniques-merging database, reshaping and pivoting T1, R1 1 20/8/2024
reshaping and pivoting, Transformation
7 T1, R1 1 21/8/2024
techniques

AIHT/IQAC/LPT/01
 ANAND INSTITUTE OF HIGHER TECHNOLOGY, Kazhipattur, Chennai-603 103.
LESSON PLAN - THEORY

8 Grouping Datasets - data aggregation T1, R1 1 22/8/2024

9 Pivot tables and cross-tabulations. T1, R1 1 23/8/2024

10 Unit Test 0 1 27/8/2024

UNIT - II VISUALIZING USING MATPLOTLIB 10 0

11 Importing Matplotlib – Simple line plots T2,R2 1 28/8/2024

12 Simple scatter plots – visualizing errors T2,R2 1 29/8/2024

13 density and contour plots T2,R2 1 29/8/2024

14 Histograms – legends T2,R2 1 31/8/2024

15 colors – subplots T2,R2 1 45331

16 text and annotation – customization T2,R2 1 3/9/2024

17 three dimensional plotting T2,R2 1 4/9/2024

18 Geographic Data with Basemap T2,R2 1 5/9/2024

19 Visualization with Seaborn. T2,R2 1 5/9/2024

20 Unit Test 1 6/9/2024

UNIT - III UNIVARIATE ANALYSIS 10 0

21 Introduction to Single variable T3,R3 1 9/9/2024

22 Distributions T3,R3 1 10/9/2024

23 Variables T3,R3 1 45605

24 Numerical Summaries of Level T3,R3 1 45635

25 Spread T3,R3 1 45635

26 Scaling T3,R3 1 14/9/2024

27 Standardizing T3,R3 1 16/9/2024

28 Inequality T3,R3 1 17/9/2024

29 Smoothing Time Series T3,R3 1 18/9/2024

30 Unit Test 1 19/9/2024

UNIT - IV BIVARIATE ANALYSIS 10 0

31 Relationships between Two Variables T3,R3 2 23/9/24 24/9/24

32 Percentage Tables T3,R3 1 25/9/2024

33 Analyzing Contingency Tables T3,R3 2 26/9/2024

34 Handling Several Batches T3,R3 1 28/9/2024

35 Scatterplots T3,R3 1 28/9/2024

36 Resistant Lines T3,R3 1 30/9/2024

37 Transformations. T3,R3 1 1/10/2024

AIHT/IQAC/LPT/01
 ANAND INSTITUTE OF HIGHER TECHNOLOGY, Kazhipattur, Chennai-603 103.
LESSON PLAN - THEORY

38 Unit Test 1 3/10/2024

UNIT - V MULTIVARIATE AND TIME SERIES ANALYSIS 10 0

39 Introducing a Third Variable T3,R3 1 7/10/2024

40 Causal Explanations T3,R3 1 8/10/2024

Three-Variable Contingency Tables and
41 T3,R3 1 9/10/2024
Beyond
42 Longitudinal Data T3,R3 1 10/10/2024

43 Fundamentals of TSA T3,R3 1 10/10/2024

44 Characteristics of time series data T3,R3 1 14/10/2024

45 Data Cleaning T3,R3 1 15/10/2024

46 Time-based indexing T3,R3 1 16/10/2024

47 Visualizing – Grouping – Resampling T3,R3 1 17/10/2024

48 Unit Test 1 21/10/2024

Total Hours 50

*Kindly sign with date

Name & Sign of Faculty in charge:

Head of the Department:

Principal:

AIHT/IQAC/LPT/01
ANAND INSTITUTE OF HIGHER TECHNOLOGY, Kazhipattur, Chennai-603 103.
LESSON PLAN - THEORY

AIHT/IQAC/LPT/01