Department Events
Office Management Lab
The course will enable the students to
- Make student familiar with general purpose office automation tools.
- Enable the student in crafting professional word document, spread sheet and power point presentation using the office automation software’s.
- Become proficient in using spreadsheet applications, presentation graphics applications and database applications.
Course Learning Outcomes (CLOs):
Learning Outcome (at course level) Students will be able to: | Learning and teaching strategies | Assessment Strategies |
| Approach in teaching: Interactive Lectures, Tutorials, Demonstration, Practical Quiz, Team teaching
Learning activities for the students: Self-learning assignments, Effective questions, giving tasks, Field practical, Error Solving Quiz
|
|
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.
