Tag Archives: complicated spreadsheets

Silence in the library

I’m getting worse at updating the blog – it’s not unexpected though, as less new and exciting stuff happens to me these days! However, I thought I should probably just do a quick update on what’s going on with library life at the moment.

Exams and dissertation season has been and gone, and blimey, that was busy. People were banging on the doors fifteen minutes before we open, so desperate were they to get their hands on our thesis collection, and the demand for laptops was so high we had to turn people away. What amused me were the “regulars” who would come in every day for two weeks and ask for the same three theses – why didn’t they just photocopy the relevant bits?! There was also one guy who would come in every day and ask for a laptop – it got to the point where it felt like I worked in a pub (“the usual?”). There was, of course, all the stress and frustration that comes with exam season – not for me, but for the students. We had printer problems, network problems, printing credits going missing and essays disappearing. It meant I got to use all my customer service and “dealing with difficult situations” skills from those training sessions earlier in the year! 

The past couple of weeks have been noticeably quieter – yesterday we probably had about 50 people come in during the day, and it’s only going to get quieter now that the majority of the students are finishing their year and going back home. We’ll still have some nursing students and postgraduates, though, so it’s not going to be completely dead, but it is noticeably different to the atmosphere a few weeks ago. It’s just so quiet! Term doesn’t finish for another three weeks, but after that we’ll be on summer vacation hours until the Autumn term starts (and I’ll be gone by then!) – three more late Wednesdays and then I’ll be on regular hours for the rest of my job. We had a team meeting the other day and it was the first time that anyone mentioned that I’ll be leaving quite soon – it was quite weird to hear that said out loud! I know that the new GTs have now been chosen, and I’m looking forward to getting put in touch with them quite soon (or at least I assume this will happen, as it did for us last year). 

 The other week I went to a public lecture on digital humanities, which I was expecting to be quite interesting – and it was, but not for the reasons I expected! It was about Doing things Differently: writing, academic journals and social media in the online world. It was presented by the editors of an online journal, and the blurb made mention of Open Access, which I wanted to learn more about. I’m interested in social media too, so this sounded really good. However, the actual event did not live up to expectations, and there were some mentions of “Creative Commons” which made all the library staff whistle through their teeth like builders. (Creative Commons doesn’t mean you can use any old thing off Google image search!!) It was interesting to hear about journals and OA from the perspective of two academics, but it was a bit of an eye-opener too, as I somewhat naively expected researchers (and editors of online journals) to be a lot more clued in on technology, resources and social media. It shows that there is a lot of work than can be done by libraries and information professionals to support researchers and improve their knowledge and skills when it comes to these areas.

Last week I had a surprise delivery of 120 new books – rather more than I usually get! It is nice to be able to tell the academic staff that we’ve bought all the books they wanted, though, and the monthly new books newsletter looked very impressive! We’ve used up all our budget for this year now, so the book deliveries will dry up until next term. That takes a big chunk of work out of my day, but there are other projects to be getting on with over the summer, so I’m sure I’ll still have plenty of things to do.

We’re currently running a Patron-Driven Acquisition exercise with e-books, which is where hundreds of titles get loaded onto the catalogue, and if a student clicks on one and reads it for more than five minutes it triggers the purchase of the book. Some of the titles are interesting, to say the least – we found one about Jungian theory in relation to sand. Bit odd! The purpose of the PDA is to provide more material online while the book stock at one of the site libraries is unavailable as it moves into the main library over the summer. The move is now underway and we are having to keep on the ball when it comes to sending books to other sites – books might say one thing on the system while actually needing to be sent somewhere else. Needless to say there’s a lot of signage around to keep everything straight!

Now that the academic year is coming to an end the big project is renewing all our digitised material for the next year. This is the first time we’re doing it with the new software, so it’s a big learning curve for everyone. My first task was to write out the instructions for the renewals process, which is easier said than done – we kept getting updates to the instructions as people tried them out and discovered bugs. We are now in the process of contacting all the academic staff to find out what they want us to keep – if all goes to plan then we can upload or delete the relevant files before September and get everything straightened out. This has involved two new spreadsheets so far and I’ve been using my newfound Excel skills to add fancy conditional formatting and other bells and whistles, which has been fun in a nerdy way. The whole process is just a bit weird for me though as although I’m setting up a lot of the work, chances are I won’t be able to complete it all before I leave (depending on the speed of responses from lecturers), so I won’t get the satisfaction of seeing this through to the end.

We’re coming towards the end of the stock take as well – we’ll finish scanning the shelves with the digital library assistant this week, and then it’s just a case of tying up the loose ends and getting everything to add up. It’ll be strange not having scanning to do as part of my daily tasks!

