FCA Autofill from Excel (Under Beta Testing)

A Google Chrome extension designed for simplifing data entry by automating the filling out of HTML forms using information from an Excel spreadsheet with the thoughts of easing FCA workflows.

Created by Ronald Lam and Benjamin Chau, from Bachelor of Science in Computing, Faculty of Applied Sciences, Macao Polytechnic University; supervised by Dr Patrick Pang.

Installation

  1. Install the extension from Chrome Web Store
    Note: This extension only works with Google Chrome browser at the moment
  2. Select the [Extensions] icon, find [Autofill from Excel] and click its [Pin] button.
    Figure 1
  3. Then, it will appear as a button next to the address bar.
    Figure 2

Use Cases

There are several use cases within FCA for this extension. Please read the sections below and use the appropriate templates.

Score Input (BGE)

  1. Download this Excel template
  2. DO NOT modify the top 2 rows as it contains values needed by the extension, you can hide them instead
  3. Enter or paste student IDs, names, and scores to the relevant columns ([Paste as Values] is recommended). Due to the limitations of BGE, separate Excel files are needed for components such as CW, FE, etc.
  4. Back to the browser, open BGE
  5. Select your module, class, and component (e.g. CW), then the score input screen should appear
  6. Click on the toolbar extension button, then select or drag & drop the Excel file for that component
  7. A preview screen will be shown like below. Click [Fill All] to send all scores to BGE.
    Figure 3
  8. Check all scores are correctly entered for the corresponding students; repeat for other components if necessary

Other Uses

Other use cases are still being investigated.