ICT700 Excel 2003 Modelling a school or departmental requisition
Description
Modelling is the investigation of hypothetical or abstract situations. Basically we are going to use the computer to hypothesise asking the 'What?' and 'What if? questions and then seeing what happens when one or more things change. This use will use a departmental budget to create a model which we can use to see what will happen if we buy different volumes of items for a department.
Content:
use a spreadsheet model to hypothesise
create a simple model
design a simple macro
assign a macro to an action button
Be able to use a spreadsheet model to hypothesise
Be able to create a simple model
Be able to design a simple macro
Be able to assign a macro to an action button
Level: Intermediate users
Audience: All education staff
Pre Skills: Competence in the basic skills in a Windows environment
