Docstoc

Formatting a Business Letter - Excel

Document Sample
Formatting a Business Letter - Excel Powered By Docstoc
					aking A Poster : Creating a Flyer in Word




                 CATEGORY                    4                               3                                2                               1                Total

                                Title can be read from 6      Title can be read from 6 ft.      Title can be read from 4 ft.   The title is too small and/or
                                ft. away and is quite         away and describes content        away and describes the         does not describe the
         Title                  creative.                     well.                             content well.                  content of the poster well.

                                At least 6 accurate facts
                                are displayed on the          4-5 accurate facts are            2-3 accurate facts are         Less than 1 accurate fact is
         Content - Accuracy     poster.                       displayed on the poster.          displayed on the poster.       displayed on the poster.

                                                                                                                               There are more than 2
                                There are no grammatical There is 1 grammatical                 There are 2 grammatical        grammatical mistakes on the
         Grammar                mistakes on the poster.  mistake on the poster.                 mistakes on the poster.        poster.

                                Graphics are all in focus     Most graphics are in focus        Most graphics are in focus
                                and the content easily        and the content easily            and the content is easily
                                viewed and identified         viewed and identified from 6      viewed and identified from     Many graphics are not clear
         Graphics -Clarity      from 6 ft. away.              ft. away.                         4 ft. away.                    or are too small.

                                All graphics are related to   All graphics are related to the
                                the topic and make it         topic and most make it easier     All graphics relate to the     Graphics do not relate to the
                                easier to understand. All     to understand. All borrowed       topic. Most borrowed           topic OR several borrowed
                                borrowed graphics have        graphics have a source            graphics have a source         graphics do not have a
         Graphics - Relevance   a source citation.            citation.                         citation.                      source citation.
                                                                                                                                                                0
                                                                                                                               Total points for First
                                                                                                                               Assignment                       0
sletters as a Communication Tool (Publisher)

         CATEGORY      4                            3                             2
        Layout -       All articles have            All articles have headlines   Most articles have
        Headlines &    headlines that capture       that accurately describe      headlines that accurately
        Captions       the reader's attention and   the content. All articles     describe the content. All
                       accurately describe the      have a byline. All graphics   articles have a byline.
                       content. All articles have   have captions.                Most graphics have
                       a byline. All graphics                                     captions.
                       have captions that
                       adequately describe the
                       people and action in the
                       graphic.

        Articles -     90-100% of the articles      85-89% of the articles        75-84% of the articles
        Purpose        establish a clear purpose    establish a clear purpose     establish a clear purpose
                       in the lead paragraph        in the lead paragraph and     in the lead paragraph and
                       and demonstrate a clear      demonstrate a clear           demonstrate a clear
                       understanding of the         understanding of the topic.   understanding of the topic.
                       topic.

        Articles -     The articles contain         The articles contain facts,   The article contains some
        Interest       facts, figures, and/or       figures, and/or word          facts or figures but is
                       word choices that make       choices that make the         marginally interesting to
                       the articles exceptionally   articles interesting to       read.
                       interesting to readers.      readers.

        Spelling and   No spelling or grammar       No more two spelling or       No more than 3 spelling
        Proofreading   errors remain after one      grammar errors remain         or grammar errors remain
                       or more people (in           after one or more people      after one or more people
                       addition to the typist)      (in addition to the typist)   (in addition to the typist)
                       read and correct the         read and correct the          read and correct the
                       newspaper.                   newspaper.                    newspaper.

        Graphics       Graphics are in focus,   Graphics are in focus and         80-100% of the graphics
                       are well-cropped and are are clearly related to the        are clearly related to the
                       clearly related to the   articles they accompany.          articles they accompany.
                       articles they accompany.
1
Articles are missing bylines
OR many articles do not
have adequate headlines
OR many graphics do not
have captions.




Less than 75% of the
articles establish a clear
purpose in the lead
paragraph and demonstrate
a clear understanding of the
topic.

The article does not contain
facts or figures that might
make it interesting to read.



Several spelling or grammar
errors remain in the final
copy of the newspaper.




More than 20% of the
graphics are not clearly
related to the articles OR no
graphics were used.

                                0
Total points for Second
Assignment                      0
Data Book rubric

 CATEGORY                          4                                  3
Data Entry         Data is appropriately entered      Data is appropriately entered
                   Data structure supports sorting    Data structure does not support
                   when appropriate                   sorting when appropriate




Formatting         Clear, easy to read cells.       Missing one area in formatting
                   Bolded labels, wrapped text,     options in the overall
                   number format tool applied where spreadsheet.
                   necessary.
