G062 Similar but Different Answers – 2014-15
CONTENTS
INTRODUCTION ............................................................................................................................... 3 Task 1 – RELATIONAL DATABASE .................................................................................................... 4 1ai – Import data..................................................................................................................... 4 1aii – Relationships ................................................................................................................. 6 1bi – Church form ................................................................................................................... 7 1bii – Campers form................................................................................................................ 8 1biii – Camper photographs ................................................................................................... 9 1biv – Church details on Camper form ................................................................................. 11 1ci – Booking form ................................................................................................................ 14 1cii – Booking form annotation ............................................................................................ 15 1di – Adult campers report ................................................................................................... 19 1dii – Annotation of Campers report .................................................................................... 20 1ei – Phone call reminders report ........................................................................................ 21 1eii – Phone call reminders annotation ................................................................................ 22 1f – Reminder letter .............................................................................................................. 24 1g – Automated routine........................................................................................................ 25 1hi – New booking form ....................................................................................................... 26 1hii – Annotate booking form ............................................................................................... 27 1hiii – Process booking routine ............................................................................................. 35 1i-i – Main menu ................................................................................................................... 40 1i-ii – Automated menu annotation ..................................................................................... 41 1i-iii – Navigation annotation ............................................................................................... 42 1j – User Guide ...................................................................................................................... 43

Task 2 – Spreadsheet .................................................................................................................... 44 2ai – APR_Calculator worksheet ........................................................................................... 44 2aii – APR_Calcualtor interface annotation .......................................................................... 45 2aiii – Print button annotation ............................................................................................. 50 2aiv – Formulae with annotation .......................................................................................... 50 2bi – Ownership_Model worksheet ..................................................................................... 53 2bii – Ownership_Model annotation .................................................................................... 54 2biii – Completed Ownership_Model worksheet ................................................................. 58 2biv – Completed Ownership_Model annotation ................................................................ 59 2bv – Relative and absolute cell referencing ........................................................................ 64 2bvi – Cell and worksheet protection ................................................................................... 66 2c – Help sheet...................................................................................................................... 68 2d – Test plan ........................................................................................................................ 69 Task 3 – WEBSITE .......................................................................................................................... 70 3a – Design specification ...................................................................................................... 70 3bi – CSS with annotation ..................................................................................................... 71 3bii – Website pages ............................................................................................................. 72 3c – Map annotation ............................................................................................................. 74 3di – Validation rules with annotation ................................................................................. 76 3dii – Flowchart..................................................................................................................... 78 3e – Test plan ........................................................................................................................ 79

INTRODUCTION
These answers may be shared with students. Students can use these to see what they should have done for the similar but different tasks after they have completed them. Alternatively, some tasks are quite easy and students may want to do the task straight away and just make reference to the similar but different questions and answers. The software used to produce the answers is Microsoft Office 2013 and screenshots reflect this. Microsoft Office 2007 and 2010 have very similar features and use the same ribbon style of icons. The documents have been saved in Office 2007/2010/2013 Open XML format. If you are using an earlier version of Office and cannot open these files, then download the Microsoft Office Compatibility Pack from http://www.microsoft.com/downloads/details.aspx?familyid=941b3470-3ae9-4aee-8f43c6bb74cd1466&displaylang=en The similar but different tasks are provided in a document called “G062 Similar but Different 2014-15 Questions.pdf”. Instructions for how to complete the tasks are provided in a document called “G062 Similar but Different 2014-15 Instructions.pdf”. These can be used by students as an AfL exercise following completion of the practice tasks or they can be used to see the type of evidence required where tasks don’t require practice. The example mark scheme is called “G062 Similar but Different 2014-15 Mark Scheme.pdf”. The files used to create the similar but different task answers are in a folder called “Answer Files”. The documents that would be produced as printouts or drawings can be found in the “Printouts” folder. Data files can be found in a folder called “Data Files”. Video tutorials of the similar but different tasks are provided as a separate product. If you have purchased the videos and stored them in the correct folder then the links in this document will work. Centre staff are highly recommended to use the Model answers for 2014-15 available from www.paullong.net as these include answers that staff can refer to and are designed to cover all the skill sets required. Students are advised to use these similar but different tasks to either practice the skills required or look at the type of evidence required or a mixture of both.

TASK 1 – RELATIONAL DATABASE
1ai – Import data See Answer File 1a Imported Data.accdb

1aii – Relationships

1bi – Church form See Answer File 1b Church and Camper Forms.accdb

