Getting Started Interactive Worksheet for Instructure

image from Getting Started Interactive Worksheet for Instructure

About Aplikasi

Interactive Worksheet application, hereinafter referred to as IW, is an add-on to Google spreadsheets. IW is useful for helping teachers / lecturers in designing projects and practicums (real or virtual practicums), by involving students in small teams collaboratively.

IW is currently available for free. If you want to help with development you can send a donation via paypal.

If you want to invite us in training please send us an email or whatsapp message

Monitoring sheet preparation

Follow these steps bellow to set up a monitoring sheet

  1. Open the folowing link via browser
  2. Make a copy
    1. Click menu: File
    2. Select sub menu: Make a Copy
    3. Fill in the name in the column: Name
    4. Click button: Make a Copy
  3. Do authorization
    1. Click menu: Extensions
    2. Select sub menu: Interactive worksheets
    3. Click Start
    4. When the authorization dialog appears, click button: Continue
    5. Select your email
    6. Click Advanced
    7. Click: Go to Interactive Worksheet (unsafe)
    8. Scroll down
    9. Click button: Allow

Activity list preparation

Follow these steps bellow

  1. Activate Menu Interactive Worksheet
    1. Click menu: Extensions
    2. Select sub menu: Interactive worksheets
    3. Click Start
    4. Menu Interactive Worksheets, will appear to the right of the Help menu
  2. List Activity Preparation
    1. Click Menu Interactive Worksheets
    2. Select: Practical Event Setting, list of activity will appear.
    3. To ad new activity click button Add Row, to delete click Del and to save click Save
      1. Practicum Event: Filled with the name of the activity (example: Reaction of water formation)
      2. Worksheet Label: the name to be used in the sheet
      3. Virtual Lab URL: Virtual lab link
      4. Video Tutorial URL: tutorial video link on youtube with the format:: https://www.youtube.com/embed/[video_unique_code]
      5. Work Procedure URL : activity/practicum guide link
    4. There is a status that can be filled Close or Open
      1. Open: Worksheets will be distributed to participants
      2. Close: Worksheets will not be distributed to participants

Worksheet preparations

Follow theese steps bellow

  1. Click Menu Interactive Worksheets
  2. Select: Worksheet Design, A list of worksheets will appear on the right side (sidebar) containing a list of events that we have prepared
  3. Select the worksheet to design
  4. Make some instructions and tables as in the included example (Water Formation Reaction)
  5. Complete the table (can use numbers or not numbers)
  6. Coloring the background of the section to be filled in by students to make it easier for students to check the sections that must be filled in
  7. When the worksheet is ready, protect the worksheet so that students can only change the specified part
    1. Click Menu: Data
    2. Select: Protect Sheet and Range
    3. Pay attention to the right sidebar,
    4. If the worksheet is not protected a. Click button + Add a sheet or range, b. Select Sheet and specify the worksheet to be protected
    5. If it already exists, select it by clicking Sheet Name
    6. Specifies the excluded range
      1. Tick Except certain cells
      2. Select the part that has been colored by typing it directly
        1. If only 1 cell on A1 : A1
        2. If several consecutive cells from A1 to D1: A1:D1
      3. To add an exception click: Add another range, then repeat step 6.2
    7. Setting Permission
      1. If you haven’t been protected before, click the button: Set Permission
      2. If it was previously protected, click the button: Change Permission
      3. Select Restrict who can edit this range
        1. If the worksheet is used alone: Only You
        2. If the worksheet is shared by several teachers select custom, then add another instructor’s email as a collaborator

Group Preparation

Follow thee steps bellow

  1. Click Menu Interactive Worksheets
  2. Select: Distribute Worksheets
  3. Select: Setting up Links
  4. On the right side will appear a form, where we are asked to fill in many groups (1 to 18)
  5. Click button: Run, Wait a while until the message “Process has been completed” appears.

Distributing Worksheets With Status Open

Follow thee steps bellow

  1. Click Menu Interactive Worksheets
  2. Select: Distribute Worksheets
  3. Select: Prepare Worksheets, uangil lebih dari satu, maka email dipisah spasi
  4. Click button: Send
  5. When the email sending process is complete, a message will appear: Invitation email has been sent, and participants will receive an invitation in their inbox

(note: email must be google email or institutional GCP email)

Giving Access to Student Worksheets

  1. Notice on the monitoring sheet, under the group name the text #REF will appear
  2. Place the cursor on that section, a note Allow Access will appear.
  3. Click Allow Access
  4. The recapitulation of the group will be displayed in real time according to the latest conditions

Practical Implementation

Follow thee steps bellow

  1. Click Menu Interactive Worksheets
  2. Select: Practicum implementation
  3. A Popup will appear: Monitoring,,
    1. If the practicum has not started, a button will appear Start Lab
    2. If the practicum is running a button will appear End Lab
  4. A group button will appear (according to the number of groups created), if you click it, you will be directed to the worksheets of each group
  5. When the Start Lab button is clicked, students can start activities on the worksheet
  6. When the End Lab button is clicked, all students are forced to stop the activity on the worksheet

Delete unused worksheets

If we want to delete unused worksheets follow these steps

  1. Click Menu Interactive Worksheets
  2. Select Others
  3. Select Delete Unused Worksheets
  4. On the right side will display a list of unused worksheets, click the worksheet to be deleted
  5. A confirmation confirmation will appear, whether it will be deleted, if we click Yes, the worksheet will be deleted.

Archiving Results

  1. Click Menu Interactive Worksheets
  2. Select Others
  3. Select: Archive Results
  4. Current activity will be saved in archive

Read also

Check it out!


Ikuti terus tutorial saya di e-Project dan channel saya di