Course Title: Build a dynamic website

Part B: Course Detail

Teaching Period: Term2 2017

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

 

Catherine Han Lin

+61 3 9925 1336

han.lin@rmit.edu.au

Deepani Guruge

deepani.guruge@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 including self-paced and collaborative classroom based activities.

The self-paced activities will include your contribution to reflective journals and project work.

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.


Teaching Schedule

This course is co-delivered and co-assessed holistically along with (COSC7372C) ICTDBS504 Integrate database with a website.

 

The Teaching Schedule for this course is as follows:

 

Induction Session

Prior to training commencement a program level induction session will be conducted that comprises the following:

  • Program overview and requirements
  • MyRMIT/Blackboard
  • Overview of assessment requirements
  • Pre-Training Review including:
    • Recognition of Prior Learning and Credit Transfers
    • Assessment of current skills and knowledge
  • Competency/Grading Criteria
  • Plagiarism
  • Appeals
  • Extensions
  • Feedback
  • Privacy
  • Submission requirements
  • Resubmission policy
  • Where to get support
  • Student responsibilities

 

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 Commencing

Topics

Assessment

Competencies Delivered

1

03/07/2017

 

Introduction to the Course including:

·         Course requirements

·         Course support documents

·         Course Blackboard access

·         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 & Internet Server setup

Create blog for assessment 1

  Assessment 1 – blog handout

 

ICTWEB501 ICTDBS504

2

10/07/2017

PHP syntax (echo, strings, variables, global variables); PHP & HTML

Assessment 2 – dynamic website specification issued

ICTWEB501 ICTDBS504

3

17/07/2017

PHP concepts

(if else, conditional statements, loops)

 

ICTWEB501 ICTDBS504

4

24/07/2017

PHP concepts

(arrays, forms, post & get)

 

ICTWEB501 ICTDBS504

5

31/07/2017

PHP concepts

(sessions, image files)

Assessment 1– progress check

Assessment 2 – (part 1) due

ICTWEB501 ICTDBS504

6

07/08/2017

PHP & database connectivity

SQL: select, search

 

 

ICTWEB501 ICTDBS504

7

14/08/2017

PHP concepts (validation & sanitation)

SQL: insert

PHP & database connectivity

 

ICTWEB501 ICTDBS504

8

21/08/2017

Individual project work (assessment 2)

Assessment 1– progress check

Assessment 2 (part 2) due

ICTWEB501 ICTDBS504

Term Break, 28 Aug - 1 Sept, 2017 inclusive

9

04/09/2017

SQL: update

PHP & database connectivity

 

ICTWEB501 ICTDBS504

10

11/09/2017

SQL: delete

PHP & database connectivity

 

ICTWEB501 ICTDBS504

11

18/09/2017

PHP login with sessions

 

ICTWEB501 ICTDBS504

12

25/09/2017

Individual project work (assessment 2)

 

ICTWEB501 ICTDBS504

13

02/10/2017

Individual project work (assessment 2)

Assessment  2 (part 3) due

ICTWEB501 ICTDBS504

14

09/10/2017

SQL: security

PHP prepared statements

Assessment 1 due

ICTWEB501 ICTDBS504

15

16/10/2017

 

Assessment  2 (part 4) due

ICTWEB501 ICTDBS504

16

23/10/2017

Interview or re-submission if required

Re-submission if required

ICTWEB501 ICTDBS504


Learning Resources

Prescribed Texts


References


Other Resources

There is no prescribed text book for this course.

Materials will include articles, web links and worksheets, which will be made available through the Blackboard portal.


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

There are 2 main assessment tasks in this course (Blog Posts, and a Web Project consisting of 4 sub-Tasks). You must successfully complete all assessment tasks including all sub-tasks to be deemed competent in this unit.

 

ASSESSMENT TASK 1: Maintain a blog of PHP & SQL concepts (Due: weekly)

 

In this assessment you are required to maintain a blog of programming (PHP) and database (SQL) concepts required to create dynamic websites

 

  • In week 1, you will set up a PHP blog website on RMIT’s Jupiter and SQL servers
  • Each week you are required to post explanations and examples of the PHP code and concepts discussed in class.
  • Specific details of the required posts will be available on the learning hub (Blackboard) on a weekly basis
  • Your posts will be monitored by your teacher throughout the semester and you may be asked to personally discuss / explain your posts during class

 

 Submission Instructions (Week 14)

  • Enter your details (Student name and number) in the assessment cover sheet 
  • Export your blog tables (completed weekly posts) as an SQL file
  • Save your SQL file with the following name “yourlastname_firstname.sql
  • Submit both files as a zipped archive (.zip) through Blackboard. Name your zip archive with your name

 

 ASSESSMENT TASK 2 - Dynamic WebsiteProject

This assessment task requires you to design, build and test a dynamic website on a theme of your choice.

The completed website will need to demonstrate the following:

  • Connection to a MySQL database (multiple tables)
  • The use of PHP & SQL to search, select, insert, update and delete records
  • Validation and sanitization of data (security issues)
  • Session-based user login
  • HTML5 structure with a clear navigation (include files)
  • CSS3 styling
  • Thorough testing in a variety of browsers and platforms

 

