SHRI VILE PARLE KELAVANI MANDAL’S

SHRI BHAGUBHAI MAFATLAL POLYTECHNIC

INFORMATION TECHNOLOGY DEPARTMENT

SEMESTER-III
SCHEME -2023
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
1. COURSE DETAILS

Programme: CSE/IT Semester: III

Course: Social & Life Skills Course Category: VEC

Course Code: SLS238910 Duration:16 Weeks

2. LEARNING AND ASSESSMENT SCHEME

Learning Scheme Assessment Scheme

Actual Self-
Contact Learning Based on LL & TL Based on
Pape Theory (Marks) Self
Hrs./Week (SL^)
r Learning
(Term Credits Practical (Marks)
Dura Total
Work +
tion Marks
Assignmen SA
CL TL LL (Hrs. FA- FA- SA- SA- SLA
t) - Total
) TH PR PR OR (Marks)
(Hrs.) TH

- - - 2 1 - - - - - --- 25 25
--

3. COURSE OBJECTIVE:
Life skills include social skills and interpersonal skills that help individual make informed decisions,
solve problems, think critically and creatively, build healthy relationships, empathize with others, by
managing one’s life. Life skills are essentially those abilities that help to promote overall wellbeing
with holistic approach to face the problems of real life. Students learn socio- life skills from parents,
teachers and significant others individuals to translate knowledge, attitude and values into actual
abilities.
Note: The course offers three different alternatives(modules) for achieving above outcomes. Students
must complete any one module from the following given objective.
a. MODULE-I : Unnat Maharashtra Abhiyan (UMA)
b. MODULE-II : National Service Scheme (NSS)
c. MODULE-III : Financial Literacy (NABARD)
The institute can choose to offer any one MODULE to the groups of the students by taking into
consideration the resources required and resources available in the institute. Different group of
students may be offered different MODULE based on their choices.
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
4. SKILL COMPETENCY/INDUSTRY/EMPLOYER EXPECTED OUTCOME
1. Decision making
2. Problem solving
3. Time management
4. Presentation and Grooming skills
5. Social Skills & Empathy
6. Emotional intelligence
7. Financial Literacy

5. COURSE OUTCOMES (COs): At the end of the semester student will be able to: -
CO No. COURSE OUTCOME
CO1 Develop interpersonal skills and leadership skills for empowerment of self and others
CO2 Provide the opportunity to get social experience while working individually or in group for society.
CO3 Develop financial literacy skills for self & community development.
CO4 Communicate professionally for liaisoning between individual & group.

6. CO-PO, CO- PSO MAPPING TABLE

Programme Outcomes
Course and Course PO1 PO2 PO3 PO4 PO5 PO6 PO7 PSO1 PSO2
Code Outcom
es
Social & Life CO 1 - - - - - 3 1 - -
Skills
CO 2 - - - - 3 1 1 - -
( SLS238910)
CO 3 - - - - 2 1 1 - -

CO 4 - - - - 1 3 1 - -

CO - - - - -
- 2 2 1
Avg.
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
7. COURSE CONTENTS

UNIT TOPIC/sub topic

NO
MODULE I: Activities Under Unnat Maharashtra Abhiyan (UMA)
1.1 Introduction to Societal Needs and respective stakeholders:
Regional societal issues that need engineering intervention
1.2 Multidisciplinary approach-linkages of academia, society and technology
1.3 Stakeholders’ involvement
1.4 Introduction to Important secondary data sets available such as census,
district economic surveys, cropping pattern, rainfall data, road network data etc
1.5 Problem Outline and stakeholders:
Importance of activity and connection with Mapping of system components
and stakeholders (engineering / societal)
I
1.6 Various instruments used for data collection - survey templates, simple
measuring equipment.
1.7 Format for measurement of identified attributes/ survey form and piloting of
the same
1.8 Fieldwork: Measurement and quantifications of local systems such as
agriculture produce, rainfall, Road network, production in local industries,
Produce /service which moves from A to B
1.9 Analysis and Report writing 1. Introduction of the topic
2. Data collected in various formats such as table, pie chart, bar graph etc
3. Observations of field visits and data collected.
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT

MODULE II : National Service Scheme (NSS)

2.1 Contacting Village/Area Leaders
2.2 Primary socio -economic survey of few villages in the vicinity of the institute.
2.3 Selection of the village for adoption - conduct of activities
2.4 Comprehensive Socio Economic Survey of the Village/Area
2.5 Identification of Problem(s)
II
2.6 Dissemination of information about the latest developments in agriculture,
watershed management, wastelands development, non-conventional energy, low
cost housing, sanitation, nutrition and personal hygiene, schemes for skill
development, income generation, government schemes, legal aid, consumer
protection and allied fields.
2.7 A liaison between government and other development agencies for the
implementation of various development schemes in the selected village / slum.

MODULE-III : Financial Literacy

3.1 Introduction - Life Goals and financial goals
3.2 Savings and Investments - Three pillars of investments, Popular asset classes,
Government schemes, Mutual Funds, Securities markets (Shares and bonds), Gold, Real
Estate, Do’s and Don’ts of investments
3.3 Retirement planning
III
3.4 Cashless transactions
3.5 Income, expenditure and budgeting – Concepts and Importance
3.6 Inflation- Concept, effect on financial planning of an individual
3.7 Loans – Types, Management of loans, Tax benefits
3.8 Insurance – Types, Advantages, selection
3.9 Dos and Donts in Financial planning and Transactions
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
8. List of activities for Self Learning:
Following list is an illustrative list of the type of activities that can be undertaken. Under this
course it would be open to undertake one of these or many other activities which may seem
suitable to local needs.
1) Plantation of trees, their preservation and upkeep
2) Construction & maintenance of village streets, drains.
(3) Cleaning of village ponds and wells.
(4) Popularization and construction of Gobar Gas Plants, use of non- conventional
Energy.
(5) Disposal of garbage & composting.
(6) Prevention of soil erosion and work for soil conservation.
(7) Watershed management and wasteland development.
(8) Preservation and upkeep of monuments, and creation of consciousness about the
preservation of cultural heritage among the community.
(9) Health education, AIDS Awareness and preliminary health care.
(10) Working with cancer patients / orphans/ old age home/ welfare organizations of
women with NGO.
(11) Empowering women by creating awareness among them and imparting training
in sewing, embroidery, knitting and other skills wherever possible to make them
financially independent.
(12) Organizing Blood donation/Eye check Up/Body donation camp.
(13) Popularization of small savings and assistance in procuring bank loans of
government schemes, mutual funds and share market, financial planning.
(14) Organization of youth clubs, rural land indigenous sports in collaboration with
Nehru Yuva Kendras;
(15) Assisting the authorities in distribution of rations, medicine, clothes, immunization,
supply of medicine, relief and rescue operation; collection of clothes and other
materials, and sending the same to the affected areas
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
9. IMPLEMENTATION STRATEGY (PLANNING)
1. Industry visit
2. Guest/Expert lectures
3. Demonstrations
4. Slides
5. Self-Learning Online Resources
6. Case Study
7. Role Play
8. Collaborative learning

10.SUGGESTED LEARNING RESOURCES

Sr.No. Title of Book Author Publication
Compendium of Training Materials
for the Capacity Building on
‘IMPROVING THE IRAP, Hyderabad,
PERFORMANCE OF RURAL CTARA, IIT Bombay UNICEF
1
and UNICEF, Mumbai
WATER SUPPLY AND
SANITATION SECTOR IN
MAHARASHTRA’
Districts Economic survey reports
Central Public Health and Ministry of Urban
2 Environmental
Manual on Water Supply and Treatment Development, New
Engineering Organization Delhi
Indian Standards (IS) Codes and Indian Specifications And Bureau of Indian
3 Roads Congress (IRC) Codes Standards Committee Standards and The
Indian Road
Congress

4 Sample Case Studies on UMA website Local college students,

UMA staffs IITB-UMA team

11 LEARNING WEBSITE & PORTALS

1 https://gr.maharashtra.gov.in/Site/Upload/Government
2 https://gr.maharashtra.gov.in/Site/
3 https://censusindia.gov.in/census.website/
4 https://gsda.maharashtra.gov.in/english/
5 https://mrsac.gov.in/MRSAC/map/map
6 https://ejalshakti.gov.in/jjmreport/JJMIndia.aspx
7 https://cpcb.nic.in/
8 http://www.mahapwd.com/#
9 http://tutorial.communitygis.net/
10 https://nss.gov.in/
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
12. ASSESMENT METHODOLOGIES/TOOLS
Formative Assessment (Assessment for Learning)
1. Self-Learning
2. Seminar/Presentation
3. Report and presentation of fieldwork activities
4. Assignment

13. COURSE EXPERT COMMITTEE MEMBERS

Sr.
NAME sign
No.
1 Internal Mr. Balaji M. Pande, Senior Lecturer in English

