E10 - Elective data > Students: Import Elective preferences from a spreadsheet

Modified on Thu, 14 Aug at 12:52 AM

TABLE OF CONTENTS

Step 1: Set up a Spreadsheet
Step 2: Import preferences
Step 3: Check Student preference data

Preamble

Most schools will use Edval Choice to capture student preferences, but some schools use other methods, such as manual data entry or import via a spreadsheet. This document covers the process of importing student preferences via a spreadsheet.

The steps below assume that there is already an existing dataset set up ready to receive the student preference data.

Step 1: Set up a Spreadsheet

Set up an Excel/CSV spreadsheet for the elective data in the following format:

include a header row
one row per student, including their student code, name and preferences listed in preference order. The student name is not necessary for the import but may assist with data checking. Include a year level if importing into a multi-year dataset.

Step 2: Import preferences

File > Import data > Student elective prefs

Select the dataset that the student preferences are to be imported to

Navigate to the location of the spreadsheet and select the file
Edval will do it's best to match headings, but where it is not obvious or where Edval is mistaken, simply drag and drop headers around to correctly match the data.
Select Go.

Import options:
Clear & Overwrite: this action will delete all existing preferences within the selected dataset and replace them with preference codes in the spreadsheet, as per the headings.
Merge: New students and their preferences will be added, while any existing preferences for existing students will be altered to match the incoming data from the spreadsheet, as per the headings.
e.g. if CLINTON, Angela currently has 7FRE as Pref1 in Edval, the spreadsheet import above will change 7FRE to 7CHI.
if CLINTON, Angela currently has Pref2 blank in Edval, the spreadsheet import above will change the blank entry to 7FRE.

Step 3: Check Student preference data

Navigate to Lines > Elective data F10 > Students to check the preference data is correct.

TIP: Create a copy of the .etz timetable file to practice importing student preferences until confident. Alternatively, save the file right before importing, check the data, and if it is faulty, simply File > Revert to saved file.