do: Organise your meetings more effectively!

This do: session will look at often-overlooked aspects of planning and running meetings.

We’ll cover initial planning, pre-meetings, agenda, running the meeting, accessibility, environment, technology, chairing styles, minutes and follow-up. The session goal is to enable you to achieve greater meeting efficiency and focus, and to maximise the value derived from the time and effort put into your meetings.

Speaker: Tony Brett
——

Download the slides

 w  Watch the recorded talk

Posted in Spring 2016 | Comments Off on do: Organise your meetings more effectively!

————————-do: Lunchtime talks ————————————

————————————————————————————————————————————————–

do: is a series of lunch time talks that highlight the use of IT technology in support of business systems and processes in the University.

The new season of talks will run in Hilary term 2016: details of the talks will appear here as they become available, so book your places and come along to 13 Banbury Road to hear about how you could save time and frustration.

Many of our events are recorded and/or live streamed as a simultaneous webcast.  w  means that a talk is to be webcast (links for you to connect to the webcast are given below).

do02“do-do, dee-doo”do03

Posted in Spring 2016 | Comments Off on ————————-do: Lunchtime talks ————————————

do: Time management

Beth Asbury is an administrator at the Pitt Rivers Museum and she has several years of experience in similar positions elsewhere. She has had time management training, which she finds invaluable and is happy to share some of the tips and tricks she has learned with others.

In this do: talk, Beth will be discussing ‘time bandits’ and how to deal with them, energy levels, prioritising tasks, ‘elephant tasks’, delegation, scheduling and workload analysis. These skills are useful for anyone who has more than one thing to do every day and not only for administrators!

Speaker: Beth Asbury
——
Download the slides and the handout
26 January 2015

Posted in Spring 2015 | Comments Off on do: Time management

do: Managing mailing lists

This do: talk is for those who use mailing lists regularly and particularly for those managing them.  We will look at some common time-saving tricks and have time for general discussion about best practice in mailing list use.

We’ll cover:

  • managing subscribers
  • tweaking the automatic messages
  • tagging subject lines and adding footers
  • using a list to book a meeting in outlook
  • sharing list ownership and/or management
  • passing ownership and/or management of a list to someone else
  • Managing archives

The intended audience for this talk is seasoned users of mailing lists who want to sharpen up their toolkit a bit so they can use this service even more effectively.

We’ll expect you to have used mailing lists regularly and be a manager or moderator of at least one list.

Speaker: Tony Brett
—–
Download the slides and watch the recorded talk
27 January 2015

Posted in Spring 2015 | Comments Off on do: Managing mailing lists

do: Managing versions of program code with Git

Managing code changes in a programming project isn’t easy, especially when collaborating with other developers. Git automates many of these tasks such as merging, tracking, diffing and rolling back code.
We apologise that this event has been cancelled

Posted in Spring 2015 | Comments Off on do: Managing versions of program code with Git

do: Nothing (and your staff and reputation could be at risk on social media)

Social networking sites are great engagement tools for the University. But these can be a fraudster’s paradise. Social media is a target for “social engineering attacks” which harm your professional reputation, can shame the University and put your staff at risk.

But you can do something about this!

This do: talk will interest department administration and communications teams running the online presence of their University unit, College, society, project or research group – or indeed anyone who uses social media to enhance their professional online presence.

Speaker: Alun Edwards
—–
Download the slides and handout; watch the recorded talk
10 February 2015

Posted in Spring 2015 | Comments Off on do: Nothing (and your staff and reputation could be at risk on social media)

do: Soothing course admin headaches with SharePoint

Running an academic or training programme can mean grappling with several systems, lots of spreadsheets and, as a consequence, version control issues. This talk will consider how to run the administrative side of a programme in SharePoint to make things more efficient and to help provide students and course participants with useful sources of clear, current information.

This  do: talk will interest programme leaders and administrators.

Speaker: John Miles
—–
John Miles invites anyone who is interested to visit the Humanities training site in SharePoint, to see what they have set up:
https://sharepoint.nexus.ox.ac.uk/training
Watch the recorded talk

16 February 2015

Posted in Spring 2015 | Comments Off on do: Soothing course admin headaches with SharePoint

