1 / 21

Spreadsheets - Starter

Spreadsheets - Starter. ?. What was the name of the first spreadsheet program?. google.co.uk. dogpile.co.uk. wikipedia.org. ask.com. Bing.com. wikipedia.org. Spreadsheets. Answer. ?. First spreadsheet:. VisiCalc. “VisiCalc was the first spreadsheet program available for PC.”

paley
Download Presentation

Spreadsheets - Starter

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Spreadsheets - Starter ? What was the name of the first spreadsheet program? google.co.uk dogpile.co.uk wikipedia.org ask.com Bing.com

  2. wikipedia.org Spreadsheets Answer ? First spreadsheet: VisiCalc “VisiCalc was the first spreadsheet program available for PC.” “…application that turned the microcomputer from a hobby for computer enthusiasts into a serious business tool.” “VisiCalc sold over 700,000 copies in six years.”

  3. Spreadsheets This weeks topic is ‘Spreadsheets’ We will be using this to calculate information about different dinosaurs

  4. Objectives and Outcomes • Learning Objectives: • Learning Outcome:• Recognise and use cell references • Use the fill handle • Create and use simple formulae• Apply formatting to a spreadsheet • Be able to state an example formula

  5. A spreadsheet is 'software' which consists of a grid which can contain 'text', 'numbers' and 'formulae'. Spreadsheets can be used for making models, predicting and producing graphs. In school we use 'Excel' What is a Spreadsheet?

  6. Worksheet A page made up of ROWS Cells Columns

  7. Cell Reference Each cell has a name from the COLUMN and the ROW it is in. A1

  8. Adding Data Each cell can contain text, numbers (or a formula - which you don’t see)

  9. Today’s Task Open the Spreadsheet from the ICT SoW Complete Tasks 1 and 2 ONLY Hands on head when finished

  10. Fill Handle Click and drag to transfer a formula into other cells. What about patterns though?!

  11. Fill Handle Sometimes you will have to show Excel the pattern by highlighting 2 or 3 first

  12. Today’s Task Go back to the spreadsheet Nowcomplete sheets/tasks 3 ONLY Hands on head when finished

  13. Formatting Change font style Fill cell colour Format border Text colour

  14. Formatting Undo/Redo Sort Merge/Unmerge cells Changing cell values Charts

  15. More Buttons Change font size Format text Alignment

  16. Today’s Tasks Go back to the spreadsheet Nowcomplete sheet/task 4 Hands on head when finished

  17. Formulas All formula must start with = To add something, use + To subtract something, use - To multiply something, use * To divide something, use /

  18. Today’s Tasks Go back to the spreadsheet Nowcomplete sheet/task 5 Once you have completed task 5 SAVE the SPREADSHEET in your year 7 ICT folder Call it – Zoo Spreadsheet

  19. Today’s Tasks Continued You now need to link your spreadsheet to your powerpoint Follow along with the video tutorial on the ICT SoW

  20. Plenary • What do the following keywords mean? • Worksheet • Cell • Row • Column • Fill Handle

  21. Levels • Level 5 - Pupils will be able to identify features of a spreadsheet such as cell reference, value and variable. They will be able to edit the formula and change the look of the spreadsheet. • Level 4 - Pupils will be able to identify features of a spreadsheet such as cell, data, column, data, formula, label. They will be able to complete the spreadsheet using the formula. • Level 3 - Pupils will need support with using formulae and using the fill handle. They may be able to name some of the features of the spreadsheet.

More Related