COMPUTER    FUNDAMENTAL

 Introduction to computer parts:

•  Hardware
•  Software 

Introduction to hardware parts:

•  Monitor 
• Keyboard 
• Mouse 
• CPU 

Introduction:

• Operating System & Application Software 
•  Desktop Icon, Task Bar, & Start Button.
• Introduction the activities of the buttons of a keyboard How to start typing in the Keyboard?  

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 

                                 Review Previous Class

 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?

                                Review Previous Class

 Fonts Group :

• Formatting Text 
• Apply font styles 
• How to Increase & Decrease the Font Size? 
• 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 

• How to move a Text in Right, Left, and Center & Justified of a Page?
•  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:

1.  Format 
2. 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
• About Formulas(+,-,*,/,=)
• Excel requires every  formula to begin with 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.
• Formula bar Editing

                              Review Previous Class

• Cash Memo & Balance Sheet
• Cells formatting

                               Review Previous Class

• Salary Sheet

                                 Review Previous Class

• Result 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
• Advance Formula ( Vlookup, Pivot Table, Sumif, Countif)

                                 Review Previous Class

• Excel Project

                                Review Previous Class

                                            PowerPoint

How to get started with PowerPoint:

• Introduction of MS 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

• MS PowerPoint Project-1                          

                                   Review Previous Class

• MS PowerPoint Project-2

                           Review Previous Class

                                                         MS Access(Part-1)

• What is Access & Why we used it?
• How to create a Database?
• Give knowledge about “Report” & “Form” option?
• Which ways we are used to show a Database?
• Create an “Employee” or “Student” Database

                                  Review Previous Class

                                                                MS Access(Part-2)

• What is Query? Why we used it?
• How can find out a specific data from a Database using “Query”Option?

                                 Review Previous Class

• Control Panel

                              Review Previous Class

• Paint
• Data Entry 
• Pen Drive Use
• Multimedia

                             Review Previous Class

• Internet Browsing
•  Picture Download 
• Software Download

                             Review Previous Class

• Email Create & Using
•  Google Drive Access
•  How to Download from YouTube?

                          Review Previous Class

• Problem Solution of Full Course.

                        Review Previous Class

• Windows & PC Setup