Sample Notes + Written Material For Contents of The Syllabus:

Sample Notes + Written Material For Contents of The Syllabus:

Sample Video Lectures For The Content:

Sample Video Lectures For The Content:

Sample Video Lectures For The Content:

Sample Quizzes For Preparation:

Sample Quizzes For Preparation:

Sample Cheat Sheets:

Sample Cheat Sheets:

Sample Practice Questions/ Practice Exams:

Sample Practice Questions/ Practice Exams:

Sample Practical Support:

Sample Practical Support:

Sample Paper Pattern/ Paper Preparation/ Techniques To Attempt The Paper/ Common Mistakes To Avoid:

Sample Paper Pattern/ Paper Preparation/ Techniques To Attempt The Paper/ Common Mistakes To Avoid:

Sample Mock Exam:

Sample Mock Exam:

Sample Solved Past Paper:

Sample Solved Past Paper:

Sample Past Paper Session:

Sample Past Paper Session:

Data And Information: Differences Between Data And Information

Data And Information: Uses Of Direct And Indirect Data And Their Suitability For Given Purposes

Data And Information: Sources Of Direct Data

Data And Information: Sources Of Indirect Data

Data And Information: Advantages And Disadvantages Of Direct And Indirect Data

Quality Of Information: Factors That Affect The Quality Of Information

Encryption: The Need For Encryption

Encryption: Methods Of Encryption

Encryption: Encryption Protocols

Encryption: Uses Of Encryption

Encryption: Advantages And Disadvantages Of Different Protocols And Methods Of Encryption

Checking The Accuracy Of Data: Methods And Uses Of Validation And Verification

Checking The Accuracy Of Data: The Difference Between Validation And Verification

Checking The Accuracy Of Data: The Need For Both Validation And Verification

Checking The Accuracy Of Data: Advantages And Disadvantages Of Validation And Verification

Data Processing: Methods And Uses Of Batch Processing

Data Processing: Methods And Uses Of Online Processing

Data Processing: Methods And Uses Of Real-Time Processing Systems Where The Output Affects The Input

Data Processing: Write An Algorithm To Show The Steps Involved In Different Methods Of Processing

Data Processing: Advantages And Disadvantages Of Different Methods Of Data Processing

Mainframe Computers And Supercomputers: Characteristics Of Mainframe Computers And Supercomputers

Mainframe Computers And Supercomputers: Uses Of Mainframe Computers

Mainframe Computers And Supercomputers: Uses Of Supercomputers

Mainframe Computers And Supercomputers: Advantages And Disadvantages Of Mainframe Computers And Supercomputers

System Software: Types And Functions Of System Software

System Software: Uses Of System Software

System Software: Advantages And Disadvantages Of Different Types Of System Software

Utility Software: Need for Utility Software

Utility Software: Types of Utility Software

Utility Software: Uses of the Different Types of Utility Software

Utility Software: Advantages and Disadvantages of Different Types of Utility Software

Custom-Written Software and Off-The-Shelf Software: Custom-Written Software

Custom-Written Software and Off-The-Shelf Software: Off-The-Shelf Software

Custom-Written Software and Off-The-Shelf Software: Advantages and Disadvantages of Different Types of Custom-Written and Off-The-Shelf Software

Custom-Written Software and Off-The-Shelf Software: Proprietary and Open-Source Software

User Interfaces: Types of User Interfaces

User Interfaces: Uses of the Different Types of User Interfaces

User Interfaces: Advantages and Disadvantages of Different Types of User Interface

Monitoring And Measurement Technologies: Sensors

Monitoring And Measurement Technologies: Uses Of Monitoring And Measurement Technologies

Monitoring And Measurement Technologies: Calibration

Control Technologies: Sensors And Their Uses

Control Technologies: Actuators And Their Uses

Control Technologies: Microprocessor-controlled/computer-controlled Technology

Control Technologies: Advantages And Disadvantages Of Different Control Technologies

Control Technologies: Write An Algorithm Or Draw A Flowchart To Represent The Processing Involved In The Control Technologies

Algorithms: Writing And Editing A Given Algorithm That Demonstrates A Decision-making Process

Algorithms: Writing An Algorithm Using Pseudocode To Solve A Given Problem

Flowcharts: Drawing A Basic Program Flowchart To Solve A Given Problem

