Since the test is rather short and there will be no lecture after the test, if anyone wishes to skip class tomorrow, I will give a makeup exam for Word next week after class, at 12:30. There will be no penalty for skipping the class.

This coming Sunday there will be a proctor coming in to administer the Microsoft Word test. He will likely have to leave at 9:30, so the test will be from 8:30-9:30. Thus, try to come on time.
The test will be very, very similar to the sample test up at the website ( below). I posted a solution to half of the test, and hope to post instructions for the remainder soon.
If you have any questions about any of this, or need help with one of the steps on the sample test, please email me.

Word Exam Sample

For the purposes of this exam, you will create several files.

1) Start Word. Type in the following text:
Dear Sir or Madam:

I am pleased to inforem you that the following students have made the Dean's List:

Hooray for them!

Sincerely,
[Your Name Here]

Save the file as Test2.doc.

Solution:
Start/Run/Winword
Highlight the text from the webpage. Edit/Copy. Move to Word. Edit/Paste.
Change [Your Name Here] to whatever your name is.
File/Save, and specifiy Test2.doc

2) Change the font of "Sincerely" to be Courier point size 14. Italicize the word "following." Make the font color for "Hooray for them!" red and the background color of these words blue.
Solution:
To change "Sincerely," highlight that text. Then, Change the Font From Times New Roman to Courier New. In the box right next to it, change 12 to 14.
Highlight "following." Click on the I button.
Highlight "Hooray for them!" To the right side of the toolbare, there are two icons, one to change the font color and one to set a background color. Use those.

3) Run spell-check to correct any errors in the document.
Solution:
Either right-click on misspelled words and choose the correct word, or else Tools/Spelling and Grammar... and then choose Change.

4) Insert a page number for the document.
Solution:
Insert/Page Numbers.../ OK

5) Add a page header, and type in Courier Bold, Centered, the words "Office of the Dean"
Solution:
View/Header and Footer. Click the center icon. Change the font to Courier. Click the Bold icon. Type "Office of the Dean."

6) Change the top and bottom margins of the page to be .25 inches.
Solution:
File/Page Setup
Change "Top" from 1 to .25
Change "Bottom" from 1 to .25

7) Insert a Table before the sentence "Hooray for them." The table should be 6 rows and two columns. Make up the names of 5 students. Make the first row the title of the columns (Name and GPA). For the remaining 5 rows: In the first column enter the student's name and in the second column enter the student's GPA.
Solution:
Table/Insert/Table
Set Number of Rows to 6
Set Number of Columns to 2


8) Save the file again.
Solution:
File/Save

9) Save the file as Test3.doc
Solution:
File/Save As
specify Test3.doc

10) Start Excel, Create a table with three columns. The first column should be called Title, the second FirstName and the third LastName. Make up information for 5 people. Save this file as merge.xls. Close Excel.
Solution:
start/run/Excel
Click OK

Click in the top-left cell.
Type "Title" (without the quotation marks).
Move to the cell to the right and type "FirstName"
Move to the cell to the right and type "LastName"
This is not required but may make things clearer - highlight these top three cells and click on the Bold icon.

Under the Title column, make up Titles for 5 people: e.g. Mr., Mrs., Sir, Mr., Ms.
Under the FirstName column, make up First Names for 5 people: e.g. John, Joan, etc.
Under the LastName column, make up Names Names for 5 people: e.g. Smith, Jones, etc.

Save the file as merge.xls.
Close Excel


11) Switch back to Word, and display the mail merge toolbar. Open a data source and choose the excel file you just created. Select Sheet 1.
Solution:
Switch back to Word.
Right-click on some blank space in the toolbar, and make certain that there is a checkmark next to Mail Merge.
There should be two icons enabled (and the rest greyed-out). All the way to the left, the icon for "Main Document setup." Since we will be using the current document, we need not make use of that icon. Immediately to the right is the second icon, "Open Data Source." Click on this icon.
Browse to the folder that contains merge.xls and click Open.
Select Sheet 1 and click OK.


12) Change Dear Sir or Madam to Dear [Title] [LastName],
where [Title] and [LastName] are merge fields.

Save the file as Test3.doc

Solution:
Now, more icons on the Mail Merge Toolbar are enabled. Immediately to the left of the words "Insert Word Field" is an icon. Hovering over that icon will display the words "Insert Merge Field." Click on the "Insert Merge Field" icon to insert a merge field.
Insert merge fields for Title and Lastname. Erase any text that does not belong there.

Save the document as Test3.doc

13) Actually perform the mail merge to a new document.
Solution:
One of the icons on the right hand side of the toolbar is "Merge to New Document." Hover over the icons to find which one and click on it.

13) Save the file as Test4.doc. Call the proctor over to collect the files.

class today

advanced functions: Excel, ch 4, ex 2, starting on page 174
charts: Excel, chapter 3, ex 1 (page 121), exercise 2 (pg 133)
maintaining a list: Excel, chap 7, ex 1 (page 315)

perhaps review if, vlookup

CS12 - Test 1

1) Start Word. You will paste results of each command in the Word Document by pressing Print Screen and then switching to Word and pasting (Edit/Paste) into the document. Type your name at the top. Save this document as Test1.doc

2) Open the command Prompt.

3) Place your disk in the floppy drive and change to the floppy drive

4) Format your floppy disk and name the volume Exam1

5) Create a folder on your disk called Test, and within that folder, create another folder called Docs. Stay in the Test folder.

7) Create three files in the Test folder. Name one of them paper1.txt, the next paper3.txt, and the last paper4.DOC. This is not a graded part of the test so I will help you with this step if you need it. Create these files using Word, edit, notepad, if you want, or type the following from the command prompt:
copy con paper1.txt
hello [Ctrl-Z]
copy con paper3.txt
goodbye [Ctrl-Z]
copy con paper4.DOC
world [Ctrl-Z]

8) Change to the Docs subfolder. Copy the files that begin with the word "paper" and end ".txt" from the parent folder (Test) to the Docs subfolder, using one command involving wildcards.

9) Display the contents of the current folder

10) Change the present working directory to the root directory:

11) Now, a little bit of Windows. Open My Computer and Navigate to the Test directory. Change the View from Tiles to Details and sort in Descending Order by name.

12) Click on the Folders button to Show the Folders

13) Create a New Folder as a subfolder of Test and rename it New Documents

14) Move paper4.DOC into the New Documents folder

15) Navigate to the New Documents Folder

16) Navigate back to the Test folder and delete the Docs Folder.

17) Save your Word Document and call me over. I will email it to myself.

What we covered in class Today

• Bullets, Numbers and Outlines
• Columns
• Headers, Footers, Page Numbers
• Footnotes
• Tables
  

Joan

http://www.stjoan-center.com/#bio

If you read this before class

then please bring both the Word and the Excel book to class today.

An Approximate Syllabus For The Remainder of the Semester

http://qcpages.qc.cuny.edu/~svitak/cs12/syllabusmw.html

though two lab sessions will be covered in 1 class for us, and the dates are not accurate. However, more or less, the exercises are the ones we will do. There may also be some homework assignments.

The exam on Windows and DOS will likely look a lot like this

I will go over it in class tomorrow, and the exam will be one week from tomorrow, in class.

1) Start Word. You will paste results of each command in the Word Document by pressing Print Screen and then switching to Word and pasting (Edit/Paste) into the document. Type your name at the top. Save this document as Test1.doc

2) Open the command Prompt.
Solution:
Start/Run/cmd and press Enter
OR
Start/All Programs/Accessories/Command Prompt

3) Place your disk in the floppy drive and change to the floppy drive
Solution:
A:
4) Format your floppy disk and name the volume Test1
Solution:
format a:
when prompted type Test1

5) Create a folder on your disk called Exam, and within that folder, create another folder called Documents. Stay in the exam folder.
Solution:
md exam
cd exam
md Document

7) Create three files in the exam folder. Name one of them paper1.txt, the next paper3.txt, and the last paper4.DOC. This is not a graded part of the test so I will help you with this step if you need it. Create these files using Word, edit, notepad, if you want, or type the following from the command prompt:
copy con paper1.txt
hello [Ctrl-Z]
copy con paper3.txt
goodbye [Ctrl-Z]
copy con paper4.DOC
world [Ctrl-Z]

8) Change to the Documents subfolder. Copy the files that begin with the word "paper" and end ".txt" from the parent folder to the Documents subfolder, using one command involving wildcards.
Solution:
cd Documents
copy ..\paper*.txt

(remember, .. refers to the parent folder, so this copies into the current folder all documents fitting the criteria specified from the parent folder.)

9) Display the contents of the current folder
Solution:
dir

10) Change the present working directory to the root directory:
Solution:
cd
11) Now, a little bit of Windows. Open My Computer and Navigate to the exam directory. Change the View from Tiles to Details and sort in Descending Order by name.

12) Click on the Folders button to Show the Folders

13) Create a New Folder as a subfolder of exam and rename it New Documents

14) Move paper4.DOC into the New Documents folder

15) Navigate to the New Documents Folder

16) Navigate back to the exam folder and delete the Documents Folder.

17) Save your Word Document and call me over. I will email it to myself.