• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  • Level: GCSE
  • Subject: Maths
  • Word count: 2727

Software Applications

Extracts from this document...

Introduction

Page  /         133498.doc        10/05/2007

image00.jpg

Unit 20

Software Applications

By Iman Sharif 20004544

image01.jpg


Index – Unit 20

Iman Sharif 20004544

Finished

Index – Unit 20

Task-01a.xls

Task-01b.xls

Task-01c.xls

Task-01d.xls

Task-01e.xls

Task-02.doc

Task-03a.doc

Task-03b.doc

Task-03c.doc

Query-01

Form-01

Form-02

Report-01

Report-02

Report-03

Task-05.ppt


Task-01a.xls

Make

Model

Cost Price

No. in stock

Stock value

Stock value by make

Packard Bell

PB 100

£768.00

1123

£862,464.00

PB 110

£899.00

356

£320,044.00

PB 140

£901.00

17

£15,317.00

PB 160

£1,001.00

378

£378,378.00

PB 180

£1,201.00

24

£28,824.00

PB 200

£1,010.00

65

£65,650.00

PB 220

£1,233.00

98

£120,834.00

PB 260

£1,424.00

397

£565,328.00

Pb 290

£1,579.00

567

£895,293.00

PB 390

£1,657.00

25

£41,425.00

Sub total

£3,293,557.00

Sony

S-100

£745.00

58

£43,210.00

S-200

£1,104.00

1287

£1,420,848.00

S-300

£1,226.00

36

£44,136.00

S-400

£1,010.00

748

£755,480.00

S-500

£1,114.00

38

£42,332.00

S-600

£1,420.00

66

£93,720.00

S-700

£1,563.00

487

£761,181.00

S-800

£1,729.00

101

£174,629.00

S-900

£1,749.00

294

£514,206.00

S-1000

£1,882.00

73

£137,386.00

Sub total

£3,987,128.00

Toshiba

T1

£1,206.00

2654

£3,200,724.00

T2

£1,324.00

86

£113,864.00

T3

£1,598.00

43

£68,714.00

T4

£1,700.00

32

£54,400.00

T5

£1,740.00

228

£396,720.00

T6

£1,900.00

2

£3,800.00

T7

£2,001.00

89

£178,089.00

T8

£2,112.00

183

£386,496.00

T9

£2,126.00

166

£352,916.00

T10

£2,190.00

276

£604,440.00

Sub total

£5,360,163.00

Grand TOTAL

£12,640,848.00


Task-01b.xls

Make

Model

No. in stock

Retail price

% Margin

Packard Bell

PB 100

1123

£999.00

23%

PB 110

356

£1,009.00

11%

PB 140

17

£1,199.00

25%

PB 160

378

£1,230.00

19%

PB 180

24

£1,299.00

8%

PB 200

65

£1,499.00

33%

PB 220

98

£1,530.00

19%

PB 260

397

£1,699.00

16%

Pb 290

567

£1,799.00

12%

PB 390

25

£1,899.00

13%

Sub total

18%

Sony

S-100

58

£999.00

25%

S-200

1287

£1,200.00

8%

S-300

36

£1,300.00

6%

S-400

748

£1,399.00

28%

S-500

38

£1,449.00

23%

S-600

66

£1,699.00

16%

S-700

487

£1,799.00

13%

S-800

101

£1,849.00

6%

S-900

294

£1,999.00

13%

S-1000

73

£2,049.00

8%

Sub total

15%

Toshiba

T1

2654

£1,499.00

20%

T2

86

£1,549.00

15%

T3

43

£1,749.00

9%

T4

32

£1,899.00

10%

T5

228

£1,949.00

11%

T6

2

£2,049.00

7%

T7

89

£2,199.00

9%

T8

183

£2,249.00

6%

T9

166

£2,299.00

8%

T10

276

£2,399.00

9%

Sub total

10%

Grand TOTAL


Task-01c.xls

Make

Model

No. in stock

Retail price

% Margin

Packard Bell

PB 100

1123

999

23%

PB 110

356

1009

11%

PB 140

17

1199

25%

PB 160

378

1230

19%

PB 180

24

1399

14%

PB 200

65

1499

33%

PB 220

98

1530

19%

PB 260

397

1699

16%

Pb 290

567

1799

12%

PB 390

25

1899

13%

Sub total

18%

Sony

S-100

58

999

25%

S-200

1287

1300

15%

S-300

36

1400

12%

S-400

748

1399

28%

S-500

