Department of Computer Science

Hong Kong Baptist University

¡@

Self-learning Corner

¡@

Objective

To provide students the opportunity to self-learn some software packages which are commonly used in the workplaces. After going through the material, you are expected
(1) to be able to get started with those software packages,
(2)
to appreciate its usefulness, and
(3) to be able to use it to accomplish some related tasks.

Note that the material is prepared with the assumptions that
(1) you have some exposure to Windows-based and Linux-based platforms, and
(2) you have some basic understanding of the computing environment provided by the Department and the University.

Also, they are just starting points helping you to take off. You will need to refer to other related books and on-line resources in order to further enhance your competency in making the best of those packages.

More information about the computing environment at HKBU, you are referred to the ITSC website

For learning MS Office applications, go to module (1).
For learning photo and animation editing software, go to module (2).
For learning web page authoring and how to set up a web site, go to module (3).
For learning web programming and database development, go to module (4).
¡@

Where to locate the software

¡@ Software Location Partition
Module (1) MS Office 2003 *All Labs EWINXP
¡@ ¡@ ¡@ ¡@
Module (2) Photoshop CS3, Flash CS3 W802 EWINXP
¡@ ¡@ ¡@ ¡@
Module (3) Frontpage 2003, WinSCP   *All Labs EWINXP
¡@ ¡@ ¡@ ¡@
Module (4) PuTTY *All Labs EWINXP

* All labs : FSC701, FSC701B, FSC801C & D, FSC801 Open area, W802

¡@

Learning materials

Module 1: MS Office applications
¡@ Lab sheet Data files needed
Word Lab 1: Create Newsletter and Table of Contents Newsletter.doc , Toc.doc
¡@ ¡@ ¡@
Excel Lab 1: Absolute / Relative addressing, Sorting, Formula, Functions, Conditional Formatting, and so on excel-ex1.xls
Lab 2: Grade Point Average Calculation excel-ex2-GPA.xls
Lab 3: Comparison of Antibacterial Treatments excel-ex3.xls
¡@ ¡@ ¡@
Excel(VBA) Lab 1: Automate Administrative Tasks
using Excel Macros
vba1.xls
Lab 2: Working with Macro Codes ¡@
Lab 3: Simple VBA Programming vba3Supp.xls
¡@ ¡@ ¡@
Powerpoint Lab 1: Create a Multimedia Presentation ppt-datafile.zip
¡@ ¡@ ¡@
Access Lab 1: Creating Your First Database ¡@
Lab 2: Manage Your Data in a Smart Way  ¡@
Lab 3: Present Your Data in a Smart Way ¡@

¡@

¡@

Module 2 : Photo & Animation Editing
¡@ Lab sheet Data files needed
Photoshop Lab 1:  Basic manipulation of black and white images poem.psd
Lab 2: Photo Editing, Red-eye removal, Photomerge (Panorama View) photoshop2-datafile.zip
¡@ ¡@ ¡@
Flash Lab 1: Drawing, Painting, Frame-by-frame and Tweened Animation flash-ex1-ans.swf
Lab 2: Symbols, Instances, Shape Tweening and Motion Tweening skate.jpg , flash-ex2-ans1.swf , flash-ex2-ans2.swf
Lab 3: Motion Tweening along a Path and Spotlight Effect flash-ex3-lib.fla , flash-ex3-ans1.swf , flash-ex3-ans2.swf

¡@

¡@

Module 3 : Personal Webpage Setup
¡@ Lab sheet Data files needed
Webpage Lab 1: Authoring Web Pages Using MS FrontPage web1-datafile.zip
Lab 2: Uploading Web Pages Using WinSCP ¡@

¡@

 

Module  4 : Web Programming and Database Development
¡@ Lab sheet Supplementary notes
*Server-side Web programming Lab 1: Client-side /Server-side Web programming Lab 1 ppt , php_part1.pdf
Lab 2: PHP File Operation Lab 2 ppt , php_part2.pdf
Lab 3: Database Access with PHP Lab 3 ppt , php_part3.pdf 
Lab 4: Authentication database and using cookies Lab 4 ppt , php_part4.pdf 

*Student ,who wants to practise a server-side web programming, please send us an email at technical-support@comp.hkbu.edu.hk.
Then we will create the mysql acount for you.

¡@

Note: If you forget the password for downloading lab materials, please send us an email at technical-support@comp.hkbu.edu.hk.

¡@

¡@

¡@

¡@

¡@

¡@

~END~

Last Updated 21/5/09

¡@