DETAILED SYLLABUS

1. Computer Fundamentals

Characteristics of Computers, Input, Output, storage units, CPU, computer system, Binary number system, Binary to Decimal Conversion, Decimal to Binary Conversion, Binary Coded Decimal (BCD) Code, ASCII Code

2. Computer Organization

2.1      Central Processing Unit

Control Unit, Arithmetic Unit, Instruction Set, Register, Processor Speed.

2.2      Memory

Main memory: Storage Evaluation Criteria, Memory Organization, capacity, RAM, Read Only Memories. Secondary Storage Devices:- Magnetic Disks, Floppy and Hard Disks, Optical Disks CD-ROM, Mass Storage Devices.

2.3      Input Devices

Keyboard, Mouse, trackball, joystick, Scanner, OMR, Bar-Code reader, MICR Digitizer, Card Reader, Voice Recognition, web cam, video cameras.

2.4      Output Devices

Monitors, Printers – Dot matrix, inkjet, laser, Plotters, Computer Output Micro-Film (COM), Multimedia Projector, speech synthesizer; dumb, smart and intelligent terminal.

2.5      Multimedia:

What is Multimedia, Text, Graphics, Animation, Audio, images, Video; Multimedia Application in Education, Entertainment, Marketing.

2.6      Computer Software

Relationship between Hardware and Software; System Software, Application Software, compiler, names of some high level languages, free domain software.

3. Operating System Concepts

3.1     Disk Operating System

Simple DOS Commands, Simple File Operations, Directory Related Commands.

      3.2     Microsoft Windows

An overview of different versions of Windows, Basic Windows elements, File management through Windows.

Using essential accessories: Systems tools-Disk cleanup, Disk defragmenter, Entertainment, Games, Calculator, Imaging-Fax, Notepad, Paint, WordPad.

4. Office Automation Tools (MS Office)

4.1      MS Word

Word processing concepts: Saving, Closing, Opening an existing document, Selecting text, Editing text, Finding and replacing text, printing documents, Creating and Printing Merged Documents, Character and+ Paragraph Formatting, Page Design and Layout.

Editing and Proofing Tools: Checking and correcting spellings. Handling Graphics. Creating Tables and Charts. Document Templates and Wizards*.

4.2       MS Excel

Spreadsheet Concepts. Creating, Saving and Editing a Workbook, Inserting, Deleting Work Sheets, entering data in a cell / formula Copying and Moving data from selected cells, Handling operators in Formulae, Functions: Mathematical, Logical, Statistical, Text, financial, Date and Time functions, Using Function Wizard.

Formatting a Worksheet: Formatting Cells- changing data alignment, changing date, number, character, or currency format, changing font, adding borders and colors, Printing worksheets, Charts and Graphs-Creating, Previewing, Modifying Charts.

Integrating word processor, spread sheets, web pages.

4.3      MS PowerPoint    

Creating, Opening and Saving Presentations, Creating the Look of Your Presentation, Working in Different Views, Working with Slides, Adding and Formatting Text, Formatting Paragraphs, Checking Spelling and Correcting Typing Mistakes, Making Notes Pages and Handouts, Drawing and Working with Objects, Adding Clip Art and Other Pictures, Designing Slide Shows, running and Controlling a Slide Show, Printing Presentations.

5. IT Applications

Application of Information Technology in Railways, Airlines, Banking, Insurance, Inventory control, Financial systems, Hotel management, Education, Video games, Telephone exchanges, Mobile phones, Information kiosks, special effects in Movies.

1. Introduction to Business Data Processing

Overview of Business Systems: Management functions, Levels of management, Information requirements for planning, coordination and control for various levels in Business, Industry and Government.

Profile of data in Business systems: Large volumes of data and data handling implicit, identification of relevant data. Classification of data elements by function and by source, Primary and Secondary. Historical data for reference and analysis. Need for ensuring accurate, reliable and timely processing of data. Basic tasks in Business data processing, data origination, capture, sorting, merging, calculating, summarizing, managing output-results, storing and retrieving transmission, both interim and final, Examples of business data processing and applications, Payroll, Financial, Accounting, Inventory, etc.

Computer System as a potential tool to meet business data processing needs, facilities available in computerized systems for Data capture; inline and offline; validation; storage; storage; processing and output; Transmission.

1.1      Concept of Files

Master and transaction files, File organization: sequential, relative and indexed, Modes of processing: batch, online and real-time.

2. Fundamentals of Programming

Introduction to programming: program definition, life cycle, characteristics of a good program, data handling (flowcharts, pseudo codes)

