120 likes | 132 Views
Prepare a title list to send to Bibliographic Services. Open the Excel file, enter your school name, date, and box number. Record the titles and authors of the books. Note if the book is reference, professional, audio-visual, donation, or preview. Sort the list alphabetically and print it. Include a copy of the list in the first box if shipping multiple boxes.
E N D
In the top row Type your School Name, Date and Box # ABC Library 1 1/9/09
Leave the column Received blank and begin recording your first title and author book entry If the book is Reference, Professional or Audio Visual please note this in the Ref/Prof/AV column If the book is a Donation or Preview book please note this in the Donation/Prev column From tadpole to frog Slade, Suzanne Ref Don
Enter the titles that will be shipped to Bib Services found in this box
If you have more than 30 titles and need more lines for your list, left click and hold the bottom right hand corner (fill handle) of the last number cell (A30) and drag your mouse down to the required number needed If you type line numbers they will not appear in numerical order when the titles are sorted
You will need to sort the list when you are finished typing Highlight your list by left clicking the top left corner (A3) dragging your mouse to the lower right corner (in this case F11)
From the Data Selection choose Sort The “Sort by” should say Title – Ascending. Click OK
If you wish you can remove any additional numbered lines by highlighting them and hitting the delete button
You are now ready to begin printing. From the File selection choose Print Select your local printer and click OK
Your list is finished! Add to your box of titles and ship off to Bib Services
Please include an alphabetically title sorted list of books with each shipment you send If your list includes multiple box’s : Note this in the Box # area (top right corner) Box# 1-5 If the list covers multiple boxes you do not need place a copy of the list in each box. Please put the list in the first box #1 Thank you for your cooperation!