Tag: scripting

Assignment Brief and Feedback form

(Graded unit with single assignment)

Name of Centre:	Learner achievement (please circle) NB: All learner achievement is provisional until confirmed at the AVA Awards Board.
Level Achieved:	L3
Achievement (Level 3 units only)	P	M	D
Resubmission?	Y	N
Title of Access to HE Diploma: (e.g. Science)
Unit title(s): Creating Database Driven Web Pages	Unit code(s):
Learner:	Tutor/Assessor:
Description of Assignment: This assignment is both a written and practical assignment that will demonstrate your skills in the creation of database driven web pages TASK 1 Create a MySQL database containing a single table (games) for an online games store. The games table will store information about games with the minimum of the following fields: game title, genre, year of release, publisher, screenshot, and a written review and (possibly) other fields of data relating to games. Choose appropriate data types and widths for each field. Note 1) As your database server might not allow you to choose the database name any name is acceptable for this Note 2) The screenshot data does not need to be stored inside the table. Commonly this will contain a local file path or URL that can be used as a web hyperlink Use PhpMyAdmin to add 5 records to the games table based on existing information which you will research on existing games websites. Create a username and password that can access this database using your firstname+lastname and a password of your own choice. This account should have full access to the database. Create a webpage that connects to your database using PHP. Store the information the connection needs (database name, table name, username /password) in PHP variables. Display a message in the webpage when a successful connection is 2.3] Create a Word document Task1 that contains A screenshot of your working webpage A well commented listing of your HTML/PHP code Show this to your tutor to progress to the next stage TASK 2 You will build on your work in task 1 and develop the database to the next stage Using the existing records in your games db you will need to create the following: You will create a display all records page which lists all the items in the database in a html table using a control structure [1.3] You will create an insert form to allow games to be added to the database, implement validation checks so that data is correctly entered. [4.2] [5.4] Create a complex query by creating an update page which will allow users to edit the games in the database [4.3] You will create a delete page which will allow you to delete games records in the database. [4.4] You will create a basic search engine form which allows the user to search on multiple fields on the database and give back a results page based on those fields For this You will need to create a complex query using SQL and execute this query on the remote database. This results page will use single control structures for selection and iteration such as conditional statements and loops to go through all the records. [3.1] [4.1] You will extend this page to show a list of games titles outputted as hyperlinks which then take you to more detail about the game that is chosen [3.2] [3.3] You will make a single page which has links to all these different pages you have made – all records, insert record, delete record, update records and search . Finally you will password protect access to this page [6.1] Show this all working to your tutor to progress to the next stage To document this work, you will create software documentation for the user, this will have three parts. Task 2a) Write an introductory section which explains how requirements can vary between the client (games store owner) and end user and explain the importance of an effective user experience [1.1] Task 2b) Create and justify your user interface by producing design documentation in the form of wireframes and sketches to meet the specific client requirements as outlined below. [1.2] The client requirements are The website application should work on mobile phones There should be a main menu to move between the different pages such as display all records, insert, delete What are the differences and similarities between clientside and server-side scripting, update and search Instructional text and menu labels should be intuitive There should be prompts where forms are not filled out correctly prompting the user to enter data correctly Task 2c) Create a user guide document with live links and screenshots of your working pages and well commented page listings to show your understanding. Use current web development conventions in your approach. TASK 3 You will write a report which addresses the following questions within a word limit of 1500 words. Please indicate supporting references. What are the differences and similarities between clientside and server-side scripting. Draw your conclusions by giving some practical examples of code within the types of languages involved and explain where you may use these giving real examples [2.1] Explain the environment or framework you have chosen to develop your web database application [2.2] What are the differences between (GET and POST) in relation to the published and tested multi-page scripting you have completed using request.form and query strings. [5.3] Why would you need to password protect parts of a website? [6.1] Why would you use a hidden form element on a website [6.2] Why would you need to validate user input for a website with a database? Describe the validation checks have you implemented? [5.4] Finally review and evaluate the success of your uploaded files for your web database application suggesting areas for future development [7.2] File naming. Your tasks should be labelled in the following format firstname_surname_Task1_ddwp.doc firstname_surname_Task2_ddwp.doc firstname_surname_Task3_ddwp.doc Upload this to Moodle to the designated final submission area by the deadline
Date set:	Date for draft submission (if applicable):	Date for final submission: 29th May 2022
Extension date (if agreed):	Signed by Tutor/Assessor to agree extension:	Date submitted:
Internal Moderation: Yes / No Date:	Signed by internal moderator:	ON TIME / LATE
Learner declaration:  The explanations and evaluations in this work have been developed and written by me.  I have not submitted material copied from the Internet, text books or other sources in place of my own thinking and writing.  When I have referred to the work of others I have done so to discuss, comment on or argue their ideas.  I have kept quotation and paraphrasing to an absolute minimum and only to support points I have made.  I understand that referencing the names of authors whose ideas I have used without including my own interpretation of those ideas, does not meet the assessment criteria and cannot attract the Pass on What are the differences and similarities between clientside and server-side scripting, Merit or Distinction grades.  I have not copied the work of my peers.
Learner comments: (please use this space to comment on any aspect of the assignment when handing in your work)
Signature:	Date:

TO THE LEARNER: Please attach this assignment brief to any written work you are handing in for assessment, or submit the brief as instructed.

YOUR WORK CANNOT BE ASSESSED UNLESS YOU HAVE SIGNED AND SUBMITTED THIS FORM

