IP Year Plan - Std XII - Google Drive


1	Indira National School
2	Year Plan for Std.
3	Informatics Practices XII
4	Months / Days	Working Days	Lesson No & Name	Practicals
5	March	5	L-13: MySQL Revision Tour	Writing SQL queries on single table.
6
7	April	24	L-10:HTML-I: Basic HTML Elements L-11:HTML-II: Lists, Tables & Forms	Design webpages using HTML tags
8	April	24	L-3: Java GUI Programming Revision Tour-I L-4:Java GUI Programming Revision Tour-II	Design Java GUI applicaion using various Swing controls such as Radio button, checkbox, List, combobox etc.
9
10	June		L-4 Java GUI Programming Revision Tour-II ontinued..	More examples using Swing controls
11
12
13		16	L-8: Database Connectivity to MySQL	Design database connectivity applications connecting to MySQL from Java. Retrieving data based on user-specified criteria.
14
15	July	25	L-8: Database Connectivity to MySQL continued	Design database connectivity applications connecting to MySQL from Java & Performing Insert/Update/Delete queries
16			L-1: Computer Networking	No Practicals
17			L-14:Database Transactions	Write sql script to understand database transacton
18
19	August	24	L-15: More on SQL - Grouping Records & Table Joins	Write SQL queries using grouping(aggregate) functions. Write SQL queries to extract data from more than one table.
20			L-16:Tables & Integrity Constraints	Write SQL queries for creating tables with constraints, Adding / removing constraint using ALTER TABLE command
21			L-12: XML	No Practicals
22
23	September	20	L-5: Java GUI Programming Revision Tour -III(Classes & Objects)	Write Java programs invoking methods
24			L-6: More about Classes & Libraries	Write Java programs using String & Math methods
25			L-7: Concept of Inheritance	Write Java programs using the concept of Inheritance
26
27		10	L-9 Web Application Development	No Practicals
28	October	10	L-2: Open Source Concepts	No Practicals
29
30	November	23	L-17:IT Applications, Revision	No Practicals
31	November	23	Practical File Completion & Submission
32
33	December	18	Project work Completion & Submission
34	December	18	Revision / Prelims
35
36	January	24	Revision
37
38	February	20	Board Practical Exam
39
40	March	22	Board Theory Exam


1	IP Portion for Assessment
2
3	Assessments	Lesson No. & Name
4
5	PT1	L-3: Java GUI Programming Revision Tour-I
6		L-4:Java GUI Programming Revision Tour-II
7		L-10:HTML-I: Basic HTML Elements
8		L-11:HTML-II: Lists, Tables & Forms
9		L-13: MySQL Revision Tour
10
11	PT2	L-3: Java GUI Programming Revision Tour-I
12		L-4:Java GUI Programming Revision Tour-II
13		L-13: MySQL Revision Tour
14		L-1: Computer Networking
15		L-10:HTML-I: Basic HTML Elements
16		L-11:HTML-II: Lists, Tables & Forms
17
18	Mid Term Exam	L-3: Java GUI Programming Revision Tour-I
19		L-4:Java GUI Programming Revision Tour-II
20		L-10:HTML-I: Basic HTML Elements
21		L-11:HTML-II: Lists, Tables & Forms
22		L-13: MySQL Revision Tour
23		L-14:Database Transactions
24		L-1: Computer Networking
25		L-15: More on SQL - Grouping Records & Table Joins
26		L-16:Tables & Integrity Constraints
27		L-12: XML
28		L-5: Java GUI Programming Revision Tour -III(Classes & Objects)
29
30
31	Prelim 1	Entire Syllabus
32		L-3: Java GUI Programming Revision Tour-I
33		L-10:HTML-I: Basic HTML Elements
34		L-11:HTML-II: Lists, Tables & Forms
35		L-13: MySQL Revision Tour
36		L-4:Java GUI Programming Revision Tour-II
37		L-8: Database Connectivity to MySQL
38		L-14:Database Transactions
39		L-1: Computer Networking
40		L-15: More on SQL - Grouping Records & Table Joins
41		L-16:Tables & Integrity Constraints
42		L-12: XML
43		L-5: Java GUI Programming Revision Tour -III(Classes & Objects)
44		L-6: More about Classes & Libraries
45		L-7: Concept of Inheritance
46		L-9 Web Application Development
47		L-2: Open Source Concepts
48		L-17:IT Applications