KLiC Certificate in Information Technology - Class 10 CBSE (402)

Apply Stress Management Techniques

THEORY

• Meaning and importance of stress management
• Stress management techniques (physical)
  • Exercise
  • Yoga
  • Meditation
• Enjoying, going to vacations and holidays with family and friends
• Taking nature walks

PRACTICAL

• Exercises on stress management techniques – yoga, meditation, physical exercises
• Preparing a write-up or an essay on experiences during a holiday trip

Demonstrate the Ability to Work Independently

THEORY

• Importance of the ability to work independently
• Describe the types of self-awareness
• Describe the meaning of self-motivation and self-regulation

PRACTICAL

• Demonstration on working independently
• Setting goals
• Planning of an activity
• Executing tasks in a specific period, with no help or directives
• Demonstration on the qualities required for working independently

Distinguish Between Different Operating Systems

THEORY

• Classes of operating systems
• Menu, icons and task bar on the desktop
• File concept, file operations, file organization, directory structures, and file system structures
• Creating and managing files and folders

PRACTICAL

• Identification of task bar, icons, menu, etc
• Demonstration and practicing of:
  • Creating, renaming, and deleting files and folders
  • Saving files in folders and subfolders
  • Restoring files and folders from Recycle Bin

Apply Basic Skills for Care and Maintenance of Computer

THEORY

• Importance and need of care and maintenance of computer
• Cleaning computer components
• Preparing maintenance schedule
• Protecting computer against viruses
• Scanning and cleaning viruses
• Removing SPAM files, temporary files, and folders

PRACTICAL

• Demonstration of the procedures to be followed for cleaning, care, and maintenance of hardware and software

List the Characteristics of Successful Entrepreneur

THEORY

• Entrepreneurship and society
• Qualities and functions of an entrepreneur
• Role and importance of an entrepreneur
• Myths about entrepreneurship
• Entrepreneurship as a career option

PRACTICAL

• Writing a note on entrepreneurship as a career option
• Collecting success stories of first-generation and local entrepreneurs
• Listing the entrepreneurial qualities – analysis of strengths and weaknesses
• Group discussion of self-qualities that students feel are needed to become a successful entrepreneur
• Collect information and related data for a business
• Make a plan in a team for setting up a business

Demonstrate the Knowledge of Importance, Problems and Solutions Related to Sustainable Development

THEORY

• Definition of sustainable development
• Importance of sustainable development
• Problems related to sustainable development

PRACTICAL

• Identify the problems related to sustainable development in the community
• Group discussion on the importance of respecting and conserving indigenous 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
  • Vermicompost
  • Solar energy
  • Solar cooker

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

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

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

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

Implement Mail Merge

THEORY

• Advanced 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 how to print labels using mail merge
• 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

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

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

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

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

Create and Use Macros in Spreadsheet

THEORY

• Using the macro recorder
• Creating a simple macro
• Using a macro as a function
• Passing arguments to a macro
• Passing the arguments' area values
• 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
• Sort the columns using macro

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 Database 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

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 the main window
• Identify the database objects
• Create the sample table using wizard
• Practice to create different tables from the available list
• Choose fields from the available fields
• Assign data types of fields
• Set primary key
• Edit the table in design view
• Enter data in the fields
• Create and edit table using DDL Commands

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

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 (Create database, Create table, Alter table, Drop table)

PRACTICAL

• Prepare a query for given criteria
• Demonstrate to create query using wizard and design view
• Edit a query
• Demonstrate to apply various criteria in query – single field, multiple fields, using wildcard
• Perform calculations using query in Base
• Demonstrate to group data
• Use basic SQL commands

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

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.

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
• Commonly used Internet connectivity options
• Data transfer on the Internet

PRACTICAL

• Identify applications of Internet
• Compare various internet technologies
• Identify types of networks and select appropriate internet access

Introduction to Instant Messaging

THEORY

• Learn key features of instant messaging
• Creating an instant messaging account
• Launching Google Talk
• Signing into your Google Talk account

PRACTICAL

• Illustrate steps to create instant messaging account
• Sign in into your Google Talk account

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 using various messenger services

Creating and Publishing Web Pages – Blog

THEORY

• Learn and appreciate a blog and its creation using 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

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 when internet connectivity is available using various examples

Online Transaction

THEORY

• Concept of e-commerce and various online applications
• Importance of secure passwords

PRACTICAL

• Illustration of online shopping using various e-commerce sites
• Demonstration of securing passwords for online transactions

Internet Security

THEORY

• Need of internet security
• Cyber threats like phishing, email spoofing, chat 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 in various ways
• Cyber security tips
• Tips for secure passwords
• Demonstration of strong passwords using various websites
• Clearing data stored in browser applications

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
• Fire safety, falls and slips, electrical safety, use of first aid

Prevent Accidents and Emergencies

THEORY

• Accidents and emergencies
• Types of accidents
• Handling accidents
• Types of emergencies

PRACTICAL

• Illustrate handling accidents at workplace
• Demonstrate following evacuation plan and procedure in case of an emergency

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 problems at workplace that could cause accidents
• Practice general evacuation procedures in case of an emergency