Course Title: Build a dynamic website
Part B: Course Detail
Teaching Period: Term1 2018
Course Code: COSC7369C
Course Title: Build a dynamic website
School: 650T Vocational Business Education
Campus: City Campus
Program: C5341 - Diploma of Information Technology
Course Contact: Val Christou
Course Contact Phone: +61 3 9925 5076
Course Contact Email: val.christou@rmit.edu.au
Name and Contact Details of All Other Relevant Staff
Sarah Mackinnon
Nominal Hours: 60
Regardless of the mode of delivery, represent a guide to the relative teaching time and student effort required to successfully achieve a particular competency/module. This may include not only scheduled classes or workplace visits but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.
Pre-requisites and Co-requisites
None
Course Description
This unit describes the skills and knowledge required to analyse and design websites to meet technical requirements.
It applies to individuals working as web developers who are responsible for the analysis, design, implementation, and testing of websites.
National Codes, Titles, Elements and Performance Criteria
National Element Code & Title: |
ICTWEB501 Build a dynamic website |
Element: |
1. Define and analyse the technical requirements |
Performance Criteria: |
1.1 Identify the business requirements and appropriate standards
|
Element: |
2. Produce the software design specifications |
Performance Criteria: |
2.1 Produce a hierarchy of the website showing navigation |
Element: |
3. Develop the website to the specified design |
Performance Criteria: |
3.1 Create the software components of the website
|
Element: |
4. Test the web application |
Performance Criteria: |
4.1 Test the website against the requirements |
Learning Outcomes
Details of Learning Activities
A range of learning activities are planned for this course including self-paced and collaborative classroom based activities.
The self-paced activities will be delivered thought various technology platforms and include your contribution to interactive sessions.
The collaborative classroom based activities will include group discussion, group problem solving activities and opportunities to practice your skills in a simulated/real workplace environment.
We expect you to participate and contribute in all scheduled learning activities.
- Class exercises
- Challenges
- Problem solving
- Project work
Teaching Schedule
Week |
Week Commencing |
Topics |
Assessment |
Competencies Delivered |
1 |
05/02/2018 |
Introduction to the Course including: Course requirements Accuracy of enrolment Assessment requirements/Cover Sheets Reminder re Plagiarism Reminder re Appeals Extensions/Resubmissions Feedback in this course Reminder re submission requirements Getting help
Course introduction Overview PHP, MYSQL and dynamic websites Virtual Server (XAMPP) setup Review of HTML and CSS |
|
ICTWEB501 ICTDBS504 |
2 |
12/02/2018 |
PHP syntax (echo, strings, variables, arrays) PHP & HTML
|
Assessment 1 – dynamic website specification issued
|
ICTWEB501 ICTDBS504 |
3 |
19/02/2018 |
RMIT Jupiter & SQL server setup PHP & database connectivity Creating database tables Project Design Brief
|
|
ICTWEB501 ICTDBS504 |
4 |
26/02/2018 |
PHP & database connectivity – display data SQL: select PHP: variables, arrays and loops |
|
ICTWEB501 ICTDBS504 |
5 |
05/03/2018 |
PHP, SQL & database connectivity CSS & HTML Include function |
|
ICTWEB501 ICTDBS504 |
6 |
12/03/2018 |
PHP & database connectivity SQL: search (hyperlinks, forms, post & get, image files) |
Assessment 1 – stage 1 (online submission Monday 8am & in class demonstration)
|
ICTWEB501 ICTDBS504 |
7 |
19/03/2018 |
SQL: insert PHP & database connectivity |
|
ICTWEB501 ICTDBS504 |
8a |
26/03/2018 |
PHP concepts (validation & sanitation) PHP & database connectivity SQL: insert
|
|
ICTWEB501 ICTDBS504 |
Easter Term Break, 29 March – 4 April, 2018 inclusive | ||||
8b |
5/04/2018 |
PHP concepts (validation & sanitation) PHP & database connectivity SQL: insert |
|
ICTWEB501 ICTDBS504 |
9 |
9/04/2018 |
SQL: delete PHP & database connectivity |
Assessment 1 – stage 2 (online submission Monday 8am & in class demonstration)
|
ICTWEB501 ICTDBS504 |
10 |
16/04/2018 |
SQL: update PHP & database connectivity |
|
ICTWEB501 ICTDBS504 |
11 |
23/04/2018 |
SQL: update PHP & database connectivity |
|
ICTWEB501 ICTDBS504 |
12 |
30/04/2018 |
PHP login with sessions |
Assessment 1 – stage 3 (online submission Monday 8am & in class demonstration) |
ICTWEB501 ICTDBS504 |
13 |
07/05/2018 |
PHP login with sessions |
|
ICTWEB501 ICTDBS504 |
14 |
14/05/2018 |
Project Work Demonstrations and interviews commence |
In class project demonstrations and interviews commence |
ICTWEB501 ICTDBS504 |
15 |
21/05/2018 |
Project Demonstration and interview |
Assessment 1 – stage 4 (online submission Monday 8am) In class project demonstrations and interviews |
ICTWEB501 ICTDBS504 |
16 |
28/05/2018 |
Re-submission if required Project Demonstration and interviews if required |
|
ICTWEB501 ICTDBS504 |
Learning Resources
Prescribed Texts
References
Other Resources
Overview of Assessment
In order to achieve competency in this unit, you must provide:
Performance Evidence
Evidence of the ability to:
- analyse the technical requirements for a dynamic web site
- produce software design specifications
- create a website, using efficient and effective code to meet the technical requirements, and test and document a website against the requirements.
Knowledge Evidence
To complete the unit requirements safely and effectively, you must:
- summarise the principles of analysis and design
- outline programming control and design structures, and object-oriented programming
- explain web programming concepts, including:
- authentication and web security
- hypertext transfer protocol (HTTP)
- session management
- stateless programming.
Assessment Conditions
Assessment must be conducted in a safe environment where evidence gathered demonstrates consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the website technologies field of work, and include access to:
- a development environment
- a server
- a database server
- browsers.
You are advised that you are likely to be asked to personally demonstrate your assessment work to your teacher to ensure that the relevant competency standards are being met.
Feedback
Feedback will be provided throughout the semester in class and/or online discussions. You are encouraged to ask and answer questions during class time and online sessions so that you can obtain feedback on your understanding of the concepts and issues being discussed. Finally, you can email or arrange an appointment with your teacher to gain more feedback on your progress.
You should take note of all feedback received and use this information to improve your learning outcomes and final performance in the course.
Assessment Tasks
Assessment Overview - Dynamic Website Project
You are required to design; build and test a dynamic website using a MySQL database and PHP procedural scripting language. The dynamic website will be an e-commerce website – for a fictional or real business.
This website project is divided into 4 stages. Each stage must be completed and submitted with no errors to be deemed competent for these clustered units. Refer to the sub-tasks (stages) below for description and due dates
Each stage of your dynamic website project must be uploaded to the RMIT Jupiter and SQL servers for testing and demonstration (PHP / Project)
All documentation required for your dynamic website project (project brief, database design and testing) will be in the form of posts to a project blog. You will set up your project blog on the RMIT Jupiter and SQL servers in class during week 3.
The completed website will need to demonstrate the following:
- A database containing genuine records (a minimum of product and user tables)
- Connection to the MySQL database
- The use of PHP & SQL to search, select, display, insert, update and delete database records from the website
- Website security (form validation and SQL sanitization)
- Session-based user login
- HTML5 structure and CSS styling for web page design
- Thorough testing in a variety of browsers and platforms
Assessment Stage1 - Display database records in a web page
Due: Week 6 (Monday 12 March, 8 am)
This is the first stage of your dynamic website project. You are required to write a design brief, create a database, connect to the database and display records from the database on a PHP web page
Blog Posts
Set up a Project Blog on RMIT Jupiter and SQL servers
Write the following project blog posts (Design Brief & Testing)
- the purpose/audience/theme of your website (business)
- screen captures of internet websites used as inspiration
- a storyboard showing your design for a display page
- the proposed database structure (table types and fields)
- testing (errors, fixes, browsers)
Programming Tasks
Create a dynamic web page to display database records
- Create a database table containing 3 genuine records for products to be displayed in your website
- Create a folder structure on the Jupiter server - PHP / Project / Stage 1
- Write a PHP script to connect to the database
- Write a PHP script to display all product records in the database (text and images)
- Use HTML structure and CSS layout to display the product information
- Create and use PHP include files for the required HTML structure (!DOCTYPE, html, head, body)
Submission Instructions
Online Submission
Export your project database as an SQL file. Save into your project folder
Ensure your project folder has all of the required PHP, CSS, SQL & image files
Zip your project folder and save with the following name “yourfirstname_lastname_stage1.zip”
Upload to the submission drop box
Demonstration
Ensure your project is fully functional on the RMIT Jupiter and SQL servers
You will demonstrate your working project and blog posts to your teacher during class in week 6
Assessment Stage 2 – insert and search for database records using a web page
Due: Week 9 (Monday 9 April, 8 am)
This is the second stage of your dynamic website project. You task is to create more functionality for your dynamic website project – searching, inserting a new record and providing an HTML navigation
You will need to complete the following blog posts:
- screen captures of internet websites used as inspiration – searching and insert forms
- a storyboard showing your design for an insert form (fields & user information)
- any changes to the database structure (table types and fields)
- testing (errors, fixes, browsers)
- explain http requests – get & post
- explain global array $_FILES
- explain your SQL queries
You will need to complete the following programming tasks:
- Update your database table so that it contains 5 genuine product records
- Create a PHP form and script to search for and display records
- Create a PHP form (HTML) to enable a user to input data and browse for an image
- Write a PHP script to take information from the form and insert a new record into the products table and copy the image to an images folder
- Add a hyperlink to each record on the display page linking to more information
- Write PHP code to add security (form validation and SQL sanitization)
- Create PHP include files for an HTML navigation (Display, Search and Insert)
Submission Instructions
Online Submission
Export your project database as an SQL file. Save into your project folder
Ensure your project folder has all of the required PHP, CSS, SQL & image files
Zip your project folder and save with the following name “yourfirstname_lastname_stage2.zip”
Upload to the submission drop box
Demonstration
Ensure your project is fully functional on the RMIT Jupiter and SQL servers
You will demonstrate your working project and blog posts to your teacher during class in week 9
Assessment Stage 3 – update and delete database records using a web page
Due: Week 12 (Monday 30 April, 8 am)
This is the third stage of your dynamic website project. You task is to create more functionality for your dynamic website project – updating and deleting existing database records (with security features)
You will need to complete the following blog posts:
- Screen shot of an internet site where you can change information e.g. Facebook. Explain how this works – what can you change?
- Are you restricted in what you can change?
- Create a flow chart to explain how you will implement the update and delete functionality
- Create storyboards to explain the required update and delete pages.
- Explain any changes to the database structure (table types and fields), website design or functionality
- Testing (errors, fixes, browsers)
You will need to complete the following programming tasks:
- Update your database table so that it contains 8 genuine product records
- Create scripts to update a database record from a website
- Create a scripts to delete a database record from a website
- Write PHP code to add security (update form validation and SQL sanitization)
- Update your PHP include file - navigation with Update and Delete options
Submission Instructions
Online Submission
Export your project database as an SQL file. Save into your project folder
Ensure your project folder has all of the required PHP, CSS, SQL & image files
Zip your project folder and save with the following name “yourfirstname_lastname_stage3.zip”
Upload to the submission drop box
Demonstration
Ensure your project is fully functional on the RMIT Jupiter and SQL servers
You will demonstrate your working project and blog posts to your teacher during class in week 12
Assessment Stage 4 – login functionality using sessions
Due: Week 15 (Monday 21 May, 8am)
This is the final stage of your website project. You will have already created a dynamic website which enables a user to search, display, insert, delete and update information. You have added HTML structure and CSS design. You have incorporated security features (form validation and SQL sanitizing). Now you will add login functionality and create sessions.
You will need to complete the following blog posts:
- Screen shot of an internet site where you are required to login e.g. Facebook or RMIT. Explain the login procedure (username/email/password). What error messages appear with incorrect login? What options are available when you log in?
- Flow chart showing what users will have access to when they log in to your website.
- Screen shot and explanation of how you have used session information in your website
- Explain any changes to the database structure (table types and fields), website design or functionality
- Testing (errors, fixes, browsers)
You will need to complete the following programming tasks:
- Create a user table for your database
- Create a PHP login form and script to enable a user to login into your website
- Use sessions to display the user’s name
- Use sessions to determine navigation options displayed
- Create a logout script
Submission Instructions
Online Submission
Export your project database as an SQL file. Save into your project folder
Ensure your project folder has all of the required PHP, CSS, SQL & image files)
Zip your project folder and save with the following name “yourfirstname_lastname_stage4.zip”
Upload to the submission drop box
Demonstration & Interview
Ensure your project is fully functional on the RMIT Jupiter and SQL servers
You will demonstrate your working project and blog posts to your teacher during class in week 15
During this demonstration you will be required to answer questions about the PHP and SQL code you have used in your project as well as the database tables you have used to store data.
GENERAL SUBMISSION INFORMATION
Ensure that you submit assessments on or before the due date.
Always retain a copy of your assessment tasks. (hard copy and soft copy)
When you submit work for assessment at RMIT University you need to use a cover sheet that includes a declaration and statement of authorship. You must complete, sign and submit a cover sheet with all work you submit for assessment, whether individual or group work. On the cover sheet you declare that the work you are presenting for assessment is your own work.
Late Submission Procedures
You are required to submit assessment items and/or ensure performance based assessment is completed by the due dates.
Late submissions of assessments will be eligible for grading at CAG (Competency Achieved) level only
If you are prevented from submitting an assessment item on time, by circumstances outside your control, you may apply in advance to your teacher for an extension to the due date of up to seven calendar days.
More Information: http://www.rmit.edu.au/students/assessment/extension
Form to use: http://mams.rmit.edu.au/seca86tti4g4z.pdf
Where an extension of greater than seven days is needed, you must apply for special consideration. Applications for special consideration must be submitted no later than two working days after the assessment task deadline or scheduled examination.
More Information: http://www.rmit.edu.au/browse;ID=g43abm17hc9w (unresolved)
Form to use: http://mams.rmit.edu.au/8a5dgcaqvaes1.pdf
Resubmissions (VET Programs):
If you are found to be unsuccessful in a Course Assessment Task you will be allowed one resubmission only. Your teacher will provide feedback regarding what you need to do to improve and will set a new deadline for the resubmission. The highest grade you will receive if your resubmission is successful is “CAG”.
If you are still not meeting the assessment requirements you must apply to your Program Manager in writing outlining the steps you will take to demonstrate competence in your course. Your submission will be considered by the Program Team and you will be advised of the outcome as soon as possible.
Adjustments to Assessment
In certain circumstances students may be eligible for an assessment adjustment. For more information about the circumstances under which the assessment arrangements might be granted please access the following website:
More Information: http://rmit.edu.au/browse;ID=7usdbki1fjf31
Marking Guide (Competency):
You must demonstrate that you have all the required skills/knowledge/elements in the unit of competency you are studying.
You will receive feedback on each assessment task that will inform you about your progress and how well you are performing.
Marking Guide (Grading)
After achieving competency we then grade your performance in the unit and you will achieve one of the following grades:
Final Grade Table
CHD Competent with High Distinction
CDI Competent with Distinction
CC Competent with Credit
CAG Competency Achieved – Graded
NYC Not Yet Competent
DNS Did Not Submit for assessment
Further information regarding the application of the grading criteria will be provided by your teacher.
Assessment Matrix
Elements/Performance Criteria |
Assessment Details |
1. Define and analyse the technical requirements 1.1 Identify the business requirements and appropriate standards 1.2 Determine and document, the purpose, expectations and functionality of the website 1.3 Analyse the user-interface design requirements, including user needs, design principles and operating systems |
Assessment – Individual Web Project (stage 1) |
2. Produce the software design specifications 2.1 Produce a hierarchy of the website showing navigation 2.2 Ensure that the content is logical and accessible to the user 2.3 Produce the prototype of the user interface 2.4 Determine and document, the architectural requirements 2.5 Design the data storage requirements |
Assessment – Individual Web Project (stage 1) |
3. Develop the website to the specified design 3.1 Create the software components of the website 3.2 Test the components of the website 3.3 Integrate the components to produce the web application |
Assessment – Individual Web Project (stages 1, 2, 3 & 4) |
4. Test the web application 4.1 Test the website against the requirements 4.2 Complete and document the design structure 4.3 Obtain client feedback and adjust web applications as appropriate |
Assessment – Individual Web Project (stage 4) |
Performance Evidence |
|
analyse the technical requirements for a dynamic web site produce software design specifications |
Assessment – Individual Web Project (stage 1) |
Create a website, using efficient and effective code to meet the technical requirements, and test and document a website against the requirements. |
Assessment – Individual Web Project (stages 1, 2, 3 & 4) |
Knowledge Evidence |
|
summarise the principles of analysis and design outline programming control and design structures explain web programming concepts, including: authentication and web security hypertext transfer protocol (HTTP) session management stateless programming |
Assessment – Individual Web Project (stage 4 – blog posts & interview) |
Other Information
You will need the following for each class
- Laptop with charger
- USB or external hard drive for backup
- Text editor such as Programmer's Notepad / Sublime
Course Overview: Access Course Overview