ICSE Class 9 Syllabus 2028 Basic Data Entry Operator

ICSE
INDIAN CERTIFICATE OF
SECONDARY EDUCATION
EXAMINATION
YEAR 2028

BASIC DATA
ENTRY OPERATOR
(67)

Developed by:
Research, Development and Curriculum Division (RDCD)
CISCE

January 2026
____________________________________________________________________________________________

© Copyright, Council for the Indian School Certificate Examinations
All rights reserved. The copyright to this publication and any part thereof solely vests in the Council for the Indian
School Certificate Examinations. This publication and no part thereof may be reproduced, transmitted, distributed or
stored in any manner whatsoever, without the prior written approval of the Council for the Indian School Certificate
Examinations.

Council for the Indian School Certificate Examinations (CISCE)

MISSION STATEMENT

The Council for the Indian School Certificate
Examinations is committed to serving the nation's
children, through high quality educational
endeavours, empowering them to contribute towards
a humane, just and pluralistic society, promoting
introspective living, by creating exciting learning
opportunities, with a commitment to excellence.

ETHOS OF CISCE

Trust and fair play.
Minimum monitoring.
Allowing schools to evolve their own niche.
Catering to the needs of the children.
Giving freedom to experiment with new ideas
and practices.
Diversity and plurality - the basic strength for
evolution of ideas.
Schools to motivate pupils towards the
cultivation of:
Excellence - The Indian and Global
experience.
Values - Spiritual and cultural - to be the bedrock
of the educational experience.
Schools to have an 'Indian Ethos', strong roots in
the national psyche and be sensitive to national
aspirations.

BASIC DATA ENTRY OPERATOR
(Subject Code: 67)

(Sector: Information Technology)

OVERVIEW
Basic Data Entry Operator in the IT-ITeS Industry is also known as Data Entry Operator. These
individuals are responsible for entering data into different computer databases. Individual tasks
vary depending on the size and structure of the organization. This job requires the individual to
have thorough knowledge of various technology trends and processes as well as have updated
knowledge about database management systems and IT initiatives. The individual should be fast
and accurate in typing/data encoding. This job involves entering data, checking accuracy of data
that has been inputted, resolving discrepancies in information, and obtaining further information.
These individuals are also responsible for creating back-ups and retrieval of information upon
request.
OUTCOMES:
On completion of the course, students should be able to:
 apply effective oral and written communication skills to interact with people and customers;
 demonstrate self-management skills;
 demonstrate the ability to provide self-analysis in context of entrepreneurial skills and abilities;
 demonstrate the knowledge of the importance of green skills in meeting the challenges of
sustainable development and environment protection;
 work safely on a computer;
 identify the principal components of a computer system;
 demonstrate the basic skills of using a computer;
 start the computer;
 open and use the related software;
 exit from the software;
 shut down the computer;
 use the computer for data entry process;
 collect all necessary information about the query;
 log any decision about the query on the data entry tracking form;
 follow rules and guidelines for data entry;
 handle queries;
 undertake data entry with speed and accuracy;
 identify and control hazards in the workplace that pose a danger or threat to their safety or
health or that of others.

1

Class IX
There will be one written paper of two hours duration carrying 100 marks and Internal
Assessment of Practical of 100 marks.
COURSE STRUCTURE:
PART I: THEORY – 100 MARKS
Employability Skills – 30 Marks
Unit 1: Communication Skills – I
Unit 2: Self-management Skills – I
Unit 3: Basic Information and Communication Technology Skills – I
Unit 4: Entrepreneurial Skills – I
Unit 5: Green Skills – I
Vocational Skills – 70 Marks
Unit 6: Introduction to IT-ITeS Industry
Unit 7: Data Entry & Keyboarding Skills
Unit 8: Digital Documentation (Elementary)
Unit 9: Electronic Spreadsheet (Elementary)
Unit 10: Digital Presentation
PART II: INTERNAL ASSESSMENT (PRACTICAL) – 100 MARKS
Practical Work – 70 Marks
Practical Examination – 40 Marks
Practical File – 10 Marks
Viva Voce (based on Practical Examination/File) – 20 Marks
Project Work – 30 Marks
Report of Field Visit/Project – 10 Marks
Student Portfolio – 10 Marks
Viva Voce (based on Report of Field Visit/Student Portfolio/Project) – 10 Marks

2

PART I: THEORY – 100 MARKS
Employability Skills
Unit-1: Communication Skills – I
Learning Outcome 1.1: Demonstrate knowledge of various methods of communication

Theory Practical

1. Methods of communication:  Writing pros and cons of written, verbal, and
non-verbal communication
(i) Verbal
 Listing dos and don’ts for avoiding common
(ii) Non-verbal
body language mistakes
(iii) Visual

Learning Outcome 1.2: Identify elements of communication cycle

Theory Practical

1. Meaning of communication  Draw a diagram of communication cycle
2. Importance of communication skills  Role plays on communication process related
to the sector/job role
3. Elements of communication cycle:
(i) Sender
(ii) Ideas
(iii) Encoding
(iv) Communication channel
(v) Receiver
(vi) Decoding
(vii) Feedback

