Final Grades

Document Sample
Final Grades Powered By Docstoc
					                                                                                         4/3/2014


        Name               Basics   Website     Markup      Spreadsheets   RDBMS   Presentation
Schlenger, Lauren          60.00     0.00        0.00           0.00        0.00       0.00


        last updated on:                      Saturday, January 24, 2009




   Final Grades                                                                           1 of 22
                                         4/3/2014


Value Added Final Average Course Grade
   70.00        13.00          F




   Final Grades                           2 of 22
                                                                                                  4/3/2014


last updated on:                              Saturday, January 24, 2009
      Skills                                        Specifications                              Subtask Grade
                                       Subtask 1.1 - Sign up to the class blog
Subtask 1.1.1      become a member of the blog                                                            100
                   timeliness in becoming a member of the class list[you lose 25% of these
Subtask 1.1.2                                                                                             100
                   points for each day late]
                   Subtask 1.1 Total
                                     Subtask 1.2 - Sign up for two newsletters
Subtask 1.2.1      subscribe to Jakob Nielsen's Alertbox                                                  100
                   subscribe to either Technology Review or to at least one additional
Subtask 1.2.2                                                                                             100
                   newsletter of your choosing
Subtask 1.2.3      tell me about it in an email, on your blog, or on the class blog                       100
Subtask 1.2.4      timeliness [you lose 25% of these points for each day late]                            100
                   Subtask 1.2 Total
                        Subtask 1.3 - Using shareware.unc.edu, download and install SSH
Subtask 1.3.1      show me that you have the software on your PC by showing me that you know              100
                   how to do a screen capture
Subtask 1.3.2      skill with screen shots                                                                100
Subtask 1.3.4      timeliness [you lose 25% of these points for each day late]                            100
                   Subtask 1.3 Total
                           Subtask 1.4 - Demonstrate some basic UNIX functional skills
Subtask 1.4.1      create a password protected directory in your public_html space on ISIS                100
                   tell me in an email the name of your directory and the userid and password I
Subtask 1.4.2                                                                                             100
                   will need to use to access it
Subtask 1.4.3      timeliness [you lose 25% of these points for each day late]                            100
                   Subtask 1.4 Total
                           Subtask 1.5 - Use WHOIS to find the owner of a domain name
Subtask 1.5.1      Please find out who owns the domain name associated with one of the
                   mailing lists you signed up for.
Subtask 1.5.2      skill with screen shots
Subtask 1.5.3      consistent file naming behavior
Subtask 1.5.4      timeliness [you lose 25% of these points for each day late]
                   Subtask 1.5 Total
                          Subtask 1.6 - Trace the route of packets from client to server
Subtask 1.6.1      Please run a traceroute on domain name and copy and paste a screenshot of
                   your results into a file.
                   understanding of the difference between IP addresses and URLs (as
Subtask 1.6.2
                   identified by the language)
Subtask 1.6.3      skill with screen shots
Subtask 1.6.4      consistent file naming behavior
Subtask 1.6.5      timeliness [you lose 25% of these points for each day late]
                   Subtask 1.6 Total
                   Points for Task 1
                   Grade for Task 1




   Schlenger Task 01                                                                                3 of 22
                                 4/3/2014


                            60
Possible Points Points Earned

           90%              90
           10%              10

          100%             100

           40%              40
           40%              40

           10%              10
           10%              10
          100%             100


           65%              65

           25%              25
           10%              10
          100%             100

           80%              80
           10%              10

           10%              10
          100%             100

           55%               0

           20%               0
           15%               0
           10%               0
          100%               0

           25%               0

           30%               0

           20%               0
           15%               0
           10%               0
          100%               0
                            60
                       L




   Schlenger Task 01              4 of 22
                                                                                                        4/3/2014


 last updated on:                               Tuesday, January 06, 2009
       Skills                                        Specifications                                  Subtask Grade
                       Hardcoding: Create a web page (of your very own) using client tools
Subtask 2.1         you will create a web page using only hard code to show your HTML skills
                    you will FTP it to your public_html space on ISIS
                    you will tell me where I can find it in an email note
                    Hardcoding skills
                              Build a web site that has at least three levels of structure
Organization        you will create a home page for your site
                    you will create four second level pages (at least one of these pages will have
Organization
                    subordinate pages)