Internal Mrs. Keerti P. Bhave Lecturer (Selection Grade )

2

3 Internal Mr. Prasad S. Dhuri , Lecturer EXTC

 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
1. COURSE DETAILS

Programme: CSE/IT Semester: III

Course: Programming in Java Course Category: AEC
Course Code: PRJ238913 Duration:16 Weeks

2. LEARNING AND ASSESSMENT SCHEME

Learning Scheme Assessment Scheme

Actual Self-Learning
Based on LL & TL Based on
Contact Hrs./Week (SL^) (Term Theory (Marks) Self
Credits Paper
Work + Learning Total
Duration
Assignment) Practical (Marks) Marks
(Hrs.)
CL TL LL (Hrs)
FA- SA- FA- SA- SA- SLA
Total
TH TH PR PR OR (Marks)
02 - 04 02 04 03 30 70 100 25 25 - 25 175

Total IKS Hrs for the course :00

3. COURSE OBJECTIVE

Java is one of the most powerful object-oriented programming languages. It supports development of
secured, portable, concurrent, and distributed applications. From laptops to data centres, game consoles
to scientific supercomputers, cell phones to the Internet, Java is everywhere! This course is designed to
provide basics of Java Language.

4. SKILL COMPETENCY/INDUSTRY/EMPLOYER EXPECTED OUTCOME

 Write Java programs using Inheritance, Exception Handling and Multithreading.
 Develop desktop GUI applications.

5. COURSE OUTCOMES (COs): At the end of the semester student will be able to: -
CO No. COURSE OUTCOME
CO1 Write code for basic problems in Java
CO2 Use class & object to solve object-oriented problems
CO3 Implement programs based on Inheritance and packages
CO4 Demonstrate exception handling mechanism
CO5 Write multithreaded Java programs
CO6 Design GUI applications using AWT and SWING controls
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
6. CO-PO, CO- PSO MAPPING TABLE - Computer Engineering

Course and Course Programme Outcomes Programme

Code Outcomes Specific
Outcomes
PO1 PO2 PO3 PO4 PO5 PO6 PO7 PSO1 PSO2
CO1 3 2 2 2 - 3 2 3 -

CO2 3 2 2 2 - 3 3 3 -

CO3 3 3 3 2 - 3 3 3 -
Programming
CO4 3 1 2 2 - 3 2 3 -
in Java
(PRJ238913)
CO5 3 2 2 2 - 3 2 3 -

CO6 3 1 1 1 -- 3 2 3 -

3 1.83 2 1.83 -- 3 2.33 3 -

CO Avg.

CO-PO, CO- PSO MAPPING TABLE - Information Technology

Course and Course Programme Outcomes Programme

Code Outcomes Specific
Outcomes
PO1 PO2 PO3 PO4 PO5 PO6 PO7 PSO1 PSO2
3 2 2 2 - 3 2 3 -
CO1
3 2 2 2 - 3 3 3 -
CO2
3 3 3 2 - 3 3 3 -
CO3
Programming 3 1 2 2 - 3 2 3
CO4 -
in Java
(PRJ238913)
CO5 3 2 2 2 - 3 2 3 -

CO6 3 1 1 1 -- 3 2 3 -

3 1.83 2 1.83 -- 3 2.33 3 -

CO Avg.
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
7. COURSE CONTENTS
UNIT NO. TOPIC/Sub-topic
Introduction to object-oriented programming
1.1 Creation of java, java byte code, java characteristics
1.2 Abstraction, OOP Principles. -Encapsulation, Inheritance and Polymorphism
1.3 Constant, Variables and Data Types, Type casting
1.4 Operator and Expression, Arithmetic Operators, Relational Operators, Logical Operators,
Assignment Operator, Increment and Decrement Operator, Bit wise Operator, Special
I
Operator
1.5 Decision making with simple if, if… else, else if ladder statements, The switch statement,
The conditional operator
1.6 Decision Making with Loops i.e. while, do and for statement, Jumps in Loops, Labelled
Loops

Classes, Objects and Methods

2.1 Class Fundamentals, The General Form of a Class, A Simple Class
2.2 Declaring Objects, A Closer Look at new, Assigning Object Reference Variables
2.3 Introducing Methods, adding a Method to the Class, returning a Value, adding a Method that
II takes parameters
2.4 Constructors, Parameterized Constructors
2.5 ‘this’ Keyword
2.6 static data, method, and blocks
2.7 String class and its methods

Inheritance, Interfaces and Packages

3.1 Inheritance Basics,
3.2 Member Access and Inheritance,
3.3 A Superclass Variable Can Reference a Subclass Object
3.4 Use of super keyword
III 3.5 Creating a Multilevel Hierarchy,
3.6 Method Overriding, Dynamic Method Dispatch, Abstract classes
3.7 Defining an Interface, Implementing Interfaces, applying interfaces, Variables in Interfaces,
3.8 Implementing Multiple Inheritance (Multiple Inheritance), Interfaces Can Be Extended
3.9 Packages, defining a Package, Finding Packages and CLASSPATH,
3.10 Access Protection, Importing Packages
Exception Handling
4.1 Exception-Handling Fundamentals, Exception class hierarchy
4.2 Uncaught Exceptions, try and catch, Multiple catch Clauses, nested try Statements, throw,
IV throws, finally clauses
4.3 Java’s Built-in Exceptions - Checked and Unchecked Exceptions
4.4 Creating Your Own Exception Subclasses using Exceptions
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
Multithreading
5.1 The Java Thread Model,The Thread Life Cycle, Thread class methods
5.2 The Thread Class and the Runnable Interface
5.3 The Main Thread, creating a Thread, Extending Thread, Implementing Runnable
V
5.4 Creating Multiple Threads, Using isAlive( ) and join( )
5.5 Thread Priorities, Synchronization, Using Synchronized Methods, The synchronized
Statement
5.6 Interthread Communication
AWT and SWING Controls
6.1 Abstract Window toolkit, AWT classes
6.2 Event handling, Delegation event model, Event model, Event classes, source of events, event
listener interface,
VI 6.3 windows fundamentals, creating a frame window, working with frame window, working with
graphics
6.4 Introduction to AWT controls, inserting user interfaces like buttons, checkbox, list, scrollbar,
text field and text areas, layout managers.
6.5 Introduction to SWING GUI Controls

8. LIST OF PRACTICALS/ASSIGNMENTS/ TUTORIALS/DRAWINGS

Term Work consists of Journal containing minimum no of –12 Experiments/assignments/drawings.
Sr. No. Title of Experiment/Assignment/Exercise/Tutorial/Drawings Approx. Hrs CO
required
1 To Install and Set up Jdk18 on Windows OS to write, compile, 2 CO1
and execute a sample Program.
2 To test various data types and typecasting concept available in 2 CO1
Java
3 To define a class having overloaded constructors and 2 CO2
instantiating objects of the same class. (2 problems)
4 To implement the concept of array of objects in Java (2 4 CO2
problems)
5 To take user inputs through command line arguments. (2 2 CO2
problems)
6 To implement single and multi-level inheritance 6 CO3
7 To implement Dynamic Method Dispatch in Java. 2 CO3
8 To implement multiple Inheritance. 4 CO3
9 To create packages with access controls and importing them in 4 CO3
appropriate classes.
10 To handle exceptions generated in Java 4 CO4
11 To create a user defined exception class. 4 CO4
12 To create user defined threads to achieve multitasking. 6 CO5
13 To achieve synchronization among multiple threads. 2 CO5
14 To develop GUI application using AWT controls and handling 8 CO6
events.
15 To develop GUI application using SWING controls and handling 8 CO6
events.
TOTAL 60
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
9. SUGGESTED MICRO PROJECT/ASSIGNMENT/ACTIVITES FOR SPECIFIC
LEARNING / SKILL DEVELOPMENT (SELF LEARNING)
Assessment to be based on one of the following tools and rubrics for evaluation of SLA to be well
defined by course teacher.
1. Micro project
a. Bank Management System – Develop savings and fixed deposit modules
b. Quiz management system – Generate technical quiz for testing knowledge
c. Airline Reservation System – Books tickets for domestic/international flights
d. Healthcare System – Implement doctor, patient, and hospital modules
e. College Management System – Develop student admission, course management modules
(Use OOPs principles to develop aforementioned Java applications)
2. Assignment
Practice problems on array of objects, inheritance, exception handling, multithreading, and
desktop GUI

10. IMPLEMENTATION STRATEGY (PLANNING)

1. Teaching Plan
2. Minimum no of practical/assignments
3. Guest/Expert lectures
4. Slides
5. Self-Learning Online Resources

11. SUGGESTED LEARNING RESOURCES (minimum 3 to 5)

Sr.No. Title of Book Author Publication

1 Java The Complete Reference Herbert Schildt Tata McGraw Hill

2 Core Java™ Volume I Cay S. Horstmann Prantice Hall

Fundamentals ,Gary Cornel
3 Java How To Program Paul Deitel, Pearson
Harvey Deitel
4 Effective Java Joshua Bloch Addison Wesley

12. LEARNING WEBSITE & PORTALS

1. https://beginnersbook.com/java-tutorial-for-beginners-with-examples/
2. https://www.javatpoint.com/java-tutorial
3. https://www.guru99.com/java-tutorial.html
4. http://tutorials.jenkov.com/java/index.html
5. https://www.digitalocean.com/community/tutorials/core-java-tutorial

13. ASSESMENT METHODOLOGIES/TOOLS

Formative Assessment (Assessment for Learning)
1. Test
2. Rubrics for COs Assignment
3. Self-Learning
4. Term Work
5. Seminar/Presentation
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
Summative Assessment (Assessment of Learning)
1. End Term Exam
2. Micro-project

14. SUGGESTED WEIGHTAGE FOR LEARNING EFFORTS & ASSESMENT PURPOSE

(Specification Table)
Aligned Learning Distribution of Theory Marks
Unit
Unit Title COs Hours R U A Total
No.
Level Level Level Marks
Introduction to object-
I oriented programming CO1 04 02 04 - 06

II Classes, Objects and 05 03 03 06 12

CO2
Methods
Inheritance, Interfaces
III and Packages CO3 08 04 08 08 20

IV Exception Handling 04 02 04 04 10
CO4

V Multithreading 04 02 04 04 10
CO5
AWT and SWING
VI Controls CO6 05 02 04 06 12

GRAND TOTAL 30 15 27 28 70
R Remember, U Understand, A Apply and above, (Bloom’s revised taxonomy levels)
NOTE: This specification table provides general guidelines to assist students for their learning and to
teachers to teach and assess students with respect to attainment of COs. The actual distribution of marks
at different taxonomy levels (R, U, A) in the question paper may vary from above table.

15. COURSE EXPERT COMMITTEE MEMBERS

Sr.
No. NAME

1 Internal Mr. Manish R Solanki

Internal Mrs. Geetha S

2

Siddhesh Vaidya
3 External
System Analyst, National Stock Exchange, Mumbai
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
1.COURSE DETAILS

Programme: CSE/IT Semester: III

Course: Data Structure Course Category: DSC

Course Code: DST238914 Duration:16 Weeks

2. LEARNING AND ASSESSMENT SCHEME

Learning Scheme Assessment Scheme

Actual Self-Learning
Based on LL & TL Based on
Contact Hrs./Week (SL^) (Term Theory (Marks) Self
Credits Paper
Work + Learning Total
Duration
Assignment) Practical (Marks) Marks
(Hrs.)
CL TL LL (Hrs)
FA- SA- FA- SA- SA- SLA
Total
TH TH PR PR OR (Marks)
04 - 02 - 03 - 30 70 100 25 25 - - 150

Total IKS Hrs for the course :00

3. COURSE OBJECTIVE
This subject intends to teach the students the core requisites of Computer programming which is
storing and analysing data in various structures like stacks, queues, linked lists, trees, graphs etc.
4. SKILL COMPETENCY/INDUSTRY/EMPLOYER EXPECTED OUTCOME

 Write and implement algorithms to store and manipulate data in various data
structure
 To implement and compare various searching –sorting algorithms and analyse the
complexities

5. COURSE OUTCOMES (COs): At the end of the semester student will be able to: -

CO No. COURSE OUTCOME

CO1 Perform operations on an array and analyze an algorithm for its time and space
complexity.
CO2 Implement searching and sorting techniques
CO3 Implement the static linear data structure
CO4 Apply the dynamic linear data structure
CO5 Describe non-linear data structure
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
6. CO-PO, CO- PSO MAPPING TABLE: Computer Engineering

Course and Course

Programme Outcomes Programme
Code Outcomes
Specific
Outcomes
PO1 PO2 PO3 PO4 PO5 PO6 PO7 PSO1 PSO2
CO1 3 2 2 1 - - 2 3 -

CO2 3 2 2 2 - - 2 3 -

CO3 2 1 2 1 - - 2 3 -
Data Structure
(DST238914) CO4 2 1 2 1 - - 2 3 -

CO5 1 - 1 1 - - 2 3 -

CO Avg. 2.2 1.5 1.8 1.2 - - 2 3 -

CO-PO, CO- PSO MAPPING TABLE: Information Technology

Course and Course

Programme Outcomes Programme
Code Outcomes
Specific
Outcomes
PO1 PO2 PO3 PO4 PO5 PO6 PO7 PSO1 PSO2
CO1 3 2 2 1 - - 2 3 -

CO2 3 2 2 2 - - 2 3 -

CO3 2 1 2 1 - - 2 3 -
Data Structure
(DST228914) CO4 2 1 2 1 - - 2 3 -

CO5 1 - 1 1 - - 2 3 -

CO Avg. 2.2 1.5 1.8 1.2 - - 2 3 -

 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
7. COURSE CONTENTS
UNIT Topics/Sub-Topics
NO.
Introduction to data structure
1.1 Linear & Non linear
1.2 Algorithm Basic Concepts
I 1.3 Introduction to Time and Space complexity of algorithms, Big O Notation and
theta notations
1.4 Definition, implementation and notation of Array- Numerical and character
1.5 Basic operation such as addition, deletion , String operations
Sorting and Searching
2.1 Sorting Techniques
2.1.1 Selection sort
2.1.2 Bubble sort
2.1.3 Insertion sort
II
2.1.4 Quick sort
2.1.5 Heap Sort
2.2 Searching
2.2.1 Linear search
2.2.2 Binary searching
Static Linear Data Structure: Stacks and Queues
3.1 Introduction to Stacks
3.2 Stacks as an Abstract Data Type
3.3 Primitive operations of stacks
3.4 Representation of Stacks through Arrays
3.5 Application of Stack
3.6 Stack and Recursion
III 3.7 Introduction to Queues
3.8 Queue as an abstract data type
3.9 Representation of a Queue as an array
3.10 Types of Queue
3.10.1 Circular Queue
3.10.2 Double Ended Queue
3.10.3 Priority Queue
3.11 Applications of Queue
Dynamic Linear Data Structure: Linked List
4.1 Terminologies
4.1.1 Node
4.1.2 Address, Pointer
4.1.3 Information
4.1.4 Next, NULL Pointer
4.1.5 Empty list
IV
4.2 Representation of Linked list in memory
4.3 Operations on a singly linked list (only algorithm)
4.3.1 Traversing a singly linked list
4.3.2 Searching a linked list
4.3.3 Inserting a new node in a linked list
4.3.4 Deleting a node from a linked list
4.3.5 Header Linked list
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
4.4 Doubly linked list – Introduction, memory representation
Non-Linear Data Structure
5.1 Trees Terminologies: Tree, Degree of a node, Degree of a tree, level of a node,
leaf node, Depth / Height of a tree, In-degree & Out-Degree, Directed edge, Path
Ancestor & descendant nodes
5.2 Storage representation of binary tree
5.3 Type of Trees
5.3.1 General tree
5.3.2 Binary tree
5.3.3 Binary search tree (BST): Searching, Inserting, Deleting
5.4 Binary Tree Traversal Methods
V
5.4.1 In order traversal
5.4.2 Preorder traversal
5.4.3 Post order traversal
5.5 Height Balanced, Weight Balanced Trees
5.6 Graphs Terminologies: graph, node (Vertices), arcs (edge), directed graph, in-
degree, out-degree, adjacent, successor, predecessor, relation, weight, path, length
5.7 Representations of a graph
5.7.1 Sequential Representation (Adjacency Matrix, Path Matrix)
5.7.2 Linked Representation
5.8 Graph Traversal: BFS, DFS

8. LIST OF PRACTICALS/ASSIGNMENTS/ TUTORIALS/DRAWINGS

Term Work consists of Journal containing minimum no of 10 Experiments

Sr. Title of Experiment/Assignment/Exercise/Tutorial/Drawings Approx. Hrs CO

No. required
1 A program for inserting and deleting an element in an array. 2 CO1
2 A program for Linear Search 2 CO2
3 A program for Binary Search 2 CO2
4 A program for selection sort. 2 CO2
5 A program for quick sort. 2 CO2
6 A program for Insertion Sort 4 CO2
7 A program for pushing and popping an element into a STACK 2 CO3
8 A program for inserting and deleting an element in a circular CO3
2
queue.
9 A program for converting an infix expression to postfix using CO3
2
STACK
10 A program for creating and traversing a linked list. 4 CO4
11 A program for various operations on a linked list 2 CO4
12 A program to perform traversing of a binary tree. 4 CO5
TOTAL 30
9. IMPLEMENTATION STRATEGY (PLANNING)
1. Teaching Plan/Tutorials
2. Minimum 10 no. of practical/assignments etc.
3. Slides
4. Self-Learning Online Resources
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT

10. SUGGESTED LEARNING RESOURCES

Sr. Title Of Book Author Publication
No.
1 Data Structures with C Lipschutz Schaum’s series
2 Algorithms in C Robert Sedgewick Addison-Wesley
3 Data structures using C Reema Thareja Professional
Oxford Publication

11 LEARNING WEBSITE & PORTALS

1. www.csbdu.in/econtent/datastructures
2. www.nptel.iitm.ac.in/courses.php
3. www.gatesit.org/gitdownloads/c&ds.pdf
4. www.opendatastructure.org/ods-cpp.pdf
12. ASSESMENT METHODOLOGIES/TOOLS
Formative Assessment (Assessment for Learning)
1. Rubrics for Cos Assignment
2. Term work
Summative Assessment (Assessment of Learning)
1. End Term Exam

13. SUGGESTED WEIGHTAGE FOR LEARNING EFFORTS & ASSESMENT PURPOSE

(Specification Table)
Aligned Teaching Distribution of Theory
COs Hours Marks
Unit No. Unit Title
R U A Total
Level Level Level Marks
Introduction to data
I structure and CO1 08 4 6 - 10
classification
Sorting and Searching
II CO2 10 - 6 8 14

Static Linear Data

III CO3 16 4 6 8 18
Structure
Dynamic Linear Data
IV CO4 10 4 4 8 16
Structure
Non Linear Data
V CO5 16 4 4 4 12
Structure
GRAND TOTAL 60 16 26 28 70

R Remember, U Understand, A Apply and above, (Bloom’s revised taxonomy levels)

NOTE: This specification table provides general guidelines to assist students for their learning and to
teachers to teach and assess students with respect to attainment of COs. The actual distribution of marks
at different taxonomy levels (R, U, A) in the question paper may vary from above table.
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
14. COURSE EXPERT COMMITTEE MEMBERS

Sr.
NAME
No.

1
Internal Mrs. Radhika Patwardhan
2
Internal Ms. Neha More
3 Mr. Prasad Wadkar
External
Organization: Sr. Consultant, Infosys, Mumbai
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
1. COURSE DETAILS
Programme: CSE/IT Semester: III/III
Course: Database Management System Course Category: DSC
Course Code: DBS238915 Duration:16 Weeks

2. LEARNING AND ASSESSMENT SCHEME

Learning Scheme Assessment Scheme

Actual Self-Learning
Based on LL & TL Based on
Contact Hrs./Week (SL^) (Term Theory (Marks) Self
Credits Paper
Work + Learning
Duration Total Marks
Assignment) Practical (Marks)
(Hrs.)
CL TL LL (Hrs)
FA- SA- FA- SA- SA- SLA
Total
TH TH PR PR OR (Marks)
04 - 02 - 03 03 30 70 100 25 25 - - 150

Total IKS Hrs for the course :00

3. COURSE OBJECTIVE
This subject will enable the students to comprehend the Database concepts at both practical
and theoretical levels. The aim of this subject is to understand the use of Structured Query
Language (SQL) and learn SQL syntax. The students will understand the needs of database
processing and learn techniques for controlling the consequences of concurrent data access.

4. SKILL COMPETENCY

 Perform data modelling using ER diagram

 Apply database management concept using SQL to manipulate the data in database
and to query the database.

5. COURSE OUTCOMES (COs): At the end of the semester student will be able to: -
CO No. COURSE OUTCOME
CO1 Describe core concepts of database models
CO2 Create and manage data tables using SQL commands.
CO3 Understand the architecture of NoSQL and distinguish the different types of NoSQL
database
CO4 Apply concepts of normalization to relational database design
CO5 Conceptualize query processing and transaction management
CO6 Explain the importance of concurrency and recovery in database management system
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
6. CO-PO, CO- PSO MAPPING TABLE – Information Technology

Programme
Course and Course Programme Outcomes Specific
Code Outcomes Outcomes

PO1 PO2 PO3 PO4 PO5 PO6 PO7 PSO1 PSO2

CO1 3 - 1 - - - 1 3 -

CO2 3 2 2 2 - - 2 3 -

CO3 2 2 1 - - - - 3 -
Database
Management
CO4 2 3 2 - - - 2 3 -
System
(DBS238915)
CO5 2 2 - - - - 1 3 -

CO6 2 - - - - - 1 3 -

CO Avg. 2.33 2.25 1.5 2 - - 1.4 3 -

CO-PO, CO- PSO MAPPING TABLE – Computer Engineering

Programme
Course and Course Programme Outcomes Specific
Code Outcomes Outcomes

PO1 PO2 PO3 PO4 PO5 PO6 PO7 PSO1 PSO2

CO1 3 - 1 - - - 1 3 -

CO2 3 2 2 2 - - 2 3 -

CO3 2 2 1 - - - - 3 -
Database
Management
CO4 2 3 2 - - - 2 3 -
System
(DBS238915)
CO5 2 2 - - - - 1 3 -

CO6 2 - - - - - 1 3 -

CO Avg. 2.33 2.25 1.5 2 - - 1.4 3 -

 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
7. COURSE CONTENTS
UNIT NO. TOPIC/Sub-topic
Introduction to DBMS
1.1 Introduction to database management system:
1.1.1 Concept of data, database and DBMS
1.1.2 Advantages of DBMS over file processing,
1.1.3 Data abstraction, data independence
I 1.2 Data Models:
1.2.1 Entity Relationship model,
1.2.2 Relational Model,
1.2.3 Network Model
1.2.4 Hierarchical Model
1.3 Database Users and Administrators
1.4. Database system structure

Overview of SQL
2.1. SQL Data Definition
2.1.1 Basics structure of SQL queries (DDL, DML, DCL, TCL)
2.1.2 Additional Basic Operations
2.1.3 Modification of the database (Update, Delete, Alter Drop)
II 2.2 Integrity constraints –
key constraints, Domain Constraints, Referential integrity, check constraints
2.3 SQL Clauses – group by clause, Having clause, order by clause
2.4 Set Operations and Aggregate functions
2.5 Date, Time and String Functions
2.6 Sub Queries and Views
2.7 JOINS
2.7.1 INNER JOIN
2.7.2 OUTER JOIN: left, right and outer join
2.8 Introduction to PL/SQL

NoSQL Databases
3.1 Overview of NoSQL
3.1.1 Features of NoSQL
3.1.2 Advantages and disadvantages of NoSQL
III 3.1.3 Difference between RDBMS and NoSQL databases
3.1.4 Types of NoSQL
3.2 MongoDB:
3.2.1 Key features,
3.2.2 MongoDB Query Language: Data type,
create database Collections and Documents, Updating and querying
database, Querying through Indexes,
3.3 Cassandra: Overview,
3.3.1 CQL: Shell commands,
3.3.2 Cassandra Data types
3.3.3 CRUD operations
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
Relational Database Design
4.1. Relational database design:
4.1.1 Functional Dependencies
4.1.2 Armstrong’s Axioms in DBMS
IV 4.1.2 Features of good relational database design
4.2 Decomposition: properties of decomposition
4.3 Normalization
4.3.1 Types of anomalies in database
4.3.2 First Normal Form, Second Normal Form, Third Normal Form and 3.5
Normal Form
Query Processor and Optimizer, Transactions
5.1. Overview of query processing.
5.1.1 Relational algebra operations: Select, project, Union, Set difference,
Cartesian product, rename
5.2 Query optimization: Cost of query
5.3 Transaction:
V 5.3.1 Concept of transaction,
5.3.2 Transaction Model
5.3.3 ACID Properties of transaction
5.4 Serializability
5.4.1 Conflict Serializability
5.4.2 View Serializability
5.4.3 Recoverability of schedules

Concurrency Control and Recovery system

6.1. Lock-based protocols
6.1.1 Shared lock and exclusive lock
6.1.2 Compatibility function
6.1.3 Starvation
6.2 Deadlock Handling
VI 6.3 Two-Phase locking protocol: Growing and Shrinking Phase
6.4 Timestamp-Based protocols
6.5 Validation-Based protocols
6.6 Recovery System
6.6.1 Failure classification
6.6.2 Storage structure
6.6.3 Log-Based recovery shadow paging and checkpoints

8. LIST OF PRACTICALS/ASSIGNMENTS/ TUTORIALS/DRAWINGS

Term Work consists of Journal containing minimum no of –10 Experiments/assignments/drawings.

Sr. No. Title of Experiment/Assignment/Exercise/Tutorial/Drawings Approx. Hrs CO

required
1. Design an ER model for statement of problem 2 CO1
2. Creation of table with constraints and insertion of data 4 CO2
3. Running simple SQL queries 4 CO2
4. Execution of Alter, Update, Delete and drop 2 CO2
5. Implementation of aggregate and character functions 2 CO2
6. Implementation of various clauses (Where, Group by and 2 CO2
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
Having) in SQL.
7. Execution of string, comparison and set operations 2 CO2
8. Implementation of various types of joins 2 CO2
9. Implementation of views. 2 CO2
10. Perform CRUD operations in MongoDB 2 CO3
11. Assignment 1: Normalization of a sample database – Show 2 CO4
decomposition from 1NF,2NF and 3NF
12. Using case study of a banking system – apply the concept of 2 CO5
transaction processing and recovery to the system
13. Assignment 2: Concurrency control 2 CO6
Total 30

9. IMPLEMENTATION STRATEGY (PLANNING)

1. Teaching Plan
2. Minimum no of practical/assignments.
3. Guest/Expert lectures
4. Demonstrations
5. Slides
6. Self-Learning Online Resources

10. SUGGESTED LEARNING RESOURCES

Sr. Title Of Book Author Publication

No.
1. Database System Concepts Silberschatz, Korth McGraw hill, Sixth Edition

2. Introduction to Database Mark L. Gillenson Wiley, India

Management Paulraj Ponniah
3. Database Management Systems Ramakrishnan, Gehrke McGraw hill, Third
Edition
4. NoSQL Distilled: A Brief Guide Pramod J. Sadalage, Addison-Wesley Professional
to the Emerging World of Martin Fowler
Polyglot Persistence

11. LEARNING WEBSITE & PORTALS

1. www.w3schools.com/sql
2. www.tutorialpoint.com/dbms
3. www.khanacademy.org/computing/computer-programming/sql
4. www.techonthenet.com/sql
5. www.beginnersbook.com

12. ASSESMENT METHODOLOGIES/TOOLS

Formative Assessment (Assessment for Learning)
1. Test
2. Rubrics for COs Assignment
3. Term Work
4. Seminar/Presentation
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
Summative Assessment (Assessment of Learning)
1. End Term Exam

13. SUGGESTED SPECIFICATION TABLE FOR QUESTION PAPER DESIGN

Aligned Learning Distribution of Theory Marks
Unit No. Unit Title COs Hours R Level U Level A Level Total
Marks

Introduction to DBMS CO1 08 2 4 6 12

I

Overview of SQL CO2 12 2 4 6 12

II

NoSQL Databases CO3 10 4 4 4 12

III

Relational Database CO4 10 2 4 4 10

IV Design

Query Processor and CO5 10 4 8 - 12

V Optimizer,
Transactions

Concurrency Control CO6 10 6 6 - 12

VI and Recovery system
GRAND TOTAL 60 20 30 20 70
R Remember, U Understand, A Apply and above, (Bloom’s revised taxonomy levels)
NOTE: This specification table provides general guidelines to assist students for their learning and to
teachers to teach and assess students with respect to attainment of COs. The actual distribution of marks
at different taxonomy levels (R, U, A) in the question paper may vary from above table.

14. COURSE EXPERT COMMITTEE MEMBERS

Sr.
No. NAME

1 Internal Mr. Pankaj Rathod

2 Internal Mr. Siddhesh Masurkar
Dr. Chetashri Bhadane
3 External
Organization: Assistant Professor, D. J. Sanghvi College of engineering
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
1. COURSE DETAILS
Programme: Information Technology Semester: III

Course: Data Analytics & Visualization Course Category: SEC

Course Code: DTA230904 Duration:16 Weeks

2. LEARNING AND ASSESSMENT SCHEME

Learning Scheme Assessment Scheme

Actual Self-Learning
Based on LL & TL Based on
Contact Hrs./Week (SL^) (Term Theory (Marks) Self
Credits Paper
Work + Learning Total
Duration
Assignment) Practical (Marks) Marks
(Hrs.)
CL TL LL (Hrs)
FA- SA- FA- SA- SA- SLA
Total
TH TH PR PR OR (Marks)
- - 4 - 2 - - - - 25 25 - - 50

3. COURSE OBJECTIVE
Data analytics uses a range of computational and statistical techniques to extract meaningful
information from raw data sets. These techniques transform, organize, and model the data to
draw conclusions and identify patterns of activity that enable organizations to make more-
informed business and policy decisions. In this course, students will learn the fundamental
concepts of data analytics and data visualization tools that enable them to present large
volumes of data in a graphical format to identify underlining patterns.

4. SKILL COMPETENCY

 Analyze statistical data to get meaningful inference

 Identify underlying patterns existing in the data
 Provide viable solutions to decision making problems

5. COURSE OUTCOMES (COs): At the end of the semester student will be able to:
CO No. COURSE OUTCOME
CO1 Recognize business value and various tools and techniques for data analytics &
visualization, and their applications
CO2 Use tools to collect, clean and transform the data.

CO3 Apply data analytics and visualization tools and techniques to derive useful insights
from raw data
CO4 Design data analytics and visualization solutions to support business goals, the
environment and society
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
6. CO-PO, CO- PSO MAPPING TABLE

Course and Course Programme Outcomes Programme

Code Outcomes Specific
Outcomes
PO1 PO2 PO3 PO4 PO5 PO6 PO7 PSO1 PSO2
2 1 1 1 1 1 1 3 2
CO1

3 2 2 2 2 3 2 3 2
CO2

Data CO3
3 2 2 2 3 3 2 3 2
Analytics &
Visualization 3 3 3 3 3 3 2 3 2
(DTA230904) CO4

2.75 2 2 2 2.25 2.5 1.75 3 2

CO Avg.

7. LIST OF TUTORIALS

Term Work Consists of Journal containing minimum no of –12 Experiments

Sr. No. Title of Experiment/Assignment/Exercise/Tutorial/Drawings Approx. CO

Hrs
required
1 To conduct survey of various tools and techniques for data 2 CO1
analytics & data visualization
2 To clean data using MS Excel through Text Functions, Date and 4 CO2
Time Values.
3 To practice essential data analytics functions of MS Excel. 4 CO3
4 To perform Data analytics using Look up, pivot tables and What- 6 CO3
if analysis in MS Excel.
5 To import, clean and transform raw data using R. 2 CO2
6 To perform data manipulation using dplyr library of R. 4 CO3
7 To perform data visualization with ggplot2. 4 CO3
8 To perform data analytics using aggregate functions in SQL 2 CO2
9 To filter data by applying Joins in SQL. 4 CO2
10 To perform data transformation in Tableau. 6 CO2
11 To perform data Analytics by applying various filters in Tableau. 6 CO2
12 To visualize data by creating Bar Chart, Line Chart, Pie Chart, 6 CO3
Histogram, Crosstab, Box Plot, Bubble Chart, etc. in Tableau.
13 To design a dashboard using Tableau. 4 CO4
14 To analyze and visualize data using Power BI. 4 CO3
15 To generate and publish dashboards and reports using Power BI. 2 CO4
TOTAL 60
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
8. IMPLEMENTATION STRATEGY (PLANNING)

1. Lab Plan
2. Minimum no of practical/assignments
3. Guest/Expert lectures
4. Slides
5. Industry Visit
6. Self-Learning Online Resources

9. SUGGESTED LEARNING RESOURCES

Sr.No. Title of Book Author Publication
Data Analysis with Excel Manisha Nigam BPB
1

SQL for Data Analytics Upom Malik , Matt Packt

2 Goldwasser,
Benjamin Johnston
3 Data Analysis with R Anthony Fischetti Packt
Visual Analytics with Tableau Alexander Loth, Wiley
4 Nate Vogel, Sophie
Sparkes
5 Microsoft Power BI Cookbook Brett Powell Packt

10. WEB REFERENCES

1. https://www.simplilearn.com/tutorials/excel-tutorial/data-analysis-excel
2. https://careerfoundry.com/en/blog/data-analytics/advanced-sql/
3. https://www.analyticsvidhya.com/blog/2016/02/complete-tutorial-learn-data-science-scratch/
4. https://www.geeksforgeeks.org/tableau-tutorial/
5. https://intellipaat.com/blog/tutorial/tableau-tutorial/
6. https://www.geeksforgeeks.org/power-bi-tutorial/?ref=lbp

11. ASSESMENT METHODOLOGIES/TOOLS

Formative Assessment (Assessment for Learning)
1. Rubrics for COs Assignment
2. Term Work
3. Micro Project
4. Self-Learning

12. COURSE EXPERT COMMITTEE MEMBERS

Sr.
NAME
No.
1 Internal Mr. Abhijit Dongaonkar
Internal Mr. Manishkumar Solanki
2
Akash Shah
3 External
Infra Transform Specialist, Accenture Pvt. Ltd, Mumbai
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
1. COURSE DETAILS

Programme: Information Technology Semester: III

Course: Software Engineering Course Category: DSC
Course Code: SWE230905 Duration:16 Weeks

2. LEARNING AND ASSESSMENT SCHEME

