Full Lesson If Statements and Graph

• Understand the use of absolute cell referencing.
• Understand the use of simple functions (sum,max,min and average) in a spreadsheet.
• Understand the use of If statements including the logical, true and false statements.
• Understand how calculations can be used as True statements
• Understand the use of nested if statements including more than one true statement.
• Understand the use of count and sum if functions.
• Understand the need the need to present data in a graph format.
• Understanding the need to present information in different forms (graphs)

Thanks to our dear colleagues Mr. Yasar Ahmed for his tremendous work for developping reources in ICT and please click the link below where you can find a lot of resources for your ICT subjects from year 7 - 12.