| Software Skills Assessment | Jennifer Kreie Accounting and Business Computer Systems New Mexico State University |
Rebecca Chaney Computer Info. Systems and Quant. Analysis University of Arkansas |
Using Spreadsheet Software
The purpose of this software skills assessment is to provide the instructor with an overview of
which skills are well-known by the group taking this assessment and which skills are not familiar
to many of the students. This will help the instructor tailor the lessons to the needs of this class.
Name: ___________________________ Date: _________________
ID: ___ ___ ___ ___ ___ ___ (Your first and last initials + the last 4 digits of your phone number.)
Name of this class: ___________________________________________
Below is a list of spreadsheet software operations for you to complete. If you are not familiar with a
particular operation, simply check the box to indicate you do not know this ( Do not know this feature.) and
move to the next item. You should not spend time trying to figure out how to do something you haven't
done before in a spreadsheet.
| 1. | Enter the ID you wrote at the top of this page in cell I1, right above the text Total Points. | |
| 2. | Change the font of the spreadsheet title, which is in cell A1. Change the font to Arial, size 14. | Do not know this feature. |
| 3. | Widen the first 2 columns, which contain the student names. Set the width to 12. | Do not know this feature. |
| 4. | Add a label in cell K2. Enter the word Grade. | Do not know this feature. |
| 5. | Change the text in the all the column headings to bold. | Do not know this feature. |
| 6. | Set the alignment for cell contents to right alignment for all the column headings. | Do not know this feature. |
| 7. | Set the text alignment for cell I2, which contains the words Total Points, to text wrap so each word appears on a separate line within the same cell. | Do not know this feature. |
| 8. | Adjust the width for column G so the word spreadsheet shows completely. | Do not know this feature. |
| Save the file under the original file name. | ||
| 9. | Insert a blank row below the first row (above the column headings). | Do not know this feature. |
| 10. | Delete the current column G, which contains the column heading Internet. | Do not know this feature. |
| 11. | Put a solid border line along the bottom of the cells that contain the column headings. | Do not know this feature. |
| 12. | Move down to the cell in column A that contains the text Points Possible. Put a solid double border line along the top of the cells in this row in the first nine columns. | Do not know this feature. |
| 13. | In the Total Points column, calculate the total points for each student. Also, calculate the total for the Points Possible row. | Do not know this feature. |
| 14. | Move down in column A to the text Average. Calculate an average for each test and assignment. (You will format these numbers in the next step.) | Do not know this feature. |
| 15. | Format the averages to display only 1 number to the right of the decimal point. | Do not know this feature. |
| 16. | Move to the row in column A with the text Count. Use the appropriate function to count the number of scores in each test and assignment column. | Do not know this feature. |
| 17. | Move to the row in column A that contains the text Maximum score. Use the appropriate function to find the highest score given for each test and assignment. | Do not know this feature. |
| 18. | To help you see column headings and student names as you scroll to other parts of the spreadsheet, freeze the top three rows (which contain the column headings) and the first two columns (which contain the student names. | Do not know this feature. |
| 19. | Calculate a percentage for the first student, Tony Beard. Use absolute cell addressing to "lock in" the cell address that contains the total points possible for the course. (You'll format this cell is another step.) | Do not know this feature. |
| 20. | Copy the percentage formula you created in the previous step to the rows below for percentages for the rest of the students. | Skip this if you did not do the previous step. |
| 21. | Format the percentages to display the % sign and to show one digit to the right of the decimal point. | Do not know this feature. |
| 22. | Move to the cell in the Grade column in the row for Tony Beard. Create a function that evaluate Tony's percentage for the course. If the percentage is 70% or higher, display the text Pass. If the percentage is below 70%, display the text Fail. | Do not know this feature. |
| Save the file under the original file name. | ||
| 23 | Copy the function you created in the previous step for each of the students. | Skip this if you did not do the previous step. |
| 24. | Copy all the values displayed in the Total Points and % columns to the second worksheet. Copy the values, not the formulas. (You can put the values in the upper left corner of the second worksheet.) | Do not know this feature. |
| 25. | Print the grading worksheet -- all the column headings, students names, scores, grades, etc. | Do not know this feature. |
| 26. | Print only the student names and the columns for total points, percentage, and grade. | Do not know this feature. |
| 27. | Print only the column headings and the last four rows--points possible, average, count, and maximum score. | Do not know this feature. |
| 28. | Name the range of cells that contain the students' first and last names. Name this range of cells students. | Do not know this feature. |
| 29. | Save the spreadsheet under its original name. | Do not know this feature. |
| 30. | Save the spreadsheet under a new name on the diskette. For the new name use your ID (your first and last initials + the last four digits of your phone number). | Do not know this feature. |
| 31. | Sort the students and their semester scores. Sort them from highest to lowest based on the total points they earned for the course. | Do not know this feature. |
Spring 1998: Revised 1-13-98
Time: 35 minutes
Chaney, Horne, Kreie, Titsworth, & Van Es