Edexcel GCE Applied ICT Unit 3- June 2011 Exam

Scroll to see replies

simba2011

Heyy! .. I just want to say thankyou! Ive done all the activities briefly (and have been mailing them to like everyone) .. But i was doing the total cost, profits from the wrong sheets & just looked at it & @Villa73 .. appreciated for helping! :smile:

...

thanks to everyone for helping out and sending help all thru. pls keep up the good work, and keep sending the work that u do!

Reply 141

simba2011

Original post by Sadii

Hey i just got £200,595.83 ... Anyone else manage to get it>?

hey, what shops are u opening and wat advertising means are u using to get this? i guess that must be the maximum then. thanks

Reply 142

Mikeyrlz

You can go higher. I got just over £204,000, and I chose the monthly figures over the total costs. :smile:

Reply 143

Gorgeous devil

Original post by Mikeyrlz

You can go higher. I got just over £204,000, and I chose the monthly figures over the total costs. :smile:

Hey how are you getting that value??
What shops have you opened?? And which advertising methods are you using??

Reply 144

SquadRedFox

Original post by Gorgeous devil

Hey how are you getting that value??
What shops have you opened?? And which advertising methods are you using??

Remember guys - THIS IS NOT THE EXAM. The data sources and figures will BE TOTALLY DIFFERENT: aka, the solution you find NOW WILL NOT WORK in the exam. Just keep playing around and experimenting; that's the best practice that can be done for the exam. :smile:

Keep up the hard work guys, and remember that nested IF:
=IF(Values!B7="Yes",IF(Values!B21="Yes",Advertising!B7,0),0)

Reply 145

tajmahal

Anyone who's felt raped and tortured by the subject is most welcome to join the following Facebook fanpage:

http://www.facebook.com/pages/Applied-ICT-ruined-my-life/219743658038141

Please spread the word...this subject has literally tortured us!!

(edited 12 years ago)

Reply 146

aWilsher

Come on guys, of course they wouldn't give us the actual data, it would make it too easy! I managed to finish the spreadsheet after a couple of practices in under 10 minutes, and its a 2 hour 30 minute exam! The reason they give us a lot of time is to enable us to play around with the things on the Values table to find a proper solution. Although i'm still quite sure it won't be too hard, 2 things i've gathered are that £200,000 profit should be the target and that 4 areas and 2 advertisements should be the target, although I may be wrong about the latter.

Reply 147

Sadii

Original post by Mikeyrlz

You can go higher. I got just over £204,000, and I chose the monthly figures over the total costs. :smile:

Lol ..got £207,000 :wink:

Reply 148

Sadii

Original post by Gorgeous devil

Heyy how did you get that value ???? =(

Lol... i think on the list you do yes,no, yes yes yes & then all no & advertisement you have leaflets & billboards?

Reply 149

Gorgeous devil

Original post by Sadii

Lol... i think on the list you do yes,no, yes yes yes & then all no & advertisement you have leaflets & billboards?

Got it =) Thanks =)

Reply 150

waseem

Original post by SquadRedFox

Keep up the hard work guys, and remember that nested IF:
=IF(Values!B7="Yes",IF(Values!B21="Yes",Advertising!B7,0),0)

Thank u for this IF Statement, i found it really useful and i managed to interpret into my spreadsheet and found it worked properly.

Reply 151

waseem

In the spreadsheet on the values page, why is there an exclamation mark by Total Revenue Figure, wot am i meant to click on after i have licked on it. any replies will be appreciated lots.

Reply 152

waseem

Original post by Sadii

Lol ..got £207,000 :wink:

where does that figure go mate??

Reply 153

waseem

Original post by simba2011

hey, what shops are u opening and wat advertising means are u using to get this? i guess that must be the maximum then. thanks

yer i got that fgure aswell..

Reply 154

Sadii

Original post by waseem

where does that figure go mate??

it goes in total profits on the first values sheet.. you work out all 3 from monthly figurres..

Reply 155

Ricco_T

Original post by tajmahal

Huh! Wait until next year - this is nothing! :biggrin:

Reply 156

Keahsel

Hey,do you mind emailing the answers to me as well please?

Original post by Sadii

Anyone doing ICT & have a teacher that doesn't do anything.. Read on! ( this ain't defiante but most likely to be what's on the exam..
Scenario: Kornish Kraftz

Activity 1: summarise current situation & list key facts to the problem you need to solve.. (basically outline main facts in bullet points).
outline decisions you need to make..
Assumptions you are making..

Activity 2: evaluate source that have been used..
Why data could lead to inaccuries within the model...
the factors that haven't been takn into account..

Activity 3: Basically once imported the data you have to add a IF & And formula on the advertising page.. this would be for all possible shops & advertise type chosen! You must then to find totals revenue & cost you sum up the bottom of all months in values sheet! (you should practise doing it around 3-4times!

Activity 4: most likely there going to ask you to write a report based on recommending model for expansion using figures & graphs from spreadsheet...
(this would mention shops you've used, why you used them - ratings, show a graph of total cost & profits, which adverising method you would want to use..

Wow that's a lot of info .. Hope it helps everyone & best of luck in your exams! x

Reply 157

Keahsel

What do ya mean when you say that you chose the monthly figures over the total cost?

Original post by Mikeyrlz

You can go higher. I got just over £204,000, and I chose the monthly figures over the total costs. :smile:

Reply 158

Sadii

Original post by Keahsel

Hey,do you mind emailing the answers to me as well please?

Hey.. no worries.. whats your email? & put it in a private message coz were not allowed to post on threads..

Reply 159

Mathematix

Original post by SquadRedFox

Keep up the hard work guys, and remember that nested IF:
=IF(Values!B7="Yes",IF(Values!B21="Yes",Advertising!B7,0),0)

Don't you need some $ in there to make it easy to paste it?

So...

=IF(Values!$B7="Yes",IF(Values!B$21="Yes",Advertising!B7,0),0)

And surely the AND has the same effect?

=IF(AND(Values!$B7="Yes",Values!B$21="Yes"),B7,0)

Which would you suggest is neatest and best to use in the exam?