Using Texas Public Library Statistics for Reports and Presentations - - PowerPoint PPT Presentation

▶
using texas public library statistics for reports and
SMART_READER_LITE
LIVE PREVIEW

Using Texas Public Library Statistics for Reports and Presentations - - PowerPoint PPT Presentation

Mar 11, 2024 537 likes •1.24k views

Using Texas Public Library Statistics for Reports and Presentations Valicia Greenwood, Library Statistics Specialist Stacey Malek, LSTA/Accreditation Program Coordinator Texas State Library and Archives Commission Library Development and

slide-1
SLIDE 1

Valicia Greenwood, Library Statistics Specialist Stacey Malek, LSTA/Accreditation Program Coordinator

Texas State Library and Archives Commission

Library Development and Networking Division Fall 2019

Using Texas Public Library Statistics for Reports and Presentations

slide-2
SLIDE 2

Today’s Plan

Identify the audience Survey of available data Quick reports Create custom reports Add graphics

2

slide-3
SLIDE 3

Take the data of your life and turn it into real people doing real things. – Dave Lieber

Purpose

3

Dave Lieber: The Power of Storytelling in Business TEDxSMU 2013, https://youtu.be/Xig_r8eKfeM

slide-4
SLIDE 4

WHO’S LISTENING?

Identify the audience

4

slide-5
SLIDE 5

Library Stakeholders

Government Library Business Internal Governing Entity Library Staff Local Non-profits External Schools Community Employers

5

adapted from Academic Library Value: The Impact Starter Kit by Megan Oakleaf, published by ALA in 2017

slide-6
SLIDE 6

Stakeholder Priorities

6

Challenges Goals Participation Partnerships Communication

slide-7
SLIDE 7

WHAT’S AVAILABLE?

Use the statistics

7

slide-8
SLIDE 8

National Data Sources

8

slide-9
SLIDE 9

9

National Public Library Data Collection

slide-10
SLIDE 10

IMLS Library Search & Compare

10

slide-11
SLIDE 11

National Association of Counties

11

slide-12
SLIDE 12

National Association of Counties

12

slide-13
SLIDE 13

Texas-Based Information

13

slide-14
SLIDE 14

Texas Municipal League

14

slide-15
SLIDE 15

Edge Assessment

15

Provides tool which aligns technology to community priorities. Guides libraries to set goals for digital inclusion National coalition of libraries, local government and non-profits. TSLAC goal: 100% Texas Public Library participation

http://www.libraryedge.org/

slide-16
SLIDE 16

Edge 2.0

16

slide-17
SLIDE 17

Why?

“If you can point to the data, it drives a much better story…Data changes how cities function and make decisions for the future.”

  • -Brooks Rainwater, Senior Executive and Director,

National League of Cities’ Center for City Solutions

17

slide-18
SLIDE 18

QUICK AND EASY REPORTS

Using the statistics

18

slide-19
SLIDE 19

https://www.tsl.texas.gov/ldn/statistics

www.tsl.texas.gov |Services for Libraries |Accreditation and Statistics

Texas Public Library Statistics

slide-20
SLIDE 20

2018 Individual Library Statistics and Comparison Charts 2018-All (Texas LibPAS) Statistics from all reporting libraries 2018-Br (Texas LibPAS) Branch statistics only

Texas Local Public Library Statistics

Texas Public Library Statistics

Texas Public Library Five Year Trend Charts individual library trends 2013-2018

slide-21
SLIDE 21

Texas Public Library Comparison Charts

slide-22
SLIDE 22

Comparison Charts: Select Library City

slide-23
SLIDE 23

Comparison Charts: Select Report Type

slide-24
SLIDE 24

Individual Library Quick Report

slide-25
SLIDE 25

Individual Library Graphs

slide-26
SLIDE 26

Comparison Charts: Select Comparison Library Cities

slide-27
SLIDE 27

Library Comparison Charts

slide-28
SLIDE 28

Five-Year Trends

28

slide-29
SLIDE 29

Texas LibPAS

Data collection portal for the Texas Public Libraries Annual Report

