Reflection: Workshop - Spreadsheet (4th Run)

15 & 22 February @ Juying Primary

Hearing from the HODs/IT
In the 1st session, got the chance to speak to 2 HOD/IT and heard from them their views:

• Both expressed that results are at stake and therefore is still the priority. Both mentioned about 'time' as a key concern.

• One of the HODs mentioned about looking into arranging training for pupils to equip them with the skills. However, was very concern over the fact that teachers had to tap on curriculum time to familiarise pupils with operational skills such as logging into the system, saving the files. She indicated that this familiarisation process will eat into lots of curriculum time and expressed that teachers were reluctant to do this.

• We acknowledged that it will definitely take up some time for pupils to become familar with the basic operational skills. However, it should be deem as a form of investment - to learn anything - be it skill or knowledge, there exists a learning curve where one will take some time to get familar with the skill or 'digest' the knowledge before we can apply the skill/knowledge with ease. Yes, it takes a while to 'habitualise' a skill... but many a time, adults undermine that pupils grasp much faster than us... It's an investment, if nobody wishes to invest, it will never take place. If the P1 teachers do not want to overcome the hurdle, this is passed on to the P2 teachers... so on and so forth...

• On the other hand, look at the positive side of things - are the pupils already demonstrating the skills? Are the teachers already teaching pupils the skills? Well, if the school has already introduced eLearning into the P1 classes, aren't the pupils already demonstrating PK1 skills, that's the fundamentals of all? Pupils already able to move the mouse, press the button on the keyboard... aren't they already navigating in the GUI (graphical user interface)? I guess, sometimes it's a matter a bridging the what's written in the standards and what's already happening.

• Indeed, one analogy will be the teachers: When teachers first started to learn using the computer, they have to learn to login and get familiar with the windows environment... What happens after that? It is a painless process to do all these now because it has become part and parcel of their daily routines... do they still have to spend that amount of time to look for the keys to press and the buttons to click at? Indeed, they are now using the tools (the applications) to aid their work... similarly, we want pupils be able to make use of the tools to learn, too... I think, it is a matter of recognising the need and the willingness to 'sacrifice'... of course, some teachers will ask: "Why me?"... On the other hand, if it's for the good and benefit to the pupils, then "Why not?" and "Why wait?"... Let's step back a little and think: What's our role as teachers? Should we compromise or delay pupils' learning experience because of our fear or incompetence?

• Another HOD/IT recognised the fact that Baseline is there for the pupils and agreed with its rationale: to better prepare pupils for the future... He is more concern how to implement that in the school. Currently, the teachers are still matching the resources to the SOW. Have highlighted to him the resources in the baseline website and how the curriculum integration map comes in helpful in the planning.
• In terms of approach, he indicated preference in having school-wide approach, in the sense that all teachers will conduct identified lessons - that is easier to account for implementation. He is less in favour to have the IT champions to spearhead, fearing that it ended up the rest of the teachers will only sit and watch, resulting unevenless again. Have suggested getting the IT champions to handhold or provide stronger support to those who need. That also includes inviting others to sit in the lesson to observe and pick up useful pointers before they implement the lessons.

Some observations to the 1st session

• The participants were enthusiastic to learn the skills, especially the macros and buttons. Most of the participants seem familar with spreadsheet, as they were able to follow the steps in the handouts, also from the way they create the picture graphs.
• However, it seems like many are not aware that they have to press enter after keying in value into the cell... otherwise the system is not able to capture the value.
• On the other hand, skills seem to have taken the centre-stage - as most instances seem that through the activity, they identify the skills they are going to learn. The value of the activity in enhancing the learning experience was not clearly brought out >> Something to refocus in the next session.
• In particular, one participant seemed to be rather impatient - in 2 encounters (i) the value entered was converted to % (eg. 7 became 0.07) - due to system setting (ii) the system could not check the input value because she did not press enter after keying in the number.

Some technical problems encountered...

• The numbers have been set to "2 decimal places" - Tools > Options > Edit.
• The shared spreadsheet refused to save. To overcome this, ask all participants to 'close' spreadsheet. Another means - to copy and rename the shared spreadsheet.
• When coming to "If" statement, do not use "TRUE" and "FASLE" for the logic test as these are default terms used in some operations, like "0" and "1".

~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2nd session...

about Technical Skills...