Flowcharts: Drawing A Basic Program Flowchart That Demonstrates A Decision-making Process

Flowcharts: Editing A Given Basic Program Flowchart That Demonstrates A Decision-making Process

Flowcharts: Identifying Errors In An Algorithm/program Flowchart For A Given Scenario

Personal Data: What Personal Data Is

Personal Data: Keeping Personal Data Secure And Confidential

Personal Data: Preventing Misuse Of Personal Data

Personal Data: Advantages And Disadvantages Of The Different Methods Of Preventing Misuse Of Personal Data

Malware: Types Of Malware

Malware: Uses Of Malware

Malware: Consequences Of Malware For Organisations And Individuals

Malware: Malware Prevention Software And Physical Malware Prevention Methods

Malware: Advantages And Disadvantages Of The Methods Of Malware Prevention

The Digital Divide: What The Digital Divide Is

The Digital Divide: Causes Of The Digital Divide

The Digital Divide: Effects Of The Digital Divide

The Digital Divide: Groups Affected By The Digital Divide

Expert Systems: How Expert Systems Are Used To Produce Possible Solutions For Different Scenarios

Expert Systems: Components

Expert Systems: Scenarios

Expert Systems: The Concepts Of Backward Chaining And Forward Chaining, Including The Use Of The If…then Constructs

Expert Systems: The Terms Data Driven And Goal Driven

Expert Systems: Advantages And Disadvantages Of Expert Systems

Creating A Spreadsheet: Creating Page/screen Structures To Meet The Requirements Of An Audience And/or Task Specification/ House Style

Creating A Spreadsheet: Creating/editing Spreadsheet Structures

Creating A Spreadsheet: Controlling Data Input Using Validation Techniques

Creating A Spreadsheet: Protecting Cells And Their Content

Creating A Spreadsheet: Freezing And Unfreezing Panes And Windows

Creating A Spreadsheet: Creating And Using Formulas

Creating A Spreadsheet: Using Absolute, Relative And Mixed Referencing To Replicate Formulas

Creating A Spreadsheet: Understanding Why Absolute, Relative And Mixed Referencing Are Used

Creating A Spreadsheet: Using Functions

Creating A Spreadsheet: Using Appropriate Input And Error Messages

Creating A Spreadsheet: Formatting Cells

Creating A Spreadsheet: Formatting Cell Emphasis

Creating A Spreadsheet: Appreciation Of The Spreadsheet Requirements, Purpose And Use For A Variety Of Audiences

Testing A Spreadsheet: Testing A Spreadsheet Structure

Testing A Spreadsheet: Testing Data

Using A Spreadsheet: Extracting Data

Using A Spreadsheet: Sorting Data

Using A Spreadsheet: Summarising And Displaying Data

Using A Spreadsheet: Importing And Exporting Data

Graphs And Charts: Creating A Graph Or Chart Appropriate To A Specific Purpose

Graphs And Charts: Apply Chart Formatting

Modelling And Simulations: What-if Analysis

Modelling And Simulations: The Characteristics Of Modelling Software

Modelling And Simulations: The Need For Computer Models

Modelling And Simulations: The Effectiveness Of Spreadsheet Models

Modelling And Simulations: The Use Of A Model To Create And Run Simulations

Creating a database: Assigning A Data Type And An Appropriate Field Size To A Field

Creating a database: The Three Relationships: One-to-one, One-to-many And Many-to-many

Creating a database: The Function Of Key Fields

Creating a database: Referential Integrity And Its Importance

Creating a database: The Difference Between A Flat File And A Relational Database And Why One Might Be More Appropriate

Creating a database: Creating And Using Relationships

Creating a database: Creating And Interpreting An Entity Relationship Diagram (Erd)

Creating a database: Creating A Relational Database

Creating a database: Setting Key Fields

Creating a database: Validate And Verify Data Entry

Creating a database: Selecting Appropriate Query Types

Creating a database: Performing Searches

Creating a database: Performing Calculations With Arithmetic Operations And Numeric And Logical Functions

Creating a database: Sorting Data

Creating a database: Designing And Creating An Appropriate Data Entry Form

Creating a database: Designing, Creating And Editing A Database Report

Creating a database: Designing And Creating A Switchboard/menu Within A Database

Creating a database: Importing Data

Creating a database: Exporting Data

