Super Cruise Tours and Resort Project

These flashcards cover key concepts related to the Super Cruise Tours and Resort project, including financial calculations, job positions, software tools, and information management.

Super Cruise Tours and Resort

An all-inclusive hotel and resort that has been operational since December 2010.

Hourly Rates

Rates per hour for job positions at the resort: Front Desk - $14.00 USD, Kitchen - $16.00 USD, House Keeping - $15.00 USD, Maintenance - $20.00 USD.

Job Positions

Positions available at Super Cruise: Front Desk, Kitchen, House Keeping, and Maintenance.

Accommodations Pricing

Pricing per night for accommodations: Single Suite (Level I) $175.00 USD; Double Suite (Level I) $200.00 USD; Deluxe (Level II) $600.00 USD; Superior (Level III) $800.00 USD.

Amenities

Available amenities at the resort include: Room Service, Gym, Spa, Bars, Restaurants, Pools, and Child Care.

Microsoft Excel

Software required to create a spreadsheet to perform calculations related to workers' salaries.

Pseudocode

An algorithm written in plain language used to outline the steps to calculate employee salaries.

Trace Table

A table used to capture data related to worker salaries and hours worked for observation.

Database Management

The process of organizing worker data, including tables for demographics and salary records.

Net Income

The income a worker takes home after taxes have been deducted from their gross income.

Tax Deduction

A 15% deduction from the gross income paid to the Jamaican government.

Design Requirements

Key tasks such as creating a flyer, database, salary information worksheet, and promotional webpage for the resort.

Pivot Table

A data processing tool used in Excel to summarize and analyze information from a data set.

Webpage Design

The creation of a webpage to promote the resort, including hotel packages and reservation forms.

Fillable Form

A form created in Microsoft Word and used to collect applicant information for job opportunities.

Relationship Tables

Connecting tables in a database that define how data is related to each other.