Design a spreadsheet that can be used by a school tuck shop.
Analysis My task is to design a spreadsheet that can be used by a school tuck shop, which can be used to find the following: * Income * Expenditures * Stock amounts * Popularity of products * The selling price of stock * Profit made * Wages of employees * Whether to order more stock The spreadsheet can be used as a model to predict all of these things throughout the three school terms. The product popularity can be used to see what products are most popular and unpopular in the different seasons. This can then be used to order in more or less of a certain product to get maximum profit. The spreadsheet has been designed to calculate the how much profit you make on each item and how much overall after expenses such as electricity and wages have been paid. IF formulas have been used to tell the owner when he/she needs to buy in more of a certain product. By using the relevant information from the spreadsheet, chart can be made. The popularity of items could be shown on the charts. The spreadsheet is set up so that if you change a certain variable, all of the calculations are updated and you are able to predict what will happen. For example: * If VAT rose to 20% on one week * If Electricity costs went up by £3 * If national insurance rose by 3% * If TAX rose by 5% * If certain stock doesn't sell I will use these examples as tests to test out the model
Spreadsheet Project Identify - A couple of months ago my friends and me formed a band called "MISK". As we are new to the field of accountancy, we are finding it hard to keep track of our spendings and savings.
Spreadsheet Project Identify A couple of months ago my friends and me formed a band called "MISK". As we are new to the field of accountancy, we are finding it hard to keep track of our spendings and savings. We also find it hard and time consuming to evenly share out the money between different funds (we have different funds for different things e.g. Drums, Amps etc and they all need different amounts of money) and ideally we need to share out the money proportionally between each fund. So we have all decided that we need something to help us easily manage our finances. I am therefore going to design and make a spreadsheet that will help us keep track and organize any of the little money that we are able to save, and how we should spend it. As our needs and funds will be continuously changing, a spreadsheet is the best solution as it is able to change and react when information is inserted and is able to perform complex equations automatically. A lot of data is to be stored, so a database could be used, but a spreadsheet package is better because complicated calculations will be performed on some of the input data and this can be done on a spreadsheet but not on a database. Another advantage of using a spreadsheet is that I am also able to show tables and other information like information that the other members of the band need to know. I will also be able to email
Reviewing draft documents to produce final versions using tools in Microsoft Word.
Transfer-Encoding: chunked For M2, the evidence can be taken from anywhere. Learners are not required to learn standard proofing symbols, but are expected to make notes or marks on the original document which indicate what has to be done. Evidence will require the initial documents, the final documents and some indication of authenticity of work. Indications of what would be appropriate are included in the relevant section of the PSA. As part of my continued training in my post I am required to maintain and improve my communication skills. I will communicate review draft documents to produce final versions. Spell checker was one tool that I used to review draft documents. I clicked on the Spelling & Grammar option. I then looked to see the options for the misspelt word and then pressed add. I then got a pop up showing that the spelling and grammar were all correct. Spelling and Grammar options are very important to ensure that everything is making sense and everything is spelt correctly. It’s very important that when you hand work in its perfect as if it’s not it will look unprofessional. Sometimes the Spelling and Grammar option may pick out words and spell them the American way. This option should be used with caution. Next I made use of the thesaurus and synonyms options. I right clicked a word that I wanted to change and clicked Synonyms which gave me a
implementation report
Implementation report For Forms Main menu Form For me to design a main menu page I need to open Microsoft access first and then after I have opened Microsoft access I need to open my database, after this I clicked on create form in design view. Appendix 1 Appendix 1 shows the form in design view; you can manually design your form by going on create form in design view. Appendix 2 Appendix 2 shows that I am going to auto format my form so that the style looks different and it looks more professional Appendix 3 Appendix 3 shows the auto format wizard of the form this lets me decide what format and style I want the form to be like this will make the form look more attractive and therefore would be more appealing to the user Appendix 4 This is how my form looked in design view when I finished the auto format. Appendix 5 Appendix 5 shows that I added a title by first adding a textbox and then writing in the appropriate title, and then I changed the font and the style of writing. Appendix 6 Appendix 6 shows that I inserted the pictures either side of my title to make the form stand out and look more colourful. Appendix 7 Appendix 7 shows how I created a command button to link to my loans form, I first need to open the command button wizard, this wizard is shown in appendix 7, and I then clicked on open form Appendix 8 Appendix 8 shows that I chose the loans table
Database design
Design Test Plan NORMAL BOUNDARY INVALID Merge Standard Letter & Database To check that merge process works as expected Insert Alex Olivares into database and merge Personalised letter to Alex Olivares appears Insert Papa Smurf into database and merge Personalised letter to Papa Smurf appears N/A 2 Spellcheck To check that Spellcheck works and letter is free from errors Write "dear" and "sir" and. Spellcheck function identifies errors N/A Write "Chippingdon" Spellcheck function offers suggestions. They are ignored 3 Print Preview To check that layout is satisfactory Check position of Spearmint logo and address Layout is fine N/A N/A 4 Font Selection To check that font is appropriate Select 5-6 fonts and apply to use implement Choose main font for my letter ???? London Main font not changed N/A 5 Readability To check that font colour used does not affect legibility Select black for main font colour. Apply to my main paragraph Readability is fine Select rose for main font colour. Apply to my main paragraph Readability is affected. Select light turquoise for main font colour. Apply to my main paragraph Writing is hardly legible. It is important to check that the merging of the letters goes well, as if I don't, letters with one set of details could be sent to the wrong person. It is also imperative that the spellcheck functions,
Database Project.
Database Project The Problem: The Drama department have always had a highly under-organised technical store cupboard. In this cupboard, they have a stock of all sorts of technical equipment, such as Lantern Lamps, Dimmer Pack Fuses, 15Amp Extension cables etc. When there is a show in the making at the school, it is very important that the chief technician in charge is aware of what is in stock in the cupboard, and what the department is short of so that it can be ordered in. Therefore it has been suggested that a computer-based database would be extremely useful in order to allow the technicians to easily see what is in stock. Why Access? For this databases, I have chosen to use the program Microsoft Access. This is because it is a program that has been explicitly designed for anybody to design simple databases. In fact, it is such a good program, you can make your database as simple, or as complicated as you require. The program allows the user to create a table for the information to be entered in. In this table, you can have as many or as few fields as you like (fields are where each record is organised into). You can then create different designs for the table, and different forms. With Word, you can only have a table in the document, so it is very easy to accidentally delete work. Like wise with PowerPoint. I could have used Excel, however, it is mainly
Lancre Festival
Task 2 Design Software Features Software Features Needed Why is this needed? . I must be able to input text. I have been asked to create a text based spreadsheet, so that I can enter descriptions for income and expenditure items. 2. I must be able to copy and paste. I need to insert two tables from shared resources on to my spreadsheet. Copy and paste functions make this task easier and less prone to error. 3. I must be able to make a system that works out all the totals every time someone changes the information. Stuart told me there must be a system that works out all the totals every time someone changes the information. It will make it easier and quicker if someone wants to add more information so they will not have to manually calculate the new totals, with the risk of errors. 4. I must be able to validate cells. I have been told that to create a system so no one can change the table so there are more than 50 floats in the float parade. Validation can be set up to automatically prevent this. 5. I must be able to save and open the spreadsheet. I will need to save it after I finish working and I will need to open the spread sheet when I wish to review it or update it. 6. I must be able to change the font and style of text. I will need to make parts of text stand out. 7. I will need to be able to change the size of some of the cells. I will need to make
Microsoft Word
How does Russell show the difference between the two mothers in the play, to affect the audience's response? At the beginning of the play Russell introduces us to the characters of Mrs Jhonstone and Mrs Lyons. Mrs Jhonstone has got a job, but Mrs Lyons has a very well paid husband who works away. Mrs Jhonstone has got 7 children and another 2 on the way. Mrs Lyons can't have children so Mrs Jhonstone sells one of her babies she is having so that both mother can be happy, because Mrs Jhonstone is all ready getting threaded with the welther officer. A quite from the play "I could manage with one more but not two." Her husband used to say "all we had to do is share hands and you would be pregnant" with mrs jhonstone having all her children it seems like she didn't plan her family, but on the other hand mrs lyons wanted a big family but as she couldn't have a child "I wanted to adopted but Mr lyons all ways wanted a son of this own." That is a quite from the play, this means Mrs Lyons is lonely. Mrs Lyons is lonely because she is on her own she hasn't got a child and her husband works away, we get the impression that she hasn't got many friends. Mrs Jhonstone has fears when she finds out she is having twins. But when she tells mrs lyons she says give one of them to me at first mrs Jhonstone says "Oh, Mrs lyons you can't be serious" mrs lyons says your 4 months pregnant but only