Normalisation To Third Normal Form (3nf): The Characteristics Of Data

Normalisation To Third Normal Form (3nf): The Normalisation Of Data Including The Advantages And Disadvantages

Normalisation To Third Normal Form (3nf): Normalise A Database

Data Dictionary: Identifying Different Data Types

Data Dictionary: Components Of A Data Dictionary

Data Dictionary: Creating A Data Dictionary And Selecting Appropriate Data Types For A Given Set Of Data And A Given Situation

File And Data Management: Different File Types And Their Use

File And Data Management: Why Generic File Formats Are Needed

File And Data Management: Proprietary And Open-source File Formats, Including Why Open-source File Formats Are Needed

File And Data Management: Using Indexed Sequential Access

File And Data Management: Using Direct File Access

File And Data Management: Using Database Management Systems

File And Data Management: The Features Of A Management Information System (Mis)

File And Data Management: How A Management Information System (Mis) Can Be Used By Organisations

File And Data Management: Advantages And Disadvantages Of The Different Types Of Database Management Systems

Video Editing: Editing A Video Clip To Meet The Requirements Of Its Intended Application And Audience

Video Editing: The Effects Of Different Methods Of Compression On Video

Video Editing: Why Typical Features Found In Video Editing Software Are Used

Video Editing: Advantages And Disadvantages Of Export File Formats

Audio Editing: Editing An Audio Clip To Meet The Requirements Of Its Intended Application And Audience

Audio Editing: How And Why Typical Features Found In Audio Editing Software Are Used

Audio Editing: Advantages And Disadvantages Of Export File Formats

Audio Editing: Why File Sizes Depend On Sampling Rate And Sampling Resolution

Audio Editing: The Effects Of Different Methods Of Compression On Audio

Data And Information: Differences Between Data And Information

Data And Information: Uses Of Direct And Indirect Data And Their Suitability For Given Purposes

Data And Information: Sources Of Direct Data

Data And Information: Sources Of Indirect Data

Data And Information: Advantages And Disadvantages Of Direct And Indirect Data

Quality Of Information: Factors That Affect The Quality Of Information

Encryption: The Need For Encryption

Encryption: Methods Of Encryption

Encryption: Encryption Protocols

Encryption: Uses Of Encryption

Encryption: Advantages And Disadvantages Of Different Protocols And Methods Of Encryption

Checking The Accuracy Of Data: Methods And Uses Of Validation And Verification

Checking The Accuracy Of Data: The Difference Between Validation And Verification

Checking The Accuracy Of Data: The Need For Both Validation And Verification

Checking The Accuracy Of Data: Advantages And Disadvantages Of Validation And Verification

Data Processing: Methods And Uses Of Batch Processing

Data Processing: Methods And Uses Of Online Processing

Data Processing: Methods And Uses Of Real-Time Processing Systems Where The Output Affects The Input

Data Processing: Write An Algorithm To Show The Steps Involved In Different Methods Of Processing

Data Processing: Advantages And Disadvantages Of Different Methods Of Data Processing

Mainframe Computers And Supercomputers: Characteristics Of Mainframe Computers And Supercomputers

Mainframe Computers And Supercomputers: Uses Of Mainframe Computers

Mainframe Computers And Supercomputers: Uses Of Supercomputers

Mainframe Computers And Supercomputers: Advantages And Disadvantages Of Mainframe Computers And Supercomputers

System Software: Types And Functions Of System Software

System Software: Uses Of System Software

System Software: Advantages And Disadvantages Of Different Types Of System Software

Utility Software: Need for Utility Software

Utility Software: Types of Utility Software

Utility Software: Uses of the Different Types of Utility Software

Utility Software: Advantages and Disadvantages of Different Types of Utility Software

Custom-Written Software and Off-The-Shelf Software: Custom-Written Software

Custom-Written Software and Off-The-Shelf Software: Off-The-Shelf Software

Custom-Written Software and Off-The-Shelf Software: Advantages and Disadvantages of Different Types of Custom-Written and Off-The-Shelf Software

Custom-Written Software and Off-The-Shelf Software: Proprietary and Open-Source Software

User Interfaces: Types of User Interfaces

User Interfaces: Uses of the Different Types of User Interfaces

User Interfaces: Advantages and Disadvantages of Different Types of User Interface

