Should I do this upgrade on my computer (mobo and CPU)?

Your not really upgrading much, AGP is outdated and garbage, get a board with PCIE- 2.0 and if you want to change your cpu, go for a quad. Then you will upgraded and updated on new hardware.