Wiki Sumber Informasi iSIKHNAS

Suggested steps for the process of getting the scanned data into electronic Excel format are:

1. Determine the required worksheet structure.
   • This is the most important step. Plan to spend time on it.
   • What metadata will be required, and where should it be stored?
2. Create a new workbook, and save it.
   • Enter the necessary metadata.
3. Set up the data structures.
   • Create the header row.
     • Use of formatting (colour, fonts, shading) should be minimual.
   • Apply any data formatting to assist clean data entry.
   • Insert any explanatory comments in header fields.
4. You may want to save the workbook at this time, with a different name, to act as a template for future (similar) data entry efforts.
5. Enter data.
6. Save your workbook frequently.
   • How often - ask yourself how much work you could bear to lose.
   • Wherever possible - use version control systems to avoid having to save multiple copies of files with different names on your computer.
   • CTRL+S is a useful shortcut that can be used to save your workbook at any time.