Year 12s: what will be the first way you research your future options? >>

6953 Applied ICT Knowledge Worker Last Minute Laura

Scroll to see replies

Reply 40

Joe_Allen7

Mines on 27th but i got a europa league final to prepare for first

Reply 41

Joe_Allen7

Original post by ciaranh98

Got mine on Monday 23rd May

Would you be able to let us know about the types of questions being asked for each activity afterwards, would be a massive help, nice one. Just wondering what's going to be asked for activity 3 and 4 based off of what there has been in the past, thanks.

Reply 42

ciaranh98

I'm afraid not, plus, this forums rules do not permit it. However, I have attached an overview of the exam, based on a past paper which gives you lots of helpful hints and tips.

GCE Applied ICT Unit 3 - Exam Overview.docx42.6KB

Reply 43

Joe_Allen7

Original post by ciaranh98

I'm afraid not, plus, this forums rules do not permit it. However, I have attached an overview of the exam, based on a past paper which gives you lots of helpful hints and tips.

Why not? just email not on the forum, not exactly illegal or anything :biggrin:

Reply 44

zyteee

Answers:
Visits - '=COUNTIF($A$14 :colondollar:

A$19,H14)'
Tide Start - '=VLOOKUP(H14,$A$14 :colondollar:

E$19,4,FALSE)'
Tide End - '=VLOOKUP(H14,$A$14 :colondollar:

E$19,5,FALSE)'
Depth In - '=IF(J14<Sights!D12,"N","Y")'
Depth Out - '=IF(K14<Sights!D12,"N","Y")'
Clearance In - '=IF(J14>Sights!E12,"N","Y")'
Clearance Out - '=IF(K14>Sights!E12,"N","Y")'

Hope this helped! Try to learn them all off by heart.

Reply 45

Joe_Allen7

Original post by zyteee

Answers:
Visits - '=COUNTIF($A$14 :colondollar:

A$19,H14)'
Tide Start - '=VLOOKUP(H14,$A$14 :colondollar:

E$19,4,FALSE)'
Tide End - '=VLOOKUP(H14,$A$14 :colondollar:

E$19,5,FALSE)'
Depth In - '=IF(J14<Sights!D12,"N","Y" :wink:

'
Depth Out - '=IF(K14<Sights!D12,"N","Y" :wink:

'
Clearance In - '=IF(J14>Sights!E12,"N","Y" :wink:

'
Clearance Out - '=IF(K14>Sights!E12,"N","Y" :wink:

'

Hope this helped! Try to learn them all off by heart.

Have you done the exam already, or just predictions ?

Reply 46

zyteee

Original post by Joe_Allen7

Have you done the exam already, or just predictions ?

Haven't done the exam but these formula's work, just need to drag them down so they cover all the attractions.

Reply 47

teri7

Hi
Can you email me the formulas please

Reply 48

Joe_Allen7

Original post by zyteee

Haven't done the exam but these formula's work, just need to drag them down so they cover all the attractions.

Can't be certain that they will be the answers as the questions could be slightly different, but this is what we think the answers will be aswell so thanks :biggrin:

Reply 49

12345678912

Original post by 10splace

Anyone done the exam yet?? What comes up??

done it easy as 3.14

(edited 7 years ago)

Reply 50

Chris_sherry

Original post by 12345678912

done it easy as 3.14

Can you tell us what comes up, not like exactly but a general idea? Are we on the right lines with the formulas

Reply 51

zyteee

For activity 3, we're required to work out the tides for a month ourselves using SINE and COSINE. Then complete the tables using the same formulas as before.

Reply 52

qra_wt

Can anyone help with unit 3 ? can you tell me what to study and what will come up ? I already saw the pre lease material and learned some functions but I still don't think it's enough ! I'm really depressed about this exam and I feel that I will fail :frown:

, My teacher don't know that much about the exam and the exam is on monday.

I will really appreciate it if someone can help me

(edited 7 years ago)

Reply 53

qra_wt

Original post by zyteee

Answers:
Visits - '=COUNTIF($A$14 :colondollar:

A$19,H14)'
Tide Start - '=VLOOKUP(H14,$A$14 :colondollar:

E$19,4,FALSE)'
Tide End - '=VLOOKUP(H14,$A$14 :colondollar:

E$19,5,FALSE)'
Depth In - '=IF(J14<Sights!D12,"N","Y" :wink:

'
Depth Out - '=IF(K14<Sights!D12,"N","Y" :wink:

'
Clearance In - '=IF(J14>Sights!E12,"N","Y" :wink:

'
Clearance Out - '=IF(K14>Sights!E12,"N","Y" :wink:

'

Hope this helped! Try to learn them all off by heart.

Can you post the fromulas without the smiling face please :smile:

Reply 54

qra_wt

Did any one do the exam or have any revision notes or directions on how to study I'm really depressed from unit 3 and our teacher doesn't even know any thing and I feel that I will fail :frown:

I will really appreciate it if someone can help me :smile:

Reply 55

zyteee

Original post by qra_wt

Can you post the fromulas without the smiling face please :smile:

ignore the winking faces, nothing is being replaced by them.

The other faces should all be a COLON :

Reply 56

ciaranh98

Now, I have spoken to my teachers, and we have come to the conclusion that in the exam, we think they will provide the height of the boat, which will mean that we can calculate the clearance which we think is how much room you have before you hit the bottom of the bridge. We do not have any other ideas of what this could be until Monday.

Reply 57

Chloebak

I would also appreicate this!!

Reply 58

Icthelp565

Has anybody created a list of key points ready for the first question? Would be much appreciated. Thanks.

Reply 59

sausageroll714

Original post by Icthelp565

Has anybody created a list of key points ready for the first question? Would be much appreciated. Thanks.

· The Bird Sanctuary is accessible from a channel ifthere is at least 1.8m of tidal water.
· The sandbanks at Seal Flats are only visible whenthere is 3.8m of tidal water or less.
· To pass under the Bridge of Sighs, there must be no morethan 6m of tidal water.
· There also needs to be at least 2.5m of tidal water.
· The Bridge of Sighs needs to be passed both to andfrom Upton Manor.
· The spire of Matilda’s Secret can only be seen ifthere is 4m or less of tidal water.
· There needs to be at least 1.6m of tidal water to viewWilson Falls.
· Maximum height of tidal water for Fingal’s Cave is 6m.
· Minimum height of tidal water for Fingal’s Cave is2.5m.
· Each boat trip must visit every attraction.
· All boat trips must start and finish at the marina.
· When passing the marina there is a speed limit of 8knots.
· For the rest of the trip the speed of the boat will be 15 knots.
· The times and order of the visits will depend on the height of the tidal water.