IT010 701 FINANCIAL MANAGEMENT AND E-BANKING
Teaching scheme Credits:
4
2 hours lecture and 2 hour tutorial per week
Objective
• To understand
the basic concepts of Accounting, book keeping, costing, fund flow and e-
banking
MODULE I (12
hours)
The basic concepts
of Accounting: The separation of ownership and control, The users of accounts, Computers and users of accounts, Accounting concepts
and
conventions,
Accounting equation, Balance sheet, Classifying
items, The processing function.
MODULE II (12
hours)
Book-Keeping: The double-entry system, Double-entry
of
expenses,
Asset
of
stock,
Capital and revenue expenditure, Balancing accounts on computers,
The trial balance, The final accounts, Depreciation, Bad debts and provision for bad debts, Division of the
ledger, Books of original entry, Source documents, Accounting systems, Interpretation of accounts.
MODULE III (12
hours)
Costing: Cost Accounting, Classifying costs, The implications for programming,
The operating statement, the cost of raw materials, the cost of direct
labour, the cost of
overheads, job costing, Break-even analysis, Break-even graphs, Budgeting, Standard costing, Variance analysis, Marginal costing. Ratio Analysis: Ratio meaning,
profitability ratios, profit in relation to sales, profit in relation to investments, Liquid ratios, Solvency
ratios, other ratios, Activity ratios, Eps, DuPont Financial
analysis, ratios for predicating
bankruptcy, Inter-fim comparison, ratios limitations.
MODULE IV (12
hours)
Fund Flow Statement:
Meaning,
Importance, Definition of terms, Funds and Flow, Sources and use of funds, Changes
in
working
capital,
Preparation
of
funds
flow
statements, cash flow statements,
Sources
and
uses,
preparation.
Cost
Reduction:
Difference between cost control and cost reduction, Prequisites for an effective cost reduction, Concept of value analysis-
crux
of
the
cost
reduction, steps involved in introducing a cost
reduction
program, some
examples of cost reduction, Common limitations.
MODULE V (12
hours)
E-Banking: Changing Dynamics in the Banking
Industry, Changing Consumer Needs,
Cost Reduction, Demographic Trends,
Regulatory Reform, Technology Based Financial
services products. Home Banking
Implementation Approaches, Home Banking
Using Bank’s Proprietary Software,
Banking via the PC Using Dial-Up
Software, Banking via Online Services, Banking via the Web: Security First Network Bank. Open versus Closed
Models, Management Issues in Online Banking,
Differentiating Products and Services,
Managing Financial Supply Chains, Pricing Issues in Online Banking, Marketing Issues:
Syllabus- B.Tech. Information Technology
Mahatma Gandhi University
Attracting Customers, Keeping Customers, Back-Office Support
for Online Banking, Integrating Telephone Call Centers with the Web.
Reference Book
1. R K Sharma and Shasi K Gupta ”Management Accounting Principles And Practice”, Kalyani
Publishers.
2. Khan and Jain, ” Theory and Problems in Financial
Management”, Tata Mc Graw Hill
3. Eugene
.F. Brigham & Joel F Houston,” Fundamentals of Financial
Management”, Thomson
Learning.
4. P.H. Basset,t ” Computerised
Accounting”, NCC Blackwell Ltd. , Oxford, 1994
5. M.C Shukla & T.S.Grewal,” Advanced
Accounts”, S.Chand & Co. , New Delhi
6. Ravi Kalkota,Andrew B. Whinston,”Electronic Commerc A Manager’s Guide”,
Pearson
Education 2006.
7. Nand
Dharmeja & K.S. Sastry,
“Finance & Accounting for ,Managerial Competiveness”, Weeler Publishing, Allahabad
Syllabus- B.Tech. Information Technology
Mahatma Gandhi University
IT 010 702 : Object
Oriented Modeling and Design
Teaching scheme Credits:
3
2 hours lecture and 1 hour tutorial per week
Objective
• To impart ideas on building systems through the object
oriented modelling
approach using the Unified Modelling Language.
Module 1 (10 hours)
Introduction: object oriented development-modeling concepts –
object
oriented methodology – models – object oriented themes-Object Modeling–
links and associations
– advanced links and association concepts
– generalization and inheritance
- grouping constructs – a sample object model
Advanced Object Modeling:
aggregation – abstract
classes – generalization as extension and restriction – multiple inheritance – metadata
– candidate keys – constraints.
Module 2 (10 hours)
Dynamic modeling: Events and states – Operations – Nested
state
diagrams – Concurrency – Advanced dynamic modeling
concepts – A sample dynamic model – Relationship of Object and Dynamic models.
Functional modeling: Functional models – Data Flow Diagrams
- Specifying operations
– Constraints – A sample
functional
model – Relation of functional to Object
and
Dynamic models.
Module 3 (10 hours)
Analysis: Analysis in object modeling, dynamic
modeling and functional modeling, Adding operations- Iterating the analysis
System Design: Breaking system into subsystems - Identifying concurrency-allocating subsystems
to
processors
and
tasks,
managing
of
data
stores.
Handling
of
global
resources- handling boundary conditions-Common Architectural Frameworks
Module 4 (8 hours)
Object Design: Overview of Object design – Combining the three models – Designing
algorithms – Design optimization – Implementation of control
–
Adjustment of inheritance - Design of association
–
Object
representation
–
Physical
packaging
–
Documenting design decisions-Comparison
of methodologies
Module 5 (7 hours)
Unified Modeling language: Introduction, UML Diagrams – Class diagrams, Sequence diagrams, Object
diagrams, Deployment diagrams, Use case diagrams, State
diagrams, Activity diagram,
Component diagrams – Case Study.
Syllabus- B.Tech. Information Technology
Mahatma Gandhi University
Reference Book
1. Object Oriented
Modeling and Design -James Rumbaugh,
Prentice Hall India
2. UML Distilled – Martin Fowler, Addison Wesley
3. Object- oriented
Systems analysis and design using UML- 4th ed., Simon Bennet,Stephen
McRobb, Ray Farmer. TMH.
4. Object Oriented
Analysis and Design with Applications - Grady Booch, Pearson Education
Asia
Mahatma Gandhi University
IT010 703 COMPUTER GRAPHICS & MULTIMEDIA
SYSTEMS
Teaching scheme Credits:
4
2 hours lecture and 2 hour tutorial per week
Objective
• To understand
the basic concepts of Computer
Graphics & multimedia techniques.
Module 1: (13 hours)
Introduction to Computer
Graphics : Uses of Computer Graphics, Display Devices,
Input Devices, Output
Devices, Computer Graphics
Software, Graphical
User Interface, Line Drawing
Algorithms – DDA,
Bresenham’s Line Algorithm, Bresenham’s Circle
Algorithm. Polygon Filling Algorithm
– Scan Conversion, Seed Filling Algorithm
Module 2: (13 hours)
Geometrical Transformations: Transformation of Points,
Straight
Lines,
Midpoint,
Parallel Lines, Rotation,
Reflection
and
Scaling
of
Straight
Lines,
Homogeneous Coordinates, Cohen Sutherland Line Clipping.
Module 3: (12 hours)
Rendering: Hidden surface Removal Algorithm- Z Buffer Algorithm, A- Buffer Algorithm, Hidden Line Removal Algorithm, Colour Models,
Z-Flat Shading, Gouraud Shading.
Module 4: (11 hours)
Multimedia: Media and
Data
Streams,
Properties of Multimedia,
Traditional
Data
Stream Characteristics, Music,
Speech, Images and
Graphics, Computer Image
Processing
Module 5: (11 hours)
Data Compression: Storage space,
Coding Requirement, JPEG, H.261,
MPEG, DVI, Multimedia Operating Systems – Real Time, Resource Management, Process Management
Reference Book
1. Amarendra
N’ Sinha and Arun D Udai, “Computer
Graphics”,The McGraw-Hill Companies.
2. Ralf
Steinmetz and
Klara
Nahrstedt, “Multimedia: Computing, Communications & Applications”, Person Education Asia.
3. Donald Hearn & Pauline Baker,
“Computer Graphics”, Prentice Hall India.
4. Foley, VanDam,
Feiner,
Hughes,
“Computer Graphics Principles
&
Practice”,
Second
Edition, Addison Wesley.
5. Ranjan
Parekh, “Principles of Multimedia”, The McGraw-Hill Companies.
Syllabus- B.Tech. Information Technology
Mahatma Gandhi
University
Syllabus- B.Tech. Information Technology
Mahatma Gandhi University
IT010 704: INTERNETWORKING
Teaching scheme Credits:
3
2 hours lecture and 1 hour tutorial per week
Objective
• to familiarize with
the TCp/IP protocol suite, the different
protocols used in each layer, and
their implementation
Module 1 (9 hours)
Internet Architecture, Classful Internet
Addresses,
Mapping Internet
Addresses
to
Physical addresses (ARP), Determining
an
Internet
address at start-up (RARP), Connectionless Datagram
Delivery (IPV4) , Forwarding IP datagrams.
.
Module 2 (9 hours)
Error and Control Messages ( ICMP ),Classless and Subnet Address Extensions (CIDR), Protocol Layering, User datagram Protocol,
Reliable Stream Transport Service.
Module 3 (9 hours)
Routing Architecture
: Cores, Peers, and Algorithms,
Routing Between Peers (BGP), Routing Within
an Autonomous System (RIP,
OSPF).
Module 4 (9 hours)
Internet Multi casting, IP Switching and MPLS, Private Network Interconnection (NAT, VPN), Bootstrap and Auto configuration (DHCP).Applications - DNS, Remote Login
and Desktop (TELNET, SSH)
Module 5 (9 hours)
File Transfer and Access ( FTP, TFTP, NFS) , Electronic Mail ( SMTP, POP, IMAP,
MIME), WWW (HTTP), Voice and Video Over IP (RTP, RSVP, QoS).
Reference Book
1.
Internetworking with TCP/IP - Volume I, Principles, Protocols and Architecture (5th Edition), Douglas
E.Comer, PHI 2009
2. The Internet and Its Protocols, Adrian Farrel,
Elsevier 2005.
Syllabus- B.Tech. Information Technology
Mahatma Gandhi University
IT010 705 WEB
APPLICATIONS DEVELOPMENT
Teaching scheme Credits:
3
2 hours lecture and 1 hour tutorial per week
Objective
• to
familiarize with the technologies used for
the devolepment of Web applications
Module 1 (9 hours)
Introduction - Web
architecture - web application
lifecycle
-
XML and J2EE. Design and development of a J2EE
application - J2EE Layers, Application
Components, J2EE Architecture, Development methodology - Task list for building J2EE Applications - database
design - defining the application - creating the interface, building pages, creating data access objects, validating the code..
Module 2 (10 hours)
JDBC: Architecture - JDBC API, Retrieving and updating Data, SQL-to-Java Data Types, JDBC
Execution
Types,
Metadata,
Scrollable Resultsets, transaction
support,
Batch Statements. Servlets: Introduction
to
Servlets, Benefits of Servlets,
use as controller in MVC, basic HTTP, servlet container, Servlets API, javax.servelet Package,
Reading Servlet parameters, service
method detail, HTML clients,
servlet
lifecycle,
HTTP response header, session management, dispatching requests,
Servlets with JDBC,
web applications.
Module 3 (10 hours)
Java Server Pages:
Generating Dynamic
Content, Using Scripting Elements, Implicit JSP
Objects, Conditional Processing
– Displaying Values, Setting attributes, Error Handling and Debugging, Using JavaBeans
Components in JSP Pages, Sharing Data Between JSP pages -Passing Control and Data between Pages – Sharing Session and Application Data – Application
Models - MVC Design.
Module 4 (7 hours)
Enterprise JavaBeans : Overview, distributed programming, EJB framework,
Session
and entity beans, Stateless and tateful
session
bean, Bean attributes, Parts
of a Bean, container-managed persistence (CMP) and bean managed - lifecycle of EJB
Module 5 (9 hours)
java message
service
(JMS)
and
message driven beans (MDB), distributed
programming services, CORBA and RMI - Transaction management, Security, deployment, personal roles
for EJB Development, building
session beans
- creating session beans - Entity beans.
Syllabus- B.Tech. Information Technology
Mahatma Gandhi University
Reference Book
1. J2EE UNLEASHED – Joseph J. Bambara, Paul R.Allen, Mark Ashnault, Ziyad Dean, Thomas
Garben, Sherry Smith – SAMS Techmedia
2.
Java Servlet Programming, Second Edition,Jason Hunter, William Crawford,O'Reilly Media
3.
Mastering EJB(2nd Edition ) – Ed Roman, Scott Ambler, Tyler Jewell – John Wiley
Publications 2003.
4.
The J2EE Tutorial- Stepahnie Bodoff, Dale Green, Kim Hasse, Eric Jendrock, Monica
Pawlan,
Beth Stearns-Pearson Education
–Asia.
5. Java Server Pages –Hans Bergsten, SPD O’Reilly
Syllabus- B.Tech. Information Technology
Mahatma Gandhi University
IT010 706L01 SOFTWARE PROJECT MANAGEMENT
Teaching scheme Credits: 4
2 hours lecture and 2 hour tutorial per week
Objectives
Pre-requisites: IT 010 604 Software Engineering
Module 1 (12 hours)
Software Project, Contract
Management and Technical Project Management, Activities of Software
Project
Management, Categorizing
Software Projects, Problems with Software Projects, Management Control, Step Wise Project Planning, Programme Management, Managing the Allocation of Resources within Programmes,
Strategic
Programme
Management, Aids to
Programme Management, Benefits Management, Cost-Benefit Analysis, Cash Flow forecasting, Cost-Benefit Evaluation Techniques, Risk Evaluation.
Module 2 (12 hours)
Technical
Plan
Contents
List,
Structure Versus
Speed of Delivery, The
Waterfall Model, The V-Process Model, The Spiral Model,
Software Prototyping, Incremental Delivery, Dynamic Systems
Development Method, Extreme Programming, Software
Effort Estimation Techniques, Estimating
by
Analogy,
Albrecht
Function
Point Analysis, Function Points
Mark II, COSMIC Full Function
Points, COCOMO.
Module 3 (12 hours)
Objectives of Activity Planning, Project
Schedules,
Sequencing ad Scheduling
Activities, Network
Planning
Models,
The Forward
Pass,
The
Backward
Pass, Identifying the Critical Path,
Activity Float, Activity-on-arrow
Networks, Categories
of Risk,
Risk
Identification, Risk Assessment, Risk
Planning,
Risk Management, PERT, Monte Carlo Simulation, Critical Chain Concepts.
Module 4 (12 hours)
Resource Requirements,
Scheduling Resources, Creating Critical Paths, Resource
Schedule,
Cost
Schedules, The Scheduling Sequence, Project Control Cycle, Visualizing
Progress, Cost Monitoring, Earned Value Analysis, Prioritizing Monitoring, Change Control.
Module 5 (12 hours)
ISO 12207, The Supply Process, Types of Contract, Stages in Contract Placement,
Contract Management, Organizational Behaviour, Motivation, The Oldham-Hackman Job Characteristics Model, Decision Making, Leadership, Organizational structures, Dispersed and Virtual Teams, Software Quality, ISO 9126, Software Quality Measures, Product Versus Process Quality Management, Quality Pans.
Syllabus - B.Tech. Information Technology
Mahatma Gandhi University
Reference Books
1. Bob Hughes and Mike Cotterell, “Software Project
Management”, Fourth Edition, Tata McGraw-Hill, New Delhi, 2006.
2. Richard H Thayer, “Software Engineering Project Management”, Second Edition, Wiley India, 2004.
3. Cleland D.L
&
King
W.R, “System Analysis And
Project Management”, Tata
Mcgraw Hill
4. Meredith J.R, “Project Management-A Management Approach”, Wiley-NY.
5. Charles.S.Parker, “Management Information Systems – Strategy and Action”,
Tata
Mcgraw Hill
Syllabus - B.Tech. Information Technology
Mahatma Gandhi University
IT010 706L02 OPTICAL
COMMUNICATION NETWORKS
Teaching scheme Credits: 4
2 hours lecture and 2 hour tutorial per week
Objectives
• To understand applications
of Optical fiber communication.
• To understand working of Optical Fiber Networks .
• To provide an insight into the working, analysis and design of basic
Optical communication networks
Module 1 (12 hours)
Introduction-Need for
Fiber Optic Communications
System, Role of Fiber Optic communication technology, Basic Block Diagram, Advantages & Disadvantages of Optical Fiber Communication,
Ray Theory,
Total internal reflection-Acceptance angle –
Numerical
aperture – Skew rays –Electromagnetic mode theory of optical propagation –
EM waves – Step
Index
Fiber,
Graded
Index
Fiber,
Attenuation- Bending Losses,
Scattering, Absorption-
modes in Planar guide – phase and group velocity – cylindrical fibers
– SM ,MM fibers.
Module 2 (12 hours)
Optical sources: Light Emitting Diodes - LED structures – LASER Diodes, Principle of action,
characteristics,
efficiency.
Detectors:
PIN Photo
detectors,
Avalanche photo diodes, characteristics and properties, Photo detector noise
-Noise
sources,
Signal to Noise
ratio.
Module 3 (12 hours)
Fiber optic receiver and measurements:-
Fundamental receiver operation, Pre amplifiers, Error sources – Receiver Configuration – Probability of Error – Quantum limit.OTDR- Fiber Attenuation
measurements- Dispersion
measurements
–
Fiber Refractive index profile measurements – Fiber cut- off Wave length Measurements – Fiber Numerical Aperture Measurements – Fiber diameter measurements
Module 4 (12 hours)
Optical fiber connectors:- Splicing, Connectors, components
of
Fiber
Optic Networks, Transceivers, Semiconductor, optical amplifiers – Principle of operation, gain, Bandwidth, Cross talk, Noise, Applications, Advantages& Disadvantages.
Module 5 (12 hours)
Optical networks :- Basic Networks – SONET / SDH – WDM-Broadcast and select
WDM Networks –Wavelength Routed Networks – Non linear effects on Network performance – Erbium Doped Fiber Amplifiers (EDFAs) – Operation, gain, noise-
Components of EDFA module- Performance of WDM + EDFA
system – Optical CDMA – Ultra High Capacity Networks.
Syllabus - B.Tech. Information Technology
Mahatma Gandhi University
Reference Books
1. Optical Fiber Communication
–
John M. Senior
–
Pearson Education
–
Second
Edition. 2007
2. Optical Fiber Communication
– Gerd Keiser – Mc Graw Hill – Third Edition.
2000
3. J.Gower, “Optical Communication System”, Prentice Hall of India, 2001
4. Rajiv Ramaswami, “Optical Networks “ , Second Edition, Elsevier , 2004.
5. Govind P. Agrawal, “ Fiber-optic communication
systems”, third edition, John Wiley
& sons, 2004.
Syllabus - B.Tech. Information Technology
Mahatma Gandhi University
IT010 706L03 DIGITAL SPEECH AND IMAGE PROCESSING
Teaching scheme Credits: 4
2 hours lecture and 2 hour tutorial per week
Objectives
Pre-requisites: IT 010 602 Digital Signal Processing
Module 1 (12 hours)
Speech Analysis: Speech processing model, Speech analysis, Estimation frequency,
Spectrum
of speech using DFT, Linear predictive Analysis.
Module 2 (12 hours)
Speech Recognizer and Production:
Speech synthesizer,
Linear predictive
synthesizer, Different
methods of speech recognition and speech encoding.
Module 3 (12 hours)
Mathematical Transform
and Enhancement: Image Transforms, Image enhancement, Restoration
Module 4 (12 hours)
Image Compression and Segmentation:
Compression Models, Lossy compression,
Image Segmentation, Boundary detection, Detection of Discontinuities, Thresholding Boundary
representation, Description, Introduction
to Classifiers,
Introduction
to
Colour image
processing.
Module 5 (12 hours)
Image Analysis: Morphology, Automated Image Analysis, Semantic Networks, Production (expert system).
Reference Books
1. R. Gonzalez and R.E.Woods, “Digital Image Processing”, Addison
Wesley, 1993.
2. Rabiner, “Speech Recognition”, Prentice Hall, 1993.
3. S Jayaraman,
S.
Essakirajan, T Veerakumar,
“Digital Image
Processing”, First
Edition, TMH,2009.
4. Rabiner and Schaeffeer, “ Digital Processing of Speech Signals”, Prentice Hall, 1995.
5. Anil Jain K. “Fundamentals of Digital Image Processing”, Prentice
Hall India, 1999.
Syllabus - B.Tech. Information Technology
Mahatma Gandhi University
IT010 706L04 Real Time
Systems
( Common to CS010 706L01 : Real
Time Systems)
Teaching scheme Credits: 4
2 hours lecture and 2 hour tutorial per week
Objectives
• to learn , real-time
operating systems,
task scheduling,
communication, fault tolerant techniques and , programming languages
Module 1 (12
hours)
Introduction to Real Time Systems: Structure of real time systems, real time computer, task classes – Periodic, Aperiodic, critical, Non-critical, definition of real time systems – real time systems, embedded systems - Hard real time systems, soft real time
systems, real time design issues.
Module 2 (12 hours)
Task Assignment
and
Scheduling:
Uniprocessor scheduling algorithms
–Rate monotonic Scheduling, Preemptive Earliest
Deadline
First
(EDF),
IRIS
Tasks. Scheduling Aperiodic and Sporadic jobs in Priority
Driven Sytems, Task Assignment- Utilization
Balancing algorithm, Next Fit Algorithm for RM scheduling, Bin Packing
for EDF,
Myopic Offline Scheduling(MOS), Focused Addressing
and Bidding, Buddy strategy. Fault Tolerant scheduling.
Module 3 (12 hours)
Communication – Communication Media and message sending topologies, network architecture issues, protocols – contention – based, token - based, stop and go multi loop,
polled bus, hierarchal round
robin,
fault
tolerant
routing
–
clocks
and synchronization– fault tolerant
synchronization in hardware, synchronization in software.
Module 4 (12 hours)
Fault tolerance – definition, cause of failure, fault types, fault detection
and containment, redundancy – hardware, software, time, information, integrated failure handling. Reliability Evaluation techniques-
Obtaining parameter values, Reliability models for Hardware redundancy, software error models.
Module 5 (12 hours)
Programming Languages
and
Real
Time databases
– Desired
language characteristics, Data Typing, Control Structures.
Real time databases, characteristics,
main
memory databases, Transaction, Disk schedule algorithms, Databases for hard real time systems, maintaining serialization constituency.
Syllabus- B.Tech. Information Technology
Mahatma Gandhi University
References
1. Real Time Systems - C.M Krishna, Kang G. Shini (Tata McGraw Hill)
2. Real Time Systems- Jane W.S. Liu(Pearson)
Syllabus- B.Tech. Information Technology
Mahatma Gandhi University
IT010 706L05 Operating System Kernel Design
( common to CS010 706L03: Operating System Kernel Design)
Teaching scheme Credits: 4
2 hours lecture and 2 hours tutorial per week
Objectives
• To provide knowledge about the operating system working principles.
• To discuss most of the significant data structures and algorithms
used in the kernel.
Module I (13 hours)
Basic Operating System Concepts – Kernel – Types: monolithic, microkernel – An Overview of
Unix Kernels-The Process/Kernel
Model,
Reentrant Kernels – Signals sending
and receiving – System calls – System Call
Handler
and Service Routines
-
Interrupts and Exceptions - Interrupt Handling
- The Timer Interrupt Handler.
Module II (13 hours)
Processes - Process
Descriptor - Process State, Process relationship – Creating Processes - Process Termination - Process Scheduling – Scheduling algorithm – SMP Scheduler.
Kernel Synchronization - Synchronization Techniques - Process Communication - System V
IPC.
Module III (10 hours)
Paging in Linux - Memory Management - Page Frame Management - The Buddy System Algorithm - The Process's Address Space - The Memory Descriptor - Memory Regions - Page Fault Exception Handler.
Module IV (14 hours)
Overview of the Unix File System - The Virtual
File System - role of the VFS - VFS Data
Structures – File system Mounting.
The Ext2 File
system
-
Disk
Data
Structures - Creating the
File system
-
Data
Blocks
Addressing - Allocating a Data Block.
Module V (10 hours)
Managing I/O Devices - Associating Files with I/O Devices - Device Drivers - Character
Device - Block Device.
Disk Caches - Buffer Cache - Writing Dirty Buffers to Disk - Page Cache.
Reference Books
1) Daniel P. Bovet, Marco Cesati, Understanding
the
Linux Kernel,
First
ed., O'Reilly, 2000
2) M Bech et al., Linux Kernel Internals, 2nd ed., Addison-Wesley, 1998
3) Maurice
J. Bach,
The Design
of
the Unix
Operating
System,
First
Edition,
Pearson Education, 1999.
4) Abraham Silberschatz, Peter B.Galvin and Greg Gagne, “Operating System
Concepts”, John Wiley & Sons Inc, 8th Edition 2010.
Syllabus - B.Tech. Information Technology
Mahatma Gandhi University
Syllabus - B.Tech. Information Technology
Mahatma Gandhi University
IT010 706 L06 Data Mining and Data Warehousing
Teaching scheme Credits: 4
2 hours lecture and 2 hour tutorial per week
Objectives
• This course deals
with
the
representation of multidimensional data for
Data warehouses
• It covers basics of data mining, clustering and classification and applications of data mining
Pre-requisites: IT 506 Database Management Systems
Module 1. (11 hours)
Evolution of Decision Support
Systems- Data warehousing Components –Data warehouse, Data Warehouse and DBMS,
Data marts, Metadata,
Multidimensional data model,
OLAP ,OLTP, Data cubes,
Schemas
for
Multidimensional
Database:
Stars, Snowflakes and Fact constellations
Module 2. (12 hours)
Types of OLAP servers, 3–Tier data warehouse
architecture, distributed and virtual data warehouses. Data warehouse implementation, tuning
and testing of data warehouse. Data Staging
(ETL)
Design
and
Development, data warehouse visualization, Data Warehouse
Deployment, Maintenance, Growth, Business Intelligence Overview-
Data
Warehousing
and
Business Intelligence Trends - Business Applications- tools-SAS
Module 3. (12 hours)
Data mining-KDD versus data mining, Stages of the
Data Mining Process-task
primitives, Data Mining Techniques -Data mining knowledge representation – Data mining query languages, Integration of a Data Mining System with a Data Warehouse
– Issues, Data preprocessing – Data cleaning,
Data transformation, Feature selection,
Dimensionality reduction, Discretization and generating - Mining frequent patterns- association and correlation.
Module 4. (13 hours)
Decision Tree Induction - Bayesian Classification – Rule Based Classification by Back
propagation – Support Vector Machines – Associative Classification – Lazy
Learners – Other
Classification Methods – Clustering techniques – , Partitioning
methods-
k-means- Hierarchical
Methods - distance-
based
agglomerative
and divisible
clustering, Density-Based Methods
– expectation maximization -Grid
Based Methods – Model-Based
Clustering Methods – Constraint – Based Cluster Analysis – Outlier Analysis
Module 5. (12 hours)
Multidimensional analysis and descriptive
mining of complex data objects
- Spatial mining - Multimedia mining - Text mining - Web mining - Temporal mining.
Syllabus - B.Tech. Information Technology
Mahatma Gandhi University
TEXT BOOKS:
1. Jiawei Han and Micheline Kamber, “Data Mining: Concepts and Techniques”, Morgan Kaufmann Publishers,
third edition2011, ISBN: 1558604898.
2. Alex
Berson and Stephen J. Smith, “ Data Warehousing, Data Mining & OLAP”, TataMc Graw Hill Edition, Tenth Reprint 2007.
3. G. K. Gupta, “Introduction to Data Min Data Mining with Case Studies”, Easter
Economy Edition, Prentice Hall of India, 2006.
4. MargaretH. Dunham, S.Sridhar,
“Data Mining : Introductory and Advanced Topics”, Pearson Education
REFERENCES:
1. Mehmed kantardzic, “Datamining concepts,models,methods, and algorithms”, Wiley
Interscience, 2003.
2. Ian Witten, Eibe Frank, “Data Mining; Practical Machine Learning Tools and
Techniques”, third edition, Morgan Kaufmann, 2011.
3. George
M Marakas, “Modern
Data Warehousing,
Mining and Visualization”, Prentice Hall, 2003
Syllabus - B.Tech. Information Technology
Mahatma Gandhi University
IT010 707 INTERNETWORKING LAB
Teaching scheme Credits: 2
3 hours practical per week
• Familiarization of Network hardware such as NIC, Hub, Bridge, Switch, Router etc
• Familiarization of different Network Cables- Color coding -
Crimping.
• Familiarization of Wireless Access Point.
• LAN Configuration – IP Addressing – Host name - Domain Name – Setting up – Configuring – testing and troubleshooting
• Wireless LAN Configuration
• Experiments using Router and Switch
¾ Basic
router configuration.
¾ Implementing static routing.
¾ Implementing dynamic routing using RIP
¾ Implementing dynamic routing using OSPF
¾ Implementing dynamic routing using EIGRP
¾ Basic switch configuration
¾ VLAN configuration
¾ VTP, VTP pruning.
¾ Implement inter-VLAN routing
¾ Backup and recovery of configuration files of a router using TFTP server.
¾ Access Control List (Standard and Extended)
¾ Configuring PPP.
• Design, Configure and implement a WAN scenario which explains
all concepts discussed above.
IT010 708 COMPUTER
AIDED SOFTWARE ENGINEERING
LAB
Teaching scheme Credits: 2
3 hours practical per week
1. Study of case tools such as rational rose or equivalent tools
2. Requirements
Implementation of requirements
engineering activities
such as elicitation, validation, management using case tools
3. Analysis and design
Implementation of analysis and design using case tools.
4. Study and usage
of software project management tools such cost estimates
and scheduling
5. Documentation generators - Study and practice of Documentation generators.
6. Data modeling using automated tools.
7. Practice reverse engineering and re engineering using tools.
8. Exposure towards test plan generators, test
case
generators, test coverage and software metrics.
9. Meta modeling and software life cycle management.
IT 010 709 Seminar
Teaching scheme credits: 2
2 hours
practical per week
The seminar power point presentation shall be fundamentals
oriented and advanced topics in the appropriate branch of engineering with references of minimum seven
latest international journal papers having high impact factor.
Each presentation is to be planned for duration of 25 minutes
including a question answer
session of five to ten minutes.
The student’s internal marks for seminar will be out of 50. The marks will be awarded based on the presentation
of the seminar by the students
before an evaluation committee consists
of a minimum of 4 faculty members. Apportioning of the marks towards
various aspects of seminar (extent
of literature survey, presentation skill, communication skill, etc.) may be decided by the seminar evaluation committee.
A bona fide report on seminar shall be submitted at the end of the semester. This report shall include,
in addition to the presentation materials, all relevant supplementary materials
along with detailed answers to all the questions
asked/clarifications sought during presentation. All references must be given toward the end of the
report. The seminar report should also be submitted for the viva-voce
examination at the end of eighth
semester.
For Seminar, the minimum for a pass shall be 50% of the total marks
assigned to the
seminar.
IT 010 710 Project
Work
Teaching scheme credits: 1
1 hour
practical per week
Project work, in general, means design and development of a system with clearly specified objectives. The project is intended
to be a challenge
to intellectual and innovative abilities and to give students
the opportunity to
synthesize and apply the knowledge
and
analytical
skills learned in the different disciplines.
The project shall be a prototype; backed by analysis and simulation etc. No project can be deemed to be complete without having an assessment of the extent to which the objectives are met. This is to be done through proper test and evaluation, in the case of developmental work, or through proper reviews in the case of experimental investigations.
• The project work has to be started
in the seventh semester
and to be continued on to eighth semester.
• Project work is to be done by student
groups. Maximum of four students only are permitted in any one group.
• Projects are expected to be proposed
by the students. They may also be proposed by faculty member (Guide)
or jointly by student and faculty member.
• Students are expected to finalise project themes/titles
with the assistance of an identified faculty member as
project guide during the first week of the seventh semester.
The progress from concept to final
implementation and testing, through
problem definition and the selection of alternative solutions
is monitored. Students build self confidence, demonstrate
independence, and develop professionalism by successfully completing the project.
Each student shall maintain a project work book. At the beginning of the project, students are required to submit a project
plan in the project book. The plan should not exceed 600 words but should cover the following matters.
™ Relevance of the project proposed
™ Literature survey
™ Objectives
™ Statement of how the objectives are to be tackled
™ Time schedule
™ Cost estimate
These proposals are to be screened by the evaluation committee (EC- minimum of 3 faculty members including the guide) constituted by the head of department, which will include a Chairman and the EC will evaluates the suitability and feasibility
of the project proposal. The EC can accept, accept
with modification, request a
resubmission, or reject a project proposal.
Every activity done as part of project work is to be recorded
in the project book, as and when it is done. Project guide shall go through these records periodically, and give suggestions/comments in writing in the same book.
The students have to submit an interim report, along with project work book showing details of the work carried out by him/her and a power point presentation at the end of the 7th semester to EC. The EC can accept, accept with modification, request
a resubmission, or extension of the project.
The student’s internal marks for project will be out of 50, in which
30 marks will be based on day to day performance assessed
by the guide. Balance 20 marks will be awarded based on the presentation of the project
by the students before an evaluation committee consists of a minimum
of 3 faculty members including the guide.
For Project, the minimum for a pass
shall be 50% of the total marks
assigned to the Project work.
