Exercise 11.5: Wrap Up


Congratulations!  We’re so proud of you for completing 11.5 COSAs Series 2.  It’s been a journey and we acknowledge your effort to carve out time from your busy schedules to learn and develop your skills.  Those skills are not only beneficial to you, through your evaluations and continued development, but also beneficial to our patrons who rely on our services every day.  Remember, to visit the Self Directed Learning LibGuide and to check the Trumba Staff Calendar to see what staff development classes are available.

Keep in mind the many technology changes the library has experienced in just a few years.  Every day, new opportunities to close the “digital divide” are presented, and public libraries are on the forefront – you’re on the forefront – of overcoming this challenge by providing a bridge over which more and more people can cross; and this happens due to your commitment to increasing your knowledge.  So: bravo to you.  If you feel a sense of pride and accomplishment, you deserve it.  Proudly display your badges; go ahead and introduce yourself as a “tech ninja,” or unabashedly tell people you’re “tech savvy;” however, before you charge off to conquer the digital world, please give us your feedback on your experience by completing this online survey and by reflecting on your learning by posting a few thoughts.

***(Please fill out, in order to receive your completion prize and badge).




Posted in Uncategorized

Exercise 1: Part 2 File Management-Dropbox

Source: Exercise 1: Part 2 File Management-Dropbox

Tagged with: ,
Posted in Uncategorized

11.5 COSAs Series 2 just around the corner!


Coming soon from SAPL 11.5 COSAs Training Committee!

The creators of 11.5 COSAs have worked hard this past year to create the second series – and it’s a bit more challenging. From feedback provided in the series one post survey, creators designed the second series to relate more to SAPL resources, including more SAPL databases, LibGuides, online mapping, coding and common network issues.

All SAPL employees are encouraged to learn and discover with this self-paced training program by participating.



11.5 Cosas is a self-paced, web-based learning program for SAPL library staff, created by SAPL library staff. It will help participants explore the potential of SAPL daily tasks for professional & personal learning. The program will run from January 30 through September 30, 2016.  Registration opens January 30th.



First thing is first, REGISTER your blog here. (You may use the same blog from the first series)

Come to one of our open workshops so that you may work alongside peers and get answers to your questions.

Join us in the 4th floor staff training room, sign up via Trumba.


**Every week, a new lesson will be posted.**

Next week Lesson 1 will be posted.

Tagged with: ,
Posted in Uncategorized

Exercise 1: File Management-Part 1

Objective: Learn about File Management

File Management 

Background- Did you complete the first series of 11.5 COSAs? If you filled out the completion survey and did all the COSAs correctly, you’re ready for Series 2.

You’ll need a USB drive for the upcoming Challenges; the one you earned for finishing the first series of 11.5 COSAs would work just fine.
An example of ‘downloading’ is transferring a file or data item from the Internet to your computer. When a file or data item is transferred from the Internet to your computer, this is a typical example of downloading. When a file is sent from your computer to the Internet, this is a typical example of uploading.

How to use a USB Flash Drive

A Flash Drive is a small drive that connects to a computer through a USB port. They are supported on all public machines, although some flash drives may require a user to install drivers before use. Flash drives can hold most types of data which may include Excel, JPEG, video, and text files. Flash drives are also commonly referred to as key drive, thumb drives, jump drives, USB drives and/or pen drives.

Copying files to a flash drive on a PC:

1. Open “Computer” and see which drives are shown. Most computers, for example, have a hard disk typically designated as  (C:) drive, and a few removable storage device such as a  (D:)CD-ROM drive, and perhaps an SD card.

2. Insert the flash drive into the USB port and watch to see where the USB flash drive appears. Most will appear as removable storage, but some will instead appear as hard drives. Note the name Windows is using to refer to the flash drive (“Removable Disk (E:),” for example).

3. Open “Documents” or the location in which the documents are currently stored such as your personal drive. Select the files or folders you want to save to the flash drive by left clicking on them. To select more than one, hold down the CTRL key while you click and select all of the files you wish to save.

4. Right-click on the file(s) or folder(s) you selected, then select Send to, then select the name of the USB drive you saw appearing in Computer for the flash drive (“Removable Disk (E:),” for example).

