Class 10

Class 10 Notes

(notes are in progress and are subject to change)

Excel Quiz on Thursday - One spreadsheet, absolute and relative cell references, conditional formatting

Discourse
Minimize Discourse

Copy 10harris folder from Class folder to your Groups (shared) folder.

Class 10 Outline
Benjamin Harris, Reference Librarian
TU Library

Locating books and articles in the Coates Library
Finding answers through the Library website
Using academic databases to search
Where to go to get help
Opportunity to help the Library for extra points
Understand Homework

Copy the 10harris folder to your groups folder. There is a Word file named Benjamin Harris that you may use to take notes during the presentation. Mr. Harris will talk about all the facets of the Trinity Library Website including the databases available free to the Trinity community.

In Class: Two spreadsheets introducing charts and graphs

Homework:

Part 1 - After you have completed your notes and are ready to do your homework, take your class's link to the Benjamin Harris page on our Wiki. Compose a college-level question about Mr. Harris' presentation. Your question should be multiple choice answer format with three possible answers. Format the correct answer in green, the "distractor" answers in red. Be clever, accurate and creative. Do not repeat a question as you add to the page. Add your name at the end.

Part 2 - Ebook Spreadsheet

Go to the Trinity Coates Library website and do a search for books in full-text electronic form on one of these subjects:

Digital Photography
Desktop Publishing
Creating Web Sites
Gourmet Cooking

Choose five books from those returned in your search to review briefly.

Open the spreadsheet titled electronicsources.xlsx and fill in the information under the heading columns.
Use the Word Wrap option when the information is long. (Hint: you may need to reformat the ISBN number to make it display correctly.
Rate the books from 1-5 in the Rating column based on whether you would use them and recommend them to a friend (1=favorite, 5=least favorite).
In the Comment column, write a few words justifying your rating of that electronic book.
Finally, insert a row at the top of the spreadsheet and merge and center an appropriate title, then format the spreadsheet with fills and fonts similar (but not necessarily identical) to the example.
Save your completed spreadsheet in 10harris/homework/electronicsources.xlsx (do not rename or move).

Look below - it works!!

Online Chat: Ask a librarian:

[14:04] meeboguest933915: What's the fastest or most straightforward way to get to a list of ebooks in our library?
[14:06] coateslibrary: Is there a book you are looking for in particular?
[14:10] coateslibrary: You can use the library catalog by clicking on the "Books & Media" section on Coates Library Home Page. Once to the catalog page, there is a panel on the right hand side of the screen and you can select Advanced Search to specify what you are looking for :)
[14:12]Thanks - it's for an assignment for my students - they are making a spreadsheet of electronic books and I wanted to give them both an example of how user-friendly the library staff is for providing answers, and also the best way to find an ebook on a particular subject - they will have four categories from which to choose

<log off>