Do I need to send my worker to attend Construction Safety Orientation Course (CSOC) just to cover the 3 or 6 months period until the work permit expires?

Yes, your worker must attend the CSOC to cover the entire duration of the work period till he departs from Singapore.