CGS2060/CGS2100

Summer C 2009

Test 1 Study Guide

1. How are vector graphics stored

2. How are Digital Graphics represented

3. AM, FM, and Satellite Radio

4. Audio compression Formats ( MP 3)

5. Know the difference between a blog and a podcast

6. WiFi, VPN (Virtual Private Networks), LAN, WAN, WiMAX

7. What is Bluetooth, GPS, and RFID

8. What do most international cellular carriers use as their network standard?

9. On a computer, what is a cookie used for

10. HTTP, SMTP, TCP/IP

11. Difference between a Client and Server

12. Difference between cable modem, dial-up, and DSL

13. Primary infrastructure of the internet

14. Software Systems Requirements

15. Productivity , Management Information Systems, Personal Information Systems, spreadsheets, database, word processors, and graphics software

16. Operating system, open source software, executable files, programming language,

17. Hard Disk, Flash Drive, Blue Laser Disk, DVD, CD

18. Moore’s Law

19. 32 – bit processor vs. 64 bit processor

20. Dual core CPU vs. Quad core CPU

21. Kilohertz, Megahertz, Gigahertz, Terahertz

22. RAM, ROM, CMOS

23. ASCII

24. What are binary numbers

25. Kilobytes, megabytes, gigabytes, terabytes, petabytes

26. Components of a Computer Based Information System

27. Decision Support System, Transaction Processing System, Expert System, Management Information System

28. Social implications of Information Technology

29. Know how to open and edit a Word 2007 document

a. Insert dates

b. Insert and manipulate images

c. Insert page breaks

d. Use styles, fonts, background colors

e. Insert and use citations

f. Set and use headers and footers to include page numbers.

g. Check for spelling and grammar errors

30. Know how to open and edit an Excel 2007 document

a. Cut and paste data into cells

b. Format cells

c. Use functions like sum, average, and number formats

d. Merge cells together

e. Borders and shading

f. Adjust columns and rows

g. Insert pie/graph charts