Government of Karnataka

Department of Collegiate and Technical Education

Board of Technical Examinations, Bangalore

Course Code 20CS01P Semester I/II

Course Title IT SKILLS Course Group ES/CS

No. of Credits 4 Type of Course Lecture + Practice

6Hrs PerWeek
Course Category ES Total Contact Hours
78Hrs Per Semester

Prerequisites Basic Computer Skills Teaching Scheme (L:T:P)= 1:0:2

CIE Marks 60 SEE Marks 40

1. RATIONALE
Information Technology is crucial to the majority of the business and has a great influence on innovation and
engineering. Every branch of engineering and every organization opt for computers and IT skills for business automation,
communication/connectivity, resource planning, work automation and securing information etc. All engineering diploma
students must be conversant with the basic IT skills which empower them to learn new technologies, adapt to changes,
business development, communication etc.

2. COURSE SKILL SET

The aim of the course is to help the student to attain the following industry identified competency through various teaching
–learning experiences.
Perform jobs related to web design and maintenance, business process automation tool management, cyber security and safety
and program assistant.

3. COURSE OBJECTIVES
1. Demonstrate the basics of coding.
2. Design and develop web pages that include static and dynamic content.
3. Describe the basic concepts of Cloud and IoT.
4. Express the workflow and business automation
5. Recognize the best practices of Cyber Safety and security.
4. JOB ROLE
SL.NO LEVEL JOB ROLES
1 3 Junior software developer - web.
2 3 Junior Creative Designer/Digital Artist

5. PREREQUISITES

BasicComputer skills(Studentswithoutbasic computerskillsshouldbetaught

STUDENT
basic skills)
TEACHER Computer science faculty with required knowledge of IT Skills.

6. COURSE OUT COMES

On successful completion of the course, the students will be able to demonstrate industry oriented Cos associated with the
above mentioned competency:
COURSE OUTCOME CL LINKED TEACHING
PO HOURS
CO1 Illustrate the basics of coding and develop simple U 1,4,7 15
applications for android phones.
CO2 Design and Develop websites. U, A 1,4,7 30

CO3 Identify Cloud Services IoT applications U, A 1,4,7 09

CO4 Apply workflow and use ERP for a simple project plan U, A 1,4,7 12

CO5 Implement best practices of cyber safety and security U, A 1,4,7 12

in the workplace.
TOTAL 78

Legends: R = Remember; U = Understand; A = Apply and above levels CL = Cognitive Level

(Bloom’s revised taxonomy)

7. SUGGESTED SPECIFICATION TABLE WITH HOURS & MARKS(THEORY)

UNIT NAME DISTRIBUTION OF
UNITNO. TEACHING THEORY MARKS
HOURS R U A TOTAL
1 Introduction to basics of coding 15
2 Design and develop web pages 30
3 Business process automation/ERP 09
 Diploma in Computer Science & Engineering 2020-21 C20

Introduction to Cloud and IoT

4 12
Concepts
5 Cybersecurity and safety 12
Total 78 200
Legends: R = Remember; U = Understand; A = Apply and above levels (Bloom’s revised
taxonomy)

8. INSTRUCTIONAL STRATERGY
These are sample strategies, which teacher can use to accelerate the attainment of the various
course outcomes

1. Lecturer method(L) does not mean only traditional lecture method, but different type of teaching methodandmedia
visual/graphicalcontentthatareemployedtodeveloptheoutcomes
2. Massive Open on-line courses (MOOCS) can be used to teach various topics/subtopics.
3. Online coding platform wherever mentioned.
4. Hands on coding should be practiced.
5. About 15 to 20% of the topics/subtopics which are relatively simpler or descriptive in nature is to be given to the
students for self-directed learning

9. 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 Topics/Sub topics Unit skill set/Learning outcomes Hours

NO
(In cognitive domain) L-T-P
1 UNIT 1 - INTRODUCTION TO BASICS OF CODING 05-0-10

Department of Collegiate & Technical Education Bengaluru-560001 Page 54

 Diploma in Computer Science & Engineering 2020-21 C20