Monitoring And Measurement Technologies: Sensors

Monitoring And Measurement Technologies: Uses Of Monitoring And Measurement Technologies

Monitoring And Measurement Technologies: Calibration

Control Technologies: Sensors And Their Uses

Control Technologies: Actuators And Their Uses

Control Technologies: Microprocessor-controlled/computer-controlled Technology

Control Technologies: Advantages And Disadvantages Of Different Control Technologies

Control Technologies: Write An Algorithm Or Draw A Flowchart To Represent The Processing Involved In The Control Technologies

Algorithms: Writing And Editing A Given Algorithm That Demonstrates A Decision-making Process

Algorithms: Writing An Algorithm Using Pseudocode To Solve A Given Problem

Flowcharts: Drawing A Basic Program Flowchart To Solve A Given Problem

Flowcharts: Drawing A Basic Program Flowchart That Demonstrates A Decision-making Process

Flowcharts: Editing A Given Basic Program Flowchart That Demonstrates A Decision-making Process

Flowcharts: Identifying Errors In An Algorithm/program Flowchart For A Given Scenario

Personal Data: What Personal Data Is

Personal Data: Keeping Personal Data Secure And Confidential

Personal Data: Preventing Misuse Of Personal Data

Personal Data: Advantages And Disadvantages Of The Different Methods Of Preventing Misuse Of Personal Data

Malware: Types Of Malware

Malware: Uses Of Malware

Malware: Consequences Of Malware For Organisations And Individuals

Malware: Malware Prevention Software And Physical Malware Prevention Methods

Malware: Advantages And Disadvantages Of The Methods Of Malware Prevention

The Digital Divide: What The Digital Divide Is

The Digital Divide: Causes Of The Digital Divide

The Digital Divide: Effects Of The Digital Divide

The Digital Divide: Groups Affected By The Digital Divide

Expert Systems: How Expert Systems Are Used To Produce Possible Solutions For Different Scenarios

Expert Systems: Components

Expert Systems: Scenarios

Expert Systems: The Concepts Of Backward Chaining And Forward Chaining, Including The Use Of The If…then Constructs

Expert Systems: The Terms Data Driven And Goal Driven

Expert Systems: Advantages And Disadvantages Of Expert Systems

Creating A Spreadsheet: Creating Page/screen Structures To Meet The Requirements Of An Audience And/or Task Specification/ House Style

Creating A Spreadsheet: Creating/editing Spreadsheet Structures

Creating A Spreadsheet: Controlling Data Input Using Validation Techniques

Creating A Spreadsheet: Protecting Cells And Their Content

Creating A Spreadsheet: Freezing And Unfreezing Panes And Windows

Creating A Spreadsheet: Creating And Using Formulas

Creating A Spreadsheet: Using Absolute, Relative And Mixed Referencing To Replicate Formulas

Creating A Spreadsheet: Understanding Why Absolute, Relative And Mixed Referencing Are Used

Creating A Spreadsheet: Using Functions

Creating A Spreadsheet: Using Appropriate Input And Error Messages

Creating A Spreadsheet: Formatting Cells

Creating A Spreadsheet: Formatting Cell Emphasis

Creating A Spreadsheet: Appreciation Of The Spreadsheet Requirements, Purpose And Use For A Variety Of Audiences

Testing A Spreadsheet: Testing A Spreadsheet Structure

Testing A Spreadsheet: Testing Data

Using A Spreadsheet: Extracting Data

Using A Spreadsheet: Sorting Data

Using A Spreadsheet: Summarising And Displaying Data

Using A Spreadsheet: Importing And Exporting Data

Graphs And Charts: Creating A Graph Or Chart Appropriate To A Specific Purpose

Graphs And Charts: Apply Chart Formatting

Modelling And Simulations: What-if Analysis

Modelling And Simulations: The Characteristics Of Modelling Software

Modelling And Simulations: The Need For Computer Models

Modelling And Simulations: The Effectiveness Of Spreadsheet Models

Modelling And Simulations: The Use Of A Model To Create And Run Simulations

Creating a database: Assigning A Data Type And An Appropriate Field Size To A Field

Creating a database: The Three Relationships: One-to-one, One-to-many And Many-to-many

Creating a database: The Function Of Key Fields

Creating a database: Referential Integrity And Its Importance

