Task 1: Create the evidence file with the header details as requested Task 2: Create folders as requested Task 3-5: Place the correct files in the correct folders Task 6: Open the CSV file using excel Task 7:
Insert Header and footer Click on left box and add “Week 29” Click on right box and add candidate details
Task 8:
Go to footer and enter the text Last edited on” Add a space and then click on current date icon Add a space and then click on current time icon
Task 9
Go back to view > normal Highlight cells A1:G11 and merge Change to 24pt, Black, Serif (Times New Roman) The background is grey stripes o Right click > format cells > Fill > Pattern Colour and Pattern Style
Task 10: Right click > Format cells > Number > Currency Task 11: Highlight range > File > Print selection Task 12:
=VLOOKUP(A22,$A$10:$B$18,2,FALSE) A vertical lookup Checks to see what A22 stands for In the range $A$10:$B$18 (which must remain absolute when copied) Returns the value in column 2 (column B in this case) False is included as we want an exact match
Task 13: =AVERAGE(F22:F58)
Task 14: Highlight range (A4:B7) > right click > define range Task 15: =VLOOKUP(C22,RATE,2,FALSE)*F22
Is a vertical look up Checks to see what C22 means in the range called RATE Returns the value in the second column in the range (column B) False is there as we want an exact match Multiplied by column F as this is the hours worked column
Task 16: =SUM(G22:G58) formatted as currency Task 17:
Remember to save as Excel and NOT CSV To print formulae and functions o Click on formulas tab > show formulas o Now resize the column widths File > print > Orientation > Landscape To fit on one page you may have to change font size To print row / column headers and gridlines o Page Layout > Gridlines > Tick view and tick print o Page Layout > Headings > Tick view and tick print
Task 18: Highlight rows 3 to 18 > right click > hide Task 19: Switch off show formula and adjust column widths again before printing Task 20: Highlight rows 59 and 60 > right click > hide Task 21:
Highlight cells A21 to G21 Click on data and then filter Go to the down arrow next to job description and click on it o Choose text filters > contains > ski > OK With these results on the screen go to the down arrow next to Hours worked o Choose number filters > greater than or equal to > 25 > OK
Task 22: Print the results making sure everything is visible
Web Authoring 23. Simplest program to resize an image is Paint, although you could also use Gimp
Open the image in paint
24. Still using Paint
Click on resize Make sure that pixels are selected Make sure that “maintain aspect ratio” is ticked Type in 720 into the horizontal Take a screen image
25. Save the image making sure that:
you have renamed it you have kept it as a jpeg you have placed it in the correct folder
26. Reduce the image resolution
Gimp is a better program to use to change the resolution of an image Open the image in gimp Click on File > Export Make sure that select file type is jpg (JPEG) Change the file name to J12BACKGD6.jpg Click on Export Move the quality slider to the a lower number (in this case about a ¼ of the original image just to make it obvious)
Take the screen shot and place it in your evidence file Take another screenshot to compare the file size before and after
27. No tiling
This comes into effect when actually using the image in your browser. Do not tick this as done until you have actually covered it later.
28. Create a new webpage called XA.HTM
In notepad create the following:

When you open this in your browser you will see that your image is now the background and that it is tiled.

As per task 27, resize your browser window so that the image does not appear tiled. You can now tick task 27.
Task 29 – Tables
You do not do anything with this task – the image is there as a reference point for the next steps. Do not tick this until you have all three tables completed as shown
Task 30 – Table A
Open the file J12TABLE4.HTM in notepad
Copy and paste the table part into your webpage XA.HTM
 
It is a good time now to read ahead to see if you need to save this page as anything other than XA.HTM As you do not, it is sensible to save it as this point to check what it looks like in your browser
This looks like TABLE A in Task 29 which is a good indication that you are on the right lines!
Task 31 – Table widths
Add the following width size inside the Table tag
Task 32 – replace text
Replace the text as stated with the following anchor
Note that there is no text before the </a> - this is so that the anchor has no visible text as requested by the task Remember to regularly save your work and to refresh the page on the browser so that you can see your progress.
Task 33 – Replace text
Replace the text as shown below
Save your work / refresh your browser
Task 34 – Create table B
First create a table that has 4 columns and two rows by using the following code
Use id=”table2” to maintain the convention in the first table Use rowspan=”4” to make the first row span over for rows, effectively merging it over four rows. Save and refresh your browser
35. Set the width of this table to 75% of the width of the window
Use the following code
Save and refresh your browser
36. Align Table B to the centre of the window
Use this code
Save and refresh your browser
37. Place image in left cell
Use this code
Save and refresh your browser
38. Add contents from J12TXT32.TXT
You have been given this text file so that you can copy and paste rather than wasting time typing in Top right cell of table B is the first row <TR> in the second column <TD>
The second row is the second <TR> and as you have used rowspan earlier there should only be one <TD>
Similar for the remaining rows
Save and refresh your browser
39. Format all the text in previous step to h3
Include the <h3> tag at the beginning of each sentence Include the </h3> tag at the end of each sentence
Save and refresh your browser
40. Create Table C using the contents of J12TABLE6.HTM ď&#x201A;ˇ ď&#x201A;ˇ
Open the file using notepad and then copy the table elements Paste these into XA.HTM
41. Set table width of the bottom table to 100% of the width of the window
42. Replace the text “Place anchor here” with non-visible anchor called “combine”
No text should be between > and </a> as task says “not visible in the browser”
43. Create a hyperlink from text “Combination Holidays” in Table A to anchor “combine”
Find the correct location in Table A Include the html shown
44. Return to top of this page using a hyperlink to the anchor called “start”.
Be careful which words you include as clickable; should only be “clicking on this link”
45. Date and time here
This is so that the examiner can see when the page was created. No HTML is required.
46. Cave Swim image
47. Scuba diving image & create a hyperlink to J12DIVE.htm to open in new window called “_ocean”
As with all images, remember to include the “alt” tag
48. Skiing image
49. ATV image
50. Contact us image & hyperlink to email message with subject line “Xtreme Holidays”
Note the lack of spaces on the hyperlink line. The space between Xtreme and Holidays is used by including %20. You should be able to do this by just using a space. Remember the alt tags after the image source.
51. All images in 46-50 are 120 pixels wide and maintain aspect ratio
Use the width tag as shown You do not need to do anything about the aspect ratio. As long as only the “width” OR the “height” tags and used and not both, the aspect ratio will be maintained.
52. View and print from browser
To print the page from the browser: right click > print To print code from browser: right click > view page source, then right click > print Also remember to print a page from notepad
53. Attach stylesheet to J12DIVE.HTM
54. Replace candidate text with your name and details
55. Replace “Heading here” with “Enjoy your drives with:”
Be careful about spacing, especially with regards the colon
56. Copy the list from J12FISH.TXT (opened in notepad) to J12DIVE.HTM and then format as lists
57. First list as ordered
See image in 56 above
58. Second list as unordered
See image in 56 above
59. Replace “image here” with scuba diving image from Web32 folder.
60. Printing
To print the page from the browser: right click > print To print code from browser: right click > view page source, then right click > print Also remember to print a page from notepad