CPSC 105 Final Exam Study Guide The final will be non-cumulative. The most important material to study are your lecture notes. Use the book as a reference. The Chapters that pertain to the topics we discussed are Chapters 6, 7, 16, 17, 18, and 20. 1. Programming and Programming Languages Different Styles of Programming languages (study chapter 6). Be able to match existing languages with the purposes they're best suited for (e.g. C is good for systems programming) ** Excel Programming. You will need to be able to write down Excel formulas similar to the ones used in the two Excel assignments. In particular, make sure you know how to use "IF". Sample Questions: What is the difference between a cell containing 3 and a cell containing the formula ="3" ? Write a formula that converts the character in cell A4 into its ASCII value 2. Operating System Understand the difference between an operating system's user interface and its interior workings. ** The Multitasking, Interrupts, and "Context Switch" mechanisms. Difference between personal and professional operating systems. Understand the difference between user and superuser mode ("mode bit") Encryption using XOR, and methods used in assignments. Sample Questions: Explain what happens during a "context switch" Give an example of an interrupt. 3. Networking Principal charateristics of an "ethernet" - difference between ethernet and token ring. ** TCP/IP fundamentals: IP addresses, IP network classifications (A,B,C) and their impact on the future of the internet. Routers. The Ethernet - IP - TCP hierarchy (each protocol deals with communication at a certain level) Related Protocols and their function: DHCP, ICMP, DNS The purpose of ATM technology. Sample Questions: Explain the difference between an ethernet "hub" and an internet "router" Explain why we need IP addresses when each ethernet card already have its own unique hardware address. What is the purpose of the subnet mask? Give an example of how it's used 4. Artificial Intelligence Know about the Turing intelligence test. Read chapter 20 and understand some of the history of AI. Sample Question: True or False: most of the claims made by AI scientists in the 50's and 60's have been realized.