ELEMENTARY COMPUTER APPLICATION

 

Theory     : Max.Marks 40
Workload : Three periods / two hours per week
Theory examination paper will consist of two parts:
Paper-I (Duration One Hours)(Max. Marks20) consists of 40 multiple-choice questions With four choices and student will have to pick the correct one. The questions will be sat from Unit—1 only. 

Paper-II (Duration one hour) (Max. Marks20) Consisting of 5 Very short answer Question (up to 50 words) (one marks each) and five short answer question (upto 150 words) (Three marks each). The questions will be set from unit—2,3 and 4. 

Unit-1 :Introduction to Computers and related Terminology

            (Basic information only)

(a)      Hardware: CPU (Motherboard, Microprocessor, The Intel     Pentium III, and Cyrix), MMX Technology, System clock address bus, data bus (PCI and EISA) Cache Memory, Processing Speed, Expansion Slots   (Video controller, sound cards, SCSI, Network Card), Memory—(Unit, RAM, ROM, EDRAM, SDRAM), Input and output Devices—(keyboard, the standard keyboard layout), Mouse, PRINTER, (Dot matrix, Ink-Jet, Laser-Jet), Microphone, Speakers, Modem, Scanner, Density, formatting, boot Recoard,FAT ,Folder Directory), Hard Disk Drive, CD-ROM Drive (CD ROM Speeds). CD-R Drive, DVD Rom Drive, Tape Drive).

(b)      Software: Introduction to programming, Languages, System Software (Operating Systems and Utilities), Application Software (Word Processors, DBMS, Presentation Graphics, Browsers, Personal Information Managers), Introduction to Multilingual Word-Processors.

(c)       Communication and connectivity: data communication systems data Transmission (Serial, Parallel, bandwidth, Protocols), E-mail, FAX, voice and Video messaging, video conferencing, online Services, user connection (types), Networking of computers (node, Clint, server, LAN, WAN), using the network, the internet and the web. 

Unit-2 Operating System

            (Working knowledge at Common Users Level Only)

overview of important DOS commands. Windows 98: Installation Scandisk, control Panel,  Taskbar, Toolbar ,Display,  Setting  (Background, Wallpaper, Screensaver , Desktop Themes). Files and folders management, windows explorer, finding files and folders. Formatting Disks and Copying files, Printer Setting, modem Installation, mouse installation, adding and Removing Program, Active Desktop Concepts, WinZip and its applications, Norton antvirus and its use of  calculator, paintbrush, sinamp, MPEG Player and windows Help. 

Unit –3 Application Software

 (Working knowledge at Common Users Level Only)

(a)   Word Processing, Software MS word, Entering, Editing and formatting Text, Document Formats,(Page size and orientation, Headers and Footers, Columns  and section, Page layout), spelling and grammer checkers, Thesaurus, find the Replace, cut and Paste, Table and formatting tables, Mail Merge, styles and Templates.

(b)   Spreadsheet Program—MS excel

Entering data, labels, values, dates, formulas, cell references. Formats, function Templates, Charts and Maps, Analyzing data in a spreadsheet.

(c)    DBMS—Microsoft Access

            Database, Entering data into the database. Creating database tables, editing data. Viewing   
            Records, Shorting records. Querying a database, generating reports.
 

Unit-4 :The Internet and Online Resources

(Working knowledge at Common Users Level Only) How the internet works, introduction to TCP /IP, IP and DNS address. Features of the internet (E-mail, News, Telnet, FTP, Chart, Channel, WWW, online Services, Bulletin Board Services), Connecting to a PC to the internet (Setting Dial up and Internet connection wizard), Overview of internet Explorer 5 and Features therein, use of search engines, surfing, creating and use of E-mail, Awareness about e-commerce and its advantages.

 Practical Max. Marks 60
Workload: four Period / Three hours per week
.
 

Course: Practical Training of course content of unit unit 2,3 and 4 of theory Syllabus. 

The Practical examination will be of four-hour duration. It will consist of four small exercise testing the working knowledge of followings each carrying a weight as given below—

1. Course content in Unit 2 of Theory                              Max.Marks 10

2. Course content in Unit 3 (a) of Theory                         Max.Marks 10

3.  Course content in Unit 3(b) of Theory                         Max.Marks 15

4. Course content in Unit 3(c) of Theory                          Max.Marks 15

5. Viva- Voce Examination                                             Max.Marks 10


