VBA to create a quiz from problem bank based on images, random weights of topics used The Next CEO of Stack OverflowCreating a new Excel File based on a template in VBAScrollable image in userformProblems using VBA to create a PPT from an excelAutomatically add rows into a MS Word table in a loop as long as you read data from the excel sheetIs there a way to save all hyperlinked documents in excel?How can I determine the best data structure/implementation for my dataset?Problems with creating vba macrosVariable Combination WriterCreating column index in VBA based in multiple conditionsCreating a record for randomized numbers in VBA
Is a distribution that is normal, but highly skewed, considered Gaussian?
Why did the Drakh emissary look so blurred in S04:E11 "Lines of Communication"?
Can I cast Thunderwave and be at the center of its bottom face, but not be affected by it?
Is it okay to majorly distort historical facts while writing a fiction story?
How to implement Comparable so it is consistent with identity-equality
How should I connect my cat5 cable to connectors having an orange-green line?
How exploitable/balanced is this homebrew spell: Spell Permanency?
Can you teleport closer to a creature you are Frightened of?
Incomplete cube
How to pronounce fünf in 45
Car headlights in a world without electricity
What are the unusually-enlarged wing sections on this P-38 Lightning?
What does this strange code stamp on my passport mean?
The sum of any ten consecutive numbers from a fibonacci sequence is divisible by 11
How can I separate the number from the unit in argument?
What happens if you break a law in another country outside of that country?
Planeswalker Ability and Death Timing
Raspberry pi 3 B with Ubuntu 18.04 server arm64: what pi version
Could you use a laser beam as a modulated carrier wave for radio signal?
Plausibility of squid whales
Is it a bad idea to plug the other end of ESD strap to wall ground?
Shortening a title without changing its meaning
Could a dragon use its wings to swim?
How to find if SQL server backup is encrypted with TDE without restoring the backup
VBA to create a quiz from problem bank based on images, random weights of topics used
The Next CEO of Stack OverflowCreating a new Excel File based on a template in VBAScrollable image in userformProblems using VBA to create a PPT from an excelAutomatically add rows into a MS Word table in a loop as long as you read data from the excel sheetIs there a way to save all hyperlinked documents in excel?How can I determine the best data structure/implementation for my dataset?Problems with creating vba macrosVariable Combination WriterCreating column index in VBA based in multiple conditionsCreating a record for randomized numbers in VBA
I'm currently planning to create a quiz creator in excel. I have a set of questions that I have image files & PDF's of (it varies due to the size of the question). The topics are all different, but there are multiple questions on certain topics. I'd like to get some opinions on an efficient way to do this.
Currently my plan is to create a process that looks at a set of syllabus weights and randomly pulls an image into a new sheet as question X (and pulls the corresponding solution PDF/Image). Preferably it should be sampling without replacement so no two same questions on the same topic show up on each quiz.
The part I'm really stuck on is incorporating the syllabus weights (although I'm considering just making it 1 question per topic to bypass this) and how exactly to organize the problem bank in order to make it easier for VBA to embed the PDFs in automatically. Let's say there's around 100 problems in the bank in total, and each quiz is 15 questions. Any advice or thoughts would be highly appreciated.
excel vba
asked Mar 21 at 19:29
TimGTimG
1
add a comment |
I'm currently planning to create a quiz creator in excel. I have a set of questions that I have image files & PDF's of (it varies due to the size of the question). The topics are all different, but there are multiple questions on certain topics. I'd like to get some opinions on an efficient way to do this.
Currently my plan is to create a process that looks at a set of syllabus weights and randomly pulls an image into a new sheet as question X (and pulls the corresponding solution PDF/Image). Preferably it should be sampling without replacement so no two same questions on the same topic show up on each quiz.
The part I'm really stuck on is incorporating the syllabus weights (although I'm considering just making it 1 question per topic to bypass this) and how exactly to organize the problem bank in order to make it easier for VBA to embed the PDFs in automatically. Let's say there's around 100 problems in the bank in total, and each quiz is 15 questions. Any advice or thoughts would be highly appreciated.
excel vba
asked Mar 21 at 19:29
TimGTimG
1
1
Why did you tag this with macos?
– dwirony
Mar 21 at 19:39
My bad, meant macros but just saw the note on that. I've removed that tag.
– TimG
Mar 21 at 21:01
add a comment |
I'm currently planning to create a quiz creator in excel. I have a set of questions that I have image files & PDF's of (it varies due to the size of the question). The topics are all different, but there are multiple questions on certain topics. I'd like to get some opinions on an efficient way to do this.
Currently my plan is to create a process that looks at a set of syllabus weights and randomly pulls an image into a new sheet as question X (and pulls the corresponding solution PDF/Image). Preferably it should be sampling without replacement so no two same questions on the same topic show up on each quiz.
The part I'm really stuck on is incorporating the syllabus weights (although I'm considering just making it 1 question per topic to bypass this) and how exactly to organize the problem bank in order to make it easier for VBA to embed the PDFs in automatically. Let's say there's around 100 problems in the bank in total, and each quiz is 15 questions. Any advice or thoughts would be highly appreciated.
excel vba
asked Mar 21 at 19:29
TimGTimG
1
I'm currently planning to create a quiz creator in excel. I have a set of questions that I have image files & PDF's of (it varies due to the size of the question). The topics are all different, but there are multiple questions on certain topics. I'd like to get some opinions on an efficient way to do this.
Currently my plan is to create a process that looks at a set of syllabus weights and randomly pulls an image into a new sheet as question X (and pulls the corresponding solution PDF/Image). Preferably it should be sampling without replacement so no two same questions on the same topic show up on each quiz.
The part I'm really stuck on is incorporating the syllabus weights (although I'm considering just making it 1 question per topic to bypass this) and how exactly to organize the problem bank in order to make it easier for VBA to embed the PDFs in automatically. Let's say there's around 100 problems in the bank in total, and each quiz is 15 questions. Any advice or thoughts would be highly appreciated.
excel vba
excel vba
asked Mar 21 at 19:29
TimGTimG
1
asked Mar 21 at 19:29
TimGTimG
1
edited Mar 21 at 21:01
TimG
asked Mar 21 at 19:29
TimGTimG
1
asked Mar 21 at 19:29
TimGTimG
1
asked Mar 21 at 19:29
TimGTimG
1
1
1
Why did you tag this with macos?
– dwirony
Mar 21 at 19:39
My bad, meant macros but just saw the note on that. I've removed that tag.
– TimG
Mar 21 at 21:01
add a comment |
1
Why did you tag this with macos?
– dwirony
Mar 21 at 19:39
My bad, meant macros but just saw the note on that. I've removed that tag.
– TimG
Mar 21 at 21:01
1
1
Why did you tag this with macos?
– dwirony
Mar 21 at 19:39
Why did you tag this with macos?
– dwirony
Mar 21 at 19:39
My bad, meant macros but just saw the note on that. I've removed that tag.
– TimG
Mar 21 at 21:01
My bad, meant macros but just saw the note on that. I've removed that tag.
– TimG
Mar 21 at 21:01
add a comment |
0
active
oldest
votes
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55287999%2fvba-to-create-a-quiz-from-problem-bank-based-on-images-random-weights-of-topics%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55287999%2fvba-to-create-a-quiz-from-problem-bank-based-on-images-random-weights-of-topics%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Why did you tag this with macos?
– dwirony
Mar 21 at 19:39
My bad, meant macros but just saw the note on that. I've removed that tag.
– TimG
Mar 21 at 21:01