**Reference at the Metcalfe 2019**

**9 May 2019**


This seminar is a collaboration between the State Library of NSW and the NSW Reference and information working group.  


9.30 - 9.40 Welcome to State Library of NSW

9.40 - 10.50 Kate Adler and Ian Beilin, editors of Reference librarianship & justice: history, practice & praxis http://libraryjuicepress.com/reference-justice.php (the forward to this work can be read online https://scholarworks.iu.edu/dspace/handle/2022/22586)

{{youtube>WNwHDVcd0g4}}

You can follow on twitter @xsublibrarian @ibeilin #critlib

10.50 - 11.00 stand and stretch and discuss with those around you one idea from the first talk you will take back to your workplace

11.00 - 12.00 1 hour combined with Find legal answers, drug info and state wide databases – Kathleen Alexander, Catherine Bryant and Andrea Curr

You can follow on @DrugInfoLibsNSW @legalanswersnsw @nswnet 

{{youtube>O8bqsKrn8Z4}}

12.00  - 1.00 lunch in the Macquarie Room 

{{youtube>T3vDEMCTcIE}}

1.00 – 1.25 [[https://docs.google.com/presentation/d/1CpH1jQkDBbZ1TtdO8F8g5ruVjhm1mCQagt7oLI1HQls/edit?usp=sharing | Reference survey - issues and opportunities]] Reference steering committee @NSWRISG

[[https://www.sl.nsw.gov.au/sites/default/files/reference_and_information_services_survey_2018.pdf | Reference and information services group survey results]].

1.25 - 1.40 Michael Doran, Information and Customer Services Librarian, City of Parramatta Libraries Analysing customer enquiries as a pathway to service improvement

[[https://drive.google.com/file/d/1oTY3CSjWt2jbmZ3PczbSqnpqzszDNJGd/view?usp=sharing|presentation here]]

{{ :wiki:copy_of_customer_questions_-_blank.xlsx |Blank copy of form described in presentation}}

Excel with macros can not be loaded in this wiki.  Contact Michel directly for a copy of the spreadsheet with macros.

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
    With Target
        If Target.Count > 1 Then Exit Sub
        If .Cells.Count = 1 And .Column = 1 And .Value <> vbNullString Then
            With .Offset(0, 1)
                .Value = Val(.Text) + 1
            End With
        End If
    End With
End Sub


The question clicking functionality of the macro has been, a key component in making the spreadsheet usable, and achieving a reasonable level of compliance from staff already engaged in serving customers.

You can paste the question clicker macro into each of the 14 daily worksheets. Right click on each worksheet name and select 'View Code', then paste into the window which appears.



1.40 - 1.45 New public library wiki

1.45 – 2.05 Enquiry completion rate data. What the new forms are helping with and a request for state wide data – Ellen Forsyth

[[https://drive.google.com/file/d/1POWHLJyynfDAJRx6_xm9zcXs4kITjLac/view?usp=sharing|presentation here]]

2.05 – 2.45 ALIA TIK – Rob Thompson will talk about the truth, integrity, knowledge (TIK) campaign being run by ALIA @robthomson2528 

[[https://drive.google.com/file/d/1HBkQDQ665wlswU048yzGnCXKAtlE1NQM/view?usp=sharing|presentation here]]

2.50 - 3.00 stand and stretch and discuss with those around you one idea from the talks today you will take back to your workplace 


Note: the session by Luke Briscoe about Indigi Lab has been postponed because Luke is unwell.  This session will be presented by a videoconference at a time to be determined. 

This seminar is a collaboration between the State Library of NSW and the NSW Reference and information services working group.  

----
Back to [[reference_and_information_services_working_group|Reference and information services working group home page]]