cbse syllabus for class 11 informatics practices 2014 -2015 with theory and practical

CBSE syllabus for class 11 informatics practices 2014 -2015 

INFORMATICS PRACTICES 

Learning Objectives:

•        To gain working knowledge of a computer system and peripherals

•        To understand the application development process.

•        To gain programming skills in front-end development

•        To gain skills in Relational Database Creation and Management.

Competencies:

•        Sound knowledge of computer system

•        Familiarity with Application Development process using simple IDEs

•        Ability to use, develop & debug programs independently.

•        Ability to store and retrieve data using an RDBMS.

Class XI

Unit	Topic	Period		Marks
1. 2. 3. 4.	INTRODUCTION TO COMPUTER SYSTEMS INTRODUCTION TO PROGRAMMING RELATIONAL DATABASE MANAGEMENT SYSTEM IT APPLICATIONS	Theory 15 40 40 5	Practical 05 35 35 15	Theory 10 25 30 5	Practical 02 16 6 6
		100	90	70	30

UNIT 1: INTRODUCTION TO COMPUTER SYSTEMS Hardware Concepts:

Computer system 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.

Primery Memory : Cache, RAM & ROM

Secondary Storage Devices: Floppy Disk, Hard Disk, Compact Disk, Magnetic Tape, Digital

Versatile Disk (DVD), Flash Pen Drive, Memory cards; Comparative properties of storage media;

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

Security of computer system: sources of attack and possible damages, malware-virus and related entities - virus, trojan, 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 Tool : 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, Text Area, Button, Checkbox, Radio Button. (As per appendix B).

•     Developing General Application - Getting Familiar with Java User Interface Swing components - Frame, Option Pane, Label, Text Field, Password Field, Text Area, Button, Check Box, Radio Button, Combo Box, List, and their respective methods and properties:

(As per appendix B)

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 Conventions,Assigning values to Variable(s);

Integer object method: Parse Int

Double object method: parse double, parse float

Control Structures:

Decision Structures: if, if-else, switch; Looping Structures: while, do-while, for; Programming Guidelines:

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

Modular approach;

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

UNIT 3: RELATIONAL DATABASE MANAGEMENT SYSTEM

Relational Database Concepts

Introduction to database concepts: Data base, Relational Database, Relation/Table, attribute/field, Tuple / Rows;

Data Types: Number, Character and Date

Keys: Key, Primary Key, Candidate key, Alternate key, Foreign key;

Examples of common Relational Database Management System - MySQL, Ingres, Postgre SQL, Oracle, DB2, MS SQL, Sybase.

Introduction to MySQL

(ANSI SQL 99 standard commands)

Classification of SQL Statements:

DML (Data Manipulation Languages):SELECT, INSERT, UPDATE, DELETE DDL (Data Definition Languages): 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 to insert new row, Inserting new rows (with Null Values, NUMBER, CHAR and DATE Values).

Displaying table data: SELECT command for Selecting all the Columns, Selecting Specific Column, UsingArithmetic Operators, Operator Precedence, Defining and using column alias, Eliminating duplicate values from display (DISTINCT Keyword), Limiting rows during selection (using WHERE clause), Working with number Character, Date, and NULL values.

•     Using Comparison Operators : =, <, >, <=, >=, <>, BETWEEN, IN, LIKE (%,_), Using

Logical Operators - AND, OR, NOT, Operator Precedence.

•            ORDER BY Clause: Sorting in Ascending/Descending Order, Sorting using Column alias, Sorting On Multiple Columns.

Manipulating Data of a Table/Relation: Update command to change existing data of a Table; Delete command for removing row(s) from a Table.

Restructuring a table: ALTER TABLE for adding new column(s), and deleting columns.

Functions in MySQL:

String Functions : 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().

UNIT 4: IT APPLICATIONS

e-Governance : Definition, Benefits to citizens, e-Governance websites and their salient features; Societal impacts; e-Governance challenges.

e-Business : Definition, Benefits to customers and business, e-Business websites and their salient features; Societal impacts; e-Business challenges.

e-Learning : Definition; Benefits to students (Learners), teachers (Trainers) and school (Institution) Management; e-Learning websites and their salient features Societal impacts; e-Business Challenges.

In each of the above domains, identify at least two real-life problems, list the input(s) required for the expected output(s), and describe the problem solving approach.

Class XI

Class XI (Practical)

S.No.	Description	Marks
1	Problem Solving using Java	12
2	SQL Queries	4
3	Practical Record •      Productivity Tools •      Simple Problems using Java •      SQL Queries •      IT Applications	8
4	Presentation on contributions by computer sciontists	2
5	Viva Voce	4

Evaluation of Practical Examination

1.      Problem solving using Java

Total                               30

Student is required to solve programming problems based on all concepts covered in theory throughout the year and maintain a record of these in the practical file. Student will be given a problem to be solved using Java during final practical examination to be conducted at the end of the academic session

2.      SQL Queries

Students will be trying out SQL queries in MySQL throughout the year along with course coverage in theory. Student will be asked to write 4 queries based on one or two tables during final practical examination to be conducted at the end of the academic session

3.      Practical Record File

A practical record file is required to be created during the entire academic session. It should be duly signed by the concerned teacher on regular basis and is to be produced at the time of Final Practical Examination for evaluation. It should include the following:

•        Print out of at least 2 documents with use of Different Style, Page Setting/Formatting, Bulleting/Numbering and Tabulation

•        Print out of at least 2 spreadsheets with simple calculations, basic functions, macros and graphs/charts

•        At least 10 solutions of simple problems using IDE based Java (refer to Appendix 'A'

& 'B')

•        At least 3 IT applications - problems solving framework

•        At least 20 SQL queries

4.      Presentation

Group of 3-4 students will prepare presentation (s) on Salient contributions by at least two computer scientists and their brief life sketch. (Refer to Appendix 'C')

5.      Viva Voce

Students will be asked oral questions during practical Examination to be conducted at the end of the course. The questions will be from the entire course covered in the academic session. Out of

6 marks, 2 marks are allotted to test student's understanding of basic computer hardware and their functions.