Hi Cindy,
Slightly tongue in cheek - but really very important - take real good care of the spreadsheet file !!
If you are going to invest time and money in additional storage and organisation maybe consider the following :-
As you say, your aim is to produce separate videos for the kids.
As you import/digitise your raw assets, you could start 'organising' them into say separate folders for each kids video, some will be specific to one project, many will be common to all maybe. Given that its easy to copy clips and storage is relatively cheap, you could start 'building' the assets for each project straight away at this stage and your spreadsheet 'index' could also indicate the usage of each clip.
It sometimes seems a bit excessive but it is a way of avoiding having hundreds (or thousands) of clips/images in one big 'list'.
It's also worth looking at batch re-namers to rename or change lots of clips say by putting kid 1, kid2 or kid3 on the front of the name - kid1_[clip name]. That way you can more easily identify clips by name.
http://www.den4b.com/downloads.php?project=ReNamer
Elements has some capability but some others might be more sophisticated.
I am doing similar things (not for our 5 kids, I hasten to add) and I've found it really daunting trying to organise and rationalise thousands of images from differing sources even if they were all sorted into differing folders etc. I ended up with 14,000 + images that I had to de-duplicate down to 8,000 + eventually and then catalogue those. Still haven't finished.
I settled on something like Elements because I use it anyway for image editing and it also plays most video files quickly so it's easy to check (2 or 10 years later!) what the clip actually was about, rather than just the name, date etc.
Cheers
Adrian
Life is really simple, but we insist on making it complicated. (see below)
Confucius
AMD Phenom IIX6 1055T, win10, 5 internal drives, 7 usb drives, struggling power supply.