Syllabus of Gujarat Technical University 5th Sem It

Syllabus of Gujarat Technical University 5th Sem It





Subject Name: Computer Network

Subject Code: 150702


1. Introduction :

Uses of computer network, Network hardware, Network software, OSI model, TCP/IP model, Comparison of OSI and TCP/IP model, Example network: The internet, X.25, Frame Relay, ATM, Ethernet, Wireless LANs: 802.11.


2. The Physical Layer:

Bandwidth, Maximum data rate of a signal, Guided and unguided transmission media.


3. The Data Link Layer :

Design Issues: Framing, Error control, Flow control. Error detection and correction, Elementary data link protocols: Simplex, stop and wait, Sliding window protocol, HDLC.


4. The Medium Access Control Sublayer:

The channel allocation problem, Multiple Access protocols: ALOHA, CSMA, Collision Free

Protocols, Limited Contention Protocols, Wavelength Division Multiple Access Protocols,

Wireless LAN protocols; Ethernet: Traditional Ethernet, Switched Ethernet, Fast Ethernet,

Gigabit Ethernet, IEEE 802.2: LLC Data link layer switching : Bridges, local Internetworking,

Spanning tree bridges, Remote Bridge, Repeaters, Hub, Switches, routers, Gateway,

Virtual LANs.


5. The Network Layer :

Design Issues: Store and forward Packet switching, Service provided to transport layer,

Implementation of connection oriented and connection less service. Comparison of virtual

circuit and datagram subnets, Routing algorithms, Optimality principle, Shortest path

routing, Flooding, Distance vector routing, Link state routing, Hierarchical routing, Broadcast routing, Multicast routing, Routing for mobile host, Routing in ad-hoc network, Congestion control algorithms, Principles, Prevention policies, Congestion control in virtual circuit subnets, Congestion control in datagram subnets, Load shedding, Jitter control quality of service requirements, Techniques for achieving good quality of service Internetworking.

How network can be connected, Concatenated virtual circuit, Connectionless internetworking,Tunneling, Internetwork routing and fragmentation, The network layer in the internet: The IP protocol, IP addresses, Internet control protocol, OSPF, BGP, Internet multicasting, Mobile IP, IPv6.


6. The Transport Layer:

The transport service: Services provided to the upper layers, Transport service primitives, Socket, Elements of transport protocols: Addressing, Connection establishment, Connection release, Flow control, Multiplexing, Crash recovery. The transport protocol: UDP, TCP.


7. The Application Layer:

DNS: The DNS name space, Resource records, Name servers, Electronic mail: Architecture and services, User agent, Message formats, Message transfer, Final delivery, World Wide Web: Architectural overview, HTTP.


Reference Books:

1. Computer network, Andrew S. Tanenbaum, Pearson.

2. Introduction to Data Communication and Networking,Behrouz Forouzan, TMH.

3. Computer Network, Natalia Olifer, Victor Olifer, Wiley-India edition.

4. Data and computer communication, William Stallings, Pearson.

 To download engineering ebooks, medical ebooks, management ebooks, free ebooks please visit



Subject Name: Computer Oriented Statistical Methods

Subject Code: 151601


1. Computer Arithmetic:

Floating point representation of numbers, Arithmetic operations with normalized floating

point numbers and their consequences, Error in number representation – Pitfalls in

computing, Error propagation in evaluation.


2. Iterative Methods:

Bisection, False position, Scant, Newton – Raphson methods. Successive approximation

method, Newton raphson method for two variables, Discussion of convergence, Solving

polynomial equations, Budan’s theorem, Barirstow’s method, Graeffe’s root squaring



3. Interpolation and Approximation:

Polynomial interpolation, Truncation error in interpolation, Difference tables and calculus of

differences, Cubic splines, Inverse interpolation, Linear regression and nonlinear regression

using least square approximation, Approximation of function by Taylor Series and

Chebyshev Polynomials.


4. Numerical Differentiation And Integration:

Differentiation dormulas based on polynomial fit, Pit-Falls in differentiation trapezoidal,

Simpson’s and gossip quadrature formulas.


5. Solution Of Simultaneous Linear Equation And Ordinary Differential Equations:

Refinement of solution in Gauss elimination method pivoting, Ill Conditional equations,

Gauss – Seidal and Gauss Jacobi Interactive methods, Taylor Series And Euler Methods,

Error analysis, Runge-Kutta Methods, Predictor-Corrector methods, Automatic error

monitoring and change of step size stability of solution.


6. Statistical Methods:

Frequency distributions, Data analysis, Expectations and moments, Co-relation and

