Adventures in Technology Enhanced Learning @ UoP

Category: General (Page 1 of 4)

Introduction for Tel Tales – Beth Hallissey

Hi, I’m Beth. I have just started in the TEL Team within DCQE. I’m based at Mercantile House where I already have a reputation for wearing flashy shoes from my extensive collection! I work Wednesdays, Thursdays and Fridays for TEL, and on Mondays and Tuesdays, I work next door at the Dental Academy next door as a Teaching Fellow. I moved to Portsmouth recently so I’m still getting my bearings and exploring the area. So if anyone has any recommendations (particularly food), please let me know!

My career had a bumpy start; I went to Drama School aiming for a degree in Stage Management and dropped out after 2 years. I then worked at a school as a Design and Technology Technician before going for an apprenticeship in Dental Nursing. Dentistry isn’t a field I ever thought about; even in the interview when they asked what experience I had, I told them I had “Dentist Barbie” as a child. I now owe my career to Dentist Barbie because I got the job, and keep a “mint in box” version of her at home.

After a couple of years in practice, I got a job at Plymouth University doing clinical demonstrations and a bit of teaching in their Dental Simulation sites. After nearly 8 years, I had become Senior Technician for Dentistry, I had an honorary contract with the National Examining Board for Dental Nurses as one of their OSCE examiners, and would support the British Antarctic Survey, training doctors in Dentistry. I’m very passionate about EDI; I was Co-Chair of their LGBT+ Staff Network and a regular guest speaker on their Springboard programme.

As you can imagine, I have a big interest in simulation technology. I have created some training resources using 3D Printing including my own “Dexterity Block” for students to develop practical skills, which has been successfully used in education over the last few years. My work has been featured on the front cover of Dental Update, and I have helped design programs for Haptic Simulators that have been used around the world. I’m really looking forward to playing with all the new tech Portsmouth has to offer!

I feel my role in TEL will complement my teaching role over at the Dental Academy really well. I’m also looking to do the HEA Fellowship in the future. I’m a big fan of Moodle and have used it previously. I think it’s utilised really well here by being integrated with so many apps, so I’m keen to be involved with it. I’m interested in Gamification and its impact on student progression. I think technology is so important in education, even more so now in a post-pandemic world. Students are incredibly lucky to have a range of accessible resources to suit various learning styles and keep them engaged. Perhaps I would have done better at school if I’d had access to what they have…

Image of Beth holding her pet African Pygmy Hedgehog named Chorge.Outside work, I dedicate my time to being a massive nerd. I spend probably far too much time gaming and building Lego than the average adult should, but I have no plans to grow up just yet! (I stillneed to get Lego Optimus Prime). I love music but it’s been many years since I picked up a guitar. Instead, I have been a local radio DJ, creating music quizzes and playing everything from Abba to Zappa. Most importantly, I have a pet African Pygmy Hedgehog named Chorge!

Introduction for Tel Tales – Mike Taylor

Hi, I’m Mike Taylor and since mid-September, I’ve been a Senior Learning Technologist (Assessment) with the TEL team on floor 3 of Mercantile House. In 2001 I was on floor 7 of the same building studying Maths and Astronomy.

After graduating and stepping out of Mercantile house for what I presumed was the final time, I began my first job in education as a library assistant at South Downs College. There, I was tasked with developing a website to promote an annual equality and diversity festival. I taught myself basic web design, which gave me my first insight into the power of using this kind of technology in education. Although most of the apps I relied upon are now defunct (Adobe Imageready, Flash and Fireworks… remember them?), it made me curious as to how this can be used to enhance learning. In hindsight, it also taught me the important lesson that the skills of an online developer must remain current!

I spent the next 11 years at South Downs teaching A level Maths and BTEC/HND Music Performance, along with a multitude of other roles (Course Manager; Lead Internal Verifier; Trainee Teaching Mentor; plus many more), all the time gathering skills and experience, and spotting opportunities to improve college life via the use of technology.

