Exam Notes

Graphics

  • Filename Differences:
    • Original image is preserved for reverting or further editing.
    • Version control to maintain an original copy.
  • EVVF:
    • Includes EVVF.

Vector Images for Company Logos

  • Benefits:
    • Scalable without distortion.
    • Detail retention at smaller sizes.
    • Small storage footprint.
  • Drawbacks:
    • Unsuitable for complex graphics.
    • Limited color options.

Vector Image Features

  • Composed of lines, curves, points, and shapes.
  • Lossless quality at any size.
  • Small file size.
  • Based on mathematical equations.
  • Uses coordinates.

Bitmaps for Photographic Images

  • Suitability:
    • Detailed due to high pixel count/resolution.
    • Realistic due to large color depth.

Vector vs. Bitmap for Logos

  • Vector images use coordinates that are recalculated upon resizing, preventing quality loss.

Database

Data Types and Field Sizes

  • Customer Contact Number Data Type:
    • Text/Short Text is most appropriate.
  • Customer Contact Number Field Size:
    • 10/11/12/13/14/15 are appropriate sizes.
  • Foreign Key:
    • Customer ID.

Data Entry Example

  • Customer Table Data:
    • Customer ID: SA1203
    • Customer Name: Samuels
    • Email Address: samuels@fortran.online
    • Preferred Contact Method: Email

Validation Checks on Date Field

  • Type check
  • Presence check
  • Range check
  • Format check

Limit to List for Preferred Contact Method

  • Reasons:
    • Prevents errors by restricting user input to the list (email or mobile).
    • Forces users to select from given choices, preventing new additions.

Loyalty Club Member Field

  • Data Type:
    • Boolean/Logical.

Table Relationships

  • One-to-many.

Validation Checks

  • Ensuring no blank records:
    • Presence check.

Database Search

  • Like "pad" Usage:
    • Returns products with "pad" in their name.

Validation Checks

  • Range check
  • Presence check
  • Type check
  • Length check

Sensible Naming Conventions

  • Reasons:
    • Easy to find when needed.
    • Facilitates use by others.

Database Relationships

  • Reasons:
    • Reduces errors by preventing duplicate records.
    • Minimizes redundant data through linked keys.
    • Saves time by avoiding repeated information entry.
    • Improves accuracy with single-table updates.
    • Enables deletion of specific entries without affecting related data.
    • Maintains data integrity by ensuring foreign key existence in related tables.

Primary Keys

  • Fields:
    • BOOKING ID
    • CLASS ID
    • CLIENT ID
  • Reasons:
    • Uniquely identifies records.
    • Allows for relationship creation.

Lookup Lists

  • Instructor Field in CLASSES Table:
    • Reduces errors by limiting choices.
    • Saves time by providing predefined options.

Lookup Lists

  • Holiday Database fields:
    • Title (Guest table)
    • Number of nights (Booking table)

Lookup List Usage

  • Reduces errors by enabling selection from a given list rather than manual typing.

Post Code Validation

  • Appropriate check:
    • Format check.

Primary Key Usage

  • Uniquely identifies records, preventing duplicates.

Limit to List Property

  • Problems with 'No' Value:
    • Potential for errors due to free-form input.

Logical Operators in Queries

  • For making comparisons within the query.

Linking Tables with Relationships

  • Reasons:
    • Prevent duplicate record entries.
    • Reduce errors.

Separate Tables

  • Splitting information into separate tables is preferable to storing all the information in one table

Referential Integrity

  • Reasons:
    • Data validation, preventing invalid data entry.
    • Protection against accidental record deletion in related tables.
    • Ensuring foreign key existence as a primary key.

Database Search

  • Like "*haus*" Usage:
    • Returns hotels with "haus" in their name.

Spreadsheet

Absolute Referencing

  • Reasons:
    • Formulae/functions can be replicated accurately because cell references do not change.

LEN Function

  • Counts the number of characters in a cell.

Automated Date and Time Field

  • Reasons:
    • Always current due to automatic updates.

Linked Worksheets

  • useful to have linked worksheets in a spreadsheet.

Absolute Referencing

  • Allows cell references to be replicated so that cell references remain static.

Named Ranges

  • Advantages:
    • Stored range details enhance readability.
    • Absolute referencing becomes unnecessary during replication.

Lookup Tables

  • Advantages:
    • Avoidance of repeated values.
    • Centralized editing, reducing errors and ensuring consistency.

PRODUCT Function

  • Function:
    • =PRODUCT(A1,A3,A4)=PRODUCT(A1, A3, A4)
    • Multiplies the content of cells A1, A3, and A4 together.

Named Ranges

  • Reasons:
    • Enhances understanding of cell contents.
    • Prevents errors when copying complicated data.
    • Simplifies referencing in formulas.

Absolute Referencing in Formulas

  • Reasons:
    • Reduces errors during replication by fixing cell references.
    • Enables copying/replication without changing cell references.

Linked Worksheets

  • Benefits:
    • Automatic data updates across sheets.
    • Facilitates data grouping.
    • Reduces information overload on a single page.

Formula Replication

  • Benefits:
    • Reduces errors/saves time by avoiding repetitive typing.

Headers

  • Benefits:
    • Ensures information appears on each sheet without re-entry.

Character Count Function

  • Function:
    • LenLen or lengthlength.

Spreadsheet Feature

  • Named range

Multiple Worksheets

  • Reasons:
    • Prevents clutter.
    • Organizes information.
    • Enhances understanding through structured tables.

Formula Replication

  • Reasons:
    • Saves time/reduces errors through single-entry application.

Presentation

House Style

  • Reasons:
    • Consistent layout.
    • Visual identity/branding.

Notes Section

  • Reasons:
    • Presenter can add additional information.
    • Reduces slide clutter.

Master Slides

  • Reasons:
    • Ensures consistency between slides.
    • Reduces errors.
    • Saves time.
    • Ensures balanced layout.

Placeholders

  • Benefits:
    • Consistency of slides as the placeholders are all pre-formatted.

Master Slides

  • Advantages:
    • Saves time.
    • Ensures consistency.
    • Easily follows house style.

Speaker Notes

  • Reasons:
    • To save including all the information on the slides - would be too much

Master Slides

  • Benefits:
    • Ensures a consistent look for a company portrays a professional look.
    • Quicker to make changes because only the master slide needs to be changed.
    • Quicker to add new slide as all basic formatting has been performed.

Word

Mail Merge

  • Advantages:
    • Saves time.
    • Reduces errors.
    • Improves efficiency and consistency.

Software Facilities for Accuracy

  • Spelling check
  • Grammar check
  • Proofread
  • Thesaurus

Data vs. Information

  • Data are raw facts, whereas information is processed data.

Flyer Weaknesses

  • Appropriate weakness and improvement suggested.

Proofreading

  • Reasons to proofread your work to ensure there are no spelling or grammar errors.

  • Reasons:

    • Ensures correctness/accuracy.
    • Ensures consistency.

Spell Checker

  • Reasons for Identifying Errors:
    • Company names are not in the dictionary.
    • Unrecognized word constructions.

Text Wrap

  • Reasons:
    • Presents text and images neatly
    • Links images to relevant text.
    • Prevents interference with line spacing.

Footers

  • Reasons:
    • Separates additional information from the body text.
    • Adds page numbers for navigation.

Saving Work Regularly

  • Reasons:
    • Prevents data loss.
    • Keeps changes.

Color Choice

  • Reasons:
    • Attracts attention.
    • Can portray style of company.
    • Helps the viewer process the information
    • Can evoke emotions.
    • Suitable color contrast promote accessibility

Mail Merge

  • Benefits:
    • Fewer Errors/Saves Time

Standard Conventions

  • Reasons:
    • consistent layout.
    • More formal/standard
    • ensure all information is included

Sensible Filenames

  • Reasons:
    • easier to find the file later
    • easier for someone else to find the file

Default Filenames

  • Reasons to Change:
    • to make filenames relevant to the content
    • default / blank files are not filled with content
    • supports version control
    • helps user find files

House Style

  • Reasons:
    • provides consistency
    • gives guidance for new contributors
    • gives organisation recognisable identity across documents

Web Page

Formatting Features

  • increased font size or emphasised text (bold) for headings
  • Example response
    • Identifying the Link to Web Page

Alt Text

  • Reasons:
    • Provides context if the image does not display.
    • Accessibility for visually impaired users.
    • Conserves bandwidth for users with limited connections.
    • Provides information when images are not included in the main text.

Templates

  • Advantages:
    • Ensures consistency between pages.
    • Saves time.
    • Easily follows house style.
    • The developer can concentrate on the content / does not have to think about the placement and style.

Website Improvement

  • Candidates need to state an improvement they would make (1) with a suitable justification produced (1)