For modules using ExtUtils::MakeMaker:

perl Makefile.PL PREFIX=/foo/bar
[download]

BTW, you can use CPAN::Mini to create a small CPAN mirror in some computer with full Internet access, burn it into a CD or DVD and then configure the CPAN module on your development machine to use that CD as its CPAN "mirror".