Reference no: EM131248291

Part -1:

Assessment Instructions

- To achieve a Competent result, each student is required to achieve a Satisfactory outcome in each marking criteria of this assessment.

- Student is required to redo the assessment in class, if outcome is Not Yet Competent due to being Not Satisfactory against any marking criteria of the given assessment.

- Plagiarism is strictly forbidden. Nil marks will be provided for plagiarism for all involved.

- Students may be asked to explain their assessment work on a regular interval to the assessor to ensure that the relevant competency standards are being met.

- The Assessor is required to the students explain the assessment instructions and required outcome before conducting assessment in class.

- The Assessor is required to record the result (Competent/Not Yet Competent) of the assessment task into the Marking Excel Sheet in accordance with the marking criteria of the assessment tasks for the student and enter the final results into RTO Manager System of the Kent Institute Australia.

- The Assessor is required to record the re-assessment result into the Marking Excel sheet in accordance with the marking criteria of the re-assessment tasks for the student and enter the final results into RTO Manager System of the Kent Institute Australia.

- The Assessor must check the student's work on each Assessment Day and provide on-going feedback to the student in class.

This following Assessment is designed to assess your competency in the following competency units:

ICTWEB501 - Build a dynamic website

1. Define and analyse the technical requirements

1.1 Identify the business requirements and appropriate standards
1.2 Determine and document, the purpose, expectations and functionality of the website
1.3 Analyse the user-interface design requirements, including user needs, design principles and operating systems

2. Produce the software design specifications
2.1 Produce a hierarchy of the website showing navigation
2.2 Ensure that the content is logical and accessible to the user
2.3 Produce the prototype of the user interface
2.4 Determine and document, the architectural requirements
2.5 Design the data storage requirements

3. Develop the website to the specified design
3.1 Create the software components of the website
3.2 Test the components of the website
3.3 Integrate the components to produce the web application
4. Test the web application
4.1 Test the website against the requirements
4.2 Complete and document the design structure
4.3 Obtain client feedback and adjust web applications as appropriate

1. Determine database requirements
1.1 Meet with the client, and conduct a user-needs analysis, to determine database functionality
1.2 Analyse the results of a user-needs analysis to identify technical requirements
1.3 Develop a conceptual model of the database
1.4 Submit the conceptual model to the client for review
1.5 Evaluate client feedback and make changes as required

2. Develop a logical data model
2.1 Identify the attributes and determine the data types
2.2 Undertake the normalisation of attributes
2.3 Develop an entity-relationship (ER) diagram in order to clarify the cardinality of relationships
2.4 Document attributes, normalised data, and the ER diagram
2.5 Forward documentation to the client for confirmation

3. Design the data structures
3.1 Confirm primary and foreign keys for tables
3.2 Review client business rules
3.3 Identify the referential integrity constraints
3.4 Establish database management system constraints and incorporate into database design
3.5 Develop the validation rules for data
3.6 Design indexes and develop the data dictionary
3.7 Document the database design

4. Design queries, screens and reports
4.1 Design the user interface for database, including menus, input screens and outputs
4.2 Design queries, based on requirements
4.3 Design output reports, based on requirements
4.4 Compare the physical design with the conceptual model, or user-needs analysis
4.5 Incorporate changes as required

5. Design access and security systems
5.1 Review the business security plan as a basis for commencing the access and security design
5.2 Design the password and access system for the database
5.3 Identify multiple-user requirements
5.4 Develop client access profiles using the client business model
6. Confirm the database design
6.1 Identify the database backup and recovery requirements
6.2 Develop and document the database backup and restore procedures
6.3 Submit the database, and documentation, to the client for final approval

Integrate database with a website
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

Overview

Bazaar Ceramics business growth is outstanding; they have engaged new staff, surpassed targeted sales growth and international demand for the product is growing daily.

Bazaar Ceramics are seeking to develop a dynamic website and shopping cart that enables new and existing customers to select products for purchase. A web presence will enable them to showcase their wares, increase sales and enable feedback from potential customers.

You have been asked to develop their dynamic website and shopping cart. The project will be implemented over a number of assessments.

The Client
The owner of the company - Kim Hayward - has become increasingly aware of the importance of the Internet as a marketing and sales tool.

Many of their competitors and industry partners now have websites and Kim has decided that in order not to be left behind, the company must develop a web presence.

The Brief

Your task is to review the requirements document to develop an understanding of the dynamic website and shopping cart and then design and develop based on these requirements.

Assessment Requirements

At the completion of this assessment of the project, you must submit the following items.

1. Technology report for Dynamic Website and Shopping Cart
To implement an online catalogue and ordering system you will be using PHP and MySQL. You are required to write a technology report on PHP and MySQL. You should:
- Search the Internet (try https://www.php.net/ and https://www.mysql.com) for information on PHP and MySQL.
- Write a report detailing the hardware and software requirements of these technologies.
- Include in the report any issues that will need to be considered when designing for the e-commerce to the dynamic website.

2. Design documentation and Prototype for Dynamic website and Shopping Cart

Dynamic website Design Documentation

You are required to write a brief summary of the requirements for the Bazaar Ceramics dynamic website.

You should:

- Review the Requirements document. A requirements document was created in Assessment two (Business requirements) and Assessment three (Technical requirements) of the project. Your teacher will give you details of where to find the requirements document.
- Write a brief summary of the website requirements using the requirements summary template.
- You are required to investigate design alternatives for the website and develop a report explaining the reasons for the choices you have made for the design of the website. You should:
- Investigate what type of metaphor would be appropriate for your website (e.g. organisational, functional, or hybrid). Write a brief report (half a page) detailing your choice and the reasons for your decision.
- Develop a detailed navigation map based on the metaphor you have chosen for your website. The navigation map should show all the pages that you intend to develop on your website. These pages must be numbered.
- Write a design report using the design report template

Shopping Cart Design Documentation
- Create a navigation map and mockup of the shopping cart pages. For example what will the pages look like for the online catalogue and ordering system?

Dynamic Website and Shopping Cart Prototype
- Choose your authoring tool (this can be a simple HTML editor) or a commercial application such as Dreamweaver or Front page.
- Create a prototype to test the navigation (menu) system. You will need to create some top level "prototype" pages to test the menu.
- Test to ensure the menu system works correctly and that pages display correctly.
- Create the pages and HTML forms required for the shopping cart.

- Create multimedia elements for these pages (discuss this with your assessor).

For example you could create:

- A banner using scrolling text.

- An image map which displays explanatory text as the mouse rolls over different parts of the image.

- A short slide show sequence using images from the Bazaar Ceramics collection.

- Get approval of Prototype from the client using client requirements check list sign-off document template

3. Developing the dynamic website and shopping cart

You are required to develop a Dynamic Website and Shopping Cart

1) Database requirements report

