SPREADSHEET APPLICATIONS

  • Category: Production & Objective Test 
    Type: Individual Event – Section, State, National

    Overview
    Two parts: a one-hour production test administered and proctored at a designated school-site prior to the conference and a 60-minute objective test administered onsite at the conference. Refer to the Production & Objective Test Guidelines (link below) for proctor registration and test request.

    Production Test Competencies: Basic mathematical concepts; Data organization concepts; Creating formulas; Functions; Generate graphs for analysis purposes; Pivot tables; Create macros; Filter and extract data.
    Objective Test Competencies: 
    Formulas; Functions; Graphics, charts, reports; Purpose for spreadsheets; Pivot tables and advanced tools; Macros and templates; Filters and extraction of data; Format and print options.

    Skills: Spreadsheet skills are necessary to convert data to information in business. This event recognizes FBLA members who demonstrate that they have acquired skills for spreadsheet development in business.

    Eligibility
    The participant may not have previously competed in this event at the national level.
    SECTIONEach local chapter may enter a maximum of three (3) members. Competitors must have paid for membership and be registered for the section conference by December 11.
    STATE: A maximum of the top five (5) places from section competition will represent their section at the State Leadership Conference. Competitors must be registered for SLC by February 28.
    NATIONAL
    The top four (4) places in state competition will represent California at the National Leadership Conference.

    Deadlines Section Conference:
    December 11: Competitor Conference Registration
    December 11: Proctor Registration and Test Request
    January 18: Skill Test Work and Certifications Submitted

    Deadlines State Conference:
    February 28: Competitor Conference Registration

    February 28: Proctor Registration and Test Request
    March 29: Skill Test Work and Certifications Submitted 

    COMPETITORS WHO FAIL TO MEET THESE DEADLINES WILL FORFEIT PARTICIPATION IN THIS EVENT


    Guidelines (Please read all guidelines)
    Production & Objective Test Guidelines
    General Guidelines for all events
    Competitive Event Tips

    Sample Practice Materials
    Sample Practice PDF #1
    Sample Practice PDF #2

    Format Guide

    Format Guide PDF

    Website Resources
    Spreadsheet Basics
    Spreadsheet Glossary

    NBEA STANDARDS:
    Computation
    Information Technology
    CAREER STANDARDS:
    Business Management & Administration
    Information Technology
    S.T.E.M.