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 |
Element: |
2. Retrieve data from database and display on web pages |
Performance Criteria: |
2.1 Retrieve data using structured query language (SQL) |
Element: |
3. Update database data from user input |
Performance Criteria: |
3.1 Update existing data stored in the database with user-supplied input |
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 |
|
Introduction to the Course including: |
|
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: |
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