Information Technology (402) Class X - Detailed Notes (CBSE Skill Education)

COURSE OVERVIEW

  • COURSE CODE AND TITLE: 402 – Information Technology; Class X; Subject code 402; Job Role: Domestic Data Entry Operator (also known as Data Entry Operator) in the IT-ITeS industry.
  • ROLE SUMMARY: Enter data electronically from client to office or vice versa; daily work reports; tasks vary with organization size; requires knowledge of technology trends, database management systems, and IT initiatives; fast and accurate typing/data encoding; work on personal computer with appropriate software.
  • COURSE OBJECTIVES: Intro to advanced concepts in digital documentation, spreadsheets, database management, and workplace safety; develop effective communication (active listening, speaking, presentation) and self-management (time management, goal setting, stress management); safe and ethical use of ICT; foster entrepreneurial mindset, critical thinking, and innovation; sustainable practices and environmental conservation; master advanced document creation, data analysis, automation using LibreOffice; database design and management; safe and secure work environment understanding health, safety, and emergency protocols; prepare for professional/personal growth in diverse environments.
  • LEARNING OUTCOMES (summary of what students will achieve):
    • Develop verbal and non-verbal communication, active listening, speaking, presentation; understand feedback and improve interpersonal communication.
    • Enhance self-awareness, self-regulation, self-motivation; learn time management, goal setting, stress management; cultivate personal and professional growth mindsets.
    • Understand basics of ICT; proficiency in digital tools for communication/productivity; safe, responsible, ethical ICT use.
    • Develop entrepreneurial mindset; problem-solving, critical thinking, innovation; understand financial literacy and risk management in business.
    • Understand sustainable practices and environmental conservation; awareness of the green economy and green jobs; promote eco-friendly initiatives.
    • Master advanced document creation, formatting, and management; templates, styles, tables, images; document collaboration and review features.
    • Learn advanced data analysis using scenarios and Goal Seek; automate tasks with macros; manage linked data across spreadsheets; securely share/review spreadsheets.
    • Design, create, and manage databases; data querying, reporting, relational concepts; forms/reports and data integrity.
    • Understand workplace safety, health and security protocols; hazard identification, risk assessment, emergency planning; promote health, safety, wellbeing at work.
  • SALIENT FEATURES: Focus on advanced digital documentation, spreadsheet management, and database handling using LibreOffice; emphasis on accuracy/speed in data-centric tasks; improved ICT skills and workplace interaction; responsible digital practices, problem-solving, critical thinking; health, safety, and emergency management protocols.
  • SCHEME OF UNITS (TOTAL 100 MARKS; Theory-50 + Practical-50)
    • This course develops employability and vocational competencies for Class X alongside other subjects.
    • UNIT-WISE HOURS & MARKS:
    • PART A: Employability Skills – Total Hours: 50
      • Unit 1: Communication Skills-II – Hours: 10; Max Marks: Part A total 10
      • Unit 2: Self-Management Skills-II – Hours: 10; Max Marks: Part A total 10
      • Unit 3: ICT Skills-II – Hours: 10; Max Marks: Part A total 1
      • Unit 4: Entrepreneurial Skills-II – Hours: 15; Max Marks: Part A total 3
      • Unit 5: Green Skills-II – Hours: 5; Max Marks: Part A total 1
      • TOTAL PART A: Hours 50; MAX MARKS 10
    • PART B: SUBJECT SPECIFIC SKILLS
      • Theory & Practical split (Total Theory 60, Practical 90, Internal/Assessment 40)
      • Unit 1: Digital Documentation (Advanced) using LibreOffice Writer
      • SUB UNIT LEARNING OUTCOMES, THEORY, PRACTICAL
      • Chapters include: Introduction to Styles, Working with Images, Advanced Features of Writer (ToC, Templates, Track Changes)
      • THEORY marks for Unit 1: 12; PRACTICAL marks: 18; Internal assessment: 8
      • Unit 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc
      • Chapters include: Data analysis using Scenario and Goal Seek, Macros in Spreadsheet, Linking Spreadsheet Data
      • THEORY marks for Unit 2: 15; PRACTICAL marks: 23; Internal assessment: 10
      • Unit 3: Database Management System using LibreOffice Base
      • Chapters include: Introduction to DBMS, Starting with LibreOffice Base, Working with multiple tables, Queries in Base, Forms and Reports
      • THEORY marks for Unit 3: 18; PRACTICAL marks: 27; Internal assessment: 12
      • Unit 4: Maintain Healthy, Safe and Secure Working Environment
      • Chapters include: Health, Safety and Security at Workplace; Workplace Quality Measures; Accident and Emergency procedures; Field visits organization guidelines
      • THEORY marks for Unit 4: 15; PRACTICAL marks: 22; Internal assessment: 10
      • TOTAL PART B: THEORY 60, PRACTICAL 90, INTERNAL ASSESSMENT 40
    • PART C: PRACTICAL WORK
      • Practical Examination: 30 total (as per document, breakdown provided below though there is some inconsistency in the line items):
      • Digital Documentation (Advanced) using LibreOffice Writer: 5 marks
      • Electronic Spreadsheet (Advanced) using LibreOffice Calc: 5 marks
      • Database Management System using LibreOffice Base: 10 marks
      • Viva Voce: 10 marks
      • Note: The document shows Practical Examination as 20 with a total of 30 when breakdowns are added; reference the scheme for your exact evaluation pattern.
    • PART D: PROJECT WORK / FIELD VISIT
      • Any interdisciplinary real-world case study; summarized data reports in Base; input via forms, output via reports; documentation in Writer.
      • PROJECT WORK/FIELD VISIT: 10 marks
      • PORTFOLIO/ PRACTICAL FILE: 10 marks (minimum 5 problems of each tool)
      • GRAND TOTAL for Parts A–D: 200 (overall course total); The document lists the grand totals as 200 and 100 in different sections; follow the official scheme for final tally.
  • DETAILED CURRICULUM (Part-A + Part-B + Part-C + Part-D)
    • PART A: EMPLOYABILITY SKILLS (50 hours total)
    • Unit 1: Communication Skills-II (10 hours)
    • Unit 2: Self-management Skills-II (10 hours)
    • Unit 3: ICT Skills-II (10 hours)
    • Unit 4: Entrepreneurial Skills-II (15 hours)
    • Unit 5: Green Skills-II (5 hours)
    • PART B – SUBJECT SPECIFIC SKILLS
    • Unit 1: Digital Documentation (Advanced) using LibreOffice Writer
      • Chapter 1: Introduction to Styles: create/update/apply styles; styles/categories (Page, Paragraph, Character, Frame, List, Table); styles/formatting; Fill Format; creating/updating new styles; load style from template/document; drag-and-drop style creation.
      • Chapter 2: Working with Images: insert, modify, position images; image toolbar; resize, crop, delete; drawing objects; properties; resizing/grouping; image positioning in text; text wrapping/anchoring/alignment.
      • Chapter 3: Advanced Features of Writer: Tables of Contents (ToC); templates (in-built, saved, online); track changes (prepare for review, recording changes, accepting/rejecting changes); comments; comparing documents; importing/applying templates; editing templates.
    • Unit 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc
      • Chapter 4: Analyse data using scenarios and Goal Seek: consolidating data; groups/subtotals; what-if analysis; scenario manager; Goal Seek; solver for complex problems.
      • Chapter 5: Using Macros in Spreadsheet: recording/running/creating/organizing macros; macro as function; passing arguments; using macros as built-in functions; accessing cells; sorting with macros.
      • Chapter 6: Linking Spreadsheet Data: multiple sheets; references across sheets and to other documents; hyperlinks (relative/absolute); linking to external data; linking to registered data sources.
      • Chapter 7: Share and Review a Spreadsheet: sharing/opening/saving shared spreadsheets; recording changes; comments (add/edit/format); reviewing changes (accept/reject); merge and compare sheets.
    • Unit 3: Database Management System using LibreOffice Base
      • Chapter 8: Introduction to DBMS: data vs information; databases and DBMS; advantages; data models (Hierarchical, Network, Relational); RDBMS terminology; objects (tables, queries, forms).
      • Chapter 9: Starting with LibreOffice Base: navigation; data types; UI; opening a database; creating a table (wizard, design view); setting primary key; saving a table; editing table in design view; entering/editing/deleting/sorting data.
      • Chapter 10: Working with Multiple Tables: editing/deleting tables; relationships (one-to-one, one-to-many, many-to-many); advantages; creating relationships; referential integrity.
      • Chapter 11: Queries in Base: wizard/design view; editing queries; applying criteria; single/multiple fields; wildcard searches; calculations in queries.
      • Chapter 12: Forms and Reports: creating/modifying forms and reports; Form Controls Toolbar; inserting controls/titles/headings/date-time; form wizard; enter/remove data; modify forms; search records; report wizard; various report examples.
    • Unit 4: Maintain Healthy, Safe and Secure Working Environment
      • Chapter 13: Health, Safety and Security at Workplace: policies; hazard identification; risk management; safe work environment; basic safety rules (fire, electrical, first aid).
      • Chapter 14: Workplace Quality Measures: air/water quality monitoring; ergonomics; guidelines for clean air/clean water; overall health and safety at computer workplace; musculoskeletal issues; precautions for computer use; evacuation and accident handling steps.
      • Chapter 15: Prevent Accidents and Emergencies: accident/emergency identification; how to seek help; follow company policies; act within responsibility; evacuations; types of accidents (trip/slip, injuries, escalator-related risks, falling objects, etc.); first aid for electrical hazards; electrical rescue techniques; simulated emergency procedures.
    • PART C: PRACTICAL WORK
    • Practical Examination: total 30 marks (components listed above); includes Viva Voce (10 marks).
    • PART D: PROJECT WORK / FIELD VISIT
    • Real-world case study; inputs via forms; outputs via reports; documentation via Writer; Portfolio/Practical File: printouts from Writer, Calc, Base; minimum 5 problems per tool.
  • FIELD VISITS GUIDELINES
    • Organize at least 3 field visits/educational tours per year to expose students to workplace activities.
    • Visit a data entry centre; observe: location, site, office building, computer systems, tools/equipment, printers, scanners.
    • During visit, collect data from owner/supervisor:
    • Data Entry Centre details
    • Computer infrastructure
    • Sitting posture of data entry operators
    • Assistive technology
    • Manpower engaged
    • Total expenditure of Data Entry Centre
    • Total annual income
    • Profit/Loss (Annual)
    • Any other information
  • LIST OF EQUIPMENT/MATERIALS (SUGGESTIVE; BASED ON TEACHER INPUT)
    • A. HARDWARE
    • 1) Computer (latest config or min Pentium with 2 GB RAM, 512 GB HDD, 17” LED, NIC, 3-button mouse, 105-key keyboard, built-in speakers/mic) – Qty 15
    • 2) Laser Printer – 1
    • 3) Inkjet Printers (Colour and B/W) – 1
    • 4) Scanner – 1
    • 5) Online UPS 5 KVA – 1
    • 6) 16 Port Switches – 1
    • 7) Air Conditioner 1.5 ton – 2
    • 8) Telephone line (For Internet) – 1
    • 9) Fire extinguisher – 1
    • B. SOFTWARE
    • Operating System Linux and Windows
    • Anti-Virus (Latest version)
    • Productivity Suite (Open Office, etc.)
    • C. FURNITURE
    • Class room chairs and desks – 25
    • Computer Tables – 15
    • Straight back revolving adjustable chairs – 15
    • Printer Tables – 2
    • Trainers Table – 1
    • Trainers Chair – 1
    • Steel cupboards/drawer – 2
    • Cabinet with drawer – 1
    • Steel Almira (big) – 1
    • Steel Almira (small) – 1
  • TEACHER’S/TRAINER’S QUALIFICATIONS
    • Qualification: Diploma in Computer Science/Information Technology or BCA/B.Sc in Computer Science/IT orGraduate with PGDCA or DOEACC A Level; higher qualifications also acceptable.
    • Age: 18-37 years (as on Jan 01 of the year) with age relaxation as per Govt rules.
    • Experience: Minimum 1 year in the same job role.
    • Language: Proficient in English and local language; knowledge of equipment/tools/safety/health.
    • Roles of teachers: discuss industry links, field visits, OJT, placement; ensure quality teachers/trainer selection; induction training (20 days); in-service training (5 days per year).
    • Selection process: Written test (technical/domain knowledge), interview (panel from field and state), practical test/mock in classroom/workshop/lab; for VTP-based appointments, committee may include state representatives and VTP.
    • Responsibilities: session planning; deliver curriculum; use ICT tools; engage students with diverse methodologies; organize skill demonstrations/visits/onsite training; identify learning gaps; provide placement support; adapt for different abilities; ensure learning needs addressed; documentation and reporting.
    • Quality assurance: annual performance appraisal using criteria like guidance/counselling activities, innovative teaching, results improvement, ongoing skill upgrades, professional memberships, instructional materials, industry linkages, community involvement, student placement involvement.
  • CAREER OPPORTUNITIES & VERTICAL MOBILITY
    • Job scope: Data entry operator/analyst across public/private sectors; input data quickly and accurately; data storage, recovery, and analysis; report preparation; proficiency in computer and database systems.
    • Sectors: Banks/public sector, marketing, accounting, HR, corporate businesses, MNCs, study centers, schools/universities, hospitals/healthcare, insurance, small businesses.
    • Vertical mobility options:
    • Pursue Polytechnic/Diploma/Certificate in IT fields.
    • Work as DEO (Data Entry Operator).
    • Data entry/analysis work from home for various companies.
  • NOTES
    • The curriculum emphasizes safe and ethical ICT use, sustainable practices, and workplace safety.
    • The scheme includes practical work, field visits, and portfolio documentation to reinforce real-world skills.
    • Some sections of the document show minor inconsistencies in mark distribution across Part C; always refer to the official CBSE SKILL ED circulars for the final scheme of evaluation.