MI4211 Computer Skills – I Syllabus:

MI4211 Computer Skills – I Syllabus – Anna University PG Syllabus Regulation 2021

COURSE OBJECTIVE:

The course is designed to aim at imparting a basic computer skills for Word Processing, Presentations and Spreadsheets

EXPERIMENTS:

PRACTICALS ON SPREADSHEET

Exercise 1: Getting Started
 creating network sheet
 selecting cells, navigating with mouse and keyboard
 entering, editing text and checking spelling
 saving the worksheet
 open the existing worksheet
 moving cells, copying cells, sorting cell data, referencing cells
 inserting columns, inserting rows and inserting cells
 filtering cell data
 deleting parts of a worksheet
Exercise 2: Spreadsheet Formatting
 page setup
 changing column widths and row
 auto format, manual formatting
 conditional formatting
 usage of format painter
 changing font sizes and attributes
 adjusting alignments, centering text across columns
 changing colors and shading
 inserting and removing page breaks
 hiding rows and columns
 protecting and un protecting documents and cells
Exercise 3: Functions
 parts of a function
 basic functions – sum, average, percentage
 Rank & Percentile
 Group & Ungroup
 Subtotal
 Random Number Generation
 entering and editing functions
 order of evaluation in functions
 error messages from functions
Exercise 4: Charts & Graphics
 creating charts using chart wizard
 creating charts on separate worksheets
 resizing and moving charts, editing chart
 controlling which series on which axis
 creating trend lines
 creating and placing graphic objects
 resizing graphics
Exercise 5: Pivot Table & Pivot Charts
 creating pivot table
 editing the different parts of pivot table
 creating pivot chart
 creating and placing pivot chart
Exercise 6: Creating Daily and Monthly Sales Reports
Exercise 7: Creating Cash Flow Statement
Exercise 8: Creating Balance Sheet
Practicals on Word Processors
Exercise 1: Getting Started
 creating newdocument
 typing text, selecting text, deleting text and checking spelling
 inserting text, replacing text, formatting text
 open the existing document
 cut, copy, paste
 saving and printing document
Exercise 2: Formatting Text and Documents
 Auto format
 line and paragraph spacing
 Margins, Borders and Shading
 definition of headers and footers
 creating basic headers and footers
 creating different headers and footers for odd and even pages
 Creating hyperlinks
Exercise 3: Tables & Graphics
 creating a simple table
 creating a table using the table menu
 entering and editing text in a table
 selecting in table
 adding rows, changing row heights and deleting rows
 inserting columns, changing column width and deleting columns
 importing graphics and
 inserting picture
Exercise 4: Creating Resume
Exercise 5: Creating Blog
Exercise 6: Creating Business Letters
Exercise 7: Creating Product Brochure
Exercise 8: Creating Project Report
Practicals on Presentations:
Exercise 1: Getting Started
 Creating Presentations : Using blank presentation option
 Creating Presentations :Using template option
 Adding Slides, Deleting a slide, Numbering a Slide
 Saving and Printing Presentation
Exercise 2: Graphics & Visual Effects
 Importing the images into presentation
 Building Transition Effects
Exercise 3: Creating Company Profile Presentation
Exercise 4: Creating Product Presentation
Exercise 5: Creating Project Presentation
Practicals on Internet and Services
Exercise 1: WWW and Web Browser
 Connecting to World Wide Web (WWW)
 Popular Web Browsers – Google Chrome, Internet Explorer, Mozilla Firefox
 Popular Search Engines (google/bing)/ Search for content
 Accessing Web Browser
 Using Favorites Folder
 Downloading Web Pages
 Printing Web Pages
 Understanding URL
 Surfing the web
Exercise 2: Email
 Basics of E-mail
 What is an Electronic Mail
 Email Addressing
 Using E-mails
 Opening Email account
 Mailbox: Inbox and Outbox
 Creating and Sending a newE-mail
 Replying to an E-mail message
 Forwarding an E-mail message
 Sorting and Searching emails

TOTAL: 60 PERIODS

OUTCOMES:

Upon completion of this course, students will
 Gain familiarity to word processor, presentation and spreadsheet
 Experience working with email and recognize email netiquette

TEXT BOOKS:

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