EDTL 6310 – Technology Skill Checklist
Name: Becca Wilson-Schultz Date: 8/7/2013
Word Processing Skills
Beginner
Intermediate
Advanced
Set
margins.
X
Align
(center, right, left, or proportional) text using ruler
X
Change
fonts and styles of text
X
Use
page break option to force material to new page
X
Create
a header and footer
X
Use
current date & time in header or footer
X
Use
title page option (not print header or footer on first page)
X
Use
automatic page numbering in header or footer
X
Turn
automatic formatting options off and on
X (7/7/13)
Use
indent markers to create hanging indent format, and indented quote format
X (7/14/13)
Apply
spacing and alignment with ruler options and with formatting palette and
toolbar options
X (7/14/13)
Set
tabs for columns of data
X (7/14/13)
Use
tab markers and type tabbed columns of data appropriately
X
Use
Leader Tabs
X
Use
Outline options
X
Create
columns then add text; format existing text into columns
X
Use
column break to force text to a new column
X
Use
section break to allow part of a page or one part of a document to have a
different type of formatting from another (as varied number of columns,
different margins, restarted page numbers)
X
Create
Tables using the menu bar and toolbar, with and without pre-selected text
X
Use
Tables Toolbar and menu to change the size of a table or merge or split cells
X
Use
convert text to table and table to text, using Table Menu and various
text/table formats
X
Save
and organize document files and backups
X
Use
spell checking, thesaurus, and word count
X
Use
borders and shading around text
X
Insert
a graphic from clip art or a file
X (7/28/13)
Use
text wrapping options on a graphic
X
Use
highlighting (not selection)
X
Use
Comments
X
Zoom
in and out
X
Mail
Merge with a word-processed document (a table in MS Word), a spreadsheet (in
MS Word), or a database
X
Use
‘Track Changes’
X
Copy
(Paint) text and paragraph formats
X
Advanced:
Create and use Styles
X (7/7/13)
8
11
14
Spreadsheet Skills
Beginner
Intermediate
Advanced
Enter
data in a cell
X
Align
cell data (center, justify, etc.)
X
Format
cell data (as number, date, etc.)
X
Enter
a formula in a cell
X
Use
relative references to cells in a formula
X
Use
absolute references to cells in a formula
X
Use
functions (Sum, Average, If, etc.)
X
Use
Fill Down (Fill Right, etc.)
X
Use
Fill Series
X
Create
charts from data in cells
X
Edit
chart components
X
Use
options for copying and inserting charts into Word documents, so that data
can/cannot be changed in the Word document to change the chart
X
4
4
4
Graphic Skills
Beginner
Intermediate
Advanced
Create
a drawing using draw tools
X (7/28/13)
Hide
and show Drawing toolbar
X
Add
pages to document (AppleWorks only)
X
Use
a variety of the Drawing Tools
X (7/21/13)
Create
layers of objects and move objects to different layers
X
Group
and ungroup objects
X
Change
Fill Pattern, Color, and Gradient
X (7/28/13)
Change
Line/Pen Pattern, Color, and Gradient
X
Change
Line/Pen width
X (7/28/13)
Wrap
text around graphic/make graphic in-line with text
X
Create
Text Objects for selected text (note: this is different from borders) and
before text is typed.
X (7/21/13)
Advanced:
Link text boxes
X
3
6
3
Slide Presentation Skills
Beginner
Intermediate
Advanced
Create
slides of different types
X
Apply
a background design
X
Use
transitions between slides
X
Use
“build effects” and custom animation within a slide
X (7/21/13)
Add
a graphic you created to a slide
X (7/28/13)
Change
bullets on the Slide Master
X
Change
colors of background
X
Add
a text object to a slide
X (7/28/13)
0
0
6
Database Skills
Beginner
Intermediate
Advanced
Search
for a specific record
X
Sort
records by two fields
X
Edit
records
X
Add
and delete records
X
Change
the layout of the record
X (8/7/2013)
Add
and delete fields
X (8/7/2013)
Change
the format of a field (as increase decimal places in a number field)
X (8/7/2013)
Merge
the file with a word processing document
X
1
5
2
E-mail
Beginner
Intermediate
Advanced
Send and receive messages
X
Create mailboxes/organizational divisions
X
Store addresses and use them to send mail
X
Send an attachment
X
Receive an attachment
X
Open an attachment that doesn’t open automatically (if the application is on your computer)
X
Edit and spell check your mail
X
0
0
7
16
26
36
Word Processing Skills
Beginner
Intermediate
Advanced
Set
margins.
X
Align
(center, right, left, or proportional) text using ruler
X
Change
fonts and styles of text
X
Use
page break option to force material to new page
X
Create
a header and footer
X
Use
current date & time in header or footer
X
Use
title page option (not print header or footer on first page)
X
Use
automatic page numbering in header or footer
X
Turn
automatic formatting options off and on
Use
indent markers to create hanging indent format, and indented quote format
X (7/14/13)
Apply
spacing and alignment with ruler options and with formatting palette and
toolbar options
Set
tabs for columns of data
Use
tab markers and type tabbed columns of data appropriately
X
Use
Leader Tabs
X
Use
Outline options
X
Create
columns then add text; format existing text into columns
X
Use
column break to force text to a new column
X
Use
section break to allow part of a page or one part of a document to have a
different type of formatting from another (as varied number of columns,
different margins, restarted page numbers)
X
Create
Tables using the menu bar and toolbar, with and without pre-selected text
X
Use
Tables Toolbar and menu to change the size of a table or merge or split cells
X
Use
convert text to table and table to text, using Table Menu and various
text/table formats
X
Save
and organize document files and backups
X
Use
spell checking, thesaurus, and word count
X
Use
borders and shading around text
X
Insert
a graphic from clip art or a file
Use
text wrapping options on a graphic
X
Use
highlighting (not selection)
X
Use
Comments
Zoom
in and out
X
Mail
Merge with a word-processed document (a table in MS Word), a spreadsheet (in
MS Word), or a database
X
Use
‘Track Changes’
X
Copy
(Paint) text and paragraph formats
X
Advanced:
Create and use Styles
8
11
14
Spreadsheet Skills
Beginner
Intermediate
Advanced
Enter
data in a cell
X
Align
cell data (center, justify, etc.)
X
Format
cell data (as number, date, etc.)
X
Enter
a formula in a cell
X
Use
relative references to cells in a formula
X
Use
absolute references to cells in a formula
X
Use
functions (Sum, Average, If, etc.)
X
Use
Fill Down (Fill Right, etc.)
Use
Fill Series
X
Create
charts from data in cells
X
Edit
chart components
X
Use
options for copying and inserting charts into Word documents, so that data
can/cannot be changed in the Word document to change the chart
4
4
4
Graphic Skills
Beginner
Intermediate
Advanced
Create
a drawing using draw tools
Hide
and show Drawing toolbar
X
Add
pages to document (AppleWorks only)
X
Use
a variety of the Drawing Tools
Create
layers of objects and move objects to different layers
X
Group
and ungroup objects
X
Change
Fill Pattern, Color, and Gradient
Change
Line/Pen Pattern, Color, and Gradient
X
Change
Line/Pen width
Wrap
text around graphic/make graphic in-line with text
X
Create
Text Objects for selected text (note: this is different from borders) and
before text is typed.
Advanced:
Link text boxes
X
3
6
3
Slide Presentation Skills
Beginner
Intermediate
Advanced
Create
slides of different types
X
Apply
a background design
X
Use
transitions between slides
X
Use
“build effects” and custom animation within a slide
Add
a graphic you created to a slide
Change
bullets on the Slide Master
X
Change
colors of background
X
Add
a text object to a slide
0
0
6
Database Skills
Beginner
Intermediate
Advanced
Search
for a specific record
X
Sort
records by two fields
X
Edit
records
X
Add
and delete records
X
Change
the layout of the record
Add
and delete fields
Change
the format of a field (as increase decimal places in a number field)
Merge
the file with a word processing document
X
1
5
2
E-mail
Beginner
Intermediate
Advanced
Send and receive messages
X
Create mailboxes/organizational divisions
X
Store addresses and use them to send mail
X
Send an attachment
X
Receive an attachment
X
Open an attachment that doesn’t open automatically (if the application is on your computer)
Edit and spell check your mail
X
0
0
7
16
26
36
No comments:
Post a Comment