Wednesday, 8 February 2017

MS Excel - Change Text from Lowercase to Uppercase using Excel Macro

Recently we had to convert all text in an excel file containing a list of books to uppercase. Here is an Excel macro to get this work done quickly.

Copy the code given below

Sub AllTextToUpper()
    Dim myRng As Range
    Dim celRng As Range
    On Error Resume Next
    Set myRng= Cells.SpecialCells(xlCellTypeConstants, 2)
    For Each celRng In myRng
        celRng.Value = UCase(celRng.Value)
    Next celRng 
End Sub

Open the Excel file and press Alt+F11 (Hold Alt key and then press F11). This will bring up Miscrosoft VBA editor. Paste the above code as shown in the image below.



  • Close VBA Editor and come back to Excel (Or press Alt+F11 again)
  • Now Press Alt+F8 (or Click View->Macros->View Macros). The following dialog box will be visible.

  • Select AllTextToUpper and then Click Run
  • All the text in your excel sheet will be converted to Uppercase
Note: Please save your original Excel sheet before running macros. This action cannot be reversed.


Anyflip - Convert your PDF into Flash & HTML5 flipbook Free

Anyflip.com provides you a free flipbook publishing platform to convert your PDF into an interactive, realistic Flash & HTML5 flipbook in minutes. It has got a free version and a pro version. The free version have certain limitations, but you will be able to create the flipbooks and publish them online free.
Now, let us see how to create a flipbook and to publish it on a blogger post.
  • Visit http://anyflip.com and click on Create Account or you may login with your Google or Facebook account
  • Once logged int, click on Quick Upload

Click on image to enlarge

  • In the select version, select Flash and click OK
  • Next, click on Upload your PDF button and select the PDF file (Your PDF must be less than 150 MB). You can add/modify the title, description, keywords and category here. Permission to download file and adding labels are available only for PRO version.
  • You may also select a template from the Template tab, add toolbar and set the flash display settings on the Advanced Tab
  • Depending on the file size uploading and converting may take some time, so please be patient.
  • Once finished converting, your flipbook will be displayed as in the image below.


Click on the Embed button and you will be presented with four options - IFrame Embed, Lightbox Embed, Button Embed and Text Link. Click on IFrame Embed tab, if it is not already selected and set the size of the frame below.

  • Now select and copy the code
Embed the Flipbook in Blogger Post
  • Login to Blogger account and click on New Post
  • Click on HTML button below the Post Title
  • Paste the code copied from Anyflip inside the body and click on Publish button to publish the post.


How to Embed e-Newsletter on Blogger Using Scribd


The e-Newsletter created in MS Publisher can be embedded in a blogger post after uploading to scribd.com which is a popular open platform for publishing and sharing documents of all kinds.



Saturday, 4 February 2017

Free Library Software for School Libraries

Library Automation - School Library Management Software

Effective management and utilisation of the library resources in an School Library requires incorporation of modern technologies as the Librarian alone has to do all the tasks in the library. This always causes delays in assisting the students to get the information they require as well as circulation of books to maximum number students in library periods alloted to the classes.
To facilitate the effective use of books the School Library has started computerisation with the Library Management Software developed in house by the Librarian. The software provides facilities for catalogue search, circulation of books and magazines, reservation of books, reports, class library management, fine collection, library statistics etc. Reports on the books issued, reservation status, search book by member and accession number, book suggestion and selection, budget expenditure and more for KV Libraries are available.
All the library resources are barcoded. Access to OPAC is provided through library websites (Intranet and Internet).
If you would like to try this free software for your library, you may download it from the link given below.
Snapshots of Library Software

Data Entry for Books
Circulation of Books
Issued Books Report
The library management software is free and may be downloaded from the link below.

Download

Please fill up the form for getting the download link. There will be four rar files. Download them all.

Wednesday, 16 March 2016

Preparing for KVS Librarian Test - Syllabus, Tips and Study Materials

Syllabus for written examination for Librarian

Part 1: Foundation of Library & Information Science.

Unit.1. Library as an Social Institution
- Social & Historical foundations of Library.
- Different types of libraries- Academic, Public, Special –their distinguishing features and functions.
- Role of U.G.C. for development of Academic libraries.
- Role in Library of formal and informal education.
Shivaji University, Kolhapur

Unit.2 Normative Principles of Lib. & Inf. Science
- Five Laws of Library Science.
- Implications of five laws in Lib. & Inf. Science
- Development of Libraries with special reference to India, Baroda
Public Library system
- Library Co-operation Resource Sharing and Library Networking.

Unit 4. Laws relating to Libraries & Inforamion.
- Library legislation need and essential features.
- Library legislation in India.
- Maharashtra Public Library Act.
- Press and registration act & Delivery of Books act (Public Library).
- Copyright act, Intellectual Property rights.
Unit.5 Library and information Profession
- Attribution of profession.
- Librarianship as a profession.
- Professional ethics.
- Professional associations & their role.
- National & International Library Associations- FID, IFLA, LA,
ILA, ALA, IASLIC etc.
- Professional education & research.
Unit.6 Promoters of Library & Information services
- National level promoters- RRRLF.
- International level promoters- UNESCO
Unit 7. Public relations & Extension activities
- Definition
- facets and programs.
- publicity & extension, Out reach activities.
- Library path finders (Guides)
- Factors affecting Library development, Literacy, publishing, Book
Trade.

Part II : Knowledge Organization, Information Processing & Retrieval.

Unit. 1. Universe of Knowledge
- Structure and attributes.
- Modes of formation of subjects.
- Different types of subjects.
- Universe of subjects as mapped in different schemes of
classification.

Unit. 2 Bibliographic description
- Catalogue purpose, Structure and types physical forms including
OPAC filling rules.
- Normative Principles of cataloguing.

- Overview of principles and practice in document description.
- Current trends in Standardization, description and exchange.
- Standard codes of cataloguing.

Unit. 3. Methods of Knowledge Organization
- General theory of Library Classification.
- Normative principles of classification and their application.
- Species of Library Classification.
- Standard Schemes of Classifications and their features, CC, DDC,
UDC.
- Notation: Need, Functions, Characteristics
- Design and development of schemes of Library Classification,
Standard sub-division Index.
- Trends in Library Classification.

Unit.4. Subject Classification
- Principles of Subject Classification.
- Subject heading lists and their feature.

Part III: Information Technology: Basic

Unit.1 Information Technology
- Definition, Need, Scope and Objectives.
Unit. 2 Computer Basic (Hardware)
- Introduction to Computers
- Overview of Historical Development of Computers.
- Generations of Computers, Classification of Computers.
- Essential Components of Computer system.

Unit.3 Computer Architecture-Organization of Computer
- Input and Output devices- Keyboard, Scanner, OCR, Printers,
Monitor

Unit. 4. Software.
- Operating systems: Single & Multi User Systems, Basic features
of MS-DOS, MS Windows, Linux, UNIX, Windows NT etc.
- Programming Languages: Concepts and Tools
- Algorithm & Flowcharting.

Unit. 5 Word Processors, Spread Sheet etc.

Unit. 6 DBMS Package
- Familiarity with DBASE, FOXPRO, CDS/ISIS, SOUL, MS Access
(Basic features)

Unit 7. Computer application to library & Information work
- House keeping operations

Unit 8. Communication Technology
- Communication Technology Basic Concepts
- Networking: Basic Concepts.
- Internet

Part IV: Management of Libraries & Information Centres/Institutions

Unit.1 Management
- Concepts, definition and scope.

- Management styles and approaches.
- Management schools of thought.
- Functions and principles of Scientific Management.

Unit.2 Human Resource Management
- Organizational structure.
- Delegation, Communication and Participation.
- Job Description and Analysis, Job evaluation.
- Inter-personal relation.
- Recruitment procedures.
- Motivation, group Dynamics.
- Training and Development.
- Disciplines and Grievances.
- Performance Appraisal.

Unit.3. Financial Management
- Resources Mobilization
- Budgeting Techniques and Methods PPBS, Zero Based Budgeting
etc.
- Budgetary Control.
- Cost effectiveness and Cost Benefit analysis.
- Outsourcing.
Unit. 4 Reporting
- Types of reports, Annual report-compilation, Contents and style.
- Library Statistics etc.
Unit 5 System Analysis and Design
- Library as a system
- Project Management PERT/COM
- Decision Tables.
- Performance evaluation standards, MIS.
- Performance Measurement, reengineering, Time and Motion
Study
- SWOT ( Strength Weakness Opportunities Threat)
- DFD (Data Flow Diagram)
Unit 6. Total Quality Management (TQM)
- Definition, Concept, Element
- Quality Audit, LIS related standards.
- Technology Management.
Unit. 7 Library House Keeping Operations.
- Different sections of Library & Information Center and their
functions.
- Collection Development and Management Policies Procedures.
- Book Ordering (Acquisition)
- Technical Processing.
- Serials Control, Circulation Control, Maintenance etc.
- Stock Verification- Policies and Procedures.
- Evaluation and Weeding.
- Archiving-conservation-Preservation.
- Restoration including Print, Non-Print and Electronic Materials.
Unit.8 Planning
- Concept, Definition, Need and Purpose, Types.
- Policies and Procedures, MBO
- Building and Space management in Libraries and Information
Centers.
- Library Building, Interior & Exterior, Furniture, Equipment’s,
Standards & Types.
- Risk Management, Contingency Management.
- Planning of related Infrastructure, Library Standards.
Unit 9. Management of change.
- Concept of change.
- Changes in Procedures, Methods, Tools and Techniques.
- Problems of Incorporating Change.
- Techniques of Managing Change.

Part V: Information Sources & Services

Unit 1. Reference and information sources.
- Documentary Sources of Information, Print, Non-Print including
Electronic: Special features, Scope, types
- Nature, Characteristic, Utility and evaluation of different types of
Information sources: Physical formats, Authority, Content, Utility.
- Non-Documentary Information Sources.
- Reference Sources Categories, Primary, Secondary & Tertiary
Information Sources.(Encyclopedia, Dictionary, Periodical,
Thesis, Books, Year book, Patents, Trade literature, standards,
Monographs, Reference Books, Year Books, Almanac, Atlas,
Abstracting & Indexing periodicals, Bibliographies, Handbooks
etc.)
- Internet as a Source of Information.
Unit.2. Reference Service.
- Concept, Definition, Need, Scope and trends.
- Reference Interview and Search Techniques.
Unit 3. Information Services and Products
- Information services and Products.
- Information services concepts, Definition, Need and trends.
- Need, Techniques and Evaluation of Alerting services (CAS
&SDI)
- Bibliographic, Referral, Document Delivery and Translation
Services.
Unit.4. Information System and their Services.
- Study of National, International and Commercial Information
Systems and Services- Background, their Services and Products.

Part VI: Library Users

Unit 1. Techniques of Library and Information Centres Survey.
- Proforma method.
- Interview method.
- Records analysis method.
Unit.2. Information users and their information Needs
- Categories of Information users.
- Information needs definition and models.
- Information seeking behaviour.
Unit.3 User Education
- Goals and Objectives level, Techniques and Methods, Evaluation
of Users Education Programmes.
Unit. 4. User Studies.
- Methods and techniques of User studies.
- Evaluation of User studies.
Unit 5. User Orientation Programmes:
- Conventional and modern Techniques: Study tour, Newsletters,
Handbooks, Leaflets, Powerpoint Presentation, Websites etc


Tips for Preparation
First - prepare from the BLISc/MLISc notes (IGNOU study materials are really good)
Solve the previous NET Question papers/sample papers
Read books on School Library management, Library automation, recent trends in Library & Information Science
Learn about the functioning of Kendriya Vidyalaya libraries, various programmes and activities, library services - you may visit the websites or blogs of KV Libraries for information.

Go through the following materials

Books

kvs tgt librarian study guideTGT Librarian KVS



Useful Websites

Tuesday, 5 March 2013

Story of a Pencil - by Paulo Coelho

The following presentation is made from the story taken from Paulo Coleho's book "Like the Flowing River" - one of my favourites. Hope you enjoy it!


Monday, 29 October 2012

S.R Ranganathan

Father of Library Science
S.R Ranganathan
Painting by Mr. A Ramakrishna
ART Teacher, KV No.2 Vijayawada

Shiyali Ramamrita Ranganathan is considered as the Father of Library Science in India.
Ranganathan's major contributions to library science were in classification and indexing theory. His Colon Classification (1933) introduced a system that is widely used in research libraries around the world.   His Five Laws of Library Science (1931) was widely accepted as a definitive statement of the ideal of library service. He also drafted plans for a national and several state library systems, founded and edited several journals, and was active in numerous professional associations.
Ranganathan was born in Shiyali in Tanjavoor District of Tamil Nadu on 9th August 1892.
In 1962 he founded and became head of the Documentation Research and Training Centre in Bangalore, with which he remained associated for the rest of his life, and in 1965 he was honoured by the Indian government with the title of national research professor in library science.
He died on September 27, 1972.