Microsoft Office

COMPUTER FUNDAMENTAL:

• Introduction of Monitor, Keyboard, Mouse & CPU.

• Introduction of Operating System & Application Software

• Introduction of Desktop, Icon, Task Bar, & Start Button.

• How to create a folder?

• Turn on the pc, Identifying File-Folder-Drive

• Search for an existing file, Find location of a file

• How to Open a MS Word File?

• The Interface of MS Word

• Document,

• Title Bar,

• Office Button/File,

• Tab Menu & Ribbon,

• Minimize Button, Maximize Button & Close Button

• Introduction the activities of the buttons of a keyboard

• How to start typing in the Keyboard?

Page Layout Tab

• Orientation

• Margins

• Size

• Columns

• Selection Techniques

• Mouse and keyboard

• How to select a word, sentence & all select

• What does drag /drop mean?

• File Tab

• How to Save/Save as a File?

• How to Create a New Document?

• How to Open a Saved File?

• How to Create a Password for a File?

• Formatting Text

• Apply font styles

• How to Increase & Decrease the Font Size?

• Bold, Italic & Underline

• Change Font color

• Highlight text color

• How to Used Bulleting text & numbering text?

• Clipboard Command

• Copy & Paste

• Cut & paste

• Moving and Copying Text Using the Mouse

• Delete

• Undo & Redo

Review Previous Class

Paragraph Group

Alignment:

• Left, Right, Center & Justify

• Changing Line Spacing, Changing Spacing Between Paragraphs

• Using Left and Right Indents

• Adding borders, Page Border and shading.

• Add watermark to the document

Review Tab

• Check spelling and grammar in word file

• Adding Thesaurus to Word file

• View word file details with word count

• Protect Document

View Tab

• Learn about print layout

• Why is Ruler used? How to hide and show Ruler?

• Give knowledge about Zoom, One Page, Two Page, and Page Width

Review Previous Class

• Find / replace

• Blank page / Page Break

• Tables

• Creating tables

• working with table content

• Changing table structure

• Add a picture to the document

• Drawing with Shapes in the document

• How to present a topic in Smartly by

• SmartArt?

• Using Headers and Footers, Page numbers

• Save from Word file to .Pdf file

Review Previous Class

• Insert Hyperlink

• Insert screenshot

• Format

• Edit

• Text Box

• Date and Time

• Equation

• Symbol

Mailings Tab

• The mail merge List

Review Previous Class

• Curriculum Vitae/Resume

Review Previous Class

• Bangla Typing

Review Previous Class

• Bangla Typing

Review Previous Class

MICROSOFT EXCEL

• Navigate the Excel User Interface

• How many Rows & Columns in a Worksheet?

• ( 10,48,576 & 16,384 )

• The Cell, cell address, active cell, cell pointer, Moving around the worksheet, To Move the Cell Pointer:

• Enter Cell Data

• Introduction to Autofill? How can we use it by showing examples?

• About Formulas (+, -, /, *, =)

• Excel requires every formula to begin with an equal sign (=).

• How can we calculate Addition, Subtraction, Multiplication, Division, Average Value, Percentage, Count Numbers, and Maximum Minimum Value?

To Edit Information in a Cell

• Direct Cell Editing.

Review Previous Class

• Cash Memo & Balance Sheet

• Cells formatting

Review Previous Class

• Salary Sheet

Review Previous Class

• Apply Basic Conditional Formatting

• Create and Modify Tables

Working with Lists

• Sort Data

• Filter Data

• Data validation

Visualizing Data with Charts

• Create Charts

• Modify and Format Charts

Review Previous Class

Printing Workbooks

• Preview and Print a Workbook

• Set Up the Page Layout

Review Previous Class

Printing Workbooks

• Preview and Print a Workbook

• Set Up the Page Layout

Excel project

Review Previous Class

How to get started with PowerPoint

• Introduction of MS PowerPoint & Interface.

• View a Presentation

• Create and Save a PowerPoint Presentation

• Select a Presentation Type

Advanced Text Editing Operations

• Format Characters

• Format Paragraphs

• Format Text Boxes

Adding Graphical Elements

• Insert Images

• Insert Shapes

Review Previous Class

• How can I add Background?

• How can I show the slides without clicking or automatically?

• Apply Transitions

• How to create a Text Animation?

• Animation Speed

• Print Your Presentation

• Deliver Your Presentation

Review Previous Class

Printing Workbooks

• Preview and Print a Workbook

• Set Up the Page Layout

Review Previous Class

MS Access

• What is Access & Why we used it?

• How to Create a Database?

• Give knowledge about “Report” & “Form” Options?

• Which ways we are used to Show a Database?

• Create an “Employee” or “Student” Database.