Faculty of Science, Engineering and Computing Assessment Form Module: CI5420 Setter: Martin Tunnicliffe Title of Assignment: Creating an E-Commerce Application Deadline: 31/03/2017 Module weighting 25% Coursework Aim This coursework gives students an opportunity to apply the skills learned in the second part of the module (HTML, PHP, SQL etc.) by creating a working e-commerce site running on a web-server. Module learning outcomes assessed in this piece of coursework This assessment is designed to assess your ability in the following module learning outcomes: • Have an understanding of network software so as to be able to participate in the writing, updating and the design of commercial applications. • Write server and client-side scripts and provide connectivity between web applications and databases. Submission details Submission of coursework will be performed using Turnitin on StudySpace. Students will submit a document containing a walkthrough of the site with screenshots of the major page displays, together with a URL where it can be accessed, and a zip-file containing the code. Coursework brief Design and implement a working e-commerce website. This could be a store to sell clothes, sports equipment or anything else you wish. Visitors should be able to: • Browse items for sale and add them to a shopping cart • Go through a checkout page to generate orders For additional credit, the following features could be added: • A password-protected administrator portal, allowing a store employee to view/edit stock and sign-off orders. • A search facility to allow users to locate items of interest in the stock database Students need not worry about the payment mechanism: a dummy form requesting credit card details (not actually doing anything with the information) will be sufficient. Assessment criteria There are four assessment criteria:  Competent use of HTML and CSS  Efficient use of PHP to provide server-side functionality  Efficient design of an SQL database interfacing with the PHP code  Design an attractive and user-friendly web page The grade boundaries and expectation of what must be provided to meet each grade interval are shown in Table 1. Feedback (including details of how and where feedback will be provided) During the first TB2 workshops (until Enhancement Week) students will perform formative worksheet exercises covering the skills and competences needed for this coursework. Before moving onto the next exercise, students should show their work to the workshop tutor and discuss solutions as feedback is essential to tackling the summative coursework. As the weeks progress, models solutions will be presented along with a discussion of the typical errors students make and methods for mitigating these. Students who make a preliminary submission of their coursework on or before 10 March will receive formative feedback allowing them to improve on it for their final submission. Table 1 Criteria Grades for the Designing a Physical Network Coursework Grade (Weighting ) Exceeded Expectations 100-80% Met Expectations 79-60% Close to Expectations 59-40% Below Expectations 39-1% Use of static HTML and CSS (25%) Original HTML/ CSS code for attractive and navigable site. Semi-original HTML /CSS for a reasonably good website. Implementation of a derivative and/or very basic website. Failure to understand and use HTML or CSS adequately. Use of PHP in conjunction with HTML (25%) Implementation of original and efficient PHP scripts which run without errors. Implementation of semi-original PHP scripts which run with few or no errors. Implementation of derivative and/or partially functional PHP scripts. Failure to understand or use PHP adequately. Design of an SQL database with PHP (25%) Several tables working together to form an efficient and versatile system. At least one table, well designed and interfacing smoothly with the PHP code. At least one table, partially successfully interface with PHP. Failure to understand SQL and its interface with PHP. Additional Features and Overall user experience (25%) Customer and admin portals work. Easy to use. Maybe some extra "dynamic" features added using Ajax. Customer portal works well, and is easy to use and navigate. Customer portal works partially (maybe with a few error messages) Website is confusing, ineffective or impossible to use.