CBSE syllabus for class 11 informatics practices 2014 -2015
INFORMATICS PRACTICES
Learning Objectives:
• To gain working knowledge of a computersystem 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 systemorganization (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, Biometricsensor, web camera;
Output Devices: Monitor/Visual DisplayUnit (VDU), LCD screen, Television,Printer (Dot Matrix
Printer, Desk jet/ Inkjet/ Bubble jet Printer, LaserPrinter), Plotter, Speaker.
Primery Memory : Cache, RAM &ROM
Secondary Storage Devices:Floppy Disk,Hard Disk, CompactDisk, Magnetic Tape, Digital
Versatile Disk (DVD),Flash Pen Drive, Memory cards; Comparative properties of storage media;
Memory Units: Bit (BinaryDigit)/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) Operatingsystems: Need for operating system, major functions of Operating System. (ii) Language Processors : Assembler, Interpreter and Compiler.
(b) UtilitySoftware: 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).
• DevelopingGeneral Application - GettingFamiliar with Java User Interface Swing components - Frame, Option Pane, Label, Text Field, PasswordField, 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 SolvingMethodology : 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 DatabaseConcepts
Introduction to databaseconcepts: Data base, Relational Database, Relation/Table, attribute/field, Tuple / Rows;
Data Types: Number, Character and Date
Keys: Key, PrimaryKey, Candidatekey, Alternatekey, Foreignkey;
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, Insertingnew 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, OperatorPrecedence.
• ORDERBY Clause: Sorting in Ascending/Descending Order, Sortingusing 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 XIClassXI (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
Studentis required to solve programming problems based on all concepts covered in theory throughout the year and maintain a recordof 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 academicsession
2. SQL Queries
Studentswill 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 concernedteacher on regular basis and is to be produced at the time of Final PracticalExamination 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 - problemssolving framework
• At least 20 SQL queries
4. Presentation
Group of 3-4 studentswill prepare presentation (s) on Salientcontributions by at least two computer scientists and their brief life sketch. (Refer to Appendix 'C')
5. Viva Voce
Students will be asked oral questionsduring 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 allottedto test student's understanding of basic computer hardware and theirfunctions.
No comments:
Post a Comment