Level 3	Unit title:
Learning outcomes	Assessment criteria
This is what you will learn on the unit.	This is what you must be able to demonstrate that you can do in your assignment in order to achieve the unit.
The learner will:	The learner can:
Understand the client/server architecture involved in web-database applications.	Explain the differences between clientside and server-side scripting. Publish and test a page that uses two variables. Publish and test pages that use single control structures for selection and iteration. Explain the differences between the published and tested multi-page scripting using request.form and query strings
Know how to create a connection to a data source	Explain the purpose of ODBC and identify an ODBC complaint DBMS. Create the DNS-less link to the database. Create a complex query using SQL and execute that query on a remote database
Know how to create a data driven web search form	Create a search form allowing the user to search on multiple fields in the database. Create a hyperlink output list displaying the results of the searches on the different fields. Create an output form to display search details from the different fields.
Be able to create a data driven web update form.	Create an Insert form allowing data to be inserted into the database. Create an Update form allowing users to edit data in the database. Create a Delete facility allowing users to delete data in the database.
Know how to customise and enhance data forms.	Explain the need for password protection and implement password protection for parts of the site. Explain the need for the validation of user input and implement validation checks. Explain the purpose of hidden form element implemented.
Be able to upload to a local web server.	Identify suitable ISP host sites and upload to a local web server.

(This section must be repeated for all units assessed through this assignment)

Level 3 units only: Learners achieve a Pass if they meet all Level 3 Assessment Criteria for a unit. You will achieve a Merit or Distinction by meeting the following Grade Descriptors. Your tutor will give you feedback for all three grades.
Grade Descriptor	Merit (Choose one or more relevant grade components)	Distinction (Choose one or more relevant grade components)
GD1. Understanding the subject	1 demonstrates a very good grasp of the relevant knowledge base 2 is generally informed by the major conventions and practices of the area of study 3 demonstrates very good understanding of the different perspectives or approaches associated with the area of study.	1 demonstrates an excellent grasp of the relevant knowledge base 2 is consistently informed by the major conventions and practices of the area of study 3 demonstrates excellent understanding of the different perspectives or approaches associated with the area of study
Grade Descriptor	Merit (Choose one or more relevant grade components)	Distinction (Choose one or more relevant grade components)
GD 3. Application of Skills	1. Generally selects appropriate Techniques 2. Applies appropriate (selected or given) Skills with very good Confidence Consistency on What are the differences and similarities between clientside and server-side scripting	1. Consistently selects appropriate Techniques 2.Applies appropriate (selected or given) Skills with excellent Confidence Consistency
Grade Descriptor	Merit (Choose one or more relevant grade components)	Distinction (Choose one or more relevant grade components)
GD7: Quality	Is structured in a way that is generally logical & fluent Contains some ambiguities or limitations in the expression of arguments or ideas Taken as a whole, demonstrates a very good response to the demands of the brief/assignment	Is structured in a way that is consistently logical & fluent with clear expression of ideas. Taken as a whole, demonstrates an excellent response to the demands of the brief/assignment

Grade Guidance: Learners must carefully read the guidance below which is linked to the components above

MERIT: (e.g. To achieve a Merit your work will show…..) GD1 : To achieve merit you will have been generally informed by the major conventions and practices in web development with evident references to support this. GD3: To achieve merit, you should generally select appropriate techniques and apply skills to complete the database driven web page programming tasks with very good confidence and consistency. The code should run correctly with a good user experience. GD7: To achieve merit, your work be complete, well thought out and commented appropriately. Both your programming and SQL code should be thought through with thought to efficiency where possible. You will need to reference external sources to show how you have extended your learning about What are the differences and similarities between clientside and server-side scripting.

DISTINCTION: (e.g. To achieve a Distinction your work will show…..) GD1 : To achieve distinction you will have been consistently informed by the major conventions and practices in web development with substantial evident references to support this. GD3: To achieve distinction you should consistently select appropriate techniques and apply skills to complete the database driven web page programming tasks with excellent confidence and consistency. The code should run with an excellent user experience with meaningful feedback to the user. GD7: To achieve the higher grades of distinction, your work be complete, very well thought out and very well presented and commented appropriately. It should be a model to others who are learning how to make database driven web pages and demonstrate the depth of your understanding. Both your programming and SQL code should be well thought through with thought to redundancy and efficiency using functions where possible.

Part A: Feedback on credit level
AC no	Credit achieved (L3)	Location of evidence	Tutor/Assessor comments on assessment criteria (the assessor may also indicate on the work itself where each AC is met)
1.1
1.2
1.3
1.4
2.1
2.2
2.3
3.1
3.2
3.3
4.1.
4.2
4.3
5.1
5.2
5.3
6.1
Level achieved		Tutor/Assessor’s signature:		Date:
Resubmission (if applicable) If any of the assessment criteria for this assignment have not been met at Level 3, a resubmission may be permitted. Resubmission must follow the QAA guidelines and be permitted only once.
Requirements for resubmission/new Task set:
Date Set:		Date due:		Date Submitted:
Feedback on resubmission:
Level achieved after resubmission:		Tutor/Assessor’s signature:		Date:
Part B: Feedback on grading (Applicable only if all assessment criteria achieved at Level 3)
Grade Descriptor	Tutor/Assessor comments against grade descriptors	Grade indicator (P/M/D) Please enter the final grade on page 1 based on this grade profile e.g. PPM=P
GD1. Understanding the subject
GD3. Application of knowledge
GD7: Quality
Tutor/Assessor’s reason for final grade decision (if applicable):
Areas for development (how will the learner be able to use and improve on what they have learnt on this unit and the skills that they have used in their further studies?)