Make The GradeIntroductionSam And Sonia Who

Better Essays
Topics: Spreadsheet
Make the Grade

Introduction:
Sam and Sonia, who are two teachers, have formed a company called 'Make the Grade'. They sell revision guides for GCSE course to schools. They produce paper-based student workbooks and interactive revision guides sold on DVDs.

At the point when schools buy a DVD they can either purchase it with a single-user license, which permits them to utilise it on only one computer at once, or with a site license, which permits them to use the item on any computer inside the school. Student workbooks are priced £10 less than DVDs with a single-user license. DVDs with a site license are valued at 20 times the cost of a single-user licence, rounded up to the most proximate pound.

A word-processed template is currently used for Sam and Sonia's invoices, they use the template to list school address details and prices of products. They also use a calculator to calculate the costs. Quotes and invoices are produced by these manual methods but calculation errors occasionally occur. They are searching for a more efficient process as their product range and their sales increase. They have been advised that they have to use a spreadsheet, yet they don't have a whole lot of understanding in operating this program.

Sam and Sonia would like you to produce a spreadsheet model that would empower them to reserve product details and prices and when new products become available they can simply add them onto the list. They would also like the spreadsheet model to store customer details and enables them to form and print invoices for placed orders.

Sam and Sonia have given you the accompanying electronic documents which you will need to finish, this includes their price list which also includes current delivery charges and discount rates. You will also need to complete an example invoice and a spreadsheet with some sample customer information to demonstrate to you the details they store about the schools who buy their revision guides.

Demonstrating

You May Also Find These Documents Helpful

  • Good Essays

    Sonia

    • 612 Words
    • 3 Pages

    EXERCISE 2.1 Individually or in a group find as many different examples as you can of physical controls and displays. (a) List them (b) Try to group them, or classify them. (c) Discuss whether you believe the control or display is suitable for its purpose. (section 3.9.3 may also help) answer open-ended investigation EXERCISE 2.2 Exercises 2.2 and 2.3 involve you examining a range of input and output devices in order to understand how they influence interaction. A typical computer system…

    • 612 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Sonia Sotomayor

    • 566 Words
    • 3 Pages

    The Supreme Court is the highest judicial court in the United States of America. Sonia Sotomayor is the Associate Justice of the Supreme Court of the United States. Sotomayor is the 1st Hispanic justice, 3rd female justice, and the courts 111th justice. She has been a loyal member of the liberal side. Sonia Sotomayor was born in the Bronx, New York, on June 25, 1954. Her parents, who were of Puerto Rican decent had a diminutive income. When Sotomayor was 9 years old, her father died. Her…

    • 566 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Sonia Sotomayor

    • 767 Words
    • 4 Pages

    In the book, My Beloved World, Sonia Sotomayor discusses the long list of struggles that she faced throughout her early childhood all the way to the point that she reached college. She explains experiences ranging from things as difficult as losing her father suddenly and unexpectedly to simply struggling to keep her grades up or decide between what college she wanted to attend. Though Sonia faced these struggles, she still managed to find things that shaped her into the Associate Justice of the…

    • 767 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Sonia Delaunay

    • 1344 Words
    • 6 Pages

    Sonia Delaunay-Terk was an innovator, inventor, fabricator and an artificer; well known for her signature style of geometrization of forms and vibrant melody of colors. Born in Ukraine, she moved to Paris in 1905 at the age of 20 after reading a book by an art critic, Julius Meier-Graefe, who had promoted the creative city as a centre of true art. Her early influences were Van Gogh and Gauguin. Delaunay took up art courses in Paris but left after feeling confused and discouraged by her teachers’…

    • 1344 Words
    • 6 Pages
    Good Essays
  • Satisfactory Essays

    Who Makes the Journey

    • 321 Words
    • 2 Pages

    Who Makes the Journey by Cathy Song In most cases its is the the old woman who makes the journey the old man having had the sense to stay put and die at home you see her scurrying behind her newly arrived family. She comes from the Azores and she comes from the the Orient. It makes no difference. You have seen her before the short substantial legs buckle under the weight of the child she carried centuries ago like a buundle of rags who now turns in fronmt of your windshield, transformed in western…

    • 321 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Sonia Sotomayor Essay

    • 645 Words
    • 3 Pages

    Sonia Sotomayor is a Associate Justice of the Supreme Court of the United States. She is known for being the first Hispanic justice, the first Latina, the third female justice, and the twelfth Roman Catholic justice. Sonia was born in the Bronx to her two Puerto-Rican born parents. Her mother’s occupation was a practical nurse while her father had a low education and was unable to speak English. During her early ages of life, she was mostly raised by her mother because her father died when she was…

    • 645 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Sonia Sotomayor Biography

    • 423 Words
    • 2 Pages

    Federal judge Sonia Sotomayor was born as the eldest of two children in the South Bronx area of New York City, on June 25, 1954. Parents Juan and Celina (Baez) Sotomayor, who were of Puerto Rican descent, moved to New York City to raise the family. Sotomayor's family functioned on a very modest income; her mother was a nurse at a methadone clinic, and her father was a tool-and-die worker who died when Sotomayor was only nine years old. Sotomayor's first leanings toward the justice system began…

    • 423 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    THE” TRUE”STORY OF” FAKE LEADER” SONIA GANDHI Alias ANTONIA MAINO-By SATYAMITRA 88 Votes Who is Sonia? (By Dr. Subramaniam Swamy) Antonia is Sonia’s real name in her birth certificate. Sonia is the name given to her subsequently by her father, Stefano Maino [now deceased] following his return from Russia where he had been a prisoner of war. Stefano had joined the Nazi army as a volunteer. Sonia is a Russian not Italian name. While spending two years in a Russian jail…

    • 505 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    PMT Who Makes The Journey

    • 253 Words
    • 3 Pages

    “Who Makes the Journey” by Cathy Song In most cases, it is the old woman who makes the journey; the old man having had the sense to stay put and die at home. You see her scurrying behind her newly arrived family. She comes from the Azores and she comes from the Orient. It makes no difference. You have seen her before: the short substantial legs buckle under the weight of the ghost child she carried centuries ago like a bundle of rags who now turns in front of your windshield, transformed in Western…

    • 253 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Who makes the Apple iPhone? BA 3320 – 102 International Business (Tuesday and Thursday 12.30 – 1.45 p.m.) Elyse Vlastuin - A00125261 1. What are the benefits to Apple of outsourcing the assembly of the iPhone to foreign countries, and particularly China? What are the potential costs and risks to China? The benefits to Apple of outsourcing to foreign countries is that labor costs are sometimes lower there, especially in China. Moreover, Chinese subcontractors are able to respond very quickly…

    • 480 Words
    • 2 Pages
    Satisfactory Essays