IT Support Service

Level-3 (Jobs)

JOB 1

Perform Microsoft Office Application Software.

Condition for the job:

02. Paper size: A4 & Page Orientation: Portrait, Margin size: Top 1”, Bottom:

1”, Left: 0” and Right: 1”.

03. Use Fonts: Arial or other’s similar font.

04. Title text size is 24, Subtitle text size 22 and other text size is 12.

05. Title and Subtitle should be bold.

06. Number of columns: 02. Left column: width 3.21” and Right column:

width 4”.

07. Insert shape in the left column: Height 10.86″ and width 3.21”. Shape fill

color #EBF5D7.

08. Insert picture and set picture size: 2.47” × 2.47” as per sample.

04.

Exampe 5:

Prepare a Business Invoice using MS Word.

Condition for the job:

01.

Prepare and save a sample document to your created folder with named: [Your

Name_Business Invoice].

02.

Paper size:A4 & Page Orientation: Portrait, Margin size: Top 1″, Bottom: 1″, Left: 1″ and

Right: 1″.

03.

Use Fonts: Arial or other’s similar font.

04.

Use Header: Company Title and Footer: Phone, Address.

05.

Title text size is 26, Sub title text size is 16 and other text size is 12.

06.

All Title and Sub title should be bold.

07

. Logo Size: 0.9″ × 0,9″ as per sample.

08

. Set Header and Footer line size: 4.5pt.

Exampe 6:

Exampe 7:

Condition for the job below:

1. Prepare and save the spreadsheet to your created folder with named: [Your

Name_ Mark

Sheet].

2. From the given MARKS table. Find the result using the excel functions:

2.Example Prepare a dynamic cash memo using MS Excel.

Condition for the job:

2.

Apply the formula where required.

3.

Calculate Item wise total.

4

. Calculate Total price.

5

. Let’s VAT is 5%. Calculate total VAT.

6

. Discount is 5% if purchase is greater than 1000tk and 7% when purchase is

greater than 3000tk. Calculate Total Price after Discount.

7.

Calculate Net Price.

8.

The product quantity and prices are changeable.

01.

Hourly Rate: 250 tk. per hour

02

. Over Time: if anyone works more than 8 hours, they will get over time.

Over time rate 500 tk. per hour

03.

Amount: Calculate amount from working hour and over time.

04

. Monthly Income: Calculate Monthly income from amount.

05.

Income Tax:

If monthly income is 12000 tk. to 32000 tk. then tax will be determining 10%,

If monthly income is 32000 tk. to 50000 tk. then tax will be determining 15%,

otherwise 0.

06

. Payment: Calculate Payment from Monthly income – income tax

07.

Insert Column if needed.

Example 4:

1. Prepare the Electricity Bill as per sample.

2. Save the file to your own folder as Electricity Bill.

3. Calculate Units Consumed= Current Units minus Previous Units.

4. Calculate Electricity Charges= If Units Consumed is less than or equal io

100, Rate per unit multiply by 10 tk. Units Consumed between 101 to 200,

Rate per unit multiply by 2 tk. Units Consumed above 200, Rate per unit

multiply by 15_tk..

Charges of 10 percent. If Electricity Charges is greater than or equal to 3000

to 4000, Electricity Charges of 8 percent. !f Electricity Charges is greater

than or equal to 2000, Electricity Charges of 5 percent. If Electricity Charges

is greater than or equal to 1000, Electricity Charges of 3 percent,Otherwise,

0 percent.

6. Bill Payable =Electricity Charges plus Surcharge.

7. Print the saved document (Electricity Bill).

8. Submit to the Assessor.

Example 5: 1. Prepare the Tabulation sheet as per sample.

2. Calculate “Total” only for those students who passed all subjects (Pass Mark 33).

3. Calculate “GPA” based on “Average” as table below:

4. Calculate the “Rank” according to “Total” using proper function.

5. Save the file to your won folder as Task-2.

6. Print the saved document (Task-2)

7. submit to the Assessor.

Example 6:

Name & Salary Sheet].

2. Prepare a salary sheet for M/S Hasan & Sons Co. Id for the month July, 2924

considering the following conditions.

House Rent:

a. When basic is 50000 or above then house rent will be 40% of Basis.

b. When busic is 30000 to 49999 thhen house rent will be 50% of Basic.

c. When basic is Below 30000 then house rent will be 35% of Basic.

04. Medical Allowance is 1500tk.

05. Education Allowance is 750tk,

06. Provident fund is 10% of Basic.

07. Calculate Gross Salary and Net Salary.

08. The basic salary is changeable. Assessor will check formula by changing there

values of Basic salary.

Powerpoint Job 1.3

Condition for the job below:

3.

Insert content with caption in 2nd slide.

4.

Write down the following equation in 3rd slide. Slide Title: Equation.

