Assessment guidelines
Student's name Date of birth Position
Web Design
VINH LONG UNIVERSITY OF TECHNOLOGY EDUCATION
PRACTICE CENTER
TEST PROJECT
PRACTICAL SKILLS
MODULE 1: WEB DESIGN
Exam Paper Code: WD01
SCHOOL LEADERSHIP CHIEF SUBCOMMITTEE ON
EXAM DEVELOPMENT
Vinh Long, month 07/2020
Assessment guidelines
Student's name Date of birth Position
Web Design
GUIDE CONTESTANTS
Time:
- Preparation Time: 05 minutes
- Time Duration: 150 minutes
- Break Time: 10 minutes
Scores:
Exam content Marks
1 Programming with HTML/CSS 30
2 Programming with JavaScript 30
3 Use the MySQL 10
4 Programming with PHP 30
Total Marks 100
Candidates are required to note:
- Ensure safety standards of health and computer
- Do the test independently without discussing while doing the test
- Comply with regulations of exam room and proctor’s instructions
- Fill the information in the form
- Complete all requirements in the content of the exam
- Do not use documents, the Internet and other communication devices during the
assignment
- If the exam does not have special requirement for the file name and storage location,
contestants save all exam file name in the folder as following format: D:\
WorkSkills\Web Design
<Student’s Name>_< Student code >[.< extension >]
CONTENT OF THE TEST
Question 1: Programming with HTML/CSS: Use HTML/CSS code to design the
following page
Assessment guidelines
Student's name Date of birth Position
Web Design
Figure 1 Project folder structure
Figure 2. WEB layout interface
DESCRIPTION OF PROJECT AND TASKS
₋ All content that uses the system default font
₋ The title uses an H3 tag with a font size of 20px and is blue
₋ One-level menu and hover mouse effect with blue
Assessment guidelines
Student's name Date of birth Position
Web Design
₋ "Related books" section divides 4 columns of content that change by column size
₋ The footer is black.
Question 2: Programming with JavaScript: Use Javascript to perform data checking
requirements on a form
DESCRIPTION OF PROJECT AND TASKS
₋ Using Ajax performs a paged feature when the bar scrolls to 70% of the page.
₋ When the subs page shows more Related books content
₋ When the notification data is out on the footer section "Page content is out"
Question 3:
Use the MySQL create database Books:
The database schema:
Table 1 "Book" table properties
Table name: Book
Properties Data type Notes
id_book INT
id_book_category INT
name VARCHAR(100)
image TEXT
description TEXT
view INT
create_date DATETIME
Table 2 " Books Category" table properties
Table name: books_category
Properties Data type Notes
id_ books_category INT
books_category VARCHAR(100)
description TEXT
create_date DATETIME
DESCRIPTION OF PROJECT AND TASKS
Assessment guidelines
Student's name Date of birth Position
Web Design
Use MySQL database management system to create data structure, binding integrity.
Add 10 news templates for each data table just created.
Question 4: Programming with PHP: Use PHP connected to MySQL to complete the
following features
DESCRIPTION OF PROJECT AND TASKS
₋ Show the book's details through an attached ID through the GET protocol
₋ Show related books that are almost identical to the title of the book (T-SQL LIKE)
₋ When a user views a book, increase the number of views of the book in the database
₋ When a user visits a page with a book id that doesn't exist in the database performs a
navigate to the page with error code 404.
GENERAL TRANSCRIPT
Maximum Achieved
Exam content
Marks Marks
1 Programming with HTML/CSS 30
2 Programming with JavaScript 30
3 Use the MySQL 10
4 Programming with PHP 30
Total Marks 100
TEST TIME
Get to know the equipment Time Duration Break Time
Starting time Starting Starting Starting
time time time
Ending time Ending Ending Ending
time time time
TEACHERS’ SIGNATURE
1 2 3 4 5
Assessment guidelines
Student's name Date of birth Position
Web Design