Library on my mind

http://k-12.pisd.edu/library/expo.html

Keynote:

http://k-12.pisd.edu/library/presentations/2011/RICHARDSONEBP2011.ppt

Dr. Ross Todd

Mary Gaver – 1958 research – School Librarianship has been around a long time!

“Alive to the limitless possibilities of tomorrow”

Since  2000 17 USA statewide studies undertaken – School Libraries Work – new updated version coming out get a copy!!!

Achievement scores tend to be 10-20% higher than schools without a librarian.

Claim – School libraries are an integral part of education reform “impact student learning”.(HOW)

Reality – “Occupational invisibility” (Hartzell)

Others often do not see depth, bredth and importance of what school librarians contribute to learning in schools.  What are the 5 most significant impacts of  your school library on student learning? your evidence?

154 school libraries in Delaware – (2004-2006) (100% of public school libraries)

39% helped students develop skills

37% improve reading

22% technology skills

Really these numbers are ok but need to be closer to 100%!!!

Why do we need libraries?  – technology, vast information on the internet, costly print, aged collections, costly personnel, less library use more internet…

What EVIDENCE do you have to defend your library?  or is it just your opinion?

“We boost achievement” – Ross and Loercher.

http://catalog.pisd.edu/cgi-bin/koha/opac-detail.pl?biblionumber=186284

How can we engage, strategize, and collect the data.

What does research tell us about our day to day work.  What can you as a practitioner do to gather the evidence, and data?

Learner reported evidence, how do we engage and gather that information about how learners value what you provide?

3 dimensions:

Foundation informational -national data

Process transformational – in practice – librarian observed

Outcomes formational – user reported evidence “learner derived evidence”  What are the kids saying about you?

Alternatives to evidence – dragging my heals, beating around the bush…  What can we do…

Accountability – prove your worth

Have to be a researcher – NO!  information literacy competencies

Our goal is life long learning – Evidence enables feedback for tomorrow

EBP detracts from the job! – What then is your job?

Time – it is about priority

Professional development – examples models templates

http://www.accessola.com/school_lib/

Mission statements should be about the user – not about the library…

Celebrate the understood not the unfound…

Knowledge outcomes – AASL

School libraries as verbs!

http://www.ouhsd.k12.ca.us/lmc/ohs/stronglib/StrongSLMP.ppt

Knowledge, creativity, inquiry learning specialist

Quality TEACHING is the largest impact!!  we must CO-TEACH!

Are you an instructional designer?  Implement inquiry based instruction? digital age?, continuous learning based research?

Common Core – Intellectual Quality, Personal Agency, Social and cultural agency…

Evidence

• Sustained focus on specific topc
• Explanatory detial
• knowledge of …  – get from ppt.

DEEP UNDERSTANDING!  Not just Squirrels gathering facts…

MS – HS – No don’t bring your kids teachers we’re going to talk about what your kids are reading or what you would want them to read!

Elementary – Book Election!  Community event politicians …  Social studies 4th grade enriching the experience!

Political parties – ok to agree/disagree  What book would represent their “class” and have a long lasting experience.

5-8 signed up to view which session they wanted – lunch time research – and teachers were intermediary with organizations to setup interviews.

Citing sources was hard as they were not pushed into this throughout.

More information www.justice.lrei.org

Feedback from many of the organizations impressed and supporting the kids work.

More deadlines, and following their calendar – reflection – too much to do blogs, interview, website(got hung up on design) more discussion time needed as a “group” to talk about citations, online interactions, online accuracy.

“Is this a kid problem or an adult problem…”

15 books suggested primary election to widdle down to 4 – discussion on “WHO” should vote!  Only 4th grade or whole school.

Stumping for their books – what to campaign on.  Voting again discussion 4th and above – faculty too.  Must register and must sign it.

Discussion on privacy and who you voted for.  Cat in the hat won!  Discussion on reflection why…  Name recognition alone!

Campaign ideas to be better- 20 second discussion, book talk the books to other students

Next election cycle 8th graders will be able to “Mentor” the 4th graders on the process.

Use more technology – online voting, webpages etc.. – twitter @mytweendom

