|
|
|
|
|
|
|
| Making Biscuits |
| Design Technology Unit 5D & ICT Unit 5C |
|
|
|
|
|
| Basic Ingredients |
1 Batch |
2 Batches |
4 Batches |
4 Batches |
| 200g Flower |
£0.25 |
£0.50 |
£0.75 |
£1.00 |
|
100g Margarine |
£0.15 |
£0.30 |
£0.45 |
£0.60 |
|
|
|
50g Suger |
£0.05 |
£0.10 |
£0.15 |
£2.00 |
|
| 1 Eggg |
£0.12 |
£0.24 |
£0.36 |
£0.48 |
| Pinsh Salt |
£0.01 |
£0.02 |
£0.03 |
£0.14 |
| 1 to 2 tbsps Milk |
£0.05 |
£0.10 |
£0.15 |
£0.20 |
| Optional: Choc chips |
£20.00 |
£40.00 |
£60.00 |
£80.00 |
| Cost per batch |
£20.63 |
£41.26 |
£61.89 |
£84.42 |
|
|
|
|
|
|
|
|
|
|
| 1 |
Check the spreadsheet for spelling mistakes and correct any you find. |
|
|
|
|
|
|
|
|
|
| 2 |
Are there any other errors? Can you correct any that you find? |
|
|
|
|
|
|
| 3a |
Is it likely that the price for Choc chips is correct? |
|
|
|
|
|
|
| 3b |
Do you know the correct price for Choc chips? |
|
|
|
|
|
|
| 3c |
What are you going to do? |
|
|
|
|
|
|
|
|
|
|
| 4a |
Check the prices in Column F by using a line graph for each ingredient. |
|
|
|
|
|
|
|
| 4b |
Were there any errors? How could you tell? Which cells contained errors? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|