D2.
My recording sheet will be made in publisher because it is easy to use and it will give the recording sheets a more professional look. I will produce to A4 printouts. On the first printout it will be a recording sheet for a track event. I am producing a recording sheet for ‘Year 7 Girls 100m’.
At the top of the A4 there will be a title, which shows what event the sheet, will be used for. I will add a text box and add the title ‘Year 7 Girls 100m’.I will underline the title by clicking on the ‘u’ at the top of the screen. I then made the title bold by clicking on the ‘b’ at the top of the screen. The text in the text box will be set to font size 26.
The page will be printed landscape. In the centre of the page I will insert a table by clicking on the ‘table frame tool’ at the side of the screen. The table will have 6 columns and 9 rows. The surname will be bold and in capital and the house name will also be in bold and in capitals.
I will outline the table with a black border. I will import the names of competitors from excel into publisher.On the second printout it will be a recording sheet for a track event. I am producing a recording sheet for ‘Year 8 Boys Long Jump’. At the top of the A4 there will be a title, which shows what event the sheet, will be used for. I will add a text box and add the title ‘Year 8 Boys Long Jump’. I will underline the title by clicking on the ‘u’ at the top of the screen. I then made the title bold by clicking on the ‘b’ at the top of the screen.
The text in the text box will be set to font size 26.The page will be printed landscape. In the centre of the page I will insert a table by clicking on the ‘table frame tool’ at the side of the screen. The table will have 8 columns and 9 rows. The surname will be bold and in capital and the house name will also be in bold and in capitals. The table will be outlined with a black border. I will import the names of competitors from excel into publisher.The table will be outlined with a black border.
I have decided to make it this way because it will look professional, it will be clear and easy for the judges to understand. The will also be enough room for the judges to write the addition information in. The table will make it easy for the amount of points for each house to be totalled up. I have decided to put the surnames of the competitors and the house names in bold and in capitals so it will be easy to see.
It will also make it quicker when totalling up the final points. I decided to set out the recording sheet in the layout I did because the B.S.
A booklet states that for I track event the recording sheet must have 6 columns. (First name, Surname, House, Time, Position, Points.) And it must have 9 rows for each competitor. It also states that for a field event the recording sheet must have 8 columns. (First name, Surname, House, Attempt 1, 2 and 3, Position and Points.)D3.
The software tasks will be: -Excel1. Must be able to export data into publisher. Egg the names of competitors.
2. Must be able to do complex searches. Eg to find all year 7 girls taking part I the 100m.
3. I should be able to print the searches.4.
I should be able to sort data into alphabetical order. Eg House names for each event in order.5. I should be able to create tables.Publisher.6.
I should be able to import data from excel.7. I should be able to print landscape.8. Text should be in black.9. Text should be in bold.
10. Text should be underlined.11. I should be able to create tables.12. I should be able to add text to the table.13. The text size should be 16 and 2014.
The table should be able to be moved around on the page.D4. The software I am going to use to make the recording sheets is Publisher because it can do all my STs. The software I will use for my testing plan and to search for data will be Excel because it meets all my Sts.
ExcelST12345EXCELThe ticks in this table show that the Software Task has been met. The table shows that all the S.Ts in Excel have been met.PublisherST67891011121314PUBThe ticks in this table show that the Software Task has been met.
The table shows that all the S.Ts in Publisher have been met.D5. Testing PlanI will manually search for all the competitors in the ‘Girls Year 7 100m’ and all the competitors in the ‘Boys Year 8 Long Jump’ so I could find out who is taking part in each event.I will then search for the same information electronically using Excel and I should get the same results.The competitors in the year 7 girls 100m are: