Outline

• Assignment for the Next Lab
• Lab 2 Instructions
• Homework 1

Read Module 3 (pp. 68-113).
We will do most of the lab exercises in this Module during the next lab. Read through the lab exercises before class so that you have a general understanding of what we will be doing in the lab.

Complete HW1 (see below)

I. Word processing

Find and open the WordPerfect folder in the Applications folder of your hard disk. Open WordPerfect by double clicking on it. Use the "Open" command from the "File" menu to start editing the file called "sample-text" which is in the "module2" folder you just copied from the file server.

Spend some time experimenting with the various editing features available in WordPerfect to fix up this text. Most of the instructions below ask you to perform certain tasks, but don't necessarily explain how to do so. Look around in the different menus and try to figure out how to accomplish the task. Don't be afraid to try something you're not sure of. If you're stuck, ask me for help.

Complete the following:

1. Make the title stand out by centering it, increasing its size, and changing the font. Notice that Word Perfect is a WYSIWYG (What You See Is What You Get) word processor-- the font appears on the screen exactly as it will on the printed version of the document.

2. Find the date feature in the menu and use it to insert the current date below the title.

3. Swap the second and third paragraphs using the cutting and pasting features of the "Edit" menu. Almost all applications for Macs have these features, so it's important to become fluent with them.

4. Correct the spelling in the document.

5. Use "Find/Change" to replace every occurence of "dogs" with "rabbits."

6. Use "Make it fit" from the "Layout" menu to make the document fit two pages without changing the spacing. (you may find this useful when writing papers)

7. Undo what you just did by using "Undo" from the "Edit" menu.

8. Finally use the "Save as" option under the "File" menu to rename your document to "corrected-text".

Call one of us over to check the result before you move on to the next portion of the lab.

II. Spreadsheets

Turn to Lab Exercise 2 on page 41 of your book. In this exercise you will create a spreadsheet to store and average the bowling scores for a team (in bowling, scores can range from 0 to 300). Take a minute or two to read through Lab Exercise 2 in the book. Don't worry about the details; just try to understand the main ideas of what a spreadsheet is and what we are going to use it for in this lab. Instead of using the High-Priced Spread stack for this exercise, you will use Excel, a spreadsheet common in the business world.

1. Find and open the Excel folder on your computer. Open Excel by double-clicking on the Excel icon.

2. You will see a ledger sheet containing cells into which data can be entered. Each cell is labelled based on its column and row (ex. A1, C4, etc.).

   To enter data into a cell, first select the cell by clicking the mouse inside it. Once the cell is selected, you can type in the appropriate data. Notice that what you are typing also appears above the worksheet, in the formula bar. To edit the contents of a cell, select the cell, and then click the mouse within the formula bar. You can now make changes to the data in the formula bar, which will also change the data contained in the cell. To delete data from a cell, select that cell and press delete.

   Practice entering data into cells, editing, and deleting this data. Keep playing around with this until you feel comfortable with it. When you are finished, erase any data you have leftover in your worksheet.

3. Now we will begin a spreadsheet which will contain bowling scores for a team of five players. Each player will have 3 scores. First, put a spreadsheet title in one of the cells in row 1. (something like "Bowling Scores" would be fine for the title).

4. Provide column labels in row 2 (ex., Score 1, Score 2 and Score 3)

5. Provide row labels in column 1 (ex., Player 1, Player 2, ...)

6. Enter scores for Player 1 in B3 through D3.

7. In cell E3, we want to enter a formula for the sum of Player 1's scores. To enter a formula, select "Function" from the "Insert" menu. A dialogue box will appear giving you choices of functions. Find SUM, select it, and click the "Next" button. You will be prompted for the labels of the cells whose data you wish to sum. So in the space by "number 1," type B3 (Player 1's first score). For numbers 2 and 3, type C3 and D3 respectively. Then click finish. In cell E3, you should now have the sum of Player 1's scores.

8. Now select cell E3. The formula =SUM(B3,C3,D3) should appear in the formula bar. Edit this so that it reads =SUM(B3:D3), and click the button containing a checkmark next to the formula bar. The value in cell E3 should remain unchanged. This is because in Excel, a ":" is used to "through." So the formula =SUM(B3:D3) means sum the values found in cells B3 through D3. Notice that if you were summing the contents of cells B3 through Y3, using a ":" would save a lot of typing.

9. Now, using the same technique as above, create formula to place in F3 the average of Player 1's scores.

10. Add column labels in E2 and F2 (ex. "Sum" and "Average")

11. Add scores for the remaining players.

12. Copy (and paste) the formulas that summarize Player 1's scores to F4..F7 and E4..E7, to summarize the scores for the other players.

13. Change some of the data values and observe how the summary information is changed automatically.

14. Now create formulas so that column G displays the maximum score for each player,and column H displays the minimum score for each player. Add the appropriate column labels.

15. Use the appropriate menu icon to save your spreadsheet.

16. Call one of us over to show us your spreadsheet before you leave the lab

17. If you finish all of the above and there's still time left in class, create cells in row 8 which display the team's average score, and the team's average maximum and minimum scores. Label the cells as you see appropriate. Call one of us over to show us your work.

18. Now if there's still time left in class, you can begin working on the first homework assignment, described below.

1. Format a new disk and clearly label it with your name as your CS10 homework disk.

2. Use Excel to design a spreadsheet of your own that performs some task that you find useful or interesting. The columns and rows of your spreadsheet should be labeled with text descriptions (use rows 1-2 and column 1 for this purpose). Be sure to summarize the data using some type of formula. Include your name and the date at the top or just under the title of your spreadsheet. You may also explore the graphical capabilities that Excel offers, but this is not required. Use the help ("?") facility available from the icon menu to learn what you need to know about Excel to do the assignment. Submit your spreadsheet on your homework disk.

3. Write a description of what your spreadsheet does and why a spreadsheet is a nice way to accomplish it.

   Submit a printed copy of your description and a disk copy of your spreadsheet.