3.2-A range of ICT tools and techniques

3.2.1 Systems life cycle

3.2.2 Working with information to solve problems

3.2.3 Operating systems and user interfaces

3.2.4 Applications software

3.2.5 Word processing, DTP, Web design and other presentation software

3.2.6 Graphics production and image manipulation

3.2.7 Spreadsheets and modelling software

3.2.8 Databases

3.2.9 Web browsing and Email

3.2.10 Web logs and social networking

3.2.11 Data logging and control software


3.2.1 Systems life cycle

Systems life cycle

Systems Life Cycle

Systems life cycle drag and drop


3.2.2 Working with information to solve problems

Are websites trustworthy?

Keywords, Strings, +, OR and - searches

Database

Quality of information

Input Storage Output

Database exercise

Verification and Validation

Accuracy and Plausibility

Spell Check

Spell Check exercise-Now write a paragraph in word explaining the advantages and limitations of a spelling and grammar checker.

Data Collection

Create a questionnaire

RFDI and Biometrics

Reviewing and modifying work

Purpose and audience

Business Documents

VLE


3.2.3 Operating systems and user interfaces

Operating Systems

User Interface

Encoding Data

Folder structure-Copy the folder structure into your own area. 

Task 1. Rename the main folder Folder structure exercise. 

Task 2. Name the sub folders Task 1,2,3,4,5,6  

Task 3. Rename the files Test 1,2,3,4,5,6

Task 4. Move a file to a different folder

Task 5. Copy a file to different folder.

Compression 1

Compression 2


3.2.4 Applications software

Open Source and  Proprietary Software


3.2.5 Word processing, DTP, Web design and other presentation software

See Business documents 3.2.2

Desktop Publishing and Word Processing

Load your PowerPoint from your business documents-Add a master slide, hyperlinks and a video.

Create a webpage using serif web plus for Mornington estate agents.  Ensure you have a master page.  Add a hotspot, rollover, hyperlinks and animation.

Podcast


3.2.6 Graphics production and image manipulation

Add digital imaging task later


3.2.7 Spreadsheets and modelling software

Spreadsheets

IF Functions

Linking Sheets

Count IF

Graphs task

Rank

Look Up


3.2.8 Databases


3.2.9 Web browsing and Email


3.2.10 Web logs and social networking


3.2.11 Data logging and control software