Wk1L1-Creating and Editing a Data Model.pptx

Introduction to spreadsheet

1. Spreadsheets Creating and editing data model

2. Starter-Identify the labelled parts of the spreadsheet Tab Cell Sheet Column Range/array Row Graph/chart

3. Learning objectives- At the end of this lesson, you should be able to: Describe a data model and explain why it is used Create and edit a simple data model E nter data into a spreadsheet with 100% accuracy

4. Introductory Activity Students are asked to explain the importance of accurate data entry in spreadsheets Students are asked to demonstrate practically how to carry out the following in a spreadsheet : inserting cells deleting cells Cut, copy, paste data inserting rows deleting rows inserting columns deleting columns Merge cells Expand row or column to accommodate data manually/automatically One click to select all cells Adding diagonal line in a cell How to save CSV in MS Excel (using project.csv file) Show formula/value

5. Class Task Download the spreadsheet file Data Model from the channel and open Insert a new row before the current row 1 Merge cells A-E of the new row Enter the text, “Students Performance” centralized and Calibri, 24pt Delete column C Enter the name Kanzi Amzi in cell B6 Enter the score 55 in D4 Change any of the scores to numbers below 80 or above 79. What do you notice about the grades in column E?

6. Extension Task Can you think of modelling in the following industries? Medicine Car manufacturing

7. Homework LOOKUP VLOOKUP XLOOKUP HLOOKUP INT ROUND COUNT IF Write short notes about the following functions against next lesson