NSDA LEVEL-3 FOR COMPUTER OPERATION

MD. ABDUL HALIM (Trainer-ICT)

UCEP Gazipur TVET Institute.

www.facebook.com/abdulhalim.rpi Website:abdulhalim.odoo.com/
 প্রথম অধ্যায়

কম্পিউটারেে ধােণা
1. কম্পিউটাে কী?
উত্তরঃ কম্পিউটার এক ধরনের ইনেকট্রম্পেক্স ম্পিভাইস ও গেণাকারী যন্ত্র। যার মাধযনম খু ব সহনে, অল্প সমনে, প্রচুর তথ্যসম্বম্পেত
গাম্পেম্পতক ম্পহসাব সহ, ম্পবম্পভন্ন সমসযার সমাধাে করা যাে তানকই কম্পিউটার বনে।
2. কম্পিউটাে কত প্রকাে ও কী কী?

COMPUTER

ANALOG DIGITAL HYBRIDE

COMPUTER COMPUTER COMPUTER

MINI MICRO MAINFRAME SUPER

COMPUTER COMPUTER COMPUTER COMPUTER

DESKTOP LAPTOP PALMTOP NOTEBOOK

3. History of Computer:
1822: চােলস বযানবে Different Engine উদ্ভাবে কনরে । 1842 সানে, চােলস বযানবে Analytical Engine (নমকাম্পেকযাে
কম্পিউটার) আম্পবষ্কার কনরে যা সিূ ণল স্বে়ংম্পিেভাবে এব়ং সমস্ত গাম্পণম্পতক ম্পিোকোপ করনত সক্ষম। এটি প্প্রাগ্রাম স়ংরক্ষণ করনত
পানর এব়ং ম্পেনদল শাবেী চাোনত পানর। এটি বযবহার করা প্রথ্ম 0 এব়ং 1 বাইোম্পর ম্পসনেম ম্পিে।
1930: প্রথম ইবেকট্রিকযাে কম্পিউটার Howard Aiken আম্পেষ্কার কবরন। যার নাম ম্পিে Mark-1.
1943: প্রথ্ম ইনেকট্রম্পেক কম্পিউটার Alan Turing Colossus আম্পেষ্কার কবরন। যার নাম ম্পিে The Bombe.
1946: প্রথ্ম ম্পিম্পেটাে কম্পিউটার J Presper Eckert এব়ং John Mauchly আম্পেষ্কার কনরে। এটির নাম ম্পিে ENIAC.
(Electronic Numerical Integrator and Calculator) ।
1964: সানে বা়ংোনদশ পরমাণু শম্পি কম্পমশনন প্রথ্ম কম্পিউটার আনা হয় । আইম্পবএম প্মইেনেম-1620 ম্পসম্পরে।
1951: EDVAC এব়ং UNIVAC প্রথ্ম বযবসাম্পেক উনেশয ইনেকট্রম্পেক ম্পিম্পেটাে কম্পিউটার তৈরী করা হয়

Analytical Engine Mark-1 ENIAC EDVAC

Page 1 of 97
4. Computer Generation:

Page 2 of 97
5. কম্পিউটাে এে অংশ কয়টি?

Computer

Hardware Software

Input Processing Output System Application

Device Device Device Software Software

1. Keyboard Processor 1. Monitor 1. Window 1. MS Office

2. Mouse (CPU- 2. Speaker 2. Linux 2. Typing Master
3. Scanner Central 3. Modem 3. MacOS 3. Bijoy
Processing 4. Headphone 4. Android 4. Google
4. Joystick
5. Printer 5. iOS Chrome
5. Camera, Unit)
6. Plotter etc. 5. Avast
6. Light Pen etc.

6. Software: -
a. Social Media: Facebook, Messenger, Instagram, WhatsApp, Imo, Viber, LinkedIn, TikTok, Likee,
Twitter (X), Snapchat, Pinterest. Reddit, YouTube, etc.
b. Online Meeting: Zoom, Google Meet, Google Classroom, Duo, Microsoft Team, etc.
c. Computer Virus: ILOVEYOU, My Doom, Code Red, Conficker, Cryptolocker, Sasser, Melissa,
Zeus, Blaster, Klez, Creeper, Sircam, etc.
d. Computer Anti-Virus: Avast, AVG, Avira, Panda, Bitdefender, Norton, Nod32, Intego, ESET,
BullGuard, etc.
e. Browser: Google Chrome, Mozilla Firefox, Microsoft Edge, Opera Mini, UC Mini, Safari, Mint,
Brave, Epic, Tor, etc.
f. Search Engine: Google, Bing, Yahoo, Ecosia, DuckDuckGo, Start page, Ask, Wikipedia, Pililika
(Bangladeshi).
g. Word Processing: Microsoft Word, Google Docs, Libre Office, WPS office, Open Office,
WordPad, Word Perfect, Abid Word, Apple Pages, etc.
h. Spreadsheet: Microsoft Excel, Google Sheet, Libre Office for Excel, Open Office for Excel, Word
Perfect for Excel, WPS Office for Spreadsheet, etc.
i. Presentation: Microsoft PowerPoint, Google Slide, Libre Office Impress, Prezi, Keynote, Canva,
Slide Dog, Flow Vella, Mentimeter, Slide share, Slide Rocket, etc.
j. Live Streaming: Stream Yard, OBS Studio, OneStream Facebook Live, Restream, etc.
7. Hardware: -

Page 3 of 97
 a. Input Device: Mouse, Keyboard, Light Pen, Joystick, Barcode Reader, Scanner, Touchpad,
Touchscreen, Punch Card, OMR, OCR, etc.
b. Output Device: Monitor, Speaker, Printer, Projector, Plotter, Headphone, Electronic Screen, etc.
c. I/O Device: MODEM, Pen drive, Camera, etc.
8. Picture inside of System Unit.

9. Memory/Storage Device:

Memory

Primary Secondary

Example Example
1. RAM-অ-স্থােী 1. HDD
2. ROM-স্থােী 2. SSD
3. Static-RAM, 3. Pen Drive
4. EEP-ROM 4. SD Card
5. Casche Memory 5. CD
6. Register Memory 6. DVD

10. Online Memory/Storage:

a. Google Drive[15 GB], One Drive[5 GB], pCloud[10 GB], TeraBox[1 TB], DropBox[2 GB], etc.

Page 4 of 97
 Memory Table

SL Memory Unit Approximately

01 1 Bit Binary Digit 1 or 0
02 1 Byte [B] 8 bits
03 1 Kilo Byte [KB] 1024 Bytes
04 1 Mega Byte [MB] 1024 KB
05 1 Giga Byte [GB] 1024 MB
06 1 Tera Byte [TB] 1024 GB
07 1 Exa Byte [EB] 1024 TB
08 1 Zetta Byte [ZB] 1024 EB
09 1 Yotta Byte [YB] 1024 ZB
10 1 Bronto Byte 1024 YB
11 1 Geop Byte 1024 Bronto Bytes

11. Mouse & Keyboard: -

Mouse: The mouse has two buttons one is Left (Okay) and the other is Right Button (Option).
Keyboard: The Keyboard has 104 buttons. They are divided into 5 types.
1. Function Key. [F1-F12]
2. Alphabetic Key. [A-Z, other symbols like > < , . ? / \ Tab Shift “ ]
3. Numeric Key. [0-9, +, -, *, / ]
4. Direction/Arrow Key.
5. Control/Navigation Key. Home, End, Page Up, Page Down, Pause/Break, Scroll Lock, etc.
6. Modifier Key. Ctrl, Alt, Shift, Windows, etc.

12. Abbreviation: -

Page 5 of 97
SL NAME FULL FORM
01 NSDA National Skills Development Authority
02 CBT&A Competency-Based Training and Assessment.
03 TVET Technical and Vocational Education and Training.
04 NTVQF National Technical and Vocational Qualification Framework.
05 CS Competency Standards.
06 CBLM Competency-Based Learning Materials.
07 PC Personal Computer.
08 CPU Central Processing Unit
09 RAM Random Access Memory. [Temporary]
10 ROM Read Only Memory. [Permanent]
11 HDD Hard Disk Drive.
12 SSD Solid State Drive.
13 SD Secure Digital.
14 CD Compact Disc.
15 ALU Arithmetic Logic Unit.
16 BIOS Basic Input-Output System.
17 URL Uniform Resource Locator.
18 HTTP Hyper Text Transfer Protocol.
19 HTTPS Hypertext Transfer Protocol Secure.
20 WWW World Wide Web.
21 E-mail Electronics Mail [Gmail, Hotmail, Yahoo, etc.]
22 VGA Video Graphics Array.
23 HDMI High-Definition Multimedia Interface
24 USB Universal Serial Bus.
25 UPS Uninterruptible Power Supply.
26 IPS Instant Power Supply.
27 WPM Word Per Minute.
28 RPM Rotation Per Minute.
29 OSH Occupational Safety and Health.
30 PPE Personal Protective Equipment.
31 OS Operating System.

Page 6 of 97
 Qualification Computer Operation, Level-III
Candidate’s Name
Assessment Centre
Date of Assessment Model-01
Put the (√) tick mark on the right answer:
1. Which tabs on the Ribbon is used to find in a. Name box
the document? b. Status bar
a. Home Tab c. Row heading
b. Review Tab d. Formula bar
c. Insert Tab 8. Which is not a presentation Program?
d. References a. Google Slide
2. Asneem inserted an arrow to point out b. Slide panel
information in a newsletter, which object did c. MS PowerPoint
she use? d. Prezi
a. WordArt 9. The PowerPoint view that displays only text
b. SmartArt (title and bullets) is
c. Chart a. Outline view
d. Shape b. Notes age view
3. What is the shortcut-key for manual line c. Slide show
break? d. Slide Sorter
a. Space+Enter 10. Which type of view is not present in MS
b. Ctrl+Enter PowerPoint?
c. Alt+Enter a. Normal
d. Shift+Enter b. Slide show
c. Slide Sorter
4. Mr. X inserted a rectangular shape into his d. Extreme animation
Word document. He wanted the shape to 11. Which of the following is not a binary
transition from one color to another. Which number?
shape fill option should he use? a. 001 b. 101
a. Gradient c. 110 d. 202
b. Picture 12. The system unit of a personal computer
c. Solid color typically contains all of the following except
d. Texture a. RAM
5. The Greater Than sign (>) is an example b. Monitor
of______Operator. c. Microprocessor
a. Arithmetical b. Relational d. Modem
c. Logical d. External 13. Element used to manage computer files &
6. Which function from bellow is return the folders is
number by reducing the fractional part? a. Control panel
a. INTA b. INTR b. Internet explorer
c. INTF d. INT c. window explorer
7. When you enter text in a cell in Excel. It also d. Window accessories
appears in the

14. What is Indention?

Ans: মার্জিনের শেনে এবং প্যারাগ্রাফ এর শুরুনে ফাকা রাখানক Indent/Indention বনে।

Page 7 of 97
15. Write down four-word processing application software?
Ans: a) Microsoft Word, b) Google Docs, c) Libri Office, and d) WPS Office

16. What do you mean by Filtering?

Ans: Filtering বেনে শেটার একটি বড় শেট শেনক র্ের্দিষ্ট মােদণ্ড অেুযায়ী প্রনযাজে়ীয েেয র্েবিাচে করার প্রর্িযানক শবাঝায।
এটি বযবহারকার়ীনদর দ্রুে প্রাের্িক েেয খুুঁনজ শবর করনে এবং অপ্রনযাজে়ীয শেটা বাদ র্দনে েহাযো কনর।
17. What happens when dollar sings ($) are entered in a cell address?
Ans: Absolute Cell Address or Lock the cell Address

18. Why we use ‘Line Chart’ in excel?

Ans: e use a Line Chart in Excel to visualize trends, changes, or progressions in data over a period of time or
across categories.

19.What does the IF function in Excel?

Ans: এনেনে IF ফ াংশন একটি শযৌর্িক প্র়ীক্ষা করার জেয বযবহৃে হয এবং েেি টি সত্য বা মিথ্য হওযার র্ির্িনে র্বর্িন্ন মাে শফরে শদয।

• র্েেটযাে: =IF(condition, value_if_true, value_if_false)

20. What is a transition in a PowerPoint?

Ans: PowerPoint-এ ট্র নমিশন হে একটি স্লাইে শেনক আনরকটি স্লাইনে যাওযার দৃেযমাে প্রিাব বা অযার্েনমেে।
21. What do you understand by placeholder?
Ans: প্লেসহ ল্ড র হে একটি প্রাক-র্ের্িার্রে শক্ষত্র বা বাে, যা স্লাইে বা েকুনমনে র্ের্দিষ্ট উপ্াদাে বা েেয রাখার জেয বযবহৃে হয।
22.What is a subfolder in computer?
Ans: কর্িউটানর স বহফ ল্ড র হে একটি শফাল্ডানরর মনর্য োকা আনরকটি শফাল্ডার, যা শেটা েংগঠিে এবং ের্িে রাখনে েহাযক।
23. What are the main causes of OS failures?
Ans: 1. Hardware Issues, 2. Software Issues, 3. Virus or Malware Infections, etc.
24. What is the diagnostic in computer education?
Ans: কর্িউটার র্েক্ষায ড য গনমিক হে শকানো কর্িউটার র্েনেম বা েফটওযযানরর েমেযা র্চর্িে এবং র্বনেেণ করার প্রর্িযা।
25. Write down four (4) common printer error?
Ans: 1. Paper Jam, 2. Low Ink or Toner, 3. Printer Offline, 4. Print Queue Error.

This candidate’s underpinning knowledge was: Satisfactory Not Satisfactory

Feedback to candidate
The candidate’s overall performance was: Satisfactory Not yet satisfactory
Candidate Signature Date:

Assessor Signature Date:

Page 8 of 97
 WRITTEN TEST Model-2
Multiple Choice and Short Question
This is a multiple-choice of test. Choose the appropriate answer and circle the letter that corresponds with
your answer. Write
appropriate answers for the short questions.
1 Which one can be used as watermark a) Text
in a word document? b) Image
c) Both A & B
d) None
2 Which of the following MS-Word a) Subscript
features crosses texts out by b) Pagination
c) Underline
drawing a line through it? d) Strikethrough
3 Which one of the following a) Ctrl+I
shortcut key to undo the last b) Ctrl+K
action in MS word? c) Ctrl+J
d) Ctrl+z
4 In MS word, what is a hanging a) The second and all the following lines of a paragraph
indentation? has more indentation value than the first line
b) The first line of the paragraph is center aligned and the rest
is justified
c) The right side of last line of the paragraph is away from the
center
d) All the lines of a paragraph is indented more than the last
and first line of the paragraph
5 Microsoft word is a a) Computer Hardware Program
b) Computer Non-Application
c) Computer Application Program
d) None of Above
6 Which of the following is not a) Word count
present in MS word? b) Font size
c) Brush
d) Page margin
7 Which is not in MS word? a) Italic
b) Font
c) Bold
d) Magic tool
8 What is landscape? a) Page Orientation
b) Paper Size
c) A Font Style
d) Page layout
9 Which function key is used to spell a) F6
check? b) F7
c) F8
d) F6
10 Which one is not a way of a) Verbal
communication? b) Written
c) Online communication
d)zoom
11 Which one is not a Channel of a) zoom
communication? b) Google meet
c) Verbal
d) Microsoft team
12 Which one is not an Ergonomic a) Chair height, seat and back adjustment
requirement? b) Workstation height and layout
c) Document holder
d) Enough lighting
13 Which one is a common application a) Note pad
software? b) MAC
c) Android
d) Microsoft

Page 9 of 97
14 Which one is not a file attribute? a) Date
b) Size
c) Time
d) Font format
15 Which one is not a type of a) Calendar
document in MS Excel? b) Monthly budget
c) Salary sheet
d) Business letter
16 Which one is data type in excel? a) Text
b) Alignment
c) Font
d) Border
17 To write the formula in excel, a) $
which symbol in needed firstly? b) *
c) =
d) ;
18 In Excel, wrap text is used for a) Keeping text in a line
b) Moving text in a line
c) Keeping text within the cell
d) None of above
19 A spread sheet is the best a) Writing an information
application for b) Handling simple accounts
c) Producing a grid-referenced map
d) Keeping an inventory of equipment used
20 Which one is not Unicode font? a) SutonnyMJ
b) Nikosh
c) Kalpurush
d) Sonar Bangla
21 Which one of the following is not a) Bing
a search engine? b) Yahoo
c) Google
d) Windows
22 The process of transferring files a) Uploading
from your computer to a computer b) Forwarding
on the Internet is called ..... c) FTP
d) Downloading
23 Verification of login name and a) Configuration
password is known as: b) Accessibility
c) Authentication
d) logging in
24 The slide that is used to introduce a) Title slide
a topic and set the tone for the b) Bullet Slide
presentation is called the c) Table Slide
d) Graph Slide
25 The effect applied to display when a) Slide animation
slides changes in slide show view b) Custom animation
is: c) Custom Transition
d) Slide Transition
Answer the following questions in short (26-30)
26 Write down the name of 3 Antivirus? Avast, Norton, Panda

27 Write down the name of 3 viruses? Iloveyou, Zeus, Cryptolocker,

28 Top 5 most common computer Windows Won't Boot, The Screen is Frozen, Computer is
Problems. Slow, Strange
Noises, Slow Internet.
29 Write down the 3 printing errors in Paper Jam, Page is not in the memory, Toner Problem
your printer.
30 What is Antivirus? Antivirus is a kind of software used to prevent, scan, detect
and delete viruses from a computer.

Page 10 of 97
 WRITTEN TEST Model-03
Multiple Choice and Short Question
This is a multiple-choice of test. Choose the appropriate answer and circle the letter that corresponds with
your answer. Write appropriate answers for the short questions.
What is meaning of “Booting” in the system? a) Restarting the computer
b) Install the program
1
c) To scan
d) To turn off
The shortcut that appears on the Desktop is a) Image c) My document
2 called? b) Icon d) My computer
Which one of the following is an input device? a) Monitor c) Printer
3 b) Speaker d) Scanner
What one is not computer peripherals? a) Scanner c) HDD
4
b) Microphone d) Webcam
The central processing unit is located in the . a) Hard disk c) System Unit
5 b) Memory unit d) Monitor
Deleted data remains on a disk until ....... a) The data is over written
b) The recycle bin is emptied
6
c) A file compression utility is used
d) The disk is scanned
While on the desktop in Windows, what happens a) Refreshes the screen
pressing F5 do? b) Opens help menu
7 c) Does nothing
d) Opens Search
What is the main advantage of using a text box? a) It automatically makes the text larger
b) It allows you to change the page orientation
c) It gives you more freedom to move
8
the text around
d) It automatically appears on every page of
your document
In Which view Headers and Footers are visible? a) Normal View c) Page Layout View
9
b) Print Layout View d) Draft View
Which items are placed at the end of a a) Footer c) Foot note
b) End note d) Header
10 document?
A number of letters that appears little below the a) Superscript c) Subscript
11 normal text is called: b) Supertext d) Top text
We can change the thickness of a line from a) Line width c) Line height
b) Line thick d) Line style
12
To get to a specific location in a document we use a) Table c) Hypertext
13
b) Bookmark d) Macro
Superscript, subscript and strikethrough are a) Font face c) Font style
14 known as? b) Font effects d) Font Format
In MS-Excel Graphics objects on a chart are used a) Add emphasis to chart data
to: b) Add interest to a chart
15
c) Help explain the chart data
d) All the above
What is the shortcut key to highlight the entire a) Ctrl + C c) Ctrl + Enter
column in excel? b) Ctrl + Page Up d) Ctrl + Space Bar
16

Page 11 of 97
 In the formula, which symbol specifics the fixed a) $ c) *
17 columns or rows? b) % d) ;
Which one is a presentation software? a) Google docs c) Numbers
18
b) Excel d) Google slide
A spreadsheet is the best application for a) Writing an information
b) Handling simple accounts
19
c) Producing a grid-references map
d) Keeping an inventory of equipment used
Which one is a Unicode font? a) SutonyMJ c) Nikosh
b) TonnyBanglaOMJ d) None of above
20
Which one of the following is a search engine? a) Bing c) Gmail
21
b) Firefox d) Windows
The process of transferring files from your a) Uploading c) Forwarding
22 computer to a computer on the Internet is called b) FTP d) Downloading
Verification of a login name and password is a) Configuration c) Accessibility
23 b) Authentication d) logging in
known as:
What is a web browser? a) A kind of spider
b) A computer that stores www files
24 c) A person who likes to look at websites
d) A software program that allows you to
access sites on the world wide web
The effect applied to Display when slides a) Slide Animation c) Custom Animation
25
changes in slide show view is: b) Custom Transition d) Slide Transition
Answer the following questions in short (26-30)
What are the 3 Virtual videos? Dialpad Meetings, TrueConf Online, Skype,
26 conferencing Platforms? FreeConference, BlueJeans, Slack Video Calls, Facebook
Live, YouTube Live
Write down the top 5 cloud data MEGA, Dropbox, Google Drive, Box, Pcloud, Amazon drive
27 storage services?
Top 5 most common computer • Abnormally Functioning Operating System or
problems Software
• Windows Won’t Boot
• The Screen is Frozen
28 • Overheating
• Computer is Slow
• Strange Noises Slow Internet
• Dropped Internet Connections

