Introduction to Computer and Other ICTs Hardware, Software and Firmware
-
Introduction to computer
-
Classification of different types of computer
-
Application of different types of computer
-
Basic components of a computer
-
Windows OS
-
Hardware and Troubleshooting
-
Basic use of computer
-
Turn on the pc, Identifying File-Folder-Drive, Open a new file
-
Search for an existing file, Find location of a file, Change location of files
-
Change file installing a new hardware, Antivirus and Computer Security
-
Daily Uses of digital Applications
Microsoft Word
-
Creating a New Document, Inserting and Deleting Text, Saving a Document
-
Opening a Document, Selecting and, Replacing Text, Using Undo, Redo and Repeat
-
Navigating through a Document, Viewing a Document, Working with the Document Window, Viewing Multiple Document Windows
-
Previewing and Printing a Document, Closing a Document Working with and Editing Text
-
Checking Spelling and Grammar, Using Find and Replace
-
Using Word Count and the Thesaurus, Inserting Symbols and Special Characters
-
Cutting, Copying, and Pasting Text, Using the Office Clipboard
-
Moving and Copying Text Using the Mouse
-
Formatting Characters and Paragraphs
-
Changing Font Type, Changing Font Size
-
Changing Font Color and Highlighting Text
-
Changing Font Styles and Effects, Creating Lists, Changing Paragraph Alignment
-
Adding Paragraph Borders and Shading
-
Changing Line Spacing, Changing Spacing Between Paragraphs
-
Using the Format Painter, Setting Tab Stops, Adjusting and Removing Tab Stops
-
Using Left and Right Indents
-
Using Hanging and First Line Indents
Formatting the Page
-
Adjusting Margins, Changing Page Orientation and Size
-
Using Columns ,Using Page Breaks, Working, with Section Breaks, Working with Line Numbers
-
Working with Hyphenation, Working with the Page Background, Adding a Cover Page and Page Numbers
-
Using Headers and Footers, Mail merge etc.
Microsoft Excel
-
Creating a New Workbook
-
Navigating in Excel, Moving the Cell Pointer ,Using Excel Menus
-
Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars
-
Entering Values in a Worksheet and Selecting a Cell Range
-
Previewing and Printing a Workshee, Getting Help from the Office Assistant
-
Saving a Workbook & Re-opening a saved workbook etc
Formatting a Worksheet
-
Creating Headers, Footers, and Page Numbers
-
Adjusting Page Margins and Orientation
-
Adding Print Titles and Gridlines, rows to repeat at top of each page
-
Formatting Fonts & Values, Adjusting Row Height and Column Width
-
Changing Cell Alignment , Adding Borders
-
Applying Colors and Patterns, Using the Format Painter , Using AutoFormat
-
Merging Cells, Rotating Text, and using AutoFit , Using AutoFill
Managing your workbooks
-
Switching Between Sheets in a Workbook
-
Inserting and Deleting Worksheets, Renaming and Moving Worksheets
-
Protecting a Workbook, Hiding Columns, Rows and Sheets
-
Splitting and Freezing a Window, Inserting Page Breaks ,
-
Advanced Printing Options
Editing a Workbook
-
Entering Date Values and using AutoComplete
-
Editing, Clearing, and Replacing Cell Contents
-
Cutting, Copying, and Pasting Cells, Moving and Copying Cells with Drag and Drop ,Collecting and Pasting Multiple Items , Using the Paste Special Command
-
Inserting and Deleting Cells, Rows, and Columns
-
Using Undo, Redo, and Repeat ,Checking Your Spelling
-
Finding and Replacing Information, Inserting Cell Comments
-
Creating a basic Formula , Calculating Value Totals with AutoSum, Editing & Copying Formulas, Fixing Errors in Your Formulas, Formulas with Several Operators and Cell Ranges
Working with the Forms Menu
-
Sorting, Subtotaling & Filtering Data, Copy & Paste Filtered Record, Using Data Validation
Creating & Working with Charts
-
Creating a Chart , Moving and Resizing a Chart , Formatting and Editing Objects in a Chart , Changing a Chart's Source Data
-
Changing a Chart Type and Working with Pie Charts , Adding Titles, Gridlines, and a Data Table ,Formatting a Data Series and Chart Axis
-
Annotating a Chart, Working with 3-D Charts
-
Selecting and Saving a Custom Chart , Using Fill Effects , Mapping Data, Modifying a Map
-
Data Analysis & Pivot Tables
-
Creating a PivotTable , Specifying the Data a PivotTable Analyzes
-
Changing a PivotTable's Calculation , Selecting What Appears in a PivotTable
-
Grouping Dates in a PivotTable , Updating a PivotTable
-
Formatting and Charting a PivotTable
Microsoft PowerPoint
-
Create a basic presentation and define its building blocks
-
Work with text, themes, and styles., Work with charts, graphs, and tables.
-
Work with smart art, shapes and objects., Work with media clips and animation etc
Linux & Open office
-
Linux installation and Basic operation of Linux
-
Basic command uses of Linux, Software Installation, Uses of Open Office
Internet & Email
-
Introducing the Internet ,Introduction to Internet Explorer
-
Getting Help ,Exploring the Web, Working with Web pages
-
Searching the Internet , Performing advanced searches
-
Customizing the search features , Working with Web pages
-
Working with Favorites , Using links , Using the History list , Printing Web content
-
Internet transactions and security ,Internet transactions ,Web security etc considerations ,Working with e-mail messages etc
-
E-mail message, Handling messages, Managing e-mail , Personal folders etc
-
Searching and sorting messages ,Printing messages
-
Address books google doc etc
-
Concept of Internet and Intranet
-
Web Browsing , Email
Unicode Bangla
-
Familiar with Unicode Keyboard and font;
-
Unicode Software and Font Installation technique;
-
Writing procedure of Bangle etc.