Syllabus

The IT Fluency Test requires students to:

  • Demonstrate the ability to access and use information effectively
  • Show an awareness of computer ethics and copyright issues
  • Demonstrate a basic understanding of operating a computer
  • Use computer applications for documentation, presentation, electronic communication and data management.

The IT Fluency Test is conducted in a dedicated computer lab and requires approximately 1 hour and 45 minutes. It consists of two parts:

  1. Multiple-choice questions
  2. Hands-on task-oriented questions

Test Syllabus

The IT Fluency Test covers:

A. Information Literacy

  1. Access of Information
  • Internet, WWW, newsgroup, search engine
  • Lingnan University Library – 1-Search Discovery Tool

2. Information Technology

  • ┬áBasic components of a computer, Operating System such as Windows

3. Economic, Legal, and Social Issues for Use of Information

  • Licensing, Software Piracy, Plagiarism, Privacy, Security, Intellectual Property, Copyright

B. IT Skill

1. Basic PC operation

  • Folder operation – create, copy, move, delete and rename
  • File operation – search, copy, move, delete and rename

2. Email/Webmail

  • Sending an email, attaching a file, and using cc and bcc

3. Communicating in integrated learning systems*

  • Downloading materials and submitting assignments

C. Word Processing: Use of MS Word *

1. File Saving

  • Create, save, print and print preview a MS Word file

2. Formatting

  • Font style and size, alignment, bullet and numbering

3. Inserting

  • Different kinds of charts, table, header and footer, page number, pictures/clip art and symbol

4. Page set up

  • Margin, indent and spacing

5. Reviewing

  • Spell and grammar checking

 

D. Spreadsheet: Use of MS Excel*

1. File Saving

  • Create, save, print and print preview a MS Excel file
  • Layout of a worksheet, row and column

2. Formatting

  • Number format, insert & delete of rows & columns

3. Inserting

  • different kinds of chart

4. Use of Formulas

  • Use of built-in functions (sum, average, max, min)
  • Use of a formula in a cell for calculation (e.g. =A1+B1)
  • Relative cell addressing, i.e. copy & paste of formula
  • Insert functions

5. Sorting data

 

E. Presentation: Use of MS PowerPoint*

1. File Saving

  • Create, save, print and print preview a MS PowerPoint file
  • Create new slides, slide layout and delete slides

2. Inserting

  • Table, picture, clip art, chart, textbox, header and footer, and media clip (movie & sound)

3. Design Theme

*Remarks: The syllabus covers the application of the latest software versions in line with those installed in computer labs and the Library.

 

In Archive