UTTARAKHAND BOARD OF TECHNICAL EDUCATION

JOINT ENTRANCE EXAMINATION AND TRAINING, RESEARCH DEVELOPMENT CELL, DEHRADUN

STUDY AND EVALUATION SCHEME FOR DIPLOMA PROGRAMME

Branch Name: Information Technology
Semester: VI

Total Marks: 1000

Total Credit Points: 35

Additional Information:

• Common with diploma programme in Chemical Technology (Paint) and Chemical Technology (Rubber & Plastic).
• General Proficiency will comprise of various Co-curricular activities like:
  • Games
  • Hobby Clubs
  • Seminars
  • Declamation Contests
  • Extension Lectures
  • Field Visits
  • NCC
  • NSS
  • Cultural Activities
  • G.K., General Study, Elementary Math, and Discipline
• Industrial Visit: Compulsory at a minimum of two industries or departments.

Notes:

1. Each period will be of 50 minutes.
2. Session will be of 16 weeks.
3. Effective teaching will be of at least 12.5 weeks.

Branch Code: 12

Multimedia Application

Rationale

The exponential growth of Engineering and Technology, particularly information and communications engineering, has benefited the day-to-day life of mankind in all respects. The research and developments are continually happening in this field to fine-tune and improve the field, particularly also in multimedia, which directly or indirectly impacts every person’s daily life. As such, the introduction of current and future trends and technology in multimedia systems would strengthen the knowledge and skills of the engineering community, taking one step further toward the prosperity of mankind.

Objectives

• Students will be able to understand the relevance and underlying infrastructure of multimedia systems.
• The purpose of the course is for students to apply contemporary theories of multimedia learning to the development of multimedia products.
• Analyze instructional and informational media (audio/visual materials, web-based materials, games, and simulations, etc.) applied with multimedia techniques.
• Acquire knowledge about multimedia software tools.
• Understand multimedia system components, evolving technologies, and fundamental elements of any multimedia system.
• Acquire knowledge about the fundamentals of handling multimedia data, compression/decompression, and various media file formats.
• Understand the underlying principles of processing various multimedia data.
• Understand the working principles of various multimedia input-output devices.
• Gain knowledge about various multimedia-related standards.
• Understand the design and development process of multimedia projects.
• Understand the technologies of multimedia used in the Internet and its applications.

Detailed Contents

1. Introduction to Multimedia (10 Periods)

• Hardware and software requirements of multimedia
• Hypertext, hypergraphics, hypermedia
• Objects for Multimedia Systems: Image, text, video, audio, graphics, animation

2. Multimedia Hardware (14 Periods)

• Multimedia PC configuration
• Features and specifications of text, images, sound, and video
• Multimedia devices: OCR, touch-screen, scanners, digital cameras, speakers, printers, plotters, optical disks and drives (CD-ROM, DVD)
• Multimedia networks

3. Multimedia Data and Standards (14 Periods)

• Compression schemes and standards (only concepts of):
  • Binary image compression
  • Color, gray scale, and still-video image compression
  • JPEG
  • Video image compression
  • Multimedia standards for video
  • MPEG
  • Audio compression
• Data and file format standards: Popular file formats (RTF, RIFF, GIF, PNG, TIFF, MIDI, JPEG, JFIF, AVI, WAV, BMP, WMF, MIX, MPEG standards)

4. Multimedia Software - Adobe Flash (16 Periods)

• Making simple Flash movie
• Setting properties (frame rate, dimensions, background color)
• Frames and frame buffer concepts
• Keyframe, scene concepts
• Layers and layer properties (normal, guide, mask layers)
• Special effects: Motion tweening, shape tweening, changing color using tint effect
• Importing/exporting movies, sounds, and other multimedia objects
• Publishing Flash movie: SWF, HTML, GIF, JPEG, PNG, and other formats

5. Multimedia Applications (10 Periods)

• Education (use of CAI tool), entertainment, edutainment
• Virtual reality, digital libraries, information kiosks
• Video on demand, web pages, video call, video conferencing

Text Books

1. Fundamentals of Multimedia, Ze-Nian Li and M. S. Drew, Pearson Education, Second Edition, 2014
2. Multimedia: Making It Work, Tay Vaughan, Tata-McGraw Hill, Eighth Edition
3. Multimedia Systems Design, Prabhat K. Andleigh, Kiran Thakra, PHI
4. Multimedia Computing, Communication, and Applications, Ralf Steinmetz and Klara Nahrstedt, Pearson Education
5. Multimedia Communication Systems: Techniques, Standards, and Networks, K.R. Rao, TMH