Learning Outcome 1.3: Identify the factors affecting our perspectives in communication

Theory Practical

1. Perspectives in communication  Group discussion on factors affecting
perspectives in communication
2. Factors affecting perspectives in
communication:  Sharing of experiences on factors affecting
perspectives
(i) Visual perception
 Sharing experiences on factors affecting
(ii) Language communication at workplace
(iii) Past experience
(iv) Prejudices
(v) Feelings
(vi) Environment

3

Learning Outcome 1.4: Demonstrate the knowledge of basic writing skills

Theory Practical

1. Writing skills related to the following:  Demonstration and practice of writing
sentences and paragraphs on topics related to
(i) Phrases the subject
(ii) Kinds of sentences
(iii) Parts of sentence
(iv) Parts of speech
(v) Use of articles
(vi) Construction of a paragraph

Unit-2: Self-management Skills – I
Learning Outcome 2.1: Describe the meaning and importance of self-management

Theory Practical

1. Meaning of self-management  Identification of self-management skills
2. Positive results of self-management  Strength and weakness analysis
3. Self-management skills

Learning Outcome 2.2: Identify the factors that help in building self-confidence

Theory Practical

1. Factors that help in building self-confidence –  Role play exercises on building self-
social, cultural, and physical factors confidence
2. Self-confidence building tips – getting rid of  Use of positive metaphors/words
the negative thoughts, thinking positively,
 Positive stroking on waking up and before
staying happy with small things, staying
going to bed
clean, hygienic, and smart, chatting with
positive people, etc.  Helping others and working for community

Unit-3: Basic Information and Communication Technology Skills – I
Learning Outcome 3.1: Demonstrate the knowledge of the role of Information and
Communication Technology (ICT) in day-to-day life and
workplace

Theory Practical

1. Introduction to ICT  Discussion on the role and importance of ICT
in personal life and at the workplace
2. Role and importance of ICT in personal life
and at the workplace  Preparing posters/collages for showing the
role of ICT at workplace
3. ICT in our daily life (examples)
4. ICT tools – mobile, tab, radio, TV, email, etc.

4

Learning Outcome 3.2: Identify components of basic computer system and their
functions

Theory Practical

1. Computer system - Central Processing Unit  Connecting the cables and peripherals to the
(CPU), memory, motherboard, storage Central Processing Unit
devices
 Starting and shutting down a computer
2. Hardware and software of a computer system
 Group discussion on the various aspects of
3. Role and functions of Random Access hardware and software
Memory (RAM) and Read-only Memory
(ROM)
4. Role and functions of Central Processing Unit
5. Procedure for starting and shutting down a
computer

Learning Outcome 3.3: Demonstrate use of various components and peripherals of a
computer system

Theory Practical

1. Peripherals devices and their uses – mouse,  Identification of various parts and peripherals
keyboard, scanner, webcam, etc. of a of a computer
computer system
 Demonstration and practice on the use of a
mouse
 Demonstration and practice on the use of a
keyboard
 Demonstration of the use of printers,
webcams, scanner, and other peripheral
devices
 Drawing a diagram of a computer system and
labelling it

Learning Outcome 3.4: Demonstrate basic computer skills

Theory Practical

1. Primary operations on a computer system –  Identification of the various input and output
input, process, storage, output, units and explanation of their purposes
communication, networking, etc.

Unit-4: Entrepreneurial Skills – I
Learning Outcome 4.1: Identify various types of business activities

Theory Practical

1. Types of businesses – service, manufacturing,  Prepare posters of business activities found in
hybrid cities/villages, using pictures
2. Types of businesses found in our community,  Discuss the various types of activities,
business activities around us generally adopted by small businesses in a

5

local community
 Best out of waste
 Costing of the product made from waste
 Selling of items made from waste materials
 Prepare list of businesses that provide goods
and services in exchange for money

Learning Outcome 4.2: Demonstrate the knowledge of distinguishing characteristics of
entrepreneurship

Theory Practical

1. Meaning of entrepreneurship development  Prepare charts showing advantages of
entrepreneurship over wages
2. Distinguishing characteristics of
 Group discussions on the role and features of
entrepreneurship
entrepreneurship
3. Role and rewards of entrepreneurship
 Lectures/presentations by entrepreneurs on
their experiences and success stories
 Identify core skills of successful
entrepreneurs

Unit-5: Green Skills – I
Learning Outcome 5.1: Demonstrate the knowledge of the factors influencing natural
resource conservation

Theory Practical

1. Introduction to the environment  Group discussion on hazards of deteriorating
environment
2. Relationship between society and
environment, ecosystem and factors causing  Prepare posters showing environment
imbalance conservation
3. Natural resource conservation  Discussion on various factors that influence
our environment
4. Environment protection and conservation

Learning Outcome 5.2: Describe the importance of green economy and green skills

Theory Practical

1. Definition of green economy  Discussion on the benefits of green skills and
importance of green economy
2. Importance of green economy
 Prepare a poster showing the importance of
green economy with the help of
newspaper/magazine cuttings

6

