- 49 students
- 0 lessons
- 0 quizzes
- 10 week duration
This course is designed to provide students with a working knowledge of computer concepts and essential skills necessary for work and communication in today’s society. Students work with an integrated office software suite called Microsoft Office. Students will learn intermediate Word Processing (Word), Presentation (PowerPoint), and Spreadsheet (Excel) skills. Students are also introduced to desktop publishing (Publisher).
Learning Objective: The objective of this course is to make the students capable of managing the office activities with the help of information technology
Program Specific Outcomes:
On completion of the course, the students are expected to;
(a) Exhibit improved understanding operate ms-office operations
(b) Have learning skills & knowledge to work on simple projects laid on text and numerical data
(c) Gain practical exposure on spread sheet
(d) Have practical skill on Power Point presentation
(e) Gain practical knowledge on Word Processing and Desktop Publishing also.
Word Processing Package: MS-Word 2013- Introduction-Features- Word User Interface Elements-Creating New Documents- Basic Editing- Saving a Document- Printing a Document- Print Preview-Page Orientation- Viewing Documents- Setting Tabs-Page Margins- Indents- Ruler- Formatting Techniques- Font Formatting- Paragraph Formatting- Page Setup- Headers &Footers-Bullets and Numbered List
Word Processing Package: Borders and Shading- Find and Replace-Page Break Page Numbers-Mail Merging-Spelling and Grammar Checking- Thesaurus- Macros- Tables- Side-By-Side and Nested Tables- Formatting Tables- Drawing- Word art- Paint Brush Document Templates – Email Editor.
Introduction to Desktop Publishing: PageMaker 7.0 - Introduction to Desktop Publishing as a Process- PageMaker Tools and Palettes- Working With Objects -Type Styling Options
Desktop Publishing: Working With Text - Formatting Options-Leading, Margins and Indents - Scaling Text-Paragraph Formatting Options -Working With Grids - Creating Frames - Layers.
Introduction to Spreadsheet Package: MS -Excel 2013-Introduction-Excel User Interface- Working With Cell and Cell Addresses- Selecting a Range, Moving, Cutting, Copying With Paste-Inserting and Deleting Cells- Freezing Cells- Adding, Deleting and Copying Worksheet Within a Workbook- Renaming a Worksheet-Cell Formatting Options- Formatting Fonts- Aligning-Wrapping and Rotating Text
Spreadsheet Package: Using Borders- Boxes and Colors- Centering a Heading, Changing Row/Column Height / Width-Formatting a Worksheet Automatically- Insert Comments- Clear Contents in a Cell- Using Print Preview- Preparing Worksheet forthe Printer- Selecting Print Area-Margin and Orientation- Centering a Worksheet- Using Header and Footer- Inserting Page Breaks- Sorting Data
Introduction to Advanced Features of Excel: All Functions in Excel- Using Logical Functions-Statistical Functions-Mathematical Functions - Linking Data between Worksheet- Elements of Excel Charts-Categories- Create a Chart- Choosing Chart Type
Advanced Features of Excel: Edit Chart Axis - Titles, Labels, Data Series and Legend- Adding a Text Box- Rotate Text in a Chart- Converting a Chart on a Web Page- Saving a Chart- Designing of Templates in Excel.
Introduction to Presentation Package: Ms-Power Point 2013-Advantages of Presentation- Screen Layout- Creating Presentation- Inserting Slides-Adding Sounds and Videos-Formatting Slides
Presentation Package: Slide Layout Views in Presentation - Colour Scheme- Background Action Buttons- Slide Transition- Custom Animation- Creating Master Slides- Managing Slide Shows - Using Pen Setting Slide Intervals