Creating a database: The Difference Between A Flat File And A Relational Database And Why One Might Be More Appropriate

Creating a database: Creating And Using Relationships

Creating a database: Creating And Interpreting An Entity Relationship Diagram (Erd)

Creating a database: Creating A Relational Database

Creating a database: Setting Key Fields

Creating a database: Validate And Verify Data Entry

Creating a database: Selecting Appropriate Query Types

Creating a database: Performing Searches

Creating a database: Performing Calculations With Arithmetic Operations And Numeric And Logical Functions

Creating a database: Sorting Data

Creating a database: Designing And Creating An Appropriate Data Entry Form

Creating a database: Designing, Creating And Editing A Database Report

Creating a database: Designing, Creating And Editing A Database Report

Creating a database: Designing And Creating A Switchboard/menu Within A Database

Creating a database: Importing Data

Creating a database: Exporting Data

Normalisation To Third Normal Form (3nf): The Characteristics Of Data

Normalisation To Third Normal Form (3nf): The Normalisation Of Data Including The Advantages And Disadvantages

Normalisation To Third Normal Form (3nf): Normalise A Database

Data Dictionary: Identifying Different Data Types

Data Dictionary: Components Of A Data Dictionary

Data Dictionary: Creating A Data Dictionary And Selecting Appropriate Data Types For A Given Set Of Data And A Given Situation

File And Data Management: Different File Types And Their Use

File And Data Management: Why Generic File Formats Are Needed

File And Data Management: Proprietary And Open-source File Formats, Including Why Open-source File Formats Are Needed

File And Data Management: Using Indexed Sequential Access

File And Data Management: Using Direct File Access

File And Data Management: Using Database Management Systems

File And Data Management: The Features Of A Management Information System (Mis)

File And Data Management: How A Management Information System (Mis) Can Be Used By Organisations

File And Data Management: Advantages And Disadvantages Of The Different Types Of Database Management Systems

Video Editing: Editing A Video Clip To Meet The Requirements Of Its Intended Application And Audience

Video Editing: The Effects Of Different Methods Of Compression On Video

Video Editing: Why Typical Features Found In Video Editing Software Are Used

Video Editing: Advantages And Disadvantages Of Export File Formats

Audio Editing: Editing An Audio Clip To Meet The Requirements Of Its Intended Application And Audience

Audio Editing: How And Why Typical Features Found In Audio Editing Software Are Used

Audio Editing: Advantages And Disadvantages Of Export File Formats

Audio Editing: Why File Sizes Depend On Sampling Rate And Sampling Resolution

Audio Editing: The Effects Of Different Methods Of Compression On Audio

Spreadsheet 1

Spreadsheet 2

Spreadsheet 2

Spreadsheet 3

Spreadsheet 4

Spreadsheet 5

Spreadsheet 6

Spreadsheet 7

Spreadsheet 8

Spreadsheet 9

Spreadsheet 10

Spreadsheet 11

Spreadsheet 12

Spreadsheet 13

Spreadsheet 14

Spreadsheet 15

Spreadsheet 16

Database 1

Database 2

Database 3

Database 4

Database 5

A2 Level: Data Analysis and Visualization

A2 Level: Mail Merge

A2 Level: Graphics Creation

A2 Level: Graphics Creation (Next)

A2 Level: Vector Graphics

A2 Level: Bitmap Images

A2 Level: Compression

A2 Level: Text

A2 Level: Animation

A2 Level: Programming for the Web

A2 Level: Programming for the Web Continued

Data And Information: Differences Between Data And Information

Data And Information: Uses Of Direct And Indirect Data And Their Suitability For Given Purposes

Data And Information: Sources Of Direct Data

Data And Information: Sources Of Indirect Data

Data And Information: Advantages And Disadvantages Of Direct And Indirect Data

Quality Of Information: Factors That Affect The Quality Of Information

Encryption: The Need For Encryption

Encryption: Methods Of Encryption

Encryption: Encryption Protocols

Encryption: Uses Of Encryption

Encryption: Advantages And Disadvantages Of Different Protocols And Methods Of Encryption

Checking The Accuracy Of Data: Methods And Uses Of Validation And Verification

Checking The Accuracy Of Data: The Difference Between Validation And Verification

Checking The Accuracy Of Data: The Need For Both Validation And Verification

