Technical Education Board Office Application Course (6 month)

Computer Basics course

Course at a glance

  • Date : 10 October 2020 - 10 April 2020
  • Last Date of Registration : 10 October 2020
  • Total Hours : 36
  • No. of Classes/ Sessions : 36
  • Class Schedule : 9 am to 8pm
  • Venue : Barishal

Price: TK. 5500.00

3850


Module 1: Computer Basic

     1.    Concept of Computer

     2.     Concept of  IT and ICT

     3.    Computer Hardware Configuration, Software

     4.     Concept of memory & storage

     5.      Uses of input & output devices

     6.      Introduce of Keyboard and Effectiveness

     7.      Concept of Computer Operating System  

Module 2: Word Processing/Microsoft Word

      1.        Word 2010 interface

      2.         Understanding the Ribbon, Title bar and Menu bar

      3.          Customizing the quick access toolbar

      4.          Navigation toolbar, Navigation pane, Status bar

      5.          Understanding the tools box and Tools

      6.         Documentation in various file format 

      7.         Concept of Home tab

      8.          Effectiveness of Clipboard tools

      9.          Effectiveness of Font tools

     10.         Effectiveness of Paragraph tools

     11.         Effectiveness of Styles and Editing Tools

     12.         Insert tab: page, Insert table, Draw table and Table properties

      13.       Illustrations of Picture, shape, chart and screenshot

      14.        Links, Header & Footer , text, Equation and symbol concept

      15.         Page Layout tab: Themes and Page Setup

      16.         Page Background Color, watermark and Borders 

      17.         View tab: Document Views, Ruler, Gridlines and Navigation

      18.          Design tab: Styles, Border & shading

      19.         Layout tab

      20.        Reference tab

      21.        Typing Procedure

Module 3: Introduce of Microsoft Excel

        1.         What is excel

        2.        Usefulness of Microsoft excel

       3.          Concept of Various Excel sheet

Module 4: Working procedures of Microsoft Excel

       1.          Understanding the Ribbon, Title bar and Menu bar

       2.          Understanding the Documentation & Security

       3.          Concept of Rows, column & cells

       4.          Selection in excel

       5.          Merge & Unmerge cells

       6.           Understanding the formula & function

       7.           Add number & text manually in excel

        8.        Add number by auto sum

        9.        Subtracting

       10.       Conditional formatting in excel

       11.        Customize Conditional formatting

       12.       Multiplying

       13.     Dividing

14.      Update date & time automatically

       15.      Use template in excel

       16.     Create original template

       17.     Header & footer in excel

       18.      Multiplying

       19.       Dividing

20.       Update date & time automatically

       21.        Use template in excel

       22.      Create original template

       23.        Header & footer in excel

       24.        Average/min/max/count function in excel

       25.        Use sum if average if in excel

       26.       Chart customization and edit in excel

       27.       Different kinds of chart on excel

       28.       Date & time Formatting

       29.     Text Formatting Text Formatting

       30.      Custom view and print selection in excel

       31.      Hide row and column in excel

       32.       Text Formatting

       33.       Sort and filter in excel

       34.       Remove duplicate data in excel

       35.       Subtotal tool in excel

       36.       Goal seek tool & PMT function in excel

Module 5: Presentation / Microsoft PowerPoint

  1. 3D effect, etc.

  2. Design tab: Page setup, slide orientation, themes,

  3. Background style etc.Animation tab: custom animation, Transition customization, advanced slide etc.

  4. Review  tab: Spelling check, comment, protect presentation, 

  5. View tab: Presentation views, show hide, macros etc.Slide show tab: Starting slide shows, set up tools, monitors

  6. Review of Presentation / Microsoft PowerPoint

Module 6: Microsoft Access/ Database

  1. Explore an Access Database: Exploring tables, Exploring forms, exploring quires, Exploring reports

  2. Creating Database and Simple data.

  3. Creating Database from simple table

  4. Creating Database from tables manually.

  5. Customizing rows & columns Creating relationship between tables.

  6. Create Simple forms:

  7. Creating forms by using form tools

  8. Changing the look of forms

  9. Changing Argument of form.

  10. Display data.

  11. Sorting information in table filtering information in table & forms

  12. Review of Microsoft Access/ Database

Module 7: MS- Outlook

       1.       Send & receive email messages

       2.       Store & access contact information

       3.       Manage scheduling

       4.       Track task

Module 8: Troubleshooting

  1. Operating system

  2. Basic networking

  3. Functions of utility software’s

Institute
Logo

IT Theory

TENTATIVE CLASS START

10 October 2020

AVAILABLE SEAT

9 / 50

Registerd

8

MEET THE INSTRUCTOR

John Doe

Related Course