kieranm9090
Badges: 6
Rep:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#1
Report Thread starter 5 years ago
#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
reply
MarioD
Badges: 5
Rep:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#2
Report 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
reply
kieranm9090
Badges: 6
Rep:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#3
Report Thread starter 5 years ago
#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
reply
MarioD
Badges: 5
Rep:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#4
Report 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
reply
MarioD
Badges: 5
Rep:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#5
Report 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
reply
Don696969
Badges: 2
Rep:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#6
Report 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
reply
kieranm9090
Badges: 6
Rep:
? You'll earn badges for being active around the site. Rep gems come when your posts are rated by other community members.
#7
Report Thread starter 5 years ago
#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.
Attached files
0
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Back
to top
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

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%

Watched Threads

View All
Latest
My Feed