Yep..usually if you insert the CD and get to its "splash screen" it will have an option that says "SATA/RAID drivers" or something along those lines..you click that and it brings up a little wizard that will ask you what you want (SATA, RAID etc etc) once you select it will say to insert a floppy and load these drivers onto a floppy for you.

Also as eric mentioned this would have be done from another working PC with an OS on it and a CD-ROM drive/Floppy drive. There is nothing you can do with that mobo CD on your current machine with no OS