To view data about the students, select the Edit | Students option from the menu.
A new window for viewing students is displayed.
There are three ways to insert students:
| 2. | import students from a CSV file and |
| 3. | insert students manually. |
For work with students you have to select:
| • | program, |
| • | studying year for the program and |
| • | subject area for the program. |
| • | Add |
Add manually a new student to the table, where you can insert the student number, the surname and the name of
the student. The subject area and the year are selected automatically because you have already selected them.
| • | To edit the student number, surname and the name of the student, double-click on the position of field gap and insert a new value. |
| • | Delete |
Manually delete the chosen student.
| • | Courses |
Define student's courses.
| • | You can check if students are distributed into the groups. The students painted in yellow are distributed into the groups. The ones painted in white remain undistributed. |
| • | Import |
Import students from a CSV file.
To import students from CSV file are two chooses:
| 1) | When you prepare the CSV file to import, choose Edit -> Students in the menu, and choose the program, the subject area and the year in which you want to import students. Then click the Import button and choose the CSV file. |
| 2) | When you prepare the CSV file to import, choose view by students, program, year and subject area in which you want import students in the main window. |
Choose Data | Import Data from CSV file| Import students in the menu and then load the CSV file.
CSV data preparation
- The data which you import must feature in a first sheet.
- You can prepare the data in an Excel file and then transform it to a CSV file.
- Open the Excel file with students' data (data have to be in the order as described above).
- Select File and then Save as.
- Choose the folder in which you want to save the file.
- Save as type CSV (the extension of the file will be renamed into .csv).
- Press the Save button and then Ok and Yes.
Instructions for student import through the Students window:
The following data are imported:
| - | student number, |
| - | surname and |
| - | name. |
Data example:
Student No. |
Surname |
Name |
19375211 |
AMMONS |
ABBIE |
19375212 |
AUMAN |
KAYLYN |
19375213 |
BAILEY |
KAROLYN |
19375214 |
BAKER |
PHYLLIDA |
Before you import students from the CSV file, you have to choose a program, a year and a subject area where you want to import students. You can import students only from a chosen program, year and subject area simultaneously.
Find an example of a CSV file on www.wisetimetable.com (DATA IMPORT).
The data of one student are written in one row. Write the student number in the first column, the surname in the second, and the name in the third.