Diploma in Mechanical Engineering 2020-21 C20

Government of Karnataka
Department of Collegiate and Technical Education
Board of Technical Examinations, Bangalore

Course Code 20SC02P Semester I/II

Course Title STATISTICS AND Course Group Core
ANALYTICS
No. of Credits 4 Type of Course Lecture and practice
Course Category Practice Total Contact 6 Hrs Per Week
Hours
78 Hrs Per Semester
Prerequisites 10TH LEVEL Teaching Scheme (L: T:P)-1:0:2
MATHEMATICS
CIE Marks 60 SEE Marks 40

RATIONALE
Statistics and analytics help the learner to use the proper methods to collect the data,
employ the correct analyses, effectively present the results and conduct research, to be
able to read and evaluate journal articles, to further develop critical thinking and analytic
skills, to act as an informed consumer and to know when you need to hire outside
statistical help. The python language is one of the most accessible programming languages
available because it has simplified syntax and not complicated, which gives more
emphasis on natural language.

COURSE OUT COMES

At the end of the course, student will be able to

CO1 Understand the tools of data collection, classification and cleaning of data.

CO2 Able to summarize the given statistical data

CO3 Understand the measure of location and dispersion of data.

CO4 Learn the basics of Python programming.

Department of Collegiate & Technical Education Bengaluru-560001 Page 104

 Diploma in Mechanical Engineering 2020-21 C20

DETAILS OF COURSE CONTENT

The following topics/subtopics is to be taught and assessed in order to develop Unit Skill
Sets for achieving CO to attain identified skill sets.
Unit skill set Hours
UNIT NO Topics/Subtopics
(In cognitive domain) L-T-P
Ø Able to collect a Definition of data and
statistical data. classification (qualitative
Ø Able to distinguish quantitative discrete and
the data types. continuous data).
UNIT-1 Ø Understands the b Data collection tools
usage of data iv) Questionnaires.
STATISTICAL collection tools v) Survey. 4-0-8
DATA
Ø Able to specify vi) Interviews.
COLLECTION AND
problem statement vii) Focus group discussion.
TYPES for data collection 1.3 Data cleaning.
Ø Able to collect data
pointing the root
cause of the
problem statement.
Ø Sketches bar, pie a Descriptive statistics
and histograms on viii)
Microsoft Excel Datatabulation(frequency
spread sheet. table
Ø Sketches frequency ix) Relative frequency table.
curve and b Grouped data
frequency polygon x) Bar graph
for the data set on xi) Pie chart
UNIT-2 Microsoft Excel xii) Line graph
spread sheet. 8-0-
SUMMARIZATION xiii) Frequency polygon 16
OF DATA Ø Sketches bar, pie
xiv) Frequency curve
and histograms on
xv) Relative frequency
Microsoft Excel
spread sheet. polygon
Ø Sketches frequency xvi) Histograms
curve and xvii) Box plot
frequency polygon xviii) Leaf-stem plot
for the data set on To be done in Microsoft excel.
Microsoft Excel
spread sheet.
UNIT-3 Ø Able to determine a Determination of central
the descriptive tendencies Range, Mean, Mode and 6-0-
MEASURE OF
statistical variables Median for the data in Microsoft 12
LOCATION AND
using Microsoft excel.
DISPERSION b Determination of absolute
Excel.

Department of Collegiate & Technical Education Bengaluru-560001 Page 105

 Diploma in Mechanical Engineering 2020-21 C20

Ø Able to determine measures of dispersion for data

the absolute like range quartile deviation,
measures of mean deviation, standard
dispersion of the deviation and variance in
given data set. Microsoft Excel.
Ø Explain the symmetry c Skewness and kurtosis graphs in
and asymmetry of the Microsoft excel and
distributed data. interpretations of results.
Ø Able Install and run the 4.1 Introduction to PYTHON.
Python interpreter. 4.2 Syntax of PYTHON.
Create and execute 4.3 Comments of PYTHON.
UNIT-4 Python programs. 4.4 Data types of PYTHON.
Ø Understand the 4.5 Variables of PYTHON.
INTRODUCTION
concepts of file I/O. 4.6 If-else in PYTHON.
TO 8-0-
Ø Able to read data from 4.6 Loops in PYTHON.
PYTHON 4.7 Arrays and functions in PYTHON. 16
a text file using Python.
PROGRAMMING Ø Learn variable
declarations in Python.
Ø Learn control
structures.
Ø Learn loop constructs.

Department of Collegiate & Technical Education Bengaluru-560001 Page 106

 Diploma in Mechanical Engineering 2020-21 C20