Vocational courses

1.    COMPUTER APPLICATIONS (Under Graduate Courses) 

B.A./B.COM./B.SC. PART I                                        Max. Marks

                                                                         B.Sc.                B.A./ B.Com.

 

Paper-I  Computer Fundamentals and                   50                    65

  Introduction to IBM PC

Paper-II Operating Systems and                           50                    65

              Business Data Processing

Practical Programming Laboratory                         50                    70

            On- the- job training 4 weeks 

            The duration of these papers will be 3 hour. 

Paper-I : Computer Fundamental and Introduction of IBM PC

What is computer—an introduction Uses of computer in modern society e.g. weather forecasting, censure, oil exploration, speech recognition, banking, publishing, accounting, Reach etc. 

Information concepts and processing—evaluation of information Processing—data, information, language and communication. 

Computer arithmetic and number systems. ASCII & EBCDIC character sets. 

Elements of a computer processing system—hardware software—Computer capabilities and limitations. Concepts of files and directories. 

Hardware features and use—CPU, I/O devices Storage devices and media. Introduction to networking, multiprocessing, time sharing, multitasking and real time computing . 

Variety of networking system and features. Various types of computers available in market. Micro, Mini and Main frames, Supercomputers. 

Evolution of personnel computer. Commodore, Atari, Apple. IBM, PC. Basic block diagram of computer difference between personal and main Frames—Simply operating system, Easy to use, Less memory, Dedicated, Normally single user. 

Introduction to microprocessors and associated computer. Timers, display controllers DMA controllers. 

Block diagram of IBM PC. Introduction to 8086 and 8088. functional description of various modules and cards.

            Boot process in IBM PC. System files self test.
           
Various types of displays and other peripherals used in IBM PCs.           

            Disk operating System—introduction. Batch files.
            Configuration files.COM, EXE, SYS, BIN and TXT files. Introduction programming in
            BASIC. Development of programs in QBASIC. Use of Graphics facilities using Basic.

Diagnostics for IBM PC. Use of Norton Utilities and other packages for
            deleting a file and other system maintenance jobs.
            Advanced version of IBM PCs and compatibles.
 

Practical

Visit computer Lab. Introduction to various components of a computer. Simple documentation preparation and printing. Usage of printer and other Components.

Physical inspection of IBM PC and internal cards, introduction to Menclature (COM 1, COM 2, etc.).Writing batch files for various purposes. Modifying config-sys files. Creating RAM Disk. Diagnostics on IBM PC. Controlling PC hardware using BASIC programs. 

Paper-II : Operating System and Business Data Processing 

                          Introduction to various categories if software. Operating system and its function.
                          Interaction of operating system with hardware and user programs
 

                         Various components of operating system with reference to DOS. Single operating
                      
   system. Task loaders. Memory management. File management, directory structure in
                         DOS Moving, Renaming, copying, deleting and undulating files under DOS. 
                         Devices Management, control of various devices. Device drivers. Interrupt even and poll
                         driven data transfers. Need of software and hardware Protocols.
 

BIOS, DOS, DOS internet and external commands. Use of DOS commands. Taking and restoring backups. BIOS and DOS interrupts. 

Multiuser, multitasking, multiprocessing and real time operating systems. Introduction to Memory management techniques.
Files systems. files management . process management and scheduling. Special requirements and facilities for multiprocessing environment. Example of multiprocessing in Unix commands
 

Introduction to data processing, records and file, data collection, Verification, editing and checking.
Overview of business function. Use of computer system for business applications.
Spread sheets. Macros. use of  spared in business.

Business files. Introduction to data structures: Elements Fields Records . Classification of files. Master files . Transaction files.

Distributed processing. Various facilities for business computing Introducing to databases.

Practical

Development of a batch file to install a software from floppy to disk Development of batch file to manage various packages on the disk Detection of viruses and protection on IBM PC. Using shell script for elementary data processing. 

Creation of shell script to manage disk quota on a Unix system. Creation of shell scripts to manage mail. Using shell scripts for processing data. 

Analysis of a business system on paper.
            Using spread sheets for payroll, balance sheet and other business applications. Design of
            packages using spreadsheet macros.


Vocational Subjects

           COMPUTER APPLICATIONS

(Under Graduate Courses) 

B.A./B.COM./B.SC. PART II                                 Max. Marks

                                                                          B.Sc.               B.A./ B.Com.

 

