Chapter 4 through 7 Review Topics Chapter 4 Input and Output

Download 16.28 Kb. Date 31.07.2017 Size 16.28 Kb. #25726

Chapter 4 through 7 Review Topics Chapter 4 – Input and Output Two most common input devices – keyboard & mouse Keyboards Qwerty vs Dvorak Ergonomic keyboard Mobile device keyboards Keyboard layout Alphanumeric/cursor movement/numeric pad/function key/modifier keys Esc/Window/Scroll/delete/backspace/insert Mice Mechanical mouse – rolling ball Optical mouse Trackball/joystick/game pad Other input devices Microphone Digital camera/page scanner/barcode scanner – resolution/storage Graphics tablets – stylus or pen New ink pen on paper captured digitally – see LiveScribe or Wacom Inkling Touch screens RFID tracking Biometric reader Common output devices Monitor – pixel/RGB/dot pitch CRT Flat-panel Printer – monochrome/color:KCYM Ink-jet Laser-ject Impact printers Thermal printers Dye-sublimation printers Projectors Plotters – large format documents such as architectural drawings Chapter 5 – System Software – helps manage hardware and software on system OS Devices that need OSs – all Functionality of OS User interface Command line GUI Desktop Ribbon File management Services Kernel Device drivers Boot Virtual memory – where/speed Common products Windows DOS/Windows 1.0, 2.0, 3.0,3.1 Windows 95/98/98 SE/ME – called the Windows 9x series Windows XP/Vista/7/8 Windows NT/Windows 2000/Windows 2003 Server/Windows 2008 R2 Server Mobile/Embedded/Auto/Compact Mac OS X – Tiger/Leopard/Snow Leopard/Lion/Mountain Lion Linux LAMP Linux Apache Web server – most used web page server MySQL – full featured open source relational DB PHP Most common distributions - Red Hat/Fedora/SUSE/Ubuntu/Debian UNIX – late 1960s IBM mainframe – System 390 z/OS Netware – first file servers Utilities File management Scan/defrag/compression/encryption Security – Anti-virus/spam/spyware/intrusion detection Firewall Ch 6 - Application Software – what is useful for user/specific tasks Acquiring software Software license Commercial – shrinkwrap/site licenses Shareware – try before you buy; honor system Freeware – use “as is” Public Domain – abandoned; modified, distributed Open Source – source + executable DVD/Online/Bloatware Local vs remote software and data Cloud computing SaaS, PaaS, IaaS ASPs (Application Service Providers) are the main purveyors of SaaS Software suites Bundled components Common interface/interaction Lower price MS Office, graphic packages, ERPs, some games Productivity Word processing – character/paragraph/section/page/document Word-wrap Enter key  paragraph Tables Point sizes – 72 points in an inch Spreadsheets – column/row/cell/worksheet/chart sheet/workbook Absolute vs relative addressing - $ used to indicate absolute Fill down/across Ranges – C14:F14, B5:B10, A5:E10 Databases – field(attribute)/row(record)/table/database Forms and reports Queries – questions posed to the DB Most common today - relational Presentation software – frame/slide/slideshow Slide transitions Custom animations Communication IM – synchronous Email – asynchronous Text messaging Twitter – Internet text messaging Searching Social networking software Graphics packages Paint programs – bmp type files, raster graphics, bitmaps Draw programs – vector graphics, resizable, line drawings, Photo-manipulation programs – photo correction, editing, layers CAD – architectural, mechanical, landscaping, tied to numerical control programs Ch 7 - Networking Nodes Types – computer/internet/telephone/TV & Radio/Monitoring/GPS Dual-mode phones 3G or 4G/WiFi CDMA / GSM / LTE / Cellular / Satellite Applications – Videoconferencing/Collaborative/Telecommuting/Telemedicine/Multimedia Topologies – Star/Ring/Bus/Mesh Architecture – Client/Server & P2P Network Size and Coverage PAN TAN LAN CAN MAN WAN Wired connections Twisted pair – phone lines Coax – cable TV Fiber optic – Uses one or more lasers to pulse light down fiber Wireless Cellular radio NFC – near field communications BlueTooth WiFi WiMax Microwave – towers(stations)/satellite Infrared Devices Hub Switch Router Gateway Bridge Multiplexor/Concentrator Repeaters/Range Extenders WAP – wireless access point; think Starbucks Common usage Internet – public network Intranet – behind firewall making it private Extranet – allows tunneling through firewall VPN Telecommuters/Salespeople/Executives/Suppliers/Customers Serial vs parallel transmission Spreadsheets Cell – intersection of row and column Tabs – third dimension Types of data Text/pictures Numeric Formulas and functions Built-in functions – PMT, Sum, Average, Max, Min, many more Cell references Relative addressing – adjusts row or column for fill down or fill across respectively Absolute addressing – use of $ to hold row or column constant in fill opertions Ranges – A1:B8 Dates – 1/1/1900 = day 1 Auto-recalculation based on cell dependencies Charts – pie, column, line, scatter Formatting Data type Font characteristics Fill Borders/Shading Conditional formatting Renaming tabs Worksheets, chart sheets Workbooks John R. North CIT 120 Download 16.28 Kb. Share with your friends: