For those who are considering switching from zuknow
It has been announced that the zuknow learning application will end on April 27, 2017.
We understand that some companies and individuals are currently using zuknow to create and sell content.
LearningBOX is a service that we recommend to those who are considering switching to zuknow following the end of zuknow.
What you need to change to LearningBOX
The original file of the teaching materials
LearningBOX account
If you do not have an account, please create a free account above.
How to Create Teaching Materials
The learning application "zuknow" allows individuals to create teaching materials by copying and pasting data from Excel.
The same data used to create content in zuknow can be used to create questions in QuizGenerator.
[Wordbook
1. Create a list of English words, etc. in Excel or Google Spreadsheet (if there is a file previously used in zuknow, display it) and copy
(Excerpted from the zuknow usage guide [http://help.zuknow.net/entry/2015/01/19/140809])
2. Paste what you just copied into a text editor, name it and save it.
3. Log in to learningBOX, open the [Manage/Create Question] screen, select the file you just created from the Create Word Cards section, and save it.
A Wordbook will be created and can be opened to the public.
Quiz
We know that some companies have distributed quizzes on zuknow. You can create similar quizzes with QuizGenerator.
The following are the rules of Excel and Google Spreadsheets when creating quiz materials on zuknow.
To be able to use this in our QuizGenerator, it is necessary to rearrange the order of
To use this in our QuizGenerator, it is necessary to rearrange the order of the quizzes into the following order.
How to rearrange the order
1. Prepare a new sheet (page 2, etc.) in the same file.
2. Write "#format:table" in A1.
3. Copy column A of the old sheet as it is and paste all questions from A2 down in the new sheet.
4. Place columns B to 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 explanations.)
At this point, the function 【CONCATENATE】 is used to pull in the data.
The function is written on the new sheet, right next to the first question text.
=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! Cell name where the supplementary information about the answer is written,"|",sheet name of the original data! cell name where the explanation is written)
(Example) =CONCATENATE(Sheet1!B2,"|",Sheet1!E2,Sheet1!C2)
In short, it is good if the correct answer|explanatory text is displayed.
5. If the first question in column B of the new sheet appears without error, click on the cell to make it selected, and hover the mouse over the lower right corner of the box. The mouse will change to the "+" symbol. Click there and drag it to the last question you just copied to column A. The function will be specified in all rows.
6. Copy and paste column F and after of the original data into column C and after on the new sheet.
You now have your choice question data for QuizGenerator!
Finally
As mentioned above, if you are already selling educational materials on zuknow, you can easily switch over.
However, we understand that it is indeed difficult to understand even if you only read the text.
If you have any trouble, we will be happy to explain it to you separately.
Please do not hesitate to contact us. Please feel free to contact us by phone.