Monday 31 January 2011

Travel to the past

My heart went "thumpity-thump" looking at the number of Egyptian Mummies and the Sarcophagus covering the entire hall. My husband simply giggled when I hurried to move out of the area. He was taking pictures of 'them' , with my 5 year old son commenting about the skeletons and skulls seen around.

I gave a sigh of relief when we entered Asia. Oh goodness! Did I tell you we were in the British Musuem?

British Museum is one of the most popular 'must see' place in London. The British Museum displays a wealth of antiques and collections from various parts of the world acquired by Britain mostly during colonial era. The exhibits are arranged geographically which gives a sense of visiting the whole world region by region.

Apart from 'Mummies', Egypt houses lots of statues and sculptures that dates back as far as 5000 BC. Many of them are the Gods and Goddesses worshiped by the ancient Egyptians.






Rosetta Stone

Another significant masterpiece is the 'Rosetta stone' . The stone is more than 2,200 years old and stands one meter high and has inscriptions of the pictorial script of Egyptians,the Hieroglyphics. It's not just the Hieroglyphics that make it significant, but the presence of various other inscriptions in other forms/languages that helped historians to decrypt the Hieroglyphics. Yes, it is a keystone, a dictionary to the Egyptians past.

Assyrian sculptures portraying wars and customs of those days are sure an evidence of architectural richness of the past. Admiring them, I could reckon the Ellora sculptures seen in India.

Asia is again primarily statues of Gods and Goddess. There are less exhibits from India. I found most of the valuables and precious stones from India are mainly spread in Queen's gallery and Windsor castle.


It is impossible to miss the tall statue of Buddha covering 2 floors outside the Japan gallery. Japanese gallery houses various forms of Buddha apart from a few art collections. One can understand the scarcity of artifacts from Japan from the context that it was not under colonial rule.

Weapons and Pottery covered most of African exhibits. Some of the modern art exhibits portrayed the never ending African civil wars. One of the exhibits that caught our eyes at the end of the African gallery were the bronze sculptures from Benin which was under French rule in the colonial era.


By that time , we (especially my kid) needed a break. So we went down to have our packed sandwiches.

Post lunch, we continued to Greece and Rome. We were delighted to see the head statues of young Alexander and that of philosophers like Socrates. Most of the statues are made of white marble which added to their charm.

Nereid Monument
The next big thing that awed us was the exhibit of an entire monument dating back to 390 BC standing up live. It is the Nereid Monument, named after the statues of daughters of Greek sea god Nereus, standing between the huge pillars of this monument. It is indeed a tomb built for Arbinas (also spelled Erbinna), ruler of Lycian Xanthos. I wonder how they managed to transport such huge pillars !

The next thing that took our breath was the Parthenon temple of Greece (also known as Elgin Marbles). It seems that this massive temple got destroyed in a fire accident in 1600s. The remains were brought from Greece and arranged here to re-create the effect of how it existed. Plan to visit this in the beginning in case you run out of time ....

Finally it was Modern Europe. Huge mechanical clocks and other inventions of the early 19th century occupied the entire area. By the time we finished Europe, my son's patience reached its limits and we had to return home.

How to go to the Museum?
5 minutes walk from Holborn underground station. Also close to Covent garden station.

The Museum History
The Museum was established by Act of Parliament in 1753 when the government acquired the private collection of Sir Hans Sloane (1660–1753), who was a successful physician by profession but a naturalist and antiquarian by inclination; it consisted of ‘books, manuscripts, prints, drawings, pictures, medals, coins, seals, cameos and natural curiosities’. In 1759 the museum opened in Montagu House, a large 17th-century mansion in Bloomsbury. Initially it was not freely accessible to the public; for nearly 50 years it was necessary to make formal application for admission. With the acquisition of Sir William Hamilton's collection of classical vases and antiquities (1772), a plethora of Egyptian antiquities (including the Rosetta Stone donated by George III) at the turn of the century, the Elgin Marbles (1816), the magnificent library of George III (1823), and many other bequests and purchases, the Museum became established as one of the world's greatest treasure houses.. There have subsequently been various other additions to the building.


Apart from tourists, the museum attracts lot of students.

Duration to plan
You will need atleast 3 hours to atleast have a look at all the key exhibits. Surely, not recommended with little kids :-)

Wednesday 19 January 2011

MS- Excel : Highlight Duplicates

Conditional Formatting in Excel is very powerful tool and comes in very handy for data management.

For example , if you have huge data and you would like to highlight duplicate values, it can be done using 2 simple steps. Sort the column for which you want to highlight duplicates
  • Select Conditional Formatting (It is in Home toolbar in Excel 2007) and choose
    Highlight Cells Rules --> Duplicate values and choose the color of your choice

Task accomplished ! Similarly there are other options in Conditional Formatting to highlight 'greater than' or 'less than' etc. ..

Tuesday 11 January 2011

