Course Title: Build a dynamic website

Part B: Course Detail

Teaching Period: Term1 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

Sarah Mackinnon

sarah.mackinnon@rmit.edu.au

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

A range of learning activities are planned for this course on a variety of topics as shown in the teaching schedule.

 

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

Course Delivery: 

The nominal hours associated with this are a guide only and represent the total teaching time and student effort required to successfully complete the course. This may include not only scheduled classes but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.

 

Week

Week Beginning

Topic

Learning Materials and Activities

Assessment Remarks

1

11th Feb 

Introduction to PHP. Setting up accounts on RMIT server. Reviewing HTML and CSS knowledge

Activity to set up account on Jupiter server

Static vs dynamic websites

Role of HTML, CSS and PHP in dynamic websites

Overview and discussion of the three assessments

2

18th Feb

PHP syntax, variables, strings and echo

Creating basic PHP scripts using strings and variables 

 

3

25th Feb

PHP Arrays and loops. Display data using css styling

Creating associative arrays; displaying associative array content and using loops 

 

4

4th Mar

Forms. HTTP request methods POST and GET. Validation

Creating HTML forms and passing data using PHP request methods. Form data validation

 

5

11th Mar

Conditional statements - if and switch 

Include files

Making decisions - using PHP conditional statements. Incorporating include files in PHP scripts

Assessment 1- activity

6

18th Mar

Superglobal arrays ($_FILE) and self-posting forms

Creating self-posting forms and uploading image files

 

7

25th Mar

In class - Project Demonstrations

In class - Project Demonstrations

Assessment 1 submission

8

1st Apr

Introduction to object-oriented PHP. Database tables and fields. Connecting to a database

Creating classes and objects.

Creating database tables and fields. 

Connecting to a database via a PHP web page

 

9

8th Apr

Methods and scripts to select and display data from a database

SQL queries

Functions and methods to select and display data

Assessment 2 - activity

10

15th Apr

Methods and scripts to insert data into a database

Validation

Creating forms to collect user input

Writing scripts to insert data into database tables

Assessment 2 submission

(Friday 26 April – Easter break)

Break (Friday 19th April- Friday 26th April)

 

11

29th Apr

Updating data in a database

Validation

Writing scripts to modify data in database tables

 

12

6th May

Deleting data from a database

Writing scripts to delete data in database tables

User testing activity

  

13

13th May

Security - Login and session control

 

Writing scripts for user login and sessions

 

14

20th May

User testing class activity

User testing class activity

Project Work

Assessment 3 - activity

15

27th May

In class - Project Demonstrations

In class - Project Demonstrations

Assessment 3 submission

16

3rd Jun

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:

 

COSC7369C (ICTWEB501) - Build a dynamic website

COSC7372C (ICTDBS504) - Integrate database with a website

are clustered and therefore co-delivered and co-assessed holistically

Assessment Overview - Dynamic Website Project

You are required to design, build and test a dynamic website using a MySQL database and PHP object oriented scripting language. The dynamic website will be an e-commerce website – for a fictional or real business.

This website project is divided into 3 assessment tasks. Each assessment must be completed and submitted with no errors to be deemed competent for these clustered units. 

 

Your dynamic website project must be uploaded to the RMIT Jupiter and SQL servers for testing and demonstration (PHP / Project)

 

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 1 – Design Specifications and Prototype

 

Due: Week 7

 

This is the first stage of your dynamic website project.  You are required to read and analyse a project brief for a business website. You will then produce a design specifications document and create a working PHP prototype to show your plans for building the website   

 

Design Specifications Document

Write a design specification document based on the technical requirements and user needs specified in the project brief. The document must contain the following information.

  • Purpose of the website
  • Design Ideas
  • Data Storage
  • Functionality

 

Prototype – Web Programming Tasks

Produce a working PHP prototype showing the design and functionality of your proposed website.

  • Product Display Page (arrays & loops)
  • Product Details Page
  • Insert Form
  • Page displaying user-input from form
  • Image browse and upload to folder

 

Submission Instructions

 

Online Submission

  • Zip your project folder (all php and css files)
  • Save with the following name “yourfirstname_lastname_stage1.zip”
  • Upload to the submission drop box by Friday week 7

 

Demonstration

  • Ensure your project is fully functional on the RMIT Jupiter and SQL servers
  • You will demonstrate your working project to your teacher during class in week 7
  • You may be asked questions about your code during the demonstration

 

 

Assessment 2 – Dynamic Website Project – Part 1

 

Due: Week 10

 

This is the second stage of your dynamic website project. You are required to build a dynamic website to meet the technical requirements and design specifications explored in assessment 1. You will integrate a MySQL database and use PHP (object-oriented) scripting language to create the website. The website will be hosted on the RMIT Jupiter and SQL servers and undergo thorough testing.

 

Web Programming Tasks:

  • Create a database table with 5 genuine records
  • Write a script to connect to the database
  • Write a script to retrieve data from the database and display on a web page
  • Format the data so that it is displayed in the most effective way (html5, css)
  • Write a script to insert data into the database with user-supplied input from a form
  • Apply validation and error checking constructs
  • Create a navigation to link all website components 

Testing:

  • Test your website against the design specifications (functionality and user interfaces)
  • Document your testing

 

 

Submission Instructions

 

Online Submission

  • Ensure your project is fully functional on the RMIT Jupiter and SQL servers
  • Export your project database as an SQL file. Save into your project folder
  • Zip your project folder and testing documents
  • Save the zip file with the following name “yourfirstname_lastname_stage2.zip”
  • Upload to the submission drop box in week 10

 

 

Assessment 3 – Dynamic Website Project – part 2

 

Due: Week 15

               

This is the final stage of your dynamic website project. You task is to build more functionality and security into your dynamic website.

 

Web Programming Tasks:

  • Add additional records to your product tables (total of 9)
  • Write a script to update database records with user supplied input
  • Write a script to delete data from the database
  • Create a user table (database)
  • Write login and logout scripts
  • Build session functionality into the website

 

Testing:

  • Test your website against the design specifications (functionality and user interfaces)
  • Document your testing

 

Submission Instructions

 

Online Submission

  • Ensure your project is fully functional on the RMIT Jupiter and SQL servers
  • Export your project database as an SQL file. Save into your project folder
  • Zip your project folder and testing documents
  • Save the zip file with the following name “yourfirstname_lastname_stage3.zip”
  • Upload to the submission drop box in week 15 (after your demonstration)

 

Demonstration

  • Ensure your project is fully functional on the RMIT Jupiter and SQL servers
  • You will demonstrate the completed website project to your teacher during class in week 15
  • You may be asked questions about your code during the demonstration

 

 

 

 

 


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 1 - design specifications document and prototype

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 1 - design specifications document and prototype

Assessment 2 - dynamic website project – part 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 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 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 1 - design specifications document and prototype

Create a website, using efficient and effective code to meet the technical requirements, and test and document a website against the requirements.

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:

  • authentication and web security
  • hypertext transfer protocol (HTTP)
  • session management
  • stateless programming

Assessment 1 - design specifications document and prototype

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