Page 89 - Technology Plan ICT Review

Spreadsheet Skills – Excel
k
1
2
3
4
5
6
A
Create a table
x
Add and rename worksheets
x
x
x
x
Add worksheets, rows, and columns
x
x
x
x
Resize rows and columns
x
x
x
x
Select, move and copy cells
x
x
x
x
Create a database and then apply a filter to reveal patterns and relationships
X
x
x
x
Basic ascending and descending sorts
x
x
x
x
Create bar graphs that have a title and labels on the x and Y-axis
X
x
x
x
Create formulas that can do product and quotient
X
x
x
x
Create formulas that can do the sum and difference
X
x
x
x
Create line graphs that have a title and labels on the x and Y-axis
X
x
x
x
Create pictographs
X
x
x
x
Create formulas that can calculate the average
X
x
Create formulas using functions
x
x
Create pie graphs, that have labels and show percents
X
x
Word Skills
k
1
2
3
4
5
6
A
Add and Format insert object (Pictures, Paint documents, Clip Art, Graph,...)
x
Add date and time
x
Add header and footer
x
Create 3d shapes
x
Create Tables
x
Format text in Word, including changing font sizes, style, and colors
x
Insert Hyperlinks to Internet Web sites
x
Revise and Edit document
x
Save a word Document as a Web Page
x
Use drawing tools
x
Use formatting tools
x
Use picture tools
x
Use table and border tools
x
Access and launch Toolbars
x
Use the Undo command
x
Move, copy, and paste text
x
Set up Bulleted and numbered lists
x
88