ࡱ> { _bjbjzz 4G668\8 0^DDDDD]]]]]]]$`b]-"]DD]^DD]]V \D@`3?VRX:]^00^X^c^ct\^c\]]xv0^^c6 V: Spreadsheet Methods - 2013 Exam Mark Scheme Student Name: ______________________ Total Mark divided by 2 to get %: _________________ Assessment CriteriaQuestion Number Marks AwardedQuestionMark Commentary24Merge and centre cells D2 to H2, add the title Furniture Sales Monaghan. Set the font to Calibri size 14 bold with a shaded background and a thick box border.32In cell A4 add the title Today format to bold with a shaded background and a normal border.Mark 44Add each of the headings as shown (back page) from cells A6 to H6, make them bold with a shaded background, left alignment and add all borders.  Creating 60 Marks53From cell A7 to C16, E7 to E16 and A21 to B27 add text as shown (back page).64In cells D7 to D16, G7 to G16, H7 to H19 and B22 to B27 set the format of the cells currency format, with two decimal places and enter the numeric values as shown from B22 to B27 (back page).73Add all borders add shading as shown (back page)84Insert the date into cell B4 using a function.98Enter a VLOOKUP formula in cell D7 to add the Gross Price of the Product listed in C7 (use a named group of cells or absolute cell referencing). Use auto fill to drag the formula for this column.108Use a S IMPLE IF to calculate Free Gifts in cell F7 as follows, if a customer buys more than one product in Quantity they receive a Door Stopper, otherwise they receive nothing. Use auto fill to drag the formula for this column. 118Use a NESTED IF formula in cell G7 to show the price of the delivery use the following rules: If the Gross Price is over 250 charge 0, If the Gross Price is over 150 charge 10, Otherwise charge 15. Use auto fill to copy this formula to cell G16.124In cell H17 add a SUM formula to find the Total Sales.134In cell H18 add a formula to find the AVERAGE Sales.144In cell H19 add a MAX formula to find the maximum Sales.Mark/2214Delete the row for Declan Treanor.2210Add a row above Kay Kelleher and add the following details: Tom First Name, Treanor Surname, Nested Table Product and 2 Quantity Ensure all the formulas are auto filled where needed.Edit 10 Marks236Delete column F with the Free Gift.Mark243Name the worksheet Furniture Sales.Organise 10 Marks257Sort the spreadsheet with a two-key sort by the Product and the Total Price.Mark/2268Create a column chart based on the First Names of the Customers and the Total Price of all people who bought Bunk Beds.Chart 10 Marks272Save the column chart to a new worksheet and rename the worksheet as Bunk Bed Sales.282Add your name as a chart title e.g. Mary Smith.292Turn off the Legend.302Turn on the Data Labels.314Add appropriate titles to the X and Y axis of the chart.Mark11Save a Spreadsheet as Your Name to the USB provided.151Set the print area of the worksheet to A1 to H27.Save & Print 10 Marks161Set the page to landscape and scale to print 1 page wide by 1 page tall.171Turn on the Row and Column headings.181Add a Custom Header to include your name and your class group.191Turn on the formula and print the worksheet Furniture Sales.201Turn off the formula and print the worksheet Furniture Sales showing the values.321Print the Column Chart on landscape orientation.331Print your worksheet Furniture Sales after all editing has been completed.341Save the spreadsheet as Your Name to the USB memory device provided.Total Marks100Comments:Total Mark:      5N1977 Spreadsheet Methods Level 5 Exam Mark Scheme ,-9:QRqt񼯢~~lZI8 h@hCJOJQJ^JaJ h@h<@CJOJQJ^JaJ#h@h<@5CJOJQJ^JaJ#h@hU5CJOJQJ^JaJh@h-OJQJ^Jh-h-OJQJ^Jh-OJQJ^Jh(h-OJQJ^Jh(h(OJQJ^Jh@h(5OJQJ^Jhx 95OJQJ^Jh@h5OJQJ^Jh@h\5OJQJ^Jh@h=y>5OJQJ^J,-$If $$Ifa$ $$Ifa$gdUgd-gd($a$gd=y> H?22 h$If^hgd<@ $Ifgd{lkd$$Iflr e P"d' t0p)44 laPytk@x y z | } ~  y z | } µ£™£ˆzziz\zJ#h@hk@5CJOJQJ^JaJhshk@OJQJ^J h6hk@CJOJQJ^JaJhk@CJOJQJ^JaJ h@hk@CJOJQJ^JaJh/OJQJ^J#h@h5CJOJQJ^JaJhshsOJQJ^J h@hCJOJQJ^JaJh tOCJOJQJ^JaJ h6hCJOJQJ^JaJhsCJOJQJ^JaJy z { | 4$$$If^a$gd<@kd$$Ifl4r e P"d' t0p)44 laPytk@ $$Ifa$ $Ifgd=y>| ~ $$Ifa$ $Ifgd- h$If^hgd<@ F2$u$If]u^a$gdk@$q$If]q^a$gdkd$$Ifl4r e P"d'  t0p)44 laPytk@ z { | } ~  $$Ifa$gdk@ $$Ifa$$If $Ifgd=y> h$If^hgd<@$q$If]q^a$gd$u$If]u^a$gdk@ }  ͼ~pcQ~CcQ~CchMCJOJQJ^JaJ#h@h5CJOJQJ^JaJhshsOJQJ^Jh tOCJOJQJ^JaJ h6hCJOJQJ^JaJhsCJOJQJ^JaJ h@hCJOJQJ^JaJh{lCJOJQJ^JaJ h@h{lCJOJQJ^JaJ h@hk@CJOJQJ^JaJ#h@hk@5CJOJQJ^JaJhk@5CJOJQJ^JaJ kd^$$Iflִ e H"d'T( t0p)    44 laPytk@ $$Ifa$ $Ifgd\ h$If^hgd<@$q$If]q^a$gd{l F6)) h$If^hgd<@$$If^a$gd<@kdx$$Ifl4r e P"d' t0p)44 laPytk@ 1kdR$$Ifl4r e P"d'  t0p)44 laPytk@ $$Ifa$gd- $Ifgd- $$Ifa$ $Ifgd- h$If^hgd<@$$If^a$gd<@      rtv"JNRUϾϾϾϾ~ϾϾ h@hsCJOJQJ^JaJhOJQJ^JhsOJQJ^JhshsOJQJ^Jh tOCJOJQJ^JaJ h6hCJOJQJ^JaJhsCJOJQJ^JaJ#h@h5CJOJQJ^JaJ h@hCJOJQJ^JaJ1 F6)) h$If^hgd<@$$If^a$gd<@kd&$$Ifl4r e P"d'  t0p)44 laPytk@     4$$$If^a$gd<@kd$$Ifl4r e P"d'  t0p)44 laPytk@ $$Ifa$ $Ifgdi.  $$Ifa$ $Ifgd- h$If^hgd<@ F6)) h$If^hgd<@$$If^a$gd<@kd$$Ifl4r e P"d'  t0p)44 laPytk@ 4$$$If^a$gd<@kd$$Ifl4r e P"d'  t0p)44 laPytk@ $$Ifa$ $Ifgd- v"N $$Ifa$ $Ifgd- h$If^hgd<@F6) h$If^hgd]$$If^a$gd<@kd$$Ifl4r e P"d'  t0p)44 laPytk@'kdb $$Ifl4r e P"d'  t0p)44 laPytk@ $$Ifa$ $Ifgd- h$If^hgd<@ST $$Ifa$ $IfgdG, h$If^hgd<@ h$If^hgd]$$If^a$gd<@TUVYF6) h$If^hgd]$$If^a$gd<@kd< $$Ifl4r e P"d'  t0p)44 laPytk@UVXYZ[ '0=E烙xfx\xLxLxLhshk@56OJQJ^Jhk@OJQJ^J#h@hk@5CJOJQJ^JaJhshk@OJQJ^J h6hk@CJOJQJ^JaJhk@CJOJQJ^JaJ h@hk@CJOJQJ^JaJhshKOJQJ^Jh tOCJOJQJ^JaJ h6hKCJOJQJ^JaJhKCJOJQJ^JaJ h@hKCJOJQJ^JaJY['kd $$Ifl4Hr e P"d'  t0p)44 laPytk@ $$Ifa$ $IfgdG, h$If^hgd<@ $$Ifa$ $Ifgd-$$If^a$gd%Y$$If^a$gd@ $$Ifa$gdk@ $Ifgdk@ kd $$Ifl4֞ e P"d'` t0p)44 laPytk@T $$Ifa$ $Ifgd%Y$$If^a$gd%Y$$If^a$gd-qu$$If^a$gd<@ EHIKSTŴ󴕇vviYiH h@hd~ECJOJQJ^JaJhshs56OJQJ^JhshsOJQJ^J h6h%YCJOJQJ^JaJhsCJOJQJ^JaJ h@h%YCJOJQJ^JaJhk@CJOJQJ^JaJ h@hk@CJOJQJ^JaJ hshk@CJOJQJ^JaJhk@56OJQJ^Jhshk@56OJQJ^Jhshk@OJQJ^J kd $$Ifl4֞ e P"d'` t0p)44 laPytk@ $$Ifa$ $Ifgd%Y$$If^a$gd%Y$$If^a$gd-qu$q$If]q^a$gdHF6&$$If^a$gd-qu$$If^a$gd<@kd$$Ifl4nr e P"d'  t0p)44 laPytk@$kd $$Ifl4r e P"d' t0p)44 laPytk@ $$Ifa$ $Ifgd-$$If^a$gd%Y $$Ifa$ $Ifgd- h$If^hgd<@$$If^a$gd-qu$$If^a$gdk@ $If^gdk@LS\ghklrtvwxyвxhxhx[MhKhk@5OJQJ^JhKhk@OJQJ^Jhshs56OJQJ^JhshsOJQJ^JhL,TCJOJQJ^JaJ h6h(CJOJQJ^JaJhsCJOJQJ^JaJ h@h(CJOJQJ^JaJhshk@OJQJ^J h@hk@CJOJQJ^JaJhk@CJOJQJ^JaJ h6hk@CJOJQJ^JaJ kd$$Ifl4֞ e P"d';|` t0p)44 laPytk@ $$Ifa$ $Ifgd- h$If^hgd<@$$If^a$gd-qu$q$If]q^a$gdk@F6&$$If^a$gd-qu$$If^a$gd<@kd$$Ifl4ar e P"d'  t0p)44 laPytk@ijk'kd$$Ifl4r e P"d' t0p)44 laPytk@ $$Ifa$ $Ifgd- h$If^hgd<@klstwy $$Ifa$ $If^gd%Y h$If^hgd<@$$If^a$gd-qu$$If^a$gdk@ $Ifgdk@]acdefijyoyyyyyh]OJQJ^JhKhKOJQJ^JhL,TCJOJQJ^JaJ h6hsCJOJQJ^JaJhsCJOJQJ^JaJ h@hsCJOJQJ^JaJhk@CJOJQJ^JaJ h@hk@CJOJQJ^JaJhKhk@56OJQJ^JhKhk@OJQJ^J%kd$$Ifl4֞P e P"d';1_ t0p)44 laPf4ytk@^_ $$Ifa$ $If^gd] h$If^hgd<@$$If^a$gd-qu$q$If]q^a$gd tO_`adE1!$$If^a$gd-qu$q$If]q^a$gd<@kd$$Ifl4<r e P"d' t0p)44 laPf4ytk@df $$Ifa$ $If^gd%Y h$If^hgd<@E1!$$If^a$gd-qu$q$If]q^a$gd<@kd$$Ifl4r e P"d' t0p)44 laPf4ytk@ $$Ifa$ $If^gd%Y h$If^hgd<@E1!$$If^a$gd-qu$q$If]q^a$gd<@kd$$Ifl4r e P"d' t0p)44 laPf4ytk@ $$Ifa$ $If^gd%Y h$If^hgd<@E1!$$If^a$gd-qu$q$If]q^a$gd<@kd$$Ifl4r e P"d' t0p)44 laPf4ytk@ $$Ifa$ $If^gd%Y h$If^hgd<@E<0< $$Ifa$gdk@ $Ifgdk@kdk$$Ifl4r e P"d' t0p)44 laPf4ytk@ !"8AUVY\^_`a%()õëëᚌ~m`m~m`mhshsOJQJ^J h@h(CJOJQJ^JaJhL,TCJOJQJ^JaJhsCJOJQJ^JaJ h6h(CJOJQJ^JaJhk@OJQJ^Jhshk@5OJQJ^Jhshk@OJQJ^J h@hk@CJOJQJ^JaJhk@CJOJQJ^JaJ h6hk@CJOJQJ^JaJ% "WX $$Ifa$ $IfgdG,$$If^a$gdd~E$$If^a$gd-quXY kdN$$Ifl4֞5! e P"d'Q` t0p)44 laPytk@YZ[\_a $$Ifa$ $IfgdG,$$If^a$gdd~E$$If^a$gd-qu$$If^a$gd<@ kdL$$Ifl4֞5! e P"d' Q   t0p)44 laPytk@ $Ifgd\ $$Ifa$gdd~E$$If^a$gd-qu$q$If]q^a$gdk@F6&$$If^a$gd-qu$$If^a$gd<@kdT$$Ifl4r e P"d' t0p)44 laPytk@&'($kd.$$Ifl4r e P"d'  t0p)44 laPytk@ $$Ifa$ $IfgdG,$$If^a$gdd~E(),.mn $$Ifa$ $IfgdG,$$If^a$gdd~E$$If^a$gd-qu$$If^a$gd<@)+,-.loprstu!'GJKMNOPµµµšššhKhK56OJQJ^JhfOJQJ^JhKhKOJQJ^JhKCJOJQJ^JaJhshsOJQJ^J h@h(CJOJQJ^JaJhL,TCJOJQJ^JaJ h6h(CJOJQJ^JaJhsCJOJQJ^JaJ-nopsF6&$$If^a$gd-qu$$If^a$gd<@kd$$Ifl4r e P"d'  t0p)44 laPytk@su'kd$$Ifl4r e P"d'  t0p)44 laPytk@ $$Ifa$ $IfgdG, h$If^hgdd~E $$Ifa$ $Ifgd=y> h$If^hgdd~E$$If^a$gd-qu$$If^a$gd<@F6&$$If^a$gd-qu$$If^a$gd<@kd$$Ifl4r e P"d'  t0p)44 laPytk@HIJ'kd~$$Ifl4r e P"d'  t0p)44 laPytk@ $$Ifa$ $Ifgdf h$If^hgdd~EJKNP $$Ifa$ $Ifgd=y> h$If^hgdd~E$$If^a$gd-qu$$If^a$gd<@F6&$$If^a$gd-qu$$If^a$gd<@kdR$$Ifl4r e P"d'  t0p)44 laPytk@'kd& $$Ifl4r e P"d'  t0p)44 laPytk@ $$Ifa$ $IfgdK h$If^hgdd~E$If $$Ifa$gdqj $Ifgd\$$If^a$gd<@ !#$%,@[\]^_ʽp[pIEh=y>#h@h=y>5CJOJQJ^JaJ(h tO5CJOJQJ^JaJmHnHu.h@h=y>5CJOJQJ^JaJmHnHu7jh@h=y>5CJOJQJU^JaJmHnHuhjhUh@h H<OJQJ^Jh@h=y>OJQJ^J h@hd~ECJOJQJ^JaJ#h@hqj5CJOJQJ^JaJ#h@h%Y5CJOJQJ^JaJHFFFAFAgdeAkd $$Ifl1r P"d'  t0p)44 laPytk@ "#[\]^_gdeA 21h:p(. A!"R#7$%w $$IfP!vh#v#v#v#v#v:V l t0p),55555aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p))v+,55555aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p)+,55555/ aPytk@$$IfP!vh#v#v#v#v#v#v#v#v:V l t0p)55555555/ /  / / aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p))v+,55555/ aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p)+,55555/ aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p)+,55555/ aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p)+,,55555/ aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p)+,,55555/ aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p)+,,55555/ aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p)+,,55555/ aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p)+,,55555/ aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p)+,,55555/ aPytk@$$IfP!vh#v#v#v#v#v:V l4H t0p)+,,55555/ aPytk@$$IfP!vh#v#v#v#v#v#v#v:V l4 t0p))v)v+++,,,5555555/ aPytk@$$IfP!vh#v#v#v#v#v#v#v:V l4 t0p)+++++++,,5555555/ aPytk@$$IfP!vh#v#v#v#v#v:V l4n t0p))v+++++,,55555/ aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p)+,,55555/ aPytk@$$IfP!vh#v;#v|#v#v#v#v#v:V l4 t0p)++++,,,5;5|55555/ / aPytk@$$IfP!vh#v#v#v#v#v:V l4a t0p))v+++++,,55555/ aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p)+,,55555/ aPytk@$$IfP!vh#v;#v1#v_#v#v#v#v:V l4 t0p))v)v,,,5;515_5555/ / aPf4ytk@$$IfP!vh#v#v#v#v#v:V l4< t0p))v+,,55555/ aPf4ytk@$$IfP!vh#v#v#v#v#v:V l4 t0p))v+,,55555/ aPf4ytk@$$IfP!vh#v#v#v#v#v:V l4 t0p))v+,,55555/ aPf4ytk@$$IfP!vh#v#v#v#v#v:V l4 t0p))v+,,55555/ aPf4ytk@$$IfP!vh#v#v#v#v#v:V l4 t0p))v+,,55555/ aPf4ytk@$$IfP!vh#vQ#v#v#v#v#v#v:V l4 t0p))v)v+++,,5Q555555aPytk@$$IfP!vh#vQ#v#v#v#v#v#v:V l4 t0p)+++,5Q555555/ / aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p))v+,55555/ aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p)+,55555/ aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p)+,55555/ aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p)+,55555/ aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p)+,55555/ aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p)+,55555/ aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p)+,55555/ aPytk@$$IfP!vh#v#v#v#v#v:V l4 t0p)+,55555/ aPytk@$$IfP!vh#v#v#v #v#v:V l1 t0p),555 55aPytk@^ 666666666vvvvvvvvv666666>6666666666666666666666666666666666666666666666666hH6666666666666666666666666666666666666666666666666666666666666666662 0@P`p2( 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p8XV~_HmH nH sH tH H`H Normal CJOJQJ_HaJmH sH tH DA D Default Paragraph FontVi@V  Table Normal :V 44 la (k (No List @@@ - List Paragraph ^4@4 Header  !4 4 Footer  !PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭V$ !)O^rC$y@/yH*񄴽)޵߻UDb`}"qۋJחX^)I`nEp)liV[]1M<OP6r=zgbIguSebORD۫qu gZo~ٺlAplxpT0+[}`jzAV2Fi@qv֬5\|ʜ̭NleXdsjcs7f W+Ն7`g ȘJj|h(KD- dXiJ؇(x$( :;˹! I_TS 1?E??ZBΪmU/?~xY'y5g&΋/ɋ>GMGeD3Vq%'#q$8K)fw9:ĵ x}rxwr:\TZaG*y8IjbRc|XŻǿI u3KGnD1NIBs RuK>V.EL+M2#'fi ~V vl{u8zH *:(W☕ ~JTe\O*tHGHY}KNP*ݾ˦TѼ9/#A7qZ$*c?qUnwN%Oi4 =3N)cbJ uV4(Tn 7_?m-ٛ{UBwznʜ"Z xJZp; {/<P;,)''KQk5qpN8KGbe Sd̛\17 pa>SR! 3K4'+rzQ TTIIvt]Kc⫲K#v5+|D~O@%\w_nN[L9KqgVhn R!y+Un;*&/HrT >>\ t=.Tġ S; Z~!P9giCڧ!# B,;X=ۻ,I2UWV9$lk=Aj;{AP79|s*Y;̠[MCۿhf]o{oY=1kyVV5E8Vk+֜\80X4D)!!?*|fv u"xA@T_q64)kڬuV7 t '%;i9s9x,ڎ-45xd8?ǘd/Y|t &LILJ`& -Gt/PK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 0_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!0C)theme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK] _ FFFFFI} UE)_ %*06BKU|  TYk_dXY(nsJ_  !"#$&'()+,-./12345789:;<=>?@ACDEFGHIJLMNOPQRSTVW@ @ (  VB  C D"?0(  B S  ? Is$su% 0  "#]` "#]`3{|}    X Y Z \ ! '  "#%,]`{|}    X Y Z \ ! ' `InXt*ky &U["RR(`(썢WL+kJA7~6oX72r=:S<)2<$E8.LLbD9?Mx|wQZ9_ORTcb,&bR(Pld.uHy:'4_BzazR4`}jbh^`56o(hH1.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h ^`hH.h ^`hH.h L^`LhH.h ^`hH.h X ^X `hH.h (#L^(#`LhH.h %^%`hH.h (^(`hH.h +L^+`LhH.^`56o(hH3. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.h ^`hH.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH. ^`o(hH4. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.h^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hH ^`hH. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH. z^z`OJQJo(J^J`OJQJ^Jo(o  ^ `OJQJo(  ^ `OJQJo(^`OJQJ^Jo(o ^`OJQJo( Z^Z`OJQJo(*^*`OJQJ^Jo(o ^`OJQJo(^`5o( ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.^`.^`.pL^p`L.@ ^@ `.^`.L^`L.^`.^`.PL^P`L.h^`OJQJo(hH^`OJQJ^Jo(hHop^p`OJQJo(hH@ ^@ `OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hH^`OJQJo(hH^`OJQJ^Jo(hHoP^P`OJQJo(hH^`56o(hH2. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.^`.^`.pL^p`L.@ ^@ `.^`.L^`L.^`.^`.PL^P`L.  hh^h`o(hH ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.9s^`sCJOJQJaJo(hH9^`OJQJ^Jo(hHo9pp^p`OJQJo(hH9@ @ ^@ `OJQJo(hH9^`OJQJ^Jo(hHo9^`OJQJo(hH9^`OJQJo(hH9^`OJQJ^Jo(hHo9PP^P`OJQJo(hHhz^z`OJQJo(hHJ^J`OJQJ^Jo(o  ^ `OJQJo(  ^ `OJQJo(^`OJQJ^Jo(o ^`OJQJo( Z^Z`OJQJo(*^*`OJQJ^Jo(o ^`OJQJo(^`.^`.pL^p`L.@ ^@ `.^`.L^`L.^`.^`.PL^P`L.^`.^`.pL^p`L.@ ^@ `.^`.L^`L.^`.^`.PL^P`L.h^`.h^`.hpLp^p`L.h@ @ ^@ `.h^`.hL^`L.h^`.h^`.hPLP^P`L. ^`o(hH4. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH. ^`hH. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.^`.^`.pL^p`L.@ ^@ `.^`.L^`L.^`.^`.PL^P`L. 8^8`OJQJo(^`OJQJ^Jo(o  ^ `OJQJo(  ^ `OJQJo(x^x`OJQJ^Jo(o H^H`OJQJo( ^`OJQJo(^`OJQJ^Jo(o ^`OJQJo(^`.^`.pL^p`L.@ ^@ `.^`.L^`L.^`.^`.PL^P`L.h ^`hH.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.hh^h`OJQJo(hHh8^8`OJQJ^Jo(hHoh^`OJQJo(hHh ^ `OJQJo(hHh ^ `OJQJ^Jo(hHohx^x`OJQJo(hHhH^H`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHoX79?MR&b[azcbWL+In<$Ey &LPld_BzA7~6|wQur=:9_OR8.LS<tHy`(`}T*G(4                 vr                 vp                                   ֳ                          ^                 s        \u                                                                                                  87iG,e468x 9 H<=y><@@k@d~EM7 O tOL,Tub$h jqjsp"t-qu@wv=/6A(eAs"-KNKD\Q]U{lH^zA%Y\]`%i.kf@-@     (_@ @UnknownG*Ax Times New Roman5Symbol3. *Cx Arial7.@ CalibriA. Trebuchet MS?= *Cx Courier New;WingdingsA$BCambria Math"qhsb&^'fc  724 3qHP?NK2!xx Question 1  6 marksRynagh McNally Rynagh McNallyt                     Oh+'0  $0 P \ h tQuestion 1 6 marksRynagh McNally NormalRynagh McNally17Microsoft Office Word@ @L@0F@ 3? ՜.+,0 hp|    Question 1 6 marks Title  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXZ[\]^_`abcdefghiklmnopqrstuvwxyz{|}~Root Entry F@%c3?Data Y!1TablejcWordDocument4SummaryInformation(DocumentSummaryInformation8CompObjr  F Microsoft Word 97-2003 Document MSWordDocWord.Document.89q