How much does a cubic yard of concrete sand weigh?

That depends on the pounds per cubic feet (PCF) of the the sands. Sand will vary from one place to another.

Assuming 106.5 pcf, 1 cubic yards (27 cubic feet) would be 1.44 tons, but 2 tons would be the 2 tons recommended order for safety's sake. A like to a sand calulator is attached.