INTRODUCTION TO COMPUTER APPLICATONS
I. PREAMBLE: Computer is now affecting every sphere of human activity, It is instrumental in bringing revolutionary changes in industry, scientific research and education. This is not only the demand of time but also the demand of almost each and every subject to have an associated computer learning to equip a student with state-of-art technology to prove himself/herself a better candidate than those without computer knowledge.
Since the C.B.S.E. has been foremost in giving best to its clientele, a single paper as per requirement of industry has been designed in such a way that it can be taken as an independent subject along with any combination of vocational packages.
This paper has been designed keeping in view the need and demand of computer industry.
II. OBJECTIVES The course is designed to fulfil the following objectives
i) Familiarisation with computers dominated technological world.
ii) To impart adequate know how to students to be able to take up entry level jobs in the area of Data Processing.
iii) Exposure of utility and applications of computers.
iv) To get acquaintance with the basic of Computer Science and lay found- ation for higher education/careers in Computers in conformance with industry requirements.
v) Application of computers in the specific areas such as accounting & auditing, stores accounting, office management & sec. practice, textile designing.
vi) Algorithmic approach to problem sovling.
vii) To use computer effectively and efficiently by acquiring working knowledge of PC softwares.
viii) Familiarisation with Data Processing environment and Data Processing terminology.
III. CAREER OPPORTUNITIES 1. Data Entry
2. Computer operations
3. Word Processing
4. Data Processing assistant
5. Documentation assistant
10
SYLLABUS OUTLINE
1. Module I Introduction to Computers
2. Module II Data Processing
3. Module III Operating Systems
4. Module IV Word Processing
5. Module V Logic Development & Programming concepts
6. Module VI Electronic Spread sheet I
7. Module VII Database Management System - I
8. Module VIII Word Processing - II
9. Module IX Electronic Spread sheet II
10. Module X Database Management System - II
11. Module XI Concepts of System Analysis & Design
12. Module XII Trends in Information Technology
13. Module XIII Practicals other than sessional work and hands on practice
of above packages. The familiarity with working (input
formats data entry reporting procedure, reports generation)
of any one of the packages related to specific areas i.e.
(i) Standard accounting package
(ii) Standard inventory package
(iii) Standard Hotel Management package
(iv) Standard DTP packages such as VENTURA
PAGEMAKER
(v) Standard Textile and Design package
(vi) Standard Library and Information Science package
14. Module XIV Project work
INTRODUCTION TO COMPUTER APPLICATIONS
3 HOURS CLASS XI MARKS 40
Theory
Module I: Introduction to computers 4
- Historical Background with generations
- Computer and its characteristics
- Application areas
- Organisation and architecture of Computer (PC family)
* Block diagram
* Input/output units and devices
(Keyboard, VDU, printers, plotters, OCR, OMR etc.)
* Central Processing Unit
* Primary Storage (memory architecture)
* Secondary Storage unit and devices
(Floppy, tape, disk, cartridges etc.)
- Computer classification (micro, mini, mainframe etc.)
- Computer terminology (Bit, Byte, MB, GB etc.)
- Data representation in Computers
* Computer codes
* Binary and decimal no. system
Module II : Electronic Data Processing 4
- Hardware/Software concepts
- Classification of software
* Application software
* Systems software
* High level and low level languages
- EDP concepts and terminology
* Data, Record, File and database
* Data processing and information
- Data Preparation
* input data formats
* Data entry
* Data validation and collation
- Data Processing
* Business data Processing using BASIC, COBOL etc.
* illustration of some small sample programs
12
Module III : Operating System 4
- Single user operating system
- MS-DOS as single user disk operating system
- internal DOS commands
(change of drive B:, C:, DIR, REN, TYPE, COPY, VER, ERASE DELETE,
DATE, TIME, CLS, MD, CD, RD, PATH etc.)
- External DOS commands
(CHKDSK, FORMAT, COMP, DISKCOPY etc.)
- Error messages
(Bad command or file name, Not ready drive, Data reading drive error,
General failure error)
Module IV: Word Processing - I 4
- Concepts of word processing
- Document and non document files
- opening a file and text entry
- Cursor movement and control
- Saving and printing the text
- Block operations
* forming a block
* block movement
* deleting a block
- Formating the text
* margin setting, page length setting
* single space and double space text
* tab setting etc.
- Creation of non document files
- mailmerge using Computer
- formating of text
* Page layouts
* header
* footer
* fonts setting
- Prining with various fonts
- Bilingual word processors
Module V : Logic Development & Programming Concepts 6
- Computer instructions and Programming
- Flow Charting concepts
13
* Flow chart - a traditional approach for programming
* Flow chart symbols
* Drawing a flow chart
* Algorithmic approach of programming
* Algorithmic development
* Advantages of flow charting and algorithm before programming
and coding
Module VI : Electronic Spreadsheet - I 6
* Introduction to electronic spreadsheet
* Spreadsheet terminology
* Cell, column, row, cell address etc.
* Moving around Spreadsheet
* Cursor movement and control
- Creating a Spreadsheet
* Lable, numeric and formula entry
- General Spreadsheet, commands (Copying a text, moving
a text etc.)
- Saving a Spreadsheet
- Printing a Spreadsheet
- 'What if' analysis (data manipulation in Spreadsheet)
business graphics
* Setting of X and Y ranges
* Saving and naming graphs
* Printing a graph
Module VII :.Data base management system (DBMS) - I 6
- Concepts of DBMS
* What and why a database
* Applications and advantages of databases
* Database terminology
* Types of data fields
- Creating and appending database
- Database manipulation
* Adding records into database
* Deleting records
* Editing records
* Modifying structures
- database queries
* Viewing a database
14
* Conditional queries and scopes
- Report generation
* Report creation
* Report formatting
* Report generation
Module VIII : The familiarity with use/working (Input formats, data entry
reporting procedure, reports generation) of any one of the
packages related to specific areas i.e. 6
(i) Standard accounting package
(ii) Standard inventory package
(iii) Standard Hotel Management Package
(iv) Standard DTP packages such as VENTURA , PAGEMAKER
PRACTICAL
INTRODUCTION TO COMPUTER APPLICATIONS
3 HOURSE 60 MARKS
I. 'HANDS ON' PRACTICE 45
(i) Operational Exercise based on Module II 10
(ii) Operational exercises based on Module III 05
Use of various DOS commands
(internal as well as external)
(iii) Operational exercises based on Module IV10
Opening of document file, text entry, block operation,
on screen, formating etc.
(iv) Exercises based on Module VI 10
Creating a worksheet text entry, value entry & formula
entry, various worksheets command such as copy, move etc..
such 'What if' analysis
(v) Exercises based on Module VII 10
File creation data entry, file structure/modification, data editing
report format creation & report generation
15
II. Viva-Voce 05
(i) Questions related to above exercises allotted
(ii) Questions related to given syllabus above
III. Sessional Work 10
Assignments related to syllabus
16
INTRODUCTION TO COMPUTER APPLICATIONS
3 HOURS CLASS XII MARKS 40
Theory
Module I : Word Processing II (Advanced Features)7
- Special print features & Dot Commands
* Bold, facing, double, striking, overstriking,
Underlining Subscripts, Superscripts.
* Binding spaces, printing special characters.
* Dot Commands
- Page Length, page numbering, Page offset, forcing a page break,
preventing a page break.
- top & bottom margins, headers & footers, character width.
- Printing Out
* Naming files to be printed
* where to start & stop paging with form feeds, suppressing formating,
pausing between pages.
* Interrupting the sprint out.
- Search & Replace
* Searching using Wild card characters, searching & replacing options.
* Using place markers, ignoring uppercase & lowercase
- Spellstar
* Spell checking a document and a word
* Choosing a dictionary, Using a supplemental dictionary proofing
a file.
* Marking and Correcting misspelled words.
* Creating and revising dictionaries.
* Looking-Lip synonyms.
- Math operations, line drawing & special symbols
* Math calculations using on-line calculator
* Using block math to total numbers
* Line and box drawing, Entering special symbols in the document,
Inserting current date & time.
- The Shorthand Feature
* Creating & Saving Macros
* Macros that save typing and perform word-processing commands
* Limitations of shorthand feature
17
* Executing macros, Revising macro definitions, creating your own
macros, chaining macros.
- Indexes & Table of Contents
* Creating an index
* Creating a table of contents
- Merge operations
* Basic Merge Printing
- The data file, Creating Master file, performing the merge, mailing
labels & envelops.
- Advanced Merge Operations
* Using predefined variables, entering variables from keyboard, setting
values for data variables.
* Formatting data variables
* Performing math operations in Merging
- Merging entire files, Chain Printing.
- Conditional Merge Commands - IF, ENDIF, ELSE, GO
Module II : Electronic Spreadsheet - II 7
(Advanced Features)
* Graphing the spreadsheet
* Converting spreadsheet to a graph, Labelling the graph changing scales
on axes, adding a background graph, adjusting colour
* Naming, Saving & Using graph
* Displaying a line graph with symbols and data graph, printing the
graph
* Creating a pie chart, using quick graph.
- Database Management
* Creating a database, Sorting and quering the database
* Using database & functions to derive totals
* Building data tables, Building a frequency distribution table.
- Macros
* Building a simple macro, Using Keynames
* Debugging macros
* Using learn feature, Using advanced macro Commands.
* Creating customized menus with macros, creating an automatic macro
* Using macro library manager
18
- Functions
* Applying commonly used functions SUM, AVG, HOOK UP, IF, DATE, COUNT, MAX, MIN
Moduel III : Database Managment System (DBMS) - II 7
- The Reporting Process * The Report Format File, Creating format files, Reporting from multiple databases, simultaneously, Using Relationships based on key fields, taking totals & Subtotals in report
* Using relationships based on record nos and data fields, Vertical formats, multiple Main & Column Heading, Lines, Using variables in Auxiliary header
* The immediate IF function, Taking totals in Reports and multiple Vertical formats, Subtotals in report
* The WHILE parameter for Report Formats, Generating Mailing labels.
- Configuring dBASE The Set Commands.
SET BELL, SET CARRY, SET COLOR, SET CONSOLE, SET DECIMALS, SET DEFAULT, SET DELETED, SET EXACT, SET FILTER, SET FIXED, SET FUNCTION, SET INDEX, SET INTENSITY, SET MENU, SET PATH, SET RELATION, SET SAFETY, SET TALK, SET UNIQUE
- Programming in d-Base III Plus
* Creating Command file with Modify Comments * Making decisions with IF and ENDIF, DO CASE, MCRO Substitution * Setting up loops in programs with Do while and endo running command files with do * Designing and developing programs - Outline the General idea - Design the database structure - Develop pseudocode - Writing the program - Run & Test the program