CSE 101 -- Midterm Review Sheet -- Summer 2001
- Chapter 1 -- Computer Continuum
analog, digital
special purpose, general purpose
mechanical, electronic
why binary?
hardware, software
definition of a computer
- 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
- 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
- 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
- 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
- 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
- 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