Paper-I  Data Base management System              50                    50

             

Paper-II Structured programming                          50                    65
         
    and computer Graphics

Practical Programming Laboratory                         50                    70                       

On- the- job training 4 weeks 

The duration of these papers will be 3 hour. 

Paper-I: Data Base Management System

Categorization of DBMS system. Network. Hierarchical and relational database, Application of DEMS systems.                       

Relational data bases management systems. Why to use them and where. Data Description Language and data control Language. 

Introduction to DBASE, DBASE commands. Development of an application under DBASE using forms, secreen and, PRG files security considerations in database management systems Performance improvement in database. 

Relational database- advanced concept. Introduction to ORACLE / INGRES or a similar RDBMS on a multiuser environment. 

Structured query language. From design on a advanced RDBMS. Report generator, Query by example and Report by form. Accessing RDBMS using programming languages. 

System management. User management. Security considerations. Practical. 

Design of a database for a business application. Design of data entry forms and reports layout for this database. Creation of  Programs to access and manipulate database. 

Development of business application in RDBMS. 

Paper-II :Structured Programming and Computer Graphics

Introduction Need of structured programming. Methods of documentation. Methods of analyzing a program requirements. Data flow diagram entity relationship. Flow charts.
Various categories of programming language (3GL,4GL,etc.) Introduction to C and Cobol. Program development in C using structure programming concepts.
 

Why Graphics. Various types of graphics programs. Drafting Packages. DTP packages. Microsoft windows. Various documentation cum DTP packages e.g. WordPerfect, Microsoft word etc. 

Introduction to a PageMaker/ Ventura or a similar package. Preparation of documents using DTP package. Formatting. Various fonts and character set. Various type of printers used in DTP. Introduction to

commercial DTP System available in market. Indian language fonts. Creation of Indian language fonts.  

Practical 

                        Development of a business application using C.
                        Preparation of a document and publishing it using a DTP system creation of fonts.
                        Managing a Microsoft window session. Creating groups and program items under windows
                        Turning windows for a computer system.
 


Vocational Subjects
           COMPUTER APPLICATIONS
           (Under Graduate Courses)
           B.A./B.COM./B.SC. PART III                                          Max. Marks

                                                                                    B.Sc.                B.A./ B.Com. 

Paper-I   :Computer Aided Drafting                                  50                    65             

Paper-II  :Advanced Topic in Computers                           50                    65             

Practical :Report, Report on the Job training                     50                    70
                Entrepreneurship, Development

The duration of these paper will be 3 hours.
Paper-I :Computer Aided Drafting

Introduction to AUTOCAD / ROBOCAD or a similar package. Advanced features of these package. Drawing the plan of a building using AUTOCAD etc. Analysis features of AUTOCAD.

 

            Paper-II : Advanced Topics in Computer

                       Computer animation. Artificial intelligence. Desiccated computer.ATMs. Data encryption.
                       Data communication and networking (courses to be modified every year to take care of the
                       latest developments).  Visits to computer industry. 

 

            Practical :

Design of layout of a building. Design of interior of its rooms. Printing and plotting the prepared drawings. It will also include Projects Reports, on the job training and entrepreneurship development.



COMPUTER APPLICATION IN ACCOUNTING

 

Optional Paper : II

Theory    : 50 Marks

Practical : 50 Marks

 

Min. Pass Marks-36                               3 hrs duration                      Max Marks-100 

Note- Candidates to required to attempt one question form each section and five question in all. 

Section-A

  1. Automated data processing, development of computer, types of computer, hardware and software.

  2. Binary code system, binary arithmetic, words, bytes and bits, introduction to other number system (octal and hexadecimal), computer languages.

  3. Introduction to flow charts, flow diagram importance, symbols and their application

 Section-B
    4.   Introduction to BASIC language: characteristics constants variables and expressions, READ,
          PRINT, AND DATA statements, CONTROL statements.
    5.   Programming in BASIC language-simple programmes.
    6.   Business applications: Payroll, inventory control, financial accounting and EDP audit. 

Section-C
    7.  Introduction to COBOL language-History of COBOL, coding format, structure of a COBOL
         program, character set, COBOL words, data names and identifiers, laterals, four division of  COBOL.
    8.  Procedure division and basic verb-Move, arithmetic verbs, sequence control verbs, input and
         output verbs, conditionals verb.

     9.  Writing simple COBOL programmes