5. When the copying is finished, do not immediately remove the flash drive from the USB port. Instead, left-click on the Remove Hardware icon located in the System Tray. A window containing a list of USB devices will appear. Left-click on the Safely Remove Mass Storage Device line that matches your flash drive (for example, Safely Remove Mass Storage Device – Drive(E:))

System Tray


6. When you see the following message appear in the bottom left toolbar, it is, as it says: safe to remove the flash drive from the USB port. You may close the message or ignore it, as it will close itself automatically.



DID YOU KNOW- In Outlook you can preview attachments?

View Attachments

When you receive documents, spreadsheets or presentations as attachments in your email, you can view the contents of the attachment using the preview button.



Download Attachments

You can download the required attachments to your local system. When you have multiple attachments, you can download all the attachments as .ZIP file. Did you know that? Wait! What’s a .ZIP file? A computer file whose contents of one or more files are compressed for storage or transmission, often carrying the extension .ZIP.


ZIP is a popular archive format widely used on the Internet. Like other archives, ZIP files are data containers, ZIP files make it easy to keep related files together and make transporting, e-mailing, downloading and storing data and software faster and more efficient. After you downloaded a ZIP file, you need to unpack its contents in order to use it.

We will come back to this.


Tagged with: ,
Posted in Uncategorized

Exercise 1: Part 2 File Management-Dropbox


images (1)


What is Dropbox?

Dropbox is an online backup facility which stores your data on their servers using Cloud Storage (which we covered in the first series) so that you can share files with others using file synchronization. The concept of Dropbox is that you can simply access your files anywhere and they can be shared with others. All files you save in your Dropbox account will instantly reflect the same in your computer, Phone, iPad and device with Dropbox access.


How does it work?








Save the zip folder below to your USB and unzip the folder and it’s contents.

-Move the zip folder to your USB

-Right click on the zip folder.

-Extract or save the zip content to your USB.

-Open the PDF file

-Fill out the PDF Certificate and save to your USB as my_certificate.


blue folder

Click on the BLUE folder to access the zip.


Lastly, send your completed certificate to mysapl11.5@gmail.com




Tagged with: ,
Posted in Uncategorized

Exercise 1: Part 3 Trouble Shoot

There are times when you will come across questions from patrons that may stump you. But there are lots of little tips and tricks that can make your life easier! First, here is an excellent reference lib-guide that could help http://guides.mysapl.org/Pharos.



Printing Questions

“How do I Print?”

  • Seems very basic but is one of the most asked questions and can be answered simply by explaining to the customer that they will need to be logged on a computer in order to print from the internet. The best option is pressing the print icon or going into file tab and printing from there. Also make sure the customer knows that they have to continue answering all questions until they get a “successfully sent to print release station” message. They will then need to go to MFD and login in order to receive their prints. And make sure you tell the patron prior to printing that they need to add funds to their account.

When a customer wants to print out a file attached to their email they will have to download the file before they can print it out. (We are using Google Browser in this example below)


They can do this by clicking the download button in their email. An icon will appear at the bottom of the screen. Clicking on the icon will make your document appear with a tool box where you can print out your document.

“How do I print out a PDF file from my email?”

  • The first thing they should do is look for a download button or tab. By clicking this it actually downloads to the computer where they can view the file and print the file. If you print out from the view screen before downloading you may get blank pages printed out!


“It says to save as a PDF file when I press print?”

  • Sometime in April we were experiencing a glitch with printing from Google or Gmail. Every time you would print it will ask you to save to a PDF file. The fix for this was simply changing the destination to the printer set up screen.


  • Another problem was locating the patron’s flash drive after the new windows 7 update. To locate your flash you type in e: under file name and press enter. This will open your flash drive, then you can type in a name for the file and  click save. Some branches may use the d: drive instead. You can also open your flash drive by clicking on the icon on your desktop associated with your flash drive.





**Every week, a new lesson will be posted.**

Next week Lesson 2 will be posted.

"STOP"- Please complete this challenge.



Tagged with: ,
Posted in Uncategorized

Exercise 2: Online Safety and Privacy

How important is privacy? Some people are very open about sharing ideas, pictures, and information with people they know. As users, we expect shopping websites to be personalized to our tastes, yet are sometimes unaware what data is being tracked and shared. Watch this TED video on behavioral tracking called “Tracking the Trackers” by privacy advocate Gary Kovacs. While I encourage you to watch the whole video, at 2 minutes in, behavioral tracking is explained in disturbing detail.


