It has been announced that the learning app zuknow will be shutting down on April 27, 2017.
There are some companies and individuals who are currently creating and selling their contents on zuknow.
We also recommend learningBOX to those who are thinking about switching to zuknow.

What you need to switch

Original files of teaching materials

Our Services learningBOXaccount in

If you don`t have an account, please create a free account above.

How to create teaching materials

The learning app "zuknow" allows individuals to copy and paste data from Excel to create teaching materials.
You can create questions in the same way in QuizGenerator with the data when you created the contents in zuknow.

[Wordbook]

1. In Excel or Google Spreadsheet, make a list of English words, etc. (If you have a file that you used in zuknow before, display it) and copy it.

(Excerpt from zuknow usage guide [http://help.zuknow.net/entry/2015/01/19/140809])

2. Paste what you have just copied into a text editor and save it with a name.

3. learningBOXLog in to the "Manage and create questions" screen and select the file you have just created from the "Create Word Cards" screen and save it.

4. A Wordbook is created and can be opened to the public.

[Quiz]

We know that there are some companies that have been distributing quizzes on zuknow. You can create similar quizzes with QuizGenerator.

Excel and Google Spreadsheet rules for producing quiz materials on zuknow

entries per page

Search:

column A	column B	column C	column D	column E	column F	column G	column H
Problem (required)	Answer (required)	Commentary	Additional information on the issue	Additional information about the answer	Wrong Answer Option 1	Wrong Answer Option 2	Wrong Answer Option 3

Showing 1 to 1 of 1 entry

To make it work with our QuizGenerator, you can use

column A	column B	column C	column D	column E
	Answer\|Explanation text	Wrong Answer Option 1	Wrong Answer Option 2	Wrong Answer Option 3

It is necessary to reorder the

How to sort ▼

1. In the same file, prepare a new sheet (such as Page 2).

2. Describe [#format:table] in A1.

3. Please copy column A of the old sheet as it is and paste all questions from A2 to the bottom of the new sheet.

4. Place columns B through E of the first question together in column B of the new sheet.
(In columns C through E, you only need to place the information you want to display in the commentary.
At this time, we will use the function 【CONCATENATE】 to pull the data together.
The description of the function is right next to the first question text on the new sheet.
=CONCATENATE(sheet name of the original data! cell name where the correct answer to the first question is written,"|",sheet name of the original data! Name of the cell where the supplementary information about the answer is written, name of the sheet of original data! cell name where the explanation is written)
(Example) =CONCATENATE(Sheet1!B2,"|",Sheet1!E2,Sheet1!C2)

The point is that it should be displayed as "Correct Answer|Explanation".

5. When the first question in column B of the new sheet appears without error, click on that cell to make it selected, and place your mouse in the lower right corner of the frame. The mouse will turn into a "+" symbol. Click there and drag it to the last question that you just copied to column A. The function will be specified in all rows.

6. Copy and paste column F and later of the original data into column C and later of the new sheet.

Now you have a set of selected question data for QuizGenerator!

Finally.

As mentioned above, if you are already selling your materials on zuknow, you can easily switch over.

However, I know that it is difficult to understand even if you only read the text.
If you have any questions, we will be happy to explain them to you separately.
Please do not hesitate to contact us and consult. We are also available by phone.