IGCSE/GCSE/O & A Level/IB/University Student Forum
Qualification => Subject Doubts => IGCSE/ GCSE => Miscellaneous => Topic started by: ashgerrard on April 04, 2009, 05:31:01 pm
-
Hello everyone.
I just did my practical ICT paper 2 and I would like to make you cool down and asure you that it is the easiest practical exam ever written. It is even easier than the year June 2008 exam. So I just wanted to say to anybody who is scared from the exam to cool down and just practice from the syllabus and past papers and everything is going to be alright and no need for the cheating and the questions because that won't be fair.
Best of luck to everyone.
-
Thanks man. Really needed that.
-
Thanks ashgerrard it's such a relief to know that.
My question is the same as esum0209's question. Did anything new came?
-
I'm doing mine next week..
I heard that there is a new weird formula in Excel. :o
-
No!!! Excel is in paper 3. Access has a small tricky part which asks you to make a query between to dates. And believe me, the rest of the exam is sooooooooo simple. I can offer any help to anyone just send me a message and I will be ready to help.
Good Luck again to everyone.
-
Post ur ques for helps. Then wll be good for all. Not PM
-
Here is a SUMMARY of all the topics found on this site especially this topic:
https://studentforums.biz/index.php/topic,670.120.html (https://studentforums.biz/index.php/topic,670.120.html)
-Paper 2 (May/June 2009) Tricks:
=========================
-MS Access:
*Reports summary you have to make a query from the table you made previously or so:
Firstly go to queries then create query by using design wizard after that select the desired field just as asked from the paper then click next, in the next step you will be asked whether you would like to create a detail or summary query, select summary, click summary options, tick the sum option for the particular field just as asked in the question paper that you will probably see on the left side of the box and for counting the number of fields tick the count option that you will see on the bottom of the left side, after everything has been done correctly click next and finish it n save the query.
In the next step you will be asked to export the data.
-For Word save it As .RTF
-For Graph/Chart package save it as .CSV
When you are making the report they will ask you to extract some dates from all of them.
In the criteria cell enter:
Between #1/1/2009# and #31/1/2009#
"there are total 3 spaces in the formula and write the dates in the correct format."
-------------------------------------------------------------------------------------
-Word:
No header and footer on first page:
1) Go to file
2) Click on page setup
3) On the tabs click on layout
4) Under Headers and footers click on different first page
5) Set "from edge" margins to 0 cm
Your headers and footers will disappear on the first page.
===============================================
*Paper 3 (May/June 2009) Tricks:
===============================================
-Powerpoint:
1)How can we ident a bullet list in powerpoint (by 2 cm for example)
2)How can we make each page in ms word have a different layout??
1) To indent, you must highlight the bullet points you want to indent and go to format then go to placeholder. Press the text box and write 2 cm internal margin from the left.
2) And to make the first page different from the rest, press File>Page Setup>Layout and mark the box saying "Different first page".
-When making the pie chart:
You have to include the Percentage and Category Name
They will also ask you to slightly pull out the part with the most percentage from the rest of the pie chart:
1) Just press on the pie chart itself once
2) Then press on the largest part
3) Then Drag It
-------------------------------------------------------------------------------------
-Frontpage:
You will have to modify, they will give u the color (RGB) so u will go to format>style>modify>font>color>more colors>custom>enter the number they tell u for each colour (i think the color will turn purple)
-------------------------------------------------------------------------------------
-Excel:
The formulas used are:
Sum If
Count If
Value Lookup
Calculate the Minutes & Hours by /60 and *60
===============================================
-More Help:
===============================================
-You have to import an image of an island or a hotel into the document. (Search from google.)
-Have a look at these steps from the mark schemes. Make sure you know how to do these:
O/N 2007 Paper 2 - Step 31 & 32
M/J 2008 Paper 3 - Step 9
O/N 2008 Paper 3 - Step 29 Part 3 & 4, Step 46 & 48
-This .zip file will help you alot!!![/u]
https://studentforums.biz/index.php?action=dlattach;topic=670.0;attach=421 (https://studentforums.biz/index.php?action=dlattach;topic=670.0;attach=421)
It was attached by "Shoaib" (No viruses, its scanned...)
==========================
Thanks To:
evilzurg307
ashgerrard
Shoaib
Monica
TheIncredibleStudent
Tammy
==========================
Enjoy!
TNas11
-
Hey guys, according to the text above it says to make the header and footer go away on the first page you should do the from edge thing uno
the
"Word:
No header and footer on first page:
1) Go to file
2) Click on page setup
3) On the tabs click on layout
4) Under Headers and footers click on different first page
5) Set "from edge" margins to 0 cm
Your headers and footers will disappear on the first page."
I found that for me it doesn't work that way. It goes away after just doing the 4 steps. And if i do the 5th step my other heads and footers become screwed and go VERY close to edge of paper and half of them don't appear while printing. So does anyone have the same problem? Anyway if that happened to you then here's the solution.
MY IT EXAM PAPER 2 IS TOMORROW!
-
Yeah me too
It only worked till the 4th step
and I didnt have to do the last
one so dont worry when doing it till
the 4th step because I asked my teacher
and she said that it is correct till the 4th step.
Thanks for mentioning this problem.
-
I first when to View>head and footer. The little tool bar for it pops up if your on the first page click "next page" icon on the tool bar. Then beside the next page (to the left) you will see link pages (word 2003), if not then different page 1 ( 2007 mybe? and mac). After unlinking enter the things you need and then your done all you have to do is check if it worked on page 3 and not one if it didnt try doing the same for page 3
Try my method
-
Cud u send me the paper on my email PLEASE … missadorable_92@hotmail.com … PLEASE… :'(
-
Lol I finished the ICT paper 2 today I found not all that easy. I mean i got everything but I didn't get summary of the incomes the way you are supposed to!
Anyway I did end up doing the correct pie chart as I just imported the database into which you extract the data from and moved it to excel and used Sumif and Countif to solve it. And I sorta checked my answers with the people who actually did it the correct way!
Anyway has anyone done paper 3 yet? I heard that it was harder than paper 2 and I did not find this paper all that easy!
Can anyone give me hints and any help? Any really hard questions?
-
hyebyekadal what u mean about the summary of the income ?? is it the report part ?
-
Lol I finished the ICT paper 2 today I found not all that easy. I mean i got everything but I didn't get summary of the incomes the way you are supposed to!
Anyway I did end up doing the correct pie chart as I just imported the database into which you extract the data from and moved it to excel and used Sumif and Countif to solve it. And I sorta checked my answers with the people who actually did it the correct way!
Anyway has anyone done paper 3 yet? I heard that it was harder than paper 2 and I did not find this paper all that easy!
Can anyone give me hints and any help? Any really hard questions?
I can asure you that paper 3 is easier than paper 2 so dont panic (except for the frotpage part).
-
hey ashgerrared u seem 2 b so happy and confident tht u dd well ;) {am glad cuz u made me feel more optimistic abt ths test}
-
what functions in paper 2??
-
wat were all the tricky stuff in frontpage? ???
-
plz help :)
-
thx for everyone! :)
Update for the file (uploaded by shoaib)!
some people couldnt download it so i uploaded it again
and i also uploaded a file that helps in EXCEL (thanks to adeel) :)
Also download the other file, it includes the files which u will use in the external (paper 2 & 3)!
Here are the links:
http://www.box.net/shared/lpgljp1d1y (http://www.box.net/shared/lpgljp1d1y)
http://www.box.net/shared/i3tf91jst0 (http://www.box.net/shared/i3tf91jst0)
http://www.box.net/shared/xth6rcdgvm (http://www.box.net/shared/xth6rcdgvm)
Enjoy! TNas11
-
Thnk u for u efforts. Now this wht I call sharing. Pst any useful links ppl.
-
No!!! Excel is in paper 3. Access has a small tricky part which asks you to make a query between to dates. And believe me, the rest of the exam is sooooooooo simple. I can offer any help to anyone just send me a message and I will be ready to help.
Good Luck again to everyone.
I do not cheat.
-
TNas11 thanks again . you helped me get some of the stuff in paper 2 . and again here u have collected info very well. but I have a question ,
i ddint quite get this part:
p { color: rgb(0%, 50%, 50%); font-family: "Times New Roman", serif; font-size: 12pt; text-align: left }
why are you entering percentages when they ask you shouldn't u enter like code itself?
-
No because this time they tell you...:
In the paragraph style, ensure that there is no red component and blue and green component is set to 50%
That's a new trick this year!
Enjoy!
-
I didnt get in paper 3 frontpage wat do u mean by u have to save the stylesheet and modify it several times. we r used to saving it once and using it . do u mean that we save once and work with it and then we modify it and work with the new one
Plz answer cuz am so confused ??? ??? ???
-
when i import the excel file into MS access...
i get an error message that tells me that not all the data was converted..
why does this happen and what do I have to do to make it work??
-
change the date format into dd/mm/yy
when u import something will cum up right.. click next once and the next time click " advance " option buttom at the bottom ..
there read from top there will be date section ,, change it
-
or just use j9sales2.csv if you use j9sales.csv or vice-versa... :)
i did the p2 external yesterday it was reaalllly easy but when u do the pie chart you have to tick Category name and VALUE not percentage as evil told me so i only lost a mark but its still an A* ... :)
my P3 is tomorrow
good luck to everyone :)
Enjoy! TNas11
-
asgherrard, how do we do that tricky bit in access?
the extracting the dates thing?
-
It is not tricky at all!! It is just logic. right "between" and then the 2 dates with "and" in between and the query is solved. If you still didnt understand send me a message.
-
Hey again
could anyone plz summarize the tricky parts plus the new stuff that came in the exam Im too lazy to read @.@
My P2 exam is on the 13th of april (this monday)
and my P3 is on the 15th
Me and my classmates tried to steal a hard copy (paper) of both exams : P2 & P3 but the teacher walked on us on the last minute so we only managed to photograph it and unfortunately my mobiles camera is too crappy so the image is realllly bad :/. I knw this is bad, but its the last resort :X sorry !
-
go to hell!!!! >:(
-
go to hell!!!! >:(
:O Im sorry if I offended you in any way but did my actions hurt you ?
-
Hahahaha !!!! 8)
-
whts so funny?
-
I used to tell people to cheat if it helps but that was before cheating was a possibility. Now it really is possible on a large scale and it is awful.
-
Whats funny??
I will tell you whats funny !!
Im laughing because of seeing such people trying to cheat in anyway....Listen my friend...FEP is a place to benefit from and get our resources in order to study...Not a place for CHEATING...
So please keep it clean..
-
No offense but
Posting exams that has just been taken IS called cheating, ur only helping those who have not taken their examination yet to cheat. So technically we're the same.....
As I said, no offense and the teacher already gave us a speech about cheating saying that ur marks will determine ur future and that you wouldn't want it to be based on cheating so we all just deleted the pics
-
Well then...Dont ask about the exams...
Its called self-control..You have to adapt your self automatically for not cheating..This will no longer benefit you in the future..As your teacher said..
-
Im not asking about exams, It is legal to notify the students about the changes that occured in the exam this includes the tricks and the new stuff and thats wht Im asking
so back to the topic can anyone summarize the tricks and the new stuff
I've read it but so far its kind of confusing. I'd be really grateful
Thx in advance
-
What do I do with the RAR files.??
-
Extract them
-
extract the rar. file using this:
http://peazip.sourceforge.net/index.html
-
can i get the supporting files for p2??????? :)
-
Cheating is not allowed saad
-
wats your problem dude .. get a life .
go revise ur studies
-
Here is a SUMMARY of all the topics found on this site especially this topic:
https://studentforums.biz/index.php/topic,670.120.html (https://studentforums.biz/index.php/topic,670.120.html)
-Paper 2 (May/June 2009) Tricks:
=========================
-MS Access:
*Reports summary you have to make a query from the table you made previously or so:
Firstly go to queries then create query by using design wizard after that select the desired field just as asked from the paper then click next, in the next step you will be asked whether you would like to create a detail or summary query, select summary, click summary options, tick the sum option for the particular field just as asked in the question paper that you will probably see on the left side of the box and for counting the number of fields tick the count option that you will see on the bottom of the left side, after everything has been done correctly click next and finish it n save the query.
In the next step you will be asked to export the data.
-For Word save it As .RTF
-For Graph/Chart package save it as .CSV
When you are making the report they will ask you to extract some dates from all of them.
In the criteria cell enter:
Between #1/1/2009# and #31/1/2009#
"there are total 3 spaces in the formula and write the dates in the correct format."
-------------------------------------------------------------------------------------
-Word:
No header and footer on first page:
1) Go to file
2) Click on page setup
3) On the tabs click on layout
4) Under Headers and footers click on different first page
5) Set "from edge" margins to 0 cm
Your headers and footers will disappear on the first page.
===============================================
*Paper 3 (May/June 2009) Tricks:
===============================================
-Powerpoint:
1)How can we ident a bullet list in powerpoint (by 2 cm for example)
2)How can we make each page in ms word have a different layout??
1) To indent, you must highlight the bullet points you want to indent and go to format then go to placeholder. Press the text box and write 2 cm internal margin from the left.
2) And to make the first page different from the rest, press File>Page Setup>Layout and mark the box saying "Different first page".
-When making the pie chart:
You have to include the Percentage and Category Name
They will also ask you to slightly pull out the part with the most percentage from the rest of the pie chart:
1) Just press on the pie chart itself once
2) Then press on the largest part
3) Then Drag It
-------------------------------------------------------------------------------------
-Frontpage:
You will have to modify, they will give u the color (RGB) so u will go to format>style>modify>font>color>more colors>custom>enter the number they tell u for each colour (i think the color will turn purple)
-------------------------------------------------------------------------------------
-Excel:
The formulas used are:
Sum If
Count If
Value Lookup
Calculate the Minutes & Hours by /60 and *60
===============================================
-More Help:
===============================================
-You have to import an image of an island or a hotel into the document. (Search from google.)
-Have a look at these steps from the mark schemes. Make sure you know how to do these:
O/N 2007 Paper 2 - Step 31 & 32
M/J 2008 Paper 3 - Step 9
O/N 2008 Paper 3 - Step 29 Part 3 & 4, Step 46 & 48
-This .zip file will help you alot!!![/u]
https://studentforums.biz/index.php?action=dlattach;topic=670.0;attach=421 (https://studentforums.biz/index.php?action=dlattach;topic=670.0;attach=421)
It was attached by "Shoaib" (No viruses, its scanned...)
==========================
Thanks To:
evilzurg307
ashgerrard
Shoaib
Monica
TheIncredibleStudent
Tammy
==========================
Enjoy!
TNas11
i cant open the links....is there any other way i can?
-
admins.. should this be moved to bin??
i see someone printing this topic, which gives me a weird feel
-
admins.. should this be moved to bin??
i see someone printing this topic, which gives me a weird feel
Me agree..Do it for now at least