SCC130 Summer Term Assessment 2019-2020 v1.0
Prepared and updated by Dr Phil Benachour 1

School of Computing and Communications:
SCC130 Summer Terms Assessment details


Task 1: You are required to build a simple Web interface for an avid reader who would like to keep a
record of his/her reading collection electronically. The user has basic proficiency in computer literacy
so the interface’s usability needs to be considered. The Web interface can be built in HTML for
example: index.html which can then link to view, add, delete, edit and update content files.

This task is based on the following requirements:
1. The HTML file needs to act as the interface.
2. The table should contain details about Books and should contain at least five fields. There is
some flexibility here with regards the maximum number of fields but be reasonable.
3. The view function/file should list the content of the table.
4. The add function/file should contain input fields enabling the user to populate the table (add
a row).
5. The delete function/file should be able to delete a specific row based on what the user has
entered.
6. The edit and update function/file should enable the user to update/change one or more
fields in the table.

*As you work through the requirements think about how you might want to combine the functions
above within one interface so that the user can see his/her list of updated data.

*You will been given some guidance and examples to enable you to get some components of the
system’s functionality to work during the sessions in Weeks 22-24. You will however need to modify
some of these examples to get the full system working.

Task 2: You are required to integrate PHP and SQL functionality and display data using Google
charts. This task requires familiarity with Google charts which you will learn about in the lab session
in Week21.
Assessment weighting and breakdown between tasks:
The summer term assessment contributes to 25% of the overall SCC.130 course work assessment.
The assessment is divided between the two tasks as follows:
1. Task 1: PHP, MySQL, Database interaction 85%
2. Task 2: Retrieving data from the database and displaying graphs using PHP/MySQL and
Google Charts 15%


SCC130 Summer Term Assessment 2019-2020 v1.0
Prepared and updated by Dr Phil Benachour 2

Assessment weighting and breakdown for each task:

Task 1: (85 marks)
• Presentation of the interface (5 marks)
• Usability (10 marks)
• Functionality (30 marks)
• Validation (30 marks)
o Server side validation (essential)
• Overall code (10 marks)

Task 2: (15 marks).
• Integrate PHP and SQL functionality within Google charts.
• Display data using Google charts
Submission and “Demonstration” deadlines for Task 1&2: Week 25 at the very latest during your
allocated lab sessions.
Submission:
All code and related files are required to be submitted via Moodle by 4 pm on Friday 22nd May 2019.
*Please refer to the submission document contained in the same folder of this document for further
details of the submission requirements.