ocr nationals – unit 1 ao5 – spreadsheets. overview of ao5 to create a spreadsheet to calculate...
Post on 31-Dec-2015
215 Views
Preview:
TRANSCRIPT
Success Criteria
Pass
I have created a simple spreadsheet with a small number of calculationsI have used row and column headings in my spreadsheetI have made some changes to the format of the spreadsheetI have made changes to the data in my spreadsheet to obtain different resultsI have printed out my spreadsheet
Merit I have created a spreadsheet displaying accurate figuresI have included at least one function in my spreadsheetI have included a title and appropriate row/column headingsI have used a range of different format options in my spreadsheetI have included formula printouts of my spreadsheetI have used print preview to check that my printouts use suitable page orientation and fit onto one pageI have inserted and deleted row (s) in my spreadsheet
Distinction I have used suitable headers and footers in my printouts
and set other print layout features correctly
Recap of Spreadsheets Spreadsheets are basically designed to perform calculations – as
data and calculations can be set up to model situations They allow data and information to be displayed and managed in
a table format Companies use spreadsheets to calculate results such as totals
and to produce graphs of the results.
Spreadsheet are normally used for:
• Displaying, calculating and managing accounts and other financial information • Performing calculations on data collected in experiments and surveys
• Producing data from which graphs can be drawn for example to calculate the average temperature for a graph of weather data or to solve a mathematical equation
Evidence of: Editing a Spreadsheet to obtain different results
Order number 1001 has changed from £15 to £18
Order number 1006 has been deleted
Order number 1014 has been added
Formatted to two decimal places, and to GB Pound.
Order number. Left aligned
Main Heading size 16 font. Use of fill colour highlights and centred
Fill coloured to make sub-headings stand out
Date and time formatted to UK Date.
Evidence of: Formatting a spreadsheet
Formula calculating Monthly income
Formula calculating amount plus VAT at 1.75%
Formula calculating VAT
Formula showing total Monthly income
Formula calculating profit/loss
Evidence of: Formula Printout
top related