Appendix A

Computer Skills Survey-Round One

 

Please identify the basic technology skills needed at ☐ work or ☐ college in each category by:

 

1.      Checking whether you think skills are needed (Yes) or not needed (No).

2.      For each skill you have identified as needed in each category, please provide a brief rationale justifying your selection.

3.      Next, identify other skills that you think are needed but are not listed in the corresponding category: Write what the skill is about on the blank spaces provided for that purpose at the end of each category if applicable, and provide a brief rationale for each as well.

 

Basic Computer Skills

Needed

Skills

Yes

(Provide Rationale)

No

Use the Windows operating system

 

 

Use a Mac Computer

 

 

Set up a new computer

 

 

View contents of C: Drive and other drives

 

 

Use external drives or thumb drives.

 

 

Use DOS Commands

 

 

Format a floppy disk

 

 

Select appropriate software program

 

 

Copy files

 

 

Move folders and manage folders/directories on hard drive

 

 

Add a new user account to computer

 

 

Change Firewall Setting

 

 

Connect or disconnect from a wireless network

 

 

Change desktop background

 

 

Change screen resolution

 

 

Back up your computer

 

 

Install new software on a computer using a disk

 

 

Install new downloaded software from the website on a computer

 

 

Setup a computer network

 

 

Setup wireless printer

 

 

Copy files to a CD or DVD

 

 

Understand the need for virus protection, pop blockers, spyware blockers, firewalls, and filters.

 

 

Maintain password security

 

 

Toggle between software programs

 

 

Speed of keyboarding skills

 

 

Identify additional skills needed but not listed in this category, if applicable, and provide a brief rationale for each.

 

 

 

 

Word Processing Skills

Needed

Skills

Yes

(Provide Rationale)

No

Create a new blank document

 

 

Open a document

 

 

Saving a document

 

 

Insert a JPEG file (picture) to a document

 

 

Change bullet types

 

 

Change font, font size, and font color, bold, italics, and underline text

 

 

Change Word's color scheme

 

 

Show/Hide tracked changes

 

 

Change line spacing in a paragraph

 

 

Sorts lists alphabetically

 

 

Add a new source for a bibliography and create a bibliography

 

 

Hide/show formatting changes in a document

 

 

Create tables

 

 

Copy and past text

 

 

Place texts in columns

 

 

Save documents in different formats (RTF, PDF)

 

 

Create a mail merge (form letters or mailing labels)

 

 

Hyperlink to webpages, other documents, or within the same document

 

 

Add header and footer

 

 

Use find and replace existing text

 

 

Indent a block of text

 

 

Insert section breaks

 

 

Add a watermark

 

 

Identify additional skills needed but not listed in this category, if applicable

 

 

 

 

Spreadsheet Skills

Needed

Skills

Yes

(Provide Rationale)

No

Create a new spreadsheet

 

 

Enter data into a spreadsheet

 

 

Enter simple formulas such as MAX, SUM, MIN, AVG

 

 

Apply number, time, date, currency, and percentage formats.

 

 

Use an absolute reference in a formula to calculate a value as a percent of another value.

 

 

Format data as a table

 

 

Use fill handle to copy cells

 

 

Hide a column

 

 

Use a "What-If-Analysis"

 

 

Create and format charts or graphs from data

 

 

Sort and filter data

 

 

Move, copy, rename, and/or protect worksheets

 

 

Use database functions (e.g. sort, query, mail merge)

 

 

Change text directions

 

 

Change print options

 

 

Use conditional formatting

 

 

Insert JPEG file (pictures) to a spreadsheet

 

 

Add header or footer

 

 

Change column widths

 

 

Hyperlink worksheets

 

 

Remove or add rows or columns

 

 

Identify additional skills needed but not listed in this category, if applicable

 

 

 

 

Presentation Skills

Needed

Skills

Yes