Learning Scheme Assessment Scheme

Actual Self-Learning
Based on LL & TL Based on
Contact Hrs./Week (SL^) (Term Theory (Marks) Self
Credits Paper
Work + Learning Total
Duration
Assignment) Practical (Marks) Marks
(Hrs.)
CL TL LL (Hrs)
FA- SA- FA- SA- SA- SLA
Total
TH TH PR PR OR (Marks)
04 - 02 - 03 03 30 70 100 25 - 25 - 150

Total IKS Hrs for the course: 00

3. COURSE OBJECTIVE

This course will help the students to understand the essentials of software development. The
subject will also familiarize the students in details of software quality control and assurance.

4. SKILL COMPETENCY/INDUSTRY/EMPLOYER EXPECTED OUTCOME

 Aid students to distinguish the software development paradigms

 Fortified to deal with analysis and design of the system
 Understand and apply software testing techniques
 Estimate software quality

5. COURSE OUTCOMES (COs): At the end of the semester student will be able to: -

CO No. COURSE OUTCOME

CO1 Describe software development paradigms
CO2 Analyze and design the system
CO3 Implement the system using programming standards
CO4 Classify the types of testing techniques
CO5 Prepare software quality assurance plan
CO6 Implement the system using agile software development methodology
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
6. CO-PO, CO- PSO MAPPING TABLE:

Course and Course Programme Outcomes Programme

Code Outcomes Specific
Outcomes
PO1 PO2 PO3 PO4 PO5 PO6 PO7 PSO1 PSO2
3 1 1 1 1 1 1 3 2
CO1
3 3 3 2 1 2 2 3 2
CO2
3 2 3 2 1 2 2 3 2
CO3
Software
3 1 1 1 1 2 2 3 2
Engineering CO4
(SWE230905)
CO5 3 1 1 1 1 2 1 3 2

CO6 3 2 2 2 1 2 2 3 2

3 1.67 1.83 1.5 1 1.83 1.67 3 2

CO Avg.

7. COURSE CONTENTS
UNIT NO. TOPIC/Sub-topic
Software Engineering Fundamentals
1.1 Definition of software, Software engineering
1.2 Software Development Life Cycle (SDLC) process & Phases
I 1.3 Software development paradigms – Waterfall, Prototype, Incremental, Spiral
1.4 Strengths and weaknesses of traditional software development models
1.5 Overview of Agile methodology, comparison of software models
System Analysis and Design
2.1 Preliminary Survey, Feasibility study
2.2 Structuring information – Abstraction, Partitioning, Projection
2.3 SRS – characteristics, structure, case study
2.4 Formal specification methods – Structured English, Regular Expression, Decision table
2.5 Flow based, Data based, Object based Analysis
II 2.6 Role of System Analyst
2.7 Process, Data and Object Oriented Design
2.8 Coupling and Cohesion
2.9 Design Metrics
2.10 System design and detailed design
2.11 Data Flow Diagram, Structure chart
2.12 Importance of Documentation in SDLC process
Coding and Reengineering
3.1 Choice of Programming Languages
3.2 Coding Standard and guidelines
III
3.3 Mixed language programming
3.4 Cyclomatic Complexity
3.5 Reengineering Legacy System
3.6 Reverse Engineering
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
3.7 LOC, FP, Empirical Estimation Models COCOMO-I, COCOMO-II, Specialized
Estimation Techniques
Software Testing
4.1 Software Testing Fundamentals
4.2 Testing Principles and Objectives
4.3 Types of Software Testing
IV 4.4 Unit Testing
4.5 Integration Testing
4.6 Regression Testing
4.7 Black Box and White Box Testing
4.8 Validation testing – Alpha and Beta Testing
Software Quality Assurance
5.1 Reliability Analysis
5.2 Reliability Metrics
5.3 Software Quality, Quality Control, Quality Assurance
5.4 Project Scheduling – Basic principle, Work break down structure, Activity network &
V
critical path method
5.5 Scheduling technique – CRM, PERT
5.6 SQA – Importance, SQA Activities – Phases of SQA
5.7 Quality evaluation standards – Six sigma, ISO for software, SEICMM- levels, KPA of
Software Organization
Agile Software Development
6.1 Agility Principals and development method
6.2 Agile Process Models: Extreme Programming (XP), Adaptive Software Development
VI (ASD), Dynamic Systems Development Method (DSDM)
6.3 Scrum, Crystal, Feature Driven Development (FDD)
6.4 Agile Modelling (AM), Micro services
6.5 Kanban Model

8. LIST OF PRACTICALS/ASSIGNMENTS/ TUTORIALS/DRAWINGS

Term Work consists of Journal containing minimum no of –10 Experiments/assignments/drawings.
Sr. Title of Experiment Approx.Hrs CO
No. required
1 Define problem statement for the selected project & write activities
02 CO1
for the project with relevant software development model(s)
2 To Prepare SRS for the selected project 04 CO2
3 To Construct DFD, Structure chart & Decision table for the
04 CO2
selected project
4 To develop timeline chart/ Gantt chart/ PERT for tracking the
progress of the project 02 CO2

5 To implement the modules of the selected project 04 CO3

6 Estimate cost of the project using Constructive Cost Model
02 CO3
(COCOMO) approach for the selected project
7 To write test cases to validate requirements of project from SRS
02 CO4
document
8 To generate bug report using bug tracking tool 02 CO4
9 To prepare SQA plan that facilitates attributes of quality of process
02 CO5
and product
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
10 To design and develop a Product Management system using
03 CO6
SCRUM tool
11 To design and develop a Product Management system using JIRA
03 CO6
tool
TOTAL 30

9. IMPLEMENTATION STRATEGY (PLANNING)

1. Teaching Plan
2. Minimum no of practical/assignments
3. Guest/Expert lectures
4. Slides
5. Self-Learning Online Resources

11. SUGGESTED LEARNING RESOURCES

Sr.No. Title of Book Author Publication
1 Software Engineering : A Pressman Roger Tata McGraw Hill
Practitioners Approach
2 An Integrated approach to Jalota Pankaj Narosa Publication
Software engineering
3 Fundamentals of Software Rajib Mall PHI publication
Engineering

12. LEARNING WEBSITE & PORTALS

1. http:// www.idc-online.com/resources/technical-references/information-technology-
technical-references.html
2. http:// www.minigranth.com/software-engineering-tutorial/case-tools/
3. http:// examupdates.in/software-engineering-notes/
4. http:// www.onlinetutorials.com
5. http:// www.rspa.com

13. ASSESMENT METHODOLOGIES/TOOLS

Formative Assessment (Assessment for Learning)

1. Test
2. Rubrics for COs Assignment
3. Self-Learning
4. Term Work
5. Seminar/Presentation
Summative Assessment (Assessment of Learning)
1. End Term Exam
2. Assignment
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
14. SUGGESTED WEIGHTAGE FOR LEARNING EFFORTS & ASSESMENT PURPOSE
(Specification Table)

Aligned Learning Distribution of Theory Marks

Unit
Unit Title COs Hours R U A Total
No.
Level Level Level Marks

Software Engineering CO1

I 12 05 05 -- 10
Fundamentals
II System Analysis and CO2 10 04 04 04 12
Design
III Coding and CO3 08 06 04 02 12
Reengineering
IV CO4 08 04 04 04 12
Software Testing
V Software Quality CO5 10 06 04 02 12
Assurance
Agile Software CO6
VI 12 04 04 04 12
Development
GRAND TOTAL 60 29 25 16 70
R Remember, U Understand, A Apply and above, (Bloom’s revised taxonomy levels)
NOTE: This specification table provides general guidelines to assist students for their learning and to
teachers to teach and assess students with respect to attainment of COs. The actual distribution of marks
at different taxonomy levels (R, U, A) in the question paper may vary from above table.

15. COURSE EXPERT COMMITTEE MEMBERS

Sr.
No. NAME

Internal Mrs. Krishna Bhatt

1
Internal Mrs. Abhilasha More
2
Mr. Manish Salvi
3 External Organization: Senior Lecturer, Computer Engineering Department, Thakur
Polytechnic, Kandivali(E).
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
1. COURSE DETAILS
Programme: Information Technology Semester: III

Course: Game Development in AR/VR Course Category: SEC

Course Code: AVR230906 Duration:16 Weeks

2. LEARNING AND ASSESMENT SCHEME

Learning Scheme Assessment Scheme

Actual Self-Learning
Based on LL & TL Based on
Contact Hrs./Week (SL^) (Term Theory (Marks) Self
Credits Paper
Work + Learning Total
Duration
Assignment) Practical (Marks) Marks
(Hrs.)
CL TL LL (Hrs)
FA- SA- FA- SA- SA- SLA
Total
TH TH PR PR OR (Marks)
- - 04 02 03 - - - - 25 - - 25 50

Total IKS Hrs for the course :00

