SPREADSHEET APPLICATIONS
Spreadsheet Applications provides members with the opportunity to demonstrate knowledge around competencies in converting data to information in business. This competitive event consists of an objective test and production test. It aims to inspire members to learn about the skills for spreadsheet development.
Event Overview
Division: High School
Event Type: Individual
Event Category: Production
Event Elements: Objective Test, 100-multiple choice questions (breakdown of question by competencies below) and Production Test
Objective Test Time: 50 minutes
Production Test Time: 60 minutes, due by date specified in the SLC Registration Packet
NACE Connections: Career & Self-Development
Equipment Competitor or School Must Provide: Sharpened pencil for Objective Test, Computer for Production Test, Conference-provided nametag, Attire that meets the Florida FBLA Dress Code
Equipment FBLA Provides: Production Test Tasks
Competencies
· Formulas
· Functions
· Graphics, Charts, and Reports
· Pivot Tables and Advanced Tools
· Macros and Templates
· Filters and Extraction of Data
· Format and Print Options
· Purpose for Spreadsheets
Production Test Competencies
· Data Organization Concepts
· Creating Formulas
· Functions
· Generate Graphs (for analysis purposes)
· Pivot Tables
· Create & Use Macros
· Filter and Extract Data
District
Check with your District leadership for District-specific competition information.
State
Eligibility
· FBLA membership dues are paid by 11:59 pm Eastern Time on December 1 (or earlier date specified by District Director) of the current program year.
· Members may compete in an event at the State Leadership Conference (SLC) more than once if they have not previously placed in the top 10 of that event at the National Leadership Conference (NLC). If a member places in the top 10 of an event at the NLC, they are no longer eligible to compete in that event.
· Members must be registered for the SLC and pay the state conference registration fee in order to participate in competitive events.
· Members must stay in an official FBLA hotel to be eligible to compete.
· Each district may be represented by participant(s) based on the Florida FBLA scaled quota system found on the Florida FBLA website.
· Each member can only compete in one individual/team event and one chapter event (American Enterprise Project, Community Service Project, Local Chapter Annual Business Report, Partnership with Business Project).
· Each competitor must compete in all parts of an event for award eligibility.
· If competitors are late for an objective test, they may be either disqualified or permitted to begin late with no extension of the time as scheduled.
· Participants must adhere to the Florida FBLA dress code established by the Florida Board of Directors or they will not be permitted to participate in the competitive event.
Recognition
· The number of competitors will determine the number of winners. The maximum number of winners for each competitive event is 5.
Event Administration
· This event has two parts: Objective Test and Production Test
· Objective Test
o The objective test is administered at the SLC.
o No reference or study materials may be brought to the testing site.
o No calculators may be brought into the testing site; online calculators will be provided.
· Production Test
o Submission Deadline: All the tasks must be uploaded in the conference registration system by the date specified in the SLC Registration Packet.
o The production test is administered and proctored by an adult at a designed school-site prior to the SLC. Administration procedures for the production test are determined by the state chair/adviser.
o The production test is a set of tasks based on the competencies for the competitor to complete.
o Documents produced for this event must be prepared by the competitor without help from the adviser or any other person.
o Calculators cannot be used on the production test.
Scoring
· The rating sheet will be released with the production test.
· Production Test is 85% of the total score.
· Objective Test is 15% of the total score.
· The Production Test score will be used to break a tie.
Americans with Disabilities Act (ADA)
· FBLA meets the criteria specified in the Americans with Disabilities Act for all competitors with accommodations submitted through the conference registration system by the registration deadline.
Penalty Points
· Competitors may be disqualified if they violate the Competitive Event Guidelines or the Honor Code.
Electronic Devices
· All electronic devices such as cell phones, headphones, and watches of any type must not be brought to the event.
National
Be sure to see the National guidelines at https://www.fbla.org/divisions/fbla/fbla-competitive-events/
Study Guide: Objective Test Competencies and Tasks
A. Formulas
1. Create basic formulas with addition, subtraction, multiplication, and division.
2. Use SUM, MIN, MAX, COUNT, PMT, IF and AVERAGE functions while completing a spreadsheet template.
3. Use advanced functions/formulas (payment, future, value, and statistical).
4. Use and change mathematical functions and formulas, including absolute and relative cell references and what-if analysis.
5. Construct arithmetic formulas to solve typical business-oriented problems.
6. Use Lookup Functions and tables (Hookup or VLOOKUP).
7. Create named ranges to be used in formulas and printing.
8. Evaluate formulas and locate invalid data and formulas.
9. Use cells from other worksheets inside a formula.
10. Use the fill handle with formulas.
B. Functions
1. Demonstrate the functions and terminology of spreadsheet software.
2. Open, save, print, and close a spreadsheet.
3. Design, create, and edit spreadsheets using appropriate inputting, editing, and formatting skills.
4. Navigate and enter values, labels, and dates within a worksheet.
5. Demonstrate locking and freezing features.
6. Use wrap text and fill alignment features to make cell entries.
7. Import data from text files (insert, drag, and drop) and other applications.
8. Export data to other applications.
9. Create, edit, and remove a comment.
10. Apply and remove worksheet and workbook protections and security settings.
11. Track changes (highlight, accept, and reject).
12. Insert headers and footers in a spreadsheet.
13. Manipulate multiple worksheets in a workbook.
14. Incorporate spreadsheets in word processing documents.
15. Design and implement a spreadsheet project which includes multiple, integrated spreadsheets.
16. Use help features and reference materials to learn software and solve problems.
C. Graphics, Charts, and Reports
1. Create and modify charts and graphs to visually represent data.
2. Import graphics elements in spreadsheet.
3. Change colors and apply spot color to graphics and text.
4. Add text boxes.
5. Edit, resize, crop, and manipulate copy and graphics.
6. Enhance and format charts.
7. Create embedded charts.
8. Add and format chart arrows.
9. Explode pie charts.
10. Create and format information in reports.
11. Create advanced reports.
D. Pivot Tables and Advanced Tools
1. Describe use of a pivot table.
2. Create a pivot table.
3. Use Pivot Table auto format.
4. Trace errors (find and fix errors.)
5. Link spreadsheet data.
6. Link workbooks.
7. Embed objects in spreadsheets.
E. Macros and Templates
1. Create, record, edit, and run/apply spreadsheet macros.
2. Design, create, and edit a template for application.
3. Add a chart to the template.
4. Save a worksheet as a template.
5. Create a workbook from a template.
F. Filters and Extraction of Data
1. Sort and filter spreadsheet data for specific information.
2. Sort a list (ascending, descending, etc.).
3. Search a list by more than one criterion.
4. Search a list by using AutoFilter.
5. Search a list using custom filters and operators.
6. Create filters using OR and AND.
7. Create filters using wildcards.
8. Filter by numerical values, text, dates, etc.
9. Extract useful information using search queries.
10. Analyze and edit data.
11. Use built-in statistical analysis features of spreadsheet software.
12. Import and export data.
G. Format and Print Options
1. Format cell contents (font, color, alignment, shading, decimal).
2. Insert, delete, copy, and paste cells.
3. Enhance a spreadsheet by using formatting features (column width, justification, and values).
4. Align the data and apply borders and/or shading to a cell or a range of cells.
5. Apply number formats (accounting, currency, and number).
6. Apply automatic formatting to ranges.
7. Apply conditional formats.
8. Create and modify custom data formats.
9. Adjust page setup for landscape or portrait layout.
10. Use print preview to view, proofread, and edit the spreadsheet.
11. Print designated areas of the spreadsheet with or without gridlines.
12. Use print scaling options (shrink to fit).
13. Set print specifications for formulas, graphs, worksheets, etc.
H. Purpose for Spreadsheets
1. Explain spreadsheets and various options.
2. Differentiate among a variety of spreadsheet programs.
3. Organize a problem for solutions with spreadsheet software.
4. Plan and create a spreadsheet from data designed for a specific purpose.
5. Analyze, interpret, and present data.
6. Manipulate spreadsheet data to answer “what if” questions.