KLiC Certificate in Information Technology - Class 11 (HSC Board)

2.1 Introduction

2.2 Definition of a Database

2.3 Introduction to Database Management System (DBMS)

2.4 Some Applications of DBMS

• Railway Reservation System
• Library Management System
• Banking
• Universities and Colleges
• Credit Card Transactions
• Social Media Sites

2.5 Advantages of DBMS

• Reducing Data Redundancy
• Sharing of Data
• Data Integrity
• Data Security
• Privacy
• Backup and Recovery
• Development and Maintenance Time

2.6 Data Types in the DBMS

2.7 Data Model

• Relational Model
• Properties of Transactions

2.8 Introduction of RDBMS

• Basic Database Concept
• There are 3 types of relationships in relational database design:
  • One-to-One
  • One-to-Many (or Many-to-One)
  • Example of One-to-Many Relationship

2.9 Introduction to SQL

2.10 Categories of SQL Commands

• Data Definition Language (DDL) Commands
• Data Manipulation Language (DML) Commands
• Data Control Language (DCL) Commands

3.1 Introduction

3.2 How does the web work?

3.3 Components of web

• Web uses the following terms

3.4 Introduction to HTML5

• Basic structure
• An attribute
• Classification of HTML Tags
• Basic structure of HTML

3.5 Text formatting element

3.6 Heading levels

3.7 Inserting an image, a horizontal ruled line and a paragraph

3.8 Creating a table

• The attributes of table are
• The attributes of the <tr>, <th>, <td>

3.9 Creating hyperlinks in a webpage

• HTML Link colours
• Image hyperlink

3.10 Forms in HTML

• Form controls
• Attributes used with form element and Input element
  • Name
  • Action
  • Method
• Attributes of <input>

3.11 Introduction

3.12 Scripting language

• Insertion of JavaScript in HTML

3.13 Variables

• Rules to declare variables

3.14 Data Types

• 1. Number type
• 2. String type
• 3. Boolean type
• 4. Infinity
• 5. null
• 6. undefined

3.15 Operators

• 3.15.1 Arithmetic operators
• 3.15.3 Assignment Operators (=)
• 3.15.4 Relational Operators
• 3.15.5 Logical Operators
• 3.15.6 Increment (++) and Decrement (--) Operators

3.16 Commonly used Built-In Functions in JavaScript

3.17 Decision Making Statements

3.18 User Defined Functions

4.1 Introduction

4.2 Ethics and Morals

• Ethics
• Morals

4.3 Cyber Crime

• Software Piracy
• Unauthorized access
• Copyright violation
• Cracking
• Cyberbully or Cyberstalking
• Phishing
• Plagiarism
• Hacking

4.4 Cyber Safety and Security

1. Identify threats and risk
2. Protection of data
3. Recovery from cyber attack
4. Educate your stakeholders (students, staff etc)

4.5 IT Act of India 2000

• Salient Features of I.T. Act