Staff Computer Course - Course Outline

Troubleshoot Problems in Microsoft Word, Excel and PowerPoint (CSC307a)

Course Outline:

Microsoft Word 2013

  1. Managing Word Files
    • Convert files to and from the previous version of Word
    • Prepare the Document for Sharing
    • Protect document
    • Recover unsaved document in Word 2013
    • Recover a document when Word shut down unexpectedly
    • Recover information from a damaged document
  2. Formatting
    • Using Quick Cover
    • Using Quick Parts
    • Using Quick Styles
    • Handle page numbering problems
    • Handling spacing problem
    • Enable or Disable AutoCorrect
  3. Miscellaneous
    • Track changes
    • Footnotes
    • Spelling & Grammar
    • Translations with the Mini Translator
  4. Changing Document Default Settings
    • Word Options - General
    • Word Options - Proofing
    • Word Options – Save

Excel 2013

  1. Managing Excel Files
    • Convert files to and from the previous version of Excel
    • Prepare the Workbook for Sharing
    • Protect Workbook
    • Protect worksheet
    • Recover unsaved Workbook in Excel 2013
    • Recover a document when Excel shut down unexpectedly
    • Share workbook
    • Recover information from a damaged document
  2. Formatting
    • Format numbers as text   
    • Convert numbers stored as text to numbers
    • Display leading zero
    • Format as Table 
    • Conditional Formatting and Data Visualization
  3. Data Editing
    • Handling wrong cell reference after move or copy
    • What to do when the Find and Replace commands do not find data
  4. Changing Default Settings
    • Change the default Currency and Date Format
    • Change View settings
    • Install Excel Data  Analysis ToolPak
  5. Functions
    • Enable Developer tab to record Macro or writing VBA
    • Check Errors in formulas

PowerPoint 2013

  1. Managing a PowerPoint Files
    • Convert files to and from the previous version of PowerPoint
    • Prepare the Presentation file for Sharing
    • Protect Presentation files
    • Recover unsaved Presentation file in PowerPoint 2013
    • Recover a document when PowerPoint shut down unexpectedly
    • Recover information from a damaged document
    • Manage presentation section
  2. Formatting a Presentation Files
    • Theme design
    • SmartArt
  3. Miscellaneous
    • Create & Change Hyperlink in presentation
    • Handle graphics displayed as red “X” in presentation
    • Advanced Animation
    • Video Maker
    • Open Word document in PowerPoint

Duration: One day

Pre-requisite(s): Participants should have a sound working knowledge of MS Office 2013


Wireless LAN Access Services for CityU Members (CSC412)

Course Outline:

  1. Introduction to Wireless
    • What is Wireless LAN (WLAN)
    • CityU WLAN Service
    • Eduroam
    • Wi-Fi at PCCW/Y5Zone hot spots
  2. Wireless LAN Compliance
    • IEEE 802.11a
    • IEEE 802.11b
    • IEEE 802.11g
    • Comparsion chart
  3. Secure connection vs insecure connection
    • What is Wireless LAN Security ?
    • Wireless LAN Security modes
    • How to switch/select and set default WLAN networks
  4. Setting up your device to access Wireless LAN
    • Laptop with Windows 7
    • Special alert in the credential caching problem while using Windows 7with WPA
    • Laptop with Windows Vista
  5. How to identify locations that offer free Wi-Fi access to CityU members
    • CityU WLAN Coverage
    • EduroamCoverage
    • Identify locations that offer Wi-Fi access to City U members

Duration: 3 hours


Chinese Input Method - Chang Jie (CSC703)

Date: 29 Nov 2017 (Wed)
Time: 14:15 p.m. - 17:15 p.m
Venue: AC2- 5506

中文輸入法日漸普及,而倉頡輸入法是其中最快速的中文輸入法之一。

修畢此課程,學員應能掌握以下之運用︰

  • 如何輸入中文字
  • 運用倉頡輸入法在不同的軟件之上輸入中文字
  • 重點題目

      1. 倉頡字母
        • 如何輸入中文字
        • 倉頡字母
      2. 哲理類
      3. 取碼原則(一)
        • 取碼順序
        • 取碼數目(連體字)
        • 組合字
      4. 筆劃類
      5. 人身類
      6. 字形類
      7. 取碼原則 (二)
        • 精簡原則
        • 完整原則
        • 字型特徵
        • 包含省略
      8. 連體字
      9. 複合字
      10. 難字
      11. 特殊字

      就讀資格:

      學員需具有 Windows的基本認識

      課程長度:3小時 (每節3小時)


      Chinese Input Method - Q9 2002 (CSC704)

      九方中文輸入法解決了電腦及其他小型介面的使用中文輸入法瓶頸,全面解決了中文輸入法的間題,令中文輸入法既簡單又快捷。

      課程內容

      1. 課程內容
      2. 九方輸入法系統
      3. 筆劃輸入規則
      4. 拼音輸入規則
      5. 字形輸入規則
      6. 九方系統輔助功能

      講授時間:半天

      參加資格:


      Microsoft Expression Web 4 - Introduction (CSC511)

      Date: 12 Apr 2017 (Wed)
      Time: 9:30 a.m. - 5:15 p.m.
      Venue: AC2-5506

      Course Outline:

      1. Introduction to Expression Web 4
        • About Expression Web
        • Understand the interface
        • Preview pages in a browser
      2. Working with Sites
        • Creating new site
        • Import or Export Files
      3. Working with Text
        • Formating Toolbar
        • Set the appearance of text
        • Copy and reuse formatting
        • Add a line break
        • Insert symbols
        • Using lists
      4. Working with images
        • Adding Images
        • Set the size of a picture
        • Create a thumbnail picture
        • Crop a picture
        • Align or wrap content around a picture
        • Add margins to a picture
        • Set the page background
        • Adding Flash media
        • Adding video
        • Adding sound
      5. Working with hyperlinks
        • Create or modify a hyperlink
        • Picture hyperlinks
        • Bookmarks (HTML anchors)
        • Change the appearance of a hyperlink
        • Adding interactive buttons
      6. Working with Styles
        • About CSS
        • Types of styles
        • Create a style
        • Apply a style
        • Modify a style
        • Attach or detach an external cascading style sheet
      7. Controlling Page Layout
        • Adding a table
        • Format a table
        • Adding CSS layout pages
        • Using layers
        • Add or remove a layer
        • Position a layer
        • Resize a layer
        • Set border, padding, and background properties
      8. Dynamic Web Templates
        • Create a Dynamic Web Template
        • Attach or detach a Dynamic Web Template
        • Update web pages
      9. Publishing sites
        • Publish to a remote production server
        • Work on a remote staging server
        • Work directly on a server using FrontPage Server Extensions
        • Work directly on a remote production server using FTP

      Duration: One day


      MS SharePoint 2010 for Site Owner (CSC514)

      Course Outline:

      1. Creating Site
        • Create and Manage SharePoint sites
        • Delete sites and site collections
      2. Customizing Sites
        • Introduction to customizing site and pages
        • Work with site settings
        • Change the default images on the home pages
        • Change the Site Colors or theme
        • Change the Welcome Page
      3. Managing navigation and site structures
        • Introduction to site navigation
        • Configure navigation inheritance
        • Configure navigation items on the Site Navigation Settings page
        • Customize the top link bar
        • Use the Table of Contents Web Part to display navigation on a Web Page
        • Show or hide tree view navigation for a site
      4. Creating Lists, and Libraries
        • Create a library
        • Create a list
        • Create a calendar
        • Create a picture library
        • Display data from a list or library on a separate page
      5. Managing SharePoint Security
        • About security features
        • About controlling access to sites and site content
        • About managing SharePoint Groups and users
        • Manage SharePoint Groups
        • Permission Levels and permissions
        • Manage Permissions Levels
        • Manage permissions for a list, library, folder, document, or list item
        • Remove users and groups from site access
      6. Using Web Parts
        • Introduction to customizing pages by using Web Parts
        • Customize pages on a site by adding Web Parts
        • Add or remove a Web Part
        • Customize Web Parts
      7. Using SharePoint 2010 Workflow
        • Introduction to workflows
        • Create a workflow
        • Delete or remove a workflow

      Duration: One day


      System Backup and Recovery (CSC016)

      This course is aimed at those who are interested in providing software solution for disaster recovery of their PC. After this course, participants will be able to backup and restore their own data and the OS.

      Date: 28 Jun 2017 (Wed)
      Time: 14:15 p.m. - 17:15 p.m
      Venue: AC2- 5506

      Course Outline:

      1. Introduction to Backup & Restore
        • Why should I backup?
        • Back up your files
        • Back up your programs, system settings, and files
        • Where should I save my backup?
        • Restore files from a backup
      2. Using CD Writer
        • CD-R vs. CD-RW
        • Burn a CD or DVD in Windows Media Player
      3. Backup System and Programs
        • Understanding cloning and image files
        • Using Ghost executable
        • Using Ghost to clone disk to an image file or disk
        • Restoring your system
      4. Automating System Recovering Procedure
        • What is System Restore>
        • What are the system recovery options in Windows 7?
      5. Backup and Restore Windows 7 Operating System
        • What is a System Image
        • Restore your computer from a system image backup
        • Create a system repair disc
        • To use the system repair disc
      6. Backup User Data Files, E-Mails and Web Page Favorites
        • Backup using Folder Synchronization Software
        • E-Mail Backup and Restore
        • IE Backup and Restore

      Duration:3 hours

      Pre-requisite(s): Participants should have a sound working knowledge of the Windows environment.


      Understanding and Controlling Computer Virus (CSC301)

      McAfee VirusScan provides comprehensive virus prevention, detection and elimination software for your computer. It finds and repairs infected files to keep your data safe and secure. Easy updating of the virus definition service over the Internet keeps McAfee VirusScan prepared for the latest threats.

      Course Outline:

      1. Getting Started
        • What's new in McAfee VirusScan Enterprise
          • How viruses work
          • Macro viruses spread quickly
          • How to maintain protection
        • Installing McAfee VirusScan Enterprise
          • System requirements
          • Before installation
          • Install McAfee VirusScan Enterprise
          • After Installation
        • McAfee VirusScan Enterprise basics
          • Work with McAfee VirusScan Enterprise
          • Maintain McAfee VirusScan Enterprise protection
          • Customize McAfee VirusScan Enterprise
      2. Antivirus tools
        • Protecting your Computer from viruses
          • Ensure that Auto-Protect is enable
          • Scan disks, folders and files
          • About custom scans
          • Scan email messages
          • If problems are found during a scan
          • Schedule automatic virus scans
        • Protecting your handheld device from threats
          • About Auto-Protect
          • Set a preference to scan after a synchronization
          • Scan for threats
          • View the Scan summary
      3. Advanced Tools
        • Recovering missing or erased files
        • Eliminating data permanently
      4. What to do if a virus is found
        • What to do if a virus is found on your computer
          • If a virus is found during a scan
          • If a virus is found by Auto-Protect
          • If you have files in Quarantine
          • If McAfee VirusScan Enterprise cannot repair a file
          • If your computer does not start properly
          • Look up virus names and definitions
        • What to do if a threat is found on your handheld device
          • If a threat is found by Auto-Protect
          • If a threat is found by a scan
          • View information about threats
          • If a threat is deleted
          • If a program is deleted

      Duration:3 hours

      Pre-requisite(s):Knowledge of basic PC operations


      Solving Common PC Problems (CSC306)

      Course Outline:

      1. Windows basic troubleshooting
        • Getting older programs to run on Windows 7
        • Updating your program or drivers
        • To start a program each time you start Windows
        • To change or remove a program
      2. Startup & shutdown troubleshooting
        • Start Windows in Safe Mode
        • Start the computer using the last known good configuration
        • [System Restore] overview
        • BIOS error warning sound
      3. Increase computer performance
        • Startup applications
        • Adjust performance options
        • End running application
        • Disk Cleanup
        • Using disk defragmenter
        • Reserve disk space for virtual memory
        • Back up files to a file or a tape
        • Restore files from a file or a tape
      4. Hardware troubleshooting
        • Device manager
        • USB plug & play hardware
      5. Computer security and virus handling
        • Anti-virus software scan
        • Windows Update
        • Use Windows Firewall
      6. Securing your computer
        • Running Windows Update
        • Using Automatic Update
        • Enable Windows Firewall
        • What to Do if Virus is Detected
        • Files in Quarantine
        • How to Block Web Pop-up
        • Activate Screen Saver
        • Creating Strong Passwords
        • How to Change your Password
        • How to Remove Auto Complete
      7. Printers troubleshooting
        • Document printing problem
        • Installing network printers
        • Setting printer properties
        • Cancel printing all documents
        • Pause or resume printing all documents
        • View documents waiting to print
      8. Network connection troubleshooting
        • Connection Checking
        • IPCONFIG command
        • Connecting two computers
      9. How to add new Chinese input method
        • Add another keyboard layout
        • Remove a text service
        • Use shortcut key to switch language & keyboard layout
      10. Remote desktop connection
        • Remote desktop connection
        • Enable remote desktop connection
      11. Setup Windows Dual Boot
        • How to setup Windows Dual Boot options
        • Technique of installing multiple OS
      12. Customized Windows Desktop Setting
        • How to Add My Computer & My Network Places Icon on Desktop
        • How to Add the Quick Launch in Taskbar
        • How to Disable MSN Messenger Autorun
        • Map Network Drive

      Duration: One day

      Pre-requisite(s):Participants should have a sound working knowledge of the Windows environment.


      Adobe Flash CS6 - Introduction (CSC432)

      Course Outline:

      1. Getting Acquainted
        • Starting Flash and Opening a File
        • Creating a New Document
        • Getting to Know the Workspace
        • Choosing a new workspace
        • Saving your workspace
        • About the Stage
        • Changing the Stage properties
        • Working with the Library Panel
        • About the Library panel
        • Importing an item to the Library panel
        • Adding an item from the Library panel to the Stage
        • Understanding the Timeline
        • Renaming a layer
        • Adding a layer
        • Inserting frames
        • Creating a keyframe
        • Moving a keyframe
        • Organizing Layers in a Timeline
        • Creating layer folders
        • Adding layers to layer folders
        • Changing the appearance of the Timeline
        • Using the Properties Inspector
        • Positioning an object on the Stage
        • Using the Tools Panel
        • Selecting and using a tool
        • Undoing Steps in Flash
        • Previewing Your Movie
        • Modifying the Content and Stage
        • Stage Resizing and Content Scaling
        • Saving Your Movie
        • Using Auto-Save
        • Using Auto-Recovery for a backup
        • Saving an XFL document
        • Modifying an XFL document
        • Publishing Your Movie
        • Finding Resources for Using Flash
        • Checking for Updates
      2. Working with Graphics
        • Getting Started
        • Understanding Strokes and Fills
        • Creating Shapes
        • Using the Rectangle tool
        • Using the Oval tool
        • Making Selections
        • Selecting strokes and fills
        • Editing Shapes
        • Using the Free Transform tool
        • Using Copy and Paste
        • Changing shape contours
        • Changing strokes and fills
        • Using Gradient and Bitmap Fills
        • Creating gradient transitions
        • Using the Gradient Transform tool
        • Adding a bitmap fill
        • Grouping objects
        • Making Patterns and Decorations
        • Creating a symbol for a pattern
        • Using the Deco tool Symmetry Brush
        • Aligning objects
        • Breaking apart and grouping objects
        • Using the Deco tool Decorated Brush
        • Using the Deco tool Flower Brush
        • Converting Vector Art to Bitmap Art
        • Creating Curves
        • Using the Pen tool
        • Editing curves with the Selection and Subselection tools
        • Deleting or adding anchor points
        • Creating Transparencies
        • Modifying the alpha value of a fill
        • Matching the color of an existing object
        • Creating and Editing Text
        • Using the Text tool
      3. Creating and Editing Symbols
        • Getting Started
        • Importing Illustrator Files
        • About Symbols
        • Creating Symbols
        • Importing Photoshop Files
        • Editing and Managing Symbols
        • Adding folders and organizing the Library
        • Editing a symbol from the Library
        • Editing a symbol in place
        • Breaking apart a symbol instance
        • Changing the Size and Position of Instances
        • Using rulers and guides
        • Changing the Color Effect of Instances
        • Changing the brightness
        • Changing the transparency
        • Understanding Display Options
        • Visible option for movie clips
        • Blending effects
        • Export as Bitmap
        • Applying Filters for Special Effects
        • Applying a blur filter
        • Positioning in 3D Space
        • Changing the 3D rotation of an object
        • Changing the 3D position of an object
        • Resetting the rotation and position
        • Understanding the vanishing point and the perspective angle
      4. Adding Animation
        • Getting Started
        • About Animation
        • Understanding the Project File
        • Animating Position
        • Using the Controller to Preview the Animation
        • Changing the Pacing and Timing
        • Change the animation duration
        • Adding frames
        • Moving keyframes
        • Animating Transparency
        • Animating Filters
        • Animating Transformations
        • Changing the Path of the Motion
        • Moving the path of the motion
        • Changing the scale or rotation of the path
        • Editing the path of the motion
        • Orienting objects to the path
        • Swapping tween targets
        • Creating Nested Animations
        • Creating animations inside movie clip symbols
        • Using the Motion Editor
        • Setting the Motion Editor display options
        • Changing property values
        • Inserting keyframes
        • Editing keyframes
        • Resetting values and deleting properties
        • Easing
        • Setting eases of a motion tween
        • Using preset eases
        • Animating 3D Motion
        • Testing Your Movie

      Duration: One day


      Adobe Flash CS6 - Advanced (CSC433)

       

      Course Outline:

      1. Creating Interactive Navigation
        • Getting Started
        • About Interactive Movies
        • Creating Buttons
        • Creating a button symbol
        • Duplicating buttons
        • Swapping bitmaps
        • Placing the button instances
        • Naming the button instances
        • Understanding ActionScript 3.0
        • About ActionScript
        • Understanding scripting terminology
        • Variable
        • Keyword
        • Arguments
        • Function
        • Objects
        • Methods
        • Properties
        • Using proper scripting syntax
        • Navigating the Actions panel
        • Preparing the Timeline
        • Adding a Stop Action
        • Creating Event Handlers for Buttons
        • Adding the event listener and function
        • Checking syntax and formatting code
        • Creating Destination Keyframes
        • Inserting keyframes with different content
        • Using labels on keyframes
        • Creating a Home Button with Code Snippets
        • Adding another button instance
        • Using the Code Snippets panel to add ActionScript
        • Code Snippets Options
        • Creating your own code snippet
        • Sharing your code snippet
        • Playing Animation at the Destination
        • Creating transition animations
        • Using the gotoAndPlay command
        • Stopping the animations
        • Animated Buttons
        • Creating the animation in a movie clip symbol
      2. Using Text
        • Getting Started
        • Understanding TLF Text
        • Merging the TLF Text library
        • Adding Simple Text
        • Adding the titles
        • Creating vertical text
        • Modifying characters
        • Adding Multiple Columns
        • Modifying the text box
        • Using the Tab Ruler
        • Wrapping Text
        • Adding the graphics
        • Linking the text boxes
        • Adding content to the linked text boxes
        • Deleting and inserting text boxes
        • Breaking and relinking text boxes
        • Hyperlinking Text
        • Adding a hyperlink
        • Creating User-input Text
        • Adding the static text elements
        • Adding the display fields
        • Embedding fonts
        • Naming the text boxes
        • Changing the contents of text boxes
        • Testing the calculator
        • Loading External Text
        • Naming the text boxes
        • Embedding the fonts
        • Loading and displaying external text
      3. Working with Sound and Video
        • Getting Started
        • Understanding the Project File
        • Using Sounds
        • Importing sound files
        • Placing sounds on the Timeline
        • Adding frames to the Timeline
        • Clipping the end of a sound
        • Changing the volume of a sound
        • Deleting or changing the sound file
        • Setting the quality of the sounds
        • Adding sounds to buttons
        • Understanding Flash Video
        • Using Adobe Media Encoder
        • Adding a video file to Adobe Media Encoder
        • Converting video files to Flash Video
        • Understanding Encoding Options
        • Cropping your video
        • Adjusting video length
        • Setting advanced video and audio options
        • Saving advanced video and audio options
        • Playback of External Video
        • Controlling the video playback
        • Working with Video and Transparency
        • Importing the video clip
        • Using a Green Screen
        • Using Cue Points
        • Inserting cue points
        • Detecting and responding to cue points
        • Adding the synchronized Flash elements
        • Finishing touches
        • Embedding Flash Video
        • Encoding the FLV for embedding
        • Embedding an FLV on the Timeline
        • Using embedded video
      4. Loading and controlling Flash Content
        • Getting Started
        • Loading External Content
        • Using the Code Snippets Panel
        • Removing External Content
        • Controlling Movie Clips
        • Creating Masks
        • Define the Mask and Masked layers
        • Create the mask

      Duration: One day


      Adobe Dreamweaver CS6 - Introduction (CSC434)

      Date: 3 Jan 2018 (Wed)
      Time: 9:30 a.m. - 17:15 p.m
      Venue: AC2-5506

      Dreamweaver is powerful web page publishing software, users can present rich media and easy editing over various content.

      Upon completion of this course, participants will be able to

      • Use text and image content
      • Structure a table
      • Create content with CSS
      • Create hyperlink
      • Preview page

      Course Outline:

      1. Adding content to pages
        • Use the Insert panel
        • Set page properties
        • Work with text
        • Set text properties in the Property inspector
        • Add and modify images
        • Visually resize an image
      2. Presenting content with tables
        • About tables
        • Insert a table and add content
        • Select table elements
        • Set table properties
        • Set cell, row, or column properties
        • Use Expanded Tables mode for easier table editing
        • Format tables and cells
        • Resize tables, columns, and rows
        • Add and remove rows and columns
      3. Creating pages with CSS
        • Understand Cascading Style Sheets
        • The CSS Styles panel
        • Create a new CSS rule
        • Define CSS type properties
        • Inspect CSS in Live view
        • Check for cross-browser CSS rendering issues
        • Lay out pages with CSS
        • Work with div tags
      4. Linking and navigation
        • Absolute, document-relative, and site root-relative paths
        • Link files and documents
        • Find broken, external, and orphaned links
      5. Previewing pages
        • About Live view
        • Preview pages in browsers

      Prerequisites

      General knowledge of Windows

      Duration:6 Hours (2 sessions – 3 hours per session)


      Adobe Dreamweaver CS6 - Advanced (CSC435)

      Date: 23 Aug 2017 (Wed)
      Time: 9:30 a.m. - 17:15 p.m.
      Venue: AC2-5506

      Dreamweaver is powerful web page publishing software, users can present rich media and easy editing over various content.

      Upon completion of this course, participants will be able to

      • Use text and image content
      • Structure a table
      • Create content with CSS
      • Create hyperlink
      • Preview page

      Course Outline:

      1. Working on Cascading Style Sheets (CSS)
        • Use the CSS styles panel
        • Create styles and tag selectors
        • Move CSS rules
        • Create a new style sheet
        • Edit style sheets
        • Link to an external CSS style sheet
        • The style rendering toolbar
        • Display flashing text
      2. Working with Images
        • Place graphics on the page
        • Zoom in and out
        • Modify image properties
        • Edit images
        • Create a rollover image
        • Use image map
        • Set hotspot properties
        • Add multimedia elements like Flash files, audio & visual files
      3. Working with Navigation
        • Create Internal Hyperlink
        • Image Based Link
        • External Link
        • Email Link
        • Target Page Elements
        • Insert Spry Menu Bar
      4. Add Interactivity
        • Using Dreamweaver Behaviour
        • Using spry accordion widget
      5. Increasing Productivity
        • Work with library items
        • Create site templates
        • Define editable regions
        • Use templates
        • Modify templates
        • Apply a template to an existing page
      6. Publishing to the Web
        • Maintain site files
        • Connect to a remote site
        • Synchronize files

      Prerequisites

      General knowledge of Windows and Dreamweaver

      Duration:6 Hours (2 sessions – 3 hours per session)


      Adobe Photoshop CS6 - Introduction (CSC436)

      Date: 27 Sep 2017 (Wed)
      Time: 9:30 a.m. - 17:15 p.m.
      Venue: AC2- 5506

      Adobe Photoshop is the most ideal choice for editing high-quality image files and as well as bring out the best in the digital image of your camera. Special effects and unrivaled editing were made easier for general users! This convenient tool will help any marketing professional to enlighten their image or photos to capture attention of their target audience. In this training course, participants will build a solid foundation for creating a vibrant and memorable image file.

      Upon completion of this course, participant will be able to:

      • Understand Adobe Photoshop interface
      • Effectively manipulate with Selection tools
      • Apply special effect to Images
      • Organize Layering Images for future editing

      Course Outline:

      1. Starting To Work In Photoshop
        • Use The Tools
        • Use The Tool Bar And Palettes
        • Hide Windows And Toolboxes
      2. Essential Concepts
        • Colour Modes: HSB, RGB, CMYK
        • Vector And Raster Images
        • File Saving Preferences
        • Printing Preferences
      3. Photo Corrections
        • Strategy For Retouching
        • Resolution And Image Size
        • Make Automatic Adjustments
        • Manually Adjust The Tonal Range
      4. Image Manipulation
        • Float Or De-Float An Image
        • Rotate A Selection
        • Effect Menu
      5. Select And Fill Colour
        • Use Picker Palette
        • Color Gamut
        • Use Eyedropper
      6. Using Layer
        • Understand Layers
        • Create, Delete And Rearrange Layers
        • Edit, Hide, Activate A Layer
        • Link Layers
      7. Printing
        • View The Print Preview
        • Producing Print
      8. Select bitmap effectively
        • Select Bitmap
        • Select, deselect and reselect pixels
        • Select with Lasso tool
        • Select with the Magnetic Lasso tool
        • Select with the Quick Selection tool
        • Select with the Magic Wand tool
        • Select a color range
        • Adjust selections manually
        • Refine selection edges
        • Soften the edges of selections
        • Extract an object from its background
        • Save a selection to a new or existing channel
        • Create a temporary quick mask
      9. Color Adjustment and Enhancement
        • Before making color and tonal adjustments
        • Adjustments panel overview
        • Correcting Colors in CMYK and RGB
        • About histograms
        • Adjust tonal range using levels
        • Adjust color and tonality with Curves
        • Adjust hue and saturation
        • Adjust color saturation using Vibrance
        • Improve shadow and highlight detail
        • Apply the Color Balance adjustment
        • Apply a gradient map to an image

      Prerequisites

      General knowledge of Windows

      Duration:6 Hours (2 sessions – 3 hours per session)


      Adobe Photoshop CS6 - Advanced (CSC437)

      Date: 11 Oct 2017 (Wed)
      Time: 9:30 a.m. - 17:15 p.m.
      Venue: AC2-5506

      The course is for users already have basic to intermediate knowledge of Photoshop to advance to next level and make use of the tools in Photoshop CS6 to achieve tasks commonly seen.

      Upon completion of this course, participants will be able to:

      • Manipulate layers with blending options and layer styles
      • Adjust images flexibly using adjustment layer
      • Draw straight and curved paths using pen tool
      • Add guides and use alignment options to help place and align images precisely

      Course Outline:

      1. Advanced Layers
        • Manipulate Color Pixels Underneath with Blending Options
        • Add Drop Shadow and Border with Layer Styles
        • Apply Layer Mask to Pixels
        • Mask Layers with Clipping Masks
        • Use Layer Comps to Create Different Views
      2. Useful Adjustment Layers
        • Image Adjustment and Adjustment Layers
        • Brightness/Contrast
        • Hue/Saturation
        • Level Adjustment
        • Curve Adjustment
        • Other Adjustment Layers
      3. Pen Tools And Paths
        • Draw Straight Line Segments with Pen Tool
        • Draw Curves with Pen Tool
        • Edit Paths
        • Convert Between Paths and Selection Borders
        • Manage Paths
        • Use Text Tools with Paths
      4. Advanced Compositing
        • Place And Align Images Precisely with Guides and Alignment Options
        • Use Vanishing Point Filter to Add Perspective Information
        • Reshape Specific Area with Puppet Warp
        • Produce Panorama with Photomerge
        • Create Actions to Automate Tasks

      Prerequisites

      General knowledge of Windows and Photoshop

      Duration:6 Hours (2 sessions – 3 hours per session)


      Adobe Illustrator CS6 - Introduction (CSC438)

      Date: 13 Dec 2017 (Wed)
      Time: 9:30 a.m. - 5:15 p.m.
      Venue: AC2-5607

      Course Outline:

      1. Start Up with Illustrator
        • Tools panel overview
        • About templates
        • Drawing basics
        • About paths
        • About direction lines and direction points
        • About color
        • CMYK
        • About fills and strokes
        • About swatches
        • Add colors from artwork to Swatches panel
        • Apply or edit a gradient
        • Gradient panel and Gradient tool overview
        • About effects
        • Apply an effect
        • Create a drop shadow
        • About saving artwork
        • Save artwork for Microsoft Office
      2. Drawing & Colouring I
        • Drawing simple lines and shapes
        • Draw rectangles and squares
        • Draw polygons
        • Drawing with the Pen tool
        • Rulers, grids, guides, and crop marks
        • Change the unit of measurement
        • Use guides
        • Smart Guides
        • Measure the distance between objects
        • Editing paths
        • Adding and deleting anchor points
        • Smooth and simplify paths
        • Convert between smooth points and corner points   
        • Erase artwork
        • Selecting and arranging objects
        • Select objects with the Selection tool
        • Group or ungroup objects
        • Transforming
        • Transform panel overview
        • Move objects
        • Align and distribute objects
        • Rotate objects
        • Reflect objects
        • Duplicate objects by dragging
        • Offset duplicate objects
        • Reshaping objects with effects
      3. Drawing & Colouring II
        • Methods of combining objects
        • Pathfinder panel overview
        • Summary of Pathfinder effects
        • About compound shapes
        • About compound paths          
        • Methods for cutting, dividing, and trimming objects
        • Clipping masks
        • Create 3D objects
        • Map artwork to a 3D object
        • About Live Paint
        • Trace artwork
        • Change the opacity of artwork

      Duration: One day


      Adobe Illustrator CS6 - Advanced (CSC439)

      Date: 24 May 2017 (Wed)
      Time: 9:30 a.m. - 5:15 p.m.
      Venue: AC2-5506

      Course Outline:

      1. Painting, Brushes, Symbol & Appearance
        • Draw and merge paths with the Blob Brush tool
        • About brushes
        • Work with brush libraries
        • Apply brush strokes
        • Draw paths and apply brush strokes simultaneously
        • Convert brush strokes to outlines
        • Calligraphic brush options
        • Colorization options for scatter, art, and pattern brushes
        • Scatter brush options
        • Art brush options
        • Pattern brush options 
        • About patterns
        • Guidelines for constructing pattern tiles
        • Create pattern swatches
        • Create corner tiles for brush patterns
        • About symbols
        • Create a symbol
        • Symbol libraries
        • About symbol sets
        • Modify symbol instances in a symbol set
        • About appearance
        • Edit or add an appearance attribute
        • Copy appearance attributes between objects
      2. Types, Layout & Printing
        • Enter text at a point
        • Enter text in an area
        • Wrap text around an object
        • Enter text along a path
        • Move or flip text along a path
        • Convert type to outlines         
        • About linked and embedded artwork
        • Place (import) files
        • Links panel overview  
        • Specify document setup options
        • Setting up documents for printing
        • Using multiple artboards
        • Print multiple artboards          
        • Specify crop marks for trimming or aligning
        • About printer’s marks 
        • About bleed
        • About Adobe PDF
        • Create Adobe PDF files
        • TIFF export options
        • About web graphics
        • About slices
        • Web graphic formats
      3. Advanced Technique: Special Effects, Blend & Mesh
        • Appearance panel overview
        • About effects
        • Apply an effect
        • About graphic styles
        • Graphic Styles panel overview
        • Create a graphic style 
        • Gradient Mesh Tool, Gradients & Blends
        • About blended objects
        • Create a blend with the Blend tool
        • Blend options
        • Meshes
        • Create mesh objects
        • Edit mesh objects
        • Width Tool
        • Change the caps or joins of a line
        • Add arrowheads
        • Shape Builder Tool
        • Gap Detection
        • Bristle Brush
        • Drawing Mode
        • Prespective Drawing

      Duration: One day


      Adobe Acrobat DC Pro(CSC103)

      Date: 20 Dec 2017 (Wed)
      Time: 9:30 a.m. - 5:15 p.m
      Venue: AC2-5607

      Course Outline:

      1. Introducing Adobe Acrobat DC
        • About PDF
        • About Adobe Acrobat
        • Working with toolbars
          • Using the toolbar
          • Using the Page Controls toolbar
        • Navigating PDF documents
          • Changing magnification
          • Accessing specific pages
          • Using bookmarks to navigate documents
      2. Creating Adobe PDF Files
        • About creating Adobe PDF files
        • Using the Create PDF tool
        • Dragging and dropping files
        • Converting different types of files
        • Using PDFMaker
        • Using the Print command to create Adobe PDF files
          • Printing to the Adobe PDF printer (Windows)
        • Reducing file size
        • Optimizing PDF files (Acrobat Pro only)
        • Scanning a paper document
        • Making scanned text editable and searchable
        • Converting web pages to Adobe PDF
          • Converting web pages from within Acrobat
          • Downloading and converting linked pages
          • Converting web pages in a web browser
      3. Using Acrobat with Microsoft Office Files (Windows)
        • Getting started
        • About Acrobat PDFMaker
        • Converting Microsoft Word files to Adobe PDF
          • Converting Word headings and styles to PDF bookmarks
          • Converting Word comments to PDF notes
          • Specifying the conversion settings
          • Converting your Word file
        • Converting Excel documents
          • Converting the entire workbook
          • Creating the PDF file
          • Using the spreadsheet split view
        • Converting PowerPoint presentations
      4. Reading and Working with PDF Files
        • Searching PDF documents
        • Printing PDF documents
      5. Enhancing PDF Documents
        • Moving pages with page thumbnails
        • Manipulating pages
          • Inserting a page from another file
          • Rotating a page
          • Deleting a page
        • Renumbering pages
        • Managing links
        • Working with bookmarks
          • Adding a bookmark
          • Changing a bookmark destination
          • Moving bookmarks
      6. Editing Content in PDF Files
        • Editing text
          • Editing a single text block
          • Replacing multiple occurrences of text
          • Changing text properties
          • Adding text
        • Working with images in a PDF file
          • Replacing images
          • Adding images
          • Editing an image in Acrobat
          • Editing an image in another application
        • Copying text and imyages from a PDF file
        • Exporting PDF content to a PowerPoint presentation
        • Saving PDF files as Word documents
        • Extracting PDF tables as Excel spreadsheets
      7. Security
        • About security in Acrobat
        • Viewing security settings
        • Adding security to PDF files
          • Adding passwords
          • Opening password-protected files
      8. Using Acrobat in a Review Cycle
        • Adding comments to a PDF document
          • About the commenting tools
          • Adding sticky notes
          • Emphasizing text
          • Marking text edits
        • Working with comments
          • Importing comments
          • Viewing comments
      9. Working with Forms in Acrobat
        • Getting started
        • Converting PDF files to interactive PDF forms
        • Adding form fields
          • Adding a text field
          • Adding a multiline text field
          • Adding radio buttons
          • Adding an action button
        • Distributing forms
        • Collecting form data
        • Working with form data

      Course Duration:1 day / 6 hours


      Introduction to JavaScript (CSC109)

      JavaScript is an easy-to-use programming language that can be embedded in the header of your Web pages. It can enhance the dynamics and interactive features of your page by allowing you to perform calculations, check forms, write interactive games, add specific visual effects, customise graphics selections, create security passwords and more.

      Course Outline:

      1. Introduction
        • What is JavaScript, and What Can It Do?
        • How Do I Put JavaScript in My Pages?
        • What is Object Oriented Programming?
      2. The Message Box
        • Basic Structure
        • Alert Command
        • Forms
      3. Making Logical Decision
        • The Prompt() Function
        • The If-Then Statement
      4. Looping
        • Looping with For Statement
        • Useful Properties & Operators
        • Putting it all together
      5. Methods
        • Window Methods
        • Date Methods
        • Strings
      6. Windows
        • Window. Open()
        • The Document Object
      7. Events
        • Event in a Form
        • onChange Events
        • Dropdown List
        • Check Boxes
        • onLoad Events
        • The SetTimeout() Method
        • Common Attributes Controlled by the Style Sheet
      8. Introducing Dynamic HTML
        • What is Dynamic HTML Style Sheets
        • Style Sheets in Depth
        • Linking to a Style Sheet
        • Importing Style Sheets
        • Inline Styles
        • The DIV and SPAN Tags

      Duration: One day

      Pre-requisite(s):Participants should have knowledge of at least one programming language, and have taken the course Introduction to HTML (CSC108).


      JavaScript - Advanced (CSC113)

      Course Outline:

      1. JavaScript Objects
        • Object-Oriented Programming Concepts
        • Defining your own Object:
          • The new Statement
          • Objects as arrays
        • Using variable length arrays and extended instances
        • Built-in objects
        • Math Object
        • Date Object
        • String Object
        • Browser & HTML Objects
      2. Creating your own Java-script Objects
        • Global and local Variables
        • More on Java Script Functions
        • JavaScript's Associative Arrays
        • JavaScript HTML Objects
      3. Using Frames & Cookies in Advanced Application
        • Storing Parameters and other data
        • Command-line Parameters
        • Storing persistent Data in cookies
        • Frames & JavaScript
        • Specifying Frames in HTML
        • Building a frameset
      4. Controlling Web page Appearance
        • Web Building with Java Script
        • Text properties & color Values
      5. Advanced Techniques
        • XML & XHTML
        • Debugging Scripts
        • Regular Expressions

      Duration: One day

      Pre-requisite(s): Participants should have knowledge of at least one programming language, and have taken the course Introduction to JavaScript (CSC109).


      Introduction to HTML (CSC108)

      HTML is the language used to create World Wide Web pages on the Internet and it stands for HyperText Markup Language. This course guides you through the elements required to create the Web pages using HTML. All jargon terms will be carefully explained.

      Course Outline:

      1. What is an HTML document
      2. Page creation and editing
      3. Basic structure
      4. Headings, line breaks and horizontal rules
      5. Text and paragraphing lists
      6. Linkage to URLs and specific sections
      7. Adding images and tables

      Duration: One day

      Pre-requisite(s): Participants should have a sound working knowledge of the Windows environment and Internet.


      Introduction to XML (CSC107)

      This is a practical course for developers with no experience in creating XML documents. The course teaches basic XML mark-up using XML 1.0 and some related extensions.

      Course Outline:

      1. XML Basics
        • Elements
        • Hierarchies
        • Attributes
        • Declarations
        • Entities
        • Well-formed documents
      2. Document type definitions
        • Document models
        • When to use a DTD
        • How to use a DTD
        • Validation
        • DTD Markup Syntax
      3. Document modelling techniques
      4. Links
      5. Namespaces
      6. More XML Extensions

      Duration: One day

      Pre-requisite(s): Completed Introduction to HTML (CSC108) and XML – Overview (CSC106) or with equivalent knowledge.


      How to Secure your PC for Windows 7

      Course Outline:

      1. Computer Security Basics
      2. Techniques used by Hackers
      3. Anti-Virus Software
      4. Use a Firewall
      5. Applying Patches, Running Windows Updates & Internet Protection
      6. Practicing Safe Computing

      Duration: 3 hours


      Chinese Input Method - Chang Jei

      Course Outline:

      1. 倉頡輸入法簡介
      2. 倉頡字母
      3. 輔助字形
      4. 倉頡輸入法
      5. 字形取碼注意事項
      6. 例外字
      7. 省略原則
      8. 定義字首

      Duration: 3 hours


      Chinese Input Method - Q9

      Course Outline:

      1. 九方輸入系統簡介
      2. 字形輸入
      3. 輸入小貼士(姓氏、標點、多碼字)
      4. 檢字
      5. 筆劃輸入
      6. 輔助功能

      Duration: 3 hours


      Microsoft Word - Introduction

      Course Outline:

      1. The Microsoft Word 2013 Screen
      2. Compatibility Mode
      3. Manipulating Text
      4. Paragraph Formatting
      5. Borders and shading
      6. Page Formatting
      7. Headers & Footers
      8. Tables
      9. Pictures
      10. Using graphics within Microsoft Word
      11. Proofing and Printing

      Duration: 3 hours


      Microsoft Word - Advanced

      Course Outline:

      1. Paragraph Formatting
      2. Sections
      3. Styles
      4. AutoCorrect
      5. Building Blocks (AutoText)
      6. Captions
      7. Footnotes and Endnotes
      8. Bookmarks
      9. Tables of Contents & Indexes
      10. Master Documents
      11. Tracking and Comments
      12. Comparing and Combining Documents
      13. Macros
      14. Mail Merging
      15. Passwords and Editing Restrictions

      Duration: 3 hours


      Microsoft Excel - Introduction

      Course Outline:

      1. Using Excel 2013
      2. Selection techniques
      3. Manipulating rows and columns
      4. Manipulating cells and cell content
      5. Worksheets
      6. Manipulating Worksheets
      7. Paste Special Options
      8. Alignment formatting
      9. Number formatting
      10. Freezing
      11. Formulas
      12. Functions
      13. Charts
      14. Customising Excel
      15. Setup & Printing Issues

      Duration: 3 hours


      Microsoft Excel - Advanced

      Course Outline:

      1. Functions and Formulas
      2. Logical Functions
      3. Lookup Functions
      4. Database Functions
      5. Cell Formatting
      6. Pivot Tables
      7. Input Tables
      8. Importing Text Files
      9. Sorting and Filtering Data
      10. Tracking and Reviewing Changes
      11. Validating
      12. Auditing
      13. Macros
      14. Passwords & Security Issues

      Duration: 3 hours


      Microsoft PowerPoint - Introduction

      Course Outline:

      1. Using PowerPoint 2013
      2. Creating a Presentation
      3. Manipulating Slides
      4. Themes
      5. Text Boxes
      6. Manipulating text
      7. Paragraph Formatting
      8. Graphics
      9. Manipulating Graphics
      10. Inserting Charts
      11. Manipulating Slides
      12. Slide Masters
      13. Slide Shows
      14. Customising and Compatibility Issues

      Duration: 3 hours


      Microsoft PowerPoint - Advanced

      Course Outline:

      1. Sections
      2. Slide MastersThemes
      3. Themes
      4. Formatting Pictures & Images
      5. Diagrams
      6. Video and Audio
      7. Animation
      8. Linking and Embedding
      9. Merging, Comparing and Exporting
      10. Slide Show
      11. Sharing Presentation
      12. Design and Compatibility

      Duration: 3 hours


      Introduction to Access

      Course Outline:

      1. Database Concepts
      2. Opening a Database & Security Issues
      3. Tables, Fields and Field Types
      4. Table Navigation & Modification
      5. Field Properties
      6. Manipulating Tables & Records
      7. Primary Keys and Indexing
      8. Filtering
      9. Sorting
      10. Searching
      11. Forms
      12. Queries
      13. Reports

      Duration: 3 hours


      Flash Introduction

      Course Outline:

      1. Creating Simple Document
      2. Creating fla File and Adding Graphics
      3. Drawing On Stage
      4. Creating Symbol and Animation
      5. Publishing

      Duration: 3 hours


      Photoshop - Introduction

      Course Outline:

      1. Workspace Basics
      2. Color Fundamentals
      3. Converting Between Color Modes
      4. Adjusting Crop, Rotation and Canvas
      5. Filter Basics
      6. Retouching Basics

      Duration: 3 hours


      Social Networks and Mobile Security (CSC513)

      Date: 28 Jun 17 (Wed)
      Time: 14:15 p.m. - 17:15 p.m
      Venue: AC2-5506

      Raise participants' awareness of digital generation information security

      Discuss the importance of information security through recent security incidents and cases

      Course Outline:

      1. IT security trends
        • APT advanced performance threat
        • ATM machine "Tyupkin"
        • Worms on the Internet
      2. How to Be Safe on the Internet/ Staying Safe Online
        • Internet Information Security Risk
        • Precautions
      3. Use Mobility Device Safety
        • Common threats
        • Incoming Call intercept APPS privacy leakage
        • Privacy Leakage case study
        • Implanted malicious software case study
        • Mobile vulnerability - Android & iOS platform
        • Jailbreak mobile device attacks
        • Fraud cases of recent telephone / electronic message
        • Protect your mobile device
        • Instant messaging software privacy ranking
        • Security threats of instant messaging software
      4. Safe online social networking
        • Social networking site fake identity
        • Use of social networking
        • Suggestions in using social networking site
      5. Cloud technology security awareness
        • Introduction to Cloud Computing
        • Cloud service application examples
        • Cloud computing security and privacy risks
        • Operational Considerations and Practices for Cloud Computing
      6. How to be a good password/ Good password usage practice
        • Understand the characteristics and forms of passwords
        • Maintain good password practice
        • Regularly review password-related security matters

      Prerequisites:

      General knowledge of using social networks and mobile devices

      Duration:3 Hours (1 session – 3 hours per session)


      Effective Use of Android Mobile & Tablet (CSC516)

      Course Outline:

      1. Introduction to Android Operating System
        • Features in Android
        • Difference between Android 2.x / 3.x / 4.0
      2. Android Operating System Settings
        • User Preference in Android Device
        • Using Android Desktop
        • Customize your Android Device
      3. Android Software Management
        • Install Application
        • Install Application from Google Play Store
        • Install Application from other Markets
        • Software Management in Android
      4. Using Android
        • Mail and Calendar
        • Contacts
        • Input Methods
        • Data synchronization and Document Exchange
        • Google Map in Android
        • Web Browsing in Android
        • Multimedia in Android
      5. CityU Applications
        • Connecting to CityU Wireless Local Area Network
        • Accessing JSMS email via Android tablet built-in email client
        • City University Official Apps Web Site
        • Blackboard Mobile Learn
        • CityU GE
        • CityU Mobile CAP
        • CityU Mobile News
        • CityU Alumni Apps
        • CityU Campus VR
        • What To Do If You Lose Your Tablet

      Duration: 3 hours
      (Note: Samsung Galaxy Android tablets will be provided in class.)


      Effective Use of iPhone & iPad (CSC517)

      Course Outline:

      1. What is iPhone and iPad
      2. iPhone and iPad Basic Operation
      3. What is iOS?
      4. What is iTunes?
      5. Purchase Apps from App Store
      6. Backup and Sync
      7. Upgrade iOS firmware
      8. What is iCloud?
      9. Using Find My iPhone / iPad
      10. What’s new in iOS5?
        • Notification Area
        • Newsstand Subscription
        • Reminder
        • New features in Camera
        • Wifi Sync
      11. What’s new in iOS5 in iPad?
      12. iPhone / iPad Tips and Tricks
        • Multi-tasking gesture
        • Enhanced Safari
        • Detached keyboard

      Duration: 3 hours
      (Note: Participants are expected to bring their own iPhones / iPads to the class.)


      iPad Application Development (CSC518)

      Course Outline:

      1. Module 1: iPad series: a Unique Gadget
        • Setting up the Development Environment
        • Creating your first project in Xcode
        • APP1 – Restaurant Ad
      2. Module 2: Building Your First iPad App
        • Understanding the iPad Platform and SDK
        • Programming for iPad is Different from iPhone
        • Controllers and Event Handling
        • Page-flipping Animation (Magazine like)
        • APP2 – Magazine Viewer
        • Recognizing Finger Gestures
      3. Module 3: Adding More Features
        • iPad Application Architecture and Design
        • How to Play Videos
        • APP3 – Wedding Video Player
        • Using Map View
        • Utilizing Core Location
        • APP4 – Office Locations
        • The Universal Application Type
      4. Module 4: iPad-specific Features and Web Services
        • iPad-Specific Design Considerations
        • UI Design for the Larger 9.7” Screen
        • Developing for all orientations
        • APP5 – Turning Around
        • iPad-Specific UI Controls: Popover and Split View
        • Building a Web Service App using Split View
        • Testing and Debugging
        • APP6 – Web Service App

      Duration: 2 days / 12 hours

      Pre-requisite(s):  Participants should have knowledge of Programming


      Android Tablet Application Development (CSC519)

      Course Outline:

      1. Module 1
        • What is Android?
        • Android Framework Fundamentals
        • Android SDK Development Environment
      2. Module 2
        • Android Applications Basic Elements
        • Set up and Design Android UI
        • Creating Your First Android Application
      3. Module 3
        • Accessing Google Maps 
        • Integrating Google Maps to Application
        • Showing Google Maps in Specific Location
        • Adding Landmark Icon in Google Maps
        • Using GPS with Google Maps
      4. Module 4
        • Debugging Application
        • Outputting Android .apk Installation File
        • Uploading .apk File to Android Market
        • Using Sata Storage on Android

      Duration: 2 days / 12 hours

      Pre-requisite(s): 
      Participants should have knowledge of Programming


      Mastering Excel Pivot Tables (CSC538)

        Date: 15 Nov 2017 (Wed)
        Time: 09:30 a.m. - 17:15 p.m
        Venue: AC2-5506
        1. Pivot Table Fundamentals
          • Why You Should Use a Pivot Table
          • When to Use a Pivot table
          • Anatomy of a Pivot Table
        2. Preparing Data for Pivot Table Reporting
          • Ensuring That data Is in a Tabular layout
          • Avoiding Storing Data in Section Headings
          • Avoiding Repeating Groups as Columns
          • Eliminating Gaps and Blank Cells in the Data Source
          • Applying Appropriate Type Formatting to Fields
          • Summary of Good Data Source Design
        3. How to Create a Basic Pivot Table
          • Adding Fields to a Report
          • Fundamentals of Laying Out a Pivot Table Report
          • Adding Layers to a Pivot Table
          • Rearranging a Pivot Table
          • Creating a Report Filter
          • Understanding the Recommended Pivot Table
        4. Using Slicers
          • Creating a Standard Slicer
          • Creating a Timeline Slicer
          • Keeping Up with Changes in the Data Source
          • Saving Time with New Pivot Table Tools
        5. Making Common Cosmetic Changes
          • Applying a Table Style to Restore Gridlines
          • Changing the Number Format to Add Thousands Separators
          • Replacing Blanks with Zeros
          • Changing a Field Name
        6. Making Report Layout Changes
          • Using the Compact Layout
          • Using the Outline Layout
          • Using the Traditional Tabular Layout
          • Controlling Blank Lines, Grand Totals, and Other Settings
          • Customizing a Pivot Table’s Appearance with Styles and Themes
          • Changing Summary Calculations
          • Adding and Removing Subtotals
          • Changing the Calculation in a Value Field
        7. Automatically Grouping Dates
          • Undoing Automatic Grouping
          • Understanding How Excel 2016 Decides What to Group
          • Grouping Date Fields Manually
          • Including Years When Grouping by Months
          • Grouping Date Fields by Week
          • Grouping Numeric Fields
          • Using the PivotTable Fields List
        8. Sorting in a Pivot Table
          • Sorting Customers into High-to-Low Sequence Based on Revenue
          • Using a Manual Sort Sequence
          • Using a Custom List for Sorting
          • Filtering a Pivot Table: An Overview
        9. Using Filters for Row and Column Fields
          • Filtering Using the Check Boxes
          • Filtering Using the Search Box
          • Filtering Using the Label Filters Option
          • Filtering a Label Column Using Information in a Values Column
          • Creating a Top-Five Report Using the Top 10 Filter
          • Filtering Using the Date Filters in the Label Drop-down
        10. Filtering Using the Filters Area
          • Adding Fields to the Filters Area
          • Choosing One Item from a Filter
          • Choosing Multiple Items from a Filter
          • Replicating a Pivot Table Report for Each Item in a Filter
          • Filtering Using Slicers and Timelines
          • Using Timelines to Filter by Date
          • Driving Multiple Pivot Tables from One Set of Slicers
        11. Performing Calculations in Pivot Tables
          • Introducing Calculated Fields and Calculated Items
          • Creating a Calculated Field
          • Creating a Calculated Item
          • Managing and Maintaining Pivot Table Calculations
        12. Using Pivot Charts and Other Visualizations
          • What Is a Pivot Chart?
          • Creating a Pivot Chart
          • Keeping Pivot Chart Rules in Mind
          • Examining Alternatives to Using Pivot Charts

        Duration: 6 hours


        Paperless Meetings using SharePoint Online (for organisers) (CSC003)

        Date: 20 Sep 2017 (Wed)
        Time: 9:30 a.m. - 17:15 p.m
        Venue: AC2- 5506
        Date: 22 Nov 2017 (Wed)
        Time: 9:30 a.m. - 17:15 p.m
        Venue: AC2- 5506

        To support sustainability and work simplification, the use of IT to reduce paper in our work is a welcome objective. The course is designed to help you achieve this objective.  After attending the course, you will be able to use a Team Site (private collection) to disseminate meeting agendas and papers to your team members, maintain membership, send alerts to members on new and revised content, and archive old meeting content.  Confidential meeting content can be further encrypted to protect it against unauthorized access.  Team members will be able to read meeting content anywhere and anytime from their PCs and mobile devices. 


        1. SharePoint Online Team Site
          • What is a Team Site?
          • Navigate a Team Site
          • Customize a Team Site
        2. SharePoint Library
          • What is a SharePoint Library?
          • Create and Customize a Library
          • Document Versioning
        3. SharePoint List
          • What is a SharePoint List?
          • Create and Customize a SharePoint List
          • Delete a List
          • SharePoint 5000 Items Limit Threshold
          • Manage a Calendar
          • Manage a Tasks List
          • Manage Links
        4. SharePoint List and Library Views
          • What is a View?
          • Create a View
          • Modify a View
          • Delete a View
        5. Information Rights Management
          • Overview of Information Rights Management
          • Apply Information Rights Management to a Library
          • How Information Rights Management works for Lists and Libraries
        6. SharePoint Online Permissions
          • Overview of Permissions
          • Default Permission Levels
          • Permissions and Dependencies
          • Create and Manage SharePoint Groups
        7. Miscellaneous
          • Site Columns
          • Create and Manage Site Column
          • Content Types
          • Create Content Types for Library

          Duration: One day / 6 hours


          How to Practise Safe Computing (CSC004)

          Date:

          29 Nov 2017 (Wed)

          Time: 09:30 a.m. - 12:30 p.m
          Venue:

          AC2- 5506

          Although the Windows operating systems are commonly installed on personal computers, they are not designed to be used with computers storing data that is considered critical to a project or that must be very securely protected. In fact, there is an increasing number of incident reports from Windows users. Thus, this course is intended to help these users become more aware of computer security.

          Course Outline:

          1. Computer Security Basics
            • What is Computer Security
            • Computer Security Risks to Computer Users
            • Physical Security Issue
          2. CityU Information Classification & Handling
            • Information Classification
            • Labeling Information
            • Information Handling
          3. Techniques used by Hackers
            • Backdoor and Remote Administration Program
            • Trojan Horse Program
            • Denial of Service
            • Packet Sniffing
            • Web Unexpected Input
            • Java, JavaScript and Active X
            • Email Spoofing
            • Viruses and Worms
            • Internet Pop-up
            • Zero-day attack
            • Other Hack Tools
          4. Anti-Virus Software
            • How Do You Know Your PC is Infected by Virus?
            • Popular Virus Protection Software
            • Right Click Scanning
            • On-Demand Scanning
            • Virus Definition
            • Handling of Unknown Virus
          5. Firewall
            • Types of Firewall
            • Which one is suitable for Individual Use
            • Windows 10 Firewall
          6. Windows Updates
            • Windows 10 Automatic Update
          7. Windows 10 Browsers
            • Internet Explorer 11 vs Edge
            • Internet Explorer Security
            • Pop-up Blocker
            • IE 11 Clear Auto Complete
          8. Bitlocker Drive Encryption
            • What is Bitlocker
            • Enable Bitlocker
          9. Practicing Safe Computing
            • Don’t open Unknown email
            • Disable Hidden Filename Extensions
            • Turn Off your Computer or Disconnect from the Network When Not in Use
            • About History
            • Disable Cookies in the browsers
            • Disable Java, Javasript and Active X if possible
            • Disable Plug-ins
            • Avoid Malicious Sites
            • Disable Scripting features in email programs
            • Phishing Filter in IE 11
            • MS Office Security
            • Safety tips on using WLAN
            • Configuring Secured Connection for WLAN
            • Notebook Security

          Duration:3 hours

          Microsoft Access 2016 - Introduction (CSC540)

          Date: 6 Sep and 13 Sep 2017 (Wed)
          Time: 9:30 a.m. - 17:15 p.m
          Venue: AC2- 5506

          Course Outline:

          1. Basic Tasks for an Access Desktop Database
            • Choose a template
            • Create a database from scratch
            • Import or link to data
          2. Database Design Basics
            • Some database terms to know
            • What is good database design
            • The design process
            • Determining the purpose of your database
            • Finding and organizing the required information
            • Dividing the information into tables
            • Turning information items into columns
            • Specifying primary keys
            • Creating the table relationships
          3. Learn the structure of an Access database
            • Overview
            • See details about the objects in a database
            • Explore a table in Design view
            • See the relationships between tables
            • See how objects use other objects
          4. Introduction to Tables
            • Overview
            • Add a table to an Access desktop database
            • Set table properties in a desktop database
          5. Add or Change a Table’s Primary Key in Access
            • Overview of primary key in Access
            • Add an AutoNumber primary key in Access
            • Set the primary key using fields you already have in Access
            • Remove the primary key in Access
          6. Filter data in a desktop database
            • About filtering
            • Different ways to filter
            • Switch between Filtered and Unfiltered views of your data
            • Clear a filter
            • Save a filter and apply it automatically
          7. Introduction to Queries
            • Queries help you find and work with your data
            • Create a select query
            • Apply criteria to a query
            • Apply criteria to text values
            • Apply criteria to dates
            • Create a parameter query
            • Create a totals query
            • Sum or count values on a datasheet with a Total row
            • Create a crosstab query
            • Create a make table query
            • Create an append query
            • Create an update query
            • Create a delete query
          8. Create an Access Form
            • Create a form from an existing table or query in Access
            • Create a form by using the Form tool
            • Create a blank form in Access
            • Create a split form in Access
            • Create a form that displays multiple records in Access
            • Create a form that contains a subform in Access
          9. Introduction to Reports in Access
            • Overview of reports in Access
            • Create a report in Access
            • Add grouping, sorting, or totals
            • Highlight data with conditional formatting
            • Customizing color and fonts
            • Add a logo or background imag
            • Preview and print a report
          10. Create a Grouped or Summary Report
            • Create a quick grouped or sorted report
            • Build a new grouped report by using the Report Wizard
            • Add or modify grouping and sorting in an existing report

          Duration: Two days / 12 hours


          Microsoft Excel 2016 - Introduction (CSC541)

          Course Outline:

          1. Microsoft Excel Essential Feature
            • The Excel Ribbon
            • Starting a New Workbook
            • Find Recent Files
            • Stay Connected
            • Set your Preferences
            • Share your Work with Others
          2. Managing Excel Workbooks
            • Creating a New Workbook
            • Save your Work
            • Save as PDF
            • Save an Excel 2016 Workbook for Compatibility with Earlier Versions of Excel
            • Share your Workbook with Others
            • Save Documents Online
          3. Managing Excel Worksheets
            • Enter Data in a Worksheet
            • Selecting Worksheet
            • Moving Around a Worksheet
          4. Manipulating Cells and Cell Content
            • Inserting Cells
            • Wrap Text in a Cell or Group of Cells
            • Merge Cells and Split Merged Cells
            • Finding and Replacing Cell Items
            • Working with Columns and Rows
            • Freeze Panes to Lock the First Row or Column
          5. Selecting, Copying, Moving, and Deleting Cell Contents
            • Select Cells, Ranges, Rows, or Columns on a Worksheet
            • Copy and Paste Format to Other Cells
            • Using Paste Options
            • Using the Paste Special Dialog Box
            • Moving Cells and Ranges
            • Clearing and Deleting Cells
            • Viewing Worksheets
          6. Worksheet Formatting and Management
            • Formatting Text Entries
            • Formatting Values
            • Rotate or Align Cell Data
            • Insert or Remove Cell Borders
            • Using Themes
            • Apply, Create, or Remove a Cell Style
          7. Filling and Entering Series
            • Using the Fill Handle
            • Display or Hide the Fill Handle
            • Creating Custom Fill Lists
            • Creating Custom Series
            • Using Flash Fill
            • Turn Flash Fill on
          8. Printing Worksheets
            • Headers and Footers
            • Using the Page Layout Commands
            • Set Page Margins before Printing a Worksheet
            • Print a Worksheet in Landscape or Portrait Orientation
            • Scale the Sheet Size for Printing
            • Set a specific Print Area
            • Inserting Page Breaks
            • Print the Top Row on Every Page
            • Working on the Print Page
          9. Overview of Formulas
            • Parts of an Excel Formula
            • Using Constants in Excel Formulas
            • Using Calculation Operators in Excel Formulas
            • Using Functions and Nested Functions in Excel Formulas
            • Using References in Excel Formulas
            • Fill a Formula down into Adjacent Cells
            • Copy and Paste a Formula to another Cell or Worksheet
            • Using Names in Excel Formulas
          10. Entering a Function in a Cell
            • Using AutoSum
            • Using the Status Bar
            • Using References in Formulas
            • Difference between Absolute, Relative and Mixed References
          11. Working with Function
            • Statistical Functions
            • Date & Time Functions
          12. Detect Errors in Formulas
            • Common Error Messages
            • Using the Auditing Tools
            • Correct Common Formula Errors one at a time
          13. Working with Chart
            • Creating a Chart
            • Change the Color or Style of a Chart
            • Add Axis Titles to a Chart
            • Add Data Labels to a Chart
            • Add a Data Series to a Chart
            • Change the Data Series in a Chart
            • Rename a Data Series
            • Add a Chart Legend
            • Copy an Excel 2016 Chart to another Office Application
            • Analyze Trends in Data using Sparkline

          Duration: One day / 6 hours


          Microsoft Excel 2016 - Advanced (CSC542)

          Date: 4 Oct 2017 (Wed)
          Time: 9:30 a.m. - 17:15 p.m
          Venue: AC2- 5506

          Course Outline:

          1. Using Conditional Formatting
            • Format all Cells by using Data Bars
            • Format all Cells by using an Icon Set
            • Format only Cells that contain Text, Number, or Date or Time Values
            • Format only Top or Bottom Ranked Values
            • Format only Values that are Above or Below Average
            • Format only Unique or Duplicate Values
            • Use a Formula to determine which Cells to Format
            • Apply Conditional Formatting by using Quick Analysis
            • Clear Conditional Formats
          2. Creating a Formula by using a Function
            • Creating a Formula by using a Function
            • Logical Function
            • Lookup Function
            • Database Functions
          3. Data Management
            • Analyze your Data instantly
            • Sort Data in an Excel Worksheet
            • Sort Data using a Custom List
            • Filter by using Advanced Criteria
            • Remove a Filter
            • Remove Duplicate Values
            • What is Subtotals
            • Insert Subtotals in a List of Data in a Worksheet
          4. Connect External Data to your Workbook
            • Importing Text Files
            • Using Text to Columns
          5. Working with PivotTables
            • Create a Recommended PivotTable
            • Create a PivotTable manually
            • Change the Data Layout of a PivotTable
            • Sorting Data in a PivotTable
            • Filter data in a PivotTable
            • Group or Ungroup Data in a PivotTable Report
            • Use the Field List to arrange Fields in a PivotTable
            • Update (Refresh) Data in a PivotTable
            • Create a PivotChart
          6. Consolidate Data from Multiple Worksheets in a Single Worksheet
            • Consolidate Data by Position
            • Consolidate Data by Category
            • Use a Formula to Consolidate Data
          7. Using a Shared Workbook to Collaborate
            • Sharing a Workbook
            • Merge Changes
            • Resolve Conflicting Changes in a Shared Workbook
            • Edit a Shared Workbook
            • Remove a User from a Shared Workbook
            • Stop Sharing a Workbook
            • Features a Shared Workbook doesn't Support
          8. Track changes in a Shared Workbook
            • Overview of Change Tracking
            • Turn on Change Tracking for a Workbook
            • Highlight Changes as you work
            • View Tracked Changes
            • Accept and Reject Changes
            • View the History Worksheet
            • Changes that Excel does not Track or Highlight
            • Turn off Change Tracking for a Workbook
          9. Protecting Workbooks and Worksheets
            • Protect a Worksheet with or without a Password
            • Lock Cells to Protect them
            • Unlock Protected Cells
            • Hide and Protect Formulas
            • Protect a Workbook
            • Remove a Password from a Worksheet or Workbook
            • Change the Password for my Workbook or Worksheet
          10. Create or Delete a Macros
            • Record a Macro
            • Run an Excel Macro
            • Delete a Macro

          Duration: One day / 6 hours


          Microsoft Word 2016 - Advanced (CSC543)

          Course Outline:

          1. Share your Document
            • Share your Document via OneDrive or SharePoint
            • Share a PDF or Copy of your Document by Email
          2. Collaborate on Word Documents with Real-Time Co-Authoring
            • Save a Document Online and invite others to work on it with you
            • Start Working Together in a Document
            • Options for Sharing Changes: Ask me, Always, and Never
          3. Using Styles
            • How to Find Styles
            • How to Apply a Style to Text
            • How to Change an Existing Style
            • How to Create a Style from Existing Formatted Text
            • How to Remove Style Formatting
          4. Creating Headers and Footers
            • Add a Page Break
            • Remove a Page Break
            • Add Section Breaks
            • Type of Section Breaks
            • Add Page Numbers
            • Add Page Numbers to a Header or Footer
            • Add Page Number X of Y to a Document
            • Add Different Page Numbers or Number Formats to different Sections
            • Start Page Numbering later in your Document
            • Start Page Number with something other than 1
            • Delete Page Numbers
            • Add a Header or Footer
            • Delete a Header or Footer from a Single Page
          5. Using Mail Merge
            • Set up the Main Documents
            • Connect the Document to a Data Source
            • Refine the list of Recipients or Items
            • Add Placeholders
            • Insert Mail Merge Fields
            • Format Mail Merge Numbers, Dates, and Other Values in Excel
            • Preview and Finish the Merge
            • Mail Merge for Labels
          6. Using Bookmark and Croos-Referencing
            • Bookmark the Location
            • Go to the Bookmark
            • Create a Cross-Reference
            • Create the item you're Cross-Referencing
            • Insert the Cross-Reference
            • Create a Hyperlink
            • Create a Hyperlink to a Document, File, Web page, or to a Blank Email Message
            • Create a Hyperlink to a specific place in a Document
            • Turn off Automatic Hyperlinks
            • Show the Full Path for Hyperlinks
            • Turn off Ctrl+Click to follow a Link
          7. Create a Table of Contents
            • Apply Heading Styles
            • Create a Table of Contents
            • Update a Table of Contents
            • Format or Customize a Table of Contents
            • Format the text in a Table of Contents
          8. Create an Index
            • Mark the Entries
            • Mark Index Entries for text that spans a Range of Pages
            • Create the Index
          9. Add Footnotes and Endnotes
            • Add a Footnote
            • Add an Endnotes
            • Customize Footnotes and Endnotes
          10. Track Changes
            • Applying Track Changes
            • Keep Track Changes on
            • Accept Tracked Changes
            • Change Options for Track Changes
            • Advanced Track Changes Options
            • Turn off Track Changes
          11. Protecting Document
            • Password Protect a Document
            • Change the Password of a Document
            • Allow Changes to parts of a Protected Documen
            • Remove a Password from a Document
          12. Using Macro
            • Create or Run a Macro
            • Create a Macro with a Keyboard Shortcut
            • Run a Macro
            • Make a Macro available in all Documents
            • Add a Macro Button to the Ribbon

          Duration: One day / 6 hours


          Microsoft PowerPoint 2016 - Advanced (CSC544)

          Date: 10 Jan 2017 (Wed)
          Time: 9:30 a.m. - 5:15 p.m
          Venue: AC2- 5506

          Course Outline:

          1. Sections
            • Add Section
            • Rename a section
            • View Sections in Slide Sorter View
            • Reorder a Section
            • Remove a section
          2. Using Slide Master
            • What is a slide master?
            • Using multiple slide masters in one presentation
          3. Working with Charts
            • Adding a chart to a presentation
            • Creating a chart in Excel
            • Fine-tune your chart
            • Change the data in your chart
            • Save a custom chart as a template
            • Copying an Excel chart to another Office program
          4. Using SmartArt to create Organization Chart
            • What to consider when choosing a layout
            • Create an organization chart with pictures
            • Format an organization chart
            • Convert text into a SmartArt graphic
            • Changing the colors of an entire SmartArt graphic
            • Applying a style to your SmartArt graphic
          5. Working with Graphics
            • Working with pictures
            • Remove background
            • Changing the brightness, contrast, or sharpness of a picture
            • Recoloring a picture or clip art
            • Applying an artistic effect
            • Cropping a picture or place it in a shape
            • Combine shapes to create a custom shape
            • Using eyedropper to match colors on your slide
            • Aligning or arranging an objects
            • Line-up and space objects equally
            • Compress a picture
          6. Using Video and Audio
            • Video / Audio Formats supported by PowerPoint
            • Adding audio to your slide show
            • Trim a music or sound clip
            • Setting the playback options for an audio clip
            • Deleting an audio clip
            • Inserting or linking to a video that is stored on my PC
            • Setting the 'Playback' options for a video in your presentation
            • Starting or ending your video with a fade effect
            • Trim a video
          7. Slide Transitions
            • Adding a transition to a slide
            • Setting the speed and timing of transitions
            • Remove a transition effect
          8. Applying an Animation Effect
            • Applying an animation effect to text or objects
            • More about animating text and objects in PowerPoint
            • Animating text bullets
            • Applying multiple animation effects to a single object
            • Viewing a list of animations currently on the slide
            • Setting the effect options, timing, or order for an animation
            • Animating a SmartArt graphic
            • Applying a motion path to text or an object
            • Copy animation
            • Remove an Animation Effect
          9. Presenting a Slide Show
            • Using keyboard shortcuts to deliver your presentation
            • Starting a slide show presentation
            • Viewing your speaker notes as you deliver your slide show
            • Create a basic custom show
            • Start a custom show
            • Creating a self-running presentation
            • Using the Office Presentation Service
          10. Screen Recording
            • Start Screen Recording
          11. Export PowerPoint
            • Save presentation as video
            • Package Presentation for CD

          Duration: One day / 6 hours


          What's New in Microsoft Office 2016 (CSC545)

          Course Outline:

          1. Common New Features for MS Office 2016
            • Change the look and feel of Office 2016 for Windows with Office themes
            • Improved Version History
            • Do things quickly with Tell Me
            • Get insights into what you're working on with Smart Lookup
            • One Drive Integration
            • Skype Integration
            • Cross-Platform, Cross-Device
            • Draw and annotate with ink
            • Work together in real time
          2. What’s New in Microsoft Excel 2016
            • Do things quickly with Tell Me
            • Work together in real time
            • Insights into what you're working on
            • Improved version history
            • Simpler sharing
            • Faster shape formatting
          3. What’s New in Microsoft Excel 2016
            • Six new chart types
            • Get and transform (Power Query)
            • One click forecasting
            • PivotTable enhancements
            • Multi-select slicer
            • Quick Shape Formatting
            • Insert pictures with the correct orientation
            • Insights into what you're working on
            • New themes
          4. What’s New in Microsoft PowerPoint 2016
            • Real Time Presence
            • Ink Annotation
            • Morph Transition
            • PowerPoint Designer
            • Ink Equations
            • Screen recording
          5. What’s New in Microsoft Access 2016
            • Export linked data source information to Excel
            • Templates get a modern look and feel
            • Larger Show Table dialog
          6. What’s New in Microsoft Outlook 2016
            • Browse and create groups from the ribbon
            • Archive (Office 365)
            • Email attachments
            • Outlook 2016 Groups (Office 365 work or school account)
            • Search
            • Use Clutter to sort low priority messages

          Duration: 3 hrs


          Introduction to Windows 10 (CSC546)

          Date: 18 Oct 2017 (Wed)
          Time: 14:15 p.m. - 17:15 p.m
          Venue: AC2- 5506
          Date: 27 Dec 2017 (Wed)
          Time: 09:30 a.m. - 12:30 p.m
          Venue: AC2- 5607

          This training course is designed to give users of Windows 10

          After finishing the course, participants are able to Use the New Functions in Windows 10.

          Course Outline:

            Introducing Windows 10
            • The New Welcome Screen
            • Logging on, Power Options and Windows Hello
            • Locking the PC and Signing Out
            New Features of Windows 10
            • The New Start Menus
            • Accessing Apps and Working With Windows Snap
            • Pinning Applications and Jump Lists to Customize The Interface
            • Searching for Applications, Files and The Internet Using Cortana
            Working with Files and Folders
            • The Improved File Explorer
            • Navigating The Device Using The Address Bar and Breadcrumbs
            Suite-wide Enhancements in Office 2016
            • Explore the New User Interface
            • Use the Tell Me Assistant
            • Format Shapes with Additional Shape Styles
            • Write Math Equations With Pen and Ink
            • Look Things Up with a Track Pad

          Prerequisites

          Basic to intermediate knowledge of Windows

          Duration:3 Hours (1 session - 3 hours per session)


        What-if Analysis in Microsoft Excel 2016 (CSC547)

        Date: 6 Dec 2017 (Wed)
        Time: 09:30 a.m. - 17:15 p.m
        Venue: AC2- 5506

        Course Outline:

        1. Working with Goal Seek
          • How Does Goal Seek Work?
          • Running Goal Seek
          • Optimizing Product Margin
          • A Note About Goal Seek's Approximations
          • Performing a Break-Even Analysis
          • Solving Algebraic Equations
        2. Working with Scenarios
          • Understanding Scenarios
          • Setting Up Your Worksheet for Scenarios
          • Adding a Scenario
          • Displaying a Scenario
          • Editing a Scenario
          • Merging Scenarios
          • Generating a Summary Report
          • Deleting a Scenario
        3. Solving Complex Problems with Solver
          • Some Background on Solver
          • Loading Solver
          • Using Solver
          • Adding Constraints
          • Saving a Solution as a Scenario
        4. Setting Other Solver Options
          • Selecting the Method Solver Uses
          • Controlling How Solver Works
          • Working with Solver Models
          • Making Sense of Solver's Messages
          • Displaying Solver's Reports
        5. Calculate Multiple Results by using a Data Table
          • Data Table Basics
          • Create a one-variable Data Table
          • Add a Formula to a one-variable Data Table
          • Create a two-variable Data Table
          • Speed up Calculation on a Worksheet that contains Data Tables
        6. Apply Data Validation to Cells
          • Overview of Data Validation
          • How to handle a Data Validation Alert
          • Add Data Validation to a Cell or Range
          • Adding other types of Data Validation
        7. Consolidate Data from Multiple Worksheets in a Single Worksheet
          • Consolidate Data by Position
          • Consolidate Data by Category
          • Use a Formula to Consolidate Data
        8. Create an Excel Table in a Worksheet
          • Create a Table in the Style you want
          • Filter Data in an Excel Table
          • Use Structured References in Excel Table Formulas
          • Convert a Table to a Range
          • Delete an Excel Table in a Worksheet
        9. Split Text into different Cells
          • Applying Text to Columns
        10. Use a Formula to apply Conditional Formatting
          • Create conditional formatting rules with formula
          • Remove Conditional Formatting
          • Find and Remove the same Conditional Formats throughout a Worksheet
        11. Sorting and Filtering Data by Color
          • Overview of Sorting and Filtering Data by Color and Icon Set
          • Using Color effectively when Analyzing Data
          • Choosing the best Colors for your needs
          • Walking through some Examples

        Duration: One day / 6 hours

        Prerequisites: Basic knowledge of Microsoft Excel


        Booklet Creation with Microsoft Word 2016 (CSC548)

        Date: 30 Aug 2017 (Wed)
        Time: 09:30 a.m. - 17:15 p.m
        Venue: AC2- 5506

        Course Outline:

        1. Creating and Formatting Documents
          • Creating a new document using a template
          • Customizing the Page Layout
          • Print settings for booklets
          • Changing the line and paragraph spacing
          • Defining a new multilevel list
          • Adding watermark to your document
        2. Using Cover Page
          • Adding or removing a Cover Page
        3. Adding a Page Break
          • Adding and viewing page breaks
          • Adjusting automatic page breaks
        4. Adding Section Breaks
          • What you can do with sections
          • Types of section breaks
        5. Creating Newsletter-Style Columns
          • Applying columns to your document
          • Inserting a line between columns
          • Adjusting the column width and the spacing between columns
          • Inserting a column break
        6. Adding Headers and Footers
          • Adding a header or footer
          • Adding images to a header or footer
          • Deleting a header or footer from a single page
          • Inserting the file name in a footer
        7. Adding Page Numbers
          • Adding page numbers to header or footer
          • Adding different page numbers or number formats to different sections
          • Add page number X of Y to a document
          • Creating different headers or footers for odd and even pages
          • Deleting page numbers
        8. Creating or Editing a Hyperlink
          • Linking to a file, Web page, or blank email message
          • Turning off automatic hyperlinks
          • Adding Bookmarks
          • Bookmark the location
          • Go to the bookmark
          • Creating a hyperlink to a specific place in a document
        9. Adding Footnotes and Endnotes
          • Adding a Footnote
          • Adding an Endnote
          • Customizing Footnotes and Endnotes
          • Converting all footnotes or endnotes
          • Deleting a Footnote or an Endnote
        10. Adding a Table of Contents
          • Creating a Table of Contents
          • Formatting or customizing a Table of Contents
          • Changing or adding levels in a Table of Contents
          • Updating a Table of Contents
          • Removing a Table of Contents
        11. Creating an Index
          • Marking the Index Entries
          • Inserting the Index
          • Inserting Images & Graphics
          • Inserting pictures
          • Picture enhancement
          • Inserting a Screenshot or Screen Clipping
          • Learn about SmartArt Graphics
          • Creating a SmartArt graphic and add text to it
          • Inserting or changing the shape of WordArt
          • Adding shapes
          • Inserting symbols
          • Creating and removing a Drop cap
        12. Reviewing a Document
          • Tracking changes in Word
          • Accepting /Rejecting tracked changes
          • Removing tracked changes
          • Advanced Track Changes Options
          • Keeping Track Changes on with a password
          • Turning off track changes
          • Spelling and grammar check
          • Choosing how spell check and grammar check work
          • Adding words to your spell check dictionary

        Duration: One day / 6 hours


        Data Analysis with Microsoft Excel 2016(CSC549)

        Date: 12 Jul 2017 (Wed)
        Time: 09:30 a.m. - 17:15 p.m
        Venue: AC2- 5506

        Course Outline:

        1. Using Flash Fill
          • Turn Flash Fill on in Excel 2016
          • Start Flash Fill manually
          • Split A Column Of Data Based On What You Type
          • Capitalization
          • Dealing with middle names
        2. Split Text into Different Cells
          • Applying Text to Colunm
        3. Use AutoFilter to Filter your Data
          • Filter a range of data
          • Remove a filter
          • Filtering data by icon set
        4. Filter by using Advanced Criteria
          • Overview
          • Multiple criteria, one column, any criteria true
          • Multiple criteria, multiple columns, any criteria true
          • Multiple sets of criteria, one column in all sets
          • Multiple sets of criteria, multiple columns in each set
          • Wildcard criteria
        5. Insert Subtotals in a List of Data in a Worksheet
          • Inserting subtotals
          • Removing subtotals
        6. Outline (Group) Data in a Worksheet
          • Create an outline of rows
          • Create an outline of columns
          • Show or hide outlined data
          • Customize an outline with styles
          • Copy outlined data
          • Hide or remove an outline
          • Create a summary report with a chart
        7. Database Functions
          • DSUM
          • DAVERAGE
          • DCOUNT & DCOUNTA
          • DMAX & DMIN
        8. Lookup and Reference Functions
          • Using VLOOKUP to Find Data
          • Limit the VLOOKUP Value for Exact Match
          • Using the Closest Match for the VLOOKUP Value
          • HLOOKUP
          • INDEX
          • MATCH
          • LOOKUP function
        9. Logical Function
          • IF
          • AND
          • OR Function
        10. Introduce Table
          • Create And Use Table
          • Quick Summary Using Total Row
          • Remove Duplicate in Table
          • Notation in Table When Writing Formula
        11. Ensure Data Correctness By Validation
          • Different Type Of Data Validation
          • Creating A Drop Down List For Entry
          • Providing An Input Message
          • Changing Alert Type For Allowing Exception
        12. Using PivotTables/ Pivot Chart to Analyze & Present your Data
          • Create a Recommended PivotTable
          • Create a PivotTable Manually
          • Filter data in a PivotTable
          • Change the data layout of a PivotTable
          • Change how subtotals and grand totals are show
          • Update (refresh) data in a PivotTable
          • Create a PivotChart
          • Create a PivotChart for an existing PivotTable
        13. Applying Conditional Formatting
          • Adding, changing conditional formats
          • Change conditional formats
          • Clear conditional formats
          • Apply conditional formatting to quickly analyse data

      Duration: One day / 6 hours

      Prerequisites: Basic knowledge of Microsoft Excel


      Building Professional Charts with Microsoft Excel 2016 (CSC550)

      Date: 27 Dec 2017 (Wed)
      Time: 14:15 p.m. - 17:15 p.m
      Venue: AC2- 5607

      Course Contents:

      1. Creating a basic chart
        • Understand Charting Purpose
        • Getting a know the elements of a chart
        • Available chart types
        • Arrange data for charts
        • Ways to create charts
      2. Modifying and formatting chart
        • Change the layout or style of a chart
        • Add or remove titles or data labels
        • Show or hide a legend
        • Display or hide chart axes or gridlines
        • Move or resize a chart
        • Save a chart as a template
      3. Capture Attention To Data
        • Create Data Series For Chart
        • Add, Delete, Modify Chart Series
        • Series Naming
        • Plotting Order
        • Display Partial Data Range Only
        • Source Data From Multiple Worksheets
        • Handle Missing Data
        • Hidden Data Series
        • Convert Data Series
  • More chart designing and formatting techniques
    • Create a combo chart with a secondary axis
    • Change the plotting order of categories, values or data series
    • Change the scale
    • Auto growing Excel charts (Excel Table)
  • Get started with 3D Maps
    • Change the look of your 3D Maps
    • Export a 3D Maps tour as a video
  • Analyzing trends in data using Sparklines
    • Add a sparkline chart
    • Format a Sparkline Chart
    • Customize a sparkline chart
  • Distinctive Showcases Of Conditional Formatting
    • Key Performance Indicators (KPIs)
    • Signal on Strength and Weakness
    • Traffic Light
    • Arrow

    Duration:half-day / 3 hours


     


    Enhancing PowerPoint Presentations with Multimedia Elements (CSC551)

    Date: 1 Nov 2017 (Wed)
    Time: 09:30 a.m. - 17:15 p.m
    Venue: AC2- 5506

    Business or sales presentations are unlikely to be appealing without the help of Microsoft PowerPoint. The phenomenon is more obvious now as digital multimedia have become more readily available. PowerPoint slides can now be easily enriched with sound, voices, graphics, photographs, video clips, Flash movies, animation, etc. The multimedia elements help make your presentations more informative, easier to understand besides more interesting. In this short but effective course you will learn the techniques to enhance your PowerPoint presentations with a variety of multimedia elements.

    Course Outline:

    1. Insert WordArt
      • Customize WordArt
      • Change the fill and outline color of WordArt text
      • Create curved or circular WordArt, and add other text effects
      • Rotate or flip WordArt text
      • Change the font of WordArt text
    2. Add online pictures or clip art to your file
      • Using Online Picture
    3. Reduce the file size of a picture
      • Change the resolution of a picture
      • Set default picture resolution for all pictures in a document
      • Compress a picture
      • Delete cropped areas of a picture
      • Delete all picture editing data
    4. Working with Pictures
      • Editing photos without Picture Manager
      • Change the brightness, contrast, or sharpness of a picture
      • Change the color intensity of a picture
      • Apply an artistic effect to a picture
      • Add or change an effect for a picture
      • Recolor a picture
      • Crop a picture or place it in a shape
    5. Create and share a photo album
      • Start creating your photo album by adding pictures
      • Add captions to pictures
      • Change the look of a picture
      • Share your photo album with others
    6. Create an organization chart using SmartArt Graphics
      • Create an organization chart
      • Create an organization chart with pictures
      • Add or delete boxes in your organization chart
      • Change the hanging layout of your organization chart
    7. Learn more about SmartArt Graphics
      • Overview of SmartArt graphics
      • What to consider when choosing a layout
      • About the Text pane
      • Style, color, and effects for SmartArt graphics
      • Animation for SmartArt graphics
    8. Add Audio to your presentation
      • About adding audio
      • Add audio
      • Preview an audio clip
    9. Insert or link to a video stored on your PC
      • Insert a video stored on your PC
      • Link to a video stored on your PC
      • Trim a Video
    10. Insert or link to a video on YouTube
      • Insert Online Video
    11. Apply an animation effect to text or objects
      • More about animating text and objects
      • Change or remove animation effects
      • Animate text and objects with motion paths
      • Change animation order, speed, or how it starts
      • Change the object or text color after an animation plays
    12. Apply custom and advanced animation effects
      • Applying multiple animation effects to one object
      • Applying a motion path animation
    13. Add or remove transitions between slides
      • Add a transition to a slide
      • Remove a transition
      • Troubleshooting
    14. Set the speed and timing of transitions
      • Set the speed of a transition
      • Set the timing of a transition
    15. Record your Slide Show in PowerPoint
      • Record your slide show
      • Preview the recorded slide show
      • Preview the audio narration
      • Set the slide timings manually
      • Turn your narrations, ink, and laser pointer off
      • Turn slide timings off
    16. Save your Presentation as a Video
      • Save your presentation as a video
      • Guidelines for saving your presentation as a video
      • What parts of a presentation are not included in a video?
    17. Save your Presentation to a CD
      • Package Presentation for CD
    18. Create a Self-Running Presentation
      • Set up a self-running presentation
      • Rehearse and record slide timings
      • Add narration or sound

    Duration:1 day / 6 hours


    Adobe Fireworks CS6 - Introduction (CSC552)

    Date: 21 Mar 2017 (Tue)
    Time: 09:30 a.m. - 17:15 p.m
    Venue: AC2- 5506

    Course Outline:

    1. Getting to know the workspace
      • The Interface
      • Preparing the canvas
      • Using the Tools panel
      • Using the Property inspector
    2. Working with Bitmap Graphics
      • Resolution and file size
      • Cropping an image
      • Managing images on the canvas
      • Hiding and locking objects
      • Distortion-free bitmap scaling
      • Adjusting tonal range
      • Applying the Unsharp Mask Live Filter
    3. Working with Selections
      • About selecting objects and selection tools
      • Bitmap selection tools
      • Selecting and modifying with the Magic Wand tool
      • Using the Magic Wand tool with keyboard modifiers
      • Selecting with the lasso tools
      • Converting a selection to a path
    4. Working with Vector Graphics
      • About vectors
      • Basic vector drawing techniques
      • Resizing vectors
      • Changing the appearance of basic vector shapes
      • Distortion-free vector scaling with the 9-slice Scaling tool
      • Adding text to your design
      • Understanding paths and the Pen tool
      • Editing paths
      • Customizing fills and strokes
      • Customizing the stroke
    5. Working with Text
      • Text basics
      • Creating a fixed-width text block
      • Editing text
      • Flowing text within a vector shape
      • Anti-aliasing
      • Special text effects
      • Using text as a mask
      • Adding Live Filters to a masked object

    Duration: One day

    Pre-requisite(s):


    Adobe Fireworks CS6 - Advanced (CSC553)

    Date: 29 Mar 2017 (Wed)
    Time: 09:30 a.m. - 17:15 p.m
    Venue: AC2- 5506

    Course Outline:

    1. The Layers Panel
      • About layers
      • Identifying objects
      • Naming objects
      • Rearranging objects within a layer
      • Moving objects from one layer to another
      • Protecting layers
    2. Masking
      • About masks
      • Designing the banner ad
      • Editing gradient colors
      • Editing gradient direction and angle
      • Creating and editing masks
      • Converting a bitmap selection to a mask
      • Editing a bitmap mask
      • Applying Live Filters to a masked image
      • Adding the silhouette
    3. Optimizing for the Web
      • Optimization basics
      • Web graphic formats
      • About the Optimize panel
      • Optimizing a single image file
      • Working with previews
      • Choosing optimization settings
      • Exporting the file
      • Creating and optimizing slices
      • Creating slices manually with the Slice tool
      • Adding interactivity
      • Exporting composite designs
    4. Using Symbols
      • What are symbols?
      • Graphic symbols
      • The universal Common Library
      • Adding a graphic symbol to a document
      • Button symbols
      • Adding more buttons
      • Testing rollovers
      • Completing the design
      • Animation symbols
    5. Prototyping Basics
      • Exploring the Pages panel
      • Master pages
      • Comparing page designs
      • Page stacking order
      • Creating a master page
      • Adding more pages
      • Creating a secure, interactive PDF

    Duration: One day


    Microsoft PowerPoint 2016 - Introduction (CSC554)

    Course Outline:

    1. Getting Started with PowerPoint 2016
      • What is PowerPoint?
      • Viewing the PowerPoint Window
      • Working with the Ribbon
      • Open Dialog Box
      • Adding or removing commands to the Quick Access Toolbar
    2. Creating a basic PowerPoint presentation
      • Choosing the right view for the task in PowerPoint 2016
      • Views for creating your presentation
      • Views for delivering and viewing a presentation
      • Creating a PowerPoint 2016 presentation
      • Adding text to placeholder
      • Adding, rearranging, and deleting slides
      • Saving your presentation file
      • Saving as PDF format
      • Recovering unsaved presentation
    3. Understanding Slide Layout
      • What is slide layout?
      • Applying a layout to a slide
      • Changing the size of your slides
    4. Understanding Theme
      • Overview of Office themes
      • Selecting Theme
      • Theme Colors
      • Theme Fonts
      • Theme Effects
    5. Working with text
      • Managing text in a placeholder by using AutoFit
      • Formatting Font
      • Formatting Paragraph
      • Splitting your text into Columns
      • Using Bullet and number list
      • Inserting WordArt
      • Copying and pasting your slides
      • Copying format using the Format Painter
      • Clear all text formatting
      • Checking Spelling
      • Finding and replacing text
    6. Using Slide Master?
      • What is a slide master?
      • Creating or customizing a slide master
    7. Working with Tables
      • Adding a table to a slide
      • Changing the look of a table
      • Formatting a Table
    8. Working with Shapes
      • Adding shapes
      • Selecting a shape or other object
      • Adding a shape fill or effect
      • Moving a text box, WordArt, or shape
      • Grouping or ungrouping shapes, pictures, or other objects
      • Changing the size of a picture, shape, WordArt, or other object
      • Rotating a text box, shape, WordArt, or picture
    9. Using SmartArt
      • Overview of SmartArt graphics
      • What to consider when choosing a layout
      • Creating a SmartArt graphic
      • About the Text pane
      • Converting slide text to a SmartArt graphic
      • Changing the colors of an entire SmartArt graphic
    10. Working with Graphics
      • Inserting Pictures
      • Working with pictures
      • Inserting a screenshot or screen clipping
    11. Slide Transitions
      • Adding a transition to a slide
      • Removing transition Effect
    12. Applying an Animation Effect
      • Applying an animation effect to text or objects
      • More about animating text and objects in PowerPoint 2016
      • Animating text bullets
      • Animating a picture on your slide
      • Removing an Animation Effect
    13. Presenting a Slide Show
      • Using keyboard shortcuts to deliver your presentation
      • Starting a slide show presentation
    14. Printing Presentation Slides
      • Printing your handouts, notes, or slides
      • Showing footer information on your slides
      • Changing the starting slide number

    Course Duration:1 day / 6 hours


    Microsoft Word 2016 - Introduction (CSC555)

    Course Outline:

    1. Getting Started with Word 2016
      • What is Word?
      • Exploring Word 2016
      • Customizing the Quick Access Toolbar
      • Customizing the Word Environment
      • Using the Status Bar
    2. Creating and Opening Documents
      • Creating a Blank Document
      • Creating a new document using a template
      • Opening an Existing Document
      • Keeping a file on the recently used files list
      • Converting a document to the Word 2016 mode
    3. Saving and Closing Document
      • Saving a Word document
      • Saving a document in another file format
      • Saving Word 2016 document for compatibility with earlier versions of Word
      • Converting a document to PDF
      • Opening and Editing PDF content in Word
      • Recovering unsaved document
      • Closing a document
    4. Creating Content
      • Inserting Content Using Quick Parts
      • Inserting a Cover Page
      • Inserting symbol
      • Inserting text automatically
    5. Selecting Techniques
      • Moving Around the document
      • Selecting Text
      • Copying and moving items
      • Using the Office Clipboard
      • Undo, redo, or repeat an action
    6. Finding and Replacing
      • Finding text or other document content
      • Replacing text
    7. Formatting Text & Paragraph
      • Applying Character Formatting
      • Creating a large dropped initial capital letter
      • OpenType options in the Font dialog box
      • Align text left or right, center text, or justify text on a page
      • Creating a first line indent
      • Creating a hanging indent
      • Change the line spacing
      • Creating and changing a bulleted or numbered list
      • Copy formatting using the Format Painter
    8. Controlling Page Appearance
      • Inserting Page Break
      • Removing Page Break
      • Inserting Section Break
      • Inserting & deleting Page Numbers
      • Creating & deleting Header/Footer
      • Inserting, changing or Removing Watermark
    9. Document Page Setup
      • Setting page margins
      • Changing the orientation of your entire document
      • Changing the paper size of your entire document
    10. Tables
      • Inserting a Table
      • Designing a Table
      • Formatting a Table
      • Deleting a Table
      • Converting text to a table or a table to text
    11. Working with Graphics
      • Inserting Pictures
      • Working with pictures
      • Inserting a screenshot or screen clipping
      • Inserting online Video
      • Drawing shape
      • Creating SmartArt
      • Create an organization chart with pictures
    12. Proofing a Document
      • Changing the language of a document
      • Checking Spelling and Grammar
      • Recheck the words and grammar that you previously checked and chose to ignore
      • Translating text in a different language
      • Smart Lookup
    13. Printing and previewing a Document

    Course Duration:1 day / 6 hours


    Adobe Acrobat DC Pro - Overview (CSC556)

    Date: 16 Jan 2017 (Mon)
    Time: 09:30 a.m. - 12:30 p.m
    Venue: AC2- 5506

    Course Outline:

    1. Introduction of Acrobat DC & Document Cloud
    2. Demo of Acrobat DC New Features
      • eForm Workflow
      • Mobile Apps
    3. Useful Tips and Tricks
      • Editing PDF Documents
      • Saving as Word/Excel/PowerPoint
      • Optical Character Recognition
      • PDF Protection
      • Collecting & Reviewing Comments
      • Comparing PDF Documents
      • PDF Portfolios
      • PDF Techniques for Web Accessibility

    Course Duration:1/2 day / 3 hours


    Microsoft Access 2016 - Advanced(CSC557)

    Course Outline:

    1. Access Options Settings
      • Changing Default Program Options
      • Enable Active Content
    2. Import and Export Data
      • Import/Export Excel Data
      • Import/Export Another Access Database
      • Import/Export Text File
    3. Database Relationship
      • Types of table relationships
      • Why create table relationships?
      • Understanding referential integrity
      • Set the join type
    4. Validation Rule
      • Overview
      • Types of Validation Rules
      • Where you can use validation rules
      • What you can put in a validation rule
      • Add a validation rule to a table
    5. Select Query
      • Review data from select fields
      • Examples of criteria for Text fields
      • Examples of criteria for Number and Currency fields
      • Examples of criteria for a Yes/No field
      • Examples of using dates as criteria in Access queries
      • Examples that use the current date in their criteria
      • Examples that work with a date or range of dates other than the current date
      • Queries that filter for null (missing) or non-null dates
    6. Create a totals query
    7. Use parameters to ask for input when running a query
      • Add a parameter to a union query
      • Combine parameters with wildcards for more flexibility
      • Return items that don’t match the parameter
      • Specify parameter data types
    8. Crosstab query techniques
      • Overview
      • Create a crosstab query manually in Design view
      • Display row totals
      • Display zeros (not blanks)
      • Handle parameters
      • Specify column headings
      • Multiple sets of values
    9. Updating records by using queries
      • Create a make table query
      • Create an append query
      • Create an update query
      • Create a delete query
    10. Use a union query to combine multiple queries into a single result
      • Tips for using union queries
    11. Create Custom Form
      • Modifying forms created by using a wizard
      • Create a Form using Form Wizard
      • Adding controls
      • Displaying subforms
    12. Create Custom Reports
      • Creating reports manually
      • Adding hyperlinks, charts, and buttons
      • Modifying report content
      • Layouts
      • Add Page Numbers
      • Adding Subreports
    13. Protect Databases
      • Assigning passwords to databases
      • Splitting databases
      • Securing databases for distribution
    14. Normalize your data using the Table Analyzer
    15. Create a macro that runs when you open a database
      • Create an AutoExec macro

    Course Duration:6 hours


    Office Collaboration with Google Drives & Google Form (CSC558)

    Date: 8 Nov 2017 (Wed)
    Time: 09:30 a.m. - 17:15 p.m
    Venue: AC2- 5506

    Course Outline:

    1. Get start with Google Drive
      • How to use Google Drive
      • System requirements and browsers
      • Use Google Drive files offline
      • Clear Google Drive space and increase storage
      • Get more storage space
    2. Store files in Google Drive
      • Upload files and folders to Google Drive
      • Download a file
      • Files you can store in Google Drive
      • View and open files
      • Back up photos and videos automatically in Google Drive
      • Store and play video in Google Drive
      • Save, edit & share Microsoft Office files
      • Save web content to Google Drive
      • Convert PDF and photo files to text
    3. Organize and find your files
      • Create a folder
      • Move a file or folder
      • Make a copy of a file
      • Delete a file or folder
      • Delete and restore files in Google Drive
      • Find or recover a file
      • Find files in Google Drive
      • More search options
      • Sort your files
      • View activity and file versions
      • Change notification settings
    4. Share file to your computer
      • Choose what to share
      • Choose who to share with
      • Choose what people can do with your file
      • Stop, limit, or change sharing
      • Prevent others from sharing your files
      • More options with Google Accounts through work or school
      • Make someone else the owner of your file
      • Share folders in Google Drive
      • Change sharing permissions of shared folders
    5. Sync file to your computer
      • Install Google Drive on your PC
      • Change your sync settings
      • Stop syncing files between your computer & Google Drive
    6. Docs, Sheets, Slides and other apps
      • How to use Google Docs
      • Insert items
      • How to use Google Sheets
      • Add formulas and functions to a spreadsheet
      • Import data sets and spreadsheets
      • Format numbers in a spreadsheet
      • Protect, hide, and edit sheets
      • Edit sheets
      • Add a chart or graph to a spreadsheet
      • Set a spreadsheet’s location and calculation settings
      • How to use Google Slides
      • Create, edit, and customize slides
      • Change the size of your slides
      • See and use suggested layouts in a presentation
      • Use Google Drive apps
    7. Privacy, polices and offers
      • Google Drive Terms of Service
      • Abuse program policies and enforcement
      • Is Google Drive secure?
      • Purchase, cancellation, & refund policies
    8. Create, edit and format a Google form
      • How to use Google Forms
      • Delete or edit items
      • Randomly order questions and answers
      • Add a theme to a form
      • Show questions based on answers
      • Skip sections in your form
      • Share your form with collaborators
      • Send your form to people
      • Send the form
    9. Collect form responses
      • Collect form responses
      • Delete a form or responses
      • View and manage form responses
      • Manage responses
    10. Google Form Tools
      • Set rules for your form
      • Install and use add-ons in Google Forms
      • Turn add-ons on and off in Google Forms
      • Use add-ons in Google Forms
      • Uninstall add-ons in Google Forms

    Duration:1 day / 6 hours


    Webmaster Skills in Search Engine Optimizations (SEO)

    Course Outline:

    1. SEO Basics
      • Create unique, accurate page titles
      • Make use of the "description" meta tag
    2. Improving Site Structure
      • Improve the structure of your URLs
      • Make your site easier to navigate
    3. Optimizing Content
      • Offer quality content and services
      • Write better anchor text
      • Optimize your use of images
      • Use heading tags appropriately
    4. Dealing with Crawlers
      • Make effective use of robots.txt
      • Be aware of rel="nofollow" for links
    5. SEO for Mobile Phones
      • Notify Google of mobile sites
      • Guide mobile users accurately
    6. Promotions and Analysis
      • Promote your website in the right ways
      • Make use of free webmaster tools

      Duration:1 day / 6 hours


    Adobe InDesign CS6 – Introduction(CSC562)

    Date: 25 Oct 2017 (Wed)
    Time: 09:30 a.m- 17:15 p.m
    Venue: AC2-5506

    Course Outline:

    1. What’s new in CC/CS6
      • Alternate Layouts
      • Liquid Layouts
      • Linked Content
      • Digital Publishing
      • Interactivity
    2. Inside the InDesign Interface
      • Understanding Global and Local Control
      • Exploring the Document Window
      • Working with Panels and Docks
      • Working with Windows
      • Working with Views
    3. Creating, Opening, and Saving Documents
      • Setting Up a New Publication
      • Creating new documents
      • Opening Documents and Templates
      • Saving Documents and Templates
      • Export formats for whole documents
    4. Working with Styles
      • Creating styles
      • Modifying styles
      • Applying styles
      • Managing styles
      • Using style groups
      • Understanding predefined styles
      • Unapplying a style
    5. Using Ruler Guides and Grids
      • Ruler guides
      • Creating a set of guides automatically
      • Working with column guides
      • Working with the baseline grid
      • Working with the document grid
      • Snapping to guides
    6. Manipulating Objects
      • Selecting Objects
      • Selecting overlapping objects
      • Selecting multiple objects
      • Deselecting objects
      • Moving Objects
      • Creating Copies of Object
      • Deleting Objects
      • Preventing Objects from Printing
      • Hiding Objects
      • Aligning and Distributing Objects
      • Working with the Align panel
      • Working with live distribution
      • Working with smart guides
      • Working with smart spacing and measurements
      • Using the Gap Tool
    7. Transforming Objects
      • Resizing and Scaling Objects
      • Scaling methods
      • Performing Other Transformations
      • Rotating objects
      • Flipping objects
      • Using the Free Transform tool
      • Repeating Transformations
      • Replacing Object Attributes
    8. Orchestrating Objects
      • Stacking Objects
      • Combining Objects into a Group
      • Using groups within groups
      • Selecting objects within groups
      • Ungrouping
      • Locking Objects
      • Creating Inline Frames
      • Wrapping Text around Objects
      • Using the Text Wrap panel
      • Setting text-wrap
      • Changing the shape of a text wrap
    9. Graphics Fundamentals
      • Importing Graphics
      • reparing Graphics Files
      • Graphics embedded in text files
      • Issues with vector files
      • Issues with bitmap formats
      • Web-oriented bitmap formats
      • Using import options
      • Import options for vector file formats
      • Using other ways to import graphics
    10. Drawing Free-form Shapes and Curved Paths
      • Drawing Lines with the Pen Tool
      • Drawing Free-Form Shapes
      • Joining Paths
      • Working with Compound Paths
      • Examples of compound paths in use
    11. Text Fundamentals
      • Using the Type tool
      • Pasting text
      • Dragging and dropping text
      • Importing text with the Place dialog box
      • Import options for Microsoft Word and RTF files
      • Import options for text-only files
      • Import options for Microsoft Excel files
      • Import options for Tagged Text files
      • Flowing Text through a Document
      • Working with Text Frames
      • Creating text frames on master pages
      • Drawing additional text frames
      • Threading Text Frames
      • Threading frames and adding pages automatically
      • Breaking and rerouting threads
      • Adjusting Columns
      • Managing Other Text Frame Behaviors
      • Using the Story Editor
      • Correcting Spelling Mistakes
      • Searching and replacing text
      • Searching and replacing formatting
      • Changing fonts globally
      • Working with Notes
    12. Document Package and Output
      • Final preflighting before you package
      • Putting the package together
      • Setting Up Booklets
      • Printing Documents
      • The Setup pane
      • The Marks and Bleed pane
      • The Output pane
      • The Graphics pane
      • The Color Management pane
      • The Advanced pane
      • The Summary pane
      • Exporting to Interactive PDFs and E-Books
      • Exporting e-books

    Duration:1 day / 6 hours


    Adobe InDesign CS6 – Advanced

    Course Outline:

    1. Working with Pages
      • Working with Multipage Documents
      • Adding pages
      • Changing pages' sizes
      • Deleting pages
      • Copying and moving pages
      • Working across documents
      • Starting documents on a left page
      • Controlling page shuffling
      • Creating gatefold spreads
      • Working with page numbers
      • Dividing a document into sections
    2. Working with Layers
      • Creating layers
      • Working with individual objects on layers
      • Manipulating entire layers
    3. Creating Layout Standards
      • Creating and Applying Master Pages
      • The Pages panel
      • Creating a new master page
      • Importing a master page
      • Laying out a master page
      • Applying a master page to document pages
      • Modifying master items on document pages
    4. Using Templates
      • Creating templates
      • Modifying templates
      • Creating documents from templates
    5. Defining Colors, Tints, and Gradients
      • Defining Color Terms
      • Identifying methods of color printing
      • Mixing spot and process colors
      • Converting spot color to process color
      • Working with Color Models
      • Creating colors the ideal way: The Swatches panel
      • Using Kuler to add to your color swatches
      • Creating tints
      • Mixing color swatches to create more colors
      • Working with Gradients
      • Creating unnamed gradients
      • Adjusting gradient angle and location
      • Applying Colors, Tints, and Gradients
    6. Object Fundamentals
      • Adding Frames, Shapes, and Lines
      • Creating a Text Frame
      • Creating a Graphics Frame
      • Converting Frames for Specific Content
      • Drawing Straight Lines
    7. Applying Effects to Objects
      • Working with Strokes
      • Creating stroke styles
      • Applying Corner Options
      • Applying Lighting Effects
      • Using the Effects panel and related controls
      • Applying transparency
      • Applying drop shadows and inner shadows
      • Applying feathering
      • Applying outer and inner glows
      • Applying beveling and embossing
      • Applying satin effects
    8. Defining and Applying Object Styles
      • Creating object styles
      • Applying object styles
      • Managing Links
      • Menu options for managing links
      • Menu options for managing link information
      • Panel Options dialog box
    9. Fitting Graphics and Frames Together
      • Fitting Graphics within Their Frames
      • Resizing a graphic's frame
      • Moving a graphic in its frame
      • Using an irregular frame
      • Figuring Out the Fitting Commands
      • Working with Clipping Paths
      • Creating a clipping path in InDesign
    10. Specifying Character and Paragraph Attributes
      • Setting character attributes
      • Setting paragraph attributes
      • Adding Automatic Bullets and Numbered Lists
      • End-of-Story Markers
      • Making text follow a path
      • Using the Glyphs panel
    11. Setting Up Tabs and Tables
      • Using the Tabs Panel
      • Tab ruler
      • Creating a table
      • Working with cells
      • Using table and cell styles
      • Converting Tabs to Tables
      • Working with Footnotes
      • Creating Tables of Contents
    12. Document Package and Output
      • Final preflighting before you package
      • Putting the package together
      • Setting Up Booklets
      • Printing Documents
      • The Setup pane
      • The Marks and Bleed pane
      • The Output pane
      • The Graphics pane
      • The Color Management pane
      • The Advanced pane
      • The Summary pane
      • Exporting to Interactive PDFs and E-Books
      • Exporting e-books

    Duration:1 day / 6 hours


    Analyze your Site Performance using Google Analytics

    Course Outline:

    1. Getting started with digital analytics
      • The importance of digital analytics
      • Core analysis techniques
      • Conversions and conversion attribution
      • Creating a measurement plan
    2. Understanding and using Google Analytics
      • How Google Analytics works
      • Key metrics and dimensions defined
    3. Collecting actionable data with Google Analytics
      • Creating an account
      • Understanding your account structure
      • Setting up basic filters
      • Setting up goals and ecommerce
      • Collecting campaign data
    4. Navigating Google Analytics reports
      • Reporting overview
      • Audience reports
      • Acquisition reports
      • AdWords reports
      • Behavior reports
      • Custom reports and dashboards

    Duration:1 day / 6 hours


    Essential of WordPress & Content Management System

    Course Outline:

    1. Why WordPress?
    2. Content Management Systems vs Traditional Website
    3. Install your first WordPress
    4. Wordpress.com vs self-hosted WordPress
    5. Dashboard
    6. Page Settings
    7. Editing Pages and Posts
    8. Adding medias
    9. Install Themes
    10. Theme options
    11. Get useful Plugins
    12. Plugin settings
    13. Create

    Duration:1 day / 6 hours



    Social Media & Facebook Marketing Trends

    Course Outline:

    1. Social Media in Digital Marketing position
    2. Feed content
    3. Audience and category breakdown
    4. Start from Fans Page
    5. Create useful posts, activities and promotion
    6. Get more attention
    7. Facebook ads
    8. Content Marketing
    9. Key opinion leader
    10. Review and improve Facebook marketing performance

    Duration:1 day / 6 hours


    Visual Design for PowerPoint Presentations(CSC560)

    Date: 26 Jul 2017 (Wed)
    Time: 09:30 a.m- 17:15 p.m
    Venue: AC2-5506

    Upon Completion of this course, Participants will be able to apply visual design concepts, skills and resources into PowerPoint presentationp

    Course Outline:

    Create Your Own Visual Presentation
    • Create Your Own Masters by Change Layout
    • Remove Placeholders to customize a Layout
    • Add Watermark
    • Add Slide Number in Slides
    • Replace All Instances of a Font in Presentation
    • Make a Document Theme the Default for New Presentations
    • Create Unique Bullets Points From Your Own Custom Graphics
    • Create a Custom Slide Theme
    • Change the Layout of Existing Slide
    • Insert a Custom Background Image
    Add Impact with Graphics
    • Communication Information with SmartArt Graphic
    • Add connector Lines to Objects
    • Emphasize Image with Border
    • Attract Attention by Crop Images
    • Compress Graphics to Make Presentations Load Faster
    • Use Photo Album to display Pictures
    • Blend Graphics into Background
    • Add Text to Shapes
    • Apply 3-DRffects to Make Graphics Stand Out
    • Align Graphics Perfectly Using the Grid and Guidelines
    Use Timesaving Tools
    • Add Word Outline into PowerPoint Presentation
    • Paste Slidesfrom Other Presentation
    • Copy Formatting from One Slide to Another
    • Translate Words from PowerPoint
    • Save Your Presentation into a PowerPoint Template
    Add Sizzle to Presentation with Effects
    • Highlight Graphics When You Use Custom Shadows
    • Create a Link to Elsewhere in the Presentation
    • Open a Documents with button
    • Add Motion to illustrate Your Content
    • Make and Entrance with Custom Animation
    • Orchestrate an Exit with Custom Animations
    • Choreograph Effects to Make a Multimedia Presentation
    • Give Your Presentation a Profession Look with Transition Effects
    • Enhance a Transition with a Sound Effect

    Prerequisites

    General knowledge of Windows and PowerPoint

    Duration:6 Hours (2 sessions – 3 hours per session)


    Microsoft Office 365 Overview

    Course Outline:

    1. OneDrive
      • Introduction OneDrive For Business
      • Sign In to OneDrive
      • Using OneDrive
    2. Common New Features for MS Office 2016
      • Office Theme
      • Tell Me
      • Smart Lookup
      • One Drive Integration
      • Skype Integration
    3. What’s New in Word 2016
      • Do things quickly with Tell Me
      • Work together in real time
      • Insights into what you're working on
      • Ink equations
      • Faster shape formatting
    4. What’s New in Excel 2016
      • Six new chart types
      • One click forecasting
      • PivotTable enhancements
      • Multi-select slicer
      • Quick Shape Formatting
      • Insert pictures with the correct orientation
      • New themes
    5. What’s New in PowerPoint 2016
      • Screen recording
      • Colorful, Dark Gray, and White Office Themes
      • Better video resolution
      • Improved Smart Guides
      • Quick Shape Formatting
    6. Working with OneNote 2016
      • Create a new notebook
      • Type or write notes in the browser
      • Add links
      • Insert pictures
      • Draw a table
      • Add more pages
      • Add more sections
      • Save your notes
      • Share OneNote notes online
      • Work together in a notebook

    Duration:1/2 day / 3 hours


    Enhance Communication using Skype for Business (CSC561)

    Date: 18 Oct 2017 (Wed)
    Time: 09:30 a.m- 17:15 p.m
    Venue: AC2-5506

    Course Outline:

    1. Enhance Communication using Skype For Business
      • Contacts and Conversations
      • Enterprise Voice Basics
      • Online Meeting Basics
      • Present Like A Pro
      • Record and Download Meeting Elements
    2. User Guide of Skype for Business in Mobile Devices

    Duration:1/2 day / 3 hours


    Microsoft Outlook 2016 and Exchange

    Course Outline:

    1. Setting Message Options
      • Specifying Email Format
      • Setting Message Flags, Importance, and Sensitivity
      • Configuring Voting Buttons, Receipts, and Delivery Options
      • The Message Options/Properties Dialog Box
      • Attaching Files and Items to a Message
      • Using Themes and Email Stationery
      • Adding a Signature
      • Sending Mail
      • Recalling a Message
      • Working with Received Email
    2. Managing Email
      • Using Quick Steps
      • Answering a Message
      • Forwarding a Message
      • Saving an Attachment
      • Deleting Messages
      • Printing Mail
      • Moving Email
    3. Using the Calendar for Appointments and Tasks
      • Navigating the Calendar
      • Scheduling an Appointment
      • Searching the Calendar
    4. Sharing Calendars
      • Creating a Calendar Share Invitation
      • Opening a Shared Calendar
      • Viewing Multiple Calendars
      • Emailing a Calendar
      • Publishing a Calendar Online
      • Setting Calendar Options
    5. Working with Tasks
      • Using the Task Folder
      • Creating a New Task from the Task Folder
      • Creating a Recurring Task
      • Assigning and Accepting Tasks
      • Viewing and Managing Tasks
      • Managing Tasks
      • Setting Tasks Options
    6. Working with Contacts and Planning Meetings
      • Navigating the Contacts List
      • Creating a New Contact
      • Editing Contact Information
      • Searching the Contacts Folder
      • Organizing Contacts with Groups
      • Forwarding and Sharing Contacts
      • Accessing Contacts on Social Networks
      • Communicating with Contacts
      • Contact Actions
      • Printing Contact Information
      • Setting Contact Options
      • Scheduling Meetings
      • Responding to Meeting Requests
    7. Creating Email Rules
      • Creating a Quick Rule for a Specific Sender
      • Creating Complex Rules
      • The Rule Wizard
      • Managing Rules
      • Archiving Outlook Items
      • Configuring an Autoreply Message
    8. Personal Folders
      • Introduction to Outlook Data Files (.pst and .ost)
      • Create an Outlook Data File (.pst)
      • Open an Outlook Data File (.pst)
      • Close an Outlook Data File (.pst)

    Duration:1/2 day / 3 hours


    csc@cityu.edu.hk