A teacher got drunk at a school's end of year prom, told male pupils the girls were "gagging for it" and threatened to "knock out" the school principal, a panel heard.
Music and drama teacher Lewis Morrison, 29, had earlier handed in his notice at Albion Academy, Salford.
He had drunk "six or seven pints" and a video of him shouting and swearing was later shared on social media.
The professional conduct panel ruled it was a "one-off".
Mr Morrison, who had worked at the school since 2014, was asked to leave the Year 11 prom, held at Hotel Football, Old Trafford on 29 June 2018.
Witness A told the hearing Mr Morrison had been seen "sloshing around his pint and swaggering".