Introductiontocomputerprogramming 1. Understand computer
Algorithms –With sufficient examples programming
Flowcharts – With sufficient examples 2. Create and write Algorithm for
Execute simpleprograms programmable problems.
Note: Below listed or any other suitable 3. Design Flowchart for
online/offline coding platforms should be programmable problems.
used to demonstrate and provide coding 4. Develop simple Android

experience to students. application.

a. https://scratch.mit.edu/

Department of Collegiate & Technical Education Bengaluru-560001 Page 55

 Diploma in Computer Science & Engineering 2020-21 C20

b. https://studio.code.org/projects

Suggested programs are listed in Table 1

Introduction to Application development
Simple android application development (No knowledge of
programming language is required). Note:

i. The purpose of application development

is to ignite and promote programming
skills.
ii. Application development should be
done using any App builder platforms
such as
iii. MITApp Inventor:
https://appinventor.mit.edu/
iv. Thunkable: https://thunkable.com/
v. ibuildapp: https://ibuildapp.com/
vi. The student should be introduced to the
android application development
environment for further research and
learninghttps://developer.android.com/
Activity: create a simple Android application
(Unique for each student) publish on the learning
management
system.

2 UNIT 2 - DESIGN AND DEVELOP WEB PAGES 10-0-20

2 Basic webtechnologies 1. Understand and examine basic web

▪ Browser technologies
▪ Web –Server 2. Creating static web pages
▪ Client-Server Model 3. Formatting Webpages with
▪ URL cascading style sheets (CSS)
▪ SEO techniques 4. Creating Dynamic web pages with
▪ Domain names and domain name system. JavaScript
Creating Web-pages with HTML5 - Static

Department of Collegiate & Technical Education Bengaluru-560001 Page 56

 Diploma in Computer Science & Engineering 2020-21 C20

web pages. 5. Creating and launching dashboard

▪ Introduction, Editors based personal website.
▪ Tags, Attributes, Elements, Headings
▪ Links, Images, List, Tables, Forms
▪ Formatting, Layout, Iframes.
Formatting web pages with style sheets (CSS3).
▪ Introduction toCSS
▪ Inline CSS, Internal CSS, Classes and IDs
▪ div, Color, Floating, Positioning
▪ Margins, Padding, Borders
▪ Fonts, Aligning Text, Styling Links
Creating a web page dynamic using JavaScript.
▪ Dynamic web page and Introduction to JS
▪ Basic syntax
▪ Functions
▪ Events
Note: Refer https://www.w3schools.com
2.6 Creating dashboards in websites.
Activity: Personal website design and
launch with a free platform or Create a
Blogging website.
▪ Online platforms (Learning and
executing)
▪ https://www.w3schools.com/
▪ https://studio.code.org
▪ https://www.khanacademy.org
Note:
1) The student must be introduced to
website development platforms -
worldpress.com.
2) The student must be made familiar

Department of Collegiate & Technical Education Bengaluru-560001 Page 57

 Diploma in Computer Science & Engineering 2020-21 C20

with launching websites.

Certification available:
• HTML -W3schools
• CSS -W3schools
• JavaScript -W3schools
3 UNIT 3 -BUSINESS PROCESS AUTOMATION/ERP 03:0:06

3 Introduction to business process 1. Identify and examine the needs of

automation. business process automation.
Organization structure and functions 2. Understand Organization
composition-Properties and applications structure and functions
▪ Structure 3. Create and use workflows
▪ Types 4. Use Enterprise resource
▪ Functional Units planning in workplace.
Note: Students should be made familiar with
organization, types and components of a big
enterprise to make him understand the
working of organization keeping him as part
of org.
Workflows
▪ Introduction
▪ Components
▪ Use and use cases
Note: Use free and open-source platform to
demonstrate and create workflows.
Example:
https://airflow.apache.org/
https://taverna.incubator.apache.org/
https://trello.com/
https://www.processmaker.com/
Enterprise resource planning
▪ History
▪ Evolution
▪ Uses of ERP
▪ ERP softwaretools.

Department of Collegiate & Technical Education Bengaluru-560001

 Diploma in Computer Science & Engineering 2020-21 C20

Note: The student should be introduced into

