|
|
|
|
|
|
IGCSE: ICT (Information & Communication Technology) |
|
|
IGCSE: ICT (Information & Communication Technology) |
|
Section 13 : Output Data |
|
|
Section 14 : Data Analysis |
|
|
|
|
|
| |
|
|
|
|
| |
COMING SOON |
|
|
Contents: |
| |
|
|
|
1. Introduction to Cambridge IGCSE Information and Communication |
| |
|
|
|
Technology 0417 |
| |
|
|
|
2. Introduction to OCR Certificate/Diploma for IT Users (CLAiT) |
| |
|
|
|
3. Introduction to Cambridge International Diploma ICT Starters |
| |
|
|
|
4. Spreadsheets
|
| |
|
|
|
4.1 What is a spreadsheet?
|
| |
|
|
|
4.2 What are Spreadsheets used for?
|
| |
|
|
|
4.3 What can Spreadsheets do? |
| |
|
|
|
5. Who uses spreadsheets? |
| |
|
|
|
5.1 Accountants |
| |
|
|
|
5.2 Teachers |
| |
|
|
|
5.3 Engineers |
| |
|
|
|
5.4 Sales people |
| |
|
|
|
5.5 Scientists |
| |
|
|
|
5.6 Supermarkets |
| |
|
|
|
5.7 Market researchers |
| |
|
|
|
6. Spreadsheet Modelling |
| |
|
|
|
6.1 Model |
| |
|
|
|
6.2 Definition of Modelling |
| |
|
|
|
6.3 Spreadsheet Modelling |
| |
|
|
|
6.4 Why do spreadsheets make good models? |
| |
|
|
|
6.5 Features of Spreadsheets Modelling |
| |
|
|
|
6.5.1 Formulae Charts |
| |
|
|
|
6.5.2 Goal Seek Tool |
| |
|
|
|
6.5.3 Graphs and Charts |
| |
|
|
|
6.5.4 Regression Analysis |
| |
|
|
|
6.6 Financial Modelling Chancellor |
| |
|
|
|
7. Computer Models |
| |
|
|
|
7.1 Weather Models |
| |
|
|
|
7.2 Civil Engineering Models / buildings / engineering / architectural |
| |
|
|
|
7.2.1 Bridge Design Models |
| |
|
|
|
7.2.2 Building a new Sky Scraper Models |
| |
|
|
|
7.2.3 Rollercoaster Design / Fairground Rides Models |
| |
|
|
|
7.2.4 Nuclear Reactions Models |
| |
|
|
|
7.2.5 Fire Simulation Models |
| |
|
|
|
7.2.6 Car Crash Models |
| |
|
|
|
7.2.7 Flight Simulation Models |
| |
|
|
|
7.2.8 Pilot Training Models |
| |
|
|
|
7.2.9 Flight Traffic Control Models |
| |
|
|
|
7.2.10 Scientific Models |
| |
|
|
|
7.2.11 Large Scale Chemical Experiments / Reactions Models |
| |
|
|
|
7.2.12 Drug Trials Model |
| |
|
|
|
7.2.13 Mathematical Models |
| |
|
|
|
7.2.14 Global Warming Models |
| |
|
|
|
7.2.15 Economic Models |
| |
|
|
|
7.2.16 Population Growth Models |
| |
|
|
|
7.2.17 Earthquake Models |
| |
|
|
|
7.2.18 Space Exploration Models |
| |
|
|
|
7.3 Why are Computer Models used instead of Real things? |
| |
|
|
|
8. Simulations |
| |
|
|
|
9. Advantages and Disadvantages of Modeling and Simulation |
| |
|
|
|
10. Introduction to Microsoft Excel 2010 Application Software |
| |
|
|
|
10.1 What is Microsoft Excel 2010? |
| |
|
|
|
10.2 How to open Microsoft Excel 2010? |
| |
|
|
|
10.3 The Quick Access Toolbar |
| |
|
|
|
10.4 The Title Bar |
| |
|
|
|
10.5 The Ribbon |
| |
|
|
|
10.6 What are Worksheets? |
| |
|
|
|
10.7 What are Cells? |
| |
|
|
|
10.8 Moving around a Worksheet |
| |
|
|
|
10.9 Entering Data in Excel |
| |
|
|
|
10.10 Deleting Data in Excel |
| |
|
|
|
10.11 Making Changes / Edit Data |
| |
|
|
|
10.12 Editing through Formula Bar |
| |
|
|
|
10.13 Saving a File |
| |
|
|
|
10.14 Exiting Excel |
| |
|
|
|
10.15 Developer Tab |
| |
|
|
|
11. Using Formulae / Rules in Microsoft Excel 2010 Application Software |
| |
|
|
|
11.1 Type-in Method |
| |
|
|
|
11.2 Point Method |
| |
|
|
|
11.3 Function Method |
| |
|
|
|
11.4 Arrow Key and Anchor Method |
| |
|
|
|
11.5 Mouse Method |
| |
|
|
|
11.6 AutoSum METHOD - S |
| |
|
|
|
11.7 Subtraction |
| |
|
|
|
11.8 Division |
| |
|
|
|
11.9 Multiplication |
| |
|
|
|
11.10 Test Data |
| |
|
|
|
11.11 Absolute References |
| |
|
|
|
11.12 Relative References |
| |
|
|
|
12. Using Functions in Microsoft Excel 2010 Application Software |
| |
|
|
|
12.1 Lookup and Reference |
| |
|
|
|
12.1.1 MATCH |
| |
|
|
|
12.1.2 VLOOKUP |
| |
|
|
|
12.1.3 HLOOKUP |
| |
|
|
|
12.2 Math and Trigonometry Functions |
| |
|
|
|
12.2.1 LOG |
| |
|
|
|
12.2.2 SUM |
| |
|
|
|
12.2.3 ROUND |
| |
|
|
|
12.2.4 ROUNDDOWN |
| |
|
|
|
12.2.5 ROUNDUP |
| |
|
|
|
12.2.6 SUMIF |
| |
|
|
|
12.3 Logical Functions |
| |
|
|
|
12.3.1 IF |
| |
|
|
|
12.3.2 True |
| |
|
|
|
12.3.3 False |
| |
|
|
|
12.4 Statistical Functions |
| |
|
|
|
12.4.1 MAX |
| |
|
|
|
12.4.2 MIN |
| |
|
|
|
12.4.3 AVERAGE |
| |
|
|
|
12.4.4 COUNT |
| |
|
|
|
12.4.5 COUNTIF |
| |
|
|
|
13. Creating Charts & Graphs with Microsoft Excel 2010 Application Software |
| |
|
|
|
13.1 Chart Tools |
| |
|
|
|
13.2 Chart Styles |
| |
|
|
|
13.3 Chart Types |
| |
|
|
|
13.4 Changing Chart Colours |
| |
|
|
|
13.5 Changing Text |
| |
|
|
|
13.6 Changing (Renaming) Excel 2010 Tabs |
| |
|
|
|
13.7 Some Additional Charting |
| |
|
|
|
13.7.1 Sizing your Graph Area |
| |
|
|
|
13.7.2 Legend Area |
| |
|
|
|
13.7.3 Printing Charts |
| |
|
|
|
14. Printing a Spreadsheet |
| |
|
|
|
14.1 Print Preview |
| |
|
|
|
14.2 Printing a Selection |
| |
|
|
|
14.3 Page Layout View |
| |
|
|
|
14.4 Headers and Footers |
| |
|
|
|
15. Microsoft Excel Keyboard Shortcuts |
| |
|
|
|
16. FAQ’s IGCSE ICT 0417/01/02 |
| |
|
|
|
17. Advice on Answering ICT Exam Questions |
| |
|
|
|
17.1 Words used in questions |
| |
|
|
|
17.2 Timing |
| |
|
|
|
18. Grade thresholds for ICT IGCSE |
| |
|
|
|
19. Exercises & Activities |
| |
|
|
|
20. Skills Assessment Booklet |
| |
|
|
|
21. Spreadsheets Word Search Puzzle |
| |
|
|
|
22. Information & Communication Technology – Crossword Puzzle |
| |
|
|
|
23. IGCSE ICT Cambridge University Press 2010 Glossary of Key ICT terms |
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
No. of Pages: 223 |
| |
|
|
|
Syllabus: 2011-13 |
| |
|
|
|
Exam Paper: 0417/01/02/03 |
| |
|
|
|
Key Stages: 2-4 |
| |
|
|
|
Year: 5-11 |
| |
|
|
|
|
| |
|
|
|
This eBook is compatible with the following curriculums: |
| |
|
|
|
(a) IGCSE (Cambridge International General Certificate of Secondary Education) |
| |
|
|
|
ICT (Information and Communication Technology) 0417 |
| |
|
|
|
• Unit 1A An introduction to modelling |
| |
|
|
|
• Unit 3D Exploring Simulations |
| |
|
|
|
• Unit 5D Introduction to spreadsheets |
| |
|
|
|
•Unit 6B Spreadsheet Modelling |
| |
|
|
|
• Unit 7D Models rules and investigations |
| |
|
|
|
(b) GCSE (Cambridge General Certificate of Secondary Education) ICT |
| |
|
|
|
(Information and Communication Technology) 0417 |
| |
|
|
|
(c) Computer Studies |
| |
|
|
|
(d) Computer Literacy and Information Technology (CLAiT) – International |
| |
|
|
|
(e) ICT Starters Modules for Stage 1:
|
| |
|
|
|
• Starting Graphs (4271) |
| |
|
|
|
• Spreadsheets for a Purpose (4291) |
| |
|
|
|
• Exploring Spreadsheets (4280) |
| |
|
|
|
|
| |
|
|
|
| Order your eBook online |
Order a Printed Copy |
| $ 25 |
$ 30 |
|
|
|
| |
|
|
|
|
| |
|
|
|
eBook |
| |
|
|
|
compatible with all latest eDevices
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|