CBSE Class 12 Informatics Practices Syllabus 2013 2014

Class XII (Theory)

UNIT 1: NETWORKING AND OPEN STANDARDS

Computer Networking:

• Networking : a brief overview.

• Communication Media: Wired Technologies - Co-Axial, Ethernet Cable, Optical Fiber, Wireless Technologies - Blue Tooth, Infrared, Microwave, Radio Link, Satelite Link.

• Network Devices : Hub, Switch, Repeater, Gateway and their functions

• Types of Network: LAN, MAN, WAN, PAN

• Network Topologies: Star, Bus, Tree

• Network Protocols: HTTP, TCP/IP, PPP

• Identifying computers and users over a network: Basic concept of domain name, MAC (Media Access Control), and IP Addres, domain name resolution.

• Networking Security: denial of service, intrusion problems, snooping.

Open Source Concepts:

• Open Source Software (OSS), comon FOSS/FLOSS examples (e.g. Gnu/Linux, Firefox, OpenOffice, Java, netbeans, MySQL), common open standards (WWW, HTML, XML, ODF, IP, TCP).

• Indian Language Computing: Character encoding, UNICODE, different types of fonts (open type vs true type, static vs dynamic), Entering Indian Language Text - Phonetic and key map based.

UNIT 2: PROGRAMMING

Review of Class XI;

Programming Fundamentals

(Refer to Appendix A for sample guidelines of GUI Programming, and Appendix B for Swing Control Methods & Properties)

Basic concept of Access specifier for classes, Members and methods Basic concept of Inheritance.

Commonly used libraries: String class and methods: toString(), concat(), length(), toLowerCase(), toUpperCase(), trim(), substring()

Math class methods: pow(), round()

Accessing MySQL database using ODBC/JDBC to connect with database.

Web application development: URL, Web Server, Communicating with the web server, concept of Client and Server Side.

HTML based web pages covering basic tags - HTML, TITLE, BODY, H1..H6, Paragraph (P), Line Break (BR), Section Separator (HR), FONT, TABLE, LIST (UL, OL), FORM;

Creating and accessing static pages using HTML and introduction to XML

UNIT 3: RELATIONAL DATABASE MANAGEMENT SYSTEM

Review of RDBMS from Class XI

Database Fundamentals

Concept of Database Transaction, Committing and revoking a Transaction using COMMIT and REVOKE,

Grouping Records: GROUP BY, Group functions - MAX(), MIN(), AVG(), SUM(), COUNT();

using COUNT(*), DISTINCT clause with COUNT, Group Functions and Null Values,

Displaying Data From Multiple Tables: Cartesian product, Union, concept of Foreign Key, Equi- Join

Creating a Table with PRIMARY KEY and NOT NULL constraints, Viewing Constraints, Viewing the Columns Associated with Constraints using DESC Command;

ALTER TABLE for deleting a column, ALTER TABLE for modifying data types of a column For adding a constraint enabling constraints, dropping constraints, DROP Table for deleting a table;

UNIT 4: IT APPLICATIONS

Front-end Interface - Introduction; content and features; identifying and using appropriate component (Text Box, Radio Button, CheckBox, List etc. as learnt in Unit-2 (Programming) for data entry, validation and display;

Back-end Database - Introduction and its purpose; exploring the requirement of tables and its essential attributes;

Front-End and Database Connectivity - Introduction, requirement and benefits Demonstration and development of appropriate Front-end interface and Back-end Database for e- Governance, e-Business and e-Learning applications

Impact of ICT on Society : Social and Economics benefits and Infomania.

 

Please refer to attached file for CBSE Class 12 Informatics Practices Syllabus 2013-2014

Tags: 

 


Click to View or Download pdf file
Click for more Informatics Practices Study Material

Latest NCERT & CBSE News

Read the latest news and announcements from NCERT and CBSE below. Important updates relating to your studies which will help you to keep yourself updated with latest happenings in school level education. Keep yourself updated with all latest news and also read articles from teachers which will help you to improve your studies, increase motivation level and promote faster learning

Board Exams Class 10 and Class 12 Datesheet 2020

CBSE has announced the datesheet for the remaining exams of class 10 and class 12 exams. The exams are going to start in July. The class 10 and 12th board exams will be conducted for the remaining 29 papers from July 1 to July 15, 2020, at various centers nominated by...

CBSE Boards Answer Sheet Evaluation Class 10 and Class 12

HRD Minister Ramesh Pokhriyal, through a video conference with all the education ministers of the state, discussed the further steps to be taken to smoothen the education process during the Covid-19 lockdown. The most important topic which was discussed repeatedly on...

CBSE Recommends Arogya Setu App

Written recommendation from CBSE to school principals for initiating the Arogya Setu App! The Central Board of Secondary Education has advised to all school principals through a written communication recommending the “Arogya Setu App” and Health Ministry's protocol for...

CBSE Recommends Arogya Setu App, Writes To School Principals

Written recommendation from CBSE to school principals for initiating the Arogya Setu App! New Delhi:  The Central Board of Secondary Education has advised all school principals through a written communication recommending the “Arogya Setu App” and Health Ministry's...

Class 10 and Class 12 Board Exams to be resumed only for Main Subjects

The CBSE Board Exams have been postponed twice this year! New Delhi: The Education Ministry has urged the Central Board of Secondary Education (CBSE) to reinstitute the board exams only for the main subjects. As per the official statement the Board will not conduct...

CBSE Board Exams in July Press Release

CBSE has released press note for the dates for the CBSE Board exams for Class 10. CBSE said “With regards to conduct of Class X examinations several queries are being received by the CBSE. In this context, it is once again reiterated that remaining examinations of...

×
Studies Today