The mod adds in ten of the powers that appeared in Multiplayer to the single player mode ala bonus powers that Shepard can get after getting the Normandy when you start a new game or during an old save. Unlike most other mods, it doesn't the require ME3 Explorer, the multiplayer DLCs, nor the ME3 Console. All you need to to is to drag the files "DLC_CON_BPPack1" and/or "DLC_CON_BPPack2" folders into your Mass Effect 3 DLC folder (Mass Effect 3\BIOGame\DLC). But it does require the WarrantyVoider's DLC Patch, which you can get it here. You can get the mod here.
The powers are listed as follows:
Bonus Power Pack 1:
- Arc Grenade
- Ballistic Blades
- Biotic Sphere
- Smash
- Submission Net
Bonus Power Pack 2:
- Annihilation Field
- Tactical Scan
- Multi-Frag Grenade
- Biotic Slash
- Geth Turret
The main differences between this and the powers in MP (quoted from the page):
- a few of the powers like Smash and Biotic Slash have slightly increased cooldowns to compensate for their power damage in SP
- any grenade power has their Rank 5A evolution, "Max Grenades", increased to 2 grenades instead of 1
- Biotic Sphere has had its overall damage reduction increased, up to a possible 100% damage reduction if the proper Rank evolutions are taken
You can find out more of the mod here on the BSN.