38

1449

23%

S-600

66

1699

16%

S-700

487

1799

13%

S-800

101

1999

14%

S-900

294

1999

13%

S-1000

73

2200

46%

Sub total

21%

Toshiba

T1

2654

1499

20%

T2

86

1549

15%

T3

43

1849

14%

T4

32

1899

10%

T5

228

1949

11%

T6

2

2149

12%

T7

89

2299

13%

T8

183

2349

10%

T9

166

2399

11%

T10

276

2499

12%

Sub total

13%

Grand TOTAL

...read more.

Middle

PB 140

901

17

15,317

1,199

25%

PB 160

1,001

378

378,378

1,230

19%

PB 180

1,201

24

28,824

1,399

14%

PB 200

1,010

65

65,650

1,499

33%

PB 220

1,233

98

120,834

1,530

19%

PB 260

1,424

397

565,328

1,699

16%

Pb 290

1,579

567

895,293

1,799

12%

PB 390

1,657

25

41,425

1,899

13%

Sub total

3,050

3,293,557

18%

Sony

S-100

745

58

43,210

999

25%

S-200

1,104

1,287

1,420,848

1,300

15%

S-300

1,226

36

44,136

1,400

12%

S-400

1,010

748

755,480

1,399

28%

S-500

1,114

38

42,332

1,449

23%

S-600

1,420

66

93,720

1,699

16%

S-700

1,563

487

761,181

1,799

13%

S-800

1,729

101

174,629

1,999

14%

S-900

1,749

294

514,206

1,999

13%

S-1000

1,882

73

137,386

2,200

14%

Sub total

3,188

3,987,128

17%

Toshiba

T1

1,206

2,654

3,200,724

1,499

20%

T2

1,324

86

113,864

1,549

15%

T3

1,598

43

68,714

1,849

14%

T4

1,700

32

54,400

1,899

10%

T5

1,740

228

396,720

1,949

11%

T6

1,900

2

3,800

2,149

12%

T7

2,001

89

178,089

2,299

13%

T8

2,112

183

386,496

2,349

10%

T9

2,126

166

352,916

2,399

11%

T10

2,190

276

604,440

2,499

12%

Sub total

3,759

5,360,163

13%

Grand TOTAL

9,997

12,640,848


Task-01e.xls

image06.png


Task-02.doc

image07.png


Task-03a.doc

Toshiba

Sony

Packard Bell

Margin

10.53%

17%

19%

image08.png

Task-03b.doc


image09.png

Task-03c.doc

image10.png


Query-01

Make

Model

Proc_speed

Price

P

PB 100

1.0

£999

P

PB 110

1.1

£1009

P

PB 140

1.4

£1199

P

PB 160

1.6

£1230

P

PB 180

1.8

£1299

P

PB 200

2.0

£1499

P

PB 220

2.2

£1539

P

PB 260

2.6

£1699

P

PB 290

2.9

£1799

P

PB 320

3.2

£1899

S

S-100

1.0

£999

S

S-200

1.5

£1200

S

S-300

1.6

£1300

S

S-400

1.8

£1399

S

S-500

2.0

£1449

S

S-600

2.2

£1699

S

S-700

2.4

£1799

S

S-800

2.8

£1849

S

S-900

3.0

£1999

S

S-1000

3.4

£2049

T

T1

0.9

£1499

T

T2

1.0

£1549

T

T3

1.2

£1749

T

T4

1.4

£1899

T

T5

1.8

£1949

T

T6

2.2

£2049

T

T7

2.4

£2199

T

T8

3.0

£2249

T

T9

4.0

£2299

T

T10

5.0

£2399

T

T11

5.5

£2499


Form-01

Cat_no

Make

Model

Proc_make

Proc_speed

Memory

Price

Hard_drive

Screen

Dvd

Cdw

Colour

LTL1/001

P

PB 100

Pentium

1.0

256

£999

10

14.2

No

Yes

Black

LTL1/002

P

PB 110

Pentium

1.1

256

£1009

12

14.2

No

Yes

Black

LTL1/003

P

PB 140

Pentium

1.4

256

£1199

12

14.2

No

Yes

Black

LTL1/004

P

PB 160

Pentium

1.6

256

£1230

12

14.2

No

Yes

Black/Silver

LTL1/005

P

PB 180

Pentium

1.8

512

£1299

13

14.7

No

Yes

Black/Silver

LTL1/006

P

PB 200

Pentium

2.0

512

£1499

13

14.7

No

Yes

...read more.

Conclusion

SS-900Pentium3.0512£19991815.1YesYesAqua/Black19

LTL2/010SS-1000Pentium3.4512£20491815.1YesYesAqua/Black20

LTL3/001TT1AMD0.9512£14991314.7NoYesSilver21

LTL3/002TT2AMD1.0512£15491315.1YesYesSilver22

LTL3/003TT3AMD1.2512£17491315.9YesYesSilver23

LTL3/004TT4AMD1.4512£18991315.9YesYesSilver24

LTL3/005TT5AMD1.8512£19491915.9YesYesSilver25

LTL3/006TT6AMD2.2512£20491915.9YesYesSilver26

LTL3/007TT7AMD2.4512£21991915.9YesYesSilver27

LTL3/008TT8AMD3.0512£22491915.9YesYesSilver28

LTL3/009TT9AMD4.0512£22991915.9YesYesSilver/Gre29

en

LTL3/010TT10AMD5.0512£23992015.9YesYesSilver/Gre30

en

LTL3/011TT11AMD5.5512£24992215.9YesYesSilver/Re31

d

29 August 2006Page 1 of 1


Report-02

report-2 Iman Sharif

MakeModelProc_speedPrice

PPB 1001.0£999

PPB 1101.1£1009

PPB 1401.4£1199

PPB 1601.6£1230

PPB 1801.8£1299

PPB 2002.0£1499

PPB 2202.2£1539

PPB 2602.6£1699

PPB 2902.9£1799

PPB 3203.2£1899

SS-1001.0£999

SS-2001.5£1200

SS-3001.6£1300

SS-4001.8£1399

SS-5002.0£1449

SS-6002.2£1699

SS-7002.4£1799

SS-8002.8£1849

SS-9003.0£1999

SS-10003.4£2049

TT10.9£1499

TT21.0£1549

TT31.2£1749

TT41.4£1899

TT51.8£1949

TT62.2£2049

TT72.4£2199

TT83.0£2249

TT94.0£2299

TT105.0£2399

TT115.5£2499

29 August 2006Page 1 of 1


Report-03

report-01 Iman Sharif

Cat_noPrice

LTL1/001£999

LTL1/002£1009

LTL1/003£1199

LTL1/004£1230

LTL1/005£1299

LTL1/006£1499

LTL1/007£1539

LTL1/008£1699

LTL1/009£1799

LTL1/010£1899

LTL2/001£999

LTL2/002£1200

LTL2/003£1300

LTL2/004£1399

LTL2/005£1449

LTL2/006£1699

LTL2/007£1799

LTL2/008£1849

LTL2/009£1999

LTL2/010£2049

LTL3/001£1499

LTL3/002£1549

LTL3/003£1749

LTL3/004£1899

LTL3/005£1949

LTL3/006£2049

LTL3/007£2199

LTL3/008£2249

LTL3/009£2299

LTL3/010£2399

LTL3/011£2499

29 August 2006Page 1 of 1


Task-05.ppt

Slide 1

image11.png

Slide 2

image12.png

Slide 3

image13.png

Slide 4

image02.png

Slide 5

image03.png

Slide 6

image04.png

Slide 7

image05.png

Iman Sharif        SRN: 20004544        

...read more.

This student written piece of work is one of many that can be found in our GCSE T-Total section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE T-Total essays

  1. T-Total Maths

    + 7 = 45+7 = 52 As expected, the equation has produced yet another correct answer. Another example is below, N= 10 T= (5x 10) + 7 = 50+7 = 57 Here is the last equation I will show from the 7 by 7 grid to show that the equation N=11 T= (5x11)

  2. Compile a report which will look at, and assess the performance of sales generated ...

    From the pie chart, we can see that the south region is leading with the highest total sales of �24,599,000, which is approximately 41% of the total sales in the uk. The north region is following closely behind with �21,169,000 - approximately 35%, whilst the east region has the lowest proportion of the total sales with �14,559,000 - approximately 24%.

  1. For this task we were required to create a model that can be used ...

    This gives you the total cost for the units. A standing charge is usually not added to a split rate model. However VAT for most companies are still applied and are applied on the total cost for all of the units. After the VAT has been applied, a total cost can be obtained by the total of the cost for the units and the VAT cost.

  2. Pay Role Model.

    The second change I did was changing Bryson's total hrs from 70 to 50. So this is a decrease in the total hours Bryson works so his overall net pay will decrease The third change is the same as before I changed the hours worked.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work