...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
...The exercises below are to introduce concepts and features of a spreadsheet program such as Excel. Please note that there are alternative ways of creating a solution and your solution may be different from others. Single argument and user developed functions The table lists some functions that are commonly used in basic spreadsheet applications function | purpose | =sum(B12:B18) | Add contents of range in B12 to B18 | =average((B12:B18) | Average the range | =count((B12:B18) | Count non zero values | =max(B12:B18) | Display the largest value | =min(B12:B18) | Display the smallest value | =B4*C4 | Multiplies the values | This is not an exhaustive list. See Excel menu command fx for a complete list of functions | User created | (…)+-*/^ | Mathematic operations brackets sum, subtract, multiplydivideexponentiation (power)=(3*(A5+B5)-C5)/2+D5^1.5 | Exercise 1 Using appropriate formulae, complete the table below in Excel. Item Name | price | Commission | Camera | $150.00 | $ 15.00 | Omega | $120.00 | | Kodak | $130.00 | | Sony | $140.00 | | F | $95.00 | | Canon | $150.00 | | JVC | $210.00 | | Total | $845.00 | | | | | Commission Rate: | 10% | | Exercise 2 Complete the personal budget worksheet for the period indicated. Add your own figures where there are spaces. Extend the table to include a full calendar year. Personal Budget | | | | Monthly Expenses | Jan | Feb | Mar | Rent | $850.00...
Words: 2177 - Pages: 9
...Exercise 1 Worksheet: Features and Functions Table Save this worksheet to your computer with the filename "Your_Name_Exercise_1." Complete the table below comparing the Online Learning System (OLS) classroom with the New Classroom by doing the following: Find the corresponding feature or function in New Classroom that most closely matches the one listed for OLS. Explain how each feature or function influences your learning experience. Submit the completed worksheet as an attachment via the Assignment tab. |OLS Feature or Function |Which New Classroom feature or function most |How does this feature or function support your | | |closely matches the OLS feature or function? |learning experience? | |Main forum |The Class Home allows students to preview |You can now click on assigments and discussions | | |assigments and monitor discussion activity in |to being interacting, posting, and participating| | |the same area. |without having to look for the syllabus in a | | | |different area. | |Individual forum |This forum is no longer needed, the Learning |It seems that you would have to wait for a | | |Teams...
Words: 358 - Pages: 2
...Exercise 1 Worksheet: Features and Functions Table Save this worksheet to your computer with the filename "Your_Name_Exercise_1." Complete the table below comparing the Online Learning System (OLS) classroom with the New Classroom by doing the following: Find the corresponding feature or function in New Classroom that most closely matches the one listed for OLS. Explain how each feature or function influences your learning experience. Submit the completed worksheet as an attachment via the Assignment tab. OLS Feature or Function Which New Classroom feature or function most closely matches the OLS feature or function? How does this feature or function support your learning experience? Main forum Class Home tab appears to be the closest thing to the old Main Forum. This helps with viewing the entire week, the assignments for today and all messages and learning activities. Since it’s all laid out for us all ready, this will assist with keeping up to date with everything that is expected of us. Individual forum It appears that the Individual Forum is now located under the Discussions box in the Class Home Tab by clicking on the Private Messages. Having an individual forum allows you to speak one on one with your instructor about assignments and what ever else you may have questions about. Syllabus There seems to be two places where the Syllabus feature is located. First, it is located in the weekly learning platform and second, it is located at the top of...
Words: 420 - Pages: 2
...It contains both basic and advanced features that anyone can learn. Once some basic features are known, learning the advanced tools becomes easy. This lesson is composed of some advanced Excel features. It assumes basic prior knowledge of Excel, and it is expected that the objectives from AT Step’s Excel Essentials are known. This lesson will talk about the advanced customization and formatting features that allow for easier data manipulation and organization. Objectives 1) Learn how to Customize the Interface 2) Advanced Formatting: Custom Lists, Cell Groups, and Transposing Tables 3) Learn how to Reference Across Sheets 4) Advanced Formulas and Using Data Ranges 5) Using Data Validation AT Computer Labs Interface Customization Most of Excels interface can be customized to fit many people’s needs. For some, customization makes tools more readily available by placing those tools in a location that is more natural for the user. This section will introduce you to customizing Excel’s interface by adding a tab in the ribbon, customizing the status bar at the bottom of the program, opening separate panes, and scrolling through a sheet with a static column or row. Adding a Tab in the Ribbon In this subsection, we will explore the tab options in Excel. Tabs in Excel can be added, deleted and even reorganized. This feature is useful if you use a set of tools frequently as it can save time navigating between tabs. 1. Download and unzip the Exercise files from the At Lab’s website. 2...
Words: 10539 - Pages: 43
...Spreadsheet Exercises The exercises below are to introduce concepts and features of a spreadsheet program such as Excel. Please note that there are alternative ways of creating a solution and your solution may be different from others. Single argument and user developed functions The table lists some functions that are commonly used in basic spreadsheet applications function | purpose | =sum(B12:B18) | Add contents of range in B12 to B18 | =average((B12:B18) | Average the range | =count((B12:B18) | Count non zero values | =max(B12:B18) | Display the largest value | =min(B12:B18) | Display the smallest value | =B4*C4 | Multiplies the values | This is not an exhaustive list. See Excel menu command fx for a complete list of functions | User created | (…)+-*/^ | Mathematic operations brackets sum, subtract, multiplydivideexponentiation (power)=(3*(A5+B5)-C5)/2+D5^1.5 | Exercise 1 Example 1 Kroenke p 387 Example 2 The table shows green grocery sales for a four quarter period Weight of each sold (kg) | | oranges | apples | bananas | QTR1 | 237 | 215 | 125 | QTR2 | 211 | 341 | 228 | QTR3 | 312 | 418 | 421 | QTR4 | 432 | 121 | 121 | Using features of Excel and including any additional rows or columns you may need, calculate the following: 1. The total weights sold for each fruit for the four quarters The average quarterly sales for each fruit 2. The average selling price/kg for each fruit is $3.25 for oranges, $4.99 for apples...
Words: 1723 - Pages: 7
...contains the following exercises and activities: Exercise 8.1Exercise 8.2Exercise 8.3 Exercise 8.4Exercise 8.5Lab Challenge | Creating a Virtual Hard DiskEditing a Virtual Hard Disk FileCreating a Virtual Machine with an Existing Virtual Hard DiskConfiguring QOS on a Virtual Hard DiskCreating a Pass-Through DiskCreating a Checkpoint | BEFORE YOU BEGIN The lab environment consists of three servers connected to a local area network, one of which is configured to function as the domain controller for a domain called adatum.com. The computers required for this lab are listed in Table 8-1. Table 8-1 Computers Required for Lab 8 Computer | Operating System | Computer Name | Domain controller 1 | Windows Server 2012 R2 | SERVERA | Member server 2 | Windows Server 2012 R2 | SERVERB | Member server 3 | Windows Server 2012 R2 | SERVERC | In addition to the computers, you also require the software listed in Table 8-2 to complete Lab 8. Table 8-2 Software Required for Lab 8 Software | Location | Lab 8 student worksheet | Lab08_worksheet.docx (provided by instructor) | Working with Lab Worksheets Each lab in this manual requires that you answer questions, take screen shots, and perform other activities that you will document in a worksheet named for the lab, such as Lab08_worksheet.docx. It is recommended that you use a USB flash drive to store your worksheets, so you can submit them to your instructor for review. As you perform the exercises in each lab, open the...
Words: 1958 - Pages: 8
...contains the following exercises and activities: Exercise 6.1 | Installing Remote Server Administration Tools | Exercise 6.2 | Configuring Removable Storage Access Policies | Exercise 6.3 | Using AppLocker | Lab ChallengeLab Challenge | Creating an AppLocker Rule Based on File Hash Using Assigned Access | BEFORE YOU BEGIN The lab environment consists of student workstations connected to a local area network, along with a server that functions as the domain controller for a domain called adatum.com. The computers required for this lab are listed in Table 6-1. Table 6-1 Computers Required for Lab 6 Computer | Operating System | Computer Name | Server | Windows Server 2012 R2 | SERVERA | Client | Windows 8.1 Enterprise | CLIENTB | In addition to the computers, you will also need the software listed in Table 6-2 to complete Lab 6. Table 6-2 Software Required for Lab 6 Software | Location | Remote Server Administration Tools for Windows 8.1 (Windows8.1-KB2693643-x64.msu) | \\SERVERA\Downloads | Lab 6 student worksheet | Lab06_worksheet.docx (provided by instructor) | Working with Lab Worksheets Each lab in this manual requires that you answer questions, shoot screen shots, and perform other activities that you will document in a worksheet named for the lab, such as Lab06_worksheet.docx. You will find these worksheets on the book companion site. It is recommended that you use a USB flash drive to store your worksheets so you can submit them...
Words: 2361 - Pages: 10
...the author's sections of the Finite Mathematics II course in the Spring 1996 semester. It was expanded to cover the Finite Mathematics I course for the Fall semester of 1996. Using a combination of specially designed projects and tutorials, students are able to analyze data, draw conclusions, and present their analysis in a professional format. The mathematical and computer skills learned with such an approach is an asset that they can carry with them to other courses as well as to their future places of employment. 2 Scope of supplement The package is divided into three portions - introduction to the software platform, interactive tutorials to reinforce ideas, and projects of more complexity. Introduction to the software Worksheets which...
Words: 3176 - Pages: 13
...CD-ROM Included! “John Walkenbach’s writing style makes the difficult seem easy in this book that can be used as a reference or read cover to cover. You won’t find a more comprehensive book on Excel 2010 than this!” —Dick Kusleika, Microsoft MVP, DailyDoseOfExcel.com • Searchable PDF of the book • Understand functions, charts, worksheets, and workbooks System Requirements: See the CD Appendix in the book for details and complete system requirements. • Master “what-if” analysis, Goal Seeking, external database files, and pivot tables • Develop custom functions, program with VBA, and create UserForms • Try new slice-and-dice tools to dynamically filter your data Preview how your copied text will look www.wiley.com/compbooks Spot trends in your data with Sparklines John Walkenbach aka “Mr. Spreadsheet” is the principal of J-Walk and Associates, Inc. and a Microsoft Excel MVP. He is a leading authority on spreadsheet software and the creator of the award-winning Power Utility Pak. John has written more than 50 books, as well as articles and reviews for publications including PC World, InfoWorld, and Windows. He also maintains the popular Spreadsheet Page at spreadsheetpage.com. ® • All the examples and workbook files used in the book Microsoft® Follow the examples in the book, chapter by chapter, using the bonus materials on the CD-ROM: Excel 2010 What’s on the CD-ROM? • Get up to speed on everything new in Excel 2010 ...
Words: 167105 - Pages: 669
...G062 Similar but Different Answers – 2014-15 CONTENTS INTRODUCTION ............................................................................................................................... 3 Task 1 – RELATIONAL DATABASE .................................................................................................... 4 1ai – Import data..................................................................................................................... 4 1aii – Relationships ................................................................................................................. 6 1bi – Church form ................................................................................................................... 7 1bii – Campers form................................................................................................................ 8 1biii – Camper photographs ................................................................................................... 9 1biv – Church details on Camper form ................................................................................. 11 1ci – Booking form ................................................................................................................ 14 1cii – Booking form annotation ............................................................................................ 15 1di – Adult campers report ........................................................................................
Words: 4923 - Pages: 20
...Microsoft Excel 2010 Formulas & Functions Table of Contents Excel 2010 Formulas & Functions ……………………………………………….….. o Formula Basics ……………………………………………….….. o Order of Operation ……………………………………………….….. Conditional Formatting ……………………………………………….….. Cell Styles ……………………………………………….….. Formulas & Functions ……………………………………………….….. Basic Formulas ……………………………………………….….. o Add the Values in Rows or Columns ……………………………………………….….. o Find the Average, Maximum, or Minimum ……………………………………………….….. Ranges & Individual Cells ……………………………………………….….. Copy a Formula ……………………………………………….….. o Using the Fill Handle ……………………………………………….….. o Using Traditional Copy & Paste ……………………………………………….….. Referencing Cells in Formulas ……………………………………………….….. o Relative References ……………………………………………….….. o Absolute References ……………………………………………….….. o Mixed References ……………………………………………….….. o References to Other Worksheets ……………………………………………….….. o Other Workbook References ……………………………………………….….. Quick Reference Guide ……………………………………………….….. o Add, Subtract, Multiple & Divide ……………………………………………….….. o Understanding Error Values ……………………………………………….….. Practical Purposes of Excel Formulas ……………………………………………….….. o Using Date & Time Formulas ……………………………………………….….. Commonly Used Functions & Formulas ……………………………………………….….. o Math & Trig Icon ……………………………………………….….. Logical Icon ……………………………………………….….. Lookup & Reference Icon ……………………………………………….….. Date & Time Icon ……………………………………………….….. AutoSum Icon ……………………………………………….….. Statistical...
Words: 478 - Pages: 2
...Module number: U51001 Module title: Key Business Competences Contents Module introduction 1 Semester plan synopsis 2 Module syllabus 3 Week 1 – Module Introduction 7 Week 2: Operations with numbers 8 Week 3: Understanding Data 16 Week 4 – Charts and Graphing in Excel 31 Week 5 – Summarising data 45 Week 6 Reading Week 57 Week 7 & 8 – Principles of elementary modelling 58 Week 9 & 10 – Financial Modelling (1) 69 Week 11 & 12 – Financial Modelling (2) 81 Week 13 – Modelling and Data handling in business 97 Week 14 – Revision Week 107 Week 15 – In-class Test 108 Assessment details 109 Regulations 110 A note on equal opportunities and diversity 114 Module introduction Introduction This module ensures that all students have the necessary numerical skills to proceed with the rest of their degree in Business and related fields. As a compulsory module it must be passed and a maximum of three attempts can be made to pass it, with a resit opportunity for each attempt. Past student comments on the module “Yes it is really enjoyable – I liked the course” “The lecturers are very helpful and friendly” “The handbook is really informative” “Very clear and well explained” “It is very interesting but at the same time very complex” “Maybe make the lectures and seminars more interactive” “Quickly go over the initial mathematics and spend more time on the more complex parts of the module” ...
Words: 27701 - Pages: 111
...including supplemental material and rights and permission policies, is available at http://ite.pubs.informs.org. Vol. 9, No. 1, September 2008, pp. 1–9 issn 1532-0545 08 0901 0001 informs ® doi 10.1287/ited.1080.0014 © 2008 INFORMS INFORMS Transactions on Education Using Simulation to Model Customer Behavior in the Context of Customer Lifetime Value Estimation Shahid Ansari, Alfred J. Nanni Accounting and Law Division, Babson College, Wellesley, Massachusetts 02457 {sansari@babson.edu, nanni@babson.edu} Dessislava A. Pachamanova, David P. Kopcso Mathematics and Science Division, Babson College, Wellesley, Massachusetts 02457 {dpachamanova@babson.edu, kopcso@babson.edu} T his article illustrates how simulation can be used in the classroom for modeling customer behavior in the context of customer lifetime value estimation. Operations research instructors could use this exercise to introduce multiperiod spreadsheet simulation models in a business setting that is of great importance in practice, and the simulation approach to teaching this subject could be of interest also to marketing and accounting instructors. At Babson College, the spreadsheet simulation exercise is part of an integrated one-case teaching day of the marketing, accounting, and operations research disciplines in the full-time MBA program, but the exercise is directly transferable to stand-alone courses as well. In our experience, students have felt empowered by the ability...
Words: 7074 - Pages: 29
...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 specific movie, bring the data to Excel to format it, and then create a time series plot using SPSS, Minitab, Excel or other software. 1. Go to http://www.the-numbers.com/ and click the Movie Archive...
Words: 7158 - Pages: 29
