[CALIBK12] Survey and copyright date

[Broger Mackey, Lori]

Barbara,

My school uses Accent.  In the reports section, I can create a shelf list that can be saved in a "comma delineated file" (which is a .csv file).  The shelf list includes the call numbers and the copyright years.  The .csv file can then be opened in Excel.  Once in Excel, I deleted all the items except the 973s.  Then I used the formula for AVERAGE to find the average year.  The formula is =average(xx:yy) where xx is the first cell in the column and yy is the last cell in the column of entries being averaged.  

The Excel part only took a couple of minutes (the report in Accent was slow).  Overall, not a painful process.

Lori Broger-Mackey, TL
Cleveland HS, Reseda

P.S. I used to use my Follett Titlewave collection analysis and be done with it.  However, I can no longer find that feature on their website.  Maybe if we all asked them to bring it back, they would.


-----Original Message-----
From: calibk12-bounces at lists.sjsu.edu on behalf of Barbara Jeffus
Sent: Fri 11/7/2008 3:53 PM
To: CALIB (E-mail)
Subject: [CALIBK12] Survey and copyright date
 
By now, many of you have discovered the survey shift to the 973s as the check point for an average copyright date. The reason for the shift was to use a section that has a strong relationship with California content standards. The 973s do that at all grade levels. Unfortunately, 973 is often a large section, particularly in high schools. In the spirit of collaboration, I'd like to start a listserv discussion about techniques and strategies to get to the average copyright date as easily as possible. For example, how do you use the various automation systems to get to it? (Don't assume that others using your system know this.) How do you use students on this project? Has anyone tried a collaboration with a mathematics teacher for this to be an extra credit assignment? All ideas welcome. It's a group think! Thanks in advance, Barbara

Pssst--the magic word to get into your survey remains the same as last year and is the same for everyone so please share with others in your district. Type it exactly as it appears in the line below:
@YourLibrary
Survey site: http://www.cde.ca.gov/ci/cr/lb/schlsurvwelcompage.asp

Barbara Jeffus
School Library Consultant
California Department of Education
1430 N Street, Suite 3207
Sacramento, CA 95814
916.319.0445
FAX 916.319.0172
http://www.cde.ca.gov/ci/cr/lb

READ Green. Borrow a Library Book!