Vocational Skills
Unit-6: Introduction to IT–ITeS Industry
Learning Outcome 6.1: Appreciate the application of IT in IT-ITeS industry

Theory Practical

1. Introduction to IT and ITeS  Identify and list the various IT-enabled
services
2. BPO services
 Observe the application of IT in various areas
3. BPM industry in India
4. Structure of the IT-BPM industry
5. Applications of IT in home computing,
everyday life, library, workplace, education,
entertainment, communication, business,
science and engineering, banking, insurance,
marketing, health care, IT in the government
and public service

Unit-7: Data Entry and Keyboarding Skills
Learning Outcome 7.1: Use data entry tools, keyboard, and mouse

Theory Practical

1. Keyboarding Skills  Identify the keys and their use on the
2. Types of keys on a keyboard keyboard
3. Numeric keypad  Demonstrate to use various keys on the
4. Home keys, guide keys keyboard
5. Typing and deleting text  Demonstrate to type the text, numbers,
special characters using appropriate keys on
6. Typing ergonomics
the keyboard
7. Positioning of fingers on the keyboard
 Practice the correct typing ergonomics
8. Allocation of keys to fingers on four different
rows  Practice to place fingers on correct keys in
four different rows of the keyboard
9. Pointing device – mouse
10. Mouse operations  Practice various mouse operations

Learning Outcome 7.2: Use typing software

Theory Practical

1. Introduction to Rapid Typing Tutor  Identify the user interface of Typing Tutor
2. Touch typing technique  Practice to type text in Typing Tutor software
and interpret the results
3. User interface of Typing Tutor
 Practice to work in lesson editor
4. Typing text and interpreting results
 Calculate the typing speed
5. Working with lesson editor
 Practice to improve typing using Typing
6. Calculating typing speed
Tutor software
7. Typing rhythm

7

Unit-8: Digital Documentation (Elementary)
Learning Outcome 8.1: Start the word processing application

Theory Practical

1. Introduction to word processing  List the available word processing
applications
2. Word processing applications
 Introduce with the parts of the main window
3. Introduction to LibreOffice Writer
 Change document views, start a new
4. Starting LibreOffice Writer
document
5. Creating a document
 Open an existing document
6. Parts of Writer window
 Save a document
7. Cursor and mouse pointer
 Close a document
 Use the Navigator

Learning Outcome 8.2: Edit the document

Theory Practical

1. Text editing – undo and redo  Type some text in the document and edit it
2. Moving and copying text  Demonstrate to use undo and redo options
3. Copy and paste  Use the keyboard and mouse options to
select, cut, copy, paste, and move text
4. Selecting text
 Demonstrate to select non-consecutive text
5. Selection criteria
items, vertical block of text
6. Selecting non-consecutive text items
 Search the word from the text and replace it
7. Selecting a vertical block of text with another word
8. Find and replace option  Jump to the given page number in a
document
9. Jumping to a page number
 Insert non-printing characters in a document
10. Non-printing characters
 Check spelling and grammar and apply the
11. Checking spelling and grammar
changes to the document
12. Using synonyms and the thesaurus
 Demonstrate to use synonyms and thesaurus

Learning Outcome 8.3: Format the document

Theory Practical

1. Page style dialog box  Apply various text formatting options for the
text
2. Formatting text - removing manual formatting,
common text formatting, changing text case,  Demonstrate to format paragraphs –
superscript and subscript indent/align paragraphs, assign font colour,
highlighting, and background colour
3. Formatting paragraph – indenting paragraphs,
aligning paragraphs, font colour, highlighting,  Assign numbers or bullets to the list items
and background colour
 Demonstrate to assign colour, border, and
4. Using bullets and numbering background to paragraph

8

5. Assigning colour, border, and background to a  Demonstrate page formatting – set up basic
paragraph page layout using styles, insert page break,
create header/footer and page numbers, define
6. Page formatting – setting up basic page layout
borders and backgrounds, insert images,
using styles, inserting page break, creating
shapes, special characters in a document,
header/footer and page numbers, defining
divide a page into columns, format the shape
borders and backgrounds, inserting images,
or image
shapes, special characters in a document,
dividing a page into columns, formatting the
shape or image

Learning Outcome 8.4: Create and use a table

Theory Practical

1. Creating a table in Writer  Demonstrate and do the following in Writer:
2. Inserting row and column in a table - Create a table
3. Deleting rows and columns - Insert and delete rows and columns in a
table
4. Splitting and merging tables
- Split and merge tables
5. Deleting a table
- Delete a table
6. Copying a table
- Copy or move from one location to
7. Moving a table
another location of document

Learning Outcome 8.5: Print the document

Theory Practical

1. Printing options in Writer  Demonstrate to print the document, selected
2. Print preview pages in the document
3. Controlling printing  Print the document with various options
4. Printing all pages, single and multiple pages  Preview pages before printing

Learning Outcome 8.6: Print the letters using mail merge

Theory Practical

1. Concept of mail merge in word processing  Demonstrate to print the letters using mail
merge, do the following to achieve it:
2. Creating a main document
˗ Create a main document
3. Creating the data source
˗ Create the data source
4. Entering data in the fields
˗ Enter data in the fields
5. Merging the data source with main document
˗ Merge the data source with main
6. Editing individual document
document
7. Printing the merged letter
˗ Edit individual document
8. Saving the merged letter
˗ Print the merged letter
˗ Save the merged letter

9

Unit-9: Electronic Spreadsheet (Elementary)
Learning Outcome 9.1: Create a spreadsheet

Theory Practical

1. Introduction to spreadsheet application  Start the LibreOffice Calc
2. Starting LibreOffice Calc  Identify the parts of Calc
3. Parts of LibreOffice Calc  Identify the row number, column number, cell
address
4. Worksheet – rows and columns, cell, and cell
address  Define the range of cell
5. Range of cell – column range, row range, row,  Identify row range, column range, row, and
and column range column range

Learning Outcome 9.2: Enter and edit the text in spreadsheet

Theory Practical

1. Different types of data  Demonstrate to enter the text, numeric data in
a cell
2. Entering data – label, values, formula
 Identify the label, values, and formula in the
3. Formula, how to enter formula
cell
4. Mathematical operators used in a formula
 Demonstrate to enter formula in a cell
5. Simple calculations using values and operators
 Construct the formula using mathematical
6. Formulae with cell addresses and operators operators
7. Commonly used basic functions in Calc –  Identify formulae with cell addresses and
SUM, AVERAGE, MAX, MIN, COUNT operators
8. Use of functions to do calculations  Identify the correct syntax of formula
 Use the basic functions to perform
calculations on data

Learning Outcome 9.3: Format data in the spreadsheet

Theory Practical

1. Formatting tools  Identify the formatting tools
2. Use of dialog boxes to format values  Demonstrate to use of dialog boxes to format
values
3. Formatting a range of cells with decimal
places  Demonstrate to format range of cells with
decimal places
4. Formatting a range of cells to be seen as labels
 Demonstrate to format a range of cells to
5. Formatting of a cell range as scientific
labels
6. Formatting a range of cells to display time
 Demonstrate to format of a cell range as
7. Formatting alignment of a cell range scientific
8. Speeding up data entry using the fill handle  Demonstrate to format a range of cells to
display time
9. Uses of fill handle for copying formulae
 Demonstrate to align the cell data range
 Demonstrate to create number series using fill

10

handle
 Copy formula by dragging the formula using
fill handle

Learning Outcome 9.4: Use referencing

Theory Practical

1. Concept of referencing  Demonstrate to use relative referencing in
spreadsheet
2. Relative referencing
 Demonstrate to use mixed referencing in
3. Mixed referencing
spreadsheet
4. Absolute referencing
 Demonstrate to use absolute referencing in
spreadsheet

Learning Outcome 9.5: Introduce the types of charts in Calc

Theory Practical

1. Importance of chart in spreadsheet  List the different types of charts supported by
Calc
2. Types of charts
 Illustrate the example of chart in Calc
3. Example of chart

Unit-10: Digital Presentation
Learning Outcome 10.1: Describe the quality of a good presentation

Theory Practical

1. Concept of presentation  Identify and list the elements of a presentation
2. Elements of a presentation  List the characteristics of a good quality
3. Characteristics of a good quality presentation presentation

Learning Outcome 10.2: Create a presentation

Theory Practical

1. Introduction to a presentation software  Start Impress
2. Starting Impress  Identify and name the various components of
main Impress window
3. Parts of Impress window
 Observe the different workspace views
4. Closing Impress
 Create a new presentation using Wizard
5. Creating a presentation using template
 Run the presentation
6. Selecting slide layout
 Save the presentation
7. Saving a presentation
 Close the presentation
8. Running a slide show
 Demonstrate to use Help in a presentation
9. Save a presentation in PDF
10. Closing a presentation
11. Using Help

11

Learning Outcome 10.3: Work with slides

Theory Practical

1. Inserting a duplicate slide  Demonstrate to insert a new slide and a
duplicate slide in a presentation
2. Inserting new slides
 Change the slide layout
3. Slide layout
 Demonstrate to copy and move slides in the
4. Copying and moving slides
presentation
5. Deleting and renaming slides in a presentation
 Demonstrate to copy, move, and delete
6. Copying, moving, and deleting contents of a contents of the slide
slide
 Demonstrate to view a presentation in
7. View a presentation different views
8. Controlling the size of the view
9. Workspace views – Normal, Outline, Notes,
Slide sorter view

Learning Outcome 10.4: Format the text in a presentation

Theory Practical

1. Formatting toolbar  Identify and list the various options in
formatting toolbar
2. Various formatting features
 Apply the appropriate formatting option to the
3. Text alignment
presentation in Impress
4. Bullets and numbering
 Align the text in the presentation
 Apply bullets and numbering to the list items
in the presentation

Learning Outcome 10.5: Create and use a table in a presentation
Theory Practical

1. Inserting tables in a presentation  Demonstrate the following:
2. Entering and editing data in a table ˗ Insert a table in the presentation
3. Selecting a cell, row, column, table ˗ Enter and edit data in a table
4. Adjusting column width and row height ˗ Select a cell, row, column, table
5. Table borders and background ˗ Adjust column width and row height
˗ Assign table borders and background

