Logo

Course Content : Advance Certificate Course in Computer

  • 1st Semester : Computer Fundamental & Operating System
    • Acquire knowledge on Computer Fundamentals
      Describe the history of computer.  
      List different types of computer depending on data processing.
      Classify computer depending on capability, size, speed, etc.
      Difference between Hardware & Software. 

    • Learn Computer System Components
      Learn Storage Devices
      Classification of different type of Storage Devices
      Define Hard Disk Type (PATA, SATA, SSD, etc) 

    • RAM Types and Features
      List the types of Memory
      Identify Primary and secondary Memory
      Distinguish between RAM and ROM
      State Bit, Byte, Kilobyte, Megabyte, Terabyte. 

    • Device Connections and Interfaces
      Hardware Port (Ex: Serial, Parallel, HDMI, USB/PS2, etc.)
      Learn Hardware specification for PC 

    • Learn Operating System Fundamentals
      Personal Computer Operating System
      Define Single user OS, Multiple user OS, multitasking

    • Control Panel Utilities
      Security Settings
      Operating System Tools 

    • Difference between System Software and Application Software.
      Learn Operational Procedures
      Basic Maintenance Tools & Techniques 

    • Describe computer virus and anti-virus, computer security.
      Describe Printer Technologies. 

  • 1st Semester : Application Packages & Office Automation
    • Install and Uninstall Application software like Microsoft Office, Bijoy, CC Cleaner,

      Winrar, PDF, Flash Player, etc. 

      Run setup program 

    • Install and Uninstall Application software like Open Office, Flash Player, etc. 

      Run setup program in Linux System 

    • Install, Configure and maintain Printer

      Install, Configure and maintain Scanner

      Install, Configure and maintain Modem 

    • Troubleshoot Video and Display devices

      Troubleshoot Hard drives

      Troubleshoot Printers, Scanners

      Troubleshoot Modem 

    • Identify the different components of MS Word program.

      Select Text using mouse / keyboard

      Edit text as per requirement 

    • Format Text / Paragraph.

      Practice typing using “Type Tutor” 

    • Save a new document in a 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. 

    • Compose Bangla/English document

      Install and work with specialized Bangla Typing software 

    • Insert AutoShape, TextBox, Bookmarks & Hyperlink (Internal & External Hyperlink),

      comments, caption, index & tables files in a document. 

    • Use Bullet & Numbers, Borders & shape as per requirement.

      Create Watermark, Drop cap, Change Cases, style of paragraphs & text and use Auto

      Formatting in a document. 

    • Use AutoSave, AutoCorrect Options and other options of tools menu.

    • Work with Mail Merge Wizard.

      Create Primary or main document, and secondary document (Add/Remove Fields, Get data or Fill up the forms)

      Merge Documents in accordance to task assigned

      Print Document, create & print Envelopes, and create & print labels in a document.

    • Configure Paper size, Margins, Gutters, Paper Orientation, Mirror Margin for printing a document.

      Print entire document or selective pages, or selective portion of the document as needed. 

    • Use shortcut keys in MS Word.

    • Compose a sample document/application/Bio-data in Bengali and English with formatting.

    • Identify the different components of spreadsheet program

      Identify Rows, Columns, Cells and range

      Move cursor upward, downward, left, right, last cell, last column, last row, first cell, first row, first column 

    • Use page setup options.

      Apply different options/operations of edit menu in a spreadsheet file (Cut, Copy, Paste, Paste Special, Fill, Clear) 

    • Use various operations of find and replace in spreadsheet file in accordance to task assigned.

      Use Hide or show options for row/column when required and zoom the sheet. 

    • Insert AutoText and Custom Text as Header and Footer, Rows, Columns, Worksheets, symbols, Comments, Page Breaks, Copied Cells, Picture from ClipArt & Image in spreadsheet file in accordance to task assigned. 

    • Format Rows & Columns, format Cells with Number on task necessity

      Practice Decimal place setting and style of Negative figures.

      Format Cells for Alignment, Merge, and Fonts 

    • Practice cell reference (Absolute & Relative).

      Logical Functions- AND(), OR(), IF(), TRUE, FALSE, etc.

      Date & Time Functions- Now(), Today(), DAYS360(), HOUR(), MINUTE(), etc. 

    • Practice Mathematical Functions- Abs(), Sum(), SUMIF(), CEILING(), FLOOR(), MOD(), POWER(), RANK(), COUNT(), MAX(), MIN(), etc. 

    • Create a salary sheet and prepare, sort by name/by salary/by date and also check for Spelling & Grammatical Error 

    • Set Page Orientation, Paper Size, Scaling, Margins, print Titles to the center of the page, set printer as default

      Print a hardcopy of entire Book, entire Worksheet, or selective pages of a Worksheet from

      MS Excel.

      Understanding Print Area and Clear Print Area under file menu. 

    • Identify the different components of MS Power Point Program

    • Design templates, color schemes, animation schemes

      Add/delete slides in the presentation in accordance with the necessity

      Create a template using slide master. 

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

    • Execute Slide transitions in accordance with the theme of the subject matter of the presentation.

      Use Sound effects and custom path of animation effects in the presentation.

      Add Video Clips. 

    • View Slides of PowerPoint presentation in a different way (for example outlining, slide shorter, etc.)

      Reorder Slides of PowerPoint presentation on the outline Tab in accordance with the necessity. 

    • Preview a presentation and print from MS PowerPoint.

    • Customized a slide show setup for a particular audience.

      Set up a slide show, Rehashing and timing a of a presentation.

      Review and adjust Slide timing as per requirement.

    • Present a Slide Show.

    • Create an E-mail account (on yahoo, gmail, hotmail, etc.) for the first time.

      Check, compose, send and reply of e-mail message.

      Attach a file to an e-mail message and open an attached file.

    • Set-up an E-mail account first time using outlook.

      Check, compose, send and reply of e-mail message by Outlook.

      Attach a file to an e-mail message and open an attached file by Outlook.

    • Use contact/address book.

      Backup Outlook files.

    • Delete a message temporarily and permanently.

      Clean up mail box by managing junk e-mail.

      Email Sorting.

    • Move messages to another folder.

      Create custom Folders to store custom emails.

      Creating Rules to manage automatic email folder arrangements in Outlook, Gmail, Yahoo,

      etc.

  • 1st Semester : Programming Language
    • Introduction to C

      The Structure of a C Program

      Some basic C Commands 

    • For loop

      Symbolic constant

      Character input and output

      Logical AND and OR

      Array and Functions

      Call by Reference and call by Value 

    • Variables and constants

      Data Types

      Operators

      Expressions 

    • if

      switch

      Conditional Expressions

      while

      break and continue 

    • Multi-file programs

      Scoping

      Recursion

      The C Pre-processor 

    • Pointers and addresses

      Organization of Memory

      Pointers and Arrays

      Managing and manipulating memory

      Passing parameters to C programs

      Pointers to functions 

  • 1st Semester : Data Structure & Algorithm
    • Basic Terminology (Data, Data Item, Group Items, Elementary Items, Attribute and Entity, Entity, Field, Record, File), Characteristics of a Data Structure, Correctness, Time Complexity, Space Complexity, Need for Data Structure, Execution Time Cases, Characteristics of an Algorithm. 

    • Aysmptotic Analysis, Greedy Algorithms, Divide & Conquer, Dynamic Programming, 

    • Array Data structure, Linked List, Doubly & Circular Linked list, Stack & Queue. 

    • Linear Search, Binary Search, Interpolation Search.

    • Sorting Algorithm, Bubble sort, Insertion sort, Selection sort, Merge sort, Quick sort 

    • Graph Data Structure, Tree Traversal, Binary Search Tree, Spanning Tree, Heap,

      Recursion Basics, Tower of Hanoi, Fibonacci Series

    • Brief About Graphics design, how to develop skill on this field, focus on particular points. 

    • Basic color concept development, color mixing idea, how to generate any color

      combination, type of color, Understand the measuring, type of measurement, where and how to use. 

    • Introduce with Photoshop environment, what’s kind of work can do via this application 

    • Introduce with Web interface design 

    • Introduce with Mobile Apps UI design 

    • To develop any HTML template, it’s necessary to prepare all images as per HTML

      development requirement. 

    • How to make Combination AI and PS, how to development design skill, how to generate idea to make a unique design, how to develop any design from scratch to finish. 

    • Intro to the Photoshop

      Major Shortcut Keys 

  • 1st Semester : Creative Graphic Design
    • Understanding Layers

      Understanding what a layer is

      Changing the opacity of a layer

      Changing the stacking order/ Arrange

      Turning the visibility of layers on and off

      Deleting Layers

      Duplicating Layers

      Aligning Layers

      Group Layer 

    • Layer All style Basic Idea

      Layer Mask

      Layer Lock

      Lock Transparent Pixel

      Blending Option

      Clipping Mask

      Linking Layers

      Grouping Layers

      Linking Groups 

    • Adding and Transforming Images

      History Panel

      Magic Wand Basics

      Smart Objects vs Normal Layers

      Canvas Size vs. Image Size

      Clipping & Masking

      Color Correction

      Clone Stamp 

    • Clipping Path 

    • Path selection

      Using pen tool to create path 

    • Complex 1 Project based, how to do the work and one by one show the problem and fixing 

    • Complex 2 - one by one show the problem and fixing 

    • What should you need to start a design, how to work faster, how to handle/make perfect

      your working software environment

      Create a document.

      Start creating Shapes

      Coloring the shapes

      Difference tools/ Plates

      Create action, change color

      Make align using Alignment Plate 

    • Practice Class

      Make logo similar to chrome

      Simple Business card with Safe and bleed

      Talk about related issues 

    • Web interface design, primary focused on target audience and type of website.

      Color combination, related images used, source of images, font size, sections, how many

      sections min requirement etc. 

    • Redraw PSD file from JPG

      Open JPG images in Photoshop

      Start Header part

      Save the file PSD format

      Finish all others works

      After Finish check with original design layout 

    • New Layout for Web page

      Create a document 1200px

      Make Guide as per bootstrap

      Total 12 column and keep 30px gutter

      Guide make on 1170px

      Make canvas size 1920px

      Increase canvas height as per design requirement 

    • Concept and compare in existing market apps and website, what compromise did on mobile apps. 

    • Come up with a concept

      Live check the website and mobile view 

    • Check existing Apps design

      Question and asking why and what etc.

      Check the used tools and content

      Redraw UI kit for Mobile 

    • Create Apps UI kit

      Create a UI kit base on apps design

      Design a new apps from given concept

      Check and fixing problems 

    • Trim the PSD

      Choose an image for slice.

      Slice the logo, icon, and images.

      Use the Copy Merge Function for copy images

      Use the Trim Function for easy picture size

      Use save for web PNG or JPG as per images requirement.

      Transparent Images only make PNG and others make jpg for make small file size. 

    • Do a Project

      Check the full document and finalize which part you need to make images.

      Also check which Image need to make PNG and which image can make JPG.

      Make a folder give the name images/img for save all images.

  • 1st Semester : Business English
    • How to Write to Influence in your Business 

    • Introducing Common Terms and Phrases 

    • Idioms and colloquial language used professionally 

    • Language to Avoid Hidden Negative Meaning 

    • Giving instructions politely 

    • Structure clear and concise Messages 

    • Ways to make a message formal 

    • Techniques to negotiate and persuade 

    • Phrases used for apologies and assurance 

    • Saying 'No' in a positive manner 

    • Writing techniques to handle complaint/negotiation/persuasion email 

    • Structuring the Report or business proposal 

    • Pre-requisites for a successful conversation 

    • Starting a conversation on a topic and switching to another 

    • Asking Questions 

    • Proper way of:

      • Greetings

      • Apologizing

      • Empathizing

      • Showing gratitude/thanking

      • Offering Assistance 

    • Maintaining professionalism by setting the right tone 

    • Ways to be Competent to Develop Oneself 

    • Constructing Good Professional Relationships 

    • Creating Motivation in a Team through Effective Communication 

  • 2nd Semester : Data Communication & Networking
    • Data communication

      Networks

      Network Topologies

      Network categories

      The internet 

    • The layers and their functions

      IPv4 & IPv6 

    • Digital signals

      Analog signals

      Composite signals 

    • Twisted Pair.

      Coaxial Cable.

      Fiber-Optic Cable.

      Radio Waves.

      Microwaves.

      Infrared. 

    • Digital Transmission.

      Analog Transmission. 

    • Types of errors , Redundancy

      Detection Versus Correction

      Error Detection, Error Correction.

      Hamming Code.

      Cyclic Redundancy Check.

      Checksum and Its idea. 

    • Random access

      Controlled access

      Channelization 

    • LAN protocol architecture

      Bridge

      Layer 2 & layer 3 switches 

    • Ethernet

      Fibre channel 

    • Main concept

      Bluetooth 

  • 2nd Semester : Database Management System
    • File Systems Organization, Sequential, Pointer, Indexed, Direct, Purpose of

      Database System, Database System Terminologies, Database characteristics, Data

      models, Types of data models, Components of DBMS, Relational Algebra.

      LOGICAL DATABASE DESIGN: Relational DBMS, Entity Relationship model ,

      Extended ER Normalization , Functional Dependencies, Anomaly, 1NF to 5NF,

      Domain Key Normal Form, De-normalization. 

    • SQL Standards Data types, Database Objects.

      Embedded SQL, Static Vs Dynamic SQL. Query Processing and Optimization,

      Heuristics and Cost Estimates in Query Optimization. 

    • Introduction, Properties of Transaction, Serializability, Concurrency Control,

      Locking Mechanisms, Two Phase, Commit Protocol, Dead lock.

      Effective Design of Forms and Reports

      Data on Forms - Programs to Retrieve and Save Data - Error Handling.

      Table Operations

      Data Storage Methods - Data Clustering and Partitioning. 

    • Database Administration - Development Stages - Application Types - Backup and

      Recovery - Security and Privacy - Distributed Databases - Client/Server Databases Web as a Client/Server System

      Data Classification, Threats and risks, Database access Control, Types of Privileges, Cryptography,

      Statistical Databases, Distributed Databases, Architecture, Transaction Processing, Data Warehousing and Mining, Classification, Association rules, Clustering, Information Retrieval, Relevance ranking, Crawling and Indexing the Web, Object Oriented Databases, XML Databases. 

  • 2nd Semester : Web & Mobile Application Development
    • Overview of Web Development

      How to keep a variable in computer memory.

      Naming convention of PHP code

      Understand how a program is run in a computer in PHP environment 

    • Understand array mechanism for keeping a series of data in computer memory

      Apply linear search for finding a particular item from a series

      Apply quick sort algorithm for ascending or descending ordering of a series of

      data

      How to keep data in an array and find them later 

    • Work with collection classes: Array List, Array to get benefits over array

      Use Stack, Queue data structure for solving particular problem 

    • Encapsulate your data and its functionality

      Define association relationship

      Understand the essence of inheritance relationship 

    • Find an object from problem domain

      Keep some field, property, method inside a class

      Understand a class with the collection of another class in its field

      Define static class and method from real life example

      Understand user defined type and create object from it 

    • Understand association relationship between two classes

      Understand inheritance relationship between classes 

    • How web works.

      Understand HTML and The Web, HTML Document Structure

      What and why: CSS, Why do we need JavaScript

      HTML5 Fundamentals, HTML Foundations

      HTML5 Features 

    • CSS Basic, Up and Running with Selectors, CSS Position

      CSS Text, Managing Details in Style Sheets

      CSS3 And Modern Web Design, Building A Solid Cross- Browser Template

      Create a HTML template by an editor and open it by any of browser application 

    • Put some HTML Tags (for heading, paragraph, break, bold, italics, HTML lists)

      in a HTML page

      Create a menu using using HTML tags 

    • Validate logic using JavaScript 

    • Understand Web design fundamentals

      Understanding aggregate function and advanced queries

      Use PHP server side controls in your web application 

    • State management of PHP

      How to put JavaScript in web page

      Working with server side programming 

    • Discuss the history of Apps Development

      Technology stack needed for android apps development

      Understand main building block of Android apps 

  • 2nd Semester : Internet & Web Technology, Online Outsourcing
    • How to use Internet

      What is Session, Session Data, Practical Example of using Session

      Understanding Cookie 

    • Email Overview 

    • What is Web 2.0 Technology

      Understanding Domain Name Server 

    • Understanding Domain, Hosting, cPanel, WHM, Plesk Panel, phpmyadmin 

    • Web Server Overview, Windows and Linux Web Server overview,

      characteristics. 

    • Introduction on online marketplace

      Overview on Skill Test importance and 100% Profile ready

      Bidding process on Project

      Way to Interview

      How to do Client Communication

      Payment System Overview 

    • Social Media Overview

      Understand Email Marketing

      Learn about Affiliate Marketing 

    • Instant messaging overview 

    • File Sharing knowledge 

    • Understanding Internet of Things (IoT)

      Benefits of IoT

      Example of WiFi Lightbulb

      Examples of Internet connected items

      Problem with IoT 

  • 2nd Semester : System Analysis & Design
    • System definition and concepts:

      Characteristics and types of system, Manual and automated systems,

      Real-life Business sub-systems:

      Production, Marketing, Personal, Material, Finance

      Systems models types of models: Systems environment and boundaries, Real-

      time and distributed systems, Basic principles of successful systems. 

    • Systems analyst: Role and need of systems analyst ,Qualifications and

      responsibilities ,Systems Analyst as an agent of change.

      Introduction to systems development life cycle (SDLC) :

      Various phases of development :Analysis, Design, Development,

      Implementation, Maintenance.

      Systems documentation considerations: Principles of systems documentation,

      Types of documentation and their importance, Enforcing documentation

      discipline in an organization. 

    • System Planning 

    • Data and fact gathering techniques: Interviews, Group communication,

      Presentations, Site visits. Feasibility study and its importance

      Types of feasibility reports System, Selection plan and proposal

      Prototyping, Cost-Benefit and analysis: Tools and techniques 

    • Process modeling, Logical and physical design, Design representation, Systems

      flowcharts and structured charts, Data flow diagrams, Common diagramming

      conventions and guidelines using DFD and ERD diagrams. Data Modeling and

      systems analysis, Designing the internals: Program and Process design,

      Designing Distributed Systems. 

    • Classification of forms: Input/output forms design, User-interface design,

      Graphical interfaces. 

    • Module specifications ,Module coupling and cohesion , Top-down and bottom-up

      design 

    • Introduction to Object Oriented Analysis and design life cycle, object modeling:

      Class Diagrams, Dynamic modeling: state diagram, Dynamic modeling:

      sequence diagramming. 

    • Planning considerations, Conversion methods, producers and controls, System

      acceptance Criteria, System evaluation and performance, Testing and validation,

      Systems qualify Control and assurance, Maintenance activities and issues. 

    • Computer system as an expensive resource:

      Data and Strong media Procedures and norms for utilization of computer

      equipment, Audit of computer system usage, Audit trails, Types of threats to

      computer system and control measures: Threat to computer system and

      control measures, Disaster recovery and contingency planning. 

Filter Branch wise Batch :

Batch : ACC-02

Start Date: 1 Jul 2021
Days : Saturday,Monday,Wednesday
Schedule : 5:30:PM To 7:30:PM
Duration : 1 Year
Course Fee : 35000 /=
Discount : 1750 /=
Apply Now