Indexed Sequential File Emulator

Indexed Sequential File Emulator is an interactive macro-enabled spreadsheet model which allows learners to see how single and multi-level indices are used to add and access indexed sequential data records on a hard disc. When the learner enters a record key field value to add to the data file, the record appears in the correct position in the block. The indices pointing to it and the path to it are highlighted in the indices and in the data block. Repeat key fields are detected and prevented.

As the learner enters a record key field value to find, the path to it is highlighted in the indices and in the data block. Trying to access a non-existent field is detected and indicated.

The learner can switch between two tabs - one using a single level index and one using a dual level index.

NOTE: for this spreadsheet to work correctly, the copy of Excel in which it is running must allow macros to execute, and ‘Enable Content’ must be clicked when the spreadsheet is opened.