File | Create New by importing text file from spreadsheet

This allows you to set up data in a spreadsheet, which may sometimes be more convenient than typing directly into Markbook90. You then create a tab-delimited text file (similar to a .csv, or comma-separated variable file) from the spreadsheet which this option will then import.

You are given an opendialogue box which will allow you to select an appropriate file. You should select a file which has been exported from a spreadsheet, otherwise the outcome of loading it will be undefined. There is no file type checking done by Markbook90. If you have prepared the exported file correctly, it should load and appear in the grid just like a standard Markbook90 file, and you can then use File | Save As to create a Markbook90 file from the imported data.

Creating the Tab-delimited text file

The instructions here refer to Microsoft Excel 2000. (Microsoft Excel is a registered trademark).
Set up the spreadsheet such that the row and column layout looks like a Markbook90 grid.



This means two fixed rows at the top, (the upper for work item titles, the second for maximum marks), and a fixed row at the left for student names. (On the spreadsheet, these are not actually fixed - they are no different from the other cells, but they will become the fixed part of the Markbook90 grid). You can have as many columns as you wish, up to an absolute maximum of 80, at this stage, provided they are consecutive starting at column A. You can have up to 100 students, again occupying consecutive rows.

Then click on File | Save As, and under File Type, select Text, tab-delimited.



Choose a suitable filename and location, and save the file. You will get two warning boxes - respond Yes to each. It should then load into Markbook90 as described above.