6

. Create a pie chart and put it in 5th slide.

1. Create and save a presentation file the name: [Your Name_ My

Presentation].

2. Write headings your full name and registration number on the 1st

Slide. Use Arial font size 26 for all or titles and size 21 for body text. All

Title should be bold.

3. Insert picture with caption in 2nd slide.

4. Write down the following equation in 3rd slide. Slide Title: Equation.

5. Create the following sample in 4th slide. Slide Title: Infographic.

6. Create a column chart and put it in 5th slide.

7. On the last slide, write “Thank You” and add animation to the slide.

8. Show your Presentation in a slide show to your Assessor..

Example 3

:

Prepare a presentation using MS PowerPoint.

1. Create and save a presentation file the name: My Presentation

2. Write your name and address on the 1t” Slide. Use Arial font

size 24 for ell headings or titles and size 20 for text body.

3. Insert picture with caption in 2nd slide.

4. Write down the following equation in 3rd slide.

(

𝑎

+

𝑏)2

=

𝑎2

+

2𝑎𝑏

+

𝑏2

(a+b)

3

= a

3

+3a

2

b+3ab

2

+b

3

5. Create the following sample in 4thslide. Title and sub title shouid be

bold.

6. Create a pie chart and put it in 5th slide.

Example 4 :

Condition for the Task-3:

Create and save a presentation file by your name: For example: ‘Sami

Presentation’. Please the following notes:

2.Should Make a presentation slide to add your name in the title on the first Slide.

Every slide Put anything be title, Font Name: Arial, Font Size: 24 for all titles and

others text size: 20. else in subtitle you want on this first slide as your wish.

3

. Insert Title “Welcome to my presentation”fonts and size 72. in second slide. Use Times New Roman Insert

any welcome picture in the slide. Add animation to the title & picture.

4. Write down the following Equation and to add notes in third slide, do the following: In Anmm rows × n

complex matrix is a rectangular array of complex numbers arranged or complex and Mmn.n columns. The

set of all m x ncomplex matrices is denoted as MmnC.

Equation

A =

(

𝟓

𝟐

𝟑

𝟒

𝟕

𝟏

𝟖

𝟓

𝟗

)

A

T

=

(

𝟓

𝟐

𝟑

𝟒

𝟕

𝟏

𝟖

𝟓

𝟗

)

5. Make a circle picture hierarchy chart (As per sample below).

7. Last slide, place: “Thank You” Font: Times New Roman, Text size: 72 & Bold, Text Colour:

Red, Align: Center. To add ‘Grow & Tum’ animation above text.

8. To add end action button & next action button in first slide bottom. To add previous action

button & next action button in every slide bottom. To add go to beginning action button

previous action button in last slide bottom.

9. Piease, slide show to your assessor what have you done.

Example 5 :

Prepare a presentation using MS PowerPoint.

Condition for the job below:

1.Create and save a presentation fil: to your own folder named: [Your Name_ My

Presentation].

2. Write your full name and registratiou number on the 1″ Slide. Use Arial font size 26 for all

headings or titles and size 21 for body text. All Title should be bold.

3. Apply a Theme only on slide-1.

4. Write down the following equation in 2nd slidc. Slide T’itle: Equation.

5. Create the following sample in 3rd slide. Slide Title: Infographic. Add an any animation is

applying on this slide.

6. Create a funnel chart and put it in 4th slide.

JOB 2

Perform Disassemble and Assemble of PC

Example 6

:

2, Write your full name and registration number on the 1″ Slide. Use Arial font size

26 for all headings or titles and size 21 for body text. All Title should be bold.

3. Insert Title “Welcome to my presentation” in 2nd slide. Insert any picture in the

slide. Add animation to the title & picture.

4. Write down the following equation in 3rd slide. Slide Title: Equation.

7. Insert a video with caption in 6th slide.

8. Write “Thank You”, Size: 26 and add animation to the last slide.

9. Show your Presentation in a slide show to yo ir Assessor.

Example 7:

Disassemble parts/ devices of a CPU as mention below:

1.1

Motherboard.

1.2

Processor and Cooling Fan.

1.3

RAM.

1.4

HDD/ SSD/ NVMe/ M.2.

1.5

Optical Disk Drive (ODD).

1.6

Power Supply Unit.

01.

Assemble parts/ devices of a CPU as mention below

:

1.1

Motherboard

1.2

Processor and Cooling Fan

1.3

RAM

1.4

HDD/ SSD/ NVMe/ M.2

1.5

Optical Disk Drive (ODD)

1.6

Power Supply Unit

Job-03

Install OS, Application Software and Utility Software with OS Backup & Recovery.

Office.

4.1 .

Create windows OS Backup

4.

2.

Recover of a Windows OS from (external drive)

Job-04

Connect Workstation to exiting network and using internet.