Now that I have your attention, let’s look at the tools we do have to protect our online privacy and safety.

Passwords and Protection

Passwords can be challenging for a lot of our customers. New computer users may not understand why passwords need to be a complex series of letters, numbers, and symbols. They may even try to share their passwords with us!

Here’s some good reasons to make passwords complex and private

1) passwords are harder to guess or hack.

2) since personal data is increasingly online, it’s very important to keep it private and secure.

What is Phishing?

Phishing is the activity of defrauding an account holder of financial information (or other sensitive data) by posing as a legitimate company. Phishing can happen in email, by text, or other communications. It could even be a website posing as the legitimate one. An example would be if I send you an email posing as Bank of America and was asking for you to respond to the email with your account information because your bank account was compromised.

It pays to have a critical eye when reviewing emails, and to hover (not click) on any links outside of the email. Don’t open attachments you don’t expect, or respond with personal data. If you have any questions, you should verify the email by calling or contacting the company separately to see if the email is legitimate. If it is not, you should report it. You can read more about phishing scams and report them through Fraud.org: http://www.fraud.org/scams/internet-fraud/phishing

How to clear browser history/cache

Along with protecting your accounts with stronger passwords and making sure that those who contact you are legitimate, it can be very important to delete your browser history. Because many sites use cookies or behavioral tracking (as we’ve seen in the TED video above) you should always log out of any website accounts and clear your cache of visited websites.

In Internet Explorer, click on the gear symbol then go to Internet Options to clear browser history.

In Chrome, you can clear your browser history by doing the following steps: click on the 3 bar menu, then Clear History or go to Settings – > Show Advanced Settings – > Clear Browsing Data.

This is especially important since our patron and staff computers are shared, and patron may “time out” before they can log out of all accounts and close the browser.

Make sure patrons delete documents off desktop/ delete recycle bin

While we’re talking about sharing, patrons saving documents to the desktop should always be shown how to drag their documents from the desktop to the recycling bin, then empty the recycling bin from there. Be aware it’s permanent (which for our patrons is a good thing on a shared PC).



Security and War Games

And just for wow factor, here’s what a live worldwide map of internet attacks and server protections looks like. Norse maintains the world’s largest threat intelligence network, gathering data on attackers and what they’re after. http://map.norsecorp.com/






Please name this blog entry: Lesson 2  Challenge 

Pick one customer service question and write 1-2 paragraphs in your blog about what actions you would take.

  • A customer comes up to you and says they think their Facebook account was hacked, but they’re not sure.
  • A customer shows you a “too good to be true” email about getting free money from Nigeria, and asks you to help them seal the deal with their banking information.
  • A customer accuses the library of spying on them, because they have observed something “unusual” on their PC.

What would you do?

Bonus Video: Online Privacy: How Did We Get There?


"STOP"- Please complete this challenge.

“STOP”- Please complete this challenge. Lesson 3 will post next week.

Tagged with: ,
Posted in Uncategorized

Exercise 3: Part 1: SAPL Marketing Tools


How in the world does this concept apply to you and your job?  At its very core – this is a simple concept.  We all need to make our library as successful as it can possibly be.  We can do this in a variety of ways, but making sure that people actually know about the services that we offer is critical.  Some of our best marketing might be through word of mouth or happenstance, but there are many ways in which we can think critically about how we approach this topic.

Of course, we are very lucky at SAPL to have our very own Marketing team to carry a large part of the burden, but there is still a great deal of marketing work that falls to other library staff members.  This lesson will help you prepare for those times and hopefully teach you a few new tricks along the way!

Let me ask you this…

  • Do you often create flyers or displays for patrons?
  • Have you had to make a presentation to a group about library services?
  • Have you wanted to increase your marketing efforts so that they are more effective?
  • Do you want better attendance at your programs?
  • What do you really know about your community’s needs?
  • Do you want to help your branch or department really feel success?

I hope you answered “yes” to at least the last question, if not a few more.  Let’s preface by saying that marketing is a huge subject and we couldn’t possibly begin to cover it all.  In this lesson we have two main objectives:

  1. Creating and implementing marketing strategies and;
  2. Creating attractive and effective marketing.

So let’s get started!

Part One:  Creating and Implementing Marketing Strategies

