Man charged with attempted murder over social worker attack