Government Polytechnic Mumbai

(Academically Autonomous Institute, Government of Maharashtra)

Programme Name Diploma In Information Technology
Programme Code IF Academic Year 2024-25
Duration Of Programme 6 Semester Duration 16 WEEKS
Semester Third Scheme P23
Learning Scheme ExaminationScheme(Marks)
Atual contact self Notiona credits pape Theory BASED ON LL & TL Based on Self
Hrs./Week learni l r learning
ng learning Dura PRACTICAL
SR.N CourseTitle Cours course code Total CL TL LL (TW+ /week tion FA-PR SA-PR SLA TOT
O e IKS ASSI FA-TH SA- AL
GNM Total MAR
Type Hrs.f TH
or ENT) KS
sem T1 T2 OR PR
Total MAX MAX MAX MAX MIN MAX MIN MAX MIN MAX MIN MAX MIN
1 Database DSC IT23106
Management 3 4 1 8 4 3 20 20 60 100 40 25 10 _ 50# 20 25 10 200
Systems
2 Software DSC IT23108
3 1 4 2 3 20 20 60 100 40 25 10 125
Engineering
3 Java Programming DSC IT23107
3 4 1 8 4 3 20 20 60 100 40 25 10 _ 50# 20 25 10 200

4 Microcontroller and AEC IT23501

Embeded Systems 3 2 1 6 3 3 20 20 60 100 40 25 10 _ 25@ 10 25 10 175

5 Multimedia SEC IT23604

2 4 2 8 4 50 20 _ 50@ 20 25 10 125
Technology
7 PHP and MYSQL SEC IT23603
4 4 2 _
(Mooc)
8 UHVII VEC UV23302 4 1 1 2 1 _ 50 20 50
Total 0 15 0 14 11 40 20 875
Abbreviations : CL- Classroom Learning , TL- Tutorial Learning, LL-Laboratory Learning, FA - Formative Assessment,SA -Summative Assessment, IKS - Indian Knowledge System, SLA - Self Learning Assessment

Legends : @ Internal Assessment, # External Assessment Note: 1. FA-TH represents two class tests of 20 marks each conducted during the semester.

2. If candidate is not securing minimum passing marks in FA-PR of any course then the candidate shall be declared as "Detained" in that semester.

3. If candidate is not securing minimum passing marks in SLA of any course then the candidate shall be declared as fail and will have to repeat and resubmit SLA work.

4. Notional Learning hours for the semester are (CL+LL+TL+SL)hrs.* 15 Weeks 5. 1 credit is equivalent to 30 Notional hrs. 6. * Self learning hours shall not be reflected in the Time Table.

Course Category : 1. Discipline Specific Course Core (DSC) : 2, Discipline Specific Elective (DSE) : 3. Value Education Course (VEC) : 4., Intern./Apprenti./Project./Community (INP) : 5.

AbilityEnhancement Course (AEC) : 6, Skill Enhancement Course (SEC) : 7. GenericElective (GE)

Coordinator In-Charge Head of Department Principal

Curriculum Development Curriculum Development Cell Department of Information Technology
Department of Information Technology
Government Polytechnic, Mumbai Information Technology

Programme : Diploma in Electronics Engineering (Sandwich Pattern)

Course Code: IT23106 Course Title: Database Management Systems

Compulsory / Optional: Compulsory

Teaching Scheme and Credits Examination Scheme

SA- SA
FA-
CL TL LL SLH NLH Credits FA-TH TH SLA Total
PR PR OR
(3Hrs.)

3 - 4 1 8 4 20 20 60 25 50# - 25 200
Total IKS Hrs. for course:
Abbreviations: CL- Class Room Learning, TL- Tutorial Learning, LL- Laboratory Learning, SLH-
Self Learning Hours, NLH-Notional Learning Hours, FA - Formative Assessment, SA -Summative
assessment, SLA- Self Learning Assessment

Legends: @ Internal Assessment, # External Assessment, *# On Line Examination, @$ Internal

Online Examination

Note:
1. FA-TH represents an average of two class tests of 30 marks each conducted during the term.
2. SA-TH represents the end term examination.
I. Rationale
Database management system creates, stores, manages a large amount of data which can be
used by different software application. In comparison to file processing systems, use of this system
increases efficiency of business operations and reduces overall costs. For Developing and managing
efficient and effective database applications it requires understanding the fundamentals of database
management systems, techniques for the design of databases, and principles of database administration.
The course focuses on the fundamentals of database management systems and the recent developments.
Industry / Employer Expected Outcome
Students should be able to develop application using Database Management System.
II. Course Outcomes: Students will be able to achieve & demonstrate the following COs on
completion of course based learning

CO1 Describe fundamental concepts of database.

CO2 Create, manage Database using SQL commands, Apply different constraints on database
CO3 Develop databases using Entity Relationship modelling approach.
CO4 Apply data normalization and techniques on database
CO5 Maintain transaction processing in Database System.
CO6 Write PL/SQL code for database, create functions and procedures, apply triggers on
database.

Database Management Systems (IT23106) Approved Copy P-23scheme

Government Polytechnic, Mumbai Information Technology

Course Content Details:

Unit
No. Theory Learning Outcomes (TLO's)aligned Topics / Sub-topics
to CO's
Database System Concepts

1.1 An Introduction to Database:

TLO 1.1: Introduce concepts like data, Data, Database, Database
1 database, DBMS, Advantages and Management Systems, advantages
applications of DBMS. of DBMS over file processing
TLO 1.2: Describe Data abstraction, Data system, Applications of DBMS
dictionary, Instance and schema 1.2 Data abstraction, Data
TLO 1.3: Explain Logical and Physical dictionary, Instance and schema,
Independence. 1.3 Data independence-Logical and Physical
TLO 1.4: Explain DBMS architecture. Independence
TLO 1.5: Explain database models. 1.4 Components of a DBMS and overall
structure of a DBMS, Database Users,
functions
of Database Administrator.
1.5 Data Modeling: Relational, Hierarchical,
Network
Course Outcome: CO1 Teaching Hours :6
hrs Marks: 10
Relational Data Model
TLO 2.1: Explain basic concepts of relational
model. 2.1 Basic Concepts of Relational Model-
TLO 2.2: Describe Codd’s 12 rules of RDBMS Domain, Attributes, Tuples and Relations
TLO 2.3: Explain structured Query language2.2 Codd’s rules of RDBMS
with syntax and examples. 2.3 Structured Query Language: Data types in
TLO 2.4: Describe syntax and examples of SQL ,DDL, DML ,TCL,DCL.
clauses in SQL. 2.4 Clauses in SQL: Where, Having, Group by,
2 TLO 2.5: Describe syntax and examples of Order by clauses
functions in SQL 2.5 Functions in SQL: Date functions, Time
functions, String functions, Aggregate
TLO 2.6: Describe concept of nested query.
functions
TLO 2.7: Explain concept of join and its types
2.6 Concept of Nested Query
TLO 2.8: Describe syntax and examples of
2.7 Concept of Join: Equi, Non-equi, outer, self
view.
join
TLO 2.9: Explain key concepts used in SQL
2.8 Views Creating , updating , Dropping
TLO 2.10: Explain integrity constraints with Views.
syntax and examples. 2.9 Key Concepts-Super Key, Candidate Key,
TLO 2.11: Describes fundamental relational Primary Key, Foreign Key.
algebra operations 2.10 Integrity Constraints- constraints on a
TLO 2.12: Describe composition of relational single relation, not null constraint, unique
operations. constraint, check constraint, Primary key
constraint, Foreign Key constraint.

Database Management Systems (IT23106) Approved Copy P-23scheme

Government Polytechnic, Mumbai Information Technology
2.11 Fundamental Relational Algebra
Operations: Select , Project
2.12 Composition of Relational operations:
Union ,Set Difference , Cartesian Product
Rename .
.
Course Outcome: CO2 Teaching Hours :12 hrs
Marks: 14
Database Design Using E-R Model

TLO 3.1: Understand data modeling with 3.2 Data Modeling Using the E-R Model: Entity,
basic concepts of E-R model. Entity Sets-Weak Strong Entity Set,
Relationship sets, Attributes, Types of
TLO 3.2: Understand the concept of attributes, Mapping Cardinalities,
Enhanced ER Model. Shortcomings of ER Model.
3.3 Enhanced ER (EER) model: Subclass, super
3.1 TLO 3.3: Design ER and EER models for class, Specialization and Generalization
3 Bank, library, education, organization,3.4 Case studies: Bank, library, education,
hotel management, hospital organization, hotel management, hospital
management. management.

Course Outcome: CO3 Teaching Hours :5hrs

Marks: 06
Normalization

TLO 4.1: Describe Normalization, Data 4.1 Normalization , Data redundancy and
redundancy and updating anomalies. updating anomalies
4 TLO 4.2: Explain Normalization based on 4.2 Normalization based on Functional
Functional dependencies and Multi-valued dependencies and Multi-valuedDependencies.
Dependencies 4.3 Normal Forms : 1NF, 2NF, 3NF,BCNF
TLO 4.3: Explain 1NF, 2NF, 3NF,BCNF
normal forms. Course Outcome: CO4 Teaching Hours :6 hrs
Marks: 10
Transaction Processing
TLO 5.1: Explain ACID properties and
transaction states. 5.1 Transaction concept: Transaction
TLO 5.2: Explain Concurrent Execution of properties (ACID), Transaction states
Transactions 5.2 Concurrent Execution of Transactions.
TLO 5.3: Describe Serial, Concurrent, 5.3 Schedule: Serial, Concurrent, Cascade less
Cascade less Schedule. Schedule.
5 TLO 5.4: Understand Locks, Granting of locks, 5.4 Lock based protocols- Locks, Granting of
Lock Based Protocol locks, Lock Based Protocol

Course Outcome: CO5 Teaching Hours :

8hrs Marks: 10

Database Management Systems (IT23106) Approved Copy P-23scheme

Government Polytechnic, Mumbai Information Technology
PL/SQL Programming

TLO 6.1: Describe block structure of PL/SQL, 6.1 Introduction of PL/SQL, Advantages of
datatypes, variables and constants in PL/SQL. PL/SQL, The PL/SQL Block Structure,
6 TLO 6.2: Explain control structures in PL/SQL PL/SQL execution environment, PL/SQL
TLO 6.3: Describe Exception Handling in data types, Variables, Constants.
PL/SQL. 6.2 Control Structure: Conditional Control,
TLO 6.4: Explain cursor, types of cursor in Iterative Control, Sequential Control.
PL/SQL 6.3 Exception Handling: Predefined Exception,
TLO 6.5: Describe functions in PL/SQL User Defined Exception.
TLO 6.6: Describe procedures in PL/SQL 6.4 Cursor: Implicit and Explicit Cursors,
TLO 6.7: Explain database triggers syntax, its Declaring, Opening and Closing a Cursor,
types . Fetching a record from Cursor, Cursor for
loops, parameterized Cursor.
6.5 Functions: Advantage, Creating, Executing
and Deleting a Functions.
6.6 Stored Procedures: Advantage, Creating,
Executing and Deleting a Stored
Procedures.
6.7 Database Triggers: Use Of Database
Triggers, How to apply database Triggers,
Types of Triggers, Syntax for creating
Trigger, Deleting Trigger.

Course Outcome: CO6 Teaching Hours :8

hrs Marks: 10

III. Laboratory Learning Outcome and Aligned Practical / Tutorial

Experiences.

Sr Practical / Tutorial / Laboratory Experiment / Number Relevant

No Laboratory Learning Outcome Practical Titles / Tutorial Titles of Cos
(LLO) hrs.
LLO: Able to install any open Install any open source database
1 4 CO1
source database Product Product like My SQL.
LLO: Able to write query to Create Create a New Database And 4 CO2
2 table,Alter the table, RenameTable, Perform Following operations
Drop the table on that Database.a)Create table
b)Alter the table c)Rename Table
d)Drop the table.
LLO: Able to write query to Create Create a New Database And
3 4 CO2
a table, Insert values in that table, Perform Following operations
Update, Delete the contents of the on that Database
table a)Create a table b)Insert values in
that table c)Update the table d)
Delete the contents of the table.

