Category Archives: Learning & Development

Finding Commands or Help in Microsoft Office Programs

Do you ever find that you simply cannot find the command you’re looking for in a program? Or need help on how to do something? 

Well, in Microsoft Office programs (such as Outlook, Word, Excel, PowerPoint, etc) there is an easy solution right within the program.

Within the program (eg, Microsoft Word), at the right hand end of the Ribbon Tabs, there is a field containing the text Tell me what you want to do…

This image shows the Help field in Word

 

  1. Click into the Tell me what you want to do… field
  2. Type in what you wish to do
    – The program will list commands relating to your query
  3. Select an option
    or select Get Help on…

 


For other great time-saving tips, look up:
Being more efficient with your technology
Technology Information for Staff website

Was this tip helpful to you? Anything else you want to know? Got some suggestions? Please leave a comment below or let me know.

You’ll find more learning at Learning and Development.

An Excel Formula to Avoid a #VALUE! Error

If you’re using Excel, this one may be for you.

In M15, you need a formula that multiplies quantity (in, let’s say,  K15) by price (in, let’s say,  L15), but the price column also contains text entries such as Out of stock.  So the formula K15*L15 is not satisfactory because when you multiply a number by a text value (such as “Out of stock”) you get the #VALUE! error.

You could use an IF function to check for text, but there is a shorter solution.

The N function has a single argument: a value. It returns the value if the value is a number, or 0 if the value is text.

So, in M15, use the formula =K15*N(L15).

Thanks to Able Owl Excel tips for this one.


For other great time-saving tips, look up:
Being more efficient with your technology
Technology Information for Staff website

Was this tip helpful to you? Anything else you want to know? Got some suggestions? Please leave a comment below or let me know.

You’ll find more learning at Learning and Development.

Under Pressure: Understanding assessment anxiety

Help your students cope with assessment-related anxiety with this new online resource by Dr Valerie Sotardi (College of Education, Health & Human Development | Te Rāngai Ako me te Hauora educational psychologist) and Associate Professor Erik Brogt (Learning Evaluation and Academic Development team).

First year students can be particularly vulnerable as they transition to university life, but help is at hand with new resources for students and teachers, funded by Ako Aotearoa, New Zealand’s Centre for Tertiary Teaching Excellence, and available on their website.

Top tips for teachers:
• Being familiar with NCEA content and structure
• Teaching for transfer of knowledge
• Setting clear expectations
• Communicating the purpose of an assessment
• Building student confidence
• Identifying a clear contact person for the course
• Creating a sense of belonging
• The learning environment matters
• Knowing the referral process

Read the full guide here: Mitigating Assessment Anxiety in First-Year University Students: A resource guide for teaching staff

Read the news story here>

Ngāi Tahu Research Centre Scholarships

Ngāi Tahu Research Centre, University of Canterbury postgraduate and doctoral scholarships

Three NTRC scholarships are offered annually to Doctoral students which are worth $21,000, plus fees, for three years.

The NTRC also offers five scholarships annually for Postgraduate Diploma, Honours and Master’s students. These scholarships are valued at $12,000 plus fees, for one year.

Scholarship recipients may be studying any discipline at the University of Canterbury, but preference will be given to applicants whose projects promote mātauranga Māori within the sciences, commerce, law or engineering and are linked to the mission and current research foci of the Ngāi Tahu Research Centre.

Subject matters of particular interest to the centre are:

  • Environmental sciences
  • Indigenous and tribal economies
  • 19th Century textual translations of rare South Island manuscripts

Applications are currently open and close at 4pm on 31 October.

Ngai Tahu Research Centre Postgraduate Scholarship

Description

This scholarship supports postgraduate diploma, honours, and master’s students at the University of Canterbury whose research is facilitated by the Ngāi Tahu Research Centre. Up to three scholarships are available annually for applicants of Ngāi Tahu descent. A further two scholarships are available annually to all students undertaking studies facilitated by the Ngāi Tahu Research Centre. The scholarship provides financial assistance to a value of $16,000 per 120 points of enrolment for scholarships reserved for those of Ngāi Tahu descent, and to a value of $12,000 per 120 points of enrolment for an open scholarship. The scholarship also covers full tuition fees for the specified programme of study, at the New Zealand domestic rate, and the Student Services Levy for the term of the scholarship.

Ngai Tahu Research Centre Doctoral Scholarship

Description

These scholarships support PhD students whose study is facilitated through the Ngāi Tahu Research Centre at the University of Canterbury. The University will make available up to three scholarships annually. Te Rūnanga o Ngāi Tahu will make available up to two scholarships every third year.

To download a copy of the scholarship regulations and to apply online please visit

https://www.canterbury.ac.nz/ntrc/scholarships/

To enquire please contact the Ngāi Tahu Research Centre Administrator, phone: +64 3 369 5527 or email: ntrc@canterbury.ac.nz

Pro-Vice-Chancellor of the College of Education, Health and Human Development

We have commissioned global recruitment firm, Fisher Leadership to assist in conducting an international recruitment search for the role of Pro-Vice-Chancellor of the Te Rāngai Ako me te Hauora | College of Education, Health and Human Development. If you would like to know more about the position it is currently being advertised on our Work at UC page on the internet>