APPLIED ICT June 2014

[HamzaQm]

I have my P2 tomorrow. I heard people in india or saudia are done with their p2 can anybody help me with what came in the exam ? Or is anyone having a guess ?
Zone 4.

 

[yazoAba]

Excel Man.

 

[Tala MA]

Excel Man.

is it only excel?
and what came in it give me details plz

 

[AdeelZafarO_o]

PLeeeeaaassseeeee! Help usss!

 

[sagittarius_1234]

Excel Man.

what else? pleaseee help

 

[yazoAba]

Study Only excel. Nov 2013 and may 2010 q 14. They Got You some lookups,if Functions, And other functions for sure

 

[Monica_Gholoum]

email me please [email protected]
my exam is on the 30th
Thanks

 

[Aisha kekhran]

C

Study Only excel. Nov 2013 and may 2010 q 14. They Got You some lookups,if Functions, And other functions for sure

Can you please help me here? [email protected]

 

[Tala MA]

i did the exam today

 

[Tala MA]

now I'm not trying to scare u but actually it was the hardest paper we ever solved we were all shocked, it was a combination of excel and access, they gave you three files and the main file was excel so you will have to take columns from it and edit them then save them as a CSV in order to solve access, and u will have to create three tables the same way, so u can't say its excel or access you will be alternating between them all the time, it had ALOT of stuff so study REALLY REALLY hard and concentrate in the exam so much so you could solve it, again I'm not trying to scare but u have to know the difficulty of it

 

[Meth Zeph]

what was it about? excel? what major functions?

 

[Tala MA]

Its not like normal excel, u solve two functions then take specified columns to make a new spreadsheet then use it for excel

 

[Meth Zeph]

so you copy and paste specific areas of the excel table and use it to form a new spreadsheet? to be imported into access? sorry im abit confused

 

[Tala MA]

Exactly

 

[AtifAhmedAict]

now I'm not trying to scare u but actually it was the hardest paper we ever solved we were all shocked, it was a combination of excel and access, they gave you three files and the main file was excel so you will have to take columns from it and edit them then save them as a CSV in order to solve access, and u will have to create three tables the same way, so u can't say its excel or access you will be alternating between them all the time, it had ALOT of stuff so study REALLY REALLY hard and concentrate in the exam so much so you could solve it, again I'm not trying to scare but u have to know the difficulty of it

Did you have to auto generate employee number?

 

[Tala MA]

What do u mean?

 

[Meth Zeph]

Did you have to auto generate employee number?

you extract it using the left function and then concatenate it while using an if to the payroll number putting either 4 or 5 0000's depending on if the payroll number is a single or double digit

 

[asma kiyani]

now I'm not trying to scare u but actually it was the hardest paper we ever solved we were all shocked, it was a combination of excel and access, they gave you three files and the main file was excel so you will have to take columns from it and edit them then save them as a CSV in order to solve access, and u will have to create three tables the same way, so u can't say its excel or access you will be alternating between them all the time, it had ALOT of stuff so study REALLY REALLY hard and concentrate in the exam so much so you could solve it, again I'm not trying to scare but u have to know the difficulty of it

Ihave my paper on 10 means paper 4 kindly let me know if u have before that pllzzzzzz

 

[Rodney69]

hey guys can anyone send me the question paper and the supporting files for P2 may/june 2014. My exam is on Sunday (30th). [email protected]
Thanks in advance, i really need it, will share if i get it.

 

[iknowrite]

Study Only excel. Nov 2013 and may 2010 q 14. They Got You some lookups,if Functions, And other functions for sure

what other functions !! can u plz tell us in detail !!!