https://tx.countingopinions.com/

slide-30
SLIDE 30

Texas LibPAS Report Tab

slide-31
SLIDE 31

Manage Reports – Texas Tab

slide-32
SLIDE 32

Manage Reports – Texas Tab

slide-33
SLIDE 33

Merge Documents: Library Snapshot

slide-34
SLIDE 34

Merge Documents: Library Snapshot

slide-35
SLIDE 35

Merge Documents: Two-Year Comparison

slide-36
SLIDE 36

Why?

Injecting hard numbers into your story will raise the stakes and bring your call to action into clearer focus. – Kate Harrison

36

slide-37
SLIDE 37
slide-38
SLIDE 38

CREATING CUSTOM REPORTS

Step-by-Step in Texas LibPAS and Excel

38

slide-39
SLIDE 39

Texas LibPAS Manage Reports

slide-40
SLIDE 40

Report Templates

40

slide-41
SLIDE 41

Table

slide-42
SLIDE 42

Trend

slide-43
SLIDE 43

Period Comparison

slide-44
SLIDE 44

To Create a Texas LibPAS Report

  • 1. Add Report
  • 2. Select Collection
  • 3. Title Report
  • 4. Select Report Folder
  • 5. Select Report Type
slide-45
SLIDE 45
  • 6. Select Questions
  • 7. Save Report
  • 8. Filter for Library
  • 9. Run

To Create a Texas LibPAS Report Modify (repeat 6-9) Publish (if desired)

slide-46
SLIDE 46
  • 1. Add Report
slide-47
SLIDE 47
  • 2. Select collection

Collection: Texas Public Libraries Annual Report

  • 3. Title Report
slide-48
SLIDE 48
  • 4. Select folder
slide-49
SLIDE 49
  • 5. Select Report Type

 Table report  Trend report  Period comparison  Other report

slide-50
SLIDE 50
  • 6. Select questions
slide-51
SLIDE 51
  • 7. SAVE report!
slide-52
SLIDE 52
  • 8. Filter for Libraries
slide-53
SLIDE 53
  • 8. Filter for Libraries
slide-54
SLIDE 54
  • 9. Run Report

Modify Report (go back to step 6) SAVE THE REPORT!

slide-55
SLIDE 55

Publish

slide-56
SLIDE 56
slide-57
SLIDE 57

Microsoft Excel

57

slide-58
SLIDE 58

Microsoft Excel

Select the data you wish to display.

58

slide-59
SLIDE 59

Insert Chart Type Selection

59

slide-60
SLIDE 60

Design and Format Tabs

Add Chart Elements Change Data Chart type

60

Fonts Colors Outlines Shapes

slide-61
SLIDE 61

61

Under 5,000 31% 5,001-10,000 21% 10,001-25,000 21% 25,001-50,000 12% 50,001-100,000 6% 100,001-200,000 5% 200,001-500,000 2% Over 500,001 2%

Texas Public Libraries by Population

Customize for emphasis

slide-62
SLIDE 62

MAKE IT COMPELLING

Add color and drama

62

slide-63
SLIDE 63

Conversation Starter

Used with permission. https://tocker.org/

slide-64
SLIDE 64

64

http://chambers.lib.tx.us/annual-report

Used with permission.

Communicate to Patrons

slide-65
SLIDE 65

65

https://www.bcslibrary.org/annual-reports/

Used with permission.

Show Value

slide-66
SLIDE 66

Identify Trends

slide-67
SLIDE 67
slide-68
SLIDE 68

Inspiration

We all have something we think is impossible,…but truly nothing is unattainable if we just swallow

  • ur excuses and do it.

–Katie Spotz, youngest person to row across

the Atlantic Ocean (2010, age 22)

68

slide-69
SLIDE 69

69

Thank you!

Library Development & Networking accreditation@tsl.texas.gov, 800-252-9386

Accreditation & Statistics

Stacey Malek, Accreditation Program Coordinator smalek@tsl.texas.gov, 512-463-5532 Valicia Greenwood, Library Statistics Specialist vgreenwood@tsl.texas.gov, 512-463-5466