Contest Descriptions and Study Material

Microsoft Excel (Office 2013):

In the Microsoft Excel contest, students will prove their skills with creating Excel spreadsheets, graphs, equations and more! They will need to brush up on skills such as these:

  • What-If Analysis
  • Data Analysis
  • Table creation and manipulation
  • Chart creation and manipulation
  • Cell Referencing

 Study:

UIL Computer Applications

Microsft Computer Applications UIL Practice Test

Fall 2014 Excel Competition:

Problem Statement

Excel Starter File

Excel Data

Final Document

Microsoft Access (Office 2013):

In the Microsoft Access contest students will need to be able to create a database using Access, create a form, report and how to troubleshoot/ manage queries.

 Study:

Microsoft Computer Applications UIL

Microsoft Computer Applications UIL Practice Test

Fall 2014 Access Competition:

Problem Statement

PC Troubleshooting:

In the PC Troubleshooting contest students wil answer questions similar to A+ testing as well as common issues regarding these Operating Systems:

Windows 7, XP, and Vista:

  • Control Panel
  • Managing and troubleshooting User Account Control
  • Managing and troubleshooting Boot TIme issues

 Study:

Tech Republic- Control Panel Settings

Microsoft TechNet- User Access Control

Microsoft TechNet- General Windows

OSX:

  • Sytem Preferences
  • Ethernet and Airport COnfiguration
  • File System Layout and file types
  • Managing and troubleshooting BootCamp

 Study:

Apple- System prefernces

Apple- BootCamp

Apple- FInder

Linux:

  • Managing and troubleshooting GRUB
  • Managing and troubleshooting network connections

 Study:

Ubuntu- Grub

Ubuntu- General

Hardware:

  • Motherboard components corresponding to intel and AMD marketing terms.
  • Managing and troubleshooting Peripheral device connections
  • Managing and troubleshotting Power On and POST

 Study:

Computer Hope- POST

Wiki- CPU Socket

Fall 2014 PCT Contest:

Written Test

Practical Problem Statement

Java

In the Java contest students will need to exemplify their basic understadning of java. They will need to be able to code:

  • Strings
  • Arrays
  • Compuations
  • Write to a file

 Study:

Java Nuts and Bolts Tutorial

Coding Bat-JAVA 

Fall 2013 Java Contest:

Java Problem Statement

Security:

Students will need the ability to brainstorm all possible procedures, policies, and countermeasurements to ensure a secure site. Considerations are physical environment, hardware, software and data communications.

  • Problem solving a security issue with a bank program
  • Skill in developing a countermeasure to resolve the security issue of the bank program
  • Skills concerning programming or writing a program will NOT be needed

Fall 2014 Security Contest:

Security Test

Disclaimer*

(not all problem statements listed have starter files. The previous contest content posted on this site are merely for example purposes only.)