Wednesday, July 27, 2011

Powerpoint Homework Exercise Due

Today is the due date for your Powerpoint homework exercise. Cut-off time will be 11:59 p.m. tonight.

Please sign and return an assignment submission form (to be distributed in class today). All submissions should be done online via the SOUL platform (http://www.soul.hkuspace.org).

If you are not able to attend class today, you can still submit the assignment online and sign the submission form the next time you attend class.

Ex4-4 Pivot Table Video Demonstration

Tuesday, July 26, 2011

Ex4-3 Pivot Table Video Demonstration

Ex4-2 Pivot Table Video Demonstration

There's a correction in this exercise - please rename the "Units Sold" column as "Units Bought" since the report is being produced for the purchasing department of Hibernian Hotel.

Tuesday, July 19, 2011

Powerpoint Tips


Guidelines for selecting font sizes for your text:
  1. Title font should be 28 to 32 point or larger.
  2. Level-1 bullet points and other body text should be 18 to 24 point or larger.
  3. Lower level bullet points should be 2 to 4 sizes smaller than the main text font, around 18 to 22 point.
  4. Secondary items such as chart axis labels or sources should be smaller but readable, around 16 point.
  5. Once you choose your font sizes, keep them consistent throughout the presentation.
Guidelines for selecting fonts for your text:
  1. Choose sans-serif fonts like Verdana and Arial as these fonts are the most readable onscreen.
  2. Choose italics for subtitles only, but do not use them for extended text.
  3. Use sentence case rather than ALL CAPS for your text.

Guidelines for choosing background colors:
  1. Use a solid color. Avoid using patterns, textures or graphics in your slides.
  2. Pick a dark cool color (blue, green, purple) or an off-white color (beige, taupe, light sage, light grey/blue, cream).
  3. For best visiblity, your background colors and text colors must contrast sharply. You have two general choices: dark background with light text, or off-white background with dark text.
Here's a link to color definitions with their hexadecimal and RGB codes.

500+Colors

Wednesday, July 13, 2011

Guestroom 20X

Guestroom20X is an exhibit shown in the annual HITEC conference. the world's largest hospitality technology conference.

Guestroom20X showcases new and upcoming technologies for the modern hotel room. You can find out more about these new hotel technologies at:

Guestroom 20x Web Site

Guestroom 20x Photo Gallery

Wednesday, July 6, 2011

Vote for your Favorite Smartphone App

Mobile apps or lightweight software running on mobile devices are another popular software trend nowadays.

The Hong Kong Wireless Technology Industry Association is running a poll where Hong Kong residents can vote for their favorite smartphone apps.

You can place your votes at: http://www.e-zone.com.hk/smartphoneapp/voting.html

Welcome to our Class !

In our first class, we went over the following materials:
  1. Unit Outline and Course Aims
  2. Session 1 lecture note
  3. Homework Exercise (due 27-July)
  4. Session 1 Tutorial exercise
Whether One of the important software trends is the rise of Software-as-a-Service, also known as SaaS for short. Here are some examples of software which can now be accessed as an online service thru the Web browser. Most of these examples happen to be free for personal use, so check them out in case they might be useful to you.
  1. Photoshop Express (from menu, select "Online Tools" > "Photoshop Express Editor")
  2. Microsoft Office Web Apps
  3. Zoho Business and Productivity Apps