ANY 12 of the following should be completed and recorded.

Separate observation and record should be maintained.

NOTE : (i) Concerned Staff In charge of the Lab should evaluate and marks be recorded for observation and record separately, on day-to-day basis for evaluation of sessional marks at the end of the semester.

(a) Create, save and print documents using Microsoft Word.
(b) Copy, cut and paste text in documents.

Type special characters and symbols in documents.

(a) Carry spell check in a document.
(b) Set margins and indentation in a document.

Change font settings.

(a) Format paragraphs and introducing multiple columns in a document.
(b) Create a table, adding new rows, columns; merging rows, columns.

Include header and footer; mail merge feature of Microsoft Word.

(a) Insert graphic objects, auto shapes in a document.
(b) Insert page breaks, page numbers, bookmarks in a document.

Protect a document from unauthorized usage.

(a) Create, save and print spreadsheets using Microsoft Excel.
(b) Insert cells, rows, columns into a spreadsheet.

Change column width and row heights in a spreadsheet.

(a) Enter and edit using formulae in a spreadsheet.
(b) Create, copy, move multiple worksheets.

(a) Use functions in a spreadsheet.
(b) Write macros to perform repeated tasks in a spreadsheet.

Get external data from an ODBC data source using Microsoft query.

(a) Create and edit charts in a spreadsheet.
(b) Create and place graphic objects in a spreadsheet.

(a) Create and save an Microsoft Access database.
(b) Create a table; add, delete and rename fields in a table.

Create primary key for a table.

(a) Change data types of a table field.
(b) Impose input masks on the fields of a table.

Enter, edit and delete data in a table.

(a) Create and edit queries to view data in one or more tables.
(b) Write macros to perform repeated tasks in a database.

(a) Create linked tables from another database.
(b) Set password for a database to prevent unauthorized entry.

(a) Export data from the database into the form of delimited text files.
(b) Create a database replica.