Data Analysis (Computer Skills)
For this coursework you are required to solve two problems using Microsoft Excel and Microsoft Access. Your solutions should be word-processed, including output from these programs, and submitted electronically.
In each case, your solution should include both the output itself and a detailed account of the methods you have used to produce the output (e.g. the menus and icons used to achieve the results). Where appropriate you should also explain the reasons you have chosen those particular methods.
A project requires different numbers of employees on different days of the week. Each employee must work 5 consecutive days, and then have 2 days off. We want to minimise the number of employees to be hired.
The number of employees required each day is:
Sun 17; Mon 14; Tue 14; Wed 14; Thur 18; Fri 18; Sat 12.
Using Excel Solver, calculate the minimum number of employees to be hired, and list the number actually hired each day. Explain carefully how we ensure that the solution does not include negative or fractional numbers of employees.
On some days there will be more people employed than are actually required. For example, if our solution involves employing 15 people on Saturday, the number of “excess” workers on that day is 3. While a small number of excess workers can contribute usefully to the project, it is undesirable to have a large number on any particular day. As a secondary objective we would like to minimise the largest number of excess workers employed on any day. Modify your solution to include that extra constraint. What is the largest number of excess workers in your final solution?
The Excel workbook “Orders” (available on Blackboard) contains two worksheets, “Orders” and “Customers”. “Orders” contains details of 673 orders, including the date of the order and the shipping address. OrderID is a unique identifier for each order. The CustomerID identifies the customer, referencing the field of the same name in the “Customers” sheet, where it identifies uniquely the contact person for that customer. The contacts are not necessarily based in the same city as the shipping address.
We wish to invite all contacts based in London to a reception, and to facilitate this we need a printout of all orders where the contact has a London address.
Import the Excel worksheets into Access as tables, defining suitable primary keys, and establish a suitable “relationship” between the CustomerID fields in the two tables, enforcing the referential integrity. Then create a Query to produce a table of orders with contacts based in London. Include the following fields: Company Name, OrderID, Order Date, Contact Name, Phone Number, and the City to which the order must be shipped. [Note that you will also need to include the “City” field for the Contact in the query, in order to select the London based ones, but that field should not be printed out.] Finally export the resulting table to a Word File (in rtf format) for inclusion in your submitted work.
Key Marking criteria will include:
• Accuracy of the numerical solutions
• Appropriateness of the methodology
• Clarity and conciseness of the descriptions of the methodology
The word limit for this individual assignment is 1000 words.
PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT ?
Our Service Charter
Excellent Quality / 100% Plagiarism-FreeWe employ a number of measures to ensure top quality essays. The papers go through a system of quality control prior to delivery. We run plagiarism checks on each paper to ensure that they will be 100% plagiarism-free. So, only clean copies hit customers’ emails. We also never resell the papers completed by our writers. So, once it is checked using a plagiarism checker, the paper will be unique. Speaking of the academic writing standards, we will stick to the assignment brief given by the customer and assign the perfect writer. By saying “the perfect writer” we mean the one having an academic degree in the customer’s study field and positive feedback from other customers.
Free RevisionsWe keep the quality bar of all papers high. But in case you need some extra brilliance to the paper, here’s what to do. First of all, you can choose a top writer. It means that we will assign an expert with a degree in your subject. And secondly, you can rely on our editing services. Our editors will revise your papers, checking whether or not they comply with high standards of academic writing. In addition, editing entails adjusting content if it’s off the topic, adding more sources, refining the language style, and making sure the referencing style is followed.
Confidentiality / 100% No DisclosureWe make sure that clients’ personal data remains confidential and is not exploited for any purposes beyond those related to our services. We only ask you to provide us with the information that is required to produce the paper according to your writing needs. Please note that the payment info is protected as well. Feel free to refer to the support team for more information about our payment methods. The fact that you used our service is kept secret due to the advanced security standards. So, you can be sure that no one will find out that you got a paper from our writing service.
Money Back GuaranteeIf the writer doesn’t address all the questions on your assignment brief or the delivered paper appears to be off the topic, you can ask for a refund. Or, if it is applicable, you can opt in for free revision within 14-30 days, depending on your paper’s length. The revision or refund request should be sent within 14 days after delivery. The customer gets 100% money-back in case they haven't downloaded the paper. All approved refunds will be returned to the customer’s credit card or Bonus Balance in a form of store credit. Take a note that we will send an extra compensation if the customers goes with a store credit.
24/7 Customer SupportWe have a support team working 24/7 ready to give your issue concerning the order their immediate attention. If you have any questions about the ordering process, communication with the writer, payment options, feel free to join live chat. Be sure to get a fast response. They can also give you the exact price quote, taking into account the timing, desired academic level of the paper, and the number of pages.