信息时代的管理信息系统9e55438教师手册试卷book.docx

Extended Learning Module D (Book Version. Office 2010) - Decision Analysis with Spreadsheet SoftwareEXTENDED LEARNING MODULE D (Book Version, Office 2010)DECISION ANALYSIS WITH SPREADSHEET SOFTWAREJUMP TO THE SUPPORT YOU WANT Lecture Outline Modules, Projects, and Data Files Slide Reviews Short-Answer Questions Assignments and Exercises Additional Assignments and ExercisesCONTACT INFORMATION: Stephen Haag (shaagdu.edu)STUDENT LEARNING OUTCOMES1. Define a list and list definition table within the context of spreadsheet software and describe the importance of each.2. Compare and contrast the Filter function and Custom Filter function in spreadsheet software.3. Describe the purpose of using conditional formatting.4. Define a pivot table and describe how you can use it to view summarized information by dimension.MODULE SUMMARYThis module explores with your students some of the many decision support features in spreadsheet software, specifically Excel.Specifically for Excel, this module focuses on Filter, Custom Filter, conditional formatting, pivot tables, and goal seek.The primary sections of this module include:1. Lists2. Basic Filter3. Custom Filter4. Conditional Formatting5. Pivot Tables6. Goal SeekLECTURE OUTLINEINTRODUCTION (p. 387)LISTS (p. 388)BASIC FILTER (p. 390)CUSTOM FILTER (p. 392)CONDITIONAL FORMATTING (p. 394)PIVOT TABLES (p. 396)GOAL SEEK (p. 402)END OF MODULE (p. 404)1. Summary: Student Learning Outcomes Revisited2. Key Terms and Concepts3. Short-Answer Questions4. Assignments and ExercisesBack to JumD ListMODULES, PROJECTS, AND DATA FILESGroup Projects Assessing the Value of Customer Relationship Management: Trevor Toy Auto Mechanics Analyzing the Value of Information: Affordable Homes Real Estate Executive Information System Reporting: Political Campaign Finance Building a Decision Support System: Creating an Investment Portfolio Advertising with Banner Ads: Hi，hwavsAndB Assessing the Value of Outsourcing Information Technology: Creating Forecast Creating a Decision Support System: Buy versus Lease Developing an Enterprise Resource Planning System: Planning, Reporting, and Data Processing Analyzing Strategic and Competitive Advantage: Determining Operating Leverage Building a Decision Support System: Break-Even Analysis Creating a Financial Analysis: Qualification and Amortization Worksheets Building a Scheduling Decision Support System: Airline Crew Scheduling Assessing the Value of Supply Chain Management: Optimizing ShipmentsDATA FILESYour students can find all of these files on the Web site that supports this text at XLMD_Customer.xls - file used for the majority of the in-text discussion and demonstration; file used for Assignment and Exercise #2 on page 406 XLMD_BreakEven.xls 一 file used for demonstrating breakeven analysis and for Assignment and Exercise #6 on page 406 XLM_Production.xls - file used for Assignment and Exercise #1 on page 405 XLMD_Employee.xls - file used for Assignment and Exercise #3 on page 406 XLMD_Travel.xls - file used for Assignment and Exercise #4 on page 406Back to Jump ListCMg1STUDEW LEARNING OUTCOMESi Define a list and list defi Won tote wthin the context of spreadsheet software and describe the importonccofexh.Compare and contrast the Filter function Ed Custom Rltcr functcn in spreadsheet serftware.» Desenbe the purpose of using ontftUonal formatting. These are the Student Learning Outcomes for the module. Use them as a road map to inform your students of what you will be covering. At the end of the module is a summary of eachSLIDE 3STUDENT LEARNING OUTCOMES Define a pKot tabte and describe how you can u&eit to view summarized informauon by dimension.i. De$6be the purpose of Goal Seek. These are the Student Learning Outcomes for the module. Use them as a road map to inform your students of what you will be covering. At the end of the module is a summary of each.SLIDE 4INTRODUCTION IT plays an inxxxtant role in aiding dec&on making Spreadsheet tools can akl in deepen making Htte ConcJtkndl fermattro PvXtobtes This slide provides a broad introduction to the module and the features of Excel that are covered.SUDE5MODULE ORGANIZATION1 Uts«. CoMbCWMl Wm 昭Fccmattngfxav !. Lcyr*X 8«icRt0f3 s.latAs92. levr*x EomRHrmm*" 。GwISeek(utters xs This slide presents the organization for the module. It does so by listing the major sections and learning outcomes associated with each section.SLIDE 6USTS Litt- information arranged in cdiMims and ra“ «Ajmn h»w one npe <X iVWnwbon Arat rew contans hcodnos er hbds. Ftorews Bbnk coljfnnWnM 刈 arcxrtf These next three slides cover the basic concepts of a list (Student Learning Outcome #1). Information must be organized as a list in Excel to use filter, conditional formatting, and pivot table functions"Q-Js This slide defines and describes a list definition table. Ust Deflnioon TableLift definition tabfc - dcsaWm It uses the customer list as an example.8UJanscf a list by cdumn (see Figure D.2 onPO. 388-389) OJSTSO- Unkue ID for custtxner.lCSON- North, SoXh, ctt. RfffT VS. customer rtrts oc<www a hvweBASIC FILTER6UJazjs Filter function ftters a list and hdcs nzvs that don't match enters. Good foe seeing only certain rows of Ir/crmaoon Base Wcr supports odyMcqu to* * criteria This slide begins the section on Basic Filter (Student Learning Outcome #2). In Office 2007, this is now called just Filter, whereas in earlier versions of Office it went specifically by the name of Basic Filter.Example: customers in the NothBask: Bfter StepsoiUJansOpen workbook fXLMD.Customer.xls fromaide in any cell in the listMenu bar - dkk on Data and then dkken Fitter This slide presents the steps necessary for starting the Filter function. That is, how to get the list box arrows next to each column heading or label.二UJansSLIDE 12Bask fMter Steps:，窖 1 :tf1o o osuouc! !Ech coMnn w* hM aarrow. Ckkon il m vSWA the erfteno These four slides present the various screen captures in Figure D.3 on page 390. They illustrate how to the Filter function to see only those customers in the North REGION.SUDE 13Bask: Frfter Steps- i：you <mst5rogg These four slides present the various screen captures in Figure D.3 on page 390. They illustrate how to the Filter function to see only those customers in the North REGION.SLIDE 14Bask Biter Steps长2呈岁三：八元芟部» oTXw'ai 2122； SE, .fj-s-2EES1:IS *、. .E>cd vM refccrd 5 shgsg cr>f those records met nw Z «4«tcn(lr. NwtREGiGM These four slides present the various screen captures in Figure D.3 on page 390. They illustrate how to the Filter function to see only those customers in the North REGION.SLIDE 15Turning off Bask: Biter Perform either of the Ww.ng fam the m«ru bar, ddc s Data «rd than Flltar. Tum B EvtX cok*rc modng by dcfcno 8 the wwiste let yrew txw arxl ckfcng 8 Clear Fitter from 'okimnzm/ 師。e 徐EtAW te the nare cf the ccKumn This slide presents how to turn off the Filter function.9 rdUJaZ sBasle Filter Q>n also filter on m(Aip<c columns Example Cutters 仍 North 购沖Si gMGg Own a hone (setect Own in 砌7* 15： OWf/f OnVonefcuwhcrfd frrtwf (sect 1 These two slides present the example of filtering on multiple columns.Mod D Book-7© 2013 by McGraw-Hill Education. This is proprietary material solely for authorized instructor use. Not authorized for sale or distribution in anymanner. This document may not be copied, scanned, duplicated, fbrwardcd. distributed, or posted on a uxrbsitc. in whole or part. These four slides present the various screen captures in Figure D.3 on page 390.They illustrate how to the Filter function to see only those customers in the North REGION.