1bii – Campers form

1biii – Camper photographs I added a Photograph field and set the data type for the Photograph field to be attachment:

I added a picture by double clicking on the paperclip:

I then clicked on Add… to add a photo:

and selected the matching Camper from the pictures:

When I created the form, the picture control was automatically created:

Double clicking on any picture control will allow the picture to be changed:

1biv – Church details on Camper form When I created the form, I included both the Camper and Church tables:

This added all the fields to the form. I created a combo box to select the supplier.

I chose the option to get values from another table:

and I chose the Church table:

I then chose to include the Church ID, Church Name and Postcode in the combo box:

I chose not to hide the key column:

I chose ChurchID as the field to store:

And I chose to store that value in the Camper_ChurchID which is the foreign key of the Camper table:

I labelled the Combo Box “Select Church” and was then able to select the Church from a list:

I then set the rest of the supplier details to be LOCKED so that they were read only:

1ci – Booking form See Answer File 1c Booking Form.accdb

1cii – Booking form annotation View Church Button I created a button and chose the option to open a form:

I then chose the form as Church Details:

I set it up so that it would find specific data to display (ie the matching Church record):

Then I chose to compare the ChurchCombo data (ChurchID) from the Booking Details Form and open the matching ChurchID on the ChurchDetails form:

I then labelled the button “View Church” and set the house style:

Check Boxes When I created the table for Booking, I set the data types for Reminder Letter, Phone Call Reminder and Paid to be Yes/No:

This meant they automatically had tick boxes when the form was created:

Validation I set a validation rule on Reminder Letter so that it could only be one of two values: 1. No 2. Same as Phone Call Reminder

I also added an error message if the user tried to tick Reminder Letter when Phone Call Reminder was not ticked. I tested that the validation rule worked by leaving Phone Call Reminder unticked and ticking Reminder Letter:

Pitch Allocations When I created the form, I included the Booking and PitchAllocation details within the selection for fields:

I then chose to arrange the form by Booking so that the PictchAllocation and PitchType data would be part of a sub-form:

Total Price Charged I added a text box to the Pitch Allocation footer to add up the total (SUM) of all the Prices Charged multiplied by the quantity: =sum([Price Charged]*[Quantity])

Record Selectors and Standard Navigation Buttons Removed I changed the properties of the form and the sub-form so they did not have record selectors or navigation buttons:

Customised Buttons I created navigation buttons as follows: First Record:

Previous Record:

Next Record:

Last Record:

1di – Adult campers report See printout 1di Adult Campers.pdf See Answer File 1d Adult Campers.accdb

1dii – Annotation of Campers report To ensure that only campers over 18 on 1st August 2015 were listed, I included the following query:

It will only show campers where their date of birth is less than or equal to 18 years (“yyyy”) before (-18) 1/8/2015. To calculate the number of campers, I created a function in the ChurchID Footer so that it appeared for each Church:

The Count function counts the number of records and I chose to count the Date of Birth field:

1ei – Phone call reminders report See printout 1ei Phone Call Reminders Needed.pdf See answer file 1e Phone Calls Report.accdb

1eii – Phone call reminders annotation To ensure that only overdue payments were included, I created the following query:

It will only show Bookings which haven’t been paid and haven’t had a Phone Call Reminder already. It will only show orders where they payment due date is more than 3 weeks ago. DateAdd adds to a date. “ww” means that it will be weeks that are added. -3 means that 3 weeks will be subtracted. Date() means today’s date. So 3 weeks will be subtracted from today’s date. Then if the Payment due date is before this calculated date then the record will be shown if the Booking hasn’t been paid or a phone call hasn’t already been made. To calculate the total costs, I selected the Summary Options when creating the report and set the Price Paid to be a SUM:

This generated a function to add up (SUM) all the Prices Paid for each Church, Booking and overall:

By including it in the BookingID Footer, it will produce a total owing for each order. However, it needed to include the quantities so I changed the formula to be: SUM([Price Charged]*[Quantity])

I repeated this for the ChurchID footer to give a total for each Church:

And I repeated it for the Report Footer to give a grand total:

1f – Reminder letter See printout 1f Reminder Letters.pdf See answer file 1f Reminder Letter.accdb

1g – Automated routine See answer file 1g Automated Route (pre-processing).accdb See answer file 1g Automated Route (post-processing).accdb I created a macro that runs an update query to change the PremiumPrice and CurrentPrice values and opens the report: This runs the update query automatically

This is the report that is opened automatically

Print ensures that the report will be printed automatically

The update query is based on the PitchType table and includes criteria to:  only update pitches that have not had their price changed  only update pitches where the number of remaining pitches is at or below the PremiumPriceLevel

It will add 15% to the CurrentPrice by multiplying the CurrentPrice by 1.15 The Premium Pitches Report is based on Qry Premium Pitches which only lists those pitches that have had their price changed:

1hi – New booking form Method 1 See answer file 1hi Booking Form (Method 1).accdb

Method 2 See answer file 1hi Booking Form (Method 2).accdb

1hii – Annotate booking form Unique BookingID Method 1: I created a new text box on the New Booking form:

I gave it a name of NewBookingID so it could be referred to later on:

In order to generate a unique Booking ID, I used the DMAX function to find out the current maximum BookingID from the Booking table and then added 1 to this value:

Method 2: I set the default value of BookingID to find the next available BokingID:

The DMAX function looks up the maximum BookingID from the Booking table and then adds 1 to this value.

Booking Date Method 1: I created a new text box and named it “NewBookingDate”. I set its value to be Date() which will be the current date.

Method 2: I set the default value of Booking Date to be the current date – Date():

Payment Due Date Method 1: I created a new text box and named it “NewPaymentDue”. I set its value to add 14 days (“d”) to the current date (Date()).

Method 2: I set the default value of Payment Due to be 14 days (“d”) after the current date (date()):

Select Existing Church I added a drop down box for Church and chose the option to get values from another table which was the Church table:

I then chose the fields shown below:

I chose the option to remember the ChurchID for later use:

I named the combo box “NewChurchID” so it could be referred to later. Here is the drop down box working:

Add New Church I created a new button to open the Church Details form

I chose to open it with specific data to display:

I deliberately chose to match a date with the ChurchID so that no data would be found and therefore the Church Form would open with a new record:

Pitch Type Drop Down List Method 1: I created a table called NewPitchAllocation which would temporarily store the data from the sub-form:

When I created the NewPitchTypeID field, I set it to be looked up from the PitchType table:

These are the fields I added:

This meant that when the form was created the drop down box was automatically created. This is the drop down box in use:

Method 2: On the sub-form, I added a drop down box that selected values from the PitchType table. I set it to select the following fields:

I chose to store the PitchTypeID in the PitchTypeID field:

This is the drop down box in use:

Description and Current Price Method 1: When I created the form, I set the structure so that the NewPitchAllocation and PitchType tables would be a part of the sub-form:

I also created a relationship between the NewPitchAllocation and PitchType tables so they would be linked:

This meant that when I chose a PitchType in the sub-form

that the description and current price would automatically be retrieved from the PitchType table:

Method 2: When I created the form, I set the structure so that the PitchAllocation and PitchType tables would be a part of the sub-form:

This meant that when I chose a PitchType in the sub-form:

That the description would automatically be retrieved from the PitchType table:

To display the current price, I set an “After Update” event for PitchTypeID that would update the Price Charged to be the Current Price:

Quantity Validation When I setup the sub-form within the form, I included the PitchesRemaining field (although this is not showing in the actual sub-form because it doesn’t need to be).

This allowed me to create a validation rule to compare the Quantity ordered with the PitchesRemaing:

The validation rule ensures that the Quantity is less than or equal to the PitchesRemaining and if it is more than the PitchesRemaining then the error message (validation text) will be displayed. There were 50 PitchesRemaining for Hard Standing Super:

I tried to book 51 pitches and got this error message:

1hiii – Process booking routine See answer file 1hiii Process Booking.accdb Storing Booking Data I created an append query to add data to the Booking table: The NewBookingID from the New Order form is appended to the BookingID.

The NewChurchID from the New Order form is appended to the ChurchID. The NewBookingDate from the New Order form is appended to the Booking Date.

The NewPaymentDue from the New Order form is appended to the PaymentDue. Reminder Letter, Phone Call Reminder and Paid The value False is appended to the Reminder Letter, Phone Call Reminder and Paid fields.

Storing PitchAllocation Data I created a new table called “NewPitchAllocation”:

I added 31 records and then deleted them in order to increase the AutoNumber to 32 which is the next available number for the PitchAllocation table.

Along with the PitchType table, this was the record source for the sub-form:

When the values were entered into PitchTypeID, Quantity, Adults and Children they were recorded in a record of the NewPitchAllocation table. The PitchAllocationID is an autonumber so increments automatically. I then created an append query to add the data from the NewPitchAllocation table to the PitchAllocation table:

I retrieved the NewBookingID from the New Booking form and appended it to the BookingID which is the foreign key.

Current Price as Price Charged I included the PitchType table in this query so that the CurrentPrice could be used to append to the Price Charged field in the PitchAllocation table:

Pitches Remaining Update I created an update query that would subtract the NewQuantity from the PitchesRemaining and update the PitchesRemaining to this new value:

The query was based on both the NewPitchesRemaining and PitchType tables.

Deletion Query I created a delete query to remove all the records from the NewPitchAllocation table:

This was to prepare for the next New Booking.

Automation I created a macro called “Process Booking” which was linked to the “Process Booking” button The button runs a macro:

called “Process Booking”:

and the text of the button is “Process Booking”:

The macro runs each of the 4 queries in turn: At the start it turns warning messages off so that the user is not troubled by update and append messages.

At the end it closes the New Booking form.

1i-i – Main menu

1i-ii – Automated menu annotation I created a macro called AutoExec:

I set it to open the form “Menu”.

1i-iii – Navigation annotation I selected the option to create a button:

I then selected the option to open a form:

I then selected the “Church Details” macro:

I gave the button the label of “Church Details”:

Here is the button:

1j – User Guide See answer file 1j User Guide.docx

TASK 2 – SPREADSHEET
2ai – APR_Calculator worksheet See answer file 2ai APR Calculator Interface.xlsx

2aii – APR_Calcualtor interface annotation See answer file 2aii APR Calculator Interface Requirements.xlsx Drop down box for Employment Status I created a list validation with the Driving Licence Types as the source:

When I click on the drop down list it gives me these values:

Scroll bars for Credit Rating I named this cell CreditRating:

I named this cell CreditRatingx10:

I set CreditRating to be =CreditRatingx10/10. This was because scroll bars only work with whole numbers so the actual Credit Rating from the scroll bar needs dividing by 10. These are the settings for the scroll bar:

There is no minimum value so it is set to zero The maximum value is 5.9 so it is set to 10x5.9 = 59 Increments should be 0.1 so it is set to 10x0.1 = 1 The cell link is CreditRatingx10 which is then divided by 10 to give the answer in CreditRating

Option buttons for Driving Licence Type These are the option buttons I created in their own group box:

I named this cell DLType I set the cell link to be DLType so that if Full is selected then DLType will be 1, if Provisional is selected it will be 2 and if None is selected it will be 3.

Tick box for Guarantor This is the tick box I created:

I named this cell Guarantor I set the Cell link to be Guarantor so that if the box is ticked then Guarantor will be TRUE and if it is not ticked it will be FALSE

Row and Column heading removal I removed row and column headings by unticking View under Headings:

Grid lines removal I removed gridlines by unticking View under Gridlines:

Validation for Date of Birth I created a validation rule that the date of birth must be before 17 years ago:

YEAR(TODAY())-17 subtracts 17 from the current year. MONTH and DAY use the current month and day. I set a customised error message of “Customer must be 17 or older”:

This is what happens when a date less than 17 years ago is entered:

IF statement for eligibility statement I used this function:

This says that if DLType (Driving Licence Type) is 3 then display “You are NOT eligible for a car hire purchase” otherwise display “You are NOT eligible for a car hire purchase”.

Conditional formatting for APR % I set the FIT cell to a red border as default:

This means that if the None for Driving Licence Type is selected it will be red. I highlighted the APR % cell and selected Conditional Formatting. I created this rule:

=NOT(DLType=3) means that if the Driving Licence Type is NOT 3 then the border will be green. DLType is the named cell for Driving Licence Type. =$D$24:$D25 is the merged cell that contains the APR %.

Worksheet Name I named the worksheet APR_Calculator:

2aiii – Print button annotation See answer file 2aiii Print Button.xlsm I created a macro and named it PrintAPR:

I followed through the following steps:  Highlighted the cells on APR_Calculator with data in:



Removed Gridlines and Print Headings:

 

Selected Print Chose to print just the selection:



Chose to fit the sheet to one page:

 

Clicked on Print Clicked another cell to remove highlighting

This is the macro code that was generated: Selects the data to print Removes Headings Removes Gridlines Fits to one page Prints selection

I assigned the macro to the button:

2aiv – Formulae with annotation See scanned printout 2aiv APR Calculator Annotated Formulae.pdf See answer file 2aiv APR Calculator Formulae and Functions.xlsm See answer file 2aiv APR Calculator (Formulae View).xlsm These are the named ranges I used:

All formulae are annotated on formulae printout sheet.

2bi – Ownership_Model worksheet See answer file 2bi Ownership Model.xlsm

2bii – Ownership_Model annotation See printout 2bii Ownership Model Formulae.pdf See answer file 2bii Ownership Model Formulae.xlsm Named Ranges:

APR Worksheet Names Named Age

Named APR

Ownership_Model Worksheet Names

OnTime APRBonus ContributionRate MinimumPayment AdditionalPayment StartDate CarValue Deposit HPValue

APR Bonus % Formula

If the Payment is On Time (OnTime) then 2 is deducted from the APR on the APR_Calculator worksheet, otherwise it is left as APR. Contribution Rate %

This multiplies the APRBonus rate by 0.3 which is 30%. Minimum Payment

This multiplies the HPValue by 0.25 which is 25%. Deposit

This multiplies the CarValue by 0.17 which is 17%

HP Value

This subtracts the Deposit from the CarValue

2biii – Completed Ownership_Model worksheet See printout 2biii Completed Ownership Model.pdf See answer file 2biii Completed Ownership Model.xlsm

2biv – Completed Ownership_Model annotation See printout 2biv Completed Ownership Model Formulae.pdf See answer file 2biv Completed Ownership Model Formulae.xlsm Named Ranges

CPI_Rates Worksheet Names:

Named: CPITable

Ownership_Model Worksheet New Names

ActualYear

AnnualPayment

Interest

HPYear

Balance

Actual Year Formula The first row simply uses the YEAR value from StartDate

Subsequent rows use the previous year (eg C14) and add 1 to the year. Interest Formula The first row multiplies the HPValue (Hire Purchase Value) by the APRBonus rate and divides by 100 because it is a percentage:

Subsequent rows start with the Balance from the previous year (eg F14) and multiply it by the APRBonus rate and divide by 100 because APRBonus is a percentage.

Annual Payment Formula This adds together the MinimumPayment, the AdditionalPayment and the Contribution Payment. The Contribution Payment is the AdditionalPayment multiplied by the ContributionRate divided by 100 (because it’s a percentage).

Subsequent rows start with the Annual Payment from the previous year (eg E14). They then lookup the CPI rate by looking up the ActualYear from the CPITable on the CPI_Rates worksheet and return column 2. One is then added to the looked up CPI rate so that it can be multiplied by last year’s Annual Payment.

Balance Formula The first year’s Balance is the HPValue for plus the AnnualInterest for the current year less the AnnualPayment for the current year:

Subsequent years use the previous year’s Balance (eg F14) plus the AnnualInterest for the current year less the AnnualPayment for the current year.

Ownership Year Function

The MATCH function looks up the AdditionalPayment (eg 450) in the AnnualBalance range. When it finds the highest value above (-1) the AdditionalPayment (eg 1840.48) then it returns the row number from the range. In this case it would be 3 which represents the number of years the AnnualBalance has not reached as low as the AdditionalPayment. Therefore, the Start Year needs to be added to the result to give the Ownership year. The Start Year is calculated by using the YEAR function on the StartDate.

2bv – Relative and absolute cell referencing

The formula in D15 uses absolute cell referencing for APRBonus which is a named CELL and relative cell referencing for F14 which refers to the previous year’s balance. The reason that F14 is RELATIVE is because it refers to a cell in the row above. When the formula is replicated down the spreadsheet then the next cell down is used:

The reason that APRBonus is ABSOLUTE is because when the formula is copied down, the APRBonus cell must NOT be changed to the cell below. This is achieved by making it a single named CELL rather than a RANGE.

The equivalent cell reference for APRBonus in D15 would be C$3. This would continue to be C$3 in D16, D16 etc.

2bvi – Cell and worksheet protection See answer file 2bvi Cell and Worksheet Protection.xlsm All cells are locked by default:

I unlocked the input cells on the Ownership_Model worksheet by selecting them all and then unlocking them:

I did the same on the APR_Calculator worksheet but I had to make sure the cells I unlocked included the cell links:

I then protected each of the worksheets so that the locked cells could not be edited or selected:

I repeated this for all 4 worksheets.

2c – Help sheet See answer file 2c Help Sheet.docx

2d – Test plan Test Number 1 Description Type of Test Input Data Value(s) Expected Output Value(s) APR % = 33.2 on APR_Calculator worksheet

APR % on APR_Calculator worksheet

