Page 10 of 26

Into the unknown – part 1

March 17, 2020 / Tom Langston / 1 Comment

Just like Elsa being called by unseen voices into an adventure as yet undefined (for those that don’t know, this is a reference to Frozen 2 and Elsa’s new and improved version of Let it go), Digifest 2020 or #digifest20, if you want to track it on social media, opens its doors and I step into the unknown, exciting event hosted by Jisc. Digifest is new to me, but to those that have been before it offers innovation, inspiration and opportunity.

This two day conference that Jisc organise every year at the Birmingham ICC is a window into the latest ideas that help create and shape fantastic innovations in learning and teaching.

The conference opened with, what would turn out to be, a controversial keynote from Jonah Stillman (@jonah.stillman on instagram), firstly outlining how the generations were categorised and then with a look into Gen Z and their approach to learning. It was an interesting insight into how Gen Z are not like the Millenials (who started in 1980!) and are being told they are winners and losers, it’s not about the taking part anymore, it’s about the winning. This, he argues, will be a potential hurdle through their learning and into the world of work as they are not able to collaborate (while admitting this was a wide generalisation).

For me the biggest take away was that you can’t wow Gen Z with technology. They quickly investigate and analyse a tool and quickly decide if it is useful or redundant. Where the older generations would see themselves as technology inept and the problem is with them, the Gen Z learner sees it as a problem with the product and that it either works for them or doesn’t.

We are all at that point where we have technology or using technology in some way as part of our lives, but for Gen Z there is the expectation it is there. It should be integrated and seamless to their experiences. Jonah Stillman expanded on this with the concept of Weconomists. The simplest example of this is Uber, but it is the shared economy. If you need something there will be someone available that can offer that service. How that fits educationally is going to be the next big sticking point. At worst we have the idea of buying essays, but how can we turn this into a positive? How can the shared economy of learning be expanded?

For me it fits into the idea that was presented by Rachel Hall (@rachela_hall on Twitter) at the next panel “Changing the world of work in the digital age” and how The Guardian has focused their future on the digital output of their journalists. They have looked at how people access the news depending on the time of the day. Headlines in the morning, just short sharp bite sized pieces of information that people can choose to discover on their commute to work. At lunch a more in depth article that expands on their day while they have a larger chunk of time to be critical of the stories that hold the most interest to them. By the evening they are looking at more lighthearted content that relates to their social experiences and lifestyle. This for me presents one potential solution to the shared economy, where students can share their stories and knowledge. They each process that information differently but if they can help interpret that to their fellow learners they will adapt the material and help reframe learning in a way that makes it accessible to everyone.

Just from the two opening sessions of this year’s Digifest, I feel inspired to think about my own practice and how as an educator I am trying to predict what is going to be useful for students in their learning. I am now more aware than ever that I am using technology in such a different way to that of the students at the university. The change we are seeing should not be seen as a problem. It should be seen as an opportunity, while we are taking a step into the unknown (just like Elsa!). We can take the challenge and channel our current students desire to learn and look at how we facilitate that desire in a way that may not be comfortable to us.

Stay tuned for Part 2, when I will focus on academics who are facing this challenge of a student body that potentially knows more than they do in terms of technology!

All the notes taken at #digifest20 can be found on Twitter @TelPortsmouth

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

March 16, 2020 / Emma Duke-Williams / 0 Comments

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’.

Peermark – a tool for group feedback.

March 9, 2020 / Tom Langston / 0 Comments

Recently Coventry University released a new plugin for Moodle around the idea of group and peer feedback. A colleague highlighted the new tool to me and at first glance I thought it looked like a promising solution to one of the requirements many academics have while running group work: the ability for students to score the contribution of individuals within the group and provide either public or anonymous feedback to group members.

Currently Moodle provides various options to support group work and peer learning, because Moodle HQ realises that these approaches hold an important place in the arsenal of many academics. Firstly, Moodle provides a generic framework for creating groups – these can then be allocated to an activity (such as discussion boards, wikis or group assignment submissions).

Secondly, and with a greater focus on the use of peer learning, Moodle provides the Workshop tool.

While groups can be added and used within the Workshop, the idea is predominantly that students add a submission. The submission is then allocated to a specified number of their peers, who then grade and provide feedback on it.

If you haven’t used the Workshop tool in anger, here is a quick overview of how to use it as a peer-assessment tool:

