How to tackle the ICT 2 Controlled test

N Kay

Task 1 Leaflet

Task 2 Mailmerged letter

Task 3 Presentation

PowerPoint or web pages

Preparation time 15hour controlled conditions

Evaluation

Data compression techniques

Task 1Purpose of the leaflet

Read the exam question and put it in your own words

Jan 08 Task 1 a programme or leaflet to be handed to clients/customers giving information on the organisations products or services.

Image and ethos

• Is created by using a name, logo, slogan, colour scheme, associated with the values or ideas connectec to a product or service or organisation

What could convey the image of the organisation?

• Logo

• Colour scheme

• Type of font

• Type of presentation

Logos

STRONG AND SOLID

TRADITIONAL

FUN

FUTURISTIC

Colour schemes

WARNING STRONG DANGER

ENVIRONMENT RURAL

GIRLY

Fonts

•CELTIC

•TRADITIONAL

•HERITAGE

•BILINGUAL

Rural

Friendly

Fun

Welcoming

Type of presentation

SOLICITORS

Black and white

Straight

Clear

What are the main features of this logo?

•Clear Font

•Evenly spaced gives

uncluttered image.

•Clear and easy to read

style of presentation

•Formal but not officious

Presentation style

•The logo appears on all their documents so this is a consistent theme

•Black and white is a consistent theme

•Straight lines are a consistent theme

•Clear , uncluttered . Good use of space , evenly spaced font easy and

clear to read represents their brand image of CLARITY

Consistent themes

Examine the house style of the next two organisations

• Recycling

• Panacea

What image are they trying to project and how do they achieve it?

Green = environment

Recycling logo = sustainability

Cartoon imagery = unfrightening / everyone can do it

Subtle pinks

Female – all age groups

Sophisticated font

Not too youthful so for older sophisticated ladies as well

Image and ethos WRONG answersColourful

xInteresting

xInformative

xProfessional ?

xIt is friendly and inviting

x

When the colour are dark and sombre and contains skull and cross bone logos

Design of the leaflet

• 1 mark was awarded for an outline layout with inherent page orientation and identifying which frames were text and which were for pictures.

• 1 mark was awarded for details of the ‘data’ both text and graphics

• 1 mark was awarded for details of fonts and font sizes to be used

• 1 mark was awarded for details of special features used such as margins, tab settings line spacing paragraph styles etc.

IMPLEMENTATION IS NOT DESIGN

Do not put in screenshots of implemented systems in the design section

Text 3 pictures

Table Text

Picture

Watermarked pic Picture

Hotel Facilities

the hotel facilities

• 3 swimming pools

•Bar

•Games room

•etc

3 pictures of Cyprus from the Internet showing the sea hotel and old town

Prices of rooms in the hotel

List giving facilities in each of the rooms the room•Single /Double

•Bathrooms

•Mini Bar

•Etc

Picture of bedroom from Internet

Watermarked picture of swimming pool from the Internet

Clipart of sun from Word clipart

Hotel facilitiesFrench script 20 pts

Bullet point list of the hotel facilities• 3 swimming pools

•Bar

•Games room

•etc

French script 18 pt

3 pictures of Cyprus from the Internet showing the sea hotel and old town

Table giving the prices of rooms in the hotel

Bullet point list giving facilities in each of the rooms the room

•Single /Double

•Bathrooms

•Mini Bar

•etc

French script 18 pts

Times new roman 16 pts

Picture of bedroom from Internet

A4 Landscape border 1.5 cm

Watermarked picture of swimming pool from the Internet

Wordart Arial 20 pt

Clipart of sun from Word clipart

Hotel facilitiesFrench script 20 pts

Bullet point list of the hotel facilities• 3 swimming pools

•Bar

•Games room

•etc

French script 18 pt

3 pictures of Cyprus from the Internet showing the sea hotel and old town

Table giving the prices of rooms in the hotel

Bullet point list giving facilities in each of the rooms the room

•Single /Double

•Bathrooms

•Mini Bar

•etc

French script 18 pts

Times new roman 16 pts

Watermark Picture of bedroom from Internet

A4 Landscape border 1.5 cm

Watermarked picture of swimming pool from the Internet

Wordart Arial 20 pt

Clipart of sun from Word clipart

