CBSE (Arts) Class 11CBSE
Share
Notifications

View all notifications

Informatics Practices Class 11 CBSE (Arts) CBSE Topics and Syllabus

Login
Create free account


      Forgot password?
Academic year:

Topics with syllabus and resources

100.00 Introduction to Computer Systems
101.00 Hardware Concepts

• Computer organization (basic concepts): CPU, Memory (RAM and ROM), 1/0 devices, communication bus, ports (serial, parallel), device specific ports;
• Input devices: Keyboard, Mouse, Light pen, Touch Screen, Graphics Tablet, 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, Byte (Kilobyte, Megabyte, Gigabyte, Terabyte, Petabyte)
• Encoding scheme :ASCll,ISCll & UNICODE
• E-waste disposal.

Security of computer system: Sources of attack and possible damages, malware - virus, worms, spyware and cookies as security threat, malware detection using a tool. Computer security, digital certificate, digital signature, firewall, password, file access permissions

102.00 Types of Software

(a) System Software:
(i) Operating systems: Need for operating system, major functions of Operating System; Examples of OS for mainframe, PC/Server, and mobile devices.

(jj) Language Processors: Assembler, Interpreter, and Compiler
(b) Utility Software: Compression tools, disk defragmenter, anti-virus
(c) Application Software:
(j) General Purpose Application Software: Word Processor, Presentation Tool, Spreadsheet Package, Database Management System, Integrated Development Environment (IDE)
(ii) Specific Purpose Application Software: Inventory .Management System, Purchasing System, Human Resource Management System, Payroll System, Financial Accounting, Hotel Management and Reservation System etc.

200.00 Introduction to Programming
201.00 Getting Started with Programming Using Ide

• Introduction, Rapid Application Development using IDE (Integrated Development Environment) such as Netbeans; Familiarization of IDE using basic Interface components- Label, Text Field, Text Area, Button, Checkbox, Radio Button. (As per appendix A)
• Developing General Application (As per the guidelines at appendix B) - Getting Familiar with Java Swing User Interface components-Frame, Dialog, OptionPane, Panel, ScrollPane, Label, TextField, PasswordField, TextArea, Button, CheckBox, RadioButton, ComboBox, List
• Basic component handling methods and properties: setText(), getText(), isSelected(), setSelected()

202.00 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: parselnt
• Double object method: parseDouble, parseFloat
• Control Structures:
Decision Structure - if, if-else, switch;
Looping Structure- while, do. . while, for;

203.00 Programming Guidelines

• General Concepts; Modular approach;
• Stylistic Guidelines: Clarity and simplicity of expressions and 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.

300.00 Relational Database Management System
301.00 Database Management System

• Introduction to database concepts: Database, Relational database, Relation/Table, Attribute/Field, Tuple I Row;
• Data Types: Text (CHAR, VARCHAR), Number (DECIMAL, INT/INTEGER), Date and Time

• Keys: Candidate key, Primary key, Alternate key, Foreign key;
• Examples of common Database Management System: MySQL, Ingres, Postgres, Oracle, DB2, MS SQL, Sybase etc.; Common Database management tools for mobile devices.

302.00 Introduction to MySQL

• Classification of SQL Commands:
DML - SELECT, INSERT, UPDATE, DELETE
DDL-CREATE,DROP,ALTER
• Creating and using a database: 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 and values of all the studied data types.
• Displaying table data: SELECT command for selecting all the columns, selecting specific column(s), use of arithmetic operators.
• Defining and using column alias
• Eliminating duplicate values from display using DISTINCT keyword
• Limiting rows during selection (using WHERE clause)
> Using Comparison operators - =, <, >, <=, >=, <>, BETWEEN, IN, LIKE(%,_);
> Logical Operators -AND, OR, NOT and corresponding operator precedence;
• Working with NULL values.
• ORDER BY clause: Sorting in Ascending/Descending order, sorting by column alias name, 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), deleting column (s) and modifying column structre

303.00 Functions in MySQL

• String Functions: ASCII(), CHAR(), CONCAT(), INSTR(), LCASE(), UCASE(), LEFT(), LOWER(), LENGTH(), LTRIM(), MID(), RIGHT(), RTRIM(), SUBSTR(), TRIM(), UPPER().
• Mathematical Functions: - POWER(), ROUND(), TRUNCATE().
• Date and Time Functions: CURDATE(), DATE(), MONTH(), YEAR(), DAYNAME(), DAYOFMONTH(), DAYOFWEEK(), DAYOFYEAR(), NOW(), SYSDATE(

400.00 IT Applications

• e-Governance: Definition, benefits to citizens, e-Governance websites and their salient features and societal impacts; e-Governance challenges.
• e-Business: Definition, benefits to customers and business, e-Business websites and their salient features and societal impacts; netbanking, mobile banking e-Business challenges.
• e-Learning: - Definition, benefits to students (learners), teachers (trainers) and school (Institution) management; MOOCs (Massive Open Online Courses) ; e-Learning websites and their salient features and societal impacts; e-Learning 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.
Impact of ICT on society- social, environmental and economic benefits, lnfomania.

BooksVIEW ALL [1]

S
View in app×