Learning Outcome 10.6: Insert and format an image in the presentation

Theory Practical

1. Inserting an image from a file  Demonstrate to insert an image from a file,
gallery in the presentation
2. Inserting an image from the gallery
 Apply formatting options to an image in the
3. Formatting images
presentation

12

4. Moving images  Demonstrate to move, resize, and rotate
images
5. Resizing images
 Apply formatting options of Image toolbar
6. Rotating images
 Drawing line, shapes using graphic objects
7. Formatting by using the Image toolbar
 Demonstrate to group and un-group objects
8. Drawing graphic objects – line, shapes
9. Grouping and un-grouping objects

Learning Outcome 10.7: Work with the slide master

Theory Practical

1. Slide masters  Create the slide masters
2. Creating the slide masters  Apply the slide masters to the presentation
3. Applying the slide masters to all slides  Add transitions to the presentation
4. Adding transitions

PART II: INTERNAL ASSESSMENT (PRACTICAL) – 100 MARKS
To be assessed internally by the school.
For guidelines for Internal Assessment refer to Class X.

13

Class X
There will be one written paper of two hours duration carrying 100 marks and Internal
Assessment of Practical of 100 marks.
COURSE STRUCTURE:
PART I: THEORY – 100 MARKS
Employability Skills – 30 Marks
Unit 1: Communication Skills – II
Unit 2: Self-management Skills – II
Unit 3: Basic Information and Communication Technology Skills – II
Unit 4: Entrepreneurial Skills – II
Unit 5: Green Skills – II
Vocational Skills – 70 Marks
Unit 6: Digital Documentation (Advanced)
Unit 7: Electronic Spreadsheet (Advanced)
Unit 8: Database Management System
Unit 9: Maintaining Health, Safety and Secure Working Environment
PART II: INTERNAL ASSESSMENT (PRACTICAL) – 100 MARKS
Practical Work – 70 Marks
Practical Examination – 40 Marks
Practical File – 10 Marks
Viva Voce (based on Practical Examination/File) – 20 Marks
Project Work – 30 Marks
Report of Field Visit/Project – 10 Marks
Student Portfolio – 10 Marks
Viva Voce (based on Report of Field Visit/Student Portfolio/Project) – 10 Marks

14

PART I: THEORY – 100 MARKS
Employability Skills
Unit-1: Communication Skills – II
Learning Outcome 1.1: Demonstrate knowledge of various methods of communication

Theory Practical

1. Methods of communication:  Writing pros and cons of written, verbal, and
non-verbal communication
(i) Verbal
 Listing dos and don’ts for avoiding common
(ii) Non-verbal
body language mistakes
(iii) Visual

Learning Outcome 1.2: Provide descriptive and specific feedback

Theory Practical

1. Communication cycle and importance of  Constructing sentences for providing
feedback descriptive and specific feedback
2. Meaning and importance of feedback
3. Descriptive feedback – written comments or
conversations
4. Specific and non-specific feedback

Learning Outcome 1.3: Apply measures to overcome barriers in communication

Theory Practical

1. Barriers to effective communication – types  Enlisting barriers to effective communication
and factors
 Applying measures to overcome barriers in
2. Measures to overcome barriers in effective communication
communication

Learning Outcome 1.4: Apply principles of communication

Theory Practical

1. Principles of effective communication  Constructing sentences that convey all facts
required by the receiver
2. 7Cs of effective communication
 Expressing in a manner that shows respect to
the receiver of the message
 Exercises and games on applying 7Cs of
effective communication

Learning Outcome 1.5: Demonstrate basic writing skills

Theory Practical

1. Writing skills related to the following:  Demonstration and practice of writing
sentences and paragraphs on topics related to
(i) Sentence
the subject

15

(ii) Phrase
(iii) Kinds of Sentences
(iv) Parts of Sentence
(v) Parts of Speech
(vi) Articles
(vii) Construction of a Paragraph

Unit-2: Self-management Skills – II
Learning Outcome 2.1: Apply stress management techniques

Theory Practical

1. Meaning and importance of stress  Exercises on stress management techniques –
management yoga, meditation, physical exercises
2. Stress management techniques – physical  Preparing a write-up on an essay on
exercise, yoga, meditation experiences during a holiday trip
3. Enjoying, going to vacations and holidays
with family and friends
4. Taking nature walks

Learning Outcome 2.2: Demonstrate the ability to work independently

Theory Practical

1. Importance of the ability to work  Demonstration on working independently on
independently goals
2. Describe the types of self-awareness  Planning of an activity
3. Describe the meaning of self-motivation and  Executing tasks in a specific period, with no
self-regulation help or directives
 Demonstration on the qualities required for
working independently
Unit-3: Basic Information and Communication Technology Skills – II
Learning Outcome 3.1: Distinguish between different operating systems

Theory Practical