Reference Books

1. Computer Graphics, Multimedia, and Animation, Malay K. Pakhira, PHI, Second Edition
2. Principles of Multimedia, Ranjan Parekh, TMGH, New Delhi
3. Multimedia Systems, John F. Koegel Buford, Pearson Education
4. Multimedia Technology & Applications, David Hillman, Galgotia Publications Pvt Ltd

Practical Lab: Multimedia Application

Rationale

This practical enables students to develop skills with interactive visual and auditory technology. It prepares students to use digital multimedia for communication, creativity, collaboration, and critical thinking. This lab brings awareness regarding the numerous resources available in multimedia, allowing students to become skilled and creative users of multimedia technology.

Objectives

After completing this lab, students should be able to:

• Create audio hardware and software applications.
• Record and edit digital audio using sound editing software.
• Learn about video editing techniques.
• Apply various filters and compression techniques in multimedia applications.
• Learn about 3D and cloud animation.

List of Experiments

1. Use HTML5 multimedia support to play different audio and video formats in a browser on desktop and mobile.
2. Use audio processing software to:
   • Import audio
   • Select and edit the sound
   • Create fade-in and fade-out effects
   • Label audio segments
   • Apply noise removal filter
   • Mix audio
   • Change stereo to mono tracks
   • Export audio to different formats
3. Use video processing software to:
   • Trim video clips
   • Crop video
   • Rotate video
   • Join video clips
   • Add subtitles
   • Edit video dimensions, bit rate, frame rate, and audio quality
4. Create a movie from video clips demonstrating:
   • Audio-video mixing
   • Music and video effects
   • Video transitions and titles
5. Create a 3D image of an object such as a magnifying glass using 3D software.
6. Create a moving animation using animation software.
7. Use a scanner to create partial scanned images of large posters/photos, and create a panoramic view by stitching them together.
8. Use an audio recording program to record audio from different input sources, applying filters and encoding/compression schemes.
9. Use suitable software to:
   • Compress/decompress audio/video files
   • Convert audio/video to different formats
   • Split, join, and rip audio/video files

Scheme of Evaluation

Suggested Hardware

Suggested Software

Marks Distribution

Suggested Distribution of Marks

.NET PROGRAMMING

RATIONALE

.NET Framework is changing the way developers write applications. .NET Framework provides a number of components to create many types of applications including those for consoles, Windows, mobile units, and the web. Using the .NET framework, the data can be made available anytime, anywhere, and on any device. This subject introduces the basics of .NET Framework. Writing applications on C#.Net is covered in this course. Concepts of developing Window applications using C#.NET are discussed. This course helps to use ADO.NET to write the applications to connect with the back-end database. The subject also enables the users to know the concepts of XML and the XML web services.

OBJECTIVES

On completion of the following units of syllabus contents, the students must be able to:

• List the major elements of the .NET Framework.
• Describe some of the major enhancements to the new version of C#.
• Describe the basic structure of a C#.NET project and use the main features of the integrated development environment (IDE).
• Use the new language features and syntax in C#.NET.
• Explain the basic concepts and terminology of object-oriented design specifically for C#.NET.
• Explain and use the basic concepts and terminology of object-oriented programming in C# .NET.
• Create applications by using Microsoft Windows Forms.
• Create applications that use ADO .NET.
• Create components in C#.NET.
• Set up and deploy various types of C# .NET-based applications.
• Develop Window applications using XML as a back-end database.

DETAILED CONTENTS

1. Introduction To .NET Framework (16 Periods)

1.1 Introduction to .NET framework: Dot Net Architecture – Managed Code and the CLR – Intermediate Language, Metadata and JIT Compilation– Automatic Memory Management.
1.2 Common Language Specification (CLS) – Assembly – Namespace.
1.3 Visual Studio .NET– Using the .NET Framework. Exploring the Visual Studio Integrated Development Environment – System requirement – Versions.
1.4 The Framework Class Library- .NET objects – ASP.NET-.NET web services– Windows Forms.

2. INTRODUCTION TO C# (16 Periods)

2.1 Elements: Variables and constants–data types–declaration. Operators–types–precedence – Expressions – Program flow – Decision statements – if..then, if..then..else, select..case.
2.2 Loop statements– while..end while, do..loop, for..next, for.. each.. next.
2.3 Types: Value data types – Structures, Enumerations. Reference data types – Single dimensional– Multi-dimensional arrays–Jagged arrays– Dynamic arrays.
2.4 Classes & objects – Abstract & override methods object-oriented concepts: abstraction, Inheritance, Polymorphism, Classes, collections, Debugging.

