Different data types in Excel

Entering labels and values

Use of formulas – SUM, PRODUCT, AVERAGE, MAX, MIN, ROUND, COUNT, COUNTIF, CONCATINATE, AND, OR, NOT, RAND, SQRT, TDEVA

Copying Cells – Relative and Absolute referencing

Making calculations and re-calculations

Conditional Formatting

Sorting and Filtering Data

Hiding Rows and Columns

Use of Macros

Creating Line Diagrams, Pie Charts, Bar Graphs

Web page design using HTML

Variable-length records

Record Structures i) Fixed-length record

File Organization: Serial, Sequential, Indexed Sequential

Decoder and Encoder

Multiplexer (4x1) and Demultiplexer (1x4)

Half Subtractor & Full Subtractor

Half Adder & Full Adder

Simple combinational circuit design using gates and simple cases of minimization

ASCII codes for character and text representation