3. How to Update the Year

Please update to RainbowOne 1.4 to use the school year features.

1. About School Year

  1. School year is essential as both teachers and students will have different groups in different years. The RainbowOne system will label them to represent these groups. Every year, each user will receive a different label.
  2. The school needs to set the school year for each student.
  3. Click “Create New School Year,” and enter the name and time of the year. 

2. How to Create a New School Year

  1. When the Open Knowledge Association opens a school account, the system will automatically set the school year according to the current date. The scheduled school opening date is September 1, and the end date is August 31.
  2. At the top of the screen, click “Display School Year” and then click “Manage School Year”
  3. Click “Create New School Year” and enter the name and time of the year.
  4. The period of each year cannot be overlapped.

3. Current Year

  1. RainbowOne will automatically select the current year based on the server’s time.
  2. For other links that need to use the label, the system will display the selected year. For example, when sharing an e-book, the label of the current school year can be selected for sharing.

4. Current Users and Archived Users

  1. Archived users will not be able to login to RainbowOne.
  2. Current users can access all RainbowOne functions and features. For example, the teacher user can access the school’s Workplace, and the students can access the school-assigned e-books.
  3. The number of current users available to each school is determined by the school subscribed plan.
  4. Archived users are mainly students who have graduated or left the school or resigned teachers.
  5. Archived users will not be counted in the current number of users and thus will not affect the maximum number of accounts quota
  6. Teachers can still view the information and records of archived users as their data will not be deleted.

5. School Year and Label

  1. The labels for each school year are separated. For example, class 1A in 2018/19 and class 1A in 2017/18 are different labels
  2. The school needs to create the labels for each school year as required in that particular year

6. How to upgrade users or change user information through the system interface

Example 1: Change class 1A in the 2017-18 school year directly into class 2A in the 2018-19 school year

  1. Establish the 2018-19 school year.
  2. Return to the 2017-18 school year shown on the top of the screen.
  3. When selecting “1A” in the tab bar, all students in group 1A of the 2017-18 school year will be displayed on the right
  4. lick on the rightmost 3-dot button, then click "Select" to select students who need to do the promotion, or "Select All" to select all students in this group to do the promotion
  5. Click “Add tag” on the top of the pop-up bar at the bottom of the screen.Select “2018-19 School Year” (New Year) shown on the top of the pop-up window, then select “2A” and click OK (please ensure that you have already established the “2A” label).

Example 2: For the 2017-18 school year, add the 2A label for individual users in the 2018-19 school year

  1. Establish the 2018-19 school year
  2. Return to the 2017-18 school year shown on the top of the screen.
  3. Select a label in the tab bar or search for a specific user.
  4. Click on the rightmost 3-dot button for the user you want to work with, and then click “Add Label.”


    Select “2018-19 School Year” (New Year) on the top of the pop-up window, then select “2A” and click OK (please ensure that you have already established the “2A” label).

  5. Note: As an upgraded class needs to be switched between different years, it is not possible to drag the label directly to the user.

7. How to Promote a User or Change User Information via Excel

If you want to handle accounts in batches in Excel, export the datasheet of the current school year and make changes in Excel before importing it to the new school year. Please note that data updated through Excel cannot be restored

  1. Click “Display School Year” on the top of the screen, then click “Manage School Year.”
  2. On the right-hand side of the current year, click “Export” and save the Excel datasheet.
  3. Edit and save the data in Excel.
  4. Click “Import” on the right-hand side of a new school year.
  5. If the information in Excel has any errors, the system will indicate the problem.
  6. If the information is correct, the system will automatically update the user information. The time required for the process will depend on the number of users.
  7. Please pay attention to the next section “About Excel Processing.”

8. About Excel Processing

Data and formatting must be correctly handled in Excel before the system can correctly import data. The field descriptions in Excel are listed below.

  1. userID:  The user identification number in the system. Please do not make any changes to this field.
  2. status (mandatory) (new/update/archive/delete): An update method, new refers to a new user, update refers to an update to an existing user, archive refers to a sealed user, delete refers to a deleted user.
  3. surname(chi): Chinese surname
  4. firstname(chi): Chinese name
  5. surname(en): English surname
  6. firstname(en):  English name
  7. displayname:  The short name of the student. It will be displayed in the seat table in the class mode.
  8. gender:  Gender; can only be M or F.
  9. type: Identity; can only be S (student) or T (teacher).
  10. username: The user name. Please note that the system will automatically add the short name of the school at the end. There is no need to enter it.
  11. email: E-mail address; must be unique and cannot coincide with any other users.
  12. change password:  If you want to change the user password, please fill in a new password. If not, just leave it blank.
  13. new tag: The user label for the new year. If there is more than one label, please use a comma (,) to separate.
  14. old tag: The label owned by the exported user of the year. It is for reference only and will not be re-imported.
  15. qrcode: User login RainbowOne QR code text, it is for reference only and will not be re-imported.

Please note that a different update status will have to be filled out with different information. Please refer to the table below. Those fields marked with a “Y” must be filled out.

  1. new: Do not fill in UserID; you must have the name and other information, such as gender, identity (type), user name/e-mail, password, and new label. If a label did not exist in the past, the system will automatically add one. Add a new line in Excel to enter new user information.
  2. update: Must have UserID, must have name and other information, such as gender, identity (type), user name/e-mail, and password. The fields that contain no information will be deleted.
  3. archive: Must have UserID; all of the remaining information system will be skipped and will not be updated even if information is provided in other fields. Set students who have graduated or teachers who have left the school as archive.
  4. delete: Must have UserID; all of the remaining data system will be skipped and will not be updated even if information is provided in other fields.
  5. Do not add, delete, or make any changes to the Excel fields.
  6. Please do not change the first line of text

When the system has completed handling the Excel information, if the information is wrong, the system will prompt where the mistakes are in Excel. If the data format is correct, data statistics will appear. Click OK to begin the official import and “Cancel Import” when necessary.

After importing is completed, switch to the current year to ensure that the information is correct.

Next Chapter: Bookstore and Bookshelf