CSE 101 -- Final Exam Review Sheet -- Summer 2001

Early Course Material -- Covered on the Midterm -- Review but not the major focus

1. Chapter 1 -- Computer Continuum
   analog, digital
   special purpose, general purpose
   mechanical, electronic
   why binary?
   hardware, software
   definition of a computer
   
2. Chapter 2 -- Computer Continuum
   types of information (numeric, character, visual, audio, instructions/program)
   binary representation of numbers, including translation between binary and decimal, binary digits (bits), etc.
   number of patterns for a given number of bits
   representing information inside a computer, encoding
   ASCII representation of characters
   representation of pictures, pixels
   
3. Chapter 2 -- Computer Continuum PLUS MS Word -- Right Phit Lab Book
   word processing
   margin, paragraph, page, header, footer
   cut, paste, copy
   find, find and replace
   formatting: font style, size, bold, underline, italics, sub/super scripts
   justification: center, right, left, justify
   columns, lists (bulleted and numbered), tables
   spelling/grammar checking
   word wrap
   
4. Chapter 3 -- Computer Continuum
   von Neumann computer: (4 basic components) input, output, processor, memory
   stored program
   input devices (keyboard, mouse, microphone, scanner, etc.)
   output devices (screen, printer, speakers, etc.)
   primary/main memory (RAM), secondary memory/storage
   memory technologies - magnetic, electronic, optical
   seconday storage devices (floppy, CD-ROM, DVD, hard disk
   disk, drive
   storage measures: speed, cost, removable/nonremovable, size, type of access (sequential or random)
   bit, byte, kilo, mega, giga, tera, word
   parallel, serial
   types of computers - microcomputer (PC), workstation/minicomputer, mainframe computer, supercomputer (cost, speed, complexity, size)
   ROM, RAM
   
5. Chapter 4 -- Computer Continuum
   why are programming languages needed for communicating with computers
   semantics, syntax
   5 generations of programming languages - machine language, assembly language, high-level language, query language, natural language
   assembler, interpreter, compiler
   algorithm
   bug, debugging
   translation
   source code, object code
   
6. Right Phit Lab book - MS Excel
   what is a spreadsheet, dynamic property of spreadsheets
   cell, row, column, cell reference/address
   formulas
   formula bar
   arithmetic operators in formulas +, -, /, *, ^
   order of evaluation in formulas, parentheses
   relative vs absolute addresses (incl. mixed)
   value
   AVERAGE, SUM functions
   workbook, worksheet
   
7. Right Phit Lab Book - MS Windows
   Window, border, title bar
   minimize, maximize
   start menu
   icon
   desktop
   folder, file, hierarchical organization of files
   drive
   task bar
   Windows Explorer
   GUI, interface, operating system

Material Covered Since the Midterm -- Major Focus of Final Exam

1. Ch 5 -- Computer Continuum
   Hardware and Software
   What is a computer program
   Where must a computer program be in order to run it
   
2. Ch 6 -- Computer Continuum
   Operating Systems
   What is an OS?
   What does it mean to boot a computer (warm/cold boot)
   Different OS interfaces (command line or text/GUI)
   File systems (flat/hierarchical)
   Platform, cross-platform issues -- different OSs (Mac, Windows, Linux/Unix)
   Context switching, multitasking, multiprocessing
   Some of the tasks of an OS (file mgt, interface, memory mgt, resource mgt, etc.)
   
3. Ch 7 -- Computer Continuum
   Networks and communication
   What is a network
   Types of physical network connections (twisted pair, coaxial cable, fiber optic)
   Types of wireless network connections (microwave, radiowave, infrared)
   LAN, WAN, Internet, intranet
   Protocols (use, definition, examples (http, ftp))
   Packets -- how information is divided up
   Simplex/HalfDuplex/Fullduplex, asynchronous/synchronous
   IP address
   
4. Ch 8 -- Computer Continuum + lab and notes on HTML
   Internet and WWW
   What is a web page
   WWW vs Internet
   Basic HTML -- structure of a simple web page
   What simple tags do (I, U, B, BR, P)
   Start/end tags
   What is a link on a web page?
   Pictures on web pages
   Domain types (gov, org, edu, com)
   hypertext, hypermedia, multimedia
   
5. Ch 10 -- Computer Continuum + MS Access Right Phit Lab Book
   Databases
   What is a DB? Structure: file, table, record, field
   Components of a DB: table, form, query, report
   Wizard
   Implications of DBs -- social, privacy issues
   Methods of collecting data (scan, enter manually, web)
   Advantages and disadvantages of DBs
   
6. Ch 12 -- Computer Continuum + web sites from class
   Artificial Intelligence
   What is AI?
   AI Successes
   Natural language understanding and AI, AI complete
   Heuristics, common sense
   Game playing computer programs, search, similar/diff from humans
   Advantages, disadvantages, social implications
   Kismet, wearable computing
   
7. Ch 13 -- Computing and Teaching
   Role of computers in education
   Social implications, distance learning
   On-line testing, course materials
   Tutoring systems
   Virtual campus
   
8. Ch 14 -- Computer Continuum
   Ethics, Privacy
   Ethical issues with electronic storage of data
   Computer Crime (examples), hacking, cracking
   Footprint, backdoor, theft of goods and money
   Trojan horse (insert bad info into program)
   salami slicing (spread trivial crimes over long haul)
   Piggybacking (ride in behind legit user)
   Data diddling (swap one piece of info for another
   Pirating software
   Viruses, vaccines, worms (not self replicating)
   ILOVEYOU (Melissa virus), email issues
   Internet crime: DDOS (distributed disruption of service)
   On the job tracking of "productivity" with electronic tools, surveillance
   issues with electronic databases