CBSE Class 12 Syllabus for IT Application

CBSE syllabus for class 12 for IT Application has been declared. All students are kindly requested to download the copy of syllabus pattern and marking scheme published by CBSE. We at myCBSEguide have collected all the necessary information and providing you in brief and easy to understand format.

As it is one of the important and demanding subject from future point of view, students give more attention towards it. You are also recommended to read our article on IT Application for more information and idea. This subject is introduced by CBSE with motive of enhancement of Information technology in higher secondary level.

 

DATABASE MANAGEMENT APPLICATIONS

THEORY

Time: 2.5 Hours Marks: 50

Database Concepts – RDBMS Tool.

1.Basics of RDBMS.

2.SQL – Creating and Opening Database.

3.Creating and populating tables.

4.Modifying the content and structure of table.

5.Ordering and Grouping.

6.Operating with multiple tables.

Operating Web Based Applications.

1.Online Reservation Systems.

2.E-Governance.

3.Online Shopping and Bill payments.

4.Online Tutorials and Tests.

5.Project Management – Web Based Application development.

6.Project essentials and tips.

7.Case Study – Online Game.

8.Case Study – Online Quiz.

9.Case Study – Online Bill Calculator.

10.Fundamentals Java programming, Introduction to Java, Object

Oriented Programming, Java Language Elements, Operators, Control

Flow, Array, Class Design, Exception Handling, Assertions, Threads,

Wrapper Classes, String Manipulation.

 

Work Integrated Learning IT – DMA.

1.Identification of Work Areas.

2.Work Experience.

 

PRACTICAL

Time: 2.5 Hours Marks: 50

Programs / Practical Questions.

1.SQL Queries

2.JAVA Programs

3.Operating Web Based Application

4.Project / Practical File

5.Viva Voce 10

ELECTIVE

WEB APPLICATONS

THEORY

Time: 2.5 Hours Marks: 50

Movie Editing Tools.

Familiarization of interface components.

Importing pictures.

Importing Audio and Video Files.

Splitting and Joining Movie Clips.

Adding Titles and publishing.

Customizing and Embedding Multimedia components in Web Pages.

Compatible Multimedia file formats for Web Pages.

Embedding Audio file.

Embedding Video file.

Embedding Flash file.

Web Scripting – Java Script.

Java Script review.

Functions – user defined.

String Object.

Math Object.

Array Object.

Events.

Case Studies.

Work Integrated Learning IT – WA-II.

Advanced Features of Web Design.

Code view, Add-ins / Snippets and Page Transitions.

Dynamic Web templates.

SEO – Search Engine Optimization.

Forms – Advanced.

Publishing webpages or websites-I.

Publishing webpages or websites-II.

Authoring tools.

CSS templates.

 

PRACTICAL

Time: 2.5 Hours Marks: 50

Programs / Practical Questions.

1.Movie Editing Tools

2.Customizing and Embedding, Multimedia Components in Web Pages

3.Web Scripting – Java Script

4.Project / Practical File

5.Viva Voce

 

LIST OF RECOMMENDED BOOKS

1. Information Technology (IT) Student Handbook for level I, Published by CBSE .
2. IT Tools, Student Handbook, Level–III by CBSE.
3. Web Application–I, Student Handbook, Level–III by CBSE.
4. Database Management Application, Level–IV by CBSE.
5. Web Application–II, Student Handbook, Level–IV by CBSE.
6. Database Systems: Design, Implementation And Management by Peter Rob, Carlos Coronel.
7. Introduction to Information Technology by Efraim Turban (Author), R. Kelly Rainer (Author), Richard E. Potter (Author).
8. Introduction to Information Technology by ITL Education Solutions Limited.
9. JavaScript, A Beginner’s Guide by McGraw-Hill Osborne Media, 2009.
10. HTML and CSS: Design and Build Websites by Wiley (ISBN-10: 1118008189, ISBN-13:  978-1118008188), 2011.
11. The Book of GIMP: A Complete Guide to Nearly Everything by No Starch Press (ISBN-10: 1593273835, ISBN-13: 978-1593273835), 2013.
12. GIMP for absolute beginners by A press Publishers (ISBN-10: 1430231688, ISBN-13: 978-1430231684), 2013.
13. Microsoft Windows Movie Maker For Dummies by Keith Underdahl.
14. Getting Start ED with Windows Live Movie Maker by James Floyd Kelly.
15. Microsoft Windows Movie Maker 2 by Jan Ozer.
16. Microsoft Windows Movie Maker Handbook (Book & CD-ROM) by Bill Birney.
17. Filmmaking For Dummies by Bryan Michael Stoller.

LIST OF EQUIPMENTS/TOOLS

1.Hardware

a) Computers : 25

b) Printers : 2

2.Internet Connection

3.Software

(a) Microsoft Office / Open Office

(i) Word Processing

(ii) Spread Sheet

(iii) Digital Presentation

(iv) MS Access

(b) Internet Browser

(c) Java SDK

(d) Database Software

(e) Movie editing tools

4.UPS/ Power Backup

5.Storage Media (Pen Drive / CDs)