MI4311 Computer Skills-II Syllabus:

MI4311 Computer Skills-II Syllabus – Anna University PG Syllabus Regulation 2021

COURSE OBJECTIVES:

The course is designed to aim at imparting computer skills for data analysis, word processing and
presentations.

EXPERIMENTS:

Practicals on Spreadsheet
Exercise 1: Look up and Reference
 VLOOKUP
 HLOOKUP
 INDEX
 MATCH
 OFFSET
 TRANSPOSE
Exercise 2: Conditional statements
 If-else statement
 AND
 OR
 NOT
 TRUE
 Nested If-else
Exercise 3: Conditional formatting
 Conditional formatting with multiple cell rules
 Color scales and icon sets in conditional formatting
 New rules and managing existing rules
Practicals on Word Processors
Exercise 1: Tools for editing a document
 Auto-text
 Autocorrect
 Spelling & Grammar tool
 Document Dictionary
 Page formatting
 Bookmark
Exercise 2: Mail Merge
Exercise 3: Macros
Exercise 4: Styles
Exercise 5: Linking and embedding objects
Exercise 6: Templates
Practicals on Presentations
Exercise 1: Create a presentation with animation effects
Exercise 2: Create a looping introduction
Exercise 3: Loop a motion path animation
Exercise 4: Master slide
Exercise 5: Sound effects
Exercise 6: Videos
Exercise 7: Macros

COURSE OUTCOMES :

Upon completion of this course, students will
 Gain familiarity with advanced features in word processor, presentation and spreadsheet.
 Experience working with macros.
 Experience working with animations.

TOTAL: 60 PERIODS

REFERENCES:

1. Taxali R.K., PC Software for Windows made simple,2nd edition , McGrawHill Education,2001
2. Microsoft Excel 2016 Step by Step, Frye Curtis, PHI, 2016.
3. MS Office 2013, Vishnu P. Singh, Computech Publications, 2012.