What is the use if Ethernet port? An ethernet port, also known as an ethernet jack, allows you
29 to connect your computer to the internet via an Ethernet cord.

What is driver software? A device driver is defined as a software program without a

user interface (UI) that manages hardware components or
30
peripherals attached to a computer and enables them to
function with the computer smoothly.

Page 12 of 97
 Name of Candidate
Assessment Center
Date of Assessment Model Test 04
Please tick [√] mark the right answer: Time: 30 Minute
1. Which is not File Extension of MS Word?
A. .docx B. rtdocx C. .rtf D. .doc
2. To avoid mistakes when typing in MS word which feature helps you more
A. Auto-Fill B. Auto Generate C. Chat GPT D. Auto Correct
3. Which of the following is not a word processing software?
A. MySQL B. MS Word C. WPS Word D. Word Graph
4. Which is the Valid Formula of MS Excel?
A. =ADD(A3:A4) B. =A3+A4 C. =SUM(A3:A4) D. A1+A2
5. An Excel workbook is a compilation of
A. Workbook B. Function C. Spreadsheet D. Worksheet
6. Which of the following keyboard shortcuts is used for closing a window or program?
A. F2 B. End C. ESC D. Delete
7. Which Feature in Excel lets you arrange data in ascending or descending order?
A. Filtering B. Sorting C. Find D. Formatting
8. Which terms will be used for clear cells in MS Excel?
A. Delete content B. Clear Content C. Delete D. Format Cell
9. To hold row and column titles in place so that they do not scroll when you scroll a worksheet
click the---
A. Freeze Panes B. Absolute Cell C. Relative D. Arrange
10. What type of chart will you use to compare performance more effectively of two product prices?
A. Pie Chart B. Line Chart C. Column Chart D. Bar Chart
11. How do you customize the slide background in PowerPoint?
A. Layout B. Slide C. Theme D. Effect
12. Process of touching an object with computer mouse pointer is called
A. Pausing B. Dropping C. Pointing D. Hovering
13. Which is not a presentation program?
A. MS PowerPoint B. Prezi C. Google Slide D. Slide Panel
14. Which is a valid file format in PowerPoint?
A. pptx B. pdf C. Power PT D. docx
15. Which is the right team of presentation page?
A. Chart B. Slide C. Clipart D. Image
16. To insert a new slide, go to----
A. Animation B. View C. Home D. Slide Show
17. Program or a set of electronic instructions that tell a computer what is called----
A. Software B. Hardware C. Menu D. Monitor
18. The ALU preforms___________Operation.
A. Logarithm B. Algorithm C. Arithmetic D. ASCII

Page 13 of 97
19. The command we will choose to convert a column of data into row is----
A. Cut and Paste B. Paste Special-Transpose C. Formatting D. Value
20. Shortcut ‘Ctrl+P’ is used for----
A. Open paragraph dialog box B. Open page format dialog box
C. Open save dialog box D. Open print dialog box
21. How do we test our Ethernet Connection?
Ans.
i. ফিফিক্যাল চেক্: Ethernet ক্যাবলফি সফিক্ভাবব সংযু ক্ত আবে ফক্না এবং LED লাইি অন আবে ফক্না তা ফনফিত
ক্রার মাধ্যবম।
ii. ফ ং চিস্ট: ক্মান্ড প্রম্পি বা িাফমিনাবল "ping" ক্মান্ড বযবহাবরর মাধ্যবম।
iii. চনিওযাক্ি চসফিংস রীক্ষা ক্রার মাধ্যবম।

22. What is Presentation Animation?

Ans. চপ্রবিবেশবন অযাফনবমশন বযবহাবরর মাধ্যবম আমরা আমাবের চপ্রবিবেশনবক্ আবরা আক্র্িণীয এবং
প্রভাবশালী ক্রবত াফর। অযাফনবমশন বযবহার ক্বর আমরা চিক্সি, েফব, োিি, এবং অনযানয মূ লযবান তথ্যগুফলর
উ র ধ্ারাবাফহক্ প্রভাব ততফর ক্রবত াফর।
23. What is Ribbon?
Ans. Ribbon হল এক্ফি গ্রাফিক্াল ইউিার ইোরবিস (GUI) যা মাইবরাসিি অফিস চপ্রাগ্রামগুফলর সাবথ্ সংযু ক্ত। এফি
চপ্রাগ্রাবমর শীর্িস্থানীয চমনু বাবরর উ র স্থা ন ক্রা হয, যাবত সহবিই ফবফভন্ন অ শন এবং ক্াযিক্াফরতা এবক্সস ক্রা যায।
24. What is Paper Jam?
Ans. চ ার িযাম হল ফপ্রোবরর চ াবরর অববধ্ বথ্, চ াবরর অববরাধ্ অবস্থা। এফি সাধ্ারণত এমন ঘিনা
যা চ ার ফপ্রোবরর ইন ু ি চে চথ্বক্ চ াবরর ফপ্রোবরর অনযানয অংবশ চ াবরর অববধ্ বথ্ েবল চেবে এবং
ফপ্রোবরর প্রবাহ বন্ধ হওযা।
25. What are main causes of OS failure?
Ans. হার্িওযযার সমসযা: অ াবরফিং ফসবস্টম চিইবলর এক্ফি সাধ্ারণ ক্ারণ হবলা হার্িওযযার ক্বম্পাবনেগুফলর ফবিলতা,
চযমন- হার্ি ড্রাইবভর অফিত্ব না থ্াক্া, চরাবক্ন র্যাম ইতযাফে।
সিিওযযার সমসযা: অ াবরফিং ফসবস্টবম সিিওযযাবরর চক্ান সমসযা থ্াক্বত াবর, চযমন- বাে, অসম্পূ ণি ইনস্টবলশন
ইতযাফে।

The candidate’s Underpinning knowledge was: Satisfactory ∎ Not yet Satisfactory ∎

Feedback to Candidate
The candidate’s overall performance was: Satisfactory ∎ Not yet Satisfactory ∎
Candidate’s Signature Date:

Assessor Signature Date:

Page 14 of 97
 Qualification
Candidate’s Name
Assessment Centre
Date of Assessment Model_Test 05
Put the (√) tick mark on the right answer:

1. Which feature usually used to create a 12. Times New Roman, Cambria, Arial are the
document like newspaper? example of -----------
A. Tab stopes B. Tables A. Themes B. Clipart
C. Columns D. Bullets & Numbering C. SmartArt D. Font Face
2. Using Find command in Word. We can 13. Which term is related with increasing or
search- decreasing the space between character?
A. Characters B. Format’s A. Page number B. Spacing
C. Symbols D. All C. Header D. Footer
3. What is the Function of the Ctrl+Z key? 14. What is the term used when you press and
A. Paste B. Copy hold the left mouse key and move the mouse
C. Undo D. Repeat around the slide?
4. The-----------function is used to send same A. Highlighting B. Dragging
letter to different recipient? C. Moving D. Sliding
A. Macros B. Template 15. Scanner is an example of
C. Mail Merge D. Biography A. Music Device B. Output Device
5. What is the following is not a type of page C. Input Device D. None of theme
margin? 16. Which option can be used to split windows
A. Right B. Left into two?
C. Center D. Top A. Review>Window
6. Which ribbon includes the command for B. View>Window>Split
inserting charts that illustrate or compare data? C. Window>Split
A. Draw B. Home D. View>Split
C. Insert D. Design 17. To view “Header & Footer”, user must switch
7. Work area on which computer Windows, to
Icons, Menus and Dialog box appear is called? A. Normal View
A Screen B. Desktop B. Print Layout View
C. Working area D. Frame C. Print preview mode
8. The result of a formula in a cell is the- D. Both B & C
A. Content B. Range 18. How we can put a Chart in the presentation
C. Value D. Label using Power Point?
9. In Excel, you can sum a large range of data by A. Insert>Pictures>Chart
simply selecting a tool button called_____ B. Edit>Chart
A. Auto Fill B. Auto Correct C. Insert>Chart
C. Auto Sum D. Auto Format D. View>Chart
10. What do you call the chart that show the 19. The word indicates the spelling error’s with
Proportions of how one or more data A. Blue Underline B. Green Underline
elements? C. Red Underline D. Black Underline
A. XY Chart B. Line Chart 20. How do you wrap the text in a cell?
C. Pie Chart D. Column Chart A. Format>Cell>Font
11. The default page setup orientation of slide in B. Format>Cell>Protection
PowerPoint is- C. Format>Cell>Number
A. Vertical B. Landscape D. Format>Cell>Alignment
C. Portrait D. None

Page 15 of 97
21. A6:A8 indicates: 23. If we want to repeat a row to the next page
A. Cells A6 and Cell A8 when printing in excel, we have to click----
B. Cells A6 through A8 A. Insert>Print Titles>Rows to repeat at top
C. Cells A7 only B. Page Layout>Print Titles> Rows to
D. All Cells except A6:A8 repeat at top
22. You can auto fit the width of column by C. View>Page Layout>Print Titles>Rows to
A. Double clicking on the column name on repeat at top
column header D. View>Rows to repeat at top
B. Double click on the cell pointer in 24. What are presentations?
worksheet A. A sequence of slides that usually
C. Double clicking on column right border incorporate text, sound, graphics, and
on column header animation.
D. Double clicking on the column left border B. A speech
on column header. C. Information presented using more text than
graphics and animation
D. A television interview or new report.

Short Question
25. How would you format a cell?
Ans. A cell can be formatted by using the format cells options.
26. Write down four words processing application Software?
Ans: i. MS Word ii. Notepad iii. Google Docs iv. Libre Office
27.What does the IF function in excel?
Ans: IF function is used in Excel to check whether certain conditions are true or false. If the condition is
true then it will give the result accordingly and if the condition is false the result or output will be
different.
[IF ফ াংশন এক্সেক্সে কিছু শর্ত সর্য ন কি কিথ্য র্ পরীক্ষ িরক্সর্ ব্যব্হ র ির হয়। িকিশন সর্য হক্সে সস অনু য য়ী ফে ফে
সেক্সব্ এব্াং শর্ত কিথ্য হক্সে ফে ফে ব্ আউটপু ট কিন্ন হক্সব্]
28. What is “Exit” effect in MS Power Point?
Ans: Exit animation effects determine how animated slide objects exits from the slide area.
29. What is diagnostic in computer?
Ans: A Hardware diagnostic is a method of finding problems with a computer’s hardware systems.
[এিটি হ র্তওয়য র র্ য় গনকিি এিটি িকিউট ক্সরর হ র্তওয়য র কসক্সিক্সির স ক্সথ্ সিসয খুুঁক্সে সব্র ির র এিটি পদ্ধকর্]
30. How do we identify our network switch is bad?
Ans: To verify that your switch is properly working, check the LED lights located at the back panel of
the device. They should be lit up to confirm that it is working. By performing a loopback test, you can
also confirm that the switch is working.
[আপন র সু ইচটি সঠিিি ক্সব্ ি ে িরক্সছ কিন র্ য চ ই িরক্সর্, কর্ি ইক্সসর কপছক্সনর পয ক্সনক্সে অব্কির্ LED ে ইটগুকে
পরীক্ষ িরুন৷ এটি ি ে িরক্সছ র্ কনকির্ ির র েনয র্ ক্সের আক্সে কির্ ির উকচর্।]

Page 16 of 97
 Qualification
Candidate’s Name
Assessment Centre
Date of Assessment Model_Test 06
Put the (√) tick mark on the right answer:
12. Computer mouse event is
1. Home Key use to moves the cursor beginning A. left click B. right click
of the___ C. double click D. all of these
A. Documents B. Paragraph 13. A BIT represents a
C. Screen D. Line A. Hexadecimal digit B. Octal digit
2. A character that is raise and smaller above the C. Decimal digit D. Binary digit
baseline is known as 14. Which of the following is not a storage media?
A. Subscript B. Superscript A. Email B. USB Pen drive
C. Strikethrough D. Raised C. Portable Hard Drive D. Optical Drive
3. What is the default number of lines to drop for 15. AutoCorrect was originally designed to
drop cap? replace___words as you type.
A. 2 B. 3 A. Short, repetitive
C. 4 D. 5 B. Grammatically incorrect
4. Which of the following option is not available C. Misspelled
in paste special dialog box? D. None of the above
A. Add B. Subtract 16. How do you rearrange the data in ascending or
C. Divide D. Sqrt descending order?
5. Within a cell long text can be broke into many A. Data>Sort B. Data>Form
lines. We can do this in excel through__ C. Data>Table D. Data>Subtotals
A. Ctrl+Enter B. Alt+Enter 17. Which option can be used to split windows
C. Shift+Enter D. Alt+Enter into two?
6. The result is a ___ value either TRUE or A. Review>Window B. View>Window>Split
FALSE. C. Window>Split D. View>Split
A. Logical B. Arithmetic 18. Want a PowerPoint album Slide show to play
C. Algorithm D. Logarithm continuously?
7. What type of chart will you use to compare A. use Random slide transitions
performance of sales of two products? B. Launch an online broadcast
A. Pie Chart B. Column Chart C. Loop continuously
C. Line Chart D. Bar Chart D. Run continuously
8. Which command brings you to the first slide 19. In order to edit a chart, you can___
in your presentation? A. Triple click the chart object
A. next slide button B. Page up B. Click and drag the chart object
C. Ctrl+Home D. Ctrl+End C. Double click the chart object
9. The arrangement of elements such as title and D. Click the chart object
subtitle text, pictures, tables etc. is called 20. When all the numbers between 33 and 100 in a
A. Layout B. Presentation range should be displayed in red color, apply_
C. Design D. Scheme A. Use = if () function to format the required
10. Which view helps to rearrange the slides numbers red
easily and quickly? B. Apply Conditional Formatting command
A. Notes page B. Slide master on Format menu
C. Slider Sorter D. Normal C. Select the cells that contain number
11. The main memory is also known between 33 and 100 then click Red color on
as___memory. Text Color tool
A. Auxiliary B. Permanent D. Use Review>Check Accessibly>
C. Secondary D. Primary Accept>rang 33 and 100

Page 17 of 97
 Qualification
Candidate’s Name
Assessment Centre
Date of Assessment Model_Test 07
Put the (√) tick mark on the right answer:

1. Write down the short command of center 11. The maximum zoom percentage in Microsoft
alignment. Power Point is____
A. Ctrl+E B. Ctrl+Z A. 100% B. 200%
C. Ctrl+R D. Ctrl+L C. 300% D. 400%
2. Which of the following is not a type of page 12. ___ allow communications between the user
margin? and the computer
A. Normal B. Narrow A. CPU B. I/O Devices
C. Moderate D. Middle C. Memory D. None
3. Superscript, subscript, outline, emboss, 13. What should be done before printing the
engrave are known as___ document in MS word?
A. font styles B. font effects A. Set the paper setting to the desired form
C. word art D. text effects B. See the print preview
4. What is the command on the Insert Ribbon C. Add Images
used to capture and insert a picture of any D. Both A & B
other open program window? 14. Formulas in Excel are made up of ___
A. Picture B. Screenshot A. Arithmetical Operation and functions
C. Shape D. Clipart B. Only arithmetic operators
5. What is the pictorial representation of C. Only symbols
worksheet data? D. Only functions
A. Chart B. Clipart 15. How do you wrap the text in a cell?
C. WordArt D. All of these A. Format>Cell>Font
6. - - - - - - cells involve creating a single cell by B. Format> Cell>Protection
combining two or more selected cells. C. Format>Cell>Number
A. Formatting B. Merging D. Format>Cell>Alignment
C. Embedding D. Splitting 16. How we can put a chart in the presentation
7. What do you call the chart that shows the using Power Point?
proportions of how one or more data elements A. Insert>Picture>Chart B. Edit>Chart
relate to another data element? C. Insert>Chart D. View>Chart
A. XY Chart B. Line Chart 17. Three main components of computer are
C. Pie Chart D. Column Chart A. CPU, Memory, Tape
8. The___feature of MS Excel quickly completes B. CPU, I/O, Memory
a series of data. C. Tape, I/O, Floppy Disk
A. Auto Feature B. Auto correct D. I/O, Printer, Mouse
C. Auto Fill D. Auto Series 18. Interface used by windows is called.
9. Special effects used to introduce slides in a A. Menu driven interface
presentation are called. B. Command driven interface
A. Effects B. Custom animations C. Graphical user interface
C. Transitions D. Present Animation D. Prompt interface
10. ___ are already created presentations on 19. In the context of animations, what is a trigger?
different topics. A. An action button that advances to the next
A. Templates B. Images slide
C. Video D. Design B. An item on the slide that performs an
action when clicked.
C. The name of a motion path
D. It is a rehearse timing

Page 18 of 97
20. How can you apply exactly the same tool on new place.
formatting you did to another text? C. select the text then click on Format
A. Copy the text paste in new location, then Painter and select the new text
type the new text again. D. select the text and click on Bold & Italic.
B. Copy the text and click on paste special
21. What is handout in Power Point?
Ans. In PowerPoint, a handout is a printed version of a presentation that provides slides in a format
suitable for distribution to an audience.
22. What is Freeze Panes in MS Excel?
Ans. Freeze Panes in MS Excel is a feature that allows you to lock specific rows or columns in place so
that they remain visible as you scroll through the rest of the worksheet.
23. What is Printer tonner?
Ans. Printer toner is a fine powder used in laser printers and photocopiers to form the text and images on
printed paper. The toner powder is made up of granulated plastic, carbon, and coloring agents that create
the print on the paper.
24. How do you free a paper jam?
Ans. ডিভাইসটি বন্ধ করুন, কাগজটি ড িঁ ড়ে না যাওযার জনয আড়ে কড়র টিড়ন টবর করুন এবং পুনরায চালু করার
আড়গ সমে টে ও টরালার পরীক্ষা করুন।
25. What is network switch?
Ans. A network switch is a hardware device that connects multiple devices on a computer network and
uses packet switching to forward data to its destination.

Page 19 of 97
Qualification Computer Operation, Level-III
Candidate’s Name
Assessment Centre UCEP Tongi
Date of Assessment Model: 08
1. In a computer spreadsheet, function which is used to count numbers of entries in given range is called
a) length B) Counter C) counting D) count
2. What is an Excel feature that displays only the data in column (s) according to specified criteria?
A) Filtering B) sorting c) Formula D) Pivot
3. A change in the appearance of a value or label in a cell.
A) Alteration B) Format C) Indentation D) Design
4. Which of this font of effects is NOT available in the Power Point Font dialogue box?
A) Shadow B) Underline C) Strikethrough D) Emboss
5. Which Types of templates provides all the users with a design concept, color scheme, and fonts for
presentation?
A) Content B) Format C) Normal D) design
6. Power Point presentations are widely used as:
A) Note outlines for teachers B) Project presentations by students
C) Communication of planning D) All of Above
7. What is a Motion path?
A) A type of animation entrance effect B) A method of advancing slides
C) A method of moving items on a slide D) All of above
8. What happens when you click on CTRL + X after selecting some cells in Excel?
A) The cell content of selected cells disappears from the cell and is stored in a clipboard
B) Value in the cells selected is marked for cutting
C) The selected cells are deleted and the cells are shifted left
D) The selected cells are deleted and cells are shifted up
9. A numeric data analysis tool that allows us to create a computerized ledger.
A) Word processing package B) Spreadsheet package
C) Graphics package D) Mathematical package
10. In Google sheet, columns are represented by _____
A) Numbers B) Letters C) letters and number D) cells
11. Which sign is used in the formula to use absolute reference?
A) Underscore (_) B) Dollar ($) C) Equal (=) D) Column (:)
12. Which feature allows you to narrow down the data in your worksheet?
A) Filters B) Reporting C) Sorting D) Statics
13. Which format represents the numbers with the dollars ($) sign? [ for example, $1,000.00]
A) Automatic B) Number C) Currency D) Time
14. A list of various coded instructions is known as:
A) Flowchart B) Utility programs C) Algorithm D) Computer program
15. What is a URL?
A) an acronym for Unlimited Resources for Learning
B) the address of a document or “Page” on the world Wide Web
C) a type of programming object D) a computer software program
16. Which of the following is not operating system?
A) UNIX B) MS- DOS C) CP/M D) PASCAL
17. Which is used to store firmware?
A) EPROM B) ROM C) RAM D) PROM
18. Documents can be ____ with MS Word.
A) Created B) Edited C) Saved D) All of the above
19. Which of the following tab is the default in MS Word?
A) Home B) Insert C) Page Layout D) Reference
20. Which of the following is automatically counted in MS Word?
A) Number of words B) Number of pages C) Number of Characters D) All of the above
21. Write down 4 (four) email service providers name?
Ans: G mail, Hot mail, yahoo mail, Outlook, icloud

