Games Shelf-reading
Department
Circulation
Purpose
Ensures games are present and that the boxes contain the correct pieces.
Overview
It is important that we regularly confirm that we are getting games back from loan and that they contain the appropriate pieces.
Required Knowledge/Skills
Weighing items on a scale
Safety Issues/Precautions
N/A
Equipment/Supplies
Computer with FOLIO access, Games shelf reading spreadsheet and the games, themselves.
Procedure
Student Responsibilities
Find the games shelf-reading spreadsheet hanging from the games shelf.
a. If there is no spreadsheet, you will need to ask the manager on duty to print one. (See the “Printing out a new games shelf-reading spreadsheet” manager responsibility below.)
Grab any games that you will be shelf-reading for.
For each game:
a. Check the game in using FOLIO. A pop-up should appear with the correct weight for that game.
i. Make sure that the weight on the pop-up matches the weight label on the game.
ii. The weight label is generally placed on an inside box cover of the game.
b. Grab the scale from the media desk, and make sure the scale is set to measure grams using the appropriate button.
i. The button may be labeled “unit” or similar. Press it until the display on the scale shows grams as the measurement.
c. Weigh the game in grams using the scale.
d. Compare the weight from the scale with the weight listed on the game, and then:
i. If the weights are within 8-10 grams of one another:
The game can go back on the shelf.
Check that game off on the spreadsheet indicating that it has been checked.
ii. If the weights differ by more than 8-10 grams:
Write the difference on the spreadsheet.
Place the game on the missing pieces shelf in the media closet.
When you are done checking all the games for that shelf-reading session, email moecirc@valpo.edu a list of games that had weight differences of more than 8-10 grams. Each entry should contain:
a. The name of each game
b. The weight differential that you recorded on the spreadsheet
Manager Responsibilities
Printing out a new games shelf-reading spreadsheet
Generate List in FOLIO
Go to the Games list in FOLIO.
Click Actions in the top right corner and select Refresh List.
Click View Updated List in the info bar that pops up at the top of the screen.
Click Actions and select Export All Columns to download the CSV file.
Open the spreadsheet entitled “Games Shelf-Reading Spreadsheet” which is located at: S:\CCLS\Circulation & Media\Admin\Circ Student Work Folder
a. There will probably be pre-existing data in the sheet. You can ignore that.
Click the dark blue button that says “Import CSV Data” and browse to wherever you saved the csv file that you generated from Folio, choosing that file and hitting OK.
If this didn’t work for any reason, you will need to set up a new spreadsheet manually. See the procedure below entitled which details the manual procedure.
Manually configuring and printing out a new games shelf-reading spreadsheet (only if the above method doesn’t work for some reason)
When students begin shelf reading, they will need a manager to generate and print a new list of games:
Generate List in FOLIO
Go to the Games list in FOLIO.
Click Actions in the top right corner and select Refresh List.
Click View Updated List in the info bar that pops up at the top of the screen.
Click Actions and uncheck all fields except Instances-Resource title.
Click Actions and select Export Selected Columns to download the CSV file.
Open the CSV file in Excel and delete all columns other than Instances-Resource title.
Set Up the Spreadsheet (Excel)
Open the exported CSV file. Delete any extra columns, leaving only Instances-Resource title.
Rename the header Instances: Resource title to Name.
Add three new columns to the right:
i. Weight from Scale (g)
ii. Weight from Label (g)
iii. Notes (for missing games, missing labels, weight discrepancies, etc.)
Format & Sort Data
Sort: Alphabetically by Name (A to Z).
Font: Set all text to DM Sans, 12 pt.
Alignment: Center text both horizontally and vertically across all cells.
Borders: Enable borders on all sides for populated cells.
Row Height & Text: Select all rows, apply Wrap Text, and set Row Height to 20. Manually adjust height for multi-line entries if needed.
Print Settings
Layout: Landscape, Single-sided.
Margins: 0.25" on all sides.
Scaling: Fit all columns on one page.
For Stacks Manager: When students are done reading the entire games shelf
Determine which games are missing pieces.
Email the Stager Collection Committee and inquire about replacement of pieces or entire games.
If replacement is necessary:
a. The game should stay on the missing pieces shelf.
b. The stacks manager should update the spreadsheet to say AWAITING REPLACEMENT PIECES until the new pieces are acquired or the game is replaced entirely.
Games for which replacement is unnecessary will be weeded
a. Update the spreadsheet to remove the weeded item from future shelf-reading.