Docstoc

Different Styles of Business Letter Formats

Document Sample
Different Styles of Business Letter Formats Powered By Docstoc
					                                                              Arch Ford/Northwest Arkansas Instructional Align
                                                                            Computer Applications II

                   AR Department of Workforce Education

       CONTENT STANDARD/
                                               Objective / Task Analysis
           Knowledge

                                          Unit 1: Formatting and Changing the Appearance of a W
1. Enduring Understanding - Spreadsheet--Formatting and Changing the Appearance of a Worksheet
1a. Essential Vocabulary - Autocomplete, Autoformat, Currency format, Embedded fonts, Fit to, Labe
1.1 Define terminology                  1.1.1 Prepare a list of terms with
                                        definitions




1.2 Describe commonly used numeric 1.2.1 Apply appropriate numeric
formats                               formats
1.3 Explain how to use custom         1.3.1 Create a custom numeric format
numeric formatting, and give examples
of when it would be needed

1.4 Explain simple alignment features 1.4.1 Use center, left, and right
                                        alignment in cells
1.5 Explain advanced formatting         1.5.1 Center text over a range of
techniques                              columns
                                        1.5.2 Wrap text on several lines of a
                                        cell
                                        1.5.3 Change indents within a cell
                                        1.5.4 Rotate text within a cell
                                        1.5.5 Add line breaks in cells
1.6 Explain how to change column        1.6.1 Change column width and row
width and row height                    height
1.7 Explain the purpose of hiding       1.7.1 Hide columns and rows
columns and rows
1.8 Explain the reasoning behind        1.8.1 Use different fonts, font sizes,
using different fonts and font features etc., to enhance the worksheet

1.9 Explain enhancing cells             1.9.1 Add borders to cells
                                        1.9.2 Add gridline borders
                                        1.9.3 Add color and shading to cells
1.10 Explain styles, AutoComplete,      1.10.1 Apply styles and AutoFormat to
and AutoFormat                          a selection or worksheet
                                        1.10.2 Use AutoComplete to enter
                                        data into a spreadsheet
1.11 Explain how to copy the format of 1.11.1 Copy the format of a cell to a
a cell to other cells                   group of selected cells
1.12 Explain how to change page         1.12.1 Using printing options,
orientation and use the "fit to" option landscape and fit to one page
                               Unit 2: Spreadsheets - Using Functions and Formulas, and Const
2. Enduring Understanding - Spreadsheets--Using Functions and Formulas, and Constructing Templa
2a. Essential Vocabulary - Absolute reference, Argument, Average function, Counta function, Count fu
function, Min function, Mixed reference, Nested function, Order of operation (math hierarchy), Relative
2.1 Define terminology                2.1.1 Prepare a list of terms with
                                      definitions




2.2 Explain common functions -        2.2.1 Use the average function in a
average, count, min, max              formula
                                      2.2.2 Use the count function in a
                                      formula
                                      2.2.3 Use the min function in a
                                      formula
                                      2.2.4 Use the max function in a
                                      formula
                                      2.2.5 Use the counta function in a
                                      formula
2.3 Explain the difference in the     2.3.1 Use the int function in a formula
integer and round functions           2.3.2 Use the round function
                                      2.3.3 Write and use formulas that use
                                      relative references
                                      2.3.4 Write and use formulas that use
                                      absolute references
                                      2.3.5 Write and use formulas that use
                                      mixed references

2.4 Define a nested function          2.4.1 Write formulas that use nested
                                      functions
2.5 Explain templates and their       2.5.1 Use a template to create a
purpose                               business form (such as an invoice)
2.6 Explain customizing or creating   2.6.1 Customize a template or create
templates                             a new template, and save as a
                                      template file
2.7 Explain how to display a cell     2.7.1 Display and print cell formulas
formula
2.8 Explain the reason for freezing   2.8.1 Freeze a title, and split a screen
titles and splitting screens
                                       Unit 3: Spreadsheet - Creating and Enhancing Charts an
3. Enduring Understanding - Spreadsheet - Creating and Enhancing Charts and Graphs
3a. Essential Vocabulary - Bar graph, Category axis, Chart title, Column chart, Data marker, Data poin
3.1 Define terminology                3.1.1 Prepare a list of terms with
                                      definitions
