DIPLOMA IN INFORMATION TECHNOLOGY ( A02 )

Subject Code  

Subject Name  

Details  

T  

P  

Total Dur.

Hrs.  

Total Marks  

Exam  

Dur.  

A02-01  

Computer  

Fundamentals  

Computer Fundamentals,  

Operating System: DOS, UNIX, LINUX, Windows  

60  

40  

100  

100  

3  

A02-02  

MS- Office  

MS- Word,  

MS- Excel,  

MS- Power Point  

35  

65  

100  

100  

3  

A02-03  

MS-Access  

DBMS Concepts, Design of database, Fill exposure of MS-Access  

30  

45  

75  

100  

3  

Total  

125  

150  

275  

300  

Subject Code  

Subject Name  

Details  

T  

P  

Total Dur.

Hrs.  

Total Marks  

Exam  

Dur.  

A02-04  

Concepts of Networking

Introduction to Computer Networking, Windows 2000 or higher  

50  

30  

75  

100  

3  

A02-05  

Web Programming  

HTML, FrontPage Page & DHTML  

40  

60  

100  

100  

3  

A02-06  

Computer  

Programming  

Concepts of OOP’s & Programming using C++ Language  

40  

60  

100  

100  

3  

A02-07  

Project Work  

Using any Language of the course  

-  

50  

50  

100  

-  

Total  

130  

200  

325  

400  

Paper  

Subject  

Syllabus  

Contents  

T  

P  

A02-01  

Computer

Fundamentals  

Computer Fundamentals,  Operating System:  

DOS, UNIX,   

Ms- Windows  

Introduction: Characteristics of Computers; The Evolution of Computers; The Computer Generations (First Generation (1942-1955), Second Generation (1955 – 1964), Third Generation (1964 – 1975), Fourth Generation (1975 – 1989), Fifth Generation (1989 – Present)).  

Basic Computer Organization: Input Unit; Output Unit; Storage Unit; Arithmetic Logic Unit; Control Unit; Central Processing Unit; The  System Concept.  

Number Systems: Non-Positional Number Systems; Positional Number Systems (Binary Number System, Octal  Number System, Hexadecimal Number System); Converting One number System to

Another (Converting to Decimal from Another Base, Converting from Decimal to Another  Base

(Division-Remainder Technique), Converting from a Base Other Than 10 to a Base Other Than 10, Shortcut  Method for Binary to Octal Conversion, Shortcut Method for Octal to Binary Conversion, Shortcut Method for Binary to  Hexadecimal Conversion, Shortcut Method  for Hexadecimal to Binary Conversion); Fractional Numbers.  

