My exam is tomorow but i've been getting answers from classmates who have sat it on monday and today.
So activity 1 is the listing 10 things that are the conditions etc, part b will be about potential errors and part c is about things out of your control like sudden earthquake and water floods etcetc.
Activity 2 is what you've hopefully done in class which is the IF statements and the VLOOKUP's.
Activity 3 is the one we dont get given, from what ive heard is it going to be involving Sin and Pi to work out different tidal values.
Someone managed to get a picture of the question in school and it is along the lines of the person saying they want the tidal trip to be designed on the week commencing August 1st, the harbour master is busy so you've got to work out the tidal values yourself.
I'm sorry this isn't hella helpful but obviously I dont have the exact formulas you need but hopefully knowing what the exam is about will make you less nervous.
I have the exam tommorow, if im not too busy revising for Bio i will pop back on here to say what happened!
Good luck!