Bold centre underline

Double line spacing

Pagination 1

Indent bullets

Evidence –all features must be on the final document

We only need evidence for the following basic skills • Origen of graphics• Headers and footers must be on the final document

• Everything else we can see on your printed document

• Annotating your document would help us a lot in case we miss something!!!!

Do not crop screen shots

Advanced skills- Safer to do at least 6

We need before and after screen shot evidence of;• Different paragraph formats (evidence before and after)• Different line spacing (evidence before and after)• Superscript and subscript (Sensible use ;not automatic th )• Set and use own tabs (evidence in annotated screen shots) Do not give automatic tabs created by bullet points)• Set and use own indents (evidence in annotated screen

shots)• Watermarks (if not clear show the process)• Use of layering (must see forward and behind)On your final document we can see•Customised tables – cell merging / text direction not just coloured cells or borders •Page or frame borders•Pagination

Remember to printout your final document!!!!!

And annotate the features on this document

Be very careful about cropping screenshots and cutting out the evidence must see document behind

Task 2 Mailmerge•Purpose – see exam paper•Image and ethos-professional ……….. formal

•Design – 1 mark was awarded for the basic layout and page orientation–1 mark was awarded for automated features including fields and macros. –must write in the names of the fields–1 mark for font styles and sizes used –1 mark was awarded for the data on the document including origin of graphics and description or planning of the data in the letter.

Task 2 a mailmerge letter to clients/customers inviting them to the promotional evening.

Mailmerged letter marking scheme• Import data from an external source• 1 mark was awarded for the wordprocessed template document

showing the fields incorporated into the document• 1 mark was for evidence of the database used, usually a screenshot or

printout.• Use of suitable format and layout for data• 1 mark for a suitable letter i.e matches the exam question/

professional• 1 mark no capital letter or spelling mistakes in the letter or in the

data imported from the database. Names and addresses in the database had to be realistic and not nonsense. The layout had to be professional and contain contact details of the organisation. The layout had to be clear not squashed into the top third of the page and should not contain graphics put in as watermarks which obscured the writing.

• Ensure automated routines work• 1 mark for printouts of the letter. There should be at least 3 records /

letters. One example would not get a mark.• 1 mark was given if there were no spacing errors in the merged data.

No Contact details

No Title

Spelling mistake

Letter not professional and squashed on top

half of page

Spacing Error in merged

data

3 recorded macros

Use INSERT DATE - do NOT type in the date

Do NOT copy and pasteinsert from a file

Other common recorded macros• Insert a logo from a file

• Insert letter head

• Insert headers and footers

• Insert ref numbers

• Edit the font and font size so suitable for visually impaired

Evidence

Just print out the macro code

No need to show how you recorded them !!

• Sub insertdate()• ' insertdate Macro• ' Macro recorded 9/26/2007 by kay• Selection.InsertDateTime DateTimeFormat:="dd/MM/yy", InsertAsField:=True, _• DateLanguage:=wdEnglishUK, CalendarType:=wdCalendarWestern, _• InsertAsFullWidth:=False• End Sub

