Using Spreadsheets

Okay, so now you have a list of data recorded and saved as a CSV file and you want it as a spreadsheet. First of all, you've got to know a bit (or a lot) more about them before doing anything. So first things first.

1) What is Spreadsheets Modelling?
Spreadsheet Modelling is a computer program that allows you to create, edit and maintain full data. Note that the output depends on the input. Changing the input value will most certainly affect the output.

2) List three uses of Spreadsheets.
So you're wondering what those spreadsheets can do? Well, you can put it this way: It is used to design, perform calculations, produce high quality output; the fact is that it is actually used to predict the possible outcomes 

3) What does CSV.File stand for.
You should be very aware that CSV stands for "Comma Separated Values". Forget this and see where that'll get you. 

Read More

System Documentation

Read More

System Design (Home-Work Question)

When desigining a layout, the analyst will be influenced by the views of the users and their requirements. He'll need to consider who will see them. There will also need to be consultation with the owner(s) of the firm.

For screen forms, the analyst has to consider the attractiveness of the screen layout and its simplicity. The screen form should not be complicated for the users and it is heavily advised to include on-screen instructions on how to navigate from screen to screen.
The main aspects of the way output is designed is its output and the medium it is to be produced on.

The format could be: graphs, tables, reports or lists of records. The medium on the other hand could be a hardcopy (paper), a softcopy (screen display) and/or sound.

Sometimes, the designer will also want to consult customers via questionnaires in order to design the most suitable system for the firm. It is normal for system analysts to produce three or four different designs of an item output. When designing these, the analyst is fully aware of what the purposed system is capable of producing. The users of the system will also be asked for their views.

Read More