Turn on thread page Beta

Anyone have any thoughts on the Edexcel Applied ICT 'Last Minute Laura' Pre release? watch

    • Thread Starter
    Offline

    1
    ReputationRep:
    I'm slightly concerned about the large amount of sheets and the fact that there is so much to do with time and tides - I know nothing about tides and struggle with converting things to time on excel!
    Offline

    0
    ReputationRep:
    Do you think that it is harder than last years Truckles
    Offline

    0
    ReputationRep:
    What formulas would be reccomended for this exam
    • Thread Starter
    Offline

    1
    ReputationRep:
    (Original post by jalizajade)
    Do you think that it is harder than last years Truckles
    Personally I think it looks a lot harder. I did the truckles exam as a mock and found it hard but this looks a lot more difficult, especially as someone who struggles with time.
    Offline

    0
    ReputationRep:
    Does anyone have any idea about what kind of tasks we might be asked to do?
    Offline

    1
    ReputationRep:
    I have been looking at IF(AND( statements to check if the tide is the right depth (Depth In & Depth Out), and asking it to return Y or N which correlates with their current conditional formatting. I have then used INDEX(MATCH( to get the tide start and end to work properly, still working on Clearance In and Clearance Out.
    Offline

    1
    ReputationRep:
    kill me now
    this is too hard for my small brain.
    help is needed
    Offline

    1
    ReputationRep:
    (Original post by ciaranh98)
    I have been looking at IF(AND( statements to check if the tide is the right height, and asking it to return Y or N which correlates with their current conditional formatting. I have then used INDEX(MATCH( to get the tide start and end to work properly, still working on Clearance In and Clearance Out.
    keep up the good work buddy
    good luck for your exam
    Offline

    0
    ReputationRep:
    (Original post by ciaranh98)
    I have been looking at IF(AND( statements to check if the tide is the right height, and asking it to return Y or N which correlates with their current conditional formatting. I have then used INDEX(MATCH( to get the tide start and end to work properly, still working on Clearance In and Clearance Out.
    Any ideas on the formulas for depth in and out?
    Offline

    1
    ReputationRep:
    (Original post by seemamohammed)
    Any ideas on the formulas for depth in and out?
    This is what I used the IF(AND( statements for and I asked it to return either a Y or a N depending on whether the Tide Start and Tide End meet the requirements (e.g. Bird Sanctuary must be between 1.6m and 20m). You only really need the IF(AND( statement for two of the attractions, Upton Manor and Fingals Cave, the others can just be IF( statements with < or >. But I used it for all of them so that you can just copy the formula for each one, saves time.
    Offline

    1
    ReputationRep:
    here ya go guys.. form your bestie on the chat room!!!!!!!!!!
    Attached Files
  1. File Type: xlsx Copy of Spy Game.xlsx (34.1 KB, 268 views)
  2. File Type: xlsx Richards LML_practice (example).xlsx (241.8 KB, 363 views)
  3. File Type: xlsx Richards LML_practice (example 2).xlsx (241.6 KB, 373 views)
    Offline

    1
    ReputationRep:
    This is what I think, I prefer using INDEX(MATCH( to VLOOKUP(.
    Attached Files
  4. File Type: xlsx 2.xlsx (241.5 KB, 347 views)
    Offline

    0
    ReputationRep:
    There are two more sheets if you right click on any page at the bottom and click unhide, you can unhide the october tides sheet and sheet3
    Offline

    0
    ReputationRep:
    Also, the examiner has been very sneaky and has hidden some data behind pictures so if you unprotect the worksheets using the password 'edexcel' you are able to move the picture and have full access
    • Political Ambassador
    Offline

    17
    ReputationRep:
    Political Ambassador
    (Original post by samiyahussain)
    Also, the examiner has been very sneaky and has hidden some data behind pictures so if you unprotect the worksheets using the password 'edexcel' you are able to move the picture and have full access
    I've just had a look at that and on the "selection" sheet, it gives the sights and a variety of times. Are these supposed to be clues or what? If I'm being honest, I don't even know what the **** I need to do
    Offline

    0
    ReputationRep:
    Anyone find flaws in the models?
    For activity 4 to evaluate the model we are often asked to suggest improvements for the model in the report..
    Also for Tide in and tide out, why cant we just use a vlook up instead of an INDEX MATCH
    • Political Ambassador
    Offline

    17
    ReputationRep:
    Political Ambassador
    (Original post by seemamohammed)
    Anyone find flaws in the models?
    For activity 4 to evaluate the model we are often asked to suggest improvements for the model in the report..
    Also for Tide in and tide out, why cant we just use a vlook up instead of an INDEX MATCH
    What do we actually have to do? What are all these activities?


    Posted from TSR Mobile
    Offline

    1
    ReputationRep:
    Yeah you can use VLOOKUP, whatever is easier for you to remember. One of the things that it mentions in the pre-release is that the tide cannot be so high that the boat hits the bridge when it goes underneath, however, the scenario does not specify what the height of the boat is.
    Offline

    1
    ReputationRep:
    There will be 4 activities:

    1. Understand the Scenario, find 10 points that you have noticed in the Scenario that are important, e.g. the max/min depths etc.
    2. Complete the Model
    3. Complete model extension tasks (you won't see these until you enter the exam)
    4. Complete Report & Evaluation including suggestions and graphs etc.

    All of these are similar for every exam if you look at any past papers.

    Time spent on each Activity:
    Activity 1: 15 mins (approx.)
    Activity 2: 60 mins (approx.)
    Activity 3: 30 mins (approx.)
    Activity 4: 35 mins (approx.)

    Times will change depending on the extension exercises, but the paper will tell you how much time is recommended you spend on each activity.

    Marks for each Activity:
    Activity 1: 17 Marks (approx.)
    Activity 2: 28 Marks (approx.)
    Activity 3: 28 Marks (approx.)
    Activity 4: 15 Marks (approx.)
    Standard ways of working: 2 marks

    Make sure your teachers have told you how to print specific areas of an Excel Sheet and make sure you print and save EVERYTHING the exam paper tells you to or you can lose unnecessary marks.

    If its not printed, it won't be marked.

    If it's printed badly, you will lose "standard ways of marking" marks.

    Make sure you know how to use "Show Formulas" on Excel as you will need to show the formulas you have used, not just the answer!

    Bear in mind that all of this information is based on a range of past papers, it doesn't mean it can't change, but this is unlikely, everything will probably stay fairly similar to past papers.
    Offline

    0
    ReputationRep:
    (Original post by ciaranh98)
    I have been looking at IF(AND( statements to check if the tide is the right depth (Depth In & Depth Out), and asking it to return Y or N which correlates with their current conditional formatting. I have then used INDEX(MATCH( to get the tide start and end to work properly, still working on Clearance In and Clearance Out.
    what does clearance mean??
 
 
 
Reply
Submit reply
Turn on thread page Beta
Updated: May 27, 2016

University open days

  • University of East Anglia
    All Departments Open 13:00-17:00. Find out more about our diverse range of subject areas and career progression in the Arts & Humanities, Social Sciences, Medicine & Health Sciences, and the Sciences. Postgraduate
    Wed, 30 Jan '19
  • Solent University
    Careers in maritime Undergraduate
    Sat, 2 Feb '19
  • Sheffield Hallam University
    City and Collegiate Campus Undergraduate
    Sun, 3 Feb '19
Poll
Brexit: Given the chance now, would you vote leave or remain?

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

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