3. COURSE OBJECTIVE
This subject will enable the students to comprehend the Game design and development concepts at
practical level. It introduces the basic game coding patterns and basics of physics engine. The aim
of this subject is to get broad perspective of game development engines and AR/VR.

4. SKILL COMPETENCY:
 Create workflow for creating 2D video games and understand different types/genres
of video games and the components.
 Apply usage of subcomponents of game engines such as graphics, physics and audio
engines
 Write scripts which control the behavior of different game components.
 Implement Augmented reality and Virtual Reality.

5. COURSE OUTCOMES (COs): At the end of the semester student will be able to: -

CO No. COURSE OUTCOME

CO1 Familiarize with the workflow for creating 2D video games and understand different
types/genres of video games and the components
CO2 Create 2D /3D using Physics with Game Engines-Unity.
CO3 Use subcomponents of game engines such as graphics, audio engines and create game
assets such as sprites, tiles, textures
CO4 Write scripts which control the behaviour of different game components
CO5 Implement Augmented Reality and Virtual Reality.
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
6. CO-PO, CO- PSO MAPPING TABLE – Information Technology

Course and Course Programme Outcomes Programme

Code Outcomes Specific
Outcomes
PO1 PO2 PO3 PO4 PO5 PO6 PO7 PSO1 PSO2
CO1 3 1 3 3 2 1 2 2 2

CO2 3 1 3 3 2 1 3 2 2

CO3 3 2 3 3 2 2 3 2 2
Game
Development
in AR/VR CO4 3 2 3 3 2 2 3 2 2
AVR230906

CO5 3 1 3 3 2 2 3 2 2

CO Avg. 3 1.4 3 3 2 1.4 2.8 2 2

7. COURSE CONTENTS
UNIT NO. TOPIC/Sub-topic
Introduction to Unity
1.1 Game Engines
1.2 Development Tools
1.3 Introducing Unity, Installation of Unity Software, Unity Development
Environment
1.4 IDE Basics
I
1.5 Unity Concepts
1.5.1 Images, Buttons, Toggles, Sliders, Dropdowns, Input Fields
1.5.2 Simple Movement and Input
1.5.3 Simple Rotation and Scaling
1.5.4 Easy Input Handling in Unity

2D Physics Concepts
2.1 Rigid Body Components
2.1.1 Static
2.1.2 Dynamic
2.1.3 Kinematic
2.2 Physics Materials
II 2.3 Colliders
2.4 Joints
2.4.1 Distance Joint
2.4.2 Hinge Joint Wreaking Ball
2.4.3 Spring Joint Platform
2.5 Effectors
2.5.1 Area Effectors
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
Subcomponents of game engines
3.1 Game Design Strategies
3.1.1 Game Requirements
3.1.2 Game Mechanics
3.1.3 Story telling & Progression
III
3.2 Graphics Concepts
3.2.1 Assets: Sprites, Tiles & Textures
3.2.2 Importing images, Texture images
3.2.3 Building 2D & 3D Scenery
3.3 Animation
3.3.1 Timing & Spacing

Introduction to Scripting
4.1 C# script basic fundamentals
4.1.1 Data Types & Variables, Enums
4.1.2 Conditional Switch…Case statements
4.1.3 Functions: Defining a Function, parameters and return types, Update
and Event Functions
4.1.4 Loops: for each, while & do while
4.1.5 Arrays
4.2 C#
3.3.2 Object Oriented Concepts
States
IV 4.2.1 Defining Class & Objects
3.3.3 Parameters & Transitions
4.2.2 Constructors & methods
4.2.3and
3.3.4 Turning Creating & the
Jumping managing Game objects
Character
4.2.4 Controlling object lifespans
3.4 Audio
4.2.5 Generating & Handling Exceptions
4.3
3.4.1Creating useful C# Scripts
Sound Effects
4.3.1 Creating Camera Shake
4.3.2 Zooming in & out
4.3.3 Rotating objects with mouse
4.3.4 Detecting button clicks & calling functions
4.3.5 Creating backgrounds & other effects
Augmented Reality and Virtual Reality
5.1 Augmented Reality
5.1.1 AR Basics & Terminologies
5.1.2 Creating Image Target, adding images to the database
5.1.3 Importing 3D models in Unity, Mapping an image to 3D model
5.1.4 Creating an AR application
5.1.5 Testing an AR application
5.2 Virtual Reality Fundamentals
V
5.2.1 VR Basics & Terminologies
5.2.2 Creating an Environment in Unity I.e. Maze
5.2.3 Setting configurations i.e. shadow, weight, etc.
5.2.4 Doing VR settings
5.2.5 Creating a VR application
5.2.6 Testing a VR application
5.3 Introduction to METAVERSE, Application and use case.
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT

8. LIST OF PRACTICALS/ASSIGNMENTS/ TUTORIALS/DRAWINGS

Term Work consists of Journal containing minimum no of –10 Experiments/assignments/drawings.
Sr. Title of Experiment/Assignment/Exercise/Tutorial/Drawings Approx.Hrs CO
No. required
1. Install Unity, create projects, Import assets ,Package manager 2 CO1
2. 2D Game development with character design, sprites and 4 CO2
movements.
3. Conceptualize the theme & Create the game Idea into a game 4 CO1
concepts
4. Design interaction between the player and the world using the 4 CO3
physics engine
5. Design interaction between the player and the world using the 4 CO4
physics engine
6. Design of menus and user interaction with animation and sound 4 CO3
7. Setting up Vuforia Software Development Kit(SDK) 2 CO5
8. Import the model and the image targets in Unity and mapping 4 CO5
9. Creating a simple AR application in Unity 4 CO3
10. Installing & setting up VR SDK OpenXR/Oculus/Pico) 4 CO5
11. Setting up VR headset and controller for development 4 CO5
12. Creating a simple VR application using Open XR 4 CO5
13. Creating a METAVERSE domain 4 CO5

14. Mapping METAVERSE Object to Actual Domain 4 CO5

15. Mini Project (Game Development) 8 All CO’s

Total 60

9. SUGGESTED MICRO PROJECT/ASSIGNMENT/ACTIVITES FOR SPECIFIC

LEARNING / SKILL DEVELOPMENT (SELF LEARNING)
Assessment to be based on one of the following tools and rubrics for evaluation of SLA to be well
defined by course teacher.
Mini-Project
1. Build A 2D Shooter Game in 1 Hour
2. Design a VR app for measuring room dimensions
3. Create jungle safari
4. Create Your First 3D Model & Import into Unity
5. Create A Candy Catching Game
6. Survival game and terrain building
7. Create Intelligent Enemies
8. Build a METAVERSE Classroom
9. Build a 3D Endless Game
10. Create Snowfall Particle Effect

Quiz
 Quiz on basics of Game engines.
 Quiz on basics of Scripting for game Development.
Assignment
 Convert the units of a given physical quantity from one system of units to another.
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
 Demonstrate the variation of angle of refraction with respect to refractive index using online
tool
 Use a digital Vernier caliper and micrometer screw gauge for measurements. (lab- based).
 Applications of optical fibers in Information technology and Computer engineering etc.
 Solve numerical based on Faraday’s first and second law of electrolysis.
10. IMPLEMENTATION STRATEGY (PLANNING)
1. Teaching Plan
2. Minimum no of practical/assignments.
3. Guest/Expert lectures
4. Demonstrations
5. Slides
6. Self-Learning Online Resources

11. SUGGESTED LEARNING RESOURCES

