Microsoft Office – Grades 9-12
District
2853
|
Month |
Content |
Performance Standards Addressed |
Skills for Student Achievement |
Assessment |
1 Week
|
·
|
|
·
D –
Continue to develop 8th grade skills |
|
5 Weeks
|
·
Word
Processing (Word) |
|
·
I –
Format Outlines ·
I –
Format MLA style research papers with hanging indents, footnotes, and end notes ·
I –
Create a document using various column features ·
I –
Use of drop caps ·
I –
Use of Headers and Footers ·
I –
Use of Macros ·
I –
CreateTables with calculations ·
I –
Use of charts ·
I –
Use of fill-in forms ·
I –
Create table of contents ·
I –
Create index ·
I –
Use of search and replace ·
I –
Use of convert caps ·
I –
Create envelopes and labels ·
I –
Use of desktop publications ·
I –
Incorporating other applications with word processing |
·
Document
production |
|
4
Weeks |
·
Spreadsheets (Excel) |
|
·
I –
Use of sort functions ·
I –
Use of fills ·
I –
Creating charts and changing attributes ·
I –
Use of absolute cell referencing ·
I –
Create a What If… analysis ·
I –
Changing attributes of the sheet ·
I –
Use of find and replace ·
I –
Use of hide ·
I –
Create LOOKUP function ·
I –
Managing worksheets ·
I –
Introduce creating templates ·
I –
Use of spreadsheets in other applications |
·
Document
production |
|
5
Weeks |
·
Database
(Access) |
|
·
I –
Creating and using Queries ·
I –
Creating reports from database and queries ·
I –
Merging database & queries with Word ·
I –
Create fields in word processing ·
I –
Creating and using macros |
·
Document
production |
|
3
Weeks |
·
Presentation
(PowerPoint) |
|
·
I –
Create presentation with graphics from internet, scanned images, and/or
digital cameras ·
I –
Create animations in presentation ·
I –
Create variable backgrounds ·
I –
Use of sound (optional) ·
I –
Create variable slide transitions |
·
Presentation |