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.
- Lecturer: Fredericks Ngubi
Level of Study: 300 Level