Created a very open collaboration for the future with teachers.

MS – TEAMWORK 7 months 8th grade- social justice – 5 visits, investigative journalism, informal interview, research about the social justice topic – with 2 sources for muckbreaking?  Had to design a lesson – one day where the students become the teacher for the day and teach the 4-7th graders about their topic.

Speaking to adults, visual art design on their topic, PSA’s

Created positions for the students – 10 teams, 4 students per team

HS – TEDxHumanRights: – 7 years – to get embedded – 200 students…  Recognize it takes time – means working with EVERYONE.

Librarians… You are ON even when you are OFF.

Information literacy to “transliteracy”

Visualization makes a difference.  Forget the ppt bullets!

KEEP IT SIMPLE – Tell a story 10 points with a primary FOCAL point.

Embedded means leaving the library.

CALL TO ACTION – We don’t belong and are not a department – we have the ability to move between each group/grade and make change.

Couple of references that I have been unable to track down.

Dr. David Lankes – “it’s all about learning… how is this going to fundamentally enrich a conversation?”

Dr. Henry Jenkins – TED – “Confronting the Challenges of Participatory Culture: Media Education for the 21st Century.”

Library blog – has guest bloggers on the research process.  Why I love “end note” – use video.

Thanks to Teachingbooks.net I found this – write about a day with a dragon and possibly get the author to visit!

http://www.charlesbridge.com/client/client_pdfs/contests/Me_and_My_Dragon_contest.pdf

WIN A VISIT FROM AUTHOR JUDY SCHACHNER! (Elementary) Sign up for the Skippy Scoop monthly e-newsletter and be automatically entered for a chance to win the grand prize—a visit from Judy Schachner and a Skippy costume!

To enter, just send an email to schoolandlibrary@us.penguingroup.com with the subject line “Skippy Scoop Sign Up Sweepstakes.” The e-newsletter is free and sweepstakes entry is open to eligible teachers, school librarians, or educators of preschool through 1st grade.

Deadline: November 30th, 2011

NO PROMISES!

ON DEMAND – messages

ERMI – Electronic resource management integration

• import holdings data
• Built in Open Link resolver
• SUSHI stats
• Handle usage limitations and access restrictions

Biblio relationships

• user configurable relationship – this bib has this relation to this one
• FRBR
• This is “like” this

Arbitrary metadata schemas

• XML-based
• Managed by config file
• Mapped to database and index fields
• User defined views in progress

Widgetize staff client

Shouldn’t take you months and months to migrate.

Complexity is not always your enemy, bit it is never, ever your friend.

Toolkit options for data

• MARCEdit -
• Libre Office – Swiss Army Can Opener for data: – www.libreoffice.org
• Some PERL is REALLY handy.  Grab these: Text::CSV_XS, MARC::Record, Text::CSV::Simple, MARC::Field  http://www.cpan.org
• Programming Perl, by Wall, Christiansen & Orwant (2000)
• Perl Best Practices, by Damian Conway (2005) O’Reilly Media good tool for best practices…
• Caffeine, angry-sounding music, whatever suits you…

People are the biggest challenge in an ILS migration…

RFP – nobody loves them…  Talk to other libraries – use something ke LibWebCats to find other libraries…

Treat it like a job interview – would you have them do another migration for you?

Ask other community players about them.

How do you migrate data:

• What should you move?  “everything” frequent answer… Patriot act
• “Gotta have” vs “nice to have” MARC, Borrowers, Holds, Items, Tagging?
• What is the relationships between your data?
• maximum data – 96% data conversion 100% optimum
• Migration strategy what is your timeline
• Plan for 2 full extracts – one for scripts and testing second for go live
• write down what you did to get this correctly – Wash, Rinse, Repeat…
• Be AVOIDED – Catalog freeze, patron freeze – not your friend
• Data manipulation – bib and item records
• system designator number – is it really needed?  Creating confusion later what is that number?
• Barcodes are your friend
• use MARCEdit or Perl scripts to rearrange item fields
• Prices – need something there default values?
• Let Koha ingest these naturally – bulkmarcimport.pl or stage and import
• Consider authorized values
• create a csv map  [current items and how they map to KOHA]
• try to create a CSV that looks like what KOHA wants
• Take some time to clean it up while in CSV format
• USE koha’s patron import tool – slow but it works but accurate