Sr. Title of Book Author Publication
No.
Paris Buttfield–
1 Unity Game Development Cookbook: addis (Author), Jonathon
O' REILLY
Essentials for Every Game Paperback Manning (Author), Tim
Nugent (Author
2 Unity in Action: Multiplatform game Manning Publications
Joseph Hocking (Author)
development in C# Paperback Company,
The Game Maker's Apprentice: Game
3 Jacob Habgood,Mark
Development for Beginners (Technology Technology In Action
Overmars
in Action)
Unity From Zero to Proficiency
4 (Foundations): A step-by-step guide to Independently
Patrick Felicia
creating your first game: 1 Paperback – Published
Import, 4 February 2019
Paris Buttfield–
5 Unity Game Development Cookbook: addis (Author), Jonathon
O' REILLY
Essentials for Every Game Paperback Manning (Author), Tim
Nugent (Author
6 Unity in Action: Multiplatform game Manning Publications
Joseph Hocking (Author)
development in C# Paperback Company,
Hands-On Unity 2022 Game Development Nicolas Alejandro EXPERT INSIGHTS
7 - Third Edition: Learn to use the latest Borromeo
Unity 2022 features to create your first
video game in the simplest way possible

12. LEARNING WEBSITE & PORTALS

1. https://docs.unity3d.com/Manual/Quickstart3D.html
2. https://www.javatpoint.com/unity-transforms-and-object-parenting
3. https://www.tutorialspoint.com/unity/index.htm
4. https://gamedevacademy.org/best-ar-tutorials/
5. https://xrbootcamp.com/unity-vr-tutorial-for-beginners/
6. https://developer.oculus.com/documentation/unity/unity-tutorial/
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
13. ASSESMENT METHODOLOGIES/TOOLS
Formative Assessment (Assessment for Learning)
1. Rubrics for COs Assignment
2. Self-Learning
3. Term Work

Summative Assessment (Assessment of Learning)

1. Mini-project

14. COURSE EXPERT COMMITTEE MEMBERS

Sr.
NAME
No.

1 Internal Mrs. Swapna Naik

2 Internal Mr. Manish Solanki

Mr. Rutvij Joshi

3 External
Organization: Shifu Games, Mumbai
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
1. COURSE DETAILS
Programme: Information Technology Semester: III
Course: Web Development using PHP Group: DSC
Course Code: PHP230907 Duration:16 Weeks

2. TEACHING AND EXAMINATION SCHEME

Learning Scheme Assessment Scheme

Actual Self-Learning
Based on LL & TL Based on
Contact Hrs./Week (SL^) (Term
Credits Paper Theory (Marks) Self
Work +
Duration Learning Total Marks
Assignment) Practical (Marks)
(Hrs.)
CL TL LL (Hrs)
FA- SA- FA- SA- SA- SLA
Total
TH TH PR PR OR (Marks)
02 - 02 02 03 - - - - 50 50 - 25 125

Total IKS Hrs for the course :00

3. COURSE OBJECTIVE
PHP is an open source, easy to learn, flexible, well documented, wide community supported and
most popular server-side scripting language used to build dynamic websites. It has very simple
database integration with a wide range of drivers. This course intends to teach the students the
concepts of web development with PHP.
4. SKILL COMPETENCY
 Develop dynamic webpages using PHP
 Perform database Connectivity with MySQL

5. COURSE OUTCOMES(COs) At the end of the semester student will be able to: -

CO No. COURSE OUTCOME

CO1 Use fundamentals, conditional statements, loops and functions in a PHP script.
CO2 Implement arrays and string functions in PHP script
CO3 Implement Object Oriented Programming concepts of PHP
CO4 Write dynamic web pages by handling forms with cookies and sessions
CO5 Perform database operations in PHP.
CO6 Build a web application using WordPress and PHP
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
6. CO-PO, CO- PSO MAPPING TABLE: Information Technology

Programme
Programme Outcomes Specific
Course and Course
Outcomes
Code Outcomes
PO1 PO2 PO3 PO4 PO5 PO6 PO7 PSO1 PSO2

CO1 3 2 2 2 1 2 1 3 1
CO2 3 2 3 2 1 2 1 3 1

Web CO3 3 2 3 2 1 2 2 3 2
Development
CO4 3 2 3 2 1 3 2 3 2
using PHP
PHP230907 CO5 3 2 3 2 1 3 2 3 2

CO6 3 2 3 2 1 3 2 3 1

CO Avg. 3 2 2.83 2 1 2.75 1.66 3 1.5

7. COURSE CONTENTS

Unit TOPIC/Sub-Topic
No.
I PHP Basics

1.1 Introduction: History of PHP, PHP Features, role of client and server,
Apache Application Server, PHP Installation with XAMPP and configuring
php.ini, Hello world PHP script
1.2 Fundamentals: Keywords, Identifiers, Variables, Constants Data Types,
Type Conversion, Operators and Expressions, Strings, Comments
1.3 Conditional Statements: if, if...else, nested if, else if ladder, switch…case
1.4 Loops: for, while, do…while
1.5 Functions: Defining a user defined function, passing and returning
parameters, Call by value and Call by reference
II Arrays and Strings

2.1 Arrays: Anatomy of an Array, creating index based and Associative array,
Accessing array Element Looping with Index based array, Looping with
associative array using each () and foreach (), Some useful Library functions
2.2 Strings: Creating and accessing String, Searching & Replacing String,
Formatting String, String Related Library function
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
III Object Oriented Programming Concepts

3.1 Declaring a class and objects, The new keyword, constructor, Destructor,
3.2 Access method and properties using $this variable, Public, private, protected
properties and methods, Static properties and functions, Class constant
3.3 Inheritance & code reusability, Polymorphism, Parent: & self: keyword,
Instance of operator, Abstract method and class, Interface, final keyword
3.4 Introspection, Exception Handling: Error handling, Exception Handling, try-catch-
throw,
3.5 Filters

IV Handling Html Form with PHP

4.1 Form Handling: Accessing Form controls from web page using $_GET,
$_POST, $_REQUEST methods, include, include_once, require,
require_once
4.2 Cookies: Cookies, Start a PHP Cookies, Cookie variables,
4.3 modify Cookie, destroy Cookie
4.4 Session: Introduction to sessions, Start a PHP session, session variables,
modify session, destroy session
4.5 Sending Email through PHP

V Database Connectivity with MySQL

5.1 Working with MySQL Admin: Working with PHP My Admin, Types Data
Type, Creating Database & Tables, Dropping Database & Tables, Adding
Fields
5.2 MySQL Connection: Establishing Connection with MySQL,
Create table and Insert data to the table from PHP application, Retrieve,
Update and delete data from MYSQL table and display it in PHP page
5.3 PHP web Application: Developing a PHP web application, Deploying and
Hosting a PHP Application on a server.

VI WordPress

6.1 Installing WordPress, WordPress dashboard, creating custom pages-posts-categories

and tags, uploading media, template hierarchy, Choosing, Installing and
activating plugins, Themes,
6.2 WordPress hooks: actions and filters
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT
8. LIST OF PRACTICALS/ASSIGNMENTS
Term Work consists of Journal containing minimum 08 no of experiments

Sr. Title of Approx. COs

No. Experiment/Assignment/Exercise/Tutorial/Drawings Hrs
required
1. To Install and Set up XAMPP to run a HelloWorld PHP script 2 CO1
2. To develop user defined functions in PHP 2 CO1
3. To manipulate arrays and strings 2 CO2
4. To implement Inheritance and handle Exceptions in PHP 2 CO3
5. Perform introspection and apply filters. 2
6. To extract form fields from an HTML form using $_GET, $_POST, 2 CO4
$_REQUEST methods.
7. To create, modify and destroy cookies in PHP 2 CO4
8. To manage sessions in PHP 2 CO4
9. To send an Email using PHP script 2 CO4
10. To check login of a user using MySQL database connection. 4 CO5
11. To update MySQL database through Signup/Registration process. 4 CO5
12. To develop a web application and to deploy it on the web server. 2 CO6
(Case Study)
13 To install WordPress and exploring WordPress admin through 2 CO6
creating custom pages, posts, categories, tags and themes.
Total 30

9. SUGGESTED MICRO PROJECT/ASSIGNMENT/ACTIVITES FOR SPECIFIC

LEARNING / SKILL DEVELOPMENT (SELF LEARNING)

Assessment to be based on one of the following tools and rubrics for evaluation of SLA to be
well defined by course teacher.

1. Micro-Project (Web Application)

Use functions, inheritance, database connectivity to develop web application

2. Seminar/ Presentation
To Demonstrate/presentation on Micro Project(website).

10. IMPLEMENTATION STRATEGY (PLANNING)

1. Teaching Plan
2. Minimum no of practical/assignments.
3. Guest/Expert lectures
4. Demonstrations
5. Slides
6. Self-Learning Online Resources
 SHRI VILE PARLE KELAVANI MANDAL’S
SHRI BHAGUBHAI MAFATLAL POLYTECHNIC
INFORMATION TECHNOLOGY DEPARTMENT

11. SUGGESTED LEARNING RESOURCES

Sr. Title Of Book Author Publication

No.
1. The Joy of PHP Alan Forbes Plum Island Publishing
LLC
2. PHP: A Beginners guide Robin Nixon McGraw-Hill Education

3. Learning PHP, MySQL & JavaScript with Richard A. McMohan, Sir O’Reilly
j Query, CSS & HTML
4. Building Web Apps with WordPress Brian Messe Lehner and Jason O’Reilly
Coleman

12. LEARNING WEBSITE & PORTALS

1. https://www.guru99.com/php-tutorials.html
2. https://www.phptpoint.com/php-tutorial/
3. https://www.javatpoint.com/php-tutorial
4. https://www.tutorialspoint.com/php/index.htm

13. ASSESMENT METHODOLOGIES/TOOLS

Formative Assessment (Assessment for Learning)

1. Self-Learning
2. Term Work
3. Seminar/Presentation

14. COURSE EXPERT COMMITTEE MEMBERS

Sr. No. NAME
1. Internal Mrs Abhilasha V More
2. Internal Mrs Krishna V Bhatt
External Mrs Meena Talele
3.
VES Polytechnic