QuizMenuTool Tutorial: Difference between revisions

Line 139:

=== Question Generator: Multiple Choice Monotony ===

This tab of the sheet is dedicated to the design and storage of the individual random questions in the quiz.

This tab of the sheet is dedicated to the design and storage of the individual random questions in the quiz. The way this sheet works revolves around "Question Templates" that store the question text, question number, answer text, pool ID, and points for that pool ID. Below is an example of a Question Template, and how it translates to question data:

{| class="wikitable"

|+Do you prefer to be busy or to have\na lot of free time?^35|Being busy.^11^4^8^2|Free time!^9^4|In between.^12^4

!Question Text

! colspan="8" |Question #

|-

|Do you prefer to be busy or to have a lot of free time?

| colspan="8" |35

|-

!Answer Text

! colspan="2" |Pool 1 ID and Pts

|-

|Being busy.

|11

|4

|8

|2

| -

|-

|Free time!

|9

|4

| -

|-

|In between.

|12

|4

| -

|}

==== Paste Values Only ====

This tab is the first which will require the use of "Paste Values". When this guide specifies that a copy/paste must "Paste Values", this means that the copied text is a formula, and the pasted text should not be a formula.

There are two ways to paste values, either by right-clicking the paste location and selecting "Paste Special" then "Values Only", or by holding shift as you paste.

==== Question Template Input ====

On the far left, is an input for an existing Question Template.[[File:Question Template Input.png|alt=Question Template Input Location|center|thumb|600x600px|Question Template Input Location]]The "Use Question Template Input" checkbox tells the sheet whether or not to use the Question Template provided. When writing questions entirely from scratch, disable this checkbox. When modifying existing questions, enable the checkbox, and paste in the Question Template. This will subsequently auto-fill the Question Data Inputs with the data within the template. If the auto-filled data itself needs to be altered, you will need to copy and '''paste values''' the data, then disable the checkbox.

==== Question Data Inputs ====

The Question Data Inputs Area should seem relatively intuitive. The question text is at the top, the answers are beneath, and up to 4 Personality Pools can gain points from each answer choice. The White Space checkbox is identical to the previous tab, and the question index is just the internal "ID" of the question. It should be incremented for each new question created, and will translate to the ID of the switch case in the final code. Note that the drop-down for the Pool Names is sourced from the Pool Names column of the Starter Selection Generator, and any changes to that list after creating the questions may lead to problems. With the current setup of the sheet, each question is limited to a maximum of 26 answer choices, but this limit is arbitrary, and can be circumvented by editing the question template manually, and pasting it in the Template List. In the event that more than 26 choices becomes necessary, please ping happylappy in a support thread.

==== Question Template Output ====

==== Question Template Output & Template List ====

[TODO] Describe the Number of Possible Questions field, and the Question Template Output.

=~~===~~ Question Template List ~~====~~

[TODO] Explain that the template output needs to be shift-pasted into the corresponding green cell in the Question Template List, and that the orange output cells are again just for debug purposes.

=== Personality Pool Selection Generator: Tallying Up the Points ===

@@ Line 139: / Line 139: @@
 === Question Generator: Multiple Choice Monotony ===
-This tab of the sheet is dedicated to the design and storage of the individual random questions in the quiz.
+This tab of the sheet is dedicated to the design and storage of the individual random questions in the quiz. The way this sheet works revolves   around "Question Templates" that store the question text, question number, answer text, pool ID, and points for that pool ID. Below is an example of a Question Template, and how it translates to question data:
+{| class="wikitable"
+|+Do you prefer to be busy or to have\na lot of free time?^35|Being busy.^11^4^8^2|Free time!^9^4|In between.^12^4
+!Question Text
+! colspan="8" |Question #
+|-
+|Do you prefer to be busy or to have a lot of free time?
+| colspan="8" |35
+|-
+!Answer Text
+! colspan="2" |Pool 1 ID and Pts
+! colspan="2" |Pool 1 ID and Pts
+! colspan="2" |Pool 1 ID and Pts
+! colspan="2" |Pool 1 ID and Pts
+|-
+|Being busy.
+|11
+|4
+|8
+|2
+| -
+| -
+| -
+| -
+|-
+|Free time!
+|9
+|4
+| -
+| -
+| -
+| -
+| -
+| -
+|-
+|In between.
+|12
+|4
+| -
+| -
+| -
+| -
+| -
+| -
+|}
+==== Paste Values Only ====
+This tab is the first which will require the use of "Paste Values". When this guide specifies that a copy/paste must "Paste Values", this means that the copied text is a formula, and the pasted text should not be a formula.
+[[File:How To Paste Values.png|alt=Depiction of the "Values Only" button in the menu|center|thumb|600x600px|Depiction of the "Values Only" button in the menu]]
+There are two ways to paste values, either by right-clicking the paste location and selecting "Paste Special" then "Values Only", or by holding shift as you paste.
 ==== Question Template Input ====
-[[File:Question Template Input.png|alt=Question Template Input Location|center|thumb|600x600px|Question Template Input Location]]
+On the far left, is an input for an existing Question Template.[[File:Question Template Input.png|alt=Question Template Input Location|center|thumb|600x600px|Question Template Input Location]]The "Use Question Template Input" checkbox tells the sheet whether or not to use the Question Template provided. When writing questions entirely from scratch, disable this checkbox. When modifying existing questions, enable the checkbox, and paste in the Question Template. This will subsequently auto-fill the Question Data Inputs with the data within the template. If the auto-filled data itself needs to be altered, you will need to copy and '''paste values''' the data, then disable the checkbox.
 ==== Question Data Inputs ====
+[[File:Question Data Inputs.png|alt=Location of the Question Data Inputs Area|center|thumb|750x750px|Location of the Question Data Inputs Area]]
+The Question Data Inputs Area should seem relatively intuitive. The question text is at the top, the answers are beneath, and up to 4 Personality Pools can gain points from each answer choice. The White Space checkbox is identical to the previous tab, and the question index is just the internal "ID" of the question. It should be incremented for each new question created, and will translate to the ID of the switch case in the final code. Note that the drop-down for the Pool Names is sourced from the Pool Names column of the Starter Selection Generator, and any changes to that list after creating the questions may lead to problems. With the current setup of the sheet, each question is limited to a maximum of 26 answer choices, but this limit is arbitrary, and can be circumvented by editing the question template manually, and pasting it in the Template List. In the event that more than 26 choices becomes necessary, please ping happylappy in a support thread.
-==== Question Template Output ====
+==== Question Template Output & Template List ====
+[TODO] Describe the Number of Possible Questions field, and the Question Template Output.
-==== Question Template List ====
+[[File:Question Template Output & Template List.png|alt=Location of Question Template Output & Template List|center|thumb|750x750px|Location of Question Template Output & Template List]]
+[TODO] Explain that the template output needs to be shift-pasted into the corresponding green cell in the Question Template List, and that the orange output cells are again just for debug purposes.
 === Personality Pool Selection Generator: Tallying Up the Points ===