Term
| Substitution Cipher w/ one-time pad |
|
Definition
| Create two identical books (pad) with randomly generated letters. Keep one, give one to ally before deployment (picking letters from bag in Scabble) |
|
|
Term
|
Definition
| Used to encrypt messages. Two distinct random (large) prime numbers - keep secret. Generate public and private keys. Both message and key can't be sent using channel with eavesdropper(internet). Decryption is impractical. Need to guarantee authenticity of public key. |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
| Simple substitution cipher |
|
Definition
Pros: easy to understand and implement
Cons: have to send private key before submission, easy for enemies to decipher |
|
|
Term
|
Definition
| finding and correcting errors within a program. Step into to find error in your code |
|
|
Term
|
Definition
UIUC provided: net files.uiuc.edu.compass
Cloud/commercial: synchronizing (googel doc) and computer backup (mozy)
local: apple time machine |
|
|
Term
|
Definition
| data, cell ranges, other functions. Some have fixed others have variable numbers. |
|
|
Term
|
Definition
Uses parentheses, behaves as function so returns a value and string.
InputBox(prompt, {title}, {default}) |
|
|
Term
|
Definition
MsgBox (prompt, [button], [title])
Behaves as subrocedure and function, gathers data |
|
|
Term
|
Definition
| takes in 0 or more arguments, returns one value, called with parentheses |
|
|
Term
|
Definition
| takes in 0 or more arguments, returns NO values, called WITHOUT parentheses, private or public |
|
|
Term
|
Definition
|
|
Term
|
Definition
| clears only formatting, not contents |
|
|
Term
|
Definition
| clear contents, not formatting |
|
|
Term
|
Definition
| Used to decrypt message, very difficult to derive form public key and message |
|
|
Term
|
Definition
| Used to decrypt message, very difficult to derive form public key and message |
|
|
Term
|
Definition
Annual interest rate/12 - per month, Period (years), loan amount
-PMT(C16/12,C17*12,C15) |
|
|
Term
|
Definition
range to check for condition, counts number of cells that fulfill condition
(A:A, ">10") |
|
|
Term
|
Definition
= equal
<> not equal to
< less than
> greater than
>= greater than or equal to
<= less than or equal to |
|
|
Term
|
Definition
row first, then column
Cells(3,1) = R3C1
B3 = Cells(3,2)
RC Cola |
|
|
Term
| Merlin Mann's backup rules |
|
Definition
| not automated, not redundant, not regularly rotated off-site |
|
|
Term
|
Definition
| cell that is referenced in a formula, then formula doesn't change |
|
|
Term
|
Definition
| Easy to carry, loose, steal. Hold entire semester of work. Easily corrupted and hard to recover. |
|
|
Term
|
Definition
| hardware failure, malware infection, user mistake |
|
|
Term
|
Definition
signers are known as certificate authorities. Public keys used to check signatures
private key is stolen, fake public keys can be created.
If public keys are tampered with you can accept forged signatures. |
|
|
Term
|
Definition
| Looking for exact match. Doesn't have to look for ascending order. |
|
|
Term
|
Definition
| cell reference not valid. Refer to cell AB or add word to number cat +1 |
|
|
Term
|
Definition
| column not wide enough, with number will convert to scientific notation |
|
|
Term
|
Definition
| range for cells to fulfill criteria, criteria sums cells that fulfill it. (A1:A5, ">10") |
|
|
Term
|
Definition
| makes a change to something, does things. |
|
|
Term
|
Definition
| run one procedure from another procedure. Call even if stored in another module/worksheet. Call sub procedure by wring name if necessary. |
|
|
Term
|
Definition
| Assigns a command to something, things you can get/set |
|
|
Term
|
Definition
flow of program is determined by events (mouse click)
responds to user-intitated events such as keystroke or click, opening up workbook |
|
|
Term
| Simple Substitution Cipher |
|
Definition
| switch every letter with another letter, give ally key in private |
|
|
Term
|
Definition
| do reverse function (modular subtraction). Never use same line of pad. |
|
|
Term
|
Definition
| for each letter in your message, perform a function (modular addition) using one letter from pad |
|
|
Term
|
Definition
| = _____(value - function may return error, value if error- returns if first argument returns error) |
|
|
Term
|
Definition
| Don't run unless triggered by event. Use button-click events to execute our code. Programs ability to respond to events form basis of event-driven programming. |
|
|
Term
|
Definition
| code that runs in response to the event aka event handler |
|
|
Term
|
Definition
| any action that is recognized by an application such as Excel (open or close workbook, click command button, change date in cell) |
|
|
Term
|
Definition
| Uses (), has return value, returns range object |
|
|
Term
|
Definition
| Uses (), returns value, returns cell object, cells (row, column) |
|
|
Term
|
Definition
| largest value less than or equal to, ends with column number |
|
|
Term
|
Definition
| changes the cell reference |
|
|
Term
|
Definition
| Looking for approximate match. Need to look for ascending order. |
|
|
Term
|
Definition
|
|
Term
|
Definition
| counts cells with numbers |
|
|
Term
|
Definition
series of letters and numbers. "True", "False" - has " "
ex) Teaching, Course105, 1-727-487-2775 |
|
|
Term
|
Definition
joins together two strings.
ex) MsgBox "Hello" & Range("A1").Value |
|
|
Term
|
Definition
| If true returns false, if false returns true |
|
|
Term
|
Definition
| Returns true unless all conditions or false |
|
|
Term
|
Definition
| Need both conditions to be true in order to be true |
|
|
Term
|
Definition
| =____(condition, output 1 - true, output 2 - false) |
|
|
Term
|
Definition
| cell reference that changes automatically when it is copied |
|
|
Term
| Absolute/Mixed Cell references |
|
Definition
| exact location on the worksheet and doesn't adjust when copied. Column and/pr row preceded by $ doesn't change |
|
|
Term
|
Definition
formula references itself either directly or indirectly
ex) In C3 and want to know C3-B1 |
|
|
Term
|
Definition
Condition true - value after first comma
Condition false - value after second comma
= _____(logical test, true, false)
ex) =____(A32>B32, "Yes", "No") |
|
|
Term
|
Definition
| formula divides by 0, happens when dividing by empty cell |
|
|
Term
|
Definition
problem occurs with a number.
ex) SQRT(-45) |
|
|
Term
|
Definition
| evaluate inner parts and then overall formula. Test two conditions. Lookup the match for something in one table then lookup the match for that in another table. |
|
|
Term
|
Definition
Fill in "is - :)" or "is not - :("
=IF(D36- inner most formula and work your way out |
|
|
Term
|
Definition
program elements that the program manipulates (worksheet, chart, cell, command, range)
- Properties(caption, name)
- Methods(select, delete, add, clear)
- Refer by names(cmdCopy) |
|
|
Term
|
Definition
| stores data organized in cells and can do complex data manipulation. Workbooks contain these. |
|
|
Term
|
Definition
|
|
Term
|
Definition
takes value on right and assigns it to the left
[cell reference].Value = expression
Range("B3").Value=9 |
|
|
Term
|
Definition
| series of instructions for the computer to do some task |
|
|
Term
|
Definition
user recorded VBA programs.
Pros: no programming needed, easy to use
Cons: only replays recorded task, no random task, no logic |
|
|
Term
| Flawed Assignment operator |
|
Definition
|
|
Term
|
Definition
| makes it available to everything. use m in front to signify. |
|
|
