• 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

# ICT modelling spreadsheet - This coursework was designed to investigate the uses of electricity bills and how electricity bills are produced.

Extracts from this document...

Introduction

GCSE ICT Modelling Spreadsheet: Write Up Introduction This coursework was designed to investigate the uses of electricity bills and how electricity bills are produced. Firstly we needed to list all of the electrical appliances in our homes and find out how many units of electricity is uses up. These units are measured in kilowatt-hours, meaning how many kilowatts the appliance needs for each hour that it is used. This information was then tabulated into a spreadsheet (as shown on the left). After doing this, we then estimated how long each appliance is going to be used and how many times per week. When the cost of each appliance is calculated, they are all added up to give a total bill. After this, V.A.T. (value added tax) is added on to the price; the V.A.T. is five percent of the cost. Finally, to work out the final bill, the standard charge is added on. The standard charge is a set price from the company, and is the cost of the electricity being supplied to your home. For the supplier 'npower' the standard charge is �21.59, and this is charged annually. However, this cost is just the basic tariff, with no day rates or night rates, and for 'npower' the rate per kilowatt-hour is 6.72p. This rate is used for those who use most of their electrical appliances through the day. This basic rate is the first of two main tariffs. The other tariff is known as economy 7. This is where there are two tariffs, a day rate and a night rate. The day rate is more expensive than the basic rate, at approximately 7.8p per kilowatt-hour. This is the charge between 6am and 11pm. On the other hand, the night rate is much more cheaper, at approximately 2p per kilowatt-hour, and is the charge for each electrical appliance being used between 11pm and 6am. ...read more.

Middle

and the standard charge added on to it. As you can see from this graph, the biggest decline in costs is the 'What if I renew my kitchen' question. This evidently shows that the electrical appliances in the kitchen take up a huge percentage of the final bill. Also, if we were to subtract the standard charge and the V.A.T., the cost for the 'what if' would be an even smaller cost. Model #2 Design and Layout This second model is designed to show a progression from the first model, and is supposed to show a change in design. The change in design for these sets of spreadsheets is that the tariff has been changed from the basic npower rate, of 6.72p per kilowatt-hour, to what is known as economy 7. This tariff is designed so that you are charged a more expensive rate, of 7.8p, during the day, but then charged a much cheaper rate for the electrical appliances used during the night, of about 2.8p per kilowatt-hour. This information is then put into the spreadsheet, one spreadsheet for the day rate and one for the night rate, and then a third sheet is needed, to add together the two bills, add the standard charge and the V.A.T. The original model is to be changed by duplicating the original model twice, one for the day rate and one for the night rate. We then need to work out how many hours of the day each appliance would be used, and then for the night hours. The time-span for the day rate is from 6am to 11pm, and the time-span for the night rate is from 11pm to 6am. Therefore, if an appliance is used during the day and the night, for example, the refridgerator, the amount of hours it is used for during both time-spans would need to be calculated. On the other hand, some parts of the table will remain the same. ...read more.

Conclusion

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Patterns of Behaviour 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

# Related GCSE Patterns of Behaviour essays

1. ## Enzyme Coursework.

I could vary the concentration of yeast suspension solution, but I chose to vary the concentration of Hydrogen Peroxide because as it would be easier to measure out and to carry out the experiment quickly, as I need to repeat the experiment many times.

2. ## Give an account of the properties and uses of phenol

Anti-oxidants are added to certain food products such as potato crisps to reduce rancidity of fats and oils, thereby prolonging the shelf-life of these foods by chemical changes vi. Irradiation - ?-rays prevent spoilage from inside fruit and vegetable and the unbroken skin prevents aerial oxidation.

1. ## Science Coursework

These are three different ways that the rates of reactions can be measured. These are 1. Precipitation This is when the product of a reaction has become cloudy. (In this experiment this method is going to be sued to measure the rate of reaction).

2. ## How Hitler came to power

Enzymes help to turn the substrate into the product. The enzyme has an active site that helps it to recognise its substrate in a very specific way. Each enzyme has its own specific substrate. This is called the Lock and Key Theory. Figure 1 shows that at very high temperatures the enzyme gets damaged and is denatured.

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