The move toward a career in online development came six years ago when I joined the Online Course Developer Team at St George’s, supporting the online learning of the Schools of Education and Criminal Justice. In 10 short months, the team taught me an invaluable amount and provided me with excellent opportunities such as obtaining my HEA Fellowship and giving me the freedom to learn and experiment with programming tools such as JavaScript and jQuery.

Five years in the two Schools of Engineering provided a more direct experience with HE assessment. This, along with everything we have learnt from our rapid response to the pandemic, has reinforced my confidence in the value of weaving tech into education. I took a deep dive into the world of automating workloads with Google Apps Script and built ethics review systems centrally and for the faculty. I generated an enormous question bank of auto-marking Maths questions for the Mathematical Principles modules, greatly easing the marking burden of the assessment team.

Now, 21 years later, I’ve returned to Mercantile house. A lot has changed. It looks a lot nicer, and I’m 99% sure no one uses Netscape anymore. But my trip down 4 flights of stairs has taught me that we are in a great position to enhance the student experience, improve our colleagues’ work lives, and innovate across the board.

I now have the incredibly difficult job of filling Mike Wilson’s shoes, a tough act to follow. Fortunately for all of us, he’s not going too far so the transition should be a smooth one, and I’ll be assisting him in the delivery of the trial of the end-to-end assessment platform WiseFlow. 

Computer images of Mike standing in from of his campervan playing a guitarIn my personal life, I love playing the guitar, ukulele and singing (there’s nothing as satisfying as a bunch of disparate musicians coming together to make a melodious racket) and camping with the family (and dog!) in our DIY converted campervan (see attached image generated by DALL-E!).

I look forward to working with you all over the next year. If you have any questions, drop me an email at mike.taylor@port.ac.uk.

Welcome to the team, Mike!

Introduction for Tel Tales – Joanna Clarke

Hi everyone 😁

I’m Joanna Clarke and I started in the Technology Enhanced Learning team as an eLearn Support Analyst this summer. I did my MA in Applied Linguistics and TESOL here a few years ago, and my favourite module was on the use of technology and corpora in language teaching. Now I’m thrilled to be joining the team here, learning even more about technology and pedagogy, and applying what I already know.

I’ve taught EFL (English as a Foreign Language) and trained teachers for over 20 years (as well as having some pretty varied earlier work experience including a data assistant for clinical trials, a receptionist in France, and a thankfully short stint in a chicken factory). 

Back in 2000, photocopiers and OHPs were the extents of the technology available in my college – and laminators if we were lucky, but you had to fight for those! I loved experimenting with new tools and finding new ways to engage students with lesson content. This led me to take on an ILT training role at Chichester College to find ways of supporting my colleagues in the use of technology. Initially, I was focused on how Moodle and other online resources can support individual study. As technology has evolved, it’s been fascinating to see the emergence of a wealth of resources for highly motivating competitive and cooperative activities, as well as new ways to help students express themselves and become more comfortable with sharing their ideas.

The pandemic took me to a new role at Chatterbox, a social enterprise that provides employment opportunities for marginalised people such as refugees in corporate language teaching. I was responsible for online content development and it was here that I really started to be interested in the data available for measuring student engagement and progress. In a classroom, I could always adjust my lesson content in response to students’ needs and reactions, but it’s very different from online material. At Chatterbox, I loved exploring the data available and then conducting user testing to investigate my hypotheses about student experiences. Working within the TEL team at Portsmouth will hopefully give me plenty more opportunities to use user data to inform module development.

What else can I say? You can probably predict from my work experience that I love languages – I’ve variously had passions for French, German, Greek, Czech, Japanese, and Spanish, although French is the only one that really stuck. My love of languages has also extended to programming languages. If anyone else out there is interested in learning these, I’d thoroughly recommend W3schools as an amazing resource for things like HTML, CSS and Javascript.

