Information Technology

Subject Code 402

Class 10

Syllabus

COURSE TITLE: DOMESTIC DATA ENTRY OPERATOR

Domestic Data Entry Operator in the IT-ITeS Industry is also known as Data Entry Operator. Individuals are responsible to provide daily work reports and work on daily hour bases. The individual is responsible for electronic entry of data from the client side to the office site or vice-versa. 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 have fast and accurate typing/data encoding. This job involves working in a personal computer, and appropriate software to enter accurate data regarding different issues like retrieving data from a computer or to a computer

COURSE OUTCOME: On completion of the course, students should be able to:

  • Apply effective oral and written communication skills to interact with people and customers;
  • Identify the principal components of a computer system; Demonstrate the basic skills of using computer;
  • Demonstrate self-management skills;
  • Demonstrate the ability to provide a 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 the 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.

COURSE OBJECTIVES:
In this course, the students will be introduced to the fundamental concepts of digital documentation, digital spreadsheet, digital presentation, database management and internet security.
The following are the main objectives of this course:

  • To familiarize the students with the world of IT and IT enabled services.
  • To provide in-depth training in use of data entry, internet and internet tools.
  • To develop practical knowledge of digital documentation, spreadsheets and presentation.
  • To enable the students to understand database management systems and have updated knowledge about digital record keeping.
  • To make the students capable of getting employment in Private Sector, Public Sector, Ministries, Courts, House of Parliament and State Legislative Assemblies.
  • To develop the following skills:
    • Data Entry and Keyboarding skills
    • The concept of Digital Documentation
    • The concept of Digital Presentation
    • The concept of Electronic Spreadsheet
    • The concept of Databases
    • Internet Technologies

SALIENT FEATURES: To be a data entry operator/analyst, one requires a lot of hard work and practical hands-on experience. One should have an intensive knowledge of Office applications, computer operations, and knowledge of clerical, administrative techniques and data analysis. Along with this, as a data entry operator/analyst, you will be expected to have fast typing speed, accuracy, and efficiency to perform tasks.

As a data entry operator/analyst, one should improve their computer skills, numerical and literacy skills. These skills can help one expand into a new career path in the future

SCHEME OF UNITS
Total Marks: 100 [Theory (Part A+B) -50 + Practical (Part C+D) -50]
This course is a planned sequence of instructions consisting of units meant for developing employability and vocational competencies of students of Class X opting for skill subject along with other subjects.
The unit-wise distribution of marks for class X is as follows:

PART-A
Employability Skills
UNITMARKS
Unit 1: Communication Skills-II*
Unit 2: Self-Management Skills-II3
Unit 3: ICT Skills-II3
Unit 4: Entrepreneurial Skills-II4
Unit 5: Green Skills-II*
TOTAL MARKS10
PART-B
SUBJECT SPECIFIC SKILLS
UNITMARKS
Unit 1: Digital Documentation (Advanced)8
Unit 2: Electronic Spreadsheet (Advanced)10
Unit 3: Database Management System12
Unit 4: Web Applications and Security10
TOTAL MARKS40
PART-C
PRACTICAL WORK
UNITMARKS
Advanced Documentation (Unit 1)5
Advanced Spreadsheets (Unit 2)5
Databases (Unit 3)10
Viva Voice10
TOTAL MARKS30
PART-D
PROJECT & FILE
PARTICULARMARKS
PROJECT WORK/FIELD VISIT
Any Interdisciplinary Real World Case Study to be taken. Summarized data reports of same can be presented in base. Input should be taken using forms and output should be done using reports using base.
Documentation of the case study should be presented using writer.
10
PORTFOLIO/ PRACTICAL FILE
(Portfolio should contain printouts of the practical done using Writer, Calc and Base with minimum 5 problems of each)
10
TOTAL MARKS20

Learning Outcomes

UNIT 1: DIGITAL DOCUMENTATION (ADVANCED)

1. Create and Apply Styles in the document
  • THEORY
    • Styles/ categories in Word Processor
    • Using the Styles and Formatting window.*
    • Using Fill Format.*
    • Creating and updating new style from selection
    • Load style from template or another document.
    • Creating a new style using drag-and-drop.*
    • Applying styles.
  • PRACTICAL
    • List style categories. Select the style from the Styles and Formatting window.
    • Use Fill Format to apply a style to many different areas quickly.
    • Create and update a new style from a selection.
    • Load a style from a template or another document.
    • Create a new style using drag-and drop.
2. Insert and use images in document
  • THEORY
    • Options to insert image to document from various sources.
    • Options to modify, resize, crop and delete an image.
    • Creating drawing objects, setting or changing its properties.
    • Resizing and grouping drawing objects.
    • Positioning image in the text.
  • PRACTICAL
    • Insert an image to document from various sources.
    • Modify, resize, crop and delete an image.
    • Create drawing objects
    • Set or change the properties of a drawing object
    • Resize and group drawing objects
    • Position the image in the text
3. Create and use template
  • THEORY
    • Templates.
    • Using predefined templates.
    • Creating a template.*
    • Set up a custom template as the default..
    • Editing a template
    • Changing to a different template.
    • Updating a Document*
  • PRACTICAL
    • Create a template.
    • Use predefined templates.
    • Set up a custom default template.
    • Update a document.
    • Change to a different template.
    • Use the Template.
    • Update the document and save the changes.
4. Create and customize table of contents
  • THEORY
    • Table of contents. Hierarchy of headings. Customization of table of contents.
    • Character styles. Maintaining a table of contents.
  • PRACTICAL
    • Create a table of contents. Define a hierarchy of headings.
    • Customize a table of contents.
    • Apply character styles. Maintain a table of contents.
5. Implement Mail Merge
  • THEORY
    • Advance concept of mail merge in word processing,
    • Creating a main document,
    • Creating the data source,
    • Entering data in the fields,
    • Merging the data source with main document,
    • Editing individual documents.*
    • Printing a letter and its address label
  • PRACTICAL
    • Demonstrate to print the label using mail merge, do the following to achieve
    • Create a main document,
    • Create the data source,
    • Enter data in the fields,
    • Merge the data source with main document,
    • Edit individual document,
    • Print the letter and address label.

(Note: * To be assessed in Practicals only. No question shall be asked from this portion in Theory Exams)

UNIT 2: ELECTRONIC SPREADSHEET (ADVANCED)

1. Analyse data using scenarios and goal seek.
  • THEORY
    • Using consolidating data. Creating subtotals.
    • Using “what if” scenarios. Using “what if” tools
    • Using goal seek and solver.
  • PRACTICAL
    • Use consolidating data Create subtotals
    • Use “what if” scenarios Use “what if” tools
    • Use goal seek and solver
2. Link data and spreadsheets
  • THEORY
    • Setting up multiple sheets. Creating reference to other sheets by using keyboard and mouse.
    • Creating reference to other document by using keyboard and mouse.*
    • Relative and absolute hyperlinks
    • Hyperlinks to the sheet.
    • Linking to external data.
    • Linking to registered data sources.
  • PRACTICAL
    • Setup multiple sheets by inserting new sheets.
    • Create reference to other sheets by using keyboard and mouse.
    • Create references to other documents by using keyboard and mouse.
    • Create, Edit and Remove hyperlinks to the sheet.
    • Link to external data.
    • Link to registered data source.
3. Share and review a spreadsheet
  • THEORY
    • Setting up a spreadsheet for sharing.*
    • Opening and saving a shared spreadsheet. Recording changes.
    • Add, Edit and Format the comments.
    • Reviewing changes – view, accept or reject changes. Merging and comparing
  • PRACTICAL
    • Set up a spreadsheet for sharing.
    • Open and save a shared spreadsheet.
    • Record changes.
    • Add, Edit and Format the comments.
    • Review changes – view, accept or reject changes.
    • Merge and compare sheets.