Valid

APR_Calculator Worksheet: Employment Status = Casual Credit Rating = 4.9 Driving Licence Type = Provisional Guarantor = ticked Date of Birth = 16/04/1977

2

Eligibility statement on APR_Calculator worksheet

Valid

Driving Licence Type = None on APR_Calculator worksheet

Eligibility statement on APR_Calculator worksheet = “You are NOT eligible for a car hire purchase” APR Bonus % on Ownership_Model worksheet = 33.2

3

APR Bonus % on Valid Ownership_Model worksheet

APR % on APR_Calculator worksheet = 33.2 On-Time Payments on Ownership_Model worksheet = No

TASK 3 – WEBSITE
3a – Design specification Royal Return black Button to each web page TOP AREA width 100%, height 50 pixels, background

BUTTONS AREA width 100%, height 50 pixels, background black

MAIN AREA width 100%, height continuous Background white

Web page titles  Serif, White, 24 pixels, Bold Sub-titles  Serif, Black, 18 pixels, Bold Body text  Serif, Black, 14 pixels Buttons  White

3bi – CSS with annotation See answer file royalreturn.css The external file royalreturn.css was used and is referred to in the home page:

This is the content of royalreturn.css: Top Width = 100% (whole screen) Height = 50 pixels Background Colour = black Buttons Width = 100% (whole screen) Height = 50 pixels Background Colour = black Main Width = 100% (whole screen) Height = continuous so not specified Background Colour = white Body Font = Serif Size = 14 pixels Colour = Black Web Page Titles Font = Serif Size = 24 pixels Colour = White Emphasis = Bold Sub-Titles Font = Serif Size = 18 pixels Colour = Black Emphasis = Bold

3bii – Website pages See website folder 3 Royal Return Website See printouts:  3bii Home Page.pdf  3bii Fast Food.pdf  3bii Contact Us.pdf

3c – Map annotation I searched for B74 2YZ in Google maps and got this result:

B74 2YZ does not exist. I’ve therefore selected the option presented which is B74. I then copied the embed code from Google Maps:

I then pasted the embed code into the Contact Us page:

This is the Contact Us page with the map included:

3di – Validation rules with annotation I edited the HTML code to add some HTML5 attributes to the INPUT fields. Postcode This is the INPUT tag with the REQUIRED attribute:

The REQUIRED attribute means that some data must be entered (presence check). I left the Postcode blank and clicked on Submit. The error message below was displayed:

Email address This is the INPUT tag with the TYPE attribute set to email:

The email value means that an email address with data before and after the @ symbol must be entered. I typed “a” and clicked on Submit. The error message below was displayed:

Date of Last Visit This is the INPUT tag with the TYPE attribute set to date:

The date value means that a full date must be entered. I typed “02” for the day, left the rest blank, and clicked on Submit. The error message below was displayed:

Telephone number This is the INPUT tag with the PATTERN attribute set and the PLACEHOLDER attribute set:

The PATTERN attribute makes sure the user follows the given pattern which is 0 followed by 11 digits. [0] forces a 0. [0-9] forces a digit. {10} means that a digit has to be entered 11 times The PLACEHOLDER attribute adds an instruction for the user so the error message makes sense:

I typed “08282” and clicked on Submit. The error message below was displayed:

3dii – Flowchart See 3dii Flowchart.vsd (Microsoft Visio) Due to the similarity in task and most web forms working in a very similar way, it is not possible to show the entire answer.

Start

User Clicks Submit

Validation Check Yes

No

Error Message

Yes

Email to Royal Return

End

3e – Test plan Test Number Item to Test How to Test it Expected Result

1

Reset button on Contact Us page

Open the Contact Us Page. Type “Smith” into surname. Click on “reset”. Open the Home page and check the spelling of Royal Return at the top.

All the fields should become blank so that “Smith” is no longer displayed. The spelling of Royal Return should be “Royal Return” with capital R and R. The Mobile telephone number includes the instruction “Enter 11 digit telephone number with 0 and no spaces” Navigation bar should remain consistent throughout with “Home”, “Fast Food” and “Contact Us” links showing on a black background

2

Spelling on Home page

3

Firefox browser

Open the Contact Us page in Firefox

4

Consistent navigation bar

From the Contact Us page, open the Home page, then the Fast Food Page, then the Contact Us Page by clicking on the buttons

5

Validation for Postcode

On the Contact Us Page, leave An error message should the Postcode blank and click appear “Please fill out this on Submit field”