What do you know about the community that you are serving?  Most communities are diverse, but recognizing what the large percentage of your community is made up of may also help you determine their needs, wants and desires.  It can also help you formulate a plan on how best to serve them.

Business Decisions

The Business Decisions database is a very useful and simple tool that lets you look at the demographics of your community.

Once you log in to the Business Decisions database, you might even find a report template for your library already created.  For the sake of this lesson though, let’s start from scratch.

Select “new project” and give it name.  Use the “Point on the Map” option and then put in your library’s address.  There several ways to customize from this point on – but the first one is your service radius.  It defaults to 1, 2 and 3 mile radius – play around with this to see what different results you get.  Most library reports are commonly run with 1, 3 and 5 radiuses.

raidus pic

Select Save and Choose Reports – now you can select all of the reports you want run on this address.  There is a lot of variety in the reports and many useful statistics to be found.  The Demographic and Income Comparison report is an exceptionally worthwhile report to run.  Go ahead and pick a few that seem interesting to you and then select the option to run the reports.

That’s it!  There’s more you can do with Business Decisions besides running these reports though.

For example, I can search the zip code of the Igo Library and then look at their recreational spending.  Look at all of these crazy people PAYING for their books!  And if the people in the Igo area have spent nearly $300,000 on Digital Book Readers – maybe we should make sure they know about the Library’s digital offerings or that we have classes that help people learn to use their eReader.

bd screenshot

A Few Other Ideas…

Show off your results!  Take lots of pictures from your events and use your branch’s small picture frame or larger digital display to show off the fun everyone had.  The more people see the enjoyment others are having, the more likely they are to join in.

Don’t forget that you can talk with the Marketing department to get some more ideas about what you could be doing to increase your effectiveness.

Reach out to local HOAs.  Most have newsletters or information they post to their community members.  Get in touch with the local apartment complexes and ask to put a library brochure in their welcome packet.  Think about how you can market to different groups and what they might want to know the library offers.  And carefully examine what groups are near your library – and then think about who is using your library.  What groups are you not seeing?  How can you reach out to them?  Do you offer something that they want to come for?

Take some time to really think this over.  The more focused you are in your efforts, the more likely your marketing will be received well.


Tagged with: ,
Posted in Exercise 4 Part 1

Exercise 3: Part 2: Marketing Tools

Part Two:  Creating Attractive and Effective Marketing

First things first:  the Marketing LibGuide.  You’ll recall we learned all about LibGuides in the first part of our 11.5 COSAs lessons and the Marketing LibGuide is quite useful.

Some of the very important items you will find on the Marketing LibGuide:

Flyer Templates

Flyer templates have taken away all of the hard work in creating flyers for your programs AND they help us present a consistent marketing message to all of our patrons.  If you have a special event going on, please do follow the special event procedures or submit a request in advance to have different marketing materials prepared for your event.  For most library events though, the flyer template should be able to meet your needs.  And Marketing has even put together a very useful document with tips on using the flyer template!flyer tempalte 2

Finding a Fantastic Photo for Your Flyer

Finding the right photo for your flyer does not need to be difficult or fraught with worry about copyrighted images.  SAPL has a subscription to several ThinkStock collections and you will definitely find something you are pleased with.  The Marketing LibGuide has all of the details on how to go through this process, but it’s really as easy as visiting the ThinkStock Photos webpage, searching within the parameters given on the LibGuide and then requesting the images you want through a Marketing request.  Marketing is lightning fast in their response to getting you an image, so don’t let that put you off!

Video Tutorial:  Resizing Images

So now you’ve found the perfect image – but it does not fit perfectly into your flyer – what to do?  Don’t just shrink or enlarge so that you end up with a stretched out image.  Trust me when I say that resizing an image is critical element to an attractive flyer.  Remember that an attractive flyer says a lot to patrons – and not just about the program information.  A flyer that is attractive and created with care shows professionalism, commitment and respect for the topic.

Luckily the Marketing team has put together a video for us that demonstrates how to do this easy but often tricky task.  It’s less than three minutes, but you might want to take a few notes so that you can nail it!

More Great Tools on the LibGuide…

Be sure to explore the LibGuide in depth and discover the other great tools available to you.  There is a template for PowerPoint presentations, Frequently Asked Questions, signage that you might need to commonly use, digital display templates, and even a tips and tricks section that will teach about the various tools you might need to use from the Marketing department!

Wait a minute…I already know all of this!

