GCSE ICT Unit 2 Controlled Assessment

Get Started. It's Free
or sign up with your email address
GCSE ICT Unit 2 Controlled Assessment by Mind Map: GCSE ICT Unit 2 Controlled Assessment

1. Modelling

1.1. Spreadsheet

1.1.1. Basic tools

1.1.1.1. Formulas / Functions

1.1.1.1.1. Operators

1.1.1.1.2. SUM

1.1.1.1.3. AVERAGE

1.1.1.1.4. IF

1.1.1.1.5. MAX

1.1.1.1.6. MIN

1.1.1.2. Absolute Cell Refderences

1.1.1.3. Goal Seel

1.1.1.4. Filters

1.1.1.5. Titles

1.1.1.6. Row / Column Headers

1.1.1.7. Linked Sheets

1.1.1.8. Charts / Graphs

1.1.1.8.1. Appropriate Title

1.1.1.8.2. Suitable scale

1.1.1.8.3. Legend / Key

1.1.1.8.4. Colour Scheme

1.1.1.8.5. Correct Type

1.1.1.9. Cell Formatting

1.1.1.9.1. Number

1.1.1.9.2. Currency

1.1.1.9.3. Date

1.1.1.9.4. Conditional Formatting

1.1.2. Advanced tools

1.1.2.1. Scenarios Manager

1.1.2.1.1. https://youtu.be/c0tdVlPvFZ4

1.1.2.2. Lookups

1.1.2.3. Protection

1.1.2.4. Macros

1.1.2.5. Advanced filters

1.1.2.6. Validation

1.2. Analysis

2. Gathering Information

2.1. Internet Search

2.1.1. Advanced Search Techniques

2.1.2. Trustworthyness

2.1.3. Coipyright

2.1.4. Creative Commons

2.2. Database

2.2.1. Queries

2.2.1.1. Sort

2.2.1.2. Search Criteria

2.2.1.3. Wild cards

2.2.2. Reports

2.2.2.1. Layout

2.2.2.2. Grouping

2.2.2.3. Sorting

2.2.3. Froms

3. Developing Digital Products

3.1. Logo

3.2. Video

3.3. Flyer

4. Evaluation