Purpose of 8051/AVR USB programmer in a micro-controller kit
It's an ISP programmer. The IC on it interprets the commands set to it via USB and manipulates the pins on the connector appropriately to program AVR and 8051 MCUs.

JP1 on the dev board is the connector that the cable from the programmer connects to.