Beginning with a pool of 22 tasks taken from the SAM 2000 test, the panel selected 20 tasks to keep in the pool, 14 of which are identified as essential. See the list of these tasks (pdf format). Based on the expertise of faculty participants, an analysis of each task, and a review of the scores students obtained in fall 2001, an acceptable score was set at 80% or 8 out of 10 tasks completed correctly. It was further determined that 80% of all students taking the test should achieve that acceptable score.

After establishing these standards, the panel identified the domains that should be reflected in the presentation test. Specifically these include the ability to:

1. Create a background
2. Build???
3. Insert tables and charts
4. Preview final presentation
5. Set headers and footers (not automatic)
6. Print X number of slides per page
7. Follow basic design principles
8. Be ADA compliant???

Beginning with a pool of 30 tasks taken from the SAM 2000 test, the panel selected 28 tasks to keep in the pool, 22 of which are identified as essential. See the list of these tasks (pdf format). Based on the expertise of faculty participants, an analysis of each task, and a review of the scores students obtained in fall 2001, an acceptable score was set at 70% or 7 out of 10 tasks completed correctly. It was further determined that 70% of all students taking the test should achieve that acceptable score.

After establishing these standards, the panel identified the domains that should be reflected in the database test. Specifically these include the ability to:

1. Query
2. Edit/Modify records
3. Print
4. Create a table
5. Generate reports
6. Input data
7. Modify a table structure
8. Sort data
9. Combine records and fields
10. Save
11. Copy

Beginning with a pool of 38 tasks taken from the SAM 2000 test, the panel selected 37 tasks to keep in the pool, 31 of which are identified as essential. See the list of these tasks (pdf format). Based on the expertise of faculty participants, an analysis of each task, and a review of the scores students obtained in fall 2001, an acceptable score was set at 70% or 7 out of 10 tasks completed correctly. It was further determined that 75% of all students taking the test should achieve that acceptable score.

After establishing these standards, the panel identified the domains that should be reflected in the spreadsheet test. Specifically these include the ability to:

1. Split panes
2. Hide/Unhide
3. Create simple charts
4. Order mathematical operations
5. Conduct "What if" analyses
6. Format (including autoformat)
7. Present ???
8. Sort
9. Import and Export (not currently taught)

Beginning with a pool of 36 tasks taken from the SAM 2000 test, the panel selected 29 tasks to keep in the pool. See the list of these tasks (pdf format). Based on the expertise of faculty participants, an analysis of each task, and a review of the scores students obtained in fall 2001, an acceptable score was set at 80% or 8 out of 10 tasks completed correctly. It was further determined that 80% of all students taking the test should achieve that acceptable score.

After establishing these standards, the panel identified the domains that should be reflected in the word processing test. Specifically these include the ability to:

1. Use symbols
2. Create tables
3. Align text
4. Manipulate text (move, copy, paste)
5. Format text
6. Use save and print commands
7. Print part of a document
8. Use "Help"