{"id":8418,"date":"2023-05-01T19:00:44","date_gmt":"2023-05-01T19:00:44","guid":{"rendered":"https:\/\/studentwork.prattsi.org\/infoshow\/?p=8418"},"modified":"2023-05-10T20:39:57","modified_gmt":"2023-05-10T20:39:57","slug":"tracking-archival-collections-use-at-the-center-for-brooklyn-history","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infoshow\/2023\/tracking-archival-collections-use-at-the-center-for-brooklyn-history","title":{"rendered":"Tracking Archival Collections Use at the Center for Brooklyn History"},"content":{"rendered":"<p>As a fellow at the Center for Brooklyn History Othmer Library, I undertook a long-term project to record and analyze data from the call slips used to request archival materials.<\/p>\n\n\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\" style=\"grid-template-columns:36% auto\"><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"1920\" height=\"2560\" src=\"https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/image0-scaled.jpeg\" alt=\"\" class=\"wp-image-8656 size-full\" srcset=\"https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/image0-scaled.jpeg 1920w, https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/image0-225x300.jpeg 225w, https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/image0-768x1024.jpeg 768w, https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/image0-1152x1536.jpeg 1152w, https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/image0-1536x2048.jpeg 1536w, https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/image0-973x1297.jpeg 973w, https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/image0-508x677.jpeg 508w\" sizes=\"auto, (max-width: 1920px) 100vw, 1920px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<p>First, I created a spreadsheet and entered the appointment date, collection name &amp; call number, box number and pull date from over 1,000 paper call slips, creating a dataset that represented over a year of patron research activities at the CBH library. Using what I was learning in my Programming for Cultural Heritage course at Pratt, I then wrote a Python script to analyze the data and create smaller data sets showing information about how much each collection was used and displaying patterns in patron behavior. I uploaded each cleaned-up dataset to Tableau, and created a set of visualization dashboards to serve as a final report for my colleagues.<\/p>\n\n\n\n<p><\/p>\n<\/div><\/div>\n\n\n\n<p>My goal is for the report to be a useful tool for CBH staff, especially because the institution, changing its official name from the Brooklyn Historical Society to the Center for Brookly History, was recently integrated into the Brooklyn Public Library system and is in a period of large-scale transition.<\/p>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"532\" src=\"https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/Screenshot-2023-05-04-163926-1024x532.png\" alt=\"\" class=\"wp-image-8668\" srcset=\"https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/Screenshot-2023-05-04-163926-1024x532.png 1024w, https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/Screenshot-2023-05-04-163926-300x156.png 300w, https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/Screenshot-2023-05-04-163926-768x399.png 768w, https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/Screenshot-2023-05-04-163926-1536x798.png 1536w, https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/Screenshot-2023-05-04-163926-973x505.png 973w, https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/Screenshot-2023-05-04-163926-508x264.png 508w, https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/Screenshot-2023-05-04-163926.png 1737w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"479\" src=\"https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/Screenshot-2023-05-04-164253-1024x479.png\" alt=\"\" class=\"wp-image-8669\" srcset=\"https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/Screenshot-2023-05-04-164253-1024x479.png 1024w, https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/Screenshot-2023-05-04-164253-300x140.png 300w, https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/Screenshot-2023-05-04-164253-768x359.png 768w, https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/Screenshot-2023-05-04-164253-1536x718.png 1536w, https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/Screenshot-2023-05-04-164253-973x455.png 973w, https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/Screenshot-2023-05-04-164253-508x238.png 508w, https:\/\/studentwork.prattsi.org\/infoshow\/wp-content\/uploads\/sites\/2\/Screenshot-2023-05-04-164253.png 1768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Above are screenshots of two of the visualizations I created in Tableau. To view all the visualizations in interactive dashboards, visit the <a href=\"https:\/\/public.tableau.com\/views\/CBHCollectionsUse\/CollectionsInfoDashboard?:language=en-US&amp;:display_count=n&amp;:origin=viz_share_link\">workbook on Tableau Public<\/a>. <\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>To access the Python script I wrote to analyze the main spreadsheet containing entries for each call slip, visit <a href=\"https:\/\/github.com\/altheameer1\/cbh-call-slip-analysis\/\" target=\"_blank\" rel=\"noreferrer noopener\">my GitHub repository<\/a>. I wrote to multiple CSV files to create small datasets that could easily be translated into visualizations.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.canva.com\/design\/DAFih-2dzAs\/58AXFbka4fsVldVL1j29Xw\/edit?utm_content=DAFih-2dzAs&amp;utm_campaign=designshare&amp;utm_medium=link2&amp;utm_source=sharebutton\">Link to presentation slides<\/a>. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>As a fellow at the Center for Brooklyn History Othmer Library, I undertook a long-term project to record and analyze data from the call slips used to request&#8230;<\/p>\n","protected":false},"author":4058,"featured_media":8643,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1036],"tags":[],"coauthors":[1052],"class_list":["post-8418","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-1036"],"_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/posts\/8418","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/users\/4058"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/comments?post=8418"}],"version-history":[{"count":17,"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/posts\/8418\/revisions"}],"predecessor-version":[{"id":9085,"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/posts\/8418\/revisions\/9085"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/media\/8643"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/media?parent=8418"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/categories?post=8418"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/tags?post=8418"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infoshow\/wp-json\/wp\/v2\/coauthors?post=8418"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}