(Provide Rationale

No

Create a new presentation

 

 

Delete a slide

 

 

Change content in a presentation

 

 

Save, close, and open presentation software

 

 

Create a layout from a master slide

 

 

Preview a slideshow

 

 

Apply a design template

 

 

Insert, size, and move clip art

 

 

Create WordArt objects

 

 

Add text boxes

 

 

Add connectors between objects and group objects

 

 

Add sound and video to slides

 

 

Set timings for a presentation.

 

 

Preview and print a presentation,

 

 

Export a presentation via e-mail

 

 

Animate objects (tables, charts, clip art, etc.)

 

 

Copy modify, and hide chart slide

 

 

Package presentation in a CD

 

 

Save as a pdf.

 

 

Save as a movie

 

 

Hyperlink PowerPoint for an interactive PowerPoint

 

 

Identify additional skills needed but not listed in this category, if applicable

 

 

 

 

 

 

 

Networking Skills

Needed

Skills

Yes

(Provide Rationale)

No

Set up a computer network (LAN)

 

 

Set up a computer wireless network

 

 

Set up a wire printer.

 

 

Setting up other devices, such as cellphones, tablets, and IPads

 

 

Identify additional skills needed but not listed in this category, if applicable

 

 

 

 

Graphic and Imaging Skills

Needed

Skills

Yes

(Provide Rationale)

No

Create a new image or file

 

 

Upload pictures from camera

 

 

Use editing software programs to edit pictures

 

 

Optimize pictures for online quality

 

 

Change resolution of image

 

 

Print a specific page range.

 

 

Change page orientation between landscape and portrait.

 

 

Set page margins

 

 

Resizing, cropping, and rotating images

 

 

Changing pictures colors, brightness/contrast, hues, and saturation

 

 

Understand camera raw files

 

 

Upload pictures to websites (Facebook, MySpace, Photobucket)

 

 

Identify additional skills needed but not listed in this category, if applicable

 

 

 

 

Database Skills

Needed

Database Skills

Yes

(Provide Rationale)

No

Create a new database

 

 

Enter data into an existing database

 

 

Create functions and formulas for a database

 

 

Create a database report

 

 

Use database functions (e.g. sort, query, mail merge)

 

 

Create a query of multiple databases

 

 

Set primary keys

 

 

Create forms for data entry

 

 

Identify additional skills needed but not listed in this category, if applicable

 

 

 

 

Information Retrieval/Telecommunications Skills

Needed

Skills

Yes

(Provide Rationale)

No

Send and receive electronic mails

 

 

Use online library electronic database

 

 

Use an electronic bulletin board

 

 

Locate and retrieve information over the Internet

 

 

Set up a computer teleconference

 

 

Identify and use the address bar in a web browser, back function, refresh function, and book mark.

 

 

Access information through online resources included encyclopedias and online libraries.

 

 

Use and appropriately cite references

 

 

Configure e-mail

 

 

Configure address books

 

 

Use Wikispaces or blogs

 

 

Subscribe to a discussion list

 

 

Follow copyright and plagiarism policies

 

 

Send a document as an attachment to an E-mail message

 

 

Keep copies of outgoing messages

 

 

Use Internet search engine (e.g. Google, InfoSeek) to find webpages

 

 

Create a World Wide Web page or site.

 

 

Keep track of websites visited

 

 

Use technology to collaborate with workers, teachers, and/or students.

 

 

Find primary sources of information on the Internet to produce data that is truthful and relevant

 

 

Send and receive electronic mails

 

 

Identify additional skills needed but not listed in this category, if applicable

 

 

 

                                                                                                

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Appendix B

Computer Skills Survey Template-Round Two

 

 

Please identify what you think are the top 10 skills used in work (you can substitute “work” for “college” on the duplicate template for the other group) based on the entire list and provide a rationale for your selection of each essential skill.

 

Computer Skills

Essential Skill (Only 10)

Justification

Listed Skills from Round One

(Rank skills from 1 – 10)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Appendix C

Computer Skills Survey Template-Round Three

 

Please indicate your agreement on the top 10 essential skills identified by panelists in the previous round. That is, because the sets of top 10 skills identified by each panelist may differ, there may be more than 10 skills listed below. Thus, proceed as follows: after building consensus on that, (2) ask them to rank them in order of importance, and finally (3) ask panelists to justify the ranking of each skill including examples of use in their particular context.

 

Rank order the basic technology skills needed at ☐ work or ☐ college in each category identified as important or most important by:

 

1.      For each skill on the list, indicate your agreement with what you think are the actual top 10 most essential skills in your particular context.----this should be on the second column.

2.      Next, rank-order the skills from 1 to 10 with one being the most essential skill.---third column.

3.      Finally, provide a brief justification for each ranking including examples of use.

 

Listed Skills from Round Two

Agree or disagree

Rank-Order

Justification

 

Yes

No

Ranking

Include examples