Software Skills

Worked examples (9)

• 1Identify the word-processing feature for each goal
• 2Classify the level of formatting
• 3Identify mail-merge components
• 4Calculate document layout figures
• 5Calculate mail-merge output and time saved
• 6Calculate proportional image resizing
• 7Produce a professional, fit-for-purpose report
• 8Describe the full mail-merge process
• 9Evaluate using styles vs manual formatting

Worked examples (9)

• 1Identify the database object/feature
• 2Choose the data type for each field
• 3Identify the validation check for each rule
• 4Predict the records a query returns
• 5Determine sorted query output
• 6Calculate database storage size
• 7Design a database for a small library
• 8Compare a flat file with a relational database
• 9Build a query and report to answer a question

Worked examples (9)

• 1Identify the function for each task
• 2Classify the cell reference type
• 3Choose the right chart for each purpose
• 4Calculate the results of formulae
• 5Calculate results when copying with absolute references
• 6Evaluate a nested IF (grade boundaries)
• 7Build a budget model with what-if analysis
• 8Use VLOOKUP to build a pricing system
• 9Decide between a spreadsheet and a database

Worked examples (9)

• 1Identify the web element/technology
• 2Identify the purpose of each HTML tag
• 3Identify the CSS property for each effect
• 4Calculate page load time
• 5Calculate the impact of optimising images
• 6Calculate links in a navigation structure
• 7Plan and build a small website
• 8Compare WYSIWYG editors with hand-coding
• 9Design for accessibility and usability

Worked examples (9)

• 1Identify the presentation feature
• 2Classify as transition or animation
• 3Identify the slide-design fault
• 4Calculate presentation timing
• 5Calculate presentation file size
• 6Calculate effort saved by using a master slide
• 7Design an effective presentation
• 8Explain the benefits of master slides and templates
• 9Adapt a presentation for different audiences

Worked examples (9)

• 1Classify each image as bitmap or vector
• 2Choose the best image format
• 3Identify the editing tool/feature
• 4Calculate proportional resizing
• 5Calculate bitmap file size from resolution and colour depth
• 6Calculate colours from colour depth
• 7Plan an image edit for a poster
• 8Explain bitmap vs vector for a branding project
• 9Choose formats and compression for a website gallery

Worked examples (9)

• 1Identify the file type from its extension
• 2Order storage units by size
• 3Identify the file-management practice
• 4Calculate how many files fit on a drive
• 5Calculate backup transfer time
• 6Calculate compression savings
• 7Design a folder structure and naming system
• 8Design a backup strategy
• 9Compare local and cloud file storage