4. Create and Use Macros in spreadsheet
  • THEORY
    • Using the macro recorder. Creating a simple macro. Using a macro as a function. Using a macro as a function.
    • Discuss Passing arguments to a macro.
    • Discuss Passing the arguments’ area values.
    • Discuss Macros to work like built-in functions.
    • Accessing cells directly.
    • Sorting the columns using macro.
  • PRACTICAL
    • Demonstrate the use of a macro recorder.
    • Create a simple macro.
    • Use a macro
    • Access cells directly
    • Using a macro.
    • Sort the columns using macro.

(Note: * To be assessed in Practicals only. No question shall be asked from this portion in Theory Exams)

UNIT 3: DATABASE MANAGEMENT SYSTEM

1. Appreciate the concept of Database Management System
  • THEORY
    • Concept and examples of data and information,
    • Concept of database,
    • Advantages of database,
    • Features of database,
    • Concept and examples of Relational database,
    • Concept and examples of field, record, table, database,
    • Concept and examples of Primary key, composite primary key, foreign key,
    • Relational Data base management system (RDBMS) software.
  • PRACTICAL
    • Identify the data and information,
    • Identify the field, record, table in the database,
    • Prepare the sample table with some standard fields.
    • Assign the primary key to the field,
    • Identify the primary key, composite primary key, foreign key.
2. Create and edit tables using wizard and SQL commands
  • THEORY
    • Introduction to a RDBMS
    • Database objects – tables, queries, forms, and reports of the database,
    • Terms in database – table, field, record,
    • Steps to create a table using table wizard*
    • Data types in database.,
    • Option to set primary key Table Data View dialog box
  • PRACTICAL
    • Start the RDBMS and observe the parts of main window,
    • Identify the data base objects Create the sample table in any category using wizard, Practice to create different tables from the available list and choosing fields from the available fields.
    • Assign data types of field, Set primary key,
    • Edit the table in design view, Enter the data in the fields.
    • Create and edit table using DDL Commands
3. Perform operations on table
  • THEORY
    • Inserting data in the table,
    • Editing records in the table,
    • Deleting records from the table,
    • Sorting data in the table, Referential integrity,
    • Creating and editing relationships – one to one, one to many, many to many
    • Field properties (default, required and format)
  • PRACTICAL
    • Demonstrate to:
      • Insert data in the table, Edit records in the table, Delete records from table, Sort data in the table,
      • Create and edit relationships
      • one to one, one to many, many to many,
      • Enter various field properties.
4. Retrieve data using query
  • THEORY
    • Database query,
    • Defining query,
    • Query creation using wizard,*
    • Creation of query using design view,*
    • Editing a query,
    • Applying criteria in query – single field, multiple fields, using wildcard,
    • Performing calculations,
    • Grouping of data,
    • Structured Query Language (SQL).
    • Introduction to DDL (purpose of- Create database, Create table, Alter table and Drop table)
  • PRACTICAL
    • Prepare a query for given criteria,
    • Demonstrate to create query using wizard, and using design view,
    • Edit a query,
    • Demonstrate to apply various criteria in query – single field, multiple fields, using wild card,
    • Performing calculations using query in Base,
    • Demonstrate to group data,
    • Use basic SQL commands,
5. Create Forms and Reports using wizard
  • THEORY
    • Introduction to Forms in DBMS..
    • Creating form using wizard,*
    • Steps to create form using Form Wizard, *
    • Options to enter or remove data from forms
    • Modifying form,
    • Changing label, background,
    • Searching record using Form,
    • Inserting and deleting record using Form View,
    • Concept of Report in Base,
    • Creating Report using wizard, *
    • Steps to create a Report using Wizard. *
    • Insert date and time
  • PRACTICAL
    • Illustrate the various steps to create Form using Form Wizard,
    • Enter or remove data from Forms,
    • Demonstrate to modify Forms,
    • Demonstrate to change label, background,
    • Search record using Form,
    • Insert and delete record using Form View,
    • Illustrate the various steps to create Report using Report Wizard,
    • Demonstrate various examples of Report.

(Note: * To be assessed in Practicals only. No question shall be asked from this portion in Theory Exams)

