I can understand your frustration with high school science. I’m currently in graduate school for Molecular Biology, but I didn’t want to have anything to do with science until college. My memories of high school science are foggy, but I remember a lot of memorizing random facts, and being assigned mindless tasks and calculations. I didn’t even take a science class during my last year of high school, which in retrospect was an excellent decision.
Regarding your question, I think it depends on the specific discipline. For computer science, you can go to the CS section of any bookstore, and find endless tutorial-type books that will give you a basic introduction to any given programing language. After one or two of those, I think that most of computer science is best learned in a project-oriented manner. That is, you find a project that interests you on the internet, and you try to make a contribution to it. You’ll probably screw up the first few times, but during that process you’re going to learn a lot of new skills.
Biology consists of lots of terms, facts, and concepts. Outside of population genetics, there are almost no equations to apply. This means that you can actually develop a knowledge of even specialized fields in Biology rather quickly. Or, to put it differently, the amount of core knowledge required to get a basic understanding of Biology is actually less than any other science. My recommendation would be to try to avoid textbooks and books that are a collection of reviews by different authors. Instead, begin by finding some books for the layman that focus on a subject that’s interesting to you.
Most general chemistry seems to consist of applying equations and understanding concepts, so there’s less memorization required than in Biology. In this case, you’d probably learn it best by running through exercises in a textbook. I’ve never done physical chemistry, but I hear there’s a lot of math involved. Organic chemistry involves a lot of mental spacial manipulation, and it’s completely different from what most people think of as chemistry. It’s also really hard (it’s commonly used to weed out premeds), and a lot of fun if you can find a good teacher. I can’t help much on this, since I was one of the lucky people who had an excellent teacher.
I can’t give any advice for math or physics. I constantly struggled with math, and physics is still very confusing for me.
Since you requested specific resources, the best learning resource I’ve found in general are the lectures from the teaching company:
http://www.teach12.com/
However, the pricing on these lectures is basically insane. They’ll charge hundred of dollars for a course, but all of their products go on sale at least once a year, at which point the price goes from insane to really expensive. The science and mathematics courses also generally require visual aids to completely understand what’s going on, which means you’re stuck with buying the dvds. I really shouldn’t say this, but you can also find several of these lecture series on illegal downloading sites, if you want to get an understanding of how good they are before getting the money together to buy one of the ones on sale.