Category: Digital Capabilities Framework

Microsoft Excel Tips and Tricks (Part 2)💡

Laurie Stevenson [las60] Digital proficiency and productivity, Information, data and media literacies, LinkedIn Learning, Student Digital Champions, Students Leave a comment

Blogpost by Laurie Stevenson (Student Digital Champion)

Banner with Student Digital Champion

I published Part 1 of this blogpost earlier this week, where I introduced you to 5 tips and tricks to help you make the most of Excel, and this blogpost contains 5 further tips! If you want to learn more about Excel, please visit my new Excel LinkedIn Learning collection.

Tip 6: Adding in multiple rows or columns at once

If you want to add more than one row or column in one go, this tip will save you the time of having to do this one row at a time.

  • Highlight the number of rows or columns you want
  • Right-click on the highlighted rows or columns
  • Choose Insert from the drop-down menu that appears

Tip 7: Adding bullet points

Finding the button to add these is not as easy as on Microsoft Word but luckily there are a couple of different ways to do this.

Read More

Microsoft Excel Tips and Tricks (Part 1)💡

Laurie Stevenson [las60] Digital proficiency and productivity, Information, data and media literacies, Student Digital Champions, Students Leave a comment

Blogpost by Laurie Stevenson (Student Digital Champion)

Banner with Student Digital Champion

Feel a sense of dread whenever you have to use Excel for your degree? Well, we’re here to help! Many degrees will require the use of Excel at some point for data analysis, maths calculations, graph or chart creation, project management and much more.

Excel can seem complicated and daunting to some, particularly if you are relatively new to it, so I’ve put together a list of tips and tricks as well as a new Excel LinkedIn Learning collection to help you out.

Keep an eye out on our blog later on this week as I’ll be publishing the second part of this blogpost, which will include 5 more tips and tricks on using Excel!

Tip 1: Useful keyboard shortcuts

Keyboard shortcuts involve pressing more than one key simultaneously and if memorised can save you a great deal of time. For example, use CTRL+A to select all the cells in a spreadsheet. Take a look at the following list of good ones to learn:

Ctrl + NCreate a new workbook
Ctrl + OOpen an existing workbook
Ctrl + SSave the active workbook
F12Save the active workbook under a new name, displays the save as dialog box
Ctrl + WClose the active workbook
Ctrl + CCopy the contents of the selected cells to the Clipboard
Ctrl + XCut the contents of the selected cells to the Clipboard
Ctrl + VPaste/insert the content of the Clipboard into the selected cells(s)
Ctrl + ZUndo your last action
Ctrl + POpen the Print dialog
Alt + HOpen the home tab
Alt + NOpen the Insert tab
Alt + POpen the page layout tab
Ctrl + SSave a workbook
Ctrl + 9Hide the selected row(s)
Ctrl + 0Hide the selected column(s)

Read More

Online Scams: Identifying Scam Emails and Texts

WordPress User [jec68] Digital Identity and Wellbeing, Digital proficiency and productivity, LinkedIn Learning, Student Digital Champions, Students Leave a comment

Blogpost by Jeffrey Clark (Student Digital Champion)

Banner with Student Digital Champion

The Internet is a great place to connect with friends, work on projects, and even make money. However, there are some who will use the Internet to try and make money from YOU! Unfortunately, scams are becoming more and more advanced but thankfully I’ve got you covered! In this blogpost I’ll go over scam emails, what they are, how to identify them and what to do when you find them.

Make sure to read the Aberystwyth University page on spam emails before reading this blog post.

What is a phishing email?

A phishing email is an email that is designed to obtain sensitive personal data from you. This data may come in the form of your address, credit card information, or even your bank details! Phishing emails are usually disguised as legitimate business emails like the example below.

Screenshot of a Phishing Email from TustedBank
Image from Wikimedia Commons

It’s easy to see how one might fall for a phishing email like this. Firstly, the email notifies the victim that their bank account may have been compromised which prompts them to act urgently. Secondly, there is nothing suspicious about the link at first glance. So how can you tell the difference between a legitimate email and a phishing email?

