 Graph for examination grades
|
|
|
Andrew
|
I want to write the code to produce a graph for results for each subject in
our examinations (in England). Our database is in Paradox 9. I can get as far as creating a table with all the marks
in each subject eg marketing with marks ranging in the English way from, say 20% to 75%. Below 40% are fails,
40 to 44 pass, 45 to 49 third class. 50 to 59 lower second and 60 to 69
upper second and above 70 first class. I want to produce the classic bell
graph that shows the numbers in each class, the x axis having the numbers in each class and
the y axis the classes. I have written the code to produce the numbers in
each class as separate answer tables but I just don't know how to go on further. I'll get there eventually but I'd be grateful for any help. I am neither a statistician nor a programmer but like so many have drifted into writing the reports for our database. Andrew
|
| About Andrew |
|
Inactive member.
Member does not subscribe to this thread.
|
Email Not Verified!
Once email is verified, we will review and approve the account.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #10045, 1 replies
Thread Started 12/9/2003 11:35:00 AM
View Counter=3682
Last Reply Posted 12/10/2003 6:40:00 AM)
|
|
|
|
Location=UK
|
|
 |
Most Recent Post
|
|
|
Andrew
|
Now I realise they are called charts I managed to find on the bulletin board some code by rt # 29. I have used this as follows
markSORT.DB | MARK |
| <40,calc count all |
| >39,<45, calc count all |
| >44,<50, calc count all |
| >49,<60,calc count all |
| >59,<70,calc count all |
| >69,calc count all |
eNDquery
fam5qbe.executeQBE("markstat.db")
the markstat answer gives the first four answers but no more even though there is data for a fifth and sixth record. What am I doing wrong?
|
| About Andrew |
|
Inactive member.
Member does not subscribe to this thread.
|
Email Not Verified!
Once email is verified, we will review and approve the account.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #10046 (Level 1.1)
Reply to 10045
Thread Started 12/10/2003 6:40:00 AM
View Counter=2
|
|
|
|
Location=UK
|
|
|