In my free time, I love going to the beach – particularly snorkelling around looking at the weird and wonderful underwater world.  I’m lucky to have joined a very musical department. I used to play the piano and accordion, and the conversations around me now have given me a much-needed push to start playing again (and to take up the guitar – just have to toughen up my fingers first 😬). 

Anyway, that’s plenty for a first introduction. If you want some company diving into the data on your Moodle site, please get in touch – we can go snorkelling for stats together 🤿😊.

Joanna is based in Mercantile House within the TEL team.

Welcome to the team, Joanna!

 

Introduction for Tel Tales

Hi, I’m Chris Wood and I am one of the new eLearning Support Analysts for the Department of Curriculum and Quality Enhancement (DCQE).

In my previous role, I taught Music Technology and Media Studies at Portsmouth College for nearly 12 years. I also lead the College’s 1:1 “creative and curious” iPad project, resulting in Portsmouth College becoming one of only two colleges in the UK to be recognised as an Apple Distinguished School. In 2019, I became an Apple Distinguished Educator – a recognition of how I continued to use Apple technology to transform teaching and learning. This has taken me all over the world and I have met so many amazing friends and colleagues because of this. Over the past few years, I’ve had many incredible opportunities to present my work at worldwide events such as ISTE, Apple Distinguished Schools events, Mobile Learning Conference, JISC, and BETT as well as local education technology events within Portsmouth. 

I have thrived on creating a culture of teaching, learning and innovation. A place where staff and students are risk-takers, sharers of good practice and digital advocates. I believe that providing a safe environment for teachers to share, explore and be brave can lead to incredible moments of learning. Throw Away Your WhiteboardLast year, I released my first book “Throw away your whiteboard”, which documented my journey of switching from a traditional whiteboard to using an iPad, Keynote and an Apple Pencil. This revolutionised the way I taught and more importantly, the way my students learnt.

The book has achieved great success worldwide and has been featured in many online book talks/events. You can download it from Apple Books for free.

I’m hoping that I will be able to bring this experience, passion and innovation into my new role at the University of Portsmouth. 

I believe we are in an exciting time for education, particularly as we emerge from the pandemic. The pandemic has taught us that we can transform education for all and develop new ways of teaching and learning. The modern classroom should no longer consist of rows of desks: technology allows students to design their own learning path and allows educators to push the boundaries of their work by extending the classroom beyond the physical institution. Having supported many teachers throughout the pandemic I strongly believe in the importance of equipping students and staff with the correct tools, resources and training to deliver effective lessons. We still have a lot to learn about the impact the pandemic has had on learning, but I am sure that a ‘one-size-fits-all’ approach will not work. We must adopt a ‘no-one left behind’ approach and offer students differentiated paths to the same outcomes as we move forward into this new normal. 

Outside of work I have played the guitar for over 22 years and also become a successful music producer. I sit on the governing board at Leesland School in Gosport, which is incredibly rewarding and allows me to give back to these amazing schools that I attended as a child. I enjoy days out with my family; taking our whippet “Twiggy” for a walk (although, not when it’s raining as she refuses to go out without a coat!); paddleboarding; snooker; DIY; and getting up at the crack of dawn to chase sunrises.

View of the Solent

If you’d like to connect and share ideas around technology-enhanced learning, I’m always open to talk!  Feel free to connect with me and follow my adventures on Twitter @ChrisWoodTeach 

Chris is based in Mercantile House within the TEL team.

Welcome to the team, Chris!

TEL in 2020

Well … 2020 has been quite a year. The most extraordinary 12 months any of us have experienced. Although 2020 has had its stresses (to put it mildly) I’m proud at how the TEL team has helped the University maintain its mission. Our existing students were able to progress and new students have been able to start their University career. Without technology, that would have been impossible.   

Like many people, we understood the disruptive potential of Covid-19 in late February. By early March we started thinking about the support we could offer if the University had to deliver teaching remotely. We thus had the elearning Tools website ready to publish when the VC sent his email about home working.  

