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
No comments:
Post a Comment