All students submit their work (traditionally this will be an essay, but it could be work in some other format).
The work is allocated to the other students. This can be scheduled and automated if required.
Every student marks the assessments they have been given (academics can also provide feedback, although this is not a requirement).
Each student receives a final grade for the submission and a grade for their ability to assess the work (academics can overwrite grades should they feel the process has proven unfair).

This tool provides students a fantastic opportunity to reflect on their own writing and work while comparing it to that of their peers. However, it does not allow for a group to provide anonymous feedback to their peers on projects. To do this academics currently have to find solutions outside of Moodle. The most notable option for this is TeamMates. TeamMates allows groups to feedback on the overall project work and then score the engagement of the rest of the team throughout the project.

We now have a new Moodle-based solution! Peerwork, created by Coventry University, is an integration with Moodle that provides a peer feedback option for group work. You can learn more about this approach from the video they have produced:

While working through Peermark, I was really impressed with its simplicity of set-up and use. I created the framework as an academic, but also completed the process as a student. Using multiple test accounts, I was able to understand how the process would work from both sides and see how you can adjust the overall grade given to a group though the peer reviews on the work.

The only criticism was really just my understanding of what the tool did (so not really a criticism of the system). When I uploaded a document as a student it cascaded it to each other members of the group. Each student does not need to upload a file, it is targeting the students for feedback on their peers and how the group worked throughout a project. The upload was almost a secondary consideration to the process.

Peermark is not the Workshop reimagined. They are two very different tools that serve a specific purpose.

The Workshop facilitates a student writing a piece of work, submitting it and other students provide feedback and evaluation of that work.

Peermark allows groups to discuss, rank and analyse how the entire team worked together over the course of the project. The work is created by the team for evaluation by the academic but the feedback given by the group on each other member will directly affect the shared grade of the team.

Peermark is currently on a test installation of Moodle.

If you would like a demonstration to see whether it would fit your need, please contact tom.langston@port.ac.uk

Image taken from Unsplash :John Schnobrich
John Schnobrich

Amand standing behind a handheld video camera

Guest Blogger: Jonny Bell – Video content as learning objects – Capturing more than just the lecture

March 2, 2020 / Jonny Bell / 0 Comments

We often advise lecturers to use more interesting content on their Moodle sites, rather than just lecture slides, PDFs and so on, but what does that mean in practice and how can lecturers facilitate this and manage their busy schedules?

Videos are an easy way to make sites more visually appealing and are more likely to engage students. We can use videos in two ways: either

(i) source already-created videos, via sites such as Youtube or Box of Broadcasts.

(ii) can create our own.

As an amateur videographer outside of work this is an area I am very interested in. During my time working in the Institute of Criminal Justice Studies I had the chance to interview some extraordinary characters, including government advisers on how to deal with terrorist attacks and ex-convicts who have been successfully rehabilitated into society.

These short interviews provided much better value to students than watching a rerun of a longer lecture. In fact, studies show that the length of the video directly links to how much of the content the student will watch. Whilst this study looks at MOOCs, I strongly believe we can translate this to a Higher Education environment also.

With the introduction of H5P functionality within Moodle we can make these videos interactive and make sure students answer questions to solidify the knowledge they’ve gained by watching them.

The generation of students coming through now have grown up on Youtube and Netflix, and academics are keen to tap into that mindset to provide videos of educational value. There’s various different styles of video to choose from, and I have personally been involved in 7 different ones.

In my current job in the Science and Health Faculty there has been a lot of scope to provide instructional or demonstration videos for specific pieces of equipment in laboratories, for example. Students can watch these videos outside of class, and it saves valuable lab time: students can get on with their work straight away rather than having to get to grips with the equipment.

I think videos also provide a vital link on Distance Learning courses: it’s often a great way for students to connect with the course, especially if the lecturer is happy to do bits to camera. It can humanise the experience if they can see who is teaching them.

Students want to feel they get value for money and just providing Powerpoints and PDFs isn’t enough these days. By creating our own in-house videos the students get an almost personalised learning experience. When I started in the Faculty there was some basic camera equipment, but I was able to purchase a higher-spec camera, lapel mics and some small studio lights via senior management. This means that I’m mobile and can go to the lecturer or a location they wish, rather than have everyone go to a dedicated filming space.

Projects currently in the pipeline are a “TV” style video with student presenters introducing pieces about their specific course, including how to present their poster assessment in front of a panel on a Pharmacy course; this will be invaluable for first-year students.

Looking to the future there have already been requests for my services on field trips for geography-type courses. This means we can increase the accessibility of these courses for students who, for various reasons, might be unable to get onto these trips. Having a short video on how to conduct experiments on soil, for example, means these students will have a similar experience to those who go on the trips. Ultimately, as an institution, we should be striving for all of our students to have consistent learning experiences and by creating short videos we can go some way to achieving that.

