Notes for Practical

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

ememer these r$les

*+a,e

-./0/2-


!*+a,e

-./0/2-


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-


-)thn ,o to S$mmary

) e5it yo$r s$mmary y clicin, on S$mmary ;ptions

# * + a , e

-./0/2-


!oo $p means its not a normal form$la an5 yo$ ha< to $se the loo$p f$nction

$*+a,e

-./0/2-


In front pa,e

Chan,e the $n5erscore to hypen= lso p$t a "S" efore any hexa5ecimal >,$re lie ??00CC sh5 e chan,e5 to @??00CC n5 chan,e the centE to centE

%*+a,e

-./0/2-


A$l

this stan5s for

$nor5ere5 list

&*+a,e

-./0/2-


'ave to do this to make sure the date and other things on the foter appear

(*+a,e

-./0/2-


)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-


+ * + a , e

-./0/2-


 * + a , e

-./0/2-


Thin,s yo$ sho$l5 consi5er efore startin, practical

! * + a , e

-./0/2-


" * + a , e

-./0/2-


# * + a , e

-./0/2-


$ * + a , e

-./0/2-


% * + a , e

-./0/2-


& * + a , e

-./0/2-


( * + a , e

-./0/2-


* * + a , e

-./0/2-


!+ * + a , e

-./0/2-


This is ho3 $ can >t all the col$mns properly 3itho$t selectin, each one separately

if ase5 to format the cell to a strippe5 pattern  ,o on home an5 then a small ox elo3 font

! * + a , e

-./0/2-


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-


this is how we do it

Example of a label

Thin,s to rememer 3hen creatin, a lael 8hen $ choose a lael loo at ho3 many col$mns it has a match it to the %$estion !" * + a , e

-./0/2-


If it says that incl$5e lael an5 the as 3ell as the 5ata then $ clic on the lael then 3rite



then clic a,ain

on the lael nother thin, is that that $ hat on one pa,e This can e 5one y remo
lie this (E:FDSTIG !BE!)

!# * + a , e

-./0/2-


"o3 the lael sho$l5 loo lie

!$ * + a , e

-./0/2-


?or

Ho$ sometimes harst pa,e 5i from others etc=6 This is ho3 yo$ 5o it

!% * + a , e

-./0/2-


!& * + a , e

-./0/2-


,or

!( * + a , e

-./0/2-


#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$mer 3ith 1 5ecimal place So e
"+ * + a , e

-./0/2-


The n$mer across represents the no of col$mns in a pa,e ?or example if there are 2 laels in total an5 this option is selecte5 then on that pa,e there 3ill e - col$mns an5 4 ro3s= :

" * + a , e

-./0/2-


This means that there sho$l5 e 2 laels in total an5 if there arenLt then there is somethin, 3ron, 3ith the 5esi,n or the %$ery itself= &3asnLt lie that in -002s exam tho$,h'

"! * + a , e

-./0/2-


Sometimes yo$ may ha,$re yo$r chart accor5in, to the %$estion6

"" * + a , e

-./0/2-


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 reas 3here necessary=

"# * + a , e

-./0/2-


This Is ho3 yo$ sho3 oth lael an5 5ata for a !BE!

E#E#BE

!oo caref$lly at ho3 I 3rote #ae >rst 3itho$t the parenthesis &' an5 then I 3rote mae 3ith the parenthesis= •

8hen creatin, laels an5 only 3hen creatin, laels $ sho$l5 sort the 5ata (if nee5e5) in the %$ery 5esi,n not in the lael it self

this s consi5ere5 a lan line e
-./0/2-


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 clicin, on this option $ can set the o$tsi5e or5er to 3hate
"% * + a , e

-./0/2-


?lippi n, an ima,e

$ll means lan66

"& * + a , e

-./0/2-


?or access rememer that 3hene
M ?$nction ( The lael lie price cost JI mo5el etc= )

Ho$ ha
"( * + a , e

-./0/2-


"* * + a , e

-./0/2-


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-


~This is a s$mmary report~

I 5i5 this as the %$estion re%$ire5 me to • performs a co$nt of the n$mer of +ro5$cts for each Co$ntry • calc$lates the s$m of the n$mer of items in Stoc for each Co$ntry • only reports 3here +ro5$cts n$mer more than 

# * + a , e

-./0/2-


8hen $ are tryin, to remo
#! * + a , e

-./0/2-


ememer that the pict$re ali,nment sho$l5 e perfect

#" * + a , e

-./0/2-


## * + a , e

-./0/2-


Instea5 of $sin, pa,e reas ,o to pa,e layo$t an5 hen clic on reas an5 then choose ext +a,e

8hen yo$ $se this comman5 $ can mae the >rst pa,e 5ierent from the other or mae one pa,e portrait an5 the other lan5scape=

#$ * + a , e

-./0/2-


ememer this step as it is $s$ally ase5 in the pp6 #% * + a , e

-./0/2-


~This is for the r$ler~

#& * + a , e

-./0/2-


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-


?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-


$+ * + a , e

-./0/2-


This is the ho3 yo$ sh5 tae a screenshot of transition ein, applie5 to the sli5es=

$ * + a , e

-./0/2-


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-


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 tae notes=

$" * + a , e

-./0/2-


T"E ODESTI; EODIE: #E T;

sho3s only the recor5s 3here the Co$ntry is Colomia or G$atemala or +er$=

-aper " $# * + a , e

,ront -./0/2-


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 rememer that 3hen $ 3rite times ne3 roman it sho$l5 e 3ritten lie 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 !ie after rial $st p$t a comma an5 3rite sansRserif= The colour code has three parts... $$ * + a , e

-./0/2-


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)

ememer to create an anchor 3hen ase5 to create a oomar an5 mae s$re that it 5oes not appear in the pre
$% * + a , e

-./0/2-


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-


n example of a style sheet

$( * + a , e

-./0/2-


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 GEE no B!DE)  +$re =;//N is ++7,,7++ (no E: 100 GEE no B!DE)  +$re >:?/ is ++7++7,, (no E: no GEE 100 B!DE)  +$re >:9@A is ++7++7++ (no E: no GEE no B!DE) +$re 8"ITE  is ,,7,,7,, (100 E: 100 GEE 100 B!DE)

$* * + a , e

-./0/2-


 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-


/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 5ic$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-


"#$%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-




*$%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 ineualit- 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-


'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-


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 horiontal 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-


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?EECE chan,es if yo$ copy across the ro3s an5 col$mns  Jal$es in BS;!DTE CE!! E?EECE 5o not chan,e if yo$ copy across the ro3s an5 col$mns %% * + a , e

-./0/2-


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-


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$mer then $st remer that it 3ill start from the ran,e = example if the ran,e is(WCW1WEW1) an5 yo$ 3ant to 5isplay 5ata from col$mn : then $ 3ill 3rite the col$mn in5ex n$mer as - an5 not as 4 = &ot s$re ao$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 ase5 to format ro3s select them this 3ay=

%( * + a , e

-./0/2-


8hen ase5 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-


Croppin, an ima,e yo$ can either 5o it man$ally or $ts enter the
&+ * + a , e

-./0/2-


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-


T"ESE 3ere the form$la $se5

This 3hole thin, is for the year octXno< -010 %$estion 14 &! * + a , e

-./0/2-


To ali,n a tale ,o to tale properties an5 then select ali,nment=

&" * + a , e

-./0/2-

Notes for Practical

Recommend Documents