The output this Sports Day Programme will take would be in an A5 booklet. On the middle pages there will be a list of track events with the times. On the back page the will be a half- page advert of Helmcroft Hotel. A list of last year’s record breakers will also be on that page. The information to be output would be the School’s Crest, photographs of the school, an advertisement of Helmcroft Hall and photographs of the new sports hall. The data needed to be output would be record breaking list and the events.
The data that would be needed for the programme as an output are as follows:
- The events and times that they take place (excel).
- Food cost during the day.
- What time the actually starts and finishes.
- Who’s invited
- The people who are running in the races.
- Records of previous events.
Testing is needed to make sure the data and the information is detailed, precise and specific on the document so that people can fully understand it thoroughly with ease. Although testing is not needed at this stage as you are only writing up information.
Analysis for Task 2
For this task I will be using different programs for the different forms. The categories, records list and the list of beverages and food (and prices) would be produced in Excel. The entrance cost would be produced in PowerPoint so it can be created with lots of colours. The price of drinks to make a profit would be the information to be output. The data needed to produce the output would be the model on how many drinks are sold compared to the weather. I would like the best price to result in a profit.
Design – Task 1
The problem that has to be solved is how to arrange the front and back page of the brochure for the school’s Sports Day, and the software that might be useful to achieve this. I shall use Microsoft Word to solve this problem. This is because the functions of the features available on Microsoft Word are necessary for solving the problem.
Firstly, to set about reaching the problem I will use the functions of Word to make titles and sub-titles bold, italic and using the appropriate font size. The reason for this is so they will stand out, allowing the readers to see them more easily as they would be more clearer and more alluring. Secondly, I will use boxes around the text to make them stand out clearer. The text boxes will also allow me to import, position and resize graphics a lot more easily. The boxes and their borders would have bright colours to make the programme less dull. Word also allows graphics (e.g. the Helmcroft Hall advert) to be kept in the same proportions. These graphics are very easy to import using ‘drag and drop’.
Design – Task 2
For Design 1 of the spreadsheet I have shown the basic layout of the:
- Fixed Incomes
- Fixed Expenditures
- Costs of drinks to buy
- Costs of drinks to sell
My design also shows a different layout to what I will be using to display the various weather conditions. For this design I have only shown COLD and COOL conditions, as the rest will follow in my own design.
For my own design of the spreadsheet I will produce the spreadsheet in a horizontal way rather than the original design, provided by the teacher, which was shown vertically. To fit the whole spreadsheet I will make use Arial 10pt font for the main text, the main headline will be Comic Sans MS 18pt font. The sub headlines will be different fonts, two will be Showcard Gothic 14pt font and the others will be Tempus Sans ITC 12pt font. The total headings are produced in bold Arial Narrow 10pt font. The cells with the results of the formulae are formatted to be shown as currency. I varied the widths of the columns to allow the text to fit perfectly; in some parts I merged the cells. The formulae I used were simple, only addition and multiplication sums being used.
For the spreadsheets I will produce I will use Microsoft Excel. The following table outlines the software features needed to produce my Price Pledge Model, and for each feature, the suitability of Excel has been examined. Excel has a simple-to-use replicate feature. I can select a cell (that contains text, a number or formulae), highlight a section to the right and copy the contents of the original cell into those selected to the right. It will automatically change the letter for the column being used as it’s replicated across. Excel can carry out simple calculations.
For example, I need it to calculate the cost of hot drinks, e.g. D4*B8.
Test Plan
Testing for this spreadsheet will be needed, for example:
Test Data
This data is given from last year:
On a warm day, 150 hot drinks and 400 cold drinks were sold.
Cost of drinks: 60p for hot drinks and 54p charged for cold drinks gives a £1 profit.
Cost of drinks: 60p for hot drinks and 53p charged for cold drinks gives a £3 loss.