Processor and Memory: The Central Processing Unit (CPU) (The Control Unit, The  Arithmetic Logic Unit (ALU), Instruction Set, Registers, Processor Speed, Types of  Processors); The Main Memory (Storage Evaluation Criteria, Main Memory Organization, Main Memory Capacity, RAM, ROM,  PROM and  EPROM, Cache Memory.  

Secondary Storage Devices: Sequential and Direct-Access Devices; Magnetic Tape (Basic

Principles of Operation, Types of Magnetic Tapes, Advantages and Limitations of Magnetic Tapes, Uses of Magnetic Disks); Optical Disk (Basic Principles of Operation, Types of Optical Disks, Advantages and Limitations of Optical  Disks, Uses of Optical Disks); Mass Storage Devices (Disk Array, Automated Tape Library, CD-ROM Jukebox); Storage Hierarchy.  

Input-Output Devices: Input Devices (Keyboard Devices, Point-and-Draw  Devices, Data Scanning Devices, Digitizer, Electronic Card Reader, Voice  Recognition Devices, Vision-Input System); Output Devices (Monitors, Printers, Plotters, Screen Image Projector, Voice Response Systems).  

Computer Languages: Analogy with Natural Languages; Machine Language (Advantages and Limitations of Machine Language); Assembly Language (Assembler, Advantages of Assembly

Language over Machine Language, Limitations of Assembly Language, Assembly Languages with Macro Instructions); High-Level Language (Compiler, Linker, Interpreter, Advantages and Limitations of High-Level Languages); Object-Oriented Programming Languages; Some High-Level Languages  

04  

04  

06  

04  

04  

04  

06  

-                

-                

-                

-                

-                

-                

-                

(FORTRAN, COBOL, BASIC, Pascal); Some More  High-Level Languages (C and C++, Java, RPG,  LISP, SNOBOL); Characteristics of a Good Programming Language; Selecting a Language for Coding an Application; Subprogram.  

Application Software Packages: Word-Processing Package (What it is?, Commonly Supported

Features); Spreadsheet Package (What it is?, Commonly Supported Features); Graphics Package (What it is?, Commonly Supported Features); Personal Assistance Package (What it is?, Commonly Supported Features).  

Classification of Computers: Notebook Computers; Personal Computers (PCs); Workstations; Mainframe Systems; Supercomputers; Clients and Servers.   

Operating System:   

Introduction: Machine Hardware (Traps  and Interrupts, Multimode Execution); Operating System Structure (Operating System Types, Operating  System Kernel, The  Boot Process).  

MS-DOS: Basics of OS, functions of OS, DOS as OS, Getting started with MS-DOS, Starting PC; Booting sequence, Types of commands, Internal & external, reserve words, typing a command (Syntax of command)  

Files in MS-DOS: Naming a file, permissible characters and extensions, reserve words, creating a file with copy con <xxx>. Commands like TYPE, COPY, RENAME, DEL, DATE, TIME, ATTRIB.  

Directory Handling: MKDIR, CHDIR, RMDIR, TREE, SUBST, DELTREE, PATH, APPEND, editing files with Edit, cut, copy & Paste, search with find.  

Disk Maintenance: Format, Diskcopy, XCOPY, DISKCOPY, BACKUP RESTORE, LABEL, VOL.  

Batch File:  REM, ECHO, FOR, PAUSE, IF, GOTO replacable parameters %1 to %9 & %* Autoexec.bat.  

Command:  Special features: redirection and filters; piping, MORE, SORT, FIND commands.  

Config. Sys: Device Drivers, MEM managements, files Buffers, High memory area.  

UNIX Overview: Unix Architecture; Kernal, process, Time sharing, Shell, files and directories creation of file, file security, peripheral devices as files, inodes.  

02  

02  

02  

02  

02  

02  

01  

02  

01  

02  

04  

-                

-                

02  

04  

04  

04  

04  

04  

02  

02  

02

Unix Editor:  Ed editor, vi editor  

File Handling Utilities: File handling Commands, Is, cp, mv, rm, cat lp, grep, mail, sed etc.  

Shell Script: Bourne shell, C shell, Shell variables, Shell Scripts, if a case statements, for while until loops.  

The Internet: Definition (What it is?); Brief History; It’s Basic Services (Electronic Mail, File Transfer Protocol, Telnet. Usenet News, The World Wide Web); WWW Browsers; Uses of the Internet.  

02  

 02  

02

04  

04  

04  

Total

60  

40  

A02- 02  

Ms- Office  

Ms- Word,  

Ms- Excel,  

Ms- Power Point  

Microsoft Office   

Introduction; Microsoft  Word; Microsoft Excel ;  Microsoft Access; Microsoft PowerPoint ,  Microsoft Outlook ; Internet Explorer 5.0; Microsoft

FrontPage; Microsoft Publisher 2000; Microsoft PhotoDraw; Microsoft Office Bar; Using the Mouse (To Click, To double-click, To select, To drag, To scroll, To choose  from a menu, To move a window, To resize a  window,  To minimize  a  window,  To restore a minimized window, To maximize a  window, To switch windows, To close a window, Remember); Microsoft Office  and Web (Microsoft  Word , Microsoft Excel ,  Microsoft Access 2000, /XP Microsoft PowerPoint ,  Microsoft Outlook , Microsoft FrontPage ); Common Keyboard Commands.  

Creating Your Document in Word : Introduction; Saving the file; Formatting the  text, Alignment of Text; Applying  Fonts; Spell Checking; Consulting Thesaurus; Assign Character  Styles (Assign  a Character  Style, Create a character  style); Borders and Shading (Apply Borders and Shading); Closing of the File; Save as option; Open File (From File  menu, From Open Icon); Printing  Your Document.  

Proofing Your Document in Word : Introduction; Editing Tools; AutoCorrect (Add AutoCorrect Entries Without Formatting, Add New AutoCorrect Entries with Formatting); Auto Text (Creating an AutoText Entry, AutoComplete Option); AutoFormat (AutoFormat as You Type, AutoFormat on Command, AutoFormatting Text); Find and Replace; Find; Replace Text; Page Numbering; Header and Footer (Adding a Header or Footer in Your Document); Footnotes and Endnotes (Add a Footnote or Endnote).  

Getting Started :  Staring, Menu system, tabbed dialog bxes, workbooks, worksheets within workbooks, Cells : cell reference, active cell toolbar: (displaying, hiding, getting poput tool explanantions, controlling size, moving tool bars, drop down palettes) using online help.  

Workbooks, Worksheets & Windows Workbooks: Creating new workbooks, opening existing ones, opening more than one workbooks, saving closing.  

06  

02  

04  

02

02  

04  

06  

08  

04  

04  

Worksheets with in Wbs: Activating Wks, scrolling tabs, printing Wks, inserting, deleting, copying/moving, manipulation of Multiple files. Creating a Worksheet: Introduction; Copying Formula.  

Advanced Techniques of Excel : Introduction; Auditing a Workbook (To Trace  the  

Precedents for a Formula); Comment Inserting (To Insert a Comment); Formulas That Make  Decisions

(How the  If function works); Headers and Footers; Merging  Workbooks (To merge workbooks); 

Outlines (Outline a  Worksheet Automatically, Clear Entire  Outline, Show or Hide Outline Symbols, Group Rows or  Columns in an Outline, Ungroup Rows or Columns in an  Outline, Remove Group from Outline, Set Outline Options); Printing Column and Row Labels on Every Page; Protecting a Workbook (To unlock cells so that others  can edit the cell contents, To protect  a workbook, To share a workbook); Ranges, Naming (To name a range); References (Absolute references, Mixed references); Seeking Goals (To seek a goal); Sheets  Naming (To Name a Sheet); Working with Workbooks (Copying Entries Between  Workbooks, Moving Sheets Between Workbooks, Deleting Sheets).  

Power Point Basic: Creating Presentation Using AutoContent Wizard, Creating New Presentation, Introduction; Changing views. OLE Tips for Power point, Terminology, Color Schemes, PowerPoint Templates, Getting Started, Views.  

Creating Presentations the Easy Way: Auto Content Wizard, The Pick A Look Wizard, Masters, Adding Slides.  

Working with Text in Power Point : Editing and Moving Text, Working in Outline View, SpellChecking, Finding and Replacing Text, Adding Removing Periods in Sentences, Formatting Text, Aligning Text, Word Tables Power Point.  

Working with Graphics in Power Point: Importing Images from the Outside World, The CLIP PART Gallery, Drawing in Power Point, Creating Organizational Charts, Inserting Photos in Your PowerPoint Presentation.  

Showtime: If we can put a man on the Moon…, Arranging, Previewing and Rehearsing, Transition and Build Effects, Showing Slides Out of Order, Deleting Slides, Printing Presentation Elements, Creating Overhead Transparencies, Obtaining Colour 35mm Slides, Sharing Presentation Files with others.  

 02  

06  

02  

01  

01  

01  

01  

06  

12  

04  

03  

04  

04  

04  

Total

35  

65  

A02- 03  

MS-Access  

DBMS Concepts,  

Design of database,  Fill exposure of MS-

Introduction to Databases,  DBMS and RDBMS :  Introduction, Information, Quality of Information, Information Processing, What is a  Database?,Why a Database?, Charateristics of  Data in  a  

Database, What is a Database  Management System (DBMS)?,  Need for DBMS, Types of DBMS,  

 04  

-  

Access  

Relational Database Management Systems (RDBMS),  RDBMS Terminology, Relational Data  Structure, Relational Data Intergrity  

Access 2000 Basics:  Introduction, Starting Access 2000, Opening an existing database, Opening the sample north window database, What is a database?, Managing database objects Access Startup

Dialog Box, Menus and Toolbars, Using Toolbar Buttons, Arranging Buttons on the Toolbar, Viewing  

Data, Creating an Access 2000 Database  and Tables, Database Properties, Modifying Tables,   Creating Forms, Entering and Updating Data Using Forms, Navigating between Records in a Form, Finding, Editing and Deleting Data in a Form, Using Access 2000  Help, Using Answer Wizard, Using the Contents Tab to Get Help,  Using the Index Tab to ger Help, Exercises.  

UNDERSTANDING DATABASES: Why store data, You use tables to store data, Terminology time, Why use multiple tables?  

CREATING DATABASES: Introduction, Database is not a table, Creating a blank database, Using the file new database dialog box,   

CREATING TABLES: Using the table wizard, Object naming rules, Planning a table from scratch, Creating a table without using a wizard, Defining a tables fields, Choosing appropriate data types, Defining field propertiesm,  Setting a primary key, Defining indexes, Saving a table structure, Switching between design and datasheet views, Changing properties, About lookup fields

ADDING, EDITING AND VIEWING DATA: Datasheet view and form view, Changing the datasheet appearances, Navigating forms and datasheets, Changing  data in a table, Deleting data, Copying and moving data, Special techniques for memo fields, Duplicate key message, Null value in index, Validation rule, Changing the table design from datasheet view, Creating a table from a blank datasheet    

SORTING: Introduction, Quick and easy sorting, Sorts within sorts, Filtering out unwanted records, Using advanced filter/sort, Creating complex filters, Specifying selection criteria, Specifying 'and/or' criteria, Sample filters, Saving a filter as a query  

Queries:  Introduction, What queries let you do, Types of queries, Creating a query, Viewing the dynaset, Running an action query, Refining your query, Changing field properties, Creating crosstab queries, Creating action queries, Update queries, Make table queriesSorting and Filtering Records, Creating and Printing Reports,  Creating and Using Queries.  

02  

04  

02  

02  

02  

02  

02  

02  

-  

08  

01  

01  

05  

05  

02  

06  

Introduction to Structured Query Language (SQL):  Introduction, Characteristics of SQL, Advantages of SQL, Types of SQL Tables, Create Table, NULLS, Data Manipulation, Update

Operations, SQL in Access., SELECT Queries in QBE, Make-Table Query, DELETE Query, UPDATE Query,  APPEND Query  

CREATING FORMS: Creating forms with form wizards, Making hierarchical forms work properly, Charts, Pivot tables, Using wizards, Saving a form,  Opening and using a form, Getting around in hierarchical forms, Changing the style   

CREATING REPORTS: Introduction, Kinds of reports, Groups, totals and summary reports, When the report wizard needs your help, Charts, Using wizards to create a report, Creating mailing labels, Formatting postal codes and phone numbers, Saving a report, Opening a report, Removing a filter and sort order, Changing the style for a report  

04  

02  

02  

06  

06  

05  

Total

30  

45  

A02- 04  

Concepts of Networking  

Introduction to  

Computer  

Networking,

Windows 2000 or

higher  

DATA COMMUNICATIONS: Multiplexing, Signaling, Encoding & Decoding, Error Detection & Recovery, Flow Control, Sliding Window, Congestion Management.  

COMMUNICATION NETWORKS:  Introduction to networking, OSI Model for Networking, Internet, ATM, Network Components (Cables, Hubs, Bridges, Switches, Routers), Network Topologies, Shared Medium, Peer to Peer, Hybrid Technology.  

NETWORK TECHNOLOGIES:  Local Area Network Technologies, Ethernet Technologies, Ethernet Versions, Token Ring Technologies, Wide Area Network Technologies (Frame Relay, SMDS, ISDN, SONET, PPP, HDLC, LLC), Wireless Networks (Radio Frequencies, Microwave Frequencies, Infrared Waves.  

MULTIPLE ACCESS: Design Issues, Distributed & Centralized Design, Circuit Mode & Packet Mode Design, Implementation Issues, Performance Considerations,  Base Technology (FDMA, TDMA, CDMA, Centralized Access, Circuit Mode Access, Poling or Packet Mode Access, Reservation Based Access), Distributed Access (decentralized polling, CSMA, CSMA/CA, CSMA/CD, Busy Tone Multiple Access & Multiple Access Collision Avoidance, Token Passing, ALOHA, Slotted ALOHA, Reservation ALOHA), Hardware Addressing  

SWITCHING: Circuit Switching (Time Division switching, Space division switching, time space switching, time space time switching),  Packet Switching (Port Mappers, Blocking, ATM Switching, Switching Fabric (Crossbar, Broadcast, Switching Fabric Elements), Bridges (Transparent bridges, Spanning Tree Algorithm, Virtual LANS), Switches.  

NAMING & ADDRESSING:  Hierarchical Naming, Addressing, Telephone Networks, Internet, IPv4,  Subnetting Ipv4 Networks,  Private Networks, Asynchronous Transfer Mode,  Name Resolution, 

Address Resolution Protocol (Arp), RARP  

Networking Topologies:  Network Services, Transmission Media, Connectivity Devices, Network  

 02  

02  

04  

06  

06  

04  

06  

-                

-                

01  

-                

02  

01  

04  

Protocols & Models, Servers and clients, Introductions to the OSI Model, the Physical Media, the Data Link Layer, Data Transmission, The Network Layer, The transport Layer, The Session Layer, Lower Layer Protocols, Bridging, Switching & routing, TCP/IP Network, Directory Services, Remote Access Protocols, Network Security and fault Tolerance, Preparing for Network Installation, Main ting the Network, Troubleshooting the Network.  

Basics of Networking: Basic Networking Knowledge, LAN Vs. WAN, Primary Network Components, Network Topologies, Network Architectures, Network Media, Connectivity Devices, Repeaters, Bridges, Hubs, Routers, Brouters, Gateways.  

Operating System: Introduction to the Window 9x Family of Products, Introduction to Windows 9x Networking, Windows 9x Architecture, Supporting Printers, Troubleshooting Windows 9x, Introduction to the Windows 2000 Family of Products, The Windows 2000 Boot Process, Windows 2000 System Administration Basics, Introduction to Networking with TCP IP, Name Resolution Services, Customizing a Windows 2000 Installation, Managing Network Printing, Managing Hard Disks and Partitions, Monitoring and Troubleshooting Windows 2000.  

Windows 2000 or higher: Introduction to administering Windows 2000,  Planning & creating User Accounts, Configuring User Profile, Planning & Creating Local & Global groups, Implementing Built-in groups, Managing Account, Managing Domain Controllers, Planning Shared folders, Sharing folders, Planning & assigning NTFS permissions, Auditing resources & events, Installing Windows 2000.

Configuring Windows 2000 Environment, Managing System Policy, Managing file system, Creating &

Managing Partitions, Implementing fault tolerance, Supporting Applications, Windows 2000 Networking Environment, Configuring WNS, Installing & Configuring DNS, Remote Access Server,

Installing Internet Information Server (ISS), Installing & configuring gateway service for netware, Setting up Network Printers, Printers from windows 2000, implementing Netware Clients, Implementing file synchromization & Directory Replications, The Windows 2000 boot Process.  

06  

06  

08  

-  

05  

12  

Total

50  

25  

A02- 05  

Web  

Programming  

HTML, FrontPage  

Page, DHTML &  

Java Script  

INTRODUCTION TO HTML: Information Files Creation; Web Server; Web Client/Browser  

(Understanding how a Browser communicates with a Web Server); Hyper Text Markup Language  (HTML) (HTML Tags, Paired Tags); Commonly used HTML Commands (The structure of an HTML program, Document Head, Document Body); Titles and Footers; Text Formatting (Paragraph Breaks, Line Breaks); Emphasizing Material in a Web Page (Heading Styles, Drawing Lines); Text Styles (Bold, Italics, Underline); Other Text Effects  (Centering (Text, Images etc.); Spacing (Indenting Text).  

Lists: Types of Lists (Unordered List (Bullets), Ordered Lists (Numbering), Definition Lists).  

Adding  Graphics to  HTML Documents: Using the Border attribute; Using the Width and  

04  

01  

06  

01  

Height Attribute; Using the Align Attribute;  Using the ALT Attribute.  

Tables:  Introduction (Header, Data rows, The Caption Tag); Using the  Width  and  Border Attribute; Using the Cellpadding Attribute; Using the Cellspacing Attribute; Using the BGCOLOR Attribute; Using the COLSPAN and  ROWSPAN Attributes.  

Linking Documents: Links (External Document References, Internal Document References); Images as Hyperlinks (Image  Maps).  

DHTML AND STYLE SHEETS: Defining Styles; Elements of Style; Linking a Style Sheet to an HTML Document; In-line Styles; External Style Sheets; Internal Style Sheets; Multiple Styles.  

FRAMES: Introduction to Frames (The <FRAMESET> tag, The <FRAME> tag, Targeting  Named Frames. Frameset Definition; Frame Definition; Nested  Framesets.  

INTRODUCTION TO JAVASCRIPT: JavaScript in Web Pages (Netscape and JavaScript,  

Database Connectivity, Client side JavaScript, Capturing  User Input); The  Advantages of JavaScript (An Interpreted Language, Embedded within HTML, Minimal Syntax - Easy to Learn, Quick Development, Designed for Simple, Small Programs, Performance, Procedural Capabilities, Designed for Programming User Events, Easy Debugging and Testing, Platform Independence/Architecture Neutral); Writing JavaScript into HTML; Building Up JavaScript Syntax; Basic Programming   

Techniques (Data Types and Literal, Type Casting, Creating Variables,  Incorporating  variables in a

Script, The  JavaScript Array, The Elements of an Array, The JavaScript Array and its length  

Property); Operators and Expressions in JavaScript (Arithmetic Operators, Logical Operators,   Comparison  Operators,  String Operators, Assignment Operators, The Conditional Expression Ternary Operator, Special Operators); JavaScript Programming Constructs; Conditional Checking (If

- then - else, Immediate If (Conditional expression); Super Controlled - Endless Loops (For Loop);

Functions in JavaScript (Built-in  Functions, User Defined functions, Declaring functions, Place  of Declaration, Passing Parameters, Variable Scope, Return Values, Recursive Functions); Placing  text in a Browser; Dialog Boxes (The Alert dialog box, The Prompt dialog box,  The Confirm dialog box).  

The JavaScript Document Object Model: Introduction (Instance, Hierarchy); The JavaScript Assisted Style Sheets DOM (JSSS DOM); Understanding Objects in HTML (Properties of HTML objects, Methods of HTML objects);  Browser Objects (The  Web Page HTML Object Hierarchy, Access  to Elements of a Web  Page, How a Web Page Element  is Manipulated);  Handling (WEB PAGE) Events Using JavaScript (Named JavaScript Event handlers).  

02  

03  

02  

04  

02  

10  

04  

06  

04  

06  

05  

12