XI-IP Syllabus

SYLLABUS
XI -INFORMATICS PRACTICES (Code 065)

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 Database Creation and querying using ANSI SQL.
• To design, program and develop database driven web applications using GUI Programming
Tool and RDBMS.
• To understand and appreciate open source and open standard concepts

Competencies:
• Sound knowledge of computer system
• Familiarity with Application Development process using simple IDEs
• Ability to use, develop & debug programs independently.
• Ability to use ANSI SQL for storing and retrieving data from the RDBMS.
• Ability to develop a Web Application using Front end and Back end tools.

Unit	Unit Name	Period		Marks
		Theory	Practical	Theory	Practical
1	INTRODUCTION TO COMPUTER SYSTEMS	20	-	10	-
2	INTRODUCTION TO PROGRAMMING	40	40	25	16
3	RELATIONAL DATABASE MANAGEMENT SYSTEM	45	40	30	9
4	IT APPLICATIONS	5	20	5	5
		110	100	70	30

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, network, phone);
Input devices: Keyboard, Mouse, Light pen, Touch Screens, 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), USB Drive, Memory cards - Comparative properties

Software Concepts:
Operating systems, Need for operating system, major functions of Operating System, Memory
Management;

Security of system:
sources of attack and possible damages, virus and related entities - worms,
propagation of these entities, virus detection using a tool, Desktop security, Digital certificates, Digital
signature, cookies, firewall, password, file access permissions.
Types of Software: System Software, Utility Software, Application Software and Developer Tools
System Software:
General Purpose Application Software: Word Processor, Presentation Tool, Spreadsheet Package,
Database Management System;
Specific Purpose Application software (for example: Inventory Management System, Purchasing System,
Human Resource Management System, Payroll System, Financial Accounting, Hotel Management
and Reservation System, etc.);
Developer Tools: Compilers and Interpreters, Integrated Development Environment

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;
Basic component handling methods/attributes
Programming Fundamentals
Data Types: Concept of data types; Built-in data types - byte, short, int, long, float, double, char,
String (or any object), Boolean; Concept of a Class and Instance as user-defined datatypes.
Variables:
Need to use variable, Declaring Variables, Variable Naming Convention, Assigning value to Variables;

Control Structures:
Assignment Statement
Decision Structure - if, if-else, switch;
Looping Structure- while, do-while, for;
Concept of a Method: structure, local variables, return values, types of parameter passing
Concept of a Class ( simple class only): members, methods, using classes as data types
Programming Guidelines:
Choice of Expressions and Names, , Comments, use of Indentation; Documentation and Program
Maintenance; Debugging programs: Syntax Errors, Run-Time Errors, Logical Errors;
Problem Solving Methodology and Techniques: Understanding of the problem, Identifying relevant
information, top-down development approach

UNIT 3: RELATIONAL DATABASE MANAGEMENT SYSTEM

Database Management System
Introduction to database concepts: Relation/Table, attribute/fields, Tuple / Rows;
Data Types - Number, Character and Date
Key - Primary Key, Candidate key, Alternate key;

Introduction to MySQL
(ANSI SQL 99 standard commands)
Classification of SQL Statements:
DML - SELECT, INSERT, UPDATE, DELETE;
DDL - CREATE, DROP, ALTER;
SQL SELECT Statement (working with demo/already existing tables): SELECT statement, Selecting
All the Columns, Selecting Specific Column, Using Arithmetic Operators, Operator Precedence, Defining
and using Column Alias, Duplicate rows and their Elimination (DISTINCT keyword), Displaying Table
Structure (DESC command); SELECT Statement Continued: 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;

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().
Manipulating Data of a Table/Relation: Inserting New Rows, Inserting New Rows with Null Values,
Inserting NUMBER, CHAR and DATE Values, Update Statement to Change Existing Data of a
Table, Updating Rows in A Table, Delete statement - removing row/rows from a Table;
Creating Table using CREATE TABLE, ALTER TABLE for adding a new column, using naming
conventions for column names;

UNIT 4: IT APLICATIONS

• e - Governance - Definition, e-Governance websites; their salient features and societal impacts
• e - Business - Definition, e-Business websites, their salient features and societal impacts
• e - Learning - Definition; Benefits to students (Learners), Teachers (Trainers) and School
(Institution) Management; e-Learning websites and their salient features and societal impacts