Read More

RB&I Seminar (28 March): Mobile apps for research, assistance or profit

Sioned Llywelyn [sil12] Digital creation, problem-solving and innovation, Training Leave a comment
Person Holding Silver Android Smartphone with apps displayed on the screen

On Tuesday 28.03.23 (12:00-14:00), the Research, Business and Innovation department have arranged an in-person seminar to help researchers decide whether their app idea is feasible and how to go about making it happen.

The seminar will be led by Professor Chris Price from the Computer Science Department.

For further information, and to book your place, please visit the event page.

Using Primo Effectively 📚

WordPress User [jec68] Information, data and media literacies, Student Digital Champions, Students Leave a comment

Blogpost by Jeffrey Clark (Student Digital Champion)

Banner with Student Digital Champion

Introduction to Primo

It can be challenging to go into any library and find what you’re looking for. Most libraries contain hundreds of books, and the Hugh Owen library has THOUSANDS of books. If you want to find what you’re looking for with clinical precisions, then I recommend you give Primo a try. Primo is a digital library catalogue used by Aberystwyth University. It’s a massive database that allows students to search for books to loan from the University, make lists of books to check-out, and access online versions of reading materials. It has tonnes of features which have made my time at Aberystwyth that much easier. While it’s easy to see it as ‘just Google search for the library’, it’s much more than that. From saving lists of books to requesting books I need for my course, Primo has saved me time and from many headaches during my studies. In this blog post I’ll be going over Primo, what it does, and how to make it work for you.

Using the search function

Using Primo’s search function is easy. Simply type the name of the item you wish to find and Primo will tell you where it is in the Hugh Owen library or if you can access it online (some items have both online and physical copies.) Primo’s search function is set to search for ‘all items’ by default, which can muddy your search results a bit by giving you too many options.

At the bottom of the search bar, there are three drop-down menus which have options to help you find EXACTLY what you’re looking for. For example, let’s say that I want to search only for books by John Steinbeck. From the bottom of the search bar, I would select ‘Books’, then ‘with my exact phrase’, selecting ‘as author/creator’ and finally searching ‘John Steinbeck.’

Screenshot of Primo showing how to insert text in the search bar and the different filters

Read More

Microsoft Word Tips and Tricks 💡

WordPress User [jec68] Digital proficiency and productivity, LinkedIn Learning, Student Digital Champions, Students Leave a comment

Blogpost by Jeffrey Clark (Student Digital Champion)

Banner with Student Digital Champion

Making things easier

Microsoft Word is perhaps the most used and widely recognized computer program in all of academia. Virtually every course you can take at Aberystwyth University uses Microsoft Word to some degree, with some courses requiring you to do more with it than just type out an essay. In this blog post, I’ll tell you about some shortcuts in Microsoft Word that have helped me during my studies.

Tip 1: Keyboard shortcuts

Keyboard shortcuts are a combination of keys that you press to perform a function. For example, press control (ctrl) and C at the same time while highlighting text copies that text onto your clipboard. Instead of right-clicking and scrolling down the drop-down menu to ‘Paste’, you can press ctrl + V to paste the text instead.

The ALT key can also be used for shortcuts. Specifically, the ALT key is used for shortcuts as they relate to the top task bar. By holding down the ALT key for a few seconds, the keys for each shortcut will pop up. For instance, on my keyboard, pressing ALT and 2 will save my document.

But if we press ALT + S to go to the References tab…

We get an entirely new set of ALT keyboard commands to use!

By holding down the ALT with a different tab open we can see what shortcuts are available for each tab on the taskbar. If you forget what ALT key shortcuts do, holding the ALT key down will give you a helpful reminder of your keyboard shortcuts!

Read More

Join the Digital Marketing Masterclass (8 February)

Sioned Llywelyn [sil12] Digital creation, problem-solving and innovation, Training Leave a comment

Want to learn how you can use digital marketing to promote your Business or Social Enterprise?

Woman holding a tablet