There are fourparts to this project. Refer to the sub-tasks below for description and due dates.

 

ASSESSMENT TASK 2.1: Design brief for dynamic website (Due: Week 5)

 

This is the first part of your dynamic website project. Before you start your project, you are required to create a Word document outlining the purpose, theme and functionality of the website.

 The Word document must include:

  • the purpose/theme (business) of your website
  • a storyboard showing your design for an input form
  • a storyboard showing your design for a display page
  • the proposed database structure (table types and fields)
  • a working prototype for a PHP/HTML form showing the required user input fields (form.php)

 

Submission Instructions

  • Enter your details (Student name and number) in the assessment cover sheet 
  • Save your Word file with the following name “sql
  • Submit both files (form.php and Word document & coversheet) as a zipped archive (.zip) through Blackboard. Name your zip archive with your name

 

ASSESSMENT TASK 2.2: Dynamic Website (Due: Week 8)

 

This is the second part of your dynamic website project. Your task is to begin creating your website. The focus is on building the PHP, SQL, HTML and CSS structure for the insert form, display page and search bar.

 

You will need to complete the following tasks:

  • create a project folder on your localhost server (XAMPP/htdocs) – project1
  • create a database with at least one table (containing at least 5 records) - PHPMyAdmin
  • create a connection to the MySQL database
  • create web pages (using PHP, SQL and HTML) to display, search and insert database records
  • create include files for the required HTML components - head, navigation and footer
  • apply CSS for page layout and design

Testing tasks:

  • Create a folder on the Jupiter server named project1 and upload your project files
  • Modify the connection file to point to the SQL server
  • Import your PHPMyAdmin database to the RMIT SQL server
  • Test the functionality of your web pages in a variety of browsers
  • Document your testing in a Word document

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.

 

Submission Instructions

  • Enter your details (Student name and number) in the assessment cover sheet 
  • Export your project database as an SQL file. Save into your project folder
  • Zip your project folder (XAMPP) and save with the following name “yourlastname_firstname_website1.zip”
  • Submit all files (cover sheet, testing document and website1 project zip) as a zipped archive (.zip) through Blackboard. Name your zip archive with your name
  • Ensure there is a working version of your files on the RMIT Jupiter server

 

ASSESSMENT TASK 2.3: Dynamic Website (Due: Week 13)

 

This is the third part of your dynamic website project. Your task is to add additional features to your dynamic website. The focus is now on completing the required functionality. You will need to create the following features for your project

  • update, delete and login (session) functionality
  • validation and security
  • insert 3 more genuine database records (total of 8 project records)

 

Additional functionality (optional but recommended)

  •  the ability for users to comment on posts
  • registration for users and/or password security (encryption)
  • navigation based on login and sessions

Testing Tasks

Create a folder on the Jupiter server named project2 and upload your project files

  • Ensure the connection file to points to the SQL server
  • Import your updated PHPMyAdmin database to the RMIT SQL server
  • Test the functionality of your web pages in a variety of browsers
  • Document your testing in a Word document

 

Submission Instructions

  • Enter your details (Student name and number) in the assessment cover sheet 
  • Export your project database as an SQL file. Save into your project folder
  • Zip your project2 folder (XAMPP) and save with the following name “yourlastname_firstname_website1.zip”
  • Submit all files (cover sheet, testing document and website1 project zip) as a zipped archive (.zip) through Blackboard. Name your zip archive with your name
  • Ensure there is a working version of your files on the RMIT Jupiter server

 

ASSESSMENT TASK 2.4: Dynamic Website (SQL prepared statements) (Due: Week 15)

 

This is the final part of your dynamic website project. Your task is to add greater security to your website by using SQL prepared statements when inserting into or updating database tables.

You will need to do the following:

  • Create a new connection using object oriented syntax
  • Re-write one of your insert scripts using prepared statements
  • Create a folder on the Jupiter server named project3 and upload your modified files
  • Test the functionality of your web pages in a variety of browsers

 

Submission Instructions

  • Enter your details (Student name and number) in the assessment cover sheet 
  • Zip your PHP files (XAMPP) and save with the following name “yourlastname_firstname_website3.zip”
  • Submit both files (cover sheet and website project zip) as a zipped archive (.zip) through Blackboard. Name your zip archive with your name
  • Ensure there is a working version of your files on the RMIT Jupiter server

 

 Late submissions of the project will be eligible for grading at CAG (Competency Achieved) level only.

 

Submission Requirements

You should:

  • 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.  An assignment cover sheet for submission of each assessment task is available on blackboard.
  • Each page of your assessment should include footer with your name, student number, the title of the assessment, unit code and title and page numbers. For example, Julie Macpherson, 324567, Task 2, OHS2345C Ensure safe workplace, Page 1 of 10.

 

Late Submission Procedures

You are required to submit assessment items and/or ensure performance based assessment is completed by the due dates.

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 Informationhttp://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 Grades 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

The Assessment Matrix that maps all assessments to the critical aspects of evidence, skills, knowledge and elements is available from the teacher.

Course Overview: Access Course Overview