A Resource for Free-standing Mathematics Qualifications

Data Sheet

A store has a sale of four different types of goods. The normal prices and the percentage reductions in the sale are given below.

MP3 Players

LOGIK 256MB LCD CREATIVE V200 FM 256Mb SUPPORT + Ellipse Silver 1Gb Q-Be 512Mb Pink SONY NWA1000 Black 6Gb ARCHOS AV7100 Multimedia

10% off

39.99 54.99 64.99 84.99 159.99 549.99

Televisions

SAMSUNG LW15M23CX DAEWOO DSL17D3 MAXIM 11-57 HITACHI 37LD6600 PANASONIC 32LXD500 PHILIPS 50PF9966

20% off

279.99 299.99 599.00 1499.99 1799.99 2999.00

DVD Players

MATSUI DVD227 FERGUSON-DVD3051 PHILIPS DVP3005 TOSHIBA SD150E MAXIM 11-21 SONY DVPNS52P

30% off

24.99 34.99 39.99 44.98 49.99 69.99

Digital Cameras

KODAK C340 PENTAX OPT60 FUJI Z1 SILVER CANON IZOOM NIKON 7900 OLYMPUS SP500

25% off

99.89 129.00 199.89 254.89 259.89 299.89

Photo-copiable

The Nuffield Foundation

Worksheet

The normal prices and percentage reductions in the sale are given in the spreadsheet. Finding the Reductions The blue cell, C3 shows the price reduction on the first MP3 player. This is 10% of 39.99 Click on the C3 cell so that you can see the spreadsheet formula: =0.1*B3 This works because 10% =

= 0.1 = 100 10

Use formulae (or fill down) to find the price reductions on the other MP3 players. The price reduction on televisions is 20%. As a decimal 20% =

= = 0.10

Click on the blue C 10 cell so that you can see the spreadsheet formula: =0.2*B10 Use formulae (or fill down) to find the price reductions on the other televisions. DVD prices are reduced by 30% and digital camera prices by 25%. Write these percentages as decimals 30% =. 25% =. (Ask your tutor to check your answers.) Use formulae to find the price reductions on DVDs and digital cameras.
Finding the Sale Prices The first green cell, D3, shows the sale price of the first MP3 player. Click on the D3 cell so that you can see the spreadsheet formula: =B3-C3 Use formulae (or fill down) to find the sale prices of all the other goods. Print your spreadsheet table. The answers can be checked using estimates. Example : The OLYMPUS SP500 (last in the table) normally costs 299.89 This is roughly 300. One way of finding 25% of 300 is to find 10% first. As 10% is one tenth, just divide 300 by 10. 10% of 300 = 30 20% of 300 = = 60 5% of 300 = = 15 25% of 300 = 60 + 15 = 75 Sale Price = 225
Alternative Method for 25% 1 25% = , so we can estimate the reduction by 5 dividing by 4:
Use estimates to check the other values on the spreadsheet.

Teacher Notes

Unit Foundation Level, Managing money
Skills used in this activity: using spreadsheet formulae (fill down optional) writing percentages as decimals checking calculations using estimates Preparation Each student will need: a copy of the data sheet and worksheet to know how to use spreadsheet formulae and access to the Sale spreadsheet Answers 30% = 0.3 25% = 0.25
Normal Price Reduction Sale Price 4.00 35.99 39.99 5.50 49.49 54.99 6.50 58.49 64.99 8.50 76.49 84.99 16.00 143.99 159.99 549.99 55.00 494.99 279.99 299.99 599.00 1,499.99 1,799.99 2,999.00 24.99 34.99 39.99 44.98 49.99 69.99 99.89 129.00 199.89 254.89 259.89 299.89 56.00 223.99 60.00 239.99 119.80 479.20 300.00 1,199.99 360.00 1,439.99 599.80 2,399.20 7.50 10.50 12.00 13.49 15.00 21.00 24.97 32.25 49.97 63.72 64.97 74.97 17.49 24.49 27.99 31.49 34.99 48.99 74.92 96.75 149.92 191.17 194.92 224.92
MP3 Players 10% off LOGIK 256MB LCD CREATIVE V200 FM 256Mb SUPPORT + Ellipse Silver 1Gb Q-Be 512Mb Pink SONY NWA1000 Black 6Gb ARCHOS AV7100 Multimedia Televisions 20% off SAMSUNG LW15M23CX DAEWOO DSL17D3 MAXIM 11-57 HITACHI 37LD6600 PANASONIC 32LXD500 PHILIPS 50PF9966 DVDs 30% off MATSUI DVD227 FERGUSON-DVD3051 PHILIPS DVP3005 TOSHIBA SD150E MAXIM 11-21 SONY DVPNS52P Digital Cameras 25% off KODAK C340 PENTAX OPT60 FUJI Z1 SILVER CANON IZOOM NIKON 7900 OLYMPUS SP500

