YouTube provide many prior examples of projects from Science Olympiad competition.
As to each subject, the student needs to study the CD provided by the organizer. The CD or scope of the subject with rules is the bible for the contest. For example, Optics often test a contestant's ability to redirect light to a differnt position, for example, by bypassing several objects in the orginal light path, to reach the final destination.
Simple calculation plus practical design of homemade tools, when allowed, would help the contestant beat others.
Rocks and minerals, on the other hand, test a constestant's knowledge of specifica facts. Unless the contestant has good memory, spend time on memorizing all sorts of facts, and has hands-on experience of differentiating different rocks, there is no chance to win. Go to natural history museum locally or nationally, browse the internet for pictures of rare rocks, buy a few books about the subject, and pay attention to the environment when walking. That would give the contestant a better chance of winning.
Biology or chemistry related subjects need extra learning of the science and experiments involved in each year's topics. Pay close attention to the rules and scopes. No need to explore more but become aware of related scientific principals and basic experimental skills.