Ongoing Reporting Collective (Day Two, 2018)
I attended a day recently looking into ongoing reporting. It included a presentation from Hilary Hollingsworth from ACER discussing her work with the Centre for Assessment Reform and Innovation. She discussed their focus on exploring new thinking relating to communicating growth, as well as possible alternatives to traditional reporting. ACERās areas of interest are the existing policies, existing electronic systems, existing practices, the alignment with teaching and learning, what works and what stakeholders actually need. The method involves a desk review, collection of artefacts and scoping commerical tools. The intent is to design a map of possibilities, rather than a single ideal reporting solution.
There are many challenges to sharing specific data in Google Sheets, some of these can be overcome using the QUERY formula.
I attended a day recently continuing the look into ongoing reporting. One of the focuses involved reflecting on various points pf data. Something that stood out was the willingness of teacher to share data. Whether it be with students, teachers or parents, for some providing access can still be a challenge.
I discussed this with a principal attending the day and one suggestion made is that it can be hard to share particular data, without sharing everyones data. This is especially the case when talking with parents or conferencing a student. An answer is using the QUERY formula.
With Google the chosen platform, a lot of teachers store their data in Google Sheets.
[googleapps domain=ādocsā dir=āspreadsheets/d/e/2PACX-1vRxo2utujutnQHS3qkbv5WlhpdAZHgNHiC5eDDMMU9nvRCuChM2_axflwsJl7Tqe1A6kOYyI0YYHZQ6/pubhtmlā query=āgid=0&single=true&widget=true&headers=falseā width=ā100%ā height=ā400ā³ /]
QUERY combines a whole lot of functionality into the one formula. As David Krevitt explains:
It is a language developed by Google, using the principles of Structured Query Language (SQL).
For example, you may wish to share the results of just one students:
[googleapps domain=ādocsā dir=āspreadsheets/d/e/2PACX-1vRxo2utujutnQHS3qkbv5WlhpdAZHgNHiC5eDDMMU9nvRCuChM2_axflwsJl7Tqe1A6kOYyI0YYHZQ6/pubhtmlā query=āgid=22451332&single=true&widget=true&headers=falseā width=ā100%ā height=ā150ā³ /]
To do this, you select the columns you want to copy from the MASTER tab and which value you wish to filter by:
=QUERY(MASTER!A:F, "SELECT C,D,E,F WHERE A = 'Donna'", -1)
If you wished to quickly create a tab for each student, Alice Keeler has created a script for generating tabs from a list. This personalised information can then be shared with students (see Jake Millerās explanantion). Another thing to consider is to protect formulas by adjusting permissions at a celular level, as well as prevent others from copying the file, therefore getting the information that way.
The other option is to create a dynamic selector involving either a name:
[googleapps domain=ādocsā dir=āspreadsheets/d/e/2PACX-1vRxo2utujutnQHS3qkbv5WlhpdAZHgNHiC5eDDMMU9nvRCuChM2_axflwsJl7Tqe1A6kOYyI0YYHZQ6/pubhtmlā query=āgid=1390882743&single=true&widget=true&headers=falseā width=ā100%ā height=ā150ā³ /]
Or even a whole form:
[googleapps domain=ādocsā dir=āspreadsheets/d/e/2PACX-1vRxo2utujutnQHS3qkbv5WlhpdAZHgNHiC5eDDMMU9nvRCuChM2_axflwsJl7Tqe1A6kOYyI0YYHZQ6/pubhtmlā query=āgid=1541349550&single=true&widget=true&headers=falseā width=ā100%ā height=ā300ā³ /]
These options might be used when working with colleagues or talking with parents. You are able to bring up just the information required. Depending on the data, you can also create dynamic charts. One other benefit to using the QUERY formula is that it allows you to quickly and easily reorder the representation of data. So lets say āFā is associated with literacy testing and you would like that at the start. Rather than writing
SELECT C,D,E,F
you would writeSELECT F,C,D,E
.This is only the tip of the iceberg of what the QUERY formula can do. For more information, see posts from Ben Collins and David Krevitt. Collins also ran two webinars, which you can go back and watch. One on the basics, while the other getting a bit more complicated.
One thing to note when using Google Sheets to store data is what sort of information you are collecting. In some districts and regions there are issues raised about storing āsensitive dataā in platforms like Google.
Reflecting on Class Dojo, Ben Williamson explains that āsensitiveā can be the consequence of collecting data:
This same concern needs to be considered in regards to Sheets, especially with the changes being brought about by GDPR.
As always, comments welcome. Webmentions too.
If you enjoy what you read here, feel free to sign up for my monthly newsletter to catch up on all things learning, edtech and storytelling.
Share this:
Email
Reddit
Twitter
Pocket
Tumblr
LinkedIn
Like this:
Like Loadingā¦
Sharing Data is Easy with QUERY by Aaron Davis is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Also on:
Year 6 student, Lynton, reflects on the problems with report cards and the power of technology to transform learning. This is interesting reading, especially in light of the work being done by ACER around growth and the new Gonski review, which is pushing for a focus on growth.
Also on:
My Month of May
This month I realised the limitations to using a priority matrix to organise my work. It was not capturing the different facets of my work, such as reporting, online portal, attendance and timetable. I am still organising my work around priorities, I have just taken to representing this in a spreadsheet, therefore allowing me to filter it in various ways. I still am not quite settled on this, but it will do for now
In regards to other aspects of work I was lucky enough to attend a presentation by Hilary Hollingsworth on ACERās work on reporting. I have also been helping some schools with the implementation of various administrative applications focusing on interviews and excursions. The more I do the more I realise how much of what is ātransformativeā is built upon a raft of invisible parts that build to make the complex systems, which we so easily take for granted.
On the family front, my girls have taken to belting out duets together, even in the middle of the shops. Although the youngest one cannot keep up with every word of every line, she gives it a go. In general, it is fascinating watching them learn together.
Personally, I have found myself spending more time bookmarking and collecting my thoughts, rather than crafting long forms. It was interesting to read Doug Belshaw reflect upon this with his own writing. I think that Ian OāByrne captures this best when he explains the interrelated nature of the different spaces.
In regards to my writing, here was my month in posts:
Finding the Tools to Sing ā A Reflection on Big B Blogging: I started writing this post a few months ago in response to Tom Critchlowās post, but did not get around to finishing it, subsequently my initial notes have lay waiting. I was reminded of it by recent posts from Jim Groom and Alan Levine reflecting on the purpose of blogging. Here then is my contribution to the conversation.
Sharing Data is Easy with QUERY: There are many challenges to sharing specific data in Google Sheets, some of these can be overcome using the QUERY formula.
Here then are some of the thoughts and ideas that have also left me thinking:
Learning and Teaching
21 simple design elements that will make any School Assessment Task sheet accessible: Haley Tancredi, Jill Willis, Kelli McGraw and Linda Graham reflect on the assessment task sheet so common in the secondary classroom. Responding to the challenge of accessibility, they collect together a number of elements to support all students. This list is organised around visuals, clarity and directions.
Civix Releases New Online Media Literacy Videos: Mike Caulfield shares a series of videos summarising his work on Web Literacy for Student Fact-Checkers. Although it only touches on the basics, it still provides a useful introduction to the āFour Movesā approach. Caulfield has also started a project associated with local newspapers that is worth checking out.
When words wonāt suffice: behavior as communication: Benjamin Doxtdator unpacks behaviour in the classroom. He touches on knowing your child, student choices and systemic inequalities. This is a useful post to read and critically reflect upon various practices and pedagogies. I think that it all starts with the language that we choose. Chris Friend also considers the influence of language in regards to learning management systems and assessment. In regards to behaviour, Riss Leung compares dog training with her classroom experiences.
Learning for learningās sake: Austin Kleon responds to the challenge associated with ālearning for learningās sakeā. He suggests that we need to invest in hobbies and curiosity, just as much as we focus on āreturn on investmentā. This reminds me of Amy Burvallās point that āin order to connect dots, one must first have the dotsā. Thinking about luck, Janice Kaplan discusses the importance of engaging with curiosity. Diane Kashen suggests we need more messy play.
Forget the checkout: what about the plastic clogging supermarket aisles?: Nicola Heath reports on the current plastic crisis in Australia. Although every state has agreed to ban single use bags, the real problem that needs to be addressed is in the aisles and aisles of pre-packaged food. Although the impact of plastics on our ocean has been well reported, it seems that there is a significant impact on our fresh water lakes too. Studies have found microplastics in drinking water, beer and honey. I wonder if the solution starts with school and education?
The Brick Wall: When I taught robotics I would show my students a video involving the use of a simple Lego kit in a science laboratory as a point of inspiration. The Brick Wall takes these possibilities to a whole new level, providing a collection of videos useful for thinking about what is possible in regards to programming, Lego and robotics. Some other series and collections that I have stumbled upon lately include the New York Timesā podcast Caliphate, which explores the world of ISIS, as well as Amy Burvallās creativity vlogs as a part of the #LDvid30 project.
[youtube https://www.youtube.com/watch?v=J5lpZWDfjEM?rel=0&w=560&h=315%5D
Edtech
Better visions of ourselves: Human futures, user data, & The Selfish Ledger: Ian OāByrne reflects on the internal video produced by Google Project X focusing on speculative design the notion of a ledger that does not actually belong to the user, but managed by some grand AI. Although this was designed as a case of āwhat ifā, it is a reminder of what could happen. It therefore provides a useful provocation, especially in light of Cambridge Analytica and GDPR. OāByrne suggests that this is an opportunity to take ownership of our ledger, something in part captured by the #IndieWeb movement. Not sure what this means for our digitally proficient three year olds. Douglas Rushkoff makes the case for including less on the ledger, not more.
How an Algorithmic World Can Be Undermined: danah boyd continues her investigation of algorithms and the way in which our data is being manipulated. She did this at re:publica 2018. This is very much a wicked problem with no clear answer. The Data & Society Research Institute have also published a primer on the topic. I wonder if it starts by being aware of the systemic nature of it all? Alternatively, Jamie Williams and Lena Gunn provide five questions to consider when using algorithms. Om Malik highlights the focus of algorithms focus on most over best. Jim Groom also presented at re:publica 2018 on Domain of Oneās Own and Edupunk.
Truth in an age of truthiness: when bot-fueled PsyOps meet internet spam: Kris Shaffer continues his work in regards to bots, unpacking the way in which our attention is hijacked through attempts to influence and advertise. It is important to appreciate the mechanics behind these things for they are the same mechanics that those on social media engage with each and every day. One of the points that Shaffer (and Mike Caulfield) make is that whether something is true or not, continual viewing will make such ideas more familiar and strangely closer to the truth.
Email Is Dangerous: Quinn Norton takes a dive into the mechanics of email. She continues to remind us how everything is broken, Norton gives a history of email and many of its inherent flaws. This comes on the back of the latest discovery of bugs associated with supposed encrypted email.
Programming with Scratch ā An educator guide: Anthony Speranza provides an introduction to Scratch. An often underrated application, Scratch provides an insight into some of the ways that the web works, particularly in regards to āblocksā. Sometimes it feels as if you are not really coding unless you are working with some form of language. The problem is that this is not how the world works. More often than not it is about building on the ideas (and snippets) of others. Look at WordPressā move to Gutenberg. In addition to this, we interact with āblocksā each and everyday in the applications and sites that we use. One only needs to use something like Mozillaās X-Ray Goggles to start realising that inherent complexity within the web. For more insight into Scratch, listen to Gary Stager on the Modern Learners podcast.
The platform patrons: How Facebook and Google became two of the biggest funders of journalism in the world: Mathew Ingram reports on the increasing influence of platforms on the news industry. Google has been really pushing into journalism lately, with the further investment of News Lab and the Digital News Initiative, as well as the ability to subscribe using your Google account. This in part seems to be in response to Facebookās problems. It is interesting considering this alongside discussions of the history of news and the long association with advertising.
Storytelling and Reflection
What We Talk About When We Talk About Digital Capabilities: In a keynote at the UCISA Digital Capabilities event at Warwick University, Donna Lanclos unpacks the effect of analytics and the problems of profiling when trying to identify improvements. A skills approach is an issue when decisions get made on your behalf based on the results of a preconceived checklist. Lanclos suggests that we need to go beyond the inherent judgments of contained within metaphors and deficit models, and instead start with context.
Citizen of Apple, State of Lego: Julian Stodd explores the evolving idea of ācitizenshipā. Whereas it was defined by geography and culture in the past, Stodd wonders if in the future it will be subscription based. Rather than depending on the state and taxes to provide societies infrastructures, we now rely on the various multi-national platforms, such as Microsoft, Amazon, Netflix, Facebook and Google. This reminds me of the conversation that was had recently around being a citizen of the #IndieWeb. If states lose their sway, I wonder if this opens up other alternatives? This is something Aral Balkan touches upon. I wonder what this means for rituals or habits.
School is One Spoke in the Wheel of Learning & Why This is a Critical Insight for the Future of Education: Bernard Bull reflects on what people need to stay current in a job, shift to a similar job, develop skills that transfer to work environments, move into leadership within oneās field, or make a full career shift. To support this, he provides a series of questions to consider. I wonder where the second wave of MOOCs sits within all of this?
The risks of treating āacademic innovationā as a discipline: Rolin Moe argues that we need to recognise the often negative history associated with āinnovationā in the way that we use it. If we donāt do this we risk the word being simply an emotive tool. This touches upon Audrey Watters message to respect history, rather than live in the ever present that so many try to perpetuate.
12 tips for great speaking: Steve Wheeler provides some useful tips and reflections on the art of the keynote. They include use humour, minimal text, engage with your audience, donāt speak too quickly, repeat key points and only stick to three of them. In part, this reminds me of Presentation Zen and the idea of a minimalist slidedeck, while Emma Cottier also wrote an interesting post share a range of tips and tricks associated with Google Slides. Although not necessarily about ākeynotesā, Andrew Denton recently shared some tips for a better conversation that I think relate to this conversation, including be respectful and empathise with the interviewee (or audience).
Burden of Proof: Malcolm Gladwell wonders how much āproofā we need in order to do something about CTE, a neurodegenerative disease found in people who have had multiple head injuries. Gladwellās focuses on Owen Thomas and his suicide in 2010. In regards to the question of breaking point, there was no reference of Aaron Hernandez, whose case involves murder and suicide. I wonder how long until this becomes a case in AFL?
Gonski review reveals another grand plan to overhaul education: but do we really need it?: Glenn Savage has written, recorded and been interviewed about the new Review to Achieve Educational Excellence in Australian Schools. He raises a number of questions, including whether the new report addresses the question of inequality, is āpersonalised teachingā worth the money and investment, is the educational sector exhausted by continual reform agendas and do the recommendations really address what is happening in the classroom? In other spaces, both Andrea Stringer and Deborah Netolicky have highlighted the potential in providing more time for teachers to collaborate. Greg Miller argues that we need to wrestle with how to assess the capabilities, rather than continue to work where the next silver bullet for literacy and numeracy is. Peter Hutton shares concerns about testing the capabilities. Gabrielle Stroud sees it as the industrial model of accountability rebadged, where a teacherās relationship with their students is trumped by a test. Netolicky also raises concern about the lack of trust for teachers. Darcy Moore describes the whole affair as a never-ending rebuilding of The Windmill. Ann Caro rues the missed opportunity associated with equitable funding of education in Australia with this clear change in direction.
tās time to be honest with parents about NAPLAN: your childās report is misleading, hereās how: It was that time of year again, when the whole nation stops for NAPLAN. There has been a range of posts shared. One that stood out was from Nicole Mockler She summarises Margaret Wuās work around the limitations to NAPLAN in regards to statistical testing. Moving forward, Mockler suggests that NAPLAN should become a sample based test (like PISA) and is better suited as a tool for system wide analysis. To me, there is a strange balance, for on the one hand many agree that NAPLAN is flawed, yet again and again we return to it as a source of ātruthā.
FOCUS ON ā¦ GDPR
The General Data Protection Regulation (GDPR) (EU) is a regulation in EU law on data protection and privacy for all individuals within the European Union (EU) and the European Economic Area (EEA). Adopted on 14 April 2016, it became enforceable on 25 May 2018. Here then is a collection of posts exploring what it all means. Although not exhaustive, it provides a starting point:
What is the GDPR Privacy Law and Why Should You Care?: Harry Guinness summarises the eight rules associated with GDPR and what they mean for those outside of the EU.
LA Times among US-based news sites blocking EU users due to GDPR: Alex Hern on the threat that GDPR could āBalkiniseā the web, with a range of sites closing off access to EU visitors.
Facebook and Google targeted as first GDPR complaints filed: Alex Hern reports on Noybās test of the new regulations. The case being tested is whether the processing of data for targeted advertising can be argued to be necessary for the fulfilment of a contract to provide services such as social networking or instant messaging.
The Ultimate Guide to WordPress and GDPR Compliance ā Everything You Need to Know ā The team at WPBeginner provide a guide for making WordPress compliant, including plugins that store or process data like contact forms, analytics, email marketing, online store and membership sites.
No oneās ready for GDPR: Sarah Jeong explains why nobody is actually ready. Part of the problem is how companies are set up, and part of it is that āpersonal informationā is a wishy-washy category.
Can we PLEASE talk about privacy, not GDPR, now?: Sebastian Gregor explains that GDPR is no deadline, it is a process. Now that it is here, lets engage in ever broadening debates on how to treat the personal data of human beings
Privacy: David Shanske reflects on privacy, the IndieWeb and webmentions. He also added an extended response to a WordPress forum on GDPR.
13 things to know about the GDPR: M.J. Kelly breaks down the rights associated with GDPR with a focus on what this all means for Mozilla.
Good enough, the EUās data protection regulation and what CryptoKitties can tell us about the future of art:Angela Daly discusses what GDPR might mean for Australia with Antony Funnell on the Future Tense podcast.
Doctor, I think I have GDPR fatigue:Jordan Erica Webber, Alex Hern and Dr Rachel Birch explore GDPR and its consequences for the health sector.
GDPR and the marketerās dilemma: Seth Godin argues that GDPR will create an actual market, where getting permission to send messages to a user requires that marketers make a compelling proposition.
GDPR will pop the adtech bubble: Doc Searls discusses what he sees as the eminent demise of āadtechā and what will be left afterwards.
Comments on ClassDojo controversy: Ben Williamson addresses a number of questions leveled at Class Dojo, especially in light of the current concern around data. One of the points that he makes that really stuck out was the notion of āsensitive dataā. Often this is defined by privacy, however as Williamson explains the collection of data over time actually has the potential to turn the seemingly arbitrary into sensitive data.
Notes from Understanding the General Data Protection Regulation course: Doug Belshaw shares a series of reflections based on his participation in an online course designed to unpack GDPR.
There Will be Blood ā GDPR and EdTech: Eylan Ezekiel discusses GDPR, making the comparison between data and oil.
I am a data factory (and so are you): Nicholas Carr reflects on the metaphors that we use and demonstrates some of the flaws, particularly when they are used against us inadvertently. Although not explicitly about GDPR, it has ramifications for the way we talk about it.
READ WRITE RESPOND #029
So that is May for me, how about you? As always, interested to hear.
Also, feel free to forward this on to others if you found anything of interest or maybe you want to subscribe? Otherwise, for those concerned about privacy and sharing thier email address, archives can be found here.
Cover image via JustLego101.
Being in a role that supports the implementation of biannual reporting, it is an intriguing question. What I find the most interesting is how little schools are actually mandated to do. Even though they need to provided judgements (for some things) twice a year and feedback to parents twice a year (which can be in person), it sometimes feels as if we have bought into some myth that we must provide written reports and that parents want it. Even worse, everyone has a belief as to how they must look.
It has been good to see some of the schools that I have spoken to really strip back some elements, especially in regards to specialists. It always amazes me the amount of time spent by a teacher who would potentially see the children for an hour a week.
It will be interesting to see if Gonski 2.0 brings any changes, but I guess that is your point about solutions being pushed on schools. I also look forward to reading ACERās research into the area and the general guidelines that they put forward.
For the past few years I have written both a December newsletter, as well as a summary of the whole year (see 2016 and 2017). As Decemeberās highlights are included within the summary, I decided to just do one.
In regards to reporting, @ACEReduau is doing some work in this area that might be worth checking out https://collect.readwriterespond.com/ongoing-reporting-collective-day-two-2018/
Thanks for sharing this @mrkmdvs. We have a couple of articles on our site on different aspects of ACERās research into reporting that might interest you too: rd.acer.org/article/teacheā¦
This Article was mentioned on brid-gy.appspot.com
This Article was mentioned on brid-gy.appspot.com