Page 20 of 97
22. What is the difference between a file and a folder?
Ans:
• ফাইল হললা তলের ধারক, যেখালে নেনদ িষ্ট ডাটা থালক।
• যফাল্ডার হললা ফাইল এবং অন্যান্য যফাল্ডার রাখার জন্য একটি ধারক, ো ব্যবস্থাপো এবং সংগঠলের কাজ সহজ কলর।

23. What is system software?

Ans: নসলেম সফটওয়্যার হললা যসই সফটওয়্যার ো কনিউটালরর সানব িক কাে িক্রম নেেযন্ত্রণ ও পনরচালো কলর এবং অন্যান্য সফটওয়্যালরর জন্য
কাজ করার পনরলবশ ততনর কলর।

24. Write down 5(five) Antivirus name?

Ans: a. Panda, b. Norton, c. NOD32, d. AVG, e. AVAST.

25. What are the uses of NIC?

Ans: Network Interface Card (NIC) is used for connect to the internet.

26. Which Excel function removes the irregular spacing, leaving one space between each value?
Ans: =TRIM()

27. What does it mean to “install” software on a computer?

Ans: কনিউটালর সফটওয়্যার "ইেেল" করা মালে হল সফটওয়্যারটি যসটআপ কলর ব্যবহার উপলোগী করা।

28. What is a slide shorter view?

Ans: Slide Shorter view means all slide show at once.

29. What’s The default file extension of Power point files?

Ans: .pptx

30. Computer not getting internet connection, what to check?

Ans: Check the Ethernet Connection.

Page 21 of 97
 Qualification Computer Operation, Level-III
Candidate’s Name
Assessment Centre UCEP Tongi
Date of Assessment
Put the (√) tick mark on the right answer:
1. Which ribbon tab contains options related to font A. Normal View B. Slide Sorter View
formatting in Microsoft word? C. Slide Show View D. Notes Page View
A. Home B. Insert 11. How can you add a new slide in PowerPoint?
C. Review D. Page Layout A. Left-click and select “New Slide”
2. How can you insert a new page in the middle of an B. Press Ctrl+N
existing document in Microsoft Word? C. Use the insert tab and Click on “New Slide”
A. Press Enter until a new page appears D. Press F5
B. Use Ctrl+N 12. Which feature in PowerPoint allows you to rehears
C. Insert a page Break Option timings for your slide show?
D. Click on the page layout tab A. Slide Sorter
3. Which feature in Microsoft Word automatically B. Presenter View
corrects common spelling mistakes as you type? C. Animation Pane
A. Auto Format B. Auto Correct D. Slide show tab>Rehears Timings
C. Auto Complete D. Auto Save 13. What is the purpose of Slide Master in PowerPoint?
4. What is the function of the ‘Find and Replace’ A. To add animations to slides
feature in MS Word? B. to design and customize the appearance of all
A. It lets you search for specific words or phrases slides
and replace them with new ones C. to record narration for slides
B. It helps you format text in different fonts and D. To print handouts of the presentation
colors 14. Which feature in PowerPoint allows you to add
C. It allows you to insert images from you computer motion and visual effects to text or objects on slides?
D. It creates automatic backups of your document A. Slide Sorter B. Animation Pane
5. Which ribbon tab in MS Word contains option for C. Slide show view D. Presenter View
adjusting the margins and orientation of the 15. How can you start a PowerPoint slide show from the
document? beginning?
A. Home B. Insert A. Click on the slide sorter button
C. Page Layout D. References B. Press F5
6. What is the purpose of the ‘Track changes’ feature in C. Use the slide show tab and click on “Start Slide
MS Word? Show”
A. It allows you to insert comments into the D. Right click and select “Start from Beginning”
document 16. Which tab in Power Point allows you to insert
B. It keeps a record of all the changes made to the shapes, images, and other objects into slide?
document A. Design B. Slide Show
C. It automatically saves the document at regular C. Insert D. Home
intervals 17. How can you freeze the top row and the first column
D. It adjusts the spacing between lines of text. in Excel?
7. How can you insert a picture from your computer A. Use the Freeze Panes option under the View
into a MS Word document? tab
A. Go to the Home tab and click ‘picture’ B. Use the Split option under the Home Tab
B. Press Ctrl+P C. Use the Freeze Panes option under the Home Tab
C. Use the Insert tab and click on ‘pictures’ D. Use the Pivot Table option under the Insert Tab
D. Go to the View tab and click on ‘Layout’ 18. Which function in Excel is used to find the highest
8. Which file format is typically used for saving value in range of cells?
documents in MS Word to ensure compatibility with A. =MAX() B. =MIN()
older versions of Word? C. =SUM() D. =COUNT()
A. .docx B. .txt 19. How can you sort data in Excel in descending order
C. .pdf D. .doc based on a selected column?
9. How can you change the line spacing in MS Word A. Use the Sort Ascending option under the Data tab
document? B. Use the Sort Descending option under the Data
A. Use the page layout tab and adjust the spacing tab
option C. Use the Filter option under the Home tab
B. Press Shift+Enter D. Use Pivot Table option under the Insert tab
C. Use the Home tab and adjust the font size 20. The intersection of a column and row in a worksheet
D. Use the Insert tab and insert a text box is called____.
10. Which view in PowerPoint allows you to see A. Box B. Cell
multiple slides at once for editing purpose? C. Range D. Page Break

Page 22 of 97
 Written Question
21. What does the “Duplex” printing option allow you to do?
Ans: Print on Both Sides.
22. What is the purpose of a section break (Continuous) in a Word document?
Ans: Insert a section break and start a new section on the same page.
23. Which command is used to wrap text around an illustration or image?
Ans: Wrap Text.
24. What is Google Meet used for?
Ans: Google Meet অনলাইন মিটিং/মিমিও কনফারেন্স কোে জনয ব্যব্হাে কো হয়।
25. How do I Share my screen in Zoom?
Ans: Zoom-এ আপনাে মিন শেয়াে কেরে, মনরেে ধাপগুরলা অনু সেণ করুন:
১. মিটিংয়ে য োগ মিন:Zoom অযাপ ব্া ওরয়ব্সাইরে লগইন করে মিটিং শুরু করুন ব্া শকারনা মিটিংরয় শ াগ মিন।
২. “Share Screen” বোটযন মিক করুন:
মিটিংরয় শ াগ শিওয়াে পে, zoom উইরডাে মনরে একট সব্ু জ েরেে “Share Screen” ব্ােন শিখরে পারব্ন শসখারন মিক করুন।
৩. ো যে়েোর করযে চোন েো মনবব োচন করুন:
এেপে একট পপ-আপ উইরডা আসরব্ শ খারন আপনাে কমিউোরে শখালা থাকা মব্মিন্ন অযামিরকেন ব্া মিন শিখরে পারব্ন।
শ মিন ব্া মনমিি ষ্ট অযামিরকেন উইরডাট আপমন শেয়াে কেরে োন, শসট মনব্িােন করুন।
৪. “Share” বোটযন মিক করুন:
মনব্িােন কোে পে, উইরডাে মনরে িানমিরক থাকা “Share” ব্ােরন মিক করুন।
26. What is Utility tool or software? Given Example?
Ans: ইউটমিট টুি বো সফটও়েযোর হল এিন একট কমিউোে শরাগ্রাি া কমিউোরেে মসরেি পমেোলনা, েক্ষণারব্ক্ষণ, এব্িং কা িক্ষিো ব্ৃ মিে জনয ব্যব্হৃে
হয়। এগুরলা িূ লে অপারেটিং মসরেরিে অিংে মহরসরব্ কাজ করে, েরব্ কখনও কখনও আলািা সফেওয়যাে মহরসরব্ও ব্যব্হাে কো হয়।
27. What does Google Mean?
Ans: Google হরলা Google LLC শকািানী কেৃি ক তেমে একট সােি ইমিন।
28. What is the basic difference between Etiquette & Manner?
Ans: মেষ্টোচোর ব্লরে শব্াঝায় মনমিি ষ্ট পমেমিমেরে শ আেেণগুমল সিাজ ব্া সিংস্কৃমেে দ্বাো স্বীকৃে এব্িং রেযামেে। এট শব্মেেিাগ সিয় ব্াইরেে মনয়িগুমলে উপে
মিমি করে, া একট মনমিি ষ্ট পমেরব্ে ব্া অনু ষ্ঠারনে ররয়াজনীয়ো অনু ায়ী গঠন কো হয়।
উিাহেণস্বরূপ:
• অমফস ব্া শকান ফেিাল অনু ষ্ঠারন সঠিক শপাোক পো।
• কাউরক োাঁরিে উপামধ মিরয় সরবাধন কো।
• খাব্াে শেমব্রল ব্রস সঠিক মনয়ি শিরন খাওয়া।

ভদ্রেো: ব্লরে শব্াঝায় একজন ব্যমিে ব্যমিগে আেেণ, া োে মনরজে মেন্তািাব্না, িূ লযরব্াধ এব্িং অরনযে রমে শ্রিা রিেিন করে। এট অন্তমনিমহে িূ লযরব্ারধে
উপে মিমি করে এব্িং িানু রেে তিনমিন আেেরণ রমেফমলে হয়।
উিাহেণস্বরূপ:

• কাউরক ধনযব্াি ব্লা।

• ব্য়স্ক ব্া দুব্িল িানু েরক সাহা য কো।
• কাউরক কথা ব্লাে সিয় ব্াধা না শিওয়া।
29. Why is it necessary for employees to prove unbiased and objective information to clients?
Ans: একজন কিিোেীে জনয িারয়ন্টরিে রমে পক্ষপােহীন এব্িং মনেরপক্ষ েথয রিান কো গুরুত্বপূণি কােণ:
মবশ্বোস স্থোপন করো: পক্ষপােহীন ও মনেরপক্ষ েথয রিান কেরল িারয়ন্টো সিংিাে রমে আিা তেমে করে। োো িরন করে শ সিংিা োরিে সঠিক এব্িং সৎ েথয
মিরে, া িীর্িরিয়ািী সিকি গর়ে েু লরে সহায়ক।
যপেোিোমরত্ব বজো়ে রোখো: কিিোেীরিে কারজে িান এব্িং শপোিামেরত্বে িাপকাঠি হরলা মনেরপক্ষ েথয রিান কো। এট শিখায় শ োো ব্যমিগে
িোিে ব্া স্বারথিে ব্াইরে মগরয় েথয মিরে, া িারয়ন্টরিে সঠিক মসিান্ত মনরে সাহা য করে।
সঠিক মসদ্ধোন্ত গ্রহযে সহো়েেো: িারয়ন্টরিে সঠিক মসিান্ত মনরে মনেরপক্ষ এব্িং সঠিক েথয ররয়াজন। পক্ষপােহীন েথয না মিরল িারয়ন্টো িুল
মসিান্ত মনরে পারে, া িমব্েযরে ক্ষমে হরে পারে।
30. Mention the use of Snipping Tool.
Ans: Snipping Tool মিরয় আিো Screenshot মনরয় থামক।

Page 23 of 97
 Qualification
Candidate’s Name
Assessment Centre
Date of Assessment Model_Test 10
Put the (√) tick mark on the right answer:
1. Which one of the following is not the section 13. When you cut and paste something, it is
break option? temporarily transferred to____
A. Next Page B. Previous Page A. Another partition on the hard drive
C. Odd Page D. Even Page B. Virtual memory
2. Which of the following is not an essential C. Swap File
component to create mail merge? D. Clipboard
A. Main document B. Data Source 14. Which of the following do we use to change
C. Merge fields D. Word fields margins?
3. Which of the following keyboard command is A. Formatting toolbar
used to increase font size by 1 point? B. Page setup dialog box
A. Ctrl++ B. Ctrl+] C. Standard toolbar
C. Ctrl+[ D. Ctrl+- D. Paragraph dialog box
4. Which bar show the used formula of selected 15. The clock rate of a processor is measure in
active cell? A. Megahertz or gigahertz
A. Formula bar B. Ribbon B. Nanoseconds
C. Menu bar D. Scroll bar C. Micro hertz
5. One of the text functions, to join two or more D. Milliseconds
text strings into one string 16. Ctrl+Alt+Del is
A. CONCATENATE B. COUNTA A. an invalid key combination
C. COUNT D. INT B. recognized by windows only
6. To select the entire column, press C. used to close the active window
A. Tab+C B. Tab+E D. used to refresh a program
C. Alt+Space D. Ctrl+Space 17. In Microsoft Power Point, two kinds of sound
7. In Excel, Columns are labelled as effects files that cab be added to the
A. A, B, C B. 1, 2, 3 presentation is____
C. A1, B1, C1 D. A1:C1 A. .jpg files and .gif files
8. Which of the following sections does not exist B. .wav files and .jpg files
in a slide layout? C. .wav files and .gif files
A. Ctrl+N B. Ctrl+K D. .wav files and .mid files
C. Ctrl+Z D. Ctrl+Y 18. To create and ID card sing word processing
9. Which of the following sections does not exist software. Which is most important?
in a slide layout? A. Insert & Modify shape
A. Titles B. Lists B. Page Layout
C. Charts D. Animations C. Insert Header & Footer & modify them
10. Which of the following provides a printed D. Insert and Modify picture
copy of your presentation? 19. If you need to remove only the formatting
A. Outline B. Speaker notes done in a range (numbers and formula typed
C. Audience Handouts D. All there should not be removed), you must-
11. ______refers to forward the object one level A. From Edit menu choose clear>Format
or to the front of all objects. B. From Edit menu choose delete
A. Bring to front B. Rotate C. Click on Remove Formatting tool on
C. Send to back D. Align Standard Toolbar
12. Which of the following is not an example of D. Double click on the Format Painter> Press
application software? Esc key.
A. Adobe Photoshop B. Linux
C. MS Word D. MS Excel

Page 24 of 97
20. What does COUNTA() function do? C. Count cells having number
A. Counts cells having alphabets D. Count non-empty cells
B. Counts empty cells

21. What are charts in MS Excel?

Ans: Chats are used to enable graphical representation of the data in MS Excel. A user can use any chart
type, including Column, Bar, Line, Pie, etc by selecting an option from Insert Tab.

22. What is animation pane in PowerPoint?

Ans: The Animation Pane is a tool that displays the list of animated objects on your slide. It allows you
to look at and manage all the effects that are on the present slide.
[অ্যানিমেশি প্যাি হল একটি টুল যা আপ্িার স্লাইমে অ্যানিমেমটে বস্তুর তানলকা প্রদশশি কমর । এটি আপ্িামক বতশ োি স্লাইমে
থাকা সেস্ত প্রভাবগুনল দদখমত এবং প্নরচালিা করমত দদয়]

23. What causes print failure?

Ans: Common factors include Driver Problems, Software Issues, Hardware Failures and Overuse

24. When should I replace toner?

Ans: ***we should start paying close attention to our printer once its toner lebels reach about 10%. This
means looking for those too-light print jobs or low toner alerts while regularly checking printer status
pages.
*Faded Printouts: If your printouts appear faded or lighter than usual, it's often a sign that the toner
cartridge is running low or needs replacement.
*Visible Toner Level: Some toner cartridges have transparent or translucent panels that allow you to
visually inspect the toner level. If you can see that the toner is low or depleted, it's time to replace the
cartridge.
[*** আোমদর নপ্রন্টারটির দটািার দলমবল প্রায় 10% এ দপ্ ৌঁছামল তার প্রনত গভীর েমিামযাগ দদওয়া শুরু করা উনচত। এর
অ্থশ হল নপ্রন্টার স্ট্যাটাস প্ৃ ষ্ঠাগুনল নিয়নেত দচক করার সেয় খু ব হালকা নপ্রন্ট জব বা কে দটািার সতকশ তাগুনল সন্ধাি করুি৷
*নববর্শ নপ্রন্টআউট: যনদ আপ্িার নপ্রন্টআউটগুনল স্বাভানবমকর দচময় নববর্শ বা হালকা দদখায় তমব এটি প্রায়শই একটি নচহ্ন দয
দটািার কাটিশজ কে চলমছ বা প্রনতস্থাপ্মির প্রময়াজি।
* দৃশযোি দটািার স্তর: নকছু দটািার কাটিশমজ স্বচ্ছ বা স্বচ্ছ প্যামিল রময়মছ যা আপ্িামক দটািার স্তরটি দৃশযত প্নরদশশি করমত
দদয়। আপ্নি যনদ দদখমত প্াি দয দটািারটি কে বা ক্ষয় হময়মছ, তমব এটি কাটিশজ প্রনতস্থাপ্ি করার সেয়।]

25. How do we identify our network switch is bad?

Ans: To verify that your switch is properly working, check the LED lights located at the back panel of
the device. They should be lit up to confirm that it is working. By performing a loopback test, you can
also confirm that the switch is working.
[আপ্িার সু ইচটি সঠিকভামব কাজ করমছ নকিা তা যাচাই করমত, নেভাইমসর নপ্ছমির প্যামিমল অ্বনস্থত LED লাইটগুনল
প্রীক্ষা করুি৷ এটি কাজ করমছ তা নিনিত করার জিয তামদর আমলানকত করা উনচত]

Page 25 of 97
 Qualification
Candidate’s Name
Assessment Centre
Date of Assessment Model_Test 11

1. What does a computer’s RAM (Random Access Memory) primarily do?

A. Stores permanent data B. Stores temporary data for current tasks
C. Controls input and output devices D. Displays Graphics on the screen
2. What is the function of an operating system (OS) a personal computer?
A. Displays images and videos B. Stores documents and files
C. Manages hardware and software resources D. Connects to the Internet
3. Which of the following is NOT a type of computer operating system?
A. Windows B. iOS
C. Android D. Microsoft Office
4. What is the purpose of using a function like “VLOOKUP” in excel?
A. To create a chart or graph
B. To search for a value in the first column of a range and return a value in the same row from another
column.
C. To protect the worksheet from unauthorized access
D. To insert a new worksheet into the workbook
5. How can you freeze panes in excel?
A. Go to the View tab and click on Freeze Panes
B. Right click on the row or column you want to freeze and select Freeze panes
C. Press CTRL+F
D. Apply a filter to the data range.
6. What is a chart in Excel used for?
A. Sorting data in a worksheet B. Creating visual representation of data
C. Printing the worksheet D. Protecting cells from editing
7. What is the purpose of sorting data in excel?
A. To delete unwanted data
B. To insert new data
C. To arrange data in ascending or descending order based on criteria
D. To create formulas
8. Which is not a data type in excel?
A. Date B. Percentage
C. Number D. Rank
9. Which of the following formulas will excel not be able to calculate?
A. =SUM(Sales)-A3 B. =SUM(A1:A5)*5
C. =SUM(A1:A5)/(10-5) D. =SUM(A1:A5)-10
10. How do you rearrange the data in ascending or descending order?
A. Data>Sort B. Data>Form
C. Data>Table D. Data>Subtotal
11. What type of chart will you use to compare the sales performance of two product?
A. Pie chart B. Column Chart
C. Line Chart D. Bar Chart
12. Which is a valid file format in PowerPoint?
A. .pptx B. .pdf
C. PowerPT D. .docx
13. We can check spelling and grammar error by pressing _____in MS word?
A. Shift+F7 B. Ctrl+F7
C. Alt+F7 D. F7
14. Which term is related with increasing or decreasing the space between character?
A. Page Number B. Spacing
C. Header D. Footer
15. What is a motion path in Power Point?
A. A method of moving items on a slide B. A type of animation entrance effect
C. A method of advancing slide D. Type of master sliding
16. Which one of the bellow is an example of an Absolute Address?
A. &A&5 B. =A5
C. A$5$ D. $A$5

Page 26 of 97
17. What is the purpose of a web browser?
A. To create documents B. To send emails
C. To browse websites D. To play games
18. What is the purpose of a search engine?
A. To browse websites B. To send emails
C. To find information on the web D. To create documents
19. What is the purpose of defragmenting a hard drive?
A. To clean up temporary files B. To organize fragmented data
C. To update software drivers D. To install antivirus updates
20. What does the Windows Task Manager allow you to do?
A. Manage installed programs
B. Monitor system performance and close unresponsive applications
C. Update device drivers
D. Clean up disk space
21. What does the term “Hardware” refer to in computing?
Ans: কম্পিউটার হার্ডওয়্যার বা কম্পিউটার যন্ত্াাংশসামগ্রী হল কম্পিউটাররর সসইসব অাংশ সযগুরলা স্পশ করা
ড
যায়্ ও সেখা যায়্ সযমন মননটর, মাউস, সকনসাং, মাোররবার্ড, রম, নসনর্, নর্নিনর্, ইত্যানে।
22. Write down 4 basic formulas in excel?
Ans:
a. =SUM(A1:A6)
b. =AVERAGE(A1:A6)
c. =MIN(A1:A6)
d. =MAX(A1:A6)
23. What is a word Processor?
Ans: Word Processor হরলা সকান র্কুরমন্ট সুন্দর িারব ত্থ্যরক উপস্থাপন করার সরাগ্রাম/ সফটওয়্যার। সযমন:
MS Word, Google Docs, Apple Pages, etc.
24. Write down the name of one web browser?
Ans: Google Chrome, Mozila Firefox.
What is the purpose of using Headers and Footers in a document?
Ans: পৃষ্ঠার শুরুরত্ মার্জডন লাইরনর উপরর পৃষ্ঠার নশররানাম/রপইজ নাম্বার/ফাইল পাথ্ রেশনড করারনার জনয

Page 27 of 97
 Qualification
Candidate’s Name
Assessment Centre
Date of Assessment Model_Test 12

1. What is the standard unit of Font size? 7. Each excel file is a workbook that contains
A. Centimeters B. Bytes different sheet. Which of the following cannot
C. Points D. Inches be a sheet in workbook?
2. We can check spelling and grammar error by A. Work sheet B. Chart sheet
pressing C. Macro sheet D. Data sheet
A. Shift + F7 B. Ctrl + F7 8. Which of the following can you use to add
C. Alt + F7 D. F7 time to the slides in a presentation?
3. Which option is used to remove the unwanted A. Slice Show Menu
part of an image? B. Rehearse timing button
A. Delete B. Remove C. Slide transition button
C. Crop D. Remove Background D. Custom Slide Show
4. Which of the following file used to start MS 9. Objects on the slide that hold text are called
words? A. Placeholders B. Object holders
A. Winword.exe B. word.exe C. Auto layouts D. Text holders
C. Msword.exe D. Word356.exe 10. ___is widely used by banks to process cheques
5. Which one is a function? A. OMR B. Touch screen
A. Average B. Accounting C. OCR D. MICR
C. Number D. Currency
6. The example of Logical operator is…………
A. Or B. Equal
C. Division D. Less Than

Please Write Answer

11. Write down the types of page orientation?
Ans: Landscape & Portrait.
12. What is the short cut key to insert a page break?
Ans: Ctrl+Enter
13. What are cells?
Ans: The area where data is stored in known as Cell. [সেলের সে অংলে সেটা েংরক্ষণ করা হয় তালক
সেে বো হয়]

14. Why COUNT function use in excel?

Ans: COUNT is used to count cells containing numbers, dates, etc. any value stored as number
excluding blanks.
[COUNT নম্বর, তাররখ, ইতযারি েম্বরেত কক্ষ গণনা করলত বযবহৃত হয়। ফাাঁকা স্থান বযতীত েংখযা রহোলব
েংররক্ষত সেলকালনা মান।]

15. What are the advantages of using formula in Excel sheet?

Ans: Formula makes it easy to calculate the numbers in Excel sheet. It also calculates automatically the
number replaced by another number or digit. It is used to make complex calculations easy.
[ফরমুো এলেে েীলট েংখযা গণনা করা েহজ কলর সতালে। এটট স্বয়ংক্রিয়ভালব অনয েংখযা বা অঙ্ক
দ্বারা প্ররতস্থারিত েংখযা গণনা কলর। এটট জটটে গণনা েহজ করলত বযবহৃত হয়]

Page 28 of 97
16. What do you understand by motion path in PowerPoint?
Ans: A motion path is a method of moving objects on a slide. PowerPoint allows its users to add motion
to an object in the slide. We can add motion to an object from the animation tab by selecting an object.
[একটট সমােন িাথ একটট স্লাইলে বস্তু েরালনার একটট িদ্ধরত। িাওয়ারিলয়ন্ট তার বযবহারকারীলির
স্লাইলে একটট বস্তুর গরত সোগ করার অনুমরত সিয়। আমরা অযারনলমেন টযাব সথলক একটট বস্তু রনবাচন
ব
কলর একটট বস্তুর গরত সোগ করলত িারর।}
17. What do you understand by trigger in context of animation?
Ans: Trigger is an action or cell it as an event that performs on the slides when clicked. It comes under
the advanced animation category.
[টিগার হে একটট অযাকেন বা এটটলক একটট ইলভন্ট রহোলব সেে ো রিক করার েময় স্লাইলে েঞ্চারেত
হয়। এটট Advance Animation রবভালগর অধীলন আলে]

18. What is entrance effect in MS PowerPoint?

Ans: Entrance effects control the way objects appear on your slide.

19. In computer, GUI stands for

Ans: Graphical User Interface.

20. What is a folder in computer?

Ans: In computers, a folder is the virtual location for applications, documents, data or other sub-folders.

21. What is an Icon?

Ans: An icon is a small graphical representation of a program, feature, or file.

22. What causes boot failure on device?

Ans: The reason of boot failure our machine can’t find the operating system and therefore, is unable to
boot.
[বুট বযথতার
ব কারণ আমালির সমরেন অিালরটটং রেলেম খুলাঁ জ িায় না এবং তাই, বুট করলত অক্ষম।]

23. What is device driver?

Ans: A driver, or device driver, is a set of files that tells a piece of hardware how to function by
communicating with a computer’s operating system.
[একটট ড্রাইভার, বা রেভাইে ড্রাইভার হে ফাইেগুরের একটট সেট ো কম্পিউটালরর অিালরটটং
রেলেলমর োলথ সোগালোলগর মাধযলম কীভালব কাজ করলত হয় তা হােবওয়যালরর একটট অংেলক বলে
সিয়।]

24. How do we test our Ethernet connection?

Ans: Control Panel>Network and Internet>Network Connections.

25. __________software packages allow the user to manipulate numbers.

Ans: Spreadsheet.

Page 29 of 97
Name of Candidate
Assessment Center
Date of Assessment Model Test 13

1. _________is used to display values in ascending or descending order.

a) Filtering b) Shorting
c) Numbering d)Formatting
2. When we want to scroll down the worksheet, and lock heading rows is place. So it is always
visible, we can use_________ command.
a) Freeze pane b) View heading row
c) View Ruler d) Split windows
3. Process of touching an object with computer mouse pointer is called –
a) Pausing b) Dropping
c) Pointing d) Hovering
4. Which of the following sections does exist in a slide layout?
a) Titles b) Lists
c) Charts d) Animations
5. The space between the margin and the start of a paragraph is called_________
a) Blank space b) Positive space
c) Negative space d) Indentation
6. What is the shortcut Key for creating hyperlink?
a) Ctrl+N b) Ctrl+K
c) Ctrl+Z d) Ctrl+Y
7. Auto Correct was originally designed to replace_______ words as you type.
a) Misspelled b) Short, repetitive
c) Grammatically incorrect d) None of this
8. _______ Excel function returns TRUE or FALSE based on two or more conditions.
a) = AVERAGEIFS b) = COUCAT
c) = COUNTA d) = AND
9. Which ribbon tab in MS word contains options for adjusting the margins and orientation of
the document?
a) Inset b) Home
c) Page Layout d) References
10. What is the purpose of Slide Master in PowerPoint?
a) To add animations to slides
b) To design and customize the appearance of all slides
c) To record narration for slides
d) To record endnote for slides