Organization        you will create from two to eight third level pages for material types
Organization        you will create from one to six fourth level pages for book subject areas
                    A viewer should be able to find the site by using a URL structured with
                    a server name/a user name                              [www.unc.edu/
                    ~YourOnyen]
Organization
                    or
                    a server name/a user name/and a site name [www.unc.edu/~YourOnyen/
                    261Task02/]
CSS                 you will incorporatemake the URL as simple as possible.
                    The goal here is to a CSS stylesheet
                    Structural skills
                    Thus, the URL should terminate at the directory level, not at the page level.
                       Let users know how current the data is and who is responsible for it.
Currency &          you will add a date updated on each page
Scripting
                    you will ensure there is a way to contact the person responsible for the web
Contact info
                    site on your home page
                    Currency & Responsibility components
                                                        Content
Linking to files    the home page will include some introductory material and a way to contact
                    the author
Design &
                    the second level pages will discuss basic information about the topic
navigation
Design &
                    the third level pages will discuss particular types of information
navigation
Design &
                    the fourth level pages will discuss particular subtypes of books
navigation
Client side         you will add a piece of JavaScript code somewhere in your site
scripting
                 Content components
                               Esthetics: Make your site look good and easy to use
Esthetics        The home page loads quickly and does not require scrolling right or left
Esthetics        The formatting from page to page is consistent
                 Esthetics skills
                  Navigation: Make sure the user can easily navigate all through your site
Linking to pages Home page should have links to all second level pages
Linking up,      Second level pages should have links to the home page, to other second level
down, and        pages, and to any third level pages directly below them
sideways
Linking up,      Third level pages should should have links to the home page, to their parent
down, and        second level page, and to other third level pages in their subgroup
sideways
Linking up,      Fourth level pages should should have links to the home page, to their parent
down, and        third level page, and to other fourth level pages in their subgroup
sideways
Image map        you may choose to add an image map as a navigation tool somewhere



      YourName Task 02                                                                                    5 of 22
                                                        4/3/2014


 Skills                             Specifications   Subtask Grade
            Navigation components
            Points for Task 2
            Grade for Task 2




YourName Task 02                                          6 of 22
                                4/3/2014


                            0
Possible Points Points Earned

           80%              0
           10%              0
           10%              0
          100%              0

           20%              0
           20%              0

           20%              0
           20%              0



            5%              0




           15%              0
          100%              0


           50%              0

           50%              0

          100%              0


           25%              0

           25%              0

           30%              0

           10%              0

           10%              0

          100%              0

           55%              0
           45%              0
          100%              0

           10%              0

           25%              0


           30%              0


           30%              0

            5%              0



   YourName Task 02              7 of 22
                                4/3/2014


Possible Points Points Earned
          100%              0
                            0
                      F




   YourName Task 02              8 of 22
                                                                                                      4/3/2014


 last updated on:                                Thursday, December 18, 2008
       Skills                                           Specifications
                                                         Set up skills
Edit text         you will remove unneeded text from the source material
Edit text         you will only include the original document in your final product
Find and Replace you will demonstrate skill with the find and replace tools (CNTL+H)
Page Setup        the e-book will print on International Standard book-sized paper.
Page Setup        you will demonstrate page setup skills
                  Set up skills
                                                     Style control skills
Create style      you will create a new style
Style change      you will convert text objects from one style to another
Create style      you will create a second new style
Style change      you may have to change additional styles
Style             you will modify an existing style
Style usage
modification      you will format parts of the text to different styles
Style usage       you will format each chapter name and/or number with specific styles
                  Style control skills
                                                       Sectioning skills
Sectioning        you will demonstrate skill with the sectioning tool
Sectioning        you will create new sections in your final document
                  Sectioning skills
                                                      Image tools skills
Image tools       you will format an image
Image tools       you will format a different image with different properties
Using objects,
grouping, and 3-D you will demonstrate skills with the image tools
tools
Image tools       you will create new image objects
                  Image tools skills
                                            Header and reference tools skills
Page numbering you will add page numbers to your document
Headers           you will use headers for the name of your document
Headers           you will use headers for the names of your chapters
Table of Contents you will format and insert a table of contents object, using the ToC tool
                  Header and reference tools skills
                                                       Admin tasks