Formula and        Calculations were completely     Formulas were used but didn't
                   performed using formulas within  calculate properly
Data
                   the spreadsheet.
Manipulation
Accuracy           All calculations work correctly and Some calculations did not work
                   were dynamically linked to a chart Chart was dynamic

Chart              Correct use of chart type          Chart type is appropriate
                   Title identifies purpose           Title defines the purpose
                   Labels are appropriate             Labels are somewhat distracting
                                                      but appropriate
                  2                                   1                     Total
Data contains two-three errors    Data contains four or more errors
Data structure does not support   Data structure does not support sorting
sorting when appropriate          when appropriate




Missing two or more formatting    No formatting techniques applied to the
options in the overall            spreadsheet.
spreadsheet.

Formulas were inconsistent used Formulas where not used at all within
and didn’t calculate properly.  the spreadsheet.


Calculations worked               Few calculations worked correctly and
Chart was not dynamic             were not linked to a chart

Chart type is inappropriate       Chart type is inappropriate Title
Title doesn't clearly identify    misleading
purpose                           Labels are missing or not appropriate
Labels are distracting and
inappropriate
                                  Total                                      0
                                  Total points for                           0
                                  third assignment
Mail Merge

CATEGORY 4                          3                         2
Form Letter grammar and             one grammar error or two grammar errors or
              structure are correct one structural       letter structure
              and professional      problem              inappropriate

Formatting    Complies with all     Complies with almost      Complies with several of
              the requirements on   all the requirements      the requirements on
              formatting for        on formatting for a       formatting for a business
              business letter       business letter           letter


Spelling      Document contains     Document contains         Document contains 2-3
              no spelling errors    one spelling error        spelling errors

Merged    The letters contain       The letters contain       The letters contain most
Documents all properly placed       most of the data          of the data source code
              data source code      source code               information but are not all
              information.          information which is      properly placed.
                                    properly placed
Data Merge    All of the            Most of the               Some of the information
              information for the   information for the       for the data merged
              data merged           data merged               correctly into the form
              correctly into the    correctly into the form   letter
              form letter           letter
1                                            Total
grammar errors - letter setup is incorrect




Complies with less than 5% of the
requirements on formatting for a business
letter


Document contains more than 3 spelling
errors

The letters contain less than 5% of the
data source code information and but are
not properly placed.


None of the information for the data
merged correctly into the form letter




Total Points                                 0
Total Points for                             0
fourth assignment
Multimedia Project : PowerPoint


           CATEGORY       4                     3                     2                     1                Total
          Content         Covers topic in-      Includes essential    Includes essential    Content is
                          depth with details    knowledge about       information about     minimal OR there
                          and examples.         the topic. Subject    the topic but there   are several
                          Subject               knowledge             are 1-2 factual       factual errors.
                          knowledge is          appears to be         errors.
                          excellent.            good.
          Attractiveness Makes excellent        Makes good use        Makes use of          Use of font, color,
                         use of font, color,    of font, color,       font, color,          graphics, effects
                         graphics, effects,     graphics, effects,    graphics, effects,    etc. but these
                         etc. to enhance        etc. to enhance to    etc. but              often distract from
                         the presentation.      presentation.         occasionally          the presenation
                                                                      these detract         content.
                                                                      from the
                                                                      presentation
                                                                      content.
          Organization    Content is well       Uses headings or      Content is            There was no
                          organized using       bulleted lists to     logically             clear or logical
                          headings or           organize, but the     organized for the     organizational
                          bulleted lists to     overall               most part.            structure, just lots
                          group related         organization of                             of facts.
                          material.             topics appears
                                                flawed.
          Mechanics       No misspellings       Three or fewer        Four misspellings More than 4
                          or grammatical        misspellings          and/or            errors in spelling
                          errors.               and/or                grammatical       or grammar.
                                                mechanical errors.    errors.


          Presentation    Well-rehearsed        Rehearsed with        Delivery not          Delivery not
                          with smooth           fairly smooth         smooth, but able      smooth and
                          delivery that holds   delivery that holds   to maintain           audience
                          audience              audience              interest of the       attention often
                          attention.            attention most of     audience most of      lost.
                                                the time.             the time.

                                                                                            Total                    0
                                                                                            Total points for
                                                                                            fifth assignment         0
Web Site Evaluation
    CATEGORY       4                         3                         2
Content            The sites have well-      At least 8 sites have     At least 8 sites have
                   stated clear purposes     well-stated clear         well-stated clear
                   with content              purposes with             purposes with most
                   appropriate for           content appropriate       content appropriate
                   students.                 for students.             for students.


