UNIVERSITY OF MADRAS
B.Sc. DEGREE COURSE IN Nautical Science
SEMESTER SYSTEM WITH CREDITS
(Effective from the Academic Year 2003-2004)

SYLLABUS

Semester IV - Allied IV - Computer Programming

Duration of Examination: 3 hrs
Maximum Marks: 100
Credits: 4

1. COMPUTER FUNDAMENTALS

Historical development of computers an evolution, Classification of Computers on different norms such as generations, technology. etc. Different functional parts of a computer and their functions. Computer peripherals: Monitor. Printer. Key board, Floppy disk drive, Floppy, Hard disk, Mouse. Computer arithmetic: Binary, Octal, Decimal & Hexadecimal number systems and mutual conversion: Addition. 1's & 2's complementation in binary only. Units of memory measurement: Bits. Bytes. KB. MB. GB. TB. Unit of run-time measurement: sec, ms, μs, ns, ps, fs, as. Different computer environments: Batch processing, time sharing, Interactive & Network, their functional details and difference. Computer connectivity: LAN, MAN, WAN, Internet. Internet activity in india and various facilities available on Internet, Sateilte based Communication.

2. DOS / WINDOWS 95 / WINDOWS 98:

Role and Function of D/S. MS-DOS- (DISKETTE OPERATING SYSTEM) What is Ms-Dos. DOS Internal / External comrnnds. Wild cards/pipes/redirections. Graphic user interphase. Windows 95. Features of WINDOWS 95. Control panel and display properties. Mouse, Icons and selection. Accessories. DOS prompt and My briefcase, Desktop. Settings control panel, Explorer. Find utility. Overview of Networking options.

3. MS - OFFICE:

Introduction to OFFICE concept. Role of MS-OFFICE in Office productivity.

4. MS WORD (WORD PROCESSOR) :

Starting MS-WORD. Creating of documents. Menus and functions. Mouse operations / keyboard operations. Designing Document. Typing text. Formatting features. Block operations. Tool bars. Saving and printing. Creating a document / template. Creating Tables. Insert columns / rows. Formatting text (Fonts/justification), inserting and aligning pictures. Inserting spreads sheets / graphs. Saving and printing. Creating documents based on template. Mail merge. Concept of mail merge. Creating data source. Creating document. Merging and printing of mails.

5. EXCEL (SPREAD SHEET):

Introduction to Excel. Navigating selecting cells. Entering and editing numbers / text / formulae / date / formatting rows / columns. Excel standard, format, drawing tool bars, series fill. Copying / pasting values / formulae. Insert / delete rows / columns. Renaming worksheets. Copying data between worksheets. Auto fit selection. Creating a chart. Saving / opening / closing a file.

FUNCTIONS:
ROUND ( ) SORT ( ) AVERAGE ( ) MAX ( ) MIN ( ) COUNT ( ) SUM ( ) IF ( ) ABS ( ) ROMAN ( ) UPPER ( ) LOWER ( ) CELL ( ) TODAY ( ) NOW ( ).

6. ACCESS:

7. POWER POINT:

Role of presentation. Working with power point. Parts of power point windows. Power point standard / formatting / drawing / drawing + / auto shapes tool bars. Text formatting. Insert clipart / picture. Manipulation of clipart / picture inserting new slide. Creating and manipulating animations. Organisation chart. Table. Design template. Master slide. Colour bax. Saving the presentation. Auto content wizard template.

8. INTERNET:

Internet - Getting connected. Introduction to network. Important features of internet. Introduction to protocols. Setting up internet connection. Configuring TCP / IP connection. Netscape Navigator / Internet Explorer. Logging in to internet service provider. Concept of E-mails, creating accounts sending / receiving / replaying the e-mails attachments surfing and download of data.

PRACTICALS

MS-WORD:

* Usage of Bullets and Numbering.

* Header and Footer

* Usage of Spell check and Grammar

* Find and Replace

* Symbol, Picture insertion and Alignment

* Mail Merge

* Text Manipulation

* Text and document formatting.

MS-EXCEL:

* Pivot table

* Multiplication table

* Subtotal

* Functions - Date, Mathematical & trigonometry, Text Logical and Statistical

* Chart.

MS - POWERPOINT:

* Auto content wizard

* Selecting and editing text

* Creating and Saving presentation and slide

* Working with text

* Formatting text

* Printing and Running slide shows.

REFERENCE:

(1) Turbo C reference manual.

(2) Programming in C: Kris A Jamsa : Galgotia Publications Pvt. Ltd.

(3) Mastering turbo C: Kelly / Bootle : BPB

(4) Turbo C Programming techniques : Stevena a. : BPB

(5) Computer Virus - prevention, detection & removal Kaput R : BPB

(6) Introduction to computer science Vol. I & II: Jam S. BPB

(7) Introducing computers I, II & III : Mehta S. : BPB