| Original submission元の投稿 : |
Presentation title: A new Moodle admin tool to import users directly from an Excel file Presentation type: Lightning talk (10 mins) ライトニング・トーク（１０分） Presentation language: English 英語 Presentation keywords: import, users, excel Presentation abstract: The presentation will introduce a new tool for Moodle administrators and teachers that allows student users to be imported into Moodle directly from an Excel or OpenOffice spreadsheet file, which is the format that schools and universities typically use to distribute class lists to teachers. In such files, the same kind of information appears in the same columns every year that the file is produced, and only the data changes. Hitherto, it would be necessary to manually open the spreadsheet file, change the title headings, perhaps reorder or remove some columns, then export the modified data to a CSV file, and finally upload the CSV file to Moodle using the "upload user" tool that is available in a standard Moodle installation. The new tool featured in this presentation reduces this long-winded and error-prone upload process to a single step, namely uploading the original spreadsheet to Moodle. The tool makes use of an XML file which defines the structure of the spreadsheet file. Since the structure of the spreadsheet file does not change from year to year, a single XML file, once developed, can be used every year without any changes. As a result, the tool can handle spreadsheet files, whatever the internal structure of the sheets, columns and rows. The presentation will explain the design and implementation of the tool, and show real-life examples of spreadsheet files that the tool was developed to handle. |
| Abstract要約 : |
The presentation will introduce a new tool for Moodle administrators and teachers that allows student information to be imported into Moodle directly from spreadsheet files containing class lists that are distributed by a school or university administration office.
Hitherto, it would be necessary to manually open the spreadsheet file, change the title headings, perhaps reorder or remove some columns, then export the modified data to a CSV file, and finally upload the CSV file to Moodle using the "upload user" tool that is available in a standard Moodle installation.
The new tool featured in this presentation reduces this long-winded and error-prone upload process to a single step, namely uploading the original spreadsheet to Moodle. The tool makes use of an XML file which defines the structure of the spreadsheet file. Thus, the tool can handle spreadsheet files whatever the internal structure of the sheets, columns and rows.
The presentation will explain the design and implementation of the tool, and show real-life examples of spreadsheet files that the tool was developed to handle. |
|
Peer Review 1
| Criteria | Assessment |
|---|
| 9 / | | 9 / | | 9 / | | 9 / | | 9 / | | 45 / | | | 90 / |
Feedback Seems like a useful tool that many participants would be interested in Peer Review 2
| Criteria | Assessment |
|---|
| 10 / | | 10 / | | 10 / | | 10 / | | 10 / | | 45 / | | | 95 / |
Feedback This is a good abstract and offers a tool that will be of interest to many. Peer Review 3
| Criteria | Assessment |
|---|
| 8 / | | 8 / | | 8 / | | 9 / | | 6 / | | 45 / | | | 84 / |
Feedback The abstract is quite long and some parts feel redundant. E. g. "Since the structure of the spreadsheet file does not change from year to year, a single XML file, once developed, can be used every year without any changes. " because already explained in the second sentence. Besides that, this seems like an interesting lightning talk! |