1 / 17

It’s not that I’m so smart , it’s just that I stay with problems longer.

It’s not that I’m so smart , it’s just that I stay with problems longer. - Albert Einstein. Perserverance.

latham
Download Presentation

It’s not that I’m so smart , it’s just that I stay with problems longer.

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. It’s not that I’m so smart, it’s just that I stay with problems longer. - Albert Einstein

  2. Perserverance I've missed more than 9000 shots in my career. I've lost almost 300 games. 26 times, I've been trusted to take the game winning shot and missed. I've failed over and over and over again in my life. And that is why I succeed. Perseverance

  3. Lesson Objectives • Use simple formulae within a spreadsheet. • Use basic functions within a spreadsheet.

  4. Spreadsheet Formulae Use mathematical operations, for example: add, subtract, multiply, divide, indices - / + * You need to be able to use these within a spreadsheet. We did this in Year 7 so it should be easy!

  5. Basic Formulae Always start your formula with an equals sign = To add, subtract, multiply or divide you must use cell references E.g. =A1 + A2, =C2 – D3, =F5*F6

  6. Do some *-/+ work! Complete the worksheet you have been given by writing in the formulae you need to use. Open Task 1.xls from the shared area. (Handout> KS4 > iGCSE > Practical Skills > Year 10 and 11> 14 Spreadsheets > Lesson 1-3 > Task 1 Add the relevant formulae.

  7. Spreadsheets Functions Putting the FUN back in spreadsheets since 1907! =COUNTIF =SUM =MAX =IF =AVERAGE =MIN =LOOKUP =SUMIF How many can you name?

  8. Tasks • You will now be guided through a number of functions by video tutorials. • The videos will ask you to add functions to a spreadsheet and make written notes. • The videos are located in • Dept Share > ICT > Handout > KS4 > iGCSE > Year 10 and 11 > Practical Skills > 14 – Spreadsheets > Lesson 1 - Formulae and Functions > Task 2 Videos

  9. =LOOKUP Where is the data you want to lookup? Where is the table that contains the results? Some functions use more than one piece of data. They are separated with comas. =LOOKUP(E6,Tutors.csv!$A$3:$B$12)

  10. =MAX Which range of cells do you want to compare? =MAX(I6:M6) =MIN(I6:M6)

  11. =SUMIF Which range of cells do you want to compare/use for the sum? What criteria must be met for it to be included? =SUMIF(I6:M6,"<>ABS")

  12. Operators Greater than Less than Greater than or Equal to Less than or Equal to Equal to Not Equal to > < >= <= = <>

  13. =COUNTIF Which range of cells do you want to compare/use for the sum? What criteria must be met for it to be included? =COUNTIF(I6:M6,“=ABS")

  14. ROUND and AVERAGE However…you can use 2 or more formulae in the same cell. This is called a nested formula. To how many decimal places? Which cell do you want to round? Which range of cells should be averaged? =ROUND(A1,0) =AVERAGE(I6:M6)

  15. Nested Formulae =ROUND( A1 ,0) AVERAGE(I6:M6) =

  16. =IF( What test do you want to do? What do you want to check? What is entered if the test is true? What is entered if the test is false? =IF(P6>=$B$3,"Yes","No")

  17. Plenary =COUNTIF =SUM =MAX =IF =AVERAGE =MIN =LOOKUP =SUMIF What do the following functions do?

More Related