Presented by G.Baker
PESOS Coaches Clinic
What is Compute This?
Compute This requires both the ability to
locate information in a given domain and,
using Microsoft Excel, to interpret data
found, as well as finding the answers to
short answer questions.
You are given a total of 50 minutes to
finish the event, with a 10 minute
introduction at the beginning. Teams of 2.
50 Minute Event (5 Minute Orientation + 45 Minute Competition)
Team of Up to 2 Students
, Network Connected PC w/ WWW Access
Requires Information Search on WWW (Quantitative Data)
Spreadsheet Data Entry and Graphical Presentation
Up to 5 Additional Short Answer Questions
May Involve Analysis of Data
Previously Captured or Additional Facts to Be Captured via Internet Search
Data Tables and Graphics
Answers to Short Answer Questions + URL’s
Supervisor Will Specify if Files are to Be Saved, Printed, E
No Resource Materials or Calculators (Blank Scrap Paper is OK)
Teams May Construct a
Reference Web Site
Prior to Competition
No External Communication
during Event (E
Mail, Chat, etc.)
Be a Google Guru!
Most likely you will need to know how to use google efficiently. Here are a few tips:
Search one domain.
Use the "site:" tool to search one domain. For example, searching
"site:www.nasa.gov Pluto mass" will give you results from only the NASA.gov domain.
Use full sentences
Sometimes you want to find words that are next to each other. When
you want to do this, use quotes. For example, searching " "Pluto mass" " will give you results
with the words "Pluto" and "mass" together.
Use logical operators. Those are AND, OR, and NOT. Searching "Pluto AND
mass NOT Disney" will give you results with the word "Pluto"
the word "mass", but
the word Disney.
No memorization required
Too much info? Just click "advanced search" and all the
keywords will be filled in for you.
Google ignores words like "of", "is", "the", and so on. So "mass of Pluto" gives the
same results as "mass Pluto".
Google isn't case sensitive, so "Mass Pluto" will give the same results as "mass
Order of Words
Word order doesn't matter, so "mass pluto solar system" will give the same results
as "system mass pluto solar".
Pick your favorite.
Don't like Google? Too many search engines? Pick your favorite using
this blind search test
Reminders / Common Questions
Teams May Use
Web Resource or Search Engine
to Locate Data within the
Google, Yahoo, Ask, Bing, etc.)
However, Immediate Disqualification for E
Mail or Chat
URL’s Associated with Short Answers
Completeness and Accuracy of Quantitative Data Collected (20 Pts.)
Correct X and Y Axis Data Points in Data Table (n Pts. each)
Correct Units of Measure (n Pts., if conversion required)
Completeness, Accuracy, and Format of Graphical Presentation (30
Correct Graph Format (n Pts.)
Title Above Graph (n Pts.)
Axis Properly Labeled (n Pts.)
Axis Properly Labeled (n Pts.)
Legend Exists (n Pts.)
At Least One Data Point Plotted (n Pts. each)
Answers and URL’s Associated with Short Answer Questions (50 Pts.)
Correct Answers with Valid URL’s (n Pts. each)
Tie Breakers are: (1) Short Answer Questions, (2) Quantitative Data Collected,
and (3) Overall Graphical Quality. Time is
a Tie Breaker.
Preparing a Team
Efficient Use of WWW Browser and Search Engine (e.g. Google)
Intelligent Selection of “Keywords” for Searches
Use of “Operators” to Narrow Searches (e.g. “and”, “or”, etc.)
Extraction of Numeric Data from Tables or Text (Manual Transcription)
Construction of (Non Password Protected) Team Web Site
Efficient Use of Spreadsheet Tools for Charting of Numeric Data
Construction of Data Tables
Familiarity with Chart Types and Sub
Proper Insertion of Titles, Axis Labels, and Legends
Follow Instructions Carefully in Problem Statement
Use of Word Processor for Short Answer Questions (Up to Five
Basic Word Processing (Advanced Features Not Required)
Data Entry of Short Answers… Complete Sentences Not Required
Ability to Copy & Paste Source URLs from Web Browser to Word Processor
Common Challenges in Compute
Multiple Web Searches
Required to Find Quantitative Data
Quantitative Data Buried Deep
in a Large Data Table
Required to Locate Quantitative Data or Short
Mathematical Calculation or a Conversion of Units
to Determine Age of People or Events
Mature, Unflappable Test
are the Medalists in Compute
Student Constructed Web Sites Can Greatly Assist in Preparation
Across a Broad Range of Students
Don’t Prejudge Success or Failure
This is as Much of a Quantitative Data (Math) Event as a Computing Event
In Division B,
is a Key Factor (i.e. 8th and 9th Graders)
: Mastery of NOAA Subject Matter is
Requisite… the Ability Search & Graph
. Topical Familiarity Can Help, However.
Structured Practice Sessions
Develop Practice Problems in a Format Similar to Today’s Examples
Conduct Practices in a Computing Lab, if Possible (Simulate Competition)
3 Hours of Coaching Prep for Each Hour of Team Practice
competent Parent or Math/Tech Instructor as Coach
Attention to Detail
on Spreadsheet Graphics
Label Axes and Data Points, Use Correct Units of Measure, etc.)
Role Sharing Strategy
for the Team
is to Maximize Points Earned During a 50 Minute Competition
Disciplined Time Management
are Keys to Success!
Day of the Event
When you are actually in the room taking the exam there are some very important things to
consider as you work through the task:
Read the Directions
including the rubric (once, twice, its worth the time) Your proctor may
even give a reading period and you need to use it.
Identify the problems
that may take longer and also the problems that you can solve quickly.
You do not have to create your graph and data table before the questions. These questions are
generally half your score and may be much easier to find and possibly even lead you to find the
major data for your graph. This is why you should read the rubric if its provided and know the
point scale...sometimes you can even get points for a blank graph that has an appropriate title.
and get as many points as you can in the time allotted. If you have practiced
searching for data and know excel you will do fine.
if a search isn't working change the terms...a good rule of thumb was that if there was nothing
in the first three results, move on with new search terms.
Use your partner
, because the person sitting next to you can think of new search terms, write
down data to be transferred, etc. Your partner can also be especially useful in reading
directions and making sure you didn't miss anything (this is key for graphs
as the proctor may
want data in alphabetical order or something that is not always typical)
Know your partner and work well with them having an enemy as a partner is not going to be
on the exam sheet make sure you do not forget to put on data labels or put it
in alphabetical order or specific font types and formatting your answer sheet. This especially
applies to the graph portion of the test. You do not want to lose points for stuff that if you read
the exam could have been done quickly and easily.
Microsoft Excel tutorials
2003 Nationals Test
Compute This 2006
Compute This 2006
Compute This 2006
New England Landing
Pinot Noir Grape Harvest