Fundamental of Computer Science Excel Research Project Study Guide

Project Overview and Administrative Constraints

• The Fundamental of Computer Science Excel Project (FCSA - Excel Project) requires students to work in collaborative groups of $4$ to design, conduct, analyze, and report on an original empirical research study.

• The timeline for the entire project is strictly limited to $1$ week ($5$ school days). Due to this explicit time constraint, research designs must be cross-sectional and feasible within a few days; longitudinal studies requiring repeated measurements over extended periods are strictly prohibited.

• Data collection must be conducted using either Microsoft Forms or Google Forms.

• Data processing, organization, filtering, and quantitative analysis must be performed exclusively using Microsoft Excel.

• Student researchers are strictly prohibited from answering or submitting entries to their own surveys to avoid personal response contamination.

• Sampling scope and community inclusion requirements:

  • Research topics and participant recruitment must not be targeted exclusively to magnet program students.

  • Target samples must incorporate the broader Montgomery Blair High School community, home neighborhoods, families, or other schools within the Montgomery County Public Schools (MCPS / MoCo) district.

  • Researchers must account for and document potential sampling biases that could skew results when drawing from these populations.

• All project materials, shared files, and spreadsheet workbooks must be shared with full edit permissions granted to Mrs. Koval.

Research Topic Selection and the Decision Matrix

• Every individual member of the four-person group must develop and pitch an independent, unique research proposal before designing the survey.

• Topic evaluation is conducted using a structured decision matrix (Decision_Matrix_Template), a systematic tool designed to evaluate and compare multiple competing options against a standardized set of criteria.

• In this engineering and research context, options represent the proposed research questions, while criteria represent the required characteristics and quality standards necessary for project feasibility.

• Core steps for completing the decision matrix:

  • Step 1: Identify Options

  • Brainstorm research questions as a collective team.

  • Input each unique proposal into the matrix under separate option headings.

  • Example questions provided in templates serve illustrative purposes only and cannot be adopted by groups.

  • Verify that each proposed question investigates a feasible topic through an online survey distributable to a realistic sample within a $1$-week timeframe.

  • Step 2: Choose Criteria

  • Establish uniform evaluation criteria across all group proposals to guarantee unbiased, objective scoring.

  • The standard criteria and their guiding considerations include:

    • Time and feasibility: Can the group design the survey, collect responses, and finish the entire Excel analysis and report within exactly $1$ week?

    • Access to participants: Can the group reach respondents capable of providing meaningful, relevant responses?

    • Useful variables: Will the survey collect well-defined variables suited for comparing distinct groups or uncovering statistical relationships?

    • Excel analysis: Does the data structure allow application of classroom Excel functions for organizing, cleaning, filtering, summarizing, and evaluating datasets?

    • Meaningful visualizations: Can the resulting data generate clear charts and graphs that directly resolve the research inquiry?

    • Clarity and potential bias: Can questions be phrased neutrally and transparently, and can the team recognize systematic limitations in respondent demographics?

  • Step 3: Score Ideas

  • Scoring rules and interpretations must be established prior to evaluating ideas.

  • Scoring occurs along an anchored scale:

    • $1$: Meets the criterion poorly.

    • $2$: Intermediate score between poor and adequate.

    • $3$: Meets the criterion adequately.

    • $4$: Intermediate score between adequate and very well.

    • $5$: Meets the criterion very well.

  • Teams must select and complete either an unweighted matrix or a weighted matrix:

    • Unweighted Matrix: Assumes equal importance for all criteria. The raw scores across all criteria are summed directly for each option to produce a cumulative total.

    • Weighted Matrix: Assigns an importance multiplier (weight) to each criterion. Each raw score ($1$ to $5$) is multiplied by its criterion weight, and the resulting weighted scores are summed. Criteria with higher weights exert greater mathematical leverage on the total score (for example, if Time and Feasibility has an assigned weight of $5$ and receives a raw score of $4$, its weighted score is $5 \times 4 = 20$).

  • Step 4: Justify the Choice

  • Compare composite scores and discuss results among all $4$ group members.

  • Select the highest-performing, fully compliant topic and formally document the decision using the required rationale structure:

    • "Our group selected [insert topic] because [insert reasoning]. Our matrix shows [insert evidence from matrix scores]. We plan to use Excel to analyze [insert variables/data] and visualize. One possible source of bias is [insert bias], which could affect our finding by [insert impact on findings]."

Research Planning and the Scientific Method Framework

• The research investigation follows the foundational steps of the scientific method, adapted from a physical laboratory experiment to survey-based quantitative data collection.

