You are Here: Home

# Edexcel GCE Applied ICT Unit 3- June 2011 Exam watch

Right guys, complete solution (See Last Post) AND my spreadsheet, where you may all look around and see how i've completed it. Feel Free.
If you turn Bodmin to off you make more profit lol
2. we have just discovered we have to do an Nested IF Statement?
Can anyone provide me with this please?

Also, if you have over £186,591.91 profit, please explain how you got this and what you used to get the figure?

Thanks.

PS: Good luck to everyone who has the exam Monday - Wednesday. (I have it on Thursday).
3. (Original post by Villa73)
we have just discovered we have to do an Nested IF Statement?
Can anyone provide me with this please?

Also, if you have over £186,591.91 profit, please explain how you got this and what you used to get the figure?

Thanks.

PS: Good luck to everyone who has the exam Monday - Wednesday. (I have it on Thursday).
Hey I have attached the Excel Sheet. Check it out.
Hope it helps
Attached Files
4. Copy of Kraftz_practice.xls (248.5 KB, 214 views)
5. (Original post by Jorgeyy)
Don't you need some \$ in there to make it easy to paste it?

So...

And surely the AND has the same effect?

=IF(AND(Values!\$B7=&quot;Yes&quo t;,Values!B\$21=&quot;Yes&quot,B7,0)

Which would you suggest is neatest and best to use in the exam?
I used the second and formula!
6. (Original post by Villa73)
we have just discovered we have to do an Nested IF Statement?
Can anyone provide me with this please?

Also, if you have over £186,591.91 profit, please explain how you got this and what you used to get the figure?

Thanks.

PS: Good luck to everyone who has the exam Monday - Wednesday. (I have it on Thursday).
Hey i think the data could be different in exam so you'l have to get a different figure! However i got around £207,000 & thats the highest!! Lol... i think on the list of stores you do yes,no, yes yes yes & then all no & advertisement you have leaflets & billboards? & no to the other two! .. Hope it helps!

Good luck with your exam on thursday.. I have 5 exams next week & ICT is my last on friday so please let me know how it goes x
7. (Original post by ajay fernando)
Guys i have completely done the model, im making a profit of £177,950.73 by opening only two shops and using all of the advertising methods! Im nt sure if im right, so if u guys cud do the model so tht we will be able to discuss whose right and the highest profit made here.

thank you
can u send me a copy of your model coz i am struggling and i got the exam on monday plz
thankz
Hey i think the data could be different in exam so you'l have to get a different figure! However i got around £207,000 & thats the highest!! Lol... i think on the list of stores you do yes,no, yes yes yes & then all no & advertisement you have leaflets & billboards? & no to the other two! .. Hope it helps!

Good luck with your exam on thursday.. I have 5 exams next week & ICT is my last on friday so please let me know how it goes x
could u send me ur model plz im struggling coz my teacher was of ill for the last month
9. Hi

I teach this unit and have been reading through the posts here.

Couple of things that may help:

The exam files will be exactly the same as the ones you are currently working from.

For the model to work correctly you need to add two checks - One to see if the shop is open and one to see if advertising method has been selected. There are numerous methods of achieving this but the maximum profit achievable should be somewhere near £200,000 - if you are able to get figures well over this amount, you have set up the spreadsheet wrong.

BTW shame on the teacher who was selling the worksheets
I used the second and formula!
Sweet, thats the one I made up in my class today so no need to edit worksheet... after I noticed the one our teacher provided (just an IF formula dependant on shops being open and not taking into account advertising) was wrong.

Decided to tell my teacher she was wrong to tell the class rather than keep to myself after debating it LOL.
11. (Original post by Jorgeyy)
Sweet, thats the one I made up in my class today so no need to edit worksheet... after I noticed the one our teacher provided (just an IF formula dependant on shops being open and not taking into account advertising) was wrong.

Decided to tell my teacher she was wrong to tell the class rather than keep to myself after debating it LOL.
LOL did the same thing lol! .. teacher was impressed and told everyone to change what they had already done
12. (Original post by joey don)
could u send me ur model plz im struggling coz my teacher was of ill for the last month
Hey what exactly are you struggling on?

Heres my model and you can see pretty much all the formulas etc used... hope it helps & good luck with your exam!
LOL did the same thing lol! .. teacher was impressed and told everyone to change what they had already done
My teacher made everyone bow down to me, not even joking...

Suck it ;D
14. (Original post by Jorgeyy)
My teacher made everyone bow down to me, not even joking...

Suck it ;D
haha all i got was a few claps! damn
Hey what exactly are you struggling on?

Heres my model and you can see pretty much all the formulas etc used... hope it helps & good luck with your exam!
thankz for that but do u know how to fill in the advertising yellow box
16. (Original post by joey don)
thankz for that but do u know how to fill in the advertising yellow box
Open her spreadsheet and evaluate the formulas she has used in the yellow cells...

She can't really do more than actually send you a working model for you to look at...

If you're having trouble understanding what a formula actually means/does/it's purpose just quote this and i'll explain.
17. (Original post by Jorgeyy)
Open her spreadsheet and evaluate the formulas she has used in the yellow cells...

She can't really do more than actually send you a working model for you to look at...

If you're having trouble understanding what a formula actually means/does/it's purpose just quote this and i'll explain.
yeh could u do that plz i cant work out where u got it from
18. hi iv gt my exam next friday
i really need help with activity 2 and 4
cud someone plz send me thier
also this is the formular i got
=if(and(value!\$b7="yes",b\$21="ye s"),b7,0)
it does wrk but it is differnt from saidas
ps dnt forget to look at the rating when u open the shop as if above 1 it is good as falmouth is rated as 1.
hope it help
pzl cud some1 help me
:~
19. (Original post by *Wat Da Hell*)
Hope it helps
hi hav u already done ur exam
haha all i got was a few claps! damn
sorry to bother u so much but could u help me with the advertising formulas

so u type them in ur or is their a easier way of doing that

thankz
21. (Original post by joey don)
hi hav u already done ur exam
Nopes I havn't .. Its on 25th May

### Related university courses

TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: May 2, 2012
The home of Results and Clearing

### 1,294

people online now

### 1,567,000

students helped last year
Today on TSR

### University open days

1. Sheffield Hallam University
Tue, 21 Aug '18
2. Bournemouth University
Wed, 22 Aug '18
3. University of Buckingham
Thu, 23 Aug '18
Poll
Useful resources

Can you help? Study Help unanswered threadsStudy Help rules and posting guidelines

## Groups associated with this forum:

View associated groups

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE