202 Pgdca
202 Pgdca
202 Pgdca
FIRST SEMESTER
1.1 Basics Of Computer And Information Technology 19-21
1.2 Computer Programming Using Python 22-26
1.3 Data Communication & Computer Network 27-30
1.4 Office Automation Tools 31-33
1.5 Internet And Web Technology 34-36
SECOND SEMESTER
2.1 Operating System 37-39
2.2 Web Designing Tools 40-42
2.3 Data Structure Using Python 43-45
2.4 Software Engineering 46-48
2.5 Database Management System 49-52
THIRD SEMESTER
3.1 Object Oriented Programming Using Java 53-56
3.2 Internet Of Things 57-59
3.3 E-Commerce And Digital Marketing 60-62
3.4 Computer Hardware And Maintenance 63-65
3.5 Soft Skills 66-68
3.6 Industrial Training 69
FOURTH SEMESTER
4.1 Cloud Computing 70-72
4.2 Environment Studies 73-75
4.3 Information Security And It Laws 76-79
4.4 Elective: 80-91
1- Web Development Using Laravel Framework
2- Computer Based Accounting
3- Development Of Android Applications
4.Big Data
4.5 Project 92-94
APPROVED IN CDC COMMITTEE MEETING OF BTE,UP,LKO DATED:26-09-2021
2
10. Resource Requirement 95-101
11. Evaluation Strategy 102-104
12. Recommendations for Effective Implementation of 105-107
Curriculum
13. List of Participants 108
Manoj Kumar
Director
Institute of Research Development & Training
Kanpur, U.P.
We gratefully acknowledge the guidance and contribution received from the following
persons:
1. Sh. Alok Kumar-III, IAS, Secretary, Technical Education Department, U.P. Govt.
2. Sh. Sunil Kumar Chaudhary, Special Secretary, Technical Education Department, U.P.
Govt.
3. Sh. Manoj Kumar, Director, Technical Education, UP & I.R.D.T., Kanpur, for taking keen
interest in the review of this curriculum.
Coordinator
Institute of Research Development & Training,
Kanpur, U.P.
8) Industrial Training
One Month of industrial training is included after IInd semester during summer
vacation. Total marks allotted to industrial training will be 50.
(1) Service Division (IT enabled services, maintenance service and installation of
computer services)
(2) Assembly and Quality Control Division
(3) Software Development and Testing Industries
(4) Web Development Industries
(5) Mobile Applications Development
(6) Junior Level Data Analytics
(7) Industry Automation
(8) E-Commerce Support Engineer
(9) News and Newspaper/Agencies, Magazines
(10) Data Entry and MIS/ERP Operator
(11) Lab. Assistant/Technician
(12) Hospitals/Healthcare/Institutions/Schools
(13) Cloud Services Support Engineer
(14) Publishing Industry
(15) Animation Industry
(16) Data Processing Industry
(17) Marketing Division (Corporate Handling, SME, Institutional Segment,
Government Tender Business)
(18) Telecommunication Sector
(19) Teaching Organizations (Polytechnics, Vocational Institutions etc)
(20) Networking (LAN, WAN etc)
(21) Defense Services/Police Services/Cyber Services/Forensic Services
(22) Call Centres, BPO etc.
1. Understand a computer system that has hardware and software components, which
controls and makes them useful.
2. Write Python programs using various collection data types
3. Setup computer networks and diagnose & solve network problems
4. Use file mangers, word processors, spreadsheets, presentation software’s
5. Understand various types and services of operating system
6. Identify the programming problem and formulate an algorithm for it.
7. Understanding the problem and corresponding requirement for development of
software.
8. Understand the concept of Database system and Client Server Architecture
9. Debug and compile the program written in Java.
10. Explain core concepts of cloud computing paradigm.
11. Comprehend the importance of ecosystem and sustainable
12. Demonstrate interdisciplinary nature of environmental issues
13. Understand the concepts of Internet of Things.
14. Develop a mobile application using different components of Android.
15. To develop in-depth knowledge and understanding of the big data analytic
domain.
16. Identify core concepts of digital marketing and the role of digital marketing in
business.
17. Work on different Web Designing Tools for manipulating images, creating web
graphics, animation etc.
18. Write, compile and debug program using different programming constructs
19. Create, manage and secure database
20. Design, develop and host websites using internet technologies
21. Communicate effectively in English with others
22. Writing cv/ resume
23. Facing a Mock Interview
24. Set-up, diagnose problems, troubleshoot computers, servers & networks and
implementing security measures for web development.
25. Write and debug simple as well as complex program in Python/PHP
26. Apply the acquired knowledge and skills in solving live problems in the Computer
and I.T. industry
27. Perform data backups
28. Use open-source tools and software
29. Handle malware and viruses
30. Install and manage operating system and application software
31. Implementing security measure for web-based applications
The following curriculum area subjects have been derived from learning outcomes:
I II III IV
1. Basics of computer and information 8 - - -
technology
2. Computer programming using python 10 - - -
3. Data communication & computer network 09 - - -
4. Office automation tools 08 - - -
5. Internet and web technology 08 - - -
6. Operating system - 09 - -
7. Web designing tools - 08 - -
8. Data structure using python - 11 - -
9. Software engineering - 06 - -
10. Database management system - 10 - -
11. Object oriented programming using java - - 12 -
12. Internet of Things - - 08 -
13. E-Commerce and Digital Marketing - - 06 -
14. Computer hardware and maintenance - - 10 -
15. Soft skills - - 06 -
16. Cloud computing - - - 08
17. Environment studies - - - 05
18. Information security and it laws - - - 08
19. Elective: - - - 12
1- Web Development Using Laravel
Framework
2- Computer Based Accounting
3- Development of Android Applications
4.Big Data
20. Project 08
21. Student centered activities 02 02 03 02
Total 45 46 45 45
FIRST SEMESTER
Note: ** Four Weeks of Industrial Training to be assessed in third Semester. ** Student will be required to complete four week industrial
training after the completion of 2nd semester.
THIRD SEMESTER
It was discussed and decided that the maximum marks for SCA should be 30 as it involves a
lot of subjectivity in the evaluation. The marks may be distributed as follows:
a) 75 - 80% 2 Marks
b) 80 - 85% 4 Marks
c) Above 85% 5 Marks
Note: There should be no marks for attendance in the internal sessional of different subjects.
L T P
4 - 4
RATIONALE
The PG diploma holders in Computer Application needs to understand computer fundamentals and
information technology. They should be able to operate basic software related to computer. Hence
this subject is introduced in the curriculum.
LEARNING OUTCOMES
Understand a computer system that has hardware and software components, which controls
and makes them useful.
Understand the operating system as the interface to the computer system.
Outline various application of IT
Differentiate between assembly and high-level language
Identify various web browser
Use the Internet to send mail and surf the World Wide Web
DETAILED CONTENTS
Hardware and Software, Types of Software, Introduction and need of operating system, Types
of operating system, dos operating system, Types of dos Commands, operating system as a
resource manager; BIOS; System utilities – Editor, Loader, Linker, File Manager. Concept of
GUI and CUI standards. Directories and files , wild cards, autoexec.bat, config.sys, features of
APPROVED IN CDC COMMITTEE MEETING OF BTE,UP,LKO DATED:26-09-2021
19
Window desktop, components of Window, function of each component of Window, method of
starting a program using start button, Understand maximize, minimize, restore down and close
button, uses of file and folder, method of viewing the contents of hard disk drive using explore
option, control panel,disk defragmentation installation and un installation of the application
software.
Structure, Kernel and Shell, Basic command, File system, VI editor, LINUX Installation
Concepts of computer Network, Client Server Model, Peer to Peer Model, Networking Devices:
Switch, Router, Hub, Bridge, Gateway, LAN, MAN, WAN, Topology, Internet, Intranet,
Extranet, internet service provider and its relevance, role of the modem in accessing the internet,
installation procedure of a modem using control panel, purpose of web browser software,
URL,URI, URN, WWW, FTP,HTTP,RDC(Remote Desktop Connection), Telnet, Email,
process of sending and receiving e-mail, transmission modes, IP address and its format, MAC
Address, DNS, search engines, social network sites, internet security, Firewall, Cloud
Computing and its services
LIST OF PRACTICALS
Since this subject is practice oriented, the teacher should demonstrate the capabilities of computers
to students while doing practical exercises. The students should be made familiar with computer
parts, peripherals, connectors etc. and proficient in making use of operating system functionalities
in addition to working on internet. The student should be made capable of working on computers
independently
MEANS OF ASSESSMENT
RECOMMENDED BOOKS
http://swayam.gov.in
http://spoken-tutorial.orgs
L T P
4 - 6
RATIONALE
This course introduces to the students the Python language. Upon completion of this course, the
student will be able to write non trivial Python programs dealing with a wide variety of subject matter
domains. Topics include language components, the IDLE/IDE environment, control flow constructs,
strings, I/O, collections, classes, modules, and regular expressions.
LEARNING OUTCOMES
DETAILED CONTENTS
Indenting Requirements
The if Statement
Relational and Logical Operators
Bit Wise Operators
The while Loop
break and continue
The for Loop
Introduction
Lists
Tuples
Sets
Dictionaries
Sorting Dictionaries
Copying Collections
Summary
Introduction
Defining Your Own Functions
Parameters
Function Documentation
Keyword and Optional Parameters
Passing Collections to a Function
Variable Number of Arguments
Modules
Standard Modules - sys
Standard Modules - math
Standard Modules - time
The dir Function
Errors
Runtime Errors
The Exception Model
Exception Hierarchy
Handling Multiple Exceptions
Raise
assert
Introduction
Data Streams
Creating Your Own Data Streams
Access Modes
Writing Data to a File
Reading Data From a File
Additional File Methods
Using Pipes as Data Streams
Handling IO Exceptions
Classes in Python
Principles of Object Orientation
APPROVED IN CDC COMMITTEE MEETING OF BTE,UP,LKO DATED:26-09-2021
24
Creating Classes
Instance Methods
File Organization
Special Methods
Class Variables
Inheritance
Polymorphism
Introduction
Simple Character Matches
Special Characters
Character Classes
Quantifiers
The Dot Character
Greedy Matches
Grouping
Matching at Beginning or End
Match Objects
Substituting
Splitting a String
Compiling Regular Expressions
Flags
LIST OF PRACTICALS
1. Getting started with Python and IDLE in interactive and batch modes
2. What do the following string methods do?
lower
count
replace
3. Write instructions to perform each of the steps below
(a) Create a string containing at least five words and store it in a variable.
(b) Print out the string.
(c) Convert the string to a list of words using the string split method.
(d) Sort the list into reverse alphabetical order using some of the list methods (you might
need to use dir(list) or help(list) to find appropriate methods).
(e) Print out the sorted, reversed list of words.
4. Write a program that determines whether the number is prime.
What is your favorite number? 24
24 is not prime
What is your favorite number? 31
31 is prime
5. Find all numbers which are multiple of 17, but not the multiple of 5, between 2000 and 2500?
6. Swap two integer numbers using a temporary variable. Repeat the exercise using the code
APPROVED IN CDC COMMITTEE MEETING OF BTE,UP,LKO DATED:26-09-2021
25
format: a, b = b, a. Verify your results in both the cases.
7. Find the largest of n numbers, using a user defined function largest().
8. Write a function myReverse() which receives a string as an input and returns the reverse of
the string.
9. Check if a given string is palindrome or not.
10. WAP to convert Celsius to Fahrenheit
11. Find the ASCII value of charades
12. WAP for simple calculator
INSTRUCTIONAL STRATEGY
Teachers should put emphasis on practicals and experts from industries may be invited to deliver
lectures and share experiences with the students.
MEANS OF ASSESSMENT
RECOMMENDED BOOKS
L T P
5 - 4
RATIONALE
The future of computer technology is in Data Communication and Computer Networks. Global
connectivity can be achieved through computer networks. A PG diploma holder in Computer
Application should therefore understand the function of networks and get exposure to different
existing and upcoming communication technologies. Knowledge about hardware and software
requirements of networks is essential.
LEARNING OUTCOMES
DETAILED CONTENTS
LIST OF PRACTICALS
1. Recognize the physical topology and cabling (coaxial, OFC, UTP, STP) of a network.
2. Recognition and use of various types of connectors RJ-45, RJ-11,BNC and SCST
3. Making of cross cable and straight cable
4. Install and configure a network interface card in a workstation.
5. Identify the IP address of a workstation and the class of the address and configure the IP
Address on a workstation
6. Managing user accounts in windows and LINUX
7. Sharing of Hardware resources in the network.
8. Use of Netstat and its options.
9. Connectivity troubleshooting using PING, IPCONFIG, IFCONFIG
10. Installation of Network Operating System
11. (NOS)
12. Visit to nearby industry for latest networking techniques
13. Create a network of at least 6 computers.
Required Software
Windows Server/Linux Server
INSTRUCTIONAL STRATEGY
Since the facilities are not available in the polytechnic, students need exposure to various security
systems and software available in some organizations, universities and engineering colleges. For this,
MEANS OF ASSESSMENT
Assignments and quiz/class tests, mid-term and end-term written tests
Actual laboratory and practical work exercises and viva-voce
Software installation, operation, development and viva-voce
RECOMMENDED BOOKS
1. Computer Networks by Tanenbaum, Prentice Hall of India, New Delhi
2. Data Communications and Networking by Forouzan, (Edition 2 nd and 4th ), Tata McGraw
Hill Education Pvt Ltd , New Delhi
3. Data and Computer Communication by William Stallings, Pearson Education, New Delhi
4. Local Area Networks by Peter Hudson
5. Network+ Lab manual,- BPB Publications -by Tami Evanson
6. Networking Essentials – BPB Publications New Delhi
7. Computer Network and Communications By V.K. Jain and Narija Bajaj, Cyber Tech
Publications, New Delhi.
8. Cloud Computing Bible by BerrieSarinby
9. E-books/e-tools/relevant software to be used as recommended by AICTE/NITTTR,
Chandigarh.
L T P
- - 8
RATIONALE
This subject aims to cover the handling of word processing software. It also involves various clerical
tasks, such as organizing customer data or creating reports. It enables people with lower skill levels
to perform higher-level tasks. In Today's commercial world, automation helps the users with a
sophisticated set of commands to format, edit, and print text documents. It is used as valuable and
important tools in the creation of applications such as newsletters, brochures, charts, presentation,
documents, drawings and graphic images. This will make the students proficient in office automation
applications.
DETAILED CONTENTS
1. Word Processing
2. Spread Sheet
MS Excel Concept: Creating, Saving, closing, editing a Workbook, Inserting, Deleting Work Sheets,
entering data in a cell, Copying and Moving from selected cells, entering formula, handling operators
in Formula, Functions: Mathematical, Logical, statistical, text, financial, Date and Time functions,
Using Function Wizard. Formatting a Worksheet: Formatting Cells – changing data alignment,
changing date, number, character or currency format, changing font, adding borders and colors,
Printing worksheets, Charts and Graphs – Creating, Previewing, Modifying Charts,
LOOKUP/VLOOKUP
3. Presentation
MS Power Point Concept : Creating, Opening and Saving Presentations, Working in Different
Views, Working with Slides, Adding and Formatting Text, Formatting Paragraphs, Checking
APPROVED IN CDC COMMITTEE MEETING OF BTE,UP,LKO DATED:26-09-2021
33
Spelling and Correcting Typing Mistakes, Making Notes Pages and Handouts, Drawing and Working
with Objects, Adding Clip Art and other pictures, Designing Slide Shows using templates, Rehearse
timing, Narration, Multimedia effects- Apply Transitions between Slides, Animate Slide Content, Set
Timing for Transitions and Animations, Insert and Format Media, Encrypting presentations with a
password, Running and Controlling a Slide Show, Printing Presentations
4. Database
Creating, saving, downloading, sharing files/folders from Google drive, creating and sharing Google
docs, import and export docs, creating and sharing Google sheet, import and export Google sheet,
Google forms and form responses, creating Google slides to present your ideas
LIST OF PRACTICALS
1. Creating a document using different font, changing font size and color, changing the appearance
through bold/italic/underline.
2. Creating a document using subscript and superscript, justification of the document.
3. Create a document using Bullets and Numbering.
4. Create a document using page number, header and footer.
5. Create a document using inserting page breaks and column break, line spacing.
6. How to use mail merge and macro in MS Word.
7. Creating table, formatting cells, use of different border styles, shading in tables, merging of
cells, and partition of cells, inserting and deleting a row in a table in MS word document.
8. Apply spelling checker, grammar mistakes, thesaurus in a document.
9. Create a Boucher using templates, page setup and print preview, and then print that document.
10. Working on spreadsheet like adding, deleting, merging cells, layout and style.
11. Create a table and perform operation using predefined function on it.
12. In MS Excel procedure to switching between different spreadsheets and workbook.
13. Create a spreadsheet and print selected as well as full workbook.
14. Create a spreadsheet with LOOKUP/VLOOKUP features.
15. Create different charts in excel and implement formulas (automatic and use defined).
16. Create a Power Point presentation using slide template.
17. Create a Power Point presentation using animation.
18. Create a Power Point presentation using transition
19. Create a Power Point Presentation with Adding movie and sound.
20. Create a Power Point Presentation with Adding tables and chart etc.
21. Changing slide color scheme in presentation.
22. Viewing the presentation using slide navigator.
23. Create, Save, Run and Print the Power Point Presentation.
24. Create a database table using predefined template.
25. Create a database form using form wizard.
26. Create and share files/folders in Google drive
27. Create and share Google docs.
28. Create and share Google sheets.
APPROVED IN CDC COMMITTEE MEETING OF BTE,UP,LKO DATED:26-09-2021
34
29. Create and share Google Forms.
30. Create and share Google slides.
INSTRUCTIONAL STRATEGY
As the subject is practice oriented, more stress should be given to students to do the work practically.
The features of software packages MS Office/ Libre Office to be demonstrated in class using LCD
projector.
MEANS OF ASSESSMENT
RECOMMENDED BOOKS
http://office.microsoft.com/en-us/training/CR010047968.aspx
https://gsuite.google.com/learning-center
http://spoken-tutorial.org
L T P
4 - 4
RATIONALE
It is important for P.G. diploma holders in Computer Application s to understand about Internet, Web
Space and how to develop static website. They should be able to develop basic static websites by
using different platform independent front-end Technologies which can run on mobile llbrowsers as
we. Hence this subject is introduced in the curriculum.
LEARNING OUTCOMES
After undergoing the subject, the students will be able to:
Understand working of Internet/ Websites, Client Server Model and Internet Tools.
Understand and develop HTML Web pages.
Provide logics on the web pages by using JavaScript
Use Bootstrapto develop responsive website
Control the Look and feel of web pages by using CSS
Use JQuery for developing the Web Pages
Develop Static webpage/web portal
DETAILED CONTENTS
LIST OF PRACTICALS
INSTRUCTIONAL STRATEGY
Since this subject is practice oriented, the teacher should demonstrate the capabilities of
websites/WebPages to students while doing practical exercises. The students should be made
familiar with developing web pages by code editor/browsers, working on internet. The student
should be made capable of developing static websites by using HTML, JavaScript, CSS and jQuery
and Bootstrap
MEANS OF ASSESSMENT
APPROVED IN CDC COMMITTEE MEETING OF BTE,UP,LKO DATED:26-09-2021
37
Assignments and quiz/class tests, mid-term and end-term written tests
Actual laboratory and practical work, exercises and viva-voce
Software installation, operation, development and viva-voce
RECOMMENDED BOOKS
1. Head First HTML and CSS: A Learner's Guide to Creating Standards-Based Web Pages ,
O Reilly Publications by Elisabeth Robson Eric Freeman
2. Head First JavaScriptProgramming, O Reilly Publications by Eric FREEMAN
3. Head First jQuery, O Reilly by Ryan Benedetti, Ronan Cranley
4. Web Technologies, Black Book ,Kogent Learning Solutions Inc
5. Developing Web Applications, 2ed ,Wiley Publications, M.T.Savaliya
6. Mastering Bootstrap 4 ,by Benjamin Jakobus and Jason Marah, Packt Publishing
7. e-books/e-tools/relevant software to be used as recommended by AICTE/UPBTE/NITTTR,
Chandigarh.
LEARNING OUTCOMES
After undergoing the subject, students will be able to:
Describe various types and services of operating system
Identify the concept of process, various states in the process and their scheduling.
Process concept, Process State, Process Control Block, Scheduling Queues, Scheduler, Job
Scheduler, Process Scheduler, Context Switch, Operations on Processes, Interprocess
Communication, Shared Memory Systems, Message-Passing Systems, CPU Scheduler,
Scheduling Criteria, Scheduling Algorithms, Preemptive and Non Preemptive, First come first
serve (FCFS), Shortest Job first
APPROVED IN CDC COMMITTEE MEETING OF BTE,UP,LKO DATED:26-09-2021
39
(SJF), Round Robin (RR), Multiprocessor scheduling, Process Synchronization.
Deadlock, Conditions for Dead lock, Methods for handling deadlocks, Dead
Prevention, Deadlock Avoidance, Deadlock detection, Recovery from deadlock.
Definition – Logical and Physical address Space, Swapping, Memory allocation, Contiguous
Memory allocation, Fixed and variable partition, Internal and External fragmentation
and Compaction, Paging – Principle of operation, Page allocation, Hardware support for
paging, Protection and sharing, Disadvantages of paging, Segmentation, Virtual Memory.
Dedicated Devices, Shared Devices, I/O Devices, Storage Devices, Buffering, Spooling.
Types of File System; Simple file system, Basic file system, Logical file system, Physical
file system, Various Methods of Allocating Disk Space
History of Linux and Unix, Linux Overview, Structure of Linux, Linux releases, Open Linux,
Linux System Requirements, Linux Commands and Filters: mkdir, cd, rmdir, pwd, ls, who,
whoami, date, cat, chmod, cp, mv, rm, pg, more, pr, tail, head, cut, paste, nl, grep, wc, sort,
kill, write, talk, mseg, wall, merge, mail, news Shell: concepts of command options, input,
output, redirection, pipes, redirecting and piping with standard errors, Shell scripts, vi editing
commands
LIST OF PRACTICALS
INSTRUCTIONAL STRATEGY
APPROVED IN CDC COMMITTEE MEETING OF BTE,UP,LKO DATED:26-09-2021
40
This subject is both theory and practical oriental. Therefore, stress must be given on particulars along
with theory. Laboratory must have windows as well as Linux operating system. Concepts of O.S.
must be taught practically.
MEANS OF ASSESSMENT
RECOMMENDED BOOKS
http://swayam.gov.in
(Periods) (%)
1. 10 18
2. 10 18
3. 06 10
4 10 18
5 04 8
6 06 10
7 10 18
Total 56 100
This subject aims to cover the study of various tools related to development of websites and blogs
with adequate knowledge of web development technology. Student can work on tools related to
content management or learning management system to develop/build website with focus on
designing aspects of websites.
LEARNING OUTCOMES
Use Image editing tools for editing and enhancing the images
Use Animation tools for creating 2D & 3D Animation.
Differentiate various type of websites
Prepare presentation for explaining/ demonstrating the required topic.
Differentiate between CMS and LMS
Develop Content Management & Learning Management websites.
DETAILED CONTENTS
LIST OF PRACTICALS
INSTRUCTIONAL STRATEGY
Since this subject is practice oriented, the teacher should demonstrate the capabilities of tools
mentioned in detailed contents of syllabus to students while doing practical exercises. The students
should be made familiar with developing web pages by using these tools, working on internet.
MEANS OF ASSESSMENT
Assignments and quiz/class tests, mid-term and end-term written tests
Actual laboratory and practical work, exercises and viva-voce
Software installation, operation, development and viva-voce
RECOMMENDED BOOKS
http://office.microsoft.com/en-us/training/CR010047968.aspx
https://gsuite.google.com/learning-center
http://spoken-tutorial.org
L T P
5 - 6
RATIONALE
Data structures are the techniques of designing the basic algorithms for real-life projects.
Understanding of data structures is essential and this facilitates the understanding of the language.
The practice and assimilation of data structure techniques is essential for programming. The
knowledge of Python language and data structures will be reinforced by practical exercises during
the course of study. This course will help students to develop the capability of selecting a particular
data structure.
LEARNING OUTCOMES
DETAILED CONTENTS
1. Data Structures: Data Structures in Python, Introduction to Built-in Data Structures, Introduction
to User-defined Data Structures, Algorithms, Elements of a Good Algorithm, Basic algorithmic
analysis: input size, asymptotic complexity, O() notation (10 Periods)
2. Strings: Working with series of characters that can represent plaintext messages, passwords, and
more, including all the complexities of combining human language with programming code. (08
Periods)
3.List-Based Collections: definitions and examples of list-based data structures, arrays, linked lists,
stacks, queues, Examine the efficiency of common list methods, Arrays vs lists (10 Periods)
4. Searching and Sorting: search and sort with list-based data structures, binary search and insertion
sort, bubble sort, merge sort, quick sort, use of recursion in searching and sorting. (10 Periods)
5. Maps and Hashing: concepts of sets, maps (dictionaries), hashing, common problems and
approaches to hashing, hash tables and hash maps. (10 Periods)
7. Graph: concept of a graph and understand common graph terms, coded representations, properties,
traversals and paths.
(10 Periods)
MEANS OF ASSESSMENT
LIST OF PRACTICALS
1. Write a Python program to create an array contains six integers. Also print all the members of
the array
2. Given a two list. Create a third list by picking an odd-index element from the first list and even
index elements from second.
3. Given an input list removes the element at index 4 and add it to the 2nd position and also, at the
end of the list
4. Given a list iterate it and count the occurrence of each element and create a dictionary to show
the count of each element
5. Given a two list of equal size create a set such that it shows the element from both lists in the
pair
6. Given a following two sets find the intersection and remove those elements from the first set
7. Iterate a given list and Check if a given element already exists in a dictionary as a key’s value if
not delete it from the list
8. Remove duplicate from a list and create a tuple and find the minimum and maximum number
9. Swapping of two tuples.
10. Perform Insertion sort
11. Exercise based on Bubble sort
12. Binary Search exercise
13. Exercise based on merge & quick sort
14. Use of recursion in sorting
15. Use of recursion in searching
16. Write a Python program to triple all numbers of a given list of integers. Use Python map
17. Write a Python program to square the elements of a list using map() function.
18. Write a Python program to compute the square of first N Fibonacci numbers, using map function
and generate a list of the numbers.
19. Using two Arrays of equal length, create a Hash object where the elements from one array (the
keys) are associated with the elements of the other (the values)
APPROVED IN CDC COMMITTEE MEETING OF BTE,UP,LKO DATED:26-09-2021
47
20. Exercise based on Build in Hash Functions
21. Write a Python program to create a Balanced Binary Search Tree (BST) using an array (given)
elements where array elements are sorted in ascending order.
22. Write a Python program to check whether a given a binary tree is a valid binary search tree (BST)
or not.
23. Write a Python program to convert a given array elements to a height balanced Binary Search
Tree (BST).
24. Exercise based on graph traversal
RECOMMENDED BOOKS
The system analysis and design is the backbone of Application software development. After studying
this subject the students will be able to develop and design the system according to given
requirements. It involves various steps in analysis and design of the system. It includes the knowledge
of preparing project systematically. It is important to know about various aspects of the system
analysis and design so that the students will be able to understand the responsibilities while designing
and implementation of software project.
LEARNING OUTCOMES
DETAILED CONTENTS
System Concepts: Types of systems : (open, closed, static and dynamic systems).
Introduction, Programmes v/s Software Products
Emergence of Software Engineering- Early Computer Programming, High-level Language
Programming, Control flow based Design, Data Structure Oriented Design, Object Oriented
Design
Requirement of Life Cycle Model, Classic Waterfall Model, Prototyping Model, Evolutionary
Model, Spiral Model, introduction to agile methodology.
Comparison of different Life Cycle Models
Characteristics and features of good Software Design Cohesion and Cupling, Software design
Approaches- Function Oriented Design (Data flow diagrams, Data dictionary, Decision Trees and
tables), Object Oriented Design, Structured Coding Techniques, Coding Styles, and
documentation
Concept of Testing, Testing type cycle (V-Model), Verification v/s Validations, Unit Testing,
Black Box Testing, White Box Testing, Integration testing, System testing, Configuration
management, Overview of test cases.
MEANS OF ASSESSMENT
LIST OF PRACTICALS
RECOMMENDED BOOKS
L T P
5 - 4
RATIONALE
The PG diploma holders in Computer Application need to understand about Relational Database to
manage the data at backend for different applications. They should be able to develop basic table and
write query to fetch the required data. Hence this subject will remain the part of this curriculum.
LEARNING OUTCOMES
DETAILED CONTENTS
Basic concepts, Advantages of a DBMS over file processing system, Data Abstraction, Database
Languages, Data Independence. , Components of a DBMS and overall structure of a DBMS.
,Three views of Data (External View, Conceptual View, Internal View), Three level architecture
of DBMS, Data Independence, , Client Server Architecture
Define data model, Data Models : Network Model Hierarchical Model, E-R Model, Advantage
& Disadvantages of each Data Model
ER Model :
Entity sets and relationship sets- Attributes - Keys in entity and relationship sets : (a) Super Key
(b) Candidate Key (c) Primary Key (e) Unique Key - Mapping constraints, Participation
Constraint, E-R diagram, Notations. Strong Entity Set and Weak Entity Set
Data definition language, Data manipulation language, SQL, Object naming conventions, Object
naming guidelines, Data types, Tables (Creating , Inserting, Updating and deleting tables and
using constraints), Views, Indexes,
Aggregate functions, String functions and date time functions, Null values
LIST OF PRACTICALS
1.Installation of MYSQL
Creating a table
Specifying constraints
Creating indexes
APPROVED IN CDC COMMITTEE MEETING OF BTE,UP,LKO DATED:26-09-2021
53
3. Table and Record Handling
INSERT statement
Using In, BETWEEN, LIKE, ORDER BY, GROUP BY & HAVING clause
Explanation of concepts using real time examples, diagrams etc. For practical sessions books along
with CDs or learning materials with specified activities are required. Various exercises and small
applications should be given along with theoretical explanation of concepts.
MEANS OF ASSESSMENT
RECOMMENDED BOOKS
RATIONALE
Object orientation is a new approach to understand the complexities of the real world. In contrast to
the earlier approaches like procedural etc, object orientation helps to formulate the problems in a
better way giving high reliability, adaptability and extensibility to the applications. The students are
already familiar with this concept of programming in C which is the basic for JAVA. This course
offers the modern programming language JAVA that will help the students to implement the various
concept of object orientation practically. The students will be able to program in the object-oriented
technology with the usage of JAVA.
LEARNING OUTCOMES
DETAILED CONTENTS
variables, types and type declarations, data types : Integer, floating point type, character,
Boolean, all Operators, iteration and jump statement, if then else clause; conditional
expressions, input using scanner class and output statement, loops, switch case, arrays,
methods.
Class fundamentals, constructors, declaring objects (Object & Object Reference), creating and
accessing variables and methods, static and non static variables/methods defining packages,
Creating and accessing a package, Importing packages, Understanding CLASSPATH, auto
boxing , String , String Buffer
Definition of inheritance, protected data, private data, public data, constructor chaining,
order of invocation, types of inheritance, single inheritance, multilevel inheritance,
hierarchical inheritance, hybrid inheritance , access control (Private Vs PublicVs Protected
Vs Default)
Defining an interface, difference between classes and interface, Key points of Abstract class
& interface, difference between an abstract class & interface, implementation of multiple
inheritance through interface.
Difference between multi threading and multi tasking, thread life cycle, creating threads,
thread priorities, synchronizing threads.
LIST OF PRACTICALS
1. WAP to create a simple class to find out the area and perimeter of rectangle and box using
super and this keyword.
2. WAP to design a class account using the inheritance and static that show all function of
bank (withdrawal, deposit).
3. WAP to design a class using abstract methods and classes.
4. WAP to design a string class that perform string method (equal, reverse the string, change
case).
5. Consider we have a Class of Cars under which Santro Xing, Alto and Wagon R represents
individual Objects. In this context each Car Object will have its own, Model, Year of
8. WAP to handle the exception using try and multiple catch block.
9. WAP that implement the Nested try statements.
10. WAP to create a package that access the member of external class as well as same package.
11. WAP that show the partial implementation of interface.
12. WAP to create a thread that implement the Runnable interface.
INSTRUCTIONAL STRATEGY
The subject is totally practical based. Students should be given clear idea about the basic concepts of
programming. In practical session student should be asked to draw flow chart write algorithm and
then write program for algorithm and run on computer. It is required that students should maintain
records (files with printouts).
MEANS OF ASSESSMENT
RECOMMENDED BOOKS
Internet of Things (IoT) is presently a hot technology worldwide. Government, academia, and
industry are involved in different aspects of research, implementation, and business with IoT. IoT
cuts across different application domain like agriculture, space, healthcare, manufacturing,
construction, water, and mining. IoT-based applications such as innovative shopping system,
infrastructure management in both urban and rural areas, remote health monitoring and emergency
notification systems, and transportation systems, are gradually relying on IoT based systems.
Therefore, it is very important to learn the fundamentals of this emerging technology. This
introductory syllabus will enable learners to leverage their business and/or technical knowledge
across IoT-related functions in the workplace.
LEARNING OUTCOMES
DETAILED CONTENTS
Introduction to IoT, Defining IoT, Things in IoT, Characteristics of IoT, Physical design of IoT,
Logical design of IoT, Functional blocks of IoT,IoT Protocols,IoT communication Models, IoT
communication API’s,IoT enabling Technologies.
How electronic devices fit with the Internet of Things, and why they are important
Electronic Components : Breadboard and its internal connections,Seven segment display on bread
board,LED and its connections, Tri-color LED, Resistor
Introduction to the many ‘end devices’, sensors and actuators, differentiate between different
sensor types
Introduction to the components of basic IoT networks, the types of network connections and how
data travels through them, and the role of Internet Protocols.Basicunderstanding of
microcontrollers/Arduino and communication protocols
Introduction, M2M, Difference between IoT and M2M, SDN and NFV for IoT- Software defined
networking, network function virtualization, IoT and WoT.
LIST OF PRACTICALS
INSTRUCTIONAL STRATEGY
Some of the topics may be taught using question/answer, assignment, seminar or case study method.
The teacher will discuss case studies with students to feel the importance of the subject, since this
subject is practical oriented, the teacher should demonstrate functioning of various sensors and
demonstrate building of IoT applications. Solution to various regression and classification problems
should also be built
MEANS OF ASSESSMENT
RECOMMENDED BOOKS
1. The Internet of Things: Connecting Objects to the Web,Wiley Publisher Hakima Chaouchi
2. Internet of Things: A Hands On Approach, University Press,Vijay Madisetti, Arshdeep
Bahga.
3. 21 Internet Of Things (IOT) Experiments,BPB Publications Yashavant Kanetkar
APPROVED IN CDC COMMITTEE MEETING OF BTE,UP,LKO DATED:26-09-2021
61
4. Arduino Projects For Engineers ,BPB Publications ,Neerparaj Rai
5. Internet of Things – A Hands on Approach, By Arshdeep Bahga and Vijay Madisetti
Universities Press, ISBN: 9788173719547
6. The Internet of Things , Pearson, By Michael Miller ISBN: 9789332552456
7. e-books/e-tools/relevant software to be used as recommended by AICTE/UPBTE/NITTTR,
Chandigarh.
LIST OF COMPONENTS
1. One kit for 3-4 students : Arduino Uno, sensors(Bluetooth module(HC05), MQ135,
DHT11, breadboard , LCD, 2-relay module etc)
2. Consumables : LED, button, connecting wires, LDR, LM35, battery, etc
The course is designed to help you master the essential disciplines in digital marketing, including
search engine optimization (SEO), social media, conversion optimization, web analytics, content
marketing, email and mobile marketing. Digital marketing is one of the world’s fastest growing
disciplines.
LEARNING OUTCOMES
After undergoing the subject, the students will be able to:
DETAILED CONTENTS
Payment Gateway, Modes of Electronic Payment, Threats & protections for e-commerce
payment system
LIST OF PRACTICALS
INSTRUCTIONAL STRATEGY
The subject is totally practical based. Students should be given clear idea about the basic concepts of
E-Commerce and digital marketing. In practical session student should be asked carried out the basic
concepts related to this subject.
MEANS OF ASSESSMENT
RECOMMENDED BOOKS
Servicing of computer peripherals and system such as Key Board, Disk Drives, Printers,
Power Supplies and different stages of the computer results in increasing efficiency and life
of the Computer Centre. A technician having skills of servicing the above peripherals and
systems will prove useful for a Computer Centre.
LEARNING OUTCOMES
DETAILED CONTENTS
2. Mother Board : BUS, Motherboard components & it’s type, Battery, Connections on the
Mother Board, Keeping CPU cool, Mother board trouble shooting. (10 Periods)
3. Key Board : Switches, Keyboard organization, Key board type trouble shooting. (03 Periods)
4. Mouse : Mouse type, Connecting Mouse: Wired & Wireless, Troubleshooting Mouse. (03
Periods)
5. HDD : Magnetic recording, Data Encoding Method, HDD feature, Head barking, HDD trouble
shooting. (05 Periods)
7. RAM: Definition, Types of RAM, advantages, Removable RAM Vs. Soldered RAM (02 Periods)
6. Compact Disc Drive : CD-R, CD-W, CD-RW, DVD-R, DVD-RW, Blue Ray. Working and
Maintenance. (02 Periods)
7. Printers : Image formation method, Printing mechanism, DMP, Ink Jet, Laser Printer, Multi-
functional printer. How printer works and Trouble shooting. (05 Periods)
8. Network Devices: Hub, Switch, Router, Bridge, Gateway, Ethernet Card, Network Cables
(CAT-6 & OFC), Cabling Tools, Troubleshooting (08 Periods)
10. External Devices- Pen Drive, Flash Drive, External Hard Disk.
List Of Practical’s
INSTRUCTIONAL STRATEGY
MEANS OF ASSESSMENT
- Assignments
- Viva-voce
- Written examination
- Practical Tasks
RECOMMENDED BOOKS
1. Electronics and Radio Engineering M.L. Gupta Dhanpat rai & Sons, New Delhi
2. PC And Clones Hardware, Troubleshooting and Maintenance B. Govinda rajalu, Tata Mc-
graw-Hill Publication
3. PC Troubleshooting and Repair Stephen J. Bigelow Dream tech Press, New Delhi
4. Computer Installation & Servicing, D. Balasubramanian, Tata McGraw Hill
5. e-books/e-tools/relevant software to be used as recommended by AICTE/UPBTE/NITTTR,
Chandigarh.
5. 05 10
6. 02 05
7. 02 05
8. 02 05
9. 05 05
10. 10 15
11. 02 05
12. 02 05
13. 02 05
14. 06 10
Total 56 100
L T P
2 - 4
RATIONALE
Soft Skills plays an important role in career development. This subject aims at introducing basic
concepts of communication besides laying emphasis on developing listening, speaking, reading and
writing skills as parts of Communication Skill and focuses on learning various interview techniques.
LEARNING OUTCOMES
DETAILED CONTENTS
1. Basics of Communication (04 periods)
4. Curriculum Vitae and Resume: Overview, types of CV, Covering Letter, Resume, Types of
Resume, Difference between CV and Resume. (08 periods)
5. Interview Techniques & Interview Preparation Preparing for an interview, Interview Formats,
Types of Interview Questions, Mock Interviews, the benefits of mock interviews. (06 periods)
LIST OF PRACTICALS
Note: Teaching Learning Process should be focused on the use of the language in writing reports and
making presentations. Topics such as Effective listening, effective note taking, group
discussions and regular presentations by the students need to be taught in a project oriented
manner where the learning happens as a by product.
INSTRUCTIONAL STRATEGY
Student should be encouraged to participate in role play and other student centered activities in class
room and actively participate in listening exercises.
MEANS OF ASSESSMENT
RECOMMENDED BOOKS
5 06 20
Total 28 100
This document includes guided and supervised industrial training of 4 weeks duration to be
organised during the semester break starting after second year i.e. after 4 th semester
examinations. The concerned HODs along with other teachers will guide and help students
in arranging appropriate training places relevant to their specific branch. It is suggested that
a training schedule may be drawn for each student before starting of the training in
consultation with the training providers. Students should also be briefed in advance about the
organizational setup, product range, manufacturing process, important machines and materials
used in the training organization.
An external assessment of 50 marks has been provided in the study and evaluation scheme of
5th Semester. Evaluation of professional industrial training report through viva-
voce/presentation aims at assessing students understanding of materials, industrial process,
practices in industry/field organization and their ability to engage in activities related to
problem solving in industrial setup as well as understanding of application of knowledge and
skills learnt in real life situations.
Teachers and students are requested to see the footnote below the study and evaluation scheme
of 3rd semester for further details.
The teacher along with field supervisors will conduct performance assessment of students.
The components of evaluation will include the following:
This course offers a good understanding of cloud computing concepts and challenges faced in
implementation of cloud computing.
LEARNING OUTCOMES
LIST OF PRACTICALS
1. Introduction to Cloud Vendors: Amazon, Microsoft, IBM.
2. Setting up Virtualization using Virtualbox/VMWare Hypervisor
3. Introduction to OwnCloud
4. Installation and configuration of OwnCloud software for SaaS
5. Accessing Microsoft AZURE cloud-services
6. Cloud Simulation Software Introduction: CloudSim
INSTRUCTIONAL STRATEGY
In addition to classroom teaching, the teacher should demonstrate the practical usage of cloud using
real cloud services.
MEANS OF ASSESSMENT
RECOMMENDED BOOKS
Rajkumar Buyya, James Broberg, Andrzej Goscinski (Editors): Cloud Computing: Principles
and Paradigms, Wiley, 2011
Kumar Saurabh, Cloud Computing, Wiley, 2012.
Barrie Sosinsky: Cloud Computing Bible, Wiley, 2011.
Judith Hurwitz, Robin Bloor, Marcia Kaufman,Fern Halper: Cloud Computing for Dummies,
Wiley, 2010
E-books/e-tools/relevant software to be used as recommended by AICTE/NITTTR,
Chandigarh.
RATIONALE
A diploma holder must have knowledge of different types of pollution caused due to industries and
constructional activities so that he may help in balancing the ecosystem and controlling pollution by
various control measures. He should also be aware of environmental laws related to the control of
pollution. He should know how to manage the waste. Energy conservation is the need of hour. He
should know the concept of energy management and its conservation.
LEARNING OUTCOMES
After undergoing the subject, the student will be able to:
Comprehend the importance of ecosystem and sustainable
Demonstrate interdisciplinary nature of environmental issues
Identify different types of environmental pollution and control measures.
Take corrective measures for the abatement of pollution.
Explain environmental legislation acts.
Define energy management, energy conservation and energy efficiency
Demonstrate positive attitude towards judicious use of energy and environmental protection
Practice energy efficient techniques in day-to-day life and industrial processes.
Adopt cleaner productive technologies
Identify the role of non-conventional energy resources in environmental protection.
Analyze the impact of human activities on the environment
DETAILED CONTENTS
1. Introduction (04 Periods)
1.1 Basics of ecology, eco system- concept, and sustainable development, Resources
renewable and non renewable.
LIST OF PRACTICALS
INSTRUCTIONAL STRATEGY
In addition to theoretical instructions, different activities pertaining to Environmental Studies like
expert lectures, seminars, visits to green house, effluent treatment plant of any industry, rain water
harvesting plant etc. may also be organized.
MEANS OF ASSESSMENT
Assignments and quiz/class tests,
Mid-term and end-term written tests
RECOMMENDED B OOKS
1. Environmental and Pollution Awareness by Sharma BR; Satya Prakashan, New Delhi.
2. Environmental Protection Law and Policy in India by Thakur Kailash; Deep and Deep
Publications, New Delhi.
3. Environmental Pollution by Dr. RK Khitoliya; S Chand Publishing, New Delhi
4. Environmental Science by Deswal and Deswal; Dhanpat Rai and Co. (P) Ltd. Delhi.
5. Engineering Chemistry by Jain and Jain; Dhanpat Rai and Co. (P) Ltd. Delhi.
6. Environmental Studies by Erach Bharucha; University Press (India) Private Ltd., Hyderabad.
7. Environmental Engineering and Management by Suresh K Dhamija; S K Kataria and Sons,
New Delhi.
L T P
4 - 4
RATIONALE
Contents of this course provide understanding of Information Security & theirs measures. Content
of this course will enable students to use techniques like Cryptography, VPNs, IDS etc. and IT Laws
in the field of Information Technology.
LEARNING OUTCOMES
Understand the need for security, Security principles related to Information Management.
Understand the various computer related attacks.
Apply different types of cryptography techniques to encrypt/decrypt data or information.
Understand the network security measures and the concept of VPNs.
Understand concept of IDS, Operating system security and web security
Understand the IT Laws and latest amendments applicable in India as well as Intellectual
property laws
DETAILED CONTENTS
1.2 Threats to security : Viruses and Worms, Intruders, Insiders, Criminal organization,
Terrorist, Information Warfare (IW), Avenues of attack, Steps in Attack.
1.3 Types of attack : Active and Passive attacks, Denial of service, backdoors and
trapdoors, sniffing, spoofing, man in the middle, replay, TCP/IP Hacking, Encryption
attacks, Malware : Viruses, Logic bombs.
2.2 Physical security : Access controls Biometrics : Fingerprints, hand prints, retina,
patterns, voice patterns, signature and writing patterns, keystrokes and physical barriers.
3.4 Public key encryption : Basics, digital certificates, certificate authorities, registration
authorities, steps for obtaining a digital certificate, steps for verifying authenticity and
integrity of a certificate.
4.1 Firewalls : Concept, design, principles, limitations, trusted system, Kerberos- concept.
4.2 Security topologies - Security zones, DMZ, Internet, Intranet, VLAN, Security
implication, Tunnelling.
4.5 Email security : Email security standards : Working principles of SMTP, PEM,
PGP, S/MINE, spam.
5.1 Intruders, Intrusion detection system (IDS), Host Based IDS, Network based IDS.
5.3 Operating system security : Operating system hardening, General steps for securing
windows operating system, Hardening UNIX/LINUX based operating system, Updates :
Hot Fix, Patch, Service pack.
6.2 Web security threats, Web traffic security approaches, Secure socket layer and
transport layer security, secure electronic transaction software development : secure code
techniques, buffer overflow, code injection, least privilege, good practices, Testing.
7.1 Information Security Standards - ISO, IT Act, Copyright Act, Patent Law, IPR, Cyber
Laws in India. IT Act 2000 Provisions and latest amendments.
7.2 Intellectual property law : Copy Right Law, Software License, Semiconductor Law
and Patent Law.
LIST OF PRACTICAL
2. Recovery the password of window machines using password recover utility (John the ripper
) or any other utility.
5. Encrypt and decrypt the message using simple transposition - Permutation (Cryptool)
6. Encrypt and decrypt the message using Caesar Cipher With variable key (Cryptool)
9. Send and receive secret message using stenography techniques using steghide.
10. Recover the data from formatted Pen Drive and Hard Disk using Power Data Recovery
Utility or any other utility.
INSTRUCTONAL STRATEGY
The content of this course is to be taught on conceptual basis with real world examples. Since this
subject is practice oriented, the teacher should demonstrate the capabilities of websites/Webpages
to students while doing practical exercises for information security. The students should be made
familiar with preventive measures for information and computer security.
MEANS OF ASSESSMENT
Assignments and quiz/class tests, mid-term and end-term written tests
Actual laboratory and practical work, exercises and viva-voce
Software installation, operation, development and viva-voce
RECOMMENDED BOOKS
1. Information Security Handbook by Darren Death ,Packt Publishing
APPROVED IN CDC COMMITTEE MEETING OF BTE,UP,LKO DATED:26-09-2021
81
2. Principles of Information Security by Whitman , Cengage Publisher
3. Cyber Security by Nina Godbole, Wiley Publisher
4. Introduction to Information Security And Cyber Laws by Dr. Surya Prakash Tripathi
5. Information Systems Security: Security Management, Metrics, Frameworks and Best
Practices by Nina Godbole, Wiley Publisher
6. Cryptography and Network Security - Principles and Practice by Stallings William, Pearson
Education Publisher.
7. Cyber Law & Cyber Crimes Simplified ,by Cyber Infomedia Publisher
8. Information Technology Act, 2000 Along with Rules & Regulations by Universal Law
Publishing
9. e-books/e-tools/relevant software to be used as recommended by AICTE/UPBTE/NITTTR,
Chandigarh.
Websites for Reference:
1. http://swayam.gov.in
2. http://spoken-tutorial.org
L T P
6 - 6
RATIONALE
This course will enable the students to understand and develop competency amongst the students to
design professional database backed dynamic and feature based web sites. The course covers the use
of programming with PHP and the concepts of database with MySQL Students will be introduced to
popular web application frameworks for building scalable web applications. The main objective for
this course is to motivate student's interest in learning Web-app development by giving them an
insight into its possibilities through practical applications. In addition, the course also provides a
sufficiently broad but practical introduction to Server-side web technologies. Hence this paper is
introduced in this curriculum.
LEARNING OUTCOMES
DETAILED CONTENTS
Print Variable, Control Statement, Form Handling, Connecting Database, Insert, Retreive,
update and delete records, Localization, MODEL, jQuery AJAX, Error Handling, File
Uploading, Validation & Preserving the Data, Sessions- Accessing, Storing & Deleting , Crud
Operations (CREATE, READ, UPDATE, DELETE, SEARCH), Redirecting to control
instructions and named routes.
LIST OF PRACTICALS
1. Design PHP based web pages using correct PHP, CSS, and XHTML syntax, structure.
2. Create Web forms and pages that properly use HTTP GET and POST protocol as appropriate.
3 Design SQL language within MySQL and PHP to access and manipulate databases.
4. Install and configure both PHP and MySQL.
5 Create PHP code that utilizes the commonly used API library functions built in to PHP.
6. Design and create a complete web site that demonstrates good PHP/MySQL client/server
design using ajax
7. To store a cookie using PHP on client side.
8. To save the user session on server side.
9. Design website using LARAVEL
10. Creation of basic Blogging website
INSTRUCTIONAL STRATEGY
Since this subject is practice oriented, the teacher should demonstrate the capabilities of
websites/WebPages to students while doing practical exercises. Since the entire course content is web
based, students can practice it online. The teachers should have practice on this framework. Entire
course is hands-on based so practicals should be conducted in the laboratory.
MEANS OF ASSESSMENT
Assignments and quiz/class tests, mid-term and end-term written tests
Actual laboratory and practical work, exercises and viva-voce
Software installation, operation, development and viva-voce
RECOMMENDED BOOKS
1. Head First PHP & MySQL , O'Reilly Media, Inc , Michael Morrison, Lynn Beighley
2. Sams Teach Yourself PHP, MySQL, and Apache All in One" by Julie C. Meloni, Publisher:
SAMS ,ISBN 0-672-32976-X
3. Web enabled development application by Ivan Byross: Commercial; TMH
4. PHP: The Complete Reference , by Steven Holzner Mcgraw Higher Ed
5. PHP and MySQL Web Development , by Luke Welling , Pearson Education india
6. Beginning Laravel by Sanjib Sinha, 2016.
7. Design Patterns in PHP and Laravel by Kelt Docking, 2016.
8. e-books/e-tools/relevant software to be used as recommended by AICTE/UPBTE/NITTTR.
L T P
6 - 6
RATIONALE
This course will enable students to understand & develop accounting features of different
organizations. The students are able to create different vouchers, ledgers. The students are able to
calculate TDS & GST of different entities like individual, company etc. Hence this subject is
introduced in the curriculum.
LEARNING OUTCOME:
After undergoing the subject, the students will be able to:
Perform various accounting operations
Calculate TDS of different entities like individual, company
Calculate GST of organizations, products etc.
To create ledger, inventory, vouchers etc.
To create update vouchers.
DETAILED CONTENTS
5. GST : What is GST. General terminologies used in GST, Advantages of GST, Advances of GST
over VAT, GST rates, Computation of GST, GST documents, Ledger Masters, Sales Ledger,
Vouchers and transactions, GST calculation, Major Amendments in GST .
LIST OF PRACTICALS
1. Exercises Based on above all topics
INSTRUCTIONAL STRATEGY
Since this subject is practice oriented, the teacher should demonstrate the capabilities of
websites/WebPages to students while doing practical exercises. Since the entire course content is web
APPROVED IN CDC COMMITTEE MEETING OF BTE,UP,LKO DATED:26-09-2021
86
based, students can practice it online. The teachers should have practice on this framework. Entire
course is hands-on based so practicals should be conducted in the laboratory.
MEANS OF ASSESSMENT
Assignments and quiz/class tests, mid-term and end-term written tests
Actual laboratory and practical work, exercises and viva-voce
Software installation, operation, development and viva-voce
RECOMMENDED BOOKS
1. Computer Based Accounting, Sandeep K. Bansal & Rama Bansal C. Mohan Juneja, Kalyani
Publishers
2. Computerized Accounting, P.H. Bassett, NCC Services.
3. e-books/e-tools/relevant software to be used as recommended by AICTE/UPBTE/NITTTR.
http://swayam.gov.in
http://spoken-tutorial.org
L T P
6 - 6
RATIONALE
Knowing the details of Mobile and their working principle are need of every common man. Mobile
Application development is the very hot business domain. Majority of the corporate have a separate
division for the development of mobile applications. It is essential that diploma students must know
the way to apply advanced data communicating methods and networking protocols for wireless and
mobile devices. Hence this subject is introduced in this course.
LEARNING OUTCOMES
• Consume JSON data and call web services from Android mobile app.
DETAILED CONTENTS
What is Android? Dalvik Virtual Machine & .apk file extension, Fundamentals: Basic Building
blocks - Activities, Services, Broadcast Receivers & Content providers, UI Components - Views &
notifications, Components for communication -Intents & Intent Filters, Android API levels (versions
& version names)
Layouts: Liner Layout, Relative Layout, Frame Layout, Coordinate Layout, [dip, dp, sip, sp] versus
px
Intents: Intents introduction and importance, Types of Intents (Explicit Intents, Implicit intents)
Introduction to Menus, Types of Menus (Option menu, Context menu), Uses of Shared Preferences
Time and Date, List View, Grid View, Card View, recycler view Adaptors (Base Adaptor, Array
Adaptor) & View Holder, Dialogs, Toast, Popup, Fragments, Material Design (Introduction,
Navigation, Floating Button, Tool bar).
Threads running on UI thread (run on UI Thread), Worker thread, Handlers & Runnable, AsynTask,
calling web services and consuming JSON data from Web Services.
Supported Storage in Android (Internal memory, External memory, Shared Preferences and network),
SQLite introduction, CRUD Operations in SQLite database (cursor, content values etc), Basics of
Content Provider
LIST OF PRACTICALS
4. Write a program to implement simple calculator using text view, edit view, option button and
button
5. Write a program to develop app having multiple activities and user should be able switch between
the activities by using intents.
9. Develop and simple application with context menu and option menu.
11. Develop a sample Android application having navigation items similar to Gmail Application.
15. Write a program to store and fetch data from SQL life database.
INSTRUCTIONAL STRATEGY
Since this subject is practice oriented, the teacher should demonstrate the capabilities of Android app
to students while doing practical exercises. The students should be made familiar with developing
mobile app and understand the basic concept of Android Platform.
MEANS OF ASSESSMENT
RECOMMENDED BOOKS
L T P
6 - 6
RATIONALE
Business data subject provides an introduction to Big data and analytics, which include the use of
data, statistical and quantitative analysis, exploratory and predictive models, to inform decisions
and actions related to data.
LEARNING OUTCOMES
LIST OF PRACTICAL
1. Write a very simple Hadoop program that counts the number of occurrences of each word in
a text file.
3. Write a Hadoop program to take a text file as input now convert all characters in upper case
and save into another text file.
4. Write a Hadoop program to take a text file as input now search a word in the file and
count number of occurrence of that word in the file.
5. Write a Hadoop program to take a text file as input now search a word in the file now
replace that word with another word.
Projects:-
1. Public Interest Analysis Based on Implicit Feedback of IPTV(Internet Protocol television)
Users.
2. Dynamic Job Ordering and Slot Configurations for MapReduce Workloads.
INSTRUCTONAL STRATEGY
The subject is totally practical based. Students should be given clear idea about the basic concepts of
programming related to Big Data.
RECOMMENDED BOOKS
1. Big Data Analytics with R and Hadoop by Vignesh Prajapati
2. Data Science for Business: What You Need to Know about Data Mining by om Fawcett
3. Hadoop for Dummies by Dirk Deroos
4. The Human Face of Big Data by Rick Smolan and Jennifer Erwitt
5. Big Data: A Revolution That Will Transform How We Live, Work, and Think by Kenneth
Cukier and Viktor Mayer-Schönberger
6. Hadoop – The Definitive Guide by Tom White
7. e-books/e-tools/relevant software to be used as recommended by AICTE/UPBTE/NITTTR,
Chandigarh.
Major Project Work aims at developing innovative skills in the students whereby they apply in totality
the knowledge and skills gained through the course work in the solution of particular problem or by
undertaking a project. The individual students have different aptitudes and strengths. Project work,
therefore, should match the strengths of students. For this purpose, students should be asked to
identify the type of project work, they would like to execute. It is also essential that the faculty of the
respective department may have a brainstorming to identify suitable project assignments for their
students. The project assignment can be individual assignment or a group assignment. There should
not be more than 3 students if the project work is given to a group. The students should identify
themselves or accept the given project assignment at least two to three months in advance. The project
work identified in collaboration with industry should be preferred. Each teacher is expected to guide
the project work of 5–6 students.
The project assignments may consist of:
LEARNING OUTCOMES
A suggestive criterion for assessing student performance by the external (personnel from industry)
and internal (teacher) examiner is given in table below:
The overall grading of the practical training shall be made as per following table
In order to qualify for the diploma, students must get “Overall Good grade” failing which the students
may be given one more chance of undergoing 8 -10 weeks of project oriented professional training
in the same industry and re-evaluated before being disqualified and declared “not eligible to receive
diploma ”. It is also important to note that the students must get more than six “goods” or above
“good” grade in different performance criteria items in order to get “Overall Good” grade.
Important Notes
1. These criteria must be followed by the internal and external examiner and they should
see the daily, weekly and monthly reports while awarding marks as per the above
criteria.
2. The criteria for evaluation of the students have been worked out for 100 maximum
marks. The internal and external examiners will evaluate students separately and give
marks as per the study and evaluation scheme of examination.
3. The external examiner, preferably, a person from industry/organization, who has been
associated with the project-oriented professional training of the students, should
evaluate the students performance as per the above criteria.
4. It is also proposed that two students or two projects which are rated best be given merit
certificate at the time of annual day of the institute. It would be better if specific nearby
industries are approached for instituting such awards.
The students must submit a project report of not less than 50 pages (excluding coding). The report
must follow the steps of Software Engineering Concepts
It is proposed that the institute may organize an annual exhibition of the project work done by the
students and invite leading Industrial organizations in such an exhibition. It is also proposed that two
students or two projects which are rated best be given merit certificate at the time of annual day of
the institute. It would be better if specific industries are approached for instituting such awards.
Norms and standards laid down by All India Council for Technical Education (AICTE) may
be followed to work out space requirement in respect of class rooms, tutorial rooms, drawing
halls, laboratories, space required for faculty, student amenities and residential area for staff
and students.
10.1.2 Laboratoires/Shops
- Programming Lab
PROGRAMMING LAB
Sr. Description Qty Approx. Price
No. (Rs)
1. Computer Server (Quad core, intel processor 32 GB 1 5,00,000/-
RAM)
2. Computer Desktop (i7,8th Generation, 1TB Hard disk, 60 48,00,000/-
8Gb RAM, Pre loaded window with 5 year warranty)
3. Switch with 24 port speed 10/100/1000 (Manageable) 3 1,50,000/-
4. Multifunctional Laser/Ink tank Printer 3 90,000/-
5. Laptop 1 75,000/-
6. Online UPS, 6KVA with battery 2 2,00,000/-
7. Internet Connectivity 60 3,00,000/-
Nodes
8. LCD/DLP Projector with Screen (HD/Full HD/4K) 1 60,000/-
9. Linux Operating System (Open Source) - -
10. Visual Studio Community Edition (Freeware, Open - -
Source)
11. Visual Studio Code (Open Source) - -
12. Multimedia Tools – Software - -
- Blender (Freeware)
- Gimp Animation Tool (Freeware)
13. Mongo DB (Freeware) - -
14. Python IDE (PyCharm/Eclipse with PyDev/VS Code etc) - -
– Freeware
6. Laptop 1 75,000/-
31. VLSI Kit Xilinx with cable and power adapter 10 45,000/-
No.
1. pH Meter 01 500
NOTE:
Norms and standards laid down by AICTE be followed for working out furniture
requirement for this course.
Weekly work schedule, annual work schedule, student teacher ratio for various group and class
size, staffing pattern, work load norms, qualifications, experience and job description of teaching
staff workshop staff and other administrative and supporting staff be worked out as per norms
and standards laid down by the AICTE. The website www.aicte.ernet.in may be referred for
downloading current norms and standards pertaining to technician courses.
11.1 INTRODUCTION
Evaluation plays an important role in the teaching-learning process. The major objective of any
teaching-learning endeavour is to ensure the quality of the product which can be accessed
through learner’s evaluation.
The purpose of student evaluation is to determine the extent to which the general and the specific
objectives of curriculum have been achieved. Student evaluation is also important from the point
of view of ascertaining the quality of instructional processes and to get feedback for curriculum
improvement. It helps the teachers in determining the level of appropriateness of teaching
experiences provided to learners to meet their individual and professional needs. Evaluation also
helps in diagnosing learning difficulties of the students. Evaluation is of two types: Formative and
Summative (Internal and External Evaluation)
Formative Evaluation
Summative Evaluation
It is carried out at the end of a unit of instruction like topic, subject, semester or year. The main
purpose of summative evaluation is to measure achievement for assigning course grades,
certification of students and ascertaining accountability of instructional process. The student
evaluation has to be done in a comprehensive and systematic manner since any mistake or lacuna
is likely to affect the future of students.
In the present educational scenario in India, where summative evaluation plays an important role
in educational process, there is a need to improve the standard of summative evaluation with a
view to bring validity and reliability in the end-term examination system for achieving objectivity
and efficiency in evaluation.
- Theory
- Practical Work (Laboratory, Workshop, Field Exercises)
- Project Work
- Professional Industrial Training
A. Theory
Section-I
It should contain objective type items e.g. multiple choice, matching and completion type.
Total weightage to Section-1 should be of the order of 20 percent of the total marks and no
choice should be given in this section. The objective type items should be used to evaluate
students’ performance in knowledge, comprehension and at the most application domains
only.
Section-II
It should contain short answer/completion items. The weightage to this section should be of
the order of 40 percent of the total marks. Again, no choice should be given in section-II
Section-III
It may contain two to three essay type questions. Total weightage to this section should be of
the order of 40 percent of the total marks. Some built-in, internal choice of about 50 percent
of the questions set, can be given in this section
B. Practical Work
C. Project
Validity and reliability are the most important considerations in the selection and construction
of evaluation procedures. First and foremost are the evaluation tools to measure the specific
outcomes for which they are intended to measure. Next in importance is reliability, and
following that is a host of practical features that can be classified under the heading of
usability.
For weightage of marks assigned to formative (internal) and summative (external) evaluation
and duration of evaluation has been given in the study and evaluation scheme of the
curriculum document. Teachers/Paper-setters/Examiners may use Manual for Students’
Evaluation developed by Institute of Research Development & Training, U.P. Kanpur to bring
objectivity in the evaluation system. The working group found it very difficult to detail out
precisely the contents of subject on languages and therefore teachers may send guidelines to
respective examiners for paper setting to maintain objectivity in evaluation.
This curriculum document is a Plan of Action (POA) and has been prepared based on exhaustive
exercise of curriculum planning and design. The representative sample comprising selected senior
personnel (lecturers and HODs) from various institutions and experts from industry/field have been
involved in curriculum design process.
The document so prepared is now ready for its implementation. It is the faculty of polytechnics who
have to play a vital role in planning instructional experiences for the courses in four different
environments viz. class-room, laboratory, library and field and execute them in right perspective. It
is emphasized that a proper mix of different teaching methods in all these places of instruction only
can bring the changes in stipulated students behaviour as in the curriculum document. It is important
for the teachers to understand curriculum document holistically and further be aware of intricacies of
teaching-learning process (T-L) for achieving curriculum objectives. Given below are certain
suggestions which may help the teachers in planning and designing learning experiences effectively.
These are indicative in nature and teachers using their creativity can further develop/refine them. The
designers of the programme suggest every course teacher to read them carefully, comprehend and
start using them.
2. Uttar Pradesh State Board of Technical Education (BTE U.P.) may make the academic plan
available to all polytechnics well in advance. The Principals have a great role to play in its
dissemination and, percolation upto grass-root level. Polytechnics in turn are supposed to
prepare institutional academic plan by referring state level BTE plan.
3. HOD of every Programme Department along with HODs and in-charges of other departments
are required to prepare academic plan at department level referring institutional academic
plan.
5. All lecturers/Senior lecturers are required to prepare course level and class level lesson plans
referring departmental academic plan.
Teachers are educational managers at class room level and their success in achieving course
level objectives lies in using course plan and their judicious execution which is very important
for the success of programme by achieving its objectives.
Polytechnic teachers are required to plan various instructional experiences viz. theory lecture,
expert lectures, lab/workshop practicals, guided library exercises, field visits, study tours,
camps etc. In addition, they have to carry out progressive assessment of theory, assignments,
library, practicals and field experiences. Teachers are also required to do all these activities
within a stipulated period of 16 weeks which is made available to them in the academic plan
at BTE level. With the amount of time to their credit, it is essential for them to use it
APPROVED IN CDC COMMITTEE MEETING OF BTE,UP,LKO DATED:26-09-2021
109
judiciously by planning all above activities properly and ensure execution of the plan
effectively.
Following is the gist of suggestions for subject teachers to carry out T-L process
effectively:
1. Teachers are required to prepare a course plan, taking into account departmental academic
plan, number of weeks available, course to be taught, different learning experiences required
to be developed etc.
2. Teachers are required to prepare lesson plan for every theory class. This plan may comprise
of content to be covered, learning material (transparencies, VCDs, Models etc.) for execution
of a lesson plan. They may follow steps for preparing lesson plan e.g. drawing attention, state
instructional objectives, help in recalling pre-requisite knowledge, deliver planned subject
content, check desired learning outcome and reinforce learning etc.
3. Teachers are required to plan for expert lectures from field/industry. Necessary steps are to
plan in advance, identify field experts, make correspondence to invite them, take necessary
budgetary approval etc.
4. Teachers are required to plan for guided library exercises by identification of course specific
experience requirement, setting time, assessment, etc. The tutorial, assignment and seminar
can be thought of as terminal outcome of library experiences.
5. Concept and content based field visits with appropriate releases (day-block) may be planned
and executed for such content of course which otherwise is abstract in nature and no other
requisite resources are readily available in institute to impart them effectively.
6. There is a dire need for planning practical experiences in right perspective. These slots in a
course are the avenues to use problem based learning/activity learning/ experiential learning
approach effectively. The development of lab instruction sheets for the course is a good
beginning to provide lab experiences effectively.
8. The co-curricular activities like camp, social gathering, study tour, hobby club etc. may be
used to develop generic skills like task management, problem solving, managing self,
collaborating with others etc.
9. Where ever possible, it is essential to use activity based learning rather than relying on
delivery based conventional teaching all the time.
10. While imparting instructions, emphasis may be laid on the development of cognitive,
psychomotor, reactive and interactive skills in the students.
11. Teachers may take working drawings from the industry/field and provide practices in reading
these drawings.
13. Teachers may take initiative in establishing liaison with industries and field
organizations for imparting field experiences to their students.
14. Case studies and assignments may be given to students for understanding of Enterprise
Resource Management (ERM).
15. Students be made aware about issues related to ecology and environment, safety, concern for
wastage of energy and other resources etc.
16. Students may be given relevant and well thought out minor and major project assignments,
which are purposeful and develop practical skills. This will help students in developing
creativity and confidence for their gainful employment (wage and self).
17. A Project bank may be developed by the concerned department of the polytechnics in
consultation with related Industry, Research Institutes and other relevant field organizations
in the state.
The following experts have participated in workshop for Developing Curriculum Contents of
PG diploma course in Computer Application for UP State on 18th October, 2019 at IRDT
Kanpur, 30th January, 2020 at GP Ghaziabad, 05th July, 2021 at IRDT Kanpur and 8th July,
2021 at IRDT Kanpur: