V
vgla
Hi there
My name is Vincent,
In the past, I created tests and quizzes using the "Forms" from Word with
the hope that my boss will agree to have our testing online instead of doing
paper based. Unfortunately I had a lot of resistance from my coworkers so my
request was never approved. A few years has passed and now I may have another
window of opportunity to have the testing done on-line.
My only challenge that goes against me is the marking since I do not know
how to make the score to add automatically instead of me marking the test a
manually.
I tried to read the online help from Word but it was not helpful. It seems
that I need to create a table but I do not understand how. I believe I
already create a table since I can only do forms by creating a table first
but I still can figure out what to do with the formula... please help.
I hope by reviewing my word document sample, It will be simplier that it seems
I attached a sample of a test that I created. The answers are found in bold
blue
Sample
Sections Marks
Section AMultiple Choice – Basics /1
Section BMultiple Choice – Authorizations /1
Section CMultiple Choice – Referrals /3
Total /5
Percent %
Section A – Multiple choice
1. For VISA products, who can request an address change? (1pt)
0 a) CIBC branch on behalf of the primary cardholder
0 b) Primary cardholder and any authorized users on the account
0 c) Primary cardholder only
1 d) Primary cardholder or CIBC Branch on behalf of primary cardholder
Section B – Select all Answers
2. Which address is written in the correct format? (1 pt)
0 a) US$
1 b) Aero Corporate
1 c) Purchasing Card
0 d) Corporate
Section C – True or False (3pts)
When the c/h is NOT present, and there is an authorization realtime
referral, we need to ask the merchant for the customers name and billing
address True
Memos cannot be manually deleted False
It is nessessary to update the MACD screen when ordering a VISA card to a
CIBC branch using rush delivery True
Based on the sample above, my questions are the following
In section A , How can I create a formula that will add 1 pts only if the
answer is D ?
In section B, How can I create a formula that will add 1 pts only if the
answer B and C are selected ?
In section C, How can I create a formula that will add 1 pts only if the
answer correct ?
How can all the scores be shown automatically in marking section ?
Thank you very much for your help
God bless
My name is Vincent,
In the past, I created tests and quizzes using the "Forms" from Word with
the hope that my boss will agree to have our testing online instead of doing
paper based. Unfortunately I had a lot of resistance from my coworkers so my
request was never approved. A few years has passed and now I may have another
window of opportunity to have the testing done on-line.
My only challenge that goes against me is the marking since I do not know
how to make the score to add automatically instead of me marking the test a
manually.
I tried to read the online help from Word but it was not helpful. It seems
that I need to create a table but I do not understand how. I believe I
already create a table since I can only do forms by creating a table first
but I still can figure out what to do with the formula... please help.
I hope by reviewing my word document sample, It will be simplier that it seems
I attached a sample of a test that I created. The answers are found in bold
blue
Sample
Sections Marks
Section AMultiple Choice – Basics /1
Section BMultiple Choice – Authorizations /1
Section CMultiple Choice – Referrals /3
Total /5
Percent %
Section A – Multiple choice
1. For VISA products, who can request an address change? (1pt)
0 a) CIBC branch on behalf of the primary cardholder
0 b) Primary cardholder and any authorized users on the account
0 c) Primary cardholder only
1 d) Primary cardholder or CIBC Branch on behalf of primary cardholder
Section B – Select all Answers
2. Which address is written in the correct format? (1 pt)
0 a) US$
1 b) Aero Corporate
1 c) Purchasing Card
0 d) Corporate
Section C – True or False (3pts)
When the c/h is NOT present, and there is an authorization realtime
referral, we need to ask the merchant for the customers name and billing
address True
Memos cannot be manually deleted False
It is nessessary to update the MACD screen when ordering a VISA card to a
CIBC branch using rush delivery True
Based on the sample above, my questions are the following
In section A , How can I create a formula that will add 1 pts only if the
answer is D ?
In section B, How can I create a formula that will add 1 pts only if the
answer B and C are selected ?
In section C, How can I create a formula that will add 1 pts only if the
answer correct ?
How can all the scores be shown automatically in marking section ?
Thank you very much for your help
God bless