Docstoc

Business Letter Formatting - Excel

Document Sample
Business Letter Formatting - Excel Powered By Docstoc
					                                  Exceeds Expectation           Meets Expectation
                                            (10)                         (5)
8.1.A.1 - Create a multi-      Document is well formatted      Document has
page document with             showing evidence of             some evidence of
citations using word           appropriate margins, use of     formatting and
processing software in         font style, bold or italics,    choice of font style,
conjunction with other         and use of text boxes and       bold or italics, and
tools that demonstrates        word art.                       either text boxes or
the ability to format, edit,                                   word art.
and print.
8.1.A.2 - Construct a          Graph contains evidence of      Graph shows some
spreadsheet, enter data,       data, proper use of             data, mathematical
use mathematical               mathematical functions,         functions, data
functions to manipulate        data labels, and                labels, and no
and process data,              interpretation.                 interpretation.
generate charts and
graphs, and interpret the
results.
8.1.A.3 - Plan and create      Database defines all fields     Database defines
a relational database,         and data from multiple          some fields from a
define fields, input data      records. A report shows         few records. A
from multiple records,         evidence of using sort and      report shows
produce a report using         query. Proper interpretation    evidence of a query,
sort and query, and            of data is evident.             but no sorting skills.
interpret the data.                                            Improper
                                                               interpretation of
                                                               data.
8.1.A.4 - Produce a            Presentation is complete        Presentation is
multimedia project using       with appropriate use of font,   incomplete including
text, graphics, moving         background, text, graphics,     only a font style and
images, and sound.             moving images, and sound.       background, but no
                                                               graphics, images or
                                                               sound.


8.1.A.5 - Produce and          Artifacts have evidence of a    Artifacts have
edit page layouts in           variety of page layouts in      evidence of page
different formats using        Microsoft Word and              layouts in Microsoft
desktop publishing and         Publisher.                      Word only.
graphics software.
8.1.A.6 - Develop a
document or file for
inclusion into a website or
web page.
8.1.A.7 - Discuss and/or
demonstrate the
capability of emerging
technologies and
software in the creation of
documents.
8.1.A.8 - Create         Artifacts have evidence of a      Artifacts have some
documents using          well formatted resume and         evidence of
professional format      business letter.                  formatting a
including a resume and a                                   resume, but
business letter.                                           excluded the letter.
8.1.A.9 - Merge
information from one
document to another.
8.1.B.1 - Evaluate the
potentional and
implications of
contemporary and erging
computer applications for
personal, social, lifelong
learning, and workplace
needs.
                            Artifacts include proper       Artifacts give some
8.1.B.2 - Exhibit legal and citations for graphics and     citations for
ethical behaviors when      information taken from         information.
using information and       other sources.
technology, and discuss
consequences of misuse.
8.1.B.3 - Make informed
choices among
technology systems,
resources and services in
a variety of contexts.
8.1.B.4 - Demonstrate
sensitivity in
communicating with
diverse audiences using
computer and information
literacy.
8.1.B.5 - Select and use      Proper databases were        Some databases
specialized databases for     chosen for the information   chosen were useful
advanced research and         research to solve a          for the problem.
solve real world              problem.
problems.
8.1.B.6 - Integrate new       Artifacts show evidence of Artifacts show some
information into existing     information taught and new new information
knowledge base and            information researched.    gained from
communicate the results                                  research.
in a project or
presentation.
8.1.B.7 - Identify new
technologies, and other
organizational tools to
use in personal, home,
and/or work environments
for information retrieval,
entry, and presentation.
8.1.B.8 - Evaluate the       Artifacts show evidence of           Artifacts show some
accuracy, relevance, and     information needed for a             evidence of
appropriateness of           proper works cited page:             information
electronic information       author, title of article, title of   including half of the
sources.                     web site, and date                   information needed.
                             accessed and relevance to
                             assignment.