SL Unit
Practical outcomes/Practical exercises PO CO L:T:P
NO no
Prepare a questionnaire (closed end) containing 25
1 questions for a specified problem statement: for example 1 1,2,4,5,7 1 0:0:2
experience of an individual in a restaurant.
Prepare a Google form for a specified problem statement
2 to collect the dataset. (for example questionnaire to 1 1,2,4,5,7 1 0:0:2
conduct online quiz)
Send out a survey on your problem statement to number
3 of 50 1 1,2,4,5,7 1 0:0:2
(By Google forms) and collect the data.
Remove duplicate or irrelevant observations. Remove
unwanted observations from the dataset provided,
4 1 1,2,4,5,7 1 0:0:2
including duplicate observations or irrelevant
observations.
In Microsoft Excel spread sheet draw the frequency
5 distribution table for the given data (data set should 2 1,2,4,5,7 2 0:0:2
contain minimum 50 data).
In Microsoft Excel spread sheet draw the relative
6 frequency distribution table for the given data (data set 2 1,2,4,5,7 2 0:0:2
should contain minimum 50 data).
Using Microsoft Excel spread sheet plot bar graph for the
data collected from 100 people( for example, conduct a
7 survey on the favorite fruit of a person in your 2 1,2,4,5,7 2 0:0:2
locality(restricting to 5 to 6 fruits). Explain the bar graph
with minimum 30 words.
Using Microsoft Excel spread sheet plot pie chart for the
data collected from 50 people( for example, conduct a
8 2 1,2,4,5,7 2 0:0:2
survey on the smokers with respect to their ages in your
locality. Explain the pie chart with minimum 30 words.
Using Microsoft Excel spread sheet draw a line graph for
9 2 1,2,4,5,7 2 0:0:2
the given dataset.
Using Microsoft Excel spread sheet draw frequency
polygon and frequency curve for the data collected from
50 people. (For example, marks obtained by the students
10 2 1,2,4,5,7 2 0:0:2
in your class in 5 subjects in previous examination).
Explain your observations from the graph in minimum 30
words.
Using Microsoft Excel spread sheet construct a box plot
for the given dataset. (For example dataset can be the
11 2 1,2,4,5,7 2 0:0:2
number of passengers in a flat form at different time in a
day).
Using Microsoft Excel spread sheet construct a leaf plot
12 for the given dataset. Explain the graph with minimum 30 2 1,2,4,5,7 2 0:0:2
words.

Department of Collegiate & Technical Education Bengaluru-560001 Page 107

 Diploma in Mechanical Engineering 2020-21 C20

Using Microsoft Excel spread sheet find the Mean, Mode

13 and Median for the data (univariate data) given and also 3 1,2,4,5,7 2 0:0:2
represent them in a Histogram.
Generate a 50 random data sample (even and odd
14 number dataset) using Microsoft Excel spread sheet 3 1,2,4,5,7 2 0:0:2
and determine the range and Quartiles.
Collect the current yield of a crop from 50 different
persons (problem statement can be changed according
to priorities of the tutor) in your locality and determine 0:0:2
15 3 1,2,4,5,7 3
mean deviation and Quartile deviation in Microsoft
excel spread sheet and brief your inference with less
than 30 words.
Collect the data of any 2 livestock population from 50
different houses in your locality (problem statement
can be changed according to priorities of the tutor) and
16 3 1,2,4,5,7 3 0:0:2
determine standard deviation for both the two
separately in Microsoft excel spread sheet and brief
your inference with less than 30 words.
Collect the data of two wheeler (with a rider and a
pillion) crossing a busy junction in your locality in the
peak hours (problem statement can be changed 0:0:2
17 3 1,2,4,5,7 3
according to priorities of the tutor) and determine the
variance of the data in Microsoft excel spread sheet and
brief your inference with less than 30 words.
Using Microsoft Excel spread sheet draw a Skewness
0:0:2
18 graph and kurtosis graph for randomly generated 3 1,2,4,5,7 3
dataset.
Write a python program to add 2 integers and 2 strings 0:0:2
20 4 1,2,4,5,7 4
and print the result.
Write a python program to find the sum of first 10 0:0:2
21 4 1,2,4,5,7 4
natural numbers.
Write a python program to find whether the number is 0:0:2
22 4 1,2,4,5,7 4
odd or even.
Write a python program to find the variance and 0:0:2
23 4 1,2,4,5,7 4
standard deviation for the given data..
Write a python program to display student marks from 0:0:2
24 4 1,2,4,5,7 4
the record.
Write a python program to create a labeled bar graph 0:0:2
25 4 1,2,4,5,7 4
using matpoltlib. pyplot.
Write a python program to create a labeled pie chart
26 4 1,2,4,5,7 4 0:0:2
using matpoltlib. pyplot.
0:0:52=5
Total Hours
2

Department of Collegiate & Technical Education Bengaluru-560001 Page 108

 Diploma in Mechanical Engineering 2020-21 C20

MAPPING OF CO WITH PO

Experi Tutorial &

Cognitive
PO ment Practical
TOT
CO Course Outcome Linked Level
Mapped Sessions AL
R/U/A
in Hrs.

CO1 Understand the tools of data

collection, classification and 1,2,4,5,7 1-4 A 12 12
cleaning of data.
CO2 Able to summarize the given
1,2,4,5,7 5-12 A 33 33
statistical data
CO3 Understand the measure of
1,2,4,5,7 13-18 A 12 12
location and dispersion of data.
CO4 Learn the basics of Python
1,2,4,5,7 19-26 A 21 21
programming.

78 78

Programme Outcomes (PO’s)

Course CO’s
1 2 3 4 5 6 7
CO1 3 3 0 3 3 0 3
CO2 3 3 0 3 3 0 3
Statistics & Analytics
CO3 3 3 0 3 3 0 3
CO4 3 3 0 3 3 0 3
Level 3- Highly Mapped, Level 2-Moderately Mapped, Level 1-Low Mapped,
Level 0- Not Mapped

Department of Collegiate & Technical Education Bengaluru-560001 Page 109

 Diploma in Mechanical Engineering 2020-21 C20

SUGGESTED LEARNING RESOURCES:

1. Statistical Analysis with Excel For Dummies (For Dummies Series) Paperback
Import, 9 April 2013 by Joseph Schmuller (Author)
2. https://www.brianheinold.net/python/A Practical Introduction to Python Progra
mmingHeinold.pdf
3. http://www.bikeprof.com/uploads/9/0/6/5/9065192/excel stats handout npl.pdf
4. https://adminfinance.umw.edu/tess/files/2013/06/Excel-Manual1.pdf
5. https://www.brianheinold.net/python/A Practical Introduction to Python Progra
mmingHeinold.pdf
6. Introduction to Python programming for beginners by Vivian Baily Kindle edition.
7. PYTHON PROGRAMMING: Python programming: the ultimate guide from a beginner
to expert by Clive Campbell.
8. Open source for python: https://hub.gke2.mybinder.org/user/jupyterlab-
jupyterlab-demo-zfkdwy4y/lab

SUGGESTED LIST OF STUDENT ACTIVITY

Note: The following activities or similar activities for assessing CIE (IA) for 10 marks
(Any one)
Describe the data collection activity itself (interviews, surveys, library research,
etc.) AND why this specific form of data collection was chosen. Be sure to explain
why you think this kind of data will help you in your design process. Also be sure
to provide details about the activity: how many interviews, how long they took,
where they took place, how many questions asked in a survey, how many
respondents, etc.
Present the results of your data collection. You do not have to have completely
analyzed all your data, but do make sure you present the results of your research.
If you did a survey, please attach a copy of the survey as an appendix; if you did
interviews, please attach a copy of the interview questions.
Discuss any preliminary analysis of your data. What have you learned thus far from
the data should be discussed from an analytical perspective (rather than a data
1 dump). For example, if you surveyed people about their use of the local bus system,
and 90% of your respondents said they take the bus when it is raining, and 60% of
your respondents said they usually wait more than 10 minutes for a bus, think
about what this teaches you rather than just the information itself. In this instance,
you can see that people are generally waiting for several minutes in the rain for a
bus, so a covered bus stop might be a good idea. Keep in mind that your findings
from data should lead directly to the conclusions you make about your design
recommendations. This is the time to begin thinking very specifically about your
research in those terms. This is also an opportunity to think about your definition
of “better” and how it applies to your design goals and your choice of research
activities (for example, if you are choosing to make something better by making it
cheaper, maybe you are interviewing people to see how much loss of functionality
or decrease in features for a technology they are willing to tolerate).
https://ils.unc.edu/courses/2013 spring/inls541 001/Assignments.html#Assign
2 ment 9

Department of Collegiate & Technical Education Bengaluru-560001 Page 110

 Diploma in Mechanical Engineering 2020-21 C20

DOWNLOAD a dataset from the above link and use data visualization tools to
analyze it.
Acquire the dataset from https://www.kaggle.com/datasets (For example
acquire the data of IPL ball by ball scores and find the standard deviation and
3 variance of score of a batsmen)and clean the data for the root cause of the
problem statement and summarize the date and explain the inference.

COURSE ASSESSMENT AND EVALUATION CHART

Meth What To When/Wh Max Evidence Course

od whom ere Mar collected outcomes
(Frequenc ks
y in the
course)
CIE Mode Studen Two IA 20 Blue Book 1,2,3.
(Continuo ls ts Tests
us Internal (Written)
DIRECT ASSESSMENT

Evaluation Three Skill 20 Model 1,2,3

) tests
Student 20 Model/Rep
Activity ort
TOTAL 60
SEE End End of the 100 Models 1,2,3
(Semester Exam course
End
Examinati
on)
Student Feedback Studen Middle of Feedback 1,2,3,
INDIRECT ASSESSMENT

on course ts the course forms Delivery of

course
End of Course End of the Questionnai 1,2,3
Survey course res Effectiveness
of
Demonstratio
ns&
Assessment
Methods

Department of Collegiate & Technical Education Bengaluru-560001 Page 111

 Diploma in Mechanical Engineering 2020-21 C20

Sl.No Assessment Duration Max Conversion

marks
CIE Assessment 1 (Written Test -1-theory) 60 Average of
1 20
- At the end of 3rd week minutes two written
CIE Assessment 2 (Written Test -2-theory) 60 tests
2 20
- At the end of 13 week
th minutes 20
CIE Assessment 3 (Skill test)
3 3 Hrs 20
- At the end of 5th week Average of
CIE Assessment 4 (Skill test) three skill
4 3 Hrs 20
- At the end of 7th week tests
CIE Assessment 5 (Skill test) 20
5 3Hrs 20
- At the end of 9th week
CIE Assessment 6 (Student activity)
6 - 20 20
- At the end of 11th week
7 Total Continuous Internal Evaluation (CIE) Assessment 60
Semester End Examination (SEE) Assessment
8 3Hrs 100 40
(Practical Test)
Total Marks 100

Note:
1. CIE written test is conducted for 20 marks (Two sections). Each section shall have
two full questions of same CL, CO. Student shall answer one full question (10
marks) from each section.
2. CIE Skill test is conducted for 100 marks (3 Hours duration) as per scheme of
evaluation and the obtained marks are scaled down to 20 marks.
3. SEE is conducted for 100 Marks (3 Hours duration) as per scheme of evaluation.

Department of Collegiate & Technical Education Bengaluru-560001 Page 112

 Diploma in Mechanical Engineering 2020-21 C20

MODEL QUESTION PAPER

CIE, SKILL TEST AND SEMESTER END EXAMINATION

Course & Programme: Common to all Engineering Programmes. Semester: II

Subject: Statistics and Analytics Practice Max Marks: 100
Course Code : 20SC21P Duration : 3Hrs

Instruction to the Candidate: Answer both questions

Qn.No Question CL CO PO Marks

1 For the given ungrouped data set plot the A 2,3 1,2,4,5,7 50
bar graph by grouping the data in Microsoft
excel spread sheet and interpret the
obtained results. (Dataset. bar graphs and
interpretation have to be entered in the
answer script).
OR
Generate a random data set in Microsoft
excel spread sheet containing 50 data and
find the mean mode and median in
Microsoft excel spread sheet and interpret
the obtained results. (Dataset, bar graphs
and interpretation have to be entered in the
answer script).
2 Write the python program to enter two A 4 1,2,4,5,7 50
integers and two strings and to print the
sum two integers and two strings.

Questions are not framed from Unit 1 in the final SEE. Short questions can only be asked
from that unit.

SCHEME OF EVALUATION FOR BOTH CIE AND SEE

Sl.
Particulars Marks
No
1 Short questions from Unit 1 10
2 Observation 30

Department of Collegiate & Technical Education Bengaluru-560001 Page 113

 Diploma in Mechanical Engineering 2020-21 C20

3 Conduction 20
4 Output and Interpretation of result 20
5 Viva-voce 20

100
Total

EQUIPMENT LIST

FOR STATISTICS AND DATA ANALYTICS LAB

2 laboratories. Each containing 30 computers (Desktop) with the following system
requirements.

SYSTEM REQUIREMENTS
SL
NO REQUIREMENTS MINIMUM RECOMMENDED

1 RAM 4GB FOR FREE RAM 8GB OF TOTAL SYSTEM RAM

DISK SPACE 2.5 GB AND 1 GB FOR SSD DRIVE WITH AT LEAST 5 GB OF
2
CACHES FREE SPACE
MONITOR
3 RESOLUTION 1024x768 1920×1080

OFFICIALLY
RELEASED 64-BIT
VERSIONS OF THE
OS(OPERATING FOLLOWING: LATEST 64-BIT VERSION OF
4
SYSTEM) WINDOWS
MICROSOFT
WINDOWS 8 OR
LATER

Department of Collegiate & Technical Education Bengaluru-560001 Page 114