Checking The Accuracy Of Data: Advantages And Disadvantages Of Validation And Verification

Data Processing: Methods And Uses Of Batch Processing

Data Processing: Methods And Uses Of Online Processing

Data Processing: Methods And Uses Of Real-Time Processing Systems Where The Output Affects The Input

Data Processing: Write An Algorithm To Show The Steps Involved In Different Methods Of Processing

Data Processing: Advantages And Disadvantages Of Different Methods Of Data Processing

Mainframe Computers And Supercomputers: Characteristics Of Mainframe Computers And Supercomputers

Mainframe Computers And Supercomputers: Uses Of Mainframe Computers

Mainframe Computers And Supercomputers: Uses Of Supercomputers

Mainframe Computers And Supercomputers: Advantages And Disadvantages Of Mainframe Computers And Supercomputers

System Software: Types And Functions Of System Software

System Software: Uses Of System Software

System Software: Advantages And Disadvantages Of Different Types Of System Software

Utility Software: Need for Utility Software

Utility Software: Types of Utility Software

Utility Software: Uses of the Different Types of Utility Software

Utility Software: Advantages and Disadvantages of Different Types of Utility Software

Custom-Written Software and Off-The-Shelf Software: Custom-Written Software

Custom-Written Software and Off-The-Shelf Software: Off-The-Shelf Software

Custom-Written Software and Off-The-Shelf Software: Advantages and Disadvantages of Different Types of Custom-Written and Off-The-Shelf Software

Custom-Written Software and Off-The-Shelf Software: Proprietary and Open-Source Software

User Interfaces: Types of User Interfaces

User Interfaces: Uses of the Different Types of User Interfaces

User Interfaces: Advantages and Disadvantages of Different Types of User Interface

Monitoring And Measurement Technologies: Sensors

Monitoring And Measurement Technologies: Uses Of Monitoring And Measurement Technologies

Monitoring And Measurement Technologies: Calibration

Control Technologies: Sensors And Their Uses

Control Technologies: Actuators And Their Uses

Control Technologies: Microprocessor-controlled/computer-controlled Technology

Control Technologies: Advantages And Disadvantages Of Different Control Technologies

Control Technologies: Write An Algorithm Or Draw A Flowchart To Represent The Processing Involved In The Control Technologies

Algorithms: Writing And Editing A Given Algorithm That Demonstrates A Decision-making Process

Algorithms: Writing An Algorithm Using Pseudocode To Solve A Given Problem

Flowcharts: Drawing A Basic Program Flowchart To Solve A Given Problem

Flowcharts: Drawing A Basic Program Flowchart That Demonstrates A Decision-making Process

Flowcharts: Editing A Given Basic Program Flowchart That Demonstrates A Decision-making Process

Flowcharts: Identifying Errors In An Algorithm/program Flowchart For A Given Scenario

Personal Data: What Personal Data Is

Personal Data: Keeping Personal Data Secure And Confidential

Personal Data: Preventing Misuse Of Personal Data

Personal Data: Advantages And Disadvantages Of The Different Methods Of Preventing Misuse Of Personal Data

Malware: Types Of Malware

Malware: Uses Of Malware

Malware: Consequences Of Malware For Organisations And Individuals

Malware: Malware Prevention Software And Physical Malware Prevention Methods

Malware: Advantages And Disadvantages Of The Methods Of Malware Prevention

The Digital Divide: What The Digital Divide Is

The Digital Divide: Causes Of The Digital Divide

The Digital Divide: Effects Of The Digital Divide

The Digital Divide: Groups Affected By The Digital Divide

Expert Systems: How Expert Systems Are Used To Produce Possible Solutions For Different Scenarios

Expert Systems: Components

Expert Systems: Scenarios

Expert Systems: The Concepts Of Backward Chaining And Forward Chaining, Including The Use Of The If…then Constructs

Expert Systems: The Terms Data Driven And Goal Driven

Expert Systems: Advantages And Disadvantages Of Expert Systems

Creating A Spreadsheet: Creating Page/screen Structures To Meet The Requirements Of An Audience And/or Task Specification/ House Style

Creating A Spreadsheet: Creating/editing Spreadsheet Structures

Creating A Spreadsheet: Controlling Data Input Using Validation Techniques

Creating A Spreadsheet: Protecting Cells And Their Content

Creating A Spreadsheet: Freezing And Unfreezing Panes And Windows

Creating A Spreadsheet: Creating And Using Formulas

Creating A Spreadsheet: Using Absolute, Relative And Mixed Referencing To Replicate Formulas

Creating A Spreadsheet: Understanding Why Absolute, Relative And Mixed Referencing Are Used

Creating A Spreadsheet: Using Functions

Creating A Spreadsheet: Using Appropriate Input And Error Messages

Creating A Spreadsheet: Formatting Cells

Creating A Spreadsheet: Formatting Cell Emphasis

Creating A Spreadsheet: Appreciation Of The Spreadsheet Requirements, Purpose And Use For A Variety Of Audiences

Testing A Spreadsheet: Testing A Spreadsheet Structure

Testing A Spreadsheet: Testing Data

Using A Spreadsheet: Extracting Data

Using A Spreadsheet: Sorting Data

Using A Spreadsheet: Summarising And Displaying Data

Using A Spreadsheet: Importing And Exporting Data

Graphs And Charts: Creating A Graph Or Chart Appropriate To A Specific Purpose

Graphs And Charts: Apply Chart Formatting

Modelling And Simulations: What-if Analysis

Modelling And Simulations: The Characteristics Of Modelling Software

Modelling And Simulations: The Need For Computer Models

Modelling And Simulations: The Effectiveness Of Spreadsheet Models

Modelling And Simulations: The Use Of A Model To Create And Run Simulations

Creating a database: Assigning A Data Type And An Appropriate Field Size To A Field

Creating a database: The Three Relationships: One-to-one, One-to-many And Many-to-many

Creating a database: The Function Of Key Fields

Creating a database: Referential Integrity And Its Importance

Creating a database: The Difference Between A Flat File And A Relational Database And Why One Might Be More Appropriate

Creating a database: Creating And Using Relationships

Creating a database: Creating And Interpreting An Entity Relationship Diagram (Erd)

Creating a database: Creating A Relational Database

Creating a database: Setting Key Fields

Creating a database: Validate And Verify Data Entry

Creating a database: Selecting Appropriate Query Types

Creating a database: Performing Searches

Creating a database: Performing Calculations With Arithmetic Operations And Numeric And Logical Functions

Creating a database: Sorting Data

Creating a database: Designing And Creating An Appropriate Data Entry Form

Creating a database: Designing, Creating And Editing A Database Report

Creating a database: Designing And Creating A Switchboard/menu Within A Database

Creating a database: Importing Data

Creating a database: Exporting Data

Normalisation To Third Normal Form (3nf): The Characteristics Of Data

Normalisation To Third Normal Form (3nf): The Normalisation Of Data Including The Advantages And Disadvantages

Normalisation To Third Normal Form (3nf): Normalise A Database

Data Dictionary: Identifying Different Data Types

Data Dictionary: Components Of A Data Dictionary

Data Dictionary: Creating A Data Dictionary And Selecting Appropriate Data Types For A Given Set Of Data And A Given Situation

File And Data Management: Different File Types And Their Use

File And Data Management: Why Generic File Formats Are Needed

File And Data Management: Proprietary And Open-source File Formats, Including Why Open-source File Formats Are Needed

File And Data Management: Using Indexed Sequential Access

File And Data Management: Using Direct File Access

File And Data Management: Using Database Management Systems

File And Data Management: The Features Of A Management Information System (Mis)

File And Data Management: How A Management Information System (Mis) Can Be Used By Organisations

File And Data Management: Advantages And Disadvantages Of The Different Types Of Database Management Systems

Video Editing: Editing A Video Clip To Meet The Requirements Of Its Intended Application And Audience

Video Editing: The Effects Of Different Methods Of Compression On Video

Video Editing: Why Typical Features Found In Video Editing Software Are Used

Video Editing: Advantages And Disadvantages Of Export File Formats

Audio Editing: Editing An Audio Clip To Meet The Requirements Of Its Intended Application And Audience

Audio Editing: How And Why Typical Features Found In Audio Editing Software Are Used

Audio Editing: Advantages And Disadvantages Of Export File Formats

Audio Editing: Why File Sizes Depend On Sampling Rate And Sampling Resolution

Audio Editing: The Effects Of Different Methods Of Compression On Audio