do: Win friends and influence people using Microsoft Project

Microsoft Project can be an effective aid to accommodating the differences your colleagues bring to your project/event/research, and can enable you to keep your colleagues happy and get the job done.
Do this successfully and you will create effective, collaborative working relationships with people who will be willing to work with you again and potentially give you more of their time.

Sara Tindall is Project Manager for the Technology-Assisted Lifelong learning unit, based at the Department for Continuing Education.

This do: talk is for anyone who manages projects, events or research collaborations that involve getting a number of people to work together to reach a goal.

Speaker: Sara Tindall
—–
17 February 2015

Posted in Spring 2015 | Comments Off on do: Win friends and influence people using Microsoft Project

do: Fifteen favourite functions – making Excel easier

In Excel you’ll soon discover the power of a well-chosen function. The problem is there are so many it’s hard to know what might be useful. This talk takes 15 favourites of mine and shows you how to use them alone and in combination to simplify formulas and solve some tricky spreadsheet problems.

  • Is INDEX a MATCH for VLOOKUP?
  • Does COUNT always count?
  • What can you FIND with LEN?
  • Could that formula be IFfy?
  • Will you be CONVERTed?

Speaker: Duncan Young
—–
Download the spreadsheet with examples
23 February 2015

Posted in Spring 2015 | Comments Off on do: Fifteen favourite functions – making Excel easier

do: SharePoint an administration and collaboration workspace

Sharepoint is a powerful tool that can help you organise and share information, has granular security and is accessible from anywhere.

This  do: talk is for anyone who needs to share information and wants to spend less time on admin.

Speaker: Sean Nightingale
—–
Watch the recorded talk
24 February 2015

Posted in Spring 2015 | Comments Off on do: SharePoint an administration and collaboration workspace

do: Running committees with SharePoint

Committees at the University of Oxford can be simple, or very complex beasts.

This do: talk introduces the idea of using SharePoint to help manage those committees. It will interest anyone who looks after a committee or working group, who wants to spend less time on admin.

You may wish to try to ‘go paperless’ and have everything available from one web page. You may wish to keep a check on versions of a document that the committee is working on. Or to work on some documents for the committee, only releasing them for everyone on the committee to read when they are ‘published’. As part of the SharePoint Best Practices project a site template was produced for managing committees and distributing the documents. It has recently been improved further.

Speaker: Mark Norman
—–
Watch the recorded talk
2 March 2015

Posted in Spring 2015 | Comments Off on do: Running committees with SharePoint

do: Chorus in action

Chorus is the University of Oxford’s new unified communications service. It will replace existing telephony systems in a phased approach by 2017 and offer new ways for people across the University to work better together.

We apologise that this event has been cancelled.

Posted in Spring 2015 | Comments Off on do: Chorus in action

do: Backing up your data to the HFS

Do you have data that you don’t want to lose? You can keep it safe with the HFS, IT Services’ Backup and Archive service. You can back up work-related data currently on your machine; or, if you have data that’s of long-term value to the University, you can archive it, and we will keep it for you.

This do: talk will interest anyone who has work-related data that they don’t want to lose.

Speaker: Jason Zerdin
—–
Watch the recorded talk 
10 March 2015

Posted in Spring 2015 | Comments Off on do: Backing up your data to the HFS

do: Me, myself and IT: solving business problems with IT, a case study

The Exams and Assessments team have been using IT to tackle various administrative problems.

This do: session will be a case study of some of the things they have been working on and the systems used to tackle the business problems, namely Sharepoint and Microsoft Access. The talk will suit anyone interested in making use of Sharepoint or other systems in their business.

Speaker: Gavin Taylor
—–
Watch the recorded talk   w 
11 March 2015

Posted in Spring 2015 | Comments Off on do: Me, myself and IT: solving business problems with IT, a case study

do: Code with your kids

This do: session explores what computer programming is all about, why it’s fun to learn and what free software is available to help get started.
It also explains how parents can support the new computing curriculum. No knowledge of coding is required and no technical jargon will be used!

This brief introduction to learning what coding is and how it’s done will be especially interesting for parents who get asked by their children to help with the new computing curriculum. It’s also a good starting point for anyone who thinks they might be interested in learning what coding is all about and why it might be fun to learn.

