Assessor Resource

ICTDBS504
Integrate database with a website

Assessment tool

Version 1.0
Issue Date: April 2024


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.

No licensing, legislative or certification requirements apply to this unit at the time of publication.

You may want to include more information here about the target group and the purpose of the assessments (eg formative, summative, recognition)


Evidence Required

List the assessment methods to be used and the context and resources required for assessment. Copy and paste the relevant sections from the evidence guide below and then re-write these in plain English.

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Connect to the database

1.1 Identify site data needs from the technical requirements

1.2 Connect to the database from a web application using a web development language

2. Retrieve data from database and display on web pages

2.1 Retrieve data using structured query language (SQL)

2.2 Display the data in the most appropriate control

2.3 Format the data so that it is displayed in the most effective way

3. Update the database data from user input

3.1 Update the existing data stored in the database with user-supplied input

3.2 Insert the data in the database with user-supplied input

3.3 Delete the data stored in the database

3.4 Validate the data and check for errors

Evidence of the ability to:

access database using a web development language

retrieve and display web-based data

update web-based data.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

To complete the unit requirements safely and effectively, the individual 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.

Gather evidence to demonstrate 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.

Assessors must satisfy NVR/AQTF assessor requirements.

Submission Requirements

List each assessment task's title, type (eg project, observation/demonstration, essay, assingnment, checklist) and due date here

Assessment task 1: [title]      Due date:

(add new lines for each of the assessment tasks)

Assessment Tasks

Copy and paste from the following data to produce each assessment task. Write these in plain English and spell out how, when and where the task is to be carried out, under what conditions, and what resources are needed. Include guidelines about how well the candidate has to perform a task for it to be judged satisfactory.

ELEMENT

PERFORMANCE CRITERIA

Elements describe the essential outcomes.

Performance criteria describe the performance needed to demonstrate achievement of the element.

1. Connect to the database

1.1 Identify site data needs from the technical requirements

1.2 Connect to the database from a web application using a web development language

2. Retrieve data from database and display on web pages

2.1 Retrieve data using structured query language (SQL)

2.2 Display the data in the most appropriate control

2.3 Format the data so that it is displayed in the most effective way

3. Update the database data from user input

3.1 Update the existing data stored in the database with user-supplied input

3.2 Insert the data in the database with user-supplied input

3.3 Delete the data stored in the database

3.4 Validate the data and check for errors

Evidence of the ability to:

access database using a web development language

retrieve and display web-based data

update web-based data.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

To complete the unit requirements safely and effectively, the individual 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.

Gather evidence to demonstrate 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.

Assessors must satisfy NVR/AQTF assessor requirements.
Copy and paste from the following performance criteria to create an observation checklist for each task. When you have finished writing your assessment tool every one of these must have been addressed, preferably several times in a variety of contexts. To ensure this occurs download the assessment matrix for the unit; enter each assessment task as a column header and place check marks against each performance criteria that task addresses.

Observation Checklist

Tasks to be observed according to workplace/college/TAFE policy and procedures, relevant legislation and Codes of Practice Yes No Comments/feedback
Identify site data needs from the technical requirements 
Connect to the database from a web application using a web development language 
Retrieve data using structured query language (SQL) 
Display the data in the most appropriate control 
Format the data so that it is displayed in the most effective way 
Update the existing data stored in the database with user-supplied input 
Insert the data in the database with user-supplied input 
Delete the data stored in the database 
Validate the data and check for errors 

Forms

Assessment Cover Sheet

ICTDBS504 - Integrate database with a website
Assessment task 1: [title]

Student name:

Student ID:

I declare that the assessment tasks submitted for this unit are my own work.

Student signature:

Result: Competent Not yet competent

Feedback to student

 

 

 

 

 

 

 

 

Assessor name:

Signature:

Date:

Assessment Record Sheet

ICTDBS504 - Integrate database with a website

Student name:

Student ID:

Assessment task 1: [title] Result: Competent Not yet competent

(add lines for each task)

Feedback to student:

 

 

 

 

 

 

 

 

Overall assessment result: Competent Not yet competent

Assessor name:

Signature:

Date:

Student signature:

Date: