Computer Applications 2

This Computer Applications 2 module will provide learners with the knowledge and skills needed to thrive in the modern data-driven business environment. The module will enhance learner’s ability to manipulate and retrieve data easily and effectively.

Computer Applications

Spreadsheet Functions

• Creating Spreadsheets
• Working with Spreadsheets
• Saving Spreadsheets
• Understanding Cells
• Inserting, Selecting, and Editing Data
• Copying, Moving and Deleting Data
• Understanding Worksheets
• Using Cell References and Arithmetic Operators
• Good Practice in Formula Creation
• Using Functions

Formatting Spreadsheets

• Managing Rows and Columns
• Modifying Widths and Heights
• Formatting Numbers
• Changing cell content appearance
• Formatting cell content or background
• Copying cell formatting
• Alignment and Border Effects
• Creating and Editing Charts
• Preparing Outputs and Printing

Creating Databases

• Understanding key database concepts
• Designing and structuring databases
• Creating, saving and relating databases
• Working with tables
• Populating new databases
• Designating primary key
• Importing and exporting in various formats

Working with Databases

• Creating database queries
• Querying databases and retrieving data that matches multiple criteria
• Implementing forms
• Applying input masks
• Manipulating and editing database contents
• Cataloguing, organising, and filtering database contents
• Generating Reports
• Understanding how databases function in conjunction with other software