WINISIS for teaching

ISISMARC 1.542 is no more available for download at UNESCO website at the URL http://www.unesco.org/webworld/download/isis/isismarc/setup1542.zip.  However, the snapshot of the above is available at URL using Wayback Machine   Click here to download.

The following link contains the raw data of a hypothetical library.  You can use it for Pivot Table exercise in Excel.

https://drive.google.com/file/d/1F8HndGUdVqxycLxhwl-wTNfP_kQ6MDx_/view?usp=sharing 

Google Scholar Library - Google Scholar Blog

I found out this by serendipity.  May be useful for many.  Google Scholar Library - Google Scholar Blog

Seminar Topics for MPhil

Names of Students	Exercise	Reference Book
1) Abilash 2) Boraiah	Design a relational database corresponding to the E-R diagram of Figure 3.38.  Add a few records of your own.	Dababase System Concept.  A. Silberschatz, H.F. Korth and S. Sudarshan
3)  Girish 4)  Harisha	Consider the relational database of Figure 3.39, where the primary keys are un- derlined. Give an expression in the relational algebra to express each of the following queries: a. Find the names of all employees who work for First Bank Corporation. b. Find the names and cities of residence of all employees who work for First Bank Corporation. c. Find the names, street address, and cities of residence of all employees who work for First Bank Corporation and earn more than $10,000 per annum. d. Find the names of all employees in this database who live in the same city as the company for which they work. e. Find the names of all employees who live in the same city and on the same street as do their managers. f. Find the names of all employees in this database who do not work for First Bank Corporation. g. Find the names of all employees who earn more than every employee of Small Bank Corporation. h. Assume the companies may be located in several cities. Find all companies located in every city in which Small Bank Corporation is located.	Dababase System Concept.  A. Silberschatz, H.F. Korth and S. Sudarshan
5)  Hasan 6)  Hemavathi	Consider the following employee database schema (Figure 4.13), where the primary keys are underlined. Give an expression in SQL for each of the following queries. a. Find the names and cities of residence of all employees who work for First Bank Corporation. b. Find the names, street address, and cities of residence of all employees who work for First Bank Corporation and earn more than $10,000. c. Find all employees in the database who do not work for First Bank Corporation. d. Find all employees in the database who earn more than each employee of Small Bank Corporation. e. Assume that the companies may be located in several cities. Find all companies located in every city in which Small Bank Corporation is located. f. Find the company that has the most employees. g. Find those companies whose employees earn a higher salary, on average, than the average salary at First Bank Corporation.	Dababase System Concept.  A. Silberschatz, H.F. Korth and S. Sudarshan
7) Mahadeva S. 8)  Mutturaj	Develop the E-R diagram for an online bookstore. Books are identified by ISBN codes, written by authors and sold at a given price. Books are published by publishers. The online bookstore has several warehouses with a given stock-level for each title, whereas each book may be present (at different quantities) in different warehouses. Customers create accounts (assume that user_id is their email) and in each session they make a shopping basket.
9)  Rajesh H.T. 10) Shivaraju M.	Exercise No. 4.3 (4th edition, page 144).	Dababase System Concept.  A. Silberschatz, H.F. Korth and S. Sudarshan
11)  Sowmya 12)  Sunitha	Exercise No. 4.1 (4th edition, page 143).	Dababase System Concept.  A. Silberschatz, H.F. Korth and S. Sudarshan
13) Vasantha 14)  Yogesh Kumar	Exercise No. 3.8 (4th edition, page 129).	Dababase System Concept.  A. Silberschatz, H.F. Korth and S. Sudarshan

ISCII

Read this interesting article in Kannada about ISCII
http://www.kagapa.in/Lekhana2.html

ASCII Introduction

Use this for introducing the concept of ASCII.  Computers need to understand each other to communicate. 

MARC by the Numbers

I happen to visit this website which gives details about number of tags, subfields and other units used in MARC21.  

Source: http://futurelib.pbworks.com/w/page/13686649/Data%20and%20Studies

MARC by the Numbers (With Apologies to Harper's)

The MARC21 Bibliographic Format, by the numbers

(with apologies to Harper's Magazine)

(Note: all figures exclude fields 863-887)

Number of total tags defined in the MARC21 bibliographic format: 182

Number of variable field tags: 175

Total number of subfields defined: 1711

Total number of unique subfields, based on their names: 551 (32%)

Number of the 352 indicator positions that are undefined: 211 (60%)

Number of subfields that are a type of title: 87 (5%)

Subfields in order of occurrence: $a: 174; $8: 172; $6: 161; $b: 108; $c: 83; $d: 70; $7: 67; $g: 56; $n: 52; $h: 50; $3: 50; $z: 46; $f: 45; $k: 45; $e: 44; $x: 41; $m: 39; $u: 38; $t: 37; $2: 37; $s: 35; $p: 33; $o: 32; $i: 29; $y: 29; $r: 28; $l: 27; $v: 20; $5: 20; $w: 17; $j: 17 $4: 14; $q: 14; $1: 0; $9: 0 (Note: numeric subfields generally have the same value in every field in which they appear. Non-numeric subfields can have a different value in every field in which they appear.)

Number of fixed field values (006-008): 2401

Number of 006 values: 688

Number of 006 values that are unique: 0

Number of 007 data elements defined: 118

Number of unique 007 data elements (based on their names): 55 (47%)

Total number of 007 data values in all 007 positions: 867

Number of 007 unique data values in all 007 positions: 434 (50%)

Number of 007 data values that are defined as "Unknown": 70

Number of 007 values that are "Other": 66

Number of 007 values that are "No attempt to code": 90

Total percentage of 007 values that are one of the three above: 26%

Number of 008 data elements defined for all formats: 82

Number of unique 008 data elements (based on their names): 58 (71%)

Number that are obsolete: 17 (21%)

Number of 008 data values in all positions: 846

Number that are unique: 485 (57%)

Number of 008 data values that are "Unknown" or "Other": 51 (6%)

Approximate number of defined data value lists included in the MARC21 standard: 201

To check these values, or try for others, I (kc) have two tab-delimited files that can be uploaded into a database or spreadsheet. They are:

• Fixed fields

The data elements are:

tag (3 digits, e.g. 006)

format to which it applies (3-5 chars, e.g. MUSIC)

position in the field (2 digits, e.g. 01)

vocabulary name (var char, e.g. Motion picture presentation format)

MARC code for the value (1 char, e.g. p)

textual name of value (var char, e.g. Standard sound aperture (reduced frame))

• Variable fields Updated 3/8/2010

The data elements are:

MARC Tag (3 digits, e.g. 010)

Subfield (1 to 3 chars. If Subfield="n/a" then this is an indicator position. Position (next data element) is indicator position)

Position (2 digits, e.g. 02; if "n/a" then this is a subfield, not an indicator)

Data Element (var char, name of data element from MARC21 concise)

Use of apostrophe

One of my students - Raghu - has sent me this article on apostrophe.  I found it interesting too.

http://www.livemint.com/Opinion/JplhLh0YZeoFX0cd6SbOMN/Aspects-of-the-apostrophe.html

Dvorak Keyboard Design

Students of MLISc second semester of the University of Mysore 2013 batch did a small experiment to test the alphabet frequency in a given text.  Four students took one page each from a randomly selected text book and counted the alphabet frequency.  The results are shown below.  This experiment was done in connection with the alphabet arrangement in the home row of the Dvorak Keyboard design. The result showed that the alphabets on the home row and the top ranked alphabets in the experiment done by the students match to a very great extent; and thus testifying that the most frequently used alphabets are place on the home row of the Dvorak Keyboard.

Alphabet	Student 1	Student 2	Student 3	Student 4	Total	Percent
e	151	116	180	200	647	12.01
t	119	94	165	139	517	9.60
a	131	78	135	129	473	8.78
o	112	90	110	111	423	7.86
i	150	70	78	124	422	7.84
r	100	74	81	98	353	6.56
s	106	64	78	91	339	6.30
n	110	52	77	82	321	5.96
l	63	63	38	78	242	4.49
h	50	28	77	69	224	4.16
d	66	44	60	39	209	3.88
c	65	46	46	48	205	3.81
f	48	28	31	56	163	3.03
m	28	18	48	51	145	2.69
u	20	28	35	55	138	2.56
p	29	28	31	38	126	2.34
g	38	12	26	19	95	1.76
b	34	18	17	18	87	1.62
w	10	14	33	27	84	1.56
y	11	10	20	19	60	1.11
v	15	9	16	12	52	0.97
k	0	4	4	11	19	0.35
q	0	0	4	11	15	0.28
j	0	12	0	0	12	0.22
x	2	5	3	2	12	0.22
z	0	1	1	0	2	0.04
					5385

Continuous Assessment Marks - C1

Course: Information Retrieval System Year: 2011 Semester: 3rd
Continuous Assessment Marks - C1
Name Marks for 25

L111001 20
L111002 20
L111003 22
L111004 18
L111005 21
L111006 21
L111007 17
L111008 19
L111009 20
L111010 22
L111012 20
L111013 12
L111014 18
L111015 17
L111016 18
L111017 18
L111018 19
L111019 18
L111020 18
L111021 20
L111022 18
L111023 16
L111024 18
L111025 17
L111026 18
L111027 16
L111028 17
L111029 16
L111030 18
L111031 15
L111032 18
L111033 18
L111034 18

Private Secretary

I joined as Private Secretary to Vice-Chancellor in the second week of May 2011. It was a surprise call by Prof. V.G. Talawar inquiring about my opinion to take up the new assignment. I was thrilled. In fact, I wanted some change. I got it when I just needed.

My past two months experience is great. I am learning many things over here. Lot of people to talk to, lot of work to do, lot of fun as well.

Metadata Dance!

You want to understand metadata? See the following video.

English Improvement Resource

We constantly encounter problems in usage of words. Chicago Manual of Style is a resource which helps to overcome this problem. I have subscribed (free) for their Question and Answer (Q&A). It helps me to get answers for many doubts. Today, I just visited the site http://www.chicagomanualofstyle.org/CMS_FAQ/qatopics.html.

Reference Manager Software

I have been working with a few referencing software. I am yet to master one! I find new features in each of them. I am interested only in open source version. The reason is obvious. I don't have enough penny to purchase the commercial ones. Some of the software that I am working include Zotero, Mendeley, JabRef, CiteUlike, Bibme, RefWorks, Referencer(Linux), Connotea, etc.

Are libraries finished? Five arguments for and against

Find the following interest article on the subject. Click here

Koha Exam Online

I have a special experience today when I conducted the practical exam on Koha in cloud computing mode. It was possible with the positive cooperation of OSS Labs. They extended all their support during training and examination period. This environment has remove all the headaches for us regarding installation and maintenance of the software. My personal thanks to OSS Labs for this.

Killer English

The following email was received by me recently... Enjoy reading it!

Killerrrrrrrr English....



Principal to student... : " Tomorrow call your parents especially mother and father

(Any other options???)

************ ********* ********* ********* ********* ********* ********* ***

Class teacher once said :

"Pick up the paper and fall in the dustbin!!!"

(Who??? paper or student???)


************ ********* ********* ********* ****

Once Hindi teacher said...."I'm going out of the world to America..."

(hmmm...interesting)

************ ********* ********* ********* ****

"..DON'T TRY TO TALK IN FRONT OF MY BACK..."

(Topsyturvy)

************ ********* ********* ********* ****

Don't laugh at the back benches...otherwise teeth and all will be fallen down.....

(Grrr....this person needs Basic Communication Skills Class Room Training)

************ ********* ********* ********* ****

It was very hot in the afternoon when the teacher entered. She tried to switch the fan on, but there was some problem. And then she said

"why is fan not oning" (ing form of on)

(New Discovery)


************ ********* ********* ********* ****

Teacher in a furious mood...

Write down your name and father of your name!!

(Excuse me...)

************ ********* ********* ********* ****



"Shhh... quiet... the principal is revolving around college"

(Gr8...is he a satellite or sumthing???)





************ ********* ********* ********* ****



"I'll illustrate what I have in my mind" said the professor and erased the board

(What an illustration...I like this professor)



************ ********* ********* ********* ****



"Will you hang that calendar or else I'll HANG MYSELF"

(Well, you can proceed, would U like to leave a note behind as well...)



************ ********* ********* ************ *



LIBRARIAN SCOLDED," IF U WILL TALK AGAIN, I WILL KNEEL DOWN OUTSIDE"

(That will be better....)



************ ********* ********* ********* ****



Chemistry HOD comes and tells us...



"My aim is to study my son and marry my daughter"

(No Comments...!!!)



************ ********* ********* ********* ****



"Why are you looking at the monkeys outside when I am in the class?!"

(Because we want to check similarities :-) )



************ ********* ********* ********* ****



Lab assistant said this when my friend wrote wrong code...



"I understand. You understand. Computer how understand??

(In terms of 1's n 0's)



************ ********* ********* ********* *****

Seeing the principal passing by, the teacher told the noisy class,

"Keep quiet, the principal has passed away"

(2 minz of silence)

****************************************

The master told the students who were notorious.

"Hey, from tomorrow onwards you both come together separately"

(Make it possible and I will reward my life time savings...)

********************************************

Master to his students "Do you know? I have 2 daughters. Both are girls!!!"

(You need some counselling dude...)

****************************************

Hindi master to his students by pointing his scooter that is parked under a tree,

"See there.My scooter is understanding the tree!!!"

(Wow... )
*****************************************

master rocks again,

"Okay guys, all of you stand in a straight circle!"

(Wow what an oxymoron...)

TCP/IP Protocol

The following video is an excellent video on YouTube

Video on Mr. Bean

Script for Smilies

script src="http://mltan100.googlepages.com/emoticons.js" type="text/javascript"/