You are Here: Home

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

1. 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!
2. Do you think that it is harder than last years Truckles
3. What formulas would be reccomended for this exam
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.
5. Does anyone have any idea about what kind of tasks we might be asked to do?
6. 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.
7. kill me now
this is too hard for my small brain.
help is needed
8. (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
9. (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?
10. (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.
11. here ya go guys.. form your bestie on the chat room!!!!!!!!!!
Attached Files
12. Copy of Spy Game.xlsx (34.1 KB, 268 views)
13. Richards LML_practice (example).xlsx (241.8 KB, 363 views)
14. Richards LML_practice (example 2).xlsx (241.6 KB, 373 views)
15. This is what I think, I prefer using INDEX(MATCH( to VLOOKUP(.
Attached Files
16. 2.xlsx (241.5 KB, 347 views)
17. 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
18. 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
19. (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
20. 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
21. (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
22. 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.
23. 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.
24. (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??

TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: May 27, 2016
Today on TSR

Four simple steps to get an A*

Here's all you have to do

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
Sat, 2 Feb '19
• Sheffield Hallam University
Sun, 3 Feb '19
Poll
Useful resources

Can you help? Study Help unanswered threadsStudy Help rules and posting guidelines

Groups associated with this forum:

View associated groups

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