Tuesday, April 21, 2020
Different methods of Negative Number Representation
i) Signed Magnitude
ii) One’s Complement
iii)Two’s Complement
ii) One’s Complement
iii)Two’s Complement
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
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)
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 GenerationCLICK
OR
Using Excel creation of Mark Sheet, Balance Sheet, Monthly/Yearly Expenditure, Reports CLICK
• Webpage design and implementation CLICK
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 CLICK
Using MS-Access and MS-Excel CLICK-ACCESS CLICK-EXCEL
Creating a Web Page CLICK
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 GenerationCLICK
OR
Using Excel creation of Mark Sheet, Balance Sheet, Monthly/Yearly Expenditure, Reports CLICK
• Webpage design and implementation CLICK
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 CLICK
Using MS-Access and MS-Excel CLICK-ACCESS CLICK-EXCEL
Creating a Web Page CLICK
C. Sessional: Laboratory Notebook (5 Marks)
D. Viva Voce: (5 Marks)
CLASS 12 COMPUTER APPLICATION THEORY
1. Simple Binary Arithmetic – Addition, Subtraction, Multiplication, Division - CLICK
2. Different methods of Negative Number Representation - CLICK HERE
i) Signed Magnitude
ii) One’s Complement
iii)Two’s Complement
3. ASCII codes for character and text representation CLICK
B. Logic Functions: (5 Marks)
1. Simple combinational circuit design using gates and simple cases of minimization - CLICK
2. Combinational Circuits (conversion is not necessary)
i) Half Adder & Full Adder (only definition and representation) CLICK
ii) Half Subtractor & Full Subtractor (only definition and representation) CLICK
iii) Multiplexer (4x1) and Demultiplexer (1x4) CLICK
iv) Decoder and Encoder (maximum 3 –bits) CLICK
C. Data Processing: (5 Marks)
1. File Organization: Serial, Sequential, Indexed Sequential CLICK
2. Record Structures
i) Fixed-length record CLICK
ii)Variable-length records CLICK
D. Computer Networking: (20 Marks)
1. Introduction to Networking
i) Utility of Networking (importance and application areas) CLICK
ii) Types of Network (LAN, MAN, WAN) CLICK
iii) Point-to-Point & Multipoint Communication and concept of client-serverCLICK
iv) Network Topology (Bus, Ring, Star, Mess or Multipoint) CLICK
v) The OSI MODEL (Networking layers) CLICK
2. Concept of Internet and intranet
i) Dial-up and Leased line connections CLICK
ii) ISP and URL CLICK
iii)Services provided by Internet – WWW, Browser, E-mail CLICK
iv)Web page design using HTML CLICK
E. Database Concepts: (20 Marks)
1. Introduction to Database
i)Introduction & Goals, Purpose of using DBMS CLICK
ii)Disadvantages of File System and Advantages of DBMS CLICK
iii) Different Data Key: Super key, Candidate Key, Primary Key, Foreign KeyCLICK
2. Introduction to Access
i) Table creation using Design View and Wizard CLICK
ii) Different data types in Access CLICK
iii)Manipulation of data using Access facilities-Inserting,Updating, DeletingdataCLICK iv) Creating Relationships between Tables CLICK
v) Form creation using Design View and Wizard CLICK
vi) Query generation using Design View and Wizard CLICK
vii) Report generation using Design View and Wizard CLICK
F. Spreadsheet: (15 Marks)
1. Introduction to Excel
i) Concept of Workbook, Worksheet, Row, Column, Cell CLICK
ii) Creating, Opening, Editing, Saving a Workbook CLICK
iii) Changing Row and Column widths CLICK
iv) Formatting cells click
v) Different data types in Excel CLICK
vi) Entering labels and values CLICK
vii) Use of formulas – SUM, PRODUCT, AVERAGE, MAX, MIN, ROUND, COUNT, COUNTIF, CONCATINATE, AND, OR, NOT, RAND, SQRT, TDEVA CLICK
viii)Copying Cells – Relative and Absolute referencing CLICK
ix) Making calculations and re-calculations CLICK
x) Conditional Formatting CLICK
xi) Sorting and Filtering Data CLICK
xii) Hiding Rows and Columns CLICK
xiii) Use of Macros CLICK
xiv) Creating Line Diagrams, Pie Charts, Bar Graphs CLICK
WEST BENGAL STATE UNIVERSITY SEMESTER 6 COMPUTER SCIENCE HONOURS SYLLABUS
WEST BENGAL STATE UNIVERSITY SEMESTER 6 COMPUTER SCIENCE HONOURS SYLLABUS
CORE :
| HONOURS | PAPER CODE | PAPER TITLE | CREDIT | LINK |
| THEORY | CMSACOR13T: | Artificial Intelligence | 4 | CLICK |
| THEORY | CMSACOR13P: | Artificial Intelligence | 2 | CLICK |
| PRACTICAL | CMSACOR14T: | Computer Graphics | 4 | CLICK |
| THEORY | CMSACOR14P: | Computer Graphics | 2 | CLICK |
DSE : ANY TWO
| HONOURS | PAPER CODE | PAPER TITLE | CREDIT | LINK |
| THEORY | CMSADSE04T: | Big Data | 4 | CLICK |
| PRACTICAL | CMSADSE04P: | Big Data | 2 | LINK |
| THEORY | CMSADSE02T: | Digital Image Processing | 4 | CLICK |
| PRACTICAL | CMSADSE02P: | Digital Image Processing | 2 | CLICK |
| THEORY | CMSADSE06P: | Project | 6 | LINK |
Subscribe to:
Posts (Atom)