• Giving the "Bonus segment": I guess today's session has certainly answered to many participants' curiosity - the use of macros and buttons... they were attentive and quiet during the demonstration... but also, obvious that quite a number could not follow... (see another point to address to this). In particular, with this 'bonus segment', I think it has saved one participant from writing unsatisfying feedback... ok, I sound sarcastic?
• Managing theDemand: The participant was insistent that technical skills have to be taught otherwise they would not be able to accomplish what's needed - being able to design the lessons - since they could not create the resources!!! How do we manage such as situation... I think, we were tested at that point of time - how to respond and cushion the demand (reasonable, yet unreasonable at the wrong time! wrong platform). How to manage the situation? First thing crossed my mind, do not be defensive, and cannot be seen being defensive otherwise, other participants will 'sing' along and it's going to make the rest of the workshop very difficult to move! I took (what I thought) the most appropriate move: to acknowledge the participants' concern and agree on what's true in the actual situation. They want their need to be heard - it's obvious... and we agree to bring the requests back for consideration....
• Reiterating our Ground: It is also important and necessary for us to reiterate our stand and the objective of the workshop. Also, getting them to see the bigger picture - why certain things are carried out in such a way... However, we have to be cautious not to over-promise! such as giving them uncertain hope that they would expect to see a workshop where technical skills take centre-stage... Be mindful of that!
• Aligning and Communicating Expectations: This brings us to another point... has the intended objectives of the workshop been clearly communicated? or it was communicated but has been filtered along the way as it travels through the air before ending the ears? Or along the way... was there signals that sent out to emphasize the importance of acquiring certain technical skills??? One point that I'm quite sure... there isn't enough emphasis to bring across the intend of the workshop... more could be done to play out the "skill" emphasis...
• Anchoring and driving what's to be 'heard': Moreover, terms like "skills" or related terms are too frequently mentioned in the workshop... would that have shaped the thinking that "Hey, you are talking so much about skills, showing us these very interesting features - so many times and bringing out the advantages of these features, yet you are not showing us how to do? What's the point?" I am quite sure it has! The outburst, I believe, was triggered when participants were asked to suggest how to use ICT in assessing pupils' understanding. No! No! No! It intensifies their concern! At that point of time, what flashed across: It's going to overkill and backfire! Yes, indeed, it happened... led to that outburst.
• What the slide intends to communicate: On the other hand, it has never crossed my mind (although having run the same workshop twice, to ask participants to think how ICT can be used to support the different forms of assessment... it'll create the 'overwhelmed' effect... yes, it's a good to have, but more importantly, be focus! This indeed brings out another very important point: Think through what we intend to say, that's not enough... but to think how the audience receive it - how they perceive and react... that's important!
• Managing this concern: I've never disagree that it is necessary to equip participants with enough skills so that they can 'fish' - On the other hand, given the amount of time and the agenda we want to drive at, how to strike a balance? The 'spreadsheet' competency of the participants varies... when we cater to one group, we lost the other... when too much given, will that scare the novice? From the participants (in the past few runs), it's the frequent users expect more on the technical skills, while the less regular user will treat that as an exposure (as they can't possibly cope with so many new skills!).
• To cater to the more spreadsheet-savvy, suggest that supplementary handouts made available to particpiants at the end of the 1st session so that they could explore on their own... if they are keen, they will try and ask in the subsequent session... if they have little interest, well, they won't bother to ask! This would have probably reduce the 30 min 'bonus segment' to about 5-10 min?
• To cater to the less spreadsheet-savvy, I feel that, we have somehow missed out the fact that how the use the simple features of spreadsheet in good ways in learning activities - those does not require macros or visual basic.
• Striking the balance: There are things that can be done without using the control toolbox, for example, creating a textbox, but one participant wanted to use the text feature in the contol toolbox to do it... well, what difference does that make apart from telling me "I want to use that because it looks better." Where is the value-add? I wonder... are we over promoting the use of macros and buttons because we are comfortable in using it? How many of them will use the skills when they go back to schools? What's exactly practical to them? On one hand, we would very much like to 'give', yes, the kind of satisfaction we get when we realised that the participants are delighted with the fact their immediate request are met. I think, we may have to think of "What's next?" for the participants, perhaps...

the baseline skills...

This is a session where we talk about baseline and we wanted to clarify their doubts and this is a very important group of people as they are the ones who help to 'explain' (at the front line and first cut) what's expected of the standards? Well... without going through with them the standards apart from telling them what the codes mean... are they able to do so? Thought this would be good time to 'pre-clarify' some jargons and big terms like, what do we mean by "multimedia"? I thought, more can be done here...

the Sharing Session by Participants...

On the whole - can't quite see the baseline skills (PS1 & PS2) being 'brought' out from the learning activities and these have not been brought upfront, what's expected to see from the learning activity or task they are to come up with. This could be improved when communicating the task to the participants - their "job" (a word to avoid, I think) is to come up with a learning activity or task using spreadsheet (so? anything thing about spreadsheet?). At this point, the skills PS1 & PS2 should be emphasize and possibly elaborate - with examples. That will help to guide the participants' thinking and planning better. For instance,

• P1 Shapes - indeed, the participants misunderstood what to do: instead, a fair bit of time was spent in modifying/extending the activity in the powerpoint slides. Although one suggested using spreadsheet to teach or get pupils to create patterns - well, that was not materialise... What the participants simply did, when told that the task suppose to be in spreadsheet - they copied all the objects to the spreadsheet instead so that pupils can 'manipulate' the objects in spreadsheet (because the workshop requires them to do so) rather than using the powerpoint, which they agree it's a better tool! So, have they seen the 'value' of using spreadsheet. In my opinion, it's a definite NO!
• P5 Area of Triangles -