You are required to write a report which identifies the database requirements of the e-commerce enhancements to the Bazaar Ceramics website. You should:

- Review the project specifications

- Write a database requirements report listing the type of data and the size of the fields required for the database tables described in the specifications.

- Modify your database tables in consultation with the supervisor.

- You are required to create the database to match the tables in the database requirements report.

2) Security policy
You are required to develop a naming convention and password policy for security to the database.

3) Dynamic Website and shopping cart

You are required to test the development environment organised at Kent Institute.

Organise access to a server at Kent Institute. Check with your assessor about what method should be used for this. Create a test web page and load it onto the server.

Develop a dynamic website and shopping cart based on the prototype developed. Ensure that you include:

- Facility for customers to add their name to a mailing list

- Facility for customers to fill out an order form

- You are required to setup and test a database connection to your web server.

- You should: Install and configure PHP and MySQL (Both are pre-installed an pre-configured at Kent Institute)

- Create a PHP script to open a database connection to the database server

- Test the connection by querying the "test" database

- You are required to implement the e-commerce functions in the prototype specifications document.

- Include PHP scripting language and MySQLQuery as per required in the prototype files.

- Test to ensure the dynamic website pages and shopping cart pages work correctly and that pages display correctly. Record the test result into Test result document

- Review Test Result document to fixed the bugs and submit bug free Dynamic Website and Shopping Cart.

Part -2:

This following Assessment is designed to assess your competency in the following competency units:

1. Determine audit criteria
1.1 Investigate the system or product for which the quality audit is being performed to understand its functionality
1.2 Determine the objectives to be achieved by the quality audit
1.3 Determine the scope of the quality audit
1.4 Develop a list of audit criteria and quality benchmarks
1.5 Develop a metric to classify the audit criteria
1.6 Determine the audit technique or methodology to be followed
1.7 Examine and detail the resources available to carry out the audit
1.8 Document the objectives, scope, criteria, technique and resources in an audit plan

2. Audit aspects of the final system
2.1 Use the audit criteria to collect evidence about the functionality and quality of the final system, including documentation
2.2 Use a checklist to monitor audit progress
2.3 Document audit outcomes as the audit progresses

3. Review and confirm contract and specifications
3.1 Review system contract against audit outcomes
3.2 Compare system functionality against audit outcomes and system contract
3.3 Identify items of non compliance where audit outcomes do not meet performance targets or fall short of contract requirements
3.4 Review system procedures for corrective action
3.5 Document items of non-compliance and proposed corrective action

Overview

Bazaar Ceramics business growth is outstanding; they have engaged new staff, surpassed targeted sales growth and international demand for the product is growing daily.

Bazaar Ceramics are seeking to develop a dynamic website and shopping cart that enables new and existing customers to select products for purchase. A web presence will enable them to showcase their wares, increase sales and enable feedback from potential customers.

You have been asked to develop their dynamic website and shopping cart. The project will be implemented over a number of assessments.

The Client
The owner of the company - Kim Hayward - has become increasingly aware of the importance of the Internet as a marketing and sales tool.

Many of their competitors and industry partners now have websites and Kim has decided that in order not to be left behind, the company must develop a web presence.

The Brief
The Bazaar Ceramics dynamic website and shopping cart has been developed and we are now required to conduct an audit of the dynamic website and shopping cart to ensure it matches the requirements.

You are required to audit the dynamic website and shopping cart. You will need to access the functional requirements, website design and shopping cart design and also technical specifications in order to find out what the system was meant to do.

You will need to select audit criteria from these documents and develop an audit plan. You will then need to check the work performed against what was intended to be done.

Requirements

At the completion of this assessment of the project, you must submit the items shown on the right.

1. Audit plan

You need to develop an audit plan for Dynamic Website and Shopping Cart. You should:

Check with your teacher for guidance on the audit objective, scope and number of audit criteria to be tested.
Develop your audit plan using the Audit plan template

2. Audit Test worksheet
You need to develop a test worksheet Dynamic Website and Shopping Cart to identify the way that you will test the audit criteria. The test worksheet will be used to document the tests performed. You should:
Check with your teacher for guidance on the number of tests per audit criteria.
Develop the test worksheet using the Audit Test worksheet template

3. Audit Test report including completed Audit Test worksheet
You are required to perform the audit of the Bazaar Ceramics Dynamic website and Shopping Cart and also record the results. You should:
Check with your teacher regarding the system that you will audit.

Perform the audit
Record the test results in the Audit Test Worksheet.
Summarise results in the audit test report. Use the Audit Test Report template Include any non conformance issues in this report.

4. Audit report for Dynamic Website and Shopping Cart

You are required to develop an audit report using the Audit Report template

Attachment:- Resources.rar