If you already know how to use these tools and are a frequent user of the LibGuide – that’s great.  Let’s take it a step further.

Owning It

There are several really fun online resources that can help you personalize, create and do more.

My personal favorite is Canva.  It’s completely free, but you do need to create an account (no other information than an email address is needed).  You can make flyers, bookmarks, collages, invitations, posters, infographics and more.  And it is REALLY user friendly.  Basically you pick what you want and it guides you through the rest.  You can make a beautiful creation in no time.  They even have tons of copyright free images that you can edit to your liking or use for whatever you happen to be making.

Here’s a sample of some of the things you can create (but there’s much more):


Now there’s a couple of ways to use this and I’m sure you’ve already had a few ideas yourself!  And just browsing through the options might give you a ton of ideas too.  Check out this neat Fiction vs. Non-Fiction pamphlet that is PREMADE on the site and can be edited to suit your needs.

fic v nf

(Due to recent changes in PicMonkey’s business model, it has been removed as a resource for this lesson.)

And with all of this fun and fancy talk about graphics and design, don’t forget about the actual content.  The Hemingway Editor is immensely helpful in recognizing common grammatical mistakes and advertises that it will make your writing “bold and clear.”  It highlights passive voice, adverbs and provides other hints about using shorter or more effective words to replace others.  It will even show you how “hard” your writing is to read by grade level.

(PS – it’s a great tool for writing reports and making sure you sound like the smartest person in the room!)





Please name this blog entry: Lesson 3 Challenge

Do you use any of these tools on a regular basis?  Write about whether or not you think you can use these tools to create better marketing pieces.  Then create a piece of marketing regarding a service that is offered at your branch by using the flyer template, Canva or PicMonkey.  Share the document (or a screen shot of it) on your blog post.

"STOP"- Please complete this challenge.

“STOP”- Please complete this challenge.

Tagged with: ,
Posted in Exercise 4 Part 2

Exercise 4: Databases- EBSCO






Did you know that not only can you perform research in EBCSO databases but you can also find magazine articles for popular periodicals? For example, when all of your Consumer Reports Magazines go missing and you have a patron looking for the most recent article on cell phones, you can find the article by searching the EBSCO family of databases.

We are going to use Academic Search Complete as the example for EBSCO databases.Academic Search Complete

Please be aware that the interface will be the same for all EBSCO products.

Part 1: To look for a specific topic in a particular publication such as Consumer Reports:

  • From the SAPL Databases page, open Academic Search Complete
  • Enter your search term(s). For this training, we are going to use “cell phones” (hint: putting search terms in quotes ensures the search for the phrase “cell phones” not the words cell and phones)
  • Under the Limit your results section, type in Consumer Reports (typing in just the word Consumer will bring results for all periodicals that use that word in the title, give it a try and see the different results)
  • Click on Search

EBSCO Arrows





Please name this blog entry:

Lesson 4: Challenge 1:

  1. Find and open the article titled “The Right Phone for You” in the results list. Select the version PDF. Click on the email option on the left of the page, enter your email address and mysapl11.5@gmail.com, in the To Field. For Subject put your full name and your location.
  2. Search for the June 2014 Consumer Reports issue by using the “Publications” and  the “Published Date” limiters.  How many articles are there in this issue?



Part 2: Find the entire publication, such as Consumer Reports Oct 2015:

  • Open Academic Search Complete
  • Click on Publications at the top
  • Type in Consumer in the Search Box
  • On the results list click on Consumer Reports

ebsco Publish Arrow

There should now be a description of the publication on the left side of the screen and on the right side is the list of all monthly issues that are in the database. Clicking on a year will bring up another menu (a cascade menu) for the volume (month) of the issue. Once you click on the volume, all articles in that issue will be listed and can be read in any order.





Lesson 4 Challenge 2:

  1. How many articles are in the May 2001 issue?
  2. Search for Consumer Reports volume 80, issue 9. How many articles are retrieved?


Ninja tip: On the page with the description of the publication you should also see a “Search This Publication” link. Click on this link to search within all the magazine issues. This is similar to the first part of this lesson where you entered the publication title into the delimiter search box. Clicking on the link automatically populates the JN (journal name), simply enter your search term in the next box and you should end up with the same results as the very first search you did.

“STOP”- Please complete this challenge.

Tagged with: ,
Posted in Uncategorized