Turn on thread page Beta
 You are Here: Home

# 6953 Applied ICT Knowledge Worker Last Minute Laura watch

1. Me too..i wasnt taught any fomulas at all😭😭😭

Posted from TSR Mobile
2. hey christina_tw i also need help with the formulae, My email is [email protected],com
3. here guys i did some microsoft excel spreadsheets for the pre-release......
Attached Files
4. Richards LML_practice (example).xlsx (241.8 KB, 232 views)
5. Richards LML_practice (example 2).xlsx (241.6 KB, 229 views)
6. (Original post by Chris_sherry)
We understand this but what are the formulas we need to put into the spreadsheet for the depth and clearance.
I'm not too worried about the exam tbh, just have some water and relax and then put your hair in a man bun with some out the side and score against watford. its okay.
7. (Original post by deadline3)
here guys i did some microsoft excel spreadsheets for the pre-release......
you god, which one is it though for the depth in ext. you've got three different formulas shwoing three different reuslts ?
8. (Original post by joe_allen7)
you god, which one is it though for the depth in ext. You've got three different formulas shwoing three different reuslts ?
mate we dont really know what the formula is actually going to be otherwise we could smash the exam fella...
9. I have attached one worksheet using INDEX(MATCH( and one using VLOOKUP( for the Tide Start and End section.
Attached Files
10. 2.xlsx (241.5 KB, 189 views)
11. 3.xlsx (241.5 KB, 192 views)
12. (Original post by deadline3)
mate we dont really know what the formula is actually going to be otherwise we could smash the exam fella...
fair bruvah
13. i have figured out a possible formula for the depth in and out ! i just need help with the clearance in/out?
Attached Files
14. Last Minute Laura.xlsx (241.3 KB, 186 views)
15. (Original post by deadline3)
i have figured out a possible formula for the depth in and out ! i just need help with the clearance in/out?
I got u brah
Attached Files
16. LML_practice.xlsx (241.5 KB, 186 views)
17. (Original post by Joe_Allen7)
I got u brah
yes boi
18. What dates are you guys doing the exam?
19. Anyone done the exam yet?? What comes up??
20. (Original post by Chris_sherry)
What dates are you guys doing the exam?
27th boi
21. (Original post by 10splace)
27th boi
Me too
22. (Original post by christina_tw)
Hey guys just take it easy. So first of all the "depth in" is related to the "tide start", the "depth out" is related with the "tide end".Likewise "clearance in" is related with "tide start" , "clearance out" with "tide end". Now the depth represent the lowest values found in the "sights" sheet and the clearance with the lowest. If anyone needs help with the formulas please let me know and I will email you.Hope I helped

Thanks alot
23. hey christina_tw i also need help with the formulae, My email is [personal details removed]
24. 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.
25. (Original post by Chris_sherry)
What dates are you guys doing the exam?
Got mine on Monday 23rd May
26. (Original post by ciaranh98)
Got mine on Monday 23rd May
Mine is on 27th may

Turn on thread page Beta

### Related university courses

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 23, 2016
Today on TSR

### Edexcel C3 Maths Unofficial Markscheme

Find out how you've done here

### 3,320

students online now

Exam discussions

Poll
Useful resources

## Make your revision easier

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