Enterprise resource planning software tools
to understand importance of ERP.
Examples:
▪ https://erpnext.com/
▪ www.bitrix24.com
▪ https://www.odoo.com/
Activity:
▪ Project plan for summer internship -
use open source ERP Software
▪ Identify different components of
nearby organization with recourse
plan and workflow design.
▪ Identify types of ERP software
available with their market share.
4 04-0-8
UNIT 4 - INTRODUCTION TO CLOUD AND IOT CONCEPTS
Fundamentals ofcloud 1. Understand Cloudconcepts
Cloud servicemodels
2. Identify and use Cloud services
▪ IaaS (Infrastructure-as-a-Service)
3. UnderstandIoT concepts
▪ PaaS (Platform-as-a-Service)
▪ SaaS (Software-as-a-Service) 4. Identify IoT applications
Cloud deploymenttypes
▪ Public,
▪ Private,
▪ Hybrid
▪ Community Cloud
Cloud services:
▪ Google Drive - file storage and synchronization
service developed by Google;
▪ Google docs- bring your documents to life with smart
editing and styling tools to help you easily format text
and paragraphs;
▪ Google Co-lab (Usage of Jupyter Notebook):
Colab notebooks allow you to combine

Department of Collegiate & Technical Education Bengaluru-560001

 Diploma in Computer Science & Engineering 2020-21 C20

executable code and rich text in a single document,

along with images, HTML, LaTeX, and more.
▪ Google App Engine: Google App Engine is a Platform
as a Service and cloud computing platform for
developing and hosting web applications in Google-
managed data centers. Applications are sandboxed and
run across multiple servers.

Note: Above cloud services are not compulsory

for all branches; teacher can recommend
other cloud service based on need of
engineering branch.

Working of IoT and IoT components (Only brief

introduction and demonstration through videos)
Explain concept of Internet of Things with examples
▪ Smart home
▪ Smart city
▪ Smart farming
Note:
a. Teacher can also select specific area of
work where Things (autonomous
computing devices) could be
interconnected over TCP/IP to establish
IoT.
b. The students should be introduced to the
IoT environment for further research
and study.
Example:
▪ https://www.raspberrypi.org/
▪ https://www.arduino.cc/

Department of Collegiate & Technical Education Bengaluru-560001

 Diploma in Computer Science & Engineering 2020-21 C20

4.7 Activity:
Create your cloud service account and
demonstrate using cloud services.
Identify cloud service provider with respect
to service models and deployment types.
Identify areas where Internet of Things could
bring positive changes.
5 UNIT 5 - CYBERSECURITY AND SAFETY 4-0-8

Introduction to Cyber security and cyber safety. 1. Identify need for Cyber
▪ Brief awareness on cyber safety security and cyber safety
measures 2. Identify basic security issues in
▪ Identification of basic security issues in mobile mobile phones andpersonal
phones and personalcomputers computers
▪ Installation of Antivirus software
3. Examine Importance of
▪ Firewall concepts
privacy, Password policy
▪ Browser settings
4. Implement best practices of
▪ Importance of privacy and Password policy
cyber safety and security in
(Bestpractices).
Common threats - Demonstration work place
▪ Phishing
▪ DoS attack
▪ Man in the middle attack
▪ Eavesdropping
▪ Spamming
Activity
▪ Identification of basic security issues in
computers of your college and fixing the
same.
▪ Visit nearby government organization.
▪ Identify basic cybersecurity issues
and fixing the same
▪ Demonstrate the importance of
cybersecurity, password policy, and
cyber safety.

Department of Collegiate & Technical Education Bengaluru-560001

 Diploma in Computer Science & Engineering 2020-21 C20

10. SUGGESTED PRACTICAL SKILL EXERCISES

TABLE-I

