Home

Unit G064 - Exemplar website project

Contents

1. PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Number of records found 2 1 County Tournament Sport Hockey Date 2011 10 11 Start Time Venue John Spence Staff Member A Dress Second Staff Member None Transport Booked Yes Lunch Required Yes Group Size 12 Date Added 2012 10 20 15 33 15 2 Schools Cup Round 1 Sport Cross Country Date 2011 10 28 Start Time Venue Alnwick Staff Member A Dress Second Staff Member A Lille Transport Booked Yes Lunch Required Yes Group Size 25 Date Added 2012 10 20 16 11 36 You have searched for lunch with the criteria Yes Fixture search page Log out 89 Staff Search Results Custom Search By Venue results php COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Number of records found 1 1 National Schools Tournament Sport Hockey Date 2011 10 05 Start Time Venue The Parks Staff Member A Dress Second Staff Member None Transport Booked Yes Lunch Required Group Size 12 Date Added 2012 10 20 15 32 06 You have searched for venue with the criteria The Parks Fixture search page Log out Staff Search Results Custom Search By Support Staff results php COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Informa
2. Lunch Booked and have typed in the criteria Yes with Group Size 25 Date Added 2012 10 20 16 11 36 3 results being displayed and the search criteria 3 Schools Cup confirmed at the end of the search results Sport Athletics Date 2012 06 13 Start Time Venue Gateshead Stadium Staff Member H Lille Second Staff Member None Transport Booked No Lunch Required Yes Group Size 30 Date Added 2012 10 21 11 29 10 You have searched for lunch with the criteria Yes Fixture search page Log out Invalid data entry for sport and staff name is not allowed on the new fixture form You are logged in as hdu You are logged in as hdu Sport Athletics 7 Sport Athletics Cross Country Date yyyy immiy dd Bane Su aL JL ae l Time of Day H Dune Time of Day Netball J Hamilton H Lille Lead Staff Member x J Walton Wheel Assistant Staff Member None Swimming es Venue Venue Tennis Lead Staff Member Squash Assistant Staff Member None ie aS Year 7 Year 10 Year 10 Year Group s Year B Year 11 Year 11 Year 9 Year Year Group s Years Year Fixture search page Fivtiires caarrh nana darts the drop down box would not allow any other Spoon the drop down box would not allow any values to be entered and simply highlighted other values to be entered and simply different values based on the keyboard letter highlighted different values based on the selected
3. echo lt br gt Second Staff Member echo stripslashes Srow staff2 echo lt br gt Transport Booked echo stripslashes Srow transport echo lt br gt Lunch Required echo stripslashes Srow lunch echo lt br gt Group Size echo stripslashes Srow size echo lt br gt Date Added echo stripslashes Srow dateadded echo lt font gt lt p gt gt lt span gt lt span class h2 gt You have searched for the sport lt span gt lt span class body gt lt php echo S_POST fsearchsport gt lt span gt lt span class h2 gt for lt span gt lt span class body gt lt php echo S_POST fsearchyear echo lt br gt lt br gt lt a href fixturesrcstaff php gt Fixture search page lt a gt lt br gt lt br gt echo lt a href logout php gt Log out lt a gt lt br gt gt 86 lt span gt lt p gt Staff Search Results Custom Search By Transport results php COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Number of records found 2 1 Schools Cup Regional Round Sport Cross Country Date 2011 11 12 Start Time Venue Leeds Staff Member A Lille Second Staff Member J Walton Transport Booked No Lunch Required Group Size 25 Date Added 2012 10 20 16 53 05 2 Tyne and Wear Knockout Sport Netball Date 2012 01 17 Start Time
4. echo stripslashes Srow size echo lt br gt Date Added echo stripslashes Srow dateadded echo lt font gt lt p gt gt lt span gt lt span class h2 gt You have searched for the staff member lt span gt lt span class body gt lt php echo _POST fsearchstaff echo lt br gt lt br gt lt a href fixturesrcstaff php gt Fixture search page lt a gt lt br gt lt br gt echo lt a href logout php gt Log out lt a gt lt br gt gt lt span gt lt p gt 84 Staff Search Results By Sport and Year Group staffsrcsportyear php PE Department Fixtures Diary COMBE ABBEY SCHOOLS Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Search Results Number of records found 2 1 National Schools Tournament Sport Hockey Date 2011 10 05 Start Time Venue The Parks Staff Member A Dress Second Staff Member None Transport Booked Yes Lunch Required Group Size 12 Date Added 2012 10 20 15 32 06 2 County Tournament Sport Hockey Date 2011 10 11 Start Time Venue John Spence Staff Member A Dress COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Search Results Number of records found 1 1 Friendly Sport Hockey Date 2011 10 17 Start Time Venue Westgate Staff Member J Walton Second
5. else echo lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt delete has failed lt font gt mysql_close Sconn gt lt br gt lt br gt lt span class body gt You have deleted record number lt span gt lt span class body gt lt php echo _POST fdelete echo lt br gt lt br gt lt a href fixturesrcstaff php gt Fixture search page lt a gt lt br gt echo lt br gt lt a href deleteform php gt Delete another fixture lt a gt lt br gt echo lt br gt lt a href newfixture php gt Add a new fixture lt a gt lt br gt echo lt br gt lt a href logout php gt Log out lt a gt lt br gt gt lt td gt lt tr gt lt table gt lt span gt lt p gt lt EndEditable gt lt div gt lt div gt 74 Staff Search Page Not Logged In fixturesrcstaff php If anyone tries to access the fixture search page when COMBE ABBEY SCHOOLS not logged in they are denied access a message is PE Department Fixtures Diary displayed to inform them that they must be logged in Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Search Page Staff Only You are not logged in Only staff may see this page Back to login page Log out Staff Search Page Logged In Once logged in authorised users can carry out a range of searches All searches use a drop down selection box allowing the user to se
6. School Calendar By obtaining a copy of the calendar can see how this information is laid out what information is provided to pupils staff and parents and it will also give me some fixture dates which I can enter into the diary system to check that it is working correctly EXTRA CURRICULAR TIMETABLE 2010 2011 AUTUMN AND SPRING TERM Year 7 9 Choir B G Music Room SD Year 8 sports activity B Sports Hall WPH Year 10 Hockey SR Year 4 6 Football RW MONDAY Year 11 12 13 netball G Sports Hall JD AL Junior sports priority 7 8 9 12 05 12 55 Maths lub Year 7 9 R 84 Junior Gym club B G GYM VW Year 7 History Club B G Room 22 JC Year 7 hockey G ASTRO JD Year 8 speech drama lessons Year 7 9 Technology Club B G Lab F SWr Year 11 speech drama lessons Orchestra Music Room B G MD Rugby Positional Skills Training AC Year 10 amp 11 Open Art Sessions DAGS DABS Gillie ZA Year10 13 Weight Training Weights Room LF Year 9 speech drama lessons Year 7 13 Amnesty Group B G Room 87 Yr 8 Netball Sports Hall HD Junior Band Music Room B G Y 9 10 netball Sports Hall AL Year 7 speech drama lessons Year 9 amp 10 Netball Sports Hall AL WEDNESDAY Senior sport Priority evening Y10 11 12 13 Year 7 Activity B Sports Hall WPH Year 10 speech drama lessons 7 13 Chess club DO C KW Junior Dept netball G KC Y7 netball HW Year 9 hockey astro SR Junior Dept Country Dancing Junior Netball JK Y 7 9 Science Cl
7. lt span gt lt span class h2 gt You have searched for the year group lt span gt lt span class body gt lt php echo S_POST fsearchyearonly echo lt br gt lt br gt lt a href fixturesrcstaff php gt Fixture search page lt a gt lt br gt lt br gt echo lt a href logout php gt Log out lt a gt lt br gt gt lt span gt lt p gt 80 Staff Search Results By Sport staffsrcsport php Home Page Fixture List Fixture Search Club Information PE Department Fixture Search Results Number of records found 3 1 National Schools Tournament Sport Hockey Date 2011 10 05 Start Time Venue The Parks Staff Member A Dress Second Staff Member None Transport Booked Yes Lunch Required Group Size 12 Date Added 2012 10 20 15 32 06 2 County Tournament Sport Hockey Date 2011 10 11 Start Time Venue John Spence Staff Member A Dress Second Staff Member None Transport Booked Yes Lunch Required Yes Group Size 12 Date Added 2012 10 20 15 33 15 3 Friendly Sport Hockey Date 2011 10 17 Start Time Venue Westgate Staff Member J Walton Second Staff Member None Transport Booked Yes Lunch Required Group Size 12 Date Added 2012 10 20 15 34 06 You have searched for the sport Hockey Fixture search page Log out PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information Fixture Search Results Number of records found 0
8. lt span gt lt span class h2 gt with the criteria lt span gt lt span class body gt lt php echo _POST fsearchcriteria echo lt br gt lt br gt lt a href fixturesrcstaff php gt Fixture search page lt a gt lt br gt lt br gt echo lt a href logout php gt Log out lt a gt lt br gt gt lt span gt lt p gt 92 Evidence of the System CSS The site has been developed using the style requirements provided by Miss Chew Each page is linked to the CSS file CssStyle css via the website template Heading background color CF3131 width 1000px height 50px font family verdana Geneva Tahoma sans serif font size 16px font weight bold color FFFFFF text align left vertical align middle banner height 150px width 1000px 1 font family verdana Geneva Tahoma sans serif font size 14px font weight bold color 4C4C4D 2 font family verdana Geneva Tahoma sans serif font size 12px font weight bold color 4C4C4D main background color DCDDDE width 1000px height auto position absolute body font family verdana Geneva Tahoma sans serif font size 12px color 4C4C4D font family verdana Geneva Tahoma sans serif font size 14px font weight bold color 4C4C4D navigation background color DCDDDE position absolute width 200px float left maint background color DCDDDE width 1000px
9. Allows a logged in user to select a sport then displays the relevant results Fixture Search Page Staff Only PE Department Fixtures Diary You are logged in as adr Home Page Fixture List Fixture Search C Use the forms below to search for fixtures Fixture Search Results Search by Year Group Search by Sport Number of records found 2 Select Year Group Year Select Sport Hockey a 1 National Schools Tournament Sport Hockey Date 2011 10 05 Start Time Venue The Parks Search by Staff Search by Sport and Year Group Staff Member A Dress Select Staff Member A Dress Select Sport _ Athletics a Second Staff Member None submit Search Criteria Year Transport Booked Yes Lunch Required No Group Size 12 Add a new fixture Date Added 2012 10 20 17 03 25 submit submit submit 2 County Tournament Log out Sport Hockey Date 2011 10 11 Start Time PASS The logged in user has selected the sport of hockey and 2 results have been displayed with the search criteria Venue John Spence Staff Member A Dress Second Staff Member None Transport Booked Yes Lunch Required Yes Group Size 12 Date Added 2012 10 20 15 33 15 confirmed at the end of the search results You have searched for the sport Hockey Fixture search page Log out 113 Allows a logged in user to select a year group then displays the relevant results PE Department Fixtures Diary 8 Newcastle Schools Gala S
10. O yi3 char 3 latint _swedish_ci No No gt JSXAD SB Es t CheckAll UncheckAllWithseleced JY X 0 D E A Table Data Fixtures Show 30 row s starting from record O in mode and repeat headers after 100 cells Sonbykey None Options eventid sport event date venue staffi staff2 timeoday starttime dateadded transport lunch size y7 y8 y9 y10 yii y12 y13 Onr 21 gt s 3 Cross Country Schools Cup Regional Round 2011 11 12 Leeds A Lille JWalton Morning 09 00 00 2012 10 20 17 03 25 No No 25 Yes Yes Yes Yes Yes Yes Yes O Z X 18 Netball County Tournament 2011 10 18 Blue Flames JWalton None Morning 11 00 00 2012 10 20 17 03 25 Yes No 30 Yes Yes Yes Yes Yes I AA 2 Cross Country Schools Cup Round 1 2011 10 28 Alnwick A Dress ALille Afternoon 12 00 00 2012 10 20 16 11 36 Yes Yes 25 Yes Yes Yes Yes Yes Yes Yes TA 1 Swimming ESSA Regional Trials 2011 10 20 Neptune Centre Middlesbrough J Wheel NULL Evening 17 00 00 2012 10 20 17 03 25 Yes No 16 Yes Yes Yes Yes Yes Yes Yes D s 15 Hockey Friendly 2011 10 17 Westgate J Walton None Evening 17 00 00 2012 10 20 17 03 25 Yes No 12 Yes Yes O AA 14 Hockey County Tournament 2011 10 11 John Spence A Dress None Afternoon 12 00 00 2012 10 20 15 33 15 Yes Yes 12 Yes Yes DF Al 13 Hockey National Schools Tournament 2011 10 05 The Parks A Dress None Afternoon 11 00 00 2012 10 20 17 03 25 Yes No 12 Yes Yes g alee 22 Netball City Tournament 2011 11 30 Westfield H Lille None Afternoon 16 00 00 2012 10 20 17 03 25 Yes No
11. PE Trampoline National gymnast and competed for Great Britain 1996 to 2003 Netball Years 9 and 10 p Athletics HOEN some background Mrs H Lile TAMS Current member of the City Hockey Team Hockey Year 7 Played hockey as a junior at National level and at senior county level Hockey Year 8 Cross Country information about Hockey Netball Year 7 7 Athletics Member of Tyne Netball Team Mrs H Dune Netball Played netball for the county at junior and senior levels Netball Year 8 who IS runni ng Hockey Years 11 to 13 Gymnastics umes as the teams and NS A Dresi Reins Played hockey for Tyne and Wear at school and university level Hockey Year 8 f Current member of Northumberland Hockey Team Hockey Years 9 and 10 Trampoline what teams they WaT Haato Squash Played squash and tennis at a National level Squash Team Years 7 to 13 Tennis Current GB team coach for squash actua ly run Swann Swam for Great Britain at Commonwealth Games World Championships Miss J Wheel qramncine and European Championships 1998 to 2002 Swimming Team Years 7 to 13 National Swimming Champion 1998 to 2002 53 54 PE Department Page HTML Coding lt p gt lt span class h1 gt Meet the PE Department lt span gt lt p gt lt table cellspacing 7 class body style width 100 gt lt table gt 55 lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt tr
12. Venue Blue Flames Staff Member J Walton Second Staff Member A Lille Transport Booked No Lunch Required Group Size 35 Date Added 2012 10 20 16 53 05 You have searched for transport with the criteria No Fixture search page Log out Staff Search Results Custom Search By Date results php COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Number of records found 1 1 Friendly Sport Hockey Date 2011 10 17 Start Time Venue Westgate Staff Member J Walton Second Staff Member None Transport Booked Yes Lunch Required Group Size 12 Date Added 2012 10 20 15 34 06 You have searched for date with the criteria 2011 10 17 Fixture search page Log out Staff Search Results Custom Search By Event results php COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Number of records found 1 1 ESSA Regional Trials Sport Swimming Date 2011 10 20 Start Time Venue Neptune Centre Middlesbrough Staff Member J Wheel Second Staff Member Transport Booked Yes Lunch Required Group Size 16 Date Added 2012 10 20 16 11 36 You have searched for event with the criteria ESSA Fixture search page Log out 88 Staff Search Results Custom Search By Lunch results php COMBE ABBEY SCHOOLS
13. You have searched for the sport Athletics Fixture search page Log out 81 Staff in PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information Fixture Search Results Number of records found 2 1 Schools Cup Round 1 Sport Cross Country Date 2011 10 28 Start Time Venue Alnwick Staff Member A Dress Second Staff Member A Lille Transport Booked Yes Lunch Required Yes Group Size 25 Date Added 2012 10 20 16 11 36 2 Schools Cup Regional Round Sport Cross Country Date 2011 11 12 Start Time Venue Leeds Staff Member A Lille Second Staff Member J Walton Transport Booked Lunch Required Group Size 25 Date Added 2012 10 20 16 13 43 You have searched for the sport Cross Country Fixture search page Log out PE Department Staff Login PE Department Staff Search Results By Sport PHP Coding lt p gt lt span class h1 gt Fixture Search Results lt span gt lt p gt lt p gt lt span class body gt lt php create short variable names Ssearchsport SHTTP_POST_VARS fsearchsportonly Ssearchsport addslashes Ssearchsport Sdb mysql_pconnect localhost root if Sdb echo Error Could not connect to database Please try again later exit mysql_select_db PE Squery select from fixtures where sport Ssearchsport ORDER BY date Sresult mysql_query Squery Snum_results mysql_num_rows Sr
14. height auto position absolute 93 94 Evidence of the System Tables The two tables have been developed using MySQL in phpMyAdmin Each table has a primary key defined and the fixtures table also has a timestamp field to allow staff to log when a fixture was added to the database Table Structure Fixtures Field Type Collation Attributes Null Default Extra Action _ eventid int 11 No None auto_increment aFrX RE B SF sport char 15 _latin _swedish_ci No None SawFVFX ABB event char 40 _latin1_swedish_ci No None a FXK HBB Hm date date No None SlVFxX WDB tr _ venue char 30 latint_swedish_ci Yes NULL YT XRD SB EH staff1 char 15 _latin1_swedish_ci No None SVX BBS amp staff2 char 15 _ latin _swedish_ci Yes NULL BFXK ADB Rm thmeoday char 10 _latini_swedish_ci Yes NULL E VFXK HOB _ starttime time Yes NULL VFX RB B SF dateadded timestamp on update CURRENT_TIMESTAMP Yes CURRENT_TIMESTAMP onupdate CURRENT_TIMESTAMP FP XK ff DRA _ transport char 3 latint_swedish_ci No No SFX HBB ER C lunch char 3 _latini_swedish_ci No No E2 xo pB D size int 11 Yes NULL RX RB Be y char 3 latint _swedish_ci No No B2 xB DEBED JYE char 3 latint _swedish_ci No No B2 XR DBA y9 char 3 latini _swedish_ci No No EP xE DUBRA J y10 char 3 latint_swedish_ci No No SlV7X RH BB Em O y1 char 3 latint _swedish_ci No No AVX ABB amp DUR char 3 latint _swedish_ci No No E2 xR DERD
15. Lunch Required Log out Group Size Add another fixture Fixture search page Log out New Fixture Confirmation Page PHP Coding lt php open the connection Sconn mysql_connect localhost root select the database mysql_select_db PE Sconn sql statement Ssql INSERT INTO fixtures sport event date venue staff1 staff2 timeoday starttime transport lunch size y7 y8 y9 y10 y11 y12 y13 VALUES S_POST fsport S_POST fevent S_POST fdate S_ POST fvenue S_POST fstaff1 S_POST fstaff2 S_POST ftofday S_POST fti me S_ POST ftransport S_POST flunch S_POST fsize S_ POST f7 S_ POST f8 S_ POST f9 S_ POST f10 S_ POST f11 S_ POS T f12 S_POST f13 if Imysql_query Ssql Sconn 68 die Error mysql_error echo 1 record added mysql_close Sconn gt lt p gt lt span class h1 gt Fixture Confirmation lt span gt lt span class body gt lt br gt lt br gt lt table width 60 border 0 gt lt tr gt lt td style width 25 class h2 gt Sport lt td gt lt td width 82 class body gt lt php echo _POST fsport gt lt td gt lt tr gt lt tr gt lt td style width 25 class h2 gt Event Name lt td gt lt td class body gt lt php echo S_POST fevent gt lt td gt lt tr gt lt tr gt lt td style width 25 class h2 gt Fixture Date lt td gt lt td class body gt lt php
16. PASS The logg Event Name a Staff Login Custom Search Search Type Search Criteria Event Name ESSA submit ed in user has selected the search type nd have typed in the criteria ESSA with 2 results being displayed and the search criteria confirmed at the end of the search results PE Department Fixtures Diary Home Page Fixture List Fixture Search Clul Number of records found 2 1 ESSA Regional Trials Sport Swimming Date 2011 10 20 Start Time Venue Neptune Centre Middlesbrough Staff Member J Wheel Second Staff Member Transport Booked Yes Lunch Required No Group Size 16 Date Added 2012 10 20 17 03 25 2 ESSA National Finals Sport Swimming Date 2012 11 24 Start Time Venue Coventry Staff Member Second Staff Member Transport Booked No Lunch Required No Group Size Date Added 2012 10 21 11 09 38 You have searched for event with the criteria ESSA Fixture search page Log out Allows a logged in user to type in a support staff name then displays the relevant results 7E De rtment Staff l ogin FE VEpPpanmenr Ps Home Page Fixture List Fixture Search Club Infor Number of records found 2 1 Schools Cup Regional Round Sport Cross Country Date 2011 11 12 nae l Start Time Ta Support Staff e g Walton Venue Leeds Search Walton Staff Member A Lille Criteria Second Staff Member J Walton eme Transport Booked No Lunch Required No
17. PHP Coding lt php session_start gt lt echo lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt lt h3 gt Fixture Entry Page Staff Only lt h3 gt lt font gt check session variable if isset SHTTP_SESSION_VARS valid_user 65 echo lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt You are logged in as SHTTP_SESSION_VARS valid_user lt font gt lt p gt echo lt p gt 66 lt form action insert1 php method post gt lt table class body style width 80 cellpadding 4 gt lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt td style width 148px gt Sport lt td gt lt td style width 115px gt lt select name fsport style width 126px tabindex 1 class body gt lt option gt Athletics lt option gt lt option gt Cross Country lt option gt lt option gt Hockey lt option gt lt option gt Netball lt option gt lt option gt Swimming lt option gt lt option gt Tennis lt option gt lt option gt Squash lt option gt lt select gt lt td gt lt td style width 122px gt Event lt td gt lt td style width 115px gt lt input name fevent type text tabindex 7 size 40 gt lt td gt lt td style width 148px gt Date yyyy mm dd lt td gt lt td style width 115px gt lt input name fdate type text tabindex
18. Squery select from fixtures where Ssearchtype like Ssearchterm ORDER by date Sresult mysql_query Squery Snum_results mysql_num_rows Sresult echo lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Number of records found Snum_results lt font gt lt p gt for Si 0 Si lt Snum_results i Srow mysql_fetch_array Sresult echo lt p gt lt strong gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Si 1 echo htmlspecialchars stripslashes Srow event echo lt strong gt lt br gt Sport echo stripslashes Srow sport echo lt br gt Date echo stripslashes Srow date echo lt br gt Start Time echo stripslashes Srow time echo lt br gt Venue echo stripslashes Srow venue echo lt br gt Staff Member echo stripslashes Srow staff1 echo lt br gt Second Staff Member echo stripslashes Srow staff2 echo lt br gt Transport Booked echo stripslashes Srow transport echo lt br gt Lunch Required echo stripslashes Srow lunch echo lt br gt Group Size echo stripslashes Srow size echo lt br gt Date Added echo stripslashes Srow dateadded echo lt font gt lt p gt gt 91 lt span gt lt span class h2 gt You have searched for lt span gt lt span class body gt lt php echo _POST fsearchtype gt
19. Staff Login Area Create New Fixture Only attempt to access this area if you are authorised to do so You are logged in as adr Delete Fixture Log out Fixture Search Create New Fixture Delete Fixture Fixture Search Logged In Confirmation Page Once a user has logged in the page below confirms this It also displays the username they are logged in by Staff Login PHP Coding lt php session_start if isset HTTP_POST_VARS userid amp amp isset HTTP_POST_VARS password if the user has just tried to log in Suserid SHTTP_POST_VARS userid Spassword SHTTP_POST_VARS password Sdb_conn mysql_connect localhost root mysql_select_db PE Sdb_conn Squery select from users where userid Suserid and password Spassword Sresult mysql_query Squery Sdb_conn if mysql_num_rows Sresult gt 0 if they are in the database register the user id SHTTP_SESSION_VARS valid_user Suserid gt lt p gt lt span class h1 gt Staff Login Area lt span gt lt p gt lt p gt lt span class body gt Only attempt to access this area if you are authorised to do so lt span gt lt p gt lt font face Verdana Arial Helvetica sans serif color 4C4C4D gt lt if isset SHTTP_SESSION_VARS valid_user echo You are logged in as SHTTP_SESSION_VARS valid_user lt br gt lt br gt echo lt a href logout php gt Log out lt a gt
20. Yes or No 102 Any pages which are accessible only by username and password are clearly identfied to the visitor and suitable messages are displayed when the user is logged in and also when their access has been denied due to insufficient authorisation PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Entry Page Staff Only You are not logged in Only staff may see this page Fixture search page Log out Tables have been sometimes used to try and organise data within pages where displayed data is dynamic This helps to organise the layout of information and ensure that pages do not become too cluttered and lengthy PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Deletion Page Staff Only You are logged in as adr Fixture Deletion Find the fixture ID and use the form below to delete selected fixtures Io Sport Event Date Time Staff Member National Schools Tournament 2011 10 05 11 00 00 A Dress The Parks 18 Netball County Tournament 2011 10 18 11 00 00 J Walton Blue Flames J Wheel Neptune Centre Middlesbrough 103 COMBE ABBEY SCHOOLS Finally a prompt have also been provided to users when entering data Home Page Fixture List Fixture Search Club Information PE Department Staff Login into the fixture entry Fixture Entry Page Staff Only form T
21. lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Only staff may see this page lt font gt lt p gt echo lt a href fixturesrcstaff php gt Fixture search page lt a gt lt br gt lt br gt echo lt a href logout php gt Log out lt a gt lt br gt gt New Fixture Confirmation Page insert1 php This is the confirmation page which displays all of the data that the user has entered to the fixture COMBE ABBEY SCHOOLS addition page PE Department Fixtures Diary If anyone were to access Home Page Fixture List Fixture Search Club Information PE Department Staff Login the page without being Fixture Confirmation logged in or adding a Event Name Newcastle Schools Gala Fixture Date 2012 02 15 confirmation screen below Fixture Time 16 00 Time of Day Swimming would be displayed Year 7 Yes Year 10 Yes Year 127 Yes Year Groups Year 8 Yes Year ii Yes Year 13 Yes PE Department Fixtures Diary Year 4 Yes Venue West Benton Pool Home Page Fixture List Fixture Search Club Information PE Department Staff Login Lead Staff Member J Wheel Support Staff J Walton Patre Conan Transport Booked Yes Lunch Required cc A vent Name Group Size 16 Fixture Date Fixture Time Time of Day Year 7 Year 10 Year 12 Add another fixture Year Groups Year 8 Year 11 Year 13 Year9 Venue Lead Staff Member Fixture search page Support Staff Transport Booked
22. the code points to the correct location View the new fixture confirmation page and check links are visible and that the code points to the correct location View the fixture search page and check links are visible and that the code points to the correct location View the search results page and check links are visible and that the code points to the correct location The user will be denied access and the staff areas will be unavailable The page link is visible and correct The page link is visible and correct The page link is visible and correct The page link is visible and correct The page link is visible and correct The page link is visible and correct The page links are visible and correct The page links are visible and correct The page links are visible and correct The page links are visible and correct The page links are visible and correct n12 Delete Fixture provides links to View the delete fixture page The page links are visible Search for a fixture and check links are visible and and correct Create a new fixture that the code points to the Log out correct location Confirmation Page n13 Delete fixture confirmation View the delete confirmation The page links are visible provides links to page and check links are visible and correct Create a new fixture and that the code points to the Delete a fixture correct location Search for a fixture Log out n14 The reset button on the fixtur
23. verdana Geneva Tahoma sans serif color 4C4C40 gt You are not logged int Netball Tyne and Wear Knockout echo lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D Only staff may see this p Athletics Newcastle Schools Cup r SE air es aey Tennis Friendly vs Church ner dq href logout php Log out lt abdbr P s Athletics Schools Cup l EndEditable gt Swimming Tyne and Wear Gala al Jav vu uy ys vnec nvs Cross Country National Finals 2012 11 09 10 00 00 She 30 Swimming ESSA National Finals 2012 11 24 13 00 00 Cov Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Deletion Page Staff Only You are logged in as adr Fixture Deletion Find the fixture ID and use the form below to delete selected fixtures Enter ID Number Delete Fixture Fixture search page Add new fixture Log out Delete fixture confirmation provides extra links to Create a new fixture Delete a fixture Search for a fixture Log out COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login echo lt font face verdana Geneva Tahoma sans serif color 4C4C403delete has fai led lt font fixture has been deleted from database F i i i You have deleted record number 35 A ce lt span lt br lt b
24. 06 Start Time Venue RGS Staff Member J Wheel Second Staff Member Transport Booked No Lunch Required No Group Size Date Added 2012 10 21 11 09 38 7 National Finals Sport Cross Country Date 2012 11 09 Start Time Venue Sheffield Athletics Stadium Staff Member Second Staff Member Transport Booked No Lunch Required No Group Size Date Added 2012 10 21 11 09 38 8 ESSA National Finals Sport Swimming Date 2012 11 24 Start Time Venue Coventry Staff Member Second Staff Member Transport Booked No Lunch Required No Group Size Date Added 2012 10 21 11 09 38 You have searched for transport with the criteria No Fixture search page Log out Allows a logged in user to type in whether lunch is required then displays the relevant results PE Department Fixtures Diary Department Staff Login Number of records found 3 1 County Tournament Sport Hockey Date 2011 10 11 Start Time Venue John Spence Staff Member A Dress Second Staff Member None Transport Booked Yes Lunch Required Yes Custom Search Group Size 12 Search Date Added 2012 10 20 15 33 15 Type Search Criteria Lunch Booked Yes or No a a ee 2 Schools Cup Round 1 Yes Sport Cross Country Date 2011 10 28 submit Start Time Venue Alnwick Staff Member A Dress Second Staff Member A Lille T i T rt Booked Y PASS The logged in user has selected the search type Label ssa
25. 17 12 ine Develop Student Search Page and Results 1 18 12 1 20 12 9 Test Student Search Pages 1 21 12 1 23 12 Develop Fixture Display Page 1 24 12 1 27 12 Test Fixture Display Page 1 28 12 1 31 12 Finalise testing and security levels 2 1 12 2 29 12 GanttProject to help me plan the development and The candidate has only included the development and testing elements of the project which is the way The diagram could be bigger in size as it is difficult to read but the candidate is awarded 2 correct thing to do They have included all aspects of the system development and testing along the O rar S g E D 5 O v D l 5 X I o ba C S X S Qs Nw gt S vo wv Dd HU A So gt G O ZS S SS gt o Q 2 vs O gt O as 0 oe Q O used a Gantt Chart developed in the software x D 9 O w NM G e ie 5 O WY lt v Q G Q b ii Project Plan testing section of the project as seen here 50 c i Software Development and Testing Evidence of the System Webpages Webpage Template Template dwt This template has been developed for use on every page that is created as part of the fixtures diary It contains the banner area which holds the school name and logo It also displays the website name PE Department Fixtures Diary and links to all of the main pages within the site It is a
26. 2 gt lt td gt lt td style width 122px gt Time hh mm lt td gt lt td style width 115px gt lt input name ftime type text tabindex 8 gt lt td gt lt td style width 148px gt Time of Day lt td gt lt td style width 115px gt lt select name ftofday style width 100px tabindex 3 class body gt lt option gt Morning lt option gt lt option gt Afternoon lt option gt lt option gt Evening lt option gt lt option gt Weekend lt option gt lt select gt lt td gt lt td style width 122px gt Transport Booked lt td gt lt td style width 115px gt lt input type hidden name ftransport value No gt lt input name ftransport type checkbox value Yes tabindex 9 gt lt td gt lt td style width 148px gt Venue lt td gt lt td style width 115px gt lt input name fvenue type text tabindex 4 size 40 gt lt td gt lt td style width 122px gt Packed Lunch lt td gt lt td style width 115px gt lt input type hidden name flunch value No gt lt input name flunch type checkbox value Yes tabindex 10 gt lt td gt lt td style width 148px gt Lead Staff Member lt td gt lt td style width 115px gt lt select name fstaff1 tabindex 5 class body gt lt option gt A Dress lt option gt lt option gt H Dune lt option gt lt option gt J Hamilton lt option gt lt option gt H Lille lt option gt lt option gt J Walton
27. 20 Yes Yes Yes Yes O E 20 Swimming Tyne and Wear Gala 2011 11 05 RGS J Wheel None Evening 16 00 00 2012 10 20 17 03 25 Yes No 20 Yes Yes Yes Yes Yes Yes Yes DE AE 21 Swimming Newcastle Schools Gala 2012 02 15 West Denton Pool J Wheel JWalton Evening 16 00 00 2012 10 2017 0325 Yes No 16 Yes Yes Yes Yes Yes Yes Yes By lt lt 4 Netball Tyne and Wear Knockout 2012 01 17 Blue Flames J Walton ALille Evening 16 00 00 2012 10 20 17 03 25 No No 35 Yes Yes Yes Yes Yes Yes Yes e ile 23 CrossCountry National Finals 2011 12 02 Crystal Palace A Dress HDune Weekend 09 00 00 2012 10 2017 03 25 No No 20 Yes Yes Yes Yes Yes Yes Yes JUAR 25 Athletics Newcastle Schools Cup 2012 02 06 Gateshead Stadium J Hamilton None Morning 10 00 00 2012 10 20 17 00 29 No No 25 Yes Yes Yes t__ Check All Uncheck All With selected 2 X Show 30 row s starting from record 0 in horizontal 4 mode and repeat headers after 100 cells Pisanan ae miii ae eae oe Table Structure Users 4 Server localhost M Database PE p ij Table users E Browse Structure SOL Search j lnsert fEjExport Ejlmport Operations fffEmpty Drop Field Type Collation Attributes Null Default Extra Action userid char 4 latind swedish_ci No Nene FS A Ee fl amp Ff password char 15 latini_swedish_ci No None se xX Bo amp forename char i5 latini_swedish_ci No None AH A fe fh HH B surname char i5 Jatini_swedish_ci No None a FAK He DBD ii Check All Uncheck Al
28. 2011 11 05 ross Country Schools Cup Regional Round 011 11 12 eeds tall estfield ross Country National Finals 11 12 02 rystal Palace etball yne and Wear Knockout 012 01 17 lue Flames 5 ateshead Stadium wimming Nest Denton Pool Enter ID Number ara in PJ D p H PJ r oo ad S Ww LA PJ r PJ La A i m I i i j 4 PJ mn ma PJ r PJ r i Un i 2 23 6 Delete Fixture Fixture search page Add new fixture Log out 71 Delete Fixture Page PHP Coding lt php session_start gt lt echo lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt lt h3 gt Fixture Deletion Page Staff Only lt h3 gt lt font gt check session variable if isset SHTTP_SESSION_VARS valid_user echo lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt You are logged in as SHTTP_SESSION_VARS valid_user lt font gt lt p gt echo lt p gt lt span class h1 gt Fixture Deletion lt span gt lt p gt lt p gt lt span class h2 gt Find the fixture ID and use the form below to delete selected fixtures lt span gt lt span class h2 gt lt span gt lt p gt Scon mysql_connect localhost root if Scon die Could not connect mysql_error mysql_select_db PE Scon Sresult mysql_query SELECT FROM fixtures ORDER BY date echo lt table w
29. 343px gt lt form action staffsrcsport php method post name sport gt lt table style width 79 gt lt tr gt lt td gt lt span class body gt Select Sport lt span gt lt td gt lt td gt lt select name fsearchsportonly class body gt lt option gt Athletics lt option gt lt option gt Cross Country lt option gt lt option gt Hockey lt option gt lt option gt Netball lt option gt lt option gt Squash lt option gt 76 lt table gt lt tr gt lt tr gt lt tr gt lt form gt lt td gt lt td gt lt option gt Swimming lt option gt lt option gt Tennis lt option gt lt select gt lt td gt lt td gt amp nbsp lt td gt lt td gt lt input class h2 name Submit3 type submit value submit gt lt td gt lt form action results php method post gt lt table style width 84 class body gt lt table gt lt form gt lt tr gt lt tr gt lt tr gt lt tr gt Group lt span gt lt td gt lt tr gt lt tr gt 104px gt 77 lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt td gt lt td class body style width 105px gt Search Type lt td gt lt td style width 128px gt lt select name fsearchtype class body gt lt option value event gt Event Name lt option gt lt option value staff2 gt Support Staff e g J Walton lt option gt lt option value venue gt Venue lt opti
30. 55 to 12 25 12 25 to 13 00 15 45 to 17 00 Year 9 and 10 Hockey Monday ee iat Netball Years 7 to 13 Netball Matches home Years 11 to 13 Hockey Matches Year 8 Netball Tuesday Year 7 Netball versT ands Nabal Tarnamnents Year 10 Hockey League Wednesday Years 9 and 10 Netball Year 11 Hockey Years 7 to 13 Cross Country Years 7 to 13 Netball Matches amp Practice Thursday Years 7 to 13 Hockey Goalkeeping Practice Kearon sees Years 7 and 8 Hockey Friday Years 7 to 13 Squash Coaching Summer Term Timetable 11 55 to 12 25 12 25 to 13 00 15 45 to 17 00 Year 8 Trampolining Monday Years 7 to 13 High Jump Years 7 and 8 Tennis Club Years 7 and 8 Rounders League Tuesday Years 9 and 10 Rounders League Wednesday Year 9 Trampolining Years 7 to 13 Long Jump Years 9 and 10 Tennis Club Thursday Years 7 to 11 Tennis Team Coaching Years 7 to 13 Running Club Friday Years 7 and 8 Tennis Team Coaching Years 9 to 11 Tennis Team Coaching Years 7 to 13 Squash Coaching taking place within the school Club Information Page HTML Coding lt p gt lt span class h1 gt Sports Club Information lt span gt lt p gt lt p class h2 gt Autumn and Spring Term Timetable lt p gt lt table class auto style1 style width 100 gt lt tr class h2 gt 56 lt td class auto style3 style width 8
31. Booked No i echo lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C40 gt 0nly staff ma Lunch Required No Group Size 10 echo lt q href newfixture php 3Add a new fixture lt o gt lt br gt lt bro s Date Added 2012 10 22 18 25 50 echo lt q href Logout php 2Log out lt ar br gt gt else You have searched for the sport Tennis Fixture search page Log out n12 n13 125 Delete Fixture provides extra links to Search for a fixture Create a new fixture Log out Confirmation Page PE Department Fixtures Diary PASS The delete fixture page clearly provides links to search for a new fixture create another fixture or to logout of the site The delete fixtures button also takes the user to a deletion confirmation page The hyperlink code has been Sport Event Date Time Staff Member A N checked amp confirmed Hockey National Schools Tournament 2011 10 05 11 00 00 A Dress Hockey County Tournament 2011 10 11 12 00 00 A Dress Netball County Tournament 2011 10 18 11 00 00 I Walton Swimming ESSA Regional Trials 2011 10 20 17 00 00 J Wheel Ne Cross Country Schools Cup Round 1 br gt lt input class H2 name Submiti type submit value Delete Fixture lt td gt Swimming Tyne and Wear Gala hls Cross Country Schools Cup Regional Rou 3 Netball City Tournament Cross Country National Finals i echo p gt lt font face
32. Colour CD3131 Today Previous Eae 2011 Next Sub Titles Verdana 14px 4C4C4D Bold Tuesday 27th September 2011 Main Body Text Verdana 12px 4C4C4D J Junior Netball v Durham High Away Main Body Colour DCDDDE Time 12 00 AM 2 30 PM Wednesday 28th September 2011 G Year 11 A Team Netball City Tournament Time 12 00 AM 12 00 AM Walbottle Thursday 29th September 2011 J Junior Netball v Church High Home Time 12 00 AM 4 00 PM Miss Chew also provided me with electronic copies of the school banner and logo which is often used on school publications They follow the school s colour scheme and house style so would still be suitable for use within the new system 20 Fixtures Diary COMBE ABBEY SCHOOLS A view of what the fixtures diary looks like at the moment will give me an idea of the key information which is required for the new system and how fixtures are viewed by the department at the moment so that a similar feature may be provided if required by the department tried to get a copy of the fixtures diary from Miss Walton but she wasn t happy with me copying it and couldn t find time to arrange this herself have seen the diary though Extra Curricular Timetable Collecting the extra curricular timetable would help me to find out when sports practices are for the PE department so that they could be added to information pages on the website if required by the department
33. Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Staff Login Area ff provide form to log in Only attempt to access this area if you are authorised to do so echo lt form method post action Llogin php gt 5 echo lt table 3 i echo lt tre lt tdsUseridi lt td gt You are not logged in echo lt td gt lt input type text name userid gt lt td gt lt tre s echo lt tr gt lt td gt Password lt td gt AIC echo lt td lt input type password name password gt lt td gt tri Userid echo lt tr gt lt td colspan 2 align center gt 5 Password echo lt input type submit value Log in gt lt td gt lt tre echo lt tabled lt form Log in 2 gt lt font lt br gt Create New Fixture q href newfixture php Create New Fixture a lt br br gt q href deleteform php Delete Fixture lt a gt lt br gt lt br Delete Fixture a href fixturesrestaff php 2Fixture Search lt a gt lt l EndEdi table gt Fixture Search eae PASS The login page clearly provides links to create a fixture delete a fixture and search a fixture via written links and to login to the site via a button The hyperlink code has been checked amp confirmed 122 New Fixture provides extra links to Search for a fixture Log out Confirmation Page PASS The fixture data entry page clearly provides links to COMBE ABBEY
34. Information PE Department Staff Login Fixture Confirmation on a lt tr gt Sport Tenrin Std style width 258 class h2 2Group Size lt td gt Event Name Friendly vs Church td class body 3 lt php echo POST fsize 73 lt td gt Fixture Date 2012 06 12 lt ftr gt Fixture Time 16 00 lt tr gt Time of Day Tennis td style width 254 class h2 senbsp3 lt td gt Year 7 Yes Year 10 Year 12 lt td gt Year Groups Year8 Yes Year 11 Year 13 br lt br 3a href newfixture php Add another fixture lt a lt br gt lt br gt Year9 Yes q href fixturesrestaff php 3Fixture search page lt a gt lt br gt lt br Venue DAS da href Llogout php 2Log out lt at lt br s gt Lead Staff Member J Hamilton lt td gt Support Staff None Transport Booked No a wA Lunch Required No able T EE E h lt l Ended i table gt grdiw Add another fixture sediu Fixture search page Log out 123 n10 124 Fixture search provides extra links to Create a new fixture Log out Results pages COMBE ABBEY SCHOOLS PE Department Fixtures Diary else Home Page Fixture List Fixture Search Club Information echo lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C40 gt You are echo lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C40 gt 0nly st Fixture Search Page Staff Only echo 4a href newfixture php gt Add a new fixture lt a gt lt br gt lt
35. Investigation Interview Planning will be using an interview to find out how the current system operates at present have chosen this method as can have a detailed discussion with the client Miss Walton and there is also opportunity to explain my questions if the client does not fully understand them I can also ask additional questions at the time if feel my question has not been answered as expected will interview Miss Walton the Head of PE She will hopefully give me a better idea of how the fixtures diary works at the moment She is the most suitable person to interview as have been informed that she is in charge of the diary and knows exactly how it works Following an email conversation between me and Miss Walton we have arranged for the interview will take place in the school library on the 12 September 2011 at 12 00 which is during lunch break have already checked that Miss Walton does not have any club practices that day Te j walton combeabbey ac uk Subject Initial Interview Dear Miss Walton Further to our meeting the other day would like to meet with you to ask some questions to help me understand the PE department s fixture diary a little better Would the 12 September be good for you at all can meet you in the school library Regards Jenny This is her reply forwarded her a list of questions as requested which are shown on the next page From J Walton Sent 11 September 201
36. Links to other staff only pages but the layout for each is the same style and format Unauthorised viewers cannot see this page and a message is displayed to inform them that access has been denied Fixtures Search Page Results Staff Only Fixture Results Page Number of records found 1 Event Name Sport Venue Time Staff Support Staff Date Transport Lunch You have searched for SEARCH TYPE for CRITERIA Fixtures Search Page Staff and Pupils Fixture Search Page Search Instructions Select Sport M Select Year f M Fixtures Search Page Results Staff and Pupils Fixture Results Page Number of records found 1 Event Name Sport Venue Time Staff 2 Event Name Sport This is the layout of each of the staff search pages Unlike the student search results more fields are displayed as the staff will need access to more information Each search result page displays the fixtures that match the criteria and the criteria and search type is also confirmed at the bottom of the page The data is obtained via a connection to the database and the relevant search field and criteria are queried and then displayed Unauthorised viewers cannot see this page and a message is displayed to inform them that access has been denied This page is accessible to anyone and is available via a link on every page The page allows the user to select a year group and sport
37. Page Logged In delete php 7 Once a fixture id has been entered and the submit CO M B E A BB EY SC H O LS button pressed the user has confirmation that the fixture has been deleted ee ee and the id number is again Home Page Fixture List Fixture Search Club Information PE Department StaffLogin CONfirmed fixture has been deleted from database You have deleted record number 6 COMBE ABBEY SCHOOLS Fixture search page PE Department Fixtures Diary Delete another fixture Home Page Fixture List Fixture Search Club Information PE Department Staff Login Add a new fixture fixture has been deleted from database Log out You have deleted record number Fixture search page If someone were to visit the page without being logged Delete another fixture in they would see the following screen Although it Add anew fixture states that a record has been deleted this is not possible icici as they are not logged in and no records could therefore be deleted Delete Confirmation Page PHP Coding lt php open the connection Sconn mysql_connect localhost root select the database mysql_select_db PE Sconn sql statement Sfdelete S_POST fdelete Squery delete from fixtures where eventid Sfdelete if mysql_query Squery 73 echo lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt lt br gt fixture has been deleted from database lt font gt
38. Sport and Year Group Select Sport Search Criteria Year 11 F submit PASS The logged in user has selected the sport Cross Country and year group year 11 and 3 results have been PE Depa Cross Country 7 Allows a logged in user to select a sport and year group then displays the relevant results Home Page Fixture List Fixture Search Club Inf Fixture Search Results Number of records found 3 1 Schools Cup Round 1 Sport Cross Country Date 2011 10 28 Start Time Venue Alnwick Staff Member A Dress Second Staff Member A Lille Transport Booked Yes Lunch Required Yes Group Size 25 Date Added 2012 10 20 16 11 36 2 Schools Cup Regional Round Sport Cross Country Date 2011 11 12 Start Time Venue Leeds Staff Member A Lille Second Staff Member J Walton Transport Booked No Lunch Required No Group Size 25 Date Added 2012 10 20 17 03 25 3 National Finals Sport Cross Country Date 2011 12 02 Start Time Venue Crystal Palace Staff Member A Dress Second Staff Member H Dune Transport Booked No Lunch Required No Group Size 20 Date Added 2012 10 20 17 03 25 displayed with the search criteria confirmed at the end of the search results You have searched for the sport Cross Country for y11 Fixture search page Log out i6 Allows a logged in user to type in an event then displays the relevant results 115 PE Department
39. Staff Member A Lille Transport Booked Yes Lunch Required Yes Group Size 25 Date Added 2012 10 20 16 11 36 6 Tyne and Wear Knockout Sport Netball Date 2012 01 17 Start Time Venue Blue Flames Staff Member J Walton Second Staff Member A Lille Transport Booked Lunch Required Group Size 35 Date Added 2012 10 20 16 13 43 7 Newcastle Schools Gala Sport Swimming Date 2012 02 15 Start Time Venue West Denton Pool Staff Member J Wheel Second Staff Member J Walton Transport Booked Yes Lunch Required Group Size 16 Date Added 2012 10 20 15 55 52 You have searched for the year group y13 Fixture search page Log out 79 COMBE ABBEY SCHOOLS PE Department When a Staff search is performed on a year group the results are displayed as shown The year selected is displayed at the end and although this search looks similar to the student search more field values are displayed to the staff member This format is followed for all other search result pages for staff members but with different messages and types of criteria at the end of the search results Staff Search Results By Year Group PHP Coding lt p gt lt span class h1 gt Fixture Search Results By Year Group lt span gt lt p gt lt p gt lt span class body gt lt php create short variable names Ssearchyear SHTTP_POST_VARS fsearchyearonly Ssearchyear addslashes Ssearchyear Sdb mysql_pco
40. Staff Member None Transport Booked Yes Lunch Required Group Size 12 Date Added 2012 10 20 15 34 06 You have searched for the sport Hockey for y7 Fixture search page Log out Second Staff Member None Transport Booked Yes Lunch Required Yes Group Size 12 Date Added 2012 10 20 15 33 15 COMBE ABBEY SCHOOLS You have searched for the sport Hockey for y11 Fixture search page PE Department Fixtures Diary og Home Page Fixture List Fixture Search Club information PE Department Stati Login L out Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Search Results Number of records found 0 ove eoe S eee Fixture search page Log out PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Search Results Number of records found 2 1 County Tournament Sport Netball Date 2011 10 18 Start Time Venue Blue Flames Staff Member J Walton Second Staff Member None Transport Booked Yes Lunch Required Group Size 30 Date Added 2012 10 20 15 48 06 2 Tyne and Wear Knockout Sport Netball Date 2012 01 17 Start Time Venue Blue Flames Staff Member J Walton Second Staff Member A Lille Transport Booked Lunch Required Group Size 35 Date Added 2012 10 20 16 13 43 You have searched for the sport Netball for y7 g 5 Fixture search page Log out Staff Search Resu
41. Template Logo School Name Page Content e Page Title Logo School Name S Links Page Content Updated Search Results Design Staff Fixture Results Page Number of records found 1 Event Name Sport Venue Time Staff Support Staff Date Transport Lunch You have searched for SEARCH TYPE for CRITERIA Return to Search Page amp other staff links The login page i good and looks very chor tol i s staff only jo 41 Logo School Name Links Page Content links oF refer the 3rd phan hath a page fille i he There is lok more spaa for he page Content jr This s better but can you add the group size and date the fixhre woo dobld FK As a result of Miss Walton s written comment I will ensure that the extra fields are displayed on the actual results pages Updated Login Design Login Page Staff Only Access Username d i Password Information to users about logging in Links to other staff only pages Updated Fixture Entry Form Staff Only Data Entry Instructions Event o Time Transport L Lunch C Lead Staff Group Size Backup Staff M Year Groups Year 7 _ Year 10 E Year 12 O ia Reset Updated Table Design Deleted fields have been crossed through and new fields are shaded in yellow Field Name Data Type Length Validation Sample Values EventID Primary Key Int Not Null 00
42. bro s You are logged in as adr echo 4a href Logout php Log out lt a gt lt br r s 77 Use the forms below to search for fixtures Search by Year Group Search by Sport Custom Search Search ri Type Select Year Group Year7 Select Sport Athletics Search submit submit Criteria Event Name Search by Staff Search by Sport and Year Group Select Staff Member A Dress z Select Sport Athletics submit Search Criteria Year7 submit Add a new fixture Log out PASS The staff search page clearly provides links to create another fixture and to logout of the site When any of the submit buttons are selected the user is then directed to the relevant results page The hyperlink code has been checked amp confirmed Fixture search results provides extra links to Search for a fixture Log out PASS The fixture search results page for staff clearly COMBE ABBEY SCHOOLS provides links to search for another fixture and to logout of the site The hyperlink code has been checked amp Home Page Fixture List Fixture Search Club Information PE Department Staff Login confirmed PE Department Fixtures Diary Fixture Search Results Number of records found 1 1 Friendly vs Church Sport Tennis Date 2012 06 12 Start Time Venue DAS Staff Member J Hamilton Second Staff Member None echo lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C40 gt You are not Le Transport
43. daily basis In the girls school there are currently three full time members of staff and one part time member with each managing one or two sports teams Other members of the school staff also assist with the running of smaller teams The client for this project will be the Head of Girls PE Miss Jane Walton She has been in charge of the department for just over a year and is finding the organisation of fixtures and staff very time consuming a i a Definition a brief description of the organisation or group that has the problem and an introduction to the client and or the end user s and their place within the organisation or group 1 The candidate has provided a brief introduction to the organisation and client The candidate would gain the mark here Problem Outline All fixtures are written in a paper based diary When a new fixture is to be arranged the diary needs to be consulted to see if there is a clash for the year group concerned and also the teacher Due to the department being quite large the diary can sometimes go missing which causes great panic within the department as there is no other method used to store details of fixtures The department would like a safer method of storing their fixture details which could be easily accessible and available to more than one person at a time a i b Definition an outline of the problem that needs to be solved 1 Candidate would gain the mark here a ii
44. details would be lost and staff would struggle to remember every event that has been booked This could be a major inconvenience to the department and also embarrassing for the staff as they would look very unorganised and unprofessional to other schools The current system is flawed in a number of areas and the main issues have been listed below e Only one person can access the diary at a time e The diary does not have a fixed location e f Miss Walton is off work ill the diary will most likely be with her and not at school e Fixture information is duplicated between the diary school website and calendar e Messy handwriting can mean that fixture information is illegible e lf the diary is lost or misplaced the department will no longer have access to their fixtures e When attending meetings each member of staff has to take responsibility for the safe keeping of the diary e Amendments to fixtures can make the diary entries look messy and sometimes confusing e Other members of school staff are often unaware of the sports fixtures that have been planned e To keep parents students and staff updated of fixtures any new events would have to be entered three times into the diary onto the school website and on the pupil PE noticeboard e The school paper based calendar is never up to date with sporting fixtures as it is published before many of the fixtures have been arranged Client Agreement Miss Walton agree that the above represents
45. e 1GBofRAM or more e 2GBor more of available hard disk space e NET Framework 4 0 e Silverlight 4 0 e Support for Microsoft DirectX 9 0 graphics with Windows Vista Display Driver Model WDDM Driver 128 MB of graphics RAM or more Pixel Shader 3 0 in hardware 32 bits per pixel e DVD compatible drive e 1024 x 768 or higher resolution monitor with 24 bit color e Internet functionality requires Internet access additional fees may apply e Actual requirements and product functionality may vary based on your system configuration and Operating system e Some product features require FireFox 3 0 or later and Internet Explorer 8 Minimum Requirements for Windows 7 Enterprise e 1 gigahertz GHz or faster 32 bit x86 or 64 bit x64 processor e 1 gigabyte GB RAM 32 bit or 2 GB RAM 64 bit e 16GB available hard disk space 32 bit or 20 GB 64 bit e DirectX 9 graphics device with WDDM 1 0 or higher driver Based on the minimum system requirements have obtained for the operating system and web development software the recommended minimum hardware and software requirements to run the system are as follows Web Hosting Server Requirements So that the site can be hosted with a backend e Internal and external network connectivity database which stores fixture information The e PHP5 2 0 server will need to be accessed via a user s e MySQL 5 0 or newer internet or network connection and the database e phpMyAdmin will be queried
46. echo S_POST fdate 2 gt lt td gt lt tr gt lt tr gt lt td style width 25 class h2 gt Fixture Time lt td gt lt td class body gt lt php echo S_POST ftime gt lt td gt lt tr gt lt tr gt lt td style width 25 class h2 gt Time of Day lt td gt lt td class body gt lt php echo S_POST fsport gt lt td gt lt tr gt lt tr gt lt td style width 25 class h2 gt Year Groups lt td gt lt td class body gt lt table style width 81 height 46px gt lt tr gt lt td class body gt Year 7 lt td gt lt td class body style width 39px gt lt php echo S_POST f7 gt lt td gt lt td class body gt Year 10 lt td gt lt td class body style width 36px gt lt php echo S _POST f10 gt lt td gt lt td class body gt Year 12 lt td gt lt td class body style width 37px gt lt php echo S _POST f12 gt lt td gt lt tr gt lt tr gt lt td class body gt Year 8 lt td gt lt td class body style width 39px gt lt php echo S_POST f8 gt lt td gt lt td class body gt Year 11 lt td gt lt td class body style width 36px gt lt php echo S _POST f11 gt lt td gt lt td class body gt Year 13 lt td gt lt td class body style width 37px gt lt php echo _POST f13 gt lt td gt lt tr gt lt tr gt lt td class body gt Year 9 lt td gt lt td class body style width 39px gt lt php echo S_POS
47. fixed computer and want to a desktop computer or whether they use a portable device such as an iPad would have to rely on their own personal data connection Interview Transcript New System Requirements Technical Aspects Interview with Mr A Blackburn Date 23 September 2011 Time 12 30pm Venue School Resource Centre 1 Does the school have IT servers that could be used to host a website Yes we have Moodle hosted on school servers and the school website is hosted here too Follow up If yes would it be possible for the PE department to use some of the server space for their own website It really depends how much you want to put on the website If you were thinking of putting on lots of videos and large files I d say at the moment no But if you were thinking of mainly a text based website with a few images then that should be fine Follow up Could the website be accessed from outside of school Yes 2 Are the servers configured for database connectivity For example the use of PHP and MySQL 19 Yes Moodle uses this type technology You would have to give us the database and website files though and we would need to load it directly onto the server for you We can set you up witha private hosting area on your user account to develop the site and when you have finished it we can help you transfer the files over to the main server Follow up Can the database be accessed from outside of school Your own priva
48. from the drop down boxes and when the submit button is pressed a connection is made to the database which searches for the two fields and entered criteria The results page below is shown as a result of every search carried out via this page The results displayed to all users is similar to the format of the staff only searches but limited fixture information is provided as the general public do not need to know the specific details of a fixture The number of records returned by the search is displayed each record is then listed with labels provided to inform the viewer of what they are looking at You have searched for the sport SPORT for YEAR The search criterion that has been selected is also confirmed at the bottom of the page Fixtures List Staff and Pupils The fixture list is again available to any Fixture List Page visitors of the website It establishes a connection to the database and displays Upcoming Events fixture information in date order The first table displays fixtures that are from today s date and in the future The second table displays fixtures that are older than today s date again in date order Logout Page Logout Page Once a logged in user has finished their work on the VOUS SUE Emon sone ee fixtures diary they can click the logout link This ends Back to Home Page the session that was established which authorises them to view the add edit delete and search pages and co
49. gt lt td style height 17px gt Netball Year 7 lt br gt Netball Year 8 lt br gt Hockey Years 11 to 13 lt td gt lt td class h2 style width 134px gt Mrs A Dress lt td gt lt td style width 121px gt Hockey lt br gt Athletics lt br gt Trampoline lt td gt lt td style width 454px gt Played hockey for Tyne and Wear at school and university level lt br gt Current member of Northumberland Hockey Team lt td gt lt td gt Hockey Year 8 lt br gt Hockey Years 9 and 10 lt br gt lt td gt lt td class h2 style width 134px gt Miss J Hamilton lt td gt lt td style width 121px gt Squash lt br gt Tennis lt td gt lt td style width 454px gt Played squash and tennis at a National level lt br gt Current GB team coach for squash lt td gt lt td gt Squash Team Years 7 to 13 lt td gt lt td class h2 style width 134px gt Miss J Wheel lt td gt lt td style width 121px gt Swimming lt br gt Trampoline lt td gt lt td style width 454px gt Swam for Great Britain at Commonwealth Games World Championships and European Championships 1998 to 2002 lt br gt National Swimming Champion 1998 to 2002 lt td gt lt td gt Swimming Team Years 7 to 13 lt td gt PE Department Fixtures Diary Sports Club Information Autumn and Spring Term Timetable Home Page Fixture List Fixture Search Club Information COMBE ABBEY SCHOOLS PE Department Staff Login 11
50. gt Friday lt td gt lt td class auto style4 style width 306px gt Years 7 and 8 Tennis Team Coaching lt td gt lt td class auto style4 style width 313px gt Years 9 to 11 Tennis Team Coaching lt td gt lt td class auto style4 gt Years 7 to 13 Squash Coaching lt td gt Student Search Page fixturesrcstudent html This page allows students and parents to search for fixtures by selecting their chosen sport and year group The results are then displayed in date order COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Search Use the form below to search for fixtures Select your sport and year group Select Sport Athletics Search Criteria Year 7 x Student Search Page HTML Code lt p gt lt span class h1 gt Fixture Search lt span gt lt p gt lt p gt lt span class h2 gt Use the form below to search for fixtures lt span gt lt p gt lt p gt lt span class h2 gt Select your sport and year group lt span gt lt p gt lt form action resultsstudent php method post gt lt table style width 40 gt lt tr gt lt td class body style width 105px gt Select Sport lt td gt lt td class body gt lt select name fsearchsport gt lt option gt Athletics lt option gt lt option gt Cross Country lt option gt lt option gt Hockey lt option gt lt option gt Netball lt option gt lt o
51. input name f12 type checkbox value Yes tabindex 17 gt lt td gt lt tr gt lt tr gt lt td style width 51px gt Year 8 lt td gt lt td style width 48px gt lt input name f8 type checkbox value Yes tabindex 13 gt lt td gt lt td style width 52px gt Year 11 lt td gt lt td style width 51px gt lt input name f11 type checkbox value Yes tabindex 16 gt lt td gt lt td style width 51px gt Year 13 lt td gt lt td style width 51px gt lt input name f13 type checkbox value Yes tabindex 18 gt lt td gt lt tr gt lt tr gt lt td style width 51px gt Year 9 lt td gt lt td style width 48px gt lt input name f9 type checkbox value Yes tabindex 14 gt lt td gt lt td style width 52px gt amp nbsp lt td gt lt td style width 51px gt amp nbsp lt td gt lt td style width 51px gt amp nbsp lt td gt lt td style width 51px gt amp nbsp lt td gt lt tr gt lt table gt lt td gt lt td style width 115px gt lt input class h1 name Submit1 type submit value submit tabindex 19 gt lt td gt lt tr gt lt tr gt lt td style width 115px gt lt input class h1 name Reset1 type reset value reset tabindex 20 gt lt td gt lt tr gt lt form gt lt p gt else echo lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt You are not logged in lt font gt lt p gt echo
52. is confirmed to the user The record details are confirmed to the user Deleting a Fixture Is the user logged in No access denied amp appropriate message displayed Yes access granted amp deletion page is displayed Connection to the database fixtures table is made All fixtures are displayed in date order The user finds the fixture and types in the ID number A delete button deletes the entered record A confirmation page is displayed for the user Staff Logout Is the user logged in No the user is logged out and this is confirmed Yes the user is not logged in amp a message states this b i a Nature of the Solution Design of data handling including capture preparation and storage to include map and diagrammatic representation of links where relevant 4 The candidate has provided table designs for their database flow charts a website structure diagram and list of processes Entity Relationship diagrams should be shown but in this instance the database does not have linked tables The candidate could also provide some data flow diagrams and a website navigation diagram to show how pages are linked together As this is an important aspect of the website design the full marks are not awarded and the candidate is given 3 marks CSS Specification Titles Verdana 14px bold 4C4C4D Sub Titles Verdana 12px bold 4C4C4D Main Body Text Verdana 12px 4C4C4D Colours Banner Dark Grey 808285 and Light Grey C
53. keyboard letter selected 119 A logged in user can delete a selected fixture Home Page Fixture List Fixture Search Club Ir PE Department Fixtures Diary Fixture Deletion Page Staff Only Home Page Fixture List Fixture Search You are logged in as jwh Fixture Deletion fixture has been deleted from database Find the fixture ID and use the form below to delete select You have deleted record number 15 ID sport 13 Hockey ational Schools Tournament Fixture search piFixture Deletion Page Staff Only Cross Country Schools Cup Regional Round 20 swimming m BEG i ary 5 8 I ockey Friendly etball County Tournament i ID Sport ESSA Regional Trials a fixture i Choos 14 Hockey ry Schools Cup Round 1 ate Ta Netball Event National Schools Tournament County Tournament County Tournament ESSA Regional Trials Schools Cup Round 1 Tyne and Wear Gala Schools Cup Regional Round City Tournament National Finals Tyne and Wear Knockout Newcastle Schools Cup Newcastle Schools Gala Schools Cup Tyne and Wear Gala National Finals ESSA National Finals wimming Tyne and Wear Gala 1 wimming 2 Cross Country O anj C 1 O m am rt N ockey County Tournament KOU DoE cater aK Delete another fiFixture deletion Find the fixture ID and use the form below to delete select 5 etball City Tournament 3 Cross Country z 22 Netball Cross Country National Fi
54. logged in members Backup Staff MI Unauthorised viewers cannot see this page and a message is displayed to inform them that access has been denied 33 Confirmation Page Staff Only Fixture Entry Confirmation Page Record Added to Database List of field Data carried over names which from the data entry are the same page to confirm to as the ones the user what has shown on the been inserted data entry page Links to other staff only pages Fixture Edit Page Instructions to the user ID Event Sport Date C i Links to other staff only pages that access has been denied Edit Fixture Form Staff Only Data Editing Instructions aporti M Event Date time FO TimeofDay M Year Group sd D Suomi Venue Lead Staff M Backup Staff MI When the submit button is pressed the user is taken to the confirmation screen This displays all of the data that was entered on the previous page but also connects to the database and inserts the record into the fixtures table Again this page will only be visible to staff members and only accessible via the pressing of the submit button on the data entry page Unauthorised viewers cannot see this page and a message is displayed to inform them that access has been denied Fixture Edit Page Staff Only Whilst a user is logged in they can also access the edit fixture page This will display all of the fixtur
55. lt option gt lt option gt J Wheel lt option gt lt option gt None lt option gt lt select gt lt td gt lt table gt 67 lt td style width 122px gt Team Size approx lt td gt lt td style width 115px gt lt input name fsize type text tabindex 11 gt lt td gt lt tr gt lt tr gt lt td style width 148px gt Assistant Staff Member lt td gt lt td style width 115px gt lt select name fstaff2 tabindex 6 class body gt lt option gt None lt option gt lt option gt A Dress lt option gt lt option gt H Dune lt option gt lt option gt J Hamilton lt option gt lt option gt H Lille lt option gt lt option gt J Walton lt option gt lt option gt J Wheel lt option gt lt select gt lt td gt lt td style width 122px gt amp nbsp lt td gt lt td style width 115px gt amp nbsp lt td gt lt tr gt lt tr gt lt td style width 148px rowspan 2 gt Year Group s lt td gt lt td colspan 2 rowspan 2 gt lt table align left style width 91 height 56px gt lt tr gt lt td style width 51px gt Year 7 lt td gt lt td style width 48px gt lt input name f7 type checkbox value Yes tabindex 12 gt lt td gt lt td style width 52px gt Year 10 lt td gt lt td style width 51px gt lt input name f10 type checkbox value Yes tabindex 15 gt lt td gt lt td style width 51px gt Year 12 lt td gt lt td style width 51px gt lt
56. lt br gt else if isset Suserid if they ve tried and failed to log in echo Could not log you in else they have not tried to log in yet or have logged out echo You are not logged in lt br gt lt br gt provide form to log in echo lt form method post action login php gt echo lt table gt echo lt tr gt lt td gt Userid lt td gt echo lt td gt lt input type text name userid gt lt td gt lt tr gt echo lt tr gt lt td gt Password lt td gt echo lt td gt lt input type password name password gt lt td gt lt tr gt echo lt tr gt lt td colspan 2 align center gt echo lt input type submit value Log in gt lt td gt lt tr gt echo lt table gt lt form gt gt lt font gt lt br gt lt a href newfixture php gt Create New Fixture lt a gt lt br gt lt br gt lt a href deleteform php gt Delete Fixture lt a gt lt br gt lt br gt lt a href fixturesrcstaff php gt Fixture Search lt a gt 63 Staff Logout Page Confirmation logout php COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search ClubInformation PE Department Log out Logged out Back to main page Staff Logout Page Confirmation Logged Out If a anyone clicks on the Log Out link and they are not already logged in the following page is displayed to inform them of this Staff Logout Pa
57. lt span class h1 gt Fixture Search Results lt span gt lt p gt lt p gt lt span class body gt lt php create short variable names Ssearchsport SHTTP_POST_VARS fsearchsport Ssearchyear SHTTP_POST_VARS fsearchyear Ssearchsport addslashes Ssearchsport Ssearchyear addslashes Ssearchyear Sdb mysql_pconnect localhost root if Sdb echo Error Could not connect to database Please try again later exit mysql_select_db PE Squery select from fixtures where sport Ssearchsport and Ssearchyear like Yes ORDER BY date Sresult mysql_query Squery Snum_results mysql_num_rows Sresult echo lt p gt lt font face verdana Geneva Tahoma sans serif gt Number of records found Snum_results lt font gt lt p gt for Si 0 Si lt Snum_results i Srow mysql_fetch_array Sresult echo lt p gt lt strong gt lt font face verdana Geneva Tahoma sans serif gt Si 1 echo htmlspecialchars stripslashes Srow event echo lt strong gt lt br gt Date echo stripslashes Srow date echo lt br gt Time echo stripslashes Srow time echo lt br gt Venue echo stripslashes Srow venue echo lt br gt Staff Member echo stripslashes Srow staff1 echo lt font gt lt p gt gt lt span gt lt span class h2 gt You have searched for the sport lt span gt lt span clas
58. of the school calendar which is issued at the start of the academic year However the last two methods are not always accurate as fixture information can be added or amended on a regular basis Students are also made aware of fixtures normally two weeks before the event via a notice on the PE notice board which lists the team and fixture information The school are often quite successful in sporting events and have won a number of titles ranging from city county and even national titles Whenever a fixture it is arranged it is written down in the paper diary and details such as the year group teacher in charge venue time and sport are added When other fixtures are arranged the diary is consulted to see if there is a clash of events If so the staff try to arrange the fixture on an alternative date The diary is also updated with details of other school events that may impact upon student availability for fixtures The current system is not very practical as four or more people are using it at the moment and it is not always kept in the same location on a day to day basis This means that only one person can access the diary at any one time The diary is also sometimes misplaced which can cause problems for the department One major flaw of the current system is that all information is stored within the diary with only some fixture details duplicated on the school website This means that if the diary was lost a large proportion of the fixture
59. school have a Wi Fi network which you could use They do have a Wi Fi network but nobody knows the password apart from the technicians have tried to ask them for it in the past to connect my own personal laptop and iPad but they have refused do know it is used for school laptops though Would you like the option to print out fixture information This would be useful but not 100 necessary 18 13 14 15 16 17 Would you like to provide general departmental information to students using an online system It would be nice to provide brief information about what sports we offer and who is in charge of each team Even providing a brief profile on the staff and coaches we have here would give pupils and parents a better idea of our sporting background It would be very handy to provide a copy of the extra curricular timetable for PE on the system or even have a news board for important information How much IT experience does your department have at present in particular with using websites and online forms am quite happy using the Internet and filling in forms My department is also generally quite good using a computer and know that they have all used the school reporting system which is based online and they have to select from drop down boxes and type in information Follow up Would the department need training and would you like someone to come in to deliver it It would be useful to see how the system
60. see this page Staff Only Fixture Deletion Page Fixture Deletion Page Staff Only You are not logged in Only staff may see this page b i b Nature of the Solution design of inputs queries processing and outputs including error capture reports as appropriate based clearly on the analysis of the client requirements 4 The candidate has provided designs for the following aspects of the website CSS code specification template design pages and a description about what each one does security consideration drop down box contents and error messages It looks like the candidate will be using coding to connect to a database when entering editing deleting and searching for data For the designs of this it would be beneficial to see how the code would need to be amended for their system to work as intended Due to this omission the candidate is awarded 3 marks for this section 38 User Feedback gave Miss Walton a copy of my designs and she provided me with the feedback shown in the letter below Combe Abbey School Archibold Terrace Newcastle upon Tyne NE10 9JH 4 November 2011 Dear Miss Jackson Thank you for sending me through the designs for the website and associated information The flowcharts and list of processes helped me to understand how it would actually work which was good as have often wondered where information goes once you have entered it into an online form am pleased with the structure and l
61. shown a message to explain that the area is restricted To assist staff members in their deletion of fixtures a list of current fixtures stored within the database is provided so they can just look at the list and then enter the fixture they wish to delete Shortfalls During the development of the pages the PHP coding was quite difficult to get right at the start and although the pages display the required information it is felt that the layout of some pages could still be improved The only main shortfall experienced was the lack of an event edit page Due to time restrictions and lack of technical experience it was not possible to develop a working solution Although a form was created to 141 select an event which took the user to a data editing form it was not possible to get the data to transfer over to the form and then for the user to edit the required data and submit With a little more time and perseverance it would be possible to get this requirement implemented In the meantime the user could gain access to the database via phpMySQL This has been explained in the user manual and it is a workaround that can be used until the proper function is incorporated into the actual system e a Evaluation Evaluation of each of the requirements from the requirements specification including showing how the completed solution meets the requirements Areas from the requirements specification that have not been met are discussed 4 The ca
62. sport and year results for y11 cross country will be displayed The logged in user will have access to the staff search page and the event results for ESSA will be displayed The logged in user will have access to the staff search page and the support staff results for J Walton will be displayed The logged in user will have access to the staff search page and the venue results for RGS will be displayed The logged in user will have access to the staff search page and the date results for 2012 01 17 will be displayed The logged in user will have access to the staff search page and the transport results for no transport booked will be displayed The logged in user will have access to the staff search page and the lunch required results no will be displayed Invalid data entry for sport Fixture Entry Page The user will not be able to enter and staff name is not Sport Darts any values other than the ones allowed on the new fixture Staff Name J Spoon presented on the drop down list form A logged in user can delete a selected fixture Unauthorised users are denied access from the staff areas Navigation Test Plan Test ID Input Data Expected Result n1 Home Page is accessible from all other pages Fixture List Page is accessible from all other pages Fixture Search Page is accessible from all other pages Club Information Page is accessible from all other pages PE Department Page is accessible from all
63. system worked 100 right so carefully went through all of the tests on the test plan to make sure that every area was checked also found a number of errors with the system whilst it was being developed and had to make a number of amendments then to ensure the system worked correctly e c Evaluation Evaluation of the finished development against the project plan from design 2 The candidate has looked back at their project plan and evaluated their use of time for a range of tasks that did not go as planned They have looked at the aspects that took longer than expected and try to provide an explanation into why this happened 2 marks are awarded 143 ce f Presentation of Report Log of Events No log of events f Presentation of Report The candidate has produced some material that explains part of the solution attempted It will be difficult to navigate and will assume much knowledge of the solution that the reader will probably not possess The information may be expressed without a structure Errors of grammar or spelling may be intrusive 3 The candidate has produced a well structured and navigable report Page numbers are included and titles subtitles clearly identify what is displayed on a page The contents page is accurate and spelling grammar used is good Technical language is used by the candidate and is also used in the correct contexts Although this project is written at a top mark band level no log of e
64. the database where the fixture id number is found within the fixtures table and the associated record is deleted A confirmation message is also displayed to the user indicating which record has been deleted When the fixture delete page is viewed again it can be seen that the record with the ID number 6 has been deleted COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login fixture has been deleted from database You have deleted record number 6 Fixture search page COMBE ABBEY SCHOOLS Delete another fixture Add a new fixture a Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Deletion Page Staff Only You are logged in as adr Fixture Deletion Find the fixture ID and use the form below to delete selected fixtures Se ee ae ockey 011 10 05 11 00 00 The Parks Fienaly 2011 10 17 17 00 00 fi waton Westgate ESSA Regional Tals 2011 10 20 17 00 00 Whee Neptune Centre Middlesbrough AEIR pa ee Tyne and Wear Gala 2011 11 05 18 00 00 fi Whee Cross Country Schools Cup Regional Round A Lille Leeds cy Touma elle Westfkd ean Cammy asic a crystal pace Tyne and Wear Knockout 2012 01 17 16 00 00 Walton Blue Flames Gateshead Stadium Swimming Newcastle Schools Gala 2012 02 15 a N wae ake lt N oa lt 2 B 22 23 a 25 21 Enter ID Number
65. the issues we are facing with our current system and is an accurate representation of the problem in hand Signed Man Date 15 September 2011 12 a ii d Investigation evidence of analysis of the current system or of likely problem areas arriving at reasoned conclusions that will show evidence of being agreed by client 3 The candidate has provided an overview of how the current system works at the moment They have listed the range of problems experienced at present and have drawn some conclusions about the impact they can have on the department Ideally the candidate would provide more discussion about the greater impact of the problems faced by the user This section is therefore awarded 2 marks 13 New System Requirement Information Collection Interview New System Requirements Based on the initial analysis of the current system can clearly see that the diary system is not ideal feel the department would benefit from the use of an electronic diary and will now carry out a second interview to find out exactly what Miss Walton would like from a new system 1 Do you want to continue using the old diary This is to find out how feasible it would be system for the department to stop using their old system 2 How would you feel about using a computer This is to find out how comfortable the based diary department would be about moving away from a paper based system to a computerised system 2 If the answer to quest
66. to view staff only areas 106 PASS For the three staff only pages the unauthorised user is unable to view the COMBE ABI COMBE AB content They are displayed with a message telling them COMBE ABBI PE Department Fixtures Diary PE Department Fixtures Diary herdonol y ao no Home Page Fixture List Fixture Search C Home Page Fixture List Fixture Search have access to Fixture Entry Page Staff Only Fixture Search Page Staff Only the page Homa Page Fixture List Fixture Search Club Fixture Deletion Page Staff Only You are not logged in You are not logged in Ved are nde iooesa i Only staff may see this page Only staff may see this page Fixture search page Fixture search page Add a new fixture Add new flature l oak Log out Log out Only staff may see this page 107 Validation will be used to ensure that the staff names and sport are entered correctly on fixture entry form You are logged in as adr rn Fixture Entry Page Staff Only Sport Athletics Sport Athletics cath ha ae You are logged in as adr Tinks Ieee hie Time of Day Morning SSS Venue Time of Day Morning 3 Sport x Athletics O Lead Staff Member y A Dress g Venue CIGSS COUNTY TE Assistant Staff Member J Hamilton Date yyyy mm dd Hockey Lead Staff Member A Dress H Lille Year 10 0 Netball J Walton Swimming Assistant Staff Member V None veer Geumanes van Tome Venue Tennis H Dune Year 10 0 None Squash Year Gr
67. 1 Auto Increment Sport The sport concerned 15 Not Null Swimming Form Drop down box Event The name of the event Char 40 Not Null National Championships Lidii the fixture is eee place Mot Null 09 10 2011 Where the fixture is taking place oe Centre Staff1 The lead member of staff 15 Not Null Form Drop down box Staff2 The second member of staff Form Drop down TimeODay When the fixture is to be taking place Char Morning Afternoon S StartTime What time the fixture starts Po 09000 lt lt S 00 DateAdded When the fixture was added to the Md 10 12 2011 dav 42 TT he fobl ard fom Oeog look gr eot NON oa b i c Nature of the Solution clear evidence of iteration and development of designs in the form of annotated drafts where relevant this should include feedback from the client and evidence of how these have had an effect on the solution 1 The candidate has clearly shown the client their designs and feedback has been obtained As a result the candidate has redesigned a number of aspects and they have again been shown to the client for further feedback The candidate is awarded the mark 43 A Test Plan Requirement a a a Tests Expected Result PE department members can login to the fixtures diary with their own username amp password The department can add new fixtures to the diary using an online form A confirmation page will display the submitted fixture There will be a
68. 1 10 50 To J Jackson Subject RE Initial Interview Dear Jenny Yes that would be fine I look forward to meeting with you Please could you send me a list of the questions before the interview to help me plan the answers accurately for you Regards Miss Walton From J Jackson Sent 9 September 2011 09 20 To J Walton Subject Initial Interview Dear Miss Walton Further to our meeting the other day would like to meet with you to ask some questions to help me understand the PE department s fixture diary a little better Would the 12 September be good for you at all can meet you in the school library a ii a Investigation thorough planning of the mechanics of the interview situation 2 The candidate has explained their reasoning for conducting an interview the venue place and time have been clearly organised and communicated with the client Evidence of communication with the client is in the form of emails The candidate would be awarded the marks Interview Current System Number fixtures diary is used at the moment works so that can understand it better 2 What problems are you experiencing with To get a better understanding of why the the diary at the moment department wants to change their current system and they impact that their current problems can have Do you have any worries about the diary This will help me to understand any concerns system you use at the moment that
69. 17 with 1 result being displayed and the search criteria Eog aut confirmed at the end of the search results Fixture search page PE Department Fixtures Diary PE Department Staff Login Home Page Fixture List Fixture Search Club Ii Number of records found 2 1 Tyne and Wear Gala Sport Swimming Date 2011 11 05 Start Time Custom Search Venue RGS aon ii i Staff Member J Wheel Search Second Staff Member None ena Transport Booked Yes Lunch Required No Group Size 20 oup Date Added 2012 10 20 17 03 25 7 5 2 Tyne and Wear Gala Sport Swimming PASS The logged in user has selected the search type Date 2012 11 06 Venue and have typed in the criteria RGS with 2 Gone results being displayed and the search criteria Staff Member J Wheel confirmed at the end of the search results Second Staff Member Transport Booked No Lunch Required No Group Size Date Added 2012 10 21 11 09 38 i10 Allows a logged in user to type in whether transport is booked then displays the relevant results 117 118 PE Department Staff Login Custom Search Search Transport Booked Yes or No Type Search Criteria submit Dup i PASS The logged in user has selected the search type Transport Booked and have typed in the criteria No with 8 results being displayed and the search criteria confirmed at the end of the search results 6 Tyne and Wear Gala Sport Swimming Date 2012 11
70. 2 10 20 17 03 25 Select Year Group Year Select Sport Athbeti 3 Newcastle Schools Gala submit submit Sport Swimming B j Date 2012 02 15 Start Time Venue West Denton Pool Staff Member J Wheel Search by Staff Search by Sport and Ye Second Staff Member J Walton Transport Booked Yes Select Staff Member Select Sport Athleti Lunch Required No Fixture search page Log out Search by Year Group Search by Sport TAN Group Size 16 submit Search Criteria Year 7 Date Added 2012 10 20 17 03 25 submit 4 Tyne and Wear Gala Sport Swimming Add a new fixture Date 2012 11 06 Start Time Venue RGS Log out Staff Member J Wheel Second Staff Member PASS The logged in user has selected the staff member J Transport Booked No Lunch Required N Wheel and 4 results have been displayed with the search oasis oof criteria confirmed at the end of the search results ee eee ee You have searched for the staff member J Wheel Fixture search page Log out 114 PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information Fixture Search Page Staff Only You are logged in as hdu Use the forms below to search for fixtures Search by Year Group Select Year Group Year 7 aq submit Search by Staff Select Staff Member A Dress z submit Add a mew fixture Log out Search by Sport Select Sport Athletics submit Search by
71. 36 137 d Documentation 4 to 7 mark band Candidates will provide clear documentation The documentation will be well presented There is clear on screen help to support the end user The supporting documentation and on screen help is well presented and covers most aspects of the operations that the user would be required to perform Some subject specific terminology will be used There may be occasional errors of spelling grammar and punctuation The candidate has demonstrated the onscreen help that has been provided to the user within the system The candidate could add more support to the user in the form of an online manual and more screen tips to explain how to use the data entry form for example but they have attempted to explain data entry requirements and page functions The candidate has produced a well written user manual and their spelling grammar is good The manual is presented clearly with a good mix of written instructions and informative screen shots Terminology has been used appropriately and the guide explains how to use both the front end of the system i e the web pages and also the back end of the system via a technical guide explaining how to manage the database and content appearance of the pages Although the candidate has produced a project that could fit into the top mark band there are a couple of areas that have been omitted and the user guide is therefore incomplete The candidate has not explained how the CSS cod
72. 6C8CA Page Content Area DCDDDE House Style Banner School logo and name should be present on every page COMBE ABBEY SCHOOLS Banner Colour DCDDDE sone Rca torm On screen messages will assist all users Title Banner Background Colour CF3131 Font Verdana Font Size 16px Font Colour FFFFFF Webpage Design Template The page layout will be the same for each of the pages within the site The content will obviously change but the location of links school name and logo will remain the same The logo and school name will be in the form of the banner A template will be created which all pages will be developed from and this will follow the design layout shown below A template will make page development a lot easier and will ensure that pages are consistent in their look The links will be for Home Page Fixture Search Fixture List School Logo School Name Clubs Department and for Staff Login The home page will welcome visitors to the site and provide information about what it has to offer Page Content The fixture search page will allow visitors to the site to search for fixtures by selecting a sport and a year group The fixture list page will display a list of all current and past fixtures The clubs page will provide visitors with a table of the autumn spring sports clubs and a separate table for the summer term sports clubs The department page provides visitors with basic information about the PE depart
73. 9JH 25 April 2012 Dear Miss Walton Further to our discussion today would like to confirm in writing the details for the installation of your new online fixtures diary plan to meet with ICT network technician first so that can obtain the settings required to install the system on the school network will then meet with Mr Blackburn and yourself on the 16 May in the ICT technician s office so that the database and website files can be installed If you can provide me with a list of planned fixtures for the next month can enter these into the database before our meeting so that the department can see how the system works and practice using it The training plan is attached to this letter and again think you will find it meets the plans we agreed verbally Please do not hesitate to contact me if you have any questions about this prior to the 16 May Otherwise look forward to seeing you then Yours Sincerely Jenny Jackson 127 Letter from client Combe Abbey School Archibold Terrace Newcastle upon Tyne NE10 9JH 27 April 2012 Dear Miss Jackson Once again would like to thank you for creating what looks to be a superb fixture diary for the school have looked at the demo version you have sent me and it looks very impressive Your plans for installation are as recall us discussing and would therefore like to confirm that am happy for you to come to the school ICT technician s of
74. 9px gt amp nbsp lt td gt lt td class auto style2 style width 306px gt 11 55 to 12 25 lt td gt lt td class auto style2 style width 313px gt 12 25 to 13 00 lt td gt lt td class auto style2 gt 15 45 to 17 00 lt td gt lt td class auto style5 style width 89px gt Monday lt td gt lt td class auto style4 style width 306px gt Year 7 Hockey lt br gt Years 11 to 13 Netball lt td gt lt td class auto style4 style width 313px gt amp nbsp lt td gt lt td class auto style4 gt Year 9 and 10 Hockey lt br gt Years 7 to 13 Netball Matches home lt br gt Years 11 to 13 Hockey Matches lt td gt lt td class auto style5 style width 89px gt Tuesday lt td gt lt td class auto style4 style width 306px gt Year 7 Netball lt td gt lt td class auto style4 style width 313px gt Year 8 Netball lt br gt Years 7 and 8 Netball Tournaments lt td gt lt td class auto style4 gt Year 10 Hockey League lt td gt lt td class auto style5 style width 89px gt Wednesday lt td gt lt td class auto style4 style width 306px gt Years 9 and 10 Netball lt td gt lt td class auto style4 style width 313px gt amp nbsp lt td gt lt td class auto style4 gt Year 11 Hockey lt td gt lt td class auto style5 style width 89px gt Thursday lt td gt lt td class auto style4 style width 306px gt Years 7 to 13 Club Information Page clubs html This page
75. ABBEY SCHOOLS Girls PE Department Fixtures Diary Home Page News Fixture List Fixture Search Club Information PE Department Staff Login Home Page Welcome to the fixtures diary for Combe Abbey School Girls PE Department Here you can find information about the latest sporting fixtures that have been planned Just use the Fixture List link to view all of the fixtures or use the handy Fixture Search link to be able to search for fixtures by sport and year group The Club Information page holds information about the practices we hold on a school lunchtime and after school The PE Department page tells you a little about our team of staff We hope you find this page useful Miss J Walton Head of Girls PE If there is any user action required the page explains how the user should proceed as seen in the search page below where the user is told what to do with the drop down boxes COMBE ABBEY SCHOOLS Girls PE Department Fixtures Diary Home Page News Fixture List Fixture Search Club Information PE Department Staff Login Fixture Search Use the form below to search for fixtures Select your sport and year group Select Sport Athletics zy Select Year Year T r 132 Staff Only Areas The staff only areas are clearly labelled to all users and it is easy to see that this area is for staff only Any visitor to this page will be able to see that if they are not a staff member they should not be tryin
76. D Primary Key and Text JW username for login purposes password to login forename surname 27 28 Flowchart Adding a Fixture Flowcharts Editing a Fixture Flowcharts Deleting a Fixture 29 Navigation Diagram NA zo Y Home 2 Login Logout Page g By Staff e Fixtur i z a By Sport Search Add Delete Edit Search Fixture Fixture Fixture Fixtures Fixture List S A Fixture Add Fixture Delete Fixture Goniimauon Confirmation Alteration S Fixture Edit Confirmation Staff Search Results All pages have two way links with the 6 main pages The secure staff pages all have a link back to the login page and also links to the other staff only pages 30 Processing Student Fixture Search A connection is made to the fixtures table Any fixtures gt today are displayed in the first table Any fixtures lt today are displayed in the second table All fixtures are displayed in date order Staff Login Is the user logged in Yes message to the user to say they are logged in No message to ask the user to log in User enters their username and password A connection to the database checks the user table Authorised User Access is confirmed Unauthorised User Access is denied Editing a Fixture Is the user logged in No access denied amp appropriate message displayed Yes access granted amp edit form is displayed Connection to the database fixtures table is made All fixtures a
77. Delete Fixture Fixture search e Add new fixture Log out 101 HCI All of the pages within the site follow the required HCI of the client The school logo and name have been included on every page as is the site name and links to all of the main pages The colour scheme of white red black and grey has also been followed with every page being displayed the same to ensure visitors view pages that are of a consistent nature and content does not jump about from one place to another The font used is Verdana as suggested by the school s marketing manager and most fonts use the colour 4C4C4D which is the dark grey shade seen for all page text The red colour used for the site title banner is CF3131 and the banner where the school name and logo are situated uses the colours 808285 and DCDDDE The lighter colour DCDDDE is also used for the main page content background colour COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Home Page Welcome to the fixtures diary for Combe Abbey School Girls PE Department Here you can find information about the latest sporting fixtures that have been planned Just use the Fixture List link to view all of the fixtures or use the handy Fixture Search link to be able to search for fixtures by sport and year group The Club Information page holds information about the practices we hold on a school lunchtime an
78. Fixture 7KB php qin results php CA PE Department Fixture Search Results E php ain resultsstudent php CA PE Department Fixture Search Results 3KB php aah staffsrcsport php CA PE Department Fixture Search Results by Sport E php aang staffercsportyear php CA PE Department Fixture Search Results by Sport and Year E php qin staffercstaff php CA PE Department Fixture Search Results by Staff 4KB php qin staffercyear php CA PE Department Fixture Search Results by Year 4KB php Template dwt Untited 1 2B dwt c i a Software Development and Testing 6 8 marks the candidate has solved a problem that has needed a level of complexity greater than a simple linear type solution The candidate has developed a system that seems to work very well The have provided evidence of all pages and in the case of query results they have tried to show the varied outputs that can occur as a result of the searches They have also explained each page what it is used for and how it works PHP CSS and HTML coding have been provided by the candidate for all pages but there is no explanation of how it works which is ashame The candidate has clearly customised the interface but an explanation of the code would prove that they fully understand the system they have developed and how it operates They do however explain each page so this does give some explanation into the system The candidate has also provided evidence of the database including tables and dat
79. Fixture Data Input Page logged in Once logged in staff members can enter a new fixture using COMBE ABBEY SCHOOLS the form below There is four drop down boxes used to PE Department Fixtures Diary prevent staff from making data entry errors for sport Home Page Fixture List Fixture Search Club Information PE Department Staff Login staff members and time of Fixture Entry Page Staff Only day For the date and year You are logged in as adr staff members are provided een Bien guidance for the format that Date yyyy mm dd Time hh mm should be used when entering Time of Bay Morning Transport Booked LJ SEE kd 7 data There are also a number Venue Packed Lunch LJ Lead Staff Member A Dress Team Size approx of checkboxes that when Assistant Staff Member None selected will input the value Year J Year 10 J Year 12 submit 1 J Year Group s Year Year 11 Year 13 yes Into the relevant field In reset i vere r the database The fields Fixture search page transport and lunch also Log out have hidden values on the form so that no is entered if the boxes are left unticked This helps when it comes to searching the database at a later stage The remaining input fields are text boxes Finally there is a reset button to clear all data and a submit button which adds the data to the database via insert1 php and displays the confirmation page New Fixture Data Input Page
80. Group Size 25 Date Added 2012 10 20 17 03 25 Custom Search 2 Newcastle Schools Gala Sport Swi int PASS The logged in user has selected the search sith Stee type Support Staff and have typed in the criteria J Start Time ar Venue West Denton Pool Walton with 2 results being displayed and the tai Member 3 Wheel search criteria confirmed at the end of the search Second Staff Member J Walton results Transport Booked Yes Lunch Required No Group Size 16 Date Added 2012 10 20 17 03 25 You have searched for staff with the criteria Walton Fixture search page Log out i8 Allows a logged in user to type in a venue then displays the relevant results 116 You have searched for venue with the criteria RGS Fixture search page Log out Allows a logged in user to type in a date then displays the relevant results PE Department Fixtures Diary PE Department Staff in Home Page Fixture List Fixture Search Club In Number of records found 1 1 Tyne and Wear Knockout Sport Netball Date 2012 01 17 Start Time Custom Search Venue Blue Flames aaa Pua yn A Staff Member J Walton Search Second Staff Member A Lille oo Transport Booked No submit Lunch Required No Group Size 35 Date Added 2012 10 20 17 03 25 You have searched for date with the criteria 2012 01 17 PASS The logged in user has selected the search type Date and have typed in the criteria 2012 01
81. OCR Exemplar Coursework Combe Abbey School Online Fixtures Diary October 2012 Contents PUDEN eroesaisic gies se eae cl ccipsaesuaaaee ssa cceoas caboose cawoua so cuessecapanavacdesesse sn vaanasiesbars vereeushwaniacttecssaeceoncabsiensaasecteer 4 TM Cai St ON secica toes ca tote sis EA ENE naa EEEE 4 MeCN e E E E E E E E E E 4 Propilen OUTING sanese iine N edonaayadenceananounaaneet nu aieemets 4 RAE E ON EE A E I E O E E NEA E NAE A TETEE ANENE 5 terme w PIN ereire EEEE EEE EE REE EEE R 5 CSI VIEW CURIE oy SECM ae a E E E E a tne nreautinnetaumatecesons 6 mterview Transcript Current SVSt CIN arcs sacascasecsmaconssianbsecusosesansaaysousinoasoacsaatesssdaebinespatinscwunte ebdsaensoacnaatoavoneionte 8 Analysis of Current Syste Mirisni pona TE E E E 12 New System Requirement Information Collection cccccccsssecccccessececeesececeeececeesccesausecessuenecesseneeeeseges 14 AAN SI Gioncocacavacncteeaeecanasasossasccho E A E E 22 PRE CUTE SOC HC ANON eaea E A EN 22 Alternative Methods ccccccccssssscccccsssseccceeeeeeeeeesseeeeeeeeeeeseeeeeeeseeeeeeesaeeseeeeesaeeeeeeeeesaaesseeeeesaaaseeeee eeeesauaaseess 23 Hardware ana SOTEW Ale ss ccnivncoeneasnsecosnenconianauunsonv T E 25 BAO Bh havi gome e OUTO eE PvE ne ORNS Neon oe ee E et ne ee Oe ne oe Cee 27 Database Table Design sicssssnsessecckeasns coscvbescatbacsuabousnvcctadasecsbnuavscabsustsameabas catnanybanteevacdedaxsadaeaunmeiapieesecstberteaareacs 27 Flow
82. RU scl E ntact E E th leas E E E het alba E A E A aint nt clade tales EE T 128 New File Creation Including Hardware and Software ccccccssseccccesssccecesececeeecceeeesccessaeeceseegeceeseeeeeetes 129 Methods or CHINE COVE enan a A eee 130 d User Mantal asso tees shah a a su bacaesauen aaueenaemuamaens oa ateesees 132 OR SCO SIH Cl Dicaiizas sas cchsanenetaasaecsenss aie uscususayeusnc sv sacoaisasadancs A ounce iaaasen cainotey E EON 132 E EV Uat ON eetetatrnceaecatien aie Det sha a lace ahead a salaried arensteshaadoanemaen mada 139 Evaluation Of Requirements SpecificatioMs sneins a E 139 EXEN SONS eea A S ds eneteeeigacsca eect 142 Project Plan Timing vs Development TIMINGS ccccccssscccesscccesececeneceeeneeeeuenceceuececeueceseeeseeneetsugesessneeees 143 Te PResentation or Report L Lop OF EVENTS ona a E ATEN A A A eesg oceans 144 a i Definition The Organisation Combe Abbey is a secondary school located in the centre of Newcastle upon Tyne and was founded in 1905 It provides education for young people aged 11 to 18 and currently has a roll of 980 students Although it is a mixed school boys and girls are taught separately until the 6 form where classes are mixed There are currently 80 teachers employed by the school and it is located on one large site The Client The school has a very busy PE department and they enter teams of all ages into a range of competitions with multiple fixtures often occurring on a
83. SCHOOLS search for a fixture and to logout of the staff area The submit button will link the user PE Department Fixtures Diary to the confirmation page The hyperlink code has been Home Page Fixture List Fixture Search Club Information PE Department Staf checked amp confirmed Fixture Entry Page Staff Only lt td style width 115px gt lt input class h1i name Reseti type reset value reset gt ftr gt You are logged in as adr epee les lt form p gt Sport Athletics else Date yyy mm dd Morning A echo lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C40 gt rc arning 7 Time of Day echo lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C4020r Venue A Deas Ta echo lt a href fixturesrcstaff php 3Fixture search page lt a lt br3 lt bro s Lene at earner seni nc echo lt q href Logout php log out lt abtbr fo Assistant Staff Member None 2 gt Year 7 Year Bi EndEdi table Year Group s Year A Yearil J Yeari3 J Year 9 Fixture search page Log out New fixture confirmation provides extra links to Create a new fixture Search for a fixture Log out PASS The fixture confirmation COMBE ABBEY SCHOOLS page clearly provides links to create another fixture search a fixture to logout of the site The PE a Fixtures Diary hyperlink code has been checked i amp confirmed Home Page Fixture List Fixture Search Club
84. Seiemeg Team Years T ta 17 Bohol Daimming Champion F70 io HEF COMBE ABBEY SCHOOLS PE Depertmeant Fixtures Diary Home Page Fixture list Fixture Search Glub Infomation PE Department Stai Login COMBE ABBEY SCHOOLS Fixture Search Page Staff Only You are logged in as adr Use the forms below to seerch for fixtures Search by Year Group Seerch by Sport Custom Search ons Event Name Year oJ Am Select Year Group Yes Select Sport Athletics X tusteret yonn Criteria tateret Search by Staff Search by Sport and Yaar Group Select Statf Member A Oress 3 Select Sport Athietics 3 Labrat Geerch rheria Vesr 7 t tenn Add a new fixture Log out PASS Each page follows the house style with logo and school name and pages provide department and club information as required Visual Testing Each page follows the house style Each page includes the logo amp school name COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login PageContent v1 and v2 PASS The template developed is used to structure every page of the website The house style has been followed for the template and CSS has been used to implement the font styles The logo and school name are also visible on every page via the template as are the 6 main links and site name PE Department Fixtures Diary Drop down boxes contain t
85. Sport Custom Search Search Type Search Criteria Select Sport Athletics _submit_ Search by Staff Select Staff Member Search by Sport and Year Group Select Sport Athletics Search Criteria submit A Dress _submit_ Add a new fixture PASS the view on the left hand side is the results for a staff search whereas the results on the right hand side are the search results for students and non logged in visitors There will be general information about the clubs and the department The site will follow the school house style and pages will include the school logo COMBE ABBEY SCHOOLS Department Fixtures Diary Home Page Fixture list Fixture Search Club Information PE Department Staff Login Fixture Search Wee the form below bo tarch for Neturei Select your sport and year group Select Sport Aahir it Select Year Fear E submit COMBE ABBEY SCHOOLS PE Deparment Fixtures Diary Home Face Fitore List Fixture Search Club Information Home Page PE Department Staff Login Wacome to a iuret diary for Ci Here pou can fed infermabor aba handy Pinture Search link tn bey abr COMBE ABBEY SCHOOLS The Clad Information pepe hokia ini The PF Departmarit Gage tel you a Department Fixtures Diary We hope qa find thii page ebetyl Home Psoe Fixture lit fixture Search Cut information Pt Oeoartment Staff Losin Mice J Walton Mead of Giria PE An Upcoming PE Departm
86. T f9 gt lt td gt lt td class body gt amp nbsp lt td gt lt td class body style width 36px gt amp nbsp lt td gt lt td class body gt amp nbsp lt td gt lt td class body style width 37px gt amp nbsp lt td gt lt tr gt lt table gt lt td gt lt tr gt lt tr gt lt td style width 25 class h2 gt Venue lt td gt lt td class body gt lt php echo S_POST fvenue gt lt td gt lt tr gt lt tr gt lt td style width 25 class h2 gt Lead Staff Member lt td gt 69 lt td class body gt lt php echo S_POST fstaff1 gt lt td gt lt tr gt lt tr gt lt td style width 25 class h2 gt Support Staff lt td gt lt td class body gt lt php echo S_POST fstaff2 gt lt td gt lt tr gt lt tr gt lt td style width 25 class h2 gt Transport Booked lt td gt lt td class body gt lt php echo S_POST ftransport gt lt td gt lt tr gt lt tr gt lt td style width 25 class h2 gt Lunch Required lt td gt lt td class body gt lt php echo S_POST flunch gt lt td gt lt tr gt lt tr gt lt td style width 25 class h2 gt Group Size lt td gt lt td class body gt lt php echo S_POST fsize 2 gt lt td gt lt tr gt lt tr gt lt td style width 25 class h2 gt amp nbsp lt td gt lt td gt lt br gt lt br gt lt a href newfixture php gt Add another fixture lt a gt lt br gt lt br g
87. The username sjw and password of Pa5Sword were rejected by the system and a message was displayed informing the user that access was denied 121 Navigation Testing Staff Login Page is accessible from all other pages PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Meet the PE Department PASS For tests n1 to n6 the above screenshot shows how there are links on every page of the website The style above is obtained from the site template which has been used for every single page The screenshot below also provides confirmation of the link gdi class maini gt span class a gt q href ndex html Home Page lt o gt amp nbsp nbsp ga href qdllevents php Fixture List lt c gt inbsp nbsp amp nbsp a href fixturesrestudent html 3Fixture Search rattnbsp amp nbsp3 amp nbsp3 ga href clubs Atml 2Club Information lt a gt amp nbsp3 amp nbsp amp nbsp q href department html gt PE Department lt a inbsp3 nbsp nbsp ga href Login php Staff Login a lt span lt br div class main style left px topi 17px BeginEdi table PageContent gt p gt span class body gt PageContent lt span lt p gt lt EndEdi table gt lt d destinations Staff login page provides extra links to Create a new fixture Delete a fixture Search for a fixture Log in COMBE ABBEY SCHOOLS A PE
88. a 2012 02 15 16 00 00 wne Athletics Schools Cup 2012 06 13 09 00 00 H Lille Gateshead Stadium r7 A search facility allows visitors and staff to search for fixtures Select your sport and year group FAIL The label for the PE Department Fixtures Diary lee Sport thiet year group says Search lSearch Criteria h I submit Criteria rather than Number of records found 3 Select Year This has 1 Schools Cup Round 1 been amended Date 2011 10 28 Fixture Search Time Home Page Fixture List Fixture Sear PASS The fixture list can aag iehi EA be searched by selecting Use the form below to search for fixtures Cite a the year group and sport Time from the drop down Venue Leeds F Staff Member A Lille options When the submit 3 National Finals button is pressed the user x ata 2011 12 02 2 A Select Sport Cross Country 4 Time 2 aide is displayed the matching Golack Vear Staff Member A Dress events for their chosen You have searched for the sport Cross Country for y7 C rite ri a Select your sport and year group submit PASS The fixture list shows students and staff all of the COMBE ABBEY SCHOOLS fixtures that have been arranged PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login It shows firstly the upcoming fixtures and then in another A
89. a Tahoma sans serif gt Srow staff1 lt font gt lt td gt echo lt td gt lt font face verdana Geneva Tahoma sans serif gt Srow venue lt font gt lt td gt echo lt tr gt echo lt table gt mysql_close Scon echo lt br gt lt form action delete php method post gt lt table width 47 style width 40 gt lt tr gt lt td width 211 class h2 style width 105px gt lt font face verdana Geneva Tahoma sans serif gt Enter ID Number lt font gt lt td gt lt td width 177 class body gt lt label gt lt input type text name fdelete id fdelete gt lt label gt lt td gt 72 lt td class body style width 105px gt amp nbsp lt td gt lt td gt lt br gt lt input class h2 name Submit1 type submit value Delete Fixture gt lt td gt lt tr gt lt table gt lt form gt else echo lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt You are not logged in lt font gt lt p gt echo lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Only staff may see this page lt font gt lt p gt echo lt a href fixturesrcstaff php gt Fixture search page lt a gt lt br gt lt br gt echo lt a href newfixture php gt Add new fixture lt a gt lt br gt lt br gt echo lt a href logout php gt Log out lt a gt lt br gt gt Delete Confirmation
90. a The connection made to the database can also be seen via the PHP coding that the candidate has provided Finally the candidate has provided evidence of the website file structure If the code were annotated this candidate could be awarded the full marks but due to their omission 6 marks have been awarded 96 Data Processing There are numerous processes occurring within the fixtures diary but the main one is the adding of a fixture and then displaying it via a confirmation page and then further searches A second process is deleting fixtures that have been saved to the database Adding a Fixture Data Entry Form process 1 To add a fixture the logged in staff member completes the relevant fields in the data entry form They have an option to submit the fixture or to reset the form to a blank state COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Entry Page Staff Only You are logged in as jwh Sport Athletics ri Event Newcastle Schools Cup Date yyyy mm dd 2012 02 06 Time hh mm 10 00 Time of Day Transport Booked LJ Venue Gateshead Stadium Packed Lunch g Lead Staff Member J Hamilton Team Size approx 25 Assistant Staff Member Mone Year M Year 10 O Year 12 O submit Year Groups Years M Year ii Year 13 Yearo Ml mesei Fixture search page Log out Adding a Fixture Confirmati
91. ally go from using the old system to the new system and have to deal with the problems which the new system contains and will have to learn how to use the new system This could cause problems if some teachers are unwilling to learn how to use the new system however it should not be a problem Phased changeover e The new system does not have phases and it would be impossible for the new system to be implemented in phases Therefore a phased changeover is not an option After discussing these options with the client and advising her Miss Walton has agreed that the direct changeover method will be used J Walton have discussed the changeover methods with Jenny and feel comfortable with the chosen method of a direct transfer Client signature jatar Date 14 May 2012 c ii c Installation details of appropriate different methods of changeover explained so that the client can make a reasoned decision 2 The candidate has provided the four different changeover methods and they have been customised towards the client s system They have discussed the different options with the client and a signature has been obtained to show their agreement with the plan Instead of a signature the candidate could also include a letter or email from the client 131 d User Manual See separate document On Screen Help General Page Information Each page has a written description explaining what the contents are COMBE
92. and always take it to morning staff briefings If am teaching practical lessons will leave the diary in the PE office Follow up What about in the evenings and at weekends I normally take the diary home with me but if a member of my department has a fixture meeting one evening will trust them to take the diary home with them normally like to keep it with me just in case someone contacts me to query a date or fixture Are details of fixtures stored anywhere else We try to coordinate our fixtures with the school website but we often forget to forward the information onto the school secretary as there are so many fixtures organised and new ones being added all the time A card A6 calendar is also produced at the start of term which is handed to all staff and pupils This calendar normally just has information about major events which have been planned before the end of the summer term The fixtures are also listed on the PE noticeboards normally a week or two in advance along with team lists for students to look at Follow up How is the information entered For the school website and card calendar the information is typed in by the school secretary who is informed of the event by email The notices are typed in a Word document and posted by the member of staff responsible for the team attending the fixtures Follow up Who has access to this information Anyone who checks the school website and students who have access to th
93. and updated on a regular basis Sufficient storage space for the fixtures system approx 250Kb Desktop Computer Requirements system and store the necessary software required software 32 bit or 64 bit Processor minimum of 1GHz So that the computer can effectively run the required software and deal with processing requirements when using developing the system displayed effectively A pointing device such as a mouse select a range of options within the fixtures diary A typing input device such as a keyboard To allow the user to type in new fixtures into the diary and to enter custom information as required Monitor To display the software required to develop the system and also to allow staff to view the fixtures diary once up and running Network Interface Card So that the computer can be connected to the school network and the diary system edited and updated DVD Drive To install the necessary software onto the computers Operating System Windows 7 Enterprise So that the user can interact with the computer hardware and required software Web Expression 4 To enable the development of the website and for any amendments that need to be made to the page structure and content Internet Explorer or equivalent with cookies enabled To allow users to view the fixtures system and to access the database as required to view add and amend fixtures a iii c Analysis a reasoned list of hardware and software req
94. atches G SPORTS HALL JD AL HW HD Year 7 8 hockey Westgate JD HW Yr 4 5 amp 6 Hockey HD Year 10 rugby B coach Senior Rugby 1 XV AC Ceilidh Band B G KSL Y 10 13 Drama Rehearsal B G Hall Drama room AW Y 10 13 Christian Union B G 3 45 5 00 Junior Dept Rugby AMB Year 10 13 dance exam prep Dance Studio Mu Squash Coaching B G Jane Dennis Badminton B G 4 6pm Sports Hall KSL Yr 7 Textiles Club Rm 2 PHa 4 Schoo Dance Companies Dance Studio LC T J FE Dipa ee ik Fiir tes fe om Ermey 4 Ti wa on FE Dey Hrak of lryaramm imag dpm haa i haag Tin de DAE Weer i HIPC bieria tam i PA MAY Mii fs a fiervice faye bemites Deir Brees iist Mi Clary Riia t H b EES S SERGE EAE EES pere EPErt i irai mi The candidate has conducted another interview with the client and also with the network technician to try and find out information about their requirements for a new system and how feasible it would be In addition documentation collection has been justified stating why they would be beneficial in the new system development A questionnaire could be handed out to the remaining members of the department find out their views and using the questionnaire data graphs could be produced The candidate is awarded the two marks for this section 21 a ii f Investigation clear presentation of the information collected about the new system 1 The information has been clearly presented howeve
95. ayed for reference purposes The house style provided by Miss Chew has been followed and all pages include the school name and logo on the top banner The school s theme is clearly identifiable There are two types of search pages one for all visitors and one for staff only Each page shows all the fixtures that meet the search criteria and they are sorted by date The search criteria is also confirmed to the user at the end of the page The staff search results page vs public search results pages are different in content and only a few fields are displayed on the public ones with all i more specific fixture information o fields displayed on the staff only pages 140 There will be a general information screen which will provide information about the different sports clubs that are run in school and the department Staff will be able to carry out more complex searches than students parents i e search by sport search by year group search by venue search by date The home page provides visitors with information about the site and how it can be used The club page provides information about the sports clubs held throughout the year and the department page introduces all of the department members and provides information about the teams they run and their sporting experience There are 4 main searches available By Main Staff By Sport By Year By Sport and Year Each search allows the user to select their search criter
96. ayout of most pages but was wondering if you could provide me with some alternative options for the actual page layout I m not a fan of the left hand navigation bar as it often means you have less space on the actual web page Is it possible to develop some alternative designs for this Please could you also add some more fields to the fixtures form so that we can record whether a bus has been booked whether lunches are required or not and how many pupils are going to be at the fixture Is it also possible to select multiple year groups for a fixture as this is a regular occurrence You may need to also update the table design for the database but my understanding of that may be incorrect On the login page it would be useful to have some links on there for staff once they re logged in and also to let people know that it is a secure area they are trying to access It would be good to also add some links to the staff search result pages too so that they can continue using the staff only area options Apart from the points have mentioned above the designs look great and feel very excited about the new system and what it can do Please can you let me see your updated designs though and l Il give you some more feedback Keep up the good work Kind regards Man J Walton 39 Tel 0191 222 3321 40 Fax 0191 222 3322 Email enguiries combeabbey ac uk Principal Mr A Watson Updated Designs Following Feedback Updated Page
97. be free to alter their password when required It would also be good to have the staff name which entered a fixture to the diary added to the fixture table This could help staff members keep track of who has entered a fixture into the system if there was ever a query about it 142 Finally it would be good to have more options available for staff members and sports Although not many other fixtures are organised at the moment there are sometimes other sports teams that are keen on competing for example a ski team and also rounders team It would also be good to have more staff members within the list of options to cater for the additional teams This would be easy to do and the forms would just need to be amended so that the drop down lists displayed the appropriate data e b Evaluation Details of extensions to the project and how these might be completed 2 The candidate has clearly thought about the additional improvements that could be made to the system They have provided a description of the improvement and how it would benefit the department and have also thought about the possible implementation of the changes 2 marks are awarded here Project Plan Timing vs Development Timings The actual development of the system did take a little longer than the planned duration This was due to the PHP code being problematic and the actual editing of the pages taking longer than expected wanted to try and get the layout and appearan
98. ce of the pages just right and to do this took quite a bit of time that hadn t planned for This was particularly relevant for the staff search pages and the fixtures list where wanted every page to look uniform in appearance and therefore make the system less confusing to the user had never done any work with PHP before so it was quite a challenge and because of this it took a while to get used to the structure of the code and when something was wrong trying to find the missing or in my code The development of the edit page also took up a lot of time as tried to get the page working for over a week but could not get it right This therefore delayed later tasks and meant that was behind schedule think my coding was very close for the page but in the end decided that it was more important to get the rest of the system working correctly and then could go back to the edit page at the end if had more time The security of the system also took longer than expected This was due to the additional security that had to be added to the staff only pages The use of session authorisation meant that coding needed to be altered and had to test each page worked correctly when both logged in and logged out also had to check all of the search results pages and confirmation pages to ensure that they did not provide unauthorised users with too much information The testing also took longer than expected as wanted to make sure the
99. ch by venue search by date There will be an option to see future and past events Client Agreement Miss Walton agree that these requirements are as discussed and am agreeable to the project being undertaken by Jenny Jackson based on this requirements specification Walter Signed l Date 27 September 2011 a iii a Analysis Information collected about the requirements of the new system 3 The candidate has covered all main areas of the new system in their requirements The requirements are specific and where data storage is concerned fields have been listed All requirements are specific and they seem to link back to the investigation However it would be useful for the candidate to try and cross reference each requirement back to the investigation for example by adding an interview question number by each of the requirements The candidate is awarded the 3 marks 22 Alternative Methods Website with backend MYSQL database A website could be used with database connectivity to store user account details and fixture information This would allow the staff to login and add edit or delete fixtures as required using an online form which connects to the backend database The fixture information could then be displayed in a range of formats with some information only visible to logged in members if required The database could be searched by students and staff and results could be displayed which match the search cri
100. chart Adding a FIXtULC cscsessssrsccsssescsssencusrencusstecacscscacscnoussencuesteneustenssssossencuserencusteneustscacseneauers 29 POMC Fh Se CNIS a FACUTE serer E ee tre EEE EE A AE 29 FOV Cees Deleting a FIX tactics rone e iE E TEE se O 29 Navigation Diagram s essessssessesesressrssessorrseesesrrssssesressrssesesreseorreresessreroseosesrrerosessesrosrereseosreeesreseoreeseseereeeee 30 PCS I aa a E E sonsimesconeaeeeeces 31 SS SS S EE L E A A A A A se EEA A A E E AS AEE AE E A acess 32 WATS ae e DEEN aio E EE E E ne eenae ens nea ee see ondetasaseaeyeaceet 32 Jor FS i scare ceracrrts nee seine E A E E nase sensinenseutpenctobusssutenctienanssamencsse neues 39 Updated Designs Following Feedback vic cssccccvencesanencacwrsvasanaredaevoseedteacineddoduasbOsahaciveuncadshessenenOtamnareatatnace oesnareas 41 TOTP a E E E E A E 44 DD ccc 6 lt 2 91 aa I e E E ee eee 50 c i Software Development and Testing ccccccessseccccessccceeesececeeececeeeeececeeesecessusecessueeceseeeuecesseaecessuneceesenes 51 Evidence of the System Webpages cccccsssccccsesececcenecceeeeseececeuseceeceeecceeeeeceseuneecesseeecessuecessugsceesenaeesetas 51 Data PFO CESS IIE sisiane E E E A Ei 97 E E E E EA NE E E EN EE T E EE 102 REGUIFEMENT SPECIFICATION TESNE seras a tetera tasiwaadanantuuaeenusiateanuieaun audi ee eiatenaneeauentanee 106 em CUD BL aH een pnd errte nn ats ae A nn etry PR UREA PY PA PE Ro eg RE ne 127 W
101. d after school The PE Department page tells you a little about our team of staff We hope you find this page useful Miss J Walton Head of Girls PE The data entry screens try to use drop down boxes as much as possible This is to limit the number of errors made when trying to search for information The drop down search options are also the same when entering data for the following fields sport and staff name The year group is also validated via the fixture entry form where only the values Yes or blank can be selected Informative instructions have also been positioed next to the drop down boxes indicating to the user what they have to select To make the custom search easier for staff members to use suggested data or data formats have been rpovided to ensure that they get their search critreria correct Fixture Search Page Staff Only You are logged in as adr Use the forms below to search for fixtures Search by Year Group Search by Sport Custom Search i cecal Event Name a Select Year Group Year Select Sport _ Athletics Fi eee submit submit Criteria submit Search by Staff Search by Sport and Year Group Select Staff Member A Dress q Select Sport Athletics T Custom Search submit Search Criteria Year7 l i i mee l Search sy Event Name 7 l Type Support Staff e g J Walton Search Unii Add a new fixture Criteria ae Date yyyy nmm dd Log out Transport Booked Yes or No Lunch Booked
102. date gt Current_Date ORDER by date echo lt table width 100 border 1 cellspacing 2 cellpadding 2 gt lt tr gt lt th gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Sport lt font gt lt th gt lt th gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Event lt font gt lt th gt lt th gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Date lt font gt lt th gt lt th gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Time lt font gt lt th gt lt th gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Staff Member lt font gt lt th gt lt th gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Venue lt font gt lt th gt lt font gt lt tr gt while Srow mysql_ fetch_array Sresult echo lt tr gt echo lt td gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Srow sport lt font gt lt td gt echo lt td gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Srow event lt font gt lt td gt echo lt td gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Srow date lt font gt lt td gt echo lt td gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Srow starttime lt font gt lt td gt echo lt td gt lt font face verdana Geneva Tahoma sans serif c
103. dit and delete fixtures Not all of the required information may be added for each fixture as there is no indication of what fields need to be entered and validation of postcodes is also not possible Searching the diary would have to be done manually and every page would need to be viewed so that the required results could be found The only people that could view the diary would be the members of the PE department and anyone they decide to show the diary to This means that fixture information would not be accessible to pupils and parents and they would have to rely upon the old method of finding fixtures i e the school website and fixtures board Cost It would be very cheap to buy a new diary About 10 and this would need to be paid every year when a new diary is required The entry of data into the diary is also cheap and could be done using pens that are provided in the school stationery cupboard Chosen System After looking at the three alternative methods have decided that the website with backend database would be most suitable for the PE department All of the requirements can be met it would be a relatively easy system for the department to use and it should solve a lot of the problems that they are facing at the moment The solution would also be cheap to implement as the required hardware and software is also readily available in school for use have explained the three different solutions to the client and my recommended syst
104. dynamic template so whenever it is updated these changes are reflected in all pages that have been created The final area is PageContent which is where the page information is to be entered Site View Template dwt lt div banner gt div Danner COMBE ABBEY SCHOOLS IPE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login PageContent Webpage Template HMTL Coding lt DOCTYPE html gt lt html dir Itr gt lt head gt lt meta content en gb http equiv Content Language gt lt meta content text html charset utf 8 http equiv Content Type gt lt BeginEditable doctitle gt lt title gt Untitled 1 lt title gt lt EndEditable gt lt link href CssStyle css rel stylesheet type text css gt lt style type text css gt lt style gt lt head gt lt body gt lt div class banner gt lt img alt Banner height 150 src Banner jpg width 1000 gt lt div gt lt div class Heading gt PE Department Fixtures Diary lt br gt lt span class a gt amp nbsp lt br gt lt span gt lt div gt lt div class main1 gt lt span class a gt lt a href Index html gt Home Page lt a gt amp nbsp amp nbsp lt a href allevents php gt Fixture List lt a gt amp nbsp amp nbsp amp nbsp lt a href fixturesrcstudent html gt Fixture Search lt a gt amp nbsp amp nbsp amp nbsp lt a href clubs html gt Club Informat
105. e lt spon class body gt You have deleted record number lt spond lt span class body gt Fixture search e lt php echo POST fdelete echo lt br gt lt be gt lt a href fixturesrestaff php gt Fixture search cracks eal echo lt br lt q href deleteform php 2Delete another fixture lt farcbr gt 5 Delete another fixture echo lt bro a href newfixture php Add a new fixture lt a gt lt br ft echo lt bro qa href Logout php log out lt at lt br o s gt Add a new fixture lt td gt Log out Rite PASS The delete fixture confirmation page clearly provides links to search for a fixture create a fixture to delete another fixture or to logout of the site The hyperlink code has been checked amp confirmed The reset button on the fixture entry page clears all form data l Home Page Fixture List Fixture Search Club Information PE Department Staff Loain Home Page Fixture List Fixture Search Qub Information PE Department Staff Login Fixture Entry Page Staff Only Fixture Entry Page Staff Only You are logged in as adr You are logged in as adr Fixture search page Fixture search pagt Log out Log out PASS The add new fixture page reset button clears all of the completed form data when clicked All drop down fields are restored back to their default values User Testing Questionnaire J Walton Test ID Was the navigation easy to use Was the page text clear to read Does the system mee
106. e some fixture information will be hidden from search results e g transport arrangements and Each member has been allocated with a username and password and they can all access the fixtures diary via the login screen Although the pages can still be selected and viewed the actual content is not visible to unauthorised users and appropriate messages are provided to say this A form has been created which allows users to enter data to the diary using checkboxes drop down lists and text fields Guidance has been provided to users explaining the format requirements of some fields Once the submit button is pressed the fixture is added to the database and all details are confirmed to the user on the next page A database table has been created and all of the required information can be stored within the database Amendments to the database structure were made during the design process to allow each year group to have data stored for fixtures Drop down boxes have been used for the two fields and no other option can be typed in apart from the ones listed It was not possible given the time limitation to develop an edit page However a deletion page was Created and it allows the user to select from a list of fixtures and type in the one they want to delete A confirmation page then displays the fixture that was deleted The fixture list shows all of the fixtures that are for today s date and beyond There are also the past fixtures displ
107. e then displays the relevant results Allows a logged in user to type in a venue then displays the relevant results Allows a logged in user to type in a date then displays the relevant results Allows a logged in user to type in whether transport is booked then displays the relevant results Allows a logged in user to type in whether lunch is required then displays the relevant results ae Search Student Page Sport Netball Year 9 Fixture Search Staff Only Sport Hockey Fixture Search Staff Only Year 13 Fixture Search Staff Only Staff Member J Wheel Fixture Search Staff Only Sport Cross Country Year 11 Fixture Search Staff Only Event ESSA Fixture Search Staff Only Support Staff J Walton Fixture Search Staff Only Venue RGS Fixture Search Staff Only Date 2012 01 17 Fixture Search Staff Only Transport No Fixture Search Staff Only Lunch Yes Records will be displayed for netball fixtures arranged for y9 students The logged in user will have access to the staff search page and the sport search results for y10 hockey will be displayed The logged in user will have access to the staff search page and the year group results for year 13 will be displayed The logged in user will have access to the staff search page and the staff member results for J Wheel will be displayed The logged in user will have access to the staff search page and the
108. e On the fixture entry page enter The data should be cleared entry page clears all form data the following information and and values will return to blank for textboxes un ticked for checkboxes and the initial value for drop down boxes then press the reset button Sport Cross Country Date 2012 10 12 Time of Day Morning Venue Gateshead Stadium Lead Staff H Dune Assistant Staff J Walton Event Newcastle Schools Time 16 00 Transport amp Lunch Yes Size 25 Year Groups All User Testing Questionnaire will give Miss Walton the questionnaire below and ask her to test the system before the arranged training session with the rest of the department will also give her a copy of the user guide so that can obtain feedback on that too 48 b i d Nature of the Solution a test plan that will identify a number of tests that will be carried out on completion of the work All requirements should be tested The specific test to be carried out should be included in the plan together with the result expected Some elements of testing should involve the end user s 4 All aspects of the system have been considered in the development of the test plan input tests visual tests navigation tests and requirement tests The candidate has also developed a questionnaire that could be given to the client We would expect to see some more validation testing on the input test plan including invalid and extreme tes
109. e could be updated to reflect changes to the house style They have also failed to explain how to amend the table and form structure if the needs of the department were to change in the future The candidate has been awarded 7 marks for this section 138 e Evaluation eevee of Requirements Specification Requirement_____ _Met _ Discussion 139 Each member of the PE department will be able to login to the fixtures diary with their own username and password Unauthorised users will not be able to view staff only areas The PE department will be able to add new fixtures to the diary using an online form A confirmation screen will be displayed once fixtures have been submitted which will summarise the data entered on the data entry form There will be a method of storing fixture data such as fixture date staff member in charge sport event name year group venue and time Validation will be used to ensure that staff names and sports have been entered correctly on the form Staff will be able to amend and delete fixtures if they have been changed or cancelled There will be a screen which will display all fixtures that have been arranged The site will follow the school s house style and all pages will include the school name and logo There will be a search facility for both visitors to the site and staff which will allow a search for fixtures by a selected year group and sport For visitors to the sit
110. e noticeboards All staff and students also get a copy of the card calendar and they should also be given a copy to take home We have found though that the website calendar is not checked very often as information is not always accurate and complete How often do you add fixtures to the diary Most are added at the start of term but after this they tend to be added once or twice a week or as they are arranged When is the busiest time for arranging fixtures The start of the autumn and summer term when we attend the fixtures meetings How do you prevent making double bookings for a teacher or a year group We just look at the date concerned and check if there is a fixture already planned for those concerned If not we can assume that a fixture has not been planned and the new one can be added to the diary If there is a clash we normally speak to the other member of staff concerned and try to see if the students play for both teams We only do this for different sports e g a year 11 netball and hockey match It just wouldn t work planning two netball matches on the same night for the same year group Can non PE department staff check the diary when they want to organise an event e g drama production 15 16 Yes normally during morning briefing or they may send me an email to check A lot of staff tend to use the card and website calendars as final fixture confirmation which can cause some tension as not every event is lis
111. e school network Expression Web and WebPlus so this software would not need to be purchased However it would need to be installed on the PE department computer as it is only installed in the ICT suites at the moment The website could also be created using HTML but the department may find this difficult to do The department also have their own desktop computer installed in their office so this could be used to maintain the site To view the site from a location other than school the department would need to use their own Internet connection and device with a web browser which they would be paying for themselves If they had this available anyway then the costs would be minimal Old Method Paper Based Diary This would be the easiest option as the department is familiar with how the diary works and they have a system in place to enter edit and view fixtures The department could access the diary during school hours and use a pen or pencil to add the fixtures they have planned If a fixture was to be amended or deleted they could use Tippex to do this or simply cross the information out Feasibility and meeting requirements It would be easy to implement the diary as the department has used it for many years and they know exactly how to use it The meeting of requirements however would be more difficult Obviously the technical requirements would not be possible as it is a manual system The department would still be able to add view e
112. e school already has hosting facilities already set up within school with the option to use a MySQL database As the school website is already hosted internally the school would not need to pay any extra money to set up the required equipment The school also has many networked computers which could be used to access the website and update fixture information To edit the webpages there are a few computers in the ICT suites which could be used but software would need to be installed on the PE department s computer As the school already has licences for WebPlus and Expression Web this could be done by the technicians at no extra cost If the department wanted to update and view the fixtures list from a location other than school they would have to rely on their own personal internet connections and devices If they had this in place already then the cost would be minimal but for someone who does not have a broadband connection at home or mobile broadband using a dongle or 3G then this could be quite costly and mean that fixtures would not necessarily be updated straight away Website A website could be used with a range of pages to display information such as department details fixture lists and practice schedules The website would have to be updated using website authoring software such as Dreamweaver Expression Web or WebPlus and someone would need to know how to use the software have access to the hosting server and understand the ba
113. e to add to the diary system The definite information would be date of the fixture venue which staff member is taking the group the year group s involved time of the fixture what sport it is what event it is and maybe what date it was added and who added the event That s all can think of at the moment Follow up Would this be the same for staff and pupils would want staff to see all of the information I have just mentioned but pupils could probably just see the information had mentioned a couple of questions ago 16 17 7 10 11 12 Would you like the option to search for fixture information e g by staff member or sport This would be really useful as there will be lots of fixtures in the diary and it would be useful to perform a search Searching by staff member date sport and year group would be the main ones think Would you like there to be any validation methods present to avoid data entry errors being made have seen on some websites how they have drop down boxes where you can choose information from this would be useful for things such as teacher initials and sport as it will save time for us and also make sure that information is not entered incorrectly We would need the option to change this information though if a staff member joined or left the department How would you like fixture information to be displayed to staff and pupils If there could be an option to display fixtures fo
114. ed to prevent duplication lt p gt lt span class h1 gt Home Page lt span gt lt p gt lt p class body gt lt span class body gt Welcome to the fixtures diary for Combe Abbey School Girls amp 39 PE Department lt span gt lt p gt lt p class body gt Here you can find information about the latest sporting fixtures that have been planned Just use the Fixture List link to view all of the fixtures or use the handy Fixture Search link to be able to search for fixtures by sport and year group lt p gt lt p class body gt The Club Information page holds information about the practices we hold on a school lunchtime and after school lt p gt lt p class body gt The PE Department page tells you a little about our team of staff lt p gt lt p class body gt We hope you find this page useful lt p gt lt p class body gt amp nbsp lt p gt lt p class body gt lt span class h2 gt Miss J Walton Head of Girls PE lt span gt lt p gt PE Department Page department html This page provides COMBE ABBEY SCHOOLS information about the department PE Department Fixtures Diary members who Home Page Fixture List Fixture Search Club Information PE Department Staff Login run sporti ng Meet the PE Department teams It provides Sports Sporting Background Team Responsibility stu d ents an d Netball Miss J Walton Gymnastics Member of Westside Netball Team Netball Years 11 to 13 are nts with Head of Girls
115. em After a discussion they agreed to use the option of a website and database Client Agreement 24 Miss Walton agree that the creation of a website with a database will be most suitable in meeting my requirements and am happy to proceed at this stage Signed jalan Date 29 September 2011 a iii b Analysis a comparison of a number of different methods of solution one of which may be the present solution and at least two others to allow a reasoned decision to be made in consultation with the client 3 The candidate has discussed each of the different methods that could be used and they have then gone on to discuss feasibility the extent to which each method meets the requirements and cost implications Although they have discussed the requirements generally the candidate should really cover each requirement individually for each of the different methods They have identified the chosen method and provided client confirmation in the form of a signature Ideally a letter email to and from the client would be useful to show that they have been consulted about the different solutions with each method explained in full The candidate is awarded 2 marks due to a number of requirements not being discussed Hardware and Software Minimum Requirements for Expression Web 4 e Microsoft Windows XP with Service Pack 3 Windows Vista Windows 7 or Windows Server 2008 Operating system e PC with 1 GHz or faster processor
116. ent Yes very simply we could lose it or it could be destroyed and there would be little or no record left of what had been written in it With the amount of fixtures we take part in the department and extra curricular timetable would come to a standstill It would also look very unprofessional when we start missing fixtures or having to re confirm every single fixture with the schools we play 4 Has the diary ever been lost or misplaced Yes it has been misplaced on a number of occasions Sometimes have forgotten where I had left the diary which causes great panic or other times it is simply hidden under paperwork This actually happens on a regular basis and it causes quite a lot of stress for my department and me Follow up What impact did this have on the department As I mentioned before it can cause quite a bit of stress as we all try to find the diary and work out who had it last Luckily we have only lost it for a day or two at a time and we normally know what fixtures we have planned for those days It just gets difficult when we need to consult the diary to look at or plan future fixtures We are a successful department with many teams being city regional and even national champions so to miss a fixture could mean missing out on that important title How big is the diary and who is in charge of it It is an A4 diary which has a hard back cover and I am in charge of it Follow up Do you view dates by day week month o
117. ent Matures weg ARE a St et ea em ae ann ON ce 2012 13 06 16 00 00 Whee O 2a pastoral a E 10 00 00 A E wiring JESSA anonsi inaa porria fixo0o0 O roventry O Oniy attempt te eccess this arce You are logged in as adr Log out Create New Fixture Delete Fixture Es ee ee ee Seimrning Newcastle Schocte Gala 2032 02 15 pee Peres es ees COMBE ABBEY SCHOOLS PE Department Pothures Clery Home Peng Fixture List Fixture Search Club information PE Department Staff Login Moat the PE Department Sparta Sparling flackgrnund Taam Fea gem nalleal ity LE bon pm Boren of Winnie aed Toe Retna Taari LL in 13 Mine bal r T iad of Giele PE Trampin nea granat snd competed ter Gerai Baan 1k to Pg fapthadl Years 9 pad 10 Aaa easy Serer ceember of he Cey Rothe Team Fairy Year 7 ire H Liis Crom Em Pipo Reteer i a jumis el Abbana lee and al erent touse bee Rekiey Yor E Heche HIND Athirhen emer of Tare Mette Te fire am on Mayet pertal fer cae courte at jurie ami aie ley ee ba Yami on Ghar Heck Tor at a TEET Piped fecha iar Tyre ard Wear s prigi arj unirarnip kawri Becky Tear E signe Tram oa tae irem armbar of Martumberiatd Hotkey Tea Bechity Tard 3 are L m Tea Ripped guash aed teri ot a Aerial lawl ci ma i Taraia uroni GE am coach ber iquaah F Term Y Te mm ear fee Greet Bien it Com Seneeth Gamri Woe i Hias 7 Wesa Truppen Peardktnships eed Bercecen Chantferrahies LVH ta HHO
118. ent at these and staff members can come along to the Resource Centre to practice using the fixtures diary and I will be on hand to answer any questions they may have Venue ICT Resource Centre clii a Installation details of the training that will need to be available for the staff who must use the new system 3 The candidate has clearly outlined some sensible and viable methods for training the staff with full details of what the training would involve and logistically how it would take place The plans have been communicated with the client and are detailed The candidate is awarded 3 marks New File Creation Including Hardware and Software Hardware Software Acquisition and Installation The school already has a large number of networked computers in every ICT room with every staff member having access to a networked computer in their teaching room or office There are network connections within each room which means the system can be accessed from any computer within the school and also at home due to the external network connection that is offered by the school s servers Therefore no extra hardware was needed to run the system on all the computers Also all of the computers meet the original hardware requirements of the system All ICT teaching computers and the ones in the Resource Centre come equipped with Microsoft Expression Web and therefore no extra software is needed See the hardware specification for the school compu
119. entered into the deletion form and upon selection of the button the record has been deleted and no longer displays on the fixture list The ability to edit records was not developed within the system due to time constraints and this part of the test cannot be achieved r6 All fixtures will be displayed There will be an option to see future and past events Swimming ESSA National Finals 2012 11 24 13 00 00 Coventry All Past PE Department fixtures Sport Event Date Time Staff Member Venue Hockey National Schools Tournament 2011 10 05 11 00 00 lA Dress The Parks Hockey County Tournament 2011 10 11 12 00 00 A Dress John Spence Hockey Friendly 2011 10 17 17 00 00 f Walton Westgate Netball County Tournament 2011 10 18 11 00 00 f Walton Blue Flames Swimming ESSA Regional Trials 2011 10 20 17 00 00 p Wheel Neptune Centre Middlesbrough Cross Country Schools Cup Round 1 2011 10 28 12 00 00 JA Dress Swimming Tyne and Wear Gala 2011 11 05 16 00 00 F Wheel RGS Cross Country Schools Cup Regional Round 2011 11 12 09 00 00 A Lille Leeds Netball City Tournament 2011 11 30 16 00 00 H Lille Westfield Cross Country National Finals 2011 12 02 09 00 00 A Dress Crystal Palace Netball Tyne and Wear Knockout 2012 01 17 16 00 00 p Walton Blue Flames Athletics Newcastle Schools Cup 2012 02 06 10 00 00 I Hamilton Gateshead Stadium Swimming Newcastle Schools Gal
120. err evrgewre x 23 Cross Country National Finals x 25 Athletics Newcastle Schools Cup ej J Tt Check All Uncheck All With selected 2 X Wi Adding a Fixture Event Search Now that the new fixture has been added to the database it can be searched using both the staff or pupil search options The first search demonstrated is a staff search for the sport Athletics The inserted record can clearly be seen in the search results The next two searches are via the pupil screens The first shows how the inserted record is displayed when searching for Year 7 Athletics and the second search shows how the fixture has been added to the fixture list 2 last record re err EELEE TYIT ea e AALE 2011 12 02 Crystal Palace A Dress 2012 02 06 Gateshead Stadium tww Dwie VY eY Vwen ree iw we owe we we we we we we 20 Yes Yes Yes Yes Yes Yes Yes 25 Yes Yes Yes HDune Weekend 09 00 00 2012 10 2017 03 25 No No J Hamilton None Morning 10 00 00 2012 10 20 17 00 29 No No COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Search Results Number of records found 1 1 Newcastle Schools Cup Sport Athletics Date 2012 02 06 Start Time Venue Gateshead Stadium Staff Member J Hamilton Second Staff Member None Transport Booked No Lunch Required No Group Size 25 Date Added 2012 10 20 17 00 29 You have searched for the spo
121. es and at the end of each record will be an option in the form of a hyperlink to edit the fixture The fixtures are displayed via a connection to the database with the records being displayed in a table When the edit button is selected the record is then displayed on the fixture edit form Unauthorised viewers cannot see this page and a message is displayed to inform them This screen is displayed when the edit button is selected The corresponding record details will be displayed in the text and drop down boxes via a connection to the database and the user will have the option to edit any of the fields Once they have finished they can click on submit and the updated data will be amended on the database The user also has an option to cancel any changes they have made and this button will return them to the editing page Fixture Delete Page Staff Only Whilst logged in a staff member can also Fixture Delete Page delete fixtures From a connection to the Instructions to the user fixtures database a list of all fixtures is provided to the user along with the ID number for each fixture The user simply needs to find the fixture from the list and enter the corresponding number into the text box Upon the clicking of Delete Event the Enter Event ID Cd Dace Euan event will be deleted from the database and a confirmation page will be displayed to the Links to other staff only pages user showing which record has been de
122. esult echo lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Number of records found Snum_results lt font gt lt p gt for Si 0 Si lt Snum_results i Srow mysql_fetch_array Sresult echo lt p gt lt strong gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Si 1 echo htmlspecialchars stripslashes Srow event echo lt strong gt lt br gt Sport echo stripslashes Srow sport echo lt br gt Date echo stripslashes Srow date echo lt br gt Start Time echo stripslashes Srow time echo lt br gt Venue echo stripslashes Srow venue echo lt br gt Staff Member echo stripslashes Srow staff1 echo lt br gt Second Staff Member echo stripslashes Srow staff2 echo lt br gt Transport Booked echo stripslashes Srow transport echo lt br gt Lunch Required echo stripslashes Srow lunch echo lt br gt Group Size echo stripslashes Srow size echo lt br gt Date Added echo stripslashes Srow dateadded echo lt font gt lt p gt gt lt span gt lt span class h2 gt You have searched for the sport lt span gt lt span class body gt lt php echo S_POST fsearchsportonly echo lt br gt lt br gt lt a href fixturesrcstaff php gt Fixture search page lt a gt lt br gt lt br gt echo lt a href logout php gt Log out l
123. f Day Morning Venue Lead Staff Member y A Dress H Dune Hamilton D H Lille Walton Wheel None Assistant Staff Member Year it Year Group s Year 1 PASS The 6 required staff members are displayed on the fixture entry page under the lead staff field PASS The 6 required staff members are displayed on the fixture entry page under the assistant staff field Input Testing For information testing of the login form and new fixture form has already been done through the requirement specification testing Allows the any user to select a sport and year group then displays the relevant results E Department Fixtures Diary COMBE ABI Home Page Fixture List Fixture Search Fixture Search PE Department Fixtures Diary Home Page Fixture List Fixture Search C Use the form below to search for fixtures Fixture Search Results Number of records found 2 Select your sport and year group 1 County Tournament Select Sport Netball Date 2011 10 18 Time W Select Year Venue Blue Flames submit Staff Member J Walton 2 Tyne and Wear Knockout PASS The user can select a sport and year from the drop down Date 2012 01 17 boxes and the search results are displayed They have selected Timer A Venue Blue Flames netball and year 9 with the search criteria confirmed at the Staff Member J Walton end of the sea rch results You have searched for the sport Netball for y9
124. fice where we can install the system ready for user practice on the 21 May will give your form tutor a list of the next two month s fixtures think there s about 50 and hope that s ok look forward to seeing you then Kind regards Man J Walton Tel 0191 222 3321 Fax 0191 222 3322 Email enquiries combeabbey ac uk Principal Mr A Watson Training The timetable for installation and training is shown in a table below and it was this document that I sent to Miss Walton with my letter above Before implementation is it necessary to show all staff that will be using the system how it works and allow the future users to ask questions about the system The demonstration will take place in the ICT Resource Centre at the school as part of a PE Department meeting so that all of the department will know how to use it The system will run from a school computer which will have access to the system with the final system being located on the school network It will also be projected onto a large screen Once the demonstration has taken place staff will then be able to login to the system and practice adding searching for and deleting fixtures The plan for this demonstration will be to do the following show each of the website pages and basic student search options show users how to login to the 128 system demonstrate how to add a new fixture show how to delete a fixture and finally how to perform some advanced searches on the fi
125. g to access the area The fields which are to be filled in by staff members are clearly labelled PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Staff Login Area Only attempt to access this area if you are authorised to do so You are not logged in Userid Password _Log in Create New Fixture Delete Fixture Fixture Search Anyone who does attempt to access the staff only areas are provided with a message to state that the area is restructured and they must be logged in to see the content PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Entry Page Staff Only You are not logged in Only staff may see this page Fixture search page Log out 133 Staff Fixture Search The fixture search page for staff is a data entry form and a range of labels are provided to indicate to staff what each search will look for For the custom search additional support has been provided to staff members so that they know the format for data to be entered When search results are displayed the search criteria is confirmed at the bottom of the page for staff reference just to clarify exactly what has been searched for PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Search Page Staff Only You are lo
126. ge PHP Coding amp nbsp lt h1 gt lt span class h1 gt Log out lt span gt lt h1 gt lt span class body gt lt php if empty Sold_user echo Logged out lt br gt lt br gt else if they weren t logged in but came to this page somehow When a staff member clicks on the Log Out link they are logged out of the staff only area and the following screen is displayed to confirm this Staff Login COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Log out You were not logged in and so have not been logged out Back to main page echo You were not logged in and so have not been logged out lt br gt gt lt span gt lt span class h1 gt lt a href index html gt Back to main page lt a gt lt span gt lt span class body gt lt span class h1 gt lt span gt lt span gt lt p gt 64 New Fixture Data Input Page not logged in newfixture php If anyone tries to access the fixture entry page COMBE ABBEY SCHOOLS when not logged in they are denied access a message is displayed to PE Department Fixtures Diary inform them that they Home Page Fixture List Fixture Search Club Information PE Department StaffLogin MUSt be logged in Fixture Entry Page Staff Only You are not logged in Only staff may see this page Back to in e Log out New
127. gged in as hdu Use the forms below to search for fixtures Search by Year Group Search by Sport Custom Search ae Event Name T Select Year Group Year Select Sport Athletics T iA submit submit Criteria submit Search by Staff Search by Sport and Year Group Select Staff Member A Dress Select Sport submit Search Criteria Year 11 Custom Search submit search sy Event Name P i E i F Add a new fixture Type Support Staff e g Walton Search Wears Log out Criteria Date yy mim dd J i res L re bas my Transport Booked Yes or No Lunch Booked Yes or No Home Page Fixture List Fixture Search Club Information PED Number of records found 2 1 Schools Cup Regional Round Sport Cross Country Date 2011 11 12 Start Time Venue Leeds Staff Member A Lille Second Staff Member J Walton Transport Booked No Lunch Required No Group Size 25 Date Added 2012 10 20 17 03 25 2 Newcastle Schools Gala Sport Swimming Date 2012 02 15 Start Time Venue West Denton Pool Staff Member J Wheel Second Staff Member J Walton Transport Booked Yes Lunch Required No Group Size 16 Date Added 2012 10 20 17 03 25 You have searched for staff with the criteria Walton Fixture search page Log out 134 Fixture Entry Page The new fixture page for staff is a data entry form and a range of fields and labels are presented to the user Most fields are completed via the selectio
128. gin Home Page Fixture List Fixture Search Gub information PE Oepartment Staff Login Fixture Entry Page Staff Only Fixture Confirmation You are logged in as adr Sport Event Name Fixt D Sport Athletics G Event Schools Cup Fixture Time Time of ay Date yyyy mm dd 2012 06 13 Time hh mm 09 00 Time of Day Morning Transport Booked O Vear Groupe Venue Gateshead Stadium Packed Lunch 4 va iE Bembarr 4 Ui a x n aeee Support Staff Lead Staff Member H Lille 4 Team Size approx 30 Trenapert Geoked Na yes a i La Assistant Staff Member None Puran stant Year 7 Year 10 Year 12 M submit Year Group s Year 8 Year 11 Year 13 M Year9s M reset Fixture search page 32 Swimming lyne and Wear Gala 2012 11 06 HGS J wheel NULL Evening 16 00 00 2012 10 21 11 0938 No NO NULL NO NO NO NO NO NO NO 33 Athletics Schools Cup 2012 06 13 Gateshead Stadium H Lille None Morning 09 00 00 2012 10 21 11 29 10 No Yes 30 Yes Yes Yes Yes Yes Yes Yes Check All Uncheck All With selected X Mi Sport Athletics Start Time oe PASS The user has been able to insert the data into the data entry form It has then Stai Member H Ula aca epea been sent to the confirmation page and the database When a search is performed Transport Booked M Lunch Required Yes the record is displayed showing the data that has been entered by the user Date Added 2012 10 21 11 29 10 Ficture search page Log out Unauthorised users will not be able
129. gt echo lt td gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Srow sport lt font gt lt td gt echo lt td gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Srow event lt font gt lt td gt echo lt td gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Srow date lt font gt lt td gt echo lt td gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Srow starttime lt font gt lt td gt echo lt td gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Srow staff1 lt font gt lt td gt echo lt td gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Srow venue lt font gt lt td gt echo lt tr gt echo lt table gt mysql_close Scon gt Staff Login Page login php oe 7 ay will be authorised to view the staff only page links to the MySQL database and de embedded within the page COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Departme Staff Login Area COMBE ABBEY SCHOOLS Only attempt to access this area if you are authorised to do so PE Department Fixtures Diary You are not logged in Userid Password Home Page Fixture List Fixture Search Club Information PE Department Staff Login Login
130. gt lt tr gt lt tr gt lt td class h2 style width 134px gt amp nbsp lt td gt lt td class h2 style width 121px gt Sports lt td gt lt td class h2 style width 454px gt Sporting Background lt td gt lt td class h2 gt Team Responsibility lt td gt lt td class h2 style width 134px gt Miss J Walton lt br gt Head of Girls amp 39 PE lt td gt lt td style width 121px gt Netball lt br gt Gymnastics lt br gt Trampoline lt br gt Athletics lt br gt lt td gt lt td style width 454px gt Member of Westside Netball Team lt br gt National gymnast and competed for Great Britain 1996 to 2003 lt td gt lt td gt Netball Years 11 to 13 lt br gt Netball Years 9 and 10 lt td gt lt td class h2 style width 134px gt Mrs H Lile lt td gt lt td style width 121px gt Hockey lt br gt Tennis lt br gt Cross Country lt td gt lt td style width 454px gt Current member of the City Hockey Team lt br gt Played hockey as a junior at National level and at senior county level lt br gt lt td gt lt td gt Hockey Year 7 lt br gt Hockey Year 8 lt td gt lt td class h2 style width 134px height 17px gt Mrs H Dune lt td gt lt td style height 17px width 121px gt Hockey lt br gt Athletics lt br gt Netball lt br gt Gymnastics lt td gt lt td style height 17px width 454px gt Member of Tyne Netball Team lt br gt Played netball for the county at junior and senior levels lt br gt lt td
131. h is how I plan to develop the diary system This will help me to decide what method of training will be most suitable for the department and the content required One method of training could be through the use of a user guide so this question will find out whether the department would use one This is to find out the best format to present the user guide that would suit the department This question will find out whether need to use a specific format for layout and fonts etc for the diary system This will tell me whether should use the website as a guide for the layout of the diary system As the diary system may be accessed via the Internet need to find out what hosting facilities the school has in place at the moment understand Miss Walton may not know anything about this If not could you recommend a technician who This will direct me to someone who can 17 Do you know anything about the school network and how they host their website 15 Follow Up could speak to explain the hosting options that the school has in place at the moment Interview with Miss J Walton Date 20 September 2011 Time 12 00pm Venue School library 1 Do you want to continue using the old diary system I am quite attached and familiar with the diary as we have been using it for so many years now but due to all of the problems we are facing at the moment with it I am interested in trying out an alternative system 2 How would yo
132. he correct data Student Search Sport Select your sport and year group Select Sport Athletics Select Year Cross Country Hotkey Netball Squash Swimming Tennis PASS The 7 required sports are displayed on the student search page Fixture Entry Sport You are logged in as adr Sport f Athletics Cross Country Date yyyy mmi dd Hockey Time of Day Netbal Swimming Venue Tennis Lead Staff Member Squash PASS The 7 required sports are displayed on the fixture data entry page Staff Search Sport Staff Search Year Group 111 Student Search Year Group Use the form below to search for fixtures Select your sport and year group Select Sport Athletics P Select Year y Year Year 8 Year 9 Year 10 Year 11 Year 12 Year 13 PASS The 7 required year groups are displayed on the student search page Staff Search Sport Search by Sport Select Sport v Athletics Cross Country Hockey Netball Squash Swimming Tennis Select Sport aIneics PASS The 7 required sports are displayed on the staff search page under the sport only search Search by Spal Search by Sport and Year Group Select Sport f Athletics y Search Criteria Cross Country Hockey Netball Squash Swimming Tennis PASS The 7 required sports are displayed on the staff search page under the sport and year search Staff Search Custom Custom Search Search i Event Name J I ie H Suppo
133. he date format You are logged in as adr has been provided for Sport Event hh users to follow Morning PE Department Fixtures Diary p Date yyyy mm dd Time hh mm Time of Day Morning Transport Booked Venue Packed Lunch Lead Staff Member Team Size approx Assistant Staff Member Year 7 Year 10 Year 12 submit Year Group s Year 8 Yearii J Year 13 Year 9 eset Fixture search page Log out 104 c i c Software Development and Testing hard copy evidence of an effective HCI with annotations explaining its effective solutions for problems that had been highlighted in the requirements specification 2 The candidate has customised their system following the company house style They have ensured that every page follows the same layout and pages are consistent The candidate has used drop down boxes and check boxes to try and limit user input and provide a form of validation They have provided an explanation to the user regarding what each page contains and users are clearly notified when they try to access a restricted area The candidate has also added onscreen instructions to the user explaining how to use the search facility for example or the data format that should be entered when submitting data via a form It would be good to see a little more onscreen support for the user in the form of an online user guide link and further prompts but the candidate has clearly demonstrated their customisat
134. he school have a website and house This question is to find out whether the school style that they use for publications has a corporate house scheme that they use at present a ii b Investigation reasoned set of questions to elicit important information possible responses have been considered and follow up questions have been planned 3 A range of questions have been planned that cover the main areas input output and storage The candidate has also considered system HCI and processing that is carried out within the current system All questions have been justified and there are a number of follow up questions showing that the candidate has thought about the possible responses they may get They are awarded the 3 marks for this section Oo SOS Interview Transcript Current System Interview with Miss J Walton Date 12 September 2011 Time 12 00pm Venue School library 1 Please could you explain to me how the fixtures diary is used at the moment At the end of an academic year we order a new diary from Thelma our stationery representative We then start to enter fixtures that have already been organised and continue to do so throughout the new academic year The diary is our one central store of all of the fixtures we have organised so it is really important that everything is entered as soon as it is planned We also enter other events that are happening around school so that we are aware of days when students may be unava
135. ia from a drop down box In addition there is a more customised search available which lets users type in their search criteria from the following options By Event By Venue By Date By Transport By Support Staff By Lunch There will be an option to see future and The fixtures list sorts fixtures into two tables one past events for fixtures that are being held today and later The other is for any fixture that occurred before today System Discussion The system allows students and staff members to view all of the fixtures that have been added to the diary All records are stored within a database meaning that users can perform customised searches and authorised users can also add and delete fixtures within the database Staff can also perform a range of searches for fixtures depending on the query they may have The system is to be used mainly by staff parents and pupils of the school but it could also be visited by the general public and for anyone interested in attending the school it would act as a good marketing too to demonstrate the school s involvement in PE To ensure that only authorised staff members can add and delete fixtures security measures have been put in place A login screen and the use of PHP coding in particular sessions ensures that only a logged in member can see the full screens for adding deleting and advanced searching of the diary Anyone who tries to access these pages without being logged in will be
136. idth 100 border 1 cellspacing 2 cellpadding 2 gt lt tr gt lt th gt lt font face verdana Geneva Tahoma sans serif gt ID lt font gt lt th gt lt th gt lt font face verdana Geneva Tahoma sans serif gt Sport lt font gt lt th gt lt th gt lt font face verdana Geneva Tahoma sans serif gt Event lt font gt lt th gt lt th gt lt font face verdana Geneva Tahoma sans serif gt Date lt font gt lt th gt lt th gt lt font face verdana Geneva Tahoma sans serif gt Time lt font gt lt th gt lt th gt lt font face verdana Geneva Tahoma sans serif gt Staff Member lt font gt lt th gt lt th gt lt font face verdana Geneva Tahoma sans serif gt Venue lt font gt lt th gt lt font gt lt tr gt while Srow mysaql_ fetch_array Sresult echo lt tr gt echo lt td gt lt font face verdana Geneva Tahoma sans serif gt Srow eventid lt font gt lt td gt echo lt td gt lt font face verdana Geneva Tahoma sans serif gt Srow sport lt font gt lt td gt echo lt td gt lt font face verdana Geneva Tahoma sans serif gt Srow event lt font gt lt td gt echo lt td gt lt font face verdana Geneva Tahoma sans serif gt Srow date lt font gt lt td gt echo lt td gt lt font face verdana Geneva Tahoma sans serif gt Srow starttime lt font gt lt td gt echo lt td gt lt font face verdana Genev
137. ilable due to trips exams or other activities Normally I keep a hold of the diary but other members of my department may borrow it to take to a meeting or to check add fixtures Each member of the department is responsible for at least one team i e netball hockey and cross country during the autumn and spring terms with athletics and tennis in the summer term There are other members of staff non PE who also look after smaller teams such as swimming and squash We tend to have fixtures on a daily basis including weekends and there are often fixtures arranged during the school day We try to organise them during a PE lesson but this is not always possible and it can mean that staff and students have to miss their normal lessons The fixtures are also planned around our extracurricular timetables which is a list of all of the clubs both sporting and non that take place within school 2 What problems are you experiencing with the diary at the moment It is sometimes misplaced which can cause quite a bit of worry for the department The diary also looks very messy as the term goes on with numerous additions and editing of existing events There are also problems when more than one person needs to check or add to the diary as it cannot be in two places at the same time Sometimes there are also problems with messy handwriting and we can t always read what has been entered 3 Do you have any worries about the diary system you use at the mom
138. ilton lt option gt lt option gt H Lille lt option gt lt option gt J Walton lt option gt lt option gt J Wheel lt option gt lt select gt lt td gt lt tr gt lt tr gt lt td style width 134px gt amp nbsp lt td gt lt td style width 129px gt lt input class h2 name Submit4 type submit value submit gt lt td gt lt tr gt lt table gt lt form gt lt td gt lt td style width 343px gt lt form action staffsrcsportyear php method post name sportyear gt lt table style width 81 gt lt tr class body gt lt td class body style width 105px gt Select Sport lt td gt lt td class body gt lt select name fsearchsport class body gt lt option gt Athletics lt option gt lt option gt Cross Country lt option gt lt option gt Hockey lt option gt lt option gt Netball lt option gt lt option gt Squash lt option gt lt option gt Swimming lt option gt lt option gt Tennis lt option gt lt select gt lt td gt lt tr gt lt tr class body gt lt td class body style width 105px gt Search Criteria lt td gt lt td class body gt lt select name fsearchyear class body gt lt option value y7 gt Year 7 lt option gt lt option value y8 gt Year 8 lt option gt lt option value y9 gt Year 9 lt option gt lt option value y10 gt Year 10 lt option gt lt option value y11 gt Year 11 lt option gt lt option value y12 gt Year 12 lt o
139. ion 2 is positive This is to see how likely Miss Walton will Follow Up Would you be interested in using an online diary want to change from a paper based Explain the features of an online diary system if system to an online diary that could needed potentially be accessed from anywhere Who would you want to add new fixtures to the This will tell me how many user accounts diary Do you want to do this yourself or are you need to create for the diary system to happy for the rest of your department to assist enable users to add fixtures O a Tete ee thet lb rege by the ary diary system system that will be required by the diary 5 Would you want everyone to be able to see the This will help me to find out whether the same fixture information fixture information can be published to everyone i e the general public or whether Miss Walton would like some information to be kept private 5 If no would you like there to be different This question will help to identify whether Follow Up information for staff and pupils separate access areas are required for staff pupil information What fixture information would you like to add to This question will help me to identify the the diary system exact data which needs to be stored in the new system 6 Would this be the same for staff and pupils As with question 5 this will help me to Follow Up identify which information should be visible to the two different groups and wha
140. ion lt a gt amp nbsp amp nbsp amp nbsp lt a href department html gt PE Department lt a gt amp nbsp amp nbsp amp nbsp lt a href login php gt Staff Login lt a gt lt span gt lt br gt lt div class main style left Opx top 17px gt lt BeginEditable PageContent gt lt p gt lt span class body gt PageContent lt span gt lt p gt lt EndEditable gt lt div gt lt div gt 51 lt body gt lt html gt 52 Home Page index html This is a brief introductory COMBE ABBEY SCHOOLS page to anyone viewing the site PE Department Fixtures Diary to provide him as l or her with Home Page Fixture List Fixture Search Club Information PE Department Staff Login Hame Paes information Welcome to the fixtures diary for Combe Abbey Schoo Girls PE Department a bo ut what the Here you can find information about the latest sporting fixtures that have been planned Just use the Fixture List link to view all of the fixtures or use the handy it ff Fixture Search link to be able to search for fixtures by sport and year group Site otters The Club Information page holds information about the practices we hold on a school lunchtime and after school The PE Department page tells you a little about our team of staff We hope you find this page useful Miss J Walton Head of Girls PE Home Page HTML Coding For all pages only the code within the editable areas of the template is provid
141. ion of the HCI and their evidence has been annotated explaining how the system operates to meet user requirements 2 marks have been awarded 105 Requirement Specification Testing PE department members can login to the fixtures diary with their own username amp password PE Department Fixtures Diary PE Department Fixtures Diary Options userid password forename surname adr password Anne Dress hdu password Helena Dune jha password Jane Hamilton hii password Helen Lille You are not logged in jwa password Jane Walton You are logged in as adr 7 jwh password Jen Wheel Userid adr Password fssssesss 1 Log out to Check All Uncheck All With selected Zo E PASS The user has been granted Create New Fixture Create New Fixture access to the staff only area as their Delete Fixture es details are stored in the database and Fixture Search Fixture Search Staff Login Area Staff Login Area Only attempt to access this area if you are authorised to do so Only attempt to access this area if you are authorised to do so the login script works as intended The department can add new fixtures to the diary using an online form A confirmation page will display the submitted fixture There will be a method of storing fixture data COMBE ABBEY SCHOOLS COMBE ABBEY SCHOOLS PE Department Fixtures Diary PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Lo
142. l With selected A 7 X E hl B Table Data Users Show 30 row s starting from record 0 in mode and repeat headers after 100 cells Son by key Options userid password forename surname g X adr password Anne Dress O Lf X hdi password Helena Dune O fF X ma password Jane Hamilton O fA X hil password Helen Lille O Lf X jwa password Jane Walton O Lf A jwh password Jen Wheel Check All Uncheck All With selected 2 X W Show 30 row s starting from record 0 in mode and repeat headers after 100 cells y 95 Evidence of the System File Structure This shows all files related to the website and how each page has its title formatted appropriately Name Title Size Type aah allevents php CA PE Department Fixtures List SKE php Banner jpg Banner jpg 47KB jpg dubs html CA PE Department Clubs html Aj CssStyle css CssStyle css IKB css qh delete php CA PE Department Fixture Delete Confirmation 3KB php qin deleteform php CA PE Department Fixture Deletion SKB php a department html CA PE Department Department Information 4KB html he fixturesrcstaff php CA PE Department Staff Fixture Search 8KB php fixturesrcstudent html CA PE Department Fixture Search IKE html fal index html CA PE Department Home IE html qn insertLphp CA PE Department Fixture Confirmation SKB php ih login php CA PE Department Staff Login 3KB php qin logout php CA PE Department Logout php qin newfixture php CA PE Department Add
143. lect an option from the available list This prevents invalid search criteria from being entered The only exception is the custom search which allows users to select their search area and then type in their search criteria To assist users instructions for data entry formats are also provided alongside the search area names Coste earth Search Event Name Type Support Staff e g J Walton Search y Criteria e Date yyyy mm dd Transport Booked Yes or No Lunch Booked Yes or No PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Search Page Staff Only You are logged in as jwh Use the forms below to search for fixtures Search by Year Group Search by Sport Custom Search Search Event Name 3 Select Year Group Year l Select Sport Athletics ypa i l gt Search p AA submit submit Criteria _ submit Search by Staff Search by Sport and Year Group Select Staff Member Select Sport Athletics i submit Search Criteria Year submit Add a new fixture Log out 75 Staff Search Page HTML Coding lt php session_start gt lt echo lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt lt h3 gt Fixture Search Page Staff Only lt h3 gt lt font gt check session variable if isset SHTTP_SESSION_VARS valid_user echo lt p gt lt font face verdana Geneva Tahoma sa
144. leted Unauthorised viewers cannot see this page and a message is displayed to inform them that access has been denied Fixtures Deletion Confirmation Page Staff Only As previously mentioned this page is simply Fixture Deletion Confirmation Page to confirm which record has been deleted You have successfully deleted record and the fact that the process has taken place Click here to delete another fixture If the ID number is incorrect then an appropriate message will be displayed to Logged in staff links inform the user that their request was not possible and no record could be found The page provides the user with the option to delete another fixture or to access the other staff only pages Fixtures Search Page Staff Only This page is only visible to staff members and Fixture Search Page Staff Only rovides them with the option to carry outa Search Instructions p p y wider range of searches than parents and a y ppor aea a a ee upils The user can select a range of elect Sport Select Sport M PRUS 8 Select Year YJ searches which use drop down boxes to Submit enable the user to select their search criteria Search by Year Custom Search There is also a custom search enabling the Select Year sf Select Criteria L__M Enter Search J staff MEMET Ee AEA fields and to type in their own criteria Each search Search by Staff directs the user to a customised results page Select Staff C M
145. lps to quickly identify the member of staff associated with the fixture This is done mainly by myself when a member of my department tells me of a new fixture but sometimes they add it in themselves Follow up What information do you add to a fixture entry in the diary Under the fixture date we add the sport event name year group s time of the event venue and staff initials who is taking the team Follow up What happens if a fixture is changed or cancelled We normally just cross the event out in full if cancelled or alter the information using tippex if it is changed How many teams do you actually have running in the school We have teams for every year group from years 7 to 11 and then normally a 6 form team so that s 6 different year groups in total For every year group there is a netball and hockey team in the first two terms and then tennis and athletics teams in the summer Each team has their own dedicated practice either during lunchtimes or after school and a member of the PE department is responsible for each team So altogether there are 12 teams to organise each term In addition to these main teams there are the swimming and squash teams but their age groups are often combined as are events which normally happen at the same time for all age groups rather than being spread over different days 9 10 11 12 13 14 10 Where is the diary kept during the day I normally keep the diary with me
146. lts By Sport and Year Group PHP Coding lt p gt lt span class h1 gt Fixture Search Results lt span gt lt p gt lt p gt lt span class body gt lt php create short variable names Ssearchsport SHTTP_POST_VARS fsearchsport Ssearchyear SHTTP_POST_VARS fsearchyear Ssearchsport addslashes Ssearchsport Ssearchyear addslashes Ssearchyear Sdb mysql_ pconnect localhost root if Sdb echo Error Could not connect to database Please try again later exit mysql_select_db PE Squery select from fixtures where sport Ssearchsport and Ssearchyear like Yes ORDER BY date Sresult mysql_query Squery Snum_results mysql_num_rows Sresult echo lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Number of records found Snum_results lt font gt lt p gt for Si 0 Si lt Snum_results i Srow mysql_fetch_array Sresult echo lt p gt lt strong gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Si 1 echo htmlspecialchars stripslashes Srow event echo lt strong gt lt br gt Sport echo stripslashes Srow sport echo lt br gt Date echo stripslashes Srow date echo lt br gt Start Time echo stripslashes Srow time echo lt br gt Venue echo stripslashes Srow venue echo lt br gt Staff Member echo stripslashes Srow staff1
147. me StaffMember Venue ockey 011 10 05 11 00 00 JA Dress rne Parks ckey County Tournament fzo111011 ohn Spence ckey 11 10 17 gat etball County Tournament 011 10 18 11 00 00 lue Flames wimming ESSA Regional Trials 11 10 20 eptune Centre Middlesbrough ross Country 11 10 28 nwick wimming 011 11 05 16 00 00 G ross Country Schools Cup Regional Round 2011 11 12 ball 11 11 30 Cross Country National Finals 011 12 02 09 00 00 A Dress Crystal Palace ae PJ ary So m un u o h To r ii 2 j j PJ as 8 BJ Pod T i O hh n GI Wi 0 iD iD a PJ Po r rm m PJ BIJ PJ J Pa e Netball Tyne and Wear Knockout 12 01 17 16 00 00 ue Flames Athletics Newcastle Schools Cup 012 02 06 10 00 00 Hamilton Gateshead Stadium 1 Swimming Newcastle Schools Gala 012 02 15 16 00 00 est Denton Pool a men i Athletics Schools Cup 2012 06 13 H Lille Gateshead Stadium Swimming Tyne and Wear Gala 2012 11 06 16 00 00 Wheel Cross Country National Finals 012 11 09 10 00 00 Sheffield Athletics Stadium Swimming ESSA National Finals 2012 11 24 13 00 00 Coventry _________ gt So i un md men 2 B 23 j4 Netball 33 32 0 uw hh He R 2 m er lt Enter ID Number Delete Fixture De e PARTIAL PASS This shows how the fixture with the ID number 34 has been
148. med to the user The fixture will display on the Fixture List The unauthorised user will be denied access to all three pages Users will only be able to select values from the drop down box options Fixture 34 Cross Country Regional finals have been deleted and a confirmation page is displayed All fixtures are displayed and there are separate display options for future and past fixtures 3 fixtures will be displayed and the search criteria will be confirmed to the user The fixture search and staff search pages will display 3 results but staff will be able to view more fields There will be 5 different searches available By year group By staff member By sport By sport and year group Custom search There will be general information View Home Page about the clubs and the View Fixture List department View Fixture Search The site will follow the school View Club Information house style and pages will include View PE Department the school logo View Staff Login View Fixture Search Page Visual Tests The home club and department pages will provide information to viewers Each page will follow the house style and include the logo ean Input Data Expected Result Each page follows Site Template the house style Each page includes Site Template the logo amp school name Drop down boxes Check the drop down boxes on the contain the correct following pages contain the correct data options fi
149. ment team including their sporting background The staff login page will allow authorised users to enter their username and password in order to gain access to the fixture add deletion and edit pages along with the advanced search pages Login Page The login page will allow authorised users to Username access the staff only areas of the system They Password Login Page must enter their username and password and this is verified against the ones stored in the user database once a connection has been Information to users about logging in established If they are valid then the user is granted access and a message is shown to say they are now logged in If access is not granted a message is also displayed to let them know Once logged in a session will be commenced to provide them access to other staff only areas Fixture Entry Page Staff Only Within the page content area the Data Entry Instructions following data entry form would be added This would allow the user to either sport C M event P Event select from drop down boxes or enter the Date Time f text using a keyboard It will allow the logged in user to add a new fixture to the Time of Day a database Year Group C se cubmit button wil ake Submit The submit button will take the user toa Venue O confirmation page as well as inputting the data into the connected database This Lead Staff OOO M page is only visible to
150. method of storing fixture data Unauthorised users will not be able to view staff only areas Validation will be used to ensure that the staff names and sport are entered correctly on fixture entry form Staff will be able to amend and delete fixtures All fixtures will be displayed There will be an option to see future and past events A search facility allows visitors and staff to search for fixtures Visitors to the site will have some results hidden from their search Staff will be able to carry out a wider range of searches T Login Page Username adr Password password New Fixture Page Sport Athletics Date 2012 06 13 Time of Day Morning Venue Gateshead Stadium Lead Staff H Lille Assistant Staff None Event Schools Cup Time 09 00 Transport Unticked Lunch Ticked Team Size 30 Year Groups Ticked All Staff Login Page amp Select Create New Fixture Delete Fixture Fixture Search New Fixture Page Select Drop Down Boxes For Sport Lead amp Assistant Staff Delete Fixture Page Enter Fixture ID 34 View Fixture List Page Fixture Search Page amp Select Sport Cross Country Year 7 Fixture Search Page amp Select Sport Swimming Year 7 Staff Search Page amp Select Sport Swimming Year 7 Select Staff Fixture Search Page All users will be able to log in and a database will store their login details The details will be added to the database The fixture will be confir
151. n of a drop down box and checkbox but other labels require text to be entered For any fields where data has to be entered in a specific format this is indicated on the form and an example is provided for staff Once the form is submitted a confirmation page is displayed which shows the field names and data that has been entered for each field COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Entry Page Staff Only You are logged in as adr Sport Event Schools Cup Date yyyy mm dd 2012 06 13 Time hh mm 09 00 Time of Day Transport Booked CL Venue Gateshead Stadium Packed Lunch Lead Staff Member Team Size approx 30 Assistant Staff Member Year 7 Year 10 Year 12 M _submit Year Group s Year 8 Year 11 Year 13 M Year 9 reset Fixture search page Log out 135 COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Confirmation Sport Athletics Event Name Schools Cup Fixture Date 2012 06 13 Fixture Time 09 00 Time of Day Athletics Year 7 Yes Year 10 Yes Year 12 Yes Year Groups Year B Yes Year 11 Yes Year 13 Yes Year 9 Yes Venue Gateshead Stadium Lead Staff Member H Lille Support Staff None Transport Booked No Lunch Required Yes Group Size 30 Add another fixture Fixture search page Log ou
152. nals 23 Cross Country etball Tyne and Wear Knockout 4_ Netball 25 Athletics thletics Newcastle Schools Cup 21 Swimming wimming Newcastle Schools Gala 33 Athletics 32 Swimming n i 1 Ty ee idl res eres eres rere vers evens eves ees eens ners eres ees ees es es ee thletics Schools Cup 31 Cross Country Swimming Tyne and Wear Gala Bo Cross Country National Finals Enter ID Number wimming ESSA National Finals MENET pe Fixture Enter ID Number 15 PASS the fixture with the ID 15 was selected a from the list and entered in the data entry field Fixture search page The submit button was then pressed and confirmation was provided that the record had been deleted This could be also seen from the ee updated delete page un S F S 8 R R F S 8 S S e Add new fixture i14 Unauthorised users are denied access from the staff areas aye Home Page Fixture List Fixture Search Club Information 120 Home Page Fixture List Fixture Search Club Info Staff Login Area Staff Login Area Only attempt to access this area if you are authorised to do sa Only attempt to access this area if you are authorised to do so Could not log you in Userid You are not logged in een A Log in nM Userid sj Passwordifwed create New Ft Legim Delete Fixture Create New Fixture Fixture Search Delete Fixture Fixture Search PASS
153. ndidate has included each requirement and has stated whether it was passed or not They have then discussed the requirement to try and explain how and where it has been met In addition they have discussed the system that they have created including what it can do and who it has been aimed towards The one requirement which was not successfully completed has been discussed along with the reason for its failure The candidate has provided an alternative option that could be used with the client whilst the failure is rectified This is a detailed evaluation and can be awarded the 4 marks Extensions Although the system nearly works as requested there are a number of extensions which could be added to make it work event better The results page could be better arranged At the moment there are limited fixtures within the diary but as time goes on more and more fixtures will be displayed in the search results At the moment staff search results are displayed in a vertical manner meaning that the page could get very lengthy and the user would have to scroll down quite a lot As an alternative a table display could be used very similar to that used on the fixture list page Obviously more fields would be added but this would limit the vertical space used to display the search results and would make more use of the whole page It may also be worth splitting the results between current and past fixtures similar to the fixture list so that s
154. nfirms this via an on screen message When the user now tries to access the staff only areas they will be displayed with the access denied messages Drop Down Box Data There will be a range of drop down boxes within the site and the table below shows the data that will be listed within each Staff Names Time of Day J Wheel Cross Country Morning Event J Walton Athletics Afternoon Venue A Dress Hockey Evening Support Staff H Dune Swimming Weekend Transport J Hamilton Netball Lunch H Lille Tennis Date Squash 37 Security Open Access Pages Fixtures List Fixture Search Club Information PE Department Staff Login es ns Staff Only Access Accessible via an authorised Username and Password Add Fixture Staff Search Add Fixture Confirmation Delete Fixture Confirmation Edit Fixture Confirmation Staff Search Results togout o ooo ooy o o yO The staff only pages may be clicked on but no actual data will be displayed apart from a unauthorised access message Username format staff forename first letter staff surname first two letters e g J Walton jwa Password format default as password for all users but will be changed once the system is installed Error Messages Unauthorised Access Staff Only Fixture Entry Page Fixture Entry Page Staff Only You are not logged in Only staff may see this page Staff Only Fixture Edit Page Fixture Edit Page Staff Only You are not logged in Only staff may
155. nnect localhost root if Sdb echo Error Could not connect to database Please try again later exit mysql_select_db PE Squery select from fixtures where Ssearchyear like Yes ORDER BY date Sresult mysql_query Squery Snum_results mysql_num_rows Sresult echo lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Number of records found Snum_results lt font gt lt p gt for Si 0 Si lt Snum_results i Srow mysql_fetch_array Sresult echo lt p gt lt strong gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Si 1 echo htmlspecialchars stripslashes Srow event echo lt strong gt lt br gt Sport echo stripslashes Srow sport echo lt br gt Date echo stripslashes Srow date echo lt br gt Start Time echo stripslashes Srow time echo lt br gt Venue echo stripslashes Srow venue echo lt br gt Staff Member echo stripslashes Srow staff1 echo lt br gt Second Staff Member echo stripslashes Srow staff2 echo lt br gt Transport Booked echo stripslashes Srow transport echo lt br gt Lunch Required echo stripslashes Srow lunch echo lt br gt Group Size echo stripslashes Srow size echo lt br gt Date Added echo stripslashes Srow dateadded echo lt font gt lt p gt gt
156. ns serif color 4C4C4D gt You are logged in as SHTTP_SESSION_VARS valid_user lt font gt lt p gt echo lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Use the forms below to search for fixtures lt font gt lt p gt lt table style width 100 gt lt tr class h2 gt lt td style width 296px height 18px gt Search by Year Group lt td gt lt td style width 343px height 18px gt Search by Sport lt td gt lt td style height 18px gt Custom Search lt td gt lt tr gt lt tr gt lt td style width 296px gt lt form action staffsrcyear php method post name year gt lt table style width 94 gt lt tr gt lt td style width 130px gt lt span class body gt Select Year Group lt span gt lt td gt lt td gt lt select name fsearchyearonly class body gt lt option value y7 gt Year 7 lt option gt lt option value y8 gt Year 8 lt option gt lt option value y9 gt Year 9 lt option gt lt option value y10 gt Year 10 lt option gt lt option value y11 gt Year 11 lt option gt lt option value y12 gt Year 12 lt option gt lt option value y13 gt Year 13 lt option gt lt select gt lt td gt lt tr gt lt tr gt lt td style width 130px gt amp nbsp lt td gt lt td gt lt input class h2 name Submit2 type submit value submit gt lt td gt lt tr gt lt table gt lt form gt lt td gt lt td style width
157. nue Alnwick Staff Member A Dress COMBE ABBEY SCHOOLS 2 Schools Cup Regional Round Date 2011 11 12 Time Venue Leeds Staff Member A Lille PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Search Results You have searched for the sport Cross Country for y7 Number of records found 0 You have searched for the sport Athletics for y7 COMBE ABBEY SCHOOLS PE Department Fixtures Diary COMBE ABBEY SCHOOLS Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Search Results PE Department Fixtures Diary Number of records found 3 Home Page Fixture List Fixture Search Club Information PE Department Stat Login 1 County Tournament Fixture Search Results Time Venue Blue Flames LESSA Regional Trials Staff Member J Walton rine 2011 10 20 Venue Neptune Centre Middlesbrough 2 City Tournament Staff Member J Wheel Date 2011 11 30 Time 2 Tyne and Wear Gala Venue Westfield Cee 2011 11 05 Staff Member H Lille ays nee 3 Tyne and Wear Knockout anh tad hd Date 2012 01 17 3 Newcastle Schools Gala Time Bate 2012 02 15 Venue Blue Flames Time Staff Member J Walton Venue West Denton Pool Stalf Member J Wheel You have searched for the sport Netball for y11 You hava searched for tha apart Swimming fan y Student Search Results Pages PHP Coding lt p gt
158. olor 4C4C4D gt Srow staff1 lt font gt lt td gt echo lt td gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Srow venue lt font gt lt td gt echo lt tr gt echo lt table gt mysql_close Scon gt lt p gt amp nbsp lt p gt lt p gt lt span class h1 gt All Past PE Department fixtures lt span gt lt p gt lt php Scon mysql_connect localhost root if Scon die Could not connect mysql_error mysql_select_db PE Scon Sresult mysql_query SELECT FROM fixtures WHERE date lt Current_Date ORDER by date echo lt table width 100 border 1 cellspacing 2 cellpadding 2 gt lt tr gt lt th gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Sport lt font gt lt th gt lt th gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Event lt font gt lt th gt lt th gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Date lt font gt lt th gt lt th gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Time lt font gt lt th gt lt th gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Staff Member lt font gt lt th gt lt th gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Venue lt font gt lt th gt lt font gt lt tr gt 61 while Srow mysql_ fetch_array Sresult echo lt tr
159. on Page PE Department Home Page Fixture List Fixture Search Club Information Fixtures Diary Fixture Confirmation COMBE ABBEY SCHOOLS PE Department Staff Login Once the form has been submitted a connection is made with the database and the data is sent to the fixtures table using the file Insert1 php Each value from the form is echoed onto the confirmation page as well as being inserted into the associated field in Sport Athletics the fixtures table An identification Event Name Newcastle Schools Cup oe ee A Aaa number is automatically added as Time of Day Athletics 5 Vear Yes Year 10 Year 12 well as the current date and time If Year Groups Year 8 Yes Year 11 Year 13 Year9 Yes the transport and lunch options are Venue Gateshead Stadium Lead Staff Member J Hamilton Support Staff Transport Booked Lunch Required Group Size None No No 25 Add another fixture Fixture search page Log out not ticked i e yes two hidden fields insert the value No to the database as this is required for search purposes later on The screen below shows how the data previously seen in the data entry form has been displayed on the confirmation page Adding a Fixture Database Confirmation The screen below shows how the data previously seen in the data entry form and confirmation page has been inserted into the fixtures table as a new record record 25 earners Pee Mere eee
160. on gt lt option value date gt Date yyyy mm dd lt option gt lt option value transport gt Transport Booked Yes or No lt option gt lt option value lunch gt Lunch Booked Yes or No lt option gt lt select gt lt td gt lt td class body style width 105px gt Search Criteria lt td gt lt td style width 128px gt lt input name fsearchcriteria type text style width 151px gt lt td gt lt td class body style width 105px gt amp nbsp lt td gt lt td style width 128px gt lt input class h2 name Submit5 type submit value submit gt lt td gt lt td style height 23px width 296px gt amp nbsp lt td gt lt td style height 23px width 343px gt amp nbsp lt td gt lt td style height 23px gt amp nbsp lt td gt lt td style height 23px width 296px gt lt span class h2 gt Search by Staff lt span gt lt td gt lt td style height 23px width 343px gt lt span class h2 gt Search by Sport and Year lt td style height 23px gt amp nbsp lt td gt lt td style width 296px valign top gt lt form action staffsrcstaff php method post name staff gt lt table class body gt lt tr class body gt lt td style width 134px gt Select Staff Member lt td gt lt td style width 129px gt lt select class body name fsearchstaff style width lt option gt A Dress lt option gt lt option gt H Dune lt option gt lt option gt J Ham
161. ool can use are as follows with descriptions Pilot changeover 130 e This is where only a small proportion of the PE department will use the new system When they agree the system is working OK then a full changeover can take place This will not be a good method for the school to use as if half of the teachers are using the old system and the other half are using the new system then problems could arise with fixture bookings Parallel running e This is where both systems are used in conjunction until everybody is completely happy with the new system and then the old system will be removed This will cause problems for the school with double bookings and other issues There will also be issues with data duplication and it could occur that some staff forgets to use the new system as the old system is still available There could also be reluctance from the staff to use the new system when the old method is still available Synchronising the two systems may be an option if parallel running is to be used however it will be the case that this method will become too complicated Direct changeover e This method is where the old system is removed completely and replaced by the new system This is likely to be the method which the school should use to implement the new system All old references to the old system will be destroyed to ensure duplicate fixture bookings and confusion does not take place In this way the staff will liter
162. other pages Staff Login Page is accessible from all other pages Staff login page provides links to Create a new fixture Delete a fixture Search for a fixture Log in New Fixture provides links to Search for a fixture Log out Confirmation Page New fixture confirmation provides links to Create a new fixture Search for a fixture Log out Fixture search provides links to Create a new fixture Log out Results pages Fixture search results provides links to Search for a fixture Log out the fixtures list Username sjw Password Pa5Sword One fixture to be deleted from The user can select a fixture for deletion they will then have the fixture deletion confirmed and the fixture will be removed from the database Check the link of the template directs the user to the home page and is visible Check the link of the template directs the user to the fixture list page and is visible Check the link of the template directs the user to the fixture search page and is visible Check the link of the template directs the user to the club information page and is visible Check the link of the template directs the user to the PE department page and is visible Check the link of the template directs the user to the staff login page and is visible View the staff login page and check links are visible and that the code points to the correct location View the new fixture page and check links are visible and that
163. oup s J Hamilton Year 11 O Lead Staff Member H Lille J Walton PASS The staff name fields and J Wheel sport have drop down boxes meaning that users have to select one of the presented options and cannot enter their own values Time of Day Assistant Staff Member None Fixture search page Staff will be able to amend and delete fixtures 108 34 Cross Country Regional Finals 2011 10 27 2 Cross Country Schools Cup Round 1 2011 10 28 12 00 00 20 Swimming Tyne and Wear Gala 2011 11 05 16 00 00 J Whee e fixture has been deleted from database il l3 Cross Country Schools Cup Regional Round 2011 11 12 09 00 00 A Lill D 22 Netball City Tournament 2011 11 30 16 00 00 H ule YOU have deleted record number 34 23 Cross Country National Finals 2011 12 02 09 00 00 A Dres Fixture search 25 Athletics Newcastle Schools Cup 2012 02 06 10 00 00 21 Swimming Newcastle Schools Gala 2012 02 15 16 00 00 33 Athletics Schools Cup 2012 06 13 09 00 00 H Lile Delete another fixture 32 Swimming Tyne and Wear Gala 2012 11 06 16 00 00 31 Cross Country National Finals 2012 11 09 10 00 00 30 Swimming ESSA National Finals 2012 11 24 13 00 00 JHE oss coana 4 Netball Tyne and Wear Knockout 2012 01 17 16 00 00 lAthietics li Add a new fixture Delete Fixture Log out Fixture search e Sport Event Date Ti
164. pes EE Departmen tere table the old fixtures i e the Sport Event Date Time Staff Member Venue ones past today s date are Swimming Tyne and Wear Gala 2012 11 06 16 00 00 f Wheel IRGS i Cross Country National Finals 2012 11 09 10 00 00 Sheffield Athletics Stadium displayed r8 Visitors to the site will have some results hidden from their search 109 110 Fixture Search Results Number of records found 3 Epri kainaming Daim J0 LH Dimi Tame Yer hapten Cemre Mipjitik aag 1 ESSA Regional Trials Date 2011 10 20 Time Venue Neptune Centre Middlesbrough Staff Member J Wheel Dats Addad P0LJ 10 70 730133 ipot beter Date 2001 10 05 Ghart Time We ROS Rist Manip Wher Geom Sheet Mersey ima 2 Tyne and Wear Gala Date 2011 11 05 Time Venue RGS Staff Member J Wheel Dir dimi eter 10 38 iriki ES Rewinstie Mhars Osia 3 Newcastle Schools Gala Date 2012 02 15 Time Venue West Denton Pool Staff Member J Wheel Seow Gaiming Dait 20701 J me Viram Hemi Qeeion Fini Gis Hernier Wifee eco DLE Meier Wilio You have searched for the sport Swimming for y7 Staff will be able to carry out a wider range of searches Home Page Fixture Search Page Staff Only Fixture List Fixture Search Club Information Staff Login PE Department You are logged in as adr Use the forms below to search for fixtures Search by Year Group Select Year Group submit Search by
165. port Swimming Date 2012 02 15 Start Time Fixture Search Page Staff Only Venue West Denton Pool Staff Member J Wheel You are logged in as hdu Second Staff Member J Walton Transport Booked Yes Use the forms below to search for fixtures Lunch Required No Group Size 16 Search by Year Group Search by Sport Date Added 2012 10 20 17 03 25 Select Year Group Select Sport Athletics 9 Schools Cup submit submit Sport Athletics Date 2012 06 13 Start Time Venue Gateshead Stadium Search by Staff Search by Sport and Year Group Staff Member H Lille Select Staff Member A Dress Select Sport Athletics Second Staff Member None submit Search Criteria Year7 7 Transport Booked No submit Lunch Required Yes Group Size 30 Add a new fixture Date Added 2012 10 21 11 29 10 Home Page Fixture List Fixture Search Club Information PE Depz Log out You have searched for the year group y13 PASS The logged in user has selected the year group year 13 and 9 results have been displayed with the search criteria confirmed at the end of the search results i4 Allows a logged in user to select a staff member then displays the relevant results Fixture Search Page Staff Only a Sport Swimming Date 2011 11 05 H Start Time You are logged in as hdu voa ee Staff Member J Wheel Use the forms below to search for fixtures Second Staff Member None Transport Booked Yes Lunch Required No Group Size 20 Date Added 201
166. provides visitors with information about the clubs that are run during the autumn spring and summer terms It is useful for current students to check when the clubs are taking place but for any prospective students parents who access the site it can be used as a marketing tool to show what extra curricular activities are 57 lt tr gt lt tr gt lt tr gt lt table gt lt br gt Cross Country lt br gt Years 7 to 13 Hockey Goalkeeping Practice lt td gt lt td class auto style4 style width 313px gt Years 7 to 13 Fitness lt td gt lt td class auto style4 gt Years 7 to 13 Netball Matches amp amp Practice lt br gt Years 7 and 8 Hockey lt td gt lt td class auto style5 style width 89px gt Friday lt td gt lt td class auto style4 style width 306px gt amp nbsp lt td gt lt td class auto style4 style width 313px gt amp nbsp lt td gt lt td class auto style4 gt Years 7 to 13 Squash Coaching lt td gt lt p class h2 gt Summer Term Timetable lt br gt lt p gt lt table class auto style1 style width 100 gt lt tr class h2 gt lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt tr gt lt table gt lt td class auto style3 style width 89px gt amp nbsp lt td gt lt td class auto style2 style width 306px gt 11 55 to 12 25 lt td gt lt td class auto style2
167. ption gt lt option value y13 gt Year 13 lt option gt lt select gt lt td gt lt tr gt lt tr gt lt td class body style width 105px gt amp nbsp lt td gt lt td gt lt input class h2 name Submit1 type submit value submit gt lt td gt lt tr gt lt table gt lt form gt lt td gt lt td gt amp nbsp lt td gt lt tr gt lt table gt lt p gt else echo lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt You are not logged in lt font gt lt p gt echo lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Only staff may see this page lt font gt lt p gt echo lt a href newfixture php gt Add a new fixture lt a gt lt br gt lt br gt echo lt a href logout php gt Log out lt a gt lt br gt gt 78 Staff Search Results By Year Group staffsrcyear php PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information Fixture Search Results By Year Group Number of records found 7 1 ESSA Regional Trials Sport Swimming Date 2011 10 20 Start Time Venue Neptune Centre Middlesbrough Staff Member J Wheel Second Staff Member Transport Booked Yes Lunch Required Group Size 16 Date Added 2012 10 20 16 11 36 2 Schools Cup Round 1 Sport Cross Country Date 2011 10 28 Start Time Venue Alnwick Staff Member A Dress Second
168. ption gt Squash lt option gt lt option gt Swimming lt option gt lt option gt Tennis lt option gt lt select gt lt td gt lt tr gt lt tr gt lt td class body style width 105px gt Search Criteria lt td gt lt td class body gt lt select name fsearchyear gt lt option value y7 gt Year 7 lt option gt lt option value y8 gt Year 8 lt option gt lt option value y9 gt Year 9 lt option gt lt option value y10 gt Year 10 lt option gt lt option value y11 gt Year 11 lt option gt lt option value y12 gt Year 12 lt option gt lt option value y13 gt Year 13 lt option gt lt select gt lt td gt lt tr gt lt tr gt lt td class body style width 105px gt amp nbsp lt td gt lt td gt lt input class h2 name Submit1 type submit value submit gt lt td gt lt tr gt lt table gt lt form gt 58 Student Search Results Pages resultsstudent php These are a range of examples of the search results COMBE ABBEY SCHOOLS that are produced The page displays how many results have been returned via the search and mip cpm eager appropriate information is provided At the end of Home Page Fixture List Fixture Search Club Information PE Department Staff Login the search results there IS confirmation of the Fixture Search Results sport and year group that the user has searched for Number of records found 2 1 Schools Cup Round 1 Date 2011 10 28 Time Ve
169. r the calendar and timetable for clubs could be enlarged so that the data can be read The candidate however is still awarded the 1 mark a iii Analysis Requirements Specification Based on what have discussed with my client and the end users have reached the following requirements specification Requirement o O 1 Each member of the PE department will be able to login to the fixtures diary with their own username and password Unauthorised users will not be able to view staff only areas The PE department will be able to add new fixtures to the diary using an online form 4 A confirmation screen will be displayed once fixtures have been submitted which will summarise the data entered on the data entry form event name year group venue and time 6 Validation will be used to ensure that staff names and sports have been entered correctly on the form 8 _ There will be a screen which will display all fixtures that have been arranged O Z o 9 _ The site will follow the school s house style and all pages will include the school name and logo fixtures by a selected year group and sport 11 For visitors to the site some fixture information will be hidden from search results e g transport arrangements and more specific fixture information clubs that are run in school and the department Staff will be able to carry out more complex searches than students parents i e search by sport search by year group sear
170. r the coming week or month which would be really useful For students it would be useful if they could do a search for their sport or age group If possible there could be a separate fixtures list for each year group For staff there could be a list of fixtures that apply only to them but I am not sure how possible that would be Follow up Would you like information to be sorted by any particular field By date would be the main sort of information we would need Where would you like to use the new diary system In our PE office is a must but also on the other computers around the school as we often have to use machines in the workroom staffroom and teaching rooms It would be great if we could also access the diary from home and for it to be on the Internet Follow up Would you like to use it off school premises for example at fixture meetings or at home At home definitely as everyone in the department has a computer at home and Internet access Fixture meetings would be very useful but we would have to either take a laptop with us or maybe another device connected to the Internet Do you have regular access to a networked computer or laptop Yes Follow up How about tablet computers such as an iPad have an iPad but it is my own The school have talked about using tablet computers for registration purposes so it may be possible that the rest of the department are given one at some point in the future Follow up Does the
171. r year It has a full week spread over two pages so you can easily see events for the upcoming week Each day has 10 lines so there is plenty of space to add information to each day How are new fixtures arranged At the start of term we normally have a range of meetings to arrange fixtures These are for the Newcastle area Tyne and Wear and Northumberland There are also some national events which we sometimes take part in but we usually have to qualify for them first There PE staff will try to arrange fixtures for the main sports i e hockey and netball for the first two terms and then tennis and athletics for the summer term We also try and arrange swimming galas and other fixtures at these meetings too We try to find dates where both schools are free from previous fixture commitments and we add dates to the diary The meetings can be quite hectic and it is important to add the dates to the diary straight away so that they are not forgotten about If we do well in a tournament this often means that we progress to the next round and these fixtures are added when we know we have qualified Follow up Is the diary ever taken to these fixture meetings Yes at the start of the autumn and summer terms Normally these meetings are held on different evenings to avoid any clashes with the planning of new fixtures How do you add new fixtures They are written in using pen or pencil We also try to highlight the fixture with a colour which he
172. rd Fixture Delete Form process 2 For the demonstration of this process record 6 will be deleted The page below shows the logged in staff member the list of fixtures within the database and associated ID numbers They can then enter the required fixture in the text box at the bottom of the form COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Deletion Page Staff Only You are logged in as adr Fixture Deletion Find the fixture ID and use the form below to delete selected fixtures National Schools Tournament 5 Hockey ___ Friendly 8 Netball County Tournament 2011 10 18 chools Cup Regional Round 2011 11 12 09 00 00 fA Lie fess ty Tournament 2011 11 30 ational Finals 2011 12 02 09 00 00 A Dress Crystal Palace yne and Wear Knockout 2012 01 17 ewcastle Schools Cup 2012 02 06 Newcastle Schools Gaia 2012 02 15 16 00 00 p wheel West Denton o T S32 l un Cross Country Cross Country ross Country etball O ross Country etball thletics 5 lational Finals 2012 10 10 Enter ID Number Ty 2 B 22 23 6 _Delete Fixture Fixture search page Add new fixture Log out Enter ID Number G Delete Fixture Fixture search p Add new fixture Log out 100 Once the ID number has been entered the Delete Fixture button is pressed which initiates a connection to
173. re displayed in date order User clicks the edit button by the selected fixture User is taken to a edit form The selected fixture is displayed on the form The user edits the required fields Cancel button cancels all changes made Submit button confirms changes The selected record is updated in the table Searching for Fixtures Is the user logged in No access denied amp appropriate message displayed Yes access granted amp search form is displayed The user selects from the 5 searches available With their chosen search they enter their criteria Clicking the submit button takes them to the corresponding search results page Connection to the database fixtures table is made All fixtures are displayed in date order Confirmation of the search criteria is provided 31 Student Fixture List Connection to the database fixtures table is made All fixtures are displayed in date order Confirmation of the search criteria is provided Adding a New Fixture Is the user logged in No access denied amp appropriate message displayed Yes access granted amp data entry form is displayed User enters fixture information into the form Drop down boxes and text boxes are used User can reset the form data using the reset button User submits the form data using the submit button A connection to the database is made fixtures table The record is inserted and assigned an ID number The date and time of entry is also assigned The record insertion
174. rt Athletics Fixture search e Log out Student fixture search result showing the newly inserted record PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information Fixture Search Results Number of records found 1 1 Newcastle Schools Cup Date 2012 02 06 Time Venue Gateshead Stadium Staff Member J Hamilton You have searched for the sport Athletics for y7 98 COMBE ABBEY SCHOOLS PE Department Staff Login Student fixture list showing the newly inserted record COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login All PE Department fixtures The Parks etball 2011 10 18 11 00 00 Blue Flames wimming ESSA Regional Trials 2011 10 20 17 00 00 J Wheel Neptune Centre Middlesbrough thletics Newcastle Schools Cup 2012 02 06 10 00 00 J Hamilton Gateshead Stadium wimming Newcastle Schools Gala 012 02 15 16 00 00 J Wheel West Denton Pool c i b Software Development and Testing evidence of the development of one aspect of the system that processes data 2 The candidate has shown how the data entry system works and has provided a range of screenshots and annotation to explain the process that occurs This would be sufficient to be awarded the 2 marks The candidate has also demonstrated a second process below but this is not a requirement of the marking point 99 Deleting a Reco
175. rt Staff e g Walton igen Venue Criteria hia Date yyyy mm dd Transport Booked Yes or No Lunch Booked Yes or No PASS The 6 required search types are displayed on the staff search page under the custom search Fixture Entry Time of Day fou are logged in as adr Sport Athletics Date yyyy mm dd Time of Day Morning 7 Afternoon Evening Weekend c Assistant Staff Member None FN PASS The 4 required time of day options are displayed on the fixture entry page under the time of day field Venue Lead Staff Member Fixture Entry Support Staff You are logged in as adr Sport Athletics Date yyyy mm dd Time of Day Morning q Venue Lead Staff Member ADress 4 x None J A Dress H Dune Hamilton H Lille Walton Wheel Assistant Staf Member Year Group s Fixture search page Search by Sport and Year Group Select Sport Athletics J Search Criteria Year Year amp Year 9 Year 10 Year 11 Year 12 Year 13 PASS The 7 required year groups are displayed on the staff search page under the year group search Staff Search Staff Name Search by Staff Select Staff Mermbe A Dress 2 H Dune Hamilton H Lille Walton Add a new fixtul Whee i mm mrk PASS The 6 required staff members are displayed on the staff search page under the staff search section Fixture Entry Lead Staff Sport Athletics Date yyyy mmdd Time o
176. s body gt lt php echo S_POST fsearchsport gt lt span gt lt span class h2 gt for lt span gt lt span class body gt lt php echo S_POST fsearchyear gt lt span gt lt p gt Full Fixture List Student and Parent View allevents php This page provides visitors with a tabular view of all fixtures that are in the diary It first shows all fixtures that are on today s date or in the future and then also shows fixtures that have occurred in the past COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login All Upcoming PE Department fixtures cross Country National Finals 2012 11 09 10 00 00 ____Sheffieid Athletics Stadium Swimming ESSA National Finals 2012 13 24 13 00 00 coventry All Past PE Department fixtures Swimming Tyne and Wear Gaia 2041 11 05 16 00 00 Wheel es INetoail city Tournament 2011 11 30 16 00 00 H Lille Jwestfie Athletics Newcastle Schools Cup 2012 02 06 10 00 00 3 Hamilton 012 02 15 60 Full Fixture List Student and Parent View PHP Coding lt p gt amp nbsp lt p gt lt p gt lt span class h1 gt All Upcoming PE Department fixtures lt span gt lt p gt lt php Scon mysql_connect localhost root if Scon die Could not connect mysql_error mysql_select_db PE con Sresult mysql_query SELECT FROM fixtures WHERE
177. sics about website development Feasibility and meeting requirements The website would be able to display all of the required information i e fixtures and department information on a range of pages but it would be visible to everyone Only one person would probably be in charge of the website due to the skills required to use the software but more could access the software to update it if needed This would probably have to be done on a single computer such as the PE office computer as the website files would be stored there There would be limited search facilities available on the website and data validation would be difficult to carry out when inputting data as 23 users would just be typing data onto the web pages All information would be visible to both staff and students and it would be time consuming to carry out maintenance on the website to ensure that only relevant fixtures were displayed for example removing past fixtures inserting new fixtures and amending current fixtures There would be no option for users to login to the site and it would be difficult to update it from another computer such as at home Fixtures could not be updated whilst at meetings so they would have to be written down and then inputted at a later date Cost The school s server could host the website at the moment as they have the required equipment and it would be free to do so There are already two types of website authoring software available on th
178. sis and how secure it is stored Follow Up weekends 10 Are details of fixtures stored anywhere This will help me to get an understanding of else where fixture information may be duplicated and the other format for the information to be displayed 10 How is the information entered A simple question to help me understand how Follow Up data is entered into the diary at the moment 6 10 Who has access to this information To understand who else needs to have access to Follow Up fixture information How often do you add fixtures to the This will help me to understand how often the diary fixtures list needs to be updated When is the busiest time for arranging This will help me determine when the diary is fixtures used the most and when it needs to be fully up and running How do you prevent making double This will help me to understand what process bookings for a teacher or a year group the department has in place at the moment to ensure they do not make double bookings Can non PE department staff check the This question will identify whether other diary when they want to organise an event members of staff need access to the diary e g drama production system at the moment Do you use any colour coding in the diary Asking this question will help me understand at the moment how information is organised within the diary system and whether staff need quick access to information by easy identification using colours Does t
179. style width 313px gt 12 25 to 13 00 lt td gt lt td class auto style2 gt 15 45 to 17 00 lt td gt lt td class auto style5 style width 89px gt Monday lt td gt lt td class auto style4 style width 306px gt Year 8 Trampolining lt br gt Years 7 to 13 High Jump lt td gt lt td class auto style4 style width 313px gt amp nbsp lt td gt lt td class auto style4 gt Years 7 and 8 Tennis Club lt td gt lt td class auto style5 style width 89px gt Tuesday lt td gt lt td class auto style4 style width 306px gt amp nbsp lt td gt lt td class auto style4 style width 313px gt amp nbsp lt td gt lt td class auto style4 gt Years 7 and 8 Rounders League lt br gt Years 9 and 10 Rounders League lt td gt lt td class auto style5 style width 89px gt Wednesday lt td gt lt td class auto style4 style width 306px gt Year 9 Trampolining lt td gt lt td class auto style4 style width 313px gt Years 7 to 13 Long Jump lt td gt lt td class auto style4 gt amp nbsp lt td gt lt td class auto style5 style width 89px gt Thursday lt td gt lt td class auto style4 style width 306px gt Years 7 to 11 Tennis Team Coaching lt td gt lt td class auto style4 style width 313px gt amp nbsp lt td gt lt td class auto style4 gt Years 9 and 10 Tennis Club lt br gt Years 7 to 13 Running Club lt td gt lt td class auto style5 style width 89px
180. t Fixture Deletion Page Again this page provides users with a list of fixtures to choose from so they don t have to remember the ID numbers from a previous page There are also instructions to the user explaining what they need to do to delete a fixture Upon deletion a confirmation screen is displayed to the user Fixture Deletion Page Staff Only You are logged in as jwh Fixture Deletion Find the fixture ID and use the form below to delete selected fixtures i PJ gt J Walton ESSA Regional Trials 2011 10 20 17 00 00 J Wheel Neptune Centre Middlesbrough Schools Cup Round 1 2011 10 28 12 00 00 A Dress Tyne and Wear Gala 011 11 05 Cross Country Schools Cup Regional Round nwick GI Ty 011 11 12 09 00 00 11 11 30 16 00 00 H Lile __ 11 12 02 012 01 17 16 00 00 J Walton lue Flames ewcastle Schools Cup 012 02 06 10 00 00 J Hamilton Gateshead Stadium Newcastle Schools Gala 012 02 15 Wheel West Denton Pool 33 Athletics Schools Cup 2012 06 13 Lille ateshead Stadium 2 Swimming Tyne and wear Gaa 2012 11 06 16 00 00 f wnes Ras 31 Cross Country National Finas 2012 11 09 10 00 00 Sheffield Athletics Stadium 30 Swimming JESSA National Finals 2012 11 24 13 00 00 Coventry Enter ID Number PJ m eeds estfield Crystal Palace Netball City Tournament ational Finals Netball ne and Wear Knockout PJ ji i a Fs Delete Fixture Fixture search page 1
181. t lt a href fixturesrcstaff php gt Fixture search page lt a gt lt br gt lt br gt lt a href logout php gt Log out lt a gt lt br gt lt td gt lt tr gt lt table gt lt span gt lt p gt 70 Delete Fixture Page Not Logged In deleteform php If anyone tries to access the fixture deletion page when not logged in they COMBE ABBEY SCHOOLS are denied access a message is displayed to inform them that they PE Department Fixtures Diary must be logged in Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Deletion Page Staff Only You are not logged in Only staff may see this page Fixture search page Add new fixture Log out Delete Fixture Page Logged In Once a user has logged in they are then displayed with a list of all fixtures in date order They can see the fixture id number and this is what they need to enter into the text box to delete a particular fixture COMBE ABBEY SCHOOLS PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information PE Department Staff Login Fixture Deletion Page Staff Only You are logged in as adr Fixture Deletion Find the fixture ID and use the form below to delete selected fixtures National Schools Tournament The Parks ockey estgate letball ounty Tournament 011 10 18 ue Flames ESSA Regional Trials 011 10 20 eptune Centre Middlesbrough ross Country nwick yne and Wear Gala
182. t a gt lt br gt gt 82 Staff Search Results By Staff Member staffsrcstaff php Home Page Fixture List Fixture Search Club Information PE Department Staff in Staff Search Results Number of records found 3 1 ESSA Regional Trials Sport Swimming Date 2011 10 20 Start Time Venue Neptune Centre Middlesbrough Staff Member J Wheel Second Staff Member Transport Booked Yes Lunch Required Group Size 16 Date Added 2012 10 20 16 11 36 2 Tyne and Wear Gala Sport Swimming Date 2011 11 05 Start Time Venue RGS Staff Member Wheel Second Staff Member None Transport Booked Yes Lunch Required Group Size 20 Date Added 2012 10 20 15 49 44 3 Newcastle Schools Gala Sport Swimming Date 2012 02 15 Start Time Venue West Denton Pool Staff Member J Wheel Second Staff Member J Walton Transport Booked Yes Lunch Required Group Size 16 Date Added 2012 10 20 15 55 52 You have searched for the staff member Wheel Fixture search page Log out 83 PE Department Fixtures Diary Home Page Fixture List Fixture Search Club Information Staff Search Results Number of records found 0 You have searched for the staff member H Dune Fixture search page Log out COMBE ABBEY SCHOOLS PE Department Staff Login Staff Search Results By Staff PHP Coding lt p gt lt span class h1 gt Staff Search Results lt span gt lt p gt lt p gt lt span class bod
183. t should be hidden if anything Would you like the option to search for fixture need to find out whether Miss Walton information e g by staff member or sport would like to search the diary system This question will help to identify which fields would be used to search for fixture details Would you like there to be any validation This will help me to determine what data methods present to avoid data entry errors is most important to the department and being made which fields have to be checked for correct entry How would you like fixture information to be The department may decide that they do displayed to staff and pupils not want all information visible to both 14 staff and pupil so this is to find out what information they want displaying to both 9 Would you like information to be sorted by any Follow Up particular field 10 Where would you like to use the new diary system 10 Would you like to use it off school premises for Follow Up example at fixture meetings or at home 11 Do you have regular access to a networked computer or laptop 11 How about tablet computers such as an iPad Follow Up 11 Does the school have a Wi Fi network which you Follow Up could use Would you like the option to print out fixture information 13 Would you like to provide general departmental information to students using an online system How much IT experience does your department have at present in particular wi
184. t the school s colour scheme Did you experience any error messages Y u4 es Were you able to successfully log into the system Did you find the home page informative u14 When logged out did you feel confident that the staff only areas were suitably Yes restricted Did you find the user guide easy to use and useful Did the pages feel consistent when you clicked between them Did you think the student search pages provided sufficient information about fixtures Man c i d Software Development and Testing evidence that each of the tests specified in the test plan have been carried out that they are linked to the hard copy evidence that the results have been analysed and that any necessary action has been identified 2 The candidate has carried out all tests and input output values have been clearly identified They have discussed whether the test has passed or failed and why this is so Although the candidate did not test the editing of the system they have explained that the test was partially passed and an explanation was provided to explain the shortfall It is easy to cross reference tests back to the original test plan and user testing has also been carried out The full 2 marks have been awarded 126 c ii Installation Letter to client 20 Rose Cottage Jesmond Newcastle upon Tyne NE2 9JD Miss J Walton Head of Girls PE Combe Abbey School Archibold Terrace Newcastle upon Tyne NE10
185. taff can see which fixtures are more relevant to them Another feature which would be very useful to the department would be to have an archive feature Whether this was something automatically done when search results were displayed e g not showing fixtures that are over 12 months old or whether it was done by the staff through the use of a form where users could select the fixture they wanted to archive It could then be stored in a new table and possibly displayed in a list on another page just so that the fixture was still accessible This would mean that the fixture list and search results did not become too cluttered with past fixtures It would be useful to the department to be able to view fixtures in a similar format to their paper based diary This would be a list of fixtures displayed on a weekly monthly termly and yearly basis Again a table format would be ideal for this and the search criteria would need to be dynamic and not fixed i e searching for fixtures that occur 7 days after today rather than 10 10 11 plus 7 days A different page could be developed for each search type and this could be incorporated into the staff only area with multiple fields displayed and also the student area but with fewer fields For staff it would be very useful to be able to change their passwords via the system This could be achieved via a change password link on the login form for example and instead of having to see the technician they could
186. te area cannot be accessed from outside of school The actual database that would be used for the site would be accessible via the webpages you are thinking of creating for example if you want to add edit or delete data Once it s all set up and running we will be happy to do basic updates to the database directly on the server if needed 3 Does the school have Wi Fi access that could be used by the PE department For example when they are away from a fixed computer and want to use a portable device such as an iPad We do have Wi Fi but we do not allow non school devices to access it due to security reasons Our school laptops do have Wi Fi connectivity but we would not be able to allow access to an iPad sorry We are looking into providing tablet computers to staff which would be Wi Fi enabled but cannot say when this will be and whether it is definite at this stage Document Analysis have visited the school website to try and get an idea of how the fixtures information is displayed at the moment also contacted the school Marketing Manager Mrs Chew who was also able to give me the specific fonts and colours used on the website so that could recreate the house style and keep the layout consistent with other school publications School Website House Style Netball Heading Titles Verdana 16px FFFFFF Bold N Nursery Events J Juniors Events B Boys Events G Girls Events 6TH Sixth Form Events Heading
187. ted there as have previously mentioned Do you use any colour coding in the diary at the moment Yes but only for the department members Other members of staff have no colour coding as they tend not to use the diary as much and have minimal fixtures have my fixtures highlighted in pink Helena has her fixtures highlighted in yellow Helen has hers highlighted in green and Jill has hers highlighted in orange The colour coding can be quite difficult when the pen runs out and there are no more left in the stationery cupboard Does the school have a website and house style that they use for publications Yes the school has a website and all promotional materials use this theme Items such as brochures student reports and advertising materials follow the house style am not sure of the exact fonts but can find them out for you from our marketing manager if you d like a ii c Investigation record of key responses of interview demonstrating two way discussion 1 All questions and follow up questions have been asked and the candidate is awarded the 1 mark 11 Analysis of Current System The Girls PE department at Combe Abbey School runs over 24 sports teams over the academic year and each team takes part in a range of fixtures which take place all over the city regionally and also nationally All of these fixtures are written down in a single paper based diary and some are duplicated onto the school website a card version
188. teria meaning that the results are relevant to the viewer The database would only need to be directly accessed for maintenance purposes for example adding new fields or user accounts Feasibility and meeting requirements Because all of the fixture editing is done via an online form this could be carried out anywhere where there is an active Internet connection This could be even done via a mobile phone or other portable device Validation would be possible via the data entry form and features such as drop down boxes could be added to ensure that only acceptable data is entered The entered information could also be confirmed via a separate page for members of staff to view exactly what has been entered It would be easy to create a range of pages which query the database in different ways to display selected information such as fixtures for different age groups and for different sports A search box could be added to a page which could enable viewers to type in their criteria and search under a chosen field This would then display the information that is relevant to their search and again the results could be different for staff and pupils To create information pages this could be done using website authoring software Because the information would not be updated that often this is something that maybe the technicians could assist the department with or one of the PE department could be trained to use Cost As discussed with Mr Blackburn th
189. ters below Desktop Computers Lenovo Thinkcentre Laptop Computers Toshiba Pentium D Class Processor with some Pentium 2 Intel Centrino Processor Core Duo Processor 129 1Gb Random Access Memory with some computers 512Mb Random Access Memory 2GB RAM 80GB Hard Drive 80Gb Hard Drive 21 Inch Lenovo Flat Screen TFT Monitor 15 Inch Monitor USB Keyboard Inbuilt keyboard USB Mouse Inbuilt mouse USB Mouse S There is a central server room at the school which has file print internet email and website servers to host the network facilities It is essentially where the phpMyAdmin database software will be located and the system will be accessible from all areas of the school and from home via the school s external network connection The server has more than enough storage space for the small database files and webpages and will cope with the system easily Also the server holds all of the applications for each individual computer such as Microsoft Expression Web 4 The server is more than capable of running the software needed File Creation shall install the database with the help of the network technician onto phpMyAdmin on the school network shall then import the necessary database settings and files by exporting them from the database had set up and then importing them into the new network database Before doing this will need to add the fixtures for the upcoming month by typing them in myself either via the fi
190. th Miss Walton she suggested speak to Mr Blackburn who is the lead technician of the school s IT department He would be able to give me more information about the school network 1 Does the school have IT servers that could be This will help me to find out whether the used to host a website online diary can be hosted in school on their own servers or whether it will have to be hosted by an external company 1 If yes would it be possible for the PE department This is to find out how feasible it would be Follow Up to use some of the server space for their own to use the servers to host the diary system website 1 Could the website be accessed from outside of This is to see whether the school s website Follow Up school hosting if available would provide the required online access from a range of locations 2 Are the servers configured for database I am thinking of using a backend database connectivity For example the use of PHP and for the diary system so this is to see MySQL whether my idea is feasible using the school servers 2 Can the database be accessed from outside of This will help me find out whether the Follow Up school database functionality will work outside of school and what aspect of the database could be accessed 3 Does the school have WiFi access that could be This is to determine whether staff could used by the PE department For example when access the diary system when away from they are away from a
191. th using websites and online forms 14 Would the department need training and would Follow Up you like someone to come in to deliver it Would a user guide be of use to you 15 If so would you prefer a printed or electronic Follow Up copy 16 Would you like the diary system to follow the house style of the school 16 If yes should use the school website as a guide Follow Up This question will help me find out how to sort the data e g by date staff member or sport This will tell me how the department wants to use the diary system and whether it needs to be portable or not Again this will give me a better idea of where the department would like to use the diary system This question will help me to identify how easy it will be for members of the department to access a computer and therefore the online system If computers are not always accessible the use of a tablet computer may also allow staff to use the diary system This is to identify whether it would be possible for staff to use the system on the move whilst around school This question will help me to determine whether the department want any of the fixture information printed out or ina printable format This will help me to find out whether they want additional information to be displayed as well as fixture information This question helps me to understand the department s background with the use of computers and in particular websites and forms whic
192. the department has about the diary system in use and potential issues that they may be faced with Has the diary ever been lost or misplaced This question will give me an idea of how vulnerable the current diary system is at the moment What impact did this have on the To try and understand how important the diary department system is to the department and how their day to day operation is affected if the diary is not available How big is the diary and who is in charge of This question will help to give me an idea of how much data is actually stored in the diary and the Follow Up person who is responsible for its safekeeping Do you view dates by day week month or Follow Up year fixtures that they have planned new fixtures with other schools Follow Up the school environment to a different location 7 To understand the process of entering a fixture into the diary and who is responsible for this 7 What information do you add to a fixture To find out what data is entered into the diary Follow Up entry in the diary and what information is necessary for the diary to be useful 7 What happens if a fixture is changed or To find out how the department deals with Follow Up cancelled amendments to the diary and how easy this is to do at the moment SS How many teams do you actually have To give me an idea of the scale of fixtures that running in the school may be planned on a yearly basis eE7 commence ba
193. ting however it may not be possible with all systems and the candidate has attempted to carry out at least 1 invalid test Each test has been clearly described with sensible input data identified Each test is also numbered using an easy to use reference system The candidate has been awarded the full 4 marks 49 Zoomin Zoom Out Show critical path Baselines Project start Previous Next k45 Week46 Week47 Week48 Week 49 Week50 Week51 Week52 Weekl Name Begin date End date 11 13 11 11 20 11 11 27 11 12 4 11 12 11 11 12 18 11 12 25 11 1 1 12 2 3 6 Create CSS File 11 10 11 11 10 11 9 Create Site Template 11 11 11 11 12 11 Create Pages and Update Links 11 11 11 11 13 11 Test Page Layout and Links 11 11 11 11 13 11 Develop Basic Pages 11 14 11 11 16 11 Create Database and Tables 11 17 11 11 18 11 Create Login and Logout Pages 11 19 11 11 22 11 Testing of Login and Logout Pages 11 23 11 11 25 11 Develop Data Entry Form and Confirmation Page 11 26 11 11 29 11 9 Testing of Data Entry and Confirmation 11 30 11 12 2 11 Develop Staff Search Page and Results 11 26 11 12 6 11 Test Search and Results Pages 12 7 11 12 12 11 Develop Fixture Delete Form amp Confirmation 12 13 11 12 16 11 9 Test Fixture Delete Form amp Confirmation 12 17 11 1 7 12 Develop Edit Fixture Form and Pages 1 8 12 1 14 12 Test Edit Pages 1 15 12 1
194. tion PE Department Staff Login Number of records found 2 1 Schools Cup Regional Round Sport Cross Country Date 2011 11 12 Start Time Venue Leeds Staff Member A Lille Second Staff Member J Walton Transport Booked Lunch Required Group Size 25 Date Added 2012 10 20 16 13 43 2 Newcastle Schools Gala Sport Swimming Date 2012 02 15 Start Time Venue West Denton Pool Staff Member J Wheel Second Staff Member J Walton Transport Booked Yes Lunch Required Group Size 16 Date Added 2012 10 20 15 55 52 You have searched for staff with the criteria Walton Fixture search page Log out 90 Staff Search Results Custom Search PHP Coding lt p gt lt span class body gt lt php create short variable names Ssearchtype SHTTP_POST_VARS fsearchtype Ssearchterm SHTTP_POST_VARS fsearchcriteria Ssearchterm trim Ssearchterm if Ssearchtype Ssearchterm echo You have not entered search details Please go back and try again echo lt br gt lt br gt lt a href fixturesrcstaff php gt Fixture search page lt a gt lt br gt lt br gt echo lt a href logout php gt Log out lt a gt lt br gt exit Ssearchtype addslashes Ssearchtype Ssearchterm addslashes Ssearchterm Sdb mysql_pconnect localhost root if Sdb echo Error Could not connect to database Please try again later exit mysql_select_db PE
195. u feel about using a computer based diary am quite comfortable with using a computer but I am not great when it comes to technical things so as long as it is easy and straight forward to use then I would be fine Follow up Would you be interested in using an online diary Yes 3 Who would you want to add new fixtures to the diary Do you want to do this yourself or are you happy for the rest of your department to assist I would want the whole department to be able to add fixtures as it would be too much for me to do on my own 4 How would you like to add new fixtures to the diary system If we could have something like a form that could be filled in that would be good Having something nice and clear which we could type information into would be best 5 Would you want everyone to be able to see the same fixture information I would want my department to see the same information as did as with the diary at the moment nothing is hidden There is a possibility we could maybe have students and parents viewing the diary but wouldn t want them to see everything don t think Follow up If no would you like there to be different information for staff and pupils Pupils should only be able to see information such as fixture date venue time and staff member maybe Just the necessary information so that they know what is happening and can plan other activities around our fixtures 6 What fixture information would you lik
196. ub 1 5 B G JCD yaar10 13 WeightTraining Weights Room LF 12 05 12 55 Years 11 Art Club B G Gillie Fitness Girls all Years Gym HD Junior Dept netball G SPORTS HALL KC Swing band B G Music Room Year 7 13 Eco Panel Meeting Room JS Debating Society Year 12 13 B G MVL Year 7 9 Print Workshop B G Girls Art Room KH ZA Yr 10 13 Dance Exam Preparation SEPTEMBER 301 iha t fs ia FRIDAY Dance priority evening ee A a b if ri F E gt mE TE a et x Ja MPL TELE LGE uo TEMARE H11 oe A z FF Ts r per Gel i 1 T j EF E if T hi whee KRH Jii gez g Re fi TE a ii e Investigation Information collected about the requirements of the new system 2 9 10 hockey G Westgate Astra SR Netball home matches G JD AL HW Climbing Club Y7 13 MVL Senior rugby B AC Year 8 Rugby B JAB Year 11 13 B G R191 Sign Language Intro BIW Y10 hockey league matches G offsite SR Year 7 rugby B Coach Senior Music choir B G Music Room SD amp MD Volleyball Years 12 13 B G GS Senior football practice B coach Duke of Edinburgh Training Room 176JPG SWh RGO Year 10 13 dance exam prep Dance StudioLC Year 10 13 B G R 191 British Sign Language 1 BIW Year 11 hockey HD Westgate Y10 13 Basketbal Football fixtures B 3 45 4 45AH cooch Year 9 Rugby B WPH Yr 7 9 Drama Rehearsal B G Hall Drama Room AW Senior Strings B G Music Room Mrs Allen Netball m
197. uirements for the new system providing clear justification for each choice in relation to the problem to be solved 3 The candidate has attempted to list all of the required hardware and software and have started their list by obtaining the minimum system requirements for their chosen software Although all components have been listed the server specification and desktop computer specification could be more precise with actual requirements rather than minimum requirements being stated They have however tried to relate each piece of hardware and software to the system requirements and have explained why they are needed The candidate is awarded 2 marks 26 b i Nature of the Solution Database Table Design Fixtures Table to hold the fixtures which will be entered via the data entry form online Field Name Data Type Length Validation Sample Values EventID Primary Key Int Not Null 001 Auto Increment Sport The sport concerned Char 15 Swimming Not Null Form Drop down box Not Null taking place involved Not Null S famme eee taking place Staff1 The lead member of Char staff a Null Form Drop down box staff Form Drop down box TimeODay When the fixture is to Morning be taking place Afternoon Evening starts i added to the diary Login Table To hold staff member login details so that they can access the private area of the system Field Name DataType Length Validation Sample Values Userl
198. vents has been produced and this section can therefore only be awarded 1 mark 144
199. works and all of the possibilities it offers A demonstration would be beneficial Would a user guide be of use to you Definitely Follow up If so would you prefer a printed or electronic copy A printed copy would be useful to have in the office but also an electronic copy that could be available online or even just to save on our USB drives would be handy too Would you like the diary system to follow the house style of the school I think if the system is to be viewed by pupils and parents it would need to follow the school s theme for websites and publications Just so that it is easily recognisable Follow up If yes should I use the school website as a guide That s a good starting point You could also try getting in touch with Miss Chew who is in charge of the website and marketing You can find her on the school email directory Do you know anything about the school network and how they host their website know nothing at all sorry do know that the school has something called Moodle and we can access that from home and in school I ve heard people talking about the Moodle servers whenever there is a problem so maybe it s done here You d have to check with the school technical team sorry Follow up If not could you recommend a technician who I could speak to Mr Blackburn is the lead technician who will be best to speak to Interview New System Requirements Technical Aspects Following my interview wi
200. xture diary In addition was asked by the client to be available in the Resource Centre over a few lunchtimes in case members of the department wanted to get some additional assistance in using the system will do this in the weeks after the system is installed Along with the user documentation both Miss Walton and feel that this will be enough to help staff get used to the system and use it effectively Training and Installation Plan 14 May Meet with the network technician Mr Blackburn to obtain the new server settings so 12pm that the database connections in the webpages can be updated 16 May Meet with Miss Walton and the network technician Mr Blackburn in the ICT 12pm technicians office to transfer the database and webpages to the school server 18 May 20 May Enter the first 50 fixtures into the fixtures diary ready for the training session on the 12pm to 12 50pm 21 May 21 May Group demonstration of the system to staff 12pm to 12 40pm Venue ICT Resource Centre which has a projector and whiteboard The room also has computers which can be used by the staff to try out the new system This will be led by me and assisted by Miss Walton A question and answer session will take place at the end 1pm onwards Input the remaining fixtures into the diary system ready for full staff use 22 May 25 May A series of lunchtime drop in sessions will take place in this period 4 in total will 12pm to 12 30pm be pres
201. xture entry form or directly into the database will contain the list of these fixtures from Miss Walton There should be about 50 fixtures that need to be inserted initially and this should take approximately 2 hours to complete After the training session the rest of the fixtures will need to be added to the diary There are approximately 100 fixtures remaining after the first 50 so this should take approximately 5 hours to do and this will be done after the training session on the 21 May c ii b Installation details of the means by which the new files are going to be created including some indication of the scale of the problem and also the possible need for hardware installation and the installation of the software on the hardware 2 The candidate has not only discussed the hardware and software required but they have also considered the files that will need to be transferred before the system can be fully used They talk about the time considerations for transferring data as well as the method used to enter the data and volume of data This section is awarded 2 marks Methods of Changeover Changeover Methods The installation of my system within the school can happen in one of a number of ways These different ways have their own advantages and disadvantages and some may be more beneficial to the smooth running of such a task than other methods of implementation The four different methods of implementation which the sch
202. xture search fixture search staff and fixture entry form Sport Cross Country Athletics Hockey Netball Tennis Squash amp Swimming Year Year 7 Year 8 Year 9 Year 10 Year 11 Year 12 amp Year 13 Staff J Walton A Dress H Dune J Hamilton H Lille amp J Wheel Time of Day Morning Afternoon Evening amp Weekend Custom Search Event Venue Date Support Staff Lunch amp Transport 45 The template will have the house style of the school and each page will then be created using this template Again the template will have the logo of the school and each page will then be created using this template Each drop down box on the three pages will contain the required options Input Test Plan Testing of the login form and new fixture form has already been done through the requirement specification testing Expected Result Allows the any user to select a sport and year group then displays the relevant results Allows a logged in user to select a sport then displays the relevant results Allows a logged in user to select a year group then displays the relevant results Allows a logged in user to select a staff member then displays the relevant results Allows a logged in user to select a sport and year group then displays the relevant results Allows a logged in user to type in an event then displays the relevant results Allows a logged in user to type in a support staff nam
203. y gt lt php create short variable names Ssearchstaff SHTTP_POST_VARS fsearchstaff Ssearchstaff addslashes Ssearchstaff Sdb mysql_ pconnect localhost root if Sdb echo Error Could not connect to database Please try again later exit mysql_select_db PE Squery select from fixtures where staff1 Ssearchstaff ORDER BY date Sresult mysql_query Squery Snum_results mysql_num_rows Sresult echo lt p gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Number of records found Snum_results lt font gt lt p gt for Si 0 Si lt Snum_results i Srow mysql_fetch_array Sresult echo lt p gt lt strong gt lt font face verdana Geneva Tahoma sans serif color 4C4C4D gt Si 1 echo htmlspecialchars stripslashes Srow event echo lt strong gt lt br gt Sport echo stripslashes Srow sport echo lt br gt Date echo stripslashes Srow date echo lt br gt Start Time echo stripslashes Srow time echo lt br gt Venue echo stripslashes Srow venue echo lt br gt Staff Member echo stripslashes Srow staff1 echo lt br gt Second Staff Member echo stripslashes Srow staff2 echo lt br gt Transport Booked echo stripslashes Srow transport echo lt br gt Lunch Required echo stripslashes Srow lunch echo lt br gt Group Size

Download Pdf Manuals

Related Search

Related Contents

Avaya Business Communications Manager 50 Meet Me Conferencing Quick Reference Guide  Trust Onyc  Hauptmenü  Adora TL - V  UM1718 - STMicroelectronics  valve tester  SPY-DVR4KIT1/SPY-DVR4KIT2    AW-2 Owner`s Manual  Controles do usuário  

Copyright © All rights reserved. Failed to retrieve file