The spreadsheet will be developed using the AppleWorks (ClarisWorks) application located on the launcher of your computer.  Open AppleWorks (ClarisWorks)  and select Spreadsheet, click OK.

Terms to know:

• Cells: The small boxes on a spreadsheet, where the data (text or numbers) is stored. When you click inside a cell it will select that information, and the cell will be surrounded by a dotted border.
• Cell Address: the intersection of a column letter and a row number
• Columns: the data that runs vertically down a spreadsheet, columns are identified by letters
• Data Entry Bar: the blank line at the top of the spreadsheet where the data is entered,  the cell address appears to the left of the line
• Rows: the data that goes horizontally (across) the spreadsheet, rows are identified by numbers

 

• Once you have opened the spreadsheet application, go to Window at the top of the page, and choose Page View. This will allow you to see the size of the page you will print on.
• Click on cell A1 to select it.
• Choose Column Width from the Format menu.
• In the dialog box that appears, type 150. This will now make your column wide enough to accomodate your information.
• Repeat this step with cell A2. 
• Continue to widen as many columns as needed.
• Click inside Cell A1 and enter the data. Notice that the information is appearing in the data entry bar even though you have selected Cell A1.
• The data will appear in your cell on the spreadsheet by:1) pressing the return/enter key 2) clicking another cell in the spreadsheet.

• Press Tab to move one cell to the right.
• Click inside the cell you want to work with.
• Press Shift and Tab together to move one cell to the left.
• Press Return to move down one cell.
• Press Shift and Return together to move up one cell.
• Use the arrow keys to move around the spreadsheet.
• Choose Go to Cell from the Options menu and type in a cell address.

Remember to make a chart / graph you must have created a spreadsheet You will need to highlight (select) the cells that are to be included in your chart

• The data in the first column becomes the X-Axis label on your chart.
• The data across the first row becomes the legend.
• Choose Make Chart from the Options menu.

• Click OK , the chart will now appear.
• You can change the type of chart by double clicking the current chart and selecting a new style. 
• Click on Axes to correctly identify your statistics.
• Click on Labels to create a title for your graph (chart).

• Your team can print the graph(chart) with the spreadsheet visible underneath. However, this does not represent a professional finish.
• With a few simple procedures you can print only the graph (chart). 

drag and enlarge the graph to cover as much of the spreadsheet as possible remember not to drag it onto the next page - watch your page view Under Options - Display uncheck the boxes for Print Column Headings, Print Row Headings, Print Cell Grid TIP - if Display is not an option make sure you click away from your chart before the above step

• Congratulations !  You are now ready to print.
• Your team will need to review the following rubric and complete any revisions prior to placing your chart into your Geography Portfolio.