HE Computing Bradford College Assignment front sheet Qualification Unit number and title BTEC HND Computing and Systems Development Unit 35: Web Applications Development Student name and number Assessor name Michael Russell Date issued Completion date Submission details 24 October 2014 19 December 2014 Upload to Moodle no later than 1600 hours Assignment title BoP Central Learning Outcome Learning Outcome Assessment Criteria In this assessment you will have the opportunity to present evidence that shows you are able to: Task no. Evidence (Page no) LO1 Understand the concepts of web application development 1.1 critically evaluate the functions and advantages of web applications 1 1.2 critically compare different types of server-side and client-side scripting languages 1 1.3 examine web security concerns and make recommendations for security improvements 1 LO2 Be able to design web applications 2.1 design a web application to meet a given requirement 2 2.2 synthesise client-side and server-side functionality in a web application 2 2.3 apply a database design for use in a web application 2 2.4 evaluate alternative designs and solutions to meet a given requirement 2 LO3 Be able to implement web applications 3.1 implement a web application to a prepared design using client-side and server-side scripting languages 3 3.2 implement a web-enabled database management system to store, retrieve and manipulate data in a web application 3 3.3 identify and implement opportunities for error handling and reporting 3 LO4 Be able to test web applications 4.1 critically review and test a web application using a web-enabled database management system 4 4.2 analyse actual test results against expected results to identify discrepancies 4 4.3 critically evaluate independent feedback on a developed web application and make recommendations for improvements 4 4.4 create user documentation for a developed web application 4 In addition to the above pass criteria, this assignment gives you the opportunity to submit evidence in order to achieve the following Merit and Distinction grades: Grade Descriptor Indicative Characteristics Contextualisation M1 Identify and apply strategies to find appropriate solutions • Effective judgements have been made • An effective approach to study and research has been applied To achieve M1, you must demonstrate effective time management strategies for completing this assignment. This includes submitting your work for this assignment in accordance with the completion date and submission details. When building your website you will need to evidence that effective judgments have been made when choosing the best design and coding and scripting commands. Your completed report should use Harvard referencing in line with the College's published guidelines. M2 Select/design and apply appropriate methods/techniques • A range of sources of information has been used • Complex information/data has been synthesised and processed To achieve M2, you should provide evidence that a diverse range of information has been consulted and that you have used this to make an informed choice in designing a system that is fit for purpose. This should be clearly evidenced by your Bibliography. M3 Present and communicate appropriate findings • A range of methods of presentation have been used and technical language has been accurately used • The communication is appropriate for familiar and unfamiliar audiences and appropriate media have been used. To achieve M3, your report should make use of appropriate media (this could include text, graphics, charts, diagrams etc.) to effectively communicate the design of the system to the intended audience. No assumption as to your audience's level of computer literacy has been made; technical terms have been used accurately and explained. D1 Use critical reflection to evaluate own work and justify valid conclusions • Conclusions have been arrived at through synthesis of ideas and have been justified • Realistic improvements have been proposed against defined characteristics for success To achieve D1, you should provide evidence that you have consulted a wide range of material that has allowed you to produce a comprehensive answer. You will have clearly evaluated your work outlining areas for improvement in the future. D2 Take responsibility for managing and organising activities • Autonomy/independence has been demonstrated To achieve D2, you should provide evidence that you are able to go beyond previously published material and use your own ideas to create a report and website that are original, unique and fit for purpose. D3 Demonstrate convergent/lateral creative thinking • Innovation and creative thought have been applied To achieve D3, you should demonstrate imagination and creativity within the presentation, formatting and structure of your report and website. Learner declaration I certify that the work submitted for this assignment is my own and research sources are fully acknowledged. Student signature: Date: Assignment brief Unit number and title Unit 35: Web Applications Development Qualification BTEC HND Computing and Systems Development Start date 24 October 2014 Deadline/hand-in 19 December 2014 Assessor Michael Russell Assignment title BoP Central Purpose of this assignment This assignment requires you to analyse a scenario and then design, build and test a suitable interactive website to meet the needs of the user. This practical demonstration of your skills will furnish you with an opportunity to utilise the latest web technologies demanded by industry. Scenario The largest birds of prey owners group in the UK has decided to setup a website for their members. They have agreed upon the following functional requirements: • New users can sign-up and open an account • Existing users can login and logout • Existing users can add the details of a new bird in their ownership • Existing users can query the database on the bird type (these are: eagle, falcon, hawk, owl, buzzard, harrier, kite, vulture), whereupon the name, owner, location and picture of each of the corresponding birds meeting the search criteria are displayed Task 1 (Learning outcome 1.1, 1.2, 1.3) a) List the typical features of websites that support people who belong to a hobby and the advantages that a website can bring to people who belong to such a community b) Pick two server side scripting languages and compare them. Give some example code for each. Do the same for two client side scripting languages c) d) For each of the following areas, choose one security concern and discuss how it can be avoided or the risk reduced: Apache web server, SQL, PHP Task 2 (Learning outcome 2.1, 2.2, 2.3, 2.4) Produce design plans for the following: a) A justification for the design of the website to meet the needs of the users b) Logos and images c) Typography d) Storyboard for each page clearly showing the page elements e) A navigation map showing the relationship of the pages to each other and the names of the files needed to display each page f) Identify areas where accessibility could be implemented You should produce at least two different designs and have these evaluated by a third party before deciding upon a final design to implement. You should fully document the feedback produced by the evaluator(s). The database has been designed for you and a copy of the ERD is attached to the end of this document. Task 3 (Learning outcomes 3.1, 3.2, 3.3) Build the website ensuring that your design is followed. The website should utilise a back end database that holds records of owners and their birds. You should employ the following technologies in the site: HTML, CSS, PHP, MySQL and Javascript. Both kinds of scripting must be employed. You should be sure to implement some form of error handling. Task 4 (Learning outcomes 4.1, 4.2, 4.3, 4.4) Thoroughly test your website as follows: • Draw up test plans and then test your website using them to ensure that it works correctly. The tests should be systematic and you should clearly contrast the actual results against the expected results. • Prove that your website meets the HTML5 and CSS3 standards by submitting the files for checking online using the appropriate W3C online validator. Discuss every item of adverse feedback received and advise whether these need addressing or can be ignored. (Place the actual online W3C reports in the appendix of your assignment). Note: The validator cannot validate PHP. Instead, you need to validate the HTML code generated after it has been parsed by the PHP server. To do this, copy the source code from your browser using the view source option. • Obtain feedback on your website by carrying out usability studies with an independent third party. Using this, list ways that your website could be improved. (note: do not implement the improvements) • Create a short user guide to explain how to use the website you have created (sorry, but you cannot incorporate this into the website). Produce an asset list to show what files are employed, where they are located and the websites dependency upon them (build time or runtime) Evidence checklist Summary of evidence required by student Evidence presented Task 1 The introductory section of your report should cover the analysis required before a website is designed Task 2 The second section of your report involves producing designs for a specific scenario provided by your client Task 3 The third section of your report involves building a website by following the plans and using the latest web technologies to include client and server side scripting. Error handling must be included Task 4 The forth section of your report involves testing your website in a systematic way, reporting the results and listing possible improvements that could be implemented Entity Relationship Diagram