IGCSE/GCSE/O & A Level/IB/University Student Forum

Qualification => Subject Doubts => IGCSE/ GCSE => Miscellaneous => Topic started by: Purplemagic on April 14, 2009, 05:30:59 pm

Title: ICT Doubt.
Post by: Purplemagic on April 14, 2009, 05:30:59 pm
What exactly is the proof of search in Email. Please attach it or a URL as the example. =)
And any personal difficulties faced during this year's (s09) papers. Wish me luck.!!!
Title: Re: ICT Doubt.
Post by: SGVaibhav on April 14, 2009, 05:44:08 pm
can anyone please describe the  whole email procedure in short.
i never practiced it at school.
are we always supposed to print a screenshot when we go to the CIE website?
Title: Re: ICT Doubt.
Post by: Purplemagic on April 14, 2009, 05:58:35 pm
And were there any labels in Access this year..like there were last summer?????
Title: Re: ICT Doubt.
Post by: saifalan on April 14, 2009, 07:03:40 pm
They want to knw it for all. So if u knw it plz post it.
Title: Re: ICT Doubt.
Post by: GodOfWar on April 14, 2009, 07:06:33 pm
i've got my paper 2 tomorrow  :o
any tips ?
Title: Re: ICT Doubt.
Post by: GodOfWar on April 14, 2009, 07:32:38 pm
k which apps were there?[ frontpage,acces etc]
i noe the formulas in excel: vlookup, sumif, countif, int and mod and thats it right?
what about powerpoint, what did they ask
Title: Re: ICT Doubt.
Post by: GodOfWar on April 14, 2009, 07:34:23 pm
oh and does anyone know how to indent bullets in powerpoint ? ???
Title: Re: ICT Doubt.
Post by: same on April 14, 2009, 07:46:18 pm
hey!could sumone plz describe the practical in full?how do we calculate total cost in report?
sam.
Title: Re: ICT Doubt.
Post by: saifalan on April 14, 2009, 07:57:42 pm
My view is exms r never easy then it wuldnt be exam. The fact is that u get so much better by preparing all those time that u dnt realize hw hard it actaully was.
Title: Re: ICT Doubt.
Post by: Tanya on April 14, 2009, 07:59:06 pm
the practical was sooooooooo easy realy there was no label in wordprocessing
the sum in the report u cn do it by going
to
the toolbars there is label box and it will show 2 box the 1st one for the tittle of the sum whch is total cost and the 2nd one
go to right click -proparties-2nd choise up-go to functions-choose sum-it will shw it up -delete whch is inside the bractes -go to quaries
choose the quarey when u want the total cost-choose cost- n click ok
that is all
sorry it s the first time i explain for some1
so i hope that u got it..
Title: Re: ICT Doubt.
Post by: GodOfWar on April 14, 2009, 08:03:40 pm
RE: can anyone tell me how to indent bullets in powerpoint ?
Title: Re: ICT Doubt.
Post by: Tanya on April 14, 2009, 08:05:46 pm
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???
Title: Re: ICT Doubt.
Post by: nameless on April 14, 2009, 08:21:53 pm
ma exam is on 18th of april am afraid of ACCESS and dat stupid summary plus labels
IF NY bobdy can help sooooooooo THAAAAAAAAAAAAAAAAAAAAAAAAAAANNNNNNNNNNNNNNNNNNKKKKKKKKKKKKKK$$$$$$$$$$$$$$$$$$$$
ALOT ! ;)
Title: Re: ICT Doubt.
Post by: GodOfWar on April 14, 2009, 08:36:11 pm
lol no tanya i know that, i was asking for some question in which thy ask you to indent a bulleted list by atleast 2 cm .Know how to do that ?
Title: Re: ICT Doubt.
Post by: ashgerrard on April 14, 2009, 08:48:24 pm
There is no ident thing in the powerpoint I did me practical a week ago.
Title: Re: ICT Doubt.
Post by: nameless 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
Title: Re: ICT Doubt.
Post by: SGVaibhav 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
Title: Re: ICT Doubt.
Post by: hyebyekadal 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!
Title: Re: ICT Doubt.
Post by: saifalan 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.
Title: Re: ICT Doubt.
Post by: Purplemagic 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
Title: Re: ICT Doubt.
Post by: nid404 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
Title: Re: ICT Doubt.
Post by: emi 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   
Title: Re: ICT Doubt.
Post by: saadmannan 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
Title: Re: ICT Doubt.
Post by: sweetsh 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
Title: Re: ICT Doubt.
Post by: ughthu 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..:)
Title: Re: ICT Doubt.
Post by: astarmathsandphysics 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/
Title: Re: ICT Doubt.
Post by: unknown 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
Title: Re: ICT Doubt.
Post by: sweetsh on April 16, 2009, 01:13:32 pm
Here is it
Title: Re: ICT Doubt.
Post by: unknown 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
Title: Re: ICT Doubt.
Post by: sweetsh 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
Title: Re: ICT Doubt.
Post by: SGVaibhav on April 16, 2009, 06:49:00 pm
By the way
im sorry to say
u stopped helping
i asked so many questions and asked u to answer like 2 of them, but none of them got answered.
plz dont mind me, i am only telling the truth.
Title: Re: ICT Doubt.
Post by: astarmathsandphysics on April 16, 2009, 06:51:17 pm
Not me! I answer all the questions I think I can answer. If it is to do with maths/physics those are my subjects.
Title: Re: ICT Doubt.
Post by: SGVaibhav on April 16, 2009, 06:53:41 pm
Mr. Paul