Save and store    Place the completed subtask in your password protected directory and place a
                  hyperlink to that file on an object on your task 3 web page
Timeliness        tell me in an email note when I can use your site to download (25% point loss for
                  each day late)
                  Admin tasks
                  Points for Task 3
                  Grade for Task 3




   YourName Task 03                                                                                    9 of 22
                                              4/3/2014


                                          0
Subtask Grade Possible Points Points Earned

                          5%              0
                          5%              0
                         60%              0
                         15%              0
                         15%              0
                        100%              0

                         15%              0
                         10%              0
                         15%              0
                         10%              0
                         15%              0
                         10%              0
                         25%              0
                        100%              0

                         90%              0
                         10%              0
                        100%              0

                         25%              0
                         25%              0

                         25%              0

                         25%              0
                        100%              0

                         20%              0
                         30%              0
                         30%              0
                         20%              0
                        100%              0


                         50%              0

                         50%              0

                        100%              0
                                          0
                                    F




   YourName Task 03                           10 of 22
                                                                                                      4/3/2014


 last updated on:                             Thursday, December 18, 2008
       Skills                                        Specifications                                 Subtask Grade
                                       Worksheet Setup - on each worksheet
                       (you may be able to do some of the subtasks in this section by grouping
                                       sheets and doing it once for all sheets)
Delete sheets       you will remove some unneeded data                                                          0
Cell Formatting     you will demonstrate cell formatting skills for display purposes                            0
Cell Formatting     you will demonstrate additional cell formatting skills                                      0
                    you will demonstrate cell formatting skills based on the type of data the cells
Cell Formatting                                                                                                 0
                    contain
Row height          you will demonstrate the ability to control cell display                                    0
Column width        you will demonstrate the ability to control cell display                                    0
Cell Formatting     you will demonstrate cell formatting skills for display purposes                            0
Cell Formatting     you will demonstrate cell formatting skills for display purposes                            0
Cell Formatting     you will demonstrate cell formatting skills for display purposes                            0
Cell Formatting     you will demonstrate cell formatting skills for display purposes                            0
Cell Formatting     you will demonstrate cell formatting skills for display purposes                            0
                    you will demonstrate cell formatting skills based on the type of data the cells
Cell Formatting                                                                                                 0
                    contain
                    you will demonstrate cell formatting skills based on the type of data the cells
Cell Formatting                                                                                                 0
                    contain
Freeze Panes        you will demonstrate understanding of how and why to freeze panes                           0
Freeze Panes        you will demonstrate understanding of how and why to freeze panes                           0
Sheet creation
                    you will create new worksheets                                                                0
and naming
Sheet               you will demonstrate cell formatting skills for display purposes                              0
Sheet creation
formatting          you will create new worksheets                                                                0
and naming
Validate data    you will validate data in a column                                                               0
                 Set up skills
                                                   Hiding Data
Hiding Data      you will demonstrate how and why to hide data                                                    0
Hiding Data      you will demonstrate how and why to hide data                                                    0
                 Hiding data skills
                                                    Comments
Comment          you will comment on a cell, format the comment, and have it show                                 0
Comment          you will fomment on a cell, format the comment, and hide it                                      0
                 Comments skills
                                               Functions & Formulas
Functions        you will demonstrate facility with functions                                                     0
Functions        you will demonstrate facility with functions                                                     0
Functions        you will demonstrate facility with functions                                                     0
Formulas         you will demonstrate facility with formulas                                                      0
Formatting       you will demonstrate cell formatting skills based on the type of data the cells                  0
                 contain
Dragging values you will demonstrate understanding of how and why to drag formatting                              0
                 information from one cell to another
                 Functions & formula skills
                                                   Sorting Data
Sort             you will do a single level sort                                                                  0
Multi-level sort you will do a multi-level sort                                                                   0
                 Sorting Skills
                                                  Filtering Data
Filtering        you will demonstrate facility with a number filter                                               0
Filtering        you will demonstrate facility with a number filter                                               0



    YourName Task 04                                                                                   11 of 22
                                                                                                   4/3/2014


      Skills                                      Specifications                                Subtask Grade
Filtering        you will demonstrate facility with a number filter                                            0
                 Filtering Skills
                                                Subtotalling Data
