CBSE Class 11 Informatics Practices Syllabus 2011-2012

Scroll down for PDF

Class XI

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), device specific ports.

Input devices: Keyboard, Mouse, Light pen, Touch Screen, 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), Flash Drive, Memory cards; Comparative properties of storage media;

Memory Units: Bit (Binary Digit)/Byte (Kilobyte, Megabyte, Gigabyte, Terabyte, Petabyte)

Security of computer system: sources of attack and possible damages, malware-virus and related

Entities - virus, trogen, spyware, worms, propagation of these entities, virus detection using a tool, digital certificates, digital signature, cookies, firewall, password, file access permissions

Types of Software:

(a) System Software

(i) Operating systems, Need for operating system, major functions of Operating System.

(ii) Language Processors : Assembler, Interpreter and Compiler.

(b) Utility Software: Compression tools, disk defragmenter, anti-virus.

(c) Application Software :

(i) General Purpose Application Software: Word Processor, Presentation Tool, Spreadsheet Package, Database Management System.

(ii) Specific Purpose application Software: Inventory Management System, Purchasing System, Human Resource Management System, Payroll System, Financial Accounting, Hotel Management and Reservation System etc.

(d) Developer Tools : Interpreter / Complier, Integrated Development Environment (IDE)

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-Label, Text Field, Test Area, Button, Checkbox, Radio Button. (As per appendix B). 

• Developing General Application (As per the guidelines at appendix B) - Getting Familiar with Java Swing User Interface components - Frame, Dialog, Option Pane, Label, Text Field, Password Field, Text Area, Button, Check Box, Radio Button, Combo Box, List, Table.

• Basic component handling methods and properties: Set Text, Get Text, Add, isSelected, setSelected.

Programming Fundamentals

Data Types: Concept of data types; Built-in data types - byte, short, int, long, float, double, char, String, boolean

Variables:

Need to use variable, Declaring Variables, Variable Naming Convention, Assigning value to Variables; Integer object method: parseInt 

Double object method: parse double, parse float

Control Structures:

Decision Structure - if, if-else, switch;

Looping Structure- while, do-while, for;

Programming Guidelines:

General Concepts; Modular approach; Stylistic Guidelines: Clarity and Simplicity of Expressions, Names, Comments, Indentation; Running and debugging programs, Syntax Errors, Run-Time Errors, Logical Errors.

Problem Solving Methodology : Understanding of the problem, Identifying minimum number of inputs required for output, breaking down problem into simple logical steps.

UNIT 3: RELATIONAL DATABASE MANAGEMENT SYSTEM

Database Management System

Introduction to database concepts: Date base, Relation/Table, attribute/field, Tuple / Rows;

Data Types - Number, Character and Date

Key - Primary Key, Candidate key, Alternate key, Foreign key;

Examples of common Database Management System - MySQL, INGRES, POSTGRES, ORACLE, DB2, MS SQL, Sybase.

Introduction to MySQL

(ANSI SQL 99 standard commands)

Classification of SQL Statements:

DML - SELECT, INSERT, UPDATE, DELETE

DDL - CREATE, DROP, ALTER

Creating and using a databse: SQL CREATE command to create a database, USE command to select a database.

Creating a table: CREATE command to create a table, DESC command to display a table structure,

INSERT command for: Inserting New Rows, Inserting New Rows with Null Values, Inserting NUMBER, CHAR and DATE Values.


Please refer to attached file for CBSE Class 11 Informatics Practices Syllabus 2011-2012

Tags: 


Click on the text For more study material for Informatics Practices please click here - Informatics Practices

Latest NCERT & CBSE News

Read the latest news and announcements from NCERT and CBSE below. Important updates relating to your studies which will help you to keep yourself updated with latest happenings in school level education. Keep yourself updated with all latest news and also read articles from teachers which will help you to improve your studies, increase motivation level and promote faster learning

Simple tips to Excel in Examinations

We are entering the last quarter of the Academic Session. With examinations just around the corner, I am sure all of us are carrying a mixed bag of Stress, Excitement, and Anxieties!! So, first and foremost- Let’s be Positive and Futuristic! It’s most important to...

CBSE Counseling for Board exam 2020 starts today

The 23rd psychological Counseling starts 1st February (today) for The Class10 and Class12 CBSE students and their parents, by the Central Board of Secondary Education (CBSE).    This Counseling service is cost-free and this counseling service will be available every...

CBSE Board Exam Date Sheet of class 10th and 12th

The Central Board of Secondary Education (CBSE) released the Date sheet of Class 10 and Class 12th 2020 examination on the official website cbse.nic.in. The board examination of Class 12 will be conducted from 15 February to 30 March 2020, while the board examination...

×
Studies Today