Page 30 of 97
11. Which types of templates provides all the users with a design concept, Scheme, and fonts for
presentation?
a) Content b) Normal c) Format d) Design
12. If you want to place a word with a character that is raised and smaller above the baseline
which one of the bellow you have to perform?
a) Subscript b) Superscript
c) Strikethrough d) Raised
13. What is the advantage of saving a document in the “RTF” (Rich Text Format) file format?
a) It supports macros and automation b) It reduces the file size
c) It preserves complex formatting d) It allows password protection
14. What is the function of the “Find and Replace” feature in MS Word?
a) It helps you format text in different fonts and colors.
b) It lets you search for specific words or phrases and replace them with new ones.
c) It allows you to insert images from your computer
d) It creates automatic backups of your document
15. Which feature allows you to narrow down the data in your worksheet?
a) Filters b) Sorting c) Reporting d) Statics

16. What is the purpose of the "Track Change" feature in MS Word?

a) It allows you to insert comments into the document
b) It keeps a record of all the changes made to the document
c) It automatically saves the document at regular intervals
d) It adjusts the spacing between lines of text
17. What is motion path?
a) A type of animation entrance effect b) A method of advancing slide
c) A method of moving item on a slide d) All of above
18. In Google sheet, columns are represented by_______.
a) Numbers b) Letters c) Letters and Numbers d) Cells

19. Document can be________ with MS Word.

a) Created b) Edited c) Saved d) All of above

20. Which feature in PowerPoint allows you to add motion and visual effects to Text or object on
slide?
a) Slide Sorter b) Animation c) Slide show view d) Presenter View

21. How can you freeze the top row and the first column in Excel?
a) Use the Freeze Panes options under the View tab

Page 31 of 97
 b) Use the Split option under the Home tab
c) Use the Freeze Panes option under the Home tab
d) Use the Freeze Panes option under the Format tab
22. How can you insert a new page in the middle of an existing document in Microsoft Word?
a) Press Enter until a new page appears b) Click on the Page Layout tab
c) Use Ctrl + N d) Insert a Page Break
23. Which is used to store firmware?
a) EPROM b) ROM c) PROM d) RAM

24. A_______ is a central device that divides a network connection among several devices.
a) Switch b) Hub c) Router d) Modem

25. Which sign is used in the formula to use absolute reference?

a) Underscore (_) b) Equal (=) c) Dollar ($) d) Clone (:)

Write short answer of the following question

26. What do you mean by Unicode?
এটি একটি সার্বজনীন ককাট িং র্যর্স্থা যা প্রটিটি অক্ষরকক একটি অননয ককা প্রদান ককর, ভাষা র্া প্ল্যািফর্ব
টনটর্বকেকষ।
27. What does the “Collate” option in printing settings do?
প্রিপ্রটিং সেট িংসে "Collate" অপশনট প্রনর্ারণ
ধ কসর সে একট ডকুসেসটর একাপ্রর্ক কপ্রপ সকান ক্রসে প্রিট
হসে।
Collate চালু থাকসল প্রিটার েম্পূণ সে
ধ আকাসর ডকুসেট প্রিট কসর (সেেন, ১, ২, ৩; ১, ২, ৩; ১, ২, ৩)।
Collate েন্ধ থাকসল প্রিটার িপ্রিট পৃষ্ঠাসক গ্রুপ আকাসর প্রিট কসর (সেেন, ১, ১, ১; ২, ২, ২; ৩, ৩, ৩)।

28. Write down 3 (Three) email service providers name?

• Gmail
• Hotmail
• Yahoomail
29. Write down 3 Antivirus Software name?
• AVG
• Avast
• Panda
30. What is Google Docs?
Google Docs একটি Online টভটিক Word Processing Software. যা র্যর্হারকারীকদর অনলাইকন কুকর্ন্ট
তিটর, সম্পাদনা এর্িং কেয়ার করার সু কযাগ কদয়।

Page 32 of 97
 Qualification Computer Operation, Level-III
Candidate’s Name
Assessment Centre
Date of Assessment Model-14

1. Which is not an edition of MS Word? 11. Which keyboard shortcut is used to easily
A. MS Word 2019 B. MS Word 2010 switch open workbooks?
C. MS Word 2007 D. MS Word 1206 A. Alt+S B. Ctrl+S
2. Which tab do you use to change the page C. Ctrl+Alt D. Ctrl+Tab
orientation in MS Word 12. The placement of information within a cell at
A. Home B. Insert the left edge, right edge, or center is:
C. Design D. Layout A. Indentation B. Placement
3. From which menu tab a new document is C. Identification D. Alignment
created 13. In a computer spreadsheet, the tool used to
A. Home B. File tab construct formulas is called
C. Insert tab D. Layout tab A. Formula Bar B. Filter
4. What is the purpose of the ‘Styles’ feature in C. Auditing Toolbar D. Format Painter
MS Word? 14. What is the maximum number of slides you
A. To Check Spelling can add in a PowerPoint Presentation?
B. To format text consistently A. 100 B. 250
C. To save document C. 500 D. No limit
D. To insert images 15. Which of these sections does a slide layout
5. How to adjust the width of a column NOT Have?
automatically in a table to fit the content? A. Lists B. Animations
A. AutoFit B. Slit Cells C. Titles D. Charts
C. Merge Cells D. Table Tools 16. Which in the default PowerPoint standard
6. Which command is used to apply a consistent layout?
format to multiple text selections? A. Blank B. Title slide
A. Format Painter B. Styles C. Title only D. Comparison
C. Text Effects D. Font 17. View displays the text of the slide only?
7. Which MS word feature helps to prevent A. Bullet view B. Notes view
accidental changes to a document? C. Text view D. Outline View
A. Protect Document B. Track Changes 18. Which one of the following is a free e-mail
C. Password Protect D. Restrict Editing service Provider?
8. How to insert a page break in MS Word? A. Foxit PDF editor
A. Insert>Page Break B. Gmail
B. Layout>Breaks>Page Break C. Safari
C. Home>Breaks>Page Break D. None of the above
D. Insert>Break>Page Break 19. Which one of the following is used for file
9. The Greater Than sign (>) exemplifies compression?
a/an_____Operator. A. Google Chrome B. Winzip
A. Arithmetic B. Conditional C. 7-Zip D. Both B & C
C. Logical D. Greater 20. Which one of the following is an online
10. ____ is not a function in Excel. meeting platform?
A. SUM B. MIN A. Zoom
C. SUBTRACT D. MAX B. Google Meet
C. Both A & B
D. None of the Above

Page 33 of 97
21. What is the purpose of the ‘Mail Merge’ feature?
Answer: To create Personalized letter or labels.

22. Explain how to use the ‘Format Painter’ tool?

Answer: Select text, Go to Home > Format Painter, select the text where the format to be applied.

23. What is the function of the ‘Page Break’ feature?

Answer: Page breaks are used to end a page without filling it with text.

24. What is the COUNT() function in excel normally used for?

Answer: The COUNT() is generally used to count a range of cells containing number or dates excluding
blank cells and text.

25. Which Excel function removes the irregular spacing, leaving one space between each value?
Answer: The = TRIM function in excel is used to remove irregular spacing leaving one space, leaving
one space between each value.

26. Why is the “wrap text” feature used in MS Excel?

Answer: The ‘wrap Text’ function in MS Excel Is used to break down lengthy text into multiple lines by
increasing the row height, ensuring complete visibility of the content.

27. Which Command is used to bring the user directly to the first slide of the presentation?
Answer: Ctrl + Home command to directly take you to the first slide of the Power Point Presentation.

28. Why transition is useful in PowerPoint?

Answer: The purpose of applying transition in PowerPoint is to make presentations more engaging and
professional by creating a smoother flow between slides.

29. How to change the date & time of the system?

Answer: Go to Setting > Time & Language and change the date & time.
Or, go to Control Panel > Date and Time to change the date & time.

30. Write 3 Operating System Software names.

Answer: Windows 11, MacOS, Ubuntu (Linux)

Page 34 of 97
 Microsoft Word
Job Sheet – 1 for Computer Operation, Level – 3

Candidate Name:

Job 01: Prepare a document as per specification using word processing software
Time: 1 Hour
Unit Covered: OU-ICT-CO-01-L3-V1: Operate a Personal Computer
OU-ICT-CO-02-L3-V1: Prepare a Document Using Word Processor
Instructions:
Read and understand the directions carefully:
▪ this practical demonstration is based on the performance criteria from all or some of the units of
competency in Computer Operation, Level – 3
▪ this assessment activity will be used to measure your underpinning skills
▪ you will have fifteen (15) minutes to familiarise yourself with the resources to be used
Working Procedure/ Steps:
1. Observe and wear personal protective equipment (PPE) as required for the Job.
2. Observe and follow Occupational Health and Safety (OHS) requirements during the
demonstration processes.
3. Read the provided Job and Specification sheet.
4. Collect required tools, materials, and equipment for the job.
5. Prepare PC to perform job smoothly.
6. Create a folder named “NSDA_Reg. no.” (except C drive).
7. Save the file with your “Registration No and name” into folder created by you.
8. Perform the Job within the given time as per Sample and specification sheet.
9. Check and review after completion of the job.
10. Save the document with both .doc. and .docx extension.
11. Apply mail merge (for 2nd page) to invite 5 recipients and prepare “finish and merge” for print
in PDF.
12. Print the document using PDF printer or document writer in PDF considering A4 size paper.
13. Submit finished output to the Competency Assessor.
14. Shutdown computer and clean your workplace.
15. Clean tools, equipment, materials, and work area.

Page 35 of 97
 Specification Sheet – 1 for Computer Operation, Level – 3

Job 01: Prepare a document as per specification using word processing software

Condition For the Job:

Work must be carried out in a safe manner and according to Computer operation (Level – 3) standards.

Page Layout (for both page)

Page size: A4
Number of Column – 2 (use as per sample for 1st page only)
Page orientation – 1st page: Portrait; 2nd page: Landscape
Footer – “File path/ Location of your file” (Only in 2nd page); Position: Left side
Page number – Position: Right side (Only in 2nd page)

English Part (1st Page)

Photograph
Shape – Round
Size – 1.78 inch x 1.78 inch
Border width – 6 pt

Shape (at the top part) – Rounded rectangular

Shape size – 6.48 inch x 2.05 inch

Text
Font Alignment Line spacing
Font – Tahoma As per sample Multiple at 1.6
Size for title (Name) – 36
Size for Sub Title – 14
Size for others Text – 13

Bangla Part (2nd Page)

Text
Font Alignment Line spacing
Font – Unicode (Nikosh) As per sample Multiple at 1.3
Font Size – 14

Mail merge
Fields to mail merge: 1. Name, 2. e-mail, 3. District, and 4. Mobile Number.
Resources Required:

Tools, Equipment and furniture: 1. Personal Computer – 1 set

2. Ergonomic Chair – 1 Pc

Software: 1. Operating software – Windows

2. Application software – Word processor
3. Bangla typing software – Bijoy/Avro

PPE: 1. Rubber sole Shoes/Sandal – 1 pair

Page 36 of 97
 Jannatul Naima
ail ID: test@example.com
Website: www.example.com
Address: BIDA Bhaban, Agargaon, Dhaka

Career Objective: Experience:

To work in the of different
national and International 1. Experience 1: Computer Operator in ABC Company from
UN Organization NGOs or 12 January 2018 to till date.
other similar who are ➢ Job Responsibilities are
operating sectors of ➢ Job Responsibilities are
Bangladesh, and grow
rapidly increasing 2. Experience 2: Computer Operator in XYZ Company from
responsibilities. 31 December 2017 to till date.
➢ Job Responsibilities are …..
➢ Job Responsibilities are …..

Education Background:

Sl Board/ Passing
Exam Name Result
No. University Year
01 HSC 2016 4.60
Jashore
02 SSC 2014 4.00

Computer Skills Personal Information:

❖ Microsoft Office
❖ Windows Date of Birth : 14/02/1999
❖ Internet NID Number : 1001341781
❖ Game Marital Status : Married
Sex : Male
Birth Place : Kushtia

Page 37 of 97
প্রাপক:

<<নাম>>
<<জেলা>>
<<জমাবাইল>>
<<ই-জমইল>>

সুধী, োতির তপিা বঙ্গবন্ধু জেখ মুজেবুর রহমান এঁর স্বপ্নের জসানার বাাংলা তবতনমাপ্নে
ম মাননীয় প্রধানমন্ত্রী জেখ হাতসনার
তনপ্নদম েনায় োিীয় দক্ষিা উন্নয়ন কিতপ ম ক্ষ (এনএসতিএ) জদপ্নের আর্-সামাজেক
ম উন্নয়ন ত্বরাতিি করার লপ্নক্ষে দক্ষ
মানবসম্পদ তিতরপ্নি কাে করপ্নে।

এ লপ্নক্ষে আগামী এনএসতিএ কিতক

ম “ICT Freelancing in Bangladesh: Present Status, Challenges and Opportunities"
েীর্কম একটি জসতমনার আপ্নয়ােন করা হপ্নয়প্নে। উক্ত জসতমনাপ্নর মাননীয় প্রধানমন্ত্রীর জবসরকাতর তেল্প ও তবতনপ্নয়াগ
উপপ্নদষ্টা েনাব সালমান ফেলুর রহমান, এমতপ মপ্নহাদয় প্রধান অতিতর্ তহপ্নসপ্নব উপতিি র্াকপ্নি সানুগ্রহ সম্মতি
জ্ঞাপন কপ্নরপ্নেন।
উক্ত জসতমনাপ্নর আপনার সানুগ্রহ উপতিতি কামনা করতে ।

