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

《信息时代的管理信息系统9e55438教师手册试卷book.docx》由会员分享，可在线阅读，更多相关《信息时代的管理信息系统9e55438教师手册试卷book.docx（7页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、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-Answ

2、er 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 Fil

3、ter 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

4、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

5、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 Questions

6、4. 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

7、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:

8、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: Airli

9、ne 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 a

10、nd 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

11、.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 se

12、rftware. 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 desc

13、ribe 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

14、 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 8ic

15、Rt0f3 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 hw one npe X iVWnwbon Arat rew contans

16、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 functionsQ-Js This slide defines and describes a list d

17、efinition 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 ocwww a hvweBASIC FILTER6UJazjs Filter function ftters a

18、 list and hdcs nzvs that dont 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 w

19、ent 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 g

20、et 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

21、 those customers in the North REGION.SUDE 13Bask: Frfter Steps- i：you cd vM refccrd 5 shgsg crf those records met nw Z 4tcn(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 Nor

22、th REGION.SLIDE 15Turning off Bask: Biter Perform either of the Ww.ng fam the mru 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 fu

23、nction.9 rdUJaZ sBasle Filter Qn also filter on m(Aipc 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 proprietar

24、y 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.