UNIT 4: WEB APPLICATIONS AND SECURITY

1. Working with Accessibility Options.
  • THEORY
    • Understand various types of impairment that impact computer usage
    • Computer Accessibility Dialog box and its tabs
    • Serial Keys
  • PRACTICAL
    • Illustrate use of various options under Computer Accessibility like Keyboard, mouse, sound, display setting serial keys, cursor options
    • use of toggle keys, filter keys, sticky keys, sound sentry, show sounds etc.
2. Understand Networking Fundamentals
  • THEORY
    • Network and its types.
    • Client Server Architecture, Peer to-peer (P2P) Architecture,
    • internet, World Wide Web,
    • benefits of networking
    • internet, getting access to
    • internet,
    • internet terminology
    • Some of the commonly used Internet connectivity options
    • Data transfer on the Internet
  • PRACTICAL
    • Identify applications of Internet
    • comparing various internet technologies
    • identifying types of networks and selecting internet
3. Introduction to Instant Messaging
  • THEORY
    • learn key features of instant messaging
    • Creating an instant messaging account
    • Launching Google Talk*
    • Signing in into your Google Talk Account*
  • PRACTICAL
    • Illustrate steps to create instant messaging account
    • Signing In into your Google Talk Account
4. Chatting with a Contact – Google Talk
  • THEORY
    • learn to chat with a contact that is already added to your contact list.
    • sending text chat messages instantly by double-clicking on a contact.
    • general rules and etiquettes to be followed while chatting.
    • chatting on various types of messengers
  • PRACTICAL
    • Illustrate chat with a contact and send messages,
    • chatting with various messenger services
5. Creating and Publishing Web Pages – Blog …
  • THEORY
    • learn and appreciate a blog and its creation with the help of some blog providers*
    • set up title and other parameters in a blog posting comments
      using offline blog editors
  • PRACTICAL
    • Illustrate Blog Creation and setting various parameters in it.
6. Using Offline Blog Editors
  • THEORY
    • Concept to create blogs using a blog application and publish the blog whenever internet connectivity is available.
  • PRACTICAL
    • Demonstration on how to create blogs using a blog application offline.
    • posting messages in an offline application
    • Publish the blog whenever internet connectivity is available using various examples
7. Online Transaction
  • THEORY
    • concept of e-commerce and various online applications
      importance of secure passwords
  • PRACTICAL
    • Illustration of online shopping using various ecommerce sites
    • Demonstration of securing passwords for online transactions.
8. Internet Security
  • THEORY
    • Need of internet security
    • Cyber threats like phishing, email spoofing, char spoofing etc.
      best practices for internet security and secure passwords
    • concept of browser, cookies, backup, antivirus
    • clearing data in browsers
  • PRACTICAL
    • Illustration of internet security threats through various ways
    • cyber security tips
    • tips for secure passwords
    • demonstration of strong passwords using various websites.
    • clearing data stored in browser applications.
9. Maintain workplace safety
  • THEORY
    • Basic safety rules to follow at workplace – Fire safety,
    • Falls and slips, Electrical safety, Use of first aid.
    • Case Studies of hazardous situations.
  • PRACTICAL
    • Practice to follow basic safety rules at workplace to prevent accidents and protect workers– Fire safety,
    • Falls and slips, Electrical safety, Use of first aid.
10. Prevent Accidents and Emergencies
  • THEORY
    • Accidents and emergency,
    • Types of Accidents,
    • Handling Accidents
    • Types of Emergencies.
  • PRACTICAL
    • Illustrate to handle accidents at workplace,
    • Demonstrate to follow evacuation plan and procedure in case of an emergency.
11. Protect Health and Safety at work
  • THEORY
    • Hazards and sources of hazards,
    • General evacuation procedures,
    • Healthy living.
  • PRACTICAL
    • Identify hazards and sources of hazards,
    • identify the problems at workplace that could cause accidents,
    • Practice the general evacuation procedures in case of an emergency.

(Note: * To be assessed in Practicals only. No question shall be asked from this portion in Theory Exams)

error: Content is protected !!