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

HollySmithGang7
Badges: 0
Rep:
?
#21
Report 2 years ago
#21
Anyone worked out the Clearance in/out formula?
0
reply
samiyahussain
Badges: 0
Rep:
?
#22
Report 2 years ago
#22
(Original post by GeorgeB16)
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
I assume they are supposed to be clues, I haven't quite worked it out fully yet however, if I was to give a tip, I would say annotate the spreadsheet, it really helps and add the map to it and link it to the spreadsheet. Remember that the pre release is the biggest clue, add bits and bobs from the pre release on to your spreadsheet
0
reply
samiyahussain
Badges: 0
Rep:
?
#23
Report 2 years ago
#23
(Original post by s.mm)
what does clearance mean??
Clearance in and out are the columns on the selection sheet which go red and have an N for no and Y for yes.
0
reply
s.mm
Badges: 0
Rep:
?
#24
Report 2 years ago
#24
(Original post by samiyahussain)
Clearance in and out are the columns on the selection sheet which go red and have an N for no and Y for yes.
thanks, but what does clearance mean? like the depth in and out refers to the height of the water...
0
reply
Student-007
Badges: 6
Rep:
?
#25
Report 2 years ago
#25
(Original post by s.mm)
thanks, but what does clearance mean? like the depth in and out refers to the height of the water...
As far as I believe clearance is the space above the boat ( e.g if they go inside fingals cave then they need enough headspace to move about )
0
reply
Student-007
Badges: 6
Rep:
?
#26
Report 2 years ago
#26
(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
If you mean tide start and tide end I've been practising and using a vlookup?
0
reply
Chris_sherry
Badges: 0
Rep:
?
#27
Report 2 years ago
#27
(Original post by HollySmithGang7)
Anyone worked out the Clearance in/out formula?
I think the formula will be along the lines of:
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")'
0
reply
R1CH101
Badges: 1
Rep:
?
#28
Report 2 years ago
#28
Has anyone got any clues about the 2 hidden sheets????

Personally I think they are there to show how the model was evolved.

I tried to add the October tides to the model but their is data missing or the data is in the wrong place.
0
reply
Enchando
Badges: 0
Rep:
?
#29
Report 2 years ago
#29
What i have been thinking is that for tide start and end, all you have to do is vlookup the table to the left to find the name of the place and then display what it says. For depth in (dont know if it is right so dont believe me!)you use an if statement to look up whether tide start is bigger than (in sights worksheet) the "lowest" value of the corresponding location -if it does then y will be displayed- for depth out its the same except switch tide in to tide out. Clearance is the same, except see whether the tide start/end is smaller than the "highest" values. any critique would be appreciated!
0
reply
R1CH101
Badges: 1
Rep:
?
#30
Report 2 years ago
#30
(Original post by Enchando)
What i have been thinking is that for tide start and end, all you have to do is vlookup the table to the left to find the name of the place and then display what it says. For depth in (dont know if it is right so dont believe me!)you use an if statement to look up whether tide start is bigger than (in sights worksheet) the "lowest" value of the corresponding location -if it does then y will be displayed- for depth out its the same except switch tide in to tide out. Clearance is the same, except see whether the tide start/end is smaller than the "highest" values. any critique would be appreciated!
Hi

I think thats correct as that is what I done as well

Any ideas about the two hidden sheets ???
0
reply
Enchando
Badges: 0
Rep:
?
#31
Report 2 years ago
#31
From what I can tell it uses sin and cosine, and could be part of the october tides. We could get given october tides as something to add to the database later-but who knows tbh, just keep going through the spreadsheet I guess and practise importing data and using the formulas.
0
reply
s.mm
Badges: 0
Rep:
?
#32
Report 2 years ago
#32
(Original post by ciaranh98)
This is what I think, I prefer using INDEX(MATCH( to VLOOKUP(.
why are you repeating the condition in clearance; you are checking for the tide to be lower than the highest value in sights worksheet, but that is already tested for depth in/out in your IF(and( formula.

So dont you think it is better to use the fromula:
Depth In - '=IF(J14<Sights!D12,"N","Y")'
Clearance In - '=IF(J14>Sights!E12,"N","Y")'
0
reply
s.mm
Badges: 0
Rep:
?
#33
Report 2 years ago
#33
(Original post by Enchando)
What i have been thinking is that for tide start and end, all you have to do is vlookup the table to the left to find the name of the place and then display what it says. For depth in (dont know if it is right so dont believe me!)you use an if statement to look up whether tide start is bigger than (in sights worksheet) the "lowest" value of the corresponding location -if it does then y will be displayed- for depth out its the same except switch tide in to tide out. Clearance is the same, except see whether the tide start/end is smaller than the "highest" values. any critique would be appreciated!
that's exactly what I am thinking about, but dont you think there needs to be a nested if there somewhere in either depth in or clearance in checking for it to be higher than the lowest as well as lower than the highest.
0
reply
BlueSpice
Badges: 1
Rep:
?
#34
Report Thread starter 2 years ago
#34
(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
I was looking at this the other day, I would say maybe to add a reset button on the selection sheet to remove the routes in one click so the next month can be inputted faster. Also maybe to hide any sheets which don't need to be changes frequently as there are a lot of them.
0
reply
BlueSpice
Badges: 1
Rep:
?
#35
Report Thread starter 2 years ago
#35
(Original post by s.mm)
that's exactly what I am thinking about, but dont you think there needs to be a nested if there somewhere in either depth in or clearance in checking for it to be higher than the lowest as well as lower than the highest.
Does it need to be as complicated as that though? This is what i did for depth in:
=IF(J14<Sights!D12,"N","Y")

The clearance could be very similar or if we are given a min clearance then you could do something like:
=IF(J14>=$Q$14,"Y","N") The Q14 is just a cell where i've added a min clearance.


Any thoughts?
0
reply
BlueSpice
Badges: 1
Rep:
?
#36
Report Thread starter 2 years ago
#36
(Original post by ciaranh98)
This is what I think, I prefer using INDEX(MATCH( to VLOOKUP(.
Why have you used IF AND? Is it needed? I've attached my opinions if you'd like to compare?
Attached files
0
reply
xTheSC18x
Badges: 0
Rep:
?
#37
Report 2 years ago
#37
What day is everyone doing their exam?
0
reply
akb17
Badges: 0
Rep:
?
#38
Report 2 years ago
#38
Does anyone have any ideas about what to put in the report?
0
reply
Bugzy Malone
Badges: 0
Rep:
?
#39
Report 2 years ago
#39
Are we not going to have to use the October Tides in the exam? I heard people saying how instead of the data we have, we'll have to use october's. Im so confused
0
reply
Gech
Badges: 0
Rep:
?
#40
Report 2 years ago
#40
Anyone had any luck with working out tide heights using sin and cos?
0
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Latest
My Feed

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.

Personalise

University open days

  • University of Derby
    Postgraduate and Professional Open Evening - Derby Campus Postgraduate
    Tue, 22 Jan '19
  • University of the West of England, Bristol
    Undergraduate Open Afternoon - Frenchay Campus Undergraduate
    Wed, 23 Jan '19
  • University of East London
    Postgraduate Open Evening Postgraduate
    Wed, 23 Jan '19

Brexit: Given the chance now, would you vote leave or remain?

Remain (1493)
79.58%
Leave (383)
20.42%

Watched Threads

View All