Preparation for Word Exam (in two weeks)

Practice Word Exam.

Word practice exam file,

Walkthrough:

Homework:
Word Ch 3, practice and mid-level exercises
Access Ch 1, practice and mid-level exercises

Quiz:
based on Word ch 3 multiple choice
based on Access ch 1 multiple choice

What is a database:
data + methods of interacting with your data
a collection of tables
what is a table?
a collection of records
what is a record?
a collection of fields
what is a field?
approx same as column in Excel, one unit of data

SELECT DISTINCTROW TOP 10 Products.ProductName AS TenMostExpensiveProducts, Products.UnitPrice
FROM Products
ORDER BY Products.UnitPrice DESC;

Times New Roman: serif, proportionally spaced

Arial: sans serif, proportionally spaced

Courier New: serif, fixed width font

Homework:
Convert these binary numbers to decimal:
1011
1101
110
1000

Count from 0 to 20 in binary.

In Exploring book,
Word Ch 2, practice and mid-level exercises
Excel Ch 2, practice and mid-level exercises

For quiz next week:
Based on:
multiple choice from Word Ch 2, Excel Ch 2
One question where you need to convert a small binary number to decimal. (E.g., what is 101 in decimal?)

A1 reference style
R1C1 reference style


Homework:
Word Ch1 practice and mid-level exercises

Quiz next week based on:
a) quick-checks in Concepts book
b) multiple choice at end of Word Ch 1
c) keyboard shortcuts homework

WYSIWYG

Show Hide Paragraph
Shift-F1 is reveal formatting
Alt-F9 is show Word Fields

Windows Essentials
http://windows.microsoft.com/en-US/windows-live/essentials-other-programs

Security Essentials
http://windows.microsoft.com/en-US/windows/security-essentials-download

Pandora.com
free music station, adjusts to your likes and dislikes


http://www.pearsonhighered.com/exploring/

HW:
make sure you get the books
Windows section, ch 1 Practice and Mid-Level Exercises at end
pg 45-48
This one is NOT to hand in
Excel ch1, Practice and Mid-Level exercises at the end
in my book, pg 364 and on

next week, we will have a quiz
for this first quiz, I will keep it simple.
all questions will be drawn from the mult choice sections of
the two chapters mentioned in the homework, namely on Windows 7 and on Excel.

Direct links to cheap versions of the books

for $13, the Grauer Book (Exploring)
http://www.amazon.com/gp/offer-listing/0136122329/ref=sr_1_1_up_1_spi_olp?s=books&ie=UTF8&qid=1359911531&sr=1-1&condition=used

For $0.01, the Computer Concepts
http://www.amazon.com/gp/offer-listing/1423906101/ref=dp_olp_used?ie=UTF8&condition=used

universal computer


von Neumann architecture

1. Say "please enter a #"
2. Get the number, store it in X
3. Say "please enter a #"
4. Get the number, store it in Y
5. Add X and Y, store it in Z
6. Say X " plus " Y " is " Z
7. Go to Step 1
fetch-execute cycle
IP (instruction Pointer)
1

X: 3

Y: 9

Z: 12