1 / 12

# S2 Business - PowerPoint PPT Presentation

S2 Business. Unit 2 Admin &amp; It - Spreadsheet. 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.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Unit 2

Bell Baxter High School

Faculty of Technologies S2 Core Business

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
• 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
Microsoft Excel
• This is the electronic spreadsheet package we will use
• It looks like this:
• See page 6 of your notes
• 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
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
Demonstrations
• Your teacher (with your help!) will demonstrate how to enter formulae into cells (page 9 in your notes booklet)
• Formulae can be used to:
• Subtract -
• Multiply *
• Divide /
• Were you able to help?
Try it out!
• Open the “Pablo’s” spreadsheet and complete activity 2 and extension activity 2.1
• Try changing the price of the Margherita Pizza to £12.99 – what happens to the total?
• You can enhance a spreadsheet and make it look professional by carrying out the following:
• Change font style/size/colour
• Increase Row/column width
• Merge Cells
• Insert graphics
• Try these out in Activity 3 “Ticketmaster” page 11
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
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.