MarC-V: A spreadsheet-based tool for analysis, normalization, and visualization of single cDNA microarray experiments

J. J. Schageman, M. Basit, T. D. Gallardo, H. R. Garner, R. V. Shohet

Research output: Contribution to journalArticle

10 Citations (Scopus)

Abstract

The comprehensive analysis and visualization of data extracted from cDNA microarrays can be a time-consuming and error-prone process that becomes increasingly tedious with increased number of gene elements on a particular microarray. With the increasingly large number of gene elements on today's microarrays, analysis tools must be developed to meet this challenge. Here, we present MarC-V, a Microsoft® Excel® spreadsheet tool with Visual Basic® macros to automate much of the visualization and calculation involved in the analysis process while providing the familiarity and flexibility of Excel. Automated features of this tool include (i) lower-bound thresholding, (ii) data normalization, (iii) generation of ratio frequency distribution plots, (iv) generation of scatter plots color-coded by expression level, (v) ratio scoring based on intensity measurements, (vi) filtering of data based on expression level or specific gene interests, and (vii) exporting data for subsequent multi-array analysis. MarC-V also has an importing function included for GenePix® results (GPR) raw data files.

Original languageEnglish (US)
Pages (from-to)338-344
Number of pages7
JournalBioTechniques
Volume32
Issue number2
StatePublished - Feb 14 2002

Fingerprint

Spreadsheets
Microarrays
Oligonucleotide Array Sequence Analysis
Visualization
Complementary DNA
Genes
Information Storage and Retrieval
Experiments
Microarray Analysis
Macros
Color

ASJC Scopus subject areas

  • Biotechnology
  • Biochemistry, Genetics and Molecular Biology(all)

Cite this

Schageman, J. J., Basit, M., Gallardo, T. D., Garner, H. R., & Shohet, R. V. (2002). MarC-V: A spreadsheet-based tool for analysis, normalization, and visualization of single cDNA microarray experiments. BioTechniques, 32(2), 338-344.

MarC-V : A spreadsheet-based tool for analysis, normalization, and visualization of single cDNA microarray experiments. / Schageman, J. J.; Basit, M.; Gallardo, T. D.; Garner, H. R.; Shohet, R. V.

In: BioTechniques, Vol. 32, No. 2, 14.02.2002, p. 338-344.

Research output: Contribution to journalArticle

Schageman, J. J. ; Basit, M. ; Gallardo, T. D. ; Garner, H. R. ; Shohet, R. V. / MarC-V : A spreadsheet-based tool for analysis, normalization, and visualization of single cDNA microarray experiments. In: BioTechniques. 2002 ; Vol. 32, No. 2. pp. 338-344.
@article{376e12922a0043f8a0e21348b78a4a40,
title = "MarC-V: A spreadsheet-based tool for analysis, normalization, and visualization of single cDNA microarray experiments",
abstract = "The comprehensive analysis and visualization of data extracted from cDNA microarrays can be a time-consuming and error-prone process that becomes increasingly tedious with increased number of gene elements on a particular microarray. With the increasingly large number of gene elements on today's microarrays, analysis tools must be developed to meet this challenge. Here, we present MarC-V, a Microsoft{\circledR} Excel{\circledR} spreadsheet tool with Visual Basic{\circledR} macros to automate much of the visualization and calculation involved in the analysis process while providing the familiarity and flexibility of Excel. Automated features of this tool include (i) lower-bound thresholding, (ii) data normalization, (iii) generation of ratio frequency distribution plots, (iv) generation of scatter plots color-coded by expression level, (v) ratio scoring based on intensity measurements, (vi) filtering of data based on expression level or specific gene interests, and (vii) exporting data for subsequent multi-array analysis. MarC-V also has an importing function included for GenePix{\circledR} results (GPR) raw data files.",
author = "Schageman, {J. J.} and M. Basit and Gallardo, {T. D.} and Garner, {H. R.} and Shohet, {R. V.}",
year = "2002",
month = "2",
day = "14",
language = "English (US)",
volume = "32",
pages = "338--344",
journal = "BioTechniques",
issn = "0736-6205",
publisher = "Eaton Publishing Company",
number = "2",

}

TY - JOUR

T1 - MarC-V

T2 - A spreadsheet-based tool for analysis, normalization, and visualization of single cDNA microarray experiments

AU - Schageman, J. J.

AU - Basit, M.

AU - Gallardo, T. D.

AU - Garner, H. R.

AU - Shohet, R. V.

PY - 2002/2/14

Y1 - 2002/2/14

N2 - The comprehensive analysis and visualization of data extracted from cDNA microarrays can be a time-consuming and error-prone process that becomes increasingly tedious with increased number of gene elements on a particular microarray. With the increasingly large number of gene elements on today's microarrays, analysis tools must be developed to meet this challenge. Here, we present MarC-V, a Microsoft® Excel® spreadsheet tool with Visual Basic® macros to automate much of the visualization and calculation involved in the analysis process while providing the familiarity and flexibility of Excel. Automated features of this tool include (i) lower-bound thresholding, (ii) data normalization, (iii) generation of ratio frequency distribution plots, (iv) generation of scatter plots color-coded by expression level, (v) ratio scoring based on intensity measurements, (vi) filtering of data based on expression level or specific gene interests, and (vii) exporting data for subsequent multi-array analysis. MarC-V also has an importing function included for GenePix® results (GPR) raw data files.

AB - The comprehensive analysis and visualization of data extracted from cDNA microarrays can be a time-consuming and error-prone process that becomes increasingly tedious with increased number of gene elements on a particular microarray. With the increasingly large number of gene elements on today's microarrays, analysis tools must be developed to meet this challenge. Here, we present MarC-V, a Microsoft® Excel® spreadsheet tool with Visual Basic® macros to automate much of the visualization and calculation involved in the analysis process while providing the familiarity and flexibility of Excel. Automated features of this tool include (i) lower-bound thresholding, (ii) data normalization, (iii) generation of ratio frequency distribution plots, (iv) generation of scatter plots color-coded by expression level, (v) ratio scoring based on intensity measurements, (vi) filtering of data based on expression level or specific gene interests, and (vii) exporting data for subsequent multi-array analysis. MarC-V also has an importing function included for GenePix® results (GPR) raw data files.

UR - http://www.scopus.com/inward/record.url?scp=0036163783&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0036163783&partnerID=8YFLogxK

M3 - Article

C2 - 11848411

AN - SCOPUS:0036163783

VL - 32

SP - 338

EP - 344

JO - BioTechniques

JF - BioTechniques

SN - 0736-6205

IS - 2

ER -