Bin-IT User Guide

IntroductionThe software program on this CD provides a governing body to achieve wage slips and employee education leaflets for your employees at the Bin-IT workplace. This is a bespoke software which is tailor made for your use. there are on screen instructions for installing your software but this user bespeak pass on provide more knowledge with in-detail instructions, troubleshooting second and a glossary. instruction manualBasic instructions to run the software1. delimit which folders you want to unless the spreadsheet, wage slip and leaflet. clear up the Run waiver which will automatically save the spreadsheet and both accounts to your computer.2. Once you have deliver the files to your computer regain your spreadsheet. This will be the spreadsheet you use to calculate the salary of various employees in your Bin-IT company. The columns youll want to swap regularly are from G to M where the existent hours. You bottom also change the wages or job baffle if people are given promotions or some matter similar.3. You will notice that when you image a value out of the range in the hours worked (outside of the parameters 0 to 12) and then an error message will appear intercourse you that you have entered an incorrect value. This is establishment this stops you from making typing errors when immersion in info.4. You female genitalia change the validation regularizations by selecting the values you give care to change by selecting the field you wish to change, going to entropy verification and then changing the parameters accordingly.5. Now the spreadsheet run lows are sorted we can carry onto the billet commingle functions. Mail merge allows you to automatically take the data from the spreadsheet and use it to make a wage slip and/or employee study leaflet. This software comes with the files already joined to each other thitherfore you dont wish to actually link the spreadsheet with the other documents.6. Open up the P ay bunk word document. Go to tools letters and ring armoring Mail connect. This will ease up up the mail merge unity.7. What will be shown to you is a mail merge wizard showing you which spreadsheet is selected to be merged with the word document.You can edit the pass catcher list and change who you wish the Mail Merge to apply to.8. Click beside twice to skip to Step 5 of 6 and there you can preview all your impress outs for the concede slips.9. Click Next again and you are on Step 6 of 6, print. Click print and ask which ones you which to print, or just leave it on All and flick OK. Before printing if there was anything you wanted to change on a one-time-basis with any of the employees wage slips then you can mouse click edit psyche letters and change a particularised thing for a specific wage slip.10. When doing Mail Merge for the leaflets just do exactly the equal thing but on Microsoft PublisherTroubleshooting* As stated in the instructions, you whitethorn rece ive an error message when laborious to enter in data in some cells on the spreadsheet. This is because a validation rule has been set on the specific cell(s). Step 4 explains how to change the validation rules if they do not meet the criteria of some of your employees.* On Step 7, you may have a problem with the Microsoft Word document not world properly linked to the spreadsheet with your data in. In the final result that this occurs, click carry a different list. From this use Explorer to see to it the spreadsheet file in the location you saved it, select it and then choose Sheet 1. semblanceMail merge Mail merge is a software function describing the production of multiple (and potentially large song of) documents from a exclusive template form and a structured data source. This helps to create personalised letters and pre-addressed envelopes or mailing labels for mass mailingsData validation In computer science, data validation is the do of ensuring that a program opera tes on clean, correct and useful data. It uses routines, often called validation rules or fancy routines, that check for correctness, meaningfulness, and security of data that are enter to the system.establishment Rule A Validation rule is a criterion use in the process of data validation, carried out after the data has been encoded onto an input medium and involves a data vet or validation program.Evaluation of User resultI have tested my user guide by providing my system to others with no other instructions apart from the ones on the user guide. I asked whether there was anything missing or anything else that may help. One common critical review I got is that I didnt have any kind of contact information in case the User Guide did not provide overflowing information. I also got advice to specify a little more in the contents of what is actually on each page.I have taken on these criticisms and have created a re-evaluated User Guide, starting on the succeeding(a) pageBin-IT System User GuideContents(Page)1. Introduction What is this software?2. Instructions Spreadsheet settings and functions3. Instructions (continued) Mail merge (Making the wage slip)4. Troubleshooting & Glossary of technological Terms5. Contact Details Phone, Fax & EmailIntroductionThe software on this CD provides a system to make wage slips and employee information leaflets for your employees at the Bin-IT workplace. This is a bespoke software which is tailor made for your use. There are on screen instructions for installing your software but this user guide will provide more information with in-detail instructions, troubleshooting help and a glossary.InstructionsBasic instructions to run the software1. Specify which folders you want to save the spreadsheet, wage slip and leaflet. Click the Run button which will automatically save the spreadsheet and both documents to your computer.2. Once you have saved the files to your computer locate your spreadsheet. This will be the spread sheet you use to calculate the wages of various employees in your Bin-IT company. The columns youll want to change regularly are from G to M where the actual hours. You can also change the wages or job position if people are given promotions or something similar.3. You will notice that when you enter a value out of the range in the hours worked (outside of the parameters 0 to 12) then an error message will appear telling you that you have entered an incorrect value. This is validation this stops you from making typing errors when entering in data.4. You can change the validation rules by selecting the values you wish to change by selecting the field you wish to change, going to Data Validation and then changing the parameters accordingly.5. Now the spreadsheet functions are sorted we can move onto the mail merge functions. Mail merge allows you to automatically take the data from the spreadsheet and use it to make a wage slip and/or employee information leaflet. This software com es with the files already linked to each other therefore you dont need to actually link the spreadsheet with the other documents.6. Open up the Pay Slip word document. Go to tools letters and mailing Mail Merge. This will open up the mail merge wizard.7. What will be shown to you is a mail merge wizard showing you which spreadsheet is selected to be merged with the word document.You can edit the recipient list and change who you wish the Mail Merge to apply to.8. Click Next twice to skip to Step 5 of 6 and there you can preview all your print outs for the pay slips.9. Click Next again and you are on Step 6 of 6, print. Click print and choose which ones you which to print, or just leave it on All and click OK. Before printing if there was anything you wanted to change on a one-time-basis with any of the employees wage slips then you can click edit individual letters and change a specific thing for a specific wage slip.10. When doing Mail Merge for the leaflets just do exactly the same thing but on Microsoft PublisherTroubleshooting* As stated in the instructions, you may receive an error message when trying to enter in data in some cells on the spreadsheet. This is because a validation rule has been set on the specific cell(s). Step 4 explains how to change the validation rules if they do not meet the criteria of some of your employees.* On Step 7, you may have a problem with the Microsoft Word document not being properly linked to the spreadsheet with your data in. In the event that this occurs, click Select a different list. From this use Explorer to find the spreadsheet file in the location you saved it, select it and then choose Sheet 1.GlossaryMail merge Mail merge is a software function describing the production of multiple (and potentially large numbers of) documents from a single template form and a structured data source. This helps to create personalized letters and pre-addressed envelopes or mailing labels for mass mailingsData validation In com puter science, data validation is the process of ensuring that a program operates on clean, correct and useful data. It uses routines, often called validation rules or check routines, that check for correctness, meaningfulness, and security of data that are input to the system.Validation Rule A Validation rule is a criterion used in the process of data validation, carried out after the data has been encoded onto an input medium and involves a data vet or validation program.