As applied ict - june 2015 - unit 3 - truckles scenario Watch

Sehbaan Ali
Badges: 0
Rep:
?
#381
Report 4 years ago
#381
(Original post by MattBurd)
Its pretty much filling out the Exam Board's pre release workbook. Theres no extra unseen spreadsheet pages. Just practice with filling in the data on the prices worksheet
oh thats alright i know all the formulas and stiuff was there anything really tricky about the formulas?

and how about activity 4 and 5 evaluation and report what was that about?

sorry for asking so many questions i just dont want to mess up i got a bio exam tomorrow aswell!
0
reply
toki112001
Badges: 2
Rep:
?
#382
Report 4 years ago
#382
(Original post by MattBurd)
Its pretty much filling out the Exam Board's pre release workbook. Theres no extra unseen spreadsheet pages. Just practice with filling in the data on the prices worksheet
Any suprises; or if we know all the formulas and functions will we be ok?
Also how many marks is it to get profit etc
0
reply
MattBurd
Badges: 2
Rep:
?
#383
Report 4 years ago
#383
(Original post by Sehbaan Ali)
oh thats alright i know all the formulas and stiuff was there anything really tricky about the formulas?

and how about activity 4 and 5 evaluation and report what was that about?

sorry for asking so many questions i just dont want to mess up i got a bio exam tomorrow aswell!
The report is based on how you did in the exam and the scenario so nothing i give you about it will help.
Formulas you should know are the working out cost of electricity and selecting data from other sheets. As this exam is still ongoing I cannot give out details about the exam in order to comply with exam board rules
0
reply
toki112001
Badges: 2
Rep:
?
#384
Report 4 years ago
#384
(Original post by MattBurd)
The report is based on how you did in the exam and the scenario so nothing i give you about it will help.
Formulas you should know are the working out cost of electricity and selecting data from other sheets. As this exam is still ongoing I cannot give out details about the exam in order to comply with exam board rules
Sorry; you said you struggled with the exam.
If you don't mind me asking .
Why was it?

Lack of preparation or was the exam more difficult than expected ?
0
reply
Sehbaan Ali
Badges: 0
Rep:
?
#385
Report 4 years ago
#385
(Original post by MattBurd)
The report is based on how you did in the exam and the scenario so nothing i give you about it will help.
Formulas you should know are the working out cost of electricity and selecting data from other sheets. As this exam is still ongoing I cannot give out details about the exam in order to comply with exam board rules
lol alright i thought i could do a hceeky one there and get a couple of questions out of you i pretty much know my stuff anyways so hopefully it`ll be okay

haha hope you did well for your exam anyways!
0
reply
MattBurd
Badges: 2
Rep:
?
#386
Report 4 years ago
#386
(Original post by toki112001)
Sorry; you said you struggled with the exam.
If you don't mind me asking .
Why was it?

Lack of preparation or was the exam more difficult than expected ?
Most of it was probably lack of preparation using the model and learning my way around the model. I was fine with formulas and stuff it was just working out the price of the filters and heater costs of electricity. Because each of the sheets are linked to other sheets, if you mess one cell or sheet up, it affects the rest of the exam...
kept giving me #!value instead of a number for some reason...
But im sure youll do fine.
This was a resit for me and i had to attend extra classes with the other groups outside of my lesson time, when most of my lessons were going which means i missed out quite a few.
0
reply
toki112001
Badges: 2
Rep:
?
#387
Report 4 years ago
#387
(Original post by MattBurd)
Most of it was probably lack of preparation using the model and learning my way around the model. I was fine with formulas and stuff it was just working out the price of the filters and heater costs of electricity. Because each of the sheets are linked to other sheets, if you mess one cell or sheet up, it affects the rest of the exam...
kept giving me #!value instead of a number for some reason...
But im sure youll do fine.
This was a resit for me and i had to attend extra classes with the other groups outside of my lesson time, when most of my lessons were going which means i missed out quite a few.
Oh ok. Thanks for your reply.
Without breaking any exam rules ; any last minute tips ? If I prepared well we should be ok right.

Plus for electricity working out we have a working one. Did you not manage to have a working electricity formula before u went to the exam?
0
reply
MattBurd
Badges: 2
Rep:
?
#388
Report 4 years ago
#388
(Original post by toki112001)
Oh ok. Thanks for your reply.
Without breaking any exam rules ; any last minute tips ? If I prepared well we should be ok right.

Plus for electricity working out we have a working one. Did you not manage to have a working electricity formula before u went to the exam?
its quite a long one you need to convert watts to kilowatts and something like
=(((F19/1000)*24*7*4)*F21)*B20
(This is from the prerelease students should have recieved before the exam)

But dont take my word for it - this is what i used in the model BEFORE the exam but i think its the same.
If you do have the prerelease material, keep working your way around it
0
reply
toki112001
Badges: 2
Rep:
?
#389
Report 4 years ago
#389
(Original post by MattBurd)
its quite a long one you need to convert watts to kilowatts and something like
=(((F19/1000)*24*7*4)*F21)*B20
(This is from the prerelease students should have recieved before the exam)

But dont take my word for it - this is what i used in the model BEFORE the exam but i think its the same.
If you do have the prerelease material, keep working your way around it
Thanks for that; similar but different order of formulas
(B20/1000)*(f19*f21)*24*28 (not included cell reference )
0
reply
MattBurd
Badges: 2
Rep:
?
#390
Report 4 years ago
#390
Yeah thats OK the 28 refers to the 4 week periods I believe with 24 relating to hours and dividing by 1000 to turn kW into w. Shame I forgot this in the exam XD
0
reply
toki112001
Badges: 2
Rep:
?
#391
Report 4 years ago
#391
(Original post by MattBurd)
Yeah thats OK the 28 refers to the 4 week periods I believe with 24 relating to hours and dividing by 1000 to turn kW into w. Shame I forgot this in the exam XD
I've hopefully prepared for all the sheets and for the selling tank have learnt Int / rounddown / mod ways;

And get close to getting a profit .

Are there any other tips you can give me or advise mate.?
0
reply
kf141998
Badges: 9
Rep:
?
#392
Report 4 years ago
#392
(Original post by toki112001)
I've hopefully prepared for all the sheets and for the selling tank have learnt Int / rounddown / mod ways;

And get close to getting a profit .

Are there any other tips you can give me or advise mate.?
what formula do you have in your selling tank?

i've got :- =IF('Stock Tank (Post1)'!C12/6>1,ROUNDDOWN('Stock Tank (Post1)'!C12/6,0)*6,0)
0
reply
Noorvik
Badges: 1
Rep:
?
#393
Report 4 years ago
#393
Name:  ****les.png
Views: 87
Size:  280.5 KB Any tips for someone just about to the exam, all my course work was well into the A grades so I shouldn't need much to get an overall A, right?
0
reply
mralbert
Badges: 0
Rep:
?
#394
Report 4 years ago
#394
what was activity one about
0
reply
TruckleTrevor
Badges: 0
Rep:
?
#395
Report 4 years ago
#395
How come people were chatting that there was a vlookup and an activity 5.


Posted from TSR Mobile
0
reply
Mstar1
Badges: 0
Rep:
?
#396
Report 4 years ago
#396
(Original post by toki112001)
Aren't the number of filters and heaters just given to you? As they are pink in the sheet. So it should calculate by itself .

Also ; why were you getting values; did you do the formulas wrong ; did your teacher not prepare you properly ??
You know I came out of my exam today and my formulas were also messed. I think I am screwed for this exam I am never going to pass it was seriously that hard! I also had the same problem when I remembered the formulas it would come out wrong and write value instead. Guys be warned if u haven't yet done the exam u are gunna struggle believe me it was really that hard.
0
reply
_colette
Badges: 0
Rep:
?
#397
Report 4 years ago
#397
What % is the exam worth in regards to the overall AS?
0
reply
madmike41
Badges: 0
Rep:
?
#398
Report 4 years ago
#398
It's 100 UMS so it is 1/3 of the whole thing.
Basically if u got an A for coursework so roughly around 80-90 UMS for both U1 and U2, you need 240UMS altogether to get an A.
This means 240-(85+85)=70
So around 70UMS which is about 40-60 marks depending on the boundaries of the mark scheme this year.
0
reply
suli123
Badges: 0
Rep:
?
#399
Report 4 years ago
#399
(Original post by kristian samuel)
mate, can you please say what came up on the exam? You would want someone to tell you! Please mate
activity 1 13 key points
activity 2 data inputting, and round down formulas.
Activity 3 screenshots/annotations
activity 4 report

there u go pal
0
reply
suli123
Badges: 0
Rep:
?
#400
Report 4 years ago
#400
(Original post by Sehbaan Ali)
are you guys ready for the theory part so activities 4 and 5 the evaluation and report
Theres no 5
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

University open days

  • Cardiff Metropolitan University
    Undergraduate Open Day - Llandaff Campus Undergraduate
    Sat, 19 Oct '19
  • Coventry University
    Undergraduate Open Day Undergraduate
    Sat, 19 Oct '19
  • University of Birmingham
    Undergraduate Open Day Undergraduate
    Sat, 19 Oct '19

Why wouldn't you turn to teachers if you were being bullied?

They might tell my parents (26)
7.01%
They might tell the bully (35)
9.43%
I don't think they'd understand (56)
15.09%
It might lead to more bullying (145)
39.08%
There's nothing they could do (109)
29.38%

Watched Threads

View All