1621ICT— Web Technologies

Web Site Project

1621ICT— Web Technologies

School of ICT Griffith University Trimester 1, 2021

Part A (10%) is due at the end of Week 6 (5pm Friday 23rd April)

Part B (20%) is due at the end of Week 11 with demonstrations to be conducted in your week 12 workshop. (5pm Sunday 30th May)

Assignment Description

This assignment tests your ability to design and develop a website using a combination of HTML, CSS and PHP. In Part A, you will need to produce the design for a website for a fictitious client. Your client could be a small local business, a government agency, a volunteer organisation or any other entity that needs an online presence. Use of an existing real business or organisation is not appropriate for this assignment. The aim of the website is to facilitate your client’s online needs which you should describe in your design document. In Part B, you must develop the website as per your design document. The implementation should make use of the technologies discussed and taught in this course over the semester, and should be hosted on the ELF platform. You will demonstrate your finished product to your tutor in the week 12 lab classes.

It is important to note that submission of this assignment is a requirement for passing the course.

Submission Requirements

Part A of your assignment must be submitted online via L@G under the assessment page. A single Word document is preferred, though a PDF file is also acceptable. Other formats are not allowed. The filename for your document should start with your student number and be named sensibly. For example:

s1234567_PartA_Design.docx

You will be required to present Part B of your assignment in your week 12 lab classes. You will also need to download the source files from ELF and upload them as a zip file to L@G before the due date. To obtain your files, log in to ELF via an SFTP client (WinSCP / FileZilla). You can then download the files and zip them up (include your student number in the zip file name – example below) and upload it to the submission link on L@G.

s1234567_PartB_Site.zip

Part B – Web Site Implementation (20%)

You are required to implement the website you designed in part A. If you make significant deviations from the design, you should provide a justification on why the design was not followed as an additional document.

While this assignment is designed to allow you to express your interests and creativity, there are some minimum requirements that must be met.

To achieve full marks, your website must include all of the following:

  • A minimum of 5 pages (including the landing/home page)
  • Demonstrate an understanding of HTML tags by including at least 1 of each of the following:
    • Images
    • Lists
    • Tables
  • A Navigation menu / Navigation bar
  • External CSS files for layout – please note you cannot use any CSS frameworks in your site.
  • Use a provided SQL database to retrieve and display some data to the user.
  • A form for entering data into the database or database searching – you may choose which you wish to do.

Use of pre-created HTML templates is not allowed and will be easily detectable. Please refer to the Academic Misconduct policy under the assessment section of the website.

In addition to the above site requirements, your website will also be assessed for:

  • Use of external stylesheets
  • Correct formatting of HTML
  • Correct formatting of CSS
  • Appropriate layout and navigation
  • Consistent ‘look and feel’

Database Usage

Set Up

On the assignment page, you will find a prebuilt database file that uses SQLLite. SQLite is a software library that implements a self-contained, server-less, zero-configuration, transactional SQL database engine. It is installed on your workspace by default.

The provided database (attached) includes 3 tables; Customers, Events and Products. These are filled with some simple data that you can retrieve and display on your website. The default tables are provided below, and the scripts used to create them are provided as an attachment.

To use the provided database, you will need to upload the 1621ICT.db file to your ELF workspace inside your Assignment folder.

Use

There are 3 main steps involved in querying a database and displaying results on a web page;

  • Connect to the database
    • Query the database using PHP & SQL
    • Present the results using PHP and HTML

The code to perform the first 2 steps is provided in the form of 3 pre-written php functions located in the file queryDb.php provided on the assignment page on L@G – 1 function per provided table; getCustomers() getProducts() and getEvents();. You will need to place this file in your assignment directory along with the database file.

Each of these functions has an OPTIONAL argument that will allow you to search the table for a specific record. The search will operate on the entire table, so for example, you could use getCustomers(“Jones”) and this would search the FIRSTNAME, LASTNAME, ADDRESS and PHONE of the Customer for the term “Jones”. If you provide no search term, all the records will be returned. The index to each row of the array will be the column name listed on the previous page:

Customers (CUSTID, FIRSTNAME, LASTNAME, ADDRESS, PHONE)

Etc.

In addition to retrieving data from a database, queryDb.php also contains 3 functions for adding an entry: addCustomer(), addProduct() and addEvent().

Each of these functions has 4 parameters – the 4 non primary key fields in each table. There is NO DATA SANITATION performed – the 4 values provided to the function will be placed in a simple SQL query. For example,