regression, Trend analysis, Seasonal effects, Cyclical fluctuation, Moving average, MSE,



Reference Books:

1. Computer Oriented Numerical Methods, R. S. Salaria., Khanna Publisher.

2. Computer Oriented Numerical Methods – V Rajaraman., PHI.

3. Introduction to Numerical Analysis – By S. S. Sastry., PHI .

4. Numerical Methods for Scientific & Engineering Computation, M. K. Jain, S.R.K.Lyenger , R. K. Jain, Wiley Eastern Ltd.

5. Numerical Methods in Science & Engineering Prog.- By Dr. B. S. Grawal, Khanna Pub., New Delhi.

6. Miller & Freund’s Probability and Statistics for Engineers – By Richard A Johnson., PHI.

7. Fundamentals of Mathematical Statistics – By S. C. Gupta & V. K. Kapoor , – Pub: Sultan Chand & Sons

8. Computer Oriented Numerical Methods D s vyassh & wandra Akshat

 To download engineering ebooks, medical ebooks, management ebooks, free ebooks please visit


Subject Name: E-Commerce & E-Business

Subject Code: 151602


1. Introduction to E-Commerce & Technology Infrastructure:

Business models, Revenue models and business processes, Opportunities- nature of ecommerce, Internet protocols, Internet2 and semantic web.


2. E-Commerce to E-Business and Spotting Business Trends:

Flexible business design, Definition of value, E-Business Communities, Customization and integration, E-Business.


3. Architecture:

Business engineering customer relationship management.


4. Digitizing the Business and Thinking E-Business Design:

E-channel pattern, E-portal pattern, E-market maker pattern, Self diagnosis.


5. Building the E-Business Backbone:



6. Business Process Model:

Customer centric business, Pre order, Point of order and post order customer support.


7. Environment of E-Commerce:

Legal, Ethical and Tax Issues

Legal environment, Use and protection, Online crime, Terrorism and warfare, Ethical issue.


8. Selling on the Web, Revenue Models and Building a Web Presence:

Revenue model, Revenue strategy issues, Usability.


9. Marketing on the Web:

Web marketing strategy, Communication, Segmentation, Advertisement, E-mail marketing.


10. Business to Business Strategy from Electronic Data Interchange to E-Commerce:

Purchasing, Logistics and support activities, Electronic data interchange, EDI, on internet.


11. Online Auctions, Virtual Communities and Web Portals:

Auction overview, Online auctions, Virtual communities and web portals.


12. E-Commerce Softwares and Payment Systems:

Web hosting alternatives, Basic and advance functions of e-commerce softwares, Software

for small, Mid size and large businesses, Online payment basic, Payment cards, Electronic

cash, Electronic wallets, Stored value cards, Internet technologies and banking.


Reference Books:

1. E-Business Roadmap for Success, Dr. Ravi Kalakota Marcia Robinson Addison Wesley.

2. E-commerce, Schneider, Cengage Learning.

3. E-commerce and web marketing, Hansom and Kalyanam, Cengage Learning.

4. E-business and e-commerce management, Chaffey, Pearson Education.

5. Frontiers of e-commerce, Ravi Kalakota, Pearson.


 To download engineering ebooks, medical ebooks, management ebooks, free ebooks please visit



Subject Name: Object Oriented Programming with Java

Subject Code: 150704


1. Introduction to Java :

Basics of Java programming, Data types, Variables, Operators, Control structures including selection, Looping, Java methods, Overloading, Math class, Arrays in Java.


2. Objects and Classes :

Basics of objects and classes in Java, Constructors, Finalizer, Visibility modifiers, Methods and

objects, Inbuilt classes like String, Character, StringBuffer, File this reference.


3. Inheritance and Polymorphism :

Inheritance in Java, Super and sub class, Overriding, Object class, Polymorphism, Dynamic binding,

Generic Programming, Casting objects, Instance of operator, Abstract class, Interface in Java, Package in Java, UTIL package.


4. Event and GUI programming :

Event handling in Java, Event types, Mouse and key events, GUI Basics, Panels, Frames, Layout

managers: Flow Layout, Border Layout, Grid Layout, GUI components like buttons, Check boxes,

Radio buttons, Labels, Text fields, Text areas, Combo boxes, Lists, Scroll bars, Sliders, Windows,

Menus, Dialog box, Applet and its life cycle, Introduction to swing.


5. I/O programming :

Text and Binary I/O, Binary I/O classes, Object I/O, Random access files.


6. Multithreading in Java, Thread life cycle and methods, Runnable interface, Thread synchronization, Exception handling with try-catch-finally, Collections in Java, Introduction to Java Beans and Network Programming.


Reference Books:

1. Introduction to Java Programming (Comprehensive Version), Daniel Liang, Seventh Edition, Pearson.

2. Programming in Java, Sachin Malhotra & Saurabh Chaudhary, Oxford University Press.

3. Murach’s Beginning Java 2, Doug Lowe, Joel Murach and Andrea Steelman, SPD

4. Core Java Volume-I Fundamentals, Eight Edition, Horstmann & Cornell, Pearson Education.

5. The Complete Reference, Java 2 ( Fourth Edition ), Herbert Schild, TMH.

6. Java Programming, D. S. Malik, Cengage Learning.

7. Big Java, 3rd Ed., Horstmann, Wiley-India.

8. Head First Java, Katy Sierra & Bert Bates, SPD (O’Reilly).


To download engineering ebooks, medical ebooks, management ebooks, free ebooks please visit


Subject Name: Visual Basic Applications and Programming (Institute Elective II)

Subject Code: 150706


1. Advantages of VBA

  1.  An easy-to-use and versatile language
  2.  Integrated with off-the-shelf products
  3.  Minimizes development time and costs


2. Macros: the first step

  1.  Recording and executing macros
  2.  Limitations
  3.  Enhancing with VBA code


3. The code design and debugging tools

  1.  Project Explorer
  2.  Help system
  3.  Code Window
  4.  IntelliSense
  5.  Properties Window
  6.  Block commenting and uncomment
  7.  Code stepping
  8.  Immediate Window
  9.  Breakpoints


4. Event-driven programming

  1.  The role of events in Windows
  2.  How events are triggered
  3.  Responding to events through event procedures


5. Putting objects to work

  1.  Properties
  2.  Methods
  3.  Events
  4.  Collections
  5.  Using With…End With


6. Storing data in variables

  1.  How and when to declare variables
  2.  Selecting data types
  3.  Fixed and dynamic arrays
  4.  Constants
  5.  The scope and lifetime of variables


7. Conditional branching

  1.  If…Then…Else
  2.  Select…Case


8. Looping through code

  1.  Do…Loop, While and Until
  2.  For…Next and For Each…Next


9. Building procedures

  1.  Creating Sub and Function procedures
  2.  Calling procedures
  3.  Passing arguments to procedures


10. Understanding object model structures

  1.  Exploring the hierarchy using the Object Browser and Help system
  2.  Referencing specific objects


11. Writing application-specific procedures

  1.  Key objects within Excel, Word and Outlook
  2.  Creating templates and add-ins


12. Exploiting the power of Automation

  1.  Controlling one Office application while working in another application
  2.  Accessing data in databases using ActiveX Data Objects


13. Using intrinsic dialogs

  1.  Communicating with the user through the message box
  2.  Gathering user information with the input box
  3.  Utilizing the File Dialog object and Dialogs collections


14. Creating customized dialogs with User Form objects

  1.  Command buttons
  2.  List and Combo boxes
  3.  Option buttons
  4.  Check boxes
  5.  Labels
  6.  Text boxes
  7.  Frames
  8.  Adding more functionality with advanced ActiveX controls


15. Modifying menus and toolbars:

  1.  Simplifying user interaction with the Command Bar object
  2.  Adding and removing Command Bar Control objects


16. Modifying menus and toolbars

  1.  Simplifying user interaction with the Command Bar object
  2.  Adding and removing Command Bar Control objects


17. Handling runtime errors

  1.  The On Error Go To structure
  2.  Classifying errors with the Error object
  3.  Continuing execution with Resume, Resume Next or Resume label


18. Implementing security

  1.  The dangers of macro viruses
  2.  Macro security levels in Office
  3.  Applying digital signatures to macros
  4.  Password protecting your VBA code


Reference Books:

1. VBA Developer’s Handbook, 2nd Edition, 2001, Authors: Ken Getz , Mike Gilbert ,Publication: Wiley Publication, Sybex.

2. Excel VBA Macro Programming, 2004, Author: Richard Shepherd, Publication: McGraw Hill.

3. Mastering VBA, 2nd Edition, 2005, Author: Guy Hart-Davis, Publication: WileyPublication, Sybex.

4. Access VBA Programming, Authors: Charles Brown, Ron Petrusha Publication: McGraw Hill.

5. Mastering VBA for Microsoft Office 2007, 2nd Edition , Author: Richard Mansfield, Publication: Wiley Publication, Sybex.

 To download engineering ebooks, medical ebooks, management ebooks, free ebooks please visit

Leave a Comment