Hey there! Sign in to join this conversationNew here? Join for free
    Offline

    2
    ReputationRep:
    Mines on 27th but i got a europa league final to prepare for first
    Offline

    2
    ReputationRep:
    (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.
    Offline

    1
    ReputationRep:
    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.
    Attached Files
  1. File Type: docx GCE Applied ICT Unit 3 - Exam Overview.docx (41.6 KB, 424 views)
    Offline

    2
    ReputationRep:
    (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
    Offline

    1
    ReputationRep:
    Answers:
    Visits - '=COUNTIF($A$14A$19,H14)'
    Tide Start - '=VLOOKUP(H14,$A$14E$19,4,FALSE)'
    Tide End - '=VLOOKUP(H14,$A$14E$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.
    Offline

    2
    ReputationRep:
    (Original post by zyteee)
    Answers:
    Visits - '=COUNTIF($A$14A$19,H14)'
    Tide Start - '=VLOOKUP(H14,$A$14E$19,4,FALSE)'
    Tide End - '=VLOOKUP(H14,$A$14E$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.
    Have you done the exam already, or just predictions ?
    Offline

    1
    ReputationRep:
    (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.
    Offline

    0
    ReputationRep:
    Hi
    Can you email me the formulas please
    Offline

    2
    ReputationRep:
    (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
    Offline

    0
    ReputationRep:
    (Original post by 10splace)
    Anyone done the exam yet?? What comes up??
    done it easy as 3.14
    Offline

    0
    ReputationRep:
    (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
    Offline

    1
    ReputationRep:
    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.
    Offline

    0
    ReputationRep:
    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, 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
    Offline

    0
    ReputationRep:
    (Original post by zyteee)
    Answers:
    Visits - '=COUNTIF($A$14A$19,H14)'
    Tide Start - '=VLOOKUP(H14,$A$14E$19,4,FALSE)'
    Tide End - '=VLOOKUP(H14,$A$14E$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.
    Can you post the fromulas without the smiling face please
    Offline

    0
    ReputationRep:
    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

    I will really appreciate it if someone can help me
    Offline

    1
    ReputationRep:
    (Original post by qra_wt)
    Can you post the fromulas without the smiling face please
    ignore the winking faces, nothing is being replaced by them.


    The other faces should all be a COLON :
    Offline

    1
    ReputationRep:
    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.
    Offline

    0
    ReputationRep:
    I would also appreicate this!!
    Offline

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

    0
    ReputationRep:
    (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.
 
 
 
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • Poll
    What's your favourite Christmas sweets?
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

    Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

    Quick reply
    Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.