Office Applications & Unicode Bangla under WID

Course Overview/Objective
  •  To Perform calculations using mathematical formulas in spreadsheets, perform data analysis, prepare a database system and Easily calculate salary/grade using  Spreadsheet
  •  To Use computer tools to create scientific documents using equation editor, represent experimental data in tables, draw figures, and integrate charts and graphs.
  •  To develop technical and scientific presentations, and embed charts, graphs, and equations using presentation tools.
  •  To enable operate the computer smoothly and Prepare a document in proper way.
  •  To gain the skills of multimedia presentation using Power Point
  •  To make an Eligible for Sending / Receiving   e-Mail, Chat & Video conferencing ,Browsing Internet, Searching specific information over Internet
Requirements
  • HSC/Equivalent
Course Project
N/A
Used Tools
Microsoft Office 2007
Course Outline

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.