K2Questions Logo
6th Standard 7th Standard 8th Standard 9th Standard 10th Standard 11th Standard 12th Standard

Study 11th STANDARD - Informatic Practices

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.
Displaying table data: SELECT command for Selecting all the Columns, Selecting Specific Column, Using Arithmetic Operators, Operator Precedence, Defining and using column Alias, Eliminating duplicate values from display (DISTINCT Keyword), Limiting Rows during selection (using WHERE clause), Working with Character Strings and Dates, Working with NULL values.
• Using Comparison Operators - =, <, >, <=, >=, <>, BETWEEN, IN, LIKE (%,_), Logical Operators - AND, OR, NOT, Operator Precedence.
• 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 a column.
Functions in MySQL:
String Function - 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 and societal impacts; e-Governance challenges.
e-Business - Definition, Benefits to customers and business, e-Business websites and their salient features and 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 and societal impacts; e-Business Challenges. In each of the above domains, identify at least two real-life problems, list the inpt(s) required for the expected outpt(s), and describe the problem solving approach.



11th Standard Subjects


Accountancy sociology Agriculture
Biology Biotechnology Business-Studies
Chemistry Computer-Science Economics
Engineering-Graphics English Entrepreneurship
Geography History Home-Science
Informatic-Practices Mathematics Multimedia-and-web-technology
Philosophy Physics Political-Science
Psychology



About us | SiteMap | Terms of use | Privacy Policy | Disclaimer | Contact us | ©2010 K2Questions.com

Page Description: Informatic Practices 11th Grade subject, Informatic Practices 11th standard, Informatic Practices exam, Informatic Practices examination question, Informatic Practices 11th standard videos, Informatic Practices 11th standard Sample question paper, Informatic Practices Eleventh standard Syllabus cirricullam,Informatic Practices 11th Grade course structure, pratical syllabus exam questions, 11th standard Informatic Practices Articles, 11th Informatic Practices download books, free questions video question paper, free articles, Eleventh standard Informatic Practices, XI th grade Informatic Practices, important Informatic Practices questions 11th grade