Download Student Records System

•
Select the "marks.iqy" file from where it is saved on your system, and then click "Get
Data". You will be asked ‘Where do you want to put the data?’ Click on ‘OK’ to select
the default setting.
•
You are then prompted separately for the Module Code, Qualification Code and Period of
Study required. Enter the appropriate value and click on ‘OK’ for each parameter. The
student data will be then be imported into Excel. Save the file using an appropriate
naming convention. This file can then be given to an examiner for completion.
Excel 97
•
Open Excel.
•
Select "Data" from the menu bar.
•
Select "Get External Data" and then "Run Web Query".
•
Select the "marks" file from where it is saved on your system, and then click "Get Data".
You will be asked ‘Where do you want to put the data?’ Click on ‘OK’ to select the
default setting.
•
You are then prompted separately for the Module Code, Qualification Code and Period of
Study required. Enter the appropriate value and click on ‘OK’ for each parameter. The
student data will be then be imported into Excel. Save the file using an appropriate
naming convention. This file can then be given to an examiner for completion.
Phase 2 – Formatting the file
•
Save the Excel file as a comma separated file, using a unique identifier as the filename.
To do this click on ‘Save as’ and the following screen appears:
D:\NIALL\DCU\internal\staff\marks\latest\Web Version 0406_070602.doc
Vers. 1.2 June 2002
Page 3.16