Calc Workbook for Non-Fiction Writing, version 1.0

"Calc Workbook for Non-Fiction Writing, version 1.0" updated at DavidFisco.com
Created:   Tuesday, 17 November 2009
Last modified:   Wednesday, 18 November 2009
Intended Users: 

Non-fiction writers who know how to use OpenOffice.org's Calc spreadsheet software.

This OpenOffice Calc workbook is a collection of spreadsheets that will assist you in non-fiction writing. It helps you identify the scope and intended audience for your writing, and allows you to organize the concepts and quotes you will use when you write. It does not provide an environment for writing, you will need a text editor or word processor for that.

The Spreadsheets

Let's take a look at each spreadsheet in the workbook and explore how they can help you become a better non-fiction writer:

Scope

Here you define the purpose of your writing. You state the subject, theme (more specific than a statement of your subject), what new (previously unpublished) information you will be providing, and the objective of your writing. The fields on this sheet are fine-grained because many writers make the mistake of not being specific enough in their intentions before they begin writing. Let's consider an example using a hypothetical article about Shakespeare's The Winter's Tale. The subject would be "Shakespeare's The Winter's Tale". The theme would be "Shakespeare was not the sole author of The Winter's Tale." What is new in your piece would be "textual analysis demonstrating that the writing style of certain passages is not congruent with Shakespeare's other plays". The objective would be "to provide evidence and demonstrate the validity of my theme".

Audience

Here you define your target readers so you can gauge your writing accordingly. The fields on this spreadsheet should be self-explanatory.

Quotes

On this sheet, you collect the quotations you might use in your piece. Let's take a look at each field:

Tags

Tags are free-text snippets that can help you in classifying quotes and searching your spreadsheet. Examples of snippets include "disagreement with thesis", "introductory material" and "supporting evidence".

Quote

Enter the quote.

Analysis

Begin writing your analysis of the quote and how the quote fits into your writing. You may end up using cut-and-paste to transfer this text to your piece.

Reference

The generic citation where you found the quote. This could be a book, article, DVD, newscast, etc.

Page(s), Chapter, DVD Chapter, Video Time Slice, etc.

The specific location where you found the quote. (For example, a page number or a time slice from a video.)

Reference Date (for searching)

This field allows you to record when the quote was written or spoken so you can search on and refer to that time. For example, a quote may have been spoken in 1977, but not published until 1997. Use this field to record that the quote comes from 1977, not the publication date.

Notes

Here you can record messages to yourself such as "further research needed" or "verify this quote".

Concepts

Here you will record ideas–but not quotations–that you want to incorporate in your piece. Note that the reference fields should be considered optional so that in addition to collecting the concepts of others, you can use this spreadsheet to also collect your original concepts. Once you understand the quotes spreadsheet, this sheet should be self-explanatory.

Updates

I plan to update this workbook occasionally. You can subscribe to this RSS feed to be notified of updates.

Changelog: 

Version 1.0 (17 November 2009): Initial release.

AttachmentSize
Non-Fiction_Writing.ods20.52 KB

The software on davidfisco.com is provided on an "as is" basis without warranty of any kind. David Fisco and David Fisco Consulting specifically disclaim any warranty, express or implied, including any warranty of merchantability or fitness for a particular purpose. In no event shall David Fisco or David Fisco Consulting be liable for any consequential, indirect, special or incidental damages, even if David Fisco or David Fisco Consulting has been advised by user of the possibility of such potential loss or damage. The user agrees to hold David Fisco and David Fisco Consulting harmless from and against any and all claims, losses, liabilities and expenses.