Database Management Systems (IT23106) Approved Copy P-23scheme

Government Polytechnic, Mumbai Information Technology
LLO: Able to write query to create Create a table and apply following
4 4 CO2
table and apply where, having. group clauses on it:Where, Having, Group
by and order by clause on it. by, Order by clauses.
LLO: Able to implement date, time, Implement the following Functions
5 4 CO2
string and aggregate functions in in SQL
SQL a) Date functions b) Time functions
c) String functions d) Aggregate
functions.
6 LLO: Able to write SQL code for Write SQL code for creating of 4 CO2
creating of View, Perform Insert, View Perform Insert
Modify, Delete records through ,Modify, Delete records through
view, Delete the View. view, Delete the View. Working
Able to write Nested -Query with Nested -Query.
LLO: Able to implement all types of Implementation of all types of Joins.
7 4 CO2
join in SQL
.

LLO: Able to implement DCL and Implementation of DCL

8 4 CO2
TCL commands. commands: Grant, Revoke
Implementation of TCL
commands: Commit, Rollback,
Savepoint.
LLO: Able to write query to apply Create table and Apply
9 4 CO1
constraints on the table. constraints such as NOT NULL,
UNIQUE, Check, Default,
Primary key ,Foreign key, on the
table
LLO: Able to write PL/SQL Write a PL/SQL programs using if
10 4 CO6
programs using if then else, for, then else, for, while, nested loop.
while, nested loop.
LLO: Able to write a PL/SQL code Write a PL/SQL code to implement
11 4 CO6
to implement implicit and explicit implicit and explicit cursors.
cursors.
LLO: Able to write a PL/SQL Write a PL/SQL programs based on
12 4 CO6
programs based on Exception Exception Handling (Predefinedand
Handling User-defined Exceptions).
LLO: Able to Write a PL/SQL Write a PL/SQL code create
13 4 CO6
code create Procedures and Procedures and Functions
Functions
LLO: Able to write a PL/SQL Write a PL/SQL programs to create
14 4 CO6
programs to create triggers on triggers on given database.
given database.
LLO: Design ER and EER models Case Study on ER Model And EER
15 4 CO3
for Bank, library, education Model
organization, hotel management,
hospital management etc.

Database Management Systems (IT23106) Approved Copy P-23scheme

Government Polytechnic, Mumbai Information Technology
Total
60

IV. Suggested Micro Project / Assignment/ Activities for Specific Learning / Skills
Development (Self Learning):
1. Prepare journal of practical.
2. Write assignment on the questions given by faculty.

V. Specification Table:
Distribution of Theory Marks
Unit Topic
No R U A Total
Title Level Level Level Marks
Database System Concepts
1 2 2 6 10
Relational Data Model
2 4 6 4 14
Database Design Using E-R Model
3 2 2 2 6
Normalization
4 4 2 4 10

Transaction Processing
5 2 4 4 10
PL/SQL Programming
6 4 2 4 10
Total 18 18 24 60

VI.Assessment

Methodologies/Tools

Formative assessment (Assessment for Learning)

Rubrics for continuous assessment based on process and product related performance indicators
(55 marks)

Summative Assessment (Assessment of Learning)

End term examination, Viva-voce, Workshop performance (110 marks)

Database Management Systems (IT23106) Approved Copy P-23scheme

Government Polytechnic, Mumbai Information Technology

VII. COs - POs Matrix Form

Programme
Programme Outcomes Specific
(POs) Outcomes
Course (PSOs)
Outcomes PO-5
(COs) PO-1 Basic PO-3 Engineering PO-7
and PO-2 Design/ PO-4 Practices for PO-6 Project Life PSO- PSO- PSO-
Discipline Problem Development Engineering Society, Management Long 1 2 3
Specific Analysis of Solutions Tools Sustainability Learning
Knowledge and
Environment

CO1 1 2 3 3 2 3 3 2 3 3
CO2 2 2 3 3 1 3 2 - 3 2
CO3 2 3 - 2 2 2 2 2 2 -
CO4 - 3 2 3 2 - - 2 3 3
CO5 1 2 3 - 2 3 3 2 3
CO6 2 2 3 3 2 3 3 2 3 3
Legends: - High:03, Medium:02, Low:01, No Mapping: -

VIII. Suggested Learning Materials / Books

Sr. Author/ Publisher Title ISBN

No
1 Abraham Silberschtz, Henry Database System
Korth& S. Sudarshan, Tata concepts 9789332901384
McGrawHill International
Elmasri and Navathe Pearson Fundamentals of Database 9780136086208 .
2 Education Systems”
3 Gupta G. K. McGraw Hill Database Management Systems 978-07-107273-1
Education, New Delhi 2013,
4 Ivan Bayross BPB publication PL/SQL 9788176566919

IX. Learning Websites & Portals

Sr.No Link / Portal

1 https://www.w3schools.com/
2 https://www.youtube.com/watch?v=IoL9Ve2SRwQ&list=PLIwC9bZ0rmjSkm1VRJROX4
vP2YMIf4Ebh
3 https://www.javatpoint.com/dbms-tutorial

Database Management Systems (IT23106) Approved Copy P-23scheme

Government Polytechnic, Mumbai Information Technology

X. Academic Consultation Committee/Industry Consultation Committee:

Sr. Name Designation Institute/Organization

No
1 Swapna Chavan Visiting Lecturer Government Polytechnic Mumbai
2 Namrata A. Wankhade Lecturer Government Polytechnic Mumbai

