S2 Business

1. S2 Business Unit 2 Admin & It - Spreadsheet Bell Baxter High School Faculty of Technologies S2 Core Business

2. Learning Intentions In this unit you will: • Learn the purpose of a Spreadsheet • The terminology and layouts associated with a Spreadsheet • Learn how use formulae to perform calculations • How to create graphs/charts from spreadsheet information

3. Spreadsheet • A spreadsheet is an electronic package that allows calculations to be carried out through use of formulae • Charts and graphs of information can be created easily • Information can be changed to allow for “what if” situations that can be used in decision making

4. Microsoft Excel • This is the electronic spreadsheet package we will use • It looks like this: • See page 6 of your notes

5. Spreadsheet Terminology • Cells – each cell (little box!) has a unique reference eg A1 this cell is found in column A and Row 1 • Text, Numbers, Formulae – these are the types of information that can be entered into each cell • Cell formats – Cells can be formatted to suit the type of information entered eg date, number, currency

6. Calculations • Calculations are completed by using a formula • These formulae use the cell references NOT the actual numbers in the cells • In the Fruit Sales example below to calculate the “total sales” a formula is used to add cells B2 + B3 + B4

7. Demonstrations • Your teacher (with your help!) will demonstrate how to enter formulae into cells (page 9 in your notes booklet) • All formulae start with the equal symbol: = • Formulae can be used to: • Add + • Subtract - • Multiply * • Divide / • Were you able to help?

8. Try it out! • Open the “Pablo’s” spreadsheet and complete activity 2 and extension activity 2.1 • Remember to save your work in your own space. • Try changing the price of the Margherita Pizza to £12.99 – what happens to the total?

9. Make your Spreadsheet Look Good! • You can enhance a spreadsheet and make it look professional by carrying out the following: • Change font style/size/colour • Wrap column headings • Increase Row/column width • Merge Cells • Insert graphics • Try these out in Activity 3 “Ticketmaster” page 11

10. Creating Graphs/Charts • You can try this in Activity 4 (page 12) • Before you create a graph you must highlight (shade) the information you require in the graph • The information highlighted below would produce a graph of VW Golfs sold each month

11. Example:

12. Extension Work – consolidate your learning! • Try the extension activities 4.2 (page 14/15) • How can you make your graphs/charts look professional? • Try adding colour and/or images • Experiment with different graph styles • Ask your teacher to demonstrate some shortcuts to you Eg: Auto sum, copying formula.