পৃথিবীর অগ্রগতির সাথে সাথে বর্তমান কর্পোরেট দুনিয়ায় আইটি নলেজ থাকা খুবই জরুরী কারণ সব অফিস এখন কম্পিউটার নির্ভর। এছাড়া অফিসের কিংবা নিজের কম্পিউটার এর কিছু নষ্ট হলে কিংবা কোন সফটওয়্যার ইন্সটল বা অফিস নেট ওয়ার্কিং বা সার্বার বিষয়ক জ্ঞান ইত্যাদি এখন জানা থাকলে কারো দ্বারস্থ হওয়া দরকার হয়না। আবার অফিসিয়াল কাজের জন্য এমএস অফিস বা ডাটাবেজ কিংবা ইমেল কনফিগারেশন বিষয়ক নলেজ থাকা আবশ্যক। তাই এইসব বিষয় চিন্তা আমাদের এই কোর্সটি সত্যিকার অর্থে আপনার জীবন বদলে দেয়ার কোর্স।  

Course duration: 72 hrs (weekly 2 days- 3 hrs/class)

Learning outcomes:

  • Basic knowledge of Computer Fundamentals.
  • Solid knowledge for working with Hardware Assembling & Troubleshooting.
  • Installing and operating PC with different operating system like Windows, Linux Desktop, etc.
  • Installing various Application and/or Utility Software like Antivirus Software, Browsers, Office Applications, Audio/Video/Image Editing Software, Typing Software (English and Bangla), etc.
  • Working with Microsoft Office Applications & Database Fundamentals
  • Data Communication and Networking Fundamentals &Network Troubleshooting.
  • E-mail Client Configuration (OutLook, Gmail) & advanced Internet searching

Module 1: Computer Essentials

Session: 1

  • Basic knowledge of Computer Fundamentals & list different types of computer
  • What is Hardware & Software? 
  • Computer System Components & Storage Devices
  • Different types of Storage Devices. Define Hard Disk Type (PATA, SATA, SSD, etc)
  • RAM Types and Features & List the types of Memory
  • What is Primary and secondary Memory?
  • Difference between RAM and ROM
  • Discuss about Bit, Byte, Kilobyte, Megabyte, Terabyte
  • Device Connections and Interfaces & Hardware Port
  • Learn Hardware specification for PC

Session: 2

  • Practically showing the different units of a Personal Computer –Casing, Motherboard, Power Supply, Hard Disk, RAM, Lan Card/ Wifi Lan Card, PCI VGA Adapter, etc.
  • Discussion about BIOS Setup
  • Practically assemble all the components, ensure power cables and data cables connection.
  • Front panel power switches, Front or Back panel USB ports, LEDs, etc.
  • Re-assemble all the components of a PC.
  • Identify the different units of Laptop/Notebook
  • Plug-in the external devices of computer –Printer, Scanner, Modem, Webcam, etc.
  • Hard Disk Partitioning with Third Party Software.
  • Primary Partition, Logical Partition

Session: 3

  • Basic Internet searching
  • Advanced internet searching
  • Review class with previous 2 sessions

Module 2: Operating System Fundamentals

Session: 1

  • Discuss Operating System Fundamentals
  • Discuss PC(Personal Computer) OS(Operating System)
  • Discuss Single & Multiple user OS, multitasking
  • Learn about Control Panel Utilities
  • Learn about Security Settings
  • What is Operating System Tools?
  • How to Troubleshoot Hard drives including Printers, Scanners & Modem
  • Install Microsoft Windows & Windows upgrade and preventive maintenance
  • How to Install Motherboard Driver
  • Install, Configure and maintain Printer, Scanner & Modem

Session: 2

  • Practical work on windows operating system environment.
  • How to create and manage User Accounts
  • How to install Linux Desktop Operating System
  • Practice on Linux Operating System Environment.
  • How to create and manage User Accounts?
  • How to set Password for user accounts?
  • How to install and uninstall application software like flash Player?
  • How to run setup program?

Session: 3

Review class with previous 2 sessions

Module 3: Application System Fundamentals

Session: 1

  • What is the Difference between System Software and Application Software?
  • Discuss about Operational Procedures
  • Fundamental Maintenance Tools & Techniques
  • Describe computer virus and anti-virus, computer security.
  • illustrate Printer Technologies
  • How to install, configure, update Antivirus Software, Malware Software, USB security and others?
  • How to Install and Uninstall various Application software like Avro, Microsoft Office, Bijoy, CC Cleaner, Winrar, PDF, Flash Player, etc? 

