Author Topic: ICT Doubt.  (Read 11693 times)

Offline nameless

  • Newbie
  • *
  • Posts: 7
  • Reputation: -2
Re: ICT Doubt.
« Reply #15 on: April 14, 2009, 08:50:00 pm »
GODOFWAR
to indent u must highli8 the points  go 2 format den 2 placeholder . press da txt box & ri8 2 cm internal margin from left

Offline SGVaibhav

  • SF Farseer
  • *******
  • Posts: 3013
  • Reputation: 5737
  • Gender: Male
  • Bugatti Veyron 16.4
Re: ICT Doubt.
« Reply #16 on: April 14, 2009, 09:14:35 pm »
first of all in the e-mails questions
u must make a sceen shot for uploading the file from the website required to download from.
and in the last question u must print the broweser this means u should print the page not tke a scrren shot...

secnd thng
in excel it was sooo easy
u need to use
sumif
vlookup
int

if u hv any questions ask me pple
bt be spesific..


hmmmm
can u do the email part for the oct/nov2008 paper 2.
only the email part, and for prinouts, can u just send me scrreenshots?
it will only take 5mins for u.
send it to "questions_of_game@yahoo.com"
and screenshots also.


THANKS
:D:D:D:D
i increased ur rep by a point

Offline hyebyekadal

  • SF Citizen
  • ***
  • Posts: 182
  • Reputation: 17
Re: ICT Doubt.
« Reply #17 on: April 15, 2009, 05:01:46 am »
HEY PPL MY PAPER 3 IS TOM and im not too sure about to use VLOOKUP or just LOOKUp which ones did you guys use?? also n my paper 2 i just took a screenie of the browser i mean thats wat they want rite? why would u print the whole page they only want to see the cc bcc etc
anyway Thanks in advance!

Offline saifalan

  • SF Master
  • ******
  • Posts: 1090
  • Reputation: 728
  • Gender: Male
  • Wht did I do to you that made you do this to me?
Re: ICT Doubt.
« Reply #18 on: April 15, 2009, 06:39:01 am »
saifalan:
i understood u, becze i was like u, bt by practising u will feel it s soo easy..
i was sooo confused abt everythng abt practical.bt i did the whole past papers that i hv n it becmes soo easy..
try practse evryday at least  2 hours u will get it really..
when is ur ICT ig exam???


Mine ?? Sis, I did my CIE Olevels a year back and got 6 As and 2 Bs. Never had ICT but had Computing. Now I am in my A2.
Why so seroisee ??

Offline Purplemagic

  • Newbie
  • *
  • Posts: 6
  • Reputation: 0
Re: ICT Doubt.
« Reply #19 on: April 15, 2009, 09:18:00 am »
Hey guyz Thankyousomcuh!!
By the way Tanya, isnt it okay to take the scrn shot of Email showin the attachment,instead of preview in browser?? And Tanya plz add me or gimme your ID. THANKS  ;D

nid404

  • Guest
Re: ICT Doubt.
« Reply #20 on: April 15, 2009, 10:22:31 am »
This doubt is from the november 2007, paper 2 , step 49wherein you need to export a query as .csv. After this is done u need to open the file in excel and use a lookup function for a cell that contains initials and replace them with their full names. The problem is that the lookup value is the initial in the cell itself. So when I write the formula, it gives an error of circular reference. So how is it supposed to be done??? I've got my paper tomorrow. Please don't say this is not in the paper. I really don't want to know what's there and what's not.  Please tell me how to do this.
Thanks

Offline emi

  • SF Geek
  • ****
  • Posts: 530
  • Reputation: 2581
  • former member
Re: ICT Doubt.
« Reply #21 on: April 15, 2009, 11:15:01 am »
sgvaibhav   if u knew how to do the email part plz tell me also ,, i have exam on 17 .

and tanya ,, why does every one use vLookup function instead of lookup ??

can any one please explain why   
former member

Offline saadmannan

  • SF Geek
  • ****
  • Posts: 343
  • Reputation: 65534
  • Gender: Male
Re: ICT Doubt.
« Reply #22 on: April 15, 2009, 12:43:23 pm »
b/c it is recommend by cambridge in all the mark schemes they  use VLOOKUP and not lookup.......this is wat my tacher told me

Today i had my Paper 2 it was the best exam....the invidulator was presented with food and he kept on eating and we were sitting very closer to each other it was kinda easy...our teacher just old us wat is coming 30min before our exam.......
it was cool

Offline sweetsh

  • Retired Adminstrator
  • SF V.I.P
  • ********
  • Posts: 7049
  • Reputation: 65535
  • Gender: Female
  • *Freedom
Re: ICT Doubt.
« Reply #23 on: April 15, 2009, 12:46:08 pm »
Guys...A website which I really prefer for studying ICT practical or written is www.teach-ict.com 
This website offers you alot..Go have a look I hope you benefit

Offline ughthu

  • Newbie
  • *
  • Posts: 7
  • Reputation: 1
Re: ICT Doubt.
« Reply #24 on: April 15, 2009, 12:52:27 pm »
Hey guys....had ma ppr 2 today..wasnt that bad...juss wanna make sure that in which format our dates were supposed to come in reports..... dd/MM/yyyy or dd/MMM/yyyy

i hope u get the question.....
asin...e.g

01/01/2009 or 01/jan/2009....

Thanks..:)

Offline astarmathsandphysics

  • SF Overlord
  • *********
  • Posts: 11271
  • Reputation: 65534
  • Gender: Male
  • Free the exam papers!
Re: ICT Doubt.
« Reply #25 on: April 15, 2009, 02:28:05 pm »
Guys...A website which I really prefer for studying ICT practical or written is www.teach-ict.com 
This website offers you alot..Go have a look I hope you benefit

Try also bbc bitesize

http://www.bbc.co.uk/schools/gcsebitesize/

Offline unknown

  • SF Immigrant
  • **
  • Posts: 123
  • Reputation: 228
Re: ICT Doubt.
« Reply #26 on: April 16, 2009, 12:56:16 pm »
hm need yr help cld somone plz upload d files fr practise which shoaib has given fr p2 of ict regarding d date stuff it wld be gr8 help
thx a lot

Offline sweetsh

  • Retired Adminstrator
  • SF V.I.P
  • ********
  • Posts: 7049
  • Reputation: 65535
  • Gender: Female
  • *Freedom
Re: ICT Doubt.
« Reply #27 on: April 16, 2009, 01:13:32 pm »
Here is it

Offline unknown

  • SF Immigrant
  • **
  • Posts: 123
  • Reputation: 228
Re: ICT Doubt.
« Reply #28 on: April 16, 2009, 01:41:01 pm »
Here is it
hey thx
man its so kind of u to help
keep it up n ya keep helping
hm serisosly sweet sweetsh

Offline sweetsh

  • Retired Adminstrator
  • SF V.I.P
  • ********
  • Posts: 7049
  • Reputation: 65535
  • Gender: Female
  • *Freedom
Re: ICT Doubt.
« Reply #29 on: April 16, 2009, 06:45:27 pm »
You welcome. But what I mostly like that helping people makes your REP going down, its nice and so kind of people.

I hope you benefit, anything else ask we will help
Good luck