Communication / Collaboration · Digital collaboration · Digital innovation · Digital research and scholarship · Distance Learning · Formative assessment · Google Chrome · Information literacy

#621 Hypothes.is [1/2]: Make reading active, visible, and social

Hypothesis is a digital annotation tool that allows anyone to add, view, and respond to comments on pretty much any public webpage. It is a great tool and is available for free. To get started you need to sign up for a free account and add Hypothes.is to your browser. Once you’ve done that you… Continue reading #621 Hypothes.is [1/2]: Make reading active, visible, and social

Communication / Collaboration · Digital creation · Digital innovation

#601 Airtable: Showing Airtable data in galleries

Airtable allows you to gather data using forms that people can fill in. This then gives you the ability to create visuals of this in galleries. In this video we look at how you might use this function in presenting speaker bios at an event. An example can be found on the Co-operative College Learning… Continue reading #601 Airtable: Showing Airtable data in galleries

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!

Classroom Technologies · Classroom technology · Digital creation · Digital participation · Distance Learning · Formative assessment · Quiz tools

#334 Formative [3/3]: Viewing and exporting results

In the last couple of posts on Formative, we have explored how to create and share a quiz. In this post we will look at how you can view and export the results (and mark any free-text answers). Featured Image: “Old Trafford score board” by  Cheekablue licenced under CC BY-NC-ND 2.0

Classroom Technologies · Classroom technology · Digital creation · Digital participation · Distance Learning · Quiz tools

#330 Formative [2/3]: How to share your Quiz

In the last post we explored getting started with Formative and how to create your quiz. In this post, we’ll look at how you can share your Quiz with your students. Featured Image: “20110410-IMG_0969” by Martin Robson licenced under CC BY-SA 2.0

Data literacy · Excel · Working with Data

#322 Use this formula to count filtered data in Excel

We saw in an earlier post just how easy it is to filter data in Excel. Filtering is a great tool, but what if you also want to count your filtered data? This is where this handy formula comes into play… Featured Image: “Counting 2” by The Shopping Sherpa licenced under CC BY-NC-ND 2.0

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

ICT proficiency · Outlook

#314 Outlook Calendar getting cluttered? Create a new one!

It is easy to create multiple personal calendars in Outlook. You might want to create a calendar which includes your personal appointments, university wide events or perhaps assessment hand-ins. These calendars can then be easily overlaid with your main calendar to view any potential clashes, without cluttering up your main view. Featured image: “Calendar” by  Hana… Continue reading #314 Outlook Calendar getting cluttered? Create a new one!

Communication / Collaboration · Digital communication · Moodle

#310 Using the Moodle Feedback Activity? Share questions using templates

We covered the confusingly named Feedback Activity in Moodle a few posts ago, see: #160 Moodle Feedback [1/2]: An easy way to survey your students! You use the Feedback Activity for creating student surveys in Moodle. One way to share a good survey with colleagues, is to set it as a template. Featured Image: “Templates” by Volpin… Continue reading #310 Using the Moodle Feedback Activity? Share questions using templates