The
North Tests of Computer Skills Student Handbook
(For Students Who Entered Grade 8 From 1996-1997
through 1999-2000)
Sample
Performance Items Fill in your answer each database and spreadsheet
question below and click on the "Submit" button.
Part
I: Keyboarding Techniques This task is scored
for typing accuracy, spacing, and length.
Directions:
Key,
as accurately as possible, the title and paragraphs below.
Remeber to use correct keyboarding techniques. Note: Do
not worry about any differences in word wrap between what
you type and how the paragraphs appear on this page.
When
you have finished keying the title and paragraphs, print
your work.
OUR
WEEKLY ASSEMBLY MEETING
Every
Wednesday morning the students at Smith Middle School meet
in the auditorium for assembly. The program amy include
speakers,
musiciams,
plays,
or movies.
Most of the students like assembly because we never know what
to expect.
Sometimes
at the end of the program, the principal tells us about special
upcoming events. Every spring my math club makes a presentation.
Last spring I explained how a computer does math.
Part
II: Word Processing/Editing This
task is scored for the number of correct edits and if other errors
are made while editing. You can use the NCWWII file to complete
this sample item.
Directions:
Edit
the title and paragraph below. You may use the "Edit
Symbol Reference Table" provided below if you need
assistance.
When
you have finished editing the title and paragraph, print
your work.
Part
III: Database Use Use
the MAGAZDB file to complete this sample item.
Directions:
Use your database program and the file MAGAZDB
Read
the scenario.
Use
the database file to respond to the questions below.
When
asked to "describe the steps you took to find your
answer," use appropriate database terms. For example,
"Sorted Ad Cost per pg in descending order" or
"Searched the Ad Cost per pg for all records greater
than 1,000."
Scenario:
Your school is selling magazines to raise money for class trips.
Using the database MAGAZDB, your job is to answer questions
asked by your classmates who are selling the magazines and other
classmates who are handling records of sales.
Explanation:
Use database terms to describe the steps to find the answer above.
Part
IV: Spreadsheet Use Use
the SSDRYCL file to complete this sample item.
Directions:
Use your spreadsheet program and the file SSDRYCL
Read
the scenario.
Use
the spreadsheet file to respond to the questions below.
Scenario:
The owners of a new dry cleaning business have pledged to
donate 1% of their profit to purchase books for the library
at your school. Your Computer Skills class has created the
spreadsheet SSDRYCL to help the owners keep accurate records.
On assignment a the dry cleaner's, you test the spreadsheet
in the following situations.
NOTE:
The spreadsheet automatically calculates 6% tax.
1.
Franco has $25.00 to pay for cleaning two sweaters and two overcoats.
How much change should he get back?
2.
Colleen paid $8.48 for having a number of blouses cleaned. How
many blouses did she have cleaned in all?