One last thing that’s happened recently is that I gained two new qualifications – I’m now a Microsoft Office Specialist in both Word and Excel. I had to sit an exam for each of them to prove I’ve got the skills, which meant a lot of quick learning of things I’d never really done before. It’s already come in handy as I have been able to “decorate” some  spreadsheets with special formatting to improve their functionality. It’s a handy thing to put on a CV too, especially seeing as I haven’t got the time or money to take the ECDL, which some job applications require.

Advertisements

Leave a comment

Filed under Uncategorized

First team-teaching session

I’m aware I haven’t updated the blog for a couple of weeks – I was struck down by a horrible flu and then went on a couple of weekend trips, and then Masterchef started, which all conspired to eat into precious blog-writing time. However, not much has happened in library life, so it’s not like anyone’s missed out on much.

The main thing that has happened is that I finally got to help teach an induction and infoskills session, trying out my presentation skills from our training back in December. I did the first part of the session on my own, which involved explaining the admin sort of stuff to the students, including usernames and passwords, printing and photocopying, and other thrilling IT-related things. I think I did quite well at this, although it’s quite hard to judge this when you’ve got a sea of blank faces staring at you. I said everything I wanted to say, and was able to answer the questions that were asked as well, so as far as that goes I’m happy with my performance. The only thing that I was unsure about was whether I was pitching the information at the right level. The thing about teaching, presenting and lecturing is that it’s not at all the same as having a conversation with someone; when you’re having a one-to-one conversation with another person, you’re getting simultaneous feedback – that’s all the nodding, “mm-hmm”, “yeah”, “right” sort of stuff that they’re doing while you’re talking. This helps you judge whether they’re understanding what you’re saying, and whether they’re still interested in hearing it or not. When you’re teaching or presenting to a roomful of people, it’s more than likely they’ll just sit still and listen without offering any of this feedback, which is part of why presenting can feel so disconcerting and scary. I found it really difficult to know whether I was going too fast or too slow and if I was explaining things in enough (or too much) detail. It’s something I think you just have to get used to, as there’s not a whole lot you can do about it. It was marginally useful to stop and ask “is that ok?” “are you ready to move on?” and other similar questions, but these were often met with silence anyway! I think the most useful thing we do here is to get students to fill in evaluation forms, so you do get feedback, albeit a little delayed.

For the rest of the session I was involved in the hands-on demonstrations, showing people how to use the catalogue, ebooks and databases. This is something I enjoy doing as I think it’s something I’m quite good at – I like explaining things and helping people to understand them, and it’s more instantly satisfying than giving a talk or presentation!

All in all, as a first taste of teaching and presenting to real live students, I think it went really well, and I’m definitely not put off by the experience. I’m itching to do some more, but opportunities are more limited at this end of the year. Fingers crossed…

 

Apart from the teaching, not a whole lot has happened recently at the library. We’ve just been plodding along! We had our busiest week last week, with over 1000 assignments due in, which meant students queueing up to use staplers, printers and laptops. It was only a tiny bit stressful in the end, as most of them were fairly well-prepared and hadn’t left everything until the very last minute. Of course, you always get one or two exceptions… This week is the start of the three-week Easter break for the majority of students (some run on a different calendar), so we’re getting about 30% of the visitors we had last week, and life on the issue counter is a bit more sedate. I’ve been working on a spreadsheet detailing our journals holdings (print and e-) and that’s been keeping me occupied for the last few weeks! The end is in sight, though, and I’m hoping I can get it finished before the long weekend, so I can start looking at some of the other stuff I want to do (more spreadsheets, mostly) next week. That’s about it for now, though – nothing super-exciting. I’m just looking forward to the Easter weekend – I really need the rest!

Leave a comment

Filed under Uncategorized

Week Four done and dusted

I can’t believe the first month is over already. It’s payday! I’ve never said that before.

Yesterday was a bit stressful. Digitisations have taken over my work life to the point that all I can think about is spreadsheets and scanning things. I also got a phone call telling me that I hadn’t been receiving new books properly because I had missed out a fairly important step in the process. Not a great thing to hear. It’s all sorted now and it didn’t cause too many problems, but it’s just annoying to trip up like that. I also don’t have much counter time on Thursdays so was stuck in the back office all day, not really interacting with anyone, transferring data from a spreadsheet, to a form, to another spreadsheet, and then to another form.

Today I saw the light at the end of the tunnel – I’ve been working through a list of digitisations for a particular lecturer and at close of play today I only have one left to upload, which I would have completed if it hadn’t gone a bit wrong at 4.25pm. Hooray! Next week I get to embark on the thrilling task of going through all our digitisations and putting their details on a brand-new spreadsheet, so that we’re completely up-to-date. I tell you what, I’m going to be glad when this is all sorted and I only have the odd few to do every now and then.

I’m in Leeds for the weekend and apparently the weather’s going to be quite nice tomorrow – just what I needed after the last couple of days! I hope you’re all having good weekends too.

Leave a comment

Filed under Uncategorized