Course Title: Integrate database with a website
Part B: Course Detail
Teaching Period: Term2 2017
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
Sarah Mackinnon
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 the 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 the database data from user input |
Performance Criteria: |
3.1 Update the 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.
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 (COSC7369C) ICTWEB501 Build a dynamic 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
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 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 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 (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