MCC - CIS105 - Study Guide for Test 2

Completion of the study guide is NOT required, so it will not be turned in or submitted electronically. However, completing the study guide will help students prepare for the exam. In addition, the completed study guide may be used on the actual exam, because exams are open book and notes. If you can't find the answer to any of the questions, please feel free to ask your classmates and/or instructor.

Chapter 2

Input



Examples of input devices



ADA



Examples of Assistive technology (also see Assistive Technology Lab)



How are international characters entered in Word?



Multi-media reader



Output



Softcopy



Hardcopy



Examples of output devices



pixel



resolution



dot pitch



refresh rate or scan rate (CRT)



response time (LCD)



Differences between integrated video and expansion card video.



GPU



DVI



DPI



Differences between impact and non-impact printers





Differences between inkjet and laser printers





Portrait orientation



Landscape orientation





Chapter 6

Secondary storage



Primary storage



read/write heads



access arm



head crash



format







partition



track



sector



cluster



cylinder



MZR



FAT



NTFS



MFT



access time



    seek time



    head switching



    rotational delay (latency)



data transfer rate



RPM



hard disk controller



fragmented disk



How is access time impacted by a fragmented disk (seek time and rotational delay)?



RAID



RAID Level 0



RAID Level 1



List and define optical storage technology for CD and DVD







DVD - Dual Layer



Magnetic Tape uses



Flash Memory Cards



Why are some reasons for backuping data and/or systems?





Chapter 12

network



List some benefits of networks



Examples of communication equipment / devices



Modem



NIC



communication channel / media



physical media



    twisted-pair



    coaxial (coax)



    fiber-optic



wireless media



    Wi-Fi (802.11)



    microwaves



bandwidth



analog signal



digital signal



broadband



baseband



simplex



half-duplex



full-duplex



asynchronous



synchronous



LAN



hub



router



gateway



network topology



Features, advantages, and disadvantages of the following:

    Star:



    Bus:



    Ring:





WAN



firewall



communication software



Client/Sever uses



Peer-to-peer Network



communication protocol



TCP/IP





Powerpoint

The difference between outline and slide panes in Normal View :

    Slide pane



    Outline pane



Speaker notes view



Slide sorter view



Slide show view



Template options for new presentations



Slide layouts



Placeholders



Design theme



Promote text



Demote text



Graphical options to emphasize text



Slide transitions



Custom animation



Master slides



Printing options (Slides, handouts, etc)



Excel

cell



cell address



range



labels



values



formulas



functions



function arguments



arithmetic operators



order of operator precedence



comparison (logical) operators (see If function)



relative cell referencing



absolute cell referencing



Main chart types and their uses







X-axis



Y-axis

---

Revised: 09/30/2009 - www.mc.maricopa.edu/~marquez/cis105/study_guide02.html