Play with it!  don’t wait to long from training to go live otherwise people will forget everything!

Vendor should have some basic testing regimen for you to walk through.

Go live…

Ah…  Cataloging and MetaData management:

one problem: – MARC must die – ‘I’M NOT DEAD YET’

“What use is sharing the source if we don’t also share the data?”

Version control for MARC records…  how can we track changes and pull those in?

• Integrated metasearch…
• Integrated support for non-marc metadata – Dublin core or IDE.
• Record sharing

IDE for Cataloging

• change tracking
• workflow tracking – send this record for review/sign-off
• Cataloger productivity

Computers are consistent but stupid.

• Updated MARC21 framework
• Indexes for RDA: 336, 337, 338
• Support for alternative metadata editors

This impacts search.

WYSIWYG – MARC editor for Koha.  Possible!

Great presentation about how to customize your site – ppt will be available on the KUDOS website.

Firefox plug in “HTML validator”

PTFS sysprefs for multi-site libraries …  concern over this getting to community…  hmmm…

Couple of jquery tweaks

$(document).ready(function(){ first line!

blah

blah

end of the item should have

});

$(document).ready(function(){

$login

Columbia Basin College – help widget

Welcome to day 2!

KUDOS discussion was very helpful and there are still concerns about the bylaws and how things will move forward with election of officers etc…

Oh boy…

Why Git – version control

Teaching about Git

Distributed allowing several people to work on code at the same time and share it back.  Manages content not files.

sudo apt-get install git-core

git config –global user.name “your NAME”

git config –global user.email “your@email.com”  or look at other .gitconfig

git clone git://git.koha-community.org/koha.git kohaclone

WAIT

cd kohaclone

Show branches * indicates the branch you are in

git branch

git status – current branch

git checkout -b mybranch master

-b new branch, mybranch(name), master()

for each file changed:

-git add /path/to/the.file

git commit – or lazy git commit -a

commit message – include bug number and a one line description of the bug

git format-patch master

see soemthing like “0001….

something…

attach patch to bug report change label to “needs signoff”

after signing off change status

easy to fetch a patch from bugzilla

wget -O bugxxxx.patch

http://bugs.koha-community.org/bugzilla3/attachment.cgi?idYYY

Process behind it:

Patch goes out, someone tests it and signs off resending it to the list – QA double checks and signs off again and the patch goes to RM for master branch

Keeping up

git checkout master -

git pull – pulls in all the changes

git checkout mybranch – goes to the branch you are working in

git rebase master – takes the branch and catches it up.

merge conflicts -

Sign-offs

git checkout -b bugxxx master

git am -i -u -3 bugxxx.patch (tap ‘y’ to confirm)

TEST TEST TEST

git commit –amend

- change the first line to [SIGNED-OFF]

git format-patch -s master

git send-email

SQL – reference interview what do you really need/want

What/Who/One time or regular basis/selection criteria

select * from information_schema_columns where table_schema like ‘%koha%’

Look for columns which appear in multiple tables those are the linking items between tables.

Found out number of records in table

SELECT count(*) from tablename

do a sample select if a small table

SELECT * from tablename

or if it is a large table to select * from tablename LIMIT 100

Use Distinct clause when working with codes

SELECT DISTINCT columnname from tablename

Add some test records to make sure you are getting the query for what you are looking for.  Have the user provide some examples of what they are looking for.

DATE COLUMNS

datetime and timestamp – may need to use a DATE function to convert date data.

select * from branchtransfers where DATE(datesent) between ’2011-04-01′ and ’2011-04-30′

this report doesn’t include the last date – select from branchtransfers where datesent between ’2011-04-01′ and ’2011-04-30′

Functions – MONTH(), MONTHNAME(), YEAR()

JOIN common columns between 2 tables! XXX on (XXX.number=XXX.number)

LEFT join results on the base table  And matches from the secondary table but shows all the base table records.

Table alias – borrowers.cardnumbers as “Barcode”