Learners will be offered opportunities to practice newly learned skills in an independent practice activity, one for each section of content. Preparing the spreadsheet for distribution: Are all data accurate? | Setting up the worksheet | Making other adjustments to the worksheet | Preparing to print | Printing | Activity | Summary.Creating charts and graphs: About charts and graphs | Customising chart type for selected data | Making changes to an existing chart or graph | Moving, duplicating, resizing, deleting | Activity | Summary.Formatting cells: Formatting cells containing numeric data | Changing the appearance of cell contents | Miscellaneous formatting techniques | Activity | Summary.Working with Formulas and Functions: Arithmetic formulas | Error values when using formulas | Cell referencing | Working with functions | Using the logical function IF | Activity | Summary.Working with and in cells: Selection in a worksheet | Inserting within a worksheet | Deleting rows and columns in a worksheet | Modifying column widths and row heights | Entering data in cells | Making changes to the contents of cells | Duplicate, move, delete | Shifting cells | Speeding up data entry | Search and replace | Sorting data | Activity | Summary.Getting to know the application: Creating, opening and closing spreadsheets| Locating the components of the Calc Screen | Saving spreadsheets | Handling worksheets | Activity | Summary.

Use the content structure in CCNC Module 4: Using spreadsheets as a starting point:

Openoffice calc graph title