Course Title: Build a dynamic website
Part B: Course Detail
Teaching Period: Term2 2019
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
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 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 |
Element: |
2. Produce the software design specifications |
Performance Criteria: |
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 |
Element: |
3. Develop the website to the specified design |
Performance Criteria: |
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 |
Element: |
4. Test the web application |
Performance Criteria: |
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 |
Learning Outcomes
Details of Learning Activities
This may include self-paced and collaborative classroom activities such as: Class exercises Challenges Problem solving Project work Quizzes We expect you to participate and contribute in all scheduled learning activities as each week builds on the next.
Teaching Schedule
Week |
Week Beginning |
Topic |
Learning Materials and Activities |
Assessment Remarks |
1 |
8th July |
Introduction to PHP and dynamic websites. Servers and Clients Reviewing HTML and CSS knowledge |
Static vs dynamic websites Role of HTML, CSS and PHP in dynamic websites Setting up accounts on RMIT server. |
Overview and discussion of the three assessments |
2 |
15th July |
PHP syntax - variables, strings and echo Include files |
Creating basic PHP scripts using strings and variables Exploring the use of include files in PHP scripts |
|
3 |
22th July |
HTTP request methods POST and GET. Storing and retrieving data from arrays |
Creating HTML forms and using HTTP request methods (POST & GET) Arrays and loops |
|
4 |
29th July |
PHP and image files Superglobal $_FILE and self-posting forms |
Creating HTML forms with image browse and upload functionality |
|
5 |
5th August |
Making decisions - PHP conditionals (if & switch) Simple user- defined functions |
Creating conditional statements to determine what should be displayed
|
Assessment 1 submission
|
6 |
12th August |
Database tables and fields Connecting to a database via a website |
Creating database tables Connecting to a database via a website using object-oriented class, method and properties |
Overview and discussion of assessment 2 project requirements |
7 |
19th August |
SQL queries Inserting records into a database via a website |
Writing SQL statements Creating HTML forms and writing PHP scripts to insert data into a database |
|
8 |
26th August |
SQL injection Escape strings, prepared statements and error control |
Exploring SQL injection and form input when inserting new records into a database |
|
Mid-semester break (Monday 2nd – Friday 6th September) | ||||
9 |
9th September |
SQL queries Methods and scripts to select and display data from a database. Loops, HTML & CSS |
Writing PHP scripts and class methods to select and display database records Applying HTML and CSS to data display |
|
10 |
16th September |
User requirements testing - class activity
Project demonstrations |
User requirements testing - class activity
Project demonstrations |
Assessment 2 In class demonstration and testing Canvas submission
|
11 |
23rd September |
SQL queries Updating data in a database |
Writing scripts to modify data in database tables |
|
12 |
30th September |
SQL queries Deleting data from a database |
Writing scripts to delete data in database tables |
|
13 |
7th October |
Security - Login and session control
|
Writing scripts for user login and sessions |
|
14 |
14th October |
User testing class activity |
User testing class activity Project Work |
|
15 |
21st October |
In class - Project Demonstrations |
In class - Project Demonstrations |
Assessment 3 submission In class demonstration Canvas submission |
16 |
28th October |
Re-submit if required |
Re-submit if required |
Learning Resources
Prescribed Texts
References
Other Resources
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
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
Please note the following two units are clustered and therefore co-delivered and co-assessed holistically
- COSC7369C (ICTWEB501) - Build a dynamic website
- COSC7372C (ICTDBS504) - Integrate database with a website
Assessment 1
You are required to create a simple website using HTML forms and PHP scripts to demonstrate how HTTP requests, PHP arrays, variables, conditional statements and functions combine to add dynamic functionality to a website. You must test the website and explain how you used web programming concepts.
The PHP website MUST be uploaded to the RMIT file server where it can be viewed and assessed. A copy of your project files and testing documentation is to be submitted to Canvas
Assessment 2
This assessment task is part 1 of a website project which has 2 parts
You are required to read and analyse a technical requirements document for a dynamic website; produce a design specifications document; and then build the dynamic website using object-oriented PHP, SQL and a MySQL database. The following tasks need to be completed
- Write a design specification document based on the technical requirements and user needs specified in the project brief
- Create a MySQL database table on RMIT SQL server
- Write PHP scripts to connect to the database, insert and display database records
- Test the website functionality against the technical requirements
Your dynamic website files and database must be hosted on the RMIT Jupiter and SQL servers.
All files required for the website (sql, php, css and images) and written documents (design specifications & testing) are to be zipped and uploaded to Canvas by the due date
You are required to demonstrate your project during class in week 10
Assessment 3
This is part 2 of your dynamic website project. You will need to re-read the technical requirements document and build additional functionality into the website you created in assessment 2.
Using object-oriented PHP and a MySQL database complete the following tasks:
- Write a script to update database records with user supplied input
- Write a script to delete data from the database
- Conduct user testing
You are required to demonstrate your completed project to your teacher in week 15 and you may be required to answer questions about your code.
After your demonstration, you need to submit a ZIP file of all website project files and testing documentation to Canvas by the end of week 15
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 2 - dynamic website project – part 1 Assessment 3 - dynamic website project – part 2 |
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 2 - dynamic website project – part 1 Assessment 3 - dynamic website project – part 2 |
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 2 - dynamic website project – part 1 Assessment 3 - dynamic website project – part 2 |
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 1 - basic PHP website Assessment 2 - dynamic website project – part 1 Assessment 3 - dynamic website project – part 2 |
Performance Evidence |
|
Analyse the technical requirements for a dynamic web site Produce software design specifications |
Assessment 2 - dynamic website project – part 1 Assessment 3 - dynamic website project – part 2 |
Create a website, using efficient and effective code to meet the technical requirements, and test and document a website against the requirements. |
Assessment 1 – a basic PHP website Assessment 2 - dynamic website project – part 1 Assessment 3 - dynamic website project – part 2 |
Knowledge Evidence |
|
Summarise the principles of analysis and design Outline programming control and design structures Explain web programming concepts, including:
|
Assessment 1 – basic PHP website Assessment 2 - dynamic website project – part 1 Assessment 3 - dynamic website project – part 2 |
Other Information
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.
Course Overview: Access Course Overview