Computerized Cash Registers:

• You may recall from Excel Section3 LessonD creating the start of a computer cash register.
• You created an inventory sheet, a categories sheet and a cash register sheet.
• This may jog your memory:

figure 5.1.1

• Such cash registers are used commonly in a variety of different retail stores and restaurants etc.
• In the case of a CD store instead of entering a number of a product in cell A2 above a clerk could simply scan a barcode as shown below:

figure 1.1.2

Barcode Font

• Remember that a barcode is simply a font used to display a number in this form which can be read from a hand held scanner.
• An inventory of all products is kept in a different sheet and when the product number is scanned the price and name of the product appears.

VLookup formula:

• In this particular case a VLOOKUP formula was used in cells B3 and B4 to lookup the information.

Computer Code:

• We will continue to turn this cash register into a full functioning one similiar to those found in stores.
• This will be done using computer programming.
• Up until this point you have been working in Excel using all the various formulas and functions in cells.
• However you can write actual computer code which will interact with the spreadsheet as well.

• Not many people other than computer programmers are familiar with this "advanced" feature of Microsoft Excel, however with programming you can create some amazingly complex applications without having a computer programming specialty from University.

Programming Computer Code:

• Computer programming requires you to be extremely conscientious as even a small typo will make your whole program not work--this is called a "bug" which you will then have to go in and find.
• This section is more advanced than previous sections and you will have to be particularly careful.
• In the assignment you will create some computer code using a macro recorder. By starting the recorder and doing various steps, the steps will be converted into code instead of you writing it all out yourself. You will then go into the code and make the necessary changes.

This website is copyright protected see contact page for details.