WBCHSE CLASS XII ( CLASS 12 ) COMPUTER APPLICATION SYLLABUS

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

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)