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 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 wireframe 2 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 simulator 3 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 to display the longest or tallest entry within the column or row Answer AutoFit 9 To enter additional lines in a cell press the Answer Alt Enter keys 10 A is a single point on a computer monitor or printout Answer Pixel 11 What is the default column width Answer 8 38 standard sized characters about 8 or 9 characters 12 True False If you increase the font size of characters you can fit more text within a given cell Answer False 13 To select adjacent ranges hold down the key and then select the range A Home B Shift C Alternate D Control Answer B 14 True False To deselect a range click in the selected range again Answer False 15 A n is a mathematical expression that calculates a value Answer formula 16 True False A worksheet can contain the following type of data text numeric values dates and calculated values Answer True 17 The calculates the total number of values Answer D a SUM b AVERAGE c MEDIAN d COUNT 18 True False Functions are used to simplify formulas Answer True 19 New Excel workbooks contain how many worksheets a One b Two c Three d Four Answer C 4 20 True False Worksheets cannot be deleted Answer False 21 To edit a cell s contents you need to work in Answer editing mode 22 True False You can reverse more than one action by clicking on the Undo button s list arrow Answer True 23 When does Flash Fill work best Answer When the pattern is clearly recognized from the values in the data 24 True False Flash Fill enters formulas not text Answer False 25 To toggle in and out