notes from class

qccs012.blogspot.com

VBA
Visual Basic for Applications

macros
record a macro by Doing it
behind the scenes generates VBA code

1) Find all three-letter words, which have a vowel as the middle letter
<[a-zA-Z][AEIOUaeiou][a-zA-Z]>

madamimadam

a man, a plan, a canal, Panama

bits, bytes

bit: binary digit
0, 1

8 bits = 1 byte
4 bits = nibble
2 bytes = word
2 words = dword

1 KB (kilobyte) = 1000 bytes, 10^3 bytes, 1024 bytes, 2^10 bytes
1 MB (megabyte) = 1 million, 2^20 bytes
1 GB (gigabyte) = 1 billion, 2^30 bytes
1 TB (terabyte) = 1 trillion, 2^40
peta
exa
http://en.wikipedia.org/wiki/Petabyte

kilohertz

1 bit, can only store 0 or 1


combining bits together to encode bigger nums

tell me what these nums mean in decimal
HW:
Convert these binary numbers to decimal
11011
111
11
1011011

Preparation for the Word Exam

Here is a prep document.
The file for the practice exam.
And the practice exam.

Homework 4

Chapter 3, hands-on exercise 2
Chapter 3, practice exercise 1, 2, 3, 4

Record a macro in a DOCM file

Tutors, and that there is no class next week

http://www.cs.qc.edu/tutors.html

And we skip next week, and meet the week after.

Regular expression homework

Write regular expressions in Microsoft Word for each of these things
1) Find all three-letter words, which have a vowel as the middle letter.
2) Find all three-letter palindromes
3) Find all four letter words which begin with the letter K
4) Transform active voice to passive voice. That is, find sentences such as:
Jim kissed Pam.
and replace it with
Pam was kissed by Jim.
For this last one, what goes in the find what box, and what goes in the replace with box?

notes

three types of formatting
character formatting
paragraph formatting
section formatting

insert section break


how do i show file extensions?


wildcards and regular expressions in Microsoft Word

*
?

http://en.wikipedia.org/wiki/Wild_card_(card_games)

http://office.microsoft.com/en-us/support/add-power-to-word-searches-with-regular-expressions-HA001087305.aspx?redir=0

http://office.microsoft.com/en-us/support/putting-regular-expressions-to-work-in-word-HA001087304.aspx?redir=0