Wk1L2-Presenting Data in Spreadsheets.pptx

Data in spreasheet

1. What you learnt in the last lesson Meaning of data model Reasons for using data models Common parts of spreadsheet Enter data into a spreadsheet with 100% accuracy Creating and editing a simple data model A bit of formatting: diagonal, save, delete, merge, show formulae Homework due

2. Spreadsheets PRESENTING DATA

3. Starter Determine what the following functions do in MS Excel by carrying out these. Ensure you press ENTER after each case =BASE(29,2) =LCM(24,9,18) =TODAY()

4. Learning objectives- At the end of this lesson, you should be able to: Describe formula and function and explain the difference between them Show some measure of understanding between relative reference and absolute reference Describe what a named range is and perform a named range

5. Introductory Activity Load a spreadsheet on your computer Content of a spreadsheet can be any of 3 things. What are they ? Practical on relative and absolute referencing Named range Inserting Candidate details in the header/footer (Normal, Page, Page break layouts) Fill color Cell border Wrapping text Formatting cell alignment Adjusting orientation for printing and showing value/formula

6. Class Task IGCSE ICT SPECIMEN PAPER 2020, QP3, Task 1, Task 2 Bullet Points 1-15 Source files on Google Classroom

7. Extension Task IGCSCE ICT 0983, OCT/Nov 2022, QP03 Task 1 Task 2, 1,8,9 Source files on Google Classroom

8. Evaluation/Plenary Teacher summarizes lesson