Computer Operation Level-3 NSDA

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  1.78 inch
Border – Width – 6 pt

Shape (at the top part) – Rounded Rectangular

Shape Size – 6.84 inch  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 other text – 13

Bangla Part (2nd Page)

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

Mail merge
Fields to mail merge – 1. Name 2. e-mail 3. District and 4. Mobile Number
Title Font : Times New Roman
Other text font : Arial
Title font size : 20 pt
Subtitle font size : 14 pt (Salary Sheet)

Cell Formatting As per sample

Logo/Image : Use any image Size – 0.72 inch  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. Value are Auto Fill following below condition
 Principal – 16000
 JPO – 9000
 Trainer – 8500
 Lead Trainer - 9500
 IT Officer – 10000

House Rent (HR) :

 55% of Basic for Designation Principal and IT Officer
 50% of Basic for Designation Lead Trainer and JPO
 60% to other

Medical Allowance (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)
 Sample
Sample -1 (Main Worksheet)
Salary Sheet

SL Basic Gross Net

Emp ID Name Designation HR MA PF IT
No Salary 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
Title Font : Times New Roman
Other text font : Arial
Title font size : 20 pt
Subtitle font size : 14 pt (Salary Sheet)

Cell Formatting As per sample

Logo/Image : Use any image Size – 1 inch  1.05 inch

Date : Using date format (DD-MM-YYYY)

Mobile Name : shown depends on the Product ID

Product ID : Validation (6 Digit, Unique Number)

Use “PCS” in quantity field

Use “BDT Sign” in Amount field

Calculate in Grand Total (All Amount are summation)

Discount : based on Grand Total

 500000 >= 9%
 300000 >= 3%
 300000 < 1%

VAT : Fixed – 3.5%

INDEX & MATCH Function (Sample – 2):

 Prepare Dropdown in Product ID & Product Name
 Shown Rate based on Product Name
 Use Index & Match function for rate
 Sample
Sample -1 (Main Worksheet)

Rashed ICT
EDB Trade Center (5th Floor)
Kazi Nazrul Islam Avenue, Dhaka
www.rashedict.com

Computer Accessorics & Services

Invoice
Customer Name: Date
Address: Mobile No:
Sl
Product ID Product Name Quantity Rate Amount
No
01 RICT01 Laptop 2 PCS 70000.00 140,000.00৳
02 RICT02
03 RICT03
04 RICT04
05 RICT05
06 RICT06
07 RICT07
08 RICT08
09 RICT09
10 RICT10
Grand Total
Discount
ID

VAT
PA

Total
In Word :

Sample – 2 (INDEX & MATCH)

Show the below information as per sample using INDEX & MATCH from sample – 1
Slide Layout – The presentation slide layout must be prepared with “Slide Master”.
Slide Size – Wide screen (16 : 9)
Slide Transitions – 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
and 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  2 inch
 Place object as per sample
nd
2 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.
th
4 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%, 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
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
th
7 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
 Sample

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
 Sample

Title Slide (1st Slide) 2nd Slide: Create infographics using shape

rd 4th Slide: Create a pie chart

3 Slide

5th Slide: Animation 6th Slide: Insert Video

7th Slide: Cropped image from screenshot 8th Slide: Animation

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)
 Designation (Computer Operation, IT Officer, IT Executive, IT Maintenance
Officer) – (Set it Dropdown)
 Email (Mandatory)
 Mobile No (Mandatory) – Number Only with 11 digits validation
 Attacched_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 pages (merge single 3 PDFs into one
using required on application / online site).

Schedule meeting using Online platform

1. Save the schedule digitally to your calendar.
2. Send the meeting link to your Assessor using social media (except same
platform you used for scheduling the meeting).

Platform – Zoom
Social media – WhatsApp
Calendar – Google calendar