Qualification > Miscellaneous

ICT IGCSE Practical Paper 2

<< < (2/10) > >>

saifalan:
Post ur ques for helps. Then wll be good for all. Not PM

tnas11:
Here is a SUMMARY of all the topics found on this site especially this topic:
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

It was attached by "Shoaib" (No viruses, its scanned...)
==========================
Thanks To:
evilzurg307
ashgerrard
Shoaib
Monica
TheIncredibleStudent
Tammy
==========================
Enjoy!
TNas11

hyebyekadal:
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!

ashgerrard:
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.

s1k0:
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

Navigation

[0] Message Index

[#] Next page

[*] Previous page