Content Accuracy   All information           Almost all the            Some of the
                   provided on the Web       information provided      information provided
                   site is accurate.         on the Web site is        on the Web site is
                                             accurate.                 accurate.


NJCCCS             All NJCCCS                The NJCCCS                The NJCCCS
                   accurately match the      provided for at least 9   provided for at least 8
                   content on the site.      of the sites accurately   of the sites accurately
                                             match the content on      match the content on
                                             the site.                 the site.

Layout             The Web site has an       The Web pages have        The Web pages have
                   exceptionally             an attractive and         a usable layout, but
                   attractive and usable     usable layout. It is      may appear busy or
                   layout. It is easy to     easy to locate all        boring. It is easy to
                   locate all important      important elements.       locate most of the
                   elements. White                                     important elements.
                   space, graphic
                   elements and/or
                   alignment are used
                   effectively to organize
                   material.
Load Time          The pages typically       All pages typicially      One Web page
                   load very quickly (10     load reasonably           typically takes more
                   seconds or less)          quickly (10-15            than 15 seconds to
                                             seconds)                  load, but the others
                                                                       load quickly.
1                      Total
Fewer than 8 sites
have well-stated clear
purposes with much
of the content
inappropriate for
students
There are several
inaccuracies in the
content provided.



The NJCCCS
provided for at least 7
or fewer sites
accurately match the
content on the site.

The Web pages are
cluttered looking or
confusing. It is often
difficult to locate
important elements.




Web pages typically
take a more than 15
seconds to download
due to large graphics,
animations, sounds,
etc.
Total                          0
Total points for
sixth assignment               0
Article Review


CATEGORY             4                        3                          2                        1
Introduction         The introduction is      The introduction           The introduction         There is no clear
                     inviting, states the     clearly states the main    gives a basic idea as    introduction of the
(Organization)
                     main topic and           topic and previews the     to the main topic but    main topic or
                     previews the structure   structure of the paper,    is not particularly      structure of the
                     of the paper.            but is not particularly    inviting to the reader   paper.
                                              inviting to the reader.    and does not preview
                                                                         the structure of the
                                                                         paper



Grammar &            Writer makes no          Writer makes 1-2           Writer makes 3-4         Writer makes more
                     errors in grammar or     errors in grammar or       errors in grammar or     than 4 errors in
Spelling
                     spelling that distract   spelling that distract     spelling that distract   grammar or spelling
(Conventions)        the reader from the      the reader from the        the reader from the      that distract the
                     content.                 content.                   content.                 reader from the
                                                                                                  content.

Sentence Length    Every paragraph has        Almost all paragraphs      Sentences do not       Sentences rarely
(Sentence Fluency) well-structured            have sentences that        vary in length but are vary in length and
                     sentences that vary in   vary in length and are     well constructed.      appear incomplete
                     length.                  most sentences are                                or rambling.
                                              well constructed.



Word Choice          Writer uses vivid        Writer uses vivid          Writer uses              Writer uses a limited
                     words and phrases        words and phrases          standards words and      vocabulary that
                     that linger or draw      that linger or draw        phrases that state       does not
                     pictures in the          pictures in the reader's   the purpose.             communicate
                     reader's mind, and the   mind, but occasionally                              strongly or capture
                     choice and placement     the words are used                                  the reader's interest.
                     of the words seems       inaccurately or seem                                Jargon or cliches
                     accurate, natural and    overdone.                                           may be present and
                     not forced.                                                                  detract from the
                                                                                                  meaning.


Conclusion           The conclusion is        The conclusion is          The conclusion is     There is no clear
                     strong and leaves the    recognizable and ties      recognizable but      conclusion, the
(Organization)
                     reader with a feeling    up almost all the loose    does not tie up loose paper just ends.
                     that they understand     ends.                      ends.
                     what the writer is
                     "getting at."


                                                                                                  Total
                                                                                                  Total points for
                                                                                                  seventh
                                                                                                  assignment
Total




  0


  0
               EdFolio Rubric for CATA

    CATEGORY                  4                             3                          2
Content        The site has a well-stated     The site has a clearly      The site has a purpose
               clear purpose and theme        stated purpose and          not in keeping with the
               that is carried out            theme, but may have         general topic for CATA.
               throughout the site. Colors    one or two elements         At least three elements
               of background, fonts,          that do not seem to be      do not seem to be
               unvisited and visited links    related to it. Colors of    related. Colors of
               form a pleasing palette, do    background, fonts,          background, fonts,
               not detract from the           unvisited and visited       unvisited and visited
               content, and are consistent    links do not detract from   links make the content
               across pages.                  the content.                hard to read or
                                                                          otherwise distract the
                                                                          reader.
