Computer Office Application

(1) Overview of Computer

• Describe the history of computers.
• Classify computer depending on capability, size, speed & generation, etc.
• Define Hardware.
• List and demonstrate different parts of a Personal Computer and Laptop.
• Define Software & Firmware.
• Classify Software
• List the types of Memory,
• Demonstrate Internal and External memories.
• Distinguish between RAM and ROM
• State Bit, Byte, Kilobyte, Megabyte, Gigabyte, and Terabyte.
• Describe computer viruses and anti-virus, computer security.
• State desktop screen icon, icon-shortcut, file, folder/Directory.
• Describe file management & windows explorer.
• Select, open and close Desktop icons for navigation purposes.
• Create / Rename a folder, Cut/Copy/Paste a File or Folder.
• Install and uninstall basic application software.
• Install and update Anti-Virus Software.

(2) Overview of Operating System

• Describe the Operating System (OS) and the importance of system software.
• Practice on Operating System Environment.

(3) Word Processing

• Getting Started with Word
• Editing Document
• Formatting Text
• Using Automated Formatting, Editing & Proofing Tools
• Working with Graphics & Tables
• Bangla typing
• Merging Documents for Mailing
• Using Macros
• Working with Tables of Contents & Indexes
• Long Document Formats
• Use shortcut keys in MS Word
• Practical.

(4) Spread sheet Analysis

• Learning Worksheet Fundamentals
• Editing and Formatting Worksheets
• Formatting Cells
• Changing Print Options
• Rows/Columns/Worksheets/Workbooks
• Working with Charts
• Performing Basic Calculations
• Using Basic Financial Functions
• Create advanced formulas
• Create advanced charts and tables
• Practical

(5) Presentation Design and Delivery

• Create a Presentation
• Insert and Format Slides
• Change Presentation Options and Views
• Configure a Presentation for Print
• Configure and Present a Slide Show
• Insert and Format Text
• Insert and Format Images
• Insert and Format Charts
• Insert and Format SmartArt graphic
• Insert and Manage Media
• Animate Slide Content
• Set Timing for Transitions and Animations
• Finalize Presentations
• Practical

(6) Database Management

• Understanding Databases & Creating Tables
• Working with Tables
• Creating and Using Queries
• Designing a Form
• Designing a Report
• Customizing Tables
• Creating Custom Queries
• Automating Tasks
• Using Database Tools
• Integrating Access with MS Applications
• Practical

(7) Email and Internet

• Establish online connectivity.
• Customize Settings
• Print and Save Information
• Perform Search Operations in Outlook
• Organize and Manage Messages

(8) Google G-suite

• Manage Google Docs
• Manage Google Sheet
• Manage Google Slides
• Manage Google Calendars