অ্যাডভান্স কম্পিউটার অফিস অ্যাপ্লিকেশন

Time 3 Month
Start Date 15/10/2022
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

 

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
  • Others
 

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.