That move to home working affected the TEL team less than many other teams in the University – partly because many of us already had some experience of home working and partly because we work with technology on a daily basis. All we need to do the basics of our job is a fast, stable internet connection. (One team member, stuck abroad when airlines began to remove scheduled flights, spent several days working from Australia. For a while we truly were providing around-the-clock service!) It helped the team enormously that we used SLACK: the platform held a record of our thinking and enabled people to catch up on discussions they might otherwise have missed.  

That’s not to say working at home (or living at work?) was without challenges – especially for those of us who were homeschooling children or who had other caring responsibilities. One lesson I think we learned far too late was this: when we’re working at home we don’t need to be available all the time. Too many of us jumped to respond to a SLACK message immediately or to answer an email the moment it reached our inbox. It’s nice to know our team members are conscientious – but that “always-there” mentality is ultimately self-defeating. And although SLACK enabled us to work efficiently while we were remote, it’s undeniable that face-to-face communication is quicker and less prone to misunderstanding than text-based communication. All that raises an interesting question: when we get back to some sort of normality, will we all rush back into the office? Not many people miss their commute, but some do miss the office environment – so will we work more flexibly, with one or two days spent in the office and the rest working at home? Or will some of us become full-time home-workers?  

Returning from speculation on future events to events that happened back in the spring of 2020: the University started to develop its “Blended and Connected” approach to the new academic year. To support that initiative, the TEL team created the website Preparing for teaching in a blended learning context, with content coming from across the whole of DCQE. We also worked closely with our colleagues in Academic Development to put on the TEL Tales Blended Learning Festival (and more recently a Blended Learning Mini-Fest).

The “Blended and Connected” approach allowed us to address a long-standing complaint from students. In response to our yearly Digital Experience Tracker, students regularly criticised the lack of consistency across their Moodle modules. We now had the chance to develop and implement a templated approach to Moodle. The TEL team also improved the Moodle theme, in light of co-creation work with a group of University computing students studying UX/UI design.

Of course, all those other tasks involved in running a large Moodle installation did not go away because of the pandemic. Integrations with other systems (more of which below) had to be managed, the upgrade to Moodle version 3.9 had to take place, and all of this took place as the University moved from Quercus to SITS. (Can anything be more stressful for a university than changing Student Record systems in the middle of a pandemic?) The SITS project touched most aspects of University life; for us, it required the development of new feeds into Moodle. 

Moodle itself has performed robustly since the start of the academic year, despite routinely serving numbers of students that in previous years would have been considered extraordinary. By the start of December our new Moodle had clocked up 1,264,306 logins and students had engaged in 14,088,187 activities (read/writes). Phew… 

Throughout 2019, discussions and consultations around content capture had taken place (and a new policy on content capture was eventually agreed). We entered 2020, however, in a difficult place. We were concerned about the technologies we had available to support content capture: our existing platforms had reached end-of-life. The team facilitated a number of supplier demonstrations early in the year, with the last demonstration taking place just before the work-from-home directive took hold, and UoP chose Panopto – the most widely adopted video platform within universities. The implementation and roll-out of such a platform would normally take place over the course of a full year, but we made Panopto available (complete with Moodle integration and a support website) within six weeks. Quite an achievement! And the platform is being heavily used: by November, we had 29,793 videos created; 10,464 hours of video created; 736,081 views and downloads; and 97,759 hours of video delivered. Again, phew…    

To support synchronous delivery for the new “Blended and Connected” approach, the University purchased Zoom. And, of course, we were quick to integrate this with Moodle. One useful feature in Zoom, which at that point could not easily be replicated by existing options such as Meet and WebEx, was the easy creation of breakout rooms. (Offering a plethora of technologies that do similar things – Zoom, WebEx, Meet – has the potential to lead to confusion for staff and an inconsistent experience for students. It can be difficult to take options away from people; in some cases, it might be technically impossible to remove options. But – in the interests of a consistent student experience – perhaps we need to be firmer in our recommendations of what tools to use?)

