|
I. Hardware - physical components
A. Chips
1. ROM
2. PROM
3. EPROM
4. EEROM
5. RAM
6. CMOS
7. CPU - micro processor
a. I/0
b. Arithmetic
1). ^
2). unary
3. *,/,\,mod
4. +,-
5. ()
c. Logic
1). >
2). <
3). >=
4). <=
5). <>
6). =
7). And
8). Or
9). Not
10). Xor
B. Mother Board
1. Expansion Slots
2. NIC
3. Modem - Modulate -demodulate
4. Serial port - mouse
5. Parallel port - printer
6.
C. Computer sizes
1. PDA - palm hand held
2. PC - micro computer|
3. Mini - IBM AS400
4. Main Frame
5. Super computer
D. Auxiliary Storage
1. Floppy Drive - magnetic - random
2. Hard Drive - magnetic -
random
3. CD -ROM - laser light read pit in
surface - Read Only
4. CD RW laser light excites magnetic
field - random - Read/Wrtie
5. Flash Memory - voltage -random
6. Tape - magnetic - sequential
E. Monitors
1. Standard -
a. Pixels -
dots on screen more pixel better the picture
II. Operating System
A. System Tools
1. Format -
a. address
b. tracks and
sectors
c. FAT
d. BIOs
2. Clean Disk
3. DeFrag
4. Back Up
a. start up
disk
b. Full Back
Up
c.
Incremental
B. Explorer - file manager
1. Folders
2. Files
a. Move
b. Copy
c. Delete
d. Rename
3. Click, Shift-Click
4. Ctrl-Click
| 5. Right-Click
6. Alt-PriScn
7. Alt-Tab
C. Code
1. ASCII- American National Standard
Code for Information Interchange
a. 8 binary
digits = Byte
b. Byte =
A to Z, a to z, 0 to 9, American Punctuation
c. Run on all
american PC's.
D. Files
1. .exe - executable file - binary
format
2. .doc - word document data
file
3. .mdb - access database data
file
4. TIFF - graphic - embed or link
5. JPG graphic embed or
link
6. BMP - paint graphic embed or
link
7. .TXT - notepad data file
III. Networks
A. LAN - local area network
B. WAN - wide area network
C. Internet - publicly owned world wide network
D. Intranet - privately owned world wide network
E. ISP
F. Browser
G. HTTP, HTML
H. Client/Server
I. Peer to Peer
IV. Word
A. Key Strokes
1. backspace
2. Home
3. Ctrl-Home
4. Ctrl - End
5. End
6.
B. Tool bars
1. Standard
a. format
painter
1). multiple objects
2). single object
b. save
c. Print
d. copy
e. Paste
f. cut
g. spell
check
h. print
preview
i. hyper link
j. show and
hide
k. Zoom
l. undo
m. redo
2. Formatting
a. increase
indent
b. decrease
indent
c. Numbered
list
d. Bulleted
list
e. Fonts
1). Point size
f. Bold
g.. Underline
h.
Italic
i. Left align
- default
j. Center
k. Right
Align
l. Justify
3. Drawing
a. word art
b. insert
picture
c.
4. Picture
a. crop
b. sizing
c. Text
wrapping
d. contrast
e. brightness
C. Formatting
1. Tab alignment - how do you set
a. Left
b. Right
c. Center
d. Decimal
e. vertical
bar
10. Tables
a. row and
columns
b. borders
and shading
11. Header/Footer how to use and get
to
12. Hard copy - printed copy
E. Mouse actions
a. with right pointing arrow on left
margin
1). single
click
2). double
click
3). triple
click
b. I beam
c. cursor
F. Menus
a. Find and Replace
b. clipboard
c. task pane
d. templates
a. library
b. online
G. Spell Checker
a. red wavy
line
b. green wavy
line
c. add words
H. Misc
a. file save
as - redirect location and/or change name of file
b. Smart tag
c.
AutoCorrect
d. status bar
e. title bar
f. auto page
break - adjust dynamically
g. move text
- highlight, click and drag
h. cut and
paste to another document - how do
i. hanging
indent
j. section
and section breaks formatting
k. vertical
alignment
l. columns
1). snaking
2). continuous break
3. line down the center of the columns
m. Symbol
1). special characters
2). symbols
n. Web page -
o. Mail
Merge
p.
Source document
q.
Envelops, Labels, Letters
r. Data source - access table, word table, comma delineated file
Excel
1. used for spreadsheet, general ledger, what if scenarios.
2. VisCalac 1st spreadsheet = 1981 ran on apple ii2
3. Lotus 123 1982 IBM PC
4. Excel 1991
5. 255 column by 65536 rows by 255 sheets make up an excel workbook
6. Text is aligned left by default
7. Number are aligned right by default
8. Auto Complete is used with Jan to Dec, Mon to Sun, Qtr 1 to Qtr 2, etc.
9. Auto Fill is used to copy and to sequence numbers by filling in the first
cell and the the increment number in the second cell and then using auto fill to
sequence.
10. Relative relationship copy changes the formula relative to the cell that it
is copied to.
11. Absolute relationship copy keeps the formula or part of the formula the same
when copied.
12. F4 is the absolute key $ is symbol used to have a absolute copy.
13. all formulas and functions begin with an = sign
14. f5 is the go to key
15. Ctrl Home take you to the first cell a1
16. Cells are referenced by Column and Row
17. =Sum(), =Max(), =Min(),=Average() what goes inside of the
parenthesis is called the argument and is usually a range of cells.
18. =Sum(A1:B15, C12, B345:C543) A!:B15 is a contiguous block of
cells called a range.
19. Charts
20. Pie Chart
21. Line Chart
22. Column Chart
23. X axis, Y axis, title, legend, grid,
24. Imbedded vs link graphic or chart
25. Format, Cell, center across selection, indent
26. if(cond,True,False) can be nested only seven deep.
27.
|