AberPreneurs, part of the University’s Careers Service, are running an exiting online event on Wednesday 8 February (2pm), Digital Marketing Masterclass with Francesca Irving from ‘Lunax Digital’.

Join the webinar online through MS Teams.

For any queries, please contact aberpreneurs@aber.ac.uk.

Busting exam stress with technology 💻

WordPress User [jec68] Digital Identity and Wellbeing, Digital learning and development, Student Digital Champions, Students Leave a comment

This blogpost has been written by Jeffrey Clark, Student Digital Champion

Banner with Student Digital Champion

That sinking feeling…

With exams around the corner, there’s no doubt that you’re all feeling the pressure. Sometimes that pressure can be overwhelming and lead to periods of high stress and anxiety. No student should have to feel like that! In this blogpost, I’ll go over some tips and useful apps that can help you and other students tackle stress during this difficult period.

Striking a balance âš–

Here is an example of how I would organize a typical revision weekday using Microsoft Teams

It is perfectly normal to feel mild to moderate levels of stress during your time at university. There is a lot going on! From reading and writing essays to hanging out with friends, it’s easy to feel overwhelmed at times. Even if you really enjoy your degree, it can still be stressful trying to find the time to manage all your modules. That is why I recommend managing your time and controlling your routine rather than letting it control you. Apps like Microsoft To-Do have been incredibly helpful to me since I’m always on-the-go. Microsoft-To-Do is a free cloud-based task management app available for desktops, Androids and Apple devices. The app contains some useful features for keeping you on track such as a customizable calendar and reminders that can be arranged in any order you desire.

Microsoft Teams also features an incredibly customizable calendar that is useful for scheduling meetings as well as keeping you up to date with your university task. Managing your time reduces stress by minimizing unpredictability and giving you the ability to work WITH deadlines as opposed to AGAINST them. Another good tip to reduce exam stress is to focus on one thing at a time. Whilst revising, focus your attention on just one of your modules a day, if you can. This makes it easier to retain information on the module that you’re studying which will make taking an exam all that easier. If you must study multiple modules, make sure you give yourself a meaningful break during your studies. Taking a break is important while studying for any amount of time. Incorporating breaks into your schedule is key to reducing stress and avoiding ‘burnout’, which we will discuss in greater detail later in this post.

Read More

LinkedIn Learning Collections to support students preparing for their exams

Laurie Stevenson [las60] Digital Identity and Wellbeing, LinkedIn Learning, Student Digital Champions, Students Leave a comment

As exam season approaches we have put together a couple of collections on LinkedIn Learning to help you banish the stress of exams and to help you revise more effectively.

Effective Exam Preparation and Revision Collection

This collection has some tips and advice to help you revise and study for your exams.

Tackling Exam Stress Collection

Exam season can be a challenging time for students, this collection gives you some strategies and advice for managing your stress levels around exams.

All Aberystwyth University students and staff have free access to LinkedIn Learning. Please see our login instructions and more general FAQ’s to help you during exam time. 

Fake News & Plagiarism: Stop the Spread! Part 2 – Preventing Plagiarism

WordPress User [jec68] Information, data and media literacies, Student Digital Champions, Students Leave a comment
Banner with Student Digital Champion

Don’t be a copycat!
Welcome to part 2 of our series on fake news and plagiarism. In part one we looked at the world of smoke and mirrors that is fake news. In this part, we will go over the many forms of plagiarism, how to avoid accidental plagiarism, and ways you can combat deliberate acts of plagiarism.

What is plagiarism?
Plagiarism is the act of presenting someone else’s work as if it were your own without giving credit to the original author(s) of the work. In other words, plagiarism is a form of theft but instead of physical property it is the idea of someone else, or intellectual property. There are several ways of committing plagiarism, many accidental and others intentional. Fortunately, virtually every course at Aberystwyth University goes over the basics of academic integrity as well as the proper referencing scheme to use for your course. More information on plagiarism can be found through the LibGuides page on plagiarism.

Referencing & Plagiarism Awareness LibGuide

Read More