Lately we have been familairising ourselves using Excel. We have used excel as an information system and just completed working with Overtime Hours using Excel. The site that helped us with the formulae is down below.
http://www.cpearson.com/excel/overtime.htm
Wednesday, February 25, 2009
Tuesday, February 17, 2009
Examples of Info Systems Put Into Practice
Today we were looking at different examples of Information Systems. We used Mark Books as an example. We also created using Microsoft Excel a spreadsheet of wages. This was another form of Information Systems.
We also learnt the difference between Absolute and Relative Reference.
Absolute Reference refers to an absolute point that won’t change. This sign $ is critical, it tells the spreadsheet what you are doing without it, or it becomes relative reference.
Relative Reference is when an item is moved or the relationship to it has changed.
Like in a spreadsheet, a cell with a relative reference changes its formula when copied elsewhere.
We also learnt the difference between Absolute and Relative Reference.
Absolute Reference refers to an absolute point that won’t change. This sign $ is critical, it tells the spreadsheet what you are doing without it, or it becomes relative reference.
Relative Reference is when an item is moved or the relationship to it has changed.
Like in a spreadsheet, a cell with a relative reference changes its formula when copied elsewhere.
Monday, February 9, 2009
Tuesday, February 3, 2009
Monday, February 2, 2009
Introduction to Information Systems!
Information Systems refer to the specific application software that is used to store data records in a computer system and automates some of the information-processing activities of the organisation.
Some Examples of Information Systems are:
Electronic Verification System: A system allowing merchants to verify that the card is valid and the credit card customer has sufficient credit to cover the purchase in a few seconds, allowing the verification to happen at time of purchase. The verification is performed using a credit card payment terminal system with communication links to the merchant's acquiring bank. Data from the card is obtained from a magnetic stripe or chip on the card.
Weather Radar: A type of radar used to locate precipitation, calculate its motion, estimate its type (rain, snow, hail, etc.), and forecast its future position and intensity. Weather radars send directional pulses of microwave radiation, which is a microsecond long, using a cavity magnetron (a high-powered vacuum tube that generates non-coherent microwaves) connected by a waveguide to a parabolic antenna.
Some Examples of Information Systems are:
Electronic Verification System: A system allowing merchants to verify that the card is valid and the credit card customer has sufficient credit to cover the purchase in a few seconds, allowing the verification to happen at time of purchase. The verification is performed using a credit card payment terminal system with communication links to the merchant's acquiring bank. Data from the card is obtained from a magnetic stripe or chip on the card.
Weather Radar: A type of radar used to locate precipitation, calculate its motion, estimate its type (rain, snow, hail, etc.), and forecast its future position and intensity. Weather radars send directional pulses of microwave radiation, which is a microsecond long, using a cavity magnetron (a high-powered vacuum tube that generates non-coherent microwaves) connected by a waveguide to a parabolic antenna.
Subscribe to:
Posts (Atom)