using google sheets + google sites tocreate a … powerpoint...using google sheets + google sites...

USING GOOGLE SHEETS + GOOGLE SITES

TO CREATE A LIBRARY DATA DASHBOARD

LLAMA Webinar

Emily Guhde

Assessment Librarian

Georgetown University Library

September 7, 2016

NICE TO MEET YOU.

� Spring 2015 – Kick-off Library Assessment Program at Georgetown University Library

�Data everywhere, but could be cleaner

�Goal – Figure out what we are measuring, gathering, and reporting, and get it all organized

GEORGETOWN UNIVERSITY LIBRARY DATA DASHBOARD

IN TODAY’S WEBINAR . . .

�How Google Sheets + Sites works

�Overview of steps to build a data dash with Google Sheets + Google Sites

�Library examples (with live updates!)

�Step-by-step Google Sites creation

�Step-by-Step Google Sites access sharing

�Questions

HOW IT WORKS

BACK END � FRONT ENDGOOGLE SHEETS GOOGLE SITES

GOOGLE SHEETS: SPREADSHEETS THAT LIVE IN THE CLOUD

GOOGLE SHEETS: SPREADSHEETS THAT LIVE IN THE CLOUD

GOOGLE SHEETS: SPREADSHEETS THAT LIVE IN THE CLOUD

GOOGLE SHEETS: SPREADSHEETS THAT LIVE IN THE CLOUD

GOOGLE SHEETS: SPREADSHEETS WITH SYNCHRONOUS EDITING

GOOGLE SHEETS: SPREADSHEETS WITH SYNCHRONOUS EDITING

libdata.09022016 libdata.09022016.2

GOOGLE SHEETS: SPREADSHEETS WITH SYNCHRONOUS EDITING

libdata.09022016 libdata.09022016.2

Library_data_final Library_data_FINAL

GOOGLE SHEETS: SPREADSHEETS WITH SYNCHRONOUS EDITING

libdata.09022016 libdata.09022016.2

Library_data_final Library_data_FINAL

Library_data_blank Library_data_Law

GOOGLE SHEETS: SPREADSHEETS WITH SYNCHRONOUS EDITING

libdata.09022016 libdata.09022016.2

Library_data_final Library_data_FINAL

Library_data_blank Library_data_LawLibrary_data_Med

GOOGLE SHEETS: SPREADSHEETS WITH SYNCHRONOUS EDITING

libdata.09022016 libdata.09022016.2

Library_data_final Library_data_FINAL

Library_data_blank Library_data_LawLibrary_data_Med

Library_data_Bioethics

GOOGLE SHEETS: SPREADSHEETS WITH SYNCHRONOUS EDITING

libdata.09022016 libdata.09022016.2

Library_data_final Library_data_FINAL

Library_data_blank Library_data_LawLibrary_data_Med

Library_data_BioethicsLibrary_data_Law_revised

GOOGLE SHEETS: SPREADSHEETS WITH SYNCHRONOUS EDITING

libdata.09022016 libdata.09022016.2

Library_data_final Library_data_FINAL

Library_data_blank Library_data_LawLibrary_data_Med

Library_data_BioethicsLibrary_data_Law_revisedLibrary_data.gsheet

GOOGLE SHEETS: SPREADSHEETS WITH AN EXIT STRATEGY

GOOGLE SHEETS: SPREADSHEETS WITH AN EXIT STRATEGY

BACK END � FRONT ENDGOOGLE SHEETS GOOGLE SITES

GOOGLE SITES: BASIC WEBSITE TO SHOW OFF YOUR DATA

GOOGLE SITES: BASIC WEBSITE WITH ACCESS CONTROLS

GOOGLE SITES: BASIC WEBSITE WITH CUSTOM BRANDING

BACK END � FRONT ENDGOOGLE SHEETS GOOGLE SITES

FREE ~ BUILD OVER TIME ~ DATA VIZ + DATA ORG

FREE ~ BUILD OVER TIME ~ DATA VIZ + DATA ORG

FREE ~ BUILD OVER TIME ~ DATA VIZ + DATA ORG

LET’S GET REAL

NO BIG DATA AUTO-FEEDS ~ NO WOW-WORTHY FORMATTING ~ NO INTERACTIVITY

NO BIG DATA AUTO-FEEDS ~ NO WOW-WORTHY FORMATTING ~ NO INTERACTIVITY

NO BIG DATA AUTO-FEEDS ~ NO WOW-WORTHY FORMATTING ~ NO INTERACTIVITY

THE STEPS

STEP 1: BUILD YOUR GOOGLE SHEET

�Add data to Google Sheets

�Structure data set

�Create data visualizations

�Document sources

�Hide/show tabs

STEP 2: DESIGN YOUR GOOGLE SITE

�Pick a theme in Google Sites

�Work with your web developer

�Consider your audience

�Add pages (usually one page = one spreadsheet*)

*One spreadsheet can have multiple tabs

STEP 3: CONNECT SHEET TO SITE

�Insert a spreadsheet

�Adjust the frame size

�Modify display options (titles, sheet names, etc.)

�Add more data (if you want)

STEP 4: SHARE AND LIMIT ACCESS

�Share the underlying Sheet, and the Site

�Add individuals, Google Groups, or share publicly

�Let others edit, or just view

BUT WAIT, THERE’S MORE . . .

EXAMPLES

EXAMPLES

�Summer Reading Club - data gathering and aggregating across libraries or branches

�Library Departments - departmental data reporting and documentation

�Annual Data Reports - sharing peer library comparisons

LET’S TAKE IT FOR A SPIN . . .