please read the question carefully and do the assignment
ICT101 Introduction to Internet and Web Development Assessment 2 – Individual project work Overview In this assessment, you will first read and understand a case study on the development of a website that serves as a marketplace for second-hand products. In this assessment, you will focus on the backend development. In particular, you will be applying the knowledge of JavaScript, PHP, and MySQL to implement interactive web designs. Important information Please include SISTC’s assessment cover page at the beginning of the assessment This assessment weighs 25% of your final grade There are two tasks in this assessment, you need to zip your answers for the two tasks and submit the zipped file. The due date of this assessment is Sunday 11pm Week 12. Submitting your work late will attract a 10% reduction of mark for each day beyond the due date. A delay of more than 5 days will result in being granted a 0. It is recommended that you plan your time appropriately and that you start your assessment early which will give you time to gain feedback from your lecturer and do well. Please note that both tasks in this assessment should be built on your programming work in the assessment 1. Learning Outcomes Assessed The following course learning outcomes are assessed by completing this assessment task: LO3. develop simple web pages using and demonstrating basic aspects of HTML5, CSS3 and JavaScript; LO4. design effective and user-friendly simple web pages, embracing usability principles and adhering to style guides; LO5. understand, and be able to modify, very simple interactive web systems using PHP and MySQL on the server side; Assessment Tasks Task 1: Your manager has asked you to implement a functionality called “magic advertisement”. That is, consumers will see a special selection of normal advertisements (at least 6 advertisements). Consumers will also see a button besides the advertisement area called “magic advertisement”. Once consumers click on it, they will see the advertisements in the special section to be changed into special offers (e.g. reduced price) – while the normal advertisements in their previous website design remain unchanged. Please note that you need to use Javascript to implement this functionality. Your task is to • Design a special area with HTML/CSS codes to display at least 6 advertisements. Place a button at the bottom of this area. • Once the button is clicked, the existing advertisements will be replaced with new advertisements: o The new product description should include the old product description and starts with “[Special offer!]”. ▪ “[Special offer!]” needs to be bold and in red colour. o The product price will be dropped by 30%. o Other advertisement information as well as advertisements outside the special new area should remain unchanged. Task 2: Your manager also gives you another task which is to implement a user registration functionality. You need to use a form to collect user registration information including a username and a password. Once submitted, the registration information will be sent to the server and stored in a special MySQL database (This database needs to be created in a separate php file, named “database.php”, at first. The servername should be “localhost”; username is “ICT101_Assessment2”; password is “ICT101_password”). There are three possible outcomes of the registration process: • If the username is a used one (i.e. you already have a same username data in the database), you need to output an error message – “Sorry! This username has been taken!”; • If the password is too short (less than 10 characters), the web systems will also not accept this new user. You need to output this error message - “Sorry! The password is too short!” o Please note that you may have the first and the second situation happening at the same time. • If both username and password are okay, you will insert the user information into the MySQL database and record its information. After it is done, a successful registration message needs to be displayed on the user’s webpage - “Thanks! The registration process has been successful!” Please note that you need to use Javascript, PHP, and MySQL in a combination to implement these functionalities. Submission Submit a zipped field including your prototype and all web system files to Moodle. Marking Criteria / Rubric Refer to the attached marking guide. General Assessment Requirement Incomprehensible submissions - Assessments provide the opportunity for students to demonstrate their knowledge and skills to achieve the required standard. To do this, assessment responses need to be both clear and easy to understand. If not, SISTC cannot determine that students have demonstrated their knowledge and skills. Assessments will, therefore, be marked accordingly including the potential for 0 (zero) marks where relevant. Case study: Assessment response must focus on the hypothetical case study given in the Task Instructions. Any assessment items that do not address the case study may be awarded 0 (zero) marks. Check with marking rubric: Before submitting your assessment, you should check it against the assessment criteria and the marking rubric included in this specification to ensure that you have satisfactorily addressed all the criteria that will be used to mark your submission. Feedback Feedback will be supplied through Moodle. Authoritative results will be published on Moodle. Academic Misconduct To submit your assessment task, you must indicate that you have read and understood, and comply with, the Sydney International School of Technology and Commerce Academic Integrity and Student Plagiarism policies and procedures. You must also agree that your work has not been outsourced and is entirely your own except where work quoted is duly acknowledged. Additionally, you must agree that your work has not been submitted for assessment in any other course or program. Assessment Marking Rubric: Criteria Fail Pass Credit Distinction High 0 - 49% 50% - 64% 65% - 74% 75% - 84% 85% - 100% Task 1 (20%) Implement a “magic advertisement” functionality (20%) Many major functional requirements indicated in the task specification have not been implemented. Some functional requirements indicated in the task specification have been implemented. A substantial number of functional requirements indicated in the task specification have been implemented. Most functional requirements indicated in the task specification have been implemented. All functional requirements indicated in the task specification have been implemented. Task 2 (70%) Successfully create a MySQL database on the server by the “database.php” file (10%) Poor attempt to create database. No codes provided. The creation of database is unsuccessful, but codes are readable and reasonable. The information used in database creation is mostly not as required. The creation of database is successful but there are substantial errors. The information used in database creation is partly as required. The database has been mostly successfully created by the php file. The information used in database creation is mostly as required. The database has been excellently successfully created by the php file. The information used in database creation is exactly as required. Output error message when username is not valid (20%) Error message is not correctly outputted. Poor attempt to connect to database. Error message is not correctly outputted. Database connection is unsuccessful. Error message is not correctly outputted, but the database connection is successful. Error message is correctly outputted given invalid username, but there some errors in processing data. Error message is correctly outputted given invalid username. Output error message when password is not valid (20%) Error message is not correctly outputted. Poor attempt to connect to database. Error message is not correctly outputted. Database connection is unsuccessful. Error message is not correctly outputted, but the database connection is successful. Error message is correctly outputted given invalid password, but there some errors in processing data. Error message is correctly outputted given invalid password. Output message for successful registrations (20%) Message is not correctly outputted. Poor attempt to connect to database. Message is not correctly outputted. Database connection is unsuccessful. Message is not correctly outputted, but the database connection is successful. Message is correctly outputted if registration is successful, but there some errors in processing data. Message is correctly outputted if registration is successful. Overall design (10%) Coding convention and quality of code (10%) The code is formatted very little to not at all. The naming of methods or variables is inconsistent. No naming convention is followed. Little or no comments provided. The code is satisfactorily written, but there is substantial room for improvement. There are significant errors in code format, and naming of methods or variables. There is a significant lack of useful comments. The code is generally well written, but there is some room for improvement. There are more than 5 errors, but less than 8 errors in terms of naming convention and code format. There is reasonable amount