If they setup sharing on the internet connection, you can connect to their computer via LAN cable (needs to be crossover) and use it that way. Otherwise, you need to hook up the modem directly to your machine, install the driver, and use it that way.
Remember as you surf that it's a normal phone call, so your host family will be paying X yen per minute to use it.