How to make a cell into a Drop-down combo-box in MS-Excel – Part 2


In the last post we saw how we can make a simple combo-box with a small list of values. Now we will see how we can make a drop-down combo with a huge list of values, in which case it will be cumbersome to write down all those values in the Source field of the Data Validation dialog.

HOW TO: MS-Excel - Create a Combo-box with a huge list of values

In this case, we can use a range in the Source field of the Data Validation dialog, which MS Excel uses to identify the values to be provided in the combo-box. Simply list the values to appear on the drop-down list in a spreadsheet column and provide the range of this list in the source field.

We can see how with an example.


Now the drop down appears as below with all the values from the range.



Optionally you can hide the column containing the values, here column D to make the spreadsheet appear neat. To do this, right-click column D and select hide as in the figure below.


By doing the above the spreadsheet combo-box looks as below.




Tip: You can also name the range, so that the source can just refer to the name, say ‘=fruits’ as below.



To name the range, just select the range and type a name for that in the name box which is to the write of the formula bar as given below.


Cool, isnt’t it!

Hope you liked this. In the next post we will see how we can make a much more complex drop down, where in the combo-box value is dependent on the value in another cell. This will be particularly useful when we have a category and sub-category classification.

Monday 10 January 2011

How to make a cell into a Drop-down combo-box in MS-Excel – Part 1

Ever wondered how some of the professional MS Excel spreadsheets work like windows forms with a drop down combo-box built into a cell of the spreadsheet? Actually, it’s quite simple. I will explain in the below article how this can be done.

A simple combo-box
A combo-box is supposed to contain a list of values from which a user can pick the desired one, like the one below.

This can be achieved as described below.
  • Select the cell in which you need the drop down to be implemented. In the above image it is B2.
  • Click Data Validation under Data Menu and select List in the Allow combo box.

  • In the Data Validation dialog box, type the values you would like to see in the combo box list separated by commas in the Source field as in the figure below and click OK.


That’s it; your cell now becomes a combo box as indicated by the down arrow control that appears in the cell. Click the down arrow to see the list of values and pick and select to test.

Cool isn't it!
In the next post, I'll let you know how to make a combo box list with too many values wherein it'll be pretty difficult to type in all the values in the Source field.
To be continued... 

Wednesday 5 January 2011

How to teach time telling to your kids?

Most of the parents find it hard to teach their kids to read time. Here are the tips to teach them in an easy way, provided they are familiar with numbers.

  • First, start with hours. Teach them to identify exact hours like 1 pm, 2 pm etc.. They learn this easily. Practice this for couple of days by asking them the time whenever it is exactly hourly time.
  • While they are learning hours, teach them jumps of 5 i.e. 5, 10, 15 ... 60. They should know this thoroughly.
  • Next, teach them only minutes. As they already know jumps of 5, they can count and say the minutes easily.
  • Finally, combine the hours and minutes. The only problem they face here is , they get confused with hours , if the minutes cross 30. As the needle moves beyond the exact hour, it causes confusion. We have to make them understand , unless the needle crosses the hour it is the previous hour. For ex. for 9:45, they say 10:45 , as the needle is closer to 10 than 9. As it has not crossed 10, it is only 9.
  • Keep asking them to read  time for couple of days. 



  • They will learn to read time in less than a weeks time. If your kids are still not comfortable, you can also make use of the time telling games from the below website.




Rewarding system for kids

'How do I make my child disciplined?' remains a nightmare for most of the parents. Apparently, with the media influences and peer pressure, it becomes a herculean task.

One most popular method parents adopt to inculcate discipline among their kids is the 'rewarding system'. But many times, it remains only a fruitless struggle. Here are some tips to parents to make it more effective..

  • Irrespective of whatever rewarding methods you follow, 'spot recognition' is a must. Be generous in appreciating your child as and when they do it right.
  • Follow a activity chart. Split up the activities , so that the child clearly understands the activity for which he/she earns points. Reward charts are available in shops but it is better to prepare a customized one yourself. Add points as and when they complete the activity. It does not serve the purpose , if it is delayed.



  • Based on the points, plan for a reward every week. If it is prolonged, the child will lose interest. Decide the reward based on your child's interest like a toy, taking out for a movie etc..

  • As kids get bored more quickly, keep revising the rewarding methods. Instead of a chart, follow a piggy bank and give a small amount every time they finish the task successfully. By this way, children get familiarized with currency. You can also ask them to count the money by giving them in lower denominations. This helps them in improving their maths.



  • As each child is unique, plan your rewarding method, rewards and frequency of rewarding according to it.
    All the Best !

    Update:

    Our friends Dhivya and Hari implemented a rewarding system that worked out very well for them.
    Their son, Pranhav's chart and certificate are below.























    They implemented the same for their daughter as well and the results are below.
























    It's really good to see how much these kids had responded to this method! Simply great!
    Congrats, Hari & Dhivya.