addCustomer(‘Sgt.’, ‘Robocop’, ‘Police station’, ‘000’); will execute the SQL:

INSERT INTO TABLE CUSTOMERS (FIRSTNAME, LASTNAME, ADDRESS, PHONE) VALUES

(‘Sgt.’, ‘Robocop’, ‘Police station’, ‘000’);

and the database will automatically assign a CUSTID to the new record. This is obviously not best practice in real-world applications due to security issues and SQL injection, but for the purposes of this course, will suffice.

Requirements

At a minimum, you need to use your knowledge of PHP and HTML to display the data from one of these tables on your web page in a sensible manner using the provided PHP functions in queryDb.php. You will also need to use a form to either search the database for a specific record or use a form to allow new data to be added to the database. Both of these options can be achieved using the provided functions. Bonus marks will be awarded for designing your own tables and/or php functions to interact with the database.

Remember to include the queryDb.php file by writing the line require_once “queryDb.php”;

inside a <?php?> script in your file.

Modifying the database

For students wishing to create their own tables or modify the existing ones, you can look at and modify the SQL_DB_CreateScript.sql used to generate the provided db. You will need to make adjustments/write your own queryDb.php to work with any modified tables. This is not a requirement for the course/assignment, but your tutor may be able help you do this. You could use https://sqliteonline.com/ as an online interface to create an sqlite database file or download the SQLiteStudio tool https://sqlitestudio.pl/

Order Now
No Fields Found.
Universal Assignment (February 2, 2023) 1621ICT— Web Technologies. Retrieved from https://universalassignment.com/1621ict-web-technologies/.
"1621ICT— Web Technologies." Universal Assignment - February 2, 2023, https://universalassignment.com/1621ict-web-technologies/
Universal Assignment July 4, 2022 1621ICT— Web Technologies., viewed February 2, 2023,<https://universalassignment.com/1621ict-web-technologies/>
Universal Assignment - 1621ICT— Web Technologies. [Internet]. [Accessed February 2, 2023]. Available from: https://universalassignment.com/1621ict-web-technologies/
"1621ICT— Web Technologies." Universal Assignment - Accessed February 2, 2023. https://universalassignment.com/1621ict-web-technologies/
"1621ICT— Web Technologies." Universal Assignment [Online]. Available: https://universalassignment.com/1621ict-web-technologies/. [Accessed: February 2, 2023]

Please note along with our service, we will provide you with the following deliverables:

Please do not hesitate to put forward any queries regarding the service provision.

We look forward to having you on board with us.

Get 90%* Discount on Assignment Help

Most Frequent Questions & Answers

Universal Assignment Services is the best place to get help in your all kind of assignment help. We have 172+ experts available, who can help you to get HD+ grades. We also provide Free Plag report, Free Revisions,Best Price in the industry guaranteed.

We provide all kinds of assignmednt help, Report writing, Essay Writing, Dissertations, Thesis writing, Research Proposal, Research Report, Home work help, Question Answers help, Case studies, mathematical and Statistical tasks, Website development, Android application, Resume/CV writing, SOP(Statement of Purpose) Writing, Blog/Article, Poster making and so on.

We are available round the clock, 24X7, 365 days. You can appach us to our Whatsapp number +1 (613)778 8542 or email to info@universalassignment.com . We provide Free revision policy, if you need and revisions to be done on the task, we will do the same for you as soon as possible.

We provide services mainly to all major institutes and Universities in Australia, Canada, China, Malaysia, India, South Africa, New Zealand, Singapore, the United Arab Emirates, the United Kingdom, and the United States.

We provide lucrative discounts from 28% to 70% as per the wordcount, Technicality, Deadline and the number of your previous assignments done with us.

After your assignment request our team will check and update you the best suitable service for you alongwith the charges for the task. After confirmation and payment team will start the work and provide the task as per the deadline.

Yes, we will provide Plagirism free task and a free turnitin report along with the task without any extra cost.

No, if the main requirement is same, you don’t have to pay any additional amount. But it there is a additional requirement, then you have to pay the balance amount in order to get the revised solution.

The Fees are as minimum as $10 per page(1 page=250 words) and in case of a big task, we provide huge discounts.

We accept all the major Credit and Debit Cards for the payment. We do accept Paypal also.

Popular Assignments