1. Classes of operating systems  Identification of taskbar, icons, menu, etc.
2. Menu, icons, and taskbar on the desktop  Demonstration and practice of creating,
renaming, and deleting files and folders,
3. File concept, file operations, file organization,
saving files in folders and sub-folders,
directory structures, and file-system structures
restoring files and folders from recycle bin
4. Creating and managing files and folders

16

Learning Outcome 3.2: Apply basic skills for care and maintenance of computer

Theory Practical

1. Importance and need of care and maintenance  Demonstration of the procedures to be
of a computer followed for cleaning, care and maintenance
2. Cleaning computer components of hardware and software
3. Preparing maintenance schedule
4. Protecting computer against viruses
5. Scanning and cleaning viruses and
removing SPAM files, temporary files, and
folders

Unit- 4: Entrepreneurial Skills – II
Learning Outcome 4.1: List the characteristics of successful entrepreneurs

Theory Practical

1. Entrepreneurship and society  Writing a note on entrepreneurship as a career
option
2. Qualities and functions of an entrepreneur
 Collecting success stories of first generation
3. Role and importance of an entrepreneur and local entrepreneurs
4. Myth about entrepreneurship  Listing the entrepreneurial qualities – analysis
of strength and weaknesses
5. Entrepreneurship as a career option
 Group discussion of self-qualities that
students feel are needed to become a
successful entrepreneur
 Collect information and related data for a
business
 Making a plan in teams for setting up a
business

Unit-5: Green Skills – II
Learning Outcome 5.1: Demonstrate the knowledge of importance, problems and
solutions related to sustainable development

Theory Practical
 Identify the problem related to sustainable
1. Definition of sustainable development
development in the community
2. Importance of sustainable development  Group discussion on the importance of
respecting and conserving indigenous
3. Problems related to sustainable development
knowledge and cultural heritage
 Discussion on the responsibilities and benefits
of environmental citizenship, including the
conservation and protection of environmental
values
 Preparing models on rainwater harvesting,
drip/sprinkler irrigation, vermin-compost,
solar energy, solar cooker, etc.

17

Vocational Skills
Unit-6: Digital Documentation (Advanced)
Learning Outcome 6.1: Apply Styles in the document

Theory Practical

1. Style categories in Writer  List style categories in Writer
2. Formatting window  Select the style from the Styles and Formatting
window
3. Fill Format
 Use Fill Format to apply a style to many
4. Creating and updating new style from
different areas quickly
selection
 Create and update new style from a selection
5. Load a style from template or another
document  Load a style from a template or another
document
6. Creating a new style using drag-and-drop
 Create a new style using drag-and-drop
7. Applying styles

Learning Outcome 6.2: Insert and use images in the document

Theory Practical

1. Options to insert image to a document from  Insert an image to the document from various
various sources sources
2. Options to modify, resize, crop, and delete an  Modify, resize, crop, and delete an image
image
 Create drawing objects
3. Drawing objects and its properties
 Set or change the properties of a drawing
4. Creating drawing objects and changing its object
properties
 Resize and group drawing objects
5. Resizing and grouping drawing objects
 Position the image in the text
6. Positioning image in the text

Learning Outcome 6.3: Create and use template

Theory Practical

1. Template in Writer  Create a template
2. Using predefined templates  Use predefined templates
3. Creating a template  Set-up a custom default template
4. Set-up a custom default template  Update a document
5. Updating a document  Change to a different template
6. Changing to a different template  Use the template
7. Using the template

18

Learning Outcome 6.4: Create table of contents

Theory Practical

1. Table of contents  Create a table of contents
2. Hierarchy of headings  Define a hierarchy of headings
3. Customization of table of contents  Customize a table of contents
4. Character styles  Apply character styles
5. Maintaining a table of contents  Maintain a table of contents

Unit-7: Electronic Spreadsheet (Advanced)
Learning Outcome 7.1: Analyse data using scenarios and Goal Seek

Theory Practical

1. Using Consolidate data  Use Consolidate data
2. Creating subtotals  Create subtotals
3. Using “What-If” scenarios  Use “What-If” scenarios
4. Using “What-If” tools  Use “What-If” tools
5. Using Goal Seek and Solver  Use Goal Seek and Solver

Learning Outcome 7.2: Link spreadsheet data

Theory Practical

1. Setting up multiple sheets  Set-up multiple sheets by inserting new
2. Creating reference to other sheets by using sheets
keyboard and mouse  Create reference to other sheets by using
3. Creating reference to another document by keyboard and mouse
using keyboard and mouse  Create reference to another document by
4. Relative and absolute hyperlinks using keyboard and mouse
5. Hyperlinks to the sheet  Create, edit, and remove hyperlinks to the
sheet
6. Linking to external data
 Link to external data
7. Linking to registered data sources
 Link to registered data source
Learning Outcome 7.3: Share and review a spreadsheet

Theory Practical

1. Setting up a spreadsheet for sharing  Set-up a spreadsheet for sharing
2. Opening and saving a shared spreadsheet  Open and save a shared spreadsheet
3. Recording changes  Record changes
4. Add, edit, and format the comments  Add, edit, and format the comments
5. Reviewing changes – view, accept or reject  Review changes – view, accept or reject
changes changes
6. Merging and comparing  Merge and compare sheets

19

Learning Outcome 7.4: Use macro in spreadsheet

Theory Practical

1. Using the macro recorder  Use the macro recorder
2. Creating a simple macro  Create a simple macro
3. Using a macro as a function  Use a macro as a function
4. Passing arguments to a macro  Pass arguments to a macro
5. Passing the arguments as are values  Pass the arguments as are values
6. Macros to work like built-in functions  Write macros that act like built-in functions
7. Accessing cells directly  Access cells directly
8. Sorting the columns using macro  Sort the columns using macro

Unit-8: Database Management System
Learning Outcome 8.1: Appreciate the concept of Database Management System

Theory Practical

1. Concept and examples of data and information  Identify the data and information
2. Concept of database  Identify the field, record, table in the database
3. Advantages of database  Prepare the sample table with some standard
fields
4. Features of database
 Assign the primary key to the field
5. Concept and examples of Relational Database
 Identify the primary key, composite primary
6. Concept and examples of field, record, table,
key, foreign key
database
7. Concept and examples of primary key,
composite primary key, foreign key
8. Database management system (DBMS)
software

Learning Outcome 8.2: Create a table using table Wizard

Theory Practical

1. Introduction to LibreOffice Base  Start the LibreOffice Base and observe the
parts of the main window
2. Database objects – tables, queries, forms, and
reports of the database  Identify the database objects
3. Terms in database – table, field, record  Create the sample table in any category using
wizard
4. Steps to create a table using table Wizard
 Practice to create different tables from the
5. Data types in Base
available list and choosing fields from the
6. Option to set primary key available fields.
7. Table Data View dialog box  Assign data types of fields
 Set primary key
 Edit the table in Design View
 Enter the data in the fields

20

Learning Outcome 8.3: Perform operations on the table

Theory Practical

1. Inserting data in the table  Demonstrate to:
2. Editing records in the table - Insert data in the table
3. Deleting records from the table - Edit records in the table
4. Sorting data in the table - Delete records from the table
5. Referential integrity - Sort data in the table
6. Creating and editing relationships – one to - Create and edit relationships – one to one,
one, one to many, many to many one to many, many to many
7. Field properties - Enter various field properties

Learning Outcome 8.4: Retrieve data using query

Theory Practical

1. Database query  Prepare a query for given criteria
2. Defining query  Demonstrate to create query using wizard,
and using design view
3. Query-creation using Wizard
 Edit a query
4. Creation of query using Design View
 Demonstrate to apply various criteria in query
5. Editing a query
– single field, multiple fields, using wild card
6. Applying criteria in query – single field,
 Performing calculations using query in Base
multiple fields, using wild card
 Demonstrate grouping of data
7. Performing calculations
 Use basic SQL commands
8. Grouping of data
9. Structured Query Language (SQL)

Learning Outcome 8.5: Create Forms and Reports using Wizard
Theory Practical

1. Forms in Base  Illustrate the various steps to create Form
using Form Wizard
2. Creating form using Wizard
 Enter or remove data from Forms
3. Steps to create form using Form Wizard
 Demonstrate to modify Forms
4. Options to enter or remove data from forms
 Demonstrate to change label, background
5. Modifying form
 Search record using Form
6. Changing label, background
 Insert and delete record using Form View
7. Searching record using Form
 Illustrate the various steps to create Report
8. Inserting and deleting record using Form View
using Report Wizard
9. Concept of Report in Base
 Demonstrate the various examples of Report
10. Creating Report using Wizard
11. Steps to create Report using Wizard

21

Unit-9: Maintaining Health, Safety and Secure Working Environment
Learning Outcome 9.1: Maintain workplace safety

Theory Practical

1. Basic safety rules to follow at the workplace –  Practice to follow basic safety rules at the
fire safety, falls and slips, electrical safety, use workplace to prevent accidents and protect
of first aid workers – fire safety, falls and slips, electrical
safety, use of first aid.
2. Case studies of hazardous situation at the
workplace

Learning Outcome 9.2: Prevent accidents and emergencies

Theory Practical

1. Accidents and emergency  Illustrate handling accidents at the workplace
2. Types of accidents  Demonstrate following the evacuation plan
and procedure in case of an emergency
3. Handling accidents
4. Types of Emergencies

Learning Outcome 9.3: Protect health and safety at work

Theory Practical

1. Hazards and sources of hazards  Identify hazards and sources of hazards
2. General evacuation procedures  Identify the problems at workplace that could
cause accidents
3. Healthy living
 Practice the general evacuation procedures in
case of an emergency

22

