Microsoft Office

DIT 1st Semester Course Outline 

Microsoft Office

(Version 2007 and onward)

(PAPER-I)

Total Th Hrs    40                                                                       Total Pr Hrs     80

Total Th Mks  75                                                                       Total Pr. Mks   25

Introduction and Installation of Microsoft Office 

A- WORD PROCESSING

 MS-Word, Word processing, Manual and Electronic Word processing

 1. Screen Layouts

  • Menus
  • Shortcut
  • Toolbars
  • Customization of Toolbars
  • Title Bar, Status Bar, Scroll
  • Bars  and Rulers.

 2. Working with files

  • Create, Open, Save, Rename and Close a document
  • Working on  Multiple Documents.
  • Cut, Copy, Paste, Special Undo and Redo Operations
  • Find Replace and go to Commands
  • Text, Paragraph and Page Formatting
  • Header and Footer
  • Date and Time
  • Bullets and Numbering
  • Columns and Drop Caps
  • Tabs and Margins
  • Comments and Foot Notes
  • Insert a picture and its Formatting
  • Use of Spelling and Grammar Check , Auto Correct Synonyms Theasurus.
  • Page Break Section Break and Background Printing
  • Table of contents Glossary,
  • Hyperlink and Bookmark
  • Insert a Table, Add and
  • Delete Columns Rows and
  • Cells
  • Merge and Split Cells
  • Formula Implementations

3.                  Document Printing

  • Selection of a printer
  • Printing Setting
  • Print Preview
  • Print and Page Setup
  • Shortcut Keys

B- MS- EXCEL

  • Basic Terminology of Ms- Excel
  • Creating Opening Renaming Saving and Closing Workbook/ Spread Sheet
  • Editing Functions: Undo, Redo. Fill, Auto Fill, Delete, Cut, Copy, Paste, Clear, Find and Replace
  • Inserting: Header & Footer Cells Rows / Columns and Worksheet
  • Working with Formulas: Entering Formula with the help of Formula Bar Entering Formula.
  • Directly into the cells, sue of Arithmetic and Logical Formulas.
  • Use of Built- in functions Time and Date Concatenation, Sum if, Nested Max, Min. Average, Count, Now, Month, Day, Year Upper , Lower, Left & Right. Ultimate IF Functions.
  • Tools and Date: Spell Check, Auto Correction, Workbook protection Data Sorting and filtering
  • Formatting Cells and Text, Borders and Shading, Positioning Cells and Text, Auto Format,
  • Categories, of numbers, Cell / Range Referencing, Alignment, Date & Time Working With Charts, Creating Editing and Formatting of various types of Charts
  • Printing: Selecting Printer, Print selected areas page selection
  • Sorter View.

C- POWER POINT

1. Define Power Point

2. PRESENTAION.

  • Power point presentation environment
  • View icon of Power Point
  • Start Power Point, Open a Presentation

3. Creating a new presentation using

  • MS- Power point by
  • Creating By Design Template
  • Creating By Blank Presentation
  • What is slide?

4. Choose an Auto Layout, Using Auto Layout

5. Editing and Formatting a Text Box

6. Choose a Common Text Tool in the Formatting Tool Bar

7. Apply design Template

8. Set Background & Layout of Slides

9. Adding Pictures and Graphics in a slide

10. Apply Custom Animation

      Apply present animation

11. Apply Action Setting

12. Adding Sound to an Animation

13. Add Sound and Music effects to the presentation

14. Set view Options

  • Normal View
  • Outline View
  • Slide View
  • Sorter View
  • Notes Page View
  • Slide Show
  • Slides Show Off
  • Important Short cut keys

D-MS. Access(Version 2007 and onward)

 1. DATABASE CONCEPTS

                   What is data and Database?

1.1      Why use Electronic Database?

1.2      Tables and Relationships

1.3      One to One

1.4      One to Many

1.5      Many to many

1.3    Database Features

1.3.1  Attributes, Character Fielded

Record, Tuples Files

1.3.2        Key, Primary Key

Foreign Key, Composite Key

1.3.3   Referential Integrity

1.3.4   Use of Wild Cards

1.4    MS- Access (Database)

Ms-Access Use Access, Window

       Title Bar, Control Menu, Toolbar

       Status Bar

       Database Window

       Object button

       Data types

       Start Access

       Creating table, Table view

1.4.1   Create Table using in

Design View

Setting Primary Key, Saving table

Close, exit add, delete record filed

Resizing row column

Freezing Hiding Column, Finding Data

Repl data, Auto content, Spell checking

Create Tales using in Wizard

1.4.2   Create relationship between Tables

1.4.3   Create Queries, define query, use adv

Types of query

Creating simple query

Executing data

Join, Difference between relations and join

Extracting data

Use of query wizard

1.4.4   Create Forms, What is form

Types of form

Create form by wizard

Create form of Design View

Add new record through form

Edit record through form

Editing option

List Box, Combo Box

Adding list Box and Combo Box

Cheek Box and option button

Command Button

1.4.5  Create Reports

What is report?

Use of Report, Standard types report

Auto report

Saving and closing auto report

Create single table report

Create two table report

Create Report in design view

Print a report

 1.4.6  Database Security


Comments

Post a Comment