Qwertyuiopasdfghjklzxcvb nmqwertyuiopasdfghjklzx cvbnmqwertyuiopasdfghjk These are notes for lzxcvbnmqwertyuiopasdfg the practical exam hjklzxcvbnmqwertyuiopas for ICT IGCSE(0417) dfghjklzxcvbnmqwertyuio By ~!I pasdfghjklzxcvbnmqwerty uiopasdfghjklzxcvbnmuiop asdfghjklzII know I’m asdfghjklz awesome I was just born that w ay mqwertyuiopasdfghjkl m qwertyuiopasdfghjkl zxcvbnmqwertyuiopasdfg hjklzxcvbnmqwertyuiopas dfghjklzxcvbnmqwertyuio
~!I "assan #$shta% ICT &0417'
Notes for practical •
sales were made after the end of the year 2011
ememer these r$les
*+a,e
-./0/2-
~!I "assan #$shta% ICT &0417'
!*+a,e
-./0/2-
~!I "assan #$shta% ICT &0417'
To chan,e the format of the presentation in +o3er+oint clic on home then format an5 choose the most appropriate one6
#eans Create a s$mmary Steps are 1)Go on %$ery 8I9:
"*+a,e
-./0/2-
~!I "assan #$shta% ICT &0417'
-)thn ,o to S$mmary
) e5it yo$r s$mmary y clicin, on S$mmary ;ptions
# * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
!oo $p means its not a normal form$la an5 yo$ ha< to $se the loo$p f$nction
$*+a,e
-./0/2-
~!I "assan #$shta% ICT &0417'
In front pa,e
Chan,e the $n5erscore to hypen= lso p$t a "S" efore any hexa5ecimal >,$re lie ??00CC sh5 e chan,e5 to @??00CC n5 chan,e the centE to centE
%*+a,e
-./0/2-
~!I "assan #$shta% ICT &0417'
A$l
this stan5s for
$nor5ere5 list
&*+a,e
-./0/2-
~!I "assan #$shta% ICT &0417'
'ave to do this to make sure the date and other things on the foter appear
(*+a,e
-./0/2-
~!I "assan #$shta% ICT &0417'
)o set animations properly go on animation pane
'ave to click on apply to all to apply the transition between slides to all slides **+a,e
-./0/2-
~!I "assan #$shta% ICT &0417'
+ * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
* + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
Thin,s yo$ sho$l5 consi5er efore startin, practical
! * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
" * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
# * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
$ * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
% * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
& * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
( * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
* * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
!+ * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
This is ho3 $ can >t all the col$mns properly 3itho$t selectin, each one separately
if ase5 to format the cell to a strippe5 pattern ,o on home an5 then a small ox elo3 font
! * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
This is ho3 yo$ chan,e the c$rrency
"ere yo$ sho$l5 $se a loo$p f$nction e
This is ho3 yo$ 5o it
!! * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
this is how we do it
Example of a label
Thin,s to rememer 3hen creatin, a lael 8hen $ choose a lael loo at ho3 many col$mns it has a match it to the %$estion !" * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
If it says that incl$5e lael an5 the as 3ell as the 5ata then $ clic on the lael then 3rite
then clic a,ain
on the lael nother thin, is that that $ ha
t on one pa,e This can e 5one y remo
lie this (E:FDSTIG !BE!)
!# * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
"o3 the lael sho$l5 loo lie
!$ * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
?or
Ho$ sometimes harst pa,e 5i from others etc=6 This is ho3 yo$ 5o it
!% * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
!& * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
,or
!( * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
#ore tips 3hen sol
Jery important for +o3er+oint
!* * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417' •
,ot it from Talha they sai5 that 5isplay siKe as a n$mer 3ith 1 5ecimal place So e
"+ * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
The n$mer across represents the no of col$mns in a pa,e ?or example if there are 2 laels in total an5 this option is selecte5 then on that pa,e there 3ill e - col$mns an5 4 ro3s= :
" * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
This means that there sho$l5 e 2 laels in total an5 if there arenLt then there is somethin, 3ron, 3ith the 5esi,n or the %$ery itself= &3asnLt lie that in -002s exam tho$,h'
"! * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
Sometimes yo$ may ha,$re yo$r chart accor5in, to the %$estion6
"" * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
The est thin, to 5o here is to clic on pa,e rea instea5 of pressin, enter each time as the %$estion sai5 to insert pa,e reas 3here necessary=
"# * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
This Is ho3 yo$ sho3 oth lael an5 5ata for a !BE!
E#E#BE
!oo caref$lly at ho3 I 3rote #ae >rst 3itho$t the parenthesis &' an5 then I 3rote mae 3ith the parenthesis= •
8hen creatin, laels an5 only 3hen creatin, laels $ sho$l5 sort the 5ata (if nee5e5) in the %$ery 5esi,n not in the lael it self
this s consi5ere5 a lan line e
-./0/2-
~!I "assan #$shta% ICT &0417'
t the start of 3or5 efore they as yo$ to inert a lan line after each para,raph ,o on para,raph an5 set spacin, after an5 efore to
0pt =
Then $ a55 a line after each para,raph y hittin, enter=
y clicin, on this option $ can set the o$tsi5e or5er to 3hate
"% * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
?lippi n, an ima,e
$ll means lan66
"& * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
?or access rememer that 3hene
M ?$nction ( The lael lie price cost JI mo5el etc= )
Ho$ ha
"( * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
"* * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
8hen creatin, a s$mmary yo$ can also $st clic on Si,ma ? (T;T!) So that yo$ can ,ro$p them etc=
#+ * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
~This is a s$mmary report~
I 5i5 this as the %$estion re%$ire5 me to • performs a co$nt of the n$mer of +ro5$cts for each Co$ntry • calc$lates the s$m of the n$mer of items in Stoc for each Co$ntry • only reports 3here +ro5$cts n$mer more than
# * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
8hen $ are tryin, to remo
#! * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
ememer that the pict$re ali,nment sho$l5 e perfect
#" * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
## * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
Instea5 of $sin, pa,e reas ,o to pa,e layo$t an5 hen clic on reas an5 then choose ext +a,e
8hen yo$ $se this comman5 $ can mae the >rst pa,e 5ierent from the other or mae one pa,e portrait an5 the other lan5scape=
#$ * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
ememer this step as it is $s$ally ase5 in the pp6 #% * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
~This is for the r$ler~
#& * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
Example of a han,in, para,raph
N.)/0 1for word2 It is very important that you also read through all of your work to make sure It is ++ percent correct3 •4ou will lose marks in the exam if you have spelling mistakes or errors in line 5pacing etc3 •6ake sure that bulleted or numbered lists7 tables7 graphs etc3 are not split over two pages3 4ou should also make sure that you have no blank pages or widows and .rphans3 •
#( * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
?or +o3er+oint 3hen creatin, the master sli5eN
•
This is if the %$estion re%$ires yo$ to p$t the ima,e ehin5 the text
#* * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
$+ * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
This is the ho3 yo$ sh5 tae a screenshot of transition ein, applie5 to the sli5es=
$ * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
n5 this is ho3 the animations sho$l5 e sho3e5= D sh5 open the animation pane(c$stom animation icon) an5 con>,$re the settin,s
$! * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
This is ho3 $ can print the sli5es 3ith the presenter notes
8hen they as $ to print han5o$ts it means the sli5es are 5isplaye5 on the left an5 there are some lan lines on the ri,ht for people to tae notes=
$" * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
T"E ODESTI; EODIE: #E T;
sho3s only the recor5s 3here the Co$ntry is Colomia or G$atemala or +er$=
-aper " $# * + a , e
,ront -./0/2-
~!I "assan #$shta% ICT &0417'
This sho3s that font $se5 is times ne3 roman siKe is 10px It is $n5erline5 an5 center ali,ne5 3ith 5isc shape5 $llet points an5 is italic an5 lastly is re5 in color=
•
Ho$ sho$l5 rememer that 3hen $ 3rite times ne3 roman it sho$l5 e 3ritten lie this PTimes ne3 romanQ as it has spaces in et3een $ 5o not nee5 to 5o the same thin, 3hen 3ritin, rial=
Ho$ can easily a55 another font y p$ttin, a comma after font !ie after rial $st p$t a comma an5 3rite sansRserif= The colour code has three parts... $$ * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
RED, REE!, "#$E Di%erent &alues entered into these three parts can create any colour re'uired The codes are( •
•
FF = 100% (maximum) C0 = 75% 80 = 50% 40 = 25% 00 = 0% (none)
Example re5 3o$l5 e 3ritten as @??0000 It ,oes in the or5er&for lac' 1=E:(00) -=Green(00) =Bl$e(00)
ememer to create an anchor 3hen ase5 to create a oomar an5 mae s$re that it 5oes not appear in the pre
$% * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
This is ho3 yo$ can create a ne3 style sheet
Thn ,o on format an5 then to style so that $ can e5it it
$& * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
n example of a style sheet
$( * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
Ho$ can also clic ,! from 3ithin ?ront+a,e to pre
"ere are some examples of colo$rs
+$re colo$rs
$se 100 (??)
+$re ;/< is ,,7++7++ (100 E: no GEE no B!DE) +$re =;//N is ++7,,7++ (no E: 100 GEE no B!DE) +$re >:?/ is ++7++7,, (no E: no GEE 100 B!DE) +$re >:9@A is ++7++7++ (no E: no GEE no B!DE) +$re 8"ITE is ,,7,,7,, (100 E: 100 GEE 100 B!DE)
$* * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
m$ch etter 3ay ho3e
Ho$ m$st spell colo$r as color in oth stylesheets an5 "T#! co5e= n or5ere5 list starts 3ith Aol an5 an $nor5ere5 list starts 3ith A$l
%+ * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
/B@ 8hen yo$ are 5oin, yo$r 3or in excel an5 3ant to sa
n alternati
Ho$ can either select the a$to s$m icon or clic on the small f(x) icon esi5e the form$la ar= These 3ays are m$ch easier than typin, in comman5s yo$rself $t I 3o$l5 prefer to $se them as a chec as they can e %$ite 5ic$lt to $se sometimes=
Inte,er is the word used to describe a Whole Number (with no decimals or fractions). In Excel, the INT function takes a number and removes all digits after the decimal oint! % * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
"#$%N&(',) If this is the ro$n5 f$nction an5 cell 1 is .-=//1Then the res$lt of ro$n5in, 3o$l5 e 0 as the R1 si,n means that the
-./0/2-
~!I "assan #$shta% ICT &0417'
*$%NTI+. This loo)s at the cells within a *i&en ran*e and counts the number of cells in that ran*e that meet a certain condition. The condition can be a number, text, an ineualit- or a cell reference!
)he speech marks C C around the criteria are needed to tell /xcel that it is dealing with another formula3 If you fail to type in the speech marks7 /xcel will look for the symbols typed in rather than what was wanted3
5?6I, compares each
In excel there is no such thing as not, so when u want to search for something not having something u have to write it like <>
N$T criteria allow you to exclude data from your calculations. N$T criteria are entered as this symbol ./ %" * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
'N E0'123E
IF AND Function +n I+ 'N& function is similar to re*ular I+ functions in that it allows a spreadsheet to roduce outcomes. The di%erence between I+ 'N& and regular I+ +unctions is as follows( #egular I+ +unctions can perform ust one test to determine the outcome
I+ 'N& can perform two or more tests that all determine the outcome
If this is the question0 The word 45es6 if the athlete is female and their sprint time is lower than the current world record for females The word 45es6 if the athlete is male and their sprint time is lower than the current world record for males The word 4No6 for all other outcomes.
%# * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
This is how the answer would look like7
There are 2 types of loo)ups
) -loo)up( where data is loo)ed up from the -ERT/+# columns. 8) loo)up( where data is loo)ed up from the horiontal rows. When u t-e in 9looku then the :rst thing is the7 looku value then the table arra-, and then from what column or row is the data to be extracted from and then :nall- if it is an exact match or not
%$ * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
Sometimes yo$ nee5 to loo $p the 5ata from another sprea5sheet= Ho$ 5o this y >rst openin, that partic$lar sprea5sheet an5 then in the main one type onMUloo$p(cell an5 then open the sprea5sheet $ 3ant to loo $p the 5ata from an5 hi,hli,ht an5 then ,o ac to the main one an5 contin$e= ote yo$ C;T open another sprea5sheet 3hile $ r typin, in a form$la= ;'
Jal$es
in E!TIJE CE!! E?EECE chan,es if yo$ copy across the ro3s an5 col$mns Jal$es in BS;!DTE CE!! E?EECE 5o not chan,e if yo$ copy across the ro3s an5 col$mns %% * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
n example from a past paper
?or this there are t3o sol$tions 3hich are B;T" correct=
;
In excel 3hen $ hane a name for a recor5 or ran,e $ cannot p$t a space in et3een it= Example Sales forecast 3o$l5 e 3ritten as SalesV?orecast= These are the relational operators to $se in excel M A A AM %& * + a , e
E%$al Greater than !ess than ot e%$al to !ess than or e%$al to -./0/2-
~!I "assan #$shta% ICT &0417'
M
#ore than or e%$al to
E#E#BE 8hen yo$ type the form$la Jloo$p in the ?orm$la ar an5 are ,oin, to 3rite 5o3n the col$mn n$mer then $st remer that it 3ill start from the ran,e = example if the ran,e is(WCW1WEW1) an5 yo$ 3ant to 5isplay 5ata from col$mn : then $ 3ill 3rite the col$mn in5ex n$mer as - an5 not as 4 = &ot s$re ao$t this tho$,h' If for example yo$ 3rite SUUUU This 3o$l5 mean that excel 3o$l5 search for anythin, that starts 3ith an S an5 has fo$r characters follo3e5 y it=
8hen ase5 to format ro3s select them this 3ay=
%( * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
8hen ase5 to >n5 a partic$lar recor5 containin, somethin, select the 5ata an5 then >lter it an5 then ,o to c$stom >lter an5 select the appropriate >lter e,
To $nhi5e 5ata $st clic in et3een the t3o cells
Bet3een ? an5 G
%* * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
Croppin, an ima,e yo$ can either 5o it man$ally or $ts enter the
&+ * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
This is ho3 yo$ can 5isplay the axis from left to ri,ht ;ooooh666
;rst 3rite the mco5e for each month an5 then >n5 the s$m of each month an5 then also >n5 the co$nt of each month an5 then 5in5 a
& * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
T"ESE 3ere the form$la $se5
This 3hole thin, is for the year octXno< -010 %$estion 14 &! * + a , e
-./0/2-
~!I "assan #$shta% ICT &0417'
To ali,n a tale ,o to tale properties an5 then select ali,nment=
&" * + a , e
-./0/2-