1007ICT / 1807ICT / 7611ICT Assignment

Due Date: 11:59pm Sunday 5th February 2023 1.   Individual Assessment This is an individual assignment. All work submitted must be your own work. Be careful not to use the work of others as your own nor have others use your work as their own. 2.   Software Requirement In this assignment,

Read More »

BSBINS407 Consolidate and Maintain Library Industry Knowledge

Student Name   Student Number Unit Code/s & Name/s BSBINS407 Consolidate and Maintain Library Industry Knowledge Cluster NameIf applicable N/A Assessment Name Portfolio of Evidence – Industry Discussion Assessment Task No. Assessment Due Date   Date submitted Assessor Name   Student Declaration:  I declare that this assessment is my own

Read More »

The best place to get Y diagram Chemistry Assignment Immediately

Struggling with Y diagram Chemistry Assignment? Many students need Y diagram chemistry assignment help to them learn the subject better.  The Y Diagram is a popular mnemonic aid for remembering certain concepts. This means that it helps us remember the relationship between the mole and other basic concepts of chemistry.

Read More »

Assessment 4: Tableau Dashboard and Report

Issued:                Monday of Week 4 Due:                     11:59PM (local Time) Wednesday of Week 7 Weight:                60% Report Length: 1500 – 4000 words + Tableau *.twbx file Overview During this assessment you will produce an interactive Tableau Dashboard and an accompanying report detailing the planning of the Tableau Dashboard. Background Tableau dashboards

Read More »

Assessment 3: Critical Review of a Tableau Dashboard

Issued:                Monday of Week 1 Due:                     11:59PM (local Time) Sunday of Week 5 Weight:                20% Length:               5-10 minutes (approx. 500-3000 words) Overview During this assessment you will produce a video presentation critically reviewing a Tableau dashboard from a design planning and communication perspective. Background Tableau dashboards are used extensively for

Read More »

Wireless Communication Engineering Assignment Help

Looking for Wireless Communication Engineering Assignment Help? If you are looking for wireless communication engineering assignment help, just get it quickly online! The good news is that you no longer need to chase your professors around with confusion about assignments. Nor do you have to stress out as chase that

Read More »

Assessment 2: Planning and Creating Static Visualisations

Due:                     11:59PM (local Time) Sunday of Week 3 Weight:                20% Length:                1000-2500 words Overview During this assessment you will produce written report detailing the planning and creation of three static visualisations derived from a data table. In this assessment, the quality of the presented visualisations is not assessed, only the

Read More »

Nursing Healthcare Case Study Assignment Help

ASSESSMENT ITEM 2: DESCRIPTION Shared decision-making is a model for clinical practice which includes patients’/clients’ values and preferences and supports them to make decisions about their own care and treatment options in collaboration with their healthcare team (Geddis-Regan et al., 2020). A patient’s/client’s culture affects the way they understand health

Read More »

BSBCRT311 Apply Critical Thinking Skills in a Team Environment

Table of Contents Table of Contents…………………………………………………………………………………………………………………. 3 About the Business Services Training Package…………………………………………………………………………………………………………………. 4 About this Unit of Competency……………………………………………………………………………………………………………… 6 Chapter 1: Prepare to Address Workplace Problem…………………………………………………………………………………………………………………. 7 ………………………………………………………………………………………………………………………………………… 8 Key Points: Chapter 1…………………………………………………………………………………………………………….. 30 Chapter 1 – ‘True’ or ‘False’ Quiz……………………………………………………………………………………………………………. 31 Chapter 2: Evaluate Solutions for Workplace Problem…………………………………………………………………………………………………………………

Read More »

BSBCRT311 Apply critical thinking skills in a team environment

WORKPLACE PROJECT TASK   Student details  Student name  Student email address  Assessment Details  About this task  This workplace project requires you to use critical thinking to resolve two typical problems in the workplace.   This assessment includes the following tasks:  Task 1: Workplace Problems  Task 2: Self-reflection  You will need 2 participants who

Read More »

BSBCRT512 Originate and Develop Concepts

Contents Section 1: Scoping a relevant issue. 5 Section 2: Generating and evaluating solutions. 8 Section 3: Concept finalisation. 11 Student name:   Assessor:   Date:   Business or Community/Social group this assessment is based on:   Documentation reviewed as preparation:   Job role assumed for this assessment:   Section

Read More »

EMS5RCE – Risk Engineering (2022)

