Contents

Module 1: Computer awareness

  1. Introduction
  2. Digital information system
    1. Hardware
    2. People
    3. Software
    4. Processes
    5. Data
  3. Computer hardware
    1. Input technology
    2. Computer awareness exercise 1
  4. Storage technology
    1. Primary storage
    2. Secondary storage
    3. Computer awareness exercise 2
  5. Central processing unit
    1. Computer awareness exercise 3
    2. Output technology
    3. Computer awareness exercise 4
    4. Computer awareness exercise 5
    5. Computer awareness exercise 6
  6. Networks
    1. Purpose of a network
    2. Network computers
    3. Backup equipment
    4. Computer awareness exercise 7
  7. Data
    1. Computer awareness exercise 8
    2. Computer awareness exercise 9
    3. Data compression
  8. Computer software
    1. Operating system software
    2. Application software
    3. Utility software
    4. Programming languages
    5. Computer awareness exercise 10
  9. Information processing cycle
    1. Computer awareness exercise 11
    2. Computer awareness project

Module 2: Social and ethical practice in IT

  1. ICT in the workplace
    1. Social and ethical practice in IT exercise 1
  2. Advantages and disadvantages of computer use
    1. Advantages
    2. Disadvantages
    3. Social and ethical practice in IT exercise 2
    4. Social and ethical practice in IT exercise 3
    5. Social and ethical practice in IT exercise 4
  3. How the digital age impacts society
    1. Advantages
    2. Disadvantages
    3. Social and ethical practice in IT exercise 5
  4. Privacy and emotional safety with ICT
    1. Social and ethical practice in IT exercise 6
    2. Social and ethical practice in IT exercise 7
    3. Social and ethical practice in IT exercise 8
  5. Being cybersmart to stay safe
  6. Intellectual property and piracy
    1. Copyright and Creative Commons
    2. Social and ethical practice in IT exercise 9
    3. Social and ethical practice in IT exercise 10
  7. Computer crime
    1. Social and ethical practice in IT exercise 11
  8. Computer errors
    1. Social and ethical practice in IT additional exercise 12
    2. Social and ethical practice in IT project

Module 3: Word processing

  1. Business letters
    1. Word processing exercise 1
  2. Inserting graphs
    1. Word processing exercise 2
  3. Using sections
    1. Word processing exercise 3
  4. Publishing tasks
    1. Word processing exercise 4
  5. More detailed newsletters
    1. Word processing exercise 5
  6. Inserting equations
    1. Word processing exercise 6
  7. Mail merge
    1. Word processing exercise 7
    2. Word processing exercise 8
    3. Word processing project

Module 4: Flash animation

  1. Flash animation
    1. The Flash workspace
    2. The Flash panels
  2. Creating an animation
    1. Flash animation exercise 1
  3. Animating along a path 1
    1. Flash animation exercise 2
  4. Creating a bouncing ball
    1. Flash animation exercise 3
  5. Animating along a path 2
    1. Flash animation exercise 4
  6. Fixed point animations
    1. Flash animation exercise 5
  7. Shape tweening
    1. Flash animation exercise 6
  8. Movie clips
    1. Flash animation exercise 7
  9. Publishing animations
    1. Flash animation exercise 8
    2. Flash animation project

Module 5: Computer graphics

  1. Different types of graphics programs
    1. Bitmapped or pixel-based programs
    2. Object-oriented or vector-based programs
  2. Creating a drawing
    1. Computer graphics exercise 1
  3. Editing objects
    1. Computer graphics exercise 2
  4. Using symbols in designs
    1. Computer graphics exercise 3
  5. Freehand drawing tools
    1. Computer graphics exercise 4
    2. Computer graphics exercise 5
  6. Creating a detailed design
    1. Computer graphics exercise 6
  7. Using text in designs
    1. Computer graphics additional exercise 7

Module 6: Photo editing

  1. Selecting parts of images
    1. Photo editing alternative exercise 1
    2. Photo editing exercise 1
  2. Adjusting image sizes
    1. Photo editing alternative exercise 2
    2. Photo editing exercise 2
  3. Saving files for the web
    1. Photo editing alternative exercise 3
    2. Photo editing exercise 3
  4. Repairing parts of photographs
    1. Photo editing alternative exercise 4
    2. Photo editing exercise 4
    3. Photo editing alternative exercise 5
    4. Photo editing exercise 5
    5. Photo editing alternative exercise 6
    6. Photo editing exercise 6
    7. Photo editing alternative exercise 7
    8. Photo editing exercise 7
    9. Photo editing alternative exercise 8
    10. Photo editing exercise 8
  5. Using filters
    1. Photo editing additional exercise 9
    2. Photo editing additional exercise 10
    3. Photo editing additional exercise 11
    4. Photo editing additional exercise 12
    5. Photo editing project

