Grade 12 CBSE Syllabus Class : Informatics
OnePaper 3 Hours 70 Marks
|
Unit
|
Marks
|
|
INTRODUCTION TO COMPUTER SYSTEMS
|
10
|
|
INTRODUCTION TO PROGRAMMING
|
25
|
|
RELATIONAL DATABASE MANAGEMENT SYSTEM
|
30
|
|
IT APPLICATIONS
|
05
|
UNIT 1: INTRODUCTION TO COMPUTER SYSTEMS
Hardware Concepts:
Computer organization (basic concepts): CPU, Memory (RAM and ROM), I/O devices, communication
bus, ports (serial, parallel, network, phone);
Input devices: Keyboard, Mouse, Light pen, Touch Screens, Graphics Tablets, Joystick, Microphone,
OCR, Scanner, Smart Card reader, Barcode reader, Biometric sensor, web camera;
Output Devices: Monitor/Visual Display Unit (VDU), LCD screen, Television, Printer (Dot Matrix
Printer, Desk jet/ Inkjet/ Bubble jet Printer, Laser Printer), Plotter, Speaker;
Secondary Storage Devices: Floppy Disk, Hard Disk, Compact Disk, Magnetic Tape, Digital Versatile
Disk (DVD), USB Drive, Memory cards - Comparative properties
Software Concepts:
Operating systems, Need for operating system, major functions of Operating System, Memory
Management
Security of system: sources of attack and possible damages, virus and related entities - worms,
propagation of these entities, virus detection using a tool, Desktop security, Digital certificates, Digital
signature, cookies, firewall, password, file access permissions.
Types of Software: System Software, Utility Software, Application Software and Developer Tools
System Software:
General Purpose Application Software: Word Processor, Presentation Tool, Spreadsheet Package,
Database Management System;
Specific Purpose Application software (for example: Inventory Management System, Purchasing System,
Human Resource Management System, Payroll System, Financial Accounting, Hotel Management
and Reservation System, etc.);
Developer Tools: Compilers and Interpreters, Integrated Development Environment
UNIT 2: INTRODUCTION TO PROGRAMMING
Getting started with Programming using IDE
Introduction, Rapid Application Development using IDE - Integrated Development Environment;
Familiarization of IDE using basic Interface components;
Basic component handling methods/attributes
Programming Fundamentals
Data Types: Concept of data types; Built-in data types - byte, short, int, long, float, double, char,
String (or any object), Boolean; Concept of a Class and Instance as user-defined datatypes.
Variables:
Need to use variable, Declaring Variables, Variable Naming Convention, Assigning value to Variables;
Control Structures:
Assignment Statement
Decision Structure - if, if-else, switch;
Looping Structure- while, do-while, for;
Concept of a Method: structure, local variables, return values, types of parameter passing
Concept of a Class ( simple class only): members, methods, using classes as data types
Programming Guidelines:
Choice of Expressions and Names, , Comments, use of Indentation; Documentation and Program
Maintenance; Debugging programs: Syntax Errors, Run-Time Errors, Logical Errors;
Problem Solving Methodology and Techniques: Understanding of the problem, Identifying relevant
information, top-down development approach.
UNIT 3: RELATIONAL DATABASE MANAGEMENT SYSTEM
Database Management System
Introduction to database concepts: Relation/Table, attribute/fields, Tuple / Rows;
Data Types - Number, Character and Date
147
Key - Primary Key, Candidate key, Alternate key;
Introduction to MySQL
(ANSI SQL 99 standard commands)
Classification of SQL Statements:
DML - SELECT, INSERT, UPDATE, DELETE;
DDL - CREATE, DROP, ALTER;
SQL SELECT Statement (working with demo/already existing tables): SELECT statement, Selecting
All the Columns, Selecting Specific Column, Using Arithmetic Operators, Operator Precedence, Defining
and using Column Alias, Duplicate rows and their Elimination (DISTINCT keyword), Displaying Table
Structure (DESC command); SELECT Statement Continued: Limiting Rows during selection (using
WHERE clause), Working with Character Strings and Dates, Working with NULL values;
Using Comparison operators - =, <, >, <=, >=, < >, BETWEEN, IN, LIKE(%), Logical Operators
-AND, OR, NOT; Operator Precedence;
ORDER BY Clause, Sorting in Ascending/Descending Order, Sorting By Column Alias Name, Sorting
On Multiple Columns;
Functions in MySQL:
String Function - CHAR(), CONCAT(),INSTR(), LCASE(), LEFT(), LOWER(), LENGTH(),
LTRIM(), MID(), RIGHT(), RTRIM(), SUBSTR(), TRIM(), UCASE(), UPPER().
Mathematical Functions - POWER(), ROUND(), TRUNCATE().
Date and Time Functions - CURDATE() , DATE(), MONTH(), YEAR(), DAYNAME(),
DAYOFMONTH(), DAYOFWEEK(), DAYOFYEAR(), NOW(), SYSDATE().
Manipulating Data of a Table/Relation: Inserting New Rows, Inserting New Rows with Null Values,
Inserting NUMBER, CHAR and DATE Values, Update Statement to Change Existing Data of a
Table, Updating Rows in A Table, Delete statement - removing row/rows from a Table;
Creating Table using CREATE TABLE, ALTER TABLE for adding a new column, using naming
conventions for column names
UNIT 4: IT APLICATIONS
• e - Governance - Definition, e-Governance websites; their salient features and societal impacts
• e - Business - Definition, e-Business websites, their salient features and societal impacts
• e - Learning - Definition; Benefits to students (Learners), Teachers (Trainers) and School
(Institution) Management; e-Learning websites and their salient features and societal impacts