3. Window Application Using Window Forms (16 Periods)

3.1 Windows programming – Creating windows Forms–Working with Toolbox Controls– Button, Check Box, Combo Box, Label, List Box, Radio Button, Text Box, Group Boxes, Picture Box.
3.2 Advanced Controls & Events: Timer, Progress Bar, Month Calendar, Tool Tips, Tab Controls, Panels - Events–Click, Close, Deactivate, Load, Mouse Move, Mouse Down, Mouse Up, Key press, Key Down, Key Up.
3.3 Multiple Document Interface (MDI) Forms – Creating MDI Applications– Creating MDI Child Windows – Arranging MDI Child Windows.
3.4 Multithreading: Thread States, Life cycle of a Thread, Thread Priorities and scheduling, creating and executing Thread, Synchronization and Class Monitor, Exception Handling.

4. Database Connectivity (16 Periods)

4.1 Features of ADO .NET. Architecture of ADO. NET–ADO. NET providers– connection–Command–Data Adapter–Data set.
4.2 Database Programming with ADO .NET: ADO .NET, Database: Connections, Data access techniques, XML Language, SQL, ADO.NET object Model, LINQ to SQL, ADO.NET and LINQ, LINQ to XML.

5. XML AND WEB SERVICES (16 Periods)

5.1 Introduction: Advantages –HTML Vs XML–Browsing and parsing XML– Creating a XML file– Details and–Well formed XML document–XML components-elements– Entities–Comments– Processing instructions– Attributes.
5.2 Creating web services, Web forms, ASP.NET, Request, Response, Server objects creating web reports using ASP.NET using ADO.NET with SQL Server and System .XML.

TEXT BOOKS

1. Programming In C#, 3E E. Balagurusamy Tata McGraw - Hill Education, 2010.
2. Applications of .NET Technology ISRD Group TMGH Education Pvt Ltd., New Delhi 2011.

REFERENCE BOOK

1. Introducing Microsoft .NET David S. Platt Microsoft Press Saarc Edition, 2001.

OBJECTIVES

On completion of the following exercises, the students must be able to:

• Develop and execute simple programs using C#.NET.
• Understand the concepts of event handlers.
• Know the usage of various C#.Net controls.
• Create C#.NET applications using menus.
• Access SQL database by using ADO.NET.
• Use Form controls.
• Create Window applications using C#.NET form controls.
• Develop XML database handling methodologies.

LIST OF EXPERIMENTS

1. Accept a character from console and check the case of the character.
2. Write a program to accept any character from keyboard and display whether it is vowel or not.
3. Write a program to accept a string and convert the case of the characters.
4. Develop a menu-based application to implement a text editor with cut, copy, paste, save, and close operations.
5. Write a program to implement a calculator with memory and recall operations.
6. Develop a form to pick a date from Calendar control and display the day, month, year details in separate text boxes.
7. Develop an application to perform timer-based quiz of 10 questions.
8. Develop a database application to store the details of students using ADO.NET.
9. Develop a database application using ADO.NET to insert, modify, update and delete operations.
10. Develop an application using Data grid to display records.
11. Develop an application using Data grid to add, edit, and modify records.
12. Develop a Window application to read an XML document containing subject, mark scored, year of passing into a Dataset.

SCHEME OF VALUATION

• Writing answer for any one program from PART -A: 10 Marks
• Writing answer for any one program from PART - B: 15 Marks
• Executing program (PART –A): 10 Marks
• Executing program (PART –B): 10 Marks
• Result with printout (PART – A): 5 Marks
• Result with printout (PART – B): 5 Marks
• VIVA - VOCE: 5 Marks
• Total: 60 Marks

HARDWARE REQUIREMENT

1. Network computer Lab.

SOFTWARE REQUIREMENT

1. MS Visual Studio .NET / 2005/2008/2012/2013/2015
2. Microsoft SQL Server 2005/2008 or above.

SUGGESTED DISTRIBUTION OF MARKS

Data Mining & Data Warehousing

Rationale

Data Mining and Warehousing enables middle and top managers to analyze data and explore relationships among the data items which helps them to make informed decisions at the right time. After completing this course, students will understand the concepts, functions, and various techniques of data mining and warehousing, and appreciate their importance in decision-making processes.

Detailed Contents

1. Introduction to Data Mining (16 Periods)

1.1 What is data mining?
1.2 Data mining background, Inductive learning, statistics, machine learning.
1.3 Difference between data mining and machine learning, data mining models, verification model, discovery model.
1.4 Data mining problems/issues.

2. Introduction to Data Warehousing (20 Periods)

2.1 Concept and benefits of data warehousing, types of data, characteristics of a data warehouse, processes in data warehousing.
2.2 Data warehousing and OLTP systems.
2.3 The data warehouse architecture.
2.4 Problems with data warehousing, criteria for a data warehouse.

3. Data Mining Functions (25 Periods)

3.1 Classification, Associations, Sequential/temporal patterns, Clustering/segmentation.

4. Data Mining Techniques (25 Periods)

4.1 Cluster analysis, Induction, decision trees, rule induction, Neural networks.
4.2 On-line analytical processing (OLAP). Examples and comparison of OLAP and OLTP (Online Transaction Processing).
4.3 Data visualization.

5. Data Mining Applications (10 Periods)

5.1 Data Mining Applications and recent trends in data mining.

Text Books

1. Data Mining Concepts and Techniques. Han, M Kamber, Morgan Kaufmann, 2001, ISBN 1-55860-489-8, 2010.
2. Introduction to Data Mining, Hand, Mannila, and Smyth, MIT Press, Cambridge, MA, 2000.

Reference Book

1. OLAP Solutions, Erik Thomsen, John Wiley & Sons, Inc., 1997 (ISBN 0471014931-4), 1997.

Marks Allocation and Time Allotted

Suggested Distribution of Marks

Advance Web Programming

Rationale

The main aim of this subject is to enable the students to know the basic concepts of open source software and tools. The students will learn about the principles of open source software, web servers, databases, operating systems, programming languages, and application development.

Objectives

On completion of the following units of syllabus contents, the students must be able to:

• Understand the need, advantages, and disadvantages of Open Source software.
• Understand the general concepts and modes of Linux Operating System.
• Understand advanced concepts like Scheduling, Time Accounting, Personalities, and coning.
• Know the basic concepts of Open Source Database.
• Know how to connect to MySQL database and close connections.
• Write simple MySQL programs.
• Create databases and tables in MySQL.
• Manipulate database tables in MySQL.
• Understand the concepts of Record Selection technologies.
• Install and Configure PHP on Windows.
• Understand the basic concepts of PHP.
• Understand the String and Array concepts in PHP.
• List the advanced features of PHP.
• Discuss Memory Management, Parameter Handling, and Variables in PHP.
• Understand how to access a database using PHP.
• Discuss advanced database techniques.
• Discuss the Apache Web Server and configuring the server.
• Explain the history and architecture of the Eclipse IDE platform.
• Understand the basics of Python.
• Know the building blocks of Python language.
• Understand the development process of a Python program.
• Understand file handling using Python.

Units & Detailed Contents

1. Open Source Software (10 Periods)

• Introduction: Need of Open Sources, Advantages of Open Sources, Applications, Application of Open Source.

2. PHP (15 Periods)

• What is PHP?
• Basic Syntax of PHP
• Programming in a web environment
• Common PHP Script Elements
• Using Variables, Constants, Data types
• Operators, Statements
• Working with Arrays
• Using Functions
• OOP (Object-Oriented Programming)
• String Manipulation and Regular Expressions
• File and Directory Handling
• Including Files
• File Access
• Working with Forms, Processing Forms, Form Validation
• Simple programs using PHP

3. Database Accessing (15 Periods)

• Introduction to MySQL
• Setting up an account
• Starting, Terminating, and Writing your own MySQL Programs
• Record Selection Technology
• Working with Strings, Date and Time
• Sorting Query Results Module
• Generating Summary
• Working with Metadata
• Using Sequences
• PHP and MySQL Database Connectivity
• Sending and Receiving Emails

4. Basic Features of Python (20 Periods)

• Overview – Installing – Running in Windows/Linux
• Variables and Strings: Data types, Operators, Decision Control, Conditional Statements, Loops
• Example Programs
• Sequences: Lists, Fixed-size lists and arrays, Lists and Loops, Assignment and references, Identity and equality
• Tuples: Tuples and string formatting, String functions
• Sets: Unordered Collections, Simple Programs
• Dictionaries, Sets, Using Modules
• File Handling, Exception Handling

5. Web Server (4 Periods)

• Apache Web Server
• Working with Web Server
• Configuring and Using Apache Web Server (WAMP and XAMP Server)

Text Books

1. Programming PHP by Rasmus Lerdorf and Levin Tatroe, O’Reilly Publications, 2002
2. Web Programming by Chris Bates, Wiley India, New Delhi, Third Edition, Reprint, 2011
3. MySQL Bible by Steve Suchring, John Wiley & Sons, 2002

List of Experiments

PHP:

1. Write a program to create a Student registration form.
2. Write a program to perform EB bill calculation.
3. Write a program to perform Student grade manipulation.
4. Write a program to perform String operations in PHP.
5. Write a program to create Book master form.
6. Write a program to perform Form validation – Railway ticket reservation.
7. Write a program to perform Date and time operations in PHP.
8. Write a program to Identify the web browser.
9. Demonstrate the Database – Insert operation.
10. Demonstrate the Database – Delete operation.
11. Demonstrate the Database – Update operation.

MySQL:

12. Demonstrate the Queries Record selection operation.
13. Write the queries to demonstrate working with date and time functions.

Python:

14. Demonstrate Simple Programming and File handling operation.

Scheme of Valuation

Hardware Requirement

• Desktop Computers – 40 No
• Printer – 2 No

Software Requirements

• Apache server (or) WAMP server (or) XAMP server
• Any text editor
• Browser with JavaScript support

Suggested Distribution of Marks

Project Work

Rationale

Project Work aims at developing innovative skills in the students whereby they apply the knowledge and skills gained through the course by undertaking a project. The individual students have different aptitudes and strengths. Project work should match the strengths of students.

The primary emphasis of the project work is to understand and gain the knowledge of the principles of software engineering practices, so as to participate and manage a large software engineering project in the future.

Objectives:

• Implement theoretical and practical knowledge gained through the curriculum into an application suitable for a real practical working environment.
• Develop software packages or applications to implement the actual needs of the community.
• Get exposure to industrial environments and their work ethics.
• Understand entrepreneurship and how to become an entrepreneur.
• Learn and understand the gap between technological knowledge acquired through the curriculum and actual industrial needs.
• Carry out cooperative learning through synchronous guided discussions, asynchronous document sharing, and collaborative editing of the final project report.
• Expose students to the field of computing and gain experience in software design.
• Understand and gain knowledge about disaster management.

Major Project

Guidelines for Project Formulation:

• Batch Size: Maximum 6 students per batch
• The project should have direct relevance to day-to-day activities in the student’s institution.
• Students are encouraged to work in fields like DBMS, OOPS, Networking, Multimedia, Artificial Intelligence, Expert Systems, and more.

Project Proposal (Synopsis):

The project proposal should include the following:

1. Title of the Project
2. Introduction and Objectives
3. Project Category (DBMS/OOPS/Networking/Multimedia/AI, etc.)
4. Tools/Platform, Hardware and Software Requirements
5. Analysis (DFDs, ER Diagrams, Class Diagrams, Database Design, etc.)
6. Project structure: Modules, Data Structures, Process Logic, Testing, Reports Generation
7. Industry/Client involvement
8. Future scope and limitations of the project.

Scheme of Valuation

Employability Skills

Rationale:

This subject is included to develop employability skills among students. Diploma holders are required not only to possess subject-related knowledge but also soft skills to get good jobs and rise steadily in their workplace.

Detailed Contents:

Unit I: (06 periods)

• Technical Education & Industrial Scenario.
• Competency required of an engineer.

Unit II: (06 periods)

• Professional Engineer Values, Ethics, and Development.
• Relationship between engineering profession, society, and environment.

Unit III: (12 periods)

• Effective Communication: Reading & Active Listening Skills, Speaking, Writing, Presentation, Group discussion.

Unit IV: (12 periods)

• Managing Projects: Leadership, Motivation, Time Management, Resource Management, Interpersonal Relationships.

Unit V: (10 periods)

• Preparing for Employment: Searching for a Job, Resume Writing, Interview Techniques.

Unit VI: (08 periods)

• Self-Management: Self-Awareness, Stress Management, Conflict Resolution.

Unit VII: (06 periods)

• Creativity, Innovation, and Intellectual Property Rights.

Unit VIII: (04 periods)

• Rules & Ethics for Engineers.

Suggested Distribution of Marks

Practical Exercises:

• Steps to write different types of letters.
• Creating a PowerPoint Presentation.
• Creating an effective resume.
• Conducting a telephonic/online interview.
• Study of stress management techniques.
• Study of workplace rules and ethical practices.

Suggested Books:

• Employability Skills by Kapil Dev, Vishnu P. Singh, Asian Pub, New Delhi.
• Employability Skills for Diploma Students by Dr. S.K. Singh, Vayu Education, New Delhi.

Implementation and Learning Outcomes

Assignments, PowerPoint presentations, class tests, individual and group activities, case studies, etc. will ensure learning outcomes based on the aforementioned modules and topics.