[ISLMA-Share] Library Sign in Procedures

[Email list for the Illinois School Library Media Association]

Here is a blank version of a spreadsheet I created. It should work for you, but let me know if it doesn't. We export the students' names and ID#s and copy/paste them into the table at the right. The formulas are set up to auto-fill their name when they type their ID# into the ID# Column on the left. It also auto-populates a number 1 to the right of their name that adds up at the top, so we have a nice, easy place to see the count when we open it. I also split it up into quarters by making a new tab for each quarter and copy/pasting everything from the first tab into the others.

Thanks!
Alison KurtzLibrary Media SpecialistSandwich High School515 E. Lions Rd.Sandwich, IL 60548akurtz at kidsroe.org815-786-2157 ex 22134

 


    On Wednesday, September 28, 2016 11:26 AM, Email list for the Illinois School Library Media Association <islma at list.railslibraries.info> wrote:
 

 Is it possible to get a copy sent of the spreadsheet?  I'd love to share it with my tech department and see how we can get it to work for us.
On Wed, Sep 21, 2016 at 9:28 AM, Email list for the Illinois School Library Media Association <islma at list.railslibraries.info> wrote:

We love our method of scanning school-required student IDs into a Google spreadsheet. With some formulas on the back-end, you can even have the spreadsheet auto fill each student's name once they scan their ID. Sort range by name, and you have a very handy alpha list of students present in LMC each period. 
I'm not sure I can share, as we have student names embedded in the sheet.~Monica Tolva
Library media specialistGoogle EducatorVernon Hills High School847-932-2039monica.tolva at d128.org
Currently reading Between the World and Me by Ta-Nehisi CoatesCurrently listening to The Rosie Project by Graeme Simsion
On Wed, Sep 21, 2016 at 9:22 AM, Email list for the Illinois School Library Media Association <islma at list.railslibraries. info> wrote:

We are looking at updating our "old fashioned" library sign in procedures. Students currently drop their pass in a basket and sign in on a piece of paper during the school day. We are looking to update to some electronic. Does anyone have library software or a program that they use to check students into the library? It would record their name and time in and out. Thanks in advance for the responses. 

-- 
Cynthia HinderliterDept. Chair of Instructional Technology/Information SpecialistPekin Community High School 

______________________________ _________________
ISLMA-Share mailing list
islma at list.railslibraries.info
For list archives and subscription options, visit:
http://list.railslibraries.inf o/cgi-bin/mailman/listinfo/isl ma
To unsubscribe, send a message to:
islma-leave at list.railslibrarie s.info


Pursuant to Illinois’ public records law, this electronic communication may constitute a public record. Please be advised that this email may be subject to monitoring and disclosure to third parties.______________________________ _________________
ISLMA-Share mailing list
islma at list.railslibraries.info
For list archives and subscription options, visit:
http://list.railslibraries. info/cgi-bin/mailman/listinfo/ islma
To unsubscribe, send a message to:
islma-leave at list. railslibraries.info



-- 
"Listen to the mustn'ts, child. Listen to the don'ts. Listen to the shouldn'ts, the impossibles,  the won'ts. Listen to the never haves, then listen close to me...Anything can happen, child, anything can be." Shel Silverstein_______________________________________________
ISLMA-Share mailing list
islma at list.railslibraries.info
For list archives and subscription options, visit:
http://list.railslibraries.info/cgi-bin/mailman/listinfo/islma
To unsubscribe, send a message to:
islma-leave at list.railslibraries.info

   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://list.railslibraries.info/pipermail/aisle/attachments/20160928/10482731/attachment-0002.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Library Sign-In.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 46715 bytes
Desc: not available
URL: <http://list.railslibraries.info/pipermail/aisle/attachments/20160928/10482731/attachment-0002.xlsx>