Assignment 2 Due Date: 13th February 2023, 23:59PM 1        Outline You have been tasked to evaluate the risks associated with moving from a traditional construction method for constructing concrete formwork (such as precast), to an advanced method that will be designed to take advantage of additive and/or automated and digital

Read More »

NIT3171 ICT Business Analysis & Data Visualization

Individual Assignment – Business Analysis Case Study (Stage II – 35 marks weighing 35%) Report Submission Date (through the dropbox): (10% will be deducted for each day of delay) Presentation (5 minutes each) 10 Marks: In this assignment, a Melbourne housing dataset is given to you to apply data mining

Read More »

HSC ECONOMICS The Global Economy

HSC ECONOMICS  Assessment Notification: Task 1 Subject: Economics Topic The Global Economy Nature of Assessment Task Oral presentation with a written component Weighting 25% Teacher Ms R Ali Date of Notification Term :4 Week 5A  (2022) Due Date Term 1 (2022), Week 7A,Friday (written component) and Week 8B(Oral component)  

Read More »

Behaviour & Environment Case Study

Section 1: Overview of Issue of Human-Environment Relations & Proposed Intervention (Delete this and enter your text for this section here) Section 2: Identify all key stakeholders: (Delete this and enter your text for this section here) Section 3: Explain how the Intervention Strategy should be implemented (Delete this and

Read More »

Assignment BMSC Pharmacology Breakdown

  Section Word Limit Marks Research Time Writing Time Description Clarity N/A 5 10 mins 1 hr sentence structure; typographical errors; scientific style Reference N/A 5 20 mins 40 mins correct use of referencing style and in text citations; typically 5-10 references depending on the topic/experimental platform and drugs used

Read More »

Assessment Task 3: Portfolio Output 3

This task requires you to create a blog post and a 3-4 minute edited video that critically and creatively responds to one of the Digital Media Contexts from weeks 7-10 (this must be a different topic from what you chose for Portfolio Output 2). Your video is to be embedded

Read More »

Formulae Sheet

Formulae Sheet Current ratio Current assets Current liabilities     Quick ratio or acid test Cash + marketable securities + net receivables Current liabilities     Current cash debt coverage Net cash provided by operating activities Average current liabilities     Receivables turnover Net sales Average net trade receivables  

Read More »

Cashflow and Financial Analysis

Assessment Task: 20% Cashflow and Financial Analysis – Template IMPORTANT:  Preparing the cashflow statement and financial analysis template. The template is prepared to satisfy all the assignment business’s so there may be extra line items in the template. To submit the cash flow statement, you need to use the template

Read More »

Cashflow and Financial Analysis – Ship’em In&Out

Assessment Task: 20% Cashflow and Financial Analysis – Ship’em In&Out IMPORTANT:  Preparing the cashflow statement and Financial analysis To submit the cash flow statement, you need to use the template document in CANVAS. The template is prepared to satisfy all the assignment business’s so there may be extra line items

Read More »

Pros and Cons of Chat GPT Assignment Help

How great is Chat GPT Assignment Help? Chat GPT Assignment help is definitely an incredible possibility for students. It is a technological advancement that can generate essays and articles on a massive range of topics. Moreover, you can just ask any question, and you will get your answer right away.

Read More »

Question 10 – REPORTS

Complete the table below, by listing three types of financial reports that are produced in your workplace. Type of Report Content of Report Frequently of Report                  

Read More »

Question 9 – BUSINESS RECORDS

Work through the following table and indicate whether each record should be kept or destroyed. Detail the reason for your answer and how long the record should be kept (for example, legislation requirement – retain for five years). Record Keep – Yes or No Reasons Suppliers Invoices     Employee

Read More »

Question 6 – BUSINESS ACTIVITY STATEMENT

Using the following information, complete the Business Activity Statement, you may need to refer to the ATO website to help you complete. Download and complete the Business Activity Statement (BAS). It can be found separately on the course page.

Read More »

Question No 5 – BREAKEVEN ANALYSIS & MOVING

AVERAGE Activity 5.1 – Break-even Answers A. B.   Manage 8 Buildings Manage 10 Buildings Manage 15 Buildings Manage 20 Buildings Manage 25 Buildings Income           Less Variable Costs           Less Fixed Costs           Total Cost    

Read More »

Can't Find Your Assignment?

Open chat
1
Free Assistance
Universal Assignment
Hello 👋
How can we help you?