PART II: INTERNAL ASSESSMENT (PRACTICAL) – 100 MARKS
Practical Work
• Practical Examination – 40 Marks
• Practical File – 10 Marks
• Viva Voce (based on Practical Examination/File) – 20 Marks
The Practical Work allows candidates to demonstrate that they have knowledge and understanding
of performing a task. This will include the hands-on Practical Examination and viva-voce. In
addition, candidates will be required to maintain a practical file of the work done throughout the
year.
Candidates will be required to perform any two practicals selected by the external examiner. The two
practicals selected by the external examiner will be from different units of the syllabus.
Project Work
• Report of Field Visit/Project – 10 Marks
• Student Portfolio – 10 Marks
• Viva Voce (based on Report of Field Visit/Student Portfolio/Project) – 10 Marks
Project Work aims at assessing the practical skills of candidates over a certain period of time.
This includes report of field visits, project undertaken, student portfolio along with viva-voce.
Candidates are required to have completed one project on a topic of their choice from any
topic/allied aspect covered in the syllabus. The project may include case study (example, study of
a local industry/business), survey, model making, poster making/creation of audio-visual aids,
interview of an entrepreneur from the local industry, etc.
Candidates should maintain record of the field visits undertaken during the year. This should
include subject-specific information obtained from the experts/observations made during the field
visits.
The student portfolio is a compilation of work done by the candidate throughout the year, and may
include reports, articles, photos of products prepared by the candidate in relation to the unit of
competency.
EVALUATION
The practical and project work is to be evaluated by the subject teacher and by an External
Examiner. The External Examiner shall be nominated by the Head of the school and may be a
teacher from the faculty, but not teaching the subject in the relevant section/class.
The Internal Examiner and the External Examiner will assess the candidate’s work independently.

Award of Marks (100 Marks)

Subject Teacher (Internal Examiner) 50 marks

External Examiner 50 marks

The total marks obtained out of 100 are to be sent to the CISCE by the Head of the school.
The Head of the school will be responsible for the online entry of marks on the CISCE’s
CAREERS portal by the due date.

23

Teaching-learning Activities
For effective transaction of the subject content a combination of classroom activities, practical
work and field visits/educational tours are to be used by the teacher.
Special emphasis should be laid on occupational safety, health and hygiene while conducting the
teaching-learning activities.
Classroom Activities
Classroom activities, including, interactive lecture sessions followed by discussions, should be
conducted by the subject teachers, using a variety of instructional or teaching aids such as, audio-
video materials, colour slides, charts, diagrams, models, exhibits, hand-outs, online teaching
materials, etc.
Practical Work
Practical work may include but not be limited to hands-on training, simulated training, role play,
case-based studies, exercises, etc. Equipment and supplies should be provided to enhance hands-
on learning experience of students. Only trained personnel should teach specialized techniques.
Field Visits/Educational Tours
Students should be taken for field visits to give them an opportunity to interact with experts and
to expose them to the various tools, equipment, materials, procedures, and operations in the
workplace. During field visits, students should obtain subject-specific information from the
experts or make a record of the activities observed.
A checklist of observations to be made by the students during the field visits should be developed
by the teachers for systematic collection of information by the students on the various aspects.
For example, a visit may be organized to a data entry centre where the students may observe the
following: location, site, office building, computer systems, tools and equipment, printer, scanner,
etc.
During the visit, students should obtain the following information from the owner or the supervisor
of the data centre:
• Name of the data entry centre
• Computer infrastructure available
• Total expenditure of data entry centre
• Total annual income
• Profit/loss (annual)
• Workforce engaged
• Assistive technology
• Sitting posture of data entry operators
• Any other information
In a year, at least 3 field visits/educational tours should be organised for the students, to expose
them to the activities in the workplace. Schools may identify different opportunities for field visits
within a short distance from the school and make necessary arrangements for the same.

24

List of Equipment and Materials
The list given below is suggestive. An exhaustive list should be prepared by the teacher. Only
basic tools, equipment and accessories should be procured by the school so that the routine tasks
can be performed by the students regularly for practice and acquiring adequate practical
experience.

S. No. Item Name, Description & Specification Quantity
HARDWARE
1. Computer with latest configuration or minimum Pentium Processor with 2 GB 15
RAM, 512 GB HDD, 17” LED monitor, NIC card, 3 button mouse, 105 keys
keyboard and built-in speakers and microphone
2. Laser printer black 01
3. Inkjet printers (colour & black) 01
4. Scanner 01
5. Online UPS 5 KVA 01
6. 16 port switches 01
7. Air Conditioner 1.5 tonne 02
8. Telephone line (For Internet) 01
9. Fire extinguisher 01
SOFTWARE
1. Operating System Linux and Windows
2. Anti-virus Latest version
3. LibreOffice or MS Office latest version
FURNITURE
1. Classroom chairs and desks 25
2. Computer tables 15
3. Straight back revolving & adjustable chairs (Computer Chairs) 15
4. Printer tables 02
5. Trainers table 01
6. Trainer’s chair 01
7. Steel cupboards with drawers 02
8. Cabinet with drawers 01
9. Steel almirah (big) 01
10. Steel almirah (small) 01

25

Teacher Qualifications
The suggestive qualifications and minimum competencies for the subject teacher are as follows:
• Diploma in Computer Science/Information Technology
OR
Bachelor’s Degree in computer application/ Science/ Information Technology (BCA, B. Sc.
Computer Science/ Information Technology)
OR
Graduate with PGDCA
OR
DOEACC A Level Certificate.
• The candidate should have a minimum of 1 year of work experience in the same job role.
• Effective communication skills (oral and written)
• Technical competencies.

26