AACS1733 Information Technology and Systems ASSIGNMENT 2010/2011 Objective This coursework aims to provide students an opportunity to explore the use of Microsoft Excel and PowerPoint so as to enhance their understanding of the application software features in spreadsheet and presentation. Grouping This is a group-based assignment. Student may form a group of minimum 4 students and maximum 5 per group (ACCORDING TO ATTENDANCE LIST NAME SEQUENCE). A group leader is to be selected to
Words: 2098 - Pages: 9
ADVANCED EXCEL TRAINING Quality Management Objective To provide the participants with an understanding of the advanced features of MS Excel Today is 7/22/2011 2 Advanced ® EXCEL Topics Working with Data Lists Naming Cells and Ranges Conditional Functions Lookup Functions Pivot Tables Data Validation Today is 7/22/2011 3 Naming Cells and Ranges Today is 7/22/2011 4 Name cells by using labels Name cells by using existing
Words: 1579 - Pages: 7
UNIV/100 Career Exploration Plan Worksheet For this assignment, you will use the My Career Plan tools on eCampus. To complete this assignment, follow the directions provided in each section. You may refer to the completed example in the Week 3 Materials as a guideline. After you have completed all sections, submit this document to your Week 3 Assignment 1 link on your student website. Section 1: Career Interests Profiler 1. Complete the Career Interests Profiler, located in My Career
Words: 822 - Pages: 4
map in the lab as the software cannot be copied onto your personal computer. To obtain data to create your map, you must write a short questionnaire and administer it to a minimum of five respondents. The data will then be input into Microsoft EXCEL and run using BrandMap Software. The map that you build must ask questions for at least five brands/products on a minimum of seven attributes. However, you can have more products or attributes if required for your product category. Product/Service
Words: 1396 - Pages: 6
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
Words: 7158 - Pages: 29
Integration Feature Linking an Excel Worksheet and Chart 5/24/2011 Northwestern Business College Gloria Gallegos Table of Contents Introduction 3 Linking an Excel Worksheet and Chart 4 Excel Basics 4 To Link an Excel Worksheet to a Word Document 4 To Link an Excel Chart to a Word Document 7 Table of Figures 8 Index 9 Introduction With Microsoft Office, you can copy part or all of a project created in one Office program to a project created in another Office program. The
Words: 1322 - Pages: 6
and” let’s get started”. The first thing on the agenda is to is to run an analysis report that shows the number of employees worked and production along with what supplies were used and the costs of the supplies used. After importing the data on my excel spreadsheet and reviewing the items in red are representing variances with a plus or minus at a rate of plus or minus 10% or where a significant increase had occurred. Now I must identify what has caused these changes and give an explanation. In the
Words: 783 - Pages: 4
capital up front (primarily for inventory) and NWC will rise to 18% of sales. The NWC will be recovered at the end of the project. The required return is 10 percent, and the tax rate is expected to be 42 percent. Requirements 1. Using an Excel spreadsheet: • Find the NPV and the IRR of the Zed Box project using the pro forma financial statement method to determine cash flows. • Enter the input variables in cells of their own at
Words: 875 - Pages: 4
and successfully opened 2 branches in 3 months. Since then, they record their daily sales and inventory manually by the use of record book and Microsoft excel. It starts from counting and checking their previous available stocks individually, computer for the total used stocks, record it in a record book and update the whole record in Microsoft excel. It takes a lot of time and the possibility for human errors is always present which could result to inaccurate information. The researchers aim to design
Words: 927 - Pages: 4
Complete the following case study and problems and submit the results in either a Microsoft Word document or a Microsoft Excel spreadsheet. If you choose to use an Excel spreadsheet, place each problem on a separate sheet and label the tab with problem number. Save your document with a descriptive file name, including the assignment and your name. | Chapter 4: * North-South Airline Case Study: In January 2008, Northern Airlines merged with Southeast Airlines . . . 3-1 Data collected on the
Words: 837 - Pages: 4
