CSE 101 -- Midterm Review Sheet -- Summer 2001

  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