Subtotals - sum you will demonstrate facility with the SUM function in the subtotal tool                       0
Subtotals        you will demonstrate facility with another function in the subtotal tool                      0
Subtotal display you wil demonstrate facility with minimizing the subtotaled data                              0
                 Subtotalling Skills
                                                   Data Display
Chart 1          you will create a chart that compares one data set over time                                  0
Formatting       you will demonstrate facility with the chart formatting tools                                 0
Formatting       you will demonstrate facility with the chart formatting tools                                 0
Chart 2          you will create a chart that compares multiple data sets over time                            0
Formatting       you will demonstrate facility with the chart formatting tools                                 0
Text Box         you will annotate the chart using a drawing object                                            0
Formatting       you will demonstrate facility with the chart formatting tools                                 0
                 Data display skills
                                                   Page Setup
Page Setup       you will set up the printed versions of the workbook so that the header rows                  0
                 will display on each printed page
Page Setup       you will set up the printed versions of some worksheets so that the header                    0
                 rows and the first column will display on each printed page
                 Suggestion: Wait until you have all your worksheets done, then group them
                 and do the next four things to all of them at the same time.
Page Setup       you will include footers on each worksheet page                                               0
Page Setup       you will include headers on each worksheet page                                               0
Page Setup       you will demonstrate facility with placing the data on the printed page                       0
Page Setup       you will demonstrate facility with basic page layout                                          0
                 Page Setup Skills
                                                   Admin tasks
Save and store   Save the workbook with a standard (i.e., YYYYMMDD.yourname.task04.xlsx)                       0
                 file name and provide a link to the file on your Task 4 web page.
Timeliness       25% reduction in points for each day beyond due date                                          0
                 Admin tasks
                 Points for Task 4
                 Grade for Task 4




    YourName Task 04                                                                                12 of 22
                                           4/3/2014


                                       0
Possible Points        Points Earned



                  5%                   0
                  5%                   0
                  5%                   0
                  5%                   0

                  5%                   0
                  5%                   0
                  5%                   0
                  5%                   0
                  5%                   0
                  5%                   0
                  5%                   0
                  5%                   0

                  5%                   0

               5%                      0
              10%                      0
                  5%                   0

                  5%                   0
                  5%                   0

               5%                      0
             100%                      0

              50%                      0
              50%                      0
             100%                      0

              50%                      0
              50%                      0
             100%                      0

              20%                      0
              20%                      0
              20%                      0
              20%                      0
              10%                      0

              10%                      0

             300%                      0

              50%                      0
              50%                      0
             100%                      0

              30%                      0
              35%                      0



YourName Task 04                           13 of 22
                                        4/3/2014


Possible Points     Points Earned
              35%                   0
             100%                   0

              40%                   0
              40%                   0
              20%                   0
             100%                   0

              20%                   0
              10%                   0
              10%                   0
              20%                   0
              10%                   0
              10%                   0
              10%                   0
              90%                   0

              20%                   0

              20%                   0



              15%                   0
              15%                   0
              15%                   0
              15%                   0
             100%                   0

              50%                   0

              50%                   0
             100%                   0
                                    0
                         F




YourName Task 04                        14 of 22
                                                                                                4/3/2014


last updated on:                          Thursday, December 18, 2008
      Skills                                     Specifications                              Subtask Grade
                                            Tables (to store data)
      tblBook  you will create specific table fields with specific field properties
               you will create specific table fields with specific field properties
               you will create specific table fields with specific field properties
               you will create specific table fields with specific field properties
               you will create specific table fields with specific field properties
  tblPublisher you will create specific table fields with specific field properties
               you will create specific table fields with specific field properties
               you will create specific table fields with specific field properties
               you will create specific table fields with specific field properties
               you will create specific table fields with specific field properties
               you will create specific table fields with specific field properties
    tblAuthor  you will create specific table fields with specific field properties
tblBookAuthor you will create specific table fields with specific field properties
               you will create specific table fields with specific field properties
     tblOrder  you will create specific table fields with specific field properties
               you will create specific table fields with specific field properties
               you will create specific table fields with specific field properties
               you will create specific table fields with specific field properties
               you will create specific table fields with specific field properties
               Table construction skills
                                         Relationships (to link tables)
  Primary Key you will ensure that each table you create includes a Primary Key field
  Primary Key you will ensure that each table you create includes a Primary Key field
  Primary Key you will ensure that each table you create includes a Primary Key field
  Primary Key you will ensure that each table you create includes a Primary Key field
 Foreign Keys you will insert Primary Keys as Foreign Keys in appropriate table fields
