CS180 Test Review Final ExamDr. Ching-Hua ChuanMay 1 2009Computer Skillsz Microsoft Windows– Folder: meaning, definition, usage– File extension z Internet keyword searchz Microsoft Excel– Cell reference: relative – A3, absolute – $A$3 – Formula, chartComputer Skills (Cont’d)z Microsoft Word– Icons, functions (copy, paste, align text/paragraph)– Margin, clipboard, page break, head note/foot note, indent, numbering, bulletz Microsoft PowerPoint– Slide layout, insert new slides, header/footer, SmartArt, clip art, text box, animationConceptsz General computer concepts (Unit A)– PC, memory, CPU, Internet, E-mail– CPU = Arithmetic Logic (ALU) + Control Unit (CU)z Computer hardware (Unit B)– Input devices (mouse, keyboard…) and output devices (printer, monitor…)– Memory (RAM), Storage (hard drive, CD/DVD, USB)Concepts (Cont’d)z Computer Software (Unit C)– System software (OS, device driver, utility software) and application softwarez Digital Electronics (Unit D)– Bit (either 1 or 0), byte (= 8bits), kilobyte, megabyte, gigabyte…– Processor specification– File locationConcepts (Cont’d)z Networks and Internet (Unit E)– NIC, modem, router– Bandwidth (kilobytes per second, bytes per second) – IP address and domain namez Data Security (Unit F)– Virus, worm, cookiesConcepts (Cont’d)z The Web (Unit G)– HTTP, HTML, hyperlinks– Search engine: good search
View Full Document