Speaker: Steve Albury
—–
Watch the recorded talk   w 
17 March 2015

Posted in Spring 2015 | Comments Off on do: Code with your kids

do: Using WebLearn to reduce the burden of administering a course

Although WebLearn is useful for teaching and learning, did you know that it also has tools which can help with the administrative burden, so you can become more effective and efficient?
This do: session will focus on these WebLearn tools: Surveys, Sign-up, Calendar, Announcements and Email Archives. The talk will be relevant and useful for administrators and researchers.

Speaker: Fawei Geng
——
Watch the recorded talk 
18 March 2015

Posted in Spring 2015 | Comments Off on do: Using WebLearn to reduce the burden of administering a course

do: Lunchtime talks 2014

—————————————————————–————————————————————————————————————————————————-
do: is a series of lunch time talks that highlight the use of IT technology in support of business systems and processes in the University.

The talks that were given in the Spring 2014 season are described below.

If you could be interested in doing a do: or if you have an idea for a talk that would be useful – contact us.

do02“do-do, dee-doo”do03

Posted in Spring 2014 | Comments Off on do: Lunchtime talks 2014

do: An Excel adventure in dates and times

Why is Easter late this year? This do: talk is for anybody who uses dates and times in their Excel work. We will explore functions, formulas and formats that are under-appreciated, or even hidden.

Learn how to work with dates and times, including calculations that work on dates. Understand how Excel formats dates, and explore some interesting formats. And, after all, find out how to calculate the date when Easter will fall.

Duncan Young has been a member of the University’s Financials Training Team since 2006 and gave his first Excel course in 1993. Since then he has given countless courses in all aspects of Excel, including installation and programming, and was part of the team which wrote and delivered Microsoft’s internal helpdesk training for Excel 2002.

———-

Duncan Young, who gave this talk, says this:

The book I held up was “Excel Formulas” by John Walkenbach. Below is the Excel 2010 version, but obviously people should buy whichever one is appropriate to their version:
http://www.amazon.co.uk/Excel-2010-Formulas-Spreadsheets-Bookshelf/dp/0470475366/ref=la_B000APG96Y_1_7?s=books&ie=UTF8&qid=1394810723&sr=1-7

Look at the slides from this talk:
Do talk Duncan Young Excel Adventure 2014-03

Try out the workbooks with formulas from this talk:
Do Talk Duncan Young Excel Workbooks Formulas

Posted in Spring 2014 | Comments Off on do: An Excel adventure in dates and times

do: The Zen of Visual Analytics in a Big Data World

Come and find out how we can leverage the ‘Cycle of Visual Analysis’ to find a needle in the haystack of Big Data world. The human visual system is powerful, and when we add fast, intuitive interaction to this experience, we empower everyone to analyze and share data effectively.

You will hear about how academic organizations around the world have been leveraging the ‘Cycle of Visual Analysis’ to balance data, analysis and reporting requirements across the system.

Mrunal Shridhar is experienced in operational strategy consulting, with strengths in improving performance and efficiency across the supply chain. His fact-driven analytical approach helps people transform data into actionable information of decision-making quality.

———-
Look at the slides from this talk:

Do talk Tableau Mrunal Shridhar 2014-03

You can read more about the Tableau software, and set up a free 14-day trial at www.tableausoftware.com

Posted in Spring 2014 | Comments Off on do: The Zen of Visual Analytics in a Big Data World

do: Soothing course admin headaches with SharePoint

Running an academic or training programme can mean grappling with several systems, lots of spreadsheets and, as a consequence, endless version control issues.

This do: talk will consider how to run the administrative side of a programme in SharePoint, to make things more efficient and to help provide students and course participants with useful sources of clear, current information. It will interest anyone who wants to run an academic or training programme more smoothly.

You will hear about using SharePoint to run a programme more efficiently, maintaining good communications and hosting resources.

———-
John Miles invites anyone who is interested to visit the Humanities training site in SharePoint, to see what they have set up:

https://sharepoint.nexus.ox.ac.uk/training

Posted in Spring 2014 | Comments Off on do: Soothing course admin headaches with SharePoint