3.2 Identify and describe appropriate    3.2.1 Create charts to appropriately
uses for the following types of charts:  represent the data
column, bar, line, pie, XY (scatter)     3.2.2 Choose the appropriate type
                                         when constructing a chart
3.3 Identify and describe the parts of a 3.3.1 Create charts with titles,
chart                                    legends, and labels
3.4 Explain enhancements to a chart 3.4.1 Resize or move the chart
                                         3.4.2 Change fonts
                                         3.4.3 Change colors and patterns
                                         3.4.4 Add backgrounds and borders
                                         3.4.5 Add drawing objects
                                         3.4.6 Add clip art, pictures, or
                                         graphics
3.5 Explain editing features             3.5.1 Add or change data in a chart
                                         3.5.2 Change the chart type
                                          Unit 4: Word Processing - Advanced Printing and Page Fo
4. Enduring Understanding - Word Processing--Advanced Printing and Page Formatting
4a. Essential Vocabulary - Footer, Hard page break, Header, Landscape orientation, Orphan, Paginatio
break, Widow, Widow/orphan protection
4.1 Define terminology                    4.1.1 Prepare a list of terms with
                                          definitions

4.2 Describe the difference in            4.2.1 Change a document to use
landscape and portrait orientation        landscape orientation
4.3 Print special documents               4.3.1 Print an envelope
(envelopes, labels, etc.)                 4.3.2 Print labels
4.4 Explain the difference between a      4.4.1 Insert a hard page break
hard and soft page break                  4.4.2 Change the formatting of one
                                          section of a document
4.5 Define widow/orphan protection        4.5.1 Set widow/orphan protection in a
                                          document
4.6 Explain the purpose of sections       4.6.1 Set section breaks
                                          4.6.2 Change the formatting of one
                                          section of a document
4.7 Explain the process of creating       4.7.1 Add, change, and format page
and editing page numbers                  numbers
4.8 Define header and footer              4.8.1 Add a header/footer to a
                                          document
4.9 Describe the information typically    4.9.1 Add headers and footers with
given in headers and footers              various information, such as the
                                          document name, date/time, author,
                                          draft or revision number, page
                                          numbers, etc.
4.10 Explain the possible features of     4.10.1 Add headers and footers within
headers and footers in complex or         sections, change the starting page
longer documents                          number, and create continuation
                                          headers
                                    Unit 5: Word Processing - Using Styles, Templates, Wizards, a
5. Enduring Understanding - Word Processing - Using Styles, Templates, Wizards, and Mail Merge
5a. Essential Vocabulary - Data source, Field, Filter, Mail merge, Main document, Merge fields, Paragra
5.1 Define terminology                   5.1.1 Prepare a list of terms with
                                         definitions

5.2 Explain the purpose of styles      5.2.1 Apply styles to documents
5.3 Explain types of templates and     5.3.1 Use a template to create a new
their features                         document
                                       5.3.2 Create/Modify templates
5.4 Explain the purpose of a wizard    5.4.1 Use a wizard to create a
                                       document
5.5 Explain the purpose of a mail      5.5.1 Create mail-merged letters
merge                                  5.5.2 Create mail-merged labels
5.6 Explain the difference in the main 5.6.1 Create a main document and a
document and data source               data source
5.7 Describe the steps in a mail       5.7.1 Add merge fields to a main
merge                                  document
                                       5.7.2 Enter and edit records in a data
                                       source
                                       5.7.3 Merge with all records
                                       5.7.4 Merge with filtered (queried)
                                       records
                                                    Unit 6: Word Processing - Using Tables and Colum
6. Enduring Understanding - Word Processing - Using Tables and Columns
6a. Essential Vocabulary - Ascending, Cell, Column, Column break, Crop, Descending, Gridlines, Orga
text
6.1 Define terminology                   6.1.1 Prepare a list of terms with
                                         definitions

6.2 Describe the features of a table   6.2.1 Create a table with multiple rows
                                       and columns
6.3 Explain how to edit or add data to 6.3.1 Add and edit data in a table
a table
6.4 Explain how a table structure can 6.4.1 Insert cells, rows, columns
be edited                              6.4.2 Delete cells, rows, columns
                                       6.4.3 Merge and split cells
                                       6.4.4 Move and copy cells, rows, and
                                       columns
                                       6.4.5 Change the table's dimensions

6.5 Define sorting, and explain how it   6.5.1 Sort contents of a table
applies to tables
6.6 Describe commonly used table         6.6.1 Change the alignment of data in
formats                                  cells
                                         6.6.2 Use borders and shading to
                                         enhance a table
                                         6.6.3 Rotate text
6.7 Explain enhancing cells             6.7.1   Add borders to cells
                                        6.7.2   Add gridline borders
                                        6.7.3   Add color and shading to cells
6.8 Explain Table AutoFormat            6.8.1   Apply Table AutoFormat

6.9 Explain how to copy the format of   6.9.1 Copy the format of a cell to a
a cell to other cells                   group of selected cells
6.10 Explain the uses of multi-column   6.10.1 Create documents with
documents                               multicolumn layouts
6.11 Explain several ways to format     6.11.1 Change the column width and
columnar text                           spacing
                                        6.11.2 Insert column breaks
                                        6.11.3 Balance the length of columns


               Unit 7: Internet/Word Processing - Creating Résumés, Letters of Appliction, T
7. Enduring Understanding - Creating Résumés, Letters of Appliction, Term Papers, and Web Pages
7a. Essential Vocabulary - Bibliography, Hyperlink, Letter of application, Parenthetical references, Rep
7.1 Define terminology                  7.1.1 Prepare a list of terms with
                                        definitions




7.2 Describe characteristics of a well- 7.2.1 List several characteristics of a
designed résumé                         well-designed résumé

7.3 Define categories that are often    7.3.1 Compose a résumé using the
included on résumés                     student's own personal information
                                        7.3.2 Create an attractive résumé
7.4 Explain the information to be       7.4.1 Compose a letter of application
included in a letter of application     7.4.2 Correctly format a letter of
                                        application

7.5 Identify report styles              7.5.1 Research the difference in at
                                        least two report styles, such as MLA
                                        and APA
7.6 Explain the formatting of a         7.6.1 Research (including Internet
term/research paper (MLA/APA or         research) a term paper on a topic
other used by the English department    related to a class the student is taking
at your school)                         7.6.2 Compose a term paper,
                                        correctly citing sources
                                        7.6.3 Create a term paper that
                                        includes a title page, body,
                                        parenthetical references, and
                                        source/bibliography
