INFORMATION TECHNOLOGY FOR OFFICE

Admin bar avatar
Priyanka Presannan
BCom Computer Application SF
₹1,000.00
  • 49 students
  • 0 lessons
  • 0 quizzes
  • 10 week duration
49 students

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.

  • Lesson I

    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

    No items in this section
  • Lesson 2

    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.

    No items in this section
  • Lesson 3

    Introduction to Desktop Publishing: PageMaker 7.0 - Introduction to Desktop Publishing as a Process- PageMaker Tools and Palettes- Working With Objects -Type Styling Options

    No items in this section
  • Lesson 4

    Desktop Publishing: Working With Text - Formatting Options-Leading, Margins and Indents - Scaling Text-Paragraph Formatting Options -Working With Grids - Creating Frames - Layers.

    No items in this section
  • Lesson 5

    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

    No items in this section
  • Lesson 6

    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

    No items in this section
  • Lesson 7

    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

    No items in this section
  • Lesson 8

    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.

    No items in this section
  • Lesson 9

    Introduction to Presentation Package: Ms-Power Point 2013-Advantages of Presentation- Screen Layout- Creating Presentation- Inserting Slides-Adding Sounds and Videos-Formatting Slides

    No items in this section
  • Lesson 10

    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

    No items in this section

0.00 average based on 0 ratings

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%
₹1,000.00