Introduction: Structure and parts of computer. Input and output devices. Central processing unit. The spread sheet. Menu and toolbars, cell address. Absolute addressing. Range of cells. Design and creation of template. Advantages of the spreadsheet (copying). Function evaluation. What if analysis, circular referencing. Matrix methods. Material and energy balance calculations using spreadsheet. Handling of recycle and purge using calculation options. Creation and use of scratch pad. Graphs plotting. Formatting of plots. Adding of trends lines, slope and correlation coefficient. Numerical differentiation and integration using excel. Calculation of reactor volumes. Use of commercial software in solving material and energy balance problems e.g. ChemCAD and Hysys.


Level of Study: 300 Level