8.1.B.9 - Compose, send,
and organize e-mail
messages with or without
attachments.
8.1.B.10 - Create and
manipulate information
independently and/or
collaboratively to solve
problems, to design and
to develop products
8.1.B.11 - Evaluate and      Artifacts include all                Artifacts show some
correct non-functioning      problems encountered                 problems
technology systems           during the construction of           encountered during
necessary to accomplish      the task.                            the construction of
required tasks.                                                   the task.


8.1.B.12 - Identify a
problem in a content area
and formulate a strategy
to solve the problem
using brainstorming,
flowcharting, and
appropriate resources.
8.1.B.13 -Integrate new      Artifacts include evidence Artifacts show some
information and existing     of information found beyond evidence of
knowledge base and           the lecture in class.       information found in
communicate the results                                  class.
in a project or
presentation.
Overall assembling and
presenting of e-portfolios
Calculated Total Score
  Below Expectation      Item
          (0)
Document shows no
evidence of
formatting or editing.




Graph shows no
evidence of data,
mathematical
functions, data
labels, or
interpretation.


Database shows no
fields or any records.
No report, sort and
query, or
interpretation is
evident.




Presentation lacks
appropriate use of
text, graphics,
moving images, and
sound.



Artifacts have no
evidence for editing
in either Microsoft
Word or Microsoft
Publisher.
                         NA
                         NA




Artifacts have
improper use of
formatting a resume.



                         NA



                         NA




Artifacts have no
citations for graphics
or information.




                         NA




                         NA




None of the selected
databases were
useful in solving the
assigned problem.

Artifacts show
information taught
from class.
                         NA




Artifacts exclude the
works cited giving no
credit to the accuracy
and relevance of the
information found.



                         NA




                         NA




Artifacts show no
evidence of problems
encountered during
the construction of
the task.
                         NA




Artifacts include only
the information
discussed in class.
                        Exceeds Expectation
                                  (10)             Meets Expectation (5)       Below Expectation (0)
8.1.A.1 - Create a  Document is well              Document has some           Document shows no
multi-page          formatted showing             evidence of formatting      evidence of formatting
document with       evidence of appropriate       and choice of font style,   or editing.
citations using     margins, use of font style,   bold or italics, and
word processing     bold or italics, and use of   either text boxes or
software in         text boxes and word art.      word art.
conjunction with
other tools that
demonstrates the
ability to format,
edit, and print.
8.1.A.2 - Construct Graph contains evidence       Graph shows some            Graph shows no
a spreadsheet,      of data, proper use of        data, mathematical          evidence of data,
enter data, use     mathematical functions,       functions, data labels,     mathematical
mathematical        data labels, and              and no interpretation       functions, data labels,
functions to        interpretation.                                           or interpretation.
manipulate and
process data,
generate charts
and graphs, and
8.1.A.3 - Plan and Database defines all fields    Database defines some       Database shows no
create a relational and data from multiple        fields from a few           fields or any records.
database, define records. A report shows          records. A report shows     No report, sort and
fields, input data  evidence of using sort and    evidence of a query, but    query, or interpretation
from multiple       query. Proper                 no sorting skills.          is evident.
records, produce a interpretation of data is      Improper interpretation
report using sort   evident.                      of data.
and query, and
interpret the data.



8.1.A.4 - Produce     Presentation is complete    Presentation is             Presentation lacks
a multimedia          with appropriate use of     incomplete including        appropriate use of text,
project using text,   font, background, text,     only a font style and       graphics, moving
graphics, moving      graphics, moving images,    background, but no          images, and sound.
images, and           and sound.                  graphics, images or
sound.                                            sound.




                     Artifacts have evidence of Artifacts have evidence       Artifacts have no
8.1.A.5 - Produce
                     a variety of page layouts in of page layouts in          evidence for editing in
and edit page
                     Microsoft Word and           Microsoft Word only.        either Microsoft Word
layouts in different
                     Publisher.                                               or Microsoft Publisher,
formats using
desktop publishing
and graphics
software.
8.1.A.6 - Develop
a document or file
for inclusion into a
website or web
page.

8.1.A.7 - Discuss
and/or
demonstrate the
capability of
emerging
technologies and
software in the
creation of
documents.
8.1.A.8 - Create   Artifacts have evidence of       Artifacts have some    Artifacts have improper
documents using a well formatted resume             evidence of formatting use of formatting a
professional       and business letter.             a resume, but excluded resume.
format including a                                  the letter.
resume and a
business letter.

8.1.A.9 - Merge
information from
one document to
another.


8.1.B.1 - Evaluate
the potentional
and implications of
contemporary and
erging computer
applications for
personal, social,
lifelong learning,
and workplace
needs.
                       Artifacts include proper     Artifacts give some        Artifacts have no
8.1.B.2 - Exhibit      citations for graphics and   citations for information. citations for graphics
legal and ethical      information taken from                                  or information.
behaviors when         other sources.
using information
and technology,
and discuss
consequences of
misuse.
8.1.B.3 - Make
informed choices
among technology
systems,
resources and
services in a
variety of contexts.
8.1.B.4 -
Demonstrate
sensitivity in
communicating
with diverse
audiences using
computer and
information
literacy.
8.1.B.5 - Select       Proper databases were      Some databases           None of the selected
and use                chosen for the information chosen were useful for   databases were useful
specialized            research to solve a        the problem.             in solving the assigned
databases for          problem.                                            problem.
advanced
research and
solve real world
problems.
8.1.B.6 - Integrate Artifacts show evidence of Artifacts show some    Artifacts show
new information     information taught and new new information gained information taught from
into existing       information researched.    from research.         class.
knowledge base
and communicate
the results in a
project or
presentation.
8.1.B.7 - Identify
new technologies,
and other
organizational
tools to use in
personal, home,
and/or work
environments for
information
retrieval, entry,
and presentation.
8.1.B.8 - Evaluate    Artifacts show evidence of        Artifacts show some       Artifacts exclude the
the accuracy,         information needed for a          evidence of information   works cited giving no
relevance, and        proper works cited page:          including half of the     credit to the accuracy
appropriateness of    author, title of article, title   information needed.       and relevance of the
electronic            of web site, and date                                       information found.
information           accessed and relevance to
sources.              assignment.


8.1.B.9 -
Compose, send,
and organize e-
mail messages
with or without
attachments.
8.1.B.10 - Create
and manipulate
information
independently
and/or
collaboratively to
solve problems, to
design and to
develop products.
                      Artifacts include all             Artifacts show some       Artifacts show no
8.1.B.11 -            problems encountered              problems encountered      evidence of problems
Evaluate and          during the construction of        during the construction   encountered during the
correct non-          the task.                         of the task.              construction of the
functioning                                                                       task.
technology
systems
necessary to
accomplish
required tasks.

8.1.B.12 - Identify
a problem in a
content area and
formulate a
strategy to solve
the problem using
brainstorming,
flowcharting, and
appropriate
resources.
                    Artifacts include evidence Artifacts show some       Artifacts include only
8.1.B.13 -Integrate of information found         evidence of information the information
new information     beyond the lecture in class. found in class.         discussed in class.
and existing
knowledge base
and communicate
the results in a
project or
presentation.
Overall
assembling and
presenting of e-
portfolios
Calculated Total
Score
Item

10




10




 5




 5




 5
NA




NA




10




NA




NA




10
NA




NA




10




10




NA
10




NA




NA




5




NA
5




10

105
                                      Exceeds Expectation          (10)         Meets Expectation (5)
                                    Document is well formatted             Document has some
8.1.A.1 - Create a multi-page       showing evidence of appropriate        evidence of formatting and
document with citations using       margins, use of font style, bold or    choice of font style, bold or
word processing software in         italics, and use of text boxes and     italics, and either text boxes
conjunction with other tools that word art.                                or word art.
demonstrates the ability to
format, edit, and print.
                                    Graph contains evidence of data,       Graph shows some data,
8.1.A.2 - Construct a
                                    proper use of mathematical             mathematical functions,
spreadsheet, enter data, use
                                    functions, data labels, and            data labels, and no
mathematical functions to
                                    interpretation.                        interpretation.
manipulate and process data,
generate charts and graphs, and
interpret the results.
8.1.A.3 - Plan and create a         Database defines all fields and        Database defines some
relational database, define fields, data from multiple records. A          fields from a few records. A
input data from multiple records, report shows evidence of using           report shows evidence of a
produce a report using sort and sort and query. Proper                     query, but no sorting skills.
query, and interpret the data.      interpretation of data is evident.     Improper interpretation of
                                                                           data.

8.1.A.4 - Produce a multimedia         Presentation is complete with       Presentation is incomplete
project using text, graphics,          appropriate use of font,            including only a font style
moving images, and sound.              background, text, graphics,         and background, but no
                                       moving images, and sound.           graphics, images or sound.


                                   Artifacts have evidence of a            Artifacts have evidence of
8.1.A.5 - Produce and edit page variety of page layouts in                 page layouts in Microsoft
layouts in different formats using Microsoft Word and Publisher.           Word only.
desktop publishing and graphics
software.

8.1.A.6 - Develop a document or
file for inclusion into a website or
web page.


8.1.A.7 - Discuss and/or
demonstrate the capability of
emerging technologies and
software in the creation of
documents.
8.1.A.8 - Create documents             Artifacts have evidence of a well   Artifacts have some
using professional format              formatted resume and business       evidence of formatting a
including a resume and a               letter.                             resume, but excluded the
business letter.                                                           letter.
8.1.A.9 - Merge information from
one document to another.

8.1.B.1 - Evaluate the
potentional and implications of
contemporary and erging
computer applications for
personal, social, lifelong
learning, and workplace needs.
                                    Artifacts include proper citations Artifacts give some citations
8.1.B.2 - Exhibit legal and ethical for graphics and information taken for information.
behaviors when using                from other sources.
information and technology, and
discuss consequences of
misuse.


8.1.B.3 - Make informed choices
among technology systems,
resources and services in a
variety of contexts.


8.1.B.4 - Demonstrate sensitivity
in communicating with diverse
audiences using computer and
information literacy.
                                      Proper databases were chosen for Some databases chosen
                                      the information research to solve were useful for the problem.
8.1.B.5 - Select and use              a problem.
specialized databases for
advanced research and solve
real world problems.
                                      Artifacts show evidence of        Artifacts show some new
8.1.B.6 - Integrate new               information taught and new        information gained from
information into existing             information researched.           research.
knowledge base and
communicate the results in a
project or presentation.

8.1.B.7 - Identify new
technologies, and other
organizational tools to use in
personal, home, and/or work
environments for information
retrieval, entry, and presentation.
8.1.B.8 - Evaluate the accuracy,   Artifacts show evidence of             Artifacts show some
relevance, and appropriateness     information needed for a proper        evidence of information
of electronic information          works cited page: author, title of     including half of the
sources.                           article, title of web site, and date   information needed.
                                   accessed and relevance to
                                   assignment.



8.1.B.9 - Compose, send, and
organize e-mail messages with
or without attachments.

8.1.B.10 - Create and
manipulate information
independently and/or
collaboratively to solve
problems, to design and to
develop products
                                   Artifacts include all problems         Artifacts show some
8.1.B.11 - Evaluate and correct    encountered during the                 problems encountered
non-functioning technology         construction of the task.              during the construction of
systems necessary to                                                      the task.
accomplish required tasks.

8.1.B.12 - Identify a problem in a
content area and formulate a
strategy to solve the problem
using brainstorming,
flowcharting, and appropriate
resources.
8.1.B.13 -Integrate new            Artifacts include evidence of          Artifacts show some
information and existing           information found beyond the           evidence of information
knowledge base and                 lecture in class.                      found in class.
communicate the results in a
project or presentation.


Overall assembling and
presenting of e-portfolios
Calculated Total Score
                           Item
 Below Expectation (0)
Document shows no          10
evidence of formatting
or editing.




Graph shows no             10
evidence of data,
mathematical
functions, data labels,
or interpretation.


Database shows no          10
fields or any records.
No report, sort and
query, or interpretation
is evident.



Presentation lacks         10
appropriate use of text,
graphics, moving
images, and sound.


Artifacts have no           5
evidence for editing in
either Microsoft Word
or Microsoft Publisher.

                           NA




                           NA




Artifacts have improper    10
use of formatting a
resume.
                            NA


                            NA




Artifacts have no           5
citations for graphics or
information.



                            NA




                            NA




None of the selected        10
databases were useful
in solving the assigned
problem.


Artifacts show              10
information taught from
class.



                            NA
Artifacts exclude the    5
works cited giving no
credit to the accuracy
and relevance of the
information found.


                         NA




                         NA




Artifacts show no        10
evidence of problems
encountered during the
construction of the
task.
                         NA




Artifacts include only   10
the information
discussed in class.




                          10
                         115
                                                                  Average
                                                                   Item
                                                                   Score
                                          Student 1   Student 2
                                             10          10         10
8.1.A.1 - Create a multi-page
document with citations using word
processing software in conjunction
with other tools that demonstrates
the ability to format, edit, and print.
                                             10          10         10
8.1.A.2 - Construct a spreadsheet,
enter data, use mathematical
functions to manipulate and process
data, generate charts and graphs,
and interpret the results.
8.1.A.3 - Plan and create a relational       5           10         7.5
database, define fields, input data
from multiple records, produce a
report using sort and query, and
interpret the data.



8.1.A.4 - Produce a multimedia               5           10         7.5
project using text, graphics, moving
images, and sound.


8.1.A.5 - Produce and edit page              5           5           5
layouts in different formats using
desktop publishing and graphics
software.
8.1.A.6 - Develop a document or file        NA          NA          NA
for inclusion into a website or web
page.
                                            NA          NA          NA

8.1.A.7 - Discuss and/or
demonstrate the capability of
emerging technologies and software
in the creation of documents.
                                             10          10         10
8.1.A.8 - Create documents using
professional format including a
resume and a business letter.
                                            NA          NA          NA
8.1.A.9 - Merge information from
one document to another.
                                        NA   NA   NA
8.1.B.1 - Evaluate the potentional
and implications of contemporary
and erging computer applications for
personal, social, lifelong learning,
and workplace needs.
                                        10   5    7.5
8.1.B.2 - Exhibit legal and ethical
behaviors when using information
and technology, and discuss
consequences of misuse.
                                        NA   NA   NA
8.1.B.3 - Make informed choices
among technology systems,
resources and services in a variety
of contexts.
                                        NA   NA   NA
8.1.B.4 - Demonstrate sensitivity in
communicating with diverse
audiences using computer and
information literacy.
                                        10   10   10

8.1.B.5 - Select and use specialized
databases for advanced research
and solve real world problems.
                                        10   10   10
8.1.B.6 - Integrate new information
into existing knowledge base and
communicate the results in a project
or presentation.
                                        NA   NA   NA
8.1.B.7 - Identify new technologies,
and other organizational tools to use
in personal, home, and/or work
environments for information
retrieval, entry, and presentation.
8.1.B.8 - Evaluate the accuracy,        10   5    7.5
relevance, and appropriateness of
electronic information sources.



                                        NA   NA   NA
8.1.B.9 - Compose, send, and
organize e-mail messages with or
without attachments.
                                        NA   NA   NA
8.1.B.10 - Create and manipulate
information independently and/or
collaboratively to solve problems, to
design and to develop products
                                       5     10    7.5
8.1.B.11 - Evaluate and correct non-
functioning technology systems
necessary to accomplish required
tasks.
                                       NA    NA    NA
8.1.B.12 - Identify a problem in a
content area and formulate a
strategy to solve the problem using
brainstorming, flowcharting, and
appropriate resources.
8.1.B.13 -Integrate new information    5     10    7.5
and existing knowledge base and
communicate the results in a project
or presentation.
                                       10    10    10
Overall assembling and presenting
of e-portfolios

Calculated Total Score                 105   115

				
DOCUMENT INFO
Description: Business Letter Formatting document sample