Learning Outcomes addressed and assessed in this Assignment:
(i) Demonstrate a clear knowledge of the role that information technology and information systems play in the business world
(ii) Display an understanding of IT concepts relevant to business and understand how they relate to each other
(iii) Apply practical skills in the most common office applications such as MS Word, MS Excel and MS PowerPoint as the industry standard
ASSIGNMENT DETAILS
In this assignment, you are required to use a spreadsheet and format it appropriately for the communication of financial details while carrying out some financial functions. Please see the instructions below. The template for the spreadsheet can be found on moodle. Where calculations are required these must be formulae rather than simply inputting values.
Instructions:
The spreadsheet can be found on moodle entitled “ExcelAssignmentTFB”. The spreadsheet details information relating to orders for products of a company.
1. Open the spreadsheet “ExcelAssignmentTFB” on the first worksheet. The spreadsheet should be formatted in a user friendly manner so that it is easy to read and analyse the existing data. For example, in the first worksheet is it easy to read all the data/headings? What could you do to improve it? What is missing for it to be more user friendly? We want to make the spreadsheet look professional and attractive to analyse.
2. For this data we need to be able to see the total, average, min, max and count of the sales for both phone units and for each year .Illustrate these calculations on the spreadsheet ensuring that the values are presented professionally. This must be done using formulae. We also need to find the total sales in dollars for each company.
3. For each company, we need to classify as to whether they are good or poor sales. Therefore we need to add a new column and use a formula to automatically decide for each company which of the two categories each order fits into based on the following information: Total order greater than or equal to 2,500,000 is “Target sales achieved” Total order up to 2,500,000 equals “Poor sales” Again presentation of this is important
4. The spreadsheet has four worksheets. In the second worksheet entitled “LinkstotalSales” create a linked formula which shows the total of the sales for all the products. This is just one cell on one spreadsheet
5. Verizon is calculating sales bonuses based on last years sales in the worksheet entitled “Commission” for its sales reps. Working with the other worksheet entitled” rates” devise a function which will work out the commission for each rep. Also, sort the names in the “Commission” worksheet in descending order as this was requested.
6. Create a suitable chart to show each company’s total sales in dollars from the first worksheet.Make the chart as user friendly as possible showing enough information to make it clear to everyone. In other words, design it well. Place this chart in a new worksheet and name the worksheet to reflect what the values are representing. Ensure all worksheets named to suit information.
7. Set it up to print effectively.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
