ࡱ> $(  0 T Tables,pptlinks/tableform.doc`Show extract-*pptlinks/wordfill.docdNarrative Form,pptlinks/proseform.docz6Colours exercise 4 page 13.(pptlinks/colours.docjCheck solution2pptlinks/Sol_TBExCol2.exe/ 0DArialngs||\0z[ 0DTahomags||\0z[ 0 DWingdings||\0z[ 0 A .  @n?" dd@  @@`` P)    "$%' 0AA@p=ʚ;!3ʚ;g4RdRdz[ 0zppp@ <4dddd@ 0|4 <4!d!d@< 0|0___PPT10 ___PPT9?  %Spreadsheets ICT4U ,In stage 4 John Ley Australian ICT InstituteHistoryInvited by the Principal of my school to develop the spreadsheet ICT skills in stage 4. In 2002 developed work booklet for year 8 In 2003 had all staff trained to deliver material In 2004 focused on DS4.1 Data Representation. Developed software support in year 7. How it works?-Classes were booked into the computer room for a fortnight allowing 7 lessons for completion of the work booklet. In 2005 a double period per fortnight for term 1 in year 7 Students work at their own pace through the work booklet. Solutions and demonstrations available through the CD ROM when needed.How was it assessedBefore students were given a pen and paper test covering all the skills that were to be developed. In 2004 interactive automated computerised testing takes place using the CD ROM.&What was the skill level of the staff?Staff skill levels ranged from the high level that designed the booklet to  What s a mouse level of ability. After repeating the course with three different classes the computing teacher thought that there must be a better way and developed the CD ROM. No teacher skill level required, students are autonomous learners.)What was the skill level of the students?BThe student s level of skill had a similar range to that of the staff. There was peer mentoring within the class as students of high skill level assisted others. How does it work?1Students have their own work booklet that they complete, writing in the answers and pasting in relevant spreadsheets. There is an accompanying CD ROM that provides demonstrations, solutions, tests and other support material fully covering at a minimum, all aspects of the ICT requirements in spreadsheets.22 Structure of the work bookletThe work booklet begins with a range of differentiated learning tasks establishing the advantages of particular forms of data representation. The forms are Narrative Form on page 1 Tables page 3 GraphsZ U 0 U 0  GlossaryThe next exercise has a passage where terms need to be filled in. Show extract- cloze activity page 5. There is a glossary on the CD that is available to assist the student. Will demonstrate glossary later. U 0BOStructure of work booklet3 exercises on prose and tabular form 13 spreadsheet exercises covering all ICT skills. 6 further exercises on other stage 4 syllabus sections. See table page VI. Develop spreadsheet skills in first 13 exercises, consolidate throughout stage 4 with 6 further exercises.Z  Structure5We will work through the first spreadsheet exercise of the work booklet, on page 7, as a demonstration. Each exercise identifies a list of new skills needed to complete the exercise reinforcing ongoing skill acquisition, providing a scaffold. The CD ROM has a link for each of these, providing demonstrations.66  Skills DemonstrationUse the CD to demonstrate now.  Demonstrate colours exerciseAs the student progresses through the work booklet there are fewer new skills in each exercise and the degree of sophistication increases. This allows the students to build new skills, reinforce acquired skills and have the opportunity to revisit skills not fully developed.Demonstrate colours exercisezColours exercise 4 page 13. Examine the exercise and consider each of the questions. Demonstrate the solution from the CD.` U 0Exercise 13 colours 2Examine exercise 13 colours 2 on page 35. This extends the previous exercise number 4, colours 1. Consider the spreadsheet. Check solution  U 0| AssessmentThe CD ROM has a number of tests that are self marking and scoring. Demonstrate quizzes Work booklets are collected and marked. Pen and paper test.What else is there?There are six other spreadsheet activities linked to other areas of the stage 4 syllabus as shown in this table. This promotes further learning in spreadsheets and the stage 4 mathematics course and maintains the skills developed.Promoting skilled learners Students develop spreadsheet skills as independent learners. Students develop and attain skills in interpreting visual data by being engaged learners. (From table to graph) Students are more able to transfer and extract knowledge from a variety of visual forms. (SNAP)The ICT4U BookletProvides a scaffold for student learning. Students are explicitly taught. Demonstration, application, execution, repetition, construction and consolidation. Allows students to have self paced learning.The ICT4U BookletContinuum of skill development. Opportunity for parents to engage in the learning. Complete activities at home. No failure, promotes positive self esteem in a positive learning environment. PriceRRP $14.95 Conference special discount makes it $10. Schools sell to students for $10. Schools are charged $11 including $1 GST but claim the GST back.1i". ` 33PP` 13` 3333` Q_{` 333fpKNāvI` j@v۩ῑ΂H>?" dd@,?n<d@ `7 `2@`7``2 n?" dd@   @@``PR    @ ` ` p>> P H  H (  H H <s" H 0   H Txvd" H 0   H <z"U_ H 0   H T}d">& H 0   H NȀ"P H 0   H <x"p H 0   H C x ?d?"bUv H 0    H < #" `   T Click to edit Master title style! !$  H 0 "   RClick to edit Master text styles Second level Third level Fourth level Fifth level!     S  H 6 "]}  F*0  H 6H "] }   H*0  H 6 "]T}  H*0B H s *޽h ? 333380___PPT10.(г%  Blends}     0L (  LT + L "+bb P@ L# "Dwoh L s *"PP L Bd" P@bb P 0  L# "Nyh L s *"P   L Bd"P 0 z  L <" a*h  L s *"  L  f?d?"+)  L BR/ ?#" ` p / T Click to edit Master title style! !  L 0`U/ " `   / W#Click to edit Master subtitle style$ $ L 6 Z/ "`p  / J* 0 L 6T^/ "`p  / L*"0 L 6?" dd@,?" dd@   " @ `"  n?" dd@   @@``PT    @ ` `6p>> &PT(  TZ  T# "2 T  BCDEF"d@ @`s"*    T c BCDEF"v @ @`" * T  BtCDEF"d@ tttt@`s"*  i` Z P T# "P T c B CDEF @))<  _ wv J c /JVJBeW<_JW R"R"F(.6 JJJQ^tkK-,&k < < TX@`"x\  P T " P  T BCDE<FF|urBAwK-Id<|u $@`"lP  T BCaDE@FJ$6B*r0a6T~~xZB<$$"$@`"u / [  T BzCDE,F6  (<y6"zL^Z6@`" 5P D  T BCBDE4F> rN<`*B~rr @`",d  T B*CHDE4F> $  $**0 H$$ @`"  d T c TBCDEF @88 1$s[6C6&fH~fM~ vpjd^ L@. $*<HW090HH<< HC<=<1HNZxNrt@`"Z  T# "^ T BmCDEdFn<BlU1mg~Or+ZH6$k_H B 6*48@`"F T BCDEXFb`$ <hZg gnm\=.0@`"F T BGC<DEXFb 5;A*G6G<;6/*$* 000$.0@`"&m,& T BCDEHFR0Hr `6`<fHlTx`r`f6&(@`"W T B;C<DE4F> ;))$/*565</6#0$;; @`"Kf T (BCDEhFr$*TM/TYB;$  /MSYe } $$68@`" T 6tz  " ``   T Click to edit Master title style! !$ T 0}  " `   RClick to edit Master text styles Second level Third level Fourth level Fifth level!     S T 6  #" `` `   @*  T 6̆  #" ``    B*  T 6  #" `` `   B* T T <v޽h @ ? 3F433___PPT10i. `+D=' = @B + Mountain Top  `Xi(  XZ  X# " |2 X  BCDEF"d@ @`s"*    X c BCDEF"v @ @`" * X  BtCDEF"d@ tttt@`s"*  m\| Z N X# "M X c B CDEF @))<  _ wv J c /JVJBeW<_JW R"R"F(.6 JJJQ^tkK-,&k < < TX@`"x\  N X " N  X BCDE<FF|urBAwK-IP<|u $@`"lN  X BCaDE@FJ$6B*r0a6T~~xZB<$$"$@`"u / [  X BzCDE,F6  (<y6"zL^Z6@`" 5P D  X BCBDE4F> rN<`*B~rr @`",d  X B*CHDE4F> $  $**0 H$$ @`"  d X c TBCDEF @88 1$s[6C6&fH~fM~ vpjd^ L@. $*<HW090HH<< HC<=<1HNZxNrt@`"Z  X# "^ X BmCDEdFn<BlU1mg~Or+ZH6$k_H B 6*48@`"F X BCDEXFb`$ <hZg gnm\=.0@`"F X BGC<DEXFb 5;A*G6G<;6/*$* 000$.0@`"&m,& X BCDEHFR0Hr `6`<fHlTx`r`f6&(@`"W X B;C<DE4F> ;))$/*565</6#0$;; @`"Kf X (BCDEhFr$*TM/TYB;$  /MSYe } $$68@`" X <  " `   T Click to edit Master title style! ! X 0(  "p`     W#Click to edit Master subtitle style$ $ X 6Ԩ  #" `` `   @*  X 6  #" `` `   B*  X 6  #" ``    B* T X <v޽h @ ? 3F433___PPT10i. `+D=' = @B +  0(  x  c $ X `   x  c $ Xp`     H  0޽h ? 33___PPT10i.Y0P+D=' = @B +  0 0(   x  c $/ H   / x  c $ / H  / H  0޽h ? 33___PPT10i.Y@h7e+D=' = @B +  @0(  x  c $l/ H   / x  c $M/ H  / H  0޽h ? 33___PPT10i.YVl+D=' = @B +  P0(  x  c $\/ H   / x  c $/ H  / H  0޽h ? 33___PPT10i.YeAu+D=' = @B +}   $(  r  S / H   / r  S 0/ H  / H  0޽h ? 3333___PPT10i.q+D=' = @B +  `0(  x  c $x/ H   / x  c $L/ H  / H  0޽h ? 33___PPT10i.ZpT+D=' = @B +   0(   x  c $/ H   / x  c $/ H  / H  0޽h ? 33___PPT10i.Z0++D=' = @B +  (0(  (x ( c $/ H   / x ( c $|/ H  / H ( 0޽h ? 33___PPT10i.\O+D=' = @B +  ,0(  ,x , c $/ H   / x , c $/ H  / H , 0޽h ? 33___PPT10i.\A+D=' = @B +}  @$(  r  S X/ H   / r  S ,/ H  / H  0޽h ? 3333___PPT10i.z+D=' = @B +  $0(  $x $ c $/ H   / x $ c $/ H  / H $ 0޽h ? 33___PPT10i.Z}+D=' = @B +  00(  0x 0 c $/ H   / x 0 c $/ H  / H 0 0޽h ? 33___PPT10i.`^+D=' = @B +  80(  8x 8 c $/ H   / x 8 c $/ H  / H 8 0޽h ? 33___PPT10i.`+D=' = @B +  p<(  p~ p s */ H   / ~ p s */ H  / H p 0޽h ? 33___PPT10i.`+D=' = @B +}  d$(  dr d S / H   / r d S |/ H  / H d 0޽h ? 3333___PPT10i.Π@+D=' = @B +  @0(  @x @ c $/ H   / x @ c $  H  / H @ 0޽h ? 33___PPT10i.` 3+D=' = @B +}  `$(  `r ` S   H    r ` S   H    H ` 0޽h ? 3333___PPT10i.a+D=' = @B +}  t$(  tr t S l  H   l  r t S l  H  l  H t 0޽h ? 3333___PPT10i.l+D=' = @B +}  x$(  xr x S p  H    r x S D  H    H x 0޽h ? 3333___PPT10i. +D=' = @B +  |0(  |x | c $TB  H    x | c $(C  H    H | 0޽h ? 3333___PPT10i. +D=' = @B +}  P$(  r  S Pl  H   l  r  S l  H  l  H  0޽h ? 3333___PPT10i..+D=' = @B + pr(  :  S D  HG    AUSTRALIAN I.C.T INSTITUTE ABN 26 467 318 723 PO Box 8244 Glenmore Park NSW 2745 Ph 0429 928 911 fax 0247318939 email sales@ict4u.com.au Website www.ict4u.com.au(H  0޽h ? 3333___PPT10i.P+D=' = @B +rP[|~}$ PFא~¢$ 4>_S=ا] hs"? ˴"Oh+'0T hp  Spreadsheets o John LeyetsBlendsysig55Microsoft PowerPointP@ԟ@&Y@ /)GSg  )'    """)))UUUMMMBBB999|PP3f333f3333f3ffffff3f̙3ff333f333333333f33333333f33f3ff3f3f3f3333f33̙33333f333333f3333f3ffffff3f33ff3f3f3f3fff3ffffffffff3ffff̙fff3fffff3fff333f3f3ff3ff33f̙̙3̙ff̙̙̙3f̙3f333f3333f3ffffff3f̙3f3f3f333f3333f3ffffff3f̙3f3ffffffffff!___www4'A x(xKʦ """)))UUUMMMBBB999|PP3f3333f333ff3fffff3f3f̙f3333f3333333333f3333333f3f33ff3f3f3f3333f3333333f3̙33333f333ff3ffffff3f33f3ff3f3f3ffff3fffffffff3fffffff3f̙ffff3ff333f3ff33fff33f3ff̙3f3f3333f333ff3fffff̙̙3̙f̙̙̙3f̙3f3f3333f333ff3fffff3f3f̙3ffffffffff!___wwwCCC"D#CD#""C"#I#CCC"DC##C#CD""D##CC"#"#C""D")#C#"#C"D""CD"##C#"#C#I"DC#C#)C#CC#CD(C#"C#)D""CCC"D#CD#""C"#I#CCC#DC##C#CDC"D##CC"#"#C""D"D)D"C#(CCDI#C"#C)#C""C"D"#"D"CCC#D#CCC#C#CCC"DIC"D"CDC"DCCC"CDCD"D#C#I#CCD"#D""CD#CCDCCCCD"D)D"C""CCDI#C##C)DC("D"DI#"D"C"C#D#CC"#C#CDCI#C#D#CD#CC#CC#CDDC)C#CC)C#DC)"ID)DCDD(#DC#CD#IDD(D#"ID#D#C#(C#CC#C#"C)CCD)D#CID#C#D"#C#"CCC#CDDDCD#IC#DC#CDDCJC#DI)C##C""C")DIDI#DDIC#I#IDDIDC#CJC#I#CCDCDCCI#CCDCDCD)CDC(DI#IDC#CJCID"DIC(DCDCDDD)CCDD)D)"CC""#"CCC"C#CIDJDDDIIDIJIDDIDIDCJC#IDICDC#"C"#"C#"#CIDICDDCDCDIDD#IDIDDIDDDID)ID)DCD)CD#CIDIDDID#DI#DI#DDDIDI#DDC#"#C#"C#"C"C"CD#"#CDC#JJIDDDJCIDICJDDDDgJJDJJDlDC""DDC#"C#"DJDDJDDIDJJCDCJCDDJDIDDJCJDCDCDDJIDDJCJDDJJDCDIDDDIDDICJDCDJD("CC"C"C#CC#DC#""D"gJJJgJmDJm"D"gJJJDJgJJIDmJJDDJDC#C#"#"C#CJIJIDJDlJCgJDJDJJIDJDJIDJDJDJJIJmDDDJgDJJDgJJJIDIgJJJDDDJgJIDD##CD#C#"D""""DJgJmJmJmJDKmJC#CJJmJmJmJJgJmJgJJmJmD#I#CDCDgDDJgIDJJDJJJJDmDJDJJmDmJDJJDDJDDmJlDJmDJJJDmDDJDJIJDlJJJDmD"C"C"#"C"D")mmJ"mKmhJmDKmJm##C"DmmJhJmJKgJJKmJmKJgJJC"C""JJmJJJmJmJgmDgJJmJJgJDJJDmJmJmJJJJJDJDJJC"DJDJJmJDmDmJDJgJJ"D"C#C"C#"CmmKmnC#JmJmKmJmn#C"C#"#mJJKmmnmnmmmKJmmJn"D"#DJDKmJgJDJJJJJCCDJmJJJmJJJm#DJmgJmJnmJm"##mmJmKDJnJJJKmJJmC#C"D"#C#CnmKmmPmKCnmnmmnmn""CDnmmnJmKmJnmmmnnrm""D""mJJmgJgm"#JmJmDnJgJmg"JmJJJJgJJ"C#CCC#KgJJmJJgmmJCg"##C##"CC#mnP"smKmnmCCKmmsmKCDmKrmnnmQnKmJnnD"D"mKJmJ#C"IKmJmJmKmK"nJJmKgmKJD"D"#"#mKmJKJm##C"C"CC#nmnCnrmnm##"snnJnrnnmC"#mmrnmrC"C#mKmJCD#CDKm#mJm"C"JnJmJJm"C#C"D"mmmDJC"DC#D#nnnrnCCD"rrKmnnC#CJm"#""mJnJm#C##Jm"#mnr#"r"#NjNJNjNJNJNJǦNJNjNjǦNJNJNJNJNJNJNJNJdžǦNJdžǦNJdžǦdždždžǦǦeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee_eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee_eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee_eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee_eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee_eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee_eeeeee_eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee_eeeeee_eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee_eeeeeeee_eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee_eeeeeeee_eeeeeeeeeeeeeeeeeeeeeeeeeee_eeeee_eeeeeeeeeeeeeeeeeeeeeeeee_eeeeeeeeeeeeeeee_eeeee_eeeeeeeeeeeeeeeeeeeeeeeeeee_eeeeeeeeeeeee_eeeeeeeee_eeeeeeeee_eeeeeeeeeeeee_eeeeeeeeeeeee_e_eeeeeeeeeeeeeeeeee_eeee_eeeeeeeeeeeeeeeeeeee_eeeeeeeeeeee_eeeeeeeeeeeeeeee_ee_eeeeeee_eeeeeeeeeeeeeeeee󅦦eeeeeeeeeeeeee_eeeeee_eeeeeeeeee_eeeeeeeeee_e_eeee_eeeeee_eeeeeeeeeeeeeeeeeeeeee_eeeeeeeeeeeeeee_eeeeeeeeee_e_eeeeeeeeeee_eeee_eeeeee_eeeeeee_eeeeeeeeeeeeeeeeee_ee_eeee__e_ee_eeeeeeeeeeeeee_eee_eeeeeeeeee_ee_eeeee_eeee_e_eeeeeeeeeee_eeeeee__ee_eeeeeeeeeee_eeeeeee_eeeeeeeeeee_eeeeee_eeeee__eee_ee_e_ee_e_eeeeeeee_eeeee_eeeeeeee_ee_eeee_ee_e__eeeee_e_eeeeeee_eeeeeeee_e_ee_eeeeeeeee_eeeee_eeeeeee_ee_e__eeeeeee__eee_eeeeeeee_eeee_ee_eeeeeeeeeee_eeee_eeeee__eeeee__eee_eeeeeeeee_e_eeeeee_e_eeee_ee_eeeeeee_eeeeeeeee_e_eeeeeeeee_ee_eeeeee_ee_eee_ee_eeee_eeeeee_eeeee_eeee_eeeeeee_e_eeeeeeeee_eee_ee_ee_ee__eeeee_e_eeee_eeeee_ee__ee_e__eeeee_ee__e_eeeee_e_ee__e_e_ee_e_eeeeeeeee__ee_ee__eeeee_e_eeee_eeeee_ee__ee_e__eeeee_ee__e_eeeee_e_ee_eeeeee_e_e_eeeeeee_e__e_e_eeeee_eee_eeeeeeee_eeeeeeee_e_eeeeee_eeeeeeeeee_e_e_e__eeeeeee_e_e_eeeeeee_e__e_e_eeeee_eee_eeeeeeee_eeeeeeee_e_eeeeee__e__eeeeeee_e_e_e__e_eee_eee_ee_eeeeee_e_e_e_ee_ee_eeee__eeee__e__eee_eee__e_e_eeeeeee__e__eeeeeee_e_e_e__e_eee_eee_ee_eeeeee_e_e_e_ee_ee_eeee__eeee__e___eeeee_e_e_ee_e_eeeee_eeeeee_ee_e__ee_eee_eee_ee_ee___eeee_ee_eeeeee_ee_eee_eee_e__e__e_eeeee_e_e_ee_e_eeeee_eeeeee_ee_e__ee_eee_eee_ee_ee___eeee_ee_eee_ee__eeee_e__e_eeee_e_ee_ee__eee_e_eee_e_ee_ee_e_ee_eeeeee_ee_eeee_e___ee_eee_eee_e_eeee_ee_ee__eeee_e__e_eeee_e_ee_ee__eee_e_eee_e_ee_ee_e_ee_eeeeee_ee_eeee_e_e__ee_e_eeeeeee_e_e_e_e_e_eeee_e_eeeee_eee_eee_ee_ee__ee_ee_e_e__eeeeeeee_e__e__e_ee_e_eee_e__ee_e_eeeeeee_e_e_e_e_e_eeee_e_eeeee_eee_eee_ee_ee__ee_ee_e_e__eeee?@ABCDEFGHIJKLMNOPQRSTUVWXYZ\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root EntrydO)Current UserSummaryInformation([TPowerPoint Document(DocumentSummaryInformation8