Question How to count points for marks (1 Viewer)
- Thread starter butek
- Start date
Im a teacher and I must prepare recruitment system .
So
My future students (candidates) have any marks from previous school. My school give for their marks points. Who have the most will be future students my school.
So I have to change marks to points. Teacher who will be work with my aplication will be write only marks and system convert it to points.
Good explantion ?
MajP
You've got your good things, and you've got mine.
- Local time
- Yesterday, 23:04
- Joined
- May 21, 2018
- Messages
- 8,525
If I understand correctly it looks like you are saying that points equals 2 * Marks. Is that correct? Is there more to it?
for 5 marks = 10 points,
for 4 marks = 8 points
3 marks = 6 points
for 5 marks = 10 points,
for 4 marks = 8 points
3 marks = 6 points
Sorry for my english marks=grade
So for grade 5(grade)= 5 * 10=50 points.
Is that clear ?
isladogs
MVP / VIP
- Local time
- Today, 04:04
- Joined
- Jan 14, 2017
- Messages
- 18,209
Butek
When I read MajP's reply, I thought he understood what you meant perfectly.
Now you've mentioned grades for the first time with a 10x multiplying factor.
So I'm unclear again and am going to drop out of this thread.
Good luck with finding a solution.
EDIT:
Now crossposted at http://www.accessforums.net/showthread.php?t=74915
When I read MajP's reply, I thought he understood what you meant perfectly.
Now you've mentioned grades for the first time with a 10x multiplying factor.
So I'm unclear again and am going to drop out of this thread.
Good luck with finding a solution.
EDIT:
Now crossposted at http://www.accessforums.net/showthread.php?t=74915
Last edited:
arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Today, 11:04
- Joined
- May 7, 2009
- Messages
- 19,229
your second table should have both mark and corresponding point, eg:
create a query that will multiply it:
Code:
table2
-------
Mark Multiplier
--------- ------------
3 6
4 8
5 10create a query that will multiply it:
Code:
select mark, dlookup('multiplier','table2','mark=' & [mark])*[mark] as point from table1;arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Today, 11:04
- Joined
- May 7, 2009
- Messages
- 19,229
create another field on the table you want to update (say Point).
then you only need to use update query (if you already made the table i posted a while ago).
then you only need to use update query (if you already made the table i posted a while ago).
Code:
update table1 inner join table2 on table1.markfield=table2.mark set table1.point=table1.mark*table2.multiplier;You want to say that you are indicating the marks to point.
e.g., if the student get 83marks out of 100 and you want to indicate that marks into point. right.
if yes, then
first of all you should know that how much marks is equal to point. say 80-100 marks is equal to 10, 60-80 =8, 40-60=6 and so on......
if you wanted to say above one then you can convert marks into points by using queries...
e.g., if the student get 83marks out of 100 and you want to indicate that marks into point. right.
if yes, then
first of all you should know that how much marks is equal to point. say 80-100 marks is equal to 10, 60-80 =8, 40-60=6 and so on......
if you wanted to say above one then you can convert marks into points by using queries...
