# CCNC/CCNC Module 4/Issue tracker

The purpose of this page is create an all-in-one place to maintain a "To Do" list for and to keep track of issues with CCNC Module 4 that span multiple pages or have to be dealt with on a long-term basis.

## To Do

### General

• Reword outcomes and preknowledge on main page in bulleted style
• Reword study tips for clarity
• Add PrevNext arrow buttons in lower right corner of pages to facilitate navigation when at the bottom of the page.
• Implement Template:MyTitle to create simple page headers
• Add self-assessment questions for each section of content
• Update topic pages on the main page to reflect new sections – Show ME and Summary & FAQs
• Resolve embedded notes. Move original to talk pages.
• Add reference to Tutorials for OpenOffice CALC
• Create content for “Show Me” sections in each topic – the navigator suggests this is a video clip
• Create content for “Summary & FAQs” sections in each topic

### Getting to Know the Application

• Saving spreadsheets begins with “So we have converted the template into a spreadsheet that contains actual data.” But the previous section indicates that creating a spreadsheet with actual data will occur later. This needs to be sorted out.
• Integrate saving on floppy disk and harddrive – same procedure, just different location
• Add section "Adjust Settings" after "Handling Worksheets" -- see relevant page in ICDL Module 4

### Working with and in cells

• The “Inserting...” section references the file “Demog.sxc”. The instructions that follow reference the data in the file. But with screenshots missing, may need to revise to use alternate file. Suggest providing a link so that user can download the file (and it is accessible for future revisions).
• In “Entering data...” add instruction for entering sequential numbers, dates.... (that is, the concept autofill) and for copying data to adjacent cells.
• The “Shifting cells...” section assumes there is data in the cells – nothing happens if there's no data – but it's not clear what data would be there.
• The “Using the Search and Replace Command” section would be very similar to the relevant section in Write – seems like it's not needed in both places or spreadsheet instance could refer user to the relevant section in Write.

### Managing Worksheets

• A note from Sdark indicates that this topic was integrated into “Using the Application” My first impression is that integration into the earlier topic works. I suggest leaving this topic in place for awhile more, with a message that content moved to earlier section. We can delete the section later on.

### Formulas and Functions

• All pages need Section navigator added, including addition of Show Me and Summary & FAQs sections.
• Consider entering example math formulas and functions using LaTex markup.
• Would it be helpful to link math terms used in this section to their entry in MsthGloss?
• "Arithmetic Formulas" section
• includes a "show me" video to go along with the written instruction (although written instruction doesn't match cell placement in video). Video needs to be placed more directly with instructions. Also wonder if these videos should be collected in "Show Me" section.
• improve formatting of included table.
• tip on order of operations could be replaced with a link to MathGloss
• In "Error values..." section
• improve table format.
• add tips for resolving calculation errors.
• A note in "Cell referencing" section indicates that contents adapted from a web resource. Need to confirm appropriate attribution.
• In "Working with functions" section
• need to introduce concept of arguments.
• include reference to epsilon button for the sum function.
• add content about other functions available, accessible with function wizard. Provide instruction in how to use function wizard, narrow searchlist with function category, and enter necessary arguments.
• suggest moving content about displaying functions to section that deals with how CALC classifies the cell contents and how to change the display of the contents.
• In "Using the logical function IF" section
• includes the term "autofill" -- I think that's the first use. I suggest including instruction on autofill in "Entering data..." section.
• need to tryout last section -- as note indicates.

### Formatting cells

• Add description of "merge cells" to "Miscellaneous formatting techniques" section

### Creating charts and graphs

• In "About charts..." section
• remove distinction between chart and graph (it's too fuzzy in the real world), integrate common types to one listing.
• Replace the included definitions of different kinds of charts/graphs with a small picture and embedded link to MathGloss
• add scatterplot to list of common graphs
• In "Customizing chart type..." section
• Need to update to OO 3.0
• Don't have the data to go with the instructions.
• Instruction seems to only cover bar charts, suggest adding instruction for at least one other chart type.
• In "Making changes to an existing chart or graph"
• Suggest adding instructions to make scale changes.
• In "Moving duplicating...."
• Suggest adding discussion of connection btwn graph and data; use of paste special to unlink graph from data.

### Preparing the Spreadsheet for Distribution

• in "Setting up the worksheet"
• I don't think fit to page adjusts column widths, rather it shrinks the whole sheet to fit on a page (no matter how much shrinkage is necessary)
• Add emphasis to use Print Preview to evaluate page settings.
• In "Making other adjustments to the worksheet"
• This appears to be about headers and footers -- if there's nothing else needed, maybe section title should reflect specific content.
• Impove table formatting
• In "Preparing to print"
• Improve table format
• "Printing"
• Spreadsheets that are longer and taller than one page will print in a particular order. Suggest adding instruction on how spreadsheet will be broken up into pages.

## Issues

### Determine/implement standard style for computer instructions (e.g., Select Insert > Function)

Submitter: --Alison Snieckus 01:32, 1 April 2009 (UTC)
Date Completed:

Consider using a LaTeX arrow between bolded commands. For example,

Select Insert $\to$ Function

The LaTeX code $\to$ creates the arrow, $\to$.

--Alison Snieckus 02:56, 16 April 2009 (UTC)

### Determine/implement standard for computer terminology (e.g., command, tool...)

Submitter: --Alison Snieckus 02:13, 1 April 2009 (UTC)
Date Completed:

### Determine/implement standard for replacing SCREENSHOT placeholders with actual screenshots

Submitter: --Alison Snieckus 02:13, 1 April 2009 (UTC)
Date Completed:

### Integrate/improve activities

Submitter: --Alison Snieckus 02:13, 1 April 2009 (UTC)
Date Completed:

Most pages appear to be a combination of describing spreadsheet elements and functioning and what the original author termed “Now do it”. I suggest rewriting the “Now do it” instructions as general instructions for how to do it, without encouraging the user to do it as they read how to do it. Then, following the instructions, add an activity box with directions for practice.--Alison Snieckus 02:13, 1 April 2009 (UTC)

### Tips vs. Reflections

Submitter: --Alison Snieckus 02:13, 1 April 2009 (UTC)
Date Completed: