Assignment 1
The following table shows the sales of various food items at Al's Diner over a five-day period:
AL'S DINER
Items Mon Tue Wed Thur Fri
Burgers 40 35 28 39 42
Chips 48 43 40 47 51
Fish 22 19 23 27 21
Lasagne 23 18 11 17 27
Pies 14 17 12 8 19
Pizzas 20 18 22 16 14
Quiche 10 13 15 9 5
Salads 18 25 28 33 29
Sandwiches 25 28 32 24 26
Soup 12 13 15 17 11
You are required to enter this data onto a spreadsheet and save the file as Diner1.
You must now carry out the following tasks:
1. Add a column after Friday's data to show the total sales of each item over the five days.
2. Insert a column between Friday's data and Total sales. Enter Saturday's sales as follows: burgers - 56, chips - 63, fish - 25, lasagne - 33, pies - 29, pizzas - 20, quiche - 11, salads - 44, sandwiches - 27 and soup - 19. Amend the totals' formulae to take account of this insertion.
3. Add a column after the Total Sales column to show the unit price of each item: burger - £0.85, chips - £0.50, fish - £1.30, lasagne - £1.95, pie - £1.05, pizza - £1.75, quiche - £2.20, salad - £1.60, sandwich - £0.95 and soup - £0.75.
4. After the Unit Price column, add a column to show the total income for the sales of each item during the six-day period.
5. Enter a formula in the appropriate cell to show the total income for the week at Al's Diner.
6. Format the unit price and total income columns to currency format.
7. Save the spreadsheet as Diner2.
Assignment 2
The Old Mill Theatre has just completed a very successful run of Lionel Bart's 'Oliver'. The following table shows the daily attendance over the period:
OLD MILL THEATRE
Date Adults Children
June 2 385 843
June 3 411 715
June 4 334 664
June 5 401 1012
June 6 346 782
June 7 433 875
June 8 481 918
June 9 411 808
June 10 417 845
June 11 393 722
June 12 477 904
June 13 578 976
June 14 468 953
June 15 364 899
June 16 463 927
June 17 459 932
June 18 593 1007
June 19 694 996
June 20 755 1016
June 21 742 951
June 22 569 962
Enter this data onto a spreadsheet and save the file as Theatre1, then carry out the following tasks:
Add a column, labelled Total Audience, to show the total number of people that attended on each day.
Add a row, labelled Total, to show the total number of:
Adults who attended over the period
Children who attended over the period.
Add a row, labelled Maximum, to show the maximum numbers of adults and children that attended on any day.
Add a row, labelled Minimum, to show the minimum numbers of adults and children that attended on any day.
Add a row, labelled Days, to show the number of days during the 'run' (Hint: Use the COUNT function).
Save the spreadsheet as Theatre2.
Add two columns, labelled '%Adults' and '%Children' respectively, to show the percentages of the audience that were adults or children for each day during the period. Format the two columns to percentage format (one decimal place).
The numbers of adults who attended the production on June 8, 9 and 10 have been incorrectly given. Erase the contents of these three cells and enter the following amended data: June 8 - 516, June 9 - 463 and June 10 - 402.
Save the spreadsheet as Theatre3 and obtain a printout.
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