Credit Image: Photo by Seth Doyle on Unsplash

Jo and Sarah sitting on different sofas looking at each other

Introduction for Tel Tales

February 24, 2020 / Jo Fairwood / 0 Comments

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!

Some comments on “The future of assessment”

February 17, 2020 / Stephen Webb / 0 Comments

The Curriculum Framework Specification document, which provides detailed precepts and guidance for the design, development and review of all new courses at the University, contains UoP’s policy on assessment. The policy’s authors made a conscious choice to call it an Assessment For Learning Policy: the policy advocates assessment for learning rather than assessment of learning. As the policy states, assessment for learning enables a culture in which:

students receive feedback from academics and peers that helps them to improve their work prior to final/summative assessments;
students understand what successful work looks like for each task they are doing;
students become more independent in their learning, taking part in peer and self-assessment;
formative assessment is, where possible, aligned to the module summative assessment, in order to facilitate cyclical feedback opportunities which will clarify expectations and standards for the summative assignment (e.g. the student’s exam or portfolio submission).

As the University considers how to implement its new five-year strategy, however, and how to meet its ambitious vision for 2030, might we need to rethink assessment? Not rethink the approach of assessing for learning, but look again at some of the details of how we assess?

The changing nature of assessment over the coming five-year period happens to be the subject of a recent publication from JISC: The Future of Assessment: Five Principles, Five Targets for 2025. This report, the output of a day-long meeting held in 2019, identifies five key aspects of assessment and the role that technology can play. The report argues that assessment should be (in alphabetical order, not order of importance):

Accessible – taking an inclusive approach to assessment is the ethical thing to do, of course, but we now have a legal requirement to meet certain accessibility standards. Digital technology can certainly help with accessibility. Contact DCQE if you would like further advice in this area.
Appropriately automated – it hardly needs to be said that marking and feedback, although crucial elements of the assessment process, is time consuming. Technology can help here, too. Technology can be used to automate the process and, if the assessment has been properly designed, students get the benefit of immediate feedback. Technology might also be used to improve the quality of feedback: in this regard TEL is currently exploring the Edword platform.
Authentic – this is, I believe, a key area for the University to develop. How does it benefit students to make them sit down for three hours and hand write an essay under exam conditions? This doesn’t prepare them for the world beyond university. Surely it’s better to assess students’ ability to work in teams; display their knowledge in a realistic setting; use the digital skills they will undoubtedly need in the workplace?
Continuous – in order to be successful in their chosen careers, our students will need to keep up with changes wrought by technology. So perhaps the most important skill we can teach our students is how to be independent, self-directed learners. An over-reliance on high-stakes, summative exams does not help. Of particular interest to me, in the JISC report, was the mention of using AI to personalise learning and assessment: the technology is not there yet, but it might come in the next few years.
Secure – if we are going to assess a student then we need to know we are assessing the right student! For a long time the focus in HE has been on detecting and deterring plagiarism. Nowadays, though, we also face the threat of essay mills and contract cheating. Once again technology can play a role: data forensics, stylistic analysis tools and online proctoring platforms can help tackle the problem. Such tools are best used, however, in a culture that promotes academic integrity: we should use technology to help promote a sense of academic community rather than to “catch the bad guys”.

The five principles identified by the JISC working group seem to me to be realistic and practical. They are also, if I’m being honest, slightly unambitious. I think mixed-reality technology, for example, opens up many opportunities to develop assessment for learning. But perhaps that is more for a 2030 vision than a 2025 strategy.

Credit Image: Needpix.com

Using animated videos to engage learners

February 10, 2020 / Becky Holman / 2 Comments

Sometimes we have a subject that we want to get across that can be tricky to make interesting. Giving students (or indeed anyone) some text, audio or PowerPoint slides can often mean that interest in the subject matter is quickly lost and information is not properly taken in. Studies have shown that students tend to find information in the form of videos far easier to absorb, and when this comes in the form of a snappy, animated video it instantly becomes dynamic and engaging.

As we know, hiring a videographer is an expensive and time consuming business, so I decided to look for a viable alternative. Previously, I have used a variety of online animation tools, that although they were easy to use and, most importantly, free, I felt that we could do better. I wanted to find a tool that was not only cost effective, but could easily create a professional looking video. I had a look in my mind already as to the type of animation tool I was looking for, I wanted these videos to look contemporary and fun so that we could apply the tool to a variety of subjects and engage viewers of different backgrounds, and levels of study. I didn’t want to disengage a viewer immediately by having a video look too ‘cartoony’. Eventually, I came across Vyond.

