Review Final Exam Chapters 1 8, 9 12

1
ReviewFinal ExamChapters 1 8, 9 12
2
Exam Topics

• Chapters 1 3 Overview of Computer Hardware
  and Software
• Chapter 4 Operating Systems and File Management
• Chapters 5 7 Computer Networks and The
  Internet
• Chapter 8 Digital Media
• Chapters 10 12 Information Systems
  Development, Management and Maintenance

3
Exam Information

• 90 questions, 1-2 points each 100 points
• True/False and Multiple Choice
• 1 hour and 45 minutes to complete
• Exam Weight 30 of final grade
• Use study aids at end of each chapter
• Use self-tests and quick quizzes in BookOnCD or
  online at Course Technology site.
• Review slides presented in class
• Take prototype exam and check answers
• Email me if you have questions or need
  clarifications

4
2 Computer Hardware

• KEY CONCEPTS
• Main components of computer system
• Microprocessor CPU ALU
• Memory vs. storage
• RAMROMEEPROM
• Magnetic vs. optical storage

5
2 Computer Hardware

• A critical difference between data in RAM and
  data on the hard drive is that data in RAM
  _____________ and data on the hard drive
  _____________.
• is numeric only. can contain letters and special
  characters
• is directly accessible to the CPU. is stored for
  future access
• can be compiled. is machine code only
• is binary. is ASCII

6
3 Computer Software

• KEY CONCEPTS
• Application Software vs. System Software
• Utilities
• Common classes of applications/suites
• document production
• spreadsheet
• database
• graphics
• entertainment
• Vertical vs. Horizontal Applications

7
3 Computer Software

• A critical difference between System Software and
  Application Software is that System Software
  _____________ and Application Software
  _____________.
• is written in C. is written in Java
• can access the Internet. can use only local data
• manages the computers resources. allows end
  users to use of the computer to accomplish tasks
• is based on a command line user interface. uses
  a GUI (Graphical User Interface)

8
4 Operating Systems File Management

• KEY CONCEPTS
• What is an operating system?
• What is a BIOS?
• What is the OS kernel?
• What is a file system?
• How are files stored?
• What is the bootstrap routine?

9
4 Operating Systems File Management

• A critical difference between a computers BIOS
  and Operating System software is that the BIOS
  __________ and the Operating System __________.
• acts as the master controller for the computers
  input and output functions. manages the user
  file system
• contains essential input and output functions
  that get the computer started. acts as the
  master controller for all activities that take
  place within a computer system
• manages the computers resources. allows end
  users to use of the computer to accomplish tasks
• is loaded from ROM. is loaded from RAM

10
5 LANs and Wireless

• KEY CONCEPTS
• LAN vs. WAN
• Wired vs. Wireless LANs
• Standards
• Topologies
• LAN security considerations

11
5 LANs and Wireless

• A critical difference between a wired LAN and
  wireless LAN is that a wired LAN ____________ and
  a wireless LAN ___________.
• has a low error rate from interference.
  encounters significant environmental interference
• has no security issues. has significant security
  issues
• uses standard communication protocols. uses
  proprietary communication protocols
• allows direct access to the Internet. require a
  wireless router to access the Internet

12
6 The Internet

• KEY CONCEPTS
• Internet vs. World Wide Web
• Domain name IP address DNS
• Internet protocol stack
• Client-server technology
• What is a packet?
• Data transfer through the Internet

13
6 The Internet

• A critical difference between a LAN and the
  Internet is that a LAN ____________ and the
  Internet ___________.
• cant be accessed directly by end users. allows
  end user access via a browser
• is typically owned and operated by a single
  individual or institution. is a wide area
  network that has no single owner/operator
• has no standards for communications. is based on
  well-defined communications standards
• uses a protocol. uses no defined protocols

14
7 The Web and Internet Applications

• KEY CONCEPTS
• Application protocols their purpose
• HTML, SMTP, FTP,
• URL and its components
• Cookies and their use
• E-Commerce.... security considerations
• E-mail basics of operation
• standard mail vs. web mail
• Symmetric Key vs. Public Key Encryption

15
7 The Web and Internet Applications

• A critical difference between the World Wide Web
  and the Internet is that the World Wide Web
  __________ and the Internet _________.
• is the data. is the network
• is global.... is local
• uses search engines to find documents. uses
  routers to find documents
• contains many different types of documents.
  contains only text and numeric documents

16
8 Digital Media

• KEY CONCEPTS
• Analog vs. digitized sound and pictures
• Digital audio sampling digitization
• Bitmap graphics vs. vector graphics
• Resolution and color depth
• Compressed vs. raw images
• Digital video basics

17
8 Digital Media

• A critical difference between bitmap graphics and
  vector graphics is that bitmap graphics
  __________ and vector graphics _________.
• cannot be edited. can be manipulated directly
• has superior color depth. has limited color
  palettes available
• is optimized for image storage. requires vast
  amounts of storage for simple images
• specifies attributes for each pixel. specifies
  attributes for each object

18
10 Information Systems

• KEY CONCEPTS
• Transaction processing Management information
  decision support system
• SDLC waterfall. purpose and key phases
• Planning build team, scope project
• Analysis decide what must be done
• Design decide how to do it
• Implementation do it and test it
• Maintenance operate, fix, improve it

19
10 Information Systems

• A critical difference between System Analysis and
  System Design is that System Analysis __________
  and System Design __________.
• describes how the systems processes data.
  describes what data the system uses
• determines what to do. decides how to do it
• defines the systems look and feel. defines the
  systems operation
• is done before the project team is formed. is
  done by the project team

20
11 Databases

• KEY CONCEPTS
• What is a database and how is it used?
• Flat file vs. relational model
• Tablesrecordsfields
• Data management tools and applications
• Data independence
• Distributed database basics
• SQL basics

21
11 Databases

• A critical difference between a flat file
  database and other database models is that with
  flat files ____________ and other models
  ___________.
• have no structure. are hierarchically structured
• can be edited/updated with a simple text editor.
  require a database application to update data
• each record is an independent entity. establish
  relationships between database records
• are simply lines of text. use a structure of
  tables, fields and records

22
12 Computer Programming

• KEY CONCEPTS
• Source codemachine code compiler
• High-level language vs. low-level language
• Problem statementalgorithmcoding
• Development tools editors IDEsVDEs
• Procedural programming
• Object-oriented programming

23
12 Computer Programming

• A critical difference between source code and
  machine code is that source code ___________ and
  machine code ___________.
• is plain text. is encrypted
• is created by humans. is created by programs
• is machine dependent. is operating system
  dependent
• supports decision branches and different data
  types. only supports straight-line execution
  using numeric data