7.7 Explain common features of Web 7.7.1 Create Web pages with text and
pages                              graphics, using software (like a word
                                   processor), being sure to include title,
                                   tables, bulleted lists, hyperlinks, and
                                   scrolling text
                                                           Unit 8: Internet/Spreadsheet/Presentation (10
8. Enduring Understanding - Integrating Internet, Speadsheet, and Presentation functions
8a. Essential Vocabulary - Integrated software (suite), Slides
8.1 Define terminology                  8.1.1 Prepare a list of terms with
                                        definitions




8.2 Explain how to organize data in a   8.2.1 Research a topic on the Internet
spreadsheet so it can be properly       8.2.2 Enter data in spreadsheets in a
charted                                 manner that leads to efficient analysis
                                        8.2.3 Create graphs and charts that
                                        illustrate the information


8.3 Explain how spreadsheets, charts, 8.3.1 Create an electronic
and graphs are placed/imported into   presentation that explains the analysis;
presentation software                 include a title slide, slides that explain
                                      and illustrate (with charts and graphs)
                                      the analysis, and a bibliography for the
                                      presentation (properly citing Internet
                                      sources)
                                      8.3.2 Make an oral presentation of the
                                      slide show to the class
                                              Unit 9: Word Processing - Scanning, Graphics, and W
9. Enduring Understanding - Scanning, Graphics, and WordArt
9a. Essential Vocabulary - Cropping, File formats, Scanner (scanning)
9.1 Define scanner/scanning             9.1.1 Use a scanner to scan an image




9.2 Explain why cropping and file size 9.2.1 Save the cropped image in
is important                           different file formats, and compare the
                                       file size and the resolution of the
                                       images
                                       9.2.2 Insert a scanned image into a
                                       document
9.3 Explain the difference in graphics9.3.1 Save the cropped image in
formats (such as .jpg, .gif, .bmp)    different file formats, and compare the
                                      file size and the resolution of the
                                      images
                                      9.3.2 Insert a scanned image into a
                                      document
9.4 Explain some common formatting 9.4.1 Insert clip art or a picture into a
for pictures                          document
9.5 Explain some common formatting 9.5.1 Re-size a scanned image and/or
features for pictures                 clip art
                                      9.5.2 Crop an image or clip art
                                      9.5.3 Copy and move images
                                      9.5.4 Position an image
9.6 Explain the purpose of using      9.6.1 Use WordArt in a document
WordArt
9.7 Explain ways WordArt can be       9.7.1 Re-size a WordArt graphic
manipulated                           9.7.2 Apply shadow, curve, and
                                      stretch to a WordArt graphic
9.8 Explain the use of shapes, lines, 9.8.1 Create a project that uses
line formatting, and grouping         shapes, line formatting, and grouping

9.9 Describe graphic manipulation        9.9.1 Insert, crop, and rotate graphics
techniques                               9.9.2 Wrap text around graphics
                                         9.9.3 Use WordArt in a document

9.10 Explain the use of different kinds 9.10.1 Make an organizational chart
of organizational charts
  Arch Ford/Northwest Arkansas Instructional Alignment
                Computer Applications II
                                                                                         Materials/    Geometry
                   Geometry / Literacy Task Analysis               Additional Vocabulary Resource
                                                                                                      Connections
                                                                                            s


atting and Changing the Appearance of a Worksheet (10 hours)
ing and Changing the Appearance of a Worksheet
mat, Currency format, Embedded fonts, Fit to, Label, Percentage format, Styles, Text Wrapping, Value
                 Literacy Standard 11 - Vocabulary, word study,
                 and fluency
                 Identify and use specialized vocabulary.
                 Use reference marterials including glossary,
                 dictionary, thesaurus, and available technology
                 to facilitate and extend learning.
- Using Functions and Formulas, and Constructing Templates (10 hours)
Functions and Formulas, and Constructing Templates
ument, Average function, Counta function, Count function, Freeze title, Function, If function, Int function, Max
nction, Order of operation (math hierarchy), Relative reference, Round function, Template, What-if analysis
                  Literacy Standard 11 - Vocabulary, word study,
                  and fluency
                  Identify and use specialized vocabulary.
                  Use reference marterials including glossary,
                  dictionary, thesaurus, and available technology
                  to facilitate and extend learning.




adsheet - Creating and Enhancing Charts and Graphs (10 hours)
g and Enhancing Charts and Graphs
s, Chart title, Column chart, Data marker, Data point, Legend, Line graph, Pie chart, Plot area, Value axis
                  Literacy Standard 11 - Vocabulary, word study,
                  and fluency
                  Identify and use specialized vocabulary.
Processing - Advanced Printing and Page Formatting (10 Horus)
vanced Printing and Page Formatting
, Header, Landscape orientation, Orphan, Pagination, Portrait orientation, Section, Section break, Soft page
                 Literacy Standard 11 - Vocabulary, word study,
                 and fluency
                 Identify and use specialized vocabulary.




essing - Using Styles, Templates, Wizards, and Mail Merge (10 hours)
ing Styles, Templates, Wizards, and Mail Merge
, Mail merge, Main document, Merge fields, Paragraph style, Query, Record, Wizard
                 Literacy Standard 11 - Vocabulary, word study,
                 and fluency
                 Identify and use specialized vocabulary.




 Word Processing - Using Tables and Columns (7 hours)
ing Tables and Columns
n, Column break, Crop, Descending, Gridlines, Organizational chart, Rotate, Row, Table, Venn diagram, Wrap

                 Literacy Standard 11 - Vocabulary, word study,
                 and fluency
                 Identify and use specialized vocabulary.
 - Creating Résumés, Letters of Appliction, Term Papers, and Web Pages (20 hours)
etters of Appliction, Term Papers, and Web Pages
 Letter of application, Parenthetical references, Report styles, Résumé, Scrolling text, Web page
                 Literacy Standard 11 - Vocabulary, word study,
                 and fluency
                 Identify and use specialized vocabulary.
                 Use reference marterials including glossary,
                 dictionary, thesaurus, and available technology
                 to facilitate and extend learning.

                 Standard 5 - Purposes, Topics, Forms, and          extraneous information,
                 Audiences                                          technical language
                 Write a variety of work-related documents such
                 as proposals… resume and letters…




                 Standard 5 - Purposes, Topics, Forms, and          salutation, closing, format,
                 Audiences                                          purpose, tone, style,
                 Write a variety of work-related documents such     audience
                 as proposals, project plans, and letters including
                 letters of employment
                 Standard 12 - Research/Inquiry Process             style manual, formal outline,
                 Organize information and use a style manual        works cited, thesis,
                 such as MLA or APA to create various levels of     parenthetical citation
                 reports
                 Standard 12 - Research/Inquiry Process             style manual, formal outline,
                 Organize information and use a style manual        works cited, thesis,
                 such as MLA or APA to create various levels of     parenthetical citation
                 reports
Unit 8: Internet/Spreadsheet/Presentation (10 hours)
 peadsheet, and Presentation functions
 te), Slides
                 Literacy Standard 11 - Vocabulary, word study,
                 and fluency
                 Identify and use specialized vocabulary.
                 Use reference marterials including glossary,
                 dictionary, thesaurus, and available technology
                 to facilitate and extend learning.

                 Standard 12 - Research/Inquiry Process
                 Use a variety of electronic sources to access
                 information
                 Access and evaluate multiple sources using a
                 variety of research tools




                 Standard 12 - Research/Inquiry Process
                 Organize information and use a style manual
                 such as MLA or APA to create various levels of
                 reports
                 Standard 1- Speaking
                 Present a formal multi-media presentation that
                 supports judgments with sound evidence and
                 well-chosen details
                 Use appropriate visual aids in presentations