Session: 2

Review class with previous 1 session

Module 4: Microsoft Office Fundamentals

Session: 1

  • Discuss the Environment of MS-word.
  • Briefly discuss all tabs of MS-word.
  • Save a new document ina specific folder, Open the previously saved document
  • Practice with save and save as option
  • Compose sample English document & create a document with multiple page
  • Insert page break, page numbers, different type of page numbering in different section of a same document, date & time, footnote & endnote, header & footer, symbols in a document.
  • Insert Picture from ClipArt, Image File, WordArt, Shape in a created document. Practice other tools.
  • Compose Bangla/English document
  • Install and work with specialized Bangla Typing software

Session: 2

  • Getting Started with Excel and Excel Environment
  • Understanding and formatting cells-cells range and Modifying Columns, Rows, and Cells
  • Formatting Cells
  • Page Layouts
  • Simple and complex Formulas with Full Knowledge of Absolute/Relative Referencing, Cell/Range Naming Concept
  • Understand the Differences between Formulas and Functions; Use Very Essential Statistical, Text and Date Functions.
  • Present Summarized Data Graphically with basic charts – Column, Bar, Line & Pie Chart
  • Preparing Database and Data-Table and searching data from table 
  • Advanced Formulas and Functions
  • Manage Large Data Table using Sorting and Filtering Techniques
  • Analyzing and Summarize Large Amount of Data Very Quickly with Subtotal and Pivot-Table Tools
  • Apply logical functions to make spreadsheet decision making tools

Session: 3

  • Getting Started with PowerPoint and PowerPoint Environment
  • How to design templates, color schemes, animation schemes?
  • How to Add/delete slides in the presentation in accordance with the necessity?
  • Create a template using slide master.
  • How to Add Pictures, graphs, charts and other objects into slides as per requirements?
  • Animate Text and other objects are in a very attractive way or motion
  • Finally, Prepare and Present a Slide Show.

Session: 4

  • Review class with previous 3 sessions
  • Problem solving

Module 5: Database Fundamentals

Session: 1

  • Define Database & its application.
  • Explain Data, Information, Record, Row, Column, Table, DBMS, RDBMS, Distributed Database Model.
  • List of Popular database software
  • Discuss Data types and list the available data types in MS Access
  • Explain Fields and Naming convention of fields and mention the Field Properties
  • Define Primary & Foreign Key, composite key, candidate key
  • State Database components (Table, form, query, report, macro, module, etc.)
  • Mention the different types of query and its importance.
  • Define Report, identify the necessity of reports and the different sections in a report
  • Create various sample database tables (Schema Design)

Module 6: Data Communication and Networking Fundamentals

Session 1: Basic Network Setup (Ethernet & Wireless)

  • Learn Network Fundamentals
  • Physical Network Connections
  • Physical Cards and ports
  • TCP/IP, IPv4 Classification (A Class, B Class, C Class, etc.)
  • Define IPv6
  • What is a computer network? And Media types.(Ethernet,
  • Optical & WiFi)
  • Types of Network (LAN, MAN & WAN)
  • Work group & Domain Concept
  • What is IP address & IP address Types (Public &Private) (Static & Dynamic)
  • Deploy a Switched network.
  • Configure a WiFi router with an SSID.
  • Connect a machine to a Wireless network.
  • What is CMD & How to check Current configuration (IPCONFIG) in Windows7.
  • Create a shared folder to share common files over the network.
  • Share a Printer Over a network

Session 2: Basic Network Troubleshooting

  • Common Network troubles in LAN?
  • How to check whatismyipaddress and the country location of IP.
  • Introduction to PING, NETSTAT, NBTSTAT and more.
  • How to solve Name server related issues. (Flush DNS, Register DNS)
  • What is DNS Server?

Session: 3

Review class with previous 2 sessions

Module 7: E-mail Client Configuration (OutLook, Gmail)

Session: 1

  • How to configure your official mail with Outlook or Thunderbird.
  • Add, Modify & Export/Import Your Content.
  • Back up your existing mail and restore on a different machine.
  • How to use a Customize Signature in Mail client.
  • How to configure Gmail with your favorite E-mail
  • Client (Outlook or Thunderbird)