CLASS 12 COMPUTER APPLICATION THEORY
A. Basic Concepts: (5 Marks)
1. Simple Binary Arithmetic – Addition, Subtraction, Multiplication, Division
2. Different methods of Negative Number Representation
i) Signed Magnitude
ii) One’s Complement
iii)Two’s Complement
3. ASCII codes for character and text representation
B. Logic Functions: (5 Marks)
1. Simple combinational circuit design using gates and simple cases of minimization 2. Combinational Circuits (conversion is not necessary)
i) Half Adder & Full Adder (only definition and representation)
ii) Half Subtractor & Full Subtractor (only definition and representation)
iii) Multiplexer (4x1) and Demultiplexer (1x4)
iv) Decoder and Encoder (maximum 3 –bits)
C. Data Processing: (5 Marks)
1. File Organization: Serial, Sequential, Indexed Sequential
2. Record Structures
i) Fixed-length record
ii)Variable-length records
D. Computer Networking: (20 Marks)
1. Introduction to Networking
i) Utility of Networking (importance and application areas)
ii) Types of Network (LAN, MAN, WAN)
iii) Point-to-Point & Multipoint Communication and concept of client-server
iv) Network Topology (Bus, Ring, Star, Mess or Multipoint)
v) The OSI MODEL (Networking layers)
2. Concept of Internet and intranet
i) Dial-up and Leased line connections
ii) ISP and URL
iii)Services provided by Internet – WWW, Browser, E-mail
iv)Web page design using HTML
E. Database Concepts: (20 Marks)
1. Introduction to Database
i)Introduction & Goals, Purpose of using DBMS
ii)Disadvantages of File System and Advantages of DBMS
iii) Different Data Key: Super key, Candidate Key, Primary Key, Foreign Key
2. Introduction to Access
i) Table creation using Design View and Wizard
ii) Different data types in Access
iii)Manipulation of data using Access facilities-Inserting,Updating, Deleting data iv) Creating Relationships between Tables
v) Form creation using Design View and Wizard
vi) Query generation using Design View and Wizard
vii) Report generation using Design View and Wizard
F. Spreadsheet: (15 Marks)
1. Introduction to Excel
i) Concept of Workbook, Worksheet, Row, Column, Cell
ii) Creating, Opening, Editing, Saving a Workbook
iii) Changing Row and Column widths
iv) Formatting cells
v) Different data types in Excel
vi) Entering labels and values
vii) Use of formulas – SUM, PRODUCT, AVERAGE, MAX, MIN, ROUND, COUNT, COUNTIF, CONCATINATE, AND, OR, NOT, RAND, SQRT, TDEVA
viii) Copying Cells – Relative and Absolute referencing
ix) Making calculations and re-calculations
x) Conditional Formatting
xi) Sorting and Filtering Data
xii) Hiding Rows and Columns
xiii) Use of Macros
xiv) Creating Line Diagrams, Pie Charts, Bar Graphs
1. Simple Binary Arithmetic – Addition, Subtraction, Multiplication, Division
2. Different methods of Negative Number Representation
i) Signed Magnitude
ii) One’s Complement
iii)Two’s Complement
3. ASCII codes for character and text representation
B. Logic Functions: (5 Marks)
1. Simple combinational circuit design using gates and simple cases of minimization 2. Combinational Circuits (conversion is not necessary)
i) Half Adder & Full Adder (only definition and representation)
ii) Half Subtractor & Full Subtractor (only definition and representation)
iii) Multiplexer (4x1) and Demultiplexer (1x4)
iv) Decoder and Encoder (maximum 3 –bits)
C. Data Processing: (5 Marks)
1. File Organization: Serial, Sequential, Indexed Sequential
2. Record Structures
i) Fixed-length record
ii)Variable-length records
D. Computer Networking: (20 Marks)
1. Introduction to Networking
i) Utility of Networking (importance and application areas)
ii) Types of Network (LAN, MAN, WAN)
iii) Point-to-Point & Multipoint Communication and concept of client-server
iv) Network Topology (Bus, Ring, Star, Mess or Multipoint)
v) The OSI MODEL (Networking layers)
2. Concept of Internet and intranet
i) Dial-up and Leased line connections
ii) ISP and URL
iii)Services provided by Internet – WWW, Browser, E-mail
iv)Web page design using HTML
E. Database Concepts: (20 Marks)
1. Introduction to Database
i)Introduction & Goals, Purpose of using DBMS
ii)Disadvantages of File System and Advantages of DBMS
iii) Different Data Key: Super key, Candidate Key, Primary Key, Foreign Key
2. Introduction to Access
i) Table creation using Design View and Wizard
ii) Different data types in Access
iii)Manipulation of data using Access facilities-Inserting,Updating, Deleting data iv) Creating Relationships between Tables
v) Form creation using Design View and Wizard
vi) Query generation using Design View and Wizard
vii) Report generation using Design View and Wizard
F. Spreadsheet: (15 Marks)
1. Introduction to Excel
i) Concept of Workbook, Worksheet, Row, Column, Cell
ii) Creating, Opening, Editing, Saving a Workbook
iii) Changing Row and Column widths
iv) Formatting cells
v) Different data types in Excel
vi) Entering labels and values
vii) Use of formulas – SUM, PRODUCT, AVERAGE, MAX, MIN, ROUND, COUNT, COUNTIF, CONCATINATE, AND, OR, NOT, RAND, SQRT, TDEVA
viii) Copying Cells – Relative and Absolute referencing
ix) Making calculations and re-calculations
x) Conditional Formatting
xi) Sorting and Filtering Data
xii) Hiding Rows and Columns
xiii) Use of Macros
xiv) Creating Line Diagrams, Pie Charts, Bar Graphs
CLASS 12 COMPUTER APPLICATION PRACTICAL
A. Project Work: (10 Marks)
• Study of Systems related to School, Town, Village, Local Industries, People
Using Access creation of Database and populating Tables, Data Manipulation, Report Generation
OR
Using Excel creation of Mark Sheet, Balance Sheet, Monthly/Yearly Expenditure, Reports
• Webpage design and implementation
Note: On the day of the practical examination, students have to demonstrate on the project work submitted by them.
B. Practical Examination: (10 Marks)
Study of email – email send/receive, use of search engine, collecting information from web
Using MS-Access and MS-Excel
Creating a Web Page
C. Sessional: Laboratory Notebook (5 Marks)
D. Viva Voce: (5 Marks)
• Study of Systems related to School, Town, Village, Local Industries, People
Using Access creation of Database and populating Tables, Data Manipulation, Report Generation
OR
Using Excel creation of Mark Sheet, Balance Sheet, Monthly/Yearly Expenditure, Reports
• Webpage design and implementation
Note: On the day of the practical examination, students have to demonstrate on the project work submitted by them.
B. Practical Examination: (10 Marks)
Study of email – email send/receive, use of search engine, collecting information from web
Using MS-Access and MS-Excel
Creating a Web Page
C. Sessional: Laboratory Notebook (5 Marks)
D. Viva Voce: (5 Marks)