Possible Extensions Discuss other ways of checking the sale price. For example, a 10% reduction means the sale price is 90% of the normal price. The spreadsheet could be extended to include checks of this sort, or estimates used. Students could set up a spreadsheet of their own to calculate other prices involving discounts, price increases or VAT.

TENTATIVE subject to change

37LD6600 LCD

Television
Hitachis new 37LD6600 LCD Widescreen Television combines the latest flat panel technology with stylish design. Offering a whole range of features, this LCD TV will fit perfectly into any environment.

Product Features

94cm Visible LCD Widescreen Television HD Ready Built-in TV Tuner High Screen Resolution of 1366 x 768 Pixels 2 x SCART Sockets HDMI and Component Sockets Side Input Terminal 15p D-Sub PC Socket Panel Luminance of 500 cd/m 2 Contrast Ratio 800:1 (typ) 2 x 8W RMS Output Headphone Socket for Personal Viewing
HITACHI DIGITAL MEDIA Hitachi Europe Ltd Whitebrook Park Lower Cookham Road Maidenhead Berkshire SL6 8YA Tel: 000 Fax: 500 www.hitachidigitalmedia.com
The HD ready Logo is a trademark of EICTA. HDMI, the HDMI logo and High-Definition Multimedia Interface are trademarks or registered trademarks of HDMI Licensing LLC.
The above specifications are for reference only and are subject to change. Version 1 06/07/05

37LD6600 LCD Television

Technical Specifications

Picture

Screen Size Pixels Processor Response Time Panel Luminance (Typical) Contrast Text Pages 94 cm Visible 1366 x 768 I3 9ms (Typ) G to G 500cd/m 2 800:1 (Typ) 1000
Programmes Cable/Hyperband European Specifications 100 y/y PAL/SECAM II/BG/LL/DK

Video Signal Input

Input signals PAL/SECAM/PAL60/NTSCS4.43/3.58
RMS Output Dynamic Bass Matrix 3DS y n y 2 x 8W

Connections

Speaker Terminals 15 Pin D-Sub PC RGB DVI Input HDMI Input Composite Video S-VHS Video Component Video Progressive Input PAL/NTSC SCART Socket Audio In Audio Out n y y y y y 2 y y n y (after first production) tbc Via SCART y Turkey tbc / <3W tbc ( tbc kg Panel only) 934 x704 x 301mm 934 x tbc x tbcmm UK,F,Ge,It,Sp,Swe,Nor,Gre,Tur,Dut,Por,Dan,Fin UK,F,Ge,It,Sp,Swe,Nor,Gre,Tur,Dut,Por,Dan,Fin TBC HITACHI DIGITAL MEDIA Hitachi Europe Ltd Whitebrook Park Lower Cookham Road Maidenhead Berkshire SL6 8YA Tel: 000 Fax: 500 www.hitachidigitalmedia.com

General

Demo Mode Hotel Mode Video Line Out Audio Line Out Country of Origin Power Consumption/Standby Weight Dimensions (WxHxD inc speakers and stand) (WxHxD Exc speakers and stand) OSD Languages IB Languages EAN code