15. INFORMATICS PRACTICES (Code 065)
• 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.
• 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.
Unit Topic Period Marks
Theory Practical Theory Practical
1. INTRODUCTION TO COMPUTER SYSTEMS 15 05 10 02
2. INTRODUCTION TO PROGRAMMING 40 35 25 16
3. RELATIONAL DATABASE MANAGEMENT SYSTEM 40 35 30 6
4. IT APPLICATIONS 5 15 5 6
100 90 70 30
UNIT 1: INTRODUCTION TO COMPUTER SYSTEMS
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)
Data Types: Concept of data types; Built-in data types: byte, short, int, long, float, double, char,
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
Decision Structures: if, if-else, switch;
Looping Structures: while, do-while, for;
Problem Solving Methodology : Understanding of the problem, Identifying minimum number of inputs
required for output, breaking down problem into simple logical steps.
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
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 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 (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
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
• At least 10 solutions of simple problems using IDE based Java (refer to Appendix ‘A’
• At least 3 IT applications – problems solving framework
• At least 20 SQL queries
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
15. INFORMATICS PRACTICES (Code 065)