# AS OCR Applied ICT PRE-RELEASE

Watch
Announcements
#1
This is all of the Pre-Release data, this can be found on the OCR website however I thought i'd post here to provide some for you all! This is the Data, Pre release scenario and the practice spreadsheet that we have been provided from OCR themselves.

Have a lot of fun with this Pre-Release data and I wish everyone good luck for the exam this summer! I will be taking the exam my very self so I hope it is all a good exam!!
0
5 years ago
#2
Do you have any idea of the formulas needed for the spreadsheet? - my teachers and all the students have been struggling to work it all out. If you do, can you please send me them
Thanks
0
#3
Sure! Basically the data has to be inserted into the large area of the spreadsheet (as usual) then you go on over to the selection worksheet. Here on the right you see lots of pink. In the visits, it will be a count if, the statistic tide start is a vlookup of the tide start and end on the same sheet. For example the first one for tide start is: =VLOOKUP(H14,'Data'!A12:O20,9,FALSE) (You may wanna cell reference st some point) if you tell that to your teacher, you will probably set their mind going. However if not, I will be able to go into more depth when home from college tonight
0
5 years ago
#4
You're a lifesaver, we are still struggling as there seems to be an error with the vlookup which we are doing, would you please go into more detail just so I can test this out and hand the spreadsheet to my teacher (as well as your information)

Thank you
0
5 years ago
#5
Also, one quick question, if the tide start and end on the selection sheet is sheet referenced to the data worksheet, why would we need a vlookup sheet reference to the data sheet? I have used this formula and have come up with the same answer =vlookup (H14,\$A\$14E\$19,4,FALSE)
0
5 years ago
#6
How about we create a whatsapp group..it will be easy to communicate
People who wants to be in the group..send their numbers plz😂👍🏿
0
#7
Okay sorry or this late reply. Attached I have provided my current spreadsheet that I have completed for the pre-release. You will notice that for the depth in/out and clearance in/out I have entered <= and >=. This is because if you look in the scenario you will notice that for each attraction (or most) there will be a depth limitation and height limitation. For seal flats the sea level must be below 3.8m. If you look in the sights worksheet you will notice the heights each attraction has. The depth will be the lower number and the clearance will be the higher number. Take a little look of this spreadsheet I am providing here and it will show you what I mean. For reference, we have also found that the worksheet has been purposely jeopardised to ensure that you are unable to get the correct solution, meaning that you will have to find it during the exam.
That's just a little bit of help for you!
Enjoy!
Anything else I will be available until Tuesday, then from Thursday to Monday and then I will be available Wednesday because I exam for IT is on the Thursday.
0
X

new posts
Back
to top
Latest
My Feed

### Oops, nobody has postedin the last few hours.

Why not re-start the conversation?

see more

### See more of what you like onThe Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

### Poll

Join the discussion

#### Would you give consent for uni's to contact your parent/trusted person in a mental health crisis?

Yes - my parent/carer (68)
32.85%
Yes - a trusted person (58)
28.02%
No (54)
26.09%
I'm not sure (27)
13.04%