• Sub hotellogo()• ' hotellogo Macro• ' Macro recorded 9/26/2007 by kay• ActiveDocument.Shapes.AddTextbox(msoTextOrientationHorizontal, 261#, _• 9#, 72#, 54#).Select• Selection.ShapeRange.TextFrame.TextRange.Select• Selection.Collapse• Selection.InlineShapes.AddPicture FileName:= _• "\\Filestore\docs\Teachers\kay\My Pictures\hotel.jpg", LinkToFile:=False, _• SaveWithDocument:=True• Selection.ShapeRange.Line.Visible = msoFalse• End Sub

Sub footer()' footer Macro' Macro recorded 9/26/2007 by kay' If ActiveWindow.View.SplitSpecial <> wdPaneNone Then ActiveWindow.Panes(2).Close End If If ActiveWindow.ActivePane.View.Type = wdNormalView Or ActiveWindow. _ ActivePane.View.Type = wdOutlineView Then ActiveWindow.ActivePane.View.Type = wdPrintView End If ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader If Selection.HeaderFooter.IsHeader = True Then ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageFooter Else ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader End If Selection.Fields.Add Range:=Selection.Range, Type:=wdFieldPage Selection.ParagraphFormat.Alignment = wdAlignParagraphCenter ActiveWindow.ActivePane.View.SeekView = wdSeekMainDocumentEnd Sub

Common Advanced features

• Editing the toolbar to put images for your recorded macros – print screen the toolbar with the document open ;do not crop. We must see the mailmerge document and the images on the toolbar

• Save mailmerge doc as a template – must see evidence it was done

• Re-use mailmerge template for other use- must have a related use

• Run the mailmerge again so print all database data in document again for new related use

Task 3 Presentation

PowerPoint

Or

Web page

• At least 3 pages but no point in doing anymore you are just wasting time

Purpose – see exam paper

Ethos

• Must be different to others

• You cannot have one global ethos

Not acceptable – colourful / interesting etc

Task 3 a screen based presentation giving clients/customers information about events and any special offers available during the evening using either web pages or a PowerPoint type show

Design

• 1 mark is for the basic background style and outline layout of the presentation with inherent page orientation and identified which frames were text and which were for pictures

• 1 mark is for details of the data both text and graphics in theses frames

• 1 mark if they added details of fonts and font sizes used.

• 1 mark is for details of animation, transition, hotspots, hypertext, bookmarks sound and video etc.

• Background styles do not use those in design library must be your own and the same theme on every slide

• Animation effects *** Using the internal features of the software

• Transition effects ***• Hypertext – must show url • Hotspots – must show url or slide No / anchor• Bookmarks – must show slide no / anchor

*** EVIDENCEDO NOT CROP

MUST SEE PRESENTATION IN BACKGROUND

Evidence of bookmarks hyperlinks and hotspots

Lets see the page or slide in the background

Sound

• 1 mark use of sound – internal to package e.g.. screeching noise or load sound from MP3 player or disc

• 1 mark for showing how you captured the sound e.g. screenshots of you downloading it from the Internet or recording it in sound recorder

Original video

• Use of original video• 1 mark record video drop it into presentation

unaltered (1) If a group take a video use different parts for your presentation do not use the same part

• 1 mark for extra features e.g. planning/story board of the video not the slides/ transcript of text /quality of video (editing sound to transition cuts and effects

• Must be own cannot copy

Animated effects on videoThere were generally three approaches to this sectionAnimated Images• 1 mark for simple ‘flash type animation • (three commands) e.g.. create ball then make ball bounce and roll or an

animation created from sites such as 3Dtextmaker.com • 1 mark a more complex one More than three commands /features/layers

put in• NB animated Gifs not produced entirely by the candidate gained no marks.

Video editing• 1 mark was awarded for one effect put onto a video e.g.. transition effects

or editing effects where evidence was provided.• 1 mark was given for an additional effect such as scrolling titles or credits,

screen effects such as sepia effects where evidence was provided. • In the case of screen effects before and after evidence would be needed.• Provide screenshots of your video in the movie package e.g..

moviemaker

A mixture of these two approaches

Video Flash type animation

Video effects

1 Simple animation

1

Titles and credits

1 Complex animation

1

There is only a max of two marks so pick the pattern you want to get the two marks

Evidence of video editing along with a written description of how you tried to match the sound and transitions and

length of film and sound track

EvaluationMust be done in 15 hour test No teacher help

A detailed and critical evaluation of all three tasks which examines the data, system and suggests future modifications 5-6 marksA detailed evaluation of all tasks, which addresses the system and future modifications

4- 3 marksNot all tasks have been evaluated or only a brief evaluation of all three tasks and limited suggestions for future modifications

2-1 marks

NO running commentaries of what you did

Compression Techniques used Must be done in 15 hour test No teacher help

• Identification of method • Discussion of the relative merits/properties of

and need for compression format such as JPEG, TIFF, WAV etc…..

• Or • Did you explain why we use compression

techniques?• Did you justify your chosen format? • If only a general description do not give the

second mark

Task Compression used

WhyWhat is the difference between them and why did you choose the one you used

Leaflets and mailmerge docs

.doc

.txt

Images .bmp

.jpeg

.gif

Sound Wav

Mp3

Movies Avi

Mpeg3

.mov

.rv

PRINTOUT !!!!!!!!!!!!!

• LEAFLET

• LETTERS

• PRESENTATION