Webparts missing in MOSS including Content Query WebPart

Scenario:
One of my student is running MOSS Virtual PC and she created a new site collection using Team Site.Now she wanted to use Content Query Webpart but its was not in the Add Webparts pop-up.

Reason:
Reason is very simple. Content Query WebPart and many other webparts are only available in MOSS and will be made available in webpart gallery only if the site collection has been created using MOSS site templates.

If you have created Top Level site using WSS out of box templates like Team Site or Blank site, you will see them missing.

Solution:

Make sure to activate site collection level feature named 'Office SharePoint Server Publishing Infrastructure' feature. Once activated , you should be able to get the CQWP.. if not try next steps

1. Go to a different site collection which was created using MOSS site templates.
2. Go to Site Action > Site Settings Modify All Site Settings > Web Parts
3. Export the defintion ( .webpart file ) of the Content Query WebPart ( or any other which you want to use ) to your desktop.
4. Now go to the site collection which was created using WSS site template.
5. Go to Site Action > Site Settings > Web Parts
6. Import the defintion ( .webpart file ) of the Content Query WebPart ( or any other which you have exported earliere ) from your desktop.
7. Go to Site Action > Site Settings > Site Collection Features
8. Go to Home Page and Add webpart > Select CQWP and configure it as you want.

Possible Errors:
Unable to display the Web Part. To troubleshoot the problem, open the Web page in a Windows SharePoint Services-compatible HTML editor such as Microsoft Office SharePoint Designer. If the problem persists, contact your Web Server administrator.

This might be because you missed the step 8 above and 'Office SharePoint Server Publishing Infrastructure' feature is not active on the site collection.

:-)