Course Title: Integrate database with a website

Part B: Course Detail

Teaching Period: Term1 2015

Course Code: COSC6121C

Course Title: Integrate database with a website

School: 650T Vocational Business Education

Campus: City Campus

Program: C5300 - Diploma of Information Technology

Course Contact : Swati Dave

Course Contact Phone: +61 3 9925 5811

Course Contact Email:swati.dave@rmit.edu.au


Name and Contact Details of All Other Relevant Staff

Name: Catherine Han Lin

Contact: catherinehan.lin@rmit.edu.au

Phone: +61 3 9925 1336


Consultation Time: Available from the teacher on first day of class

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 performance outcomes, skills and knowledge required to ensure database is integrated with a website.


National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

ICADBS504A Integrate database with a website

Element:

1. Connect to 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 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.

Learning activities will include laboratory-based sessions on a variety of topics as shown in the weekly breakdown. Learning activities will generally consist of practical computer exercises based on teacher handouts. Students should attend all sessions.

Students will also be expected to undertake work on a variety of activities for homework.

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 (COSC6120C) ICAWEB502A Create Dynamic Websites

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

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 Commencing Topics Assessment Competencies Delivered

1


 09/02/15

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)
Creation of database with one table

Assessment 1 class exercises details issued
Assessment 2 – individual project handed out
 
ICAWEB502A
ICADBS504A

2

16/02/15 Review how PHP & servers operate
Introduction to PHP variables & constants
HTML forms – sending information using POST; displaying $_POST variables
HTML hyperlinks – sending information using GET; displaying $_GET variables
  ICAWEB502A
ICADBS504A

3

23/02/15 Review PHP variables and constants
Introduction to PHP arrays (basic syntax and function)
PHP operators. Exercises on selection & loops using forms. Introduction to conditional statements (if, case)
  ICAWEB502A
ICADBS504A

4

02/03/15

Review arrays & conditional statements
More PHP arrays including associative arrays & 2-D arrays
Introduction to functions

  ICAWEB502A
ICADBS504A

5

09/03/15
Mon 9/03/15 – Labour Day PH 
More PHP functions including function declarations, arguments, returns & calls.
Pre-defined functions (date)
User-defined functions (calculations)
Introduction to PHP string functions
  ICAWEB502A
ICADBS504A

6

16/03/15

PHP database connectivity. MySQL select statements
Displaying one table record
Using a loop to display multiple table records
Search for a record to display
  ICAWEB502A
ICADBS504A
7  23/03/15 Review how server, HTML,PHP & databases work together
Introduction to include files
Inserting data into a table using a form and PHP insert script
Creating a form to collect data to insert
Javascript validation of form data & PHP string functions
MySQL insert statements
 Assessment 1 (Class Exercises) Due  – Class exercises completed and uploaded to Internet Server ICAWEB502A
ICADBS504A
8a 30/03/15 Review MySQL insert, form validation & include files
Deleting records from a database using MySQL delete statements
Delete confirmation
  ICAWEB502A
ICADBS504A
                                 Easter break Thurs 2nd April to Wed 8th April, 2014 inclusive 
8b

Thurs 9/04/2015

Thurs 9/04 & Fri 10/04

Review MySQL insert, form validation & include files
Deleting records from a database using MySQL delete statements
Delete confirmation

Self Paced Online activities

  ICAWEB502A
ICADBS504A
9 13/04/15 Search and select options
Updating table records using a form and PHP insert script
  ICAWEB502A
ICADBS504A
10

20/04/15

Individual project work (assessment 2)   ICAWEB502A
ICADBS504A
11 27/04/15 Individual project presentations & interviews Assessment 2 – individual project due
Teacher / student project interviews

 Assessment 3 – group project handed out
ICAWEB502A
ICADBS504A
12 04/05/15

Login security using session variables.

Group Project work ICAWEB502A
ICADBS504A
13

11/05/15

Group project work   ICAWEB502A
ICADBS504A

14

18/05/15 Group project work   ICAWEB502A
ICADBS504A

15

 25/05/15

Group project work  Assessment 3 – group project due ICAWEB502A
ICADBS504A
16 01/06/15 Teacher student interviews.
Course & assessment feedback. Re-submission of work if required
 
Assessment 3 – teacher / student group interviews ICAWEB502A
ICADBS504A

You will receive feedback two weeks from the due date of each task. If required, resubmissions are due by the end of the following week.


Learning Resources

Prescribed Texts


References

There is no prescribed text book for this course. However the following book is recommended for references:
Welling, L & Thomson, L, 4th Edition (2009), PHP and MySQL Web Development, Pearson Education, ISBN-13: 978-0672329166

978-067232916


Other Resources

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


Overview of Assessment

Students must demonstrate an understanding of all elements of competency to be deemed competent.

A range of assessment methods are used to assess practical skills and knowledge, for example:

  • direct questioning combined with review of portfolios of evidence
  • demonstration of techniques
  • evaluation of a web application created to access, display and update data stored in a database
  • verbal or written questioning to ensure knowledge of the impact of data-driven web applications.

Students are advised that they are likely to be asked to personally demonstrate their assessment work to their teacher to ensure that the relevant module standards are being met.


Assessment Tasks

Overview of Assessment

This course is co-delivered and co-assessed holistically along with (COSC6120C) ICAWEB502A Create dynamic web pages.

Students must demonstrate an understanding of all elements of competency to be deemed competent.

A range of assessment methods are used to assess practical skills and knowledge, for example:
• direct questioning combined with review of portfolios of evidence and third party workplace reports of on-the-job performance by the candidate
• review of authenticated documents from the workplace or training environment
• demonstration of techniques

Critical aspects of assessment

Evidence of the following is essential:

• Create a web application which accesses a database, displaying and modifying the database data provided by user input.

Assessment Tasks

There are 3 assessment tasks in this course.
You must complete all 3 assessment tasks to be deemed competent in this course.

Assessment 1 – Class Exercises
(Submission Due Dates: Week 7)

For this assessment task you are required to complete a 6 class exercises demonstrating skills in writing PHP scripts and database-driven web pages.  The required exercises will need to be uploaded to a web-hosting server on the Internet

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

Assessment 2 - Individual Dynamic Website
(Submission Due Date: Week 11)

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 (week 11) 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 3 - Group Project (dynamic website)
(Due Date: Week 15)

For this assessment task you are required to form groups of 2 and develop a dynamic website for a business / organization of your choice.
• The website will require user registration and login and could include features such as blogs, forums, shopping carts, reviews or other features observed on the Internet.
• The website will need to connect to a MySQL database consisting of multiple tables and demonstrate searching, selecting, inserting, updating and deleting 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 commencement of your project, a project requirements document needs to be completed. This should include:
• A description of the theme, features and functions of your Website.
• Research of similar websites on the internet – screen captures of forms, layout & content.
• Storyboards & flow charts illustrating proposed design & functionality

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 (week 16) 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

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

Other Information

Submission Requirements

All Assessment tasks need to be submitted via the Learning Hub.

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 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
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. 

 Final Grades Table:
After achieving competency we then grade your performance in the unit and you will achieve one of the following grades:
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