তনবাহী
ম জেয়ারমোন (সতেব)
এনএসতিএ

Page 38 of 97
 Job Sheet – 2 for Computer Operation, Level – 3

Candidate Name:

Job 01: Prepare a document as per specification using word processing software
Time: 1 Hour
Unit Covered: OU-ICT-CO-01-L3-V1: Operate a Personal Computer
OU-ICT-CO-02-L3-V1: Prepare a Document Using Word Processor
Instructions:
Read and understand the directions carefully:
▪ this practical demonstration is based on the performance criteria from all or some of the units of
competency in Computer Operation, Level – 3
▪ this assessment activity will be used to measure your underpinning skills
▪ you will have fifteen (15) minutes to familiarise yourself with the resources to be used
Working Procedure/ Steps:
16. Observe and wear personal protective equipment (PPE) as required for the Job.
17. Observe and follow Occupational Health and Safety (OHS) requirements during the
demonstration processes.
18. Read the provided Job and Specification sheet.
19. Collect required tools, materials, and equipment for the job.
20. Prepare PC to perform job smoothly.
21. Create a folder named “NSDA_Reg. no.” (except C drive).
22. Save the file with your “Registration No and name” into folder created by you.
23. Perform the Job within the given time as per Sample and specification sheet.
24. Check and review after completion of the job.
25. Save the document with both .doc. and .docx extension.
26. Apply mail merge (for 2nd page) to invite 5 recipients and prepare “finish and merge” for print
in PDF.
27. Print the document using PDF printer or document writer in PDF considering A4 size paper.
28. Submit finished output to the Competency Assessor.
29. Shutdown computer and clean your workplace.
30. Clean tools, equipment, materials, and work area.

Page 39 of 97
 Specification Sheet – 2 for Computer Operation, Level – 3

Job 01: Prepare a document as per specification using word processing software.

Condition For the Job:

Work must be carried out in a safe manner and according to Computer operation (Level – 3) standards.

Page Layout (for both page)

Page size: A4
Number of Column – 2 (use as per sample for 1st page only)
Page orientation – 1st page: Portrait; 2nd page: Landscape
Footer – “File path/ Location of your file” (Only in 2nd page); Position: Left side
Page number – Position: Right side (Only in 2nd page)

English Part (1st Page)

Photograph
Shape – Round
Size – 1.62 inch x 1.62 inch
Border width – 6 pt

Shape (at the top right and bottom left part ) – Use rectangular shape with02 (Two) separate color
Text
Font Alignment Line spacing
Font – Tahoma As per sample Multiple at 1.3
Size for title (Name) – 34
Size for Sub Title – 14
Size for others Text – 13

Bangla Part (2nd Page)

Shape size
Shape size – 3.3 in x 4.15 in and 6.25 in x 4.15 in
Text
Font Alignment Line spacing
Font – Unicode (Nikosh) As per sample Multiple at 1.3
Font Size – 14

Mail merge
Fields to mail merge: 1. Name, 2. e-mail, 3. District, and 4. Mobile Number.

Resources Required:

Tools, Equipment and furniture: 3. Personal Computer – 1 set

4. Ergonomic Chair – 1 Pc

Software: 4. Operating software – Windows

5. Application software – Word processor
6. Bangla typing software – Bijoy/Avro

PPE: 2. Rubber sole Shoes/Sandal – 1 pair

Page 40 of 97
 Avenue-6, Main Strect
Mirpur, Dhaka – 1216
+8801019 111 000
email@example.com
linkedin.com/bd/profile name

Raiyaan Mohommad
Career Objective Career History:
To secure a challenging ▪ 2019 – 2020
position in a reputable Office Executive
organization to expand my First Consultants
learnings, knowledge, and 1. Job Responsibilities are ...
skill. Secure a responsible 2. Job Responsibilities are ...
career opportunity to fully
utilize my training and ▪ 2017 - 2019
skills, while making a Computer Operator
significant contribution to Nod Publishing
the success of the 1. Job Responsibilities are ...
company. 2. Job Responsibilities are ...

Education History Background:

Exam Passing
SN Result
Skills set Name Year
➢ Creativity 01 B.A (Hons) 2016 2nd Class
➢ Leadership 02 HSC 2012 4.00
➢ Organization
➢ Problem solving Personal Information:
➢ Teamwork Date of Birth : 31/12/1998
NID Number : 2691111000
Marital Status : Single
District : Dhaka

Page 41 of 97
 সুধী, োতির তপিা বঙ্গবন্ধু জেখ মুতেবুর রহমান এঁর স্বপ্নের জ ানার বাাংলা তবতনমমাপ্নে মাননীয় প্রধানমন্ত্রী
প্রাপক: জেখ হাত নার তনপ্নদ মেনায় োিীয় দক্ষিা উন্নয়ন কর্তপম ক্ষ (এনএ তিএ) জদপ্নের আর্ ম- ামাতেক উন্নয়ন
ত্বরাতিি করার লপ্নক্ষে দক্ষ মানব ম্পদ তিতরপ্নি কাে করপ্নে।
<<নাম>>
এ লপ্নক্ষে আগামী .............................. এনএ তিএ কর্তকম “ICT Freelancing in
<<জেলা>> Bangladesh: Present Status, Challenges and Opportunities"
েীর্ মক একটি জ তমনার আপ্নয়ােন করা হপ্নয়প্নে। উক্ত জ তমনাপ্নর মাননীয় প্রধানমন্ত্রীর জব রকাতর তেল্প ও
<<জমাবাইল>> তবতনপ্নয়াগ উপপ্নদষ্টা েনাব ালমান ফেলুর রহমান, এমতপ মপ্নহাদয় প্রধান অতিতর্ তহপ্ন প্নব উপতিি
র্াকপ্নি ানুগ্রহ ম্মতি জ্ঞাপন কপ্নরপ্নেন।
<<ই-জমইল>>

উক্ত জ তমনাপ্নর আপনার ানুগ্রহ উপতিতি কামনা করতে ।

Page 42 of 97
 Job Sheet– 3 for Computer Operation, Level – 3

Candidate Name:

Job 01: Prepare a document as per specification using word processing software
Time: 1 Hour
Unit Covered: OU-ICT-CO-01-L3-V1: Operate a Personal Computer
OU-ICT-CO-02-L3-V1: Prepare a Document Using Word Processor
Instructions:
Read and understand the directions carefully:
▪ this practical demonstration is based on the performance criteria from all or some of the units of
competency in Computer Operation, Level – 3
▪ this assessment activity will be used to measure your underpinning skills
▪ you will have fifteen (15) minutes to familiarise yourself with the resources to be used
Working Procedure/ Steps:
31. Observe and wear personal protective equipment (PPE) as required for the Job.
32. Observe and follow Occupational Health and Safety (OHS) requirements during the
demonstration processes.
33. Read the provided Job and Specification sheet.
34. Collect required tools, materials, and equipment for the job.
35. Prepare PC to perform job smoothly.
36. Create a folder in “D Drive” namely “Reg. no_Your Name”.
37. Create and Save the file with named “Job-01” to the newly created folder.
38. Perform the Job within the given time as per Sample and specification sheet.
39. Check and review after completion of the job.
40. Save the document with both .doc. and .docx extension.
41. Apply mail merge (for 2nd page) to invite 3S recipients and prepare “finish and merge” for print in
PDF.
42. Print the document using PDF printer or document writer in PDF considering A4 size paper.
43. Submit finished output to the Competency Assessor.
44. Shutdown computer and clean your workplace.
45. Clean tools, equipment, materials, and work area.

Page 43 of 97
 Specification Sheet – 3 for Computer Operation, Level – 3

Job 01: Prepare a document as per specification using word processing software

Condition For the Job:

Work must be carried out in a safe manner and according to Computer operation (Level – 3) standards.

Page Layout (for both page)

Page size: A4
Page orientation: 1st page: Portrait; 2nd page: Landscape
Additional settings for 2nd page only:
Number of Column: 2, Column width: 1st column - 3.8// and 2nd column - 2.47//, Spacing: 0.6//
Footer: “File path” will be placed as “footer” on the right side of the page
Page number: Will be display on the bottom of the left side of the page

English Part (1st Page)

Photograph
Shape (At the top, right corner Shape (at the middle, left Shape (at the bottom, left
of the page) – as per sample side) – Rectangle corner) – as per sample
Size – 3.5 in  8.27 in Shape Size – 6.0 in  23 in Shape Size – 1.0 in 0.7 in
Picture Size – 2 in  2 in
Picture Border width – 3 pt

Text
Font Alignment Line spacing
Title (Name) font - Poppins Medium and size: 27 As per sample Multiple at 1.4
Other Font – Arial
Size for Sub Title – 14
Size for others Text – 13
Font color over the shape - #D7E4BD

Bangla Part (2nd Page)

Text
Font Alignment Line spacing
Font – Unicode (Nikosh) As per sample Multiple at 1.2
Font Size – 13, Heading - 24

Mail merge
Fields to mail merge: 1. Name, 2. e-mail, 3. District, and 4. Mobile Number.

Resources Required:

Tools, Equipment and furniture: 5. Personal Computer – 1 set

6. Ergonomic Chair – 1 Pc

Software: 7. Operating software – Windows

8. Application software – Word processor
9. Bangla typing software – Bijoy/Avro

PPE: 3. Rubber sole Shoes/Sandal – 1 pair

Page 44 of 97
 Name Surname
Student Job

Want to be an IT Professional  +01714400005

through utilizing Acquired  example@gmail.com
skills, knowledge and Attitude  BIDA Bhaban, Agargaon,
in the IT field, which will allow Dhaka.
me to be a good trainer in IT in
various fields.

SKILLS EDUCATION
BSc in CSE  RUET
Excel 4.5 (Out of 5)
2018
PowerPoint
Word HSC  Rajshahi
5.0 (Out of 5)
2014

EXPERIENCE
LANGUAGES Facilitator  IT
2018-2020
English Facilitate Training of different occupation related to IT
sector like, Graphic Design, Web Design, IT Support,
Bangla Computer operation.

Korean Facilitator  IT
2020-2022
Worked as a lead trainer of CBT&A Level-5 Training &
Assessment
INTERESTS

• Swimming
• Climbing
• Reading
• Travel Signature

Page 45 of 97
প্রাপক,

<< নাম >>

<< জেলা >>
<< জমাবাইল >>
<< ই-জমইল >>

সুধী,
োতির তপিা বঙ্গবন্ধু জেখ মুতেবুর রহমান এঁর েন্মবাতর্ মকী ও োিীয় তেশু তদব ২০২৩ উপলপ্নক্ষ আগামী জাতীয় শিশু
১৮ই মার্ ম ২০২৩, তবকাল ৪:০০ ঘটিকায় অত্র প্রতিষ্ঠাপ্ননর প্নম্মলন কপ্নক্ষ একটি আপ্নলার্না ভার আপ্নয়ােন
করা হপ্নয়প্নে। শিবস - ২০২৩
উক্ত অনুষ্ঠাপ্নন আপ্নলার্ক তহপ্ন প্নব উপতিি র্াকপ্নবন তম XXXXXXXX ।

উক্ত অনুষ্ঠাপ্নন আপনাপ্নদর উপতিতি কামনা করতে।

তম YYYYYVVV
আগারগাঁও ঢাকা।

Page 46 of 97
 Job Sheet – 4 for Computer Operation, Level – 3

Candidate Name:

Job 01: Prepare a document as per specification using word processing software
Time: 1 Hour
Unit Covered: OU-ICT-CO-01-L3-V1: Operate a Personal Computer
OU-ICT-CO-02-L3-V1: Prepare a Document Using Word Processor
Instructions:
Read and understand the directions carefully:
▪ this practical demonstration is based on the performance criteria from all or some of the units of
competency in Computer Operation, Level – 3
▪ this assessment activity will be used to measure your underpinning skills
▪ you will have fifteen (15) minutes to familiarise yourself with the resources to be used
Working Procedure/ Steps:

46. Observe and wear personal protective equipment (PPE) as required for the Job.
47. Observe and follow Occupational Health and Safety (OHS) requirements during the
demonstration processes.
48. Read the provided Job and Specification sheet.
49. Collect required tools, materials, and equipment for the job.
50. Prepare PC to perform job smoothly.
51. Create a folder in “D Drive” namely “Your Name_Reg no”.
52. Create and Save the file with named “Job-1” to the newly created folder.
53. Perform the Job within the given time as per Sample and specification sheet.
54. Check and review after completion of the job.
55. Save the document again with same name as “Job-1”.
56. Apply mail merge (for 2nd page) to invite 5 student recipients and prepare “finish and merge” for
print in PDF.
57. Print the document using PDF printer or document writer in PDF considering A4 size paper.
58. Submit finished output to the Competency Assessor.
59. Shutdown computer and clean your workplace.
60. Clean tools, equipment, materials, and work area.

Page 47 of 97
 Specification Sheet – 4 for Computer Operation, Level – 3

Job 01: Prepare a document as per specification using word processing software

Condition For the Job:

Work must be carried out in a safe manner and according to Computer operation (Level – 3) standards.

Page Layout (for both page)

Page size: A4
Number of Column – 2 (use as per sample for 1st page only)
Page orientation – Portrait
Footer – “File path will be placed as Footer on the right side of the page.
Page number – Will be display on the bottom of right side.

English Part (1st Page)

Photograph
Shape – Round
Size – 1.78 inch x 1.78 inch
Border width – 6 pt

Shape (at the top part) – Rounded rectangular

Shape size – 6.48 inch x 2.05 inch

Text
Font Alignment Line spacing
Font – Times New Roman As per sample Multiple at 1.6
Size for title (Name) – 36
Size for Sub Title – 14
Size for others Text – 13

Bangla Part (2nd Page)

Text
Font Alignment Line spacing
Font – Unicode (Nikosh) As per sample Multiple at 1.3
Font Size – 14

Mail merge
Fields to mail merge: 1. Name, 2. Roll, 3. Occupation, and 4. E-mail.

Resources Required:

Tools, Equipment and furniture: 7. Personal Computer – 1 set

8. Ergonomic Chair – 1 Pc

Software: 10. Operating software – Windows

11. Application software – Word processor
12. Bangla typing software – Bijoy/Avro

PPE: 4. Rubber sole Shoes/Sandal – 1 pair

Page 48 of 97
 Dam
Martinez
Graphic Designer

Work Experience____________________
CONTACT ME
▪ Senior Graphic Designer
Gullible Enterprises
Phone: +0123-456245 2020-2024
Email: hello@gmail.com
Address: 123 Anywhere St Any
Dhaka, St 12345 ▪ Graphic Designer
CRR Technologies
2015-2019
EDUCATION

▪ Junior Graphic Designer

Emmanuelle Fashion
Course Studied
2010-2015
University/College Details
06-06-2008

Course Studied
University/College Details
06-10-2012
Reference:

Course Studied Name: Mr. Mouree

University/College Details
Designation: Managing Director
06-04-2018
Mobile: 01456111213

SKILLS E-mail: mouree@gmail.com

UI/UX
Visual Design
User Flows
Process Flows

Page 49 of 97
প্রাপক:
<<নাম>>
<<জরাল>>
<<অকুপ্নপেন>>
<<ই-জমইল>>

স্মার্ ম বাাংলাপ্নদে হপ্নলা বাাংলাপ্নদে রকাপ্নরর একটি প্রতিশ্রুতি ও জলাগান যা ২০৪১ াপ্নলর মপ্নধযে জদেপ্নক তিতের্াল বাাংলাপ্নদে
জর্প্নক স্মার্ ম বাাংলাপ্নদপ্নে রূপান্তপ্নরর পতরকল্পনা। বাাংলাপ্নদপ্নের প্রধানমন্ত্রী জেখ হাত না ব মপ্রর্ম এই প্রতিশ্রুতি ও জলাগান জদন।

ইতিহা
প্রধানমন্ত্রী জেখ হাত না ১২ই তিপ্ন ম্বর ২০২২ াপ্নল রােধানীর বঙ্গবন্ধু আন্তের্াাতদক প্নম্মলন জকপ্নের (তবআই ত ) অনুষ্ঠাপ্নন
তিতের্াল বাাংলাপ্নদে তদব -২০২২ উদযাপন উপলপ্নক্ষ আপ্নয়াতেি অনুষ্ঠাপ্নন প্রধান অতিতর্র ভার্প্নে ব মপ্রর্ম ‘স্মার্ ম বাাংলাপ্নদে’য
গড়ার কর্া বপ্নলন। জখ হাত না বপ্নলন,য‘আমরা আগামী ২০৪১’য াপ্নল বাাংলাপ্নদেপ্নক উন্নি জদে তহপ্ন প্নব গপ্নড় তুলব এবাং বাাংলাপ্নদে
হপ্নব তিতের্াল বাাংলাপ্নদে।

পতরকল্পনা
‘স্মার্ ম বাাংলাপ্নদে’যগড়ার তভতি র্ারটি। এগুপ্নলা হপ্নে-
1. স্মার্ ট নাগরিক
2. স্মার্ ট অর্ টনীরি
3. স্মার্ ট সিকাি
4. স্মার্ ট সমাজ

Page 50 of 97
 Job Sheet -5 for Computer Operation, Level - 3

Candidate Name:
Job 01: Prepare a document as per specification using word processing software
Time: 1 Hour
Unit Covered: OU-ICT-CO-01-L3-V1: Operate a Personal Computer
OU-ICT-CO-02-L3-V1: Prepare a Document Using Word Processor
Instructions:
Read and understand the directions carefully:
▪ this practical demonstration is based on the performance criteria from all or some of the units of competency in
Computer Operation, Level – 3
▪ this assessment activity will be used to measure your underpinning skills
▪ you will have fifteen (15) minutes to familiarize yourself with the resources to be used

Working Procedure / Steps:

1. Observe and wear personal protective equipment (PPE) as required for the job.
2. Observe and follow Occupational Health and Safety (OHS) requirement during the demonstration processes.
3. Read the provide Job and Specification sheet.
4. Collect required tools, materials, and equipment for the job.
5. Prepare PC to perform job smoothly.
6. Create a folder in “D Drive” namely “reg no _Your Name”.
7. Create and save the file with named “Job- 1” to the newly created folder.
8. Perform the Job within the given time as per Sample and specification sheet.
9. Check and review after completion of the job.
10. Save the document with both. doc. and .docx extension.
11. Apply mail merge (for 2nd page) to invite 3 recipients and prepare “finish send merge “for print in PDF (3
individual separate fish).
12. Print the document using PDF printer or document writer in PDF considering A4 size paper.
13. Submit final output to the Competency Assessor.
14. Shutdown computer and clean your workplace.
15. Clean tools, equipment, materials and work area.

Page 51 of 97
 Specification Sheet -5 for Computer Operation, Level -3

Job 01: Prepare a document as per specification using word processing software

Condition For the Job:

Work must be carried out in a safe manner and according to Computer operation (Level -3) standards.

Page Layout (for both page)

Page size: A4
Page orientation: 1st page: Portrait; 2nd page: Landscape
Additional settings for 2nd page only:
Number of columns: 2, Column width:1st column-5.0” and 2nd column-3.3”, Spacing: 0.6
Footer: “File path” will be placed as “footer” on the left of the page.
Page number: Will be displayed on the bottom of the right side of the page.

English Part (1st page)

Photograph

Shape (At the left side of the page)-as per

sample
Size -11 in X 3.1 in
Picture size – 2 in X 2 in
Picture Border width -1pt

Text Font Alignment Line spacing

Font Name: Times New Roman As per sample Multiple at 1.15

Font Size for Name (Title)=34
Font Size for Subtitle=20
Font Size for Headings =14
Size for others Text=10
Font color= Black
Bangla Part (2nd Page)
Text Font Alignment Line spacing
Font – Unicode (Nikosh) As per sample Multiple at 1.2
Font Size – 13, Heading-24
Mail merge
Fields to mail merge: 1. Name,2. E-mail,3. District,4. Mobile Number.

Resources Required:
Tools, Equipment and furniture: 1. Personal Computer – 1 set
2. Ergonomic Chair – 1 Pc
Software: 1. Operating software- windows
2. Application software- word processor
3. Bangla typing software – Bijoy/ Avro
PPE: 1. Rubber sole shoes/Sandal-1 pair

Page 52 of 97
 FIRST NAME
SURNAME
UI/UX DESIGNER

EDUCATION
B. Sc. in CSE | Chattogram University, Chattogram

GPA 3.36 (Out of 4.0) ,2019

CONTACT H. S. C | Chattogram College, Chattogram

Plot#E-6/B,W Agargaon, GPA 5.0(Out of 5.0) ,2015

Dhaka 1205 Relevant Courses:

+8801717777777 ❖ UI/UX Design
❖ Advanced Graphics Design
name@example.com

EXPERIENCE
COMMUNICATION
December 2022 – present
English
Lead UI/UX Designer |Company Name
Bangla
February 2020 – December 2022
Korean
Graphics Designer | Company Name

I have a proven track record of delivering high-quality designs while

maintaining project deadline and client satisfaction.
INTERESTS
Signature
Travelling
REFERENCES
Reading
1. Prof. Name
Music
Professor, Department of CSE
Chattogram University, Chattogram

Signature

Page 53 of 97
প্রাপক
<<নাম>>
<<জেলা>>
<<জমাবাইল>>
<<ই-জমইল>>
সুধী ,
আো আপতন সুি এবাং ভাপ্নলা আপ্নেন । এই তর্ঠির মাধ্যপ্নম আপনাপ্নক আন্ততরক শুপ্নভো োনাতে এবাং আমাপ্নদর প্রতিষ্ঠাপ্ননর পক্ষ
জর্প্নক আপনাপ্নক আন্ততরক ভাপ্নব োনাতে জয আমরা আগামী ২১ জফব্রুয়াতর ,২০২৫ িাতরপ্নখ আন্তমোতিক মার্তভার্া তদব উপলপ্নক্ষ
একটি তবপ্নের্ আপ্নলার্না ভার আপ্নয়ােন করপ্নি যাতে ।

মার্তভার্ার প্রতি শ্রদ্ধা এবাং ভাপ্নলাবা া প্রকাপ্নের উপ্নেপ্নে আমরা এই আপ্নলার্না ভার আপ্নয়ােন কপ্নরতে,জযখাপ্নন আমরা মার্তভার্ার
গুরুত্ব এবাং আমাপ্নদর াাংস্কৃতিক ঐতিহে তনপ্নয় আপ্নলার্না করপ্নবা ।
আন্তমোতিক মার্তভার্া তদব
তবঠপ্নকর তববরে তনম্মরূপ:
২০২৫
িাতরখ :২১ জফব্রুয়াতর ,২০২৫; ময় : কাল ১০:০০ ঘটিকা
িান:তবতনপ্নয়াগ ভবন ,আগারগাঁও ঢাকা ।

উক্ত অনুষ্ঠাপ্নন আপনার উপতিতি কামনা করতে । আপনার উপতিতি আমাপ্নদর েন্য অিেন্ত গুরুত্বপূে ম এবাং আমরা আপনার মূল্যবান
মিামি ও পরামেম শুনপ্নি আগ্রহী।

েনাব, YYYYYYYYYY
আগারগাঁও ঢাকা ।

Page 54 of 97
 Job Sheet -6 for Computer Operation, Level - 3

Candidate Name:
Job 01: Prepare a document as per specification using word processing software
Time: 1 Hour
Unit Covered: OU-ICT-CO-01-L3-V1: Operate a Personal Computer
OU-ICT-CO-02-L3-V1: Prepare a Document Using Word Processor
Instructions:
Read and understand the directions carefully:
▪ this practical demonstration is based on the performance criteria from all or some of the units of competency in
Computer Operation, Level – 3
▪ this assessment activity will be used to measure your underpinning skills
▪ you will have fifteen (15) minutes to familiarize yourself with the resources to be used

Working Procedure / Steps:

16. Observe and wear personal protective equipment (PPE) as required for the job.
17. Observe and follow Occupational Health and Safety (OHS) requirement during the demonstration processes.
18. Read the provide Job and Specification sheet.
19. Collect required tools, materials, and equipment for the job.
20. Prepare PC to perform job smoothly.
21. Create a folder in “D Drive” namely “reg no _Your Name”.
22. Create and save the file with named “Job- 1” to the newly created folder.
23. Perform the Job within the given time as per Sample and specification sheet.
24. Check and review after completion of the job.
25. Save the document with both. doc. and .docx extension.
26. Apply mail merge (for 2nd page) to invite 3 recipients and prepare “finish send merge “for print in PDF (3
individual separate fish).
27. Print the document using PDF printer or document writer in PDF considering A4 size paper.
28. Submit final output to the Competency Assessor.
29. Shutdown computer and clean your workplace.
30. Clean tools, equipment, materials and work area.

Page 55 of 97
 Specification Sheet -6 for Computer Operation, Level -3

Job 01: Prepare a document as per specification using word processing software

Condition For the Job:

Work must be carried out in a safe manner and according to Computer operation (Level -3) standards.

Page Layout (for both page)

Page size: A4
Page orientation: 1st page: Portrait; 2nd page: Landscape
Additional settings for 2nd page only:
Number of Column: 2, Column width: 1st Colmn-5.0” and 2nd column- 3.3”, Spacing: 0.6
Footer: “File path” will be placed as “footer” on the right of the page.
Page number: Will be displayed on the bottom of the left side of the page.

English Part (1st page)

Photograph

Shape (At the Right side of the page) – as per sample

Size – 11 in x 3.1 in
Picture Size – 2 in x 2 in
Picture Border width – 1 pt

Text Font Alignment Line spacing

Font Name: Bookman Old Style As per sample Multiple at 1.15

Font Size For Name (Title) = 34
Font Size For Subtitle = 20
Font Size For Headings = 14
Size For Other Text = 10
Font Color = Black
Bangla Part (2nd Page)
Text Font Alignment Line spacing
Font – Unicode (Nikosh) As per sample Multiple at 1.2
Font Size – 13, Heading – 24
Mail merge
Fields to mail merge: 1. Name,2. E-mail,3. District,4. Mobile Number.

Resources Required:
Tools, Equipment and furniture: 3. Personal Computer – 1 set
4. Ergonomic Chair – 1 Pc
Software: 4. Operating software- windows
5. Application software- word processor
6. Bangla typing software – Bijoy/ Avro
PPE: 2. Rubber sole shoes/Sandal-1 pair

Page 56 of 97
 Sample
* You may prepare the CV as per your information

FIRST NAME LAST NAME

Address. Phone
Email. LinkedIn Profile. Twitter/Blog/Portfolio

To replace this text with your own, just click it and start typing. Briefly state your career objective, or
summarize what makes you stand out. Use language from the job description as keywords.

Dates From to
Job Title, CMPANY
Describe your responsibilities and achievements in terms of impact and results. Use examples, but
keep it short.
Dates From to
Job Title, CMPANY
Describe your responsibilities and achievements in terms of impact and results. Use examples, but
keep it short.

Education
Month Year
Degree Title, SCHOOL
It’s okay to brag about your GPA, awards, and honors. Feel free to summarize your coursework too.

Month Year
Degree Title, SCHOOL
It’s okay to brag about your GPA, awards, and honors. Feel free to summarize your coursework too.

Skills
• List your strengths relevant for the role you’re applying • List one of your strengths
for • List one of your strengths
• List one of your strengths • List one of your strengths

Activities
Use this section to highlight your relevant passions, activities, and how you like to give back. It’s good to
include Leadership and volunteer experiences here. Or show off important extras like publications,
certifications, languages and more

Page 57 of 97
প্রাপক:

<<নাম>>

<<জেলা>>

<<জমাবাইল>>

<<ই-জমইল>>

সুধী,

আো কতর আপতন সুি এবাং ভাপ্নলা আপ্নেন । আমাপ্নদর প্রতিষ্ঠাপ্ননর পক্ষ জর্প্নক আপনাপ্নক োনাজি আন্ততরক
শুপ্নভিা । আমরা স্বাধীনিা তদবস উপলপ্নক্ষ একটি তবপ্নের্ আপ্নলােনা সভার আপ্নয়ােন করপ্নি যাজি । এই
অনুষ্ঠানটি আগামী ২৬ মােম ২০২৫ িাতরপ্নখ অনুটষ্টি হপ্নব। আমাপ্নদর লক্ষে এই তবপ্নের্ তদপ্নন আমাপ্নদর মহান
স্বাধীনিা সাংগ্রাপ্নমর ইতিহাস, অেমন এবাং আমাপ্নদর ভতবর্েি সম্ভবনা তনপ্নয় আপ্নলােনা করা।

আপ্নলােনা সভার তববরে তনম্নরুপ:

িাতরখ: ২৬ মােম ২০২৫

আন্তমোতিক স্বাধীনিা তদব
সময়: সকাল ১০:০০ ঘটিকা; িান: তবতনপ্নয়াগ ভবন, আগারগাঁও ঢাকা।

আপনার মূলেবান উপতিতি এবাং মিামি আমাপ্নদর েনে অিেন্ত গুরুত্বপূে।ম আমরা তবশ্বাস কতর আপনার
অাংেগ্রহে এই অনুষ্ঠানপ্নক আরও অর্বহ
ম করপ্নব এবাং আমাপ্নদর সকপ্নলর েনে একটি তেক্ষামূলক ও স্মরেীয়
অতভঙ্গিা হপ্নব।

আমরা আন্ততরপ্নভপ্নব আো করতে আপতন আমাপ্নদর সপ্নঙ্গ এই তবপ্নের্ তদপ্নন উপতিি র্াকপ্নবন এবাং আমাপ্নদর
আপ্নলােনা সমতদ্ধ করপ্নবন।

েনাব, YYYYYYYYYYYYYY

আগারগাঁও ঢাকা, ২০২৫

Page 58 of 97
 Microsoft Excel
1. Summation: (য োগ করো)
a. =(CA+CA+CA+………..+CA)
b. =SUM(FCA:LCA)
c. SUMIF(FCA:LCA, Criteria, FCA:LCA)
F4 F4
d. =SUMIFS(FCA:LCA, FCA:LCA, FCA)
F4 F4
CA = Cell Address
2. Percentage: (শতকরো)
a. =CA*N% FCA = First Cell Address
b. =(CA+CA)*N% LCA = Last Cell Address
3. Average: (গড় নির্ণয় করো)
(FCA:LCA) = Range/নসমোিো
a. =(CA+CA+CA……….)/N
b. =AVERAGE(FCA:LCA) N = Number সংখ্যো
c. =AVERAGEA(FCA:LCA)
Logic = ু নক্ত/শতণ
4. Minimum: (য োট সংখ্যো)
a. =MIN(FCA:LCA) > Greater Than (যবনশ/উপরর)
5. Maximum: (বড় সংখ্যো)
< Less Than (কম/নিরে)
a. =MAX(FCA:LCA)
6. COUNT: (গির্ো করো) = Equal (সমোি/হরে)
a. =COUNT(FCA:LCA)
b. =COUNTA(FCA:LCA)
c. COUNTIF(FCA:LCA, Criteria)
7. INT: (পূর্ণ সংখ্যো)
a. =INT(CA)
8. CONCATENATE: ( ুক্ত করো)
a. =CONCATENATE(CA,CA,CA,…….)
9. Rank:
a. =Rank(FCA, FCA:LCA)
F4
10.Logical Math:
a. =IF(Logic, is logic true, is logic false)
11.Vlookup:
a. =Vlookup(lookup value, table array, column index)
b. =VLOOKUP(CA, FCA:LCA, N)
12.=TRIM(CA)
13.=LEN(CA)

Page 59 of 97
 Job Sheet – 1 for Computer Operation, Level – 3

Candidate Name:

Job 02: Prepare a Salary sheet as per specification using spreadsheet analysis software
Time: 1 Hour
Unit Covered: OU-ICT-CO-03-L3-V1: Prepare a Spreadsheet
Instructions:
Read and understand the directions carefully:
• this practical demonstration is based on the performance criteria from all or some of the units of competency
Computer Operation, Level – 3
• this assessment activity will be used to measure your underpinning skills
• you will have fifteen (15) minutes to familiarise yourself with the resources to be used
Working Procedure/ Steps:
1. Observe and wear personal protective equipment (PPE) as required for the Job.
2. Observe and follow Occupational Health and Safety (OHS) requirements during the demonstration
processes.
3. Read the provided Job and Specification sheet.
4. Collect required tools, materials, and equipment for the job.
5. Prepare PC to perform job smoothly.
6. Create a folder named “NSDA_Reg. no.” (except C drive).
7. Save the file with your “Registration No_SalarySheet” into folder created by you.
8. Perform the Job within the given time as per Sample and specification sheet.
9. Check and review after completion of the job.
10. Protect your worksheet with password (Password: 123456).
11. Save the document with both .xlsx and .csv extension
12. Show data using “VLOOKUP” as per sample-2 based on Emp_ID.
13. Print the document using PDF printer or document writer in PDF.
14. Submit finished output to the Competency Assessor.
15. Shutdown computer and clean your workplace.
16. Clean tools, equipment, materials, and work area.

Page 60 of 97
 Specification Sheet – 1 for Computer Operation, Level – 3

Job 02: Prepare a Salary sheet as per specification using spreadsheet analysis software

Condition For the Job:

Work must be carried out in a safe manner and according to Computer operation (Level – 3) standards.

Title font: Times New Roman

Other text font: Arial
Title font Size: 14 (Salary Sheet)
Cell Formatting: As per sample

Logo/Image: Use any image; Size – 0.72 inch x 0.51 inch

EMP_ID: Apply validation – Unique value for each Employee; Type: Numeric; Digit: 6;

Designation: Apply dropdown List to choose designation (as per sample)

Basic Salary: Based on Designation. Values are autofill following below condition:
▪ Principal – 16000
▪ JPO – 9000
▪ Trainer – 8500
▪ Lead Trainer – 9500
▪ IT Officer – 10000

House rent (HR):

▪ 55% of the basic for Designation Principal and IT Officer,
▪ 50% of the basic Designation Lead Trainer and JPO,
▪ 60% for others.

Medical allowances (MA): Fixed tk. 1500.

Provident fund (PF): 20% of basic.

Income Tax (IT): 15% of basic.

Gross Salary: Basic + House Rent + Medical Allowance

Net Salary: Gross Salary – PF and IT

Maximum and Minimum Salary: Calculate against Total Earning (Insert column as per requirement)

Resources Required:
Tools, Equipment, and furniture: 1. Personal Computer – 1 set
2. Ergonomic Chair – 1 Pc

Software: 1. Operating software – Windows

2. Application software – Spreadsheet Analysis Program
PPE: 1. Rubber sole Shoes/Sandal – 1 pair

Page 61 of 97
 Sample
Sample – 1 (Main Worksheet)

Salary Sheet

SL Basic Net
Emp ID Name Designation HR MA PF Gross Salary IT
No. Salary Salary
01 101001 A Principal 16000
02 101002 B JPO 9000
03 101003 C Trainer 8500
04 101004 D Lead Trainer 9500
05 101005 E Trainer 8500
06 101006 F Lead Trainer 9500
07 101007 G IT Officer 10000
08 101008 H Trainer 8500
09 101009 I Lead Trainer 9500
10 101010 J Trainer 8500

Sample – 2 (VLOOKUP)

Show the below information as per sample using VLOOKUP from sample – 1
SL Basic Gross Net
Emp ID Name Designation HR MA PF IT Min Max
No. Salary Salary Salary
01 101001 A Principal 16000 8800 1500 3200 26300 2400 20700

Page 62 of 97
 Job Sheet – 2 for Computer Operation, Level – 3

Candidate Name:

Job 02: Prepare a Salary sheet as per specification using spreadsheet analysis software
Time: 1 Hour
Unit Covered: OU-ICT-CO-03-L3-V1: Prepare a Spreadsheet
Instructions:
Read and understand the directions carefully:
• this practical demonstration is based on the performance criteria from all or some of the units of competency
Computer Operation, Level – 3
• this assessment activity will be used to measure your underpinning skills
• you will have fifteen (15) minutes to familiarise yourself with the resources to be used
Working Procedure/ Steps:
17. Observe and wear personal protective equipment (PPE) as required for the Job.
18. Observe and follow Occupational Health and Safety (OHS) requirements during the demonstration
processes.
19. Read the provided Job and Specification sheet.
20. Collect required tools, materials, and equipment for the job.
21. Prepare PC to perform job smoothly.
22. Create a folder named “NSDA_Reg. no.” (except C drive).
23. Save the file with your “Registration No_SalarySheet” into folder created by you.
24. Perform the Job within the given time as per Sample and specification sheet.
25. Check and review after completion of the job.
26. Protect your worksheet with password (Password: 123456).
27. Save the document with both .xlsx and .csv extension
28. Show data using “INDEX and Matvch” as per sample-2 based on Product_ID.
29. Print the document using PDF printer or document writer in PDF.
30. Submit finished output to the Competency Assessor.
31. Shutdown computer and clean your workplace.
32. Clean tools, equipment, materials, and work area.

Page 63 of 97
 Specification Sheet – 2 for Computer Operation, Level – 3

Job 02: Prepare a Salary sheet as per specification using spreadsheet analysis software

Condition For the Job:

Work must be carried out in a safe manner and according to Computer operation (Level – 3) standards.

Title font: Times New Roman

Title font Size: 34 (Company Name)
Font Size for Texts: 14
Other text font: Arial
Cell Formatting: As per sample

Logo/Image: Use any image; Size – 0.72 inch x 0.51 inch

Date: Set cell for fill with today’s Date

Mobile: Apply validation with 11 digits

Product ID: Apply validation – Unique value for each Item; Digit: 6

