Computer + IT Specialist for Office Work Course Module

Class – 1:
Introduction
Importance and Applications of Computer & IT Education
Basic Concept of Computer (Theoretical)
[Define Computer, Generation/History, Classifications, Elements, Memory, etc. etc.]
Basic Knowledge of Operation System
[Windows 7, Windows 10, Linux, Others]

Class – 2:
Typing
English
Bangla
Use of typing master application

Class – 3:
Typing
Other Languages
Internet
Introduction
Application
Browsing

Class – 4:
Search engines
Various Websites browsing & Sign up/Sign in
Gmail, Yahoo Mail, MS Outlook, Facebook, YouTube, Twitter, Bdjobs, Others

Class – 5:
Software (Various Software Setup & Use of some important Utility Software)

Class – 6:
Microsoft Excel (part 1)
What is Excel?
Types of Object in Excel.
Understand rows and columns in Excel
Ribbon, Quick Access Toolbar and Status Bar
Different types of TABS in Excel
Layout/References

Class – 7:
Microsoft Excel (part 2)
File Tab [Info, New, Open, Save as, Share, Account, Option]
Home Tab [Clipboard, Font, Alignment, Number, Styles, Cells, Editing]

Class – 8:
Microsoft Excel (part 3)
Insert Tab [Tables, Charts, Sparkline/Illustrations, Filters, Links, Tex]
Pivot Table
Power Query
Chart
Page Layout Tab

Class – 9:
Microsoft Excel (part 4)
Formulas Tab
Basic Function (Average, AverageA, Sum, AutoSum, Sumif, Sumifs, Count, Countif, Countifs)

Class – 10:
Microsoft Excel (part 5)
Use of Logical Function (IF) Function

Class – 11:
Microsoft Excel (part 6)
VLOOKUP
HLOOKUP
Define Table
Get External Data
Connections
Sort & Filter
Data Tools

Class – 12:
Microsoft Excel (part 7)
Text Function
Date & Time Function
Lookup Function
Reference Function
Financial Function
Math Function
Statistical Function

Class – 13:
Microsoft Excel (part 8)
Engineering Function
Information Function
Compatibility Function
Review Tab (Comments, Changes)
View Tab (Workbook View, Show, Window)

Class – 14:
Microsoft Excel (part 9)
Excel Macro
Clear (All, Format, Comments, Hyperlink, Content, Insert, Delete, Color)
Review Excel Related Classes

Class – 15:
Microsoft Word (part 1)
File options
Clipboard/format painter
Font Options
Paragraph Formatting
Find/replace/go to/editing
Header & footer
Insert page number

Class – 16:
Microsoft Word (part 2)
Link
Table
Chart
Auto Text/Fields
Date& Time
Equation & Symbol
Page Background
Page Setup/Margin
Column
Tab Setting

Class – 17:
Microsoft Word (part 3)
Use Watermarks
Page Layout
Indent & Spacing
Macro
Drop Cap
Text Box Word
Art Hyperlink

Class – 18:
Microsoft PowerPoint (part 1)
Introduction
Developing a PowerPoint presentation
Table
Graph
Importing and Exporting
Working with Objects
Templates and Masters

Class – 19:
Microsoft PowerPoint (part 2)
Transitions and Animation
Interactive Slide shows
Multimedia Automation
Setting up a Slide Show

Class – 20:
Microsoft Access (part 1)
Introduction
Table Data/Records
Primary Key
Foreign Key
Data Type

Class – 21:
Microsoft Access (part 2)
Query
Forms
Creating report
Review MS Access & problem solution

Class – 22:
Adobe Photoshop
Introduction
Document window
Working with selections
Color modes
Tools

Class – 23:
Adobe Photoshop
Photo Editing
Layer Style and Filter effects
Printing in Photoshop

Class – 24:
Adobe Illustrator
Introduction
Page setup
Color
Tools
Objects
Working with text
Working with shapes
Saving and Exporting

Class – 25:
Adobe Illustrator
Live Project (Basic)

Class – 26:
Full Course Review and solution
Freelancing Marketplace
Freelancing Class : Fiverr
Freelancing Class : Upwork.com
Freelancing Class :freelancer.com
Freelancing Class : Peopleperhour
Freelancing Class : Themeforest
Marketplace Payment Solutions Class : Payoneer