Unit
Sl. No. Practical Out Comes/Practical exercises PO CO
No.
Write an algorithm for programmable problems Example for
Reference:
1 • Add/subtract two numbers 1 1,4,7 1
• Find the largest/smallest of 3 numbers
• Calculate and print sum of 'N' numbers
Design a flowchart for programmable problems Example
for Reference:
2 Add/subtract two numbers 1 1,4,7 1
Find the largest/smallest of 3 numbers Calculate
and print sum of 'N' numbers
3 DesignandcreatesimplegameusingMIT-scratch/Code.org 1 1,4,7 1
4 Design and create simple android application (MIT App Inventor) 1 1,4,7 1
Design and create webpage for displaying your poem (Title,
5 2 1,4,7 2
header, paragraph, formatting tags)
Design and create webpage for your wish list (What you want to do).Alsolist
6 challengesandopportunitiesalongwithimagesto 2 1,4,7 2
present your dreams (List ordered and unordered, Image, table)
Design and create webpage using HTML and CSS about an
7 2 1,4,7 2
awesome animal (Use necessary CSS tags)
Designandcreatewebpageforatravelbook/recipebookwith
8 2 1,47 2
more than 3 pages, table to list places/recipes (iframe, hyperlink)
Design and create web page with JavaScript to design a simple
9 calculator to perform the following operations: sum, product, difference and 2 1,4,7 2
quotient
10 Design and create a personal webpage with dashboard 2 1,4,7 2
Designandcreatewebpageaboutadvantagesofbusinessprocess
11 2,3 1,4,7 2,3
automation with respect to your branch of engineering

Department of Collegiate & Technical Education Bengaluru-560001

 Diploma in Computer Science & Engineering 2020-21 C20

Create a workflow for education loan approval in bank/diploma

12 3 1,4,7 3
admission process (Use any tool)
Demonstrate ERP with ERPNext Demo for manufacturing, retail
13 3 1,4,7 3
and service sector (Use any other ERP tools)
Create user account and demonstrate use of Google drive, Google docs, Google Co-
14 lab (Usage of Jupyter Notebook) 4 1,4,7 4

1.1 Demonstrate Internet of Things using with examples

a. Smart home
b. Smart city
15 c. Smart farming 4 1,4,7 4
Note: Teacher can also select specific area of work where Things
(autonomous computing devices) could be interconnected over TCP/IP to establish
IoT.
16 Installation of Antivirus software 5 1,4,7 5
17 Demonstration and hands on browser settings 5 1,4,7 5
18 Demonstrationandhandsonprivacysettingsandpasswordpolicy 5 1,4,7 5
Demonstration of common security threats (using videos)
a. Phishing
b. DoS attack
19 5 1,4,7 5
c. Man in the middle attack
d. Spamming
e. Virus
The suggested practical activities (TABLE-I) in this section are demonstrated for the attainment of the competency. These
practical activities can also be used for the student assessment in portfolio mode for awarding CIE marks. The lecturer
can enhance the competency level of the students by sketching more practical exercises.

NOTES:

1. It is compulsory to prepare log book/record of exercises. It is also required to get each exercise recorded in logbook,
checked and duly dated signed by the teacher
2. Student activitiesarecompulsory andarealso requiredtobeperformed andnotedinlogbook.
3. Student activity is compulsory and part of skill assessment. The activity enable student to explore the course, help
student to demonstrate creativity & critical thinking.
4. Student activity report is compulsory part to be submitted at the time of practical ESE
5. Term work report is compulsory part to be submitted at the time of practical ESE.

Department of Collegiate & Technical Education Bengaluru-560001

 Diploma in Computer Science & Engineering 2020-21 C20

6. Student activity and student activity reports must be uploaded to Learning management system.
7. For CIE, students are to be assessed for Skills/competencies achieved.

11. MAPPING OF CO WITH PO

COURSE CO’S PROGRAMME OUTCOMES (PO’S)
1 2 3 4 5 6 7
IT SKILLS CO1 3 0 0 3 0 0 3
CO2 3 0 0 3 0 0 3
CO3 3 0 0 3 0 0 0
CO4 3 0 0 3 0 0 3
CO5 3 0 0 3 0 0 0
Level 3- Highly Mapped, Level 2-Moderately Mapped, Level 1-Low Mapped, Level 0- Not
Mapped

12 SUGGESTED LEARNING RESOURCES

BOOKS
The Art of Programming Through Flowcharts & Algorithms, A. B. Chaudhuri, Firewall
1
Media publication
2 HTML5 Black Book, by Publishing company Limited. Kogent LearningSolutions Inc.
3 “World Wide Web design with HTML”, Xavier, Tata McGraw-Hill
Internet of Things – A Hands on Approach, By ArshdeepBahga and Vijay Madisetti
4
Universities Press, ISBN: 9788173719547
URL’S
1 https://scratch.mit.edu
2 https://studio.code.org
3 http://ai2.appinventor.mit.edu
4 https://www.w3schools.com
5 https://www.tutorialspoint.com/javascript/index.htm
6 https://www.geeksforgeeks.org/html-tutorials/
7 Android
https://developer.android.com
8 https://www.khanacademy.org
Tools for Web Development
9
a. https://www.wix.com

Department of Collegiate & Technical Education Bengaluru-560001

 Diploma in Computer Science & Engineering 2020-21 C20

b. https://atom.io/
c. https://www.openelement.com/
d. https://www.layoutit.com

13. SUGGESTED LIST OF PROPOSED STUDENTS ACTIVITY

Note: Refer activities mentioned in DETAILS OF COURSE CONTENT table

14. COURSE ASSESSMENT AND EVALUATION CHART

SL.N ASSESSMENT DURATIO MAX CONVERSION

O N MARKS
(in
minutes)
1 CIE Assessment 1 ( Written Test -1 TH) - 60 20 Average of
At the end of 3rd week two written
2 CIE Assessment 2 (Written Test -2 TH) - 60 20 tests
At the end of 13th week 20
3 CIE Assessment 3 (Skill Test) - At the end of 3 hrs 20 Average of
5th week three skill test 20
4 CIE Assessment 4 (Skill Test) - Atthe 3 hrs 20
end of 7th week
5 CIE Assessment 5 (Skill Test) - At the end of 3 hrs 20
9th week
6 CIE Assessment 6 (Student activity)- At the - 20 20
end of 11th week
7 Total Continuous Internal Evaluation (CIE) Assessment 60
8 Semester End Examination (SEE) 3 hrs 100 40
Assessment (PracticalTest)
TOAL MARKS 100
Note: 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 from each section.

Department of Collegiate & Technical Education Bengaluru-560001

 Diploma in Computer Science & Engineering 2020-21 C20

15. RUBRICS FOR ACTIVITY

RUBRICS FOR ACTIVITY (Example Only)
Appropriate rubrics shall be developed by the concerned faculty
Dimensio Poor Below Average Good Exemplary Student
n Average Score
4 8 12 16 20
Concept Does not collect any Collects very Collect much Collects some Collects a great 8
information relating limited information; but basic deal of
to the concept information; very information; information; all
some relate to limited relate most refer to refer to the
the concept to theconcept the concept concept
Design Design is not Design is poor Design Design & Design considered 6
acceptable/very and not well Fallowed convey both all
poorly structured structured. layout samples content and aspect of
and well context concept, concept
structured and
presentation
(UI)
Creativity Very little Creativity in Creativity in Creativity in Creative concept, 8
creativity in concept or concept concept content,
design/impleme design or /design/impl /design/imple presentation and
ntation implementatio n ementation mentation implementation
which
complements
each other
Impleme Poorly Partially Implemented on Product convey Product is 8
ntation implemented implemented time with results both content and creative with
(content) context easy-to-use UI,
structure
Average / Total Marks: (8+6+8+8)/4 7.5 = 8

Department of Collegiate & Technical Education Bengaluru-560001

 Diploma in Computer Science & Engineering 2020-21 C20

16. RUBRICS for Skill Test Evaluation (Both for CIE & SEE)

Sl No Parameter to be Observed Marks

Allotted
1 Design-Written
Skill Test 1: Algorithm / Flowchart/Visual Design Skill Test 2: 30
Web site visual design
Skill Test 3: Work flow or Project plan or cyber security
plan or Cloud service Concept
2 Implementation 50
Skill Test 1: Android application Skill
Test 2: Web site / Web pages
Skill Test 3: Create or use cloud service account or Cyber safety and
security- Antivirus
Installation or browser settings
3 Appeal and Presentation 20

Total 100

17.SYSTEM REQUIREMENTS:

Sl. No. Specification Quantity

1. Computers with HD Graphics Card 20
2. Software:GIMP, KRETA, BLENDER,PHOTOSHOPorany -
other relevant open-source software.
3. Internet Connectivity -
Note: Above specification is for a batch of 20 students

Department of Collegiate & Technical Education Bengaluru-560001