What is Vyond?

Vyond (previously known as GoAnimate) is a cloud based video platform that anyone can use to create visually engaging, animated videos. Vyond provides the user with thousands of pre-made templates and props royalty free-music and characters which you can use to create dynamic content that keeps your viewers attention.

How can using Vyond help me?

As I mentioned earlier, studies have shown that using a short, animated videos can increase students in higher education capability of understanding difficult subject matter, whilst staying engaged with the content provided. Vyond provides many different tools to assist you with making a fantastic looking video, whether it be purely for information or to get a particular subject matter across.

Resources – Use Vyond’s asset bank of thousands of pre-made props, templates and characters to enrich your video.
Animation – You can animate pretty much everything in Vyond, to the way a character looks, to how a slide exits the scene. It all comes down to your creativity!
Adding a voice – Upload an audio file that you have recorded to either add a voiceover or character dialogue. If you give a character a voice, you can also have the character lip sync to the track!
Music and sound effects – Vyond offers lots of royalty-free music and sound effects for you to use, but you can still upload your own if you wish.
Exporting and sharing – Once you’re ready to share your video, you can either download it and upload it somwhere (for instance YouTube), embed it or simply use the shareable link provided.

Tips for making a great video

Creating a video with Vyond is easy (honestly!), but you still need to put some thought into your project. Here are three tips to get you started…

Start off by creating a storyboard – You should already have a relatively good idea of what you want your video to look like and the message you need to get across. Start off by putting those ideas down on paper, either by brainstorming or making a storyboard.
Try and keep videos no longer than 5 minutes – Viewers are more likely to retain information when videos are short and concise. The perfect time has been shown to be no longer than 2 minutes, however if you need a bit longer then try not to go over 5 minutes! This can be tricky, but it’s also where step one comes in handy, so you can plan your video and make it more concise.
Take the time to record your narrative – Creating a colourful, animated video means that trying to provide dialogue via on screen text can be really distracting and overwhelming. Of course we need to include captions for accessibility, but try and take the time to record your script and then add text only at key points of the video.

Here’s one I made earlier!

I made the below video for our TEL advent calendar to showcase what Vyond can do, so take a look!

https://youtu.be/5E-XVOAOSeQ

How can I try it out?

Anyone can sign up for a two week trial via Vyond’s website and try it out themselves. After that you will be required to purchase a license. You can find out more about the packages available on Vyond’s site.

Already using Vyond or something similar – let us know!

We would love to hear from you if you are already using Vyond or a similar tool to create animations. You can feedback to us in the comment box below.

Image credit: Photo created using character templates within Vyond’s asset bank – https://www.vyond.com/

Guest Blogger: Ruth Geddes – Feel Good Fest 2020

February 3, 2020 / Ruth Geddes / 0 Comments

A celebration of all things that support us in our quest for wellbeing!

Each year, the Feel Good Fest brings together University staff and students with local artists and organisations to take part in an afternoon of FREE food, fun, and activities.

Together, we celebrate the diversity of what Portsmouth has to offer in supporting, encouraging, and inspiring us all in maintaining our personal wellbeing.

There is a wide range of activities, brought to you by University departments such as UoP Library, UoP Careers, Global, Sports and Rec, our UoP societies and Student Union, as well as local partners such as Highbury College and Southern Domestic Abuse Services. Portsmouth based artists such as Miss Bespoke Papercutting (a UoP alumni) and Hoopshaker also support the event.

