(Syllabus) CBSE Syllabus of Informatics Practices for Class 11th For March 2009 Examination
Disclaimer: This website is NOT associated with CBSE, for official website of CBSE visit - www.cbse.gov.in
Syllabus : CBSE Syllabus of Informatics Practices for Class 11th For March 2009 Examination
EXAMINATION SPECIFICATIONS
Class XI | INFORMATICS PRACTICES (Code 065)
One Theory Paper
3 Hours
70 Marks
Unit Marks Unit-1: COMPUTER SYSTEM AND BUSINESS APPLICATIONS 10 Unit-2: INTRODUCTION TO PROGRAMMING 30 Unit-3: RELATIONAL DATABASE MANAGEMENT SYSTEM 30 TOTAL : 70
UNIT 1: COMPUTER SYSTEM AND BUSINESS APPLICATIONS
Evolution of computers; Basics of computer and its operation: Functional
Components and their inter-connections, concept of Booting;
Hardware concepts:Diagram illustrating main parts of computers; Central
Processing Unit (CPU): Arithmetic Logic Unit (ALU), Control Unit, Memory Unit
(RAM - Random Access Memory & ROM - Read Only Memory) Role of Input,
Processing and Output Devices in a computer system Input devices: Keyboard,
Mouse, Light pen, Touch Screens, Graphics Tablets, Joystick, Mic, MICR, OCR,
Scanner, Smart Card reader, Barcode reader, Biometric sensor, web camera,
digital camera;
Output Devices: Monitor/Visual Display Unit (VDU), Printer (Dot Matrix
Printer, Desk jet/ Ink jet/ Bubble jet Printer, Laser Printer), Plotter,
Speaker, Secondary Storage Devices: Floppy Disk, Hard Disk, Compact Disk,
Magnetic Tape, Digital Video Disk (DVD), Zip Drive; Units of Memory: Bit (Binary
Digit), Byte, Kilobyte, Megabyte, Gigabyte.
Software Concepts:
Types of Software: System Software, Utility Software and Application Software.
System Software: Operating System, Language Compilers, Interpreters and
Assembler; Operating System: Need of operating systems, Functions of Operating
System Types of operating system.
Utility Software: Compression tools, Anti Virus, File Management tools and Disk
Management tools; Application Software as a tool: Word Processor, Presentation
Tool, Spreadsheet Package, Database Management System; Business software (for
example: Inventory Management System, Payroll System, Financial Accounting,
Hotel Management, and Reservation System); Development of programming languages
- Machine Language, Assembly Language, High Level Language (BASIC, COBOL,
FORTRAN, PASCAL, C++); GUI based languages - Visual Basic, Visual C++; C#, Java,
vb.net.
GUI Operating System Important: Students/Teachers can also perform
similar operation on any operating system. It is advised that the teacher while
using any one operating system, give a demonstration of equivalent features for
the other operating system.
Windows
General features, Elements of Desktop - Taskbar, Icon, Start button, Shortcuts,
Folder, Recycle Bin, My Computer; Start Menu: Program, Documents, Settings,
Find/Search, Help, Run, Shut Down/Logoff; Customization of Taskbar, start menu,
Display properties (Wallpaper, Font Settings, Color Settings, Screen Savers);
Program Menu: Accessories - Calculator, Notepad, Paint, Word pad, Entertainments
(CD Player, Sound Recorder, Media Player, Volume Controller); Internet Browsers
– Mozila Firefox, Internet Explorer, Netscape Navigator. Control Panel: Add
new hardware; Add new Software, Printer Installation, Date/Time, Mouse, and
Regional Settings;
Documentation Purpose of using word processing software, opening a new/existing
document, closing a document, typing in a document, saving a document, print
preview, printing a document, setting up of page as per the specifications,
selecting a portion of document, copying selected text, cutting selected text,
pasting selected text; changing font, size, style, color of text; Inserting
symbol; Formatting: Alignment – Left, Right, Center; Justification; Industries
and Business Computing: Types of Industries (Production, Shipping, Travel,
Hotel, Insurance, Construction, Automobile), Applications of Business Computing
in Industries.
UNIT 2: INTRODUCTION TO PROGRAMMING
Programming Methodology: General Concepts; Modular approach; Stylistic
Guidelines: Clarity and Simplicity of expressions, Names, Comments,
Indentation; Documentation and Program Maintenance; Running and Debugging
programs, Syntax Errors, Run-Time Errors, Logical Errors; Problem Solving
Methodology and Techniques: Understanding of the problem, Identifying minimum
number of inputs required for output, Step by step solution for the problem,
breaking down solution into simple steps, Identification of arithmetic and
logical operations required for solution, Using Control Structure: Conditional
control and looping (finite and infinite);
Programming Tool: Visual Basic
Introduction to Programming – Modular Programming, Object Oriented Programming, Event Driven Programming; About Visual Basic (Object Based Programming Language), Rapid Application Development using Visual Basic; Concept of Project in Visual Basic, VB Project Options - Standard EXE, ActiveX DLL, ActiveX EXE, ActiveX Control, ActiveX Document DLL, ActiveX Document EXE, Addin, VB Application Wizard, IIS Application, DHTML Application; Getting Familiar with Visual Basic User Interface - Pull-Down menus, Toolbar, Toolbox, Project Explorer, Properties Window, Form Layout window, Form, Immediate window; Opening and Closing windows, Resizing and moving windows, Docking windows; Quitting Visual Basic;
Visual Basic Tool Box (Standard Window Controls) - Pointer, Picture Box,
Label, Text Box, Frame, Command Button, Check Box, Option Button, Combo Box,
List Box, Horizontal Scrollbar, Vertical Scrollbar, Timer, Drive List box,
Directory List box, File List box, Shape, Line, Image, Data, OLE; Object Naming
Conventions, Event Procedures;
Programming Fundamentals
Data Types: Integer, Long, Single, Double, Currency, String, Byte, Boolean,
Date, Object, Variant; Variables: Need to use variable, Declaring Variables,
Variable Naming Convention, Assigning value to Variables, Data Types of
variable, Scope and lifetime of Variables (Public and Private);
Control Structures: Decision Structure – IF, IF-THEN-ELSE, Select
Case;Looping Structure- Do While…Loop, Do…Loop While, For…Next, For
Each…Next; Menu Editor: Concept of Menus, Shortcut menus and Popup menus
Designing Menu System, Menu Editor Dialog Box Options (Name, Index, Shortcut,
HelpContextID, NegotiatePosition, Checked, Enabled, Visible, WindowList, Right
Arrow, Left Arrow, Up Arrow, Down Arrow, Menu List, Next, Insert, Delete, OK,
Cancel), To Create Menu Controls in the Menu Editor,
Menu Naming Conventions, Setting the Name Property, Creating a Menu Control
Array, Creating Sub Menus, Separating Menu Controls, Assigning Access Keys and
Shortcut Keys, Controlling Menus at Runtime-Enabling and Disabling Menu
Commands, Displaying a Checkmark on a Menu Control, Making a Menu Control
Invisible, Adding Menu Control at Runtime, Displaying Pop-Up Menu;
General Controls (Advance): Image List,
Common Dialog Box, ADO DC, DB Combo, Media Player Control, DB Grid; Adding a
Toolbar: Creating an Image List, Adding Images to the Toolbar, To Add Code for
the Toolbar Buttons; Adding Status Bar: Adding Status Bar panels, Adding Time on
the panel. Dialog Boxes: Pre-defined dialog box, Custom dialog box;
UNIT 3: RELATIONAL DATABASE MANAGEMENT SYSTEM
Database Management System: Introduction to database concepts:
relation/Table, attribute, Tuple / Rows, field, Data, Concept of String, Number
and Date values, Data type and Data Integrity (Domain and Referential
integrity). Candidate key, Alternate key, Primary Key, Foreign Keys; Data
Normalization-first, second, third, BCNF normal form;
Examples of Commercially available Database Management System’s (Back-End) –
Oracle, MS-SQL Server, DB2, MySQL, Sybase, INGRES. Examples of Front End
Software’s: Oracle Developer, Visual Basic, Visual C++, Power Builder, Delphi;
RDBMS Tool : Interface with Oracle, Login Screen, Entering Name and
Password; Classification of SQL Statements: DML (SELECT, INSERT, UPDATE,
DELETE), DDL (CREATE, DROP, ALTER, RENAME, TRUNCATE), DCL (GRANT, REVOKE), TCL
(COMMIT, ROLLBACK); SQL SELECT Statement: SQL SELECT statement, Selecting All
the Columns, Selecting Specific Column, Column Heading Default, Using Arithmetic
Operators, Operator Precedence, Significance of NULL value, NULL values in
Arithmetic Expressions, Defining and using Column Alias, Concatenation Operator
(||), Duplicate rows and their Elimination (DISTINCT keyword), Role of SQL and
SQL*Plus in interacting with RDBMS, Displaying Table Structure (DESC command);
SELECT Statement Continued: Limiting Rows during selection (using WHERE clause),
Working with Character Strings and Dates, Using Comparison operators, BETWEEN
Operator, IN Operator, LIKE Operator, IS NULL Comparison, Logical Operators, Use
of Logical Operators (AND/OR/NOT Operators), Logical Operator Precedence, ORDER
BY Clause, Sorting in Ascending/Descending Order, Sorting By Column Alias Name,
Sorting On Multiple Columns;
Functions: SQL Functions, Types of SQL Function (Single Row/Multiple Row),
Single Row SQL Functions, Character Functions (Case Conversion/Character
Manipulation), Case Conversion Functions (lower (), InitCap (), UPPER ())
Character Manipulation Function (CONCAT(), INSTR(), LENGTH(), TRIM(), SUBSTR(),
LPAD()), Number Functions (ROUND(), TRUNC(), MOD()), Working with Dates (LAST_DAY(),
MONTHS_BETWEEN(),
NEXT_DAY(), ADD_MONTHS(), ROUND(), TRUNC()) Arithmetic Operation on Dates, Date
Functions and their Usage, Data type Conversion Functions, Implicit and Explicit
Conversion, TO_CHAR Function with Dates, TO_CHAR Function For Numbers, TO_NUMBER
and TO_DATE Functions, NVL Function and its Usage, DECODE Function and its
Usage; Grouping Records: Concept of Grouping Records and Nested Grouping, Nested
Grouping of records, Group Functions, Types of group functions (MAX(), MIN(),
AVG(), SUM(), COUNT()),
Using AVG and SUM Functions, Using MIN and MAX Functions, Using the COUNT
Function, using COUNT(*), DISTINCT clause with COUNT, Group Functions and Null
Values, Using NVL Function with Group Functions, Grouping Records: Group By
Clause, Grouping By More than One Column, Illegal Queries with Group By Clause,
Excluding Group Results: Having Clause, Nesting Group Functions,
Sub Queries: Concept of Sub-Query, Sub Query to Solve a Problem,
Guidelines for Using Sub Queries, Types of Sub-Queries (Single Row and Multiple
Row) and (Single Column and Multiple Column); Single Row Sub-Query and its
Execution;
Displaying Data From Multiple Tables: Concept of Join, Result of Join,
Cartesian Product and Generating Cartesian Product example using Mathematical
Set), Types Of Joins (EQUI, SELF, NON-EQUI, OUTER (LEFT and RIGHT)), Equi-join:
Retrieving Records with Equi-join, Additional Search Conditions using AND
operator, Short Naming Convention for Tables (Table Aliases), Non-Equi join and
its Implementation, Outer-Join and Its Usage, Self-Join (Joining a table to
Itself);
Manipulating Data of A Table/Relation: Concept of DML (Data Manipulation
Language), INSERT Statement, Inserting New Rows, Inserting New Rows with Null
Values, Inserting Date Values, Use of Substitution Variable to Insert Values,
Copying Rows From Another Table, Update Statement to Change Existing Data of a
Table, Updating Rows In A Table, Updating Rows Based on Another Table, Delete
statement/ Removing Row/Rows from a Table, Deleting Rows Based on condition from
another Table; Making Data Manipulation Permanent (COMMIT). Undo Data
Manipulation Changes (ROLLBACK)
Database Objects: View, Table, Sequence, index, and Synonyms, DDL (Data
Definition Language), Naming Convention, Creating Views, Creating Synonyms,
Simple Views and Complex Views, Retrieving Data From a View, Querying a View,
Modifying a View, Including Constraints: Constraints, Concept of using
Constraints, Constraint Guidelines, Defining Constraints, NOT NULL, UNIQUE KEY,
PRIMARY KEY, FOREIGN KEY, FOREIGN KEY Constraint Keywords, CHECK, Adding a
Constraint, Dropping a Constraint, Disabling Constraints, Enabling Constraints,
Viewing Constraints, Viewing The Columns, Associated with Constraints;
Creation of a Table/Relation: CREATE TABLE Statement, Data types, The
DEFAULT option, Creating Tables, Referencing Another User’s Tables, Querying
the Database Dictionary to view all tables in the Oracle Database, Creating a
Table by Using a Sub-Query;
Managing Existing Tables and other Database Objects: The ALTER TABLE Statement,
Adding a New Column in a Table, Modifying Existing Column, Dropping a Column,
Renaming an Object, Truncating a Table, Adding Comments to a Table, Dropping
Views, Dropping synonyms, Dropping Tables; giving permission to other
users to work on Created Tables and Revoking it (GRANT and REVOKE statement).