Students

Top  Previous  Next

 

To view data about the students, select the Edit | Students option from the menu.

 

A new window for viewing students is displayed.

 

Students_01

 

There are three ways to insert students:

1.import students from database,
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.