Computer Operator & Programming Assistant 
(COPA)

 
UNDER

CRAFTSMEN TRAINING SCHEME

 

OBJECTIVES OF THE COURSE :

 

1. Learning fundamentals of computers

2. Identifying and checking  validity of data.

3. To attain the data entry speed.

4. Providing hand-on-experience on PC/Micro Computer.

5. Learning computers  languages like C & C++.

6. Learning various packages supported by PC such as Office Automation packages (MS-

    Office: Word, Excel, PowerPoint etc.)

7. To develop programs from planning and flow charting to coding and debugging.

8. Stressing on business data processing and office automation.

9. Learning first aid maintenance of PC & its peripherals.

10. Learning Basic concept of networking.

11. Developing soft-skill viz work culture, house-keeping, communication skill etc.

12. Practicing of Data entry in Hindi / recognized Regional Language.

13. To have awareness of IT Act’ 2000.

 

MODULE-1

 

Fundamentals of Computers [T(Theory): 160, P(Practical): 180]

 

Unit-I             History of Computers & Fundamentals (T-40)

·        Introduction

·        Definition

·        Type and Classification

·        Computer Characteristics

·        Functions

 

Unit-II           Computer Hardware and Software concepts (T-80)

·        Input devices

·        Output devices

·        CPU, Memory, Secondary Memory.

 

Unit-III          Introducing of Personal Computer Microcomputer and  Operating System.

(UNIX, WINDOWS, MS DOS, NETWARE) (T-15, P-150)

 

Unit-IV          Concept of information & data processing (T-15)

 

Unit-V            First Aid Maintenance (T-10, P-30)

  

MODULE –II

 

Basic Programming Techniques (T:180, P:670)

 

Unit –I             Programming Practice and Techniques (T-25)

Unit-II             Program design & Logic (T-25)

Unit-III           LANGUAGE –C (T-30, P-220)

Unit-IV            Programming and problem solving through C++ (T-60, P-200)

Unit-V             Introduction to business Organization (T-40, P-250)

 

MODULE-III

 

Application / Working with programming packages (T:180, P:554)

 

Unit-I              Office Automation Package (T-40, P-100)

Unit-II             Spread Sheet Package (T-35, P-100)

Unit-III           Xbase package (T-30, P-110)

Unit-IV            An Overview of selected packages, (T-30, P-110)

Unit-V             Basic concept of Networking / Communication (T-30, P-104)

Unit-VI            Data Entry in Hindi/ Recognized Regional Language (T-10, P-30)

Unit-VII          Awareness of IT act (T-5)

Unit-VIII         Development of soft-skill

                         (Will be covered in the time allotted for Extra-Curricular-Activities)

 

 MODULE- I (T:160, P:180)

Fundamentals of  Computers

Unit-I         History of Computer & Fundamentals (T:40)

 

History of Computer

 

·        Abacus of ENIAC. Computer Generation, Languages, Software and application, Computer in India.

 

Computers- An Introduction

·        Functions of computer: input, processing, output, Functions of ALU, control, storage, input and output devices.

·        Application of Computer: viz Railway reservation, Electricity / Telephone billing etc.

 

Types/ Classification

·        Classification of Computers: Home, Micro, Mini, Mainframe, Super Computers.

·        Centralized Decentralized distributed systems.

·        Networks of Computer- Homogenous, Heterogeneous Characterstics.

·        Clock Speed

·        Accuracy

 

Functions

·        Bits, bytes, characters, field, record, file.

Representation of Data : Binary, binary addition and subtraction, octal, hexadecimal,   

                  ASCIT, EBCIDIC, Positive versus Negative integers, Floating point numbers.

·        Higher level and Lower level Languages.

 

Unit-II        HARDWARE AND SOFTWARE CONCEPTS (T:80)

 

·        Computer Hardware; Electronic Digital Computers.

·        Input devices; On line data input & their importance, Dumb terminals, Intelligent terminals, voice recognition devices. Touch tone terminals, Mouse.

·        Offline data input : Key to disk system, key to tape system, Key to punched card.

·        Source data input : Point of Sale terminals, Laser beam scanners, Optical sense readers, Optical Character readers (OCR), Magnetic ink character readers (MICR).

·        Output Devices : Hard copy device- Dot matrix printer, Ink jet printers, Laser printer, Plotter response unit; Micro films.

·        CPU Architecture : ALU : Instruction Execution, Fetch and Execution  cycles, Control unit Micro-programming concept, Speed mismatch between CPU  and Memory.

·        Memory Devices : RAM, ROM, PROM, EPROM, ECC RAM, EDO RAM and their specifications, memory  storage locations, use of memory addressing of programming.

·        Secondary memory Devices : Floppy disk, hard disk (removable/fixed) , Concept of cylinders, tracks, and sectors, Advantage and Limitations of secondary storage, access time, access methods ( Sequential ,Direct, Indexed) & CD-ROM.

 

Software Concepts :

 

·        Application vs. system software, compiler, interpreter, Multiuse, Multitasking operating systems.

