Business applications Books
IEEE Computer Society Press,U.S. Software Safety and Reliability
Book Synopsis
£97.16
Scarecrow Press Domesticating Information
Book SynopsisDomesticating Information: Managing Documents Inside the Organization examines records and documents as complex business objects and explores the many different perspectives required for their management. Viewing documents as business objects requires a much different perspective from treating them as cultural artifacts, where preservation is the primary concern. When viewed as business objects, documents must be looked at in terms of integration with business processes, in defense of litigation subpoenas, or in the implementation of information technology. As a consequence, records managers are business analysts, and therefore are treated as such in this book. How information technology, the law, archives, and library & information science scholarship address and affect document and records management are all considered. Topics covered include: how to manage documents and records in any environment, hard copy vs. electronic documents, and how to create a foundation for managing recordTrade ReviewWithout question, this is one of the most interesting books ever written about records management, a welcome change from the usual how-to manual or technical report. It is a book that will find a welcome place in the graduate programs preparing individuals to work as archivists and records managers. * Records and Information Management Report *Choksy's tone, attitude, and arguments bring both renewed and needed energy...to this debate....a usefully articulated overview of the current state of the records management profession and the issues it faces....an informative book indeed. * The American Archivist *The book is very well written throughout. The author, although earnest in her objectives, has a sense of humour and her book will be accessible and interesting even to those unfamiliar with the world of records management. Highly recommended for academic and corporate libraries. * Canadian Library Journal *Aimed at academics in library and information science, this text considers records management from the perspective of the needs of the organization and discusses how it differs from archives and library science. Following an overview of the history of records management, Choksy considers the importance of context for documents and records. Other topics include business processes in relation to records, and the value of information within the organization. Choksy teaches at the School of Library and Information Science at Indiana U., Bloomington. * Reference and Research Book News *Table of ContentsPart 1 Figures Part 2 Tables Part 3 Preface Part 4 Acknowledgments Part 5 Introduction Part 6 1 History of Records Management Part 7 2 The Context of Records Part 8 3 What is a Record? Part 9 4 What Records Do We Manage? Part 10 5 The Life Cycle: Business Processes in Relation to Records Part 11 6 Creating Value: Organizing Records Part 12 7 Conclusion: New Requirements for the Records Manager Part 13 Bibliography Part 14 Index Part 15 About the Author
£52.20
IEEE Computer Society Press,U.S. Virtual Worlds on the Internet
Book Synopsis
£95.36
IEEE Computer Society Press,U.S. Digital Image Warping
Book Synopsis
£95.36
eCruiting Alternatives Inc The Ultimate SAP Pricing Guide How to Use SAPs Condition Technique in Pricing Free Goods Rebates and Much More
£33.00
£24.94
Pilinut Press, Inc. Publish Today a Helpful Guide to Book Publishing for Authors and Self Publishers
£10.36
Murine Communications The Public Domain Publishing Bible How to Create Royalty Income for Life
£10.91
James Turnbull The Logstash Book
£14.06
SB Publishing Becoming Strategic with Robotic Process
Book SynopsisRobotic Process Automation will continue its exponential growth over the next five years. This book brings a new focus on RPA's strategic potential: the innovations made possible and how to deliver through effective sourcing stakeholder-buy-in, governance, change management, and capability development practices.Table of ContentsChapter 1: Robotic Process Automation: The Diffusion of Innovation Challenge Chapter 2: Becoming Strategic with RPA Chapter 3: Start Right: RPA Sourcing, Platform and Total Value Chapter 4: Institutionalise Fast: Gaining Stakeholder Buy-In and Governance Chapter 5: Institutionalise Fast: Change Management and Capability Development Chapter 6: On The Maturity Path: Institutionalise and Innovate Chapter 7: In Their Own Words: Manufacturing, Retail and Telecommunications Chapter 8: In Their Own Words: Financial, Insight, Health and Business Services
£26.12
Vijay Madisetti Internet of Things A HandsOn Approach
£34.00
Taylor & Francis Ltd Elements of Digital Transformation
Book SynopsisElements of Digital Transformation is a practitioner's guide to the digital transformation process. It is also a guide for managers in today's organizations that are accelerating digital transformation to modernize core technology capabilities and processes. The book discusses such key components of digital transformation as processes, principles and proven methods. It also covers such novel concepts in digital transformation as the first-time right framework, incident management transformation, digital factory, cloud migration, API-first approach and legacy modernization. Other highlights of the book include: A cloud migration framework along with a cloud migration methodology, rollout strategy and migration principles Principles and approaches for legacy modernization and process modernization Smart ticket management, smart problem management, proactive maintenance and ticket-avoidance architecture The novel digital factory approTable of ContentsPART I DIGITAL TRANSFORMATION INTRODUCTION 1. An Introduction to Digital Transformation 2. Digital Transformation Framework PART II MIGRATION AND MODERNIZATION 3. Legacy Modernization 4. Cloud Migration PART III DIGITAL TRANSFORMATION OF TECHNOLOGY 5. Services Transformation 6. Digital Factory for Digital Transformation 7. First Time Right Methodology in Digital Transformations 8. Experience Transformation 9. Transforming the Platform Performance 10. AI and Digital Transformation. PART IV DIGITAL TRANSFORMATION OF PROCESS 11. Agile Delivery in Digital Transformation 12. Digital Transformation of Incident Management Process PART V DIGITAL TRANSFORMATION OF OPERATIONS 13. Digital Transformation Operations 14. Automation through DevSecOps PART VI DIGITAL TRANSFORMATION CASE STUDIES 15. Digital Transformation Case Studies 16. Digital Transformation of Intranet Platforms
£42.74
O'Reilly Media Digitalization of Financial Services in the Age
Book SynopsisIf you're planning, building, or implementing a cloud strategy that supports digitalization for your financial services business, this invaluable guide clearly sets out the crucial factors and questions to consider first. With it, you'll learn how to avoid the costly and time-consuming pitfalls and disappointments of cloud adoption.
£27.74
Cengage Learning Concepts in Enterprise Resource Planning
Book Synopsis
£115.57
John Wiley & Sons Inc Problem Seeking
Book SynopsisNow in a fully updated new edition, this work presents the leading guide to architectural programming, giving the design practitioner a clear procedure when programming a building of any scale.Table of ContentsForeword vii Preface ix Acknowledgments xi Part One 1 Problem Seeking An Architectural Programming Primer Overview 2 The Primer 2 The Search 4 Programmers and Designers 6 Analysis and Synthesis 8 The Separation 10 The Interface 12 Process 14 Five Steps 14 Procedure 16 Considerations 18 The Whole Problem 18 Four Considerations 20 Framework 22 Information 24 Information Index Matrix 26 Organizing Information 28 Two- Phase Process 30 Data Clog 32 Processing and Discarding 34 Participation 36 User on Team 36 Effective Group Action 38 Team 40 Participatory Process 42 Background Information 43 Decision Making 44 Communication 46 Steps 48 Establish Goals 48 Collect and Analyze Facts 50 Uncover and Test Concepts 52 Determine Needs 66 Cost Estimate Analysis 68 Abstract to the Essence 70 State the Problem 72
£50.36
John Wiley & Sons Inc Higher Order Basis Based Integral Equation Solver
Book SynopsisThe latest in parallel EM solutions with both in-core and out-of-core solvers The solution of complex electromagnetic (EM) problems requires one to address the issues related with numerical accuracy and efficient distribution of the solution procedure over multiple computational nodes. With the advent of multicore processors and high performance computing (HPC) technology, the EM software designers need to know how to add new functionality to computational EM codes so that they can run efficiently on these new processors. Higher Order Basis Based Integral Equation Solver [HOBBIES] presents a road map for the analysis of complex material structures using the high-performance parallel simulation software known as HOBBIES. Focusing on the Method of Moments (MoM), the book features new parallel programming techniques and user-friendly code with superior capabilities for solving challenging EM radiation and scattering problems. It provides readers with Table of ContentsPreface xv Acknowledgments xxi Acronyms xxiii Chapter 1. Electromagnetic Modeling of Composite Metallic and Dielectric Structures Using Higher Order Basis Functions 1 1.0 Summary 1.1 Integral Equations for Dielectric Structures 1.2 A General Formulation for the Analysis of Composite Metallic and Dielectric Structures 5 1.3 Geometric Modeling 8 1.4 MoM Modeling of the Structures 14 1.5 Description of Higher Order Basis Functions 21 1.6 Testing Procedure 28 1.7 Modeling of the Excitations 35 1.8 Examples Illustrating the Requirements of the Geometrical Modeling 39 1.9 Examples Illustrating the Salient Features of the Higher Order Basis Functions 43 1.10 Performance of the PMCHW Formulation Using Higher Order Basis Functions for Different Values of the Dielectric Constants 48 1.11 Performance of the PMCHW Formulation at Very Low Frequencies Using Higher Order Basis Functions for Dielectric Bodies 50 1.12 Evaluation of Antenna and Scatterer Characteristics 52 1.13 Conclusions 55 References 55 Chapter 2. Parallel In-Core and Out-of-Core LU Factorization for Solving a Matrix Equation and the Corresponding Parallel Matrix Filling in HOBBIES 57 2.0 Summary 5 2.1 Matrix Equation Resulting from a MoM Code 58 2.2 In-core Matrix Equation Solver 58 2.3 Parallel Implementation of an In-core Solver 60 2.4 Data Decomposition for an Out-of-Core Solver 64 2.5 On-slab, Left-looking, Out-of-core LU Algorithm 66 2.6 Solving a Matrix Equation Using the Out-of-core LU Matrices 74 2.7 Parallel In-core and Out-of-core Matrix Filling Schemes 76 2.8 Conclusions 80 References 81 Chapter 3. Getting Started and Working with HOBBIES Projects 83 3.0 Summary 83 3.1 System Requirements 83 3.2 Installing HOBBIES 84 3.3 Starting HOBBIES 90 3.4 Navigation through HOBBIES 91 3.5 Working with HOBBIES Projects 101 3.6 Flowchart for Making a HOBBIES Simulation 103 3.7 Exiting HOBBIES 105 3.8 Getting Help 105 3.9 Quick Start 105 3.10 Conclusion 106 References 106 Chapter 4. Creating a Geometry Model in HOBBIES 107 4.0 Summary 107 4.1 Creating a Simple Model Using the Structure Menu 107 4.2 Creating an Arbitrarily Shaped Model Using the Geometry Menu 156 4.3 Operations on a Model 171 4.4 Manipulations on a Model 189 4.5 Delete a Model 197 4.6 Conclusion 197 References 198 Chapter 5. Meshing a Model in HOBBIES 199 5.0 Summary 199 5.1 Unstructured Mesh 200 5.2 Structured Mesh 202 5.3 Element Type 205 5.4 Mesh Criteria 206 5.5 Reset Mesh Data 207 5.6 Draw 208 5.7 Generate Mesh 210 5.8 Erase Mesh 211 5.9 Edit Mesh 211 5.10 Show Errors 212 5.11 Mesh Quality 213 5.12 Mesh Options from Model 214 5.13 Mesh Generation Example for Surfaces 214 5.14 Example of Mesh Generation for a Curve 218 5.15 Assigning Element Sizes for Generating the Mesh 221 5.16 Conclusion 226 References 226 Chapter 6. Setting up a HOBBIES Solution and Running a Simulation 227 6.0 Summary 227 6.1 Operation Mode 228 6.2 Units 228 6.3 Frequency Range 230 6.4 Domains 230 6.5 Loadings 238 6.6 Excitation 242 6.7 Symmetry 248 6.8 Edge 250 6.9 Output Settings 254 6.10 Options 258 6.11 Running Simulations 265 6.12 Conclusion 272 Chapter 7. HOBBIES Post-Processing for Visualizing the Results 273 7.0 Summary 273 7.1 Entering Post-Processing Window 274 7.2 Post-Processing Window 274 7.3 Example of Operations in Post-Processing 280 7.4 Leaving Post-Processing Window 316 7.5 Limitation of Post-Processing display in Academic Version of HOBBIES 320 7.6 Conclusion 320 Chapter 8. Solving Electromagnetic Field Problems Using HOBBIES 321 8.0 Summary 321 8.1 Metallic Structures 322 8.2 Composite Metallic and Dielectric Structures 350 8.3 Loadings 374 8.4 Use of Symmetry in the Analysis of a Problem 398 8.5 Antenna above a Real Ground 428 8.6 Use of Imaging for Generating an Accurate Solution 436 8.7 Conclusion 442 References 442 Chapter 9. Advanced Electromagnetic Modeling Using HOBBIES 443 9.0 Summary 443 9.1 Radiation Analysis of Complicated Antennas 444 9.2 Radar Cross Section (RCS) Calculation of Complex Targets 458 9.3 Conclusion 476 References 476 Chapter 10. HOBBIES Optimizer and its Applications 479 10.0 Summary 10.1 Flowchart of the HOBBIES Optimizer 480 10.2 Optimization Algorithms Used in the Optimizer 482 10.3 Setting up the HOBBIES Optimizer 487 10.4 Optimization Examples 507 10.5 Conclusion 516 References 516 Appendix A. A Brief Summary of Some Commands Used in HOBBIES 517 Appendix B. A List of all Codes in the Accompanying CD 525 Index 531
£173.66
John Wiley & Sons Inc 3D Animation Essentials
Book SynopsisThe essential fundamentals of 3D animation for aspiring 3D artists 3D is everywhere--video games, movie and television special effects, mobile devices, etc. Many aspiring artists and animators have grown up with 3D and computers, and naturally gravitate to this field as their area of interest.Table of ContentsIntroduction xv Chapter 1 3D Animation Overview 1 Defining 3D Animation 1 Exploring the 3D Animation Industry 2 Entertainment 2 Scientific 4 Other 9 The History of 3D Animation 10 Early Computers 10 1960s: The Dawn of Computer Animation 11 1970s: The Building Blocks of 3D Animation 12 1980s: The Foundations of Modern Computing 14 1990s: 3D Animation Achieves Commercial Success 17 2000s: The Refining of 3D Animation 18 The Essentials and Beyond 19 Chapter 2 Getting to Know the Production Pipeline 21 Understanding the Production Pipeline’s Components 21 Working in 3D Animation Preproduction 22 Idea/Story 25 Script/Screenplay 27 Storyboard 28 Animatic/Pre-visualization 29 Design 30 Working in 3D Animation Production 33 Layout 34 Research and Development 36 Modeling 37 Texturing 39 Rigging/Setup 40 Animation 41 3D Visual Effects 41 Lighting/Rendering 42 Working in 3D Animation Postproduction 43 Compositing 44 2D Visual Effects/Motion Graphics 44 Color Correction 44 Final Output 45 Using Production Tools 45 Production Bible 46 Folder Management and Naming Conventions 52 The Essentials and Beyond 52 Chapter 3 Understanding Digital Imaging and Video 55 Understanding Digital Imaging 55 Pixels 55 Raster Graphics vs. Vector Graphics 58 Anti-Aliasing 59 Basic Graphic-File Formats 62 Channels 64 Color Depth or Bit Depth 66 Color Calibration 68 Understanding Digital Video 71 Resolution, Device Aspect Ratio, and Pixel Aspect Ratio 72 Safe Areas 74 Interlaced and Progressive Scanning 75 Compression 78 Frame Rate and Timecode 79 Digital Image Capture 80 The Essentials and Beyond 81 Chapter 4 Exploring Animation, Story, and Pre-visualization 83 Using Principles of Fine Art and Traditional Animation 83 Modeling 84 Texturing/Lighting 87 Character Animation 93 VFX 104 Building a Good Story 105 Story Arc 105 Character, Goal, and Conflict 106 The Hero’s Journey 110 Other Storytelling Principles 112 Using Pre-visualization Techniques 113 Basic Shot Framing 114 Camera Movements 126 Editing 130 The Essentials and Beyond 132 Chapter 5 Understanding Modeling and Texturing 135 Modeling 135 Polygons 136 NURBS 150 Subdivision Surfaces 153 Modeling Workflows 154 Texturing 158 UVs 160 Shaders 163 Texture Maps 167 Texturing Workflows 173 The Essentials and Beyond 174 Chapter 6 Rigging and Animation 177 Rigging 177 Parenting 179 Pivot Positions 180 Skeleton System 182 Forward and Inverse Kinematics 185 Deformers 186 Constraints 190 Scripting 191 Expressions 191 The Basic Rigging Workflow 192 Animation 193 Keyframe 196 Graph Editor 197 Timeline 202 Dope Sheet 202 Workspace 202 Tracking Marks and Ghosting 204 FK and IK 204 Video Reference 206 The Basic Animation Workflow 206 Animation Techniques 206 The Essentials and Beyond 210 Chapter 7 Understanding Visual Effects, Lighting, and Rendering 213 Creating Visual Effects 213 Particles 214 Hair and Fur 216 Fluids 218 Rigid Bodies 220 Soft Bodies 222 The Basic VFX Workflow 225 Lighting 225 Light Types 226 Light Attributes 230 Lighting Techniques 233 The Basic Lighting Workflow 236 Rendering 237 Basic Rendering Methods 237 Global Illumination 240 Advanced Shader Functions 243 The Basic Rendering Workflow 244 The Essentials and Beyond 246 Chapter 8 Hardware and Software Tools of the Trade 249 Choosing a Computer 250 Choosing a Computer Type 250 Understanding Operating Systems 252 Selecting the Components 255 Using Monitors/Displays 260 Working with Graphics Tablets 261 Using 3D Scanners 262 Setting Up Render Farms 264 Finding Data Storage Solutions 265 Local 266 Local Networked 266 Offsite 267 Cloud/Internet 267 Choosing Software 268 Comprehensive 3D Animation Packages 268 CAD 269 Compositing 269 Digital Imaging 270 3D Specialty 270 The Essentials and Beyond 272 Chapter 9 Industry Trends 275 Using Motion Capture 275 Marker Systems 276 Markerless Systems 277 Creating Stereoscopic 3D 278 Integrating Point-Cloud Data 281 Providing Real-Time Capabilities 282 Real-Time Rendering 284 Real-Time Animation 285 Real-Time Motion Performance 287 Working in Virtual Studios 288 The Essentials and Beyond 289 Appendix A Answers to Review Questions 291 Appendix B Gaining Insight into 3D Animation Education 299 Linda Sellheim 299 Larry Richman 303 Steve Kolbe 307 Appendix C Learning from Industry Pros 313 Brian Phillips 313 Jim Rivers 316 Rosie Server 321 Index 327
£25.60
John Wiley & Sons Inc Auditors Guide to IT Auditing Software Demo
Book SynopsisStep-by-step guide to successful implementation and control of IT systemsincluding the Cloud Many auditors are unfamiliar with the techniques they need to know to efficiently and effectively determine whether information systems are adequately protected. Now in a Second Edition, Auditor''s Guide to IT Auditing presents an easy, practical guide for auditors that can be applied to all computing environments. Follows the approach used by the Information System Audit and Control Association''s model curriculum, making this book a practical approach to IS auditing Serves as an excellent study guide for those preparing for the CISA and CISM exams Includes discussion of risk evaluation methodologies, new regulations, SOX, privacy, banking, IT governance, CobiT, outsourcing, network management, and the Cloud Includes a link to an education version of IDEA--Data Analysis Software As networks and enterprise resource planning Table of ContentsPreface xvii Part I: IT Audit Process 1 Chapter 1: Technology and Audit 3 Technology and Audit 4 Batch and Online Systems 8 Electronic Data Interchange 20 Electronic Business 21 Cloud Computing 22 Chapter 2: IT Audit Function Knowledge 25 Information Technology Auditing 25 What Is Management? 26 Management Process 26 Understanding the Organization’s Business 27 Establishing the Needs 27 Identifying Key Activities 27 Establish Performance Objectives 27 Decide the Control Strategies 27 Implement and Monitor the Controls 28 Executive Management’s Responsibility and Corporate Governance 28 Audit Role 28 Conceptual Foundation 29 Professionalism within the IT Auditing Function 29 Relationship of Internal IT Audit to the External Auditor 30 Relationship of IT Audit to Other Company Audit Activities 30 Audit Charter 30 Charter Content 30 Outsourcing the IT Audit Activity 31 Regulation, Control, and Standards 31 Chapter 3: IT Risk and Fundamental Auditing Concepts 33 Computer Risks and Exposures 33 Effect of Risk 35 Audit and Risk 36 Audit Evidence 37 Conducting an IT Risk-Assessment Process 38 NIST SP 800 30 Framework 38 ISO 27005 39 The “Cascarino Cube” 39 Reliability of Audit Evidence 44 Audit Evidence Procedures 45 Responsibilities for Fraud Detection and Prevention 46 Notes 46 Chapter 4: Standards and Guidelines for IT Auditing 47 IIA Standards 47 Code of Ethics 48 Advisory 48 Aids 48 Standards for the Professional Performance of Internal Auditing 48 ISACA Standards 49 ISACA Code of Ethics 50 COSO: Internal Control Standards 50 BS 7799 and ISO 17799: IT Security 52 NIST 53 BSI Baselines 54 Note 55 Chapter 5: Internal Controls Concepts Knowledge 57 Internal Controls 57 Cost/Benefit Considerations 59 Internal Control Objectives 59 Types of Internal Controls 60 Systems of Internal Control 61 Elements of Internal Control 61 Manual and Automated Systems 62 Control Procedures 63 Application Controls 63 Control Objectives and Risks 64 General Control Objectives 64 Data and Transactions Objectives 64 Program Control Objectives 66 Corporate IT Governance 66 COSO and Information Technology 68 Governance Frameworks 70 Notes 71 Chapter 6: Risk Management of the IT Function 73 Nature of Risk 73 Risk-Analysis Software 74 Auditing in General 75 Elements of Risk Analysis 77 Defining the Audit Universe 77 Computer System Threats 79 Risk Management 80 Notes 83 Chapter 7: Audit Planning Process 85 Benefits of an Audit Plan 85 Structure of the Plan 89 Types of Audit 91 Chapter 8: Audit Management 93 Planning 93 Audit Mission 94 IT Audit Mission 94 Organization of the Function 95 Staffing 95 IT Audit as a Support Function 97 Planning 97 Business Information Systems 98 Integrated IT Auditor versus Integrated IT Audit 98 Auditees as Part of the Audit Team 100 Application Audit Tools 100 Advanced Systems 100 Specialist Auditor 101 IT Audit Quality Assurance 101 Chapter 9: Audit Evidence Process 103 Audit Evidence 103 Audit Evidence Procedures 103 Criteria for Success 104 Statistical Sampling 105 Why Sample? 106 Judgmental (or Non-Statistical) Sampling 106 Statistical Approach 107 Sampling Risk 107 Assessing Sampling Risk 108 Planning a Sampling Application 109 Calculating Sample Size 111 Quantitative Methods 111 Project-Scheduling Techniques 116 Simulations 117 Computer-Assisted Audit Solutions 118 Generalized Audit Software 118 Application and Industry-Related Audit Software 119 Customized Audit Software 120 Information-Retrieval Software 120 Utilities 120 On-Line Inquiry 120 Conventional Programming Languages 120 Microcomputer-Based Software 121 Test Transaction Techniques 121 Chapter 10: Audit Reporting Follow-up 123 Audit Reporting 123 Interim Reporting 124 Closing Conferences 124 Written Reports 124 Clear Writing Techniques 125 Preparing to Write 126 Basic Audit Report 127 Executive Summary 127 Detailed Findings 128 Polishing the Report 129 Distributing the Report 129 Follow-up Reporting 129 Types of Follow-up Action 130 Part II: Information Technology Governance 131 Chapter 11: Management 133 IT Infrastructures 133 Project-Based Functions 134 Quality Control 138 Operations and Production 139 Technical Services 140 Performance Measurement and Reporting 140 Measurement Implementation 141 Notes 145 Chapter 12: Strategic Planning 147 Strategic Management Process 147 Strategic Drivers 148 New Audit Revolution 149 Leveraging IT 149 Business Process Re-Engineering Motivation 150 IT as an Enabler of Re-Engineering 151 Dangers of Change 152 System Models 152 Information Resource Management 153 Strategic Planning for IT 153 Decision Support Systems 155 Steering Committees 156 Strategic Focus 156 Auditing Strategic Planning 156 Design the Audit Procedures 158 Note 158 Chapter 13: Management Issues 159 Privacy 161 Copyrights, Trademarks, and Patents 162 Ethical Issues 162 Corporate Codes of Conduct 163 IT Governance 164 Sarbanes-Oxley Act 166 Payment Card Industry Data Security Standards 166 Housekeeping 167 Notes 167 Chapter 14: Support Tools and Frameworks 169 General Frameworks 169 COSO: Internal Control Standards 172 Other Standards 173 Governance Frameworks 176 Note 178 Chapter 15: Governance Techniques 179 Change Control 179 Problem Management 181 Auditing Change Control 181 Operational Reviews 182 Performance Measurement 182 ISO 9000 Reviews 184 Part III: Systems and Infrastructure Lifecycle Management 185 Chapter 16: Information Systems Planning 187 Stakeholders 187 Operations 188 Systems Development 189 Technical Support 189 Other System Users 191 Segregation of Duties 191 Personnel Practices 192 Object-Oriented Systems Analysis 194 Enterprise Resource Planning 194 Cloud Computing 195 Notes 197 Chapter 17: Information Management and Usage 199 What Are Advanced Systems? 199 Service Delivery and Management 201 Computer-Assisted Audit Tools and Techniques 204 Notes 205 Chapter 18: Development, Acquisition, and Maintenance of Information Systems 207 Programming Computers 207 Program Conversions 209 No Thanks Systems Development Exposures 209 Systems Development Controls 210 Systems Development Life Cycle Control: Control Objectives 210 Micro-Based Systems 212 Cloud Computing Applications 212 Note 213 Chapter 19: Impact of Information Technology on the Business Processes and Solutions 215 Impact 215 Continuous Monitoring 216 Business Process Outsourcing 218 E-Business 219 Notes 220 Chapter 20: Software Development 221 Developing a System 221 Change Control 225 Why Do Systems Fail? 225 Auditor’s Role in Software Development 227 Chapter 21: Audit and Control of Purchased Packages and Services 229 IT Vendors 230 Request For Information 231 Requirements Definition 231 Request for Proposal 232 Installation 233 Systems Maintenance 233 Systems Maintenance Review 234 Outsourcing 234 SAS 70 Reports 234 Chapter 22: Audit Role in Feasibility Studies and Conversions 237 Feasibility Success Factors 237 Conversion Success Factors 240 Chapter 23: Audit and Development of Application Controls 243 What Are Systems? 243 Classifying Systems 244 Controlling Systems 244 Control Stages 245 Control Objectives of Business Systems 245 General Control Objectives 246 CAATs and Their Role in Business Systems Auditing 247 Common Problems 249 Audit Procedures 250 CAAT Use in Non-Computerized Areas 250 Designing an Appropriate Audit Program 250 Part IV: Information Technology Service Delivery and Support 253 Chapter 24: Technical Infrastructure 255 Auditing the Technical Infrastructure 257 Infrastructure Changes 259 Computer Operations Controls 260 Operations Exposures 261 Operations Controls 261 Personnel Controls 261 Supervisory Controls 262 Information Security 262 Operations Audits 263 Notes 264 Chapter 25: Service-Center Management 265 Private Sector Preparedness (PS Prep) 266 Continuity Management and Disaster Recovery 266 Managing Service-Center Change 269 Notes 269 Part V: Protection of Information Assets 271 Chapter 26: Information Assets Security Management 273 What Is Information Systems Security? 273 Control Techniques 276 Workstation Security 276 Physical Security 276 Logical Security 277 User Authentication 277 Communications Security 277 Encryption 277 How Encryption Works 278 Encryption Weaknesses 279 Potential Encryption 280 Data Integrity 280 Double Public Key Encryption 281 Steganography 281 Information Security Policy 282 Notes 282 Chapter 27: Logical Information Technology Security 283 Computer Operating Systems 283 Tailoring the Operating System 284 Auditing the Operating System 285 Security 286 Criteria 286 Security Systems: Resource Access Control Facility 287 Auditing RACF 288 Access Control Facility 2 289 Top Secret 290 User Authentication 291 Bypass Mechanisms 293 Security Testing Methodologies 293 Notes 295 Chapter 28: Applied Information Technology Security 297 Communications and Network Security 297 Network Protection 298 Hardening the Operating Environment 300 Client Server and Other Environments 301 Firewalls and Other Protection Resources 301 Intrusion-Detection Systems 303 Note 304 Chapter 29: Physical and Environmental Security 305 Control Mechanisms 306 Implementing the Controls 310 Part VI: Business Continuity and Disaster Recovery 311 Chapter 30: Protection of the Information Technology Architecture and Assets: Disaster-Recovery Planning 313 Risk Reassessment 314 Disaster—Before and After 315 Consequences of Disruption 317 Where to Start 317 Testing the Plan 319 Auditing the Plan 320 Chapter 31: Displacement Control 323 Insurance 323 Self-Insurance 327 Part VII: Advanced It Auditing 329 Chapter 32: Auditing E-commerce Systems 331 E-Commerce and Electronic Data Interchange: What Is It? 331 Opportunities and Threats 332 Risk Factors 335 Threat List 335 Security Technology 336 “Layer” Concept 336 Authentication 336 Encryption 337 Trading Partner Agreements 338 Risks and Controls within EDI and E-Commerce 338 E-Commerce and Auditability 340 Compliance Auditing 340 E-Commerce Audit Approach 341 Audit Tools and Techniques 341 Auditing Security Control Structures 342 Computer-Assisted Audit Techniques 343 Notes 343 Chapter 33: Auditing UNIX/Linux 345 History 345 Security and Control in a UNIX/Linux System 347 Architecture 348 UNIX Security 348 Services 349 Daemons 350 Auditing UNIX 350 Scrutiny of Logs 351 Audit Tools in the Public Domain 351 UNIX Password File 352 Auditing UNIX Passwords 353 Chapter 34: Auditing Windows VISTA and Windows 7 355 History 355 NT and Its Derivatives 356 Auditing Windows Vista/Windows 7 357 Password Protection 358 VISTA/Windows 7 359 Security Checklist 359 Chapter 35: Foiling the System Hackers 361 Chapter 36: Preventing and Investigating Information Technology Fraud 367 Preventing Fraud 367 Investgation 369 Identity Theft 376 Note 376 Appendix A Ethics and Standards for the IS Auditor 377 ISACA Code of Professional Ethics 377 Relationship of Standards to Guidelines and Procedures 378 Appendix B Audit Program for Application Systems Auditing 379 Appendix C Logical Access Control Audit Program 393 Appendix D Audit Program for Auditing UNIX/Linux Environments 401 Appendix E Audit Program for Auditing Windows VISTA and Windows 7 Environments 407 About the Author 415 About the Website 417 Index 419
£60.00
John Wiley & Sons Inc Game Character Creation with Blender and Unity
Book SynopsisA complete guide to creating usable, realistic game characters with two powerful tools Creating viable game characters requires a combination of skills. This book teaches game creators how to create usable, realistic game assets using the power of an open-source 3D application and a free game engine.Table of ContentsIntroduction xv Chapter 1: Basic Game Art Concepts 1 Game Design Workflows 2 Creating Game Assets 4 Understanding and Optimizing 3D Game Art 9 Working with Game Engines 20 Scripting Happens 21 Chapter 2: Blender Basics for Game Characters 23 Working with Blender’s Unique Features 24 Working with Editor Arrangement and Types 26 Navigating and Viewing 3D Space 32 Creating and Manipulating Objects 33 Using the Properties Editor 36 Know Your Hotkeys 37 Making a Simple Block Character 39 Useful Techniques 44 Chapter 3: Modeling the Character 45 Working with Model Sheets 46 Shaping the Torso for Low Polygon Count 48 Extruding the Legs and Feet 51 Making the Arms and Hands 56 Separating Body Components to Create Clothing 62 Creating the Head with Poly-by-Poly Modeling 65 Carving Out Zombie Damage 82 Chapter 4: Prepping for Zombie Details with UV Unwrapping 87 The Uses of UV Layouts 88 Drawing Seams 89 Using Blender's UV/Image Editor 97 Laying Out a UV Sheet 100 Using Blender's Live Unwrap Functions 102 Chapter 5: Sculpting for Normal Maps 105 The Purpose of Sculpting 106 Introducing the Multires Modifier 107 Using Blender's Sculpting Interface 110 Sculpting the Zombie in Blender 120 Baking Normal Maps 128 Chapter 6: Digital Painting Color Maps 135 Understanding Digital Painting 136 Preparing for Color Map Painting 142 Digital Painting Best Practices 144 Applying Your Color Map to the Zombie 154 Chapter 7: Rigging for Realistic Movement 157 Understanding Rigging 158 Creating a Simple Armature 164 Finishing the Armature with Constraints 175 Linking the Armature and Zombie 184 Chapter 8: Animating the Zombie 193 Understanding and Planning Game Animation 194 Using Blender's Animation System 200 Creating an Idle Animation 203 Creating a Walk Animation 208 Creating a Chase Animation 210 Creating a Run Animation 212 Organizing Your Animations 214 Chapter 9: Unity Engine Basics 217 Understanding Unity’s Logic and Interface 218 Building a Whiteblock Level with Unity Primitives 223 Creating and Editing Materials in Unity 232 Organizing Assets with Unity Empties 234 Chapter 10: Implementing Your Zombie in a Unity Game 237 Importing Models into Unity 238 Unity Scripting--A Crash Course 240 Adding Interactivity to the Zombie 247 Turning the First Person Controller into an FPS Hero 259 Adding Other Gameplay Elements 270 Wrapping Up 278 Index 279
£26.24
John Wiley & Sons Inc Trillions
Book SynopsisWe are facing a future of unbounded complexity. Whether that complexity is harnessed to build a world that is safe, pleasant, humane and profitable, or whether it causes us to careen off a cliff into an abyss of mind-numbing junk is an open question.Trade Review“This book provides a refreshing, insightful guide to how companies can prepare for future technology innovations and thrive in this emerging information age. Summing Up: Recommended. Business and computer science collections serving upper-division undergraduates and above; general readers.” (Choice, 1 July 2013)Table of ContentsPreface xi Acknowledgments xvii Chapter 1 The Future, So Far 01 Trillions Is a Done Deal 02 Connectivity Will Be the Seed of Change 05 Computing Turned Inside Out 07 The Power of Digital Literacy 11 Chapter 2 The Next Mountain 15 Fungible Devices 16 Liquid Information 25 Cyberspace for Real 30 Interlude Yesterday, Today, Tomorrow: Platforms and User Interfaces 39 Yesterday 40 Today 41 Tomorrow 44 Chapter 3 The Tyranny of the Orthodoxy 51 Information Interruptus 52 The King and the Mathematician 60 Links to Nowhere 63 The Wrong Cloud 65 The Dream of One Big Computer 67 The Grand Repository in the Sky 68 FUD and the Birth of the Impostor Cloud 69 The Children’s Crusade 71 The Peer-to-Peer Bogey 80 Chapter 4 How Nature Does It 83 The Internet of Plants 84 Nature Has Been There Before 85 The Qualities of Beautiful Complexity 93 At the Intersection of People and Information 102 Chapter 5 How Design Does It 105 Birth of Industrial Design 107 Novelty, Beauty, Ritual, and Comfort 113 Hearing History Rhyme 114 Instability as the Status Quo 117 Post-Industrial Design 119 Interlude Yesterday, Today, Tomorrow: Data Storage 133 Yesterday 133 Today 136 Tomorrow 136 Chapter 6 Design Science on Trillions Mountain 139 Beyond Design Thinking to Design Science 140 Make the Right Thing 143 Chapter 7 Architecture with a Capital “A” 167 Architecture as Organic Principles 169 Architecture as Model 170 Architecture as “Style” 171 Information Architecture 173 Architecture and Design Science 178 Chapter 8 Life in an Information Ecology 181 Components 183 Challenges in the Information Ecology 188 Chapter 9 Aspects of Tomorrow 205 Beyond the Internet 206 Simplification 208 Devices 210 The Information Commons 212 The World Wide Dataflow 213 Publishing 216 Safety, Security, and Privacy 218 Epilogue Thriving in the Spacious Foothills 221 Seize the Low Ground 224 Microtransactions and the Rise of T-Commerce 225 Strange Bedfellows 226 Big Data and Information Visualization 226 The Trillions Bubble 227 Notes 231 About the Authors 245 Index 247
£21.59
John Wiley & Sons Inc Teach Yourself VISUALLY Adobe Photoshop CS6
Book SynopsisGets visual learners up to speed on the newest enhancements in Photoshop Photoshop is constantly evolving, and the newest version offers great new tools for photographers. This popular guide gets visual learners up to speed quickly; previous editions have sold more than 150,000 copies.Table of ContentsChapter 1 Getting StartedWork with Images 4Understanding Photoshop 6Start Photoshop on a PC 8Start Photoshop on a Mac 9The Photoshop Workspace 10Find Images for Your Projects 11Set Preferences 12Save a Workspace 14Open an Image 16Browse for an Image in Bridge 18Sort and Filter Images in Bridge 20Display a Slide Show in Bridge 22Import Images from a Camera in Bridge 24Create a New Image 26Exit Photoshop 27 Chapter 2 Understanding Photoshop BasicsIntroducing the Photoshop Toolbox 30Work with Toolbox Tools 32Magnify with the Zoom Tool 34Adjust Views 36Change Screen Modes 38Using Rulers and Guides 40Undo Commands 42Revert an Image 43Manage Image Windows 44 Chapter 3 Changing the Size of an ImageChange the On-Screen Size of an Image 48Change the Print Size of an Image 50Change the Resolution of an Image 52Crop an Image 54Crop and Straighten Photos 56Trim an Image 57Change the Canvas Size of an Image 58 Chapter 4 Making SelectionsSelect with the Marquee Tools 62Select with the Lasso Tool 64Select with the Magnetic Lasso Tool 66Select with the Quick Selection Tool 68Select with the Magic Wand Tool 70Select with the Color Range Command 72Select All the Pixels in an Image 74Move a Selection Border 75Add to or Subtract from a Selection 76Invert a Selection 78Grow a Selection 79Create Slices 80 Chapter 5 Manipulating SelectionsMove a Selection 84Copy and Paste a Selection 86Delete a Selection 88Rotate a Selection 89Scale a Selection 90Skew or Distort a Selection 92Perform Content-Aware Scaling 94Refine a Selection Edge 96Feather the Border of a Selection 98Create Vanishing Point Planes 100Copy between Vanishing Point Planes 102Using the Content-Aware Move Tool 104 Chapter 6 Painting and Drawing with ColorSelect the Foreground and Background Colors 108Select a Color with the Eyedropper Tool 110Select a Color with the Swatches Panel 111Using the Brush Tool 112Change Brush Styles 114Create a Custom Brush 116Using the Mixer Brush 118Apply a Gradient 120Fill a Selection 122Using Content-Aware Fill 124Stroke a Selection 126Using the Clone Stamp 128Using the Pattern Stamp 130Using the Spot Healing Brush 132Using the Healing Brush 134Using the Patch Tool 136Using the History Brush 138Using the Eraser 140Replace a Color 142Fix Red Eye in a Photo 144 Chapter 7 Adjusting Lighting and ColorsChange Brightness and Contrast 148Using the Dodge and Burn Tools 150Using the Blur and Sharpen Tools 152Adjust Levels 154Adjust Curves 156Adjust Hue and Saturation 158Using the Sponge Tool 160Adjust Color Balance 162Using the Variations Command 164Match Colors between Images 166Correct Shadows and Highlights 168Create a Duotone 170Convert to Black and White 172Adjust Vibrance 174 Chapter 8 Working with LayersWhat Are Layers? 178Create and Add to a Layer 180Hide a Layer 182Move a Layer 183Duplicate a Layer 184Delete a Layer 185Reorder Layers 186Change the Opacity of a Layer 188Merge Layers 190Rename a Layer 192Transform a Layer 193Create a Solid Fill Layer 194Create an Adjustment Layer 196Edit an Adjustment Layer 198Apply an Adjustment-Layer Preset 200Link Layers 202Blend Layers 204Work with Smart Objects 206Create a Layer Group 210Filter Layers 212Add a Layer Mask 214Edit a Layer Mask 216 Chapter 9 Applying Layer StylesApply a Drop Shadow 220Apply an Outer Glow 222Apply Beveling and Embossing 224Apply Multiple Styles to a Layer 226Edit a Layer Style 228Using the Styles Panel 230 Chapter 10 Applying FiltersTurn an Image into a Painting 234Blur an Image 236Sharpen an Image 238Distort an Image 240Add Noise to an Image 242Turn an Image into Shapes 244Turn an Image into a Charcoal Sketch 246Apply Glowing Edges to an Image 248Add Texture to an Image 250Offset an Image 252Using the Liquify Filter 254Apply Multiple Filters 256Using Smart Filters 258 Chapter 11 Drawing ShapesDraw a Shape 262Draw a Custom Shape 264Draw a Straight Line 266Draw a Shape with the Pen 268Edit a Shape 270 Chapter 12 Adding and Manipulating TypeAdd Type to an Image 274Add Type in a Bounding Box 276Change the Formatting of Type 278Change the Color of Type 280Warp Type 282 Chapter 13 Automating Your WorkRecord an Action 286Play an Action 288Batch Process by Using an Action 290Create a PDF of Images 292Create a Web Photo Gallery 294Create a Panoramic Image 298Create an HDR Image 300Convert File Types 302Batch Rename Images 304Using Tool Presets 306 Chapter 14 Saving and Printing ImagesSave in the Photoshop Format 310Save an Image for Use in Another Application 312Save a JPEG for the Web 314Save a GIF for the Web 316Save a PNG for the Web 318Add Descriptive and Copyright Information 320Save a Sliced Image 322Print by Using a PC 324Print by Using a Mac 326 Index 328
£19.79
John Wiley & Sons Inc Software in 30 Days
Book SynopsisA radical approach to getting IT projects done faster and cheaper than anyone thinks possible Software in 30 Days summarizes the Agile and Scrum software development method, which allows creation of game-changing software, in just 30 days. Projects that use it are three times more successful than those that don''t. Software in 30 Days is for the business manager, the entrepreneur, the product development manager, or IT manager who wants to develop software better and faster than they now believe possible. Learn how this unorthodox process works, how to get started, and how to succeed. Control risk, manage projects, and have your people succeed with simple but profound shifts in the thinking. The authors explain powerful concepts such as the art of the possible, bottom-up intelligence, and why it''s good to fail earlyall with no risk greater than thirty days. The productivity gain vs traditional waterfall methods has been over 100% on many prTable of ContentsAbout the Authors xi Acknowledgments xiii Introduction xv Section I Why Every Business in the World Can Produce Software in 30 Days 1 You are probably frustrated with your software organization. You would like it to be quicker, more flexible, understand your needs better, and help you become more profitable. We look at why you are frustrated and how to fix the problem. 1 The Crisis in Software: The Wrong Process Produces the Wrong Results 3 Many software organizations follow a development process that guarantees waste, uncontrolled risk, unpredictability, surprises, and low value. We will investigate why this process was chosen, how it guarantees failure, and look and some organizations that have recovered from it. 2 Scrum: The Right Process Produces the Right Results 17 There is a process that is appropriate for software development. When you get your developers to use it, you will immediately gain productivity, quality, value, control, predictability, and satisfaction. We look at how this happens in this chapter. 3 Try It Yourself: The Pilot 33 You have read our assertion that there is a better way for you to get software developed for you. However, a lot of people have made assertions and taken a lot of your money in the past, with little or no improvement. In this chapter we show you how to prove that our approach works for no money. 4 What Can I Do? 49 You learned how to do better and you’ve tried it yourself. You like the results and you know what to tell the software organization to do. In this chapter, we look at what you can do to help what you experience in the pilot project succeed. Section II How to Produce Software in 30 Days 55 Having better software developed for your needs is not so much hard as it is different from what you are used to. In this section, we look at a progressively beneficial set of approaches to get you from where you are now to organizational agility. 5 Getting Started with Scrum 57 Our secret sauce for improving your benefits from software is called “Scrum.” Yes, this is the rugby event that keeps the ball moving down the field. We’ll discuss Scrum, how it works, and why it works in this chapter. 6 Scrum at the Project Level 63 Most persistent improvement in software development starts at the project level. You can use Scrum to further prove its utility, or on critically important initiative that must succeed. We’ll explore what you can tell your developers to do after reading this chapter. 7 Develop a Scrum Capability 75 Success often breeds success. As more software initiatives using Scrum succeed, more people will want to get on the wagon. Rather than changing the entire organization, let’s look at how we can set up a software development universe separate from the disappointing, existing department. You can increasingly reap benefits here on an increasing number of projects and releases. 8 Scrum at the Enterprise Level 101 Scrum at a project or release level provides initiative level agility, the ability to rapidly respond to opportunities or rise to challenges. To gain the most significant benefits, Scrum’s empirical approach to software development must be fit into the organization as a whole. We’ll look at how to do this, and why some approaches are short-lived and others persist. 9 Enterprise Transformation: Profound and Persistent Change 107 You want to make your organization leaner, more efficient, and agile on your watch. Even more, you want these benefits and their underlying causes to persist and become the organizational culture. We’ll look at an enterprise change approach for achieving this in this chapter. 10 Scrumming Scrum 119 We devised Scrum for complex problem solving, like software development. We found Scrum a useful technique for managing organizational change, also a complex problem. The same benefits of transparency, waste removal, risk control, and predictability occurred. We’ll look at this use of Scrum in this chapter. Appendix 1: Terminology 127 We slowly and progressively introduced some new terminology. This appendix is your reference for those terms. Appendix 2: The Scrum Guide 133 Read the canonical guide to Scrum, its roles, artifacts, and events. This is the bible of Scrum. Appendix 3: A Playbook for Achieving Enterprise Agility 153 This appendix presents a more detailed plan for enterprise change, as discussed in Chapter 10. Index 185
£18.39
John Wiley & Sons Inc PowerPoint 2013 Bible
Book SynopsisMaster PowerPoint and improve your presentation skills with one book! In today's business climate, you need to know PowerPoint inside and out, and that's not all. You also need to be able to make a presentation that makes an impact.Table of ContentsPreface xxxv Part I: Building Your Presentation 1 Chapter 1: A First Look at PowerPoint 3 Chapter 2: Creating and Saving Presentation Files 41 Chapter 3: Creating Slides and Text Boxes 71 Chapter 4: Working with Layouts, Themes, and Masters 99 Chapter 5: Formatting Text 141 Chapter 6: Formatting Paragraphs and Text Boxes 179 Chapter 7: Correcting and Improving Text 207 Chapter 8: Creating and Formatting Tables 229 Part II: Using Graphics and Multimedia Content 255 Chapter 9: Drawing and Formatting Objects 257 Chapter 10: Creating SmartArt Graphics 313 Chapter 11: Working with Clip Art and Photos 335 Chapter 12: Working with Charts 377 Chapter 13: Incorporating Content from Other Programs 419 Chapter 14: Adding Sound Effects, Music, and Soundtracks 435 Chapter 15: Incorporating Motion Video 459 Chapter 16: Creating Animation Effects and Transitions 485 Part III: Interfacing with Your Audience 517 Chapter 17: Creating Support Materials 519 Chapter 18: Preparing for a Live Presentation 543 Chapter 19: Designing User-Interactive or Self-Running Presentations 577 Chapter 20: Preparing a Presentation for Mass Distribution 609 Chapter 21: Sharing and Collaborating 627 Chapter 22: Customizing PowerPoint 647 Part IV: Project Labs 673 Lab 1: Presenting Content without Bulleted Lists 675 Lab 2: Adding Sound and Movement to a Presentation 693 Lab 2A: Fading Text and Graphics In and Out 693 Lab 2B: Replacing One Picture with Another 701 Lab 2C: Zooming In on a Picture 704 Lab 2D: More Animation Practice 705 Lab 2E: Using Transitions and Soundtracks 709 Lab 3: Creating a Menu-Based Navigation System 713 Lab 4: Creating a Classroom Game 733 Appendix A: What Makes a Great Presentation? 753 Appendix B: Essential SkyDrive Skills 775 Index 787
£26.40
John Wiley & Sons Inc Word 2013 For Dummies
Book SynopsisThis bestselling guide to Microsoft Word is the first and last word on Word 2013 It's a whole new Word, so jump right into this book and learn how to make the most of it.Table of ContentsIntroduction 1 Part I: Getting Started with Word 2013 7 Chapter 1: Hello, Word! 9 Chapter 2: The Typing Chapter 21 Part II: Your Basic Word 31 Chapter 3: To and Fro in a Document 33 Chapter 4: Text Editing 41 Chapter 5: Search for This, Replace It with That 49 Chapter 6: Blocks o’ Text 61 Chapter 7: Spell It Write 73 Chapter 8: Document Calisthenics: New, Open, Save, and Close 83 Chapter 9: Publish Your Document 95 Part III: Fun with Formatting 107 Chapter 10: Character Formatting 109 Chapter 11: Paragraph Formatting 121 Chapter 12: Tab Formatting 133 Chapter 13: Page Formatting 149 Chapter 14: Document Formatting 161 Chapter 15: Style Formatting 173 Chapter 16: Template and Themes Formatting 185 Chapter 17: Sundry Formatting 195 Part IV: Spruce Up a Dull Document 205 Chapter 18: Lines and Shading 207 Chapter 19: Able Tables 215 Chapter 20: Columns of Text 227 Chapter 21: Lots of Lists 233 Chapter 22: Here Come the Graphics 241 Chapter 23: Fun with the Insert Tab 255 Part V: The Rest of Word 265 Chapter 24: Multiple Documents, Windows, and File Formats 267 Chapter 25: Word for Writers 275 Chapter 26: Let’s Work This Out 289 Chapter 27: Mail Merge Mania 299 Chapter 28: Labels of Love 315 Chapter 29: A More Custom Word 323 Part VI: The Part of Tens 331 Chapter 30: The Ten Commandments of Word 333 Chapter 31: Ten Cool Tricks 337 Chapter 32: Ten Bizarre Things 345 Chapter 33: Ten Avuncular Suggestions 351 Index 355
£15.29
John Wiley & Sons Inc Big Data For Dummies
Book SynopsisFind the right big data solution for your business or organization Big data management is one of the major challenges facing business, industry, and not-for-profit organizations.Table of ContentsIntroduction 1 About This Book 2 Foolish Assumptions 2 How This Book Is Organized 3 Part I: Getting Started with Big Data 3 Part II: Technology Foundations for Big Data 3 Part III: Big Data Management 3 Part IV: Analytics and Big Data 4 Part V: Big Data Implementation 4 Part VI: Big Data Solutions in the Real World 4 Part VII: The Part of Tens 4 Glossary 4 Icons Used in This Book 5 Where to Go from Here 5 Part I: Getting Started with Big Data 7 Chapter 1: Grasping the Fundamentals of Big Data 9 The Evolution of Data Management 10 Understanding the Waves of Managing Data 11 Wave 1: Creating manageable data structures 11 Wave 2: Web and content management 13 Wave 3: Managing big data 14 Defining Big Data 15 Building a Successful Big Data Management Architecture 16 Beginning with capture, organize, integrate, analyze, and act 16 Setting the architectural foundation 17 Performance matters 20 Traditional and advanced analytics 22 The Big Data Journey 23 Chapter 2: Examining Big Data Types 25 Defining Structured Data 26 Exploring sources of big structured data 26 Understanding the role of relational databases in big data 27 Defining Unstructured Data 29 Exploring sources of unstructured data 29 Understanding the role of a CMS in big data management 31 Looking at Real-Time and Non-Real-Time Requirements 32 Putting Big Data Together 33 Managing different data types 33 Integrating data types into a big data environment 34 Chapter 3: Old Meets New: Distributed Computing 37 A Brief History of Distributed Computing 37 Giving thanks to DARPA 38 The value of a consistent model 39 Understanding the Basics of Distributed Computing 40 Why we need distributed computing for big data 40 The changing economics of computing 40 The problem with latency 41 Demand meets solutions 41 Getting Performance Right 42 Part II: Technology Foundations for Big Data 45 Chapter 4: Digging into Big Data Technology Components 47 Exploring the Big Data Stack 48 Layer 0: Redundant Physical Infrastructure 49 Physical redundant networks 51 Managing hardware: Storage and servers 51 Infrastructure operations 51 Layer 1: Security Infrastructure 52 Interfaces and Feeds to and from Applications and the Internet 53 Layer 2: Operational Databases 54 Layer 3: Organizing Data Services and Tools 56 Layer 4: Analytical Data Warehouses 56 Big Data Analytics 58 Big Data Applications 58 Chapter 5: Virtualization and How It Supports Distributed Computing 61 Understanding the Basics of Virtualization 61 The importance of virtualization to big data 63 Server virtualization 64 Application virtualization 65 Network virtualization 66 Processor and memory virtualization 66 Data and storage virtualization 67 Managing Virtualization with the Hypervisor 68 Abstraction and Virtualization 69 Implementing Virtualization to Work with Big Data 69 Chapter 6: Examining the Cloud and Big Data 71 Defining the Cloud in the Context of Big Data 71 Understanding Cloud Deployment and Delivery Models 72 Cloud deployment models 73 Cloud delivery models 74 The Cloud as an Imperative for Big Data 75 Making Use of the Cloud for Big Data 77 Providers in the Big Data Cloud Market 78 Amazon’s Public Elastic Compute Cloud 78 Google big data services 79 Microsoft Azure 80 OpenStack 80 Where to be careful when using cloud services 81 Part III: Big Data Management 83 Chapter 7: Operational Databases 85 RDBMSs Are Important in a Big Data Environment 87 PostgreSQL relational database 87 Nonrelational Databases 88 Key-Value Pair Databases 89 Riak key-value database 90 Document Databases 91 MongoDB 92 CouchDB 93 Columnar Databases 94 HBase columnar database 94 Graph Databases 95 Neo4J graph database 96 Spatial Databases 97 PostGIS/OpenGEO Suite 98 Polyglot Persistence 99 Chapter 8: MapReduce Fundamentals 101 Tracing the Origins of MapReduce 101 Understanding the map Function 103 Adding the reduce Function 104 Putting map and reduce Together 105 Optimizing MapReduce Tasks 108 Hardware/network topology 108 Synchronization 108 File system 108 Chapter 9: Exploring the World of Hadoop 111 Explaining Hadoop 111 Understanding the Hadoop Distributed File System (HDFS) 112 NameNodes 113 Data nodes 114 Under the covers of HDFS 115 Hadoop MapReduce 116 Getting the data ready 117 Let the mapping begin 118 Reduce and combine 118 Chapter 10: The Hadoop Foundation and Ecosystem 121 Building a Big Data Foundation with the Hadoop Ecosystem 121 Managing Resources and Applications with Hadoop YARN 122 Storing Big Data with HBase 123 Mining Big Data with Hive 124 Interacting with the Hadoop Ecosystem 125 Pig and Pig Latin 125 Sqoop 126 Zookeeper 127 Chapter 11: Appliances and Big Data Warehouses 129 Integrating Big Data with the Traditional Data Warehouse 129 Optimizing the data warehouse 130 Differentiating big data structures from data warehouse data 130 Examining a hybrid process case study 131 Big Data Analysis and the Data Warehouse 133 The integration lynchpin 134 Rethinking extraction, transformation, and loading 134 Changing the Role of the Data Warehouse 135 Changing Deployment Models in the Big Data Era 136 The appliance model 136 The cloud model 137 Examining the Future of Data Warehouses 137 Part IV: Analytics and Big Data 139 Chapter 12: Defining Big Data Analytics 141 Using Big Data to Get Results 142 Basic analytics 142 Advanced analytics 143 Operationalized analytics 146 Monetizing analytics 146 Modifying Business Intelligence Products to Handle Big Data 147 Data 147 Analytical algorithms 148 Infrastructure support 148 Studying Big Data Analytics Examples 149 Orbitz 149 Nokia 150 NASA 150 Big Data Analytics Solutions 151 Chapter 13: Understanding Text Analytics and Big Data 153 Exploring Unstructured Data 154 Understanding Text Analytics 155 The difference between text analytics and search 156 Analysis and Extraction Techniques 157 Understanding the extracted information 159 Taxonomies 160 Putting Your Results Together with Structured Data 160 Putting Big Data to Use 161 Voice of the customer 161 Social media analytics 162 Text Analytics Tools for Big Data 164 Attensity 164 Clarabridge 165 IBM 165 OpenText 165 SAS 166 Chapter 14: Customized Approaches for Analysis of Big Data 167 Building New Models and Approaches to Support Big Data 168 Characteristics of big data analysis 168 Understanding Different Approaches to Big Data Analysis 170 Custom applications for big data analysis 171 Semi-custom applications for big data analysis 173 Characteristics of a Big Data Analysis Framework 174 Big to Small: A Big Data Paradox 177 Part V: Big Data Implementation 179 Chapter 15: Integrating Data Sources 181 Identifying the Data You Need 181 Exploratory stage 182 Codifying stage 184 Integration and incorporation stage 184 Understanding the Fundamentals of Big Data Integration 186 Defining Traditional ETL 187 Data transformation 188 Understanding ELT — Extract, Load, and Transform 189 Prioritizing Big Data Quality 189 Using Hadoop as ETL 191 Best Practices for Data Integration in a Big Data World 191 Chapter 16: Dealing with Real-Time Data Streams and Complex Event Processing 193 Explaining Streaming Data and Complex Event Processing 194 Using Streaming Data 194 Data streaming 195 The need for metadata in streams 196 Using Complex Event Processing 198 Differentiating CEP from Streams 199 Understanding the Impact of Streaming Data and CEP on Business 200 Chapter 17: Operationalizing Big Data 201 Making Big Data a Part of Your Operational Process 201 Integrating big data 202 Incorporating big data into the diagnosis of diseases 203 Understanding Big Data Workflows 205 Workload in context to the business problem 206 Ensuring the Validity, Veracity, and Volatility of Big Data 207 Data validity 207 Data volatility 208 Chapter 18: Applying Big Data within Your Organization 211 Figuring the Economics of Big Data 212 Identification of data types and sources 212 Business process modifications or new process creation 215 The technology impact of big data workflows 215 Finding the talent to support big data projects 216 Calculating the return on investment (ROI) from big data investments 216 Enterprise Data Management and Big Data 217 Defining Enterprise Data Management 217 Creating a Big Data Implementation Road Map 218 Understanding business urgency 218 Projecting the right amount of capacity 219 Selecting the right software development methodology 219 Balancing budgets and skill sets 219 Determining your appetite for risk 220 Starting Your Big Data Road Map 220 Chapter 19: Security and Governance for Big Data Environments 225 Security in Context with Big Data 225 Assessing the risk for the business 226 Risks lurking inside big data 226 Understanding Data Protection Options 227 The Data Governance Challenge 228 Auditing your big data process 230 Identifying the key stakeholders 231 Putting the Right Organizational Structure in Place 231 Preparing for stewardship and management of risk 232 Setting the right governance and quality policies 232 Developing a Well-Governed and Secure Big Data Environment 233 Part VI: Big Data Solutions in the Real World 235 Chapter 20: The Importance of Big Data to Business 237 Big Data as a Business Planning Tool 238 Stage 1: Planning with data 238 Stage 2: Doing the analysis 239 Stage 3: Checking the results 239 Stage 4: Acting on the plan 240 Adding New Dimensions to the Planning Cycle 240 Stage 5: Monitoring in real time 240 Stage 6: Adjusting the impact 241 Stage 7: Enabling experimentation 241 Keeping Data Analytics in Perspective 241 Getting Started with the Right Foundation 242 Getting your big data strategy started 242 Planning for Big Data 243 Transforming Business Processes with Big Data 244 Chapter 21: Analyzing Data in Motion: A Real-World View 245 Understanding Companies’ Needs for Data in Motion 246 The value of streaming data 247 Streaming Data with an Environmental Impact 247 Using sensors to provide real-time information about rivers and oceans 248 The benefits of real-time data 249 Streaming Data with a Public Policy Impact 249 Streaming Data in the Healthcare Industry 251 Capturing the data stream 251 Streaming Data in the Energy Industry 252 Using streaming data to increase energy efficiency 252 Using streaming data to advance the production of alternative sources of energy 252 Connecting Streaming Data to Historical and Other Real-Time Data Sources 253 Chapter 22: Improving Business Processes with Big Data Analytics: A Real-World View 255 Understanding Companies’ Needs for Big Data Analytics 256 Improving the Customer Experience with Text Analytics 256 The business value to the big data analytics implementation 257 Using Big Data Analytics to Determine Next Best Action 257 Preventing Fraud with Big Data Analytics 260 The Business Benefit of Integrating New Sources of Data 262 Part VII: The Part of Tens 263 Chapter 23: Ten Big Data Best Practices 265 Understand Your Goals 265 Establish a Road Map 266 Discover Your Data 266 Figure Out What Data You Don’t Have 267 Understand the Technology Options 267 Plan for Security in Context with Big Data 268 Plan a Data Governance Strategy 268 Plan for Data Stewardship 268 Continually Test Your Assumptions 269 Study Best Practices and Leverage Patterns 269 Chapter 24: Ten Great Big Data Resources 271 Hurwitz & Associates 271 Standards Organizations 271 The Open Data Foundation 272 The Cloud Security Alliance 272 National Institute of Standards and Technology 272 Apache Software Foundation 273 Oasis 273 Vendor Sites 273 Online Collaborative Sites 274 Big Data Conferences 274 Chapter 25: Ten Big Data Do’s and Don’ts 275 Do Involve All Business Units in Your Big Data Strategy 275 Do Evaluate All Delivery Models for Big Data 276 Do Think about Your Traditional Data Sources as Part of Your Big Data Strategy 276 Do Plan for Consistent Metadata 276 Do Distribute Your Data 277 Don’t Rely on a Single Approach to Big Data Analytics 277 Don’t Go Big Before You Are Ready 277 Don’t Overlook the Need to Integrate Data 277 Don’t Forget to Manage Data Securely 278 Don’t Overlook the Need to Manage the Performance of Your Data 278 Glossary 279 Index 295
£20.79
Wiley Mastering AutoCAD 2014 and AutoCAD LT 2014
Book SynopsisThe ultimate reference and tutorial for AutoCAD software This Autodesk Official Press book helps you become an AutoCAD and AutoCAD LT expert and has been fully updated to cover all of AutoCAD''s new capabilities. Featuring the popular, empowering presentation style of veteran award-winning author George Omura, this indispensable resource teaches AutoCAD essentials using concise explanations, focused examples, step-by-step instructions, and hands-on projects. Introduces you to the basics of the interface and drafting tools Details how to effectively use hatches, fields, and tables Covers attributes, dynamic blocks, curves, and geometric constraints Explores 3D modeling and imaging Discusses customization and integration Helps you prepare for the AutoCAD certification exams Features a website that includes all the project files necessary for the tutorials This detailed reference and tutorial
£35.62
John Wiley & Sons Inc 101 Excel 2013 Tips Tricks and Timesavers
Book SynopsisGet the most out of Excel 2013 with this exceptional advice from Mr. Spreadsheet himself! Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka Mr.Table of ContentsIntroduction 1 What You Should Know 1 What You Should Have 1 Conventions in This Book 2 Formula listings 2 Key names 2 The Ribbon 2 Functions, procedures, and named ranges 3 Mouse conventions 3 What the icons mean 3 How This Book Is Organized 4 How to Use This Book 4 About the Power Utility Pak Offer 4 Part I: Workbooks and Files Tip 1: Changing the Look of Excel 7 Tip 2: Customizing the Quick Access Toolbar 10 Tip 3: Customizing the Ribbon 14 Tip 4: Understanding Protected View 17 Tip 5: Understanding AutoRecover 20 Tip 6: Using a Workbook in a Browser 22 Tip 7: Saving to a Read-Only Format 24 Tip 8: Generating a List of Filenames 27 Tip 9: Generating a List of Sheet Names 29 Tip 10: Using Document Themes 32 Tip 11: Understanding Excel Compatibility Issues 37 Tip 12: Where to Change Printer Settings 39 Part II: Formatting Tip 13: Working with Merged Cells 43 Tip 14: Indenting Cell Contents 48 Tip 15: Using Named Styles 50 Tip 16: Creating Custom Number Formats 54 Tip 17: Using Custom Number Formats to Scale Values 58 Tip 18: Creating a Bulleted List 60 Tip 19: Shading Alternate Rows Using Conditional Formatting 62 Tip 20: Formatting Individual Characters in a Cell 65 Tip 21: Using the Format Painter 66 Tip 22: Inserting a Watermark 68 Tip 23: Showing Text and a Value in a Cell 70 Tip 24: Avoiding Font Substitution for Small Point Sizes 72 Tip 25: Updating Old Fonts 75 Part III: Formulas Tip 26: Resizing the Formula Bar 81 Tip 27: Monitoring Formula Cells from Any Location 83 Tip 28: Learning Some AutoSum Tricks 85 Tip 29: Knowing When to Use Absolute and Mixed References 87 Tip 30: Avoiding Error Displays in Formulas 90 Tip 31: Creating Worksheet-Level Names 92 Tip 32: Using Named Constants 94 Tip 33: Sending Personalized E-Mail from Excel 96 Tip 34: Looking Up an Exact Value 99 Tip 35: Performing a Two-Way Lookup 101 Tip 36: Performing a Two-Column Lookup 103 Tip 37: Calculating Holidays 105 Tip 38: Calculating a Person’s Age 108 Tip 39: Working with Pre-1900 Dates 110 Tip 40: Displaying a Live Calendar in a Range 114 Tip 41: Returning the Last Nonblank Cell in a Column or Row 116 Tip 42: Various Methods of Rounding Numbers 118 Tip 43: Converting Between Measurement Systems 121 Tip 44: Counting Nonduplicated Entries in a Range 123 Tip 45: Using the AGGREGATE Function 125 Tip 46: Making an Exact Copy of a Range of Formulas 128 Tip 47: Using the Background Error-Checking Features 130 Tip 48: Using the Inquire Add-In 132 Tip 49: Hiding and Locking Your Formulas 135 Tip 50: Using the INDIRECT Function 138 Tip 51: Formula Editing in Dialog Boxes 141 Tip 52: Converting a Vertical Range to a Table 142 Part IV: Working with Data Tip 53: Selecting Cells Efficiently 147 Tip 54: Automatically Filling a Range with a Series 151 Tip 55: Fixing Trailing Minus Signs 154 Tip 56: Restricting Cursor Movement to Input Cells 155 Tip 57: Transforming Data with and Without Using Formulas 157 Tip 58: Creating a Drop-Down List in a Cell 160 Tip 59: Comparing Two Ranges by Using Conditional Formatting 162 Tip 60: Finding Duplicates by Using Conditional Formatting 165 Tip 61: Working with Credit Card Numbers 168 Tip 62: Identifying Excess Spaces 170 Tip 63: Transposing a Range 173 Tip 64: Using Flash Fill to Extract Data 176 Tip 65: Using Flash Fill to Combine Data 179 Tip 66: Inserting Stock Information 181 Tip 67: Getting Data from a Web Page 184 Tip 68: Importing a Text File into a Worksheet Range 188 Tip 69: Using the Quick Analysis Feature 190 Tip 70: Filling the Gaps in a Report 192 Tip 71: Performing Inexact Searches 194 Tip 72: Proofing Your Data with Audio 196 Tip 73: Getting Data from a PDF File 198 Part V: Tables and Pivot Tables Tip 74: Understanding Tables 205 Tip 75: Using Formulas with a Table 208 Tip 76: Numbering Table Rows Automatically 212 Tip 77: Identifying Data Appropriate for a Pivot Table 214 Tip 78: Using a Pivot Table Instead of Formulas 218 Tip 79: Controlling References to Cells Within a Pivot Table 222 Tip 80: Creating a Quick Frequency Tabulation 224 Tip 81: Grouping Items by Date in a Pivot Table 227 Tip 82: Creating Pivot Tables with Multiple Groupings 230 Tip 83: Using Pivot Table Slicers and Timelines 232 Part VI: Charts and Graphics Tip 84: Understanding Recommended Charts 239 Tip 85: Customizing Charts 241 Tip 86: Making Charts the Same Size 243 Tip 87: Creating a Chart Template 245 Tip 88: Creating a Combination Chart 247 Tip 89: Handling Missing Data in a Chart 250 Tip 90: Using High-Low Lines in a Chart 252 Tip 91: Using Multi-Level Category Labels 253 Tip 92: Linking Chart Text to Cells 255 Tip 93: Freezing a Chart 257 Tip 94: Creating a Chart Directly in a Range 260 Tip 95: Creating Minimalistic Charts 264 Tip 96: Applying Chart Data Labels from a Range 268 Tip 97: Grouping Charts and Other Objects 270 Tip 98: Taking Pictures of Ranges 273 Tip 99: Changing the Look of Cell Comments 276 Tip 100: Enhancing Images 279 Tip 101: Saving Shapes, Charts, and Ranges as Images 281 Index 283
£26.60
John Wiley & Sons Inc Mathematical Structures for Computer Graphics
Book SynopsisA comprehensive exploration of the mathematics behind the modeling and rendering of computer graphics scenes Mathematical Structures for Computer Graphics presents an accessible and intuitive approach to the mathematical ideas and techniques necessary for two- and three-dimensional computer graphics.Trade Review“The book is suitable for undergraduate students of computer science, mathematics, and engineering, as well as an ideal reference for researchers and professionals in computer graphics.” (Zentralblatt MATH, 1 June 2015) Table of ContentsPreface xiii 1 Basics 1 1.1 Graphics Pipeline 2 1.2 Mathematical Descriptions 4 1.3 Position 5 1.4 Distance 8 1.5 Complements and Details 11 1.5.1 Pythagorean Theorem Continued 11 1.5.2 Law of Cosines Continued 12 1.5.3 Law of Sines 13 1.5.4 Numerical Calculations 13 1.6 Exercises 14 1.6.1 Programming Exercises 16 2 Vector Algebra 17 2.1 Basic Vector Characteristics 18 2.1.1 Points Versus Vectors 20 2.1.2 Addition 20 2.1.3 Scalar Multiplication 21 2.1.4 Subtraction 22 2.1.5 Vector Calculations 22 2.1.6 Properties 24 2.1.7 Higher Dimensions 25 2.2 Two Important Products 25 2.2.1 Dot Product 25 2.2.2 Cross Product 29 2.3 Complements and Details 34 2.3.1 Vector History 34 2.3.2 More about Points Versus Vectors 35 2.3.3 Vector Spaces and Affine Spaces 36 2.4 Exercises 38 2.4.1 Programming Exercises 39 3 Vector Geometry 40 3.1 Lines and Planes 40 3.1.1 Vector Description of Lines 40 3.1.2 Vector Description of Planes 44 3.2 Distances 46 3.2.1 Point to a Line 46 3.2.2 Point to a Plane 48 3.2.3 Parallel Planes and Line to a Plane 48 3.2.4 Line to a Line 50 3.3 Angles 52 3.4 Intersections 54 3.4.1 Intersecting Lines 54 3.4.2 Lines Intersecting Planes 56 3.4.3 Intersecting Planes 57 3.5 Additional Key Applications 61 3.5.1 Intersection of Line Segments 61 3.5.2 Intersection of Line and Sphere 65 3.5.3 Areas and Volumes 66 3.5.4 Triangle Geometry 68 3.5.5 Tetrahedron 69 3.6 Homogeneous Coordinates 71 3.6.1 Two Dimensions 72 3.6.2 Three Dimensions 73 3.7 Complements and Details 75 3.7.1 Intersection of Three Planes Continued 75 3.7.2 Homogeneous Coordinates Continued 77 3.8 Exercises 79 3.8.1 Programming Exercises 82 4 Transformations 83 4.1 Types of Transformations 84 4.2 Linear Transformations 85 4.2.1 Rotation in Two Dimensions 88 4.2.2 Reflection in Two dimensions 90 4.2.3 Scaling in Two Dimensions 92 4.2.4 Matrix Properties 93 4.3 Three Dimensions 95 4.3.1 Rotations in Three Dimensions 95 4.3.2 Reflections in Three Dimensions 101 4.3.3 Scaling and Shear in Three Dimensions 102 4.4 Affine Transformations 103 4.4.1 Transforming Homogeneous Coordinates 105 4.4.2 Perspective Transformations 107 4.4.3 Transforming Normals 110 4.4.4 Summary 111 4.5 Complements and Details 112 4.5.1 Vector Approach to Reflection in an Arbitrary Plane 113 4.5.2 Vector Approach to Arbitrary Rotations 115 4.6 Exercises 121 4.6.1 Programming Exercises 123 5 Orientation 124 5.1 Cartesian Coordinate Systems 125 5.2 Cameras 132 5.2.1 Moving the Camera or Objects 134 5.2.2 Euler Angles 137 5.2.3 Quaternions 141 5.2.4 Quaternion Algebra 143 5.2.5 Rotations 145 5.2.6 Interpolation: Slerp 148 5.2.7 From Euler Angles and Quaternions to Rotation Matrices 151 5.3 Other Coordinate Systems 152 5.3.1 Non-orthogonal Axes 152 5.3.2 Polar, Cylindrical, and Spherical Coordinates 154 5.3.3 Barycentric Coordinates 157 5.4 Complements and Details 158 5.4.1 Historical Note: Descartes 158 5.4.2 Historical Note: Hamilton 158 5.4.3 Proof of Quaternion Rotation 159 5.5 Exercises 161 5.5.1 Programming Exercises 163 6 Polygons and Polyhedra 164 6.1 Triangles 164 6.1.1 Barycentric Coordinates 165 6.1.2 Areas and Barycentric Coordinates 166 6.1.3 Interpolation 171 6.1.4 Key Points in a Triangle 172 6.2 Polygons 178 6.2.1 Convexity 179 6.2.2 Angles and Area 180 6.2.3 Inside and Outside 184 6.2.4 Triangulation 187 6.2.5 Delaunay Triangulation 189 6.3 Polyhedra 192 6.3.1 Regular Polyhedra 194 6.3.2 Volume of Polyhedra 196 6.3.3 Euler’s Formula 200 6.3.4 Rotational Symmetries 202 6.4 Complements and Details 205 6.4.1 Generalized Barycentric Coordinates 205 6.4.2 Data Structures 206 6.5 Exercises 208 6.5.1 Programming Exercises 211 7 Curves and Surfaces 212 7.1 Curve Descriptions 213 7.1.1 Lagrange Interpolation 218 7.1.2 Matrix Form for Curves 222 7.2 Bézier Curves 223 7.2.1 Properties for Two-Dimensional Bézier Curves 226 7.2.2 Joining Bézier Curve Segments 228 7.2.3 Three-Dimensional Bézier Curves 229 7.2.4 Rational Bézier Curves 230 7.3 B-Splines 232 7.3.1 Linear Uniform B-Splines 233 7.3.2 Quadratic Uniform B-Splines 235 7.3.3 Cubic Uniform B-Splines 240 7.3.4 B-Spline Properties 242 7.4 Nurbs 246 7.5 Surfaces 250 7.6 Complements and Details 260 7.6.1 Adding Control Points to Bézier Curves 260 7.6.2 Quadratic B-Spline Blending Functions 262 7.7 Exercises 264 7.7.1 Programming Exercises 266 8 Visibility 267 8.1 Viewing 267 8.2 Perspective Transformation 269 8.2.1 Clipping 273 8.2.2 Interpolating the z Coordinate 275 8.3 Hidden Surfaces 278 8.3.1 Back Face Culling 281 8.3.2 Painter’s Algorithm 283 8.3.3 Z-Buffer 286 8.4 Ray Tracing 287 8.4.1 Bounding Volumes 289 8.4.2 Bounding Boxes 289 8.4.3 Bounding Spheres 291 8.5 Complements and Details 293 8.5.1 Frustum Planes 293 8.5.2 Axes for Bounding Volumes 294 8.6 Exercises 297 8.6.1 Programming Exercises 298 9 Lighting 299 9.1 Color Coordinates 299 9.2 Elementary Lighting Models 303 9.2.1 Gouraud and Phong Shading 307 9.2.2 Shadows 311 9.2.3 BRDFs in Lighting Models 315 9.3 Global Illumination 319 9.3.1 Ray Tracing 319 9.3.2 Radiosity 323 9.4 Textures 325 9.4.1 Mapping 325 9.4.2 Resolution 332 9.4.3 Procedural Textures 333 9.5 Complements and Details 335 9.5.1 Conversion between RGB and HSV 335 9.5.2 Shadows on Arbitrary Planes 336 9.5.3 Derivation of the Radiosity Equation 337 9.6 Exercises 339 9.6.1 Programming Exercises 340 10 Other Paradigms 341 10.1 Pixels 342 10.1.1 Bresenham Line Algorithm 342 10.1.2 Anti-Aliasing 345 10.1.3 Compositing 347 10.2 Noise 350 10.2.1 Random Number Generation 350 10.2.2 Distributions 351 10.2.3 Sequences of Random Numbers 353 10.2.4 Uniform and Normal Distributions 354 10.2.5 Terrain Generation 356 10.2.6 Noise Generation 357 10.3 L-Systems 361 10.3.1 Grammars 362 10.3.2 Turtle Interpretation 363 10.3.3 Analysis of Grammars 365 10.3.4 Extending L-Systems 367 10.4 Exercises 368 10.4.1 Programming Exercises 369 Appendix A Geometry and Trigonometry 370 A.1 Triangles 370 A.2 Angles 372 A.3 Trigonometric Functions 373 Appendix B Linear Algebra 376 B.1 Systems of Linear Equations 376 B.1.1 Solving the System 377 B.2 Matrix Properties 379 B.3 Vector Spaces 381 References 383 Index 387
£54.86
John Wiley & Sons Inc Oracle 12c For Dummies
Book SynopsisDemystifying the power of the Oracle 12c database The Oracle database is the industry-leading relational database management system (RDMS) used from small companies to the world's largest enterprises alike for their most critical business and analytical processing. Oracle 12c includes industry leading enhancements to enable cloud computing and empowers users to manage both Big Data and traditional data structures faster and cheaper than ever before. Oracle 12c For Dummies is the perfect guide for a novice database administrator or an Oracle DBA who is new to Oracle 12c. The book covers what you need to know about Oracle 12c architecture, software tools, and how to successfully manage Oracle databases in the real world. Highlights the important features of Oracle 12c Explains how to create, populate, protect, tune, and troubleshoot a new Oracle database Covers advanced Oracle 12c technologies including Oracle Multitenantthe pluggablTable of ContentsIntroduction 1 Part I: Getting Started with Oracle 12c 5 Chapter 1: Discovering Databases and Oracle 12c 7 Chapter 2: Understanding Oracle Database Architecture 17 Chapter 3: Preparing to Implement Oracle 49 Part II: Implementing an Oracle Database 67 Chapter 4: Creating Your Database 69 Chapter 5: Connecting to the Database 93 Chapter 6: Understanding the Language of Databases: SQL 115 Chapter 7: Loading Data into Your Database 135 Part III: Caring for and Feeding an Oracle Database 153 Chapter 8: Keeping the Database Running 155 Chapter 9: Tuning an Oracle Database for Performance 185 Chapter 10: Securing and Auditing Your Database 215 Chapter 11: Facilitating Backup and Recovery 237 Chapter 12: Troubleshooting an Oracle Database 273 Chapter 13: Managing Your Database with Enterprise Manager 301 Part IV: Advanced Oracle Technologies 313 Chapter 14: Advanced Features 315 Chapter 15: Using High-Availability Options 351 Part V: The Part of Tens 373 Chapter 16: Ten Oracle Installation Do's 375 Chapter 17: Ten Database Design Do's 383 Appendix A: Installing Oracle 12c on Linux 391 Index 401
£19.99
John Wiley & Sons Inc Configuring SAP ERP Sales and Distribution
Book SynopsisThe first and only book to offer detailed explanations of SAP ERP sales and distribution As the only book to provide in-depth configuration of the Sales and Distribution (SD) module in the latest version of SAP ERP, this valuable resource presents you with step-by-step instruction, conceptual explanations, and plenty of examples.Table of ContentsIntroduction xv Chapter 1 Introduction to Sales and Distribution 1 Chapter 2 Enterprise Structure 27 Chapter 3 Master Data in SD 69 Chapter 4 Partner, Text, and Output Determination 103 Chapter 5 Pricing and Tax Determination 155 Chapter 6 Availability Check, Transfer of Requirements, and Backorders 207 Chapter 7 Sales 247 Chapter 8 Shipping and Transportation 323 Chapter 9 Billing 371 Chapter 10 Account Assignment and Revenue Recognition 429 Chapter 11 Credit Management 453 Chapter 12 Material Determination, Listing, Exclusion, and Proposal 483 Chapter 13 Serial Numbers and Batch Management 519 Chapter 14 Advanced Techniques 551 Appendix Transaction Codes and Database Tables 597 Index 625
£63.00
John Wiley & Sons Inc Data Fluency
Book SynopsisAnalytical data is a powerful tool for growing companies, but what good is it if it hides in the shadows? This book shows you the tools and strategies for getting the job done right. It helps you to learn the practices of data presentation and the ways that reporting and dashboards can help organizations effectively gauge performance.Table of ContentsForeword xix Introduction xxi Chapter 1 The Last Mile Problem 1 The Information Age: Driving the Need for Data Fluency 2 Data Fluency: Unlock the Potential Energy of Data in Your Organization 4 Big Data and Data Metaphors 5 Our Data Fluency Framework 7 Case Studies: A Window into the Framework for Data Fluency 8 Data Consumers: Fantasy Football 8 Producers of Data Products: U.S. News 11 Organizational-Level Consumers: School District Woes 13 Organizational-Level Producers: Insurance Company Bottom Lines 15 Chapter 2 The Data Fluency Framework 19 The Data Fluency Framework 21 Individuals and the Organization 22 Using Data versus Presenting Data 23 Element 1: Data Literate Consumers 23 Element 2: Data Fluent Producers 24 Element 3: The Data Fluent Culture 26 Element 4: The Data Product Ecosystem 27 Connective Tissue 28 Resources for More Depth 28 Benefits of the Data Fluent Organization 29 How to Use This Framework 30 How Organizations Struggle 31 Summary 32 Chapter 3 How Organizations Struggle with Data Fluency 33 Pitfalls on the Path to Data Fluency 35 Report Proliferation 35 Balkanized Data 36 Data Elitism 38 The Supermodel 39 Searching for Understanding 40 Data Care 42 Metric Fixation 43 Finding Balance 45 Chapter 4 A Consumer’s Guide to Understanding Data 47 Data Products 49 Everyday Data Products 51 Barriers to Using Data Products 55 Jargon 55 Not Knowing Where to Start or What to Focus On 57 Inconsistency 58 Learning the Language of Data 60 Atomic Data 60 Summarized Data 61 Exploring Data Tables 63 Rows Tell Stories 63 Columns Give the Bigger Picture 64 Understanding Charts and Visualizations 64 Comprehensibility 65 Dissecting Data Products 66 Where Does It Come From? 67 What Can I Learn from It? 68 What Can You Do with It? 74 Wrapping Up 77 Chapter 5 Data Authors: Skilled Designers of Data Presentations 79 A Rare Skillset 80 What You’ll Learn 81 Guided Conversations 82 Finding Your Purpose and Message 84 Let the Data Speak 85 Your Objectives 85 Your Audience 86 Information Discrimination 88 Defining Meaningful and Actionable Metrics 92 Creating Structure and Flow to Your Data Products 95 A Guided Path: Structure and Flow 95 Why Structure Matters? 97 Structure Options 97 Designing Attractive, Easy-to-Understand Data Products 103 Form 103 Visualizing Your Data 104 Color 107 Typography 109 Wrapping Data in Context 111 Language 112 Creating Dialogue with Your Data Products 114 Your Audience’s Audience 114 Data Leading to Dialogue 114 Design Principles 115 Visualizations 115 Design Principles for Data Products 121 Compactness and Modularity 121 Gradual Reveal 121 Guide Attention 122 Support Casual Use 122 Lead to Action 123 Customizable 124 Explanation before Information 124 Viva the Authors of Data Products 125 Chapter 6 The Data Fluent Culture 127 Leadership, Culture, and Communicating Priorities 129 Set and Communicate Expectations 130 Articulate Specific, Measureable Indicators 131 Celebrate Effective Data Use and Products 132 Use Data to Inform Decisions and Actions 133 Establishing Key Metrics to Rally Around 134 What Makes a Good Metric? 134 Using Metrics to Drive Organizational Improvement 137 Choose a Few Key Metrics at Any Given Level 138 Select Key Metrics That Align with the Mission and Vision 138 Show Employees That Their Contributions Are Essential 138 Reference Key Metrics and Data Analysis When Communicating Goals 139 Avoiding Metrics Pitfalls 139 Shared Understandings 141 Common Vocabulary and Terminology Relating to Organization-Specific Data 143 Clear Definitions of Measures 143 Standard Forms for Collecting Data 143 Understanding and Appreciating Credible, Reliable Data Sources 145 Understand the Strengths and Weaknesses of Data Sources 145 Provide Transparency into How Data Is Manipulated and Modeled 147 Define a Shared Set of Key Metrics 148 Understanding the Purpose and Motivation for Data Products 149 Everyday Activities 151 Data Consumers 152 Help Individuals Evaluate Data without Distraction 152 Focus on the Message 153 Data Products 153 Establish Clear Guidelines for Quality Data Products 153 Develop a Feedback Mechanism for Data Products to Help Evolve and Improve Content. 155 Celebrate Examples of Quality Data Products 156 Data Usage 156 Encourage Data-Driven Decision-Making 157 Evaluating Effective Data Use within the Organization 157 Evolution of Data Fluent Cultures 158 Chapter 7 The Data Product Ecosystem 161 Data Products for Information Delivery 162 Necessary Conditions 163 Learning from the App Store 165 Demand 167 Top-Down Demand Map 167 Grassroots Needs 169 Where to Begin 169 Design 170 Objective 170 Start with a Style Guide 172 Develop 172 “It’s a Poor Craftsman Who Blames His Tools” 174 Discover 175 Objective 176 Where to Begin: A Centralized Inventory of Data Products 176 Discuss 177 Objective 177 Where to Begin: Create a Place to Capture Insights 178 Distill 179 Learning from Wikipedia 179 Objective 180 What Can You Do Without? 180 “Only Connect” 181 Chapter 8 The Journey to Data Fluency 183 Why Data Fluency? 185 Data Consumers: Creating a Sophisticated Audience 187 Data Product Producers: The Skills to Enable Effective Data Communication 188 Data Fluent Culture: Building a Shared Understanding of Data 189 Data Product Ecosystem: Tools and Processes to Facilitate the Fluid Exchange of Information 189 Begin the Journey 190 Feature The Data Fluency Inventory 193 The Data Fluency Inventory Survey Questions 194 Component 1: Data Consumer Literacy 196 Use of Data 197 Data Skills 198 Value Placed on Data 199 Component 2: Data Product Author Skills 200 Tools 201 Skills 202 Perceptions and Attitudes 203 Component 3: Data Fluent Culture 204 Leadership 205 Key Metrics 205 Shared Understanding and Everyday Data Use 206 Component 4: Data Product Ecosystem 207 Demand and Design 208 Develop 208 Discover 209 Discuss and Distill 209 Summary of the DFI 210 DFI Scoring Guide (for Organizations) 210 Question Types and Point Values 211 Organization Scores 211 Component 1: Data Consumer Literacy 211 Thoughts for an Organizational Leader 212 Component 2: Data Product Authors 212 Thoughts for an Organizational Leader 213 Component 3: Data Fluent Culture 213 Thoughts for an Organizational Leader 214 Component 4: Data Product Ecosystem 214 Thoughts for an Organizational Leader 214 Organizational Scoring Summary 215 Scoring Guide (for Individuals) 215 What Can You Measure as an Individual? 216 Component 1: Data Consumer (Individual Only) 216 Component 2: Data Authors (Individual Only) 217 Individual Scoring Guide Summary 217 DFI Supporting Materials 218 Survey Introduction E-mail 218 Data Literacy Quiz 219 Appendix A Designing Data Products 223 A Checklist for Creating Data Products 224 Think Like a Designer 226 Designed to Be Used 228 Breaking Free of the One-Page Dashboard Rule 229 Dashboard Alerts Checklist 231 Context: Users Need to Understand How an Alert Is Defined and How It Fits into the Larger Picture 232 Cogency: An Alerting System Needs to Avoid Causing Unnecessary Alarm While Delivering Easy-to-Understand Information That Can Be Acted Upon 232 Communication: Alerts Must Be Designed to Effectively Capture Attention and Inform 233 Control: Advanced Alert System Should Give Users the Ability to Customize and Manage Alerts 233 8 Features of Successful Real-time Dashboards 234 Appendix B Style Guide 237 Style Guide Sample 1: Fonts 239 Style Guide Sample 2: Colors 240 Style Guide Sample 3: Date/Number Formatting 241 Style Guide Sample 4: Bar Charts 242 Style Guide Sample 5: Trend Charts 243 Style Guide Sample 6: Tables 244 Index 245
£24.79
John Wiley & Sons Inc AutoCAD 2015 and AutoCAD LT 2015 Bible
Book SynopsisThe perfect reference for all AutoCAD users AutoCAD 2015 and AutoCAD LT 2015 Bible is the book you want to have close at hand to answer those day-to-day questions about this industry-leading software.Table of ContentsAcknowledgments ix Foreword xxxi Introduction xxxiii Part I: Introducing AutoCAD and AutoCAD LT Basics 1 Quick Start: Drawing a Window 3 Chapter 1: Starting to Draw 15 Chapter 2: Opening a Drawing 29 Chapter 3: Using Commands 35 Chapter 4: Specifying Coordinates 53 Chapter 5: Setting Up a Drawing 91 Part II: Drawing in Two Dimensions 107 Chapter 6: Drawing Simple Lines 109 Chapter 7: Drawing Curves and Points 119 Chapter 8: Viewing Your Drawing 135 Chapter 9: Editing Your Drawing with Basic Tools 167 Chapter 10: Editing Your Drawing with Advanced Tools 193 Chapter 11: Organizing Drawings with Layers and Object Properties 259 Chapter 12: Obtaining Information from Your Drawing 295 Chapter 13: Creating Text 325 Chapter 14: Drawing Dimensions 383 Chapter 15: Creating Dimension Styles 437 Chapter 16: Drawing Complex Objects 471 Chapter 17: Plotting and Printing Your Drawing 517 Part III: Working with Data 555 Chapter 18: Working with Blocks 557 Chapter 19: Adding Attributes to Blocks 607 Chapter 20: Referencing Other Drawings 629 Part IV: Drawing in Three Dimensions 657 Chapter 21: Specifying 3D Coordinates 659 Chapter 22: Viewing 3D Drawings 691 Chapter 23: Creating 3D Surfaces 747 Chapter 24: Creating Solids and Editing in 3D 795 Part V: Organizing and Managing Drawings 867 Chapter 25: Keeping Control of Your Drawings 869 Chapter 26: Working with Other Applications 925 Chapter 27: Collaborating and Creating Electronic Output 951 Part VI: Customizing AutoCAD and AutoCAD LT 983 Chapter 28: Customizing Commands, Toolbars, and Tool Palettes 985 Chapter 29: Creating Macros and Slide Shows 1013 Chapter 30: Creating Your Own Linetypes and Hatch Patterns 1027 Chapter 31: Creating Shapes and Fonts 1039 Chapter 32: Customizing the Ribbon and Menus 1051 Part VII: Programming AutoCAD 1083 Chapter 33: Understanding AutoLISP and Visual LISP Basics 1085 Chapter 34: Exploring AutoLISP Further 1101 Chapter 35: Exploring Advanced AutoLISP Topics 1129 Part VIII: Appendixes 1149 Appendix A: Installing and Configuring AutoCAD and AutoCAD LT 1151 Appendix B: AutoCAD and AutoCAD LT Resources 1191 Appendix C: What’s on the Companion Website 1197 Index 1201 Bonus Chapters on the Companion Website Chapter 1: Working with External Databases Chapter 2: Rendering in 3D Chapter 3: Programming with Visual Basic for Applications Chapter 4: Programming with NET
£31.99
John Wiley & Sons Inc Business Risk and Simulation Modelling in
Book SynopsisThe complete guide to the principles and practice of risk quantification for business applications. The assessment and quantification of risk provide an indispensable part of robust decision-making; to be effective, many professionals need a firm grasp of both the fundamental concepts and of the tools of the trade. Business Risk and Simulation Modelling in Practice is a comprehensive, indepth, and practical guide that aims to help business risk managers, modelling analysts and general management to understand, conduct and use quantitative risk assessment and uncertainty modelling in their own situations. Key content areas include: Detailed descriptions of risk assessment processes, their objectives and uses, possible approaches to risk quantification, and their associated decision-benefits and organisational challenges. Principles and techniques in the design of risk models, including the similarities and differences with traditionalTable of ContentsPreface xvii About the Author xxiii About the Website xxv Part I An Introduction to Risk Assessment – Its Uses, Processes, Approaches, Benefits and Challenges Chapter 1 The Context and Uses of Risk Assessment 3 1.1 Risk Assessment Examples 3 1.1.1 Everyday Examples of Risk Management 4 1.1.2 Prominent Risk Management Failures 5 1.2 General Challenges in Decision-Making Processes 7 1.2.1 Balancing Intuition with Rationality 7 1.2.2 The Presence of Biases 9 1.3 Key Drivers of the Need for Formalised Risk Assessment in Business Contexts 14 1.3.1 Complexity 14 1.3.2 Scale 15 1.3.3 Authority and Responsibility to Identify and Execute Risk-Response Measures 16 1.3.4 Corporate Governance Guidelines 16 1.3.5 General Organisational Effectiveness and the Creation of Competitive Advantage 18 1.3.6 Quantification Requirements 18 1.3.7 Reflecting Risk Tolerances in Decisions and in Business Design 19 1.4 The Objectives and Uses of General Risk Assessment 19 1.4.1 Adapt and Improve the Design and Structure of Plans and Projects 20 1.4.2 Achieve Optimal Risk Mitigation within Revised Plans 20 1.4.3 Evaluate Projects, Set Targets and Reflect Risk Tolerances in Decision-Making 21 1.4.4 Manage Projects Effectively 21 1.4.5 Construct, Select and Optimise Business and Project Portfolios 22 1.4.6 Support the Creation of Strategic Options and Corporate Planning 25 Chapter 2 Key Stages of the General Risk Assessment Process 29 2.1 Overview of the Process Stages 29 2.2 Process Iterations 30 2.3 Risk Identification 32 2.3.1 The Importance of a Robust Risk Identification Step 32 2.3.2 Bringing Structure into the Process 32 2.3.3 Distinguishing Variability from Decision Risks 34 2.3.4 Distinguishing Business Issues from Risks 34 2.3.5 Risk Identification in Quantitative Approaches: Additional Considerations 35 2.4 Risk Mapping 35 2.4.1 Key Objectives 35 2.4.2 Challenges 35 2.5 Risk Prioritisation and Its Potential Criteria 36 2.5.1 Inclusion/Exclusion 36 2.5.2 Communications Focus 37 2.5.3 Commonality and Comparison 38 2.5.4 Modelling Reasons 39 2.5.5 General Size of Risks, Their Impact and Likelihood 39 2.5.6 Influence: Mitigation and Response Measures, and Management Actions 40 2.5.7 Optimising Resource Deployment and Implementation Constraints 41 2.6 Risk Response: Mitigation and Exploitation 42 2.6.1 Reduction 42 2.6.2 Exploitation 42 2.6.3 Transfer 42 2.6.4 Research and Information Gathering 43 2.6.5 Diversification 43 2.7 Project Management and Monitoring 44 Chapter 3 Approaches to Risk Assessment and Quantification 45 3.1 Informal or Intuitive Approaches 46 3.2 Risk Registers without Aggregation 46 3.2.1 Qualitative Approaches 46 3.2.2 Quantitative Approaches 48 3.3 Risk Register with Aggregation (Quantitative) 50 3.3.1 The Benefits of Aggregation 50 3.3.2 Aggregation of Static Values 51 3.3.3 Aggregation of Risk-Driven Occurrences and Their Impacts 52 3.3.4 Requirements and Differences to Non-Aggregation Approaches 54 3.4 Full Risk Modelling 56 3.4.1 Quantitative Aggregate Risk Registers as a First Step to Full Models 56 Chapter 4 Full Integrated Risk Modelling: Decision-Support Benefits 59 4.1 Key Characteristics of Full Models 59 4.2 Overview of the Benefits of Full Risk Modelling 61 4.3 Creating More Accurate and Realistic Models 62 4.3.1 Reality is Uncertain: Models Should Reflect This 62 4.3.2 Structured Process to Include All Relevant Factors 63 4.3.3 Unambiguous Approach to Capturing Event Risks 63 4.3.4 Inclusion of Risk Mitigation and Response Factors 66 4.3.5 Simultaneous Occurrence of Uncertainties and Risks 66 4.3.6 Assessing Outcomes in Non-Linear Situations 67 4.3.7 Reflecting Operational Flexibility and Real Options 67 4.3.8 Assessing Outcomes with Other Complex Dependencies 71 4.3.9 Capturing Correlations, Partial Dependencies and Common Causalities 73 4.4 Using the Range of Possible Outcomes to Enhance Decision-Making 74 4.4.1 Avoiding “The Trap of the Most Likely” or Structural Biases 76 4.4.2 Finding the Likelihood of Achieving a Base Case 78 4.4.3 Economic Evaluation and Reflecting Risk Tolerances 82 4.4.4 Setting Contingencies, Targets and Objectives 83 4.5 Supporting Transparent Assumptions and Reducing Biases 84 4.5.1 Using Base Cases that are Separate to Risk Distributions 85 4.5.2 General Reduction in Biases 85 4.5.3 Reinforcing Shared Accountability 85 4.6 Facilitating Group Work and Communication 86 4.6.1 A Framework for Rigorous and Precise Work 86 4.6.2 Reconcile Some Conflicting Views 86 Chapter 5 Organisational Challenges Relating to Risk Modelling 87 5.1 “We Are Doing It Already” 87 5.1.1 “Our ERM Department Deals with Those Issues” 88 5.1.2 “Everybody Should Just Do Their Job Anyway!” 88 5.1.3 “We Have Risk Registers for All Major Projects” 89 5.1.4 “We Run Sensitivities and Scenarios: Why Do More?” 89 5.2 “We Already Tried It, and It Showed Unrealistic Results” 89 5.2.1 “All Cases Were Profitable” 90 5.2.2 “The Range of Outcomes Was Too Narrow” 90 5.3 “The Models Will Not Be Useful!” 91 5.3.1 “We Should Avoid Complicated Black Boxes!” 91 5.3.2 “All Models Are Wrong, Especially Risk Models!” 91 5.3.3 “Can You Prove that It Even Works?” 92 5.3.4 “Why Bother to Plan Things that Might Not Even Happen?” 93 5.4 Working Effectively with Enhanced Processes and Procedures 93 5.4.1 Selecting the Right Projects, Approach and Decision Stage 93 5.4.2 Managing Participant Expectations 95 5.4.3 Standardisation of Processes and Models 95 5.5 Management Processes, Culture and Change Management 96 5.5.1 Integration with Decision Processes 96 5.5.2 Ensuring Alignment of Risk Assessment and Modelling Processes 97 5.5.3 Implement from the Bottom Up or the Top Down? 98 5.5.4 Encouraging Issues to Be Escalated: Don’t Shoot the Messenger! 99 5.5.5 Sharing Accountability for Poor Decisions 99 5.5.6 Ensuring Alignment with Incentives and Incentive Systems 100 5.5.7 Allocation and Ownership of Contingency Budgets 101 5.5.8 Developing Risk Cultures and Other Change Management Challenges 102 Part II The Design of Risk Models – Principles, Processes and Methodology Chapter 6 Principles of Simulation Methods 107 6.1 Core Aspects of Simulation: A Descriptive Example 107 6.1.1 The Combinatorial Effects of Multiple Inputs and Distribution of Outputs 107 6.1.2 Using Simulation to Sample Many Diverse Scenarios 110 6.2 Simulation as a Risk Modelling Tool 112 6.2.1 Distributions of Input Values and Their Role 113 6.2.2 The Effect of Dependencies between Inputs 114 6.2.3 Key Questions Addressable using Risk-Based Simulation 114 6.2.4 Random Numbers and the Required Number of Recalculations or Iterations 115 6.3 Sensitivity and Scenario Analysis: Relationship to Simulation 116 6.3.1 Sensitivity Analysis 116 6.3.2 Scenario Analysis 119 6.3.3 Simulation using DataTables 121 6.3.4 GoalSeek 121 6.4 Optimisation Analysis and Modelling: Relationship to Simulation 122 6.4.1 Uncertainty versus Choice 122 6.4.2 Optimisation in the Presence of Risk and Uncertainty 129 6.4.3 Modelling Aspects of Optimisation Situations 131 6.5 Analytic and Other Numerical Methods 133 6.5.1 Analytic Methods and Closed-Form Solutions 133 6.5.2 Combining Simulation Methods with Exact Solutions 135 6.6 The Applicability of Simulation Methods 135 Chapter 7 Core Principles of Risk Model Design 137 7.1 Model Planning and Communication 138 7.1.1 Decision-Support Role 138 7.1.2 Planning the Approach and Communicating the Output 138 7.1.3 Using Switches to Control the Cases and Scenarios 139 7.1.4 Showing the Effect of Decisions versus Those of Uncertainties 140 7.1.5 Keeping It Simple, but not Simplistic: New Insights versus Modelling Errors 144 7.2 Sensitivity-Driven Thinking as a Model Design Tool 146 7.2.1 Enhancing Sensitivity Processes for Risk Modelling 150 7.2.2 Creating Dynamic Formulae 151 7.2.3 Example: Time Shifting for Partial Periods 153 7.3 Risk Mapping and Process Alignment 154 7.3.1 The Nature of Risks and Their Impacts 155 7.3.2 Creating Alignment between Modelling and the General Risk Assessment Process 156 7.3.3 Results Interpretation within the Context of Process Stages 157 7.4 General Dependency Relationships 158 7.4.1 Example: Commonality of Drivers of Variability 159 7.4.2 Example: Scenario-Driven Variability 160 7.4.3 Example: Category-Driven Variability 162 7.4.4 Example: Fading Impacts 168 7.4.5 Example: Partial Impact Aggregation by Category in a Risk Register 170 7.4.6 Example: More Complex Impacts within a Category 171 7.5 Working with Existing Models 173 7.5.1 Ensuring an Appropriate Risk Identification and Mapping 173 7.5.2 Existing Models using Manual Processes or Embedded Procedures 174 7.5.3 Controlling a Model Switch with a Macro at the Start and End of a Simulation 175 7.5.4 Automatically Removing Data Filters at the Start of a Simulation 176 7.5.5 Models with DataTables 178 Chapter 8 Measuring Risk using Statistics of Distributions 181 8.1 Defining Risk More Precisely 181 8.1.1 General Definition 181 8.1.2 Context-Specific Risk Measurement 181 8.1.3 Distinguishing Risk, Variability and Uncertainty 182 8.1.4 The Use of Statistical Measures 183 8.2 Random Processes and Their Visual Representation 184 8.2.1 Density and Cumulative Forms 184 8.2.2 Discrete, Continuous and Compound Processes 186 8.3 Percentiles 187 8.3.1 Ascending and Descending Percentiles 188 8.3.2 Inversion and Random Sampling 189 8.4 Measures of the Central Point 190 8.4.1 Mode 190 8.4.2 Mean or Average 191 8.4.3 Median 193 8.4.4 Comparisons of Mode, Mean and Median 193 8.5 Measures of Range 194 8.5.1 Worst and Best Cases, and Difference between Percentiles 194 8.5.2 Standard Deviation 195 8.6 Skewness and Non-Symmetry 199 8.6.1 The Effect and Importance of Non-Symmetry 201 8.6.2 Sources of Non-Symmetry 202 8.7 Other Measures of Risk 203 8.7.1 Kurtosis 204 8.7.2 Semi-Deviation 205 8.7.3 Tail Losses, Expected Tail Losses and Value-at-Risk 206 8.8 Measuring Dependencies 207 8.8.1 Joint Occurrence 207 8.8.2 Correlation Coefficients 209 8.8.3 Correlation Matrices 210 8.8.4 Scatter Plots (X–Y Charts) 212 8.8.5 Classical and Bespoke Tornado Diagrams 212 Chapter 9 The Selection of Distributions for Use in Risk Models 215 9.1 Descriptions of Individual Distributions 215 9.1.1 The Uniform Continuous Distribution 216 9.1.2 The Bernoulli Distribution 218 9.1.3 The Binomial Distribution 219 9.1.4 The Triangular Distribution 220 9.1.5 The Normal Distribution 222 9.1.6 The Lognormal Distribution 226 9.1.7 The Beta and Beta General Distributions 232 9.1.8 The PERT Distribution 234 9.1.9 The Poisson Distribution 236 9.1.10 The Geometric Distribution 238 9.1.11 The Negative Binomial Distribution 240 9.1.12 The Exponential Distribution 241 9.1.13 The Weibull Distribution 242 9.1.14 The Gamma Distribution 242 9.1.15 The General Discrete Distribution 244 9.1.16 The Integer Uniform Distribution 245 9.1.17 The Hypergeometric Distribution 245 9.1.18 The Pareto Distribution 246 9.1.19 The Extreme Value Distributions 246 9.1.20 The Logistic Distribution 250 9.1.21 The Log-Logistic Distribution 251 9.1.22 The Student (t), Chi-Squared and F-Distributions 252 9.2 A Framework for Distribution Selection and Use 256 9.2.1 Scientific and Conceptual Approaches 257 9.2.2 Data-Driven Approaches 258 9.2.3 Industry Standards 259 9.2.4 Pragmatic Approaches: Distributions, Parameters and Expert Input 259 9.3 Approximation of Distributions with Each Other 263 9.3.1 Modelling Choices 263 9.3.2 Distribution Comparison and Parameter Matching 265 9.3.3 Some Potential Pitfalls Associated with Distribution Approximations 267 Chapter 10 Creating Samples from Distributions 273 10.1 Readily Available Inverse Functions 274 10.1.1 Functions Provided Directly in Excel 274 10.1.2 Functions Whose Formulae Can Easily Be Created 276 10.2 Functions Requiring Lookup and Search Methods 277 10.2.1 Lookup Tables 277 10.2.2 Search Methods 278 10.3 Comparing Calculated Samples with Those in @RISK 279 10.4 Creating User-Defined Inverse Functions 280 10.4.1 Normal Distribution 281 10.4.2 Beta and Beta General Distributions 282 10.4.3 Binomial Distribution 283 10.4.4 Lognormal Distribution 283 10.4.5 Bernoulli Distribution 284 10.4.6 Triangular Distribution 284 10.4.7 PERT Distribution 284 10.4.8 Geometric Distribution 285 10.4.9 Weibull Distribution 285 10.4.10 Weibull Distribution with Percentile Inputs 285 10.4.11 Poisson Distribution 285 10.4.12 General Discrete Distribution 287 10.5 Other Generalisations 287 10.5.1 Iterative Methods using Specific Numerical Techniques 287 10.5.2 Creating an Add-In 289 Chapter 11 Modelling Dependencies between Sources of Risk 291 11.1 Parameter Dependency and Partial Causality 291 11.1.1 Example: Conditional Probabilities 293 11.1.2 Example: Common Risk Drivers 293 11.1.3 Example: Category Risk Drivers 294 11.1.4 Example: Phased Projects 294 11.1.5 Example: Economic Scenarios for the Price of a Base Commodity 295 11.1.6 Example: Prices of a Derivative Product 296 11.1.7 Example: Prices of Several Derivative Products 297 11.1.8 Example: Oil Price and Rig Cost 297 11.1.9 Example: Competitors and Market Share 298 11.1.10 Example: Resampling or Data-Structure-Driven Dependence 299 11.1.11 Implied Correlations within Parameter Dependency Relationships 302 11.2 Dependencies between Sampling Processes 302 11.2.1 Correlated Sampling 303 11.2.2 Copulas 304 11.2.3 Comparison and Selection of Parameter-Dependency and Sampling Relationships 306 11.2.4 Creating Correlated Samples in Excel using Cholesky Factorisation 309 11.2.5 Working with Valid Correlation Matrices 313 11.2.6 Correlation of Time Series 315 11.3 Dependencies within Time Series 316 11.3.1 Geometric Brownian Motion 317 11.3.2 Mean-Reversion Models 319 11.3.3 Moving Average Models 321 11.3.4 Autoregressive Models 321 11.3.5 Co-Directional (Integrated) Processes 323 11.3.6 Random State Switching and Markov Chains 323 Part III Getting Started with Simulation in Practice Chapter 12 Using Excel/VBA for Simulation Modelling 327 12.1 Description of Example Model and Uncertainty Ranges 327 12.2 Creating and Running a Simulation: Core Steps 328 12.2.1 Using Random Values 328 12.2.2 Using a Macro to Perform Repeated Recalculations and Store the Results 330 12.2.3 Working with the VBE and Inserting a VBA Code Module 330 12.2.4 Automating Model Recalculation 331 12.2.5 Creating a Loop to Recalculate Many Times 331 12.2.6 Adding Comments, Indentation and Line Breaks 332 12.2.7 Defining Outputs, Storing Results, Named Ranges and Assignment Statements 333 12.2.8 Running the Simulation 334 12.3 Basic Results Analysis 335 12.3.1 Building Key Statistical Measures and Graphs of the Results 335 12.3.2 Clearing Previous Results 336 12.3.3 Modularising the Code 338 12.3.4 Timing and Progress Monitoring 339 12.4 Other Simple Features 339 12.4.1 Taking Inputs from the User at Run Time 339 12.4.2 Storing Multiple Outputs 340 12.5 Generalising the Core Capabilities 340 12.5.1 Using Selected VBA Best Practices 340 12.5.2 Improving Speed 341 12.5.3 Creating User-Defined Functions 342 12.6 Optimising Model Structure and Layout 343 12.6.1 Simulation Control Sheet 343 12.6.2 Output Links Sheet 344 12.6.3 Results Sheets 344 12.6.4 Use of Analysis Sheets 346 12.6.5 Multiple Simulations 348 12.7 Bringing it All Together: Examples Using the Simulation Template 350 12.7.1 Model 1: Aggregation of a Risk Register using Bernoulli and PERT Distributions 351 12.7.2 Model 2: Cost Estimation using Lognormal Distributions 352 12.7.3 Model 3: Cost Estimation using Weibull Percentile Parameters 352 12.7.4 Model 4: Cost Estimation using Correlated Distributions 353 12.7.5 Model 5: Valuing Operational Flexibility 353 12.8 Further Possible uses of VBA 354 12.8.1 Creating Percentile Parameters 354 12.8.2 Distribution Samples as User-Defined Functions 354 12.8.3 Probability Samples as User-Defined Array Functions 355 12.8.4 Correlated Probability Samples as User-Defined Array Functions 356 12.8.5 Assigning Values from VBA into Excel 358 12.8.6 Controlling the Random Number Sequence 359 12.8.7 Sequencing and Freezing Distribution Samples 363 12.8.8 Practical Challenges in using Arrays and Assignment Operations 364 12.8.9 Bespoke Random Number Algorithms 364 12.8.10 Other Aspects 364 Chapter 13 Using @RISK for Simulation Modelling 365 13.1 Description of Example Model and Uncertainty Ranges 365 13.2 Creating and Running a Simulation: Core Steps and Basic Icons 366 13.2.1 Using Distributions to Create Random Samples 368 13.2.2 Reviewing the Effect of Random Samples 369 13.2.3 Adding an Output 370 13.2.4 Running the Simulation 370 13.2.5 Viewing the Results 370 13.2.6 Results Storage 373 13.2.7 Multiple Simulations 373 13.2.8 Results Statistics Functions 374 13.3 Simulation Control: An Introduction 377 13.3.1 Simulation Settings: An Overview 377 13.3.2 Static View 377 13.3.3 Random Number Generator and Sampling Methods 379 13.3.4 Comparison of Excel and @RISK Samples 381 13.3.5 Number of Iterations 382 13.3.6 Repeating a Simulation and Fixing the Seed 382 13.3.7 Simulation Speed 383 13.4 Further Core Features 384 13.4.1 Alternate Parameters 384 13.4.2 Input Statistics Functions 384 13.4.3 Creating Dependencies and Correlations 385 13.4.4 Scatter Plots and Tornado Graphs 385 13.4.5 Special Applications of Distributions 395 13.4.6 Additional Graphical Outputs and Analysis Tools 400 13.4.7 Model Auditing and Sense Checking 405 13.5 Working with Macros and the @RISK Macro Language 405 13.5.1 Using Macros with @RISK 405 13.5.2 The @RISK Macro Language or Developer Kit: An Introduction 407 13.5.3 Using the XDK to Analyse Random Number Generator and Sampling Methods 409 13.5.4 Using the XDK to Generate Reports of Simulation Data 417 13.6 Additional In-Built Applications and Features: An Introduction 417 13.6.1 Optimisation 419 13.6.2 Fitting Distributions and Time Series to Data 420 13.6.3 MS Project Integration 421 13.6.4 Other Features 421 13.7 Benefits of @RISK over Excel/VBA Approaches: A Brief Summary 421 Index 425
£84.60
John Wiley & Sons Inc Visualizing Financial Data
Book SynopsisA fresh take on financial data visualization for greater accuracy and understanding Your data provides a snapshot of the state of your business and is key to the success of your conversations, decisions, and communications.Table of ContentsForeword xv Introduction xvii PART 1: INFORMATION GAINS THROUGH DATA VISUALIZATIONS CHAPTER 1: Paving a Path Toward Visual Communications 3 Information Delivery Needs 5 Industry Demands 6 Enabling Factors 8 Summary 11 CHAPTER 2: Benefits of Using Visual Methods 15 The Purpose of Charts 16 Making Comparisons 17 Establishing Connections 19 Drawing Conclusions 22 How to Leverage Charts 25 Summary 31 PART 2: TRANSFORMING DATA FOR ACTIVE INVESTMENT DECISIONS CHAPTER 3: Security Assessment 35 Tile Framework 36 Stocks 39 Bonds 42 Mutual Funds 44 ETFs 50 Tile Collection 55 Summary 58 CHAPTER 4: Portfolio Construction 61 Asset Allocation 62 Sector Analysis 67 Sector Leadership 67 Sectors and Alpha Factors 78 Risk Management 85 Overlap of Holdings 87 Stress Tests 99 Summary 106 CHAPTER 5: Trading 109 Ticker 110 Quote 117 Watchlist 127 Visual System: Ticker, Quote, and Watchlist 138 Summary 140 CHAPTER 6: Performance Measurement 143 Market Performance 144 Investment Firm Composite 151 Portfolio Gain/Loss 157 Attribution 161 Return Attribution 161 Risk Attribution 171 Summary 177 PART 3: SHOWCASING DATA FOR EFFECTIVE COMMUNICATIONS CHAPTER 7: Financial Statements 183 Statement of Cash Flows 184 Nonprofit Organizations 184 For-Profit Organizations 191 Statement of Financial Activity 202 Operating Budget 206 Summary 212 CHAPTER 8: Pension Funds 217 Plan Members 218 Members in Valuation 219 Post Retirement 227 Retirement Programs 232 Contributions versus Benefits 241 Additions by Source 241 Changes in Retirees & Beneficiaries 250 History of Member Salary 253 Funding Ratio 257 Summary 264 CHAPTER 9: Mutual Funds 267 Core Components 268 Allocation Profile 269 Fees 277 Performance 285 Risk 293 Fund Fact Sheets 312 Mutual Fund Comparison 318 Total Returns 319 Ranking Against Benchmarks 324 Summary 332 CHAPTER 10: Hedge Funds 335 Long/Short Positions 336 Long Positions and Benchmarking 344 Fund Characteristics 349 Strategy Rank 356 Strategy Rank and Ranges 361 Strategy Analysis 363 All Strategy Averages 364 Single Strategy Averages 367 Fund Level Returns 373 Summary 378 PART 4: NEXT STEPS CHAPTER 11: Data Visualization Principles 383 Cater to Your Audience 384 Provide Clarity 394 Be Efficient 403 Summary 414 CHAPTER 12: Implementing the Visuals 417 Business Value Assessment 418 Implementation Effort 422 Available Methods 427 Solution Score 428 Summary 432 Index 435
£34.99
John Wiley & Sons Inc Actionable Intelligence
Book SynopsisBuilding an analysis ecosystem for a smarter approach to intelligence Keith Carter''s Actionable Intelligence: A Guide to Delivering Business Results with Big Data Fast! is the comprehensive guide to achieving the dream that business intelligence practitioners have been chasing since the concept itself came into being. Written by an IT visionary with extensive global supply chain experience and insight, this book describes what happens when team members have accurate, reliable, usable, and timely information at their fingertips. With a focus on leveraging big data, the book provides expert guidance on developing an analytical ecosystem to effectively manage, use the internal and external information to deliver business results. This book is written by an author who''s been in the trenches for people who are in the trenches. It''s for practitioners in the real world, who know delivering results is easier said than done fraught with failure, and difficult politiTable of ContentsPreface xi Acknowledgments xvii Introduction 1 Chapter 1: Vision of Actionable Intelligence 5 The Challenge at Hand 7 The Big Data Lie 13 Actionable Intelligence: The Road and the Destination 14 Stages of Actionable Intelligence: Getting Ready for the Journey by Knowing Where You Are and Where to Go 22 Are You Ready to Take the First Step? 26 Summary and Considerations 29 Notes 29 Chapter 2: Discovery of the Business Situation (Business Discovery) 31 Government Intelligence 34 Ask the Questions 37 Answer the Questions: Business Discovery 38 Visual Consistency and the First Tool 42 Off to the Races 45 Summary and Considerations 45 Notes 45 Chapter 3: Creating a Foundation of Data 47 Building the Foundation 48 Benefits of Having the Right Data 49 The Data Challenge 50 Acquire Data in Four Consistent Steps 51 The Byproduct: Master Data Management 61 Data Management Issues in the Spotlight 63 The Data Supply Chain 65 Build the House 65 Summary and Considerations 67 Notes 68 Chapter 4: Visualization 69 Complete Circle 70 So Now, How Can You Do It? 74 The Way Ahead 77 Example of Iterative Visualization to Solve the Question “How Do I Get There Quickly, Safely, Efficiently:” Leveraging Global Positioning System Data 77 Effective Visualizations: Tell a Story to Your Mind 80 Noticing Visualization Pitfalls 80 Summary and Considerations 83 Notes 83 Chapter 5: The Initial Answers 85 Attempting to Regularly Capture Benefits, False Starts, and a Rhythm 87 The Results of Actionable Intelligence Delivered 87 The Power of Quotes 89 Possibilities with Actionable Intelligence 89 Almost Done? 98 Summary and Considerations 99 Note 99 Chapter 6: Time for Change 101 Collaborative Business Planning 103 Linking Collaboration to Actionable Intelligence 106 Summary and Considerations 110 Chapter 7: Governance: Funding Intelligence, Protecting the Results 111 An Actionable Intelligence Governance Methodology 112 Intelligence Budgeting 121 Remember the Key Points of the UPS Story 122 Governing the Use of Actionable Intelligence and Establishing Data Security 125 Summary and Considerations 133 Notes 133 Chapter 8: Sustaining Delivery of Actionable Intelligence 135 Leading Intelligence 136 Quick Wins to Build Trust 140 Hiring Done Right for Big Data with Big Data 145 Training 148 Business Cultural Change 149 Communication 155 Knowledge Lock‐In 157 What’s Next? 159 Summary and Considerations 161 Notes 161 Chapter 9: Tying It All Together 163 Clifford Siegel’s Journey at Lifetime Brands 163 Starting the Right Way 165 Finding the Right Pitch 166 Developing a Mission and Strategy for Intelligence Capabilities 167 TIE: The Intelligent Enterprise at STATS ChipPAC with Elizabeth Lim 170 The Recipe to Greatness 174 Summary and Considerations 179 Notes 180 Chapter 10: Next Frontiers 181 A Healthier Lifestyle with Actionable Intelligence 183 The Street‐Smart Cabbies 184 The Amplified Customer Experience 186 Selling Better 187 Serve Me Better . . . But Don’t Intrude on My Private Life 188 Getting Started 189 The Starbucks Experience 190 Summary and Considerations 191 Notes 191 Chapter 11: Epilogue 193 Four Steps of Actionable Intelligence 195 About the Author 197 About the Contributors 199 Index 201
£34.19
John Wiley & Sons Inc VMware vSphere PowerCLI Reference
Book SynopsisMaster vSphere automation with this comprehensive reference VMware vSphere PowerCLI Reference, Automating vSphere Administration, 2nd Edition is a one-stop solution for vSphere automation. Fully updated to align with the latest vSphere and PowerCLI release, this detailed guide shows you how to get the most out of PowerCLI''s handy cmdlets using real-world examples and a practical, task-based approach. You''ll learn how to store, access, update, back up, and secure massive amounts of data quickly through the power of virtualization automation, and you''ll get acquainted with PowerCLI as you learn how to automate management, monitoring, and life-cycle operations for vSphere. Coverage includes areas like the PowerCLI SDK, SRM, vCOPS, and vCloud Air. Plus guidance toward scheduling and viewing automation, using DevOps methodology and structured testing and source control of your PowerCLI scripts. Clear language and detailed explanations make this reference the Table of ContentsIntroduction xxiii Part I Install, Configure, and Manage the vSphere Environment 1 Chapter 1 Automating vCenter Server Deployment and Configuration 3 Chapter 2 Automating vSphere Hypervisor Deployment and Configuration 41 Chapter 3 Automating Networking 75 Chapter 4 Automating Storage 119 Rule Sets 146 Chapter 5 Using Advanced vSphere Features 165 Part II Managing the Virtual Machine Life Cycle 211 Chapter 6 Creating Virtual Machines 213 Chapter 7 Using Templates and Customization Specifications 243 Chapter 8 Configuring Virtual Machine Hardware 265 Chapter 9 Advanced Virtual Machine Features 293 Chapter 10 Using vApps 331 Part III Securing Your vSphere Environment 373 Chapter 11 Backing Up and Restoring Your Virtual Machines 375 Chapter 12 Organize Your Disaster Recovery 397 Chapter 13 Hardening the vSphere Environment 441 Chapter 14 Maintain Security in Your vSphere Environment 475 Part IV Monitoring and Reporting 495 Chapter 15 Reporting and Auditing 497 Chapter 16 Using Statistical Data 545 Chapter 17 Alarms 585 Part V Integration 619 Chapter 18 The SDK 621 Managed Object References 644 Chapter 19 vCloud Director 663 Chapter 20 vCloud Air 693 Chapter 21 vRealize Orchestrator 711 Chapter 22 Site Recovery Manager 791 Chapter 23 PowerActions 811 Part VI PowerCLI and DevOps 839 Chapter 24 Source Control 841 Chapter 25 Running Scripts 895 Appendix Example Reports 915 Index 935
£38.00
John Wiley & Sons Inc QlikView Your Business
Book SynopsisUnlock the meaning of your data with Qlikview Qlik platform was designed to provide fast and easy analytics and QlikView Your Business is your detailed, full-color, step-by-step guide to all features and techniques so you can quickly start unlocking your data s potential.Table of ContentsForeword xiii Introduction xv PART I Getting Started Chapter 1 The Needs and Challenges of Business Intelligence and Analytics 3 The Case for Business Intelligence 4 Common Challenges of Business Analytics 6 How Successful Businesses Use Business Intelligence 7 Introducing the Six Process Spheres 7 Identifying Business Measures 10 What Companies Gain from Implementing BI 14 The Business Scenario Used in the Book 16 Chapter 2 Why Use Qlik for Data Discovery and Analytics? 17 The Evolution of BI 18 Traditional Business Intelligence (OLAP) 18 Qlik’s Disruptive Approach to BI 20 Data Discovery Is the New Black 22 QlikView 11 Overview 23 In-Memory Storage Means No Need for Pre-Calculated Cubes 23 An Interactive User Experience 24 Associative Logic Powers Data Discovery 26 Right-Sized Analytics 32 Qlik Sense Overview 32 PART II Learning the Core Techniques: Sales Analysis Chapter 3 Defining a Business Scenario for Sales Analysis 41 “What Do You Mean When You Say Sales?” 42 What Is the Real Value of the Sale? 43 What Happened? 45 Why Did it Happen? What Does It Mean for My Business? 46 What Data Is Needed 50 Advanced Sales Analysis Makes the Data Visible and Available 51 Chapter 4 Visualizing Sales Analysis in QlikView 53 Preparing the Environment and Getting Ready 54 Opening a Template Document 54 Sheets and Sheet Objects 57 Working with Colors in QlikView 59 List Boxes, Text Objects, and Other Sheet Objects 60 Introducing List Boxes and Multi Boxes 61 Table Box and How It Should (Not) Be Used 65 Using Text Objects for Labels, Images, and Backgrounds 66 Line/Arrow Object 69 Mind Your Selections: Search Object and Current Selections Box 70 Organizing and Arranging Objects on the Screen 73 Developing Simple Charts in QlikView 78 Main Components of QlikView Charts 79 Using Bar Charts to Compare Outcomes Among Brands, Channels, and Salespeople 82 Using Line Charts to Visualize Trends over Time 92 Using Pie Charts to Visualize Distribution of the Whole Between its Parts 97 Using Straight Tables and Pivot Tables to Show Details 100 First Round of Improvements 111 Gathering Feedback at the First Application Review 111 Using Groups to Add Flexibility to Your Charts 113 Comparing YTD to Prior YTD or Other Conditions 118 Building Dashboards 129 Bringing It All Together 140 Chapter 5 Data Modeling for Sales Analysis 145 Data Modeling Basics 146 The Transactional Software Class 147 Using ETL to Populate Dimensional Tables 155 Designing a Data Model for Sales Analysis 159 Tips Before You Start Scripting 168 Chapter 6 Developing a Data Load Script for Sales Analysis 169 Load Script and Script Editor 170 Script Editor Basics in QlikView 170 Anatomy of a QlikView SQL Select Statement 177 Organizing Your Script 179 Using the Table Viewer and Understanding the Data Model 186 Resolving Simple Challenges in Data Load 188 Introducing Synthetic Keys and Circular References 189 Avoiding Synthetic Keys by Renaming Fields 191 Using the QUALIFY and UNQUALIFY Commands 192 A Few Words About Naming Conventions 196 Transforming the Data Model 197 Loading Data from a Spreadsheet 198 Enhancing the Data Model for Online Analytics 204 Joining Two Tables into One 207 Adding Calculated Fields 213 Additional Transformations: Calculating Conditional Flags 222 Adding a Master Calendar Table Using INCLUDE 233 PART III Expanding Your Skill Set: Profitability Analysis Chapter 7 Defining a Business Scenario for Profitability Analysis 241 The Profit and Loss Statement 242 The Direct Variable Profitability (DVP) Model 245 Deep Dive Example 248 Use of Business Intelligence Tools Makes the Data Visible and Available 251 Chapter 8 Visualizing Profitability Analysis in QlikView 253 Simple Visualizations for Profitability Analysis 254 Preparing the Template for Profitability Analysis 254 Preparing the Expressions for Profitability Calculations 256 Revisiting Simple Visualization Objects 286 Learning Advanced Visualizations 292 Visualizing Components of Costs and Profits 292 How to Visualize Correlations Between Sales and Profits 308 Advanced Visualizations Using Set Analysis 339 Using Containers as an Alternative to Auto-Minimized Charts 349 Chapter 9 Data Modeling for Profitability Analysis 355 How QlikView Stores Data 356 Modeling Multiple Transaction Sources 361 Multiple Fact Tables 362 The Concatenated Fact Table 369 Working With Dimensions 370 Slowly Changing Dimensions Defined 371 Product Costs as Dimension Attributes 373 Product Costs as Fact Metrics 375 Chapter 10 Developing a Data Load Script for Profitability Analysis 379 Creating a QVD Data Layer 380 Why Do You Need a Separate Data Layer? 380 Introducing the QVD File Format 381 Variables and Script Control Statements 384 Troubleshooting QlikView Load Scripts 406 Creating Transformed QVD Files for Profitability Data 411 Generating New Transformed QVDs 415 Building the Data Model for Profitability Analysis 416 An Overview of the Process 417 Aggregating Data in QlikView 418 How to Use Mapping in QlikView Script 420 Using Aggregation and Mapping to Load the Credit Memos 425 Building the Link Table 431 Building the Master Calendar 439 A Few Words About Link Tables 452 A Round of Improvements 455 Modifying the Data Model to Restore Missing Associations 456 Loading Complex Spreadsheets 457 Adding Commissions Data to the Data Model 470 Explaining the Multi-Tier Data Architecture 471 PART IV Mastering Advanced Techniques: Inventory Analysis Chapter 11 Defining a Business Scenario for Inventory Analysis 477 What Is Inventory—Asset or Liability? 477 Factors to Consider When Measuring Inventory 479 The Definition of Inventory Analysis 481 Commonly Used Metrics for Inventory Analysis 482 Common Data Elements Required for Inventory Analysis 484 The Benefits of Advanced Inventory Analysis 485 Chapter 12 Visualizing Inventory Analysis in QlikView 489 Developing the Key Measures for Inventory Analysis 490 Preparing the Environment for Inventory Analysis 490 Using Advanced Aggregation (AGGR) for Inventory Measures 500 Enhancing Visual Analysis with Advanced Aggregation 513 Developing Histograms 513 Visualizing Parts of Totals and Subtotals 518 Bucket Analysis 536 Does It Get Any More Advanced with Advanced Aggregation and Advanced Set Analysis? 542 Comparing TOTAL with AGGR() 542 Using TOTAL and AGGR() with Dimensions Outside of the Chart Data 545 More About Advanced Set Analysis 548 Comparative Analysis Using Alternate States 556 Declaring Alternate States 556 Assigning Objects to Alternate States 557 Using Alternate States in Combination with Set Analysis 560 Combining Selections from Multiple States 561 Getting Advanced with Straight Tables 563 Using Gauges in Straight Tables 564 Mini Charts (Sparklines) 567 Adding Images to Straight Tables 570 Adding Links (URLs) to Straight Tables 574 Advanced Presentation Features—Buttons, Actions, and Triggers 577 Buttons and Actions 578 Using Show Conditions and Calculation Conditions 582 Using Buttons, Actions, and Show Conditions to Develop Advanced Navigation Features 583 Chapter 13 Data Modeling for Inventory Analysis 589 Calculating Running Balances 590 The Logic of Calculating a Running Balance 590 How Running Balances Apply to Inventory and Inventory Aging 591 The Concatenated Fact Table 593 Introducing the Concatenated Fact Table 593 Resolve Missing Associations 596 Forcing Alignment with Link Tables and Generic Keys 598 Link Tables or Concatenated Facts? 600 Advanced Date Handling 601 Should Date Flags Reside in the Master Calendar or in the Fact Table? 601 Supporting Flexible “As Of” Dates 604 Chapter 14 Developing a Data Load Script for Inventory Analysis 607 Review of the Business Requirements and the Data Sources 608 Transforming Inventory Data 610 The Process of Generating the Aging Data 610 Transforming Sales Data for Inventory Analysis 616 Transforming On-Hand Balances and On-Hand History Data 626 Storing the Transformed QVD Files 627 Building the Concatenated Fact Table 628 Combining Multiple Facts in a Single Table 628 Propagating Missing Attributes to All the Slices of the Concatenated Fact 632 Adding Dimension Tables and Calculated Fields 635 Restoring Missing Associations 640 Building the As Of Date Table 648 Generating Chart Expressions in the Script 654 Creating Expressions Stored in Variables in the Script 655 Loading Expressions from External Text Files 660 A Few Words in Conclusion 667 Presentation Features Not Covered in the Book 668 Scripting Features Not Covered in the Book 669 PART V Qlik Sense Chapter 15 Loading Data in Qlik Sense 673 Getting Oriented with Qlik Sense 674 Introducing the Desktop Hub 674 Create a New App 676 Using Quick Data Load 678 The QDL Wizard 678 Drag and Drop 679 Using the Data Load Editor 681 Navigation and Layout 682 Introducing Data Connections 683 Loading Data from QlikView into Qlik Sense 689 Loading Data for Sales Analysis 690 Using Developer Tools 695 Data Model Viewer 695 Debug Panel 698 Chapter 16 Developing Visualizations in Qlik Sense 701 Exploring the Qlik Sense Visual Environment 702 Navigation in Qlik Sense 702 Building Simple Charts 703 Introducing the Library of Master Items 707 Developing the Sales Analysis Dashboard in Qlik Sense 713 Building More Advanced Analytics in Qlik Sense 721 Selections in Qlik Sense 728 Making Selections in Charts 728 Working with Current Selections 729 The Search and Selections Tools 730 Introducing the Filter Pane 732 Storytelling 733 Taking Snapshots 733 Creating Stories 735 Using Story Playback 737 Geo-Mapping in Qlik Sense 738 Loading Geography Data 738 Creating Maps 743 Integrating Qlik Sense Apps 749 Defining Qlik Sense Integration Terminology 749 Integrating Extensions in Qlik Sense 750 Exploring the Feature of Converting Charts 752 Where to Find More Extensions and More Information 753 What About Mashups? 754 Appendix What’s Next? 755 Index 759
£48.75
John Wiley & Sons Inc The Socially Savvy Advisor
Book SynopsisThe social media marketing bible for the financial industry The Socially Savvy Advisor: Compliant Social Media for the Financial Industry is the complete guide to creating an effective social media strategy without breaking the big rules. Written by an industry specialist Jennifer Openshaw, alongside Stuart Fross, Fidelity International''s former general counsel, and Amy McIlwain, president of Financial Social Media, this book merges marketing basics with FINRA and SEC guidelines to help readers create an effective social media campaign specifically for the finance and investing world. Contributions from industry leaders at Charles Schwab, Citibank, and others provide inside perspective and experience so readers can tap into a new audience. With a focus on compliance, the book clears common hurdles while dispelling myths and outlining effective methods and techniques. Readers also gain access to a website featuring videos, Q & As, tutorials, Slideshare, and a social mTable of ContentsForeword xi Acknowledgments xiii Introduction xv Part One The New Business Environment Chapter 1 How is Social Media Changing Investor Behavior? 3 Chapter 2 What Are Social Media's Implications for the Financial Industry? 9 Chapter 3 What Are the Tensions Between Social Media and Regulation? 19 Chapter 4 Are the Risks of Using Social Media Worth the Benefits? 25 Chapter 5 How Will Social Media Change Our Industry in 10 Years? 33 Chapter 6 What Are the Biggest Social Media Myths? 41 Part Two The Regulatory Environment Chapter 7 What Are the Top Challenges Compliance Officers Face? 49 Chapter 8 What Does FINRA Say about Social Media? 55 Chapter 9 What Does the SEC Say about Social Media? 63 Chapter 10 What Gets Financial Professionals into Trouble with Social Media? 71 Chapter 11 How Do We Create a Social Media Policy? 79 Part Three Key Playing Fields in Social Media Chapter 12 How Can We Use LinkedIn? 87 Chapter 13 How Can We Use Facebook? 99 Chapter 14 How Can We Use Twitter? 109 Chapter 15 How Can We Use YouTube? 119 Chapter 16 How Can We Use Google+? 127 Chapter 17 What Other Social Media Platforms Can Professionals Use? 133 Part Four Marketing and Business Development Chapter 18 How Do We Decide Which Social Media Platforms to Use? 147 Chapter 19 How Do We Integrate Social Media with Overall Marketing? 153 Chapter 20 How Do We Measure Social Media ROI? 165 Chapter 21 What Types of Content Work Best? 171 Chapter 22 How Do We Use SEO to Reach Key Audiences? 181 Chapter 23 How Can We Leverage Paid Social Media Promotions? 193 Chapter 24 How Do We Avoid Copyright Problems? 199 Chapter 25 How Do We Track and Defend Our Reputation on Social Media? 203 Chapter 26 How Can We Use Social Media to Promote Our Events? 209 Chapter 27 Do We Need a Social Media Manager? 219 Part Five Client Servicing Chapter 28 How Can Social Media Be Used to Save Time and Money in Servicing Clients? 227 Chapter 29 How Can We Use Social Media to Create Client Groups? 237 Chapter 30 How Do We Prevent Competitors from Poaching Our Clients on Social Media? 245 Part Six Managing Social Media Compliantly Chapter 31 What Are the Investor-Protection Rules as They Relate to Social Media? 251 Chapter 32 How Can We Comply with Making Securities Recommendations Through Social Media? 255 Chapter 33 How Can We Pre-Approve Content? 261 Chapter 34 How Can We Comply with Rules Related to Testimonials, Endorsements, and Advertising? 267 Chapter 35 How Can We Spot-Check Employee Behavior on Social Media? 273 Chapter 36 What Cybersecurity Mistakes Should Advisors Avoid? 277 Chapter 37 How Does the JOBS Act Impact Social Media and Hedge Funds? 287 Chapter 38 How Will Social Media Change the Role of the CCO in the Years Ahead? 293 Appendix Sample Social Media Policy 297 About the Author 343 About the Contributors 344 About the Companion Website 345 Index 346
£43.12
John Wiley & Sons Inc Minecraft Redstone For Dummies
Book SynopsisThe indispensable primer for achieving redstone greatness Minecraft Redstone For Dummies is the complete guide to finding, using, and maximizing the power of redstone in the Minecraft world.Table of ContentsIntroduction 1 About This Book 1 Foolish Assumptions 2 Icons Used in This Book 2 Where to Go from Here 3 Chapter 1: Introducing Redstone 5 Exploring Redstone Basics 5 Understanding How Redstone Works 7 Discovering the Applications of Redstone 8 Chapter 2: Getting Started with Redstone Programming 11 Gathering Redstone Dust 11 Laying Out Redstone Dust 12 Carrying a charge 13 Measuring redstone strength 15 Connecting machines 16 Crafting and Implementing Redstone Items 17 Redstone torches 17 Redstone repeaters 21 Redstone comparators 25 Redstone blocks 28 Powering Blocks 29 Understanding which blocks can be powered 30 Making a block powered 30 Applying powered blocks 31 Preventing blocks from being powered 32 Chapter 3: Using Redstone to Power Mechanisms 35 Using Mechanisms to Activate Redstone Devices 35 Powering Machines with Redstone 38 Using Minecart Mechanisms 40 Minecarts 40 Rails 42 Connecting Mechanisms 43 Assembling simple creations 44 Connecting machines with redstone 45 Chapter 4: Understanding the Laws of Redstone 49 Exploring the Laws of Redstone 49 The laws of power production 50 The laws of power reception 51 Designing Space-Efficient Redstone Machines 52 Building Some Essential Redstone Devices 53 Producing sensors 53 Building automatic minecart machines 55 Chapter 5: Designing Logic Gates, Loops, and Other Devices 57 Designing Basic Logic Gates 57 The NOT gate 58 The OR gate 59 The AND gate 60 The XOR gate 62 Examining Loops 64 Constructing a loop 64 Implementing loops 67 Manipulating Redstone Strength 68 Constructing Various Useful Redstone Devices 69 Implementing memory 70 Designing a block update detector 72 Building redstone vertically 73 Chapter 6: Using Physical Machines in Redstone Devices 75 Moving and Sorting Items between Containers 75 Implementing and connecting hoppers 76 Using hoppers to distribute items 78 Building item-based circuits 80 Pushing Blocks Around with Piston Machines 82 Hooking pistons together 82 Pushing powerful blocks 83 Sticking blocks together with slime blocks 86 Managing Entities with Redstone Circuits 87 Moving entities around 88 Using entities as input in redstone circuits 89 Building Circuits and Machines with Minecart Tracks 89 Understanding Other Applications of Physical Machines 91 Building an automatic farm 92 Programming fancy doors and locks 93 Bouncing entities with slime blocks 93 Chapter 7: Introducing the Command Block 95 Obtaining a Command Block 96 Programming and Activating a Command Block 96 Applying Different Commands 98 Basic commands 99 Advanced commands 103 Autocompleting Commands on the Chat Menu 118 Implementing Special Arguments in Commands 119 Examining relative positions 119 Applying selectors 120 Managing a Scoreboard 122 Creating scoreboard objectives 122 Acquainting players with the scoreboard 125 Creating teams with the scoreboard 127 Chapter 8: Using Data Tags to Customize Objects 129 Understanding the Syntax of Data Tags 129 Introducing Data Tags Belonging to Entities 132 Integrating attributes and modifiers in entities 144 Summoning customized villagers 146 Throwing blocks around with the FallingSand entity 148 Equipping and posing armor stands 150 Implementing Data Tags in Items 151 Modifying attributes through items 155 Implementing the display tag 158 Creating custom fireworks 159 Containing Data Tags in Blocks 161 Fixing Bugs in Commands and Their Data Tags 168 Trying out some general debugging methods 168 Identifying specific error messages 169 Chapter 9: Combining Commands 171 Discovering the Applications of Combined Commands 171 Exploring interesting command-block combinations 172 Connecting command blocks and comparators 173 Using the scoreboard to combine commands 177 Applying Commands to Redstone Machines 178 Creating impossible machines with command circuits 178 Setting command blocks on loops 180 Using Generalized Variables to Create Commands Efficiently 182 Using one command block in place of many 182 Mastering relative coordinates 183 Using command block minecarts 184 Chapter 10: Building a Custom World with Redstone 187 Introducing Custom Worlds 188 Customizing a Map for Other Players 189 Setting up the map 189 Controlling the adventure with redstone 190 Using Redstone to Produce Coordinated Events 191 Performing tasks determined by active player input 192 Triggering events with passive player input 193 Constructing Challenges 195 Planning out and assembling a minigame 196 Constructing an adventure 198 Chapter 11: Ten Redstone Tricks for Survival Mode 201 Self-Harvesting Farms 201 Adjustable Implements 202 Dungeon Farms 203 Fast Transportation 204 Defense Mechanisms 205 Mechanical Lights, Walls, Bridges, and Other Elements 206 Elevators 206 Handy Dispensers 207 Automatic Notifications 207 Redstone in Battle 207 Index 209
£14.04
John Wiley & Sons Inc Staying the Course as a CIO
Book SynopsisSTAYING THE COURSE AS A CIO: HOW TO OVERCOME THE TRIALS AND CHALLENGES OF IT LEADERSHIP The shelf-life of a Chief Information Officer can be shockingly short. Few survive in post for more than a few years. More often each falls prey to insurmountable problems and their careers come to a sharp and ignominious end. In this book, a global CIO with over thirty years of experience in major corporations examines the main reasons why this happens. Readers will understand which types of issue can cause problems for an IT Leader and more importantly, they will learn strategies of how these problems can be minimized or even avoided. IT is often seen a technical backwater, but it is a discipline which has the capability to add massive value to an organisation whether it is in the private or the public sector provided of course it has the right leadership doing the right things. Aspiring IT Leaders will need to deal with acommon set of recurring trials and challengeTrade Review“If you are a CIO or thinking about taking on the position, this book should be on your list of essential reading….it is an excellent book” (BCS, February 2015) “The distillation of 30 years of experience from a CIO who knows a thing or two about an extended shelf life” (i-cio.com, February 2015)“Michell gives useful advice on how to work through the toughest projects and solve some of the most pressing issues CIOs deal with today” (World Economic Forum, May 2015) “For IT professionals looking to fully integrate their function into the enterprise, 'Staying the Course as a CIO' is a valuable source of practical advice, all based on real experience.” (Good Reads, June 2015)Table of ContentsIntroduction xi Chapter 1 Dislocated Stakeholders 1 Wooden Poles with Holder 2 Because They’re Worth It? 4 The Joys of Middle Management 10 Layers and Spans 11 Middle Managers and the Linkage between IT and the Business 13 The View from the Top of the Tree 16 Bored Boards 18 The Relationship Conundrum 19 The Henry VIII Method 20 The Customer/Supplier Model 20 Teamwork! 23 Could I Have Something Impossible Please? 26 The Dead‐Hero Zone 26 Magicians, Circuses and Keeping Something in the Tank 28 Chapter 2 Pathogenic Projects 31 IT Projects are Harder than Climbing Everest 33 Not Everyone Gets to be a Pharaoh 36 Don’t Start Anything You Can’t Finish 38 Peaches Are not the Only Fruit 39 Ungrouping Group‐Think 40 Mugging by PowerPoint 42 Back to the Himalayas 43 Stalinist Project Management 44 Undo‐able Projects 44 Stalin’s Special Question 45 Being Nostradamus 49 My Piece of String is Skewed 51 Things Can Go Badly Wrong, but They Rarely Go Badly Right 52 Inoculating against Skew—Percentile Therapy 54 What Happens in Projects Stays in Projects 56 The Gates of Wrath 58 Looking Up from the Pit 62 Chapter 3 Seriously Shaky Software 63 Software Just Doesn’t Wo.. 65 Being Immune to Tangerines 70 The Unfortunate Side‐Effect of Moore’s Law 72 It Will be Fixed in the Next Release 74 Upgrade or You Will be Banished Naked to a World of Loneliness and Isolation 75 Belchware not Bloatware 77 Patched, Leaking and Lost in a Maze 79 The Wobbly Stack 81 Stabilising Shakiness 84 Safe Software 85 The Safe Software Game 86 Booking a Landing Slot at Heathrow 88 Don’t Try to Improve a Da Vinci, Unless You Are a Rembrandt 89 Bespoke Only When You’re Bespoken to 92 Chapter 4 Obsessive Outsourcing Compulsion 95 Outsourcing an Empire 97 Strains of Outsourcing Compulsion 101 Madness with Metrics 102 Giving the Fox the Keys to the Chicken Coop … 103 The Nineteenth Hole Contract 105 Dedicated Followers of Fashion 106 Finance is not about Engineering Anything 108 Contract Accounting and Runaway Trains 110 Faster than a Speeding Bullet … 113 The Capability Argument 113 The Economic Argument 114 Better Out than In? 115 Protecting the Crown Jewels 117 Everyone Needs to Win 121 In Summary 124 Chapter 5 Chronic Consultancy Syndrome 125 Consultants—The Hummingbirds of the IT Jungle 126 Survival of the Sharpest 128 Spotting Hummingbirds in the Wild 129 An Expensive Dose of Aviary Assistance 130 Predator or Prey? 131 What Consulting Isn’t …? 132 It Was Their Fault! 133 The Magic of a Name 134 The Consultant’s Crutch 135 But What Consulting Perhaps Should Be? 135 Forests, Trees and Spectacles 137 You Are not Alone on Planet Earth 139 Nothing New Under the Sun 141 Hummingbirds Flap Harder than Cash Cows 142 How Hummingbirds Turn into Cuckoos 143 Answer 1—The Cuckoo Consultancy End‐Game Solution 147 Answer 2—The Thin‐Edge‐Wedge‐End‐Game Cash Cow 147 And Finally 148 Chapter 6 Strategy Schizophrenia 151 A Beginner’s Guide to World Domination 152 Types of Strategy 154 The Better Tomorrow 154 The Grand Plan 158 Strategy Schizophrenia—Balancing the Unbalanceable 161 Summary 164 Chapter 7 Bleeding Budgets 167 A Beginner’s Guide to Building a Roulette Table 168 How Much Are You Going to Spend? 168 How Much Goodness? 170 Which Investments? 174 But What about Tomorrow? 177 Putting Today and Tomorrow’s Investments Together 180 Putting the Final Touches to the Roulette Table 181 Placing the Chips 182 Our Transformation Journey 184 Other Funding Profile Examples 186 Funding Choice 1—The Support Organisation 186 Funding Choice 2—The “Go for it” Organisation 187 Summary 188 Chapter 8 Epilogue—What Might Overcome You? 191 It’s Always the Same Culprits, Except When it Isn’t 191 Failure and Folklore 194 IT Leadership Morbidity Tables 195 First Tier—Dislocated Stakeholders 195 Second Tier—Money and Strategy 197 Third Tier—Projects and Software 198 Fourth Tier—Outsourcing 199 Fifth Tier—Consultancy 199 The Unknown Unknowns 200 Acknowledgements 203 Bibliography 207 Index 211
£28.49
John Wiley & Sons Inc Excel VBA 24Hour Trainer
Book SynopsisMaster VBA automation quickly and easily to get more out of Excel Excel VBA 24-Hour Trainer, 2nd Edition is the quick-start guide to getting more out of Excel, using Visual Basic for Applications. This unique book/video package has been updated with fifteen new advanced video lessons, providing a total of eleven hours of video training and 45 total lessons to teach you the basics and beyond. This self-paced tutorial explains Excel VBA from the ground up, demonstrating with each advancing lesson how you can increase your productivity. Clear, concise, step-by-step instructions are combined with illustrations, code examples, and downloadable workbooks to give you a practical, in-depth learning experience and results that apply to real-world scenarios. This is your comprehensive guide to becoming a true Excel power user, with multimedia instruction and plenty of hands-on practice. Program Excel''s newest chart and pivot table object modelsTable of ContentsIntroduction xxvii Part I: Understanding the Basics Lesson 1: Introducing VBA 3 What is VBA? 3 A Brief History of VBA 4 What VBA Can Do for You 5 Automating a Recurring Task 5 Automating a Repetitive Task 5 Running a Macro Automatically if Another Action Takes Place 5 Creating Your Own Worksheet Functions 7 Simplifying the Workbook’s Look and Feel for Other Users 7 Controlling Other Office Applications from Excel 7 Liabilities of VBA 8 Try It 9 Lesson 2: Getting Started with Macros 11 Composing Your First Macro 11 Accessing the VBA Environment 11 Using the Macro Recorder 16 Running a Macro 21 The Macro Dialog Box 21 Shortcut Key 22 Try It 22 Lesson Requirements 22 Hints 22 Step-by-Step 23 Lesson 3: Introducing the Visual Basic Editor 25 What is the VBE? 25 How to Get Into the VBE 25 Understanding the VBE 26 Understanding Modules 28 Using the Object Browser 28 Exiting the VBE 30 Try It 30 Lesson 4: Working in the VBE 33 Toolbars in the VBE 33 Macros and Modules 33 Locating Your Macros 33 Understanding the Code 36 Editing a Macro with Comments and Improvements to the Code 37 Deleting a Macro 39 Inserting a Module 39 Renaming a Module 41 Deleting a Module 42 Locking and Protecting the VBE 43 Try It 44 Lesson Requirements 44 Hints 44 Step-by-Step 45 Part II: Diving Deeper into VBA Lesson 5: Object-Oriented Programming: An Overview 49 What “Object-Oriented Programming” Means 49 The Object Model 50 Properties 51 Methods 51 Collections 52 Try It 53 Lesson 6: Variables, Data Types, and Constants 55 What is a Variable? 55 Assigning Values to Variables 56 Why You Need Variables 56 Data Types 57 Understanding the Different Data Types 57 Declaring a Variable for Dates and Times 58 Declaring a Variable with the Proper Data Type 59 Forcing Variable Declaration 59 Understanding a Variable’s Scope 61 Local Macro Level Only 62 Module Level 62 Application Level 63 Constants 63 Try It 64 Lesson Requirements 64 Step-by-Step 64 Lesson 7: Understanding Objects and Collections 67 Workbooks 67 Cells and Ranges 69 SpecialCells 70 Try It 71 Lesson Requirements 71 Step-by-Step 71 Lesson 8: Working with Ranges 75 Working with Contiguously Populated Ranges 75 Using the Cells Property 76 Using CurrentRegion 76 Working with Noncontiguously Populated Ranges 77 Using Range with Several Cells 77 Using OFFSET 78 Using RESIZE 78 Identifying a Data Range 79 Identifying the UsedRange 79 Finding the Dynamic Last Rows and Columns 80 Identifying Where the Range Starts and Ends When No Start or End Point is Known 81 Try It 82 Lesson Requirements 82 Hints 82 Step-by-Step 82 Lesson 9: Making Decisions with VBA 85 Understanding Logical Operators 85 AND 86 OR 86 NOT 87 Choosing Between This or That 88 If…Then 88 If…Then…Else 89 If…Then…ElseIf 90 IIF 90 Select Case 91 Getting Users to Make Decisions 92 Message Boxes 93 Input Boxes 94 Try It 94 Lesson Requirements 95 Hints 95 Step-by-Step 95 Part III: Beyond the Macro Recorder: Writing Your Own Code Lesson 10: Repeating Actions with Loops 101 What is a Loop? 101 Types of Loops 102 Do…While 106 Do…Until 107 Do…Loop While 109 Do…Loop Until 109 While…Wend 110 Nesting Loops 110 Try It 111 Lesson Requirements 111 Hints 111 Step-by-Step 111 Lesson 11: Programming Formulas 113 Understanding A1 and R1C1 References 113 Getting Started with a Few One-Liners 114 Comparing the Interface of A1 and R1C1 Styles 115 Toggling between A1 and R1C1 Style Views 116 Programming Your Formula Solutions with VBA 118 Using a Mixed Reference to Fill Empty Cells with the Value from Above 118 Using a Named Range with Relative, Mixed, and Absolute References 119 Programming an Array Formula 120 Summing Lists of Different Sizes along a Single Row 122 Try It 124 Lesson Requirements 124 Step-by-Step 125 Lesson 12: Working with Arrays 127 What is an Array? 127 What Arrays Can Do for You 128 Declaring Arrays 129 The Option Base Statement 130 Boundaries in Arrays 132 Declaring Arrays with Fixed Elements 132 Declaring Dynamic Arrays with ReDim and Preserve 133 Try It 134 Lesson Requirements 134 Step-by-Step 135 Lesson 13: Automating Procedures with Worksheet Events 137 What is an Event? 137 Worksheet Events: An Overview 138 Where Does the Worksheet Event Code Go? 138 Enabling and Disabling Events 140 Examples of Common Worksheet Events 141 Worksheet_Change Event 141 Worksheet_SelectionChange Event 141 Worksheet_BeforeDoubleClick Event 142 Worksheet_Before RightClick Event 142 Worksheet_FollowHyperlink Event 142 Worksheet_Activate Event 143 Worksheet_Deactivate Event 144 Worksheet_Calculate Event 144 Worksheet_PivotTableUpdate Event 144 Try It 144 Lesson Requirements 145 Step-by-Step 145 Lesson 14: Automating Procedures with Workbook Events 149 Workbook Events: An Overview 149 Where Does the Workbook Event Code Go? 149 Entering Workbook Event Code 151 Examples of Common Workbook Events 153 Workbook_Open Event 153 Workbook_BeforeClose Event 154 Workbook_Activate Event 154 Workbook_Deactivate Event 154 Workbook_SheetChange Event 154 Workbook_SheetSelectionChange Event 155 Workbook_SheetBeforeDoubleClick Event 155 Workbook_SheetBeforeRightClick Event 156 Workbook_SheetPivotTableUpdate Event 156 Workbook_NewSheet Event 156 Workbook_BeforePrint Event 157 Workbook_SheetActivate Event 157 Workbook_SheetDeactivate Event 157 Workbook_BeforeSave Event 158 Try It 158 Lesson Requirements 158 Step-by-Step 158 Lesson 15: Handling Duplicate Items and Records 161 Deleting Rows Containing Duplicate Entries 161 Deleting Rows with Duplicates in a Single Column 161 Deleting Rows with Duplicates in More Than One Column 164 Deleting Some Duplicates and Keeping Others 165 Working with Duplicate Data 167 Compiling a Unique List from Multiple Columns 167 Updating a Comment to List Unique Items 169 Selecting a Range of Duplicate Items 171 Inserting an Empty Row at Each Change in Items 172 Try It 173 Lesson Requirements 174 Hints 174 Step-by-Step 174 Lesson 16: Using Embedded Controls 181 Working with Form Controls and ActiveX Controls 181 The Forms Toolbar 182 Buttons 183 Using Application.Caller with Form Controls 184 The Control Toolbox 186 CommandButtons 187 Try It 191 Lesson Requirements 192 Step-by-Step 192 Lesson 17: Programming Charts 199 Adding a Chart to a Chart Sheet 200 Adding an Embedded Chart to a Worksheet 202 Moving a Chart 204 Looping Through All Embedded Charts 206 Deleting Charts 207 Renaming a Chart 208 Try It 208 Lesson Requirements 208 Step-by-Step 209 Lesson 18: Programming Pivottables and Pivotcharts 213 Creating a PivotTable Report 213 Hiding the PivotTable Field List 217 Formatting Numbers in the Values Area 219 Pivoting Your Data 222 Creating a PivotChart 223 Understanding PivotCaches 226 Manipulating PivotFields in VBA 230 Manipulating PivotItems with VBA 231 Creating a PivotTables Collection 231 Try It 232 Lesson Requirements 232 Step-by-Step 233 Lesson 19: User-Defined Functions 237 What is a User-Defined Function? 237 Characteristics of User-Defined Functions 237 Anatomy of a UDF 238 UDF Examples That Solve Common Tasks 239 Summing Numbers in Colored Cells 239 Extracting Numbers or Letters from an Alphanumeric String 241 Extracting the Address from a Hyperlink 242 Volatile Functions 243 Returning the Name of the Active Worksheet and Workbook 243 UDFs with Conditional Formatting 244 Calling Your UDF from a Macro 245 Adding a Description to the Insert Function Dialog Box 246 Try It 248 Lesson Requirements 248 Step-by-Step 249 Lesson 20: Debugging Your Code 251 What is Debugging? 251 What Causes Errors? 252 Weapons of Mass Debugging 254 The Debug Toolbar 254 Trapping Errors 264 Error Handler 264 Bypassing Errors 265 Try It 266 Lesson Requirements 267 Hints 267 Step-by-Step 267 Part IV: Advanced Programming Techniques Lesson 21: Creating Userforms 271 What is a UserForm? 271 Creating a UserForm 272 Designing a UserForm 273 Adding Controls to a UserForm 274 Showing a UserForm 280 Where Does the UserForm’s Code Go? 281 Closing a UserForm 281 Unloading a UserForm 282 Hiding a UserForm 283 Try It 283 Lesson Requirements 283 Step-by-Step 283 Lesson 22: Userform Controls and Their Functions 285 Understanding the Frequently Used UserForm Controls 285 CommandButtons 286 Labels 287 TextBoxes 288 ListBoxes 290 ComboBoxes 292 CheckBoxes 295 OptionButtons 296 Frames 298 MultiPages 300 Try It 301 Lesson Requirements 301 Step-by-Step 301 Lesson 23: Advanced Userforms 305 The UserForm Toolbar 305 Modal versus Modeless 306 Disabling the UserForm’s Close Button 307 Maximizing Your UserForm’s Size 308 Selecting and Displaying Photographs on a UserForm 308 Unloading a UserForm Automatically 309 Pre-sorting the ListBox and ComboBox Items 310 Populating ListBoxes and ComboBoxes with Unique Items 312 Displaying a Real-Time Chart in a UserForm 314 Try It 315 Lesson Requirements 315 Step-by-Step 315 Lesson 24: Class Modules 321 What is a Class? 321 What is a Class Module? 322 Creating Your Own Objects 323 An Important Benefit of Class Modules 323 Creating Collections 326 Class Modules for Embedded Objects 326 Try It 330 Lesson Requirements 330 Step-by-Step 330 Lesson 25: Add-Ins 335 What is an Excel Add-In? 335 Creating an Add-In 336 Converting a File to an Add-In 341 Installing an Add-In 342 Creating a User Interface for Your Add-In 346 Changing the Add-In’s Code 348 Closing Add-Ins 349 Removing an Add-In from the Add-Ins List 349 Try It 350 Lesson Requirements 350 Step-by-Step 350 Lesson 26: Managing External Data 353 Creating QueryTables from Web Queries 353 Creating a QueryTable for Access 356 Using Text Files to Store External Data 359 Try It 361 Lesson Requirements 362 Step-by-Step 362 Lesson 27: Data Access with Activex Data Objects 365 Introducing ADO 365 The Connection Object 367 The Recordset Object 367 The Command Object 368 An Introduction to Structured Query Language (SQL) 368 The SELECT Statement 369 The INSERT Statement 369 The UPDATE Statement 370 The DELETE Statement 370 Try It 371 Lesson 28: Impressing Your Boss (or at Least Your Friends) 373 Selecting Cells and Ranges 373 Coloring the Active Cell, Row, or Column 373 Coloring the Current and Prior Selected Cells 375 Filtering Dates 376 Filtering between Dates 376 Filtering for Dates before Today’s Date 378 Filtering for Dates after Today’s Date 378 Deleting Rows for Filtered Dates More Than Three Years Ago 378 Setting Page Breaks for Specified Areas 379 Using a Comment to Log Changes in a Cell 380 Using the Windows API with VBA 381 Clearing the Clipboard 381 Emptying the Recycle Bin 382 Scheduling Your Workbook for Suicide 382 Try It 382 Lesson Requirements 383 Hints 383 Step-by-Step 383 Part V: Interacting with Other Office Applications Lesson 29: Overview of Office Automation from Excel 391 Why Automate Another Application? 391 Understanding Office Automation 392 Early Binding 392 Late Binding 394 Which One is Better? 394 Try It 395 Lesson Requirements 395 Hints 395 Step-by-Step 395 Lesson 30: Working with Word From Excel 399 Activating a Word Document 399 Activating the Word Application 399 Opening and Activating a Word Document 400 Creating a New Word Document 402 Copying an Excel Range to a Word Document 402 Printing a Word Document from Excel 403 Importing a Word Document to Excel 404 Try It 405 Lesson Requirements 406 Step-by-Step 406 Lesson 31: Working with Outlook From Excel 409 Opening Outlook 409 Composing an E-mail in Outlook from Excel 410 Creating a MailItem Object 410 Transferring an Excel Range to the Body of Your E-mail 411 Putting It All Together 413 E-mailing a Single Worksheet 415 Try It 415 Lesson Requirements 415 Step-by-Step 415 Lesson 32: Working with Access from Excel 419 Adding a Record to an Access Table 419 Exporting an Access Table to an Excel Spreadsheet 423 Creating a New Table in Access 426 Try It 427 Lesson Requirements 427 Step-by-Step 427 Lesson 33: Working with Powerpoint From Excel 431 Creating a New PowerPoint Presentation 431 Copying a Worksheet Range to a PowerPoint Slide 432 Copying Chart Sheets to PowerPoint Slides 433 Running a PowerPoint Presentation from Excel 435 Try It 436 Lesson Requirements 436 Step-by-Step 436 Index 441
£27.75
John Wiley & Sons Inc Data Mining and Learning Analytics
Book SynopsisAddresses the impacts of data mining on education and reviews applications in educational research teaching, and learning This book discusses the insights, challenges, issues, expectations, and practical implementation of data mining (DM) within educational mandates. Initial series of chapters offer a general overview of DM, Learning Analytics (LA), and data collection models in the context of educational research, while also defining and discussing data mining's four guiding principles prediction, clustering, rule association, and outlier detection. The next series of chapters showcase the pedagogical applications of Educational Data Mining (EDM) and feature case studies drawn from Business, Humanities, Health Sciences, Linguistics, and Physical Sciences education that serve to highlight the successes and some of the limitations of data mining research applications in educational settings. The remaining chapters focus exclusively on EDM's emerging role in helping to aTable of ContentsNotes on Contributors xi Introduction: Education At Computational Crossroads xxiiiSamira ElAtia, Donald Ipperciel, and Osmar R. Zaïane Part I At The Intersection of Two Fields: EDM 1 Chapter 1 Educational Process Mining: A Tutorial and Case Study Using Moodle Data Sets 3Cristóbal Romero, Rebeca Cerezo, Alejandro Bogarín, and Miguel Sanchez‐Santillán 1.1 Background 5 1.2 Data Description and Preparation 7 1.2.1 Preprocessing Log Data 7 1.2.2 Clustering Approach for Grouping Log Data 11 1.3 Working with ProM 16 1.3.1 Discovered Models 19 1.3.2 Analysis of the Models’ Performance 23 1.4 Conclusion 26 Acknowledgments 27 References 27 Chapter 2 On Big Data And Text Mining in the Humanities29Geoffrey Rockwell and Bettina Berendt 2.1 Busa and the Digital Text 30 2.2 Thesaurus Linguae Graecae and the Ibycus Computer as Infrastructure 32 2.2.1 Complete Data Sets 33 2.3 Cooking with Statistics 35 2.4 Conclusions 37 References 38 Chapter 3 Finding Predictors in Higher Education41David Eubanks, William Evers Jr., and Nancy Smith 3.1 Contrasting Traditional and Computational Methods 42 3.2 Predictors and Data Exploration 45 3.3 Data Mining Application: An Example 50 3.4 Conclusions 52 References 53 Chapter 4 Educational Data Mining: A MOOC Experience55Ryan S. Baker, Yuan Wang, Luc Paquette, Vincent Aleven, Octav Popescu, Jonathan Sewall, Carolyn Rosé, Gaurav Singh Tomar, Oliver Ferschke, Jing Zhang, Michael J. Cennamo, Stephanie Ogden, Therese Condit, José Diaz, Scott Crossley, Danielle S. McNamara, Denise K. Comer, Collin F. Lynch, Rebecca Brown, Tiffany Barnes, and Yoav Bergner 4.1 Big Data in Education: The Course 55 4.1.1 Iteration 1: Coursera 55 4.1.2 Iteration 2: edX 56 4.2 Cognitive Tutor Authoring Tools 57 4.3 Bazaar 58 4.4 Walkthrough 58 4.4.1 Course Content 58 4.4.2 Research on BDEMOOC 61 4.5 Conclusion 65 Acknowledgments 65 References 65 Chapter 5 Data Mining and Action Research 67Ellina Chernobilsky, Edith Ries, and Joanne Jasmine 5.1 Process 69 5.2 Design Methodology 71 5.3 Analysis and Interpretation of Data 72 5.3.1 Quantitative Data Analysis and Interpretation 73 5.3.2 Qualitative Data Analysis and Interpretation 74 5.4 Challenges 75 5.5 Ethics 76 5.6 Role of Administration in the Data Collection Process 76 5.7 Conclusion 77 References 77 Part II Pedagogical Applications of EDM79 Chapter 6 Design of an Adaptive Learning System and Educational Data Mining81Zhiyong Liu and Nick Cercone 6.1 Dimensionalities of the User Model in ALS 83 6.2 Collecting Data for ALS 85 6.3 Data Mining in ALS 86 6.3.1 Data Mining for User Modeling 87 6.3.2 Data Mining for Knowledge Discovery 88 6.4 ALS Model and Function Analyzing 90 6.4.1 Introduction of Module Functions 90 6.4.2 Analyzing the Workflow 93 6.5 Future Works 94 6.6 Conclusions 94 Acknowledgment 95 References 95 Chapter 7 The “Geometry” of Naive Bayes: Teaching Probabilities by “Drawing” Them99Giorgio Maria Di Nunzio 7.1 Introduction 99 7.1.1 Main Contribution 100 7.1.2 Related Works 101 7.2 The Geometry of NB Classification 102 7.2.1 Mathematical Notation 102 7.2.2 Bayesian Decision Theory 103 7.3 Two-Dimensional Probabilities 105 7.3.1 Working with Likelihoods and Priors Only 107 7.3.2 De‐normalizing Probabilities 108 7.3.3 NB Approach 109 7.3.4 Bernoulli Naïve Bayes 110 7.4 A New Decision Line: Far from the Origin 111 7.4.1 De‐normalization Makes (Some) Problems Linearly Separable 112 7.5 Likelihood Spaces, When Logarithms make a Difference (or a SUM) 114 7.5.1 De‐normalization Makes (Some) Problems Linearly Separable 115 7.5.2 A New Decision in Likelihood Spaces 116 7.5.3 A Real Case Scenario: Text Categorization 117 7.6 Final Remarks 118 References 119 Chapter 8 Examining the Learning Networks of a MOOC121Meaghan Brugha and Jean‐Paul Restoule 8.1 Review of Literature 122 8.2 Course Context 124 8.3 Results and Discussion 125 8.4 Recommendations for Future Research 133 8.5 Conclusions 134 References 135 Chapter 9 Exploring the Usefulness of Adaptive ELearning Laboratory Environments in Teaching Medical Science139Thuan Thai and Patsie Polly 9.1 Introduction 139 9.2 Software for Learning and Teaching 141 9.2.1 Reflective Practice: ePortfolio 141 9.2.2 Online Quizzes 143 9.2.3 Online Practical Lessons 144 9.2.4 Virtual Laboratories 145 9.2.5 The Gene Suite 147 9.3 Potential Limitations 152 9.4 Conclusion 153 Acknowledgments 153 References 154 Chapter 10 Investigating Co‐Occurrence Patterns of Learners’ Grammatical Errors across Proficiency Levels and Essay Topics Based on Association Analysis 157Yutaka Ishii 10.1 Introduction 157 10.1.1 The Relationship between Data Mining and Educational Research 157 10.1.2 English Writing Instruction in the Japanese Context 158 10.2 Literature Review 159 10.3 Method 160 10.3.1 Konan‐JIEM Learner Corpus 160 10.3.2 Association Analysis 162 10.4 Experiment 1 162 10.5 Experiment 2 163 10.6 Discussion and Conclusion 164 Appendix A: Example of Learner’s Essay (University Life) 164 Appendix B: Support Values of all Topics 165 Appendix C: Support Values of Advanced, Intermediate, and Beginner Levels of Learners 168 References 169 Part III EDM and Educational Research 173 Chapter 11 Mining Learning Sequences in MOOCs: Does Course Design Constrain Students’ Behaviors Or Do Students Shape Their Own Learning? 175Lorenzo Vigentini, Simon McIntyre, Negin Mirriahi, and Dennis Alonzo 11.1 Introduction 175 11.1.1 Perceptions and Challenges of MOOC Design 176 11.1.2 What Do We Know About Participants’ Navigation: Choice and Control 177 11.2 Data Mining in MOOCs: Related Work 178 11.2.1 Setting the Hypotheses 179 11.3 The Design and Intent of the LTTO MOOC 180 11.3.1 Course Grading and Certification 183 11.3.2 Delivering the Course 183 11.3.3 Operationalize Engagement, Personal Success, and Course Success in LTTO 184 11.4 Data Analysis 184 11.4.1 Approaches to Process the Data Sources 185 11.4.2 LTTO in Numbers 186 11.4.3 Characterizing Patterns of Completion and Achievement 186 11.4.4 Redefining Participation and Engagement 189 11.5 Mining Behaviors and Intents 191 11.5.1 Participants’ Intent and Behaviors: A Classification Model 191 11.5.2 Natural Clustering Based on Behaviors 194 11.5.3 Stated Intents and Behaviors: Are They Related? 198 11.6 Closing the Loop: Informing Pedagogy and Course Enhancement 198 11.6.1 Conclusions, Lessons Learnt, and Future Directions 200 References 201 Chapter 12 Understanding Communication Patterns in MOOCs: Combining Data Mining and Qualitative Methods 207Rebecca Eynon, Isis Hjorth, Taha Yasseri, and Nabeel Gillani 12.1 Introduction 207 12.2 Methodological Approaches to Understanding Communication Patterns in MOOCs 209 12.3 Description 210 12.3.1 Structural Connections 211 12.4 Examining Dialogue 213 12.5 Interpretative Models 214 12.6 Understanding Experience 215 12.7 Experimentation 216 12.8 Future Research 217 References 218 Chapter 13 An Example of Data Mining: Exploring The Relationship Between Applicant Attributes and Academic Measures of Success in a Pharmacy Program 223Dion Brocks and Ken Cor 13.1 Introduction 223 13.2 Methods 225 13.3 Results 228 13.4 Discussion 230 13.4.1 Prerequisite Predictors 230 13.4.2 Demographic Predictors 232 13.5 Conclusion 234 Appendix A 234 References 236 Chapter 14 A New Way of Seeing: Using a Data Mining Approach to Understand Children’s Views of Diversity and “Difference” in Picture Books237Robin A. Moeller and Hsin‐liang Chen 14.1 Introduction 237 14.2 Study 1: Using Data Mining to Better Understand Perceptions of Race 238 14.2.1 Background 238 14.2.2 Research Questions 239 14.2.3 Methods 240 14.2.4 Findings 240 14.2.5 Discussion 248 14.3 Study 2: Translating Data Mining Results to Picture Book Concepts of “Difference” 248 14.3.1 Background 248 14.3.2 Research Questions 249 14.3.3 Methodology 250 14.3.4 Findings 250 14.3.5 Discussion and Implications 252 14.4 Conclusions 252 References 252 Chapter 15 Data Mining with Natural Language Processing and Corpus Linguistics: Unlocking Access to School Children’s Language in Diverse Contexts to Improve Instructional and Assessment Practices255Alison L. Bailey, Anne Blackstock‐Bernstein, Eve Ryan, and Despina Pitsoulakis 15.1 Introduction 255 15.2 Identifying the Problem 256 15.3 Use of Corpora and Technology in Language Instruction and Assessment 261 15.3.1 Language Corpora in ESL and EFL Teaching and Learning 261 15.3.2 Previous Extensions of Corpus Linguistics to School‐Age Language 262 15.3.3 Corpus Linguistics in Language Assessment 263 15.3.4 Big Data Purposes, Techniques, and Technology 264 15.4 Creating a School‐Age Learner Corpus and Digital Data Analytics System 266 15.4.1 Language Measures Included in DRGON 267 15.4.2 The DLLP as a Promising Practice 268 15.5 Next Steps, “Modest Data,” and Closing Remarks 269 Acknowledgments 271 Appendix A: Examples of Oral and Written Explanation Elicitation Prompts 272 References 272 Index 277
£98.06
John Wiley & Sons Inc AutoCAD Civil 3D 2016 Essentials
Book SynopsisStart designing today with this hands-on beginner's guide to AutoCAD Civil 3D 2016 AutoCAD Civil 3D 2016 Essentials gets you quickly up to speed with the features and functions of this industry-leading civil engineering software.Table of ContentsIntroduction xii Chapter 1 Navigating the User Interface 1 Getting to Know the Civil 3D User Interface 2 Working with the Application Menu 3 Working with the Ribbon 5 Working with the Toolspace 8 Using the Drawing Area 11 Using the Command Line 12 Using Panorama 12 Using the Transparent Commands Toolbar 13 Using the Inquiry Tool 14 Chapter 2 Leveraging a Dynamic Environment 17 Connecting Objects and Styles 18 Connecting Labels and Label Styles 23 Connecting Objects to Objects 27 Connecting Objects to Labels 29 Appreciating the Richness of the 3-D Model 31 Sharing Data in a Dynamic Environment 33 Chapter 3 Establishing Existing Conditions Using Survey Data 37 What Is Survey Data? 38 Creating a Survey Database 39 Importing Survey Data 41 Automating Field-to-Finish 45 Editing Survey Points 57 Editing Survey Figures 59 Creating Additional Points 61 Chapter 4 Modeling the Existing Terrain Using Surfaces 65 Understanding Surfaces 66 Creating a Surface from Survey Data 67 Using Breaklines to Improve Surface Accuracy 71 Editing Surfaces 77 Displaying and Analyzing Surfaces 82 Annotating Surfaces 87 Chapter 5 Designing in 2-D Using Alignments 91 Understanding Alignments 92 Creating Alignments from Objects 92 Creating Alignments Using the Alignment Creation Tools 95 Editing Alignments 99 Applying Design Criteria Files and Check Sets 107 Chapter 6 Displaying and Annotating Alignments 113 Using Alignment Styles 114 Applying Alignment Labels and Label Sets 116 Creating Station/Offset Labels 121 Creating Segment Labels 123 Using Tag Labels and Tables 126 Chapter 7 Designing Vertically Using Profiles 131 Creating Surface Profiles 132 Displaying Profiles in Profile Views 133 Creating Design Profiles 134 Editing Profiles 136 Using Design Check Sets and Criteria Files 144 Chapter 8 Displaying and Annotating Profiles 149 Applying Profile Styles 150 Applying Profile View Styles 152 Applying Profile View Bands 154 Applying Profile Labels 157 Creating and Applying Profile Label Sets 159 Creating Profile View Labels 160 Projecting Objects to Profile Views 164 Chapter 9 Designing in 3D Using Corridors 169 Understanding Corridors 170 Creating an Assembly 173 Creating a Corridor 175 Applying Corridor Targets 176 Creating Corridor Surfaces 185 Chapter 10 Creating Cross Sections of the Design 191 Using the Section Editor 192 Creating Sample Lines 195 Creating Section Views 198 Sampling More Sources 202 Chapter 11 Displaying and Annotating Sections 207 Applying Section Styles 208 Applying Section Labels 210 Controlling Corridor Section Display with Code Set Styles 213 Applying Labels with Code Set Styles 215 Applying Section View Styles 217 Applying Section View Bands 220 Applying Group Plot Styles 223 Creating Section View Labels 225 Chapter 12 Designing and Analyzing Boundaries Using Parcels 229 Understanding Parcels 230 Creating Parcels from Objects 232 Creating Parcels by Layout 235 Editing Parcels 246 Chapter 13 Displaying and Annotating Parcels 253 Applying Parcel Styles 254 Applying Parcel Area Labels 258 Creating Parcel Segment Labels 261 Editing Parcel Segment Labels 264 Creating Parcel Tables 267 Chapter 14 Designing Gravity Pipe Networks 273 Understanding Gravity Pipe Networks 273 Creating Gravity Pipe Networks 277 Editing Gravity Pipe Networks 285 Chapter 15 Designing Pressure Pipe Networks 297 Understanding Pressure Pipe Networks 297 Creating Pressure Pipe Networks 300 Editing Pressure Pipe Networks 305 Chapter 16 Displaying and Annotating Pipe Networks 317 Displaying Pipe Networks Using Styles 318 Annotating Pipe Networks in Plan View 325 Annotating Pipe Networks in Profile View 331 Creating Pipe Network Tables 335 Chapter 17 Designing New Terrain 339 Understanding Grading 340 Understanding Feature Lines 341 Creating Feature Lines 342 Editing Feature Lines 344 Understanding Grading Objects 352 Creating Grading Objects 355 Editing Grading Objects 358 Chapter 18 Analyzing, Displaying, and Annotating Surfaces 361 Combining Design Surfaces 362 Analyzing Design Surfaces 368 Calculating Earthwork Volumes 376 Labeling Design Surfaces 380 Appendix AutoCAD Civil 3D 2016 Certification 385 Index 389
£30.39
John Wiley & Sons Inc Mastering Autodesk Inventor 2016 and Autodesk
Book SynopsisYour real-world introduction to mechanical design with Autodesk Inventor 2016 Mastering Autodesk Inventor 2016 and Autodesk Inventor LT 2016is a complete real-world reference and tutorial for those learning this mechanical design software. With straightforward explanations and practical tutorials, this guide brings you up to speed with Inventor in the context of real-world workflows and environments. You''ll begin designing right away as you become acquainted with the interface and conventions, and then move into more complex projects as you learn sketching, modeling, assemblies, weldment design, functional design, documentation, visualization, simulation and analysis, and much more. Detailed discussions are reinforced with step-by-step tutorials, and the companion website provides downloadable project files that allow you to compare your work to the pros. Whether you''re teaching yourself, teaching a class, or preparing for the Inventor certification exam, this is theTable of ContentsIntroduction xxvii Chapter 1 • Getting Started 1 Understanding Parametric Design 1 Creating a Base Sketch 1 Creating a Base Feature 2 Adding More Features 3 Using the Part in an Assembly 3 Making Changes 4 Understanding History-Based Modeling and Dependencies 4 Taking a Closer Look at Sketch Dimensions 5 Following Part Modeling Best Practices 7 Following Assembly Modeling Best Practices 8 Understanding the “Feel” of Inventor 10 Understanding the Intuitive Interface 10 Using General Tools vsSpecifi c Commands 12 When in Doubt, Right-Click 12 Using the Graphical Interface 13 Inventor Title Bar 14 Graphics Window Tools 15 The Ribbon Menu 17 The Browser Pane/Model Browser 19 Dialog Boxes and the In-Canvas Mini-Toolbars 19 Task-Based Tools 20 Learning the File Types in Inventor 20 What Is an Inventor Project? 22 Project Files and Search Paths 22 Library Folders and Library Editor IPJ Files 25 Content Center Files 26 How Search Paths and Project Files Are Used 26 Exploring Project File Types 27 Creating a Project File 29 Creating Single-User Projects 29 Creating Multiuser Projects 38 Understanding Inventor Templates39 Working with Styles, Style Libraries, and Company Standards 40 The Bottom Line 40 Chapter 2 • A Hands-on Test-Drive of the Workflow 43 Creating a Part Model 43 Starting with a Part Template 45 Understanding Origin Geometry 45 Creating a Base 2D Sketch 46 Creating a Profi le in the Sketch 48 Creating a Base 3D Feature 48 Creating a Secondary 2D Sketch 49 Creating a Secondary 3D Feature 51 Patterning a 3D Feature 52 Creating and Detailing Drawings of Part Models 53 Creating a Base View on a Drawing 53 Creating Projected Views on a Drawing 55 Creating Dimensions on a Drawing 55 Putting Part Models Together in Assembly Files 56 Placing, Rotating, and Moving Parts in an Assembly File 57 Working with Degrees of Freedom in an Assembly 58 Placing Assembly Constraints to Defi ne Mechanical Movement 60 Creating and Detailing Drawings of Assembly Models 63 Creating an Assembly Detail View 63 Placing a Parts List and Balloons 65 Exporting a Drawing to a PDF File 66 The Bottom Line 66 Chapter 3 • Sketch Techniques 69 Exploring the Options and Settings for Sketches 69 Application Options 70 Document Settings 75 Sketching Basics 75 Creating a Sketch on an Existing Sketch 76 Projecting Geometry into Your Sketch 77 Breaking Links to Projected Geometry 79 Deleting a Sketch 80 Creating Another New Sketch 80 Creating Dimensions 81 Creating a Sketch in a New Part 82 Creating a New Part File from a Template 82 Creating Lines Using the Line Tool 84 Understanding Sketch Constraints 86 Using Degrees of Freedom to View Underconstrained Sketch Elements 88 Using Dimensions to Fully Constrain a Sketch 89 Understanding the Save Options 92 Making a Sketch Active for Edits 93 Using Construction Geometry 93 Using the Polygon Tool and Creating an Aligned Dimension 95 Using Offset and Creating a Three-Point Rectangle 97 Creating Driven Dimensions 99 Taking a Closer Look at Sketch Constraints 102 The Tangent Constraint 103 The Perpendicular Constraint 103 The Parallel Constraint 104 The Coincident Constraint 105 The Concentric Constraint 105 The Collinear Constraint 106 The Horizontal Constraint 106 The Vertical Constraint 107 The Equal Constraint 108 The Fix Constraint 109 The Symmetric Constraint 109 The Smooth Constraint 110 Gaining More Sketch Skills 111 Creating Arcs 111 Creating Automatic Tangents with the Line Tool 113 Understanding the Point/Center Point Tool 113 Projecting Geometry 114 Learning More about Dimensions 115 Measuring Geometry 119 Creating Sketches from AutoCAD Geometry 120 Importing Existing AutoCAD Designs 120 Copying and Pasting Existing AutoCAD Designs into Inventor 122 Creating and Using 3D Sketches 123 Creating a 3D Path 123 Using the 3D Coordinate Triad 124 Exploring More 3D Sketch Tools 127 Best Practices for Working with Sketches 132 The Bottom Line 133 Chapter 4 • Basic Modeling Techniques 135 Exploring Application Options and Settings for Part Modeling 135 Specifying Global Settings 135 Specifying Document-Specific Settings 137 Key Concepts for Creating Basic Part Features 144 Simplifying Your Sketches 147 Exploring the Extrude Tool 148 Extruding Basic Features 149 Editing an Extrusion Feature 152 Extruding with Cut and Taper 152 Extruding with Intersect 153 Extruding Surfaces from Open Profiles 155 Extruding Solids from Open Profiles 156 Extruding with To 158 Extruding with the Minimum Solution Option 160 Extruding with To Next 160 Extruding Between 161 Extruding Multi-body Solids 162 Creating Revolved Parts 164 Revolved Cylindrical Parts vsStacked Circular Extrusions 164 Creating Revolved Parts 165 Creating Work Features 167 Work Planes 168 Work Axes and Work Points 174 Creating Fillets 175 Edge Fillets 176 Face Fillets 179 Full Round Fillets 180 Working with Fillet Features 180 Creating Threaded Features 182 Creating Cosmetic Threads Using the Thread Tool 182 Using the Coil Tool to Create Physical Threads 183 Hole Features 184 Using the Thread and Clearance Spreadsheets 184 Creating Holes in Parts 186 Setting Tolerance Values in Holes 188 Bend Parts 189 Part Modeling Exercise 190 Creating a Base Feature 191 Creating a Second Feature 192 Creating a Sketch-Based Hole Feature 194 Creating a Rectangular Hole Pattern 197 Editing Sketches and Features 199 Repairing Features and Sketches 202 The Bottom Line 204 Chapter 5 • Advanced Modeling Techniques 207 Creating Complex Sweeps and Lofts 207 Creating and Using Sweeps 208 Exploring Sweep Options 210 Creating Loft Features 214 Creating a Part Using Loft and Sculpt 221 Creating Multi-body Parts 223 Creating Multiple Solids 223 Using One Solid to Shape Another 225 Creating Derived Parts and Assemblies 230 Creating Derived Parts 230 Deriving a Part File 230 Deriving an Assembly File 232 Modifying Derived Parts 233 Using the Component Derive Tool 233 Working with Patterns 233 Rectangular Patterns 233 Circular Patterns 234 Patterns Along Curves 236 The Coil Tool and Spiral Patterns 238 Pattern Solids 240 Dynamic Patterns 243 Setting iProperties and Parameters 244 iProperties 244 Part Parameters 245 Assembly Parameters 250 Adding Part Tolerances 250 Tolerances in Sketches 251 Setting Global File Tolerances 252 Working with Limits and Fits 254 Working with Free-Form Modeling and Direct Editing Tools 257 Free-Form Modeling 257 Using the Direct Edit Tool 264 Troubleshooting Failures with the End-of-Part Marker 265 Step 1: Editing the First Feature 266 Step 2: Moving the EOP Marker Down One Feature at a Time 267 The Bottom Line 268 Chapter 6 • Sheet Metal 269 Understanding Sheet-Metal Parts 269 Getting to Know the Features 270 Starting with a Base Feature 270 Creating Secondary Flange Features 276 Adding, Removing, or Deforming Material 285 Using Sheet-Metal Templates and Rules 302 What Are Sheet-Metal Rules? 302 Working with Styles and Templates 310 Working with the Flat Pattern 311 Exploring the Flat Pattern Edit Features 311 Adding Manufacturing Information to the Flat Pattern 311 Using the Flat Pattern Definition Dialog Box 313 Manufacturing Your Flat Pattern 314 Using Sheet-Metal iPart Factories 315 iParts for Confi gurations 316 iParts for Fold Progression 316 Modeling with Non-Sheet-Metal Features 317 Selecting Problematic Features 317 Using Surface-Based Workflows 317 Working with Imported Parts 318 Setting Yourself Up for Success 318 Converting Components 318 Annotating Your Sheet-Metal Design 319 Creating a View of Your Sheet-Metal Design 319 Adding Bend, Punch, and Flat Pattern Annotations 321 The Bottom Line 323 Chapter 7 • Reusing Parts and Features 325 Working with iParts 325 Creating and Modifying iParts 326 Using iParts in Designs 338 Working with iFeatures 340 Creating iFeatures 341 Creating Punch Features 345 Reusing Existing Geometry 349 Copying Features 349 Cloning 351 Linking Parameters Between Two Files 352 Copying Sketches 353 Introducing Content Center 355 Confi guring Content Center 356 Using Content Center 358 Publishing Parts to Content Center 366 The Bottom Line 369 Chapter 8 • Assembly Design Workflows 371 Assembly Relationships 372 Degrees of Freedom 372 Grounded Components 374 How the Constrain Tool Works 375 How the Joint Tool Works 376 Working with Constraints 377 Additional Constrain Tools and Options 391 Working with Joint Relationships 397 Understanding Subassemblies 408 Top-Down Design 410 Developing an Efficient Assembly Workflow 410 Layout Sketches 414 Flexibility 417 Adaptivity 417 Creating Adaptivity 418 Removing Adaptivity from Parts 420 Assembly Features 421 Managing the Bill of Materials 423 Parts-Level BOM Control 424 Assembly-Level BOM Control 424 Assembly Reuse and Configurations 431 Copying Designs 431 Using Representations 433 Using iAssemblies 443 Use Assembly Design Accelerators 447 Functional Design vsGeometric Modeling 447 Working with Design Accelerators 448 The Bottom Line 455 Chapter 9 • Large Assembly Strategies 457 Selecting a Workstation 457 Physical Memory vs Virtual Memory 458 Hardware 458 Working with Performance Settings 461 Express Mode 461 Working with Drawing Settings 461 Working with Model Display Settings 465 Working with General Settings 466 Using the Memory Probe 468 Working with System Settings 469 Large Assembly Best Practices 470 Working with the Model 470 Improving File Open Time 471 Reducing Assembly Constraints 471 Adaptivity 474 Selection Tools 475 View Representations 477 Find 477 Opening the Model 478 Working with Large Assembly Drawings 479 Managing Assembly Detail 483 LOD Strategies 483 Substitute LODs 485 Subassembly LODs 487 Simplifying Parts 489 Removing or Suppressing Unneeded Features 489 The Bottom Line 491 Chapter 10 • Weldment Design 493 Exploring Weldment Design Methodologies 493 Part Files and Part Features 494 Weldment Assembly and Derived Technology 494 Weldment Assembly 495 Multi-body Part Files 496 Modeling Preparations 497 Exploring Cosmetic Welds 499 Creating a Simple Cosmetic Weld 501 Using Split Faces to Place Cosmetic Welds 502 Placing Cosmetic Welds with Extents 502 Creating Weld Beads 503 Creating Fillet Welds 504 Modeling a Fillet Weld 505 Fillet Welds and Gaps 507 Creating Intermittent Fillet Welds 508 Creating Groove Welds 509 Performing Machining Operations 512 Exploring Weld Properties and Combinations 513 Weld Properties 513 Replication 514 Groove and Fillet Weld Combinations 514 Split Technique 515 Using the Weld Symbol 517 Understanding Bead Property Report and Mass Properties 518 Creating Drawing Documentation 519 Weldment Design Stages 521 End Fill 523 Drawing Weld Symbols 524 Caterpillar 525 Generating a Bill of Materials and Parts List 526 The Bottom Line 527 Chapter 11 • Presentations and Exploded Views 529 Getting Started 530 Working in the Presentation Environment 530 Creating an Automatically Exploded Presentation 532 Creating Tweaks Individually 535 Preparing the Exploded Presentation to Be Used in an Animation 538 Hiding Components from View During Animations 544 Rounding Up Presentation Preparation 546 Creating and Publishing Animations 546 Animation File Types and Compression Codecs 547 The Bottom Line 549 Chapter 12 • Documentation 551 Creating Drawing Views 551 Creating a Base View 552 Moving and Copying Views 556 Creating Section Views 557 Slice Views 561 Using Breakout Views 562 Using Detail Views 566 Creating Break Views 567 Cropping Views 570 Using Draft Views 570 Creating Overlay Views 570 Annotating Part Drawings 571 Using Centerline and Center Marks 571 Creating Dimensions 576 Hole and Thread Notes 588 Leadered Symbols589 Drawing Text 590 General Tables 590 Hole Tables 592 Annotating Assembly Drawings 594 Assembly Representations 595 Reference Data in Drawing Views 597 Interference and Tangent Edge Display 598 Parts Lists 599 Balloons 601 Center of Gravity Display 603 Working with Sheet-Metal Drawings 604 Flat Pattern Views 604 Bend Centerlines and Extents 605 Bend and Punch Notes 605 Bend Tables 606 Punch Tables 607 Working with Weldment Views 608 Working with iParts and iAssembly Drawings 610 Drawing Standards 611 Creating Templates and Styles 612 Understanding Template Locations 613 Choosing a File Format 614 Utilizing Drawing Resources 615 Sheet Size 615 Multiple Sheets 616 Creating a Border 616 Creating a Title Block 618 Prompted Entry 623 Sketched Symbols 625 AutoCAD Blocks 627 Sketched Symbol Libraries 627 Sheet Formats 628 Transferring Drawing Resources 629 Editing Styles and Standards 630 Object Defaults 631 Creating Styles 634 Working with Substyles 635 Drawing Style Administration 636 Sharing Your Drawings Outside Your Workgroup 636 The Bottom Line 637 Chapter 13 • Tools Overview 641 Exploring the BIM Exchange 641 Assembly Model Simplification 642 Part Model Simplification 647 Model Authoring 649 Model Publishing 650 Using AutoLimits 653 Creating AutoLimits 655 Editing AutoLimits 657 Using the Design Assistant 658 Using the Find Files Tool 660 Using the Where Used Tool 661 Renaming, Copying, and Replacing Files 663 Using Pack And Go 664 Using the Drawing Resource Transfer Wizard 667 Using the Style Library Manager 668 Using the Task Scheduler 670 Creating a Task for Migrating Files 671 Performing Sequential Tasks 673 Performing Custom Tasks 674 Tweaking Multi-Process Settings 674 Publishing DWF Files and Filenames 675 Using iProperties 675 Copying iProperties to Drawings 677 Creating Expressions with iProperties 678 Working with the Design Assistant and iProperties 679 Creating Design Property Reports 680 Using the Measure Tools 681 Using Measurement Helpers 681 Measuring in Assemblies 683 Participating in the CIP and CER R 683 Participating in the CIP 683 Participating in CER 684 Using Miscellaneous Tools 684 Using the Autodesk Multi-Sheet Plot Tool 684 Using the Add-In Manager 685 Using the Project Editor 686 The Bottom Line 686 Chapter 14 • Exchanging Data with Other Systems 687 Importing and Exporting Geometry 687 Importing vsReferencing Geometry 688 Translating DWG and DXF Files 695 Mechanical Desktop DWG 703 STEP and IGES 704 SAT 706 CATIA Import Options 706 Pro/ENGINEER Import Options 707 Unigraphics and Parasolids Import Options 707 SolidWorks Import Options 708 Rhino Import Options 708 SMT Import Options 708 JT Import Options708 STL Import Options 709 IDF Board Files 709 Working with Imported Data 711 Repair Tools 711 Edit Solid Tools 711 Viewing DWF Markup 714 Publishing a DWF or DWFx File 715 Reviewing and Marking Up DWF and DWFx Files 716 Accessing DWF or DWFx Markups in Inventor 717 The Bottom Line 718 Chapter 15 • Frame Generator 719 Accessing Frame Generator Tools 719 Exploring the Frame Generator File Structure 720 Exploring the Anatomy of a Frame Member 722 Inserting Frame Members 723 Specifying a Structural Shape 723 Changing the Orientation 724 Selecting Placement Geometry 725 Creating a Basic Frame 726 Aligning Frame Members 730 Using the Change Tool731 Adding End Treatments 732 Miter 733 Trim/Extend to Face 736 Trim to Frame Member 737 Notch Frame Members 738 Lengthen/Shorten Frame Member 739 Reuse Frame Members 739 Maintaining Frames 741 Remove End Treatments 741 Frame Member Information 741 Refresh 741 Performing Calculations and Analysis 742 The Beam and Column Calculator 742 Publishing Frame Members 751 Authoring a Part 751 Publishing a Part 754 Frame Assemblies and BOMs 755 The Bottom Line 756 Chapter 16 • Inventor Studio 757 How to Make Your Models Look Great, Live Onscreen 758 Materials and Appearances 758 Visual Styles Settings 764 Saving an Image 773 Rounding Up 773 An Introduction to Inventor Studio 774 How to Create a Still Image (Render) 776 Inventor Studio Lighting Styles 780 How to Add Local Lights 781 How to Add Cameras 784 How to Create an Animated Render 788 Animating with Inventor Studio 790 Inventor Studio Video Producer 796 Rendering Animations 797 Inventor Studio Roundup 798 The Bottom Line 799 Chapter 17 • Stress Analysis and Dynamic Simulation 801 Introducing Analysis 801 Conducting Stress Analysis Simulations 802 Simulation Guide 803 Static Stress vsModal Analysis 803 Simplifying Your Model 803 Specifying Materials 804 Applying Simulation Constraints 805 Applying Loads 806 Specifying Contact Conditions 808 Preparing Thin Bodies 810 Generating a Mesh 810 Running the Simulation 812 Interpreting the Results 813 Using the Result, Scaling, Display, and Report Tools 814 Conducting Parameter Studies 815 Conducting a Frame Analysis 819 Frame Analysis Settings 819 Frame Constraints 819 Frame Loads 820 Connections 821 Results821 Conducting Dynamic Simulations 823 Working with Joints 823 More on Working with Joints 827 Working with Redundancy 828 Working with Environmental Constraints 829 Running a Simulation 835 Exporting to FEA 838 Using the Dynamic Simulation Information in Stress Analysis 839 The Bottom Line 839 Chapter 18 • Routed Systems 841 Tube and Pipe 841 Understanding Routes, Runs, and Assembly Structure 841 Tube and Pipe Settings 843 Exploring the Tube and Pipe Styles 844 Placing Fittings 849 Creating Routes 850 Exporting ISOGEN Files 859 Cable and Harness 859 Creating and Placing Electrical Parts 860 Creating a Harness 863 Placing Wires 865 Using the Cable & Harness Library 866 Placing Cables 867 Placing and Editing Segments 868 Copying Cable and Harness Designs 871 Creating Nailboard Drawings 873 The Bottom Line 875 Chapter 19 • Plastics Design Features 877 Creating Thicken/Offset Features 878 Creating Shell Features 879 Creating Split Features 881 Creating Grill Features 882 Creating Rule Fillet Features 884 Creating Rest Features 886 Creating Boss Features 888 Creating Lip and Groove Features 891 Creating Snap-Fit Features 892 Creating Rib and Web Features 894 Creating Draft Features 896 Mold Design Overview 898 Inventor Tooling 898 Importing a Plastic Part 899 Creating Runners and Gates 902 Analyzing and Creating Cores and Cavities 904 Working with Mold Bases 907 Working with Ejectors and Sprue Bushings 909 The Bottom Line 912 Chapter 20 • iLogic 915 What Is iLogic? 915 Understanding iLogic Rules 916 What Are Functions? 916 Conditional Statements 919 Understanding the iLogic Elements and Interface 921 Exploring iLogic Parameter Types 921 Using the iLogic Browser 924 Understanding the iTrigger 930 Working with Event Triggers 930 Creating iLogic Parameters, Rules, and Forms 931 Creating iLogic Rules 931 Creating iLogic Forms 946 Working with iLogic Components 957 iLogic Design Copy 958 The Bottom Line 959 Appendix A • Th e Bottom Line 961 Chapter 1: Getting Started 961 Chapter 2: A Hands-on Test-Drive of the Workflow 963 Chapter 3: Sketch Techniques 964 Chapter 4: Basic Modeling Techniques 966 Chapter 5: Advanced Modeling Techniques 968 Chapter 6: Sheet Metal 970 Chapter 7: Reusing Parts and Features 973 Chapter 8: Assembly Design Workfl ows 974 Chapter 9: Large Assembly Strategies 977 Chapter 10: Weldment Design 978 Chapter 11: Presentations and Exploded Views 980 Chapter 12: Documentation 981 Chapter 13: Tools Overview 984 Chapter 14: Exchanging Data with Other Systems 986 Chapter 15: Frame Generator 987 Chapter 16: Inventor Studio 988 Chapter 17: Stress Analysis and Dynamic Simulation 991 Chapter 18: Routed Systems 991 Chapter 19: Plastics Design Features 992 Chapter 20: iLogic 995 Appendix B • Autodesk Inventor 2016 Certification 999 Index 1009
£61.20
John Wiley & Sons Inc Excel 2016 Formulas
Book SynopsisLeverage the full power of Excel formulas Excel 2016 Formulas is fully updated to cover all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas.Table of ContentsIntroduction xxvii Part I: Understanding Formula Basics Chapter 1: The Excel User Interface in a Nutshell 3 The Workings of Workbooks 3 Worksheets 4 Chart sheets 5 Macro sheets and dialog sheets 5 The Excel User Interface 5 The Ribbon 6 Backstage View 7 Shortcut menus and the mini toolbar 7 Dialog boxes 7 Customizing the UI 8 Task panes 9 Customizing onscreen display 9 Numeric formatting 9 Stylistic formatting 9 Protection Options 10 Securing access to the entire workbook 10 Limiting access to specific worksheet ranges 13 Protecting the workbook structure 16 Chapter 2: Basic Facts About Formulas 19 Entering and Editing Formulas 19 Formula elements 20 Entering a formula 20 Pasting names 22 Spaces and line breaks 22 Formula limits 23 Sample formulas 23 Editing formulas 24 Using Operators in Formulas 25 Reference operators 25 Sample formulas that use operators 26 Operator precedence 27 Nested parentheses 29 Calculating Formulas 30 Cell and Range References 30 Creating an absolute or a mixed reference 31 Referencing other sheets or workbooks 33 Copying or Moving Formulas 35 Making an Exact Copy of a Formula 36 Converting Formulas to Values 37 Hiding Formulas 39 Errors in Formulas 40 Dealing with Circular References 41 Goal Seeking 42 A goal seeking example 42 More about goal seeking 43 Chapter 3: Working with Names 45 What’s in a Name? 45 A Name’s Scope 46 Referencing names 47 Referencing names from another workbook 48 Conflicting names 48 The Name Manager 48 Creating names 49 Editing names 50 Deleting names 50 Shortcuts for Creating Cell and Range Names 50 The New Name dialog box 51 Creating names using the Name box 52 Creating names from text in cells 52 Naming entire rows and columns 54 Names created by Excel 55 Creating Multisheet Names 55 Working with Range and Cell Names 57 Creating a list of names 58 Using names in formulas 59 Using the intersection operators with names 59 Using the range operator with names 61 Referencing a single cell in a multicell named range 61 Applying names to existing formulas 62 Applying names automatically when creating a formula 63 Unapplying names 63 Names with errors 64 Viewing named ranges 64 Using names in charts 64 How Excel Maintains Cell and Range Names 65 Inserting a row or column 65 Deleting a row or a column 65 Cutting and pasting 65 Potential Problems with Names 66 Name problems when copying sheets 66 Name problems when deleting sheets 66 The Secret to Understanding Names 68 Naming constants 68 Naming text constants 69 Using worksheet functions in named formulas 70 Using cell and range references in named formulas 71 Using named formulas with relative references 72 Advanced Techniques That Use Names 75 Using the INDIRECT function with a named range 75 Using arrays in named formulas 77 Creating a dynamic named formula 78 Using an XLM macro in a named formula 80 Part II: Leveraging Excel Functions Chapter 4: Introducing Worksheet Functions 85 What Is a Function? 85 Simplify your formulas 86 Perform otherwise impossible calculations 86 Speed up editing tasks 86 Provide decision-making capability 87 More about functions 87 Function Argument Types 88 Names as arguments 89 Full-column or full-row as arguments 89 Literal values as arguments 90 Expressions as arguments 90 Other functions as arguments 91 Arrays as arguments 91 Ways to Enter a Function into a Formula 91 Entering a function manually 91 Using the Function Library commands 93 Using the Insert Function dialog box 94 More tips for entering functions 96 Chapter 5: Manipulating Text 99 A Few Words About Text 99 How many characters in a cell? 99 Numbers as text 99 Text Functions 101 Determining whether a cell contains text 101 Working with character codes 102 Determining whether two strings are identical 105 Joining two or more cells 105 Displaying formatted values as text 106 Displaying formatted currency values as text 108 Removing excess spaces and nonprinting characters 108 Counting characters in a string 109 Repeating a character or string 109 Creating a text histogram 110 Padding a number 111 Changing the case of text 112 Extracting characters from a string 113 Replacing text with other text 113 Finding and searching within a string 114 Searching and replacing within a string 115 Advanced Text Formulas 115 Counting specific characters in a cell 116 Counting the occurrences of a substring in a cell 116 Removing trailing minus signs 116 Expressing a number as an ordinal 117 Determining a column letter for a column number 118 Extracting a filename from a path specification 118 Extracting the first word of a string 119 Extracting the last word of a string 119 Extracting all but the first word of a string 120 Extracting first names, middle names, and last names 120 Removing titles from names 122 Counting the number of words in a cell 122 Chapter 6: Working with Dates and Times 125 How Excel Handles Dates and Times 125 Understanding date serial numbers 126 Entering dates 127 Understanding time serial numbers 129 Entering times 130 Formatting dates and times 131 Problems with dates 133 Date-Related Functions 134 Displaying the current date 135 Displaying any date with a function 136 Generating a series of dates 137 Converting a nondate string to a date 138 Calculating the number of days between two dates 139 Calculating the number of work days between two dates 139 Offsetting a date using only work days 141 Calculating the number of years between two dates 141 Calculating a person’s age 142 Determining the day of the year 143 Determining the day of the week 144 Determining the week of the year 144 Determining the date of the most recent Sunday 144 Determining the first day of the week after a date 145 Determining the nth occurrence of a day of the week in a month 145 Counting the occurrences of a day of the week 146 Expressing a date as an ordinal number 147 Calculating dates of holidays 147 Determining the last day of a month 150 Determining whether a year is a leap year 151 Determining a date’s quarter 151 Converting a year to roman numerals 151 Time-Related Functions 152 Displaying the current time 152 Displaying any time using a function 153 Calculating the difference between two times 154 Summing times that exceed 24 hours 155 Converting from military time 157 Converting decimal hours, minutes, or seconds to a time 158 Adding hours, minutes, or seconds to a time 158 Converting between time zones 159 Rounding time values 160 Calculating Durations 161 Chapter 7: Counting and Summing Techniques 163 Counting and Summing Worksheet Cells 163 Other Counting Methods 165 Basic Counting Formulas 165 Counting the total number of cells 166 Counting blank cells 166 Counting nonblank cells 167 Counting numeric cells 167 Counting text cells 168 Counting nontext cells 168 Counting logical values 168 Counting error values in a range 168 Advanced Counting Formulas 169 Counting cells with the COUNTIF function 169 Counting cells that meet multiple criteria 170 Counting the most frequently occurring entry 173 Counting the occurrences of specific text 174 Counting the number of unique values 176 Creating a frequency distribution 178 Summing Formulas 184 Summing all cells in a range 184 Summing a range that contains errors 185 Computing a cumulative sum 186 Summing the “top n” values 187 Conditional Sums Using a Single Criterion 188 Summing only negative values 189 Summing values based on a different range 190 Summing values based on a text comparison 190 Summing values based on a date comparison 190 Conditional Sums Using Multiple Criteria 191 Using And criteria 191 Using Or criteria 192 Using And and Or criteria 193 Chapter 8: Using Lookup Functions 195 What Is a Lookup Formula? 195 Functions Relevant to Lookups 196 Basic Lookup Formulas 198 The VLOOKUP function 198 The HLOOKUP function 200 The LOOKUP function 201 Combining the MATCH and INDEX functions 202 Specialized Lookup Formulas 203 Looking up an exact value 204 Looking up a value to the left 206 Performing a case-sensitive lookup 207 Choosing among multiple lookup tables 207 Determining letter grades for test scores 208 Calculating a grade point average 209 Performing a two-way lookup 211 Performing a two-column lookup 212 Determining the address of a value within a range 213 Looking up a value by using the closest match 214 Looking up a value using linear interpolation 215 Chapter 9: Working with Tables and Lists 219 Tables and Terminology 219 A list example 220 A table example 220 Working with Tables 222 Creating a table 222 Changing the look of a table 223 Navigating and selecting in a table 224 Adding new rows or columns 225 Deleting rows or columns 226 Moving a table 226 Removing duplicate rows from a table 227 Sorting and filtering a table 228 Working with the Total row 233 Using formulas within a table 235 Referencing data in a table 237 Converting a table to a list 241 Using Advanced Filtering 242 Setting up a criteria range 242 Applying an advanced filter 243 Clearing an advanced filter 245 Specifying Advanced Filter Criteria 245 Specifying a single criterion 245 Specifying multiple criteria 247 Specifying computed criteria 249 Using Database Functions 250 Inserting Subtotals 252 Chapter 10: Miscellaneous Calculations 257 Unit Conversions 257 Rounding Numbers 261 Basic rounding formulas 262 Rounding to the nearest multiple 263 Rounding currency values 263 Working with fractional dollars 264 Using the INT and TRUNC functions 265 Rounding to an even or odd integer 266 Rounding to n significant digits 267 Solving Right Triangles 267 Area, Surface, Circumference, and Volume Calculations 270 Calculating the area and perimeter of a square 270 Calculating the area and perimeter of a rectangle 270 Calculating the area and perimeter of a circle 270 Calculating the area of a trapezoid 271 Calculating the area of a triangle 271 Calculating the surface and volume of a sphere 271 Calculating the surface and volume of a cube 271 Calculating the surface and volume of a rectangular solid 272 Calculating the surface and volume of a cone 272 Calculating the volume of a cylinder 272 Calculating the volume of a pyramid 273 Solving Simultaneous Equations 273 Working with Normal Distributions 274 Part III: Financial Formulas Chapter 11: Borrowing and Investing Formulas 279 The Time Value of Money 279 Loan Calculations 280 Worksheet functions for calculating loan information 281 A loan calculation example 284 Credit card payments 285 Creating a loan amortization schedule 287 Calculating a loan with irregular payments 288 Investment Calculations 290 Future value of a single deposit 290 Present value of a series of payments 296 Future value of a series of deposits 296 Chapter 12: Discounting and Depreciation Formulas 299 Using the NPV Function 299 Definition of NPV 300 NPV function examples 301 Using the IRR Function 306 Rate of return 307 Geometric growth rates 308 Checking results 309 Irregular Cash Flows 310 Net present value 310 Internal rate of return 311 Depreciation Calculations 312 Chapter 13: Financial Schedules 317 Creating Financial Schedules 317 Creating Amortization Schedules 318 A simple amortization schedule 318 A dynamic amortization schedule 320 Credit card calculations 323 Summarizing Loan Options Using a Data Table 325 Creating a one-way data table 325 Creating a two-way data table 327 Financial Statements and Ratios 329 Basic financial statements 329 Ratio analysis 333 Creating Indices 337 Part IV: Array Formulas Chapter 14: Introducing Arrays 341 Introducing Array Formulas 341 A multicell array formula 342 A single‐cell array formula 343 Creating an array constant 344 Array constant elements 345 Understanding the Dimensions of an Array 346 One‐dimensional horizontal arrays 346 One‐dimensional vertical arrays 347 Two‐dimensional arrays 347 Naming Array Constants 349 Working with Array Formulas 350 Entering an array formula 350 Selecting an array formula range 350 Editing an array formula 351 Expanding or contracting a multicell array formula 352 Using Multicell Array Formulas 353 Creating an array from values in a range 353 Creating an array constant from values in a range 353 Performing operations on an array 354 Using functions with an array 355 Transposing an array 355 Generating an array of consecutive integers 357 Using Single‐Cell Array Formulas 358 Counting characters in a range 358 Summing the three smallest values in a range 359 Counting text cells in a range 360 Eliminating intermediate formulas 362 Using an array in lieu of a range reference 364 Chapter 15: Performing Magic with Array Formulas 365 Working with Single‐Cell Array Formulas 365 Summing a range that contains errors 366 Counting the number of error values in a range 367 Summing the n largest values in a range 368 Computing an average that excludes zeros 368 Determining whether a particular value appears in a range 369 Counting the number of differences in two ranges 371 Returning the location of the maximum value in a range 372 Finding the row of a value’s nth occurrence in a range 373 Returning the longest text in a range 373 Determining whether a range contains valid values 374 Summing the digits of an integer 375 Summing rounded values 377 Summing every nth value in a range 377 Removing nonnumeric characters from a string 379 Determining the closest value in a range 380 Returning the last value in a column 380 Returning the last value in a row 381 Working with Multicell Array Formulas 382 Returning only positive values from a range 382 Returning nonblank cells from a range 384 Reversing the order of cells in a range 384 Sorting a range of values dynamically 385 Returning a list of unique items in a range 386 Displaying a calendar in a range 387 Part V: Miscellaneous Formula Techniques Chapter 16: Importing and Cleaning Data 393 A Few Words About Data 393 Importing Data 394 Importing from a file 394 Importing a text file into a specified range 396 Copying and pasting data 398 Data Cleanup Techniques 398 Removing duplicate rows 398 Identifying duplicate rows 400 Splitting text 401 Changing the case of text 407 Removing extra spaces 408 Removing strange characters 409 Converting values 409 Classifying values 410 Joining columns 411 Rearranging columns 412 Randomizing the rows 412 Matching text in a list 413 Change vertical data to horizontal data 414 Filling gaps in an imported report 417 Spelling checking 418 Replacing or removing text in cells 419 Adding text to cells 420 Fixing trailing minus signs 420 A Data Cleaning Checklist 421 Exporting Data 422 Exporting to a text file 422 Exporting to other file formats 423 Chapter 17: Charting Techniques 425 Understanding the SERIES Formula 425 Using names in a SERIES formula 427 Unlinking a chart series from its data range 428 Creating Links to Cells 429 Adding a chart title link 429 Adding axis title links 430 Adding text links 430 Adding a linked picture to a chart 430 Chart Examples 431 Single data point charts 431 Displaying conditional colors in a column chart 433 Creating a comparative histogram 434 Creating a Gantt chart 435 Creating a box plot 438 Plotting every nth data point 439 Identifying maximum and minimum values in a chart 441 Creating a Timeline 442 Plotting mathematical functions 443 Plotting a circle 448 Creating a clock chart 450 Creating awesome designs 452 Working with Trendlines 453 Linear trendlines 454 Working with nonlinear trendlines 460 Summary of trendline equations 461 Creating Interactive Charts 462 Selecting a series from a drop‐down list 462 Plotting the last n data points 463 Choosing a start date and number of points 464 Displaying population data 465 Displaying weather data 465 Chapter 18: Pivot Tables 469 About Pivot Tables 469 A Pivot Table Example 470 Data Appropriate for a Pivot Table 472 Creating a Pivot Table Automatically 475 Creating a Pivot Table Manually 477 Specifying the data 477 Specifying the location for the pivot table 478 Laying out the pivot table 480 Formatting the pivot table 481 Modifying the pivot table 483 More Pivot Table Examples 485 Question 1 485 Question 2 486 Question 3 487 Question 4 487 Question 5 488 Question 6 489 Question 7 490 Grouping Pivot Table Items 491 A manual grouping example 491 Viewing grouped data 493 Automatic grouping examples 494 Creating a Frequency Distribution 498 Creating a Calculated Field or Calculated Item 499 Creating a calculated field 501 Inserting a calculated item 503 Filtering Pivot Tables with Slicers 506 Filtering Pivot Tables with a Timeline 507 Referencing Cells Within a Pivot Table 508 Another Pivot Table Example 510 Using the Data Model 513 Creating Pivot Charts 516 A pivot chart example 517 More about pivot charts 519 Chapter 19: Conditional Formatting 521 About Conditional Formatting 521 Specifying Conditional Formatting 523 Formatting types you can apply 523 Making your own rules 524 Conditional Formats That Use Graphics 525 Using data bars 525 Using color scales 527 Using icon sets 530 Creating Formula-Based Rules 533 Understanding relative and absolute references 534 Conditional formatting formula examples 536 Working with Conditional Formats 543 Managing rules 544 Copying cells that contain conditional formatting 544 Deleting conditional formatting 545 Locating cells that contain conditional formatting 545 Chapter 20: Using Data Validation 547 About Data Validation 547 Specifying Validation Criteria 548 Types of Validation Criteria You Can Apply 549 Creating a Drop‐Down List 551 Using Formulas for Data Validation Rules 552 Understanding Cell References 552 Data Validation Formula Examples 554 Accepting text only 554 Accepting a larger value than the previous cell 554 Accepting nonduplicate entries only 554 Accepting text that begins with a specific character 555 Accepting dates by the day of the week 556 Accepting only values that don’t exceed a total 556 Creating a dependent list 557 Using Structured Table Referencing 558 Chapter 21: Creating Megaformulas 561 What Is a Megaformula? 561 Creating a Megaformula: A Simple Example 562 Megaformula Examples 564 Using a megaformula to remove middle names 564 Using a megaformula to return a string’s last space character position 569 Using a megaformula to determine the validity of a credit card number 573 Using Intermediate Named Formulas 578 Generating random names 579 The Pros and Cons of Megaformulas 580 Chapter 22: Tools and Methods for Debugging Formulas 581 Formula Debugging? 581 Formula Problems and Solutions 582 Mismatched parentheses 583 Cells are filled with hash marks 584 Blank cells are not blank 584 Extra space characters 585 Formulas returning an error 585 Absolute/relative reference problems 590 Operator precedence problems 591 Formulas are not calculated 592 Actual versus displayed values 592 Floating‐point number errors 593 Phantom link errors 594 Logical value errors 595 Circular reference errors 596 Excel’s Auditing Tools 596 Identifying cells of a particular type 596 Viewing formulas 597 Tracing cell relationships 598 Tracing error values 600 Fixing circular reference errors 600 Using background error checking 600 Using Excel’s Formula Evaluator 603 Part VI: Developing Custom Worksheet Functions Chapter 23: Introducing VBA 607 Fundamental Macro Concepts 607 Activating the Developer tab 608 Recording a macro 608 Understanding macro-enabled extensions 611 Macro security in Excel 611 Trusted locations 611 Storing macros in your Personal Macro Workbook 612 Assigning a macro to a button and other form controls 612 Placing a macro on the Quick Access toolbar 614 Working in the Visual Basic Editor 615 Understanding VBE components 615 Working with the Project window 616 Working with a code window 619 Customizing the VBA environment 622 Chapter 24: VBA Programming Concepts 627 A Brief Overview of the Excel Object Model 627 Understanding objects 628 Understanding collections 628 Understanding properties 629 Understanding methods 629 A brief look at variables 630 Error handling 633 Using code comments 636 An Introductory Example Function Procedure 636 Using Built-In VBA Functions 638 Controlling Execution 640 The If-Then construct 640 The Select Case construct 642 Looping blocks of instructions 643 Using Ranges 648 The For Each-Next construct 648 Referencing a range 649 Some useful properties of ranges 651 The Set keyword 655 The Intersect function 655 The Union function 656 The UsedRange property 656 Chapter 25: Function Procedure Basics 659 Why Create Custom Functions? 659 An Introductory VBA Function Example 660 About Function Procedures 662 Declaring a function 662 Choosing a name for your function 663 Using functions in formulas 664 Using function arguments 665 Using the Insert Function Dialog Box 665 Adding a function description 666 Specifying a function category 667 Adding argument descriptions 669 Testing and Debugging Your Functions 670 Using the VBA MsgBox statement 671 Using Debug.Print statements in your code 673 Calling the function from a Sub procedure 673 Setting a breakpoint in the function 676 Creating Add-Ins for Functions 676 Chapter 26: VBA Custom Function Examples 679 Simple Functions 679 Is the cell hidden? 680 Returning a worksheet name 680 Returning a workbook name 681 Returning the application’s name 681 Returning Excel’s version number 682 Returning cell formatting information 682 Determining a Cell’s Data Type 684 A Multifunctional Function 685 Generating Random Numbers 688 Generating random numbers that don’t change 688 Selecting a cell at random 690 Calculating Sales Commissions 691 A function for a simple commission structure 691 A function for a more complex commission structure 692 Text Manipulation Functions 693 Reversing a string 694 Scrambling text 694 Returning an acronym 695 Does the text match a pattern? 695 Does a cell contain a particular word? 696 Does a cell contain text? 698 Extracting the nth element from a string 698 Spelling out a number 699 Counting Functions 700 Counting pattern-matched cells 700 Counting sheets in a workbook 700 Counting words in a range 701 Date Functions 701 Calculating the next Monday 702 Calculating the next day of the week 702 Which week of the month? 703 Working with dates before 1900 703 Returning the Last Nonempty Cell in a Column or Row 704 The LASTINCOLUMN function 705 The LASTINROW function 705 Multisheet Functions 706 Returning the maximum value across all worksheets 706 The SHEETOFFSET function 708 Advanced Function Techniques 709 Returning an error value 709 Returning an array from a function 710 Returning an array of nonduplicated random integers 712 Randomizing a range 714 Using optional arguments 716 Using an indefinite number of arguments 717 Part VII: Appendixes Appendix A: Excel Function Reference 725 Appendix B: Using Custom Number Formats 743 Index 763
£28.00
John Wiley & Sons Inc Word 2016 For Dummies
Book SynopsisThe bestselling beginner's guide to Microsoft Word Written by the author of the first-ever For Dummies book, Dan Gookin, this new edition of Word For Dummies quickly and painlessly gets you up to speed on mastering the world's number-one word processing software.Table of ContentsIntroduction 1 About This Book 1 How to Use This Book 2 Foolish Assumptions 3 What’s Not Here 3 Icons Used in This Book 4 Where to Go from Here 4 Part I: Your Introduction to Word 5 Chapter 1: Hello, Word! 7 Start Your Word Day 7 Starting Word the traditional way 8 Starting Word the best way 8 Opening a document to start Word 9 Behold the Word Program 10 Working the Word Start screen 10 Examining Word’s main screen 11 Working the Ribbon 12 Showing and hiding the Ribbon 13 Changing the document view 14 Making text larger or smaller 15 End Your Word‐Processing Day 16 Quitting Word 16 Closing a document without quitting Word 17 Setting Word aside 18 Chapter 2: The Typing Chapter 19 Input Devices Galore 19 Using the PC keyboard 19 Understanding the mouse pointer 21 Keyboard Dos and Don’ts 21 Following the insertion pointer 22 Whacking the spacebar 22 Backing up and erasing 23 Pressing the Enter key 23 Stuff That Happens While You Type 23 Watching the status bar 24 Observing page breaks 24 Working collapsible headers 25 Dealing with spots and clutter in the text 25 Understanding colorful underlines 26 Part II: Your Basic Word 27 Chapter 3: To and Fro in a Document 29 Document Scrolling 29 Working the vertical scroll bar 29 Using the horizontal scroll bar 31 Scrolling with the mouse wheel 31 Move the Insertion Pointer 31 Commanding the insertion pointer 32 Moving in small increments 32 Moving from beginning to end 33 Go Back to Where You Once Edited 34 Go to Wherever with the Go To Command 34 Chapter 4: Text Editing 37 Remove Text You Don’t Want 37 Deleting single characters 38 Deleting a word 38 Deleting more than a word 39 Split and Join Paragraphs 41 Making two paragraphs from one 41 Making one paragraph from two 41 Soft and Hard Returns 42 Undo Mistakes with Undo Haste 43 Undoing the Undo command with Redo 44 Using the Repeat command 44 Chapter 5: Search for This, Replace It with That 45 Text Happily Found 45 Finding a tidbit o’ text 46 Scouring your document with Advanced Find 47 Finding stuff you can’t type 49 Replace Found Text 51 Replacing one thing with another 51 Replacing it all at once 53 Finding and replacing formatting 53 Chapter 6: Blocks o’ Text 55 Meet Mr Block 55 Mark a Block of Text 57 Using the keyboard to select text 57 Marking a block with the mouse 58 Using the F8 key to mark a block 59 Blocking the whole dang‐doodle document 60 Deselecting a block 61 Manipulate the Block of Text 61 Copying a block 62 Moving a block 62 Setting the pasted text format 63 Copying or moving a block with the mouse 64 Viewing the Clipboard 65 Chapter 7: Spell It Write 67 Check Your Spelling 67 Fixing a misspelled word 68 Dealing with incorrectly flagged words 69 AutoCorrect in Action 70 Undoing an AutoCorrect correction 70 Adjusting AutoCorrect settings 71 Grammar Be Good 72 All‐at‐Once Document Proofing 73 Spell Check and Grammar Settings 74 Undoing the Ignore All command 74 Customizing the custom dictionary 75 Disabling automatic spell check 76 Curtailing grammar checking 76 Chapter 8: Documents New, Saved, Opened, and Closed 77 Some Terms to Get Out of the Way 77 Behold! A New Document 78 Save Your Stuff! 79 Saving a document the first time 79 Dealing with document‐save errors 81 Saving or updating a document 82 Forgetting to save before you quit 83 Open a Document 84 Using the Open command 84 Opening one document inside another 86 Close a Document 87 Recover a Draft 87 Chapter 9: Publish Your Document 89 Your Document on Paper 89 Previewing before printing 90 Printing the whole document 91 Printing a specific page 92 Printing a range of pages 93 Printing on both sides of the page 94 Printing odd and even pages 94 Printing a block 95 Printing more than one copy of something 96 Choosing another printer 96 Canceling a print job 97 Electronically Publishing Your Document 97 Preparing a document for sharing 98 Sending a Word document via email 98 Making a PDF 99 Exporting your document 100 Part III: Fun with Formatting 101 Chapter 10: Character Formatting 103 Text‐Formatting Techniques 103 Basic Text Formats 104 Choosing a font 105 Applying character formats 106 Text Transcending Teensy to Titanic 107 Setting the text size 108 Nudging text size 108 More Colorful Text 109 Coloring the text 109 Shading the background 110 Change Text Case 111 Clear Character Formatting 112 Behold the Font Dialog Box 112 Chapter 11: Paragraph Formatting 115 Paragraph‐Formatting Rules and Regulations 115 Formatting a paragraph 116 Locating the paragraph‐formatting commands 116 Justification and Alignment 118 Line up on the left! 118 Everyone center! 118 Line up on the right! 119 Line up on both sides! 119 Make Room Before, After, or Inside Paragraphs 119 Setting the line spacing 120 Making space between paragraphs 121 Paragraph Indentation Madness 122 Indenting the first line of a paragraph 122 Making a hanging indent (an outdent) 123 Indenting a whole paragraph 124 Using the ruler to adjust indents 124 Chapter 12: Tab Formatting 127 Once Upon a Tab 127 Seeing tab characters 128 Seeing tab stops 129 Using the ruler to set tab stops 130 Using the Tabs dialog box to set tabs 130 The Standard Left Tab Stop 132 Creating a basic tabbed list 132 Creating a two‐tab paragraph thing 133 The Center Tab Stop 135 The Right Tab Stop 136 Making a right‐stop, left‐stop list 136 Building a two‐column right‐stop list 138 The Decimal Tab 139 The Bar Tab 140 Fearless Leader Tabs 141 Tab Stop, Be Gone! 142 Chapter 13: Page Formatting 143 Describe That Page 143 Setting page size 143 Changing orientation (landscape or portrait) 144 Setting the page margins 145 Using the Page Setup dialog box 146 Page Numbering 148 Adding an automatic page number 148 Starting with a different page number 149 Numbering with Roman numerals 150 Removing page numbers 151 New Pages from Nowhere 151 Starting text on a new page 152 Inserting a blank page 152 Page Background Froufrou 153 Coloring pages 153 Printing colored pages 154 Adding a watermark 154 Chapter 14: More Page Formatting 157 Slice Your Document into Sections 157 Understanding sections 158 Creating a section 159 Using sections 160 Deleting a section break 160 That First Page 161 Adding a cover page 162 Inserting a cover page manually 162 Headers and Footers 163 Using a preset header or footer 164 Creating a custom header or footer 164 Working with multiple headers and footers 167 Removing a header or a footer 169 Chapter 15: Style Formatting 171 The Big Style Overview 171 Finding the styles 172 Using a style 173 Discovering the current style 174 Removing style formatting 175 Make Your Own Styles 176 Creating a style 176 Using the Create New Style from Formatting dialog box 177 Modifying a style 178 Assigning a shortcut key to your style 179 Deleting a style 180 Style Tips and Tricks 181 Updating the Normal style 181 Creating heading styles 182 Customizing the Style Gallery 182 Chapter 16: Template and Themes Formatting 183 Instant Documents with Templates 183 Starting a new document by using a template 184 Changing a document’s associated template 186 Templates of Your Own 187 Creating a template based on a document you already have 187 Making a new template from scratch 188 Modifying a template 188 The Theme of Things 189 Applying a document theme 190 Modifying or creating a theme 190 Chapter 17: Sundry Formatting 191 Weird and Fun Text Effects 191 Steal This Format! 193 Automatic Formatting 194 Enjoying automagical text 194 Formatting tricks for paragraphs 196 Undoing an AutoFormat 198 Center a Page, Top to Bottom 198 Part IV: Spruce Up a Dull Document 201 Chapter 18: Borders and Lines 203 The Basics of Borders 203 Putting borders around a paragraph 205 Drawing a thick line between paragraphs 206 Boxing multiple paragraphs 206 Removing borders 207 The Borders and Shading Dialog Box 207 Creating a fancy title 208 Boxing text 209 Applying a page border 209 Chapter 19: Able Tables 211 Put a Table in Your Document 211 Working with tables in Word 212 Creating a table 213 Un-creating a table 216 Deleting a table 217 Text in Tables 217 Typing text in a table 217 Selecting in a table 218 Aligning text in a cell 218 Table Modification 219 Adding or removing rows or columns 220 Adjusting row and column size 220 Merging cells 221 Splitting cells 221 Making the table pretty 222 Adding a table caption 222 Chapter 20: Columns of Text 225 All about Columns 225 Making two-column text 227 Building a trifold brochure 227 Giving up on columns 228 Column Termination 229 Changing column formats 229 Placing a column break 230 Chapter 21: Lots of Lists 233 Lists with Bullets and Numbers 233 Making a bulleted list 234 Numbering a list 234 Creating a multilevel numbered list 235 Numbering lines on a page 235 Document Content Lists 236 Creating a table of contents 236 Building an index 237 Adding a list of figures 239 Footnotes and Endnotes 239 Chapter 22: Here Come the Graphics 241 Graphical Goobers in Your Text 241 Copying and pasting an image 243 Plopping down a picture 243 Stealing images from the Internet 244 Slapping down a shape 244 Sticking things into a shape 245 Using WordArt 246 Adding a caption 246 Image Layout 247 Wrapping text around an image 249 Floating an image 249 Keeping an image with text 250 Image Editing 250 Resizing an image 250 Cropping an image 251 Rotating an image 251 Changing an image’s appearance 252 Image Arrangement 252 Moving an image hither and thither 252 Aligning graphics 253 Shuffling images front or back 253 Grouping images 254 Chapter 23: Insert Tab Insanity 255 Characters Foreign and Funky 255 Nonbreaking spaces and hyphens 255 Typing characters such as Ü, Ç, and Ñ 256 Inserting special characters and symbols 257 Spice Up Your Document with a Text Box 258 Fun with Fields 259 Understanding fields 260 Adding some useful fields 261 Updating a field 262 Changing a field 262 Deleting fields 263 The Date and Time 263 Adding the current date or time 264 Using the PrintDate field 264 Part V: The Rest of Word 265 Chapter 24: Multiple Documents, Windows, and File Formats 267 Multiple Document Mania 267 Arranging open document windows 268 Comparing two documents side by side 269 Viewing one document in multiple windows 269 Using the old split‐screen trick 270 Many, Many Document Types 271 Understanding document formats 271 Opening a non‐Word document 272 Updating an older Word document 274 Chapter 25: Word for Writers 275 Organize Your Thoughts 275 Entering Outline view 276 Typing topics in the outline 277 Rearranging topics 278 Demoting and promoting topics 278 Expanding and collapsing topics 279 Adding a text topic 281 Printing an outline 281 Large Documents 282 Creating a master document 282 Splitting a document 284 Dan’s Writing Tips 285 Choosing the best word 285 Counting every word 285 Writing for writers 286 Chapter 26: Let’s Work This Out 287 Comments on Your Text 287 Adding a comment 288 Displaying or hiding comments 288 Reviewing comments one at a time 289 Printing comments (or not) 290 Deleting comments 291 The Yellow Highlighter 291 Look What They’ve Done to My Text, Ma 292 Comparing two versions of a document 292 Tracking changes as they’re made 294 Reviewing changes 294 Collaborate on the Internet 295 Sharing a document 296 Checking updates 296 Chapter 27: Mail Merge Mania 297 About Mail Merge 297 Understanding Word’s mail merge jargon 298 Reviewing the mail merge process 299 Using the Mail Merge Wizard 300 I The Main Document 300 Creating a mail merge form letter 300 Creating mail merge email messages 302 Creating mail merge envelopes 302 II The Recipient List 303 Building a new recipient list 303 Using an already created recipient list 307 Grabbing a recipient list from Outlook 308 Editing a recipient list 308 III Fold in the Fields 309 IV Preview the Merged Documents 310 V Mail Merge Ho! 311 Merging to a new set of documents 311 Merging to the printer 311 Merging to email 312 Chapter 28: Labels and Envelopes 313 Labels Everywhere 313 Printing sheets of identical labels 314 Printing an address list 315 Instant Envelope 317 Chapter 29: A More Custom Word 321 A Better Status Bar 321 The Quick Access Toolbar 323 Adding buttons to the Quick Access toolbar 324 Editing the Quick Access toolbar 324 Removing items from the Quick Access toolbar 326 Customize the Ribbon 326 Part VI: The Part of Tens 329 Chapter 30: The Ten Commandments of Word 331 Thou Shalt Remember to Save Thy Work 331 Thou Shalt Not Use Spaces Unnecessarily 332 Thou Shalt Not Abuse the Enter Key 332 Thou Shalt Not Neglect Keyboard Shortcuts 332 Thou Shalt Not Manually Number Thy Pages 333 Thou Shalt Not Force a New Page 333 Thou Shalt Not Forget Thy Undo Command 333 Honor Thy Printer 333 Thou Shalt Have Multiple Document Windows Before Thee 334 Neglecteth Not Windows 334 Chapter 31: Ten Cool Tricks 335 Automatic Save with AutoRecover 335 Accelerate the Ribbon 336 Ancient Word Keyboard Shortcuts 337 Build Your Own Fractions 337 Electronic Bookmarks 338 Lock Your Document 339 The Drop Cap 339 Map Your Document 340 Sort Your Text 341 Map Ctrl+F to the Advanced Find Command 342 Chapter 32: Ten Bizarre Things 343 Equations 343 Video in Your Document 344 Hidden Text 344 The Developer Tab 345 Hyphenation 345 Document Properties 346 Cross‐References 346 Collect and Paste 346 Click‐and‐Type 347 Word and the Internet 347 Chapter 33: Ten Automatic Features Worthy of Deactivation 349 Bye-Bye Start Screen 349 Restore the Traditional Open and Save Dialog Boxes 350 Turn Off the Mini Toolbar 350 Select Text by Letter 351 Disable Click‐and‐Type 352 Paste Plain Text Only 352 Disable AutoFormat Features (×4) 353 Index 355
£17.59
John Wiley & Sons Inc Office 2016 AllinOne For Dummies
Book SynopsisThe fast and easy way to get things done with Office Perplexed by PowerPoint? Looking to excel at Excel? From Access to Word and every application in between this all-encompassing guide provides plain-English guidance on mastering the entire Microsoft Office suite.Table of ContentsIntroduction 1 About This Book 1 Foolish Assumptions 2 Icons Used in This Book 2 Beyond the Book 3 Where to Go from Here 4 Book I: Common Office Tasks 5 Chapter 1: Office Nuts and Bolts 7 Chapter 2: Wrestling with the Text 25 Chapter 3: Speed Techniques Worth Knowing About 43 Book II: Word 2016 51 Chapter 1: Speed Techniques for Using Word 53 Chapter 2: Laying Out Text and Pages 71 Chapter 3: Word Styles 95 Chapter 4: Constructing the Perfect Table 111 Chapter 5: Taking Advantage of the Proofing Tools 133 Chapter 6: Desktop Publishing with Word 153 Chapter 7: Getting Word’s Help with Office Chores 171 Chapter 8: Tools for Reports and Scholarly Papers 191 Book III: Excel 2016 213 Chapter 1: Up and Running with Excel 215 Chapter 2: Refining Your Worksheet 233 Chapter 3: Formulas and Functions for Crunching Numbers 247 Chapter 4: Making a Worksheet Easier to Read and Understand 279 Chapter 5: Advanced Techniques for Analyzing Data 297 Book IV: PowerPoint 2016 313 Chapter 1: Getting Started in PowerPoint 315 Chapter 2: Fashioning a Look for Your Presentation 337 Chapter 3: Entering the Text 351 Chapter 4: Making Your Presentations Livelier 367 Chapter 5: Delivering a Presentation 383 Book V: OneNote 2016 405 Chapter 1: Up and Running with OneNote 407 Chapter 2: Taking Notes 419 Chapter 3: Finding and Organizing Your Notes 435 Book VI: Outlook 2016 443 Chapter 1: Outlook Basics 445 Chapter 2: Maintaining the Contacts Folder 459Chapter 3: Handling Your Email 469 Chapter 4: Managing Your Time and Schedule 491 Chapter 5: Tasks, Reminders, and Notes 499 Book VII: Access 2016 507 Chapter 1: Introducing Access 509 Chapter 2: Building Your Database Tables 523 Chapter 3: Entering the Data 551 Chapter 4: Sorting, Querying, and Filtering for Data 561 Chapter 5: Presenting Data in a Report 581 Book VIII: Working with Charts and Graphics 587 Chapter 1: Creating a Chart 589 Chapter 2: Making a SmartArt Diagram 607 Chapter 3: Handling Graphics and Photos 625 Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects 641 Book IX: Office 2016 — One Step Beyond 669 Chapter 1: Customizing an Office Program 671 Chapter 2: Ways of Distributing Your Work 685 Chapter 3: Working with Publisher 695 Book X: File Sharing and Collaborating 711 Chapter 1: Up and Running on OneDrive 713 Chapter 2: File Sharing and Collaborating 723 Index 731
£21.24
John Wiley & Sons Inc Computing the Environment
Book SynopsisComputing the Environment presents practical workflows and guidance for designers to get feedback on their design using digital design tools on environmental performance. Starting with an extensive state-of-the-art survey of what top international offices are currently using in their design projects, this book presents detailed descriptions of the tools, algorithms, and workflows used and discusses the theories that underlie these methods. Project examples from Transsolar Klimaengineering, Buro Happolds SMART Group, Behnish Behnisch Architects, Thomas Herzog, Autodesk Research are contextualized with quotes and references to key thinkers in this field such as Eric Winsberg, Andrew Marsh, Michelle Addington and Ali Malkawi.Table of ContentsFOREWORD VI-IXPhil Bernstein, Yale School of Architecture 1. INTRODUCTION—COMPUTING THE ENVIRONMENT: DESIGN WORKFLOWS FOR THE SIMULATION OF SUSTAINABLE ARCHITECTURE 1-13Brady Peters and Terri Peters 2. NEW DIALOGUES ABOUT ENERGY: PERFORMANCE, CARBON AND CLIMATE 14-27Terri Peters 3. PARAMETRIC ENVIRONMENTAL DESIGN: SIMULATION AND GENERATIVE PROCESSES 28-42Brady Peters 4. DESIGNING ATMOSPHERES: SIMULATING EXPERIENCE 43-57Brady Peters 5. USE DATA: COMPUTING LIFE-CYCLE AND REAL-TIME VISUALISATION 58-73Terri Peters 6. NEAR FUTURE DEVELOPMENTS: ADVANCES IN SIMULATION AND REAL-TIME FEEDBACK 74-93Terri Peters 7. DESIGNING ENVIRONMENTS AND SIMULATING EXPERIENCE: FOSTER + PARTNERS SPECIALIST MODELLING GROUP 94-105Brady Peters 8. MAXIMISING IMPACT THROUGH PERFORMANCE SIMULATION: THE WORK OF TRANSSOLAR KLIMAENGINEERING 106-117Terri Peters 9. DESIGNERS NEED FEEDBACK: RESEARCH AND PRACTICE BY KIERANTIMBERLAKE 118-127Terri Peters 10. ARCHITECTURE SHAPES PERFORMANCE: GXN ADVANCES SOLAR MODELLING AND SENSING 128-137Terri Peters 11. BESPOKE TOOLS FOR A BETTER WORLD: THE ART OF SUSTAINABLE DESIGN AT BUROHAPPOLD ENGINEERING 138-149Brady Peters 12. BIG IDEAS: INFORMATION DRIVEN DESIGN 150-162Brady Peters 13. SIMULATING THE INVISIBLE: MAX FORDHAM DESIGNS LIGHT, AIR AND SOUND 162-175Terri Peters 14. WHITE ARCHITECTS: BUILD THE FUTURE 176-183Terri Peters 15. CORE: INTEGRATED COMPUTATION AND RESEARCH 184-191Terri Peters 16. SUPERSPACE: COMPUTING HUMAN-CENTRIC ARCHITECTURE 192-200Brady Peters 17. ZHACODE: SKETCHING WITH PERFORMANCE 201-209Terri Peters 18. WEWORK: BUILDING DATA FOR DESIGN FEEDBACK 210-217Terri Peters 19. GLOBAL ENVIRONMENTAL CHALLENGES: TECHNOLOGY DESIGN AND ARCHITECTURAL RESPONSES 218-235Brady Peters and Terri Peters, with contributions from Timur Dogan, Werner Sobek, William W Braham, Kiel Moe, Neil Katz, and Mostapha Sadeghipour Roudsari INDEX 236-242
£40.80
