Digital research and scholarship · ICT proficiency · Word

#362 Cutting sections from Word? Spike them instead!

The spike feature is a little known function in Word, but enables you to keep all your cut items together (on an imaginary spike!) and then to be able to paste them all in one place. This is useful for when you are editing a document and want to do all your cutting at once,… Continue reading #362 Cutting sections from Word? Spike them instead!

Data literacy · Digital research and scholarship · Excel · Timesavers · Working with Data

#350 Use SumIF in Excel to add conditions to your additions!

As we’re seen in previous posts on Excel, Excel is full of nifty little tricks to help make our lives much easier. In this post we take a look at the SumIF function. This function enables you to set conditions on what you want to add together. These conditions can come from another cell, for… Continue reading #350 Use SumIF in Excel to add conditions to your additions!

Assessment · Assessment · Digital creation · Digital research and scholarship · Distance Learning · Google Chrome · Google Forms · Working with Data

#337 Create a quiz with Google Forms [4/4]: Sharing your quiz with students

This is the last in our series on creating a quiz with Google Forms. In this post, we look at how to share your quiz with your students and how you can embed it into a web page. Featured image: “Sharing” by ryancr is licenced under CC BY-NC 2.0

Assessment · Assessment · Digital creation · Digital research and scholarship · Distance Learning · Google Chrome · Google Forms · Quiz tools · Working with Data

#333 Create a quiz with Google Forms [3/4]: Viewing the results

This is the third in our series on creating a quiz with Google Forms. In this post, we look at how you can view the results and download them to a Google sheet.

Assessment · Assessment · Digital creation · Digital research and scholarship · Distance Learning · Google Chrome · Google Forms · Quiz tools · Working with Data

#325 Create a quiz with Google Forms [2/4]: Exploring the different types of questions

This is the second in our series on creating a quiz with Google Forms. In this post, we look at the different type of quiz questions that you can create as well as the different elements you can insert into the quiz itself such as images, videos and section breaks.

Digital creation · Digital research and scholarship · ICT proficiency · Microsoft Office · PowerPoint

#319 Presenting with PPT [5/5]: Using Presenter View

Have you considered using Presenter View when you present during lectures?  Presenter View allows you to view your presentation notes and preview upcoming slides all whilst your audience views note free version on the lecture screen.  Watch the video below to find out more… Do you want to learn more about PowerPoint? Check out our… Continue reading #319 Presenting with PPT [5/5]: Using Presenter View

Data literacy · Digital research and scholarship · Excel · Working with Data

#318 Excel formulas behaving weirdly? Try a fixed cell reference

A fixed cell reference allows you to use make use of the auto-fill feature in Excel, whilst ensuring any cell references you want to keep static, remain so. So if you ever find yourself frustrated that Excel isn’t completing your formulas as you’d like, this one is for you! Featured image: ” Red Cells”by Alias… Continue reading #318 Excel formulas behaving weirdly? Try a fixed cell reference