Students & Evaluation

[Seif]

Dear All,

I'm working on a school system and all going well so far except for one issue.

I have a student table, now what i want to do is to generate an "Evaluation Report" about every student after each quarter, here are the details:

1- I want to create an Evaluation template, where i can create a set of questions under different categories e.g: Technical, Admin etc.. and under each category in the report there are a set of questions with some answers (all checkmarks).

2- I want from the students screen to click a button, open another layout with the student name, select the Evaluation Template i already created (from question 1), then all the questions start to generate in a portal with all the checkmarks (Excellent, Good, Average, Bad) so i can fill the answer then send it to printer or e-mail to give it to parents.

I would really appreciate any feedback to help me design the model above.

Thanks

[mr_vodka]

This is not a trivial task. Do a search on these forums for survey and you should come across some examples.

[Seif]

Hello Mr_Vodka, I already did but didn't find anything relevant to what i'm trying to do

Would appreciate any help.

Thanks.

[Lee Smith]

Sometimes you can find things easier by using the Google search. Try using this in the search bar survey

[mr_vodka]

This is an old thread but it may help you get started...

http://fmforums.com/forum/topic/49072-surveys-and-relationships/page__p__229378

[eos]

This may give you some ideas; it's a bit rough around the edges, the Graph isn't tidied up, and the use of ExecuteSQL is maybe a bit adventurous (no guards against table or field renaming), but the data model should do what you need.

StudentEvaluation.fmp12.zip

[Seif]

Thanks will try these and keep you posted.

Thanks again

[comment]

Hello Mr_Vodka, I already did but didn't find anything relevant to what i'm trying to do

Try:

http://fmforums.com/forum/topic/45972-another-survey-question/

in addition to the link mentioned in post #5.