March 2021
IT Support Office
How to Manage the Results of Assignments Implemented Outside of e-class
You can manage various results on e-class by importing the results of written exams and assignments
implemented on DUET or by other means. Imported results are displayed in [Score summary table] underthe [Grades] tab.
※ If you want to import the data of results from DUET etc., you need to have the student IDs at hand.
【１】 Basic Settings
1. After logging in to e-class, select the course you would like to edit.

2. Click the [Create Material] button.

3. Click the [Import external data file] button.

1March 2021
IT Support Office【２】 Creation of CSV Files
1. Download a sample file by clicking [sample file].

2.

Open the downloaded file, enter the student IDs and their scores in the cells under [user_id] and[score] respectively, and save the data.
For scores, only whole numbers can be entered. Do not delete the 1st row of the CSV files.
※ If the scores you enter are not whole numbers, the score data will be loaded after being rounded
down to the nearest whole number.

StudentID

Note: Imported data are loaded from top to bottom. If
there are overlapping data, the preceding record
will be overwritten.

Ex.

Same student ID

Invalid

Same student ID

Valid2

March 2021
IT Support Office【３】 Importation of FilesEnter [Label] (optional), [Material name to import] (mandatory) and [Perfect score] (mandatory), andselect the relevant CSV file by clicking the [参照...] button. Once selected, click the [Load］button.

Optional
Name of exam

(ex.)

Click inside the frame.

1. You have successfully imported the file.

Ensure that the number of students and the number of importedrecords are the same.

2. In the [Course Material], you can find the teaching material that you have imported as external
data. The materials are imported as [Test(Show solutions when the test is completes)], and yourstudents can confirm their results on their screen.

3March 2021
IT Support Office※ Students cannot open the material on their screen but they can confirm their score by visiting [Course Scores] >[Test Results].

3. If you do not want to show the results on the students’ screen, you can prevent this by following
either of the two methods below:➀ How to prevent teaching materials from appearing on the students’ screen
Click [Open/Close settings] on the students’ screen or on the right side of the name of the teachingmaterial.

Select and save [Hide from the Course Members] under [Access Restriction)]. Then, the materials
will not be displayed on the students’ screen.

➁ How to prevent results from appearing on the students’ screen
Click [Settings] under […] either on the students’ screen or on the right side of the name ofthe teaching material.

4March 2021
IT Support Office
Select [Examination (Hide Results)] for [Type], and click [Save Changes & Exit] at the bottom of thepage.

※ Teaching materials will be shown on the students’ screen, but their scores will not appear as they areclassified as not to be disclosed.

【４】 How to Confirm Students’ Results
1. Click [Score Summary Table] under the [Grades] tab.

2.

Title of Import external data file that you entered (【3】-1) will be displayed, allowing you to confirm
if you have correctly entered the students’ scores.

Name/Student ID

End● The names of companies, systems, programs and products in this document are trademarks or registeredtrademarks owned by the companies that developed them.
● In this document, symbols such as 🄫, 🄬 or TM are omitted.

5