Today lesson you will need to continue with adding content to your website. In todays lesson you will need to create roll over images into your website, can you add a minimum of three roll over images.
Author: Mr Ali
Year 9 – lesson 5
Complete the Paris costs spreadsheet , if you have not already started the evidence sheet click on the link below to download it:
If you have finished the Paris costs evidence ensure all files for unit 1 are in the correct folder.
You may then create a Xmas card in Publisher or word
Year 7 – Cover for lesson 4
Your task is to find the cheapest prices for a range of Xmas products use the sheet below and the internet to carry out your task:
Year 10 – Cover lesson 3
In todays lesson continue with your websites, you should have at least 3 pages of content on your website. Remember the content of your website can be straight of the internet, your role is to arrange it into a suitable format for publishing on the web.
Year 11 cover – lesson 1
You will need to continue with your website, Please complete the tasks below if you have already completed a task move on to the next task:
- Complete your 5 page website with at least the following:
- suitable hyperlinks system
- 5 unique images
- 1 external link ( minimum)
- 1 email link
- user form
- at least 1 roll over image
- 1 image link or hotspot
- suitable hyperlinks system
- Complete evidence sheet ( website checklist )go onto the moodle site for the example evidence sheet if you get stuck.
- Print out each of your webpages to PDF from Internet Explorer and not Dreamweaver (these must be saved in your AO2 folder
- Evaluate your website use the sheet below to help you.
- Go onto the moodle site and unit 2 course, move down to task 6 and complete the testing for your website. Use the example to help you.
Lesson 4 – Functional skills ICT
AO5 – Task for unit 1
Business Spreadsheet for the French trip
In this task you will design & create a spreadsheet for your work on the French trip. You will need to use some of the information that you found in Task 2 when completing this task. If you remember, you did some research on the costs of travelling to Paris.
Your spreadsheet should present the costs involved for at least two of the different trip options.
For Pass level you need to complete parts A, B, C, D, E and F of this task.
Task A: Design and create a spreadsheet to display information for at least two options for the
French trip.
For example your spreadsheet could include:
- transport costs
- entry fees for visitor attractions (sightseeing/places of interest)
- cost of evening activities
- number of people
Your spreadsheet must include column headings, row labels, a title, text and numeric data.
It maybe a good idea to draw the spreadsheet on paper first with headings to give you an idea of what you will try to produce.
Task B: Create appropriate formulas to calculate
For example:
- total cost of each option
- cost per person
- cheapest/most expensive cost.
You must use at least two different calculations in your spreadsheet.
TIP
For Merit level you must use several different formulas including at least one function and one arithmetic operator.
For Distinction level you must use several different formulas including at least two different functions and two different arithmetic operators.
Task C: Format your spreadsheet so that the information is displayed effectively
You might, for example, format:
- text (font, style, size, colour, alignment)
- numbers (decimal places, percentage, currency, date/time)
- cells (apply borders and/or shading).
Task D: Print out your spreadsheet:
- clearly showing all data
- in formula view showing all formulas in full (Higher levels only)
TIP
For the higher levels you will need to preview before printing and make sure you have chosen the options that will fit your sheet most effectively onto the paper. (you should printscreen using print preview)
For Distinction level you should also set appropriate headers and footers and other appropriate print options (eg margins, gridlines, row and column headings, setting a print area).
Task E – Making changes to the spreadsheet model to change outcomes
Change some numeric data to model the expected outcome for at least two different scenarios, for example you might increase and/or decrease the transport cost to investigate what happens to the final cost or you could investigate what would happen to the total cost of the trip if the entry fees to the attractions were increased and/or decreased.
Print the results of each change and annotate the changed outcomes as a result of the changes you carried out.
(Higher levels only)
The efficiency of your spreadsheet, including the formulas you have used, as well as the appropriateness of the formatting options you have applied, will be a significant factor in determining the grade you are awarded for this Assessment Objective.
(Evidence could be printouts of the original and changed spreadsheet and for the higher levels formula printouts. At Pass level you might evidence your formulas through the electronic file of your spreadsheet or through screen prints. Changes to data and setting of print options should be
annotated.)
Year 10 – Lesson 3
You need to continue with your website. You should have created a template and applied it to Five other pages. Now it is a matter of finding and adding content to each of your pages.
If you are unable to perform a task use the tutorials on the link below to help you:
Unit 2 – Creating a multimedia website
Today you will:
Complete your dreamweaver template
Ensure it has editable regions to add information for each page
Remember you need a website which has the following:
- 5 pages
- 5 unique images
- email link
- external link
- roll over image X 3
- User Form