S2 business
This presentation is the property of its rightful owner.
Sponsored Links
1 / 12

S2 Business PowerPoint PPT Presentation


  • 101 Views
  • Uploaded on
  • Presentation posted in: General

S2 Business. Unit 2 Admin & 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.

Download Presentation

S2 Business

An Image/Link below is provided (as is) to download presentation

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


S2 business

S2 Business

Unit 2

Admin & It - Spreadsheet

Bell Baxter High School

Faculty of Technologies S2 Core Business


Learning intentions

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


Spreadsheet

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


Microsoft excel

Microsoft Excel

  • This is the electronic spreadsheet package we will use

  • It looks like this:

  • See page 6 of your notes


Spreadsheet terminology

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


Calculations

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

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?


Try it out

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?


Make your spreadsheet look good

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


Creating graphs charts

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


Example

Example:


Extension work consolidate your learning

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.


  • Login