There is a way to configure yum locally, but you will need to copy all the RPMs to a directory, then point yum to it. Since you don't have a network connection, here goes...
1) Set up a directory, for example /usr/local/RPMS
2) Copy the .rpm files in each of the RPMS directories from the install CD's to this directory. (I would suggest cp -a *.rpm /usr/local/RPMS)
3) Generate header files using either yum-arch or createrepo. createrepo is suppose to be a replacement for yum-arch. I don't have FC6 yet so I don't know which one it comes with.
4) Configure the yum.conf file to use this directory. Here is an example.
# See the yum.conf(5) man page for information on the sytax of this file,
# including failover setup.
name=Fedora Core 6 Original Packages
You should then be able to use yum to get packages that are on your local system. Note: The reason we copied all the RPM's is so you don't have to go through the process of figuring out dependencies. Yum will do that, but the dependent packages have to be there.