·        Virus protection diagnostic tools.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Unit-III      Introduction to PC’s / Micro Computers and Operating System:

 

(WINDOWS-98/2000,MS DOS, NETWARE) (T-15,P-150).

INTRODUCTION TO

PC, PC/XT, PC/AT, LAP-TOP, PALM-TOP, DESK-TOP & Minimum hardware and software configuration of the above.

DOS/ WINDOWS Commands –

·        Profiling an Operating System

·        Booting Sequence: Operating  System files and  Command Processor file.

·        Definitions of a file; File names

·        Booting form floppy and HDD.

·        Warm and Cold reboot.

 

BASIC DOS COMMANDS

Using WINDOWS

·        Start windows

·        Using different windows simultaneously

·        Moving through windows and mouse.

·        Maximize/ Minimize Windows.

·        Use of help feature.

·        Exit Windows.

·        Starting an application.

·        Run and Manage multiple applications.

·        Close applications

Using the Program Manager

 

·        Create/ Add Groups using Program manger

·        Move/ Copy/ Delete Program Items

·        Change Programme/ their properties

·        Expand com0prssed directories and files

·        Open and manage multiple windows

·        View and sort files.

·        Save File Manager Settings.

·        Exist File Manager.

 

Using Desk Top ICONS

·        My Computer

·        Network Neighborhood

·        Control Panel

·        Add Printer

·        Create/ Delete/ Rename Folder

 

File Management Through WINDOWS

·        Select Files and Directories

·        Copy, Move, Delete, Files/Directories.

·        Creating and renaming files/ Directories.

·        Disk Operations using file Manager.

 

 

 

Using Essential Accessories

·        Starting and Using Note-Pad

·        Type and Edit text in a document in Note-Pad

·        Starting and using paintbrush

·        Printing a drawing

Basic Shell Commands of Unix:

·        Date, echo, who, is , cp, rm, mv, cd,

·        Mkdir, rmdir,chmod, sort, grep, passwd, etc.

Communication & Network Concepts:

·        Concepts of batch vs. on line environment.

·        Single user v/s. Multiuser environment, Multi tasking and Multiprocessing.

·        Network management concept.

·        Concept of batch files in MS DOS

 

Unit-IV      Concept of Information & Data – Processing (T-15)

·        Information concepts and processing : evolution of Information processing, data, Information, Language and Communication.

·        Definition of Information : difference between Data and Information ( analogous to rw material or/and finished product).

·        Value of Information : relevance to receiver, decision, decision-making potential.

·        Data concepts : symbols which describe record reality : logical and physical concepts.

·        Logical concepts of data : Entities, Attributes and Rlationships.

·        Physical concepts : storage and Retrieval of data : comparison of manual and computer storage and organization of data as files.

·        Data processing : storage, retrieval and processing of data as files.

·        Data processing : storage retrieval and processing of data, provision of Information of relevance.

·        Techniques/ Methods of Data processing.

 

Unit-V        First aid Maintenance (T-10, P-30)

·        Measuring Main Supply, Earth voltage & checking earthing.

·        Precautionary measures in Handling / Operating.

-VCD, CD, HDD, FDD, DVD, SCANNER

-Modem, Keyboard, Mouse, Hub, Monitor

-UPS, CVT

·        Printers : Dot matrix, Inkjet, Laser

-Feeding paper

-Installing the cartridge

-Refilling the cartridge

  

MODULE- II (T:180, P:670)

Basic Programming Techniques

 

Unit-I         Programming Practice and Techniques (T-25)

·        Data capture and validation, data entry package (Software & Practice)

·        Input form design, data editing, Key to disk system, validation & control.

·        Laboratory exercises on data-entry (speed 8000 characters hrs.) Tele-typewriter, video display terminal, dot matrix printers.

·        Exercise on data collection, data validation and data verification.

·        Exercise on  transferring data from one medium to another/ including back-up & Restore.

 

Unit-II        Program design & Logic (T-25)

• Problem analysis, evolution using step wise refinement Alogrithm. Data Flow Diagrams, structure charts, decision tables, pseudo coding. More emphasis on flow charts and its symbols.
• Illustrations with summing series, sorting, searching mergi9ng Analysis of algorithms-space and time trade offs. Programme documentation, style in programming, program testing. Flow charts and Data Flow Diagrams.
• Program testing land debugging efficient programming techniques Structured programming.

 

Unit-III      Language C (T-30, P-220)

Introduction to C

• Overview of C
• Constants, Variables, and Data types.
• Operators and expression
• Managing Formatted / Unformatted Input and Output
• Decision making and Branching
• Decision Making looping
• Arrays
• Handling of Character Strings
• User defined Functions
• Structures and Unions
• Pointers
• File management in C

 

Unit-IV      Programming and problem solving through C++

                    (T:60, P:200)

