Automatic export of different PDF versions from LaTeX based on a spreadsheet
0
I am a teacher designing short quizzes for students. My students take a quiz and from that I create a spreadsheet with their answers. Depending on whether they give a correct or false answer I want to omit or reuse that question in the upcoming quiz, respectively.
Can I feed LaTeX the spreadsheet and let it compile separate PDF documents containing questions that they answered false in the previous quiz? How would you go about doing this?
1 row in my spreadsheet equals to 1 student with their answers.
I'm saving each question as a separate .tex file.
pdftex
edited Jan 4 at 17:52
naphaneal
2,09111127
asked Jan 4 at 17:44
philippmikiophilippmikio
1
add a comment |
0
I am a teacher designing short quizzes for students. My students take a quiz and from that I create a spreadsheet with their answers. Depending on whether they give a correct or false answer I want to omit or reuse that question in the upcoming quiz, respectively.
Can I feed LaTeX the spreadsheet and let it compile separate PDF documents containing questions that they answered false in the previous quiz? How would you go about doing this?
1 row in my spreadsheet equals to 1 student with their answers.
I'm saving each question as a separate .tex file.
pdftex
edited Jan 4 at 17:52
naphaneal
2,09111127
asked Jan 4 at 17:44
philippmikiophilippmikio
1
1
do you have a Minimal Working Example to show?
– naphaneal
Jan 4 at 17:53
Welcome to TeX.SE. Yes, I am pretty sure you can accomplish what you desire. However, you are basically asking two different and unrelated questions here: 1. Can LaTeX read a CSV file and determine a true/false condition (assuming you can generate a CSV file)? 2. How do I use a conditional typesetting. The specifics will depend a on exactly how you are doing things and want to control the various aspects, so having more details would be helpful.
– Peter Grill
Jan 4 at 18:17
There are numerous questions on this site related to those two. For 1 you could start with Use datatool to read a row from a CSV file, then use the variables in the document? and for 2 there is Conditional typesetting / build. I would recommend you start with those and post a more specific question if you get stuck. Or, you those to construct a MWE that sets up the problem and edit the question to include that.
– Peter Grill
Jan 4 at 18:18
If you use Linux, before of reinvent the wheel you should check what AMC (auto-multiple-choice) does (more of what you are asking) including export statistics by student and by questions to a OpenOffice spreadsheet. This part however is not made by Latex (that make only the exam sheets) but by a GUI. It is available in most used Debian-based distros, so install and try is the easy part (the hard part is understand their own macros and environments, but reading the fine manual, is not so hard).
– Fran
Jan 4 at 19:21
add a comment |
0
0
0
I am a teacher designing short quizzes for students. My students take a quiz and from that I create a spreadsheet with their answers. Depending on whether they give a correct or false answer I want to omit or reuse that question in the upcoming quiz, respectively.
Can I feed LaTeX the spreadsheet and let it compile separate PDF documents containing questions that they answered false in the previous quiz? How would you go about doing this?
1 row in my spreadsheet equals to 1 student with their answers.
I'm saving each question as a separate .tex file.
pdftex
edited Jan 4 at 17:52
naphaneal
2,09111127
asked Jan 4 at 17:44
philippmikiophilippmikio
1
I am a teacher designing short quizzes for students. My students take a quiz and from that I create a spreadsheet with their answers. Depending on whether they give a correct or false answer I want to omit or reuse that question in the upcoming quiz, respectively.
Can I feed LaTeX the spreadsheet and let it compile separate PDF documents containing questions that they answered false in the previous quiz? How would you go about doing this?
1 row in my spreadsheet equals to 1 student with their answers.
I'm saving each question as a separate .tex file.
pdftex
pdftex
edited Jan 4 at 17:52
naphaneal
2,09111127
asked Jan 4 at 17:44
philippmikiophilippmikio
1
edited Jan 4 at 17:52
naphaneal
2,09111127
asked Jan 4 at 17:44
philippmikiophilippmikio
1
edited Jan 4 at 17:52
naphaneal
2,09111127
edited Jan 4 at 17:52
naphaneal
2,09111127
edited Jan 4 at 17:52
naphaneal
2,09111127
2,09111127
asked Jan 4 at 17:44
philippmikiophilippmikio
1
asked Jan 4 at 17:44
philippmikiophilippmikio
1
asked Jan 4 at 17:44
philippmikiophilippmikio
1
1
1
do you have a Minimal Working Example to show?
– naphaneal
Jan 4 at 17:53
Welcome to TeX.SE. Yes, I am pretty sure you can accomplish what you desire. However, you are basically asking two different and unrelated questions here: 1. Can LaTeX read a CSV file and determine a true/false condition (assuming you can generate a CSV file)? 2. How do I use a conditional typesetting. The specifics will depend a on exactly how you are doing things and want to control the various aspects, so having more details would be helpful.
– Peter Grill
Jan 4 at 18:17
There are numerous questions on this site related to those two. For 1 you could start with Use datatool to read a row from a CSV file, then use the variables in the document? and for 2 there is Conditional typesetting / build. I would recommend you start with those and post a more specific question if you get stuck. Or, you those to construct a MWE that sets up the problem and edit the question to include that.
– Peter Grill
Jan 4 at 18:18
If you use Linux, before of reinvent the wheel you should check what AMC (auto-multiple-choice) does (more of what you are asking) including export statistics by student and by questions to a OpenOffice spreadsheet. This part however is not made by Latex (that make only the exam sheets) but by a GUI. It is available in most used Debian-based distros, so install and try is the easy part (the hard part is understand their own macros and environments, but reading the fine manual, is not so hard).
– Fran
Jan 4 at 19:21
add a comment |
1
do you have a Minimal Working Example to show?
– naphaneal
Jan 4 at 17:53
Welcome to TeX.SE. Yes, I am pretty sure you can accomplish what you desire. However, you are basically asking two different and unrelated questions here: 1. Can LaTeX read a CSV file and determine a true/false condition (assuming you can generate a CSV file)? 2. How do I use a conditional typesetting. The specifics will depend a on exactly how you are doing things and want to control the various aspects, so having more details would be helpful.
– Peter Grill
Jan 4 at 18:17
There are numerous questions on this site related to those two. For 1 you could start with Use datatool to read a row from a CSV file, then use the variables in the document? and for 2 there is Conditional typesetting / build. I would recommend you start with those and post a more specific question if you get stuck. Or, you those to construct a MWE that sets up the problem and edit the question to include that.
– Peter Grill
Jan 4 at 18:18
If you use Linux, before of reinvent the wheel you should check what AMC (auto-multiple-choice) does (more of what you are asking) including export statistics by student and by questions to a OpenOffice spreadsheet. This part however is not made by Latex (that make only the exam sheets) but by a GUI. It is available in most used Debian-based distros, so install and try is the easy part (the hard part is understand their own macros and environments, but reading the fine manual, is not so hard).
– Fran
Jan 4 at 19:21
1
1
do you have a Minimal Working Example to show?
– naphaneal
Jan 4 at 17:53
do you have a Minimal Working Example to show?
– naphaneal
Jan 4 at 17:53
Welcome to TeX.SE. Yes, I am pretty sure you can accomplish what you desire. However, you are basically asking two different and unrelated questions here: 1. Can LaTeX read a CSV file and determine a true/false condition (assuming you can generate a CSV file)? 2. How do I use a conditional typesetting. The specifics will depend a on exactly how you are doing things and want to control the various aspects, so having more details would be helpful.
– Peter Grill
Jan 4 at 18:17
Welcome to TeX.SE. Yes, I am pretty sure you can accomplish what you desire. However, you are basically asking two different and unrelated questions here: 1. Can LaTeX read a CSV file and determine a true/false condition (assuming you can generate a CSV file)? 2. How do I use a conditional typesetting. The specifics will depend a on exactly how you are doing things and want to control the various aspects, so having more details would be helpful.
– Peter Grill
Jan 4 at 18:17
There are numerous questions on this site related to those two. For 1 you could start with Use datatool to read a row from a CSV file, then use the variables in the document? and for 2 there is Conditional typesetting / build. I would recommend you start with those and post a more specific question if you get stuck. Or, you those to construct a MWE that sets up the problem and edit the question to include that.
– Peter Grill
Jan 4 at 18:18
There are numerous questions on this site related to those two. For 1 you could start with Use datatool to read a row from a CSV file, then use the variables in the document? and for 2 there is Conditional typesetting / build. I would recommend you start with those and post a more specific question if you get stuck. Or, you those to construct a MWE that sets up the problem and edit the question to include that.
– Peter Grill
Jan 4 at 18:18
If you use Linux, before of reinvent the wheel you should check what AMC (auto-multiple-choice) does (more of what you are asking) including export statistics by student and by questions to a OpenOffice spreadsheet. This part however is not made by Latex (that make only the exam sheets) but by a GUI. It is available in most used Debian-based distros, so install and try is the easy part (the hard part is understand their own macros and environments, but reading the fine manual, is not so hard).
– Fran
Jan 4 at 19:21
If you use Linux, before of reinvent the wheel you should check what AMC (auto-multiple-choice) does (more of what you are asking) including export statistics by student and by questions to a OpenOffice spreadsheet. This part however is not made by Latex (that make only the exam sheets) but by a GUI. It is available in most used Debian-based distros, so install and try is the easy part (the hard part is understand their own macros and environments, but reading the fine manual, is not so hard).
– Fran
Jan 4 at 19:21
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "85"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
});
}
});
draft saved
draft discarded
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%2ftex.stackexchange.com%2fquestions%2f468612%2fautomatic-export-of-different-pdf-versions-from-latex-based-on-a-spreadsheet%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
draft saved
draft discarded
Thanks for contributing an answer to TeX - LaTeX Stack Exchange!
- 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.
draft saved
draft discarded
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%2ftex.stackexchange.com%2fquestions%2f468612%2fautomatic-export-of-different-pdf-versions-from-latex-based-on-a-spreadsheet%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
do you have a Minimal Working Example to show?
– naphaneal
Jan 4 at 17:53
Welcome to TeX.SE. Yes, I am pretty sure you can accomplish what you desire. However, you are basically asking two different and unrelated questions here: 1. Can LaTeX read a CSV file and determine a true/false condition (assuming you can generate a CSV file)? 2. How do I use a conditional typesetting. The specifics will depend a on exactly how you are doing things and want to control the various aspects, so having more details would be helpful.
– Peter Grill
Jan 4 at 18:17
There are numerous questions on this site related to those two. For 1 you could start with Use datatool to read a row from a CSV file, then use the variables in the document? and for 2 there is Conditional typesetting / build. I would recommend you start with those and post a more specific question if you get stuck. Or, you those to construct a MWE that sets up the problem and edit the question to include that.
– Peter Grill
Jan 4 at 18:18
If you use Linux, before of reinvent the wheel you should check what AMC (auto-multiple-choice) does (more of what you are asking) including export statistics by student and by questions to a OpenOffice spreadsheet. This part however is not made by Latex (that make only the exam sheets) but by a GUI. It is available in most used Debian-based distros, so install and try is the easy part (the hard part is understand their own macros and environments, but reading the fine manual, is not so hard).
– Fran
Jan 4 at 19:21