NCDPI Logo
Top NavigationParentsStudentsParentsEducatorsHomeFindMediaTop Navigation Bar

 

Curriculum

Employment & Licensure

Reports & Statistics

Publication Sales

Education Initiatives

Events & Conferences

Agency Web Sites

Education Directory

NC Schools Listing

NCPublicSchools.org>About NCDPI>Agency Web Sites>Accountability Services >Testing Section>Computer Skills>Handbooks>Old>Performance Sample Items

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:

  1. 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.
  2. 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:

  1. Edit the title and paragraph below. You may use the "Edit Symbol Reference Table" provided below if you need assistance.
  2. 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

  1. Read the scenario.
  2. Use the database file to respond to the questions below.
  3. 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.
1. is the magazine that has the largest circulation.
2. magazine is published 6 times per year (#PUB PER YEAR) and has an advertisement cost per page (AD COST PER PG) of $4,045.
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

  1. Read the scenario.
  2. 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?


|Search | Contact Us | State of NC | Home | 

 
North Carolina Department of Public Instruction
301 N. Wilmington St.
Raleigh, NC 27601
Phone: 919-807-3300
Fax: 919-807-3482
Driving Directions

Copyright and Legal Notices