• Formulating the research question:

  • Must sustain team interest and intellectual curiosity over the project lifespan.

  • Must represent a focused, manageable inquiry.

  • Often begins with standard inquiry words: How, What, When, Who, Which, Why, or Where.

  • Must be substantiated by a minimum of $3$ credible, trustworthy outside reference sources to provide contextual grounding.

• Defining populations, samples, and variables:

  • Population: The entire theoretical group of individuals about whom the researchers wish to draw conclusions.

  • Sample: The specific subset of individuals drawn from the population who actively complete the survey instrument.

  • Required variable structure:

  • Studies must define at least $2$ primary variables to compare distinct groups or test relationships, with additional secondary variables included to enhance analytical depth and visual comparisons.

  • Explanatory / Independent Variable: The factor systematically varied, categorized, or observed as the potential influence during the study.

  • Outcome / Dependent Variable: The measurable factor recorded and quantified in the survey responses.

  • Controlled Variable: Extraneous factors that are deliberately held constant to prevent distortion of observed relationships.

• Hypothesis construction:

  • Hypotheses must state a clear, testable proposition predicting the empirical outcomes.

  • Directional / "If-Then" Format: Directly asserts a directional causal or associational link between variables.

  • Model: "If teenagers log over two hours on screen time nightly, they will mark decreased sleep rating scores throughout their responses."

  • Null Hypothesis / Null Statement: Posits that altering conditions or group memberships produces zero measurable variation or difference in outcomes.

  • Model: "No measurable disparity in sleep ratings exists between individuals using evening social platforms versus non-users."

Excel Functions, Formulas, and Data Processing

• Analytical operations must be executed directly within Microsoft Excel, requiring at least $2$ distinct built-in spreadsheet functions learned in class, along with manual or automated sorting and filtering.

• Standard classroom functions organized by analytical objective:

  • Summarizing numerical data: SUM, COUNT, AVERAGE, MIN, MAX

  • Testing logical conditions and making decisions: AND, OR, NOT, IF

  • Numerical transformations: ABS, SQRT, INT

  • Geometric calculations, angles, and mathematical constants: COS, SIN, TAN, DEGREES, RADIANS, PI()

• Operational spreadsheet syntax:

  • Arithmetic operators: Addition ($+$), Subtraction and Negation ($-$), Multiplication ($*$), Division ($/$), Exponentiation (^).

  • Comparison / Relational operators: Less than ($<$), Greater than ($>$), Less than or equal to ($<=$\, or \,$\le$), Greater than or equal to ($>=$\, or \,$\ge$), Equal to ($=$), Not equal to (<>\, or \,$\neq$).

• Data restructuring definitions:

  • Cleaning Data: A systematic preparation process that standardizes and unifies data formatting across a dataset without altering the underlying semantic meaning (for instance, harmonizing inconsistent text entries, converting disparate capitalization, aligning misspellings, or standardizing abbreviations to a single canonical term).

  • Data Filtering: The deliberate extraction of a targeted subset from a larger dataset for focused analysis by including or excluding specific rows according to defined logical conditions.

Principles of Data Analysis and Computational Limitations

• Information extraction dynamics:

  • Raw data consists of unprocessed, individual values; extracting recurring patterns, structures, and statistical relationships transforms raw data into actionable information and knowledge.

  • Computational programs and spreadsheet environments facilitate the identification of correlations, trends, and predictive patterns.

• Fundamental principle of causality:

  • In computational and statistical analysis: CORRELATION IS <> CAUSATION ($\text{Correlation} \neq \text{Causation}$).

  • The presence of a statistical correlation or observed co-occurrence between two measured variables does not demonstrate that one variable causes the other.

  • Patterns observed in survey data can be induced by unmeasured confounding variables, participant self-selection, and survey design limitations.

• Computational challenges in data processing:

  • System performance and analytical success depend directly on user capability and software capacity.

  • universal dataset complications include handling missing records, cleaning unformatted text, correcting invalid entries, and harmonizing disparate datasets into uniform tables.

  • Free-form user text fields inevitably introduce severe data variance in spelling, abbreviation, and capitalization, necessitating rigorous cleaning.

  • Source bias: Systematic bias stems from how data is gathered and who is sampled. Increasing sample size ($N$) does not eliminate systematic collection bias.

  • Scalability and hardware limits: Enormous datasets exceed the processing capacity and memory of a single desktop machine, requiring distributed, parallel computing systems.

• Common computational methods for modifying and extracting data:

  • Universal element transformation: Systematically altering every value across an entire field or array (such as doubling every entry in a list or populating parent contact information across every individual student profile).

  • Subset filtering: Isolating data records matching specified rules (such as selecting only positive numerical values or isolating students enrolled in band).

  • Data aggregation and reduction: Calculating summary metrics across records (such as calculating numerical sums or querying the highest grade point average in a class).

  • Visual synthesis: Communicating empirical patterns via charts, plots, and structural diagrams.

  • Algorithmic searching: Implementing query systems to locate specific data elements quickly.

Data Storytelling and Visualization Requirements

• Translating raw data into an analytical narrative requires executing the five-phase Data Analysis Process:

  • Phase 1: Document the Dataset: Draft an introductory metadata summary specifying the origin of the data, collection dates, instrumentation, and the exact physical or behavioral phenomena it measures.

  • Phase 2: Create Visuals: Construct properly formatted charts and graphs aligned with the underlying data distribution and comparison types.

  • Phase 3: Explain Your Charts: Provide explicit textual explanations describing what each axis, category, series, and visual element communicates.

  • Phase 4: Share Insights: Translate empirical trends into tangible conclusions, notable takeaways, and real-world practical decisions.

  • Phase 5: Check for Bias: Critically evaluate the dataset for internal limitations, sampling distortions, and non-representative participant groups.

Written Research Report Specifications

• The written research report serves as the formal academic documentation of the study and must satisfy strict structural criteria:

• Section 1: Research Question and Purpose

  • Articulate the central research question.

  • Explicitly define all independent, dependent, and secondary variables.

  • Establish the broader real-world importance of the study to the school, local community, or academic field.

  • Synthesize background context from at least $3$ credible, authoritative outside sources.

• Section 2: Methods

  • Detail participant demographics, recruitment strategies, collection dates, and total valid response numbers.

  • Explain participant privacy protections, informed consent safeguards, and anonymity preservation.

  • Detail data cleaning protocols, error corrections, and exclusion criteria.

  • Catalog all specific Excel formulas, functions, and tools utilized, explaining the analytical purpose of each.

• Section 3: Results and Visual Evidence

  • Document a minimum of $2$ precise numerical findings directly in the body text.

  • Embed at least $1$ fully labeled Excel summary table and at least $1$ Excel chart, with direct references to both within the written narrative.

  • Clearly identify plotted variables, categories, filters applied, and response sample sizes ($N$).

  • When presenting percentage statistics, explicitly document the denominator representing the number of valid responses for that specific item.

  • Justify why the selected chart format best represents the data comparison.

• Section 4: Discussion and Limitations

  • Provide a direct answer to the research question grounded in the quantitative findings.

  • Describe practical applications, school policies, or community decisions that these findings could guide.

  • Thoroughly examine at least $2$ explicit research limitations, detailing how each limitation constrains conclusions and identifying specific demographic groups omitted or underrepresented by the sampling frame.

• Section 5: Conclusion and Next Steps

  • Summarize key overall insights gained through the study.

  • Formulate $1$ concrete, targeted follow-up research question or methodological revision designed to resolve an identified limitation.

• Section 6: Citations and References

  • Cite all external factual claims, frameworks, and data sources using formal APA style.

  • Document the team's primary survey dataset using an APA citation containing the group name, survey title, collection dates, and valid response count.

Project Workflow, Task Management, and Submission Protocol

• Standard 5-Day Project Work Plan:

  • Day 1: Select the finalized research question, establish team norms, divide responsibilities, construct survey questions, and audit questions for neutral phrasing and bias.

  • Day 2: Distribute the survey, actively collect responses, and draft the report introduction, purpose, and methodology sections.

  • Day 3: Terminate survey collection, clean and standardize raw data, and build foundational Excel formulas and calculations.

  • Day 4: Generate PivotTables, construct final Excel charts, and draft the results and discussion sections.

  • Day 5: Audit all spreadsheet calculations, revise and edit the final written report, verify APA citations, and assemble submission files.

• Group Contribution Log requirements:

  • Maintained continuously across the project to document individual workload equity.

  • Must record task descriptions, primary contributors, peer reviewers, exact document locations (such as specific sheet names, cell ranges, or report sections), completion dates, and workflow status.

• File naming and submission standards:

  • Main Excel Workbook: Must be named strictly as GroupName_ExcelResearch.xlsx.

  • Written Research Report: Must be named strictly as GroupName_ResearchReport.

  • Required Excel workbook worksheets: Raw Data, Cleaned Data, Analysis, Pivot, and Chart.

  • Submissions must include the spreadsheet workbook, the research report, the complete list of survey questions, and the finalized contribution log.

Comprehensive Grading Rubrics

