IST Implementation Essay Example for Free

IST Implementation seein sensation(a) case the carcass is fabricated, it is important to scrutiny the organization of rules, this is so I great deal discover any faults deep down the system and to make sure that I stool met the end specimenr requirementsThe system will be tested withnormal data ( data which is the normal to test)Extreme data ( data which is exceeded test range) chimerical data( data which is totally wrong to test)Macro testingFormula testing- formulas must be correct and united to specific cellsVLookups- must be correct and linked to specific cellsthe lay out of the test scrap will be in t able-bodied data format , illustrating each test as fully as possible at this stage . the plan will include the hobby column headingtest no .test criteria what is to be testedtest purpose why is it been testeddata what data is occasiond to perform the test ie. Normal extremeexpected outgrowthsactual outcomei will start out evidence of my test results by i llustrating each one with screen shots and all will be reposesection referenced and annotated properly this will be shown after the implementation is done . stressingUser porthole testing issuance quiz criteriaTest purpose evaluate outcomeActual outcome1 frankfurter the program line press release stock-taking leaningTo check the stock table out-of-doorssThe overall stock sheet should forthrightThe stock list kit and caboodleheet opens2Click the command button client dilate To check the client exposit opensThe overall client details should openThe customer details whole kit and caboodleheet opens3Click the command button Build your own pcTo check the Build your own pc opensThe overall Build your own pc should openThe Build your own pc ricksheet opens4Click the command button postingTo check the Invoice opensThe overall Invoice should openThe Invoice worksheet opens5Click the command button ExitTo check the Exit worksheet opensThe overall Exit worksheet should openThe worksheet exits and fork overs as pass on6Click the command button HELPTo check the supporter button /Vba opensThe sustain button should open with a essence lashThe help button opens showing a cognitive content misfortuneScreen shots of Testing Test procedure 1The substance ab exploiter clicks on the stock list button and the stock list worksheet opensAs you stub see on a lower floor the worksheet stock list opens and worksTest number 2The substance ab user clicks on the stock list button and the customer details worksheet opensAs you raft see beneath the worksheet customer details opens and worksTest number 3The user clicks on the stock list button and the Build your own pc worksheet opensAs you atomic number 50 see below the worksheet customer details opens and worksTest number 4The user clicks on the stock list button and the bank bill worksheet opensAs you can see below the worksheet invoice opens and worksTest number 51) the user clicks on the command butto n exit below is what message box appears this name us 2 options.If I dint want to exit excel is would click no and the message box that will appear is If I clicked yes my work would get saved and it would exit my worksheet .Test number 6The user clicks on the command button (a) help a message box should appear as shown below(a)As you can see below the help button opens .Test number 7The user clicks on the homage button (1) and the home scalawag worksheet will open (2)(1)Homepage button(2) as you can see below the homepage opens once the homage navigation button has been clickedTest number 8The user clicks on the worksheet button invoice (1)as shown below and the following will show(2)(1)user clicks the button(2) As you can see below the invoice worksheet opensTest number 9Stock list worksheetTest numberTest criteriaTest purposeExpected outcomeActual outcome7Click the command button home pageTo check the if the button goes to the home pageThe homepage should openThe homepage worksh eet should open8Click the command button invoiceTo check the Invoice opensThe overall Invoice should openThe Invoice worksheet opens9Click the command button hide power grid lines To check if the gridlines meld when clickedThe grid lines should disappearThe grid lines did not show on the worksheet10Click the command button show grid linesTo check the button shows the gridlinesThe gridlines should showThe gridlines show on the worksheet11Click the command button bulls eyeTo check the button prints the worksheet outThe stockist worksheet should print outThe worksheet printed out .Customer details(worksheet)Test numberTest criteriaTest purposeExpected outcomeActual outcome1112131415Design your own pc (worksheet)Test numberTest criteriaTest purposeExpected outcomeActual outcome1617181920Invoice(worksheet)Test numberTest criteriaTest purposeExpected outcomeActual outcome2122232425ImplementationUser port wineTo set up my new computer system I postulate to use a spreadsheet softwargon package and so I choose to use Microsoft excel. I used this softw atomic number 18 as it is simple to use for setting up and provides the most ordinarily used spreadsheet package . This means that the most of the people who are able to use the pc and use Excel , and I know that the employees at PC systems who will be using the system can use the software. I collected the data for the spreadsheet by contacting Pc Systems contacting turnedice , materials and extra and for the pc parts and early(a) information I used from the PC Systems website.How to memorialise the macro instruction instructions on the user interface and all pagesFirstly I used clip are as shown below to get the pictures for my user interfaceBelow is how I open the clipart card at a time the clip are menu is opened I searched for the following items for the pictures to come up that I used for my interfaceclip art menuThe following clip art images I used for my interface as shown belowMACROSOnce the pictures a re in place I now can record the macros I need to navigate rough the spreadsheet as shown below . dance step 1 Firstly I needed to click on tools consequentlyce macro and then record new macro as shown belowStep 2 and so I give a name for my macro .eg macro 1 then press OKStep 3Now you will see a little play and pause button icon as shown belowStep 4Now I accommodate to select the speech of the macro as you can see at the bottom of the worksheets on that point are named worksheets eg when I do the customer details macro I will do the following as shown below.Once customer details has been selected I then clicked stop on the macro button as shown below .Step 5 once I had clicked stop I then clicked on the picture which was relevant to customer details as shown belowthen right click on the picture and select qualify macro as shown hereStep 6 hence once it has opened now I will select the macro I have just made to link it with the button as show belowOnce macro 1 is found then c lick OK and the macro works and it links to the customer worksheet.I did this to all my macros which are link on the user inter face as shown below I used the alike method on all 4 of them.I also have navigation buttons on the other worksheets to return to the user interface so the user can move around my spreadsheet quick and efficiently.VBA computer grave Vba enrol is useful for producing message boxes , and are blue-blooded to do as shown below and again they are linked to my picture HelpI opened vba up as by pressing ALT, F11 together and this screen should appear(1)(2) entering the code as shown below into vba . I have included the following message for the user so if they have problems with the software or with any formulas or buttons they can contact the helpline so I can help them and guide them in the write direction .Now right click on the picture as I said before and assign macro and then choose helpline and once it is done the outcome isNow I am going to make an exi t button using vba so the user can exit excel immediately and saving in that location work at the alike(p) conviction .using this button below .this method is used again by right clicking on the picture and visualiseation the macro as shown below Then open up VBA as shown above.Now enter the code as shown belowOnce this coded is entered I linked it with my button as shown in the other example and the out come should be as shown below ..first click on the exit icon then this message box will appearIf no then If yes then application quits masteryfully.Named rangesOnce I have entered the stock information into my spreadsheet I need to name the ranges to use them in a v look up .to make it easier for the use to make calculations and search for the criteria needed to run the system correctlyStep 1 I highlighted customer details as shown belowThen I named the highlighted items customerddd as shown below using the tool measuring rod as shown below then I pressed enter so that it conf irms that the name has been changed and is saved .I used this method to name all of my ranges and named them appropriately.To show all of the named ranges I did the followingInserName defineThen this toolbox opens showing all the named ranges and the formulas in the specific range as shown below . here you can add names and delete them .V-look upsCombo boxesA combo box sometimes called a drop down box is a list of items from which you can choose one item of data.To open the combo box menu I needed to right click on the mouse and select forms as shown below Once I have clicked on the forms the menu below opened As shown above I then selected the combo box item, then I draw the combo box in the correct column to make it look victor as shown below .Once I drew the combo boxes they need to be linked to a Vlookup and I need to format the control to link with the specific sell eg, yield number as shown below(2)(1)(2)First I had to right click on the combo box and select the format cont rol as shown belowSpinnersA spinner button enables you to increase or decrease the value of a number in a cell by clicking the control.firstly I right clicked on the excel tool bar and selected forms as shown below .Then I selected the spinner from this menu choice as shown below .Then I drew the spinner on my spreadsheet as shown below Then I needed to format the spinner to a specific cell to make calculations as shown below .i firstly right clicked on the spinner and the menu below appearedI then selected format control as shown below and the following message box appeared .EvaluationIn my evaluation I will first of all consider each of the end user requirements stated in the specification in turn and my objectives , and evaluate the success of below are my general objectivesStart up screen and Homepage buttons and links to all the pages back and forrad .I have met this objective as My spreadsheet has a start up screen and various buttons which were requested by the user so the u ser can move around the spreadsheet efficiently and are able to open and close worksheets also there are 2 other buttons which I used vb code so if the user gets stuck or damages the spreadsheet they contact the help line also there is a save and exit button which will make a back up of the work for forthcoming reference and a print button eg. For the output of the invoice as needed which will save a lot of time compared to the old system where everything is done by paper and when a record needs to be found it took a long time and even got lost on the other hand the spreadsheet saves records and time and is much more reliable and efficient compared to the old systemVarious work sheets such as , hardware sheet ,invoice sheet etcI have met this objective as there are 4 separate work sheets to separate the collection of data (stock) and the output(invoice) 4 separate sheets helps the user move around the interface smoothly as he can open and close the like work sheet as neededAutomat ically store customer details and what they have bought.Once item is bought it is taken away from the stock.Protect the work sheet so no formulas can be altered by the user .Use formulas to calculate total cost and vat etcLabels to help the customer when moving on to a button option boxes to let the user choose the best product eg reposition for themLimitationsIn the system there are various limitations I have recognised.In one of my validations it wasnt accurate as when I typed in incorrect data the error message wasnt displayed . this would then create inaccurate data as the user wouldnt be aware of there mistakesImprovementsIn the system there are various amendments that can be made to improve the overall systemAlso to improve my system I would create a separate spreadsheet that contains each customers details of the products they have previously bought and what they have ordered so the end user knows what the existing customers have bought so the user can deciide to give disco unt for spending so much money etc valuable customer.End user commentsI arranged a meeting with mr Anderson who will be using the system to see how he feels more or less It and helps slue work load that he originally had to do . I first of all gave the end user a couple of days to familiarise to the new systemHere are the end user comments * The deign is practical and doesnt irate the eyes the colour is restful and doesnt distract the users attention .* Navigation is easy , as is adding and deleting information* Alternating through the worksheets are very easy* The out out of the system (the invoice) are very organise and very consistant* The macros , formulas and v look ups help reduce lots of manual(a) imput which saves time .* There are few errors made as validation used on variant data helps keep data accurate and up to dateMy overall commentsI think my design is reliable and easy to use , there are only a few things that I can change and they are mentioned in my improveme nts , I think I have reduced massed amounts of user foreplay compared to the paper work what they had to do before which took allot of time and effort , also the system looks professional and is very efficient and is very user friendly.User guideContents pageDescription knaveIntroduction / Installing / Opening the systemFunctions of the user interfaceCustomer sheetEntering customer detailsDeleting customer detailsIntroductionWelcome to the Invoicing System. This system has been created so that you can create an invoice in a seconds compared to the paper work that you used to do.InstallationThe system works directly off the USB memory stick, or alternatively you can copy it to the computer and run it from your computer. Simply press ctrl c on the Invoicing System file, and then press ctrl v in on the hardrive or in my documents on your computerOpening the spreadsheet system* Insert the USB stick .* Next, click on My Computer* Next, open the memory stick (a). If the logo is not there then wait for a couple of minutes as computer may be trying to detect the key or press F5 to refresh the page to help the computer detect the inputted device . then click on the invoice system (b) and open the file(A)(b)Once the system has been opened the following pop up will appear about the security of the spreadsheet on the screen as shown below If this is presented then simply click on alter Macros. This will activate the buttons in your spreadsheet . but if you click disable the spreadsheet will open but the macro buttons will not work which will effect the spreadsheets efficiency(C)The screen below will be presented once the spreadsheet has opened below User interfaceThe user interface is the heart of the system which allows you to approach shot the invoice system, and to access the stock list and access the customers list and allow users to choose what they would like to buy. To do this, simply click on the buttons at the top of the screen. These buttons are on all sheets , in the same place and with the same names, they will all open their appropriate areas when you click on them and do the tasks the same .CustomersTo enter the customers details into the system, you will first need to select the button from any area. This will open up the customers sheet which should look something like the one below.