ord Processing - Scanning, Graphics, and WordArt (5 hours)
and WordArt
 Scanner (scanning)
                 Literacy Standard 11 - Vocabulary, word study,
                 and fluency
                 Identify and use specialized vocabulary.
                 Use reference marterials including glossary,
                 dictionary, thesaurus, and available technology
                 to facilitate and extend learning.
                    Literacy
                  Connections




, Text Wrapping, Value
                R11.9.1
                R11.10.1
                R11.11.1
                R11.12.1
ours)

 n, If function, Int function, Max
, Template, What-if analysis
                  R11.9.1
                  R11.10.1
                  R11.11.1
                  R11.12.1




hart, Plot area, Value axis
                  R11.9.1
                  R11.10.1
                  R11.11.1
                  R11.12.1
ion, Section break, Soft page
                 R11.9.1
                 R11.10.1
                 R11.11.1
                 R11.12.1




s)
zard
               R11.9.1
               R11.10.1
               R11.11.1
               R11.12.1




w, Table, Venn diagram, Wrap

               R11.9.1
               R11.10.1
               R11.11.1
               R11.12.1
Pages (20 hours)


ng text, Web page
                R11.9.1
                R11.10.1
                R11.11.1
                R11.12.1




                W.5.12.5




                W.5.11.5




                IR.12.9.10
                IR.12.10.10
                IR.12.11.9
                IR.12.12.8
                IR.12.9.10
                IR.12.10.10
                IR.12.11.9
                IR.12.12.8
R11.9.1
R11.10.1
R11.11.1
R11.12.1




IR.12.9.4
IR.12.10.4
IR.12.11.3
IR.12.11.3




IR.12.9.10
IR.12.10.10
IR.12.11.9
IR.12.12.8
OV.1.11.2
OV.1.12.2
OV.1.9.3
OV.1.10.3




R11.9.1
R11.10.1
R11.11.1
R11.12.1

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:1005
posted:7/16/2010
language:English
pages:21
Description: Different Styles of Business Letter Formats document sample