Archive

Archive for the ‘service-is-library’ Category

LRC assistant responsibilities: A checklist (on reception desk next to your screen)


For larger view, click “Full screen”windows in lower right corner. Mote that the sheet with LRC assistant responsibilities is handily posted right under your screen at your work station – refer to it as needed,

reception-desk-responsibilities

How not to book LRC equipment: Avoid scheduling conflicts by not using “Show times as free”

2011/10/18 1 comment
      1. Appointments and Meeting requests default to “Show time as busy”. owa-calendar-appointment-show-time-as-busy-avoids-scheduling-conflicts
      2. Before you change this, like so: owa-calendar-appointment-show-time-as-free-leads-to-scheduling-conflicts-use-busy-instead. Note this “Gotcha”: “If you have already specified that this is an all day event, Save As is set automatically to Free “.
      3. consider this: a scheduling conflict can easily result, if people coming after you cannot see the resource as “busy”, they might inadvertently book over your booking: owa-calendar-appointment-show-time-as-free-leads-to-scheduling-conflicts
      4. Remember this is a platform for collaboration, not for spreading confusion: If you leave your appointment as “busy”, per the default, voilà, others can see that the resource is busy, and work around it: owa-calendar-appointment-show-time-as-free-leads-to-scheduling-conflicts-use-busy-instead-prevents-conflicts

Film-and-media-collection.xlsx online database under construction

2011/10/13 1 comment

Sneak preview (larger view here) of the searchable online database with internet background information lookup (Note: work in progress, hard-“head” area!):

Friends of the UNCC-LRC can open this link in Excel-web-app (in your web browser, internet explorer or Firefox): https://skydrive.live.com/edit.aspx?cid=0025C841818181C2&resid=25C841818181C2%21164

More than one LRC assistant can edit the sheet at the same time, just not the same cell. so: if there is more than 1 lab assistant on duty, the one whose first name is closer to the end of the alphabet starts from the bottom row of the spreadsheet and works her way up

Click on the link “try UPC lookup”,

On the page that opens, if there is a picture of the movie with “buy from amazon”, right click on the link to amazon.com, select “copy shortcut”, and paste the shortcut into the column “buy from amazon”

Find the original movie title on the page, copy it into spreadsheet  column “UPC title original”,

If there is title English translation, copy it into “UPC title English translation”

Click on link “try worldcat”,  do the same as above with the spreadsheet columns “ISBN title original” and “translation”,

How to set up your laptop to use with the LRC portable Projector

  1. re LCD projector
    1. First, book the projector from this list of bookable items (manual included). 
    2. Here is what we have as Projector: CIMG0016<
    3. connect the VGA-adapter which is in the package: CIMG0017 
    4. CIMG0018 (if your laptop does not have a secondary VGA connector, you may need to bring an adapter).
    5. power the projector on: CIMG0019 (also always power it off using the power button; never just pull the power plug).
  2. on your laptop:
    1. find the key combination to enable the secondary output
    2. CIMG0037CIMG0038
    3. right-click the windows desktop, access the graphics card settings; CIMG0041
    4. Enable the graphics card to send a video signal to the projector you just connected.  CIMG0040. I the projector native resolution is not automatically recognized, it is 1024*768.
  3. If you want to show a slideshow on the projector, go to PowerPoint 
    1. ribbon, (1) Slide Show/ item: (2)) set up show, and bring up the (3) set up show dialogue  CIMG0042
    2. here you can configure to show on monitor 2 (numbers correspond toe the numbers 1 and 2 in the graphics card dialogue above): CIMG0044. Same principle as with other dual screen computers, like the teacher station in LRCCOED434.

How to get from our Film-collection.xlsx to in-depth bibliographic data on worldcat.org and upcdatabase.com

  1. To access more in-depth (and accurate, especially foreign language-wise) information about the films in our media collection that we can possibly maintain ourselves, we added the ISBN and UPC/EAN identifiers from the collection items to our new online film-collection list. This allows us to link collection items to
  2. worldcat.org,
    1. film-collection-isbn-worldcat
    2. The link is based on the item’s ISBN (barcode-scanning was rarely possible, thus checksum checking becomes mandatory).
  3. upcdatabase.com
    1. film-collection-upc-upcdatabase
    2. The link is based on the item’s UPC/EAN which do come with barcodes, but lookup resources leave things to be desired:
      1. http://www.upcdatabase.com/item/[upc # here]: yields some info for some items (newer DVDs which usually also have ISBNs?)
      2. http://gepir.gs1.org/v32/xx/gtin.aspx?Lang=en-US, on spot-checking, yields only “Trade Item Ownership”, but “no Trade Item Info”, and does not support GET operation.
  1. This links another isolated and non-professional language resource center media collection to the world of non-pseudo libraries,  where the power of crowdsourcing has long been known.
  2. The original plan – which will take more time to implement, especially since it can be automated only in a very limiting way – was to pull into the local collection spreadsheet accurate and multi-faceted bibliographic information, to prevent the common failures of even our usually basic item searches by title:
    1. foreign-language diacritics, given that non-foreign-language-librarians edited the local collection spreadsheet. This requires that foreign character input to be installed on the LRC help desk computers (done for Western) and that student assistant personnel can be trained (theoretically done – will need more practice)
    2. English translations: may provide a safety net for searches, short of automated flattening of all title diacritics.

How to validate an ISBN checksum with an MS-Excel formula

excel-inventory.xls-isbn-check-formula

 

(Sorry, no Excel option in the sourcecode formatter on WordPress)

LRC Outlook/Exchange 2010 Resource Calendaring: How LRC staff can group calendars in Outlook 2010

2011/09/28 1 comment
  1. You can save the currently loaded calendars as a preset or “group” from the ribbon in the calendar view of outlook 2010, like so: menu-calendar-group
  2. The group and its members will be added to your calendar tree, and you can load all members with one click, like so:tree-calendar-group
  3. Then you can create multiple presets which correspond to your typical workflows: E.g. when you do not have to check the availability of equivalent sets of equipment, you may want to have an easy overview of staffing in the LRC:   tree-calendar-group-rrooms staffing
  4. Note that – while we have to load individually the calendars of other mailboxes we own –, calendar groups we create in Outlook are automagically mirrored in OWA
    1. But the calendar names get lost in the process? And: the batch select checkbox is missing. And: only up to 5 calendars can be viewed in OWA simultaneously. And: OWA does not support overlay mode for calendars.): owa-tree-calendar-group
    2. It would be great if calendar groups, with the help of ActiveSync, even worked their way through to mobile devices, but apparently they do not: webos-exchange-calendars

How not to book LRC equipment: Scheduling conflicts

2011/09/23 3 comments
  1. Do not send a meeting request to an item for a time when the item has a prior meeting request.
  2. The tab: scheduling assistant within the meeting request you edit is there to tell you when items have prior meeting requests.
    1. scheduling-assistant-timelines-marked-no-yes
    2. A “blocked” timeline denotes a prior meeting request: The item has already been booked (solid block) or requested (hatched block) during the start and end time of your meeting. Do not crash their party.
    3.  “blank” timeline means “item is free”. Go ahead: You can request a meeting with this item between your start and end time.
    4. Once you have this overview, you can easily remove, by right-clicking on the resource, extra resources that you cannot book or could, but which you do not need: scheduling-assistant-remove-resource
  3. Once the university has mail-enabled your cloud-accounts on campus, we will have a computer decline such conflicting requests automatically, and force you to start over with a new meeting request. It will be still worth your while memorizing the above: You can save time and avoid disappointment.