Bateup, Sarah

Walker, Daniel

English

It sometimes seems as though Libraries view Google as some sort of Evil Overlord trying to take over our world. Who knows, perhaps they are, but until the dark clouds begin to converge and swirl around their headquarters we should relish the chance to take advantage of Google’s free online tools.Bond Library have been utilising Google Forms in a number of ways to enhance our services. All that is required is a Gmail address, a little bit of time and a healthy dose of creativity and imagination to create fast, free, user friendly content that will automatically timestamp and collate results in a spreadsheet.In this session we will run through and showcase a few of the ways Bond University Library services have been using Google Forms in the library, such as to:- Run interactive orientation games- Record service desk statistics- Create quizzes for use in library classes/sessions- Use as an online booking formFollowed by a real time demonstration on how quickly and easily you can create and share a working Google Form

Bond University Research Portal

Bond UniversityResearch RepositoryFast, Free and Easy: Taking Advantage of Google Forms to Enhance Library ServicesBateup, Sarah; Walker, DanielPublished: 26/10/2016Document Version:Peer reviewed versionLink to publication in Bond University research repository.Recommended citation(APA):Bateup, S., & Walker, D. (2016). Fast, Free and Easy: Taking Advantage of Google Forms to Enhance LibraryServices. 2016 ALIA Qld Mini Conference, Brisbane, Australia.General rightsCopyright and moral rights for the publications made accessible in the public portal are retained by the authors and/or other copyright ownersand it is a condition of accessing publications that users recognise and abide by the legal requirements associated with these rights.For more information, or if you believe that this document breaches copyright, please contact the Bond University research repositorycoordinator.Download date: 10 May 2019INSTRUCTIONS1/ 2/ 3/ 4/ 5/ 6/	7/ 8/ 9/  Clean up your columns and make sure that there’s only one type of data per column, e.g. only dates in the column, or only names of products. Make sure each column has a heading. Select every cell in the table by pressing Ctrl + A.  Create a table by pressing Ctrl + T – make sure to have the box my table has headings checked. Put the curser in any cell of the table, choose the Table design tab at the top ribbon, and select Pivot table from the far left.	Leave	the	first	radio	button	checked	and	chose	New worksheet to have the pivot table placed on a new sheet within your excel workbook. Drag categories from the top box of your pivot table menu into either the column or row boxes below and then choose a category you want to see the data for and drag it into the values box. Now you have a table created with just a few elements, select the table and go insert and choose a type of graph. Try a few graphs to see how the data makes the most sense. To create a new pivot table remove the categories out of the column, row and	values	field	boxes	in	the	pivot	menu	by	simply	dragging	them	out.ACTIVITY	Try	adding	different	categories	to	the	column,	row	and	values	boxes to see how they go together.alia qld mini conference: library hacks | 2016Fast, Free and Easy: Taking Advantage of Google Forms to Enhance Library Services

Fast, Free and Easy: Taking Advantage of Google Forms to Enhance Library Services

https://pure.bond.edu.au/ws/files/29458733/ALIA_Mini_Conference_2016_Handout_Walker_Dern_Bond_University.pdf

Fast, Free and Easy: Taking Advantage of Google Forms to Enhance Library Services

Abstract

Similar works

Full text

Available Versions

Bond University Research Portal