Course Title: Integrate database with a website

Part B: Course Detail

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

Sarah MacKinnon
Sarah.mackinnon@rmit.edu.au

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 (COSC6121C) ICADBS504A 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

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


 06/07/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)
 

 

 

 

 

 

 

 

ICAWEB502A
ICADBS504A

2

13/07/15 Review how PHP & servers operate
Introduction to PHP
 Assessment 1 – individual project specification issued ICAWEB502A
ICADBS504A

3

20/07/15 PHP concepts   ICAWEB502A
ICADBS504A

4

27/07/15

PHP concepts

  ICAWEB502A
ICADBS504A

5

03/08/15 PHP concepts
PHP & database connectivity
Review SQL
 
 Assessment 2 – group project specification issued ICAWEB502A
ICADBS504A

6

10/08/15

PHP concepts
PHP & database connectivity
Review SQL
 
  ICAWEB502A
ICADBS504A
7  17/08/15 HTML,CSS, PHP & Database
Include files and functions
SQL: select, insert
Javascript validation of form data & PHP
  ICAWEB502A
ICADBS504A
8 24/08/15 HTML,CSS, PHP & Database
Include files and functions
SQL: select, insert
Javascript validation of form data & PHP
 Assessment 1– individual project (database) due ICAWEB502A
ICADBS504A
                                 Semester break 31st Aug to 4th Sep, 2015 inclusive
9 07/09/15 HTML,CSS, PHP & Database
Include files and functions
SQL: select, insert, update
Javascript validation of form data & PHP
 Assessment 1– individual project draft check (website) ICAWEB502A
ICADBS504A
10

14/09/15

Individual project work (assessment 1)  Assessment 1– individual project due ICAWEB502A
ICADBS504A
11 21/09/15 Individual project presentations & interviews Assessment 1 – individual project, teacher / student project interviews ICAWEB502A
ICADBS504A
12 28/09/15

PHP concepts - sessions.

  ICAWEB502A
ICADBS504A
13

05/10/15

PHP concepts - OO approach   ICAWEB502A
ICADBS504A

14

12/10/15 Group project work  Assessment 2 – group project draft check ICAWEB502A
ICADBS504A

15

 19/10/15

Group project work  Assessment 2 – Group Project Due ICAWEB502A
ICADBS504A
16 26/10/15 Teacher student interviews.
Course & assessment feedback. Re-submission of work if required
Assessment 2 – 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 (COSC6121C) ICADBS504A Integrate database with a website.

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:

• Produce dynamic web pages that include both client and server-side dynamic content
• Create efficient and effective code to meet technical requirements.

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 (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 2 - Group Project (dynamic website) (Due date: Refer to Teaching Schedule)

For this assessment task you are required to form groups of 2 and develop a dynamic website for a business / organization.
• 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