Report production and file updation, simple report generation, overview of control break procedure for report production.

3. Principles and Techniques of Programming

Programming paradigms: Unstructured programming, structured programming, procedural programming, modular programming. Program designing, Top down and bottom up design, program documentation.

Operation on files: Input, output and I/O; processing a file, multiple handling file updation; sequential file updation, random file update.

4. MS-Access

Database Concepts, Database concepts applied to Access, Tables, Using Operators Functions and Expressions, Queries, Forms, Reports, Exercises and sample questions, Project work.

5. Accounting Fundamentals

6. Accounts Application: Tally

Introduction,  Starting Tally, Masters, Vouchers, Vouchers (Advance), Display (Final accounts), Display (Book of accounts), Printing, Maintenance, Summing Up.

1. Introduction to Internet

Internet, Growth of Internet, Owners of the internet, anatomy of Internet. ARPANETand Internet history of the World Wide Web, Basic Internet Terminology, Net Etiquette.

Internet Applications-Commerce on the Internet, Governance on the Internet, Impact of Internet on Society-Crime on/through the Internet.

           1.1      Internet Technology and Protocols

Internet Protocols, TCP/IP: IP Address and its Format, TCP/IP Based          packages, SLIP, PPP. 

Network and Network Devices:- Network Architecture, Ethernet, FDDI, and ATM.

Characteristics of Local Area Network & Wide Area Network: Topology, Protocols and media, Implementation, Transmission, Access method and Technologies.

Addressing in Internet: DNS, Domain Name and their organization, understanding the Internet Protocol Address.

Client Server Concepts, their Architecture and applications.

Getting Connected-Items needed to connect, Levels of Connectivity.

2. World Wide Web

Evolution of WWW, Basic features, WWW Browsers, WWW Servers, HTTP, Universal Resource Locator (URL), Search Engines and their Categories, Searching Criterion, WWW and Hypertext.

3. Browsers

Basic features, Bookmarks, history, Progress indicators, Customization of browsers, Saving and Printing web pages, Netscape Communicator, Internet Explorer.

4. File Transfer Protocol (FTP), Telnet

Introduction to FTP and Terminology, FTP Servers and Authentication, Line Mode FTP and Common Commands, GUI Based FTP Clients, Browser Based FTP Clients.

Introduction to Telnet, Establishing Telnet Connection, Using Telnet with Netscape, Telnet Protocol, Terminal Emulation, User Authentication.

5. HTML

Document Layout, Header Elements, Section Headings, Block-oriented elements, Lists, Inline elements, Visual markup, Hypertext links, Uniform Resource Locators (URLs), Images, Forms, Tables, and Special Characters.

6. Front Page

Introduction to front page, designing web page.

7. Java Script

Introduction to scripting language, Java Script Operators, Control statements, loops, Java Script Object hierarchy.

8. Graphic Tools

Adobe Photoshop: Introduction, Using the Editing Tools, Working with layers,     channels and paths, Image modification tool, Working with text, Working with history and actions, Adjusting Images, Designing images for the Web, Using image ready, Saving your work.

1.  Integrated Development Environment

Elements of VB IDE: Menu bar, Toolbars, Project explorer, Toolbox, Properties window, Form designer, form layout, Immediate, Locals and Watch window, Edit, View, Run, Debug, Object Browser.

2. Managing Projects

Concepts of VB project, creating the Project, Opening, Renaming and Saving the projects. Elements of user interface, Designing the User Interface, creating forms and code modules, Aligning the controls.

Programming an application: Programming the command buttons, Label, TextBox, Grouping controls, and Running the application.

Visual development and event-driven programming: Common properties, methods and common events.

Customizing the environment: Editor tabs, format tab, general tab, docking tab, and environment tab

3. Visual Basic Programming Elements

Variables: Declaring variables, Data Types, Converting variables types, User-defined data types, Forcing variables declarations, scope of variables, Lifetime of a variable.

Constants; Collections objects, Arrays-Declaring Arrays, Sorting Arrays, Control Arrays, Dynamic Arrays.

Procedures: Sub procedures, and Function procedure. Control Structures: Control flow Statements, Looping Statements and  iteration, Conditional Statements.

The Input / Output: Input Box, Output Box, Form Printing methods

4. Working with Forms

The Appearance of forms, Form properties, Events, and Methods, Controlling one form within another.

Menus: Designing menus using Menu Editor, Programming menu commands, Using Access and shortcut keys, Popup Menus, Manipulating menus at runtime, Adding Toolbar, Mouse conflicts, Dragging list items, Connecting Menus to Event Procedures.

5. ActiveX Controls

The Textbox control, Basic properties, Manipulating the control’s text, Text selection, Search and replace operations, Capturing keystrokes.

List Box and Combo Box controls; Basic properties; List box control’s Methods;  Arrows, Indexing with the List Box Control, Searching a sorted list, Scrollbar and Slider controls, Scrollbar control, Scrollbar control’s events, Timer Control.

Common Dialog Control: Color Common Dialog Box; Font dialog box, Open Dialog, Save As Common Dialog Boxes, Print Dialog Box, Help Common Dialog box, File controls.

The Rich Textbox control: The RTF language, Text manipulation properties, The Rich Textbox control’s methods, Text formatting properties, Text alignment properties.

The MS Hierarchical Flex Grid Control: Basic properties, Working with Multiple Cells, Cell Appearance and Alignment, Sorting the grid, Merging cells.

6. Graphics with Visual Basic

Form, Picture Box, Image Box controls, Sizing images: Loading and saving Images, Setting picture and image properties, Exchanging image through the clipboard.

Coordinate systems: Scale properties and methods. The Drawing Methods: Drawing Curves, Manipulating pixels, specifying colors, specifying gradients, Using the Paint-picture method.

Processing images, Optimizing issues: refresh, Transparent Drawings.

7. Multiple Document Interface (MDI)

Feature of an MDI Forms. Loading MDI Forms and MDI Child Forms. Positioning child Forms. The Active Form Property. Tracking Child Windows. Unloading MDI Forms with Query Unload / Unload

8. Error Handling

Types of error, Error detection. Runtime error handling: Setting up error traps, writing an error handler, exiting an error handler. Err Object.

9. Windows APIs & DLL

Accessing the Win32 API. API Text Viewer, Dynamic-Link-Libraries (DLL): Declaring a DLL Procedure, Calling a DLL Procedure, Special Considerations when calling a DLL with special data types.

10. Object Oriented Programming with Visual Basic

Preliminary concepts: Classes, Instances, objects, Derived Classes and Base classes, Class inheritance, Dynamic binding, creating object variables, forms as classes, Creating & manipulating runtime controls, using the object browser, Object Linking and Embedding (OLE)

Building ActiveX Components: Modules and Class Modules, raising errors with in a class, Encapsulating Database Operations.

Developing ActiveX Controls: User drawn and Existing Visual Basic Controls, The user control object, Designing a simple control, Designing and Using Property Pages, The lens-effect control, Internet-enabled controls.

11. Database Programming with Visual Basic

Client-Server Programming: File server vs. Distributed client server, Advantages of Client / Server.

Using ActiveX Data Objects: Understanding of Universal Data Access, OLEDB, and ADO, Browse, Create, Delete, records of a database using the ADO Data Control. ADO Record set Objects, Cursor Types in ADO. Retrieve, Alter, Search Data using ActiveX Data Objects. Using Properties, Methods, Events and Collections of the Record set Objects. Using SQL: The format of SQL Statements, Querying Data using SQL. Handle ActiveX Data Objects errors.

1. Urdu and Hindi DTP

An introduction to Computer, Urdu software, How to run Urdu software, Urdu software interface, Text box, Picture box, Graphic box, Line, Guides, Text chain, Formatting Text, Master Page, Ribbon, Printing, How to make attractive headlines, how to layout a book, Urdu English Dictionary Layout, Ghazal layout, CorelDraw with Urdu software, Use of mathematical equation, Arabic/Persian with Urdu, Web menu, Symbol menu, Window menu, Help menu, How to make internet file, Additional features, short-cut keys, Keyboard preference.

2. PageMaker

Introduction, Tour of PageMaker, Editing, Adding Design Elements, Setting of Templates, Setting up Custom Styles, Using Layers, Printing, Adding color, Developing long documents, Using PhotoShop Filters, Creating HTML Pages, Using PageMaker help 

3. Corel Draw:

Introduction, Creating Artistic text, Working with shapes, Controlling the CorelDraw 9 Environment, Setting up Page Layout, Defining Outlines, Mixing Up Fills, Drawing and Editing FreeHand Curves, Bezier Curves, Working with Shapes and Curves, Working with Bitmaps Images, Lenses and PowerClips, Blends and Contours, Working with Perspective, Designing with Paragraph Text, Managing Layers and Pages, Importing and Exporting Objects, Printing, From CorelDraw to the World Wide Web, Driving in to PhotoPaint, Painting text, Painting Bitmap, Working with objects, Working with masks.