Course Title: Integrate database with a website

Part B: Course Detail

Teaching Period: Term2 2016

Course Code: COSC7372C

Course Title: Integrate database with a 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

 

Course Contact

Catherine Han Lin

Course Contact Phone

+61 3 9925 1336

Course Contact Email

han.lin@rmit.edu.au

Nominal Hours: 25

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 ensure the database is integrated with a website.

It applies to individuals employed as web developers who are responsible for creating data-driven web applications.


National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

ICTDBS504 Integrate database with a website

Element:

1. Connect to the database

Performance Criteria:

1.1 Identify site data needs from technical requirements 1.2 Connect to database from web application using a web development language

Element:

2. Retrieve data from database and display on web pages

Performance Criteria:

2.1 Retrieve data using structured query language (SQL) 2.2 Display data in the most appropriate control 2.3 Format data so that it is displayed in the most effective way

Element:

3. Update the database data from user input

Performance Criteria:

3.1 Update existing data stored in the database with user-supplied input 3.2 Insert data in the database with user-supplied input 3.3 Delete data stored in the database 3.4 Include error checking and validation

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 wikis and discussion threads, reflective journals, quizzes and 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.


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:

o   Recognition of Prior Learning and Credit Transfers

o   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

04/07/16

 

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

Virtual server setup (wampserver, mamp or xampp) and Internet server setup (000webhost)

 

ICTWEB501 ICTDBS504

2

11/07/16

Review how PHP & servers operate

Introduction to PHP

 

ICTWEB501 ICTDBS504

3

18/07/16

PHP concepts

Review SQL

Assessment 1 – individual project specification issued

ICTWEB501 ICTDBS504

4

25/07/16

PHP concepts

Review SQL

 

ICTWEB501 ICTDBS504

5

01/08/16

PHP concepts

Review SQL

PHP & database connectivity

Assessment 1– individual project (database) due

ICTWEB501 ICTDBS504

6

08/08/16

PHP concepts

SQL: select

PHP & database connectivity

 

ICTWEB501 ICTDBS504

7

15/08/16

HTML,CSS, PHP, Database

SQL: select, insert

Individual project work (assessment 1)

 

ICTWEB501 ICTDBS504

8

22/08/16

HTML,CSS, PHP, Database

SQL: select, insert, update

Individual project work (assessment 1)

Assessment 1– individual project draft check (website)

ICTWEB501 ICTDBS504

Term Break 29th August to 2nd September, 2016 inclusive

9

05/09/16

HTML,CSS, PHP, Database

SQL: select, insert, update, delete

Individual project work (assessment 1)

Assessment 2 – group project specification issued

ICTWEB501 ICTDBS504

10

12/09/16

Individual project presentations & interviews

 

ICTWEB501 ICTDBS504

11

19/09/16

HTML,CSS, PHP, Database

SQL: select, insert, update, delete

Group project work (assessment 2)

Assessment 1– individual project due

 

ICTWEB501 ICTDBS504

12

26/09/16

PHP concepts - sessions.

Assessment 1 – individual project interviews

ICTWEB501 ICTDBS504

13

03/10/16

PHP – OO approach

Assessment 2 – group project draft check

ICTWEB501 ICTDBS504

14

10/10/16

PHP – OO approach

Group project work (assessment 2)

Assessment 2 – Group Project Due

ICTWEB501 ICTDBS504

15

17/10/16

Group project interview

Assessment 2 – Group interview

ICTWEB501 ICTDBS504

16

24/10/16

Course & assessment feedback. Re-submission of work if required

 

ICTWEB501 ICTDBS504


Learning Resources

Prescribed Texts


References


Other Resources

 

There is no prescribed text book for this course. However the following book is recommended for references:

PHP and MySQL Web Development (5th Edition) (Developer's Library) 5th Edition. By Luke Welling and Laura Thomson

ISBN-13: 978-0321833891

ISBN-10: 0321833899

 

Other materials will include worksheets distributed by the teacher in class and various Websites 


Overview of Assessment

In order to achieve competency in this unit, you must provide:

Performance Evidence

 Evidence of the ability to:

  • access database using a web development language
  • retrieve and display web-based data
  • update web-based data.

Knowledge Evidence

To complete the unit requirements safely and effectively, you must:

  • describe a database structure
  • outline internet technology as it relates to the use of databases
  • identify and apply programming control structures, including object-oriented programming and structured query language (SQL)
  • explain web programming concepts, including:
  • authentication and web security
  • hypertext transfer protocol (HTTP)
  • session management
  • defining the principles of 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 database field of work, and include access to:

  • equipment
  • industry software packages
  • the requirements documentation
  • a web server
  • a database
  • the web development environment
  • 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 assessment tasks in this course. You must complete all assessment tasks to be deemed competent in this course.

 

Assessment 1 - Individual Dynamic Website (Due date: Refer to Teaching Schedule)

 

For this assessment task you are required to develop a dynamic website on a theme of your choice.

  • The website will need to connect to a MySQL database consisting of at least one table and demonstrate searching, selecting, inserting, updating and deleting database records using PHP procedural code. 
  • All data inserted into the database via an HTML form will need to be validated using client-side script (JavaScript).
  • The completed website should be formatted and styled using HTML and CSS and contain a clear navigation.
  • Prior to submission, the website must be thoroughly tested in a variety of browsers and uploaded to a hosting server on the Internet.
  • A testing document outlining browsers and platforms used for testing is be submitted with the completed project

 

All students are required to attend an interview with the teacher where they will demonstrate their project and answer questions about the code

 

 

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

 

 

Assessment 2 - Group Project (dynamic website) (Due date: Refer to Teaching Schedule)

 

For this assessment task you are required to form in groups and develop a dynamic website for a business / organization.

  • This assessment should be completed using the Object-Oriented approach.
  • The website will require user registration and login and could include one of the features such as blogs, forums, reviews or other observed on the Internet.
  • The website will need to connect to a MySQL database consisting of multiple tables and demonstrate basic SQL query to the database records.
  • You will be expected to demonstrate data validation using client-side script or server-side script.
  • The navigation should be based on login and distinguish between administration and user requirements
  • The completed website should be formatted and styled using HTML and CSS.

 

Prior to submission, the website must be thoroughly tested in a variety of browsers and uploaded to a hosting server on the Internet.

A testing document outlining browsers and platforms used for testing must be submitted with the completed project

All students are required to attend an interview with the teacher where they will demonstrate their project and answer questions about the code

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


Assessment Matrix

Course Overview: Access Course Overview