Module 7: Spreadsheets

  1. Reviewing spreadsheets
  2. Working with multiple worksheets
    1. Spreadsheets exercise 1
    2. Spreadsheets exercise 2
  3. Working with lists – sorting
    1. Spreadsheets exercise 3
    2. Spreadsheets exercise 4
  4. Using the subtotal
    1. Spreadsheets exercise 5
  5. Filtering
    1. Spreadsheets exercise 6
  6. Functions
    1. Statistical functions
    2. Spreadsheets exercise 7
    3. Using functions on non-adjacent cells
    4. Spreadsheets exercise 8
    5. Date and Time functions
    6. Spreadsheets additional exercise 8a
  7. Logical functions
    1. The IF function
    2. Spreadsheets exercise 9
    3. Spreadsheets exercise 10
    4. Spreadsheets exercise 11
    5. Nesting IF functions
    6. Spreadsheets exercise 12
  8. The CHOOSE function
    1. Spreadsheets exercise 13
    2. Using the CHOOSE function within a formula
    3. Spreadsheets exercise 14
  9. Lookup functions
    1. The VLOOKUP function
    2. Spreadsheets exercise 15
    3. The HLOOKUP function
    4. Additional spreadsheets exercise 15a
  10. Pivot tables
    1. Spreadsheets exercise 16
    2. Spreadsheets exercise 17
    3. Spreadsheets additional exercise 18
    4. Spreadsheets project

Module 8: Databases

  1. Reviewing databases
    1. What is data?
    2. What is information?
  2. What is a database?
    1. Database terms
  3. Creating a database
    1. Databases exercise 1
  4. Calculations in databases
    1. Databases exercise 2
  5. Sorting records
    1. Databases exercise 3
  6. Finding data
    1. Databases exercise 4
  7. Counting data items
    1. Databases exercise 5
  8. Creating a data entry screen
    1. Databases exercise 6
    2. Databases additional exercise 6a
    3. Databases additional exercise 6b
    4. Databases project

Module 9: Webpage authoring

  1. Webpage authoring
  2. Design considerations
    1. Types of graphics
    2. Planning the navigation
  3. Creating a site
    1. Webpage authoring alternative exercise 1
    2. Webpage authoring exercise 1
  4. Inserting text and graphics
    1. Webpage authoring alternative exercise 2
    2. Webpage authoring exercise 2
  5. Using tables
    1. Webpage authoring alternative exercise 3
    2. Webpage authoring exercise 3
  6. Using templates
    1. Webpage authoring alternative exercise 4
    2. Webpage authoring exercise 4
    3. Webpage authoring alternative exercise 5
    4. Webpage authoring exercise 5
    5. Webpage authoring alternative exercise 6
    6. Webpage authoring exercise 6
  7. Setting links
    1. Webpage authoring alternative exercise 7
    2. Webpage authoring exercise 7
  8. Creating forms
    1. Webpage authoring alternative exercise 8
    2. Webpage authoring exercise 8
  9. More detailed page layouts
    1. Webpage authoring alternative exercise 9
    2. Webpage authoring exercise 9
  10. Adaptive and responsive webpages
    1. Webpage authoring exercise 10
    2. Webpage authoring project

Module 10: Desktop publishing

  1. What is desktop publishing?
    1. When to use a desktop publishing program
    2. Planning publications
    3. Design suggestions
    4. Publishing steps
  2. Creating a flyer
    1. Desktop publishing exercise 1
  3. Creating hotel and restaurant menus
    1. Desktop publishing exercise 2
  4. Creating newsletters
    1. Desktop publishing exercise 3
  5. Creating greeting cards
    1. Additional desktop publishing exercise 4
    2. Desktop publishing project

Module 11: Algorithms and programming

  1. Computational thinking
    1. Finding solutions to problems
    2. Algorithms and programming exercise 1
    3. Algorithms outside the classroom
    4. Algorithms and programming exercise 2
    5. Algorithms and programming exercise 3
    6. Flowchart symbols
    7. Algorithms and programming exercise 4
    8. Algorithms and programming exercise 5
    9. Algorithms and programming exercise 6
  2. Types of algorithms
  3. Computer programming and coding
  4. Introducing Python
  5. Simple coding in Python
    1. Algorithms and programming exercise 7
    2. Algorithms and programming exercise 8
    3. Algorithms and programming exercise 9
    4. Algorithms and programming exercise 10
    5. Algorithms and programming project