Advanced Word template creation/collation

[jimmyhotfingers]

Hello all,

 

I have a complicated problem that I need a simple solution for…

 

I work for a special school that uses several annual report word templates that require manual collation at the end of the report writing process.

 

So an example of the different templates that might be needed would be:

 

Child A:

 

Key Stage 2 Generic report template

Horse riding template

Swimming template

Community visit template

 

Where as Child B might need:

 

Key Stage 5 Generic report template

Work experience template

College placement template

Activity centre template

 

So, what I’m after is some sort of wizard that the user goes through when they open up what I want to be the one word template to rule them all. I see it as Working in the following way:

 

1. Teacher opens the template

2. They get a menu or drop down asking what key stage they are in

3. Then all the templates are collated based on more questions…

4. Does the student do Horse riding?

5. Does the student do Swimming?

6. Does the student do Community visits?

7. Does the student do Work experience?

8. Does the student go to a College placement?

9. Does the student go to the Activity centre?

10. The document is now ready for authoring.

 

Has anyone managed such a system and how did they do it?

 

Cheers in advance…

 

j.

[RabbieBurns]

I think youd be best looking at a database, with a standard Report, and pulling the data into that.

[RabbieBurns]

I think youd be best looking at a database, with a standard Report, and pulling the data into that.

 

So basicaly have a table of students, table of teachers, and table of subjects, then link them up, create a form so the teacher only gets presented with filling in the subjects for that particular student for their subjects, and then the Report output will just pull it all together.

 

Depends on how many students i guess though.

[jimmyhotfingers]

Depends on how many students i guess though.

 

About 240 students, 30 teachers and about 20 templates that would need to be collated.

[RabbieBurns]

How different are the templates?

 

When i redesigned my old schools reporting system, each department were just doing their own ad-hoc reports in their own templates.

 

In the database design I had a table for each subject, where they could put all the blurb for their subject, and that was an area on the generated report.

 

It ended up with a standardised look of the reports, and each depeartment were able to have their own stuff on the page, along with the comments / grades etc.