This year, we are also excited to have secured Vidura Fonseka as a speaker and performer at our event. He speaks about his own journey with depression, and how dancing has provided him with a creative outlet to help manage his mental health and support his recovery and ongoing personal journey. (https://www.vidura.co.uk/and https://happiful.com/body-popping-my-way-back-to-health-viduras-story/)

The Festival is based on the Five Ways to Wellbeing – a set of actions proposed in 2008 by a government thinktank, (https://www.gov.uk/government/publications/five-ways-to-mental-wellbeing) to decrease some mental health problems and help people to flourish.

The 5 actions to improve personal wellbeing are:

connect
be active
take notice
keep learning
give

The Festival therefore attempts to provide activities and performances that link and promote each of these five ways to wellbeing – giving staff and students an opportunity to experience new things and connect with new people, all in a fun and supportive environment.

In the past, we have taken over Third Space for the afternoon – this year we have expanded and have also secured The Waterhole space for the afternoon too !!

The performances this year are –

UoP Show Choir – opening the festival @ 1pm
UoP Capoiera Society – @ 1:30pm
Vidura – a speaker and performer with lived experience of Mental Health challenges @ 2pm
Individual performance slots of music from two students – @ 3:15 and 3:30pm

There is also –

Free food
Drop-in craft activities such as crochet and mug painting
Free Massage
Get Active sessions from Sports and Rec
Lego building
Try out static rowing and mini-trampoline’s

There will be giveaways and raffle prizes, and wellbeing staff to chat to – all under
one roof!

If, at the event, you need some quiet time away from all the action, The Huddle is the perfect place to have a space of calm.

No need to book – just turn up!

DATE: Wednesday 5th February 2020
TIME: 1.00pm–4.00pm
VENUE: Third Space and The Waterhole, Students’ Union

Follow us on social media for updates on the festival schedule, and if you would like to get involved on the day – get in touch !!

Personal Tutoring Project

January 27, 2020 / Alana Aldred / 0 Comments

As part of the OfS-funded project Raising Awareness, Raising Aspirations (RARA) staff from a number of teams – Technology Enhanced Learning (TEL), Information Systems, Academic Development, and the Academic Skills Unit – joined forces to develop a platform, website and learning resources to support tutors and tutees in the personal tutoring process.

RARA, a collaborative project between the University of Sheffield, King’s College London and the University of Portsmouth, investigated the extent to which an enhanced personal tutoring system might help reduce the attainment gap for Black and Minority Ethnic (BME) students and those from lower socioeconomic groups. The project had its roots in research (Cousin and Cuerton, 2012; Thomas, 2012; Mountford-Zimdars, 2015) which suggested that such a system could reduce the attainment gap, ‘based on evidence that the personal tutor can play a particularly important role in the academic integration of BME students and students from lower economic groups.’

We used an agile project methodology, drawing on the skills, experience and knowledge across the University. From the start we wanted to create a space for tutors, in consultation with tutors. From these consultations, it was clear that there was a varying understanding of the personal tutoring role across the university. Many personal tutors felt they were not equipped with the knowledge they needed to fulfill their role to the best of their ability, and this was especially true of those new to teaching.

TEL’s main project deliverable was to lead on creating staff- and student-based personal tutoring resources. In August 2018 we launched the website Personal Tutoring @ UoP for tutors and those that support this process. Since this initial launch TEL have been working to develop the site further – a new, more extensive version of the site will launch in February. The site provides information about the personal tutoring role, developing tutees, supporting and signposting tutees, and training resources.

TEL have also developed student-facing resources within Learning at Portsmouth – a student website to support transition into higher education. As well as online provision, we also developed a paper-based guide for all first-year, campus-based students to be given at their first tutorial session.

Burke et al. (2016) found that academic staff play a key role in how students construct their feelings about capability, which ultimately lead to success or failure in higher education.

The guides include information for students on how to develop themselves whilst at Portsmouth and also provided contact details of services across the University and their faculty to support them in their studies and in times of personal difficulties.

The end of the two-year RARA project was marked by our University’s first personal tutoring conference for academic staff, and the launch of a RARA personal tutoring toolkit. As an institution we are now well on our way to implementing the recommendations made in the 2019 RARA Report. Student and staff feedback has been positive – the website has not only had an impact at Portsmouth but has formed part of a national toolkit for personal tutors. These have been presented at conferences and have received positive feedback on the clarity of their design. Looking to the future, TEL will continue to work with colleagues across the institution in the development of work in this area so that as an institution we can help tackle the attainment gaps that are prevalent nationally in higher education.

References

Cousin, G., and D. Cureton. 2012. Disparities in Student Attainment (DISA). York: HEA.

Mountford-Zimdars, A., Sabri, D., Moore, J., Sanders, S., Jones, S., & Higham, L. (2015). Causes of Differences in Student Outcomes. Higher Education Funding Council for England, HEFCE. Accessed July 23, www.hefce.ac.uk/pubs/rereports/Year/2015/diffout/Title,104725,en.html

Thomas, L. (2012). Building student engagement and belonging in Higher Education at a time of change: final report from the What Works? Student Retention & Success programme. London: Paul Hamlyn Foundation.

Different coloured wall lights spelling out the word google

Guest Blogger: James Lenthall – Google Apps Script

January 20, 2020 / James Lenthall / 0 Comments

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