The F. Scott stands for Francis Scott – which means that, yes, Fitzgerald was named after his distant relative (second cousin three times removed) Francis Scott Key, the man who wrote the words to "The Star-Spangled Banner." This is only slightly ironic, given the portrayal of the American Dream in The Great Gatsby. (source)
There's a rock band called Gatsby's American Dream. Guess someone was paying attention in English class.