Writing        There are no errors in         There are 1-3 errors in     There are 4-5 errors in
               spelling, punctuation or       spelling, punctuation or    spelling, punctuation or
               grammar in the information     grammar in the              grammar in the
               contained on the site.         information in this site.   information in this site
                                                                          which detract from the
                                                                          meaning of the selection.




Layout         The Web site has an            The Web site has a          The Web site has a
               exceptionally attractive and   usable layout, but may      usable layout, but may
               usable layout. It is easy to   appear busy or boring. It   appear busy or boring.
               locate all important           is easy to locate most of   Important elements are
               elements. White space,         the important elements.     difficult to locate.
               graphic elements and/or
               alignment are used
               effectively to organize
               material.
Use of multimedia   The author has                  The author has              The author has
                    incorporated at least two       incorporated at least       incorporated at leastone
                    types of multimedia             one type of multimedia      type of multimedia
                    projects. Both projects and     projects. The project       projects however, the
                    links function properly. The    and link function           file/link does not work.
                    following files are             properly. The following     The following files are
                    considered mulitmedia:          files are considered        considered mulitmedia:
                       PowerPoint                   mulitmedia:                    PowerPoint
                       Excel                           PowerPoint                  Excel
                       Audio files                     Excel                       Audio files
                       Graphing                        Audio files                 Graphing
                       Inspiration                     Graphing                    Inspiration
                                                       Inspiration

Organizational      The portfolio is organized      The portfolio is            The portfolio is
Structure           into clear links which have a   organized into clear        organized into links
                    basic and simple structure.     links which have a basic    which have a basic and
                    Each artifact has a link to     and simple structure.       simple structure. One
                    the appropriate file. All       Each artifact has a link    to two artifacts have
                    links work properly.            to the appropriate file.    links that do not work.
                                                    Most links work properly.
              1              Score
The site lacks a
purpose and theme.
Colors of background,
fonts, unvisited and
visited links make the
content hard to read
and distract the reader.




There are more than 6
errors in spelling,
punctuation or grammar
in the information in this
site which detract from
the meaning of the
selection.




The Web pages are
cluttered looking or
confusing. It is often
difficult to locate
important elements.
The author has not
incorporated multimedia
projects into the Web
site.




The portfolio is
organized into links
which have a basic and
simple structure. Three
or more artifacts have
links that do not work.




Total
                          0
Total points for
eighth assignment         0
Class Participation




   Criteria                                                Points
                            4                       3                    2                   1
                Student is always         Student is late to    Student is late to   Student is late to
                prompt and regularly      class once every      class more than      class more than
                attends classes.          two weeks and         once every two       once a week
 Attendance /                             regularly attends     weeks and            and/or has poor
 Promptness                               classes.              regularly attends    attendance of
                                                                classes.             classes.


                Student proactively       Student proactively   Student rarely       Student never
                contributes to class by   contributes to        contributes to       contributes to
                offering ideas and        class by offering     class by offering    class by offering
   Level Of     asking questions more     ideas and asking      ideas and asking     ideas and asking
Engagement In   than once per class.      questions once        questions.           questions.
    Class                                 per class.



                 Student listens when     Student listens       Student does         Student does
                 others talk, both in     when others talk,     not listen when      not listen when
                 groups and in class.     both in groups and    others talk, both    others talk, both
Listening Skills Student incorporates     in class.             in groups and in     in groups and in
                 or builds off of the                           class.               class. Student
                 ideas of others.                                                    often interrupts
                                                                                     when others
                Student almost never      Student rarely        Student              speak. almost
                                                                                     Student
                displays disruptive       displays disruptive   occasionally         always displays
                behavior during class.    behavior during       displays             disruptive
   Behavior                               class.                disruptive           behavior during
                                                                behavior during      class.
                                                                class.


                Student is almost         Student is usually    Student is rarely    Student is
                always prepared for       prepared for class    prepared for         almost never
                class with assignments    with assignments      class with           prepared for
  Preparation   and required class        and required class    assignments and      class with
                materials.                materials.            required class       assignments
                                                                materials.           and required
                                                                                     class materials.
                                                                                          Total
                                                                                         Points
Total




 0




 0
 0

				
DOCUMENT INFO
Description: Formatting a Business Letter document sample