DS is 10 (Year 5) and has 'the spikiest profile ever'. No diagnosis but AS, dyslexia and dyspraxia have all been sugested to us, however nothing quite fits. He's always been highly sensitive but is becoming better at coping with change and disappointment. Main challenge is literacy; he gets a lot of 1:2 support in class and the goal is to get him up to the reading level of a 'normal' Year 4 student when he's coming to the end of Year 6. This is a daily struggle. He may have just cracked the reading code. 
He is also not great with general knowledge; money, geography, months of the year, that sort of thing. Sounds awful to say it but just not 'intelligent' in the academic sense.
However he's a lovely, kind, fun boy with great social skills and creativity. Very artistic. He makes friends and maintains them, and is becoming more independent and confident with chores, sports and play dates. He walks himself to school, remembers PE kit etc.
OK so secondary school is looming. What should we think about? Will he be able to absorb neccessary information without the TA support he is used to in class? And what jobs could he do in the future?
He's growing up fast and for the first time I'm feeling worried and sad for him. How do I best support him?
I would really appreciate your positive stories please.