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

There is always one goody two shoes, who has now ruined it for everyone by scaring someone into taking down a helpful comment.

This is the easiest AS ICT exam I have ever done. Defiantly easier than last years one (I'm retaking). Make sure you look at the hidden sheet in the practice file and get familiar with the Pi and cos formula structures and read the questions well. You will be told what to do in the exam so don't worry too much. Just ensure that you know how to use countifs, If statements ETC.

Also get familiar with the selection page and the formulas in I-O, 13-19.I attached the practice file given to us with the front page done (someone posted it here before but not sure where)

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 improvements would you suggest?

macros to make it easier to navigate the homepage. a front page with links to all the pages. validation

thank you! whats macros?

basically hyperlinks for the spreadsheets

Angry Dragon have you done the exam? if so, how was it? Did Index match come up, anything very hard?

Every time somebody posted their version of the pre-release on here, they used I different clearance formula to the one I got taught in class.
In class, we used a nested if formula instead of the regular if formulas I've seen on here, which is correct?

Have the exam tomorrow so any advice would be useful

Edit: Clearance formula example -
=IF(J14>Sights!D12,IF(Selection!K14<Sights!E12,"Y","N","N"

activity one was list 7 points i think and put in restrictions or something. two was selection sheet. 3 was august tides. four was how to improve spreadsheet
use vlookup instead of index match IF youre more comfortable with vlookup

What about august tides? and was four a report of just how to do improve the spreadsheet? thank you!

activity one was list 7 points i think and put in restrictions or something. two was selection sheet. 3 was august tides. four was how to improve spreadsheet
use vlookup instead of index match IF youre more comfortable with vlookup

Wow thanks so muxh man thats so helpful! Really need to do well this year in this exam cus other exam and coursework modules went well . Good because I am fine wlith VLookup but not index! What do you mean August Tides? Do you have formulate the tides for August, or do they give you the August tides and you have to make the selection worksheet reflect August instead of July? How? thanks so much man so helpful really appreciate it

Hi, been following this incredibly helpful discussion for a while now. Just want to say thanks for the information. Is it true you have to calculate the phase angles for the moon on a different sheet- someone leaked another sheet a while back that has pink boxes to enter information in, regarding phase angles. any information regarding this would be very helpful.