🚧 Under construction — VoTechWorks is being built. A free tech program — complimentary, as our commitment to get America working.
voTechWorksGrade 13 · a vocational technology learning center, by urbanicity
newSchoolWorks.com › VoTechWorks › Hospitality, Food & Tourism › Hotel & Hospitality Operations › Universal Core: Safety, Math, Communication & Career for Hotel & Hospitality Operations › Lesson 5
HOS-HOTE29-01 · Lesson 5 · 20 clock hours · demo

Digital Tools for Hotel Employees: Email, Scheduling Software, and Digital Communication

Objective. Learners will compose professional emails, navigate a sample property management system (PMS) interface, use a shared scheduling or task-management tool, and apply basic spreadsheet functions used in front office and housekeeping departments.

⚠ Pending professional review

This lesson, its worked examples and its practice questions has not yet been verified by a certified food-safety manager and industry professional or by a certification or approval body. It is a study draft and may contain errors. Do not use it as instructions for work on a job site or on live equipment. Always follow your instructor, your supervising professional, and current official references and regulations.

VoTechWorks program approval and accreditation are still in progress. Credentials are issued only by the certifying bodies named in each program, after their own exams.

Why Digital Tools Matter in Hotel Operations

Modern hotels run on digital systems. From the moment a guest books a room to the moment they check out, employees use email, property management software, scheduling platforms, and spreadsheets every single day. Mastering these tools makes you faster, reduces errors, and signals professionalism to supervisors and guests alike. This lesson walks you through the three core digital skill areas you will use on the job from day one.

Professional Email in a Hotel Setting

Email is often the first written record of a situation—a guest complaint, a shift change, or a vendor negotiation. Because email can be saved, forwarded, and reviewed by managers, every message you send reflects on you and on the property.

The standard hotel email structure follows this order:

1. Subject line – brief and specific (e.g., Guest Complaint – Room 214 Noise Issue – [Date])

2. Salutation – use the recipient's name and appropriate title (Dear Ms. Rivera,)

3. Opening sentence – state your purpose immediately

4. Body – one to three short paragraphs; keep sentences under 25 words when possible

5. Closing action – tell the reader what happens next or what you need from them

6. Professional sign-off – Warm regards, or Sincerely, followed by your full name, title, department, and property name

Tone tips: Be warm but businesslike. Avoid slang, ALL CAPS, and excessive exclamation points. When replying to a guest complaint forwarded by a manager, acknowledge the guest's experience, apologize sincerely without admitting legal liability, and state a concrete next step. When writing internally—such as a shift-coverage request—be concise and give the supervisor enough notice to act.

Privacy and security: Never include a guest's full credit card number, government-issued ID number, or detailed personal data in an email. Hotels handle Personally Identifiable Information (PII) that is protected under various state and federal privacy expectations. When in doubt, reference the guest by name and reservation number only, and direct sensitive data conversations to your secure PMS or an encrypted channel approved by your property.

Navigating a Property Management System (PMS)

A Property Management System is the software that tracks every reservation, room status, guest profile, and charge at a hotel. Common platforms in the industry include Opera, Cloudbeds, and similar cloud-based systems. You will train on a simulated or training instance so that mistakes have no real-world consequences.

Four tasks every front-desk employee performs regularly:

1. Look up a reservation – Use the search function (usually by last name, confirmation number, or arrival date). Confirm the room type, rate, and special requests before the guest arrives.

2. Update a guest profile field – Guests may change their contact information, loyalty number, or preferences. Find the profile, edit the correct field, and save. Always verify you are editing the right profile before saving.

3. Post a room charge – When a guest uses a hotel service—restaurant, spa, parking—that charge is "posted" to their folio. Select the correct folio, choose the charge type, enter the amount, and confirm.

4. Print a folio – At checkout, print or email the folio (itemized bill) so the guest can review every charge before payment is processed.

Data accuracy is a safety issue here: Posting a charge to the wrong room or printing the wrong folio exposes the property to chargebacks and exposes guest financial data to unauthorized eyes. Double-check names and room numbers before every save or print action.

Spreadsheets: SUM, AVERAGE, and Occupancy Tracking

Front-office and housekeeping supervisors use spreadsheets to track occupancy rates, labor hours, and supply costs. Two formulas handle the majority of basic reporting:

Occupancy rate is a key front-office metric. It tells you what percentage of available rooms were sold on a given night:

> Occupancy Rate (%) = (Rooms Sold ÷ Rooms Available) × 100

Once data is entered and formulas are applied, format your table so columns have clear headers, numbers are consistent (no mixing of decimals and whole numbers in the same column), and the table is easy to read. A bar chart of daily occupancy gives managers a quick visual snapshot without reading every cell.

File hygiene and version control: Always save your work with a descriptive filename that includes the date (e.g., Occupancy_Week1_2025-06-02.xlsx). If you are working in a shared Google Sheet, changes are saved automatically, but you can see version history under File > Version History to recover accidental deletions.

Digital Safety and Responsible Use

All digital activity on hotel systems may be logged and audited. Follow these non-negotiable rules:

These habits protect guests, protect the property, and protect your job.

Key terms8

Property Management System (PMS)Software used by hotels to manage reservations, guest profiles, room status, charges, and folios; the central operating system of a hotel's front office.
FolioAn itemized statement of all charges and payments applied to a guest's account during their stay; presented at checkout.
Occupancy RateThe percentage of available rooms that are sold on a given night, calculated as rooms sold divided by rooms available, multiplied by 100.
Personally Identifiable Information (PII)Any data that can identify a specific individual, such as name combined with payment details or government ID numbers; must be handled securely and shared only through authorized channels.
SUM formulaA spreadsheet function written as =SUM(range) that adds all numeric values within the specified cell range.
AVERAGE formulaA spreadsheet function written as =AVERAGE(range) that calculates the arithmetic mean of all numeric values in the specified cell range.
Post a chargeThe act of recording a guest's purchase—such as a restaurant meal or parking fee—on their folio within the PMS so it appears on their final bill.
Professional toneA writing style that is clear, respectful, and businesslike; avoids slang, emotional language, and informal abbreviations; appropriate for all hotel business correspondence.

Worked examples3

1. A hotel has 120 rooms. On Monday, 96 rooms were sold. What is the occupancy rate for Monday?
  1. Identify the values: Rooms Sold = 96, Rooms Available = 120.
  2. Apply the formula: Occupancy Rate = (Rooms Sold ÷ Rooms Available) × 100.
  3. Divide: 96 ÷ 120 = 0.80.
  4. Multiply by 100: 0.80 × 100 = 80.
Answer: The occupancy rate on Monday is 80%.
2. Using a spreadsheet, daily rooms sold for a week are entered in cells B2 through B8 with values 96, 84, 110, 115, 118, 120, and 102. Write the SUM formula and the AVERAGE formula for this range, then calculate both results.
  1. SUM formula: =SUM(B2:B8). Add all values: 96 + 84 + 110 + 115 + 118 + 120 + 102 = 745.
  2. AVERAGE formula: =AVERAGE(B2:B8). Divide the sum by the count of values: 745 ÷ 7 = 106.43 (rounded to two decimal places).
Answer: Total rooms sold for the week: 745. Average daily rooms sold: approximately 106.43.
3. The hotel from the previous example has 120 rooms available every night for the same seven-day week, with rooms sold of 96, 84, 110, 115, 118, 120, and 102. What is the average occupancy rate for the week?
  1. Calculate each night's occupancy rate by dividing rooms sold by 120 and multiplying by 100: 80%, 70%, 91.67%, 95.83%, 98.33%, 100%, 85%.
  2. Add all seven rates: 80 + 70 + 91.67 + 95.83 + 98.33 + 100 + 85 = 620.83.
  3. Divide by 7 to find the weekly average: 620.83 ÷ 7 ≈ 88.69%.
  4. Alternatively, use the weekly totals: total rooms sold 745 ÷ total rooms available (120 × 7 = 840) × 100 = 745 ÷ 840 × 100 ≈ 88.69%.
Answer: The average weekly occupancy rate is approximately 88.69%.

The math in this lesson1

Learners divide 96 rooms sold by 120 available for 80% occupancy and use SUM formulas.
7.RP.3
Brush up in the math halls at newSchoolWorks.com:
In class: Write three professional emails from hotel-employee prompts—a response to a guest complaint forwarded by the manager, a shift-coverage request to a supervisor, and a vendor inquiry—applying a hotel brand email template and peer-reviewing using a tone-and-format checklist. · In a guided demo, open a training instance of a cloud-based PMS (or a simulated front-desk module) and perform four tasks: look up a mock reservation, update a guest profile field, post a room charge, and print a folio; instructor demonstrates each step before learners replicate it. · Use a shared spreadsheet (Google Sheets or Microsoft Excel) to input a week of mock occupancy data, apply SUM and AVERAGE formulas, format the table, and produce a simple bar chart of daily occupancy—matching a sample output provided by the instructor.
Materials: Computers or tablets with internet access; PMS training instance or simulation software; Google Workspace or Microsoft 365 access; hotel email template (instructor-provided); spreadsheet exercise file; email-format checklist; occupancy data set for spreadsheet activity
Check: Learner submits all three emails (scored with an 8/10 rubric on professionalism, format, and accuracy) and a completed spreadsheet with correct formulas and chart; PMS task completion is observed by the instructor using a four-task checklist with all four tasks completed correctly.

Practice check8

Answer each question, then check it. Nothing is recorded; this is your own practice.

Communication and Guest Relations
1. Which element should always appear in a professional hotel email subject line?
Communication and Guest Relations
2. When replying to a guest complaint email forwarded by your manager, the most appropriate first step in the body of your response is to:
Front Office Operations
3. In a hotel Property Management System, 'posting a charge' means:
Front Office Operations
4. A hotel has 80 available rooms. On Saturday, 68 rooms were sold. What is the occupancy rate?
Front Office Operations
5. Which spreadsheet formula correctly calculates the total of rooms sold entered in cells C2 through C8?
Security and Safety
6. Why is it important to log out of the PMS when stepping away from a shared front-desk terminal?
Security and Safety
7. Which of the following best describes Personally Identifiable Information (PII) in a hotel context?
Front Office Operations
8. A supervisor needs a quick visual summary of daily occupancy for the week without reading individual cell values. The most appropriate tool to provide this in a spreadsheet is:
Record this lesson on my transcript. Sign in with your key and enrollment email to record lessons (enroll free if you have no key). This page stays open to read and practise.
← Previous lessonProgram planNext lesson →