...Management B Bus (Hons) in Hospitality Management B Bus (Hons) in Public Management B Bus (Hons) in Tourism Management Semester : 1 Commence Date : Week 6 Deadline Date : Week 11 Unit Controller / Examiner : Suha Salem Contact Number : ext 8406 E-mail : ssalemp@gmail.com ------------------------------------------------- Coursework Requirements: 1. You are required to come out with a Microsoft Excel application to solve next Exercises 2. Open new workbook in Microsoft Excel and save as “Group Assignment”. 3. You are required to solve all the exercises and each exercise in different sheet. This group project can have Maximum 3 students. Exercise1 In this exercise, practice Conditional Formatting 1- Open a new sheet and Rename the sheet as “Exercise 1” 2- Type the next data and format the data as a Table. 3- Set up the rule that Excel formats any cell within a range with yellow fill color and dark yellow font color whenever it contains the word “Dairy”. 4- Set up the rule that excel formats any cell within a range with light red fill color whenever it contains the amount value less than ($500). Exercise 2 In this exercise, practice simple and complex formula...
Words: 1008 - Pages: 5
...| Exercise 1: Baseline Data Using the Horizontal Compression buttons and the scroll bar, display the data for Exercise 1 you wish to include in your report. | | ECG and Cardiac Cycle| |Time between QRS and the Startof Ventricular Contraction (s)| 1|1.48| 2|1.48| 3|1.46| 4|1.48| 5|1.48| Mean|1.47| Observe the heart and describe its behavior. Is this behavior consistent with what is shown in the data above? | | Study Questions | 1. Explain the basis for the delay between the atrial and ventricular contractions. | | 2. Describe the relationship between the ECG QRS complex and the beginning of ventricular contraction. What is the physiological significance of this relationship? | Exercise 2: Effect of temperature Using the Horizontal Compression buttons and the scroll bar, display the data for Exercise 2 you wish to include in your report. | | Effect of Temperature on Frog Heart Rate| |Temperature(°C)|Heart Rate(BPM)|CalculatedQ10|Cold|3|31.3||Room Temp|19|42.1|1.2|Warm|37|54.0|1.1||| Describe the effects that you observe of changing the temperature of the solution bathing the heart as it lies wihin the thorax. | | Study Questions | 1. How did temperature affect heart rate? What do you suppose is a consequence of being a poikilotherm? | | 2. Why is the Q10 a useful concept? | Exercise 3: Starling's law of the heart Using the Horizontal Compression buttons and the scroll bar, display the data for Exercise 3 you...
Words: 591 - Pages: 3
...Financial Accounting Exercise 03-02: Basic Financial Accounting Process Single Company Code Version 1 Rev: 01/03/2011 Introduction General Notes and Information It is strongly recommended that you read through the entire exercise prior to starting. Not all instructions can be provided in a linear manner. The following symbols are used to indicate important information as described below: An arrow highlights an important instruction that must not be overlooked. A text box prompts you to type-in an important piece of information. Each student or group will be assigned a unique three digit identifier. This identifier is used in all exercises to uniquely identify your data. Whenever you see ### in these exercises, replace it with your identifier. Always work with your data. Business Process Overview The financial accounting process allows GBI to pay vendors for services or materials acquired. This process can be used to pay for liabilities that GBI has incurred due to normal operations. This exercise is about paying off liabilities within the accounting statements. Chapter 04 Save Reset Print Chapter 03: Financial Accounting Exercise 03-02 Exercise 04-02 Exercise Prerequisites Chapter 04: ProcurementFinancial Accounting Master Data-SCC Exercise 3-1 Process Exercise 04-02: Basic Procurement Process Exercise Single Company Code Workflow Invest in GBI View Account Balances Purchase Supplies for Cash Purchase Supplies Via Payables Misc. Pay Rent Exercise Deliverables ...
Words: 3323 - Pages: 14
...E-Science Lab 1 UMUC - The Science of Life UMUC Biology 102/103 Lab 1: Introduction to Science INSTRUCTIONS: On your own and without assistance, complete this Lab 1 Answer Form electronically and submit it via the Assignments Folder by the date listed on your Course Schedule (under Syllabus). To conduct your laboratory exercises, use the Laboratory Manual that is available in the WebTycho classroom (Reserved Reading or provided by your instructor) or at the eScience Labs Student Portal. Laboratory exercises on your CD may not be updated. Save your Lab 1 Answer Form in the following format: LastName_Lab1 (e.g., Smith_Lab1). You should submit your document in a Word (.doc or .docx) or Rich Text Format (.rtf) for best compatibility. Exercise 1: Data Interpretation Table 1: Water Quality vs. Fish Population Dissolved Oxygen 0 2 4 6 8 10 12 14 16 18 Number of Fish Observed 0 1 3 10 12 13 15 10 12 13 1. What patterns do you observe based on the information in Table 1? The number of fish observed increased as the dissolved oxygen in the water increased. At 6 and 8 ppm, the number of observed fish peaked with a +4 observed fish rate per ppm. At 14 ppm there is a drop in observable fish (-4), and continues to drop as the dissolved oxygen increases. 2. Develop a hypothesis relating to the amount of dissolved oxygen measured in the water sample and the number of fish observed in the body of water. If the amount of dissolved oxygen is increased...
Words: 1694 - Pages: 7
...Part I (Chapters 1 – 11) MBA 611 STATISTICS AND QUANTITATIVE METHODS Part I. A. Review of Basic Statistics (Chapters 1-11) Introduction (Chapter 1) Uncertainty: Decisions are often based on incomplete information from uncertain events. We use statistical methods and statistical analysis to make decisions in uncertain environment. Population: Sample: A population is the complete set of all items in which an investigator is interested. A sample is a subset of population values. & Example: Population - High school students - Households in the U.S. Sample - A sample of 30 students - A Gallup poll of 1,000 consumers - Nielson Survey of TV rating Random Sample: A random sample of n data values is one selected from the population in such a way that every different sample of size n has an equal chance of selection. & Example: Random Selection - Lotto numbers - Random numbers Random Variable: A variable takes different possible values for a given subject of study. Numerical Variable: A numerical variable takes some countable finite numbers or infinite numbers. Categorical Variable: A categorical variable takes values that belong to groups or categories. Data: Data are measured values of the variable. There are two types of data: quantitative data and qualitative data. 1 Part I (Chapters 1 – 11) Quantitative Data: Qualitative Data: & Example: 1. 2. 3. 3. 4. 5. 6. 7. 8. Statistics: Quantitative data are data measured on a numerical scale. Qualitative data are non-numerical...
Words: 3688 - Pages: 15
...TYPE YOUR FULL NAME: Clarence Loveless TYPE YOUR FULL NAME: Clarence Loveless UMUC Physical Science 101/103 Lab 1: Introduction to Science INSTRUCTIONS: * On your own and without assistance, complete this Lab 1 Answer Form and submit it via the Assignments Folder by the date listed on your Course Schedule (under Syllabus). * To conduct your laboratory exercises, use the Laboratory Manual that is available in the classroom. Laboratory exercises on your CD may not be updated. * Save your Lab 1 Answer Form in the following format: LastName_Lab1 (e.g., Smith_Lab1). * Submit your document in a Word (.doc or .docx) or Rich Text Format (.rtf) for best compatibility. Exercise 1: Data Interpretation Table 1: Water Quality vs. Fish Population Dissolved Oxygen | 0 | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | Number of Fish Observed | 0 | 1 | 3 | 10 | 12 | 13 | 15 | 10 | 12 | 13 | 1. What patterns do you observe based on the information in Table 1? One pattern I observe was in the number of increments. ie….0,1,1,4,4,3,3,4,4,5. The increments would stay the same between for two observation periods with the exception of the 1st and last observation period. 2. Develop a hypothesis relating to the amount of dissolved oxygen measured in the water sample and the number of fish observed in the body of water. If the amount of dissolved oxygen increases in water then the amount of fish will also increase. 3. What would your experimental approach...
Words: 1347 - Pages: 6
...[pic] Business Process Integration – I Exercises ECC 6.0 Modified August 2009 Unit 2: Customer Order Management Business Cycle Including Procurement Process for Replenishment of Goods |Purpose of Unit | |The purpose of Unit 2 is to demonstrate the Customer Order Management Business Cycle beginning with a quotation and ending with recording | |final payment received from the customer. This process will include the procurement cycle as you will need to procure the items for sale. | Exercise 1: Logging on to the SAP System Enter the following: ➢ Select server name provided by the course lead ➢ Click on [pic] ➢ Client number provided by course lead ➢ User ID (e.g., User-100) provided by course lead ➢ Password (e.g., init) provided by course lead ➢ Select EN as the language ➢ [pic] (Enter) Once you have pressed enter, the system will prompt you to change your password the first time you log on to the system. The following pop-up screen will appear. Enter your new password Repeat your new password Select [pic] (Enter) This will log you onto the system. The following page is a screen shot of the SAP Easy Access Menu you should see if you have been successful. If you can not get logged on to the system...
Words: 32727 - Pages: 131
...271-9903 e-mail: bret.wagner@wmich.edu 1. Fitter Snacker Clients There are four versions of the Fitter Snacker Database client available for Student Exercises. In this document, the term Fitter Snacker Client will be used for the completely configured Fitter Snacker company. In addition to the Fitter Snacker Client, there are three other clients that are partially configured versions Fitter Snacker Client that can be used to teach SAP configuration. These clients are copies of the Fitter Snacker Client that were made during the development of the Fitter Snacker Client. The Fitter Snacker Client was created using the Dolphin Group configuration training document as a template. While there are significant differences between the Dolphin Group (and BPI) configuration classes, these are primarily in terms of the business context, although changes were made to make sure that each company in the Fitter Snacker Client was as independent as possible. The Fitter Snacker Client represents the fictitious Fitter Snacker Company that is used as an example in the textbook Concepts in Enterprise Resource Planning[1]. Exercises for the Fitter Snacker Client match with examples used in the textbook. Figure 1 describes the four clients and their roles. The Fitter Snacker Client contains 100 copies of the completely configured Fitter Snacker Company. Individual company data is identified by a two-digit prefix. For...
Words: 1653 - Pages: 7
...Seminar 1 Company Profile • Leaders in Computer-Based Measurement and Automation • Long-term Track Record of Growth and Profitability • $660M Revenue in 2006 • $184.4M in Q3 2007 (12% YOY) • More than 4,300+ employees; operations in 40+ countries • Fortune’s 100 Best Companies to Work For 8th Consecutive Year • FT 50 Best Workplaces UK 2006 & 2007 2 National Instruments Vision “To do for test and measurement what the spreadsheet did for financial analysis.” Virtual Instrumentation The software is the instrument 3 Hands-on Introduction to Data Acquisition with LabVIEW 1 The NI Approach – An Integrated Platform PXI Modular Instrumentation Multifunction High-Resolution Data AcquisitionDigitizers and DMMs Digital I/O High-Speed Digitizers Acoustics RF Signal Keypad LCD Sound Instrument Control Dynamic Signal Acquisition Temperature Monitoring Process Control Battery Laptop PC Desktop PC Counter/ Timers Machine Vision Waste Monitoring PDA Distributed I/O and Embedded Control Motion Control Body & Chassis Audio Engine Durability Motor and Valve Control Emissions Electronics Safety Tire & Brake 4 Agenda • Introduction to LabVIEW Exercise 1: Create a simple LabVIEW VI • Data Acquisition with LabVIEW Exercise 2a – 2c: Introduction to Data Acquisition with LabVIEW • Decision making in LabVIEW Exercise 3: Controlling...
Words: 7242 - Pages: 29
...Physiology of the in situ Amphibian Heart This experiment explores the basic principles of cardiac muscle physiology, including contraction force, electrocardiogram (ECG) and the effect of neurotransmitters on the heart. Written by staff of ADInstruments. [pic] Background Studies of isolated organs were pioneered in the late 19th century when scientists such as Sidney Ringer (1835–1910) developed a perfusion solution (Ringer’s solution) that could sustain an isolated organ from a pithed animal. A classic example of this phenomenon is the frog heart, which will continue to beat in situ for several hours allowing for the study of basic cardiac functions. The heart is made up of specialized tissue called cardiac muscle. Cardiac muscle is similar to skeletal (striated) muscle, but exhibits some special properties, the most important of which is rhythmicity. Specialized heart muscle cells called pacemakers spontaneously depolarize and repolarize; the depolarization spreads to the entire heart via electrical connections between cardiac muscle cells called gap junctions. This process occurs in rhythmic fashion, giving rise to an intrinsic, regular heartbeat. While no external stimulation is required to maintain the heartbeat, the heart receives continuous input from the sympathetic and parasympathetic nervous systems. Cardiac muscle responds to a variety of neurotransmitters, which can increase or decrease the heart rate. These molecules are able to influence heart rate...
Words: 2063 - Pages: 9
...Helena Clay Williams Helena Clay Williams UMUC Biology 102/103 Lab 1: Introduction to Science INSTRUCTIONS: * On your own and without assistance, complete this Lab 1 Answer Form electronically and submit it via the Assignments Folder by the date listed on your Course Schedule (under Syllabus). * To conduct your laboratory exercises, use the Laboratory Manual that is available in the WebTycho classroom (Reserved Reading or provided by your instructor) or at the eScience Labs Student Portal. Laboratory exercises on your CD may not be updated. * Save your Lab 1 Answer Form in the following format: LastName_Lab1 (e.g., Smith_Lab1). * You should submit your document in a Word (.doc or .docx) or Rich Text Format (.rtf) for best compatibility. Exercise 1: Data Interpretation Table 1: Water Quality vs. Fish Population Dissolved Oxygen (ppm) | 0 | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | Number of Fish Observed | 0 | 1 | 3 | 10 | 12 | 13 | 15 | 10 | 12 | 13 | (hint: ppm stands for “parts per million”) 1. What patterns do you observe based on the information in Table 1? Ans. The quality of fish increase as (ppm) increase to a point while the quality of water continue to increase 2. Develop a hypothesis relating to the amount of dissolved oxygen measured in the water sample and the number of fish observed in the body of water. Ans: If oxygen or ppm in the water increase more fish will be produce 3. What would your experimental approach be...
Words: 1241 - Pages: 5
...BMS192 Lab Report marking sheet for 201360 Lab Report Marking Criteria Marks awarded Section total Abstract (4 marks) 2 Approx 2 lines introducing the topic (and aims) (1 mark) 1 Approx 2 lines for methods (1 mark) 0.5 Approx 2 lines summarising results (1 mark) 0 Approx 2 lines concluding (1 mark) 0.5 Introduction (11 marks) Note: use your text and the supplied journal articles to justify and support the development of the aims and hypothesis of the study. 5.75 What is blood pressure (BP)? (1 mark) 1 What is normal blood pressure? (1 mark) 0.5 Explain and Define mean arterial pressure (MAP) and pulse pressure (PP)and what they represent without showing their calculation (2 mark) 1 What can cause changes in blood pressure? (1 mark) 0.25 How is blood pressure regulated? (Focus mainly on the short term regulation of blood pressure, but also briefly mention long term regulation) Include the following: • What receptors detect changes in blood pressure? (1 mark) • Where is the signal transmitted? (1 mark) • What is the output and effectors? (1 mark) • What is the final result of effector action(s)? (i.e. Increased or decreased BP)? (1 mark) You do not complete your argument by including this information. 1 1 0.5 0 Aims and hypothesis. Explain what the study is testing and why (2 marks). Note: a hypothesis is a statement that you can test as being true or false so your results will either support the hypothesis or show it to be incorrect...
Words: 3522 - Pages: 15
...Movie Data Accompanying Article Available at http://www.amstat.org/publications/jse/v17n1/mclaren.html Note to Instructors: Our students, like many introductory business statistics students, have access to SPSS and Minitab so in most cases these exercises provide specific instructions for these two packages. We have also included instructions for Excel 2007. While we are cognizant of the issues with using Excel for statistical analyses, we also realize its simplicity for basic functions such as graphing, and we use it in our classes along with Minitab and SPSS because we feel that business students should be proficient in its use. We used SPSS version 15, Minitab version 15, and Excel 2007 to write the following instructions. If your students will be using other versions of these softwares or if you prefer that your students use different statistical software, you will need to edit the instructions accordingly before distributing to your students. Exercise 1: Data Retrieval and Graphing Learning Objectives: 1. Locate and retrieve data from a web site. 2. Place retrieved data into Excel and format appropriately. (This step is recommended because the format from the website is not easily imported directly into SPSS and Minitab). 3. Create and format a time series plot in SPSS, Minitab, Excel or other software. Instructions for the students: For this exercise you will use movie box office data found at http://www.the-numbers.com/. You will locate data for a...
Words: 7158 - Pages: 29
...Project Data on the Internet Note: In exercises 1 and 2 the data for the year 2000 is used. Exercise 1 Using the daily mean temperatures, compute the range and standard deviation in temperature for San Francisco in January 2000. Answer The mean daily temperatures for each of the days in January 2000 as compiled by the Weather Underground are 50.8 48.5 47.8 55.9 52.1 47.8 47.7 50.5 51.3 52.4 54.1 49.6 50.5 52.6 53.9 56.4 50.5 52.8 55.5 55.3 52.4 53.6 54.6 56.2 54.4 51.5 50.5 50.3 51.1 54.9 52.6 . For this data n = 31 ∑ x = 1618.1 ∑ x 2 = 84653.61 so the mean and standard deviation are x= 1618.1 = 52.20 31 and s= 31(84653.61) − (1618.1) 2 = 2.54 . 31(30) Exercise 2 The National Football League uses a long list of criteria to determine if a city is a candidate to host the Super Bowl. One such requirement is that the city either must have a domed (i.e. heated) football stadium or that the average temperature in January for the city must be 50o F or higher. San Francisco does not have a domed stadium. Based on the January 2000 data, would San Francisco satisfy this Super Bowl eligibility criterion? Answer Yes, since the average from Exercise 1 is 52.20. Exercise 3 Which graph below best represents the performance of Microsoft stock during the first four months of 2000? Answer Graph B shows the history of Microsoft stock prices over the indicated period. Note the data is graphed in the form it is provided on the Yahoo! finance site so that January 1 is on the right. Exercise 4 What...
Words: 579 - Pages: 3
...Structured Finance Homework 3 Bond Valuation with Annual Payments Exercise 5.1 5-1 Bond Valuation with Annual Payments Data: M = Par Value = $1,000 C = Maturity value. We can assume that it is the same as the par Value = $1,000 r = Coupon rate = 0.08 i = Effective interest rate per coupon = 0.09 n =Number of coupon payments remaining = 12 Calculations In order to calculate the current market price of these bonds, I will use the formula for the bond price on the date of a coupon payment. The bond price on the date of a coupon payment is the PV of all coupons + the PV of the maturity value *. means multiplication The present value of all coupons = M * r* [1-(1+i)-n]/i The present value of the maturity date = C * [(1+i)-n] The current market price of these bonds is M * r* [1-(1+i)-n]/i + C * (1+i)-n] = = 1,000 * 0.08 * [1-(1+0.09)-12]/0.09 + 1,000 * (1+0.09)-12] = = 80 *(1-0.355)/0.09 + 1,000 * 0.355 = $572.858+ $355.534 = $928.3927 Answer: The current market price of these bonds is $ 928.39 Exercise 5.2 5-2 YTM for Annual Payments Data: M = Par Value = $1,000 Current Price (PV) = 850 r = Coupon Rate = 10% = 0.1 PMT = $100, because (0.1 * 1,000) N =Years to maturity = 12 Calculations In order to calculate the Yield to Maturity (YTM), I will use the following formula: |850 = |[pic] ...
Words: 1049 - Pages: 5
