OFFICE MANAGEMENT LAB

Paper Code: 
MCA 128
Credits: 
2
Periods/week: 
04
Max. Marks: 
100.00
Objective: 
  • To make students familiar with general purpose office automation tools.
  • To enable the students in crafting professional word documents, spread sheets and power point presentations using the office automation software’s.
  • To become proficient in using spreadsheet applications, presentation graphics applications and database applications.

 

Word-processing: Overview of  office automation software’s,  Details of the three tasks and features that would be covered using word processor – Accessing, overview of toolbars, saving files, Using help and resources, rulers, format painter.

 

Using Word processor to create project certificate: Formatting Fonts in word processor, Drop Cap, Applying Text effects, Using Character Spacing, Borders and Colors, Inserting Header and Footer, Using Date and Time option in Word Processor.

 

Creating project abstract: Formatting Styles, Inserting table, Bullets and Numbering, Changing Text Direction, Cell alignment, Footnote, Hyperlink, Symbols, Spell Check, Track Changes.

 

Creating a Newsletter: Table of Content, Newspaper columns, Images from files and clipart, Drawing toolbar and Word Art, Formatting Images, Textboxes, Paragraphs and Mail Merge in word processor.

 

Spreadsheets: Spreadsheet tools, give the details of the two tasks and features that would be covered using spreadsheet tools – Accessing, overview of toolbars, saving spreadsheet files, Using help and resources.

 

Creating a Scheduler: Gridlines, Format Cells, Summation, auto fill, Formatting Text.

 

Calculating GPA: Cell Referencing, Formulae in spreadsheet – average, std. deviation, Charts, Renaming and Inserting worksheets, Hyper linking, Count function, HLOOKUP/VLOOKUP, Sorting, Conditional formatting, Pivot Tables.

 

Electronic Presentation: Slide Layouts, Inserting Text, Word Art, Formatting Text, Bullets and Numbering, Auto Shapes, Lines and Arrows, Hyperlinks, Inserting –Images, Clip Art, Audio, Video, Objects, Tables, Charts, Master Layouts (slide, template, and notes), Types of views (basic, presentation, slide slotter, notes etc.), Inserting – Background, textures, Design Templates, Hidden slides.

 

Academic Year: