s2 business
Download
Skip this Video
Download Presentation
S2 Business

Loading in 2 Seconds...

play fullscreen
1 / 12

S2 Business - PowerPoint PPT Presentation


  • 141 Views
  • Uploaded on

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.

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

PowerPoint Slideshow about ' S2 Business' - cili


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
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.
ad