Spreadsheets and Databases

There are not enough resources to help a small nonprofit utilize spreadsheets and databases while developing their evaluation capacity. Recall a database is best for entering data and mix matching data while a spreadsheet should be used for analysis. You should become familiar with the IF and VLookup Functions in spreadsheets.Currently I am working on a spreadsheet template where I drop all my survey data. I follow the model that a spreadsheet should have one worksheet with the raw data, one worksheet that correctly codes the raw data; one worksheet with an index that displays your code values; one worksheet with your analysis. Your may want to put your final results in a separate spreadsheet with graphs. One advantage to putting your final results in a separate spreadsheet is that it makes that spreadsheet cleaner if you have to e-mail the spreadsheet. However one disadvantage is that the other worksheets are more accessible when you double check your final results.

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s