Intern & GA Projects

Weekly Schedule Form : Document from Burke Library to help organize work schedules.

Intern Projects

Spring 2009 Intern

Michael Bender

PROJECT: Identification and resolution of “lost” book, Part I

Searching for lost books in the Butler Stacks

Guidelines to Identify Mis-shelved ReCAP Items : Procedure for processing report of mis-shelving candidates. Reports in Spring 2009 did not exclude current in-transit or Reserve material.
Butler Stacks List : List of all Butler owned offsite titles. Results show that 25.6% were in-transit (currently IN at ReCAP); 44.1% are currently on Reserve; Of remainder 30.6% were potentially mis-shelved.

Sampled non-Butler owning locations for mis-shelving in Butler Stacks.

Lehman/Journalism Request survey: shows that 50% of requests from owning collections are delivered to Butler.
Lehman/Journalism List: 59.3% were found on shelves in Butler; 6.3% were found on Lehman/Journalism shelves. Initial conclusion that mis-shelving is more likely to occur at high-volume circ desk.

Avery Library Orphan Offsite Barcodes

Project targeted barcodes IN at ReCAP but not present in Voyager. Sample taken of Avery Library smart barcodes.
Flowchart for processing orphaned barcodes.
118 barcodes resolved with help from Avery Staff.

Music Library Leftover Smart Barcodes

see Music Library Project website: Intern helped in early stages of project planning and documentation.

Summer 2009 Intern

Bruce Koehler

PROJECT: Identification and resolution of “lost” book, Part II

Project Outline
Quick Notes

Project Documentation:

Guidelines to Identify Mis-shelved ReCAP Items

Copy Cataloging:

Copy Cataloging Instructions: Training for Voyager record structure involved simple copy cataloging practice. Intern helped process recently donated science fiction literature collection. All titles prepare for immediate transfer to ReCAP. [Work performed on sci-fi collection donated by Columbia University Science Fiction Society]

Fall 2009/Spring 2010 Intern

Stephen Zweibel (sz2304, rcpint2), Nov.09-Jan.10

PROJECT: Documentation and resolution of "orphan barcodes"

Project Journal
Flowchart [DRAFT] for Processing Orphan barcodes
Multiple Holdings Worksheet
Orphan Barcodes: Executive Summary [DRAFT]
Orphan Barcodes: Instructional Documentation [DRAFT]

Reference:

ReCAP Request Forms : Access to staff mechanisms for request.
Smart Barcoding : Definition and history of use at CUL
Accession Reports : How problems from weekly accession reports are resolved
Outline of ReCAP Accession : Simplified model of the process of accession at ReCAP, 10/21/08

GA Projects

Spring 2009 GA

SRL, Mar.09-May09

PROJECT: Systematic and ad hoc resolution of ReCAP problems at various department libraries

Music Library Project to resolve leftover smart barcodes, other items slated for removal and inventory special collections planned for transfer.

Music Project website: Outline and operational documents for project.

Summer 2009 GA

SRL, June09-Aug.09

PROJECT: Systematic and ad hoc resolution of ReCAP problems at various department libraries

Music Library Project: continuation of work from Spring 2009. Completed tasks:

Leftover barcode resolution (CU- and MR-prefix)
MUSMSBC001 status patron
Reference inventory
Case Collection inventory
elimination of CLIO location "mus,anx2"

Fall 2009 GA

SRL (garecap1), Sep.09-Dec.09

MAIN PROJECT: Systematic and ad hoc resolution of ReCAP problems at various department libraries

MATOB search in Butler Library. Search, transfer and resolution of items charged to missing at time of barcoing status patrons.

Outline and General Instructions: Project introduction, notes and general outline of procedure.
Processing flowchart: Detailed decision tree for resolving items found on shelf.
Statistics: Record of OTFs deleted, total number suppressed and general stats.

Secondary Projects:

Copy Cataloging Instructions: Titles prepared for a) immediate transfer to ReCAP or b) withdrawal. [Worked performed on sci-fi collection donated by Columbia University Science Fiction Society]

Spring 2010 Intern

Samantha Manoff (UNI: sm3296, Voyager: rcpint1) Feb.10-May 10

MAIN PROJECT: Resolution of Avery Library leftover smart barcodes

Avery Barcode Flowchart, Worksheet and Instructions: Processing documentation for resolving Avery Library leftover smart barocdes.

Secondary Projects:

Copy Cataloging Instructions: Training for Voyager record structure involved simple copy cataloging practice.

Reference

Smart Barcoding : Definition and history of use at CUL

Spring 2010 Intern

Ahmed Haggag (UNI: ah2866, Voyager: rcpint2), Feb.10-May 10

MAIN PROJECT: Documentation and resolution of "orphan barcodes"

Flowchart [DRAFT] for Processing Orphan barcodes
Multiple Holdings Worksheet
Orphan Barcodes: Executive Summary [DRAFT]

Secondary Projects:

Copy Cataloging Instructions: Training for Voyager record structure involved simple copy cataloging practice.

Reference:

ReCAP Website : Main, staff-side site for ReCAP related matters
Smart Barcoding : Definition and history of use at CUL
Customer Code : General outline of customer code at ReCAP and how it relates to CUL encoding.
LAS Database : Access to the ReCAP (LAS) Database
CLIO Location Guides : Off-site CLIO locations only and complete list of all CLIO locations

Summer/Fall 2010 Intern

Stephen Zweibel (sz2304, rcpint2), May 10-Aug.10

PROJECT: Data Analysis

Presentations

Circulation Data : Most recent draft (7/14/10)
Circ Data Tables and Charts : Raw data and charts supporting the Circ Data ppt presentation
xxx4off : Analysis of charges to CLIO location format "xxx4off." Items are given this location in preparation for transfer to ReCAP. From FY07-FY10 it denotes primarily new acquisitions transferred directly to Offsite.

Reference:

Data Center, Circulation : Full information on data sets and categories with relevant links.
Walkenbach, John. Excel 2003 Bible. Wiley, 2003.
Circ Stats : Monthly files of Voyager circulation data
ReCAP Appendix : Reference guide to CUL encoding

Data Sets:

Circulation: Entire data set is too large to manipulate in Excel 2003. Data must be summarized.

Circ1 : All charges summed by patron group (CLIO locations not itemized)
Circ2 : All charges summed by CLIO location (patron group not itemized)
Circ3 : All charges summed by CLIO location (happening location not itemized)

Fall 2010 GA

DWL (rcpint1), Sept. 10

Resolve Item Status problems
Begin training for East Asian Orphan Barcode project
Copy Cataloging Instructions: Titles prepared for a) immediate transfer to ReCAP or b) withdrawal. [Worked performed on sci-fi collection donated by Columbia University Science Fiction Society]

Spring 2011 GA

DWL (garecap1), Jan.11, JJM (garecap4), Mar.11

East Asian Orphan Barcode project: Resolve unlinked barcodes that have been accessioned at ReCAP but not entered in Voyager
Copy Cataloging Instructions: Titles prepared for a) immediate transfer to ReCAP or b) withdrawal. [Worked performed on sci-fi collection donated by Columbia University Science Fiction Society]

KHD (garecap2), Feb.11

Data analysis
Copy Cataloging Instructions: Titles prepared for a) immediate transfer to ReCAP or b) withdrawal. [Worked performed on sci-fi collection donated by Columbia University Science Fiction Society]

WK (garecap3), Feb.11

Epstean half card project: Copy cataloging approx. 150 titles for RBML
Copy Cataloging Instructions: Titles prepared for a) immediate transfer to ReCAP or b) withdrawal. [Worked performed on sci-fi collection donated by Columbia University Science Fiction Society]

ReCAP User Inquiry Alias: recap@library.columbia.edu

Supervisor, ReCAP Access Services: Jennifer Loubriel

Phone: (212) 854-3542

E-mail: jll2223@columbia.edu