For your reference, here are a number of examples of film and television title sequences (historic and contemporary), along with a few good examples of student title sequence work.

Professional title sequences:

North by Northwest (1959) / title design by Saul Bass

The Man with the Golden Arm (1955) / title design by Saul Bass

Charade (1963) / main title design by Maurice Binder, animation by Robert Ellis

The Twilight Zone (1959)

Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb (1964) / title design by Pablo Ferraro

Fahrenheit 451 (1966)

The Rocky Horror Picture Show (1975)

Alien (1979) / title design by Richard Greenberg (R/GA Associates)

Se7en (1995) / title design by Kyle Cooper (R/GA Associates)

Enter the Void (2009) / title design by Tom Kan

Catch Me If You Can (2002) / title design by Florence Deygas and Oliver Kuntzel

Thank You for Smoking (2005) / title design by Florence Deygas and Oliver Kuntzel

Dexter (2006) / title design by Eric Anderson (Digital Kitchen)

Superbad (2007)

Juno (2007) / title design by Jenny Lee and Gareth Smith (Smith & Lee Design)

Mad Men (2007) / title design by Steve Fuller and Mark Gardner

True Blood (2008) / title design by Rama Allen (Digital Kitchen)

The Simpsons (2014) / couch gag by Don Hertzfeldt and…

The Simpsons (2013) / couch gag by Guillermo del Toro

Game of Thrones (2011) / Creative Director Angus Wall, Designer Leanne Dare

Broad City (2014) / title design by Mike Perry