This series of six videos shows how to complete six UIL Computer Applications invitational tests that were given in the Fall of 2011. While this series is designed for students and coaches who compete in the Texas UIL High School Computer Applications contest, this real-life walk-though of taking actual tests will also be helpful for anyone seeking to brush up on Word, Excel and Access. In the tests, you will walk through a test that requires, among other things, all of the following:
- Use of LEFT, RIGHT, MID, SUM, IF and other functions in Excel as well as LEFT, RIGHT, AVG, IIF, and other functions (as well as combinations thereof) in the expression builder in Access
- Creation and formatting/customization of pie charts, XY Scatter Charts, and 2D cluster column charts in Excel
- Use of Absolute references in Excel to enable formulas to be copied laterally and accurately
- Import/Embedding/Formatting of Excel and Access objects into Modified Block Letters, Standard Memos and Simplified Memos in Word
- Use of the Yes/No field type in Access
- Use of update queries to update multiple fields to equal to the resultant value of input formulas
- Use of multiple ("OR") criteria to filter output data sets in a select query
- Creation and formatting of reports in Access with grouping intervals
- Export of data records and query results from Access to Excel and from Access to Word as a mail merge
- Use of Merge Codes in Word
To illustrate these things, we'll walk through each test, working through each part in Excel, Access and Word. Note that each test pdf is included in addition to ending point documents in order to allow you to compare your work to ours.
- Downloadable files are included with each video
- Videos are sold as an online subscription, good until June 1st (end of the academic year).
- Once your credit card, PayPal, or purchase order is processed/verified, we will create an account for you manually and email you login credentials. If you already have an account, please login here.
- TIP: Once your videos are viewed once, they move to the “Completed” tab. Please be sure to let your students know to look in the “Completed” tab in case someone else on your team has already viewed your videos.
ABOUT OUR UIL COMPUTER APPLICATIONS VIDEOS
Save time teaching and give your students a real chance to learn some of the concepts of the Texas UIL Computer Applications Contest with video from building a basic pivot table in Excel, to mastering complex update queries, to learning all the ‘ins and outs’ of dates and times, and much more! Each lesson incorporates the latest screencasting technology with the expertise of Huntley Tarrant. Videos are presented in a step-by-step, tutorial format so that students can follow along on their own computer, stopping and starting the video as needed to keep up.