Wednesday, December 21, 2011

Merry Christmas and a Happy New Year !



Have a Joyful Holiday Season, everyone ! See you in class next year !

Photo Source: http://trip.worldtravellist.com/2011/12/ten-merry-places-to-spend-christmas-other-than-home/

Session 7: Restaurant Management Systems

Restaurant Management System Demos from MaitredPOS:

MaitreD Restaurant Management System (click on "MaitreD' Flash Demo" under "Other Resources")

Case Study 1.



Chester Racecourse UK
This case study looks at how Chester Racecourse is using an electronic point-of-sale system for its restaurants, corporate and public catering facilities. It also looks at how Chester Racecourse is using software to manage inventory, procurement and stock control.

Links to companies mentioned in the case study:

  1. Chester Racecourse UK (click on "Restaurants")
  2. Infogenesis POS by Agilysis
  3. Eatec Solutions by Agilysis
  4. Restaurant Management Systems available via SaaS


Case Study 2: Hong Kong Jockey Club


HKJC Infrasys Case Study

Saturday, December 10, 2011

Exercise 5-4: Sensitivity Analysis - Goal Seek (with audio)

Exercise 5-4: Sensitivity Analysis - Goal Seek



Exercise 5-3: Sensitivity Analysis - Two Variable Data Table (with audio)

Sensitivity Analysis - Two Variable Data Table



Exercise 5-2. Sensitivity Analysis - One Variable Data Table (with audio)

Exercise 5-2. Sensitivity Analysis - One Variable Data Table



Exercise 5-1: Sensitivity Analysis - Spreadsheet Model Building

Exercise 5-1. Sensitivity Analysis - Building the Spreadsheet Model (with audio)



Exercise 4-6: Create a Pivot Table - Payment Method Analysis (with audio)

Create a Pivot Table - Payment Method Analysis

Exercise 4-5: Create a PivotChart (with audio)

Create a PivotChart based on the Registration Analysis by Workshop and Industry Pivot Table



Exercise 4-4: Create a Pivot Table - Attendees by Country (with audio)

Attendees by Country Pivot Table Report with Country as Report Filter



Exercise 4-3. Pivot Table Exercise Video

Create the Workshop Attendance Analysis Pivot Table Report (with audio)

Exercise 4-2. Pivot Table Exercise Video

Building the Registration Analysis by Workshop and Industry Pivot Table Report (with audio)

Exercise 4-1. Pivot Table Exercise Video

Building the Attendee Analysis by Industry Report (with audio)


Wednesday, November 2, 2011

MS Powerpoint Design and Organization 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, October 26, 2011

Welcome to our First Class !

In our first class, we will go over the following materials:
  1. Unit Outline and Course Aims
  2. Session 1 lecture note
  3. Homework Exercise (due 23-Nov)
  4. Session 1 Tutorial exercise
Handouts will be given out in class and all of these materials can be downloaded from SOUL, too.

The pace of change and development in the information technology field is incredibly fast.
One of the important software trends is the rise of Software-as-a-Service, also known as SaaS for short. SaaS allows software to be served to your computer via a network, similar to a utility service such as electricity or water.

Below are some SaaS examples. Most of these examples are free for personal use, so do 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
    (you must have Genuine MS Office installed on your computer to access)

  3. Zoho Business and Productivity Apps