• Excel Workbook Evaluation (Total: $21$ Points):

  • Data Collection and Ethics ($3$ points total):

  • Clear, neutral survey questions addressing a meaningful research topic: $1$ point.

  • At least $25$ valid responses imported, with data exclusions justified (higher sample sizes encouraged): $1$ point.

  • Participant awareness of voluntary participation, absence of personal identifiers, and identification and reduction of sampling bias: $1$ point.

  • Formatted Table ($3$ points total):

  • Raw data preserved on an independent sheet; cleaned table constructed with logical ordering, consistent categories, and zero merged cells: $1$ point.

  • Professional table styling featuring descriptive header rows, readable column widths, text wrapping, and proper number/date formatting: $1$ point.

  • Descriptive title or contextual note documenting table contents: $1$ point.

  • Formulas and Calculated Column ($2$ points total):

  • At least $1$ accurately calculated column generating new row-level insights: $1$ point.

  • Correct implementation of at least $2$ distinct class-taught functions, retaining live active formulas in spreadsheet cells: $0.5$ point.

  • Clear, descriptive labeling of calculated outputs: $0.5$ point.

  • PivotTable ($3$ points total):

  • Accurate PivotTable constructed from cleaned data with appropriate row, column, and data fields: $1.5$ points.

  • Table directly highlights a comparative trend or pattern addressing the core research question: $1$ point.

  • Clear data labeling, inclusion of totals where appropriate, and clean number formatting: $0.5$ point.

  • Chart ($3$ points total):

  • Accurate visual representation of a clean data subset or PivotTable summary: $1$ point.

  • Selection of a chart type and visual scale suited to the data comparison: $1$ point.

  • Inclusion of a descriptive chart title, axis titles with units where relevant, and an interpretable legend: $1$ point.

  • Advanced Excel Tools ($5$ points total):

  • Correct deployment of at least $1$ advanced capability: formula-driven conditional formatting, a dynamic PivotChart, or a second PivotTable answering a separate analytical question: $2$ points.

  • Written explanation detailing the analytical insights provided by the advanced feature relative to the research topic: $2$ points.

  • Flawless visual organization and clarity of the advanced feature: $1$ point.

  • File Management and Submission ($2$ points total):

  • Clear, standard sheet naming (Raw Data, Cleaned Data, Analysis, Pivot, Chart): $0.5$ point.

  • Exact adherence to file naming conventions (GroupName_ExcelResearch.xlsx and GroupName_ResearchReport): $0.5$ point.

  • Full submission of workbook, report, survey questions, and log with verified teacher edit access: $0.5$ point.

  • Deletion of extraneous sheets and general workbook readability: $0.5$ point.

• Written Research Report Evaluation (Total: $11$ Points):

  • Purpose ($1$ point): Articulates a focused question, defines all variables, and establishes school or community relevance.

  • Methods ($1$ point): Fully documents the participant sample, collection procedures, privacy controls, cleaning steps, and Excel functions.

  • Results ($2$ points total):

  • Documents at least $2$ accurate numerical findings in the text: $1$ point.

  • Successfully integrates an Excel summary table and chart matching the workbook data and explicitly discussed in text: $1$ point.

  • Visualization Choices ($1$ point): Justifies variable selections, data subsets, and chart types.

  • Interpretation and Application ($2$ points total):

  • Directly resolves the research question using quantitative data evidence: $1$ point.

  • Formulates a realistic real-world application without overstepping empirical evidence: $1$ point.

  • Limitations ($1$ point): Details at least $2$ methodological limitations, explaining their impact on findings and demographic generalizability.

  • Further Inquiry ($1$ point): Proposes a focused follow-up research study or methodological modification resolving an identified issue.

  • Citations ($1$ point): Integrates a minimum of $3$ credible outside references cited in APA format alongside formal citation of the primary survey data.

  • Organization and Clarity ($1$ point): Professional formatting featuring clear section headers, complete prose paragraphs, precise technical terminology, and a unified group writing style.

• Individual Collaboration and Contribution Evaluation (Total: $3$ Points):

  • Contribution ($1$ point): Fulfills an agreed-upon, substantial proportion of project work with high accuracy and actively improves the final deliverables.

  • Responsibility ($1$ point): Demonstrates productive time management during class, respects deadlines, communicates obstacles promptly, and maintains accountability.

  • Collaboration ($1$ point): Actively listens, shares decision-making authority and resources, provides constructive feedback, and maintains respectful interactions.

  • Scoring Evidence: Final individual grades are assigned based on confidential self and peer evaluations, version history logs, contribution log documentation, and daily classroom observations.