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