We invested in other tools, too: Padlet to facilitate collaboration; Vevox as an audience response system; and we continued to push Nearpod for interactive lessons. For all of these, we continued to provide our usual training support for staff, and offered face-to-face and small-group sessions – mediated by Zoom, WebEx, and Meet! 

Throughout the pandemic, the TEL team has been active on social media – and the stream of positive, uplifting, motivational messages from TEL accounts were well received during the lockdown. More than one member of staff said the posts cheered them up!

We worked with staff across DCQE to help them create support sites (for example the Wellbeing and ASK sites) and with staff across the University in workstrands, workstreams, and elsewhere. We supported departments in adapting to an online alternative to their usual ‘go-to method’ of face to face presenting such as the Staff Induction Welcome Event for new staff members held by HR. I hope that cross-institution working carries on when we return to some form of normality because everyone agrees it has been beneficial.

What else? Well, we have kept abreast of accessibility issues and our responsibilities under PSBAR. This is a difficult issue for all universities: the legislation was written, I believe, with static content in mind. But a VLE contains rapidly changing content from thousands of users. The sector as a whole is grappling with the implications of this.

We hope to develop our (externally hosted) CPD Moodle. As more people become aware of the platform, more courses are going on there. And we are working closely with CEG Digital, the University’s partners for expanding our DL offering

Questions around analytics and data have been of interest and, when we’ve had any spare time (hah!), we’ve tried to make progress in this area. We have liaised with a Business Analyst on the creation of a Student Engagement and Monitoring dashboard; locally, we have started to look at how to surface useful statistics on the Moodle dashboard. Watch for developments over the coming months! 

I could write much, much more about the team’s attainments – but I’ll leave it there.

We have encountered many setbacks and challenges – inevitably so, given the amount of change that has been implemented over such a short period of time – but the team, as part of the wider University, has achieved so much this year. We can leave the plague year behind us and enter 2021 knowing we have a bright future.

Guest Blogger: Catherine Murgatroyd – Introduction to Tel Tales

Hello, my name is Catherine Murgatroyd (SFHEA) and I am delighted to occupy the post of Principle Lecturer for Equality, Diversity and Inclusion within Academic Development. I would describe myself as a socially progressive, not quite perfect vegan who enjoys fitness, sunshine and my 2 pet cats.

I have arrived at UoP after 4 years at the University of Winchester where I was a Programme Lead for the BSc Social Work and equally undertook a range of activities with diverse programme teams to ensure that social justice and sustainability were prominent themes within socially responsible education.

Prior to this I enjoyed a career in Social Work which very much centred around social justice, tackling inequality, and championing human rights whether that was in the criminal justice system, safeguarding children or statutory quality assurance.

Behind my friendly exterior I spend a large part of my waking life somewhat outraged by widening global inequalities which motivates me to take any action I can, personally and professionally, to tackle this. I believe that equality of opportunity and a more equal society benefits everyone and that by confronting structural barriers head on we can effect change. Universities are well placed to tackle social inequality and to take action to mitigate structural disadvantage that impacts upon students’ participation and progression. It is a real privilege to be able to target my passion for social justice towards accessible, inclusive and supportive education that is co-created, diverse and decolonised, and affords all students the opportunity to succeed. One strand of my role will be focusing on reducing awarding gaps across the student body so that all students embody ambition and meet their full potential.

Starting a new job in the midst of a pandemic has felt quite surreal at times, but I am grateful for the fantastic welcome and support given by everyone I have encountered so far.

Please do contact me to find out more or to introduce yourself and say Hi.

Credit Image: Photo by Matteo Paganelli on Unsplash

Guest Blogger: Fiona Cook – Introduction to Tel Tales

Hi, I’m Fiona Cook and I am the new Research Associate for the Department of Curriculum and Quality Enhancement (DCQE). 

I have joined the University after nearly four years, across three roles, at the University of Portsmouth Students’ Union (UPSU). My latest role at UPSU was Insights Lead and I was responsible for leading all consultation, research, benchmarking, and data management, and for supporting GDPR compliance. Previously, I worked for the Student Focus team which covered areas such as academic representation, quality assurance, and collaborative partners. I have also worked in FE where I supported multiple departments including all HE provision. 

I have joined DCQE to support the University’s work on widening access to and participation in HE and enhancing the student experience. My role focuses on projects across the University that support the Access and Participation Plan, particularly those around BAME students, WP, innovation in learning and teaching, and student voice. When I saw the posting for my new role it seemed like the perfect opportunity to bring together my experience and interests! 

My previous roles at UPSU means I have already worked closely with the University, and DCQE, on similar projects including content capture, the NSS, the student charter, and the TEF. Working within the Student Focus and Insights teams means I have a lot of experience with student voice, and I thankfully already know quite a few of the many acronyms used in this area. 

I think student feedback is crucial in the development of both strategic and operational planning, and I’ve been able to share my work on using data to drive the student experience at conferences such as the University’s Learning & Teaching Conference and Qualtrics X4 which was one of the highlights of my career to date! The relationship between the University and the UPSU Insights team was also mentioned in the newest APP, demonstrating the importance of collaboration and inclusion.

I am keen to support access and participation through equity of opportunity, and I am excited to continue to contribute to this in my new role. I hope to bring my experience of these key areas and use it to support the development of University activities, whilst also developing my own research and analysis skills. 

It’s quite strange that after just over six weeks into a new role I’m now working at home daily. I shared some of my top tips for remote working on LinkedIn, and it’s been really useful to access the TEL resources as I adjust to regular video calls and life online.

Outside of work I am interested in dancing, politics, and baking – although I made my sister’s wedding cake last year so I’m on a slight hiatus. I’ve also recently adopted an eight-year-old cat called Mimi. 

Feel free to connect with me on LinkedIn

Fiona is based in Mercantile with AcDev and the Tel team.

Welcome to the team, Fiona! We look forward to hearing more about your projects in the not so distant future on Tel Tales.

Guest Blogger: Emma Duke-Williams – On changing from academic to educational Technologist

Some of you may remember me – I spent about 16 years at Portsmouth, lecturing in the School of Computing. I’ve now moved to be an Educational Technologist in Dundee University, working as part of a central team. In many ways it seems only yesterday that I left; in reality, it has been more than four years!

The change wasn’t entirely planned. I moved to Scotland for personal reasons and was therefore looking for a job. A combination of 16 years of lecturing (and a few more of school teaching before that) and a lack of a PhD made me decide that I didn’t want to lecture again. However, I did like the contact I had had with staff and students at Portsmouth, so the opportunity of a sideways jump appealed. Those who knew me at Portsmouth will remember that IT to support learning was a key area of interest for me. Indeed, my PGCE in the 80s had included “Computing in the Primary Curriculum” – those were the days of BBC Bs, Granny’s Garden and the Domesday project!

While at Portsmouth I was keen to experiment, and no doubt I drove some in the eLearning team mad with my “why won’t it do …” questions – but I also was free to experiment to see whether something could be done, and students generally went along with my ideas. 

All of that experience has really helped me here! I understand those wanting to push a tool to its limits, to get it to work for the way they want to teach, and that it’s rare to find ‘one size fits all’ solution. That aspect of my role is fun, challenging, and forces me to think about both tools and pedagogic practice. 

However, the greater challenge is supporting all staff to have a good understanding of the tools we have, the functionality on offer, while helping staff decide what’s really needed for their students. When teaching I came across students who found aspects of the subject hard, or didn’t understand why they had to do various things. Academics are no different! 

Do I miss teaching? Not often. I do miss the buzz of enthusiastic students, but I don’t miss the pile of marking – but I’d find this role 100 times harder, had I not had that experience of being on ‘the other side’. 

Introduction for Tel Tales