• Over view of programming :Introduction to Computer based Problem solving and strategies for the same, Programs Design and implementation issue, Algorithm, Data organization, Data Structures, Use of Procedures for Modular Design, documentation of programs and program  testing.
• Fundamental of  C++ Programming, Structure of C++ programming Data Type, Data Structure, Constants and variables.
• Operators: Arithmetic, Relation and Logical, control if-then, for-while.
• Arrays : Array declaration, one and two dimensional array-Function, General, function arguments, return value.
• Basic I/O : Formatted and unformatted  I/O
• Dynamic Data Structures in C++
• Miscellaneous features: File handling.

 Unit-V        Introduction to Business Organization (T:40,P:250)

• Introduction to Business Organization and their need.
• Introduction to data processing : Record and Files; Data collection, preparation, verification, edition and checking.
• Business files-master, processing sorting searching, merging, sum-marizing.  Business files- Master and Transactional Files; file generation back-ups files recovery procedures.
• Introduction to Accounting and Financial management Types of accounts, books of accounts, simple accounting entries etc.

 Computer Applications :

• Financial Accounting
• Pay Roll and invoicing application.
• Budgeting and planning.
• Cost Accounting.
• Inventory and state Control
• Sales Accounting and Sales Analysis etc.

 

MODULE-III (T:180, P:554)

Application / Working with Programming Language.

Unit-I         Office Automation Package (T-40, P-100)

(MS Office: Word, Excel etc.)

WORD PROCESSING PACKAGE

Basics of Word processing

• Text selection
• Opening Documents and Creating Documents
• Cursor Control
• Printing Documents
• Using the Interface (Menu, Toolbars)
• Editing Text (Copy, Delete, Move etc.)
• Finding and Replacing Text.
• Spell Check Feature / Auto correct Feature, Grammar Facility.
• Auto text, Character formatting, page formatting.

 

DOCUMENT ENHANCEMENT

• Adding borders and shading, Headers and Footers.
• Setting Up Multiple columns, Sorting blocks, margins and Hyphenating Documents
• Creating Master Document, Data Source
• Merging Documents
• Using Mail merge Feature for Lables and envelopes

 

Graphics and using Templates and Wizards

• Hands-on experience in word processing under DOS
• Familiarity in Word processing under Windows.

 Unit-II        SPREADSHEET PACKAGE (T-35, P-100)

Usage of MS-Excel,

Worksheet Basics

• Data Entry in cells, entry of numbers, text and Formula
• Moving data in a Worksheet
• Moving around in a worksheet
• Selecting Data range
• Using the Interface (Toolbars, Menus)
• Editing basics
• Working with Workbooks
• Saving and Quitting
• Cell Referencing

 Formatting and Calculations

• Calculations and Worksheets-Using Autofill
• Working with formula
• Efficient Data Display with Data Formatting, Number formatting etc.
• Working with ranges
• Worksheets printing

 Working with Graphs and Charts

• Adding/ Formatting Text data with Autoformat
• Creating Embedded Chart Using Chart wizard
• Sizing and moving parts
• Updating Charts
• Changing Chart Types
• Creating Separate Chart Sheet
• Adding Titles, legends and Grandlines
• Printing charts.

 Database Management                        

• Finding Records with Data Form
• Adding/ Deleting Records
• Filtering Records in a worksheet

 

Unit-III      XBase package (T-30, P-110)

• Concept of data base management  System
• Difference Data Base Files and Structures
• Editing Data Base Files
• Record pointer positioning features
• Specific record locating features
• Information display commands
• Indexed files
• Create, delete, save and recall memory variables.
• Using in-built report and label facility
• Using table facility
• Format files
• Using various functions and set commands available
• Handling of multiple database files

Developing programming for Commercial Application using Windows based, X-base package.

 

Unit-IV      An Overview of Selected packages (T-30, P-110)

• Desktop publishing
• Popular package on Communications like CCMAIL, PRUCOMPLUS etc.
• Presentation Graphics features, CorelDraw, PowerPoint etc.Multimedia / Animation package.

 

Unit-V        Basic Concepts of Networking/Communications :

(T-30, P-104)

• Concept of Networking, LAN, WAN, & Email
• Internet Connection Setup & Sharing.
• Protocols TCP/IP, FTP, ISP, NSP etc.
• Concept of Proxy server, Web server, Client server etc.
• Concept of Sites & pages
• Introduction to BIML, DHTML, XML.
• Designing Web-Pages : Static & Dynamic.

 

 

 

Unit-VI      Data Entry in Hindi / Recognized Regional Language (T-10, P-30)

• Data Entry

 Unit-VII     Awareness of IT- Act 2000 (T-5)

• Provisions of Act
• Types of offences, Fines, Imprisonment

 

Unit-VIII    Development of Sort Skills

(Will be covered in the time allotted for Extra-Curricular-Activities)

• Work Culture
• House Keeping
• Communication Skill
• Personality Building viz. punctuality, obedience, inter-personal-com-minication
• Group-activities : Sports, Debates, Tree plantation, Gardening & Indl. Visit etc.
• Preparation for Viva/ Interview.