Yasar Ahmad website. Contact me on yahmad.nba@gmail.com
31 42 20131215_0737423 20131215_0737544 20131215_0738235 20131215_0738476 20131215_0740327 20131215_0758408 20131215_0758569
Chapter 20: Data Analysis (Spreadsheets)

Spreadsheets Unit Overview

Youtube Unit Overview:

Part 1

Part 2

Part 3

Part 4

 

Youtube Spreadsheet Exam Examples (2017-2014):

Exam Questions Part 3

Part 1, Part 2

 

1. Intro Tasks

 

1.1 Spreadsheet Task Part 1 (Formulas, Functions, Counts, Sumif, lookups)

1.1 Movie Spreadsheet - For Vlookup

 

1.2 Spreadsheet Task Part 2 (If Statements)

 

1.3 Rounding, Filtering & Graphs

 

1.4 Percentages

 

1.5 Conditional Formatting and Validation

 

1.6 Sort (2)

 

2. Vlookups

2.1 Vlookup Extension Part 2 - (Click for Video Tutorial)

 

2.2 Vlookup Extension - Part3 (Approximate)

 

2.3 Vlookup Extension - Part4 (Left or Right)

 

2.4 Vlookup Extension - Part5 (Mid)

 

2.5 Vlookup Extension - Part 6 (Mid)

 

2.6 Vlookup Extension - Part 7 (Nested IF)

 

2.7 Lookup

 

2.8 Vlookup and IF - Video Tutorial

 

 

3. Nested If Statements

3.1 Nested if Spreadsheet (Intro)

 

3.2 Nested if Sequence True Statements

 

3.3 Spreadsheet Task Part 3 (Exam Examples)

4. Extension Tasks

4.1 Ahmad Holidays

 

4.2 Ski Holidays

 

4.3 Ahmad Travels

 

4.4 MobilePhonesUK

 

4.5 ExchangeRates

 

5. Exam Questions

 

5.1 Exam Questions Part 1

 

5.2 Exam Questions Part 2

 

5.3 Exam Questions Part 3

Video Tutorials: Part 1, Part 2

 

 

 

 

Extension Tasks:

 

Skills Lesson 1:

Excel File

Skills Lesson 2:

Excel File

IF Statements Part 1:

Excel File

IF Statements Part 2:

Excel File

Vlookups:

Excel File

 

Yr 9 Exam

 

 

Video Tutorials

 

1. Counts

 

2. Sum IF

 

3. Average IF

 

4. VLookup

 

5. VLookup Extension

 

6. HLookup

 

7. Lookup

 

8. IF Statement Pt1

 

9. IF Statement Pt2

 

10. Nested IF Pt1

 

11. Nested IF Pt2

 

12. Extracting

(Left, Right & Mid)

 

13. Concatenate Function

 

14. Extracting & Functions

 

15. Sort

 

16. Rounding

 

17. Filtering

 

18. Graphs

 

19. Conditional Formatting

 

20. Validation