Academic & Student Affairs

Creating Interactive Learning Resources Using Excel 2013

Creating Interactive Learning Resources Using Excel 2013

Event Description

Date:  24 February 2016

Time:  2.00 pm - 5.00 pm

Course Limit:  15

Content:

In this practical workshop staff will be introduced to some of the advanced features of Excel 2013 which can be used to create interactive spreadsheets suitable for simple quizzes or basic models.  Participants will be given the opportunity to try out some of the form tools available in Excel including Combo Boxes, Check Boxes, Spin Buttons and Option Buttons.  Practical exercises will also involve creating nested IF statements to generate feedback and how to format and protect worksheets in order to hide content.

 

 

 


Aims/Aimed at

Designed for:  Staff who would like to use Excel 2013 to develop interactive forms and quizzes to support students’ independent study.

 


Pre-requisites

This is an advanced Excel course therefore participants should have significant previous experience of using Excel 2013.

 

 


Booking Information

Registration is via Queen’s Online (In the navigation under My Services, select Other then Training Courses).


Booking URL: http://www.qub.ac.uk/qol
New Course: No
Course Type(s): Teaching and/or Supporting Student Learning
Staff Categories: Academic, Research
Keywords: Teaching, Student Learning, Interactive, Learning Resources, Excel 2013, Combo Boxes, Check Boxes, Spin Buttons, Option Buttons, nested IF statements, Format worksheets, Protect worksheets.

Course Contact Details

Name: Centre for Educational Development
Telephone: 028 9097 1447
Email: ced@qub.ac.uk