Hello!

My name is Jo Fairwood and at the start of January 2020 I joined the Technology Enhanced Learning team as an Online Course Developer, on a one year secondment. I previously worked for the Institute of Criminal Justice Studies (ICJS) as a Student and Academic Administrator. I started there a long time ago, back in 2006, so I felt it was time for a change.

My role as Student and Academic Administrator was not a traditional one. As technology developed so did my role and so did my passion for technology. I was responsible for harnessing new technologies to engage and enthuse our undergraduate distance learning students. When I first started working in ICJS everything was paper-based and posted out to our students. Over the years I developed new ways of bringing the courses fully online so that the students receive the best experience possible, wherever they were located in the world. This included broadcasting a day’s worth of live and pre-recorded sessions to them in what we called Virtual Study Days. They’re a bit like ‘This Morning’ but with our own ‘Holly’. Sadly we didn’t have time for a fashion tips session!

As you can probably tell I’m into filming, film editing and all that goes with film production. I like being creative when it comes to multimedia and I relish the opportunity to try new technologies that help with this. I think communication is important so I really like using social media for engaging with students and the wider community, and I also enjoy sharing best practice with colleagues and collaborating with colleagues around the University.

In my spare time I play tenor saxophone in two function bands and I like keeping active, so I play a lot of sports including squash, football, golf and netball. I’m also a huge football fan, in particular, a Watford FC fan (I’m originally from Watford) but I’ll watch any football match over anything else if it’s an option. I’m currently listening to a hilarious podcast called That Peter Crouch Podcast. I recommend it to all football and non-football fans!

Anyway, enough about me. All that’s left to say is that I’m thoroughly looking forward to getting stuck in with the TEL team and working on new, exciting projects over the coming year.

Twitter @jofairwood

Jo is based in Mercantile House with the eLearning Support (TEL) team .

Welcome to the team, Jo!

Guest Blogger: James Lenthall – Google Apps Script

Google Apps Script (GAS) is an extension for some Google Suite applications that allow for customisation. It could be compared to macros for Office or ExtendScript for Adobe. My experience of using it is mostly through Google Sheets so that’ll be my focus.

It’s incredibly versatile allowing you to read and write data, create your own functions, menus, pop ups, side bars and even entire web sites. This combined with integration that’s readily available with other Google services makes for an impressive toolkit for creating solutions for a wide range of tasks.

Why should you use it? Being cloud based with the ability to save versions as you work there’s no worry about losing anything, plus you can edit from anywhere. If you regularly do repetitive tasks, part of, or perhaps the entire task could be automated. Google forms don’t have the functionality you’re after? Build your own that can also populate a sheet. Trying to work out post dates? A custom function can automate that based on another cell’s data. Perhaps the most compelling reason to give it a try, taken from “7 Reasons Why Google Apps Script is a Great First Programming Language to Learn”; there’s no setup required and it’s completely free. 

If you are already familiar with front end web development then it is quick and easy to pick up. GAS is entirely written in JavaScript. It’s very well documented so finding your way around is easy. There’s also sites such as Stack Overflow for assistance as more often than not, someone else has already asked the question you have.

I know there have been other cases in the University where it has been used to email all users on a spreadsheet or simply whichever row you’re on. Personally, as a follower of Don’t Repeat Yourself (DRY) principles I use GAS or similar tools anytime I have a repetitive task.

To give a very specific case where publishing a Google Sheet as a web application has helped. In our team as we handle all the drop boxes, instead of having administrators update a spreadsheet and send us emails of changes each time or not at all, we have them fill out a form and overnight the developers are sent a single email with a list of requests.

If you’re ever thinking “there’s got to be a better way,” Apps Script might be your answer.

If this is something you’re interested in and want to find out more, email: james.lenthall@port.ac.uk  

Feature image: Photo by Arthur Osipyan on Unsplash

« Older posts

© 2024 Tel Tales

Theme by Anders NorénUp ↑