BCIS 2610 -- EXAM 2 STUDY GUIDEREMINDER OF EXAM POLICIESEXAM ADMINISTRATIONComputers in Our World, CHAPTER 4:Computer Applications in Science and EngineeringQUICK QUIZZESComputers in Our World, CHAPTER 5:Computer Applications in Arts and EntertainmentQUICK QUIZZESComputers in Our World, CHAPTER 6:Computer Applications in TransportationMICROSOFT EXCEL 2016EXCEL MODULE 1: Getting Started with ExcelEXCEL MODULE 1 KEY TERMS include …EXCEL MODULE 2: Formatting Workbook Text and DataEXCEL MODULE 2 KEY TERMS include …EXCEL MODULE 3: Calculating Data with Formulas and FunctionsEXCEL MODULE 3 KEY TERMS include …EXCEL MODULE 4: Analyzing and Charting Financial DataEXCEL MODULE 4 KEY TERMS include …EXCEL MODULE 6: Managing Multiple Worksheets and WorkbooksEXCEL MODULE 6 KEY TERMS include …EXCEL MODULES 7, 8, 9, 10, and 12: NOT ASSIGNED FOR REGULAR SECTIONSEXCEL 2013 TUTORIAL 11: Connecting to External DataEXCEL TUTORIAL 11 KEY TERMS include …BCIS 2610 -- EXAM 2 STUDY GUIDE Exam Time: When your section meets (the exam duration is 50 minutes). Exam Location: Where your section normally meets. REMINDER OF EXAM POLICIES 1. You must take the exam with your section; otherwise your grade will be zero. 2. You must present your Student ID card, or other acceptable picture ID, when turning in the exam. 3. Closed books, closed notes 4. No electronic devices. Cell phones are to be switched off. EXAM ADMINISTRATION • We do not supply you with pencils. Bring two sharpened No. 2 pencils, and a good eraser that does not leave smudges. • We will supply the machine-readable sheet(s) for you to use, as well as a numbered exam. • Follow the instructions provided by your section’s instructor. MATERIAL TO BE COVERED ON THIS EXAM *** (This is an NOT an exhaustive list of topics, but paying more attention on these areas will help you focus your exam preparation effort.)*** Computers in Our World, CHAPTER 4: Computer Applications in Science and Engineering • Understand the key terms at the end of the chapter (p. 79). • Page 80 answers: C, C, D, A, B, C, B, D, D. • Some additional review questions: QUICK QUIZZES 1) The scientists aboard hurricane hunter aircraft use ____ to collect data about the storm’s atmosphere. Answer: dropsondes 2) What type of satellite collects geographical and weather data? Answer: Geostationary Operational Environmental Satellites (GOES) 3) _______ captures optical data simultaneously from many different parts of the electromagnetic spectrum.2 Answer: Multispectral imaging 4) Product and Construction Process are major parts of a _____. Answer: building’s life cycle 5) “Refugee areas” are dedicated emergency spaces located within the _______. Answer: Burj Khalifa tower 6) _______ is a “roach robot.” Answer: CRAM Computers in Our World, CHAPTER 5: Computer Applications in Arts and Entertainment • Understand the key terms at the end of the chapter (p. 104). • Page 105 answers: A, B, B, C, A, D, C, B, C, B. • Some additional review questions: QUICK QUIZZES 1) Name the components of a MIDI system. Answer: MIDI port, MIDI protocol, and the Standard MIDI file format. 2) A(n) ____ is a peripheral device or chip that creates sound from digital instructions input by the user. Answer: synthesizer 3) True or False: The RIAA is focusing primarily on companies in their battle against copyright infringement. Answer: False 4) What is a fractal? Answer: A fractal is an art form that uses mathematical formulas to create a geometric pattern that is repeated over and over, either at smaller or larger scales. 5) What is splitting? Splitting involves segmenting a video into smaller scenes for easier editing. 6) ____ is a special effect in which one video image is transformed into another image over the course of several frames of video. Answer: Morphing 7) True or False: It is legal to add still or video images to live broadcasts so that they look as if they are part of the original scene. Answer: True 8) In 3-D animation, a(n) _____ model forms the basis for generating an artificial character or object. Answer: wireframe3 Computers in Our World, CHAPTER 6: Computer Applications in Transportation • Understand the key terms at the end of the chapter (p. 125). • Page 126 answers: D, C, B, B, C, C, A, A, B, D. • Some additional review questions: 1) The ____ of an ECM allows the various modules in the car to send data to and from the ECM. Answer: communications bus 2) Night vision systems generate an image of the road in black and white. Answer: True 3) Where are the sensors of a collision warning system placed? Answer: Sensors are placed on the bumper and below each door. 4) ____ is a system that maintains a safe driving interval between your car and other vehicles by changing the gears or by applying the brakes. Answer: adaptive cruise control (ACC) 5) The ____ oversees all air traffic control in the United States. Answer: Air Traffic Control System Command Center (ATSCC) 6) Who completes the preflight routine, which includes transmitting a flight plan to the air traffic control tower? Answer: the pilot 7) What is the purpose of a global distribution system (GDS)? Answer: maintain a database to provide travel providers and consumers information about available flights and seats and to manage inventory. 8) A(n) ____ helps train airline pilots by modeling the experience of being inside the cockpit of a plane. Answer: flight simulator4 MICROSOFT EXCEL 2016 EXCEL MODULE 1: Getting Started with Excel 1. A ____________ is a collection of text and numbers laid out in a rectangular grid. (Answer: spreadsheet) 2. You press the ____________ key to display the Key tips, which are labels that appear over each tab and command on the ribbon. (Answer: Alt) 3. In spreadsheet terms, a(n) _____ contains an Excel chart that provides a visual representation of spreadsheet data. a. Worksheet b. Chart Sheet c. Cell d. Active cell (Answer: B) 4. On the ribbon, click the ____________ tab to display Backstage view. (Answer: FILE) 5. A _____________ reminds you why you created a workbook and what it contains. (Answer: documentation sheet) 6. Each cell is identified by a(n) _____, which is based on the cell’s column and row location. (Answer: cell reference) 7. What does a green triangle in a cell indicate? (Answer:A potential error) 8. ______ changes the column width or row height