3 Parth Ghag Project Research Assistant at IIT Mumbai

System and Control Engineering

Coordinator, Head of Department

Curriculum Development, Department of Information Technology
Department of Information Technology

I/C, Curriculum Development Cell Principal

Database Management Systems (IT23106) Approved Copy P-23scheme

Government Polytechnic, Mumbai Information Technology

Programme: Diploma in Information Technology and Computer Engineering (Sandwich

Pattern)

Course Code: IT23107 Course Title: Java Programming

Compulsory / Optional: Compulsory

Teaching Scheme and Credits Examination Scheme

SA- SA
TH FA-
CL TL LL SLH NLH Credits FA-TH SLA Total
(2:30 PR PR OR
Hrs.)

3 - 4 1 8 4 20 20 60 25 50# - 25 200
Total IKS Hrs. for course:
Abbreviations: CL- Class Room Learning, TL- Tutorial Learning, LL- Laboratory Learning, SLH-
Self Learning Hours, NLH-Notional Learning Hours, FA - Formative Assessment, SA -Summative
assessment, SLA- Self Learning Assessment

Legends: @ Internal Assessment, # External Assessment, *# On Line Examination, @$ Internal

Online Examination

Note:
1. FA-TH represents an average of two class tests of 20 marks each conducted during the term.
2. SA-TH represents the end term examination.
I. Rationale
Java is platform independent open source object oriented programming language enriched with
free and open source libraries. In current industrial scenario java has the broad industry support
and is prerequisite with many allied technologies like Advanced Java, Java Server Pages, and
Android Application Development. Thus current industrial trends necessitate acquiring Java
knowledge for computer engineering and information technology graduates.

II. Industry / Employer Expected Outcome

This course develops necessary skills in students to apply object oriented programming techniques
in Java so that students will be able to develop complete applications using core Java.
III. Course Outcomes: Students will be able to achieve & demonstrate the following COs on
completion of course based learning
CO1 Develop programs using Object Oriented Methodology in Java.
CO2 Apply concept of Arrays and Strings.
CO3 Apply concept of Inheritance for code reusability.
CO4 Develop programs using User Defined Packages and Interfaces.
CO5 Develop programs using Multithreading and Exception Handling.
CO6 Develop programs using Lambda Expressions and Generics.

Java Programming (IT23107) Approved Copy P-23 scheme

Government Polytechnic, Mumbai Information Technology
CO7 Develop programs for handling I/O, File Stream and Collections.

Course Content Details:

Unit
No. Theory Learning Outcomes (TLO's)aligned to Topics / Sub-topics
CO's

TLO 1.1: Understand features of Java. Basic Syntactical Constructs in

Java
TLO 1.2: Develop program to define class, create
1.1 Features of Java
1 object and access class members. 1.2 Defining class, creating object,
accessing class members
TLO 1.3: Understand the meaning of main() 1.3 public static void main() method
method and its attributes. 1.4 Java tokens and data types.
1.5 Operators and expressions
TLO 1.4: Identify tokens and data types. 1.6 Decision making and looping

TLO 1.5: Identify operators and evaluate Course Outcome: CO1

expressions. Teaching Hours: 04 hrs
Marks: 04
TLO 1.6: Understand working of decision
making and looping statements and develop
program for the same.

TLO 2.1: Develop program to define and call Derived Syntactical Constructs in
constructors and methods. Java
2.1 Constructors and Methods
TLO 2.2: Develop program to demonstrate the
2.2 Constructor overloading, method
use of constructor overloading and method
overloading
overloading.
2.3 this keyword, variable length
argument, garbage collection,
2 TLO 2.3: Understand the use of this keyword, finalize() method
variable length argument, garbage collection,
2.4 Visibility controls
finalize() method.
2.5 Arrays and strings
2.6 Static modifier
TLO 2.4: Identify visibility controls and its use.
Course Outcome: CO1, CO2
TLO 2.5: Develop program to create arrays and Teaching Hours: 08 hrs
strings. Marks: 10

TLO 2.6: Understand the use of Static modifier.

Java Programming (IT23107) Approved Copy P-23 scheme

Government Polytechnic, Mumbai Information Technology

TLO 3.1: Understand and develop program for Inheritance, Interfaces and
different types of inheritance. Packages
3.1 Inheritance-concept, types of
TLO 3.2: Understand the use of super keyword. inheritance
3.2 Use of super keyword
TLO 3.3: Develop program to demonstrate the 3.3 Method overriding
use of method overriding. 3.4 Dynamic method dispatch
3.5 Abstract methods and classes
3 TLO 3.4: Understand Dynamic method dispatch. 3.6 Interfaces
3.7 Packages-creating user defined
TLO 3.5: Develop program to demonstrate the packages, using packages
use of abstract methods and classes.
Course Outcome: CO3, CO4
TLO 3.6: Understand and develop program to Teaching Hours: 10 hrs
define and access interface. Marks: 12

TLO 3.7: Develop program to create and access

user defined package.
Exception handling and
TLO 4.1: Understand, identify and develop Multithreading
program to handle different errors and exceptions. 4.1 Errors and Exceptions
4.1.1 try-catch
TLO 4.2: Understand and develop program to 4.1.2 throw
define and use user defined exceptions. 4.1.3 throws
4.1.4 finally
TLO 4.3: Understand and develop program to 4.2 User defined exceptions
demonstrate the use of multithreading. 4.3 Multithreading
4 4.3.1 Thread life cycle
4.3.2 Creating thread
4.3.3 Thread priority
Course Outcome: CO5
Teaching Hours: 06 hrs
Marks: 10

TLO 5.1: Understand nested classes and inner Lambda Expressions and Generics
classes. 5.1 Nested classes and inner classes
TLO 5.2: Understand default methods and 5.2 Default methods and functional
functional interface. interfaces
TLO 5.3: Understand lambda expression. 5.3 Introduction to lambda expression
TLO 5.4: Develop program for passing lambda 5.4 Passing lambda expression as an
expression as an argument. argument
5 TLO 5.5: Understand generics classes and 5.5 Generics classes and interfaces
interfaces. 5.6 Type parameter, type argument
TLO 5.6: Understand type parameter and type 5.7 Generic methods
argument. 5.8 Bounded generics
TLO 5.7: Understand generic methods. Course Outcome: CO6
TLO 5.8: Understand bounded generics. Teaching Hours: 08 hrs
Marks: 12

Java Programming (IT23107) Approved Copy P-23 scheme

Government Polytechnic, Mumbai Information Technology
Files and I/O
TLO 6.1: Understand basics of I/O. 6.1 I/O basics
6.2 Byte streams and character
TLO 6.2: Understand byte streams and character streams
streams. 6.3 Reading/writing characters
6.4 Reading/writing bytes
TLO 6.3: Develop program for reading and writing 6.5 Files and Directories
6 characters. 6.6 Creating files/directories
6.7 The java.util.Scanner class
TLO 6.4: Develop program for reading and writing
bytes. Course Outcome: CO1, CO2
Teaching Hours: 05 hrs
TLO 6.5: Understand files and directories. Marks: 08

TLO 6.6: Develop program for creating files and

directories.

TLO 6.7: Understand the use of java.util.Scanner

class.
Collections
TLO 7.1: Understand the use of Collection 7.1 Collection in Java
interface. 7.2 Hierarchy of Collection framework
7.3 Methods of Collection interface
TLO 7.2: Understand hierarchy of Collection 7.4 Collections
framework. 7.4.1 Iterator interface
7.4.2 Collection interface
7 TLO 7.3: Understand and develop program to use 7.4.3 List interface
methods of Collection interface. 7.4.4 ArrayList
7.4.5 LinkedList
TLO 7.4: Understand the use of Collections and its 7.4.6 Vector
interfaces. 7.4.7 Stack
7.4.8 Queue interface
7.4.9 Set interface

Course Outcome: CO7

Teaching Hours: 04 hrs
Marks: 04

Java Programming (IT23107) Approved Copy P-23 scheme

Government Polytechnic, Mumbai Information Technology
IV. Laboratory Learning Outcome and Aligned Practical / Tutorial
Experiences.
NOTE: Total 10 experiments (or turns) out of 18 experiments (or turns)
Sr Practical / Tutorial / Laboratory Experiment / Number Relevant
No Laboratory Learning Outcome Practical Titles / Tutorial Titles of COs
(LLO) hrs.
LLO: Able to understand Develop a program for
1 2 CO1
and develop program implementation of implicit
based on type casting. type casting in Java.
4 CO1,
LLO: Able to understand Develop program for
2 CO2
and develop program implementation of
based on overloading. constructor overloading
and method overloading.
LLO: Able to understand Develop program for CO1,
3 4
and develop program implementation of different CO2
based on String class methods of String class.
methods.
LLO: Able to understand Develop program for implementation CO1,
4 2
and develop program of Arrays in Java. CO2
based on array.
LLO: Able to understand Develop program for implementation CO1,
5 2
and develop program of static modifier. CO2
based on static modifier.
LLO: Able to understand Develop program for implementation
6 4 CO3, CO4
and develop program of different types of inheritance.
based on different types of
inheritance.
LLO: Able to understand Develop program for implementation
7 2 CO3, CO4
and develop program of use of super keyword.
based on super keyword.

LLO: Able to understand Develop program for implementation

8 2 CO3, CO4
and develop program of dynamic method dispatch.
based on dynamic method
dispatch.
LLO: Able to understand Develop program for implementation
9 2 CO3, CO4
and develop program of multiple inheritance using
based on multiple interface.
inheritance.
LLO: Able to understand Develop program for implementation
10 2 CO3, CO4
and develop program of user defined package.
based on user defined
package.
LLO: Able to understand Develop program for implementation
11 4 CO5
and develop program of multithreading.
based on multithreading.
LLO: Able to understand Develop program for implementation
12 4 CO5
and develop program of exception handling.
based on exception

Java Programming (IT23107) Approved Copy P-23 scheme

Government Polytechnic, Mumbai Information Technology
handling.

LLO: Able to understand Develop program for implementation

13 2 CO5
and develop program of user defined exception.
based on user defined
exception.
LLO: Able to understand Develop program for implementation
14 4 CO6
and develop program of lambda expressions in Java.
based on lambda
expressions.
LLO: Able to understand Develop program for implementation
15 6 CO6
and develop program of generic interfaces and methods.
based on generic
interface.
LLO: Able to understand Develop program for implementation
16 4 CO7
and develop program of reading and writing characters and
based on reading and bytes in files.
writing characters and
bytes.
LLO: Able to understand Develop program for implementation
17 2 CO7
and develop program of Scanner class.
based on Scanner class.
LLO: Able to understand Develop program for implementation
18 8 CO7
and develop program of different Collections.
based on different
Collections.
Total 60

V. Suggested Micro Project / Assignment/ Activities for Specific Learning / Skills

Development (Self Learning):
1. Prepare journal of practical.
2. Undertake mini project. Develop a Java application for the requirement given by faculty.
3. Prepare a presentation on the topic given by faculty.

VI. Specification Table:

Distribution of Theory Marks
Unit Topic
No Title R U A Total
Level Level Level Marks
1 Basic Syntactical Constructs in Java 0 2 2 4
2 Derived Syntactical Constructs in Java 0 4 6 10
3 Inheritance, Interfaces and Packages 2 4 6 12
4 Exception handling and Multithreading 2 4 4 10
5 Lambda Expressions and Generics 2 6 4 12
6 Files and I/O 2 2 4 8
7 Collections 2 0 2 4
Total 10 22 28 60

Java Programming (IT23107) Approved Copy P-23 scheme

Government Polytechnic, Mumbai Information Technology

VII. Assessment Methodologies/Tools

Formative assessment (Assessment for Learning)

Rubrics for continuous assessment based on process and product related performance indicators
(60 marks)

Summative Assessment (Assessment of Learning)

End term examination, Viva-voce, Workshop performance (140 marks)

VIII. COs - POs Matrix Form
Programme
Programme Specific
Outcomes (POs) Outcomes
Course (PSOs)
Outco PO-5
mes PO-1 PO-3 Engineeri PO-7
(COs) Basic PO-2 Design/ PO-4 ng PO-6 Life PS PS PS
and Proble Developm Engineer Practices Project Log O O O
Discipli m ent of ing Tools for Managem Learni - - -
ne Analy Solutions Society, ent ng 1 2 3
Specific sis Sustainabi
Knowle lity and
dge Environm
ent
CO1 1 2 3 1 - 1 3 1 2 2
CO2 1 3 3 2 - 3 3 2 2 3
CO3 1 3 3 2 - 3 3 3 3 3
CO4 - 3 3 2 1 3 3 3 3 3
CO5 - 3 3 2 1 3 3 3 3 3
CO6 3 3 3 1 - 1 3 1 2 2
CO7 3 3 - 2 - 1 2 3 2 3
Legends: - High:03, Medium:02, Low:01, No Mapping: --

IX. Suggested Learning Materials / Books

Sr.No Author/ Title ISBN

Publisher
E. Balgurusamy Programming with 978-9355325891
1 JAVA
Herbert Schildt Java-The complete reference 10th 978-1259589331
2 or later edition
Raoul-Gabriel Urma, Java 8 in action, first edition 978-1617291999
3 Mario Fusco, Alan
Mycroft

Java Programming (IT23107) Approved Copy P-23 scheme

Government Polytechnic, Mumbai Information Technology
X. Learning Websites & Portals

Sr.No Link / Portal

1 https://www.javatpoint.com/java-tutorial
2 https://www.w3schools.com/java/
3 https://www.geeksforgeeks.org/java/
4 https://www.programiz.com/java-programming

XI. Academic Consultation Committee/Industry Consultation Committee:

Sr. Name Designation Institute/Organization

No
1 Ms. Namrata A. Wankhade Lecturer Information Government Polytechnic,
Technology Department Mumbai
2 Sayyed Shabana Usman Visiting Lecturer, Information Government Polytechnic,
Technology Department Mumbai
3 Varsha Khandekar Lecturer Information Government Polytechnic,
Technology Department Thane

Coordinator, Head of Department

Curriculum Development, Department of Information Technology
Department of Information Technology

I/C, Curriculum Development Cell Principal

Java Programming (IT23107) Approved Copy P-23 scheme

Government Polytechnic, Mumbai Information Technology

Programme : Diploma in Information Technology (Sandwich Pattern)

Course Code:IT23108 Course Title : Microcontroller and Embedded system

Compulsory / Optional: Compulsory

Teaching Scheme and Credits Examination Scheme

SA-TH SA
FA-
CL TL LL SLH NLH Credits FA-TH (2hr 30 SLA Total
PR PR OR
min)

3 - 2 1 6 3 20 20 60 25 25@ 25 175
Total IKS Hrs. for course:
Abbreviations: CL- Class Room Learning, TL- Tutorial Learning, LL- Laboratory Learning, SLH-Self Learning Hours, NLH-
Notional Learning Hours, FA - Formative Assessment, SA -Summative assessment, SLA- Self Learning Assessment

Legends: @ Internal Assessment, # External Assessment, *# On Line Examination, @$ Internal Online Examination

Note:
1. FA-TH represents an sum of two class tests of 40 marks each conducted during the term.
2. SA-TH represents the end term examination.
I. Rationale
Microcontroller is heart of all domestic, industrial, consumer goods and other high end products. Automation in every field
of life is being used and microcontroller is inbuilt element of these systems and devices. 8051 microcontroller
architecture, peripheral interfacing to it and assembly language programming is covered in this course. Microcontroller is
inbuilt element of embedded system. This course will also cover the concepts of embedded system. It covers Arduino and
its programming.

II. Industry / Employer Expected Outcome

Students should have
1. Proficiency in Microcontroller Programming and Application Development
2. Expertise in Peripheral Interfacing and Control
3. Competence in Timer, Interrupt, and Communication Protocols
4. Foundation in Embedded Systems Design and Open Source Development

III. Course Outcomes: Students will be able to achieve & demonstrate the following COs on completion of course based
learning

CO1 Comprehend the architecture and signal description of 8051.

CO2 Develop the program for 8051 for the given operations.
CO3 Interpret the program by using timer, interrupt and serial port/parallel port.
CO4 Interface various input and output devices to microcontroller.
CO5 Comprehend the concept of embedded systems, aurdino and its programming.

Microcontroller and Embedded system (IT23108) (Approved Copy) P-23 Scheme

Government Polytechnic, Mumbai Information Technology
Course Content Details:

Unit
No. Theory Learning Outcomes (TLO's)aligned to CO's Topics / Sub-topics
Basics of Microcontroller 8051
TLO 1.1: Explain the General architecture of 1.1 General architecture of Microcontroller
Microcontroller.
TLO 1.2 : Compare between Microprocessor and 1.2 Comparison of Microprocessor and Microcontroller
Microcontroller 1.3 Architecture of 8051
TLO 1.3: Describe the Architecture of 8051 1.4 Pin configuration and signal description of 8051
TLO 1.4: Explain the Pin configuration aand function of
1.5 Memory Organization of 8051
each pin of 8051.
1
TLO 1.5: Interpret the Memory Organization of 8051 1.6 Special features of 8051- Boolean Processor, Power
TLO 1.6: Identify the Special features of 8051 saving options- idle and power down mode, Derivatives of
8051(8951, 8952, 8031, 8751).
Course Outcome- CO1 Teaching Hours – 08 Marks: 10
(R- 4, U-6, A-0)
8051 Instruction set and Programming
TLO 2.1: Interpret the Instruction set of 8051.
2.1 Instruction set (Data transfer, Arithmetic and Logical,
TLO 2.2: Explain the Addressing Modes of 8051 Branching, Machine control, stack operation, Boolean)
TLO 2.3: Write Assembly language programs for given
2.2 Addressing modes
problem statement
2 TLO 2.4:: Write C language program for given problem 2.3 Assembly language programming
statement 2.4 8051 programming in C
Course Outcome- CO2 Teaching Hours – 10 Marks: 14
(R- 0, U-0, A-14)

Timer, Interrupts, Serial and Parallel communication

TLO 3.1: Explain the Timer/Counter operation and
3.1 8051 Timer/Counter: Logic and Modes, Programming
programming of 8051.
of 8051 timer
TLO 3.2: Describe the Interrupt structure of 8051.
3.2 8051 Interrupts: Interrupts and polling, SFRs- IE, IP,
3 TLO 3.3: Explain Serial Communication operation and Priority level and interrupt sequence
programming of 8051.
3.3 Serial Communication: SCON, SBUF, Modes of serial
TLO 3.4: Explain Parallel communication I/O port
communication, Programs on serial communication
structure and its programming
3.4 Parallel communication: I/O port structure and its
programming
Course Outcome- CO3 Teaching Hours – 08 Marks: 8
(R- 0, U-4, A-4)

Microcontroller and Embedded system (IT23108) (Approved Copy) P-23 Scheme

Government Polytechnic, Mumbai Information Technology
Memory and I/O Interfacing
TLO 4.1: Understand the Memory Interfacing.
4.1 Memory Interfacing: Interfacing of external program
TLO 4.2 : Explain I/O Interfacing of 8051. and data memory, Address map table
TLO 4.3 : Explain various applications of 8051 4.2 I/O Interfacing: Interfacing of LEDs, Relays, Keyboard,
Seven segment display, LCD, Stepper motor, DC motor,
ADC 0808, DAC 0808
4.3 Applications of 8051: Square wave generation using
port pins of 8051, Triangular wave generation using DAC,
4 Water level controller, Temperature controller using ADC,
Stepper motor control for clockwise and anticlockwise
rotation, Traffic light controller
Programming can be in assembly language or C (student’s
choice)
Course Outcome- CO4 Teaching Hours: 04
Marks: 14 (R- 0, U-0, A-14)
Introduction to embedded systems
TLO 5.1: Block diagram of embedded system with 5.1 Block diagram of embedded system with hardware
hardware components. components.
TLO 5.1: Harvard and Von Neumann architecture, RISC 5.2 Harvard and Von Neumann architecture, RISC and
and CISC processors CISC processors
5 TLO 5.1: Characteristics of embedded system, Processor 5.3 Characteristics of embedded system, Processor power,
power, memory, operating system, reliability, memory, operating system, reliability, performance, power
performance, power consumption, unit cost size, consumption, unit cost size, flexibility,
flexibility,
5.4 Classification of embedded system
TLO 5.1: Classification of embedded system
Course Outcome: CO5 Teaching Hours :4hrs
Marks: 4 (R- 2, U-2, A-0)
TLO 6.1: Understand Arduino Birth and Open source Open source embedded development board (Arduino)
community
6.1 Arduino Birth, Open source community
TLO 6.2: Explain the functional block diagram of
6.2 Functional block diagram of Arduino
Arduino
6.3 Functions of each pin of Arduino
TLO 6.3: Interpret the functions of each pin of Arduino
6 6.4 I/O functions, looping techniques, Decision making
TLO 6.4: Explain the I/O functions, looping
techniques.
techniques, Decision making techniques.
6.5 Programming of an Arduino: Interfacing LEDs, Seven
TLO 6.5: Understand the Programming of an Arduino.
segment display, LCD, ADC, DAC, Stepper motor, DC
Motor. Various applications using Arduino.
Course Outcome: CO5 Teaching Hours :5hrs
Marks: 10 (R- 0, U-4, A-6)

Microcontroller and Embedded system (IT23108) (Approved Copy) P-23 Scheme

Government Polytechnic, Mumbai Information Technology
IV. Laboratory Learning Outcome and Aligned Practical / Tutorial Experiences.

Sr Practical / Tutorial / Laboratory Learning Laboratory Experiment / Practical Titles / Number of Relevant
No Outcome (LLO) Tutorial Titles hrs. Cos
02 CO1
Demonstrate the ability to identify and Identify various blocks of 8051
1
describe the functions of various blocks and microcontroller development board
components on the 8051 microcontroller
development board.
Develop and debug assembly language CO2
2 Write an assembly language program to
programs to perform basic arithmetic
perform arithmetic operations such as 02
operations, demonstrating understanding of
addition, subtraction, multiplication and
instruction sets and registers.
division
Implement and test an assembly language CO2
3 Write an ALP to find smallest /largest 02
program to identify the smallest and largest
numbers from the given data bytes stored
numbers from a set of data bytes
in internal /external data memory
locations.
Write, debug, and execute an assembly CO2
4 Write an ALP to arrange numbers in
language program to sort a list of numbers
ascending/descending order. 02
in ascending or descending order
Interface an LED with a microcontroller and CO3
5 Interface LED with microcontroller and
write a program in C or assembly language 02
turn it ON for 1 sec. Write program either CO4
to control the LED
in C or assembly language.
Create and test an assembly language CO3
6 Develop an ALP to generate pulse and 02
program to generate pulse and square wave
square wave by using timer delay.
signals using timer delays
Interface a 7-segment display with the 8051 CO4
7 Interface 7 segment display to 8051 and 02
microcontroller and write a program to
display numbers 0 to 9 on it.
display numbers 0 to 9
Interface a 4x4 keyboard matrix with the CO4
8 Interface 4X4 keyboard matrix with 8051 02
8051 microcontroller and write a program to
and display the key pressed on 7 segment
detect key presses and display them on a 7-
display
segment display
Interface a stepper motor with the 8051 Interface stepper motor to 8051 and write CO4
9 02
microcontroller and develop a program to a program to rotate in clockwise and
control its rotation in both directions for anticlockwise direction for given angles
specified angles
Write and implement a program to control 02 CO5
10 Write a Program to Control the speed of
the speed of a DC motor using Arduino
DC motor using Arduino.
Design and implement a line follower robot 02 CO5
11 Implement line follower robot using
using Arduino
Arduino.
Develop and test a water level controller 02 CO5
12 Implement water level controller using
using Arduino
Arduino
Implement a digital thermometer using 02 CO5
13 Implement Digital Thermometer using
Arduino,
Arduino
Interface a 4x4 keyboard matrix and a 16x2 02 CO5
14 Interface 4x4 keyboard matrix and 16x2
LCD to Arduino and develop a program to
LCD to Arduino
display the key presses on the LCD
Interface a Digital-to-Analog Converter 02 CO5
15 Interface DAC to 8051 and write ALP to
(DAC) with the 8051 microcontroller and
generate square and triangular

Microcontroller and Embedded system (IT23108) (Approved Copy) P-23 Scheme

Government Polytechnic, Mumbai Information Technology
write an assembly language program to waveforms.
generate square and triangular waveforms
Total
30

V. Suggested Micro Project / Assignment/ Activities for Specific Learning / Skills Development (Self
Learning):
1. Create a detailed presentation or a report that compares the 8051 with other microcontrollers like 8951, 8952, 8031,
and 8751.
2. Create a project where an LED blinks with a specific pattern controlled by timers and interrupts.
3. Develop a report or presentation highlighting the characteristics and classifications of embedded systems, and provide
real-world examples.
4. Develop a series of projects using Arduino, such as:
 Blinking LEDs with different patterns.
 Displaying information on an LCD.
 Reading analog values from a sensor and displaying them.
 Controlling a DC motor with a PWM signal.
 Creating a simple weather station that reads temperature and humidity.

5. Select an embedded system (e.g., a smart thermostat, a wearable fitness tracker) and analyze its hardware components,
architecture, and performance characteristics. Prepare a detailed case study.

VI. Specification Table:

Distribution of Theory Marks

Unit Topic Title
No R U A Total
Level Level Level Marks
1 Basics of Microcontroller 8051 2 4 4 10
2 8051 Instruction set and Programming 4 4 6 14
3 Timer, Interrupts, Serial and Parallel 2 4 2 08
communication
4 Memory and I/O Interfacing 4 4 6 14
5 Introduction to embedded systems - 2 2 04
6 Open source embedded development 2 4 4 10
board (Arduino)
Total 14 22 24 60

VII. Assessment Methodologies/Tools

Formative assessment (Assessment for Learning)

Rubrics for continuous assessment based on process and product related performance indicators (65 marks)

Summative Assessment (Assessment of Learning)

End term examination, Viva-voce, Workshop performance (85 marks)

Microcontroller and Embedded system (IT23108) (Approved Copy) P-23 Scheme

Government Polytechnic, Mumbai Information Technology

VIII. COs - POs Matrix Form

Programme
Programme Outcomes (POs) Specific
Outcomes
Course (PSOs)
Outcomes PO-5
(COs) PO-1 Basic PO-3 Engineering PO-7
and PO-2 Design/ PO-4 Practices for PO-6 Project Life PSO- PSO- PSO-
Discipline Problem Development Engineering Society, Management Long 1 2 3
Specific Analysis of Solutions Tools Sustainability Learning
Knowledge and
Environment
CO1 3 - - 2 1 - 2 1
CO2 1 3 2 2 - - 1 2 -
CO3 - 2 - - 3 1 2 2 - -
CO4 2 - 2 -- - 2 - 3 - -
CO5 2 - - 2 2 - 1 - 2 -
CO6 - 2 - - 3 1 - 1 1
CO7 1 - 1 2 - - 3 - 3 -
Legends: - High:03, Medium:02, Low:01, No Mapping: --

IX. Suggested Learning Materials / Books

Sr. Author/ Title ISBN

No Publisher
1 The 8051 Microcontroller and Mazidi, Pearson Education India; 978-8131710265
Embedded Systems: Using Assembly 2 edition 2007
and C
2 The 8051 Microcontroller & Kenneth Ayala, Delmar Cengage 978-8131511053
Embedded Systems Using Assembly Learning; First edition , January
and C with CD 2010
3 Introduction to Embedded System Shibu K. V., MC Graw Hill, 978-1259081514
First edition, 2009
4 Beginning Arduino Michael McRoberts, Technology 978-1430232414
in action, First edition 2010
5 Programming Arduino Getting started Simon monk, MC Graw Hill, 978-0071784238
with sketches First edition, 2012

Microcontroller and Embedded system (IT23108) (Approved Copy) P-23 Scheme

Government Polytechnic, Mumbai Information Technology

X. Learning Websites & Portals

Sr.No Link / Portal

1 https://www.coursera.org
2 https://www.edx.org/

3 https://www.udemy.com/

4 https://ocw.mit.edu/

5 https://www.allaboutcircuits.com/

6 https://www.hackster.io/

7 https://swayam.gov.in/

XI. Academic Consultation Committee/Industry Consultation Committee:

Sr. No Name Designation Institute/Organization

Lecturer in Electronics Engineering Government Polytechnic Mumbai
1 Dr. Hemant Pardeshi
2 Mr. Anjum Mujawar Director Discover Technologies Thane
3 Dr. N D Chavan Lecturer in Electronics Engineering L J Somaiya Polytechnic, Mumbai

Coordinator, Head of Department

Curriculum Development, Department of Information Technology
Department of Information Technology

I/C, Curriculum Development Cell Principal

Microcontroller and Embedded system (IT23108) (Approved Copy) P-23 Scheme

Government Polytechnic, Mumbai Information Technology

Programme : Diploma in Information Technology (Sandwich Pattern)

Course Title: Multimedia Techniques

Course Code: IT23604

Compulsory / Optional: Compulsory

Teaching Scheme and Credits Examination Scheme

SA- SA
FA-
CL TL LL SLH NLH Credits FA-TH TH SLA Total
PR
(3Hrs.) PR OR

2 - 4 2 8 4 - - - 25 50@ - 25 100
Total IKS Hrs. for course:
Abbreviations: CL- Class Room Learning, TL- Tutorial Learning, LL- Laboratory Learning, SLH-
Self Learning Hours, NLH-Notional Learning Hours, FA - Formative Assessment, SA -Summative
assessment, SLA- Self Learning Assessment

Legends: @ Internal Assessment, # External Assessment, *# On Line Examination, @$ Internal

Online Examination

Note:
1. FA-TH represents an average of two class tests of 30 marks each conducted during the term.
2. SA-TH represents the end term examination.
I. Rationale
For effective communication teaching, presentation multimedia is the essential feature. The
Multimedia Techniques course is designed for using multimedia technology to enhance their
professional skills to pursue a career in multimedia. The course focuses on specialized technical &
creative skills & provides students with reflective skills. It also offers student’s knowledge in theories
& methodologies relevant to current industry professional practice & research.
Industry / Employer Expected Outcome
Students should be able to develop application using Multimedia Techniques.
II. Course Outcomes: Students will be able to achieve & demonstrate the following COs on
completion of course based learning

CO1 Explain different multimedia elements

CO2 Demonstrate use of different Compression, Decompression techniques
CO3 Create animations with different tools such as FLASH, MAYA
CO4 Demonstrate the use of animation, sound, video control and scanned images
CO5 Describe multimedia Authoring System

Mutimedia Technology(IT23604) Approved Copy P-23scheme

Government Polytechnic, Mumbai Information Technology
Course Content Details:

Unit
No. Theory Learning Outcomes (TLO's)aligned Topics / Sub-topics
to CO's
Multimedia Elements:

TLO 1.1: Explain evaluation of multimedia 1.1 Evaluation of multimedia systems:

systems Multimedia elements, Photographic Images,
1 TLO 1.2: Explain categorization of Geographic’s information system maps, still
multimedia. image processing
TLO 1.3: Explain storage media used in 1.2 Categorization of Multimedia
multimedia technology 1.3 Storage media: Magnetic media technology,
TLO 1.4: Explain different applications of Hard disk technology, RAID, Optical media
multimedia 1.4 Multimedia Applications: Document
imaging,
Image processing and Image Enhancement,
OCR, Handwriting recognition, non-textual
Image recognition, Full motion Digital Video
application and Electronics message.

Course Outcome- CO1 Teaching Hours – 03

Compression/Decompression & File Format

TLO 2.1: Explain concept of compression and2.1 Compression and decompression: Types,
decompression, its types, needs Need
TLO 2.2: Explain video compression of data compression and Still video image.
technique (simple compression, interpolative, 2.2 Video compression technique: Simple
predictive) compression technique, Interpolative,
TLO 2.3: Explain JPEG compression Predictive
definition, JPEG components and standards 2.3 JPEG Compression: Definition, JPEG
2 TLO 2.4: Explain the different file formats Components and standards
(RIF, TIFF, MIDI, AVI, MPEG, WAVE) 2.4 File Formats: RIF, TIFF
MIDI file format
AVI format
Introduction to MPEG
WAVE file format

Outcome- CO2 Teaching Hours – 02

Mutimedia Technology(IT23604) Approved Copy P-23scheme

Government Polytechnic, Mumbai Information Technology

Multimedia I/O Technology:

TLO 3.1: Explain the Multimedia System 3.1 Multimedia System Architecture
Architecture. 3.2 Basics of Digital Audio: Signal -to-Noise –
TLO 3.2: Describe basics of Digital audio Ratio (SNR), Signal-to-Quantization-Noise-
(SNR, SQNR) Ratio (SQNR)
TLO 3.3: Explain the use of color in Image 3.3 Color use in Image & Video: Color
and Video, color characteristics, color models Characteristics, Color models in Images and
3 in Images and video. video
TLO 3.4: Describe the fundamental concepts 3.4 Fundamental concepts in video: Types of
in video-types of video signal, components of Videos signals, Components of video, s-
video. video,
Analog and Digital video

Course Outcome- CO3 Teaching Hours –03

Animation: Multimedia Tool-1 Flash

TLO 4.1: Introduce multimedia tool & 4.1 Introduction to multimedia tool & versions of
versions of flash Flash.
TLO 4.2: Describe macromedia flash creating4.2 Creating and Modifying elements: Line, Text,
and modifying elements(Line, text, pen tool, Pen tool, different shapes.
different shapes) 4.3 Selecting lines fill with arrow tool, using lasso
TLO 4.3: Describe functions of arrow tool, tool, Selecting and deselecting elements,
lasso tool, selecting and deselecting elements, Modifying created objects.
4 modifying created objects. 4.4 Keyframes, timelines, Tweening Motion and
TLO 4.4: Explain keyframes, timelines, Layers.
Tweening motion and Layers. 4.5 2D versus 3D Animation.
TLO 4.5: Describe 2D and 3D animation and 4.6 Advertisement in flash, Use & Applications of
difference between them. flash animation software.
TLO 4.6: Explain use applications of flash
animation software. Course Outcome- CO4 Teaching Hours – 02
TLO 5.1: Explain the concept of processing Graphics Multimedia tool-2 Photoshop
digital images. &Maya
TLO 5.2: Explain file formats and versions of
Photoshop. 5.1 Concept of processing digital images
TLO 5.3: Explain application and use of 5.2 File Formats and versions of Photoshop
Photoshop. 5.3 Application and use of Photoshop
TLO 5.4: Explain cropping & slicing, 5.4 Tools: Cropping & slicing, Measuring and
5 measuring and navigation, selection typing, Navigation, Selection Typing, Video Editing
video editing. 5.5 Introduction to Corel Draw
TLO 5.5: Explain Introduction of Corel Draw. 5.6 Introduction about VFX, its advantages and
TLO 5.6: Describe introduction of VFX, its Applications.
advantages and applications. 5.7 Introduction to MAYA Tool: Overview,
TLO 5.7: Explain introduction of MAYA tool, components, MAYA Embedded Languages,
its components system requirements, MAYA System Requirements.
embedded languages.
Course Outcome- CO4 Teaching Hours – 03

Mutimedia Technology(IT23604) Approved Copy P-23scheme

Government Polytechnic, Mumbai Information Technology
Multimedia Authoring and User Interface

TLO 6.1: Explain Multimedia Authoring 6.1 Multimedia Authoring system and its types.
system and its types 6.2 Hypermedia Application and Design
6 TLO 6.2: Explain Hypermedia application Consideration
and design consideration 6.3 User Interface Design
TLO 6.3: Describe User Interface Design 6.4 Information Access
using Multimedia. 6.5 Object Display/ Playback Issues
TLO 6.4: Explain Information Access. 6.6 Introduction to Distributed Multimedia
TLO 6.5: Describe Object Display/Playback Systems
Issues
TLO 6.6: Explain introduction of Distributed Course Outcome- CO5 Teaching Hours:02
Multimedia System.

III. Laboratory Learning Outcome and Aligned Practical / Tutorial

Experiences.

Sr Practical / Tutorial / Laboratory Experiment / Number Relevant

No Laboratory Learning Outcome Practical Titles / Tutorial Titles of Cos
(LLO) hrs.
LLO: Able to Classify & Analyze Classify & Analyze Characteristics,
1 2 CO1
Characteristics, functionality and functionality and performance of
performance of different multimedia different multimedia Input Output
Input Output devices devices.
LLO: Able to Demonstrate Demonstrate compression & 2 CO2
2 compression & decompression, decompression, different file
different file Formats. Formats.
LLO: a. Able to design a. Design advertisement in flash with
3 4 CO2
advertisement in flash withanimation.
animation. b. Develop a banner of recent
LLO: b. Able to develop a banner ofactivity in your college or any
recent activity in college or anyfestival.
festival. .
LLO: a. Able to develop a a. Develop a presentation using play,
4 6 CO2
presentation using play, pause, stoppause, stop button instances using
button instances using Action ScriptAction Script 2.0
2.0 b. Develop an Analog clock using
LLO: b. Able to develop an Analog Action Script 2.0
clock using Action Script 2.0
LLO: Able to create a presentation Create a presentation by using
5 2 CO2
by using different tools in flash different tools in flash (Lasso, Arrow
(Lasso, Arrow and etc) etc)
LLO: a. Able to design a joker a. Design a joker character in flash.
6 4 CO2
character in flash b. Develop an animation of joker’s
LLO: b. Able to develop anface by using key frames and Tween
animation of joker’s face by using Motion (Laughing and Crying)
key frames and Tween Motion

Mutimedia Technology(IT23604) Approved Copy P-23scheme

Government Polytechnic, Mumbai Information Technology
LLO: Able to develop an Develop an animation for water fall
7 4 CO2
animation for water fall effect using Flash.
LLO: Able to design and develop aDesign and develop a forest tree with
8 4 CO2
forest tree with flowers and fruits flowers and fruits from a small plant
from a small plant using different using different layers & Frame
layers & Frame Transition Time Transition Time.
LLO: Able to develop Shape tween Develop Shape tween text effect
9 4 CO2
text effect animation animation in flash.
LLO: a. Able to Insert audio toa. Insert audio to relevant frames that
10 8 CO3
relevant frames that has lightninghas lightning and Rain effect.
and Rain effect. b. Insert audio to relevant frames
LLO: b. Able to Insert audio tothat has water drop effect
relevant frames that has water drop
effect
LLO: a. Able to create Images by a. Create Images by using Photoshop
11 4 CO3
using Photoshop tool. tool.
LLO: b. Able to edit Images by b. Edit an image using photoshop
using Photoshop tools. tools

LLO: Able to create bouncing ball Create bouncing ball animation

12 4 CO3
animation using MAYA Tool. using MAYA Tool.
LLo: Able to create coffee cup Model a coffee cup using polygon
13 4 CO4
using polygon primitives in MAYA primitives in MAYA tool.
tool.
LLO: Able to create project in Create any project in MAYA using
14 4 CO4
MAYA using rendering effect. rendering effect.
LLO: Able to create a movie of Mini Project: Students should create
15 4 CO4
minimum 5 minutes using Flash & a movie of minimum 5 minutes
Maya or Adobe Animate CC using Flash & Maya or Adobe
software. Animate CC software.
Total
60

IV. Suggested Micro Project / Assignment/ Activities for Specific Learning / Skills
Development (Self Learning):
1. Mini project on Games
2. Mini project on Story
3. 3D animated film or scene
4. Short documentary film

V. Assessment
Methodologies/Tools
Formative assessment (Assessment for Learning)
Rubrics for continuous assessment based on process and product related performance indicators
(50 marks)

Summative Assessment (Assessment of Learning)

End term examination, Viva-voce, Workshop performance (50 marks)

Mutimedia Technology(IT23604) Approved Copy P-23scheme

Government Polytechnic, Mumbai Information Technology
VI. COs - POs Matrix Form

Programme
Programme Specific
Outcomes (POs) Outcomes
Course (PSOs)
Outcom PO-5
es (COs) PO-1 Engineerin
PO-3 PO-7
Basic PO-2 Design/ PO-4 g Practices PO-6 Lif PSO PSO PSO
and Proble Developme Engineeri for Society, Project e -1 -2 -3
Disciplin m nt of ng Tools Sustainabil Manageme Lo
e Specific Analys Solutions ity and nt ng
Knowled is Environme Learni
ge nt ng
CO1 3 - - - - - - - - -
CO2 3 - - 2 - - 1 3 - -
CO3 3 3 3 3 3 1 1 3 2 -
CO4 3 3 3 3 3 1 1 3 2 2
CO5 3 - 3 2 - - - 3 - 2
Legends: - High:03, Medium:02, Low:01, No Mapping: --

VII. Suggested Learning Materials / Books

Sr. Author/ Publisher Title ISBN

No
1 Prabhat K Andheigh, Kiran Multimedia System 978-9332549388
Thakrar Design
Koegel Buford Multimedia System 978-8177588279
2
3 Katherine Ulrich Macromedia flash 978-0321213440
For windows & Macintosh
4 R. Steimnetz, K. Nahrstedt Multimedia Communication 978-8177584417

VIII. Learning Websites & Portals

Sr.No Link / Portal

1 https://www.tutorialspoint.com/listtutorials/flash
2 http://www.nptel.ac.in/courses/106102065/33
3 http://www.adobe.com/in/products/animate.html
4 https://www.autodesk.in/products/maya/overview

Mutimedia Technology(IT23604) Approved Copy P-23scheme

Government Polytechnic, Mumbai Information Technology

IX. Academic Consultation Committee/Industry Consultation Committee:

Sr. Name Designation Institute/Organization

No
1 Ms. Swapna Chavan Visiting Lecturer Government Polytechnic Mumbai
2 Ms. Dipali Gosavi Lecturer Government Polytechnic Mumbai
3 Ms. Rohini Yadav Associate Developer MUFG Mumbai

Coordinator, Head of Department

Curriculum Development, Department of Information Technology
Department of Information Technology

I/C, Curriculum Development Cell Principal

Mutimedia Technology(IT23604) Approved Copy P-23scheme

Government Polytechnic, Mumbai Information Technology

Programme : Diploma in Information Technology and Computer Engineering (Sandwich

Pattern)

Course Code: IT23108 Course Title: Software Engineering

Compulsory / Optional: Compulsory

Teaching Scheme and Credits Examination Scheme

SA- SA
FA-
CL TL LL SLH NLH Credits FA-TH TH SLA Total
PR PR OR
(3Hrs.)

3 - 1 4 2 20 20 60 - - - 25 125
Total IKS Hrs. for course:
Abbreviations: CL- Class Room Learning, TL- Tutorial Learning, LL- Laboratory Learning, SLH-
Self Learning Hours, NLH-Notional Learning Hours, FA - Formative Assessment, SA -Summative
assessment, SLA- Self Learning Assessment

Legends: @ Internal Assessment, # External Assessment, *# On Line Examination, @$ Internal

Online Examination

Note:
1. FA-TH represents an average of two class tests of 30 marks each conducted during the term.
2. SA-TH represents the end term examination.
I. Rationale
Software Engineering is an engineering discipline that is concerned with all aspects of software
production. Further it is the systematic application of scientific and technological knowledge, methods,
and experience to the design, implementation, testing, and documentation of software. This course
intends to develop a systematic, disciplined approach to the development, operation, and maintenance
of software and help students to get acquainted with latest trends in Software Engineering.

Industry / Employer Expected Outcome

Students should be able to understand software development models.
II. Course Outcomes: Students will be able to achieve & demonstrate the following COs on
completion of course based learning

CO1 Understand the basics of Software Engineering.

CO2 Identify suitable process model for software development.
CO3 Understand importance of Agile Methodology.
CO4 Apply Software Engineering principles at various stages of Software Development.
CO5 Use software modelling to create data designs.
CO6 Apply project management principles for software development.

Software Engineering (IT23108) Approved Copy P-23scheme

Government Polytechnic, Mumbai Information Technology

Course Content Details:

Unit Theory Learning Outcomes (TLO's)aligned

No. to CO's Topics / Sub-topics
Overview of Software Engineering
TLO 1.1: Introduce software
TLO 1.2: Describe Characteristics of 1.1 Definition of Software
1.2 Software Characteristics, Software
software and its application
Application, Software myths
TLO 1.3: Explain the different types of 1.3 Types of Software
software 1.4 Software Engineering- Definition, Need
1 TLO 1.4: Introduce software engineering 1.5 Software Engineering- A Layered Approach
with its needs 1.6 Software Development Generic Process
TLO 1.5: Describe A Layered Approach of Framework- Typical Umbrella Activities.
software Engineering Identifying A Task Set
1.7 Some Terminologies : Product and Process,
TLO 1.6: Explain software Development
Module and Software Components,
Generic Process Framework Deliverables and Milestones
TLO 1.7: Describe terminologies related to
software engineering Course Outcome- CO1 Teaching Hours – 07
Marks 08
Process Models
TLO 2.1: Describe Personal and Team
Process Models 2.1 Personal and Team Process Models (PSP
TLO 2.2: Describe Waterfall Model and TSP)
TLO 2.3: Describe V model 2.2 Waterfall Model
2
TLO 2.4: Describe Incremental process 2.3 V Model
Model 2.4 Incremental Process Model
TLO 2.5: Describe Evolutionary Process 2.5 Evolutionary Process Model: Prototyping
Model 2.6 Selection criteria for software process
TLO 2.6: Explain Selection criteria for model.
software process model
Course Outcome- CO2 Teaching Hours – 06
Marks 10

Software Engineering (IT23108) Approved Copy P-23scheme

Government Polytechnic, Mumbai Information Technology
Agile Methodology
TLO 3.1: Describe Agile software 3.1 Agile Software Methodology: What is
methodology with its importance Agile Methodology , Importance of Agile
TLO 3.2: Describe Adaptive Software Methodology , Difference between
Development Prescriptive and Agile Process Model ,
TLO 3.3: Explain Agile Process Model Agility Principles
TLO 3.4: Explain Dynamic Systems 3.2 Adaptive Software Development
Development Method 3.3 Agile Process Model: Scrum Process Flow
3 TLO 3.5: Introduce DevOps 3.4 Dynamic Systems Development Method
TLO 3.6: Describe JIRA (DSDM)
3.5 Introduction to DevOps
3.6 JIRA
3.7 Course Outcome- CO3 Teaching Hours –
08 Marks 10
Software Requirement Engineering
TLO 4.1: Explain core principles of software
engineering. 4.1 Software Engineering Practices and its
TLO 4.2: Describe requirement importance, Core principles,
engineering Communication Practices, Planning
TLO 4.3: Explain different types of Practices, Modelling Practices, Construction
requirements Practices, Software Deployment (Statement
and meaning of each principle)
TLO 4.4: Describe software requirement 4.2 Requirement Engineering: Requirement
specification with its need and characteristics Gathering and Analysis.
4 4.3 Types of Requirements (Functional,
Product, organizational, External
Requirements), Eliciting Requirements,
Developing Use cases, Building requirement
models, Requirement Negotiation,
Validation.
4.4 Software Requirement Specification: Need
of SRS, Format, and its Characteristics.

Course Outcome- CO4 Teaching Hours – 07

Marks 12
Software Modelling and Design
TLO 5.1: Explain translation of requirement
model into Design model 5.1 Translating Requirement Model into Design
TLO 5.2: Describe elements of analysis Model: Data Modelling.
model 5.2 Analysis Modelling: Elements of Analysis
TLO 5.3: Describe concepts of design model.
modelling 5.3 Design Modelling: Fundamental Design
5 TLO 5.4: Describe notations used in data Concept (Abstraction, Information hiding,
flow diagram Structure, Modularity, Concurrency,
TLO 5.5: Explain testing, methods and levels. Verification, Aesthetics)
TLO 5.6:. Describe Contents of test 5.4 Design Notations: Data Flow Diagram
documentation. (DFD), Structured Flowcharts and Decision
Tables
5.5 Testing- Meaning and purpose, Testing
methods - Black-box and White-box, Level

Software Engineering (IT23108) Approved Copy P-23scheme

Government Polytechnic, Mumbai Information Technology
of Testing-Unit Testing, Integration Testing,
User Acceptance Testing
5.6 Test Documentation- Test Case Template,
Test plan, Introduction to defect report, Test
Summary Report

Course Outcome- CO5 Teaching Hours – 10

Marks 12
Software Project Management
TLO 6.1: Describe 4P’s of management
spectrum 6.1 The management spectrum-4P’s
TLO 6.2: Explain metrics for size estimation 6.2 Metrics for Size Estimation: Line of Code
TLO 6.3: Describe construction cost model (LoC), Function Points (FP).
6
6.3 COCOMO (Constructive Cost Model)
TLO 6.4: Explain Risk mitigation, 6.4 Risk Management: Risk Identification, Risk
monitoring, management plan Assessment, RMMM Strategy.
TLO 6.5: Describe testing methods for 6.5 DevOps testing methods.
DevOps.
Course Outcome- CO6 Teaching Hours:07
Marks 08

III. Suggested Micro Project / Assignment/ Activities for Specific Learning / Skills
Development (Self Learning):
IV.Assessment
Methodologies/Tools
Formative assessment (Assessment for Learning)
40 marks

Summative Assessment (Assessment of Learning)

End term examination, Viva-voce, Workshop performance (60 marks)

I. Specification Table:
Distribution of Theory Marks
Unit Topic R U A Total
No Title Level Level Level Marks
Overview of Software Engineering
1 2 2 4 8
Process Models
2 0 4 6 10
Agile Methodology
3 2 2 6 10
4 Software Requirement Engineering 2 4 6 12
Software Modelling and Design
5 2 6 4 12
Software Project Management
6 2 2 4 8

Total 10 20 30 60

Software Engineering (IT23108) Approved Copy P-23scheme

Government Polytechnic, Mumbai Information Technology
COs - POs Matrix Form

Programme
Programme Specific
Outcomes (POs) Outcomes
Course (PSOs)
Outcom PO-5
es (COs) PO-1 Engineerin
PO-3 PO-7
Basic PO-2 Design/ PO-4 g Practices PO-6 Lif PSO PSO PSO
and Proble Developme Engineeri for Society, Project e -1 -2 -3
Disciplin m nt of ng Tools Sustainabil Manageme Lo
e Specific Analys Solutions ity and nt ng
Knowled is Environme Learni
ge nt ng
CO1 3 - - - - - - - - -
CO2 3 - - 2 - - 1 3 - -
CO3 3 3 3 3 3 1 1 3 2 -
CO4 3 3 3 3 3 1 1 - 2 2
CO5 3 - 3 2 - - - 3 - 2
CO6
Legends: - High:03, Medium:02, Low:01, No Mapping: --

II. Suggested Learning Materials / Books

Sr. No Author/ Publisher Title ISBN

1 Software Engineering A Roger Pressman 9780078022128

Practitioner’s Approach
2 Fundamentals of Software Rajib Mall 9788120348981
Engineering
3 Software Engineering Concepts Richard Fairly 9780074631218

4 Software Engineering Deepak Jain 9780195694840

principles and practices

III. Learning Websites & Portals

Sr. No Link / Portal

1 https://www.tutorialspoint.com/software_engineering/index.html
2 http://www.rspa.com/spi/
3 https://nptel.ac.in/courses/106101061
4 https://www.sei.cmu.edu/

Software Engineering (IT23108) Approved Copy P-23scheme

Government Polytechnic, Mumbai Information Technology

IV.Academic Consultation Committee/Industry Consultation Committee:

Sr. Name Designation Institute/Organization

No
1 Ms. Ruchira Warekar Visiting Lecturer Government Polytechnic
Mumbai
2 Ms. Namrata A. Wankhade Lecturer Government Polytechnic
Mumbai
3 Mr. Abhishek Rai Associate Software Engineer Veritas Pvt Ltd Pune

Coordinator, Head of Department

Curriculum Development, Department of Information Technology
Department of Information Technology

I/C, Curriculum Development Cell Principal

Software Engineering (IT23108) Approved Copy P-23scheme