Item Name: Apply dropdown List (Item name will placed automatically by selecting Product ID

Quantity, Rate and Total Price: Use custom formatting to view same as sample.

Amount: Multiply Quantity and Rate

Grand Total: Addition of All Amount

Discount:
• If “Grand total” is more than 5 Lac, the discount will be 9% of the rest “Grand Total”.
• If “Grand total” is more than 3 Lac, the discount will be 3% of the “Grand Total”.
• For below 3 Lac, 1% of the “Grand Total”.

VAT: Fixed Tk. 3% of “Grand Total”’

Payable amount: Deduct “Discount from summation of Grand Total” and VAT.
INDEX & MATCH Function (Sample – 2):
• Prepare Dropdown in Product ID & Product Name
• Shown Rate based on Product Name
• Use Index & Match function for rate

Resources Required:
Tools, Equipment, and furniture: 3. Personal Computer – 1 set
4. Ergonomic Chair – 1 Pc

Software: 3. Operating software – Windows

4. Application software – Spreadsheet Analysis Program
PPE: 2. Rubber sole Shoes/Sandal – 1 pair

Page 64 of 97
 Sample
Sample – 1 (Main Worksheet)

Company Name
Shop# 5012, 5th Floor
IDB Bhaban, Agargoan, Dhaka-1207.
Website: www.companyname.com

All Kinds of Computer Products Sales and Service

Cash Memo

Customer Name: Date:

Address: Mobile No.
SL
Product ID Item Name Quantity Rate Amount
No.
01 Com102 Laptop 12 Pcs 50,000.00 600,000.00৳
02 Com103 Monitor 15 Pcs 10,000.00
03 Com104 Mouse 50 Pcs 500.00
04 Com105 Keyboard 20 Pcs 800.00
05 Com106 SSD 10 Pcs 2,500.00
06 Com107 RAM 15 Pcs 2,500.00
07 Com108 Casing 10 Pcs 2,000.00
08
09
10
Grand Total
Discount
Vat
Payable Amount
In Word:

Sample-2 (Using Index & Match)

SL
Product ID Item Name Quantity Rate Amount
No.

Com102 Laptop 50000

Page 65 of 97
 Job Sheet – 3 for Computer Operation, Level – 3

Candidate Name:

Job 02: Prepare a Electricity Bill as per specification using spreadsheet analysis software
Time: 1 Hour
Unit Covered: OU-ICT-CO-03-L3-V1: Prepare a Spreadsheet
Instructions:
Read and understand the directions carefully:
• this practical demonstration is based on the performance criteria from all or some of the units of
competency Computer Operation, Level – 3
• this assessment activity will be used to measure your underpinning skills
• you will have fifteen (15) minutes to familiarise yourself with the resources to be used
Working Procedure/ Steps:
33. Observe and wear personal protective equipment (PPE) as required for the Job.
34. Observe and follow Occupational Health and Safety (OHS) requirements during the demonstration
processes.
35. Read the provided Job and Specification sheet.
36. Collect required tools, materials, and equipment for the job.
37. Prepare PC to perform job smoothly.
38. Create a folder in “D Drive” namely “Reg no_Your Name”.
39. Create and Save the file with named “Job-02” to the newly created folder.
40. Perform the Job within the given time as per Sample and specification sheet.
41. Check and review after completion of the job.
42. Protect your worksheet with password (Password: abc).
43. Save the document with both .xlsx and .csv extension
44. Show data using “VLOOKUP” as per sample-B based on “Customer ID”.
45. Complete all calculation as per requirement given in the Specification Sheet.
46. Make a copy of the worksheet within the same workbook and named it “Filter”.
47. Set the filter option using header row.
48. Apply cell formatting (same fill and font color) on “Bill Amount” column where the cell contains
duplicate value.
49. Insert a new column for showing thw ranking of Bill Amount
50. Print the document using PDF printer or document writer in PDF.
51. Submit finished output to the Competency Assessor.
52. Shutdown computer and clean your workplace.
53. Clean tools, equipment, materials, and work area.

Page 66 of 97
 Specification Sheet – 3 for Computer Operation, Level – 3

Job 02: Prepare a Electricity Bill as per specification using spreadsheet analysis software

Condition For the Job:

Work must be carried out in a safe manner and according to Computer operation (Level – 3) standards.

Title font: Arial

Other text font: Tahoma
Title font Size: 15 (Electricity Bill)
Cell Formatting: As per sample

Logo/Image: Use any image; Size – 0.88 inch x 0.84 inch

Cust_ID: Apply validation for Unique ID for each customer. ID should be 6-digit numeric value .

Cust. Name: Name should be filled automatically according to Cust_ID

Meter Reading date: Apply cell format for showing the date as per sample and must be valid for within
the date of July 1, 2023 to June 30, 2024.

Calculation:
1. Consumed Unit: Use appropriate formula,
2. Electricity Charge:
Use appropriate formula for calculating electricity charge. The range of consumption and
rate per units see in the table.

Range of Consumption Rate per unit

0 – 75 units Tk 4.19
76 – 200 units Tk 5.72
201 – 400 units Tk 6.34
401 – 500 units Tk 9.94
Above 500 units Tk 11.46

3. Service Charge: Use the formula to place Tk. 500 automatically for the customer who minimum
use 1 unit of electricity.
4. Bill Amount: Bill Amount must be calculated by the summation of Electricity Charge and Service
Charge.
5. Rank: Use formula to generate ranking value based on “Bill Amount”.

Resources Required:

Tools, Equipment, and furniture: 5. Personal Computer – 1 set

6. Ergonomic Chair – 1 Pc

Software: 5. Operating software – Windows

6. Application software – Spreadsheet Analysis Program
PPE: 3. Rubber sole Shoes/Sandal – 1 pair

Sample
Sample – A (Main Worksheet)
Page 67 of 97
 Company Name
th
11 Floor, BISA Bhaban, Agargoan, Dhaka-1207
Website: www.companyname.com

Sample A: Electricity Bill

Meter
Cust. Prev. Curr. Consumed Electricity Service Bill
Cust_ID Reading Rank
Name Unit Unit Unit Charge Charge Amount
Date
December
101001 B 5682 6781
15, 2023
December
101002 B 6582 6781
11, 2023
December
101003 C 7810 7608
10, 2023
December
101004 D 21105 21035
10, 2023
December
101005 E 3511 3261
11, 2023
December
101006 F 45214 45054
11, 2023

Sample – B (VLOOKUP)

VLOOKUP
Cust_ID Bill Amount
101001 0

Page 68 of 97
 Job Sheet – 4 for Computer Operation, Level – 3

Candidate Name:

Prepare a Weekly Wages sheet for Worker as per specification using spreadsheet
Job 02:
analysis software.
Time: 1 Hour
Unit Covered: OU-ICT-CO-03-L3-V1: Prepare a Spreadsheet
Instructions:
Read and understand the directions carefully:
• this practical demonstration is based on the performance criteria from all or some of the units of competency
Computer Operation, Level – 3
• this assessment activity will be used to measure your underpinning skills
• you will have fifteen (15) minutes to familiarise yourself with the resources to be used

Working Procedure/ Steps:

54. Observe and wear personal protective equipment (PPE) as required for the Job.
55. Observe and follow Occupational Health and Safety (OHS) requirements during the demonstration
processes.
56. Read the provided Job and Specification sheet.
57. Collect required tools, materials, and equipment for the job.
58. Prepare PC to perform job smoothly.
59. Create a folder in “D Drive” namely “Your Name_Reg no”.
60. Save the file with “Job-2” to the newly created folder.
61. Perform the Job within the given time as per Sample and specification sheet.
62. Check and review after completion of the job.
63. Protect your worksheet with password (Password: 123456).
64. Save the document with both .xlsx and .csv extension
65. Print the document using PDF printer or document writer in PDF.
66. Submit finished output to the Competency Assessor.
67. Save document and Shutdown computer.
68. Clean tools, equipment, materials, and work area.

Page 69 of 97
 Specification Sheet – 4 for Computer Operation, Level – 3

Job 02: Prepare a Weekly Wages sheet for Worker as per specification using spreadsheet analysis software

Condition For the Job:

Work must be carried out in a safe manner and according to Computer operation (Level – 3) standards.

Sample-1:

Title font: Times New Roman

Other text font: Arial
Title font Size: 14 (Weekly Wages sheet for Worker)
Cell Formatting: As per sample

EMP_ID: Apply validation – Unique value for each Employee; Consider 7-digit Emp_ID where Leftmost
digit is character “E” and rest of 6 digit are Numeric type.

Designation: Apply dropdown List to choose designation (Grade-1, Grade-2 and Grade-3)

Basic Wages: Up to 40 hours wages is base wages. Values are autofill following below condition:
▪ Gread-1: 150 Taka/Hour
▪ Gread-2: 125 Taka/Hour
▪ Gread-3: 100 Taka/Hour

Overtime Wages: Hours above 40 are count as overtime hours. Calculate Overtime Wages as 200 Taka/Hour
using autofill formula.

Medical allowances (MA): Fixed Tk. 500/week for all allowance.

Gross Wages: Base Wages + Overtime Wages.

Income Tax (IT): 10% of Gross Wages.

Net Amount: (Gross Wages + Medical Allowance) – IT.

Sample - 2:

Chart Title: Font – Calibri (Body), 14 Size, Bold.

Legend Entry: Font - Calibri (Body), 11 Size.
Horizontal Axis: Font - Calibri (Body), 12 Size, Bold.
Add Axis Titles: “Months” as Horizontal Axis and “Taka” as Vertical Axis.

Resources Required:

Tools, Equipment, and furniture: 7. Personal Computer – 1 set

8. Ergonomic Chair – 1 Pc

Software: 7. Operating software – Windows

8. Application software – Spreadsheet Analysis Program

PPE: 4. Rubber sole Shoes/Sandal – 1 pair

Sample

Page 70 of 97
 Sample – 1 (Main Worksheet)

Weekly Wages Sheet for Worker

SL Basic Overtime Medical Gross Net

Emp_ID Name Designation Hours/Week IT
No. Wages Wages Allowance Amount Amount
01 E101001 A Grade-1 40
02 E101002 B Grade-3 55
03 E101003 C Grade-2 43
04 E101004 D Grade-3 44
05 E101005 E Grade-1 48
06 E101006 F Grade-3 54
07 E101007 G Grade-2 45
08 E101008 H Grade-3 35
09 E101009 I Grade-2 47
10 E101010 J Grade-3 49

Sample – 2 (VLOOKUP)
Show the Chart using information below as per sample:

Chart for Book Sale

50000
45000
40000
35000
30000
Taka

25000
20000
15000
10000
5000
0
January February March April
Months

Book-1 Book-2 Book-3 Book-4

Page 71 of 97
 Job Sheet – 5 for Computer Operation, Level – 3

Candidate Name:

Job 02: Prepare a Salary sheet as per specification using spreadsheet analysis software

Time: 1 Hour

Unit Covered: OU- ICT – CO- 03 L3 – V1: Prepare a Spreadsheet

Instruction:

Read and understand the directions carefully:

• This practical demonstration is based on the performance criteria from all or some of the units of
competency Computer Operation, Level – 3
• This assessment activity will be used to measure your underpinning skills
• You will have fifteen (15) minutes to familiarize yourself with the resources to be used

Working Procedure/ Steps:

1. Observe and wear personal proactive equipment (PPE) as required for the job.
2. Observe and follow Occupational Health and Safety (OHS) requirements during the demonstration
processes.
3. Read the provide Job and Specification sheet.
4. Collect required (PPE equipment for the job.
5. Prepare PC to perform job smoothly.
6. Create a folder in “D Drive” namely “Reg no Your Name”.
7. Create and save the file with named “Job-02” to the newly created folder.
8. Perform the job within the given time as per sample and specification sheet.
9. Check and review after completion of the job.
10. Protect your worksheet with password (Password: 4321).
11. Save the document with both .xlsx and .csv extension
12. Show data using “VLOOKUP” as per sample-B based on “Category”.
13. Complete all calculation as per requirement given in the Specification Sheet.
14. Make a copy of the worksheet within the same workbook and name it “Filter”.
15. Set the filter option using header now.
16. Print the document using PDF printer or document writer in PDF.
17. Submit final output to the Competency Assessor.
18. Shootdown computer and clean your workplace.
19. Clean tools, equipment, materials, and work area.

Page 72 of 97
 Specification Sheet – 5 for Computer Operation, Level – 3

Job 02: Prepare a Salary Sheet as per specification using spreadsheet analysis software

Condition for the Job:

Work must be carried out in a safe manner and according to Computer Operation (Level – 3) standards.
Title font: Arial
Other text font: Tahoma
Title font Size: 15 (Monthly Budget Tracker)
Cell Formatting: As per sample

Date Format: Use date for mate as DD-MMM-YY in ‘Date’ Column.

Category: Apply data validation for Category names. Category names other than “Income, Housing, Utilities, Food,
Transport, Entertainment” will not be allowed. (Use Custom rule, don’t use List Rule)

Apply Conditional Formatting on Type column to highlight “Income” with green color and “Expense” with Red Color
(As per Sample). Type will come automatically from Category. Only “Income” Category will be defined as “Income”,
all others will be “Expense”

Calculation:
1.Total: Use appropriate formula to calculate the total income and expense and show it in a separate table
(Calculation on the basis of type)
2.Budget Range: Use appropriate formula to indicate “Income “or “In Range” or “Over Budget” as per below
conditions on Type and Amount:
Type Amount Range
Income - Income
Expense >20% of Income Over Budget
Expense <20% of Income In Range
3.Rank: Use appropriate formula to show Ranking of expenses (Only which types are ‘Expense’) in this column. (Use
Helper Table as necessary)

Charts
Insert a column chart for Total Monthly Income vs. Total Monthly Expenses (Refer to Sample)

Resources Required:
Tools, Equipment, and furniture: 1. Personal Computer – 1 set
2. Ergonomic Chair – 1 Pc
Software: 1. Operating software – Windows
2. Application software – Spreadsheet Analysis Program
PPE: 1. Rubber sole Shoes/Sandal – 1 pair

Page 73 of 97
 Sample

Sample – A (Main Worksheet)

Monthly Budget Tracker

Month: June 2024

Sample A: Monthly Budget Tracker

Date Category Description Amount Budget Rank Type

Range
01-Jun-2024 Income Salary 30000 Income
02-Jun-2024 Housing Rent 12000 Expense
02-Jun-2024 Utilities Electricity Bill 1100 Expense
03-Jun-2024 Food Groceries 600 Expense
(vegetables)
03-Jun-2024 Food Groceries (Fish) 1800 Expense
05-Jun-2024 Utilities Internet Bill 500 Expense
06-Jun-2024 Transport Office transport 700 Expense

07-Jun-2024 Entertainment Movie 400 Expense

08-Jun-2024 Food Groceries 800 Expense

(vegetables)

Total Monthly Income 30000

Total Monthly Expenses 17900
Net Balance 12100

Sample – B (VLOOKUP & Line Chart)

VLOOKUP
Category Total Amount Monthly Budget Tracker
Housing 12000 40000

30000

20000

10000

0
Total Monthly Income Total Monthly Expenses

Page 74 of 97
 Job Sheet – 6 for Computer Operation, Level – 3

Candidate Name:

Job 02: Prepare a Age Calculation sheet as per specification using spreadsheet analysis
software

Time: 1 Hour

Unit Covered: OU- ICT – CO- 03 L3 – V1: Prepare a Spreadsheet

Instruction:

Read and understand the directions carefully:

• This practical demonstration is based on the performance criteria from all or some of the units of
competency Computer Operation, Level – 3
• This assessment activity will be used to measure your underpinning skills
• You will have fifteen (15) minutes to familiarize yourself with the resources to be used

Working Procedure/ Steps:

20. Observe and wear personal proactive equipment (PPE) as required for the job.
21. Observe and follow Occupational Health and Safety (OHS) requirements during the demonstration
processes.
22. Read the provide Job and Specification sheet.
23. Collect required (PPE equipment for the job.
24. Prepare PC to perform job smoothly.
25. Create a folder in “D Drive” namely “Reg no Your Name”.
26. Create and save the file with named “Job-02” to the newly created folder.
27. Perform the job within the given time as per sample and specification sheet.
28. Check and review after completion of the job.
29. Protect your worksheet with password (Password: 4321).
30. Save the document with both .xlsx and .csv extension
31. Complete all calculation as per requirement given in the Specification Sheet.
32. Set the filter option using header now.
33. Print the document using PDF printer or document writer in PDF.
34. Submit final output to the Competency Assessor.
35. Shootdown computer and clean your workplace.
36. Clean tools, equipment, materials, and work area.

Page 75 of 97
 Specification Sheet – 6 for Computer Operation, Level – 3

Job 02: Prepare a Salary Sheet as per specification using spreadsheet analysis software

Condition for the Job:

Work must be carried out in a safe manner and according to Computer operation (Level – 3) standards.
Instruction:
1. Open a new Excel worksheet.
2. Enter the following data into your workbook.
Age
S/N Name Age Sum AVERAGE COUNT MAX MIN
Category
1 Ali 30
2 Riad 25
3 Hasan 30
4 Amena 28
5 Sarah 32
6 Roy 44

3. Perform the following validation and formatting;

a) Validate the “Age” field to allow input values only between 1 and 44 (inclusive range). NO
other value will be accepted.
b) The “Age Category” field will be highlighted with color as below:
1. Children – Green Fill With Dark Green Text.
2. Children – Yellow Fill With Dark Yellow Text.
3. Children – Light Red Fill With Dark Rad Text.

4. Follow the steps below to perform different functions:

Function 1: SUM
• Use the SUM function to calculate SUM.
• This will calculate the sum of the ages from column C.
Function 2. AVERAGE
• Use the AVERAGE function to calculate the AVERAGE rounded to two decimal places.
• This will count the number of column C cell containing numeric values.
Function 4: max
• Use the MAX function to calculate the Maximum Value
• This will find the Maximum Value from column C.
Function 5: MIN
• Use the MIN function to calculate the Minimum Value
• This will find the Minimum Value from column C.
Function 6: IF
• Use a formula to calculate the condition part on the table:
• This will categories the age vases on a condition.
o Age between (1 – 12) is categories as Children.
o Age between (18 – 25) is categories as Youth.
Age between (26 – 44) is categories as Adult.

Page 76 of 97
 Microsoft Power Point

Job Sheet – 1 for Computer Operation, Level – 3

Candidate Name:

Job 03: Prepare a presentation as per specification using Presentation software

Time: 1 Hour
Unit Covered: OU-ICT-CO-04-L3-V1: Prepare a Presentation
Instructions:
Read and understand the directions carefully:
• this practical demonstration is based on the performance criteria from all or some of the units of competency
in Computer Operation, Level – 3
• this assessment activity will be used to measure your underpinning skills
• you will have fifteen (15) minutes to familiarise yourself with the resources to be used
Working Procedure/ Steps:
1. Observe and wear personal protective equipment (PPE) as required for the Job.
2. Observe and follow Occupational Health and Safety (OHS) requirements during the demonstration
processes.
3. Read the provided Job and Specification sheet.
4. Collect required tools, materials, and equipment for the job.
5. Prepare PC to perform job smoothly.
6. Create a folder named “NSDA_Reg. no.” (except C drive).
7. Save the file with your “Registration No_PPT” into folder created by you.
8. Prepare slide layout as per sample using “Slide Master” option.
9. Perform the Job within the given time as per Sample and specification sheet.
10. Check and review after completion of the job.
11. Save the document with both .pptx and .mp4 extension
12. Print the PPT for handouts using PDF printer or document writer in PDF.
13. Submit finished output to the Competency Assessor.
14. Shutdown computer and clean your workplace.
15. Clean tools, equipment, materials, and work area.

Page 77 of 97
 Specification Sheet – 1 for Computer Operation, Level – 3

Job 03: Prepare a presentation as per specification using Presentation software

Condition For the Job:

Work must be carried out in a safe manner and according to Computer operation (Level – 3) standards.
Slide Layout – The presentation slide layout must be prepared with “Slide master”.
Slide Size – Widescreen (16:9)
Slide transition – Random
Slide Show – Automatic after previous slide
Font – Font - Arial; Font size – 48 for Title of Title slide, 30 for Sub title, 38 for Slide title, 24 for other text
Alignment - As per Sample
Slide Number – Show all slide except Title slide (1st Slide)
1st Slide (Title Slide)
▪ Write your “Name and Registration Number” with Title “WELCOME”.
▪ Image size – 3 inch x 2 inch
▪ Place objects as per sample
2nd Slide
▪ Prepare and place infographics as per sample.
▪ Use Orange and ash colour for infographics
3rd Slide
▪ Prepare and place Diagram as per sample.
▪ Use Orange and ash colour for diagram, White for Text
4th Slide
▪ Prepare Chart of quarterly Sales report as per sample.
▪ Use separate colour for each quarter.
▪ Value for – 1st quarter: 14%, 2nd quarter: 64%, 3rd quarter: 7% and 4th quarter: 15%
5th Slide
▪ Prepare turbine using shapes and place as per sample.
▪ Apply appropriate animation to Rotate fan of turbine
(1st turbine: Clockwise, 2nd Turbine: Anti-clockwise, 3rd Turbine: Clockwise)
▪ Rotation will continue until End of slide.
6th Slide
▪ Place any video as per sample and trim the video at half of its original length
▪ Video will be shown in full screen in presentation/slide show mode.
7th Slide
▪ Place screen shot of your desktop screen and place any icon of the desktop use crop image option as
per sample.
End Slide
▪ Text - “THANK YOU”
▪ Font size – 40, Colour – Any colour except Black
▪ Placement – Vertically and Horizontally Centre of the Slide
Resources Required:

Tools, Equipment, and furniture: 1. Personal Computer – 1 set

2. Ergonomic Chair – 1 Pc
Software: 1. Operating software – Windows
2. Application software – Presentation Software

PPE: 1. Rubber sole Shoes/Sandal – 1 pair

Page 78 of 97
 Sample

Slide Layout (Slide Master) Title Slide (1st Slide)

2nd Slide: create infographics using shape 3rd Slide

1 2 3

4th Slide: Create a pie chart 5th Slide: Animation

6th Slide: Insert Video 7th Slide: Cropped image from screenshot

Page 79 of 97
 Job Sheet – 2 for Computer Operation, Level – 3

Candidate Name:

Job 03: Prepare a presentation as per specification using Presentation software

Time: 1 Hour
Unit Covered: OU-ICT-CO-04-L3-V1: Prepare a Presentation
Instructions:
Read and understand the directions carefully:
• this practical demonstration is based on the performance criteria from all or some of the units of competency
in Computer Operation, Level – 3
• this assessment activity will be used to measure your underpinning skills
• you will have fifteen (15) minutes to familiarise yourself with the resources to be used
Working Procedure/ Steps:
16. Observe and wear personal protective equipment (PPE) as required for the Job.
17. Observe and follow Occupational Health and Safety (OHS) requirements during the demonstration
processes.
18. Read the provided Job and Specification sheet.
19. Collect required tools, materials, and equipment for the job.
20. Prepare PC to perform job smoothly.
21. Create a folder named “NSDA_Reg. no.” (except C drive).
22. Save the file with your “Registration No_PPT” into folder created by you.
23. Prepare slide layout as per sample using “Slide Master” option.
24. Perform the Job within the given time as per Sample and specification sheet.
25. Check and review after completion of the job.
26. Save the document with both .pptx and .mp4 extension
27. Print the PPT for handouts using PDF printer or document writer in PDF.
28. Submit finished output to the Competency Assessor.
29. Shutdown computer and clean your workplace.
30. Clean tools, equipment, materials, and work area.

Page 80 of 97
 Specification Sheet –2 for Computer Operation, Level – 3

Job 03: Prepare a presentation as per specification using Presentation software

Condition For the Job:

Work must be carried out in a safe manner and according to Computer operation (Level – 3) standards.
Slide Layout – The presentation slide layout must be prepared with “Slide master”.
Slide Size – Widescreen (16:9)
Slide transition – Random
Slide Show – Automatic after previous slide
Font – Font - Arial; Font size – 48 for Title of Title slide, 30 for Sub title, 38 for Slide title, 24 for other text
Alignment - As per Sample
Slide Number – Show all slide except Title slide (1st Slide)
1st Slide (Title Slide)
▪ Write your “Name and Registration Number” with photograph Title “WELCOME”.
▪ Image size – 1.55 inch x 1.55 inch
▪ Place objects as per sample
2nd Slide
▪ Prepare and place infographics as per sample.
▪ Use three separate colours for infographics
3rd Slide
▪ Insert Equation and Symbol as per sample (Font size: 36).
▪ Use separate font color for Equation and Symbol.
4th Slide
▪ Prepare Chart of quarterly Sales report as per sample.
▪ Use separate colour for each quarter.
▪ Value for – 1st quarter: 64%, 2nd quarter: 14%, 3rd quarter: 15% and 4th quarter: 7%
5th Slide
▪ Place objects for animation as per sample.
▪ Apply appropriate animation to Rotate object 1 and 2 with the path
(Object 1: Clockwise, Object 2: Anti-clockwise)
▪ Rotation will continue until End of slide.
6th Slide
▪ Place any video as per sample and trim the video at half of its original length
▪ Video will be shown in full screen in presentation/slide show mode.
7th Slide
▪ Place screen shot of your desktop screen and place any icon of the desktop use crop image option as
per sample.
End Slide
▪ Text - “THANK YOU”
▪ Font size – 40, Colour – Any colour except Black
▪ Placement – Vertically and Horizontally Centre of the Slide
Resources Required:

Tools, Equipment, and furniture: 3. Personal Computer – 1 set

4. Ergonomic Chair – 1 Pc
Software: 3. Operating software – Windows
4. Application software – Presentation Software

PPE: 2. Rubber sole Shoes/Sandal – 1 pair

Page 81 of 97
 Sample

Slide Layout (Slide Master) Title Slide (1st Slide)

2nd Slide: Infographics (create using shape) 3rd Slide: Equation and Symbol

4th Slide: Create a pie chart 5th Slide: Animation

6th Slide: Insert Video 7th Slide: Cropped image from screenshot

Page 82 of 97
 Job Sheet – 3 for Computer Operation, Level – 3

Candidate Name:

Job 03: Prepare a presentation as per specification using Presentation software

Time: 1 Hour
Unit Covered: OU-ICT-CO-04-L3-V1: Prepare a Presentation
Instructions:
Read and understand the directions carefully:
• this practical demonstration is based on the performance criteria from all or some of the units of
competency in Computer Operation, Level – 3
• this assessment activity will be used to measure your underpinning skills
• you will have fifteen (15) minutes to familiarise yourself with the resources to be used
Working Procedure/ Steps:
31. Observe and wear personal protective equipment (PPE) as required for the Job.
32. Observe and follow Occupational Health and Safety (OHS) requirements during the demonstration
processes.
33. Read the provided Job and Specification sheet.
34. Collect required tools, materials, and equipment for the job.
35. Prepare PC to perform job smoothly.
36. Create a folder in “D Drive” namely “Reg no_Your Name”.
37. Create and Save the file with named “Job-03” to the newly created folder.
38. Prepare slide layout as per sample using “Slide Master” option.
39. Perform the Job within the given time as per Sample and specification sheet.
40. Check and review after completion of the job.
41. Save the document with both .pptx and .mp4 extension.
42. Print the PPT for handouts using PDF printer or document writer in PDF.
43. Submit finished output to the Competency Assessor.
44. Shutdown computer and clean your workplace.
45. Clean tools, equipment, materials, and work area.

Page 83 of 97
 Specification Sheet – 3 for Computer Operation, Level – 3

Job 03: Prepare a presentation as per specification using Presentation software

Condition For the Job:

Work must be carried out in a safe manner and according to Computer operation (Level – 3) standards.

Slide Layout – The presentation slide layout must be prepared with “Slide master”.
Slide Size – Widescreen (16:9)
Slide transition – Wipe
Slide Show – Automatic after previous slide
Font – Font - Arial; Font size – 50 for Title of Title slide, 30 for Sub title, 40 for Slide title, 24 for other text.
Font color – Title and Sub title color should be #0066CC and other you may choose yoursself.
Alignment - As per Sample
Slide Number – Show all slide except Title slide (1st Slide)
Date – Must be a Fixed date

1st Slide (Title Slide)

▪ Write your “Name and Registration Number” with Title “WELCOME”.
▪ Image size – W:5 inch x H:3 inch
▪ Place objects as per sample
2nd Slide
▪ Prepare and place infographics as per sample.
▪ Use different color for each shape
3rd Slide
▪ Prepare and place Diagram as per sample.
▪ You may choose the color yourself
4th Slide
▪ Prepare Chart for showing Percentage of other gender as per sample.
▪ Use the #0066CC color for the shape showing male data, use the #00B050 color for the shape
showing female data and for others use the #CC0099 color.
▪ Objects and text align as per sample.
5th Slide
▪ Prepare for bouncing ball using shapes and place as per sample.
▪ Apply appropriate animation to bounce the ball.
▪ Edit point to perfect animation (as per sample).
6th Slide
▪ Place any video as per sample and trim the video at half of its original length
▪ Video will be shown in full screen in presentation/slide show mode.
7th Slide
▪ Insert screenshot and use crop option to discard unwanted area (as per sample).
▪ Create an action button to go to slide no. 4
End Slide
▪ Text - “THANK YOU”
▪ Font size – 45, You may choose any color.
▪ Placement – Centre of the Slide.

Resources Required:

Tools, Equipment, and furniture: 5. Personal Computer – 1 set

6. Ergonomic Chair – 1 Pc

Software: 5. Operating software – Windows

6. Application software – Presentation Software

PPE: 3. Rubber sole Shoes/Sandal – 1 pair

Sample

Page 84 of 97
 Slide Layout (Slide Master) Title Slide (1st Slide)

2nd Slide: create infographics using shape 3rd Slide

4th Slide: Create a pie chart 5th Slide: Animation

6th Slide: Insert Video 7th Slide: Cropped image from screenshot

Page 85 of 97
 Job Sheet – 4 for Computer Operation, Level – 3

Candidate Name:

Job 03: Prepare a presentation as per specification using Presentation software

Time: 1 Hour
Unit Covered: OU-ICT-CO-04-L3-V1: Prepare a Presentation
Instructions:
Read and understand the directions carefully:
• this practical demonstration is based on the performance criteria from all or some of the units of competency
in Computer Operation, Level – 3
• this assessment activity will be used to measure your underpinning skills
• you will have fifteen (15) minutes to familiarise yourself with the resources to be used

Working Procedure/ Steps:

46. Observe and wear personal protective equipment (PPE) as required for the Job.
47. Observe and follow Occupational Health and Safety (OHS) requirements during the demonstration
processes.
48. Read the provided Job and Specification sheet.
49. Collect required tools, materials, and equipment for the job.
50. Prepare PC to perform job smoothly.
51. Create a folder in “D Drive” namely “Your Name_Reg no”..
52. Save the file to the newly created folder as “Job-3”.
53. Prepare slide layout as per sample using “Slide Master” option.
54. Perform the Job within the given time as per Sample and specification sheet.
55. Check and review after completion of the job.
56. Save the document with both .pptx and .mp4 extension
57. Print the PPT for handouts using PDF printer or document writer in PDF.
58. Submit finished output to the Competency Assessor.
59. Shutdown computer and clean your workplace.
60. Clean tools, equipment, materials, and work area.

Page 86 of 97
 Specification Sheet – 4 for Computer Operation, Level – 3

Job 03: Prepare a presentation as per specification using Presentation software

Condition For the Job:

Work must be carried out in a safe manner and according to Computer operation (Level – 3) standards.

Slide Layout – The presentation slide layout must be prepared with “Slide master”.
Slide Size – Widescreen (16:9)
Slide transition – Random
Slide Show – Automatic after previous slide
Font – Font - Arial; Font size – 44 for Title of Title slide, 30 for Sub title, 36 for Slide title, 28 for other text
Alignment - As per Sample
Slide Number – Show all slide except Title slide (1st Slide)

1st Slide (Title Slide)

▪ Write your “Name and Registration Number” with Title “WELCOME”.
▪ Image size – 3 inch x 2 inch
▪ Place objects as per sample
nd
2 Slide
▪ Prepare and apply animation on “Happy World” where each character will be animated separately.
rd
3 Slide
▪ Prepare and place Diagram as per sample.
▪ Use Orange and ash colour for diagram, White for Text
th
4 Slide
▪ Prepare turbine using shapes and place as per sample.
▪ Apply appropriate animation to Rotate fan of turbine
(1st turbine: Clockwise, 2nd Turbine: Anti-clockwise)
▪ Rotation will continue up to 30 Second.
th
5 Slide
▪ Prepare Chart of quarterly Sales report as per sample.
▪ Use separate colour for each quarter.
▪ Value for – 1st quarter: 7%, 2nd quarter: 15%, 3rd quarter: 14% and 4th quarter: 64%
th
6 Slide
▪ Place any video as per sample and trim the video at half of its original length
▪ Video will be shown in full screen in presentation/slide show mode.
7th Slide
▪ Text - “THANK YOU”
▪ Font size – 40, Colour – Any colour except Black
▪ Placement – Vertically and Horizontally Centre of the Slide
▪ Add a signature as per sample.

Resources Required:

Tools, Equipment, and furniture: 7. Personal Computer – 1 set

8. Ergonomic Chair – 1 Pc

Software: 7. Operating software – Windows

8. Application software – Presentation Software

PPE: 4. Rubber sole Shoes/Sandal – 1 pair

Sample

Page 87 of 97
Slide Layout (Slide Master) Title Slide (1st Slide)

2nd Slide 3rd Slide

4th Slide 5th Slide: Animation

6th Slide 7th Slide

Page 88 of 97
 Job Sheet -5 for Computer Operation, Level - 3

Candidate Name:

Job 01: Prepare a document as per specification using word processing software
Time: 1 Hour
Unit Covered: OU-ICT-CO-01-L3-V1: Operate a Personal Computer
OU-ICT-CO-02-L3-V1: Prepare a Document Using Word Processor
Instructions:

Read and understand the directions carefully:

▪ this practical demonstration is based on the performance criteria from all or some of the units of
competency in Computer Operation, Level – 3
▪ this assessment activity will be used to measure your underpinning skills
▪ you will have fifteen (15) minutes to familiarize yourself with the resources to be used

Working Procedure / Steps:

1. Observe and wear personal protective equipment (PPE) as required for the job.
2. Observe and follow Occupational Health and Safety (OHS) requirement during the demonstration
processes.
3. Read the provide Job and Specification sheet.
4. Collect required tools, materials, and equipment for the job.
5. Prepare PC to perform job smoothly.
6. Create a folder in “D Drive” namely “reg no _Your Name”.
7. Create and save the file with named “Job- 3” to the newly created folder.
8. Prepare slide layout as per sample using “Slide Master” option.
9. Perform the Job within the given time as per Sample and specification sheet.
10. Check and review after completion of the job.
11. Save the document with both .pptx and .mp4 extension.
12. Print the PPT for handouts (Max 4 slide in each page) using PDF printer or document writer in PDF.
13. Submit final output to the Competency Assessor.
14. Shutdown computer and clean your workplace.
15. Clean tools, equipment, materials and work area.

Page 89 of 97
 Specification Sheet-5 for computer Operation, Level-3
Job-3 Prepare a presentation as per specification using Presentation software
Condition for the job:
Work must be carried out in a safe manner and according to Computer Operation (Level-3) standards
Slide Layout – The presentation slide layout must be prepared with “Slide Master”.
Slide Size – Widescreen (16:9)
Slide Transition – Wipe
Slide Show – Automatic after previous slide
Font – Font-Arial; Font size-50 for Title of Title slide, 30 for Sub title, 40 for slide title, 24 for other text
Font color- Title and sub title color should be RGB = (0, 102, 204) and other you may choose yourself
Alignment – As per sample
Slide Number-Show all slide except Title Slide (1st slide)
Date- Must be Fixed Date
1st slide (Title Slide)
• Write your “Name and Registration Number” with title “WELCOME”.
• Image size- W: 5-inch x H: 3-inch
• Place objects as per sample
2nd slide
• Insert the image as per sample
• Position the image
• Make the background transparent
3rd slide
• Create title text
• Create background blended fill.
• Create graph line, align graph line & Distribute graph line
• Add rectangles.
• Add Text boxes
th
4 slide
• Add an organization chart using the content layout for Aardvark Advertising Inc. Consisting of a CEO (Jane
Peters), Her assistant (Jo Whalley), Three managers (Nathan Samms -Creative Director, John Blake – Sales
and Miriam Solberg – IT) as per sample
• Fil the Managers boxes with yellow, the PA with green, and the CEO with Grey.
• Apply different font styles for the different individuals
5th Slide
• Create a char on a new slide to depict the following data as per sample
10 mins 20 mins 30 mins 40 mins
Text Only 1 3 8 12
Graphics 0 2 5 9
Animation 0 1 3 5
6th Slide
• Place any video as per sample and trim the video at half of its original length
• Video will be shown in full screen in presentation/slide show mode.
End Slide
• Text- “THANK YOU”
• Font size – 45, You may choose any color
• Placement – Centre of the slide

Resources Required:
Tools, Equipment, and furniture: 1. Personal Computer-1 set
2. Ergonomic chair – 1 pc
Software: 1. Operating system- Windows
2. Application software – Presentation Software

PPE: 1. Rubber sole shoes/sandal – 1 pair

Page 90 of 97
 Sample

WELCOME

Name
Regi No

Slide Layout (Slide Master) Title Slide (1st Slide)

Librarian vs Search Engine
Overall Satisfaction with information provided

60%
48%

Search Engine
Librarian
2nd slide 3rd Slide
Aardvark Advertising Inc. The Important of Graphic and Animation
Jane Peters 14
CEO 12
10 10 mins
Jo Whalley 8 20 mins
PA 6
30 mins
4
2 40 min
Nathan Samms John Blale Mriam Solberg
0
Creative Director Sales IT Animation Graphics Text only

4th Slide 5th Slide

Thank
You!
This Photo by Unknown Author is licensed under CC
6th slide: Insert Video End Slide

Page 91 of 97
 Internet
Job Sheet – 1.A for Computer Operation, Level – 3

Candidate Name:

Job 04. A: Prepare and Submit Form using web platform

Time: 30 Minutes
Unit Covered: OUCO05L3V1: Use Internet and access resources
Instructions:
Read and understand the directions carefully:
▪ this practical demonstration is based on the performance criteria from all or some of the units of
competency in Computer Operation, Level – 3
▪ this assessment activity will be used to measure your underpinning skills
▪ you will have fifteen (15) minutes to familiarise yourself with the resources to be used
Working Procedure/ Steps:
1. Observe and wear personal protective equipment (PPE) as required for the Job.
2. Observe and follow Occupational Health and Safety (OHS) requirements during the demonstration
processes.
3. Read the provided Job and Specification sheet.
4. Collect required tools, materials, and equipment for the job.
5. Prepare PC to perform job smoothly.
6. Create a folder named “NSDA_Reg. no.” at google drive (create mail account if required).
7. Prepare a google form as per sample and specification
8. Save the Form with your “Registration No_CO” into folder created by you.
9. Send the form link over email to your Assessor.
10. Prepare document as per instruction to upload at google form created by you.
11. Fill up and submit the form as per field requirements.
12. Check and review after completion of the job.
13. Submit finished output to the Competency Assessor.
14. Shutdown computer and clean your workplace.
15. Clean tools, equipment, materials, and work area.

Page 92 of 97
 Specification Sheet – 1.A for Computer Operation, Level – 3

Job 04.A: Prepare and Submit Form using web platform

Condition For the Job:

Work must be carried out in a safe manner and according to Computer operation (Level – 3) standards.
Form Title – Assessment on Computer Operation
Subtitle – National Skills Development Authority (NSDA)
Description – This for is used only for assessment purpose to show the competency related to Computer
operation occupation of ICT sector.
Fields –
▪ Name (Mandatory)
▪ Email (Mandatory)
▪ Mobile No (Mandatory) with 11 digits validation
▪ Attached_doc (Mandatory) – No of Attachment – 4, file type - PDF
Document –
▪ Single page scanned PDF file – 3 Nos
▪ Single PDF file made of combined single 3 page (merge single 3 PDFs into one using required offline
application /online site.
Resources Required:
Tools, Equipment, and furniture: 1. Personal Computer – 1 set with Internet connection
2. Ergonomic Chair – 1 Pc

Software/apps: 1. Operating software – Windows

2. Google form
3. PDF reader/writer
4. PDF merge software

PPE: 1. Rubber sole Shoes/Sandal – 1 pair

Page 93 of 97
 Job Sheet – 1.B for Computer Operation, Level – 3

Candidate Name:

Job 04.B: Prepare schedule meeting using Online platform

Time: 30 Min (10 min for Assesses + 20 min for Assessor)
Unit Covered: OUCO05L3V1: Use Internet and access resources
Instructions:
▪ you will have fifteen (15) minutes to familiarise yourself with the resources to be used

Working Procedure/ Steps:

1. Observe and wear personal protective equipment (PPE) as required for the Job.
2. Observe and follow Occupational Health and Safety (OHS) requirements during the demonstration
processes.
3. Read the provided Job and Specification sheet.
4. Collect required tools, materials, and equipment for the job.
5. Prepare PC to perform job smoothly.
6. Schedule a meeting using online platform as per instruction
7. Save the schedule digitally to your calendar.
8. Send the meeting link to your Assessor using social media (except same platform you used for
scheduling the meeting).
9. Check and review after completion of the job.
10. Submit finished output to the Competency Assessor.
11. Attend an online meeting offered by your assessor.
12. Response to your assessor using remote desktop application.
13. Share your screen as per your assessors’ instruction.
14. Shutdown computer and clean your workplace.
15. Clean tools, equipment, materials, and work area.
Specification Sheet – 1.B for Computer Operation, Level – 3

Job 04.B: Prepare schedule meeting using Online platform

Condition For the Job:

Work must be carried out in a safe manner and according to Computer operation (Level – 3) standards.
Platform – Zoom
Social media – WhatsApp
Calendar – Google calendar

Resources Required:

Tools, Equipment, and furniture: 1. Personal Computer – 1 set with Internet connection
2. Ergonomic Chair – 1 Pc

Software/apps: 1. Operating software – Windows

2. Google meet
3. Google calendar
4. WhatsApp
5. Any desk/team viewer

Page 94 of 97
 Job Sheet – 2.A for Computer Operation, Level – 3

Candidate Name:
Job 04. A: Prepare and Submit Form using web platform
Time: 30 Minutes
Unit Covered: OUCO05L3V1: Use Internet and access resources
Instructions:

Read and understand the directions carefully:

▪ this practical demonstration is based on the performance criteria from all or some of the units of
competency in Computer Operation, Level – 3
▪ this assessment activity will be used to measure your underpinning skills
▪ you will have fifteen (15) m!inutes to familiarise yourself with the resources to be used

Working Procedure/ Steps:

16. Observe and wear personal protective equipment (PPE) as required for the Job.
17. Observe and follow Occupational Health and Safety (OHS) requirements during the demonstration
processes.
18. Read the provided Job and Specification sheet.
19. Collect required tools, materials, and equipment for the job.
20. Prepare PC to perform job smoothly.
21. Create a folder named “NSDA_Assessment” at google drive (create mail account if required).
22. Prepare a google form as per sample and specification
23. Save the Form with named “Your Name_Job 4.A” in the folder created by you.
24. Send the shorten link of the form over email to your Assessor.
25. Prepare document as per instruction to upload at google form created by you.
26. Fill up and submit the form as per field requirements.
27. Check and review after completion of the job.
28. Submit finished output to the Competency Assessor.
29. Shutdown computer and clean your workplace.
30. Clean tools, equipment, materials, and work area.

Page 95 of 97
 Specification Sheet – 2.A for Computer Operation, Level – 3

Job 04.A: Prepare and Submit Form using web platform

Condition For the Job:

Work must be carried out in a safe manner and according to Computer operation (Level – 3) standards.
Form Title – Assessment of Computer Operation Level-III
Subtitle – National Skills Development Authority (NSDA)
Description – This is only use for assessment purpose to show the competency related to Computer operation
occupation of ICT sector.
Section: 2 (Two)
1st section fields –
▪ Name (Mandatory Field)
▪ Email (Mandatory Field) and only valid for “@gmail.com”
▪ Mobile No (Mandatory Field) containing 11 digits only and should be valid mobile number in
Bangladesh
2nd section fields –
▪ Occupation (For select 1 and options must interchange for each user)
o Computer Operation
o Graphics Design
o ITS
▪ Number of BNQF level (as dropdown list)
o 1
o 2
o 3
o 4
o 5
o 6
▪ Attachment (Mandatory Field)
o Number of Attachment: 5
o File type: PDF
o Maximum file size: 1MB
Document –
▪ Scanned PDF file of a single page – 3 Nos
▪ Single PDF file made from combination of Scanned PDF single 3 files (merge single 3 PDF files into
1 using offline application/online site.

Resources Required:

Tools, Equipment, and furniture: 3. Personal Computer – 1 set with Internet connection
4. Ergonomic Chair – 1 Pc

Software/apps: 5. Operating software – Windows

6. Google form
7. PDF reader/writer
8. PDF merge software

PPE: 2. Rubber sole Shoes/Sandal – 1 pair

Page 96 of 97