not you
never
you always help.
i just forgot to quote sweetsh.


you always help Sir.
Sorry if you felt offended.
Title: Re: ICT Doubt.
Post by: sweetsh on April 16, 2009, 06:54:11 pm
Well dont you think I got exams too? Im a student like you and I got mock exams right now. It doesnt mean I dont want to help because of something. I dont know you so why to hate you and not answer?

I answer what my eyes come on. If I did something wrong Im sorry its not only about me.
Title: Re: ICT Doubt.
Post by: SGVaibhav on April 16, 2009, 06:56:33 pm
i dont hate.
i just told something.

i dont like hating ppl.
Title: Re: ICT Doubt.
Post by: astarmathsandphysics on April 16, 2009, 06:56:47 pm
No, am not offended, and I am sure sweetsh is not too.
Title: Re: ICT Doubt.
Post by: sweetsh on April 16, 2009, 06:58:28 pm
Mr Paul its just a matter of respecting others and situations...
And I really want to help others beacause I care, but it seems nobody understands me
Title: Re: ICT Doubt.
Post by: ashgerrard on April 16, 2009, 07:02:32 pm
Dont worry
I understand
I am also having this situation. People must be thankful instead of saying the truth !  >:( (I am not angry i just wanted to out that emoticon)
Title: Re: ICT Doubt.
Post by: saifalan on April 16, 2009, 07:11:21 pm
Mr Paul its just a matter of respecting others and situations...
And I really want to help others beacause I care, but it seems nobody understands me

No one cares abt others but themselves. So screw others and do ur own study and do ur best. Only help when ur done helping urself.
Title: Re: ICT Doubt.
Post by: sweetsh on April 16, 2009, 07:16:24 pm
I really try to do my best for everybody. But Im being misunderstood
Title: Re: ICT Doubt.
Post by: astarmathsandphysics on April 16, 2009, 09:31:05 pm
i dont hate.
i just told something.

i dont like hating ppl.


Like is nice but hate is easy.
Title: Re: ICT Doubt.
Post by: anusha500 on April 17, 2009, 02:08:26 pm
can anyone help with this question nov. 2007 p3.
43. Open the file N7ICON.JPG in a suitable application. Change its width to 40 pixels and its height to 42 pixels. Ensure that the colour depth is 256 colours (8 bit colour) and save the file as N7ICON.GIF
Title: Re: ICT Doubt.
Post by: sanity_master on April 17, 2009, 08:02:32 pm
in this Q.......i used PHOTOED program...it is very useful...but for the steps in the program sry to tell that i dont remember them right now  :-\
Title: Re: ICT Doubt.
Post by: Tammy on April 20, 2009, 01:53:18 pm
Don't worry about the labels because they are not coming this yr.
The exam was so easy... It was much easier than M/J 08 with the labels and i dunno what!
But you have to make a summary, which is also easy.
Title: Re: ICT Doubt.
Post by: anusha500 on April 20, 2009, 03:49:14 pm
can anyone help with this:
51   Using a lookup function replace each Code with Region name using the file REGIONS.CSV

and once you paste the pie chart in word what if its small and you cant read it.
( it has to fit in the column width)
Title: Re: ICT Doubt.
Post by: SGVaibhav on April 20, 2009, 04:05:21 pm
give me 10 mins

By the way which paper tell me that first
Title: Re: ICT Doubt.
Post by: anusha500 on April 20, 2009, 04:30:57 pm
its okay i figured it out Thanks anyways.

By the way if there is a sentence from a paragraph on the next page/column and its a sentance and a word long. is it still considered an orphan/widow??
Title: Re: ICT Doubt.
Post by: Christy on April 20, 2009, 04:36:11 pm
i have a question..... can we do a pie chart with a excel and import it to powerpoint or do we have to do it in powerpoint ??

and if we have to do it in powerpoint wat are the steps ??
Title: Re: ICT Doubt.
Post by: emi on April 20, 2009, 04:43:05 pm
Amber i have answered your this Question at the other post i guess u dont check ur previous Question replies =\
and you can not import charts to power point you have to make it there its self .

here are the steps again
first of all in the Power Point when u want to make a chart :
Go to that slide and the click the chart button from the tools up  like this >>>

(http://i43.tinypic.com/332ulfp.jpg)

then you will get a Bar chart and a data filling space,  right click on the Chart and then choose chart type . Choose Pie chart and click ok . Now in the space where u will put your data information for the pie ,, remove everything thats there 'cause for pie u only need the first 2 rows. ( the first for the names the second for the numbers.)  like this >>>

(http://i44.tinypic.com/mhwq34.jpg)

when u do that u will get your chart, ofcourse u will have to modify it i mean make it bigger so it fills the whole white area and like that and make the text clearly visible and so on.
Title: Re: ICT Doubt.
Post by: emi on April 20, 2009, 05:06:44 pm
Quote
can anyone help with this:
51   Using a lookup function replace each Code with Region name using the file REGIONS.CSV

and once you paste the pie chart in word what if its small and you cant read it.
( it has to fit in the column width)

anusha500, For the Pie part in word , i had problems fixing it and placing it properly.  but the easy way is when u import the chart  right click on it and then click " Work sheet Object" then choose " Edit" . there click one the names which are smal and change its font size by right clicking and choose " Format data labels " , to maximum 20 pt.
also the best way is to make your pie smaller . the colors will show anyways so it doesnt matter if its small .  make sure you are not choosing the Price numbers while making the pie . it should be Count of sales not Sum of sales, alot of people make mistakes there . ( like me )

about the lookup function im sure your teacher must have thought you that ?
Click insert >> Function >> lookup function >> choose the second option " Lookup value, array "

in the look up value choose the first code cell only
for the array section open the " region .csv " and choose all the data except for the headings.
then click enter, you will get the first one, hold your mouse on that first cell till u see a black plus sign then click on it and strech it down till the cell you want they will all appear .

follow the steps exactly and you wont have problems but as i believe they teach that in school at the very beginning .
ask if u dont understand   
Title: Re: ICT Doubt.
Post by: anusha500 on April 21, 2009, 05:01:47 pm
thank you.

a question in frontpage.

when creating hyperlinks if it says should open in current new window called _history.
what do we use? parent frame?

and when doing the colour do we spell it color or colour?
does it matter?
Title: Re: ICT Doubt.
Post by: sweetsh on April 21, 2009, 06:58:32 pm
No. What you got to do is to creat a hyperlink normally (right click-hyperlink) Then see whats your hyperlink will go to. If you want it to open in a new page or something click TARGET FRAME then choose NEW WINDOW and name it underneath.

For the colour think I didnt understand but as they are british people they prefer it colour (but Im not sure)
Title: Re: ICT Doubt.
Post by: GodOfWar on April 21, 2009, 07:28:26 pm
Does anyone else here luv Secondhand Serenade's "Fall for You"  ;D  ;D
Title: Re: ICT Doubt.
Post by: emi on April 21, 2009, 07:29:07 pm
 the spelling is "color" but i dnt think it matters .. u can try it in front page and see how it works with u . it also depends on your regional settings country if its UK then i guess its gonna be colour and i fits US then color is ok .

and im not sure about the front page Question hope some one els will answer and help you  <3

Title: Re: ICT Doubt.
Post by: sweetsh on April 21, 2009, 07:33:18 pm
Quote
Does anyone else here luv Secondhand Serenade's "Fall for You"

Yes me.
 :)
Title: Re: ICT Doubt.
Post by: GodOfWar on April 21, 2009, 07:42:56 pm
y was my fall for u post not... posted ?!  ??? >:(
Title: Re: ICT Doubt.
Post by: sweetsh on April 21, 2009, 07:45:51 pm
No it is. And I answered you
Title: Re: ICT Doubt.
Post by: emi on April 21, 2009, 08:11:11 pm
what is that ?
Title: Re: ICT Doubt.
Post by: sweetsh on April 21, 2009, 08:24:45 pm
Sorry emi I forgot to quote. I was answering GodOfWar not you.
Title: Re: ICT Doubt.
Post by: emi on April 21, 2009, 08:59:37 pm
lol i know .. i was asking about Secondhand Serenade's "Fall for You"
Title: Re: ICT Doubt.
Post by: sweetsh on April 21, 2009, 09:16:26 pm
Its a song. You should listen to it some time