Computing Skills Questionnaire

This test has been developed by Jim Greene. All rights reserved, except by written permission from the author. Please submit questions or permission requests to:

[email protected]
 
Make your Selection from the Choices Below
The QUIZ  HELP  Take the Challenge Test 
Take the Quiz
File Management Help Overview of Test
Word Processing Help Take the Test
Spreadsheet Help

If you are turning in this test as proof of you competency, please include the following information:
 


Answer each of the questions in the following sections. Keep track of the skills that you feel you can do, and those that you do not feel comfortable with. Count up the number of Yes answers you have at the end of the questionnaire. This will help determine if you are a Novice user or an Intermediate user of Windows 95 and Microsoft Office.

QUIZ

Part 1: File Management
To Get Help on File Management Topics, please click here
 
1. Are you familiar with a Windows environment? If yes, which one(s)? Y N

 

2. Can you copy a file from one disk to another?  Y N
3. Can you create a directory or folder on a floppy disk? Y N
4. Can you copy a file from one directory or folder to another directory or folder? Y N

 

5. Do you know the difference between copying a file and moving a file?  Y N

 

Part II: Word Processing:
To Get Help on these Word Processing topics, please click here
6. Can you access, start up, and use a word processing program in a Windows environment? If yes, which one(s)?

If no, please jump to question # 17.

Y N
7. Can you start a new document and save it?  Y N
8. Can you open a previously saved document, modify it, and save it again?  Y N
9. Can you format text using different fonts and different font sizes?  Y N
10. Can you cut a block of text from one place 'in a document and paste it into another area of the document?  Y N
11. Can you insert a table into a document?  Y N
12, Can you insert a picture into a document'?  Y N
13. Can you insert a file into a document?  Y N
14. Can you insert page numbers into a document?  Y N
15. Can you use a word processor to spell check a document? Y N
16. Can you print a document?  Y N

 

Part III Spreadsheets: To get help on any of these topics, please click here
 
17. Can you access, start up, and use a spreadsheet program in a Windows environment 

If yes, which one(s)?

If no, please jump to question #32

Y N
18. Can you start a new spreadsheet and save it? Y N Y N
19. Can you open a previously saved spreadsheet, modify it, and save it again? Y N Y N
20. Can you format text in a spreadsheet with different fonts and different font sizes? Y N
21. Can you format numbers in a spreadsheet as currency, as percentages, and with a specified number of decimal places?  Y N
22. Do you know how to write a formula in a spreadsheet?  Y N
23. Do you know how to enter a formula into a cell of a spreadsheet including the use of built-in functions?  Y N 
24. Can you copy the contents of a cell to other locations?  Y N
25. Do you understand the difference between relative and absolute addressing?  Y N
26. Can you create a pie chart or bar graph for appropriate spreadsheet data?  Y N
27. Given an equation of the form y = 3x' + 2x - 7, can you create a two column table of x and y values based on the equation?  Y N
28. Can you use the table described in #26 to generate a graph for the equation?  Y N
29. Can you design a spreadsheet so that whenever a particular value is altered, all calculations that depend on that value are updated appropriately?  Y N
30. Can you use built-in conditional functions such as the IF statement?  Y N
31. Can you insert additional rows or columns into a spreadsheet?  Y N

 

Part IV: The Internet and The World Wide Web
 
32. Do you know how to access the Internet?  Y N
33. Do you know how to read and send email?  Y N
34. Do you know how to use a search engine on the World Wide Web?  Y N
35. Can you retrieve documents from the World Wide Web? Y N
  1. Can you create a web page?
  2. If yes, what languages/applications/scripts have you used?
Y N
   
Total Number of Skills that you feel comfortable using.  

 

Part V: Computer Science Courses
 
 

37. Have you completed any computer applications courses?

If yes, please list the name of each course, the number of semester hours for each course, and provide a brief summary of the material covered in the course.

Check Your Results

If you feel that you can perform at least 25 of the 36 skills indicated on this quiz, and you would like to take a test based on similar activities, please contact Jim Greene at:

[email protected]

  Back to Home
Hosted by www.Geocities.ws

1