Many to many you will build a table to joint two other tables in a many to many relationship
Lookup tables you will use the Lookup Wizard to create a Combo Box to enter Foreign Keys
               values into their respective tables
Relationships you will create relationships between tables and enforce Referential Integrity
               Relationships skills
                                    Forms (to enter data into the tables)
   frmAuthor   you will use a specific layout style
               you will modify the automatically generated form
 frmPublisher you will use a specific layout style
               you will modify the automatically generated form
     frmBook   you will use a specific layout style
               you will modify the form created by the Form Wizard
               you will include a subform by using the Form Wizard
    frmOrder   Create an Orders form that will be used to generate 10 orders for books. You
               need at least ten orders of which at least five should not yet have been
               delivered (no value in the received date field).
               you will use a specific layout style
               you will include the lookup boxes that point to other fields in other tables
               you will modify the header area of the form
     General   you will pay attention to the professional appearance of all forms
Appearance of
       Forms
               Forms skills
                           Queries (to retrieve and manipulate data from tables)
                       Details for each query are on the two query session task pages
       qry01   simple single table, multiple criteria select query with sort
       qry02   simple single table, multiple criteria select query with sort and parameters



   YourName Task 05                                                                             15 of 22
                                                                                                   4/3/2014


    Skills                                        Specifications                                 Subtask Grade
    qry03       simple single table, multiple criteria select query with sort and wildcards
    qry04       simple single table, single criteria select query that meets a partial, but not
                a total match
    qry05       simple multiple table, multiple criteria select query that meets an AND match
                on similar data types
    qry06       simple multiple table, multiple criteria select query that meets an AND match
                on different data types
   qry07:       simple multiple table, multiple criteria select query that meets an OR match
                on different data types
    qry08       single table simple select query with a two criteria parameter
    qry09       simple multiple table select query that requires a COUNT on one of the
    qry10       simple multiple table select query that requires a calculated field in the query
                criteria
    qry11       simple multiple table select query that requires several calculated field in the
    qry12       simple
                query multiple table select query with bounding criteria on several fields
    qry13       simple multiple table select query with a parameter and a SUM or COUNT
                function applied to multiple fields
    qry14       simple multiple table select query with several calculated fields in the query
                and a NULL criteria
                Query skills
                  Reports (to pull data from static and dynamic tables for print display)
    rpt01       you will use the Form Wizard to create a shelf list report
report object   you will modify the header area of the report
   control
report object you will modify the footer area of the reoert with a calculated field formula
   control
   General    you will display your control over object properties by ensuring that the
Appearance of report prints out in a professional manner
   Reports
              Reports Skills
              Points for Task 5
              Grade for Task 5




  YourName Task 05                                                                                  16 of 22
                                4/3/2014


                            0
Possible Points Points Earned

            5%              0
            5%              0
            5%              0
            5%              0
            5%              0
            5%              0
            5%              0
            5%              0
            5%              0
            5%              0
            5%              0
            5%              0
            5%              0
            5%              0
           10%              0
            5%              0
            5%              0
            5%              0
            5%              0
          100%              0

           10%              0
           10%              0
           10%              0
           10%              0
           10%              0
           15%              0
           15%              0

           20%              0
          100%              0

            5%              0
            5%              0
            5%              0
            5%              0
            5%              0
            5%              0
           15%              0




            5%              0
           25%              0
            5%              0
           20%              0


          100%              0


            2%              0
            4%              0




  YourName Task 05              17 of 22
                                4/3/2014


Possible Points Points Earned
            4%              0
            4%              0

            8%              0

            8%              0

            8%              0

            8%              0
            8%              0
            8%              0
            8%              0
            9%              0
           10%              0

           11%              0

          100%              0

           30%              0
           10%              0

           20%              0

           40%              0


          100%              0
                            0
                     F




  YourName Task 05              18 of 22
                                                                                                       4/3/2014


last updated on:                                Thursday, December 18, 2008
      Skills                                          Specifications                                 Subtask Grade
                                         Layout - include a minimum of 8 slides
Templates or       you will use a design template or a theme and explain in the notes why you
  themes           selected it
                   Use the default bullet format for ONLY the overview and summary
                   slides. Every other slide in the presentation should use a format other than the
                   default slide format. If you succumb to using bullet slides, you will lose 5
Master Slides      points for each a personal logo and apply it to the master
                   you will create one.
Master Slides      you will modify the title master to include an automatically updated date as a
                   footer component.
Organization       Include an overview slide that lays out where your presentation is going to
                   go. You may use a bullet slide format if you wish.
                   Include a summary slide that wraps up your presentation with the message
Organization       you want the audience to go away remembering. Here too you may use a
                   bullet slide format if you wish.
  Templates        At least one slide should have a different background from the rest of the
                   slides (it could be the hidden slide)
                   Using your overview slide as a guide, include some sort of visible transition
Organization       device throughout the presentation so the viewer understands where he or
                   she is in the presentation. Add hyperlinks to this device so you can control
                   movement within your presentation from the objects on the slides.
                   Layout skills
                                                    Format & Design
                   Illustrate your points. Use clipart or pictures as the primary focus of slides in
                   your presentation. You may wish to incorporate screen shots on some slides.
                   At least one of the images you use should come from the Web somewhere
                   (and should include due credit for where you found it).
                   Annotate at least one of the pictures (i.e., add some explanatory text to a
                   picture using a text box or a similar device)
                   you will demonstrate facility with custom animation by making objects seem to
                   you will demonstrate facility with custom animation by making objects appear
                   move
                   on command
                   you will demonstrate facility with the drawing tools
                   you will demonstrate facility with charts in a presentation
                   Format & Design skills
                                                      Presentation
                   you will have at least one visual slide transition device
                   you will add a sound effect to at least one slide transition
                   you will hide at least one slide
                   you will have a way to get to the hidden slide and back to the presentation
                   from the hidden slide
                   you will link at least one object to something outside of the presentation
                   Add narration to the presentation. Introduce each slide with the words you
                   would use were you to present it live. This will also require you to time your
                   presentation so that it will run unattended.
                   If any of the required components would disturb the look or feel of your
                   presentation, put them on hidden slides and use the notes to explain that
                   you used these hidden slides solely to demonstrate your skill with a
                   Use the Package for CD tool to bundle all your visuals and associated files
                   particular tool.
                   into a single directory that can be downloaded and used.
                   Presentation skills
                                   Esthetics - the criteria for this section include:
                   The slide show is a well-organized, logically-connected presentation of a topic.
                   The formatting from slide to slide is consistent.
                   The slides are easy to read and presentation friendly.
                   The viewer knows where he or she is in the presentation during the
                   presentation. subjective judgement on the part of the viewer of the presentation
                   This will be a
                   (in this case, it will be my judgement)



   YourName Task 06                                                                                     19 of 22
                                                                                             4/3/2014


 Skills                                      Specifications                                Subtask Grade
            Esthetics skills
                    Formatting Decisions - the criteria for this section include:
            Use the speaker's notes feature to discuss the creative decisions that you
            The discussion needs to be as long as necessary in the presentation.
            used to decide on the features to use on the slidesto convey your thoughts and
            you need not feel compelled to go into detail, unless you feel it necessary.
            This will be a subjective judgement on my part on how well your explanations
            indicate that you understand the PowerPoint tools you are using.
            Formatting decisions skills
            Points for Task 6
            Grade for Task 6




YourName Task 06                                                                              20 of 22
                                4/3/2014


                            0
Possible Points Points Earned

           15%              0




           15%              0
           10%              0

            5%              0


            5%              0


           10%              0


           40%              0


          100%              0



           20%              0


           10%              0
           20%              0
           15%              0
           20%              0
           15%              0
          100%              0

           10%              0
           10%              0
           10%              0
           10%              0
           10%              0

           30%              0




           20%              0
          100%              0




          100%              0




  YourName Task 06              21 of 22
                                4/3/2014


Possible Points Points Earned
          100%              0




          100%              0
          100%              0
                            0
                     F




  YourName Task 06              22 of 22

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:37
posted:4/3/2014
language:Latin
pages:22