An unexpected Civil War discovery has sparked an interest in archaeology and brought local history to life for one schoolboy.