679eb0d5-09a0-4f64-9bbe-23a570ca88ed.xlsx 1/23/2012
Name Basics Website Markup Spreadsheets RDBMS Presentation Value Added Final Average Course Grade
LastName, FirstName 0.00 0.00 0.00 0.00 0.00 0.00 70.00 7.00 F
last updated on: Tuesday, January 06, 2009
Final Grades 1 of 19
679eb0d5-09a0-4f64-9bbe-23a570ca88ed.xlsx 1/23/2012
last updated on: Tuesday, January 06, 2009 0
Skills Specifications Subtask Grade Possible Points Points Earned
Subtask 1.1 - Sign up to the class blog
Subtask 1.1.1 become a member of the blog 90% 0
timeliness in becoming a member of the class list[you lose 25% of these points
Subtask 1.1.2 10% 0
for each day late]
Subtask 1.1 Total 100% 0
Subtask 1.2 - Using shareware.unc.edu, download and install SSH
show me that you have the software on your PC by showing me that you know
Subtask 1.3.1 65% 0
how to do a screen capture
Subtask 1.3.2 skill with screen shots 25% 0
Subtask 1.3.4 timeliness [you lose 25% of these points for each day late] 10% 0
Subtask 1.2 Total 100% 0
Subtask 1.3 - Demonstrate some basic UNIX functional skills
Subtask 1.4.1 create a password protected directory in your public_html space on ISIS 80% 0
tell me in an email the name of your directory and the userid and password I
Subtask 1.4.2 10% 0
will need to use to access it
Subtask 1.4.3 timeliness [you lose 25% of these points for each day late] 10% 0
Subtask 1.3 Total 100% 0
Subtask 1.4 - Use WHOIS to find the owner of a domain name
Please find out who owns the domain name associated with one of the mailing
Subtask 1.5.1 55% 0
lists you signed up for.
Subtask 1.5.2 skill with screen shots 20% 0
Subtask 1.5.3 consistent file naming behavior 15% 0
Subtask 1.5.4 timeliness [you lose 25% of these points for each day late] 10% 0
Subtask 1.4 Total 100% 0
Subtask 1.5 - Trace the route of packets from client to server
Please run a traceroute on domain name and copy and paste a screenshot of
Subtask 1.6.1 25% 0
your results into a file.
understanding of the difference between IP addresses and URLs (as identified
Subtask 1.6.2 30% 0
by the language)
YourName Task 01 2 of 19
679eb0d5-09a0-4f64-9bbe-23a570ca88ed.xlsx 1/23/2012
Skills Specifications Subtask Grade Possible Points Points Earned
Subtask 1.6.3 skill with screen shots 20% 0
Subtask 1.6.4 consistent file naming behavior 15% 0
Subtask 1.6.5 timeliness [you lose 25% of these points for each day late] 10% 0
Subtask 1.5 Total 100% 0
Points for Task 1 0
Grade for Task 1 F
YourName Task 01 3 of 19
679eb0d5-09a0-4f64-9bbe-23a570ca88ed.xlsx 1/23/2012
last updated on: Tuesday, January 06, 2009 0
Skills Specifications Subtask Grade Possible Points Points Earned
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 80% 0
you will FTP it to your public_html space on ISIS 10% 0
you will tell me where I can find it in an email note 10% 0
Hardcoding skills 100% 0
Build a web site that has at least three levels of structure
Organization you will create a home page for your site 20% 0
you will create four second level pages (at least one of these pages will have
Organization 20% 0
subordinate pages)
Organization you will create from two to eight third level pages for material types 20% 0
Organization you will create from one to six fourth level pages for book subject areas 20% 0
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]
or
Organization 5% 0
a server name/a user name/and a site name
[www.unc.edu/~YourOnyen/261Task02/]
The goal here is to make the URL as simple as possible.
Thus, the URL should terminate at the directory level, not at the page level.
CSS you will incorporate a CSS stylesheet 15% 0
Structural skills 100% 0
Let users know how current the data is and who is responsible for it.
Currency &
you will add a date updated on each page 50% 0
Scripting
you will ensure there is a way to contact the person responsible for the web site
Contact info 50% 0
on your home page
Currency & Responsibility components 100% 0
Content
YourName Task 02 4 of 19
679eb0d5-09a0-4f64-9bbe-23a570ca88ed.xlsx 1/23/2012
Skills Specifications Subtask Grade Possible Points Points Earned
the home page will include some introductory material and a way to contact
Linking to files 25% 0
the author
Design &
the second level pages will discuss basic information about the topic 25% 0
navigation
Design &
the third level pages will discuss particular types of information 30% 0
navigation
Design &
the fourth level pages will discuss particular subtypes of books 10% 0
navigation
Client side
you will add a piece of JavaScript code somewhere in your site 10% 0
scripting
Content components 100% 0
Esthetics: Make your site look good and easy to use
Esthetics The home page loads quickly and does not require scrolling right or left 55% 0
Esthetics The formatting from page to page is consistent 45% 0
Esthetics skills 100% 0
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 10% 0
Linking up,
Second level pages should have links to the home page, to other second level
down, and 25% 0
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 30% 0
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 30% 0
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 5% 0
Navigation components 100% 0
YourName Task 02 5 of 19
679eb0d5-09a0-4f64-9bbe-23a570ca88ed.xlsx 1/23/2012
Skills Specifications Subtask Grade Possible Points Points Earned
Points for Task 2 0
Grade for Task 2 F
YourName Task 02 6 of 19
679eb0d5-09a0-4f64-9bbe-23a570ca88ed.xlsx 1/23/2012
last updated on: Thursday, December 18, 2008 0
Skills Specifications Subtask Grade Possible Points Points Earned
Set up skills
Edit text you will remove unneeded text from the source material 5% 0
Edit text you will only include the original document in your final product 5% 0
Find and Replace you will demonstrate skill with the find and replace tools (CNTL+H) 60% 0
Page Setup the e-book will print on International Standard book-sized paper. 15% 0
Page Setup you will demonstrate page setup skills 15% 0
Set up skills 100% 0
Style control skills
Create style you will create a new style 15% 0
Style change you will convert text objects from one style to another 10% 0
Create style you will create a second new style 15% 0
Style change you may have to change additional styles 10% 0
Style modification you will modify an existing style 15% 0
Style usage you will format parts of the text to different styles 10% 0
Style usage you will format each chapter name and/or number with specific styles 25% 0
Style control skills 100% 0
Sectioning skills
Sectioning you will demonstrate skill with the sectioning tool 90% 0
Sectioning you will create new sections in your final document 10% 0
Sectioning skills 100% 0
Image tools skills
Image tools you will format an image 25% 0
Image tools you will format a different image with different properties 25% 0
Using objects,
grouping, and 3-D you will demonstrate skills with the image tools 25% 0
tools
Image tools you will create new image objects 25% 0
YourName Task 03 7 of 19
679eb0d5-09a0-4f64-9bbe-23a570ca88ed.xlsx 1/23/2012
Skills Specifications Subtask Grade Possible Points Points Earned
Image tools skills 100% 0
Header and reference tools skills
Page numbering you will add page numbers to your document 20% 0
Headers you will use headers for the name of your document 30% 0
Headers you will use headers for the names of your chapters 30% 0
Table of Contents you will format and insert a table of contents object, using the ToC tool 20% 0
Header and reference tools skills 100% 0
Admin tasks
Place the completed subtask in your password protected directory and place a
Save and store 50% 0
hyperlink to that file on an object on your task 3 web page
tell me in an email note when I can use your site to download (25% point loss for each
Timeliness 50% 0
day late)
Admin tasks 100% 0
Points for Task 3 0
Grade for Task 3 F
YourName Task 03 8 of 19
679eb0d5-09a0-4f64-9bbe-23a570ca88ed.xlsx 1/23/2012
last updated on: Thursday, December 18, 2008 0
Skills Specifications Subtask Grade Possible Points Points Earned
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 5% 0
Cell Formatting you will demonstrate cell formatting skills for display purposes 0 5% 0
Cell Formatting you will demonstrate additional cell formatting skills 0 5% 0
you will demonstrate cell formatting skills based on the type of data the cells
Cell Formatting 0 5% 0
contain
Row height you will demonstrate the ability to control cell display 0 5% 0
Column width you will demonstrate the ability to control cell display 0 5% 0
Cell Formatting you will demonstrate cell formatting skills for display purposes 0 5% 0
Cell Formatting you will demonstrate cell formatting skills for display purposes 0 5% 0
Cell Formatting you will demonstrate cell formatting skills for display purposes 0 5% 0
Cell Formatting you will demonstrate cell formatting skills for display purposes 0 5% 0
Cell Formatting you will demonstrate cell formatting skills for display purposes 0 5% 0
you will demonstrate cell formatting skills based on the type of data the cells
Cell Formatting 0 5% 0
contain
you will demonstrate cell formatting skills based on the type of data the cells
Cell Formatting 0 5% 0
contain
Freeze Panes you will demonstrate understanding of how and why to freeze panes 0 5% 0
Freeze Panes you will demonstrate understanding of how and why to freeze panes 0 10% 0
Sheet creation
you will create new worksheets 0 5% 0
and naming
Sheet formatting you will demonstrate cell formatting skills for display purposes 0 5% 0
Sheet creation
you will create new worksheets 0 5% 0
and naming
Validate data you will validate data in a column 0 5% 0
YourName Task 04 9 of 19
679eb0d5-09a0-4f64-9bbe-23a570ca88ed.xlsx 1/23/2012
Skills Specifications Subtask Grade Possible Points Points Earned
Set up skills 100% 0
Hiding Data
Hiding Data you will demonstrate how and why to hide data 0 50% 0
Hiding Data you will demonstrate how and why to hide data 0 50% 0
Hiding data skills 100% 0
Comments
Comment you will comment on a cell, format the comment, and have it show 0 50% 0
Comment you will fomment on a cell, format the comment, and hide it 0 50% 0
Comments skills 100% 0
Functions & Formulas
Functions you will demonstrate facility with functions 0 20% 0
Functions you will demonstrate facility with functions 0 20% 0
Functions you will demonstrate facility with functions 0 20% 0
Formulas you will demonstrate facility with formulas 0 20% 0
Formatting you will demonstrate cell formatting skills based on the type of data the cells 0 10% 0
contain
Dragging values you will demonstrate understanding of how and why to drag formatting 0 10% 0
information from one cell to another
Functions & formula skills 300% 0
Sorting Data
Sort you will do a single level sort 0 50% 0
Multi-level sort you will do a multi-level sort 0 50% 0
Sorting Skills 100% 0
Filtering Data
Filtering you will demonstrate facility with a number filter 0 30% 0
Filtering you will demonstrate facility with a number filter 0 35% 0
Filtering you will demonstrate facility with a number filter 0 35% 0
Filtering Skills 100% 0
Subtotalling Data
Subtotals - sum you will demonstrate facility with the SUM function in the subtotal tool 0 40% 0
YourName Task 04 10 of 19
679eb0d5-09a0-4f64-9bbe-23a570ca88ed.xlsx 1/23/2012
Skills Specifications Subtask Grade Possible Points Points Earned
Subtotals you will demonstrate facility with another function in the subtotal tool 0 40% 0
Subtotal display you wil demonstrate facility with minimizing the subtotaled data 0 20% 0
Subtotalling Skills 100% 0
Data Display
Chart 1 you will create a chart that compares one data set over time 0 20% 0
Formatting you will demonstrate facility with the chart formatting tools 0 10% 0
Formatting you will demonstrate facility with the chart formatting tools 0 10% 0
Chart 2 you will create a chart that compares multiple data sets over time 0 20% 0
Formatting you will demonstrate facility with the chart formatting tools 0 10% 0
Text Box you will annotate the chart using a drawing object 0 10% 0
Formatting you will demonstrate facility with the chart formatting tools 0 10% 0
Data display skills 90% 0
Page Setup
Page Setup you will set up the printed versions of the workbook so that the header rows 0 20% 0
will display on each printed page
Page Setup you will set up the printed versions of some worksheets so that the header rows 0 20% 0
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 15% 0
Page Setup you will include headers on each worksheet page 0 15% 0
Page Setup you will demonstrate facility with placing the data on the printed page 0 15% 0
Page Setup you will demonstrate facility with basic page layout 0 15% 0
Page Setup Skills 100% 0
Admin tasks
Save and store Save the workbook with a standard (i.e., YYYYMMDD.yourname.task04.xlsx) file 0 50% 0
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 50% 0
YourName Task 04 11 of 19
679eb0d5-09a0-4f64-9bbe-23a570ca88ed.xlsx 1/23/2012
Skills Specifications Subtask Grade Possible Points Points Earned
Admin tasks 100% 0
Points for Task 4 0
Grade for Task 4 F
YourName Task 04 12 of 19
679eb0d5-09a0-4f64-9bbe-23a570ca88ed.xlsx 1/23/2012
last updated on: Thursday, December 18, 2008 0
Skills Specifications Subtask Grade Possible Points Points Earned
Tables (to store data)
tblBook you will create specific table fields with specific field properties 5% 0
you will create specific table fields with specific field properties 5% 0
you will create specific table fields with specific field properties 5% 0
you will create specific table fields with specific field properties 5% 0
you will create specific table fields with specific field properties 5% 0
tblPublisher you will create specific table fields with specific field properties 5% 0
you will create specific table fields with specific field properties 5% 0
you will create specific table fields with specific field properties 5% 0
you will create specific table fields with specific field properties 5% 0
you will create specific table fields with specific field properties 5% 0
you will create specific table fields with specific field properties 5% 0
tblAuthor you will create specific table fields with specific field properties 5% 0
tblBookAuthor you will create specific table fields with specific field properties 5% 0
you will create specific table fields with specific field properties 5% 0
tblOrder you will create specific table fields with specific field properties 10% 0
you will create specific table fields with specific field properties 5% 0
you will create specific table fields with specific field properties 5% 0
you will create specific table fields with specific field properties 5% 0
you will create specific table fields with specific field properties 5% 0
Table construction skills 100% 0
Relationships (to link tables)
Primary Key you will ensure that each table you create includes a Primary Key field 10% 0
Primary Key you will ensure that each table you create includes a Primary Key field 10% 0
Primary Key you will ensure that each table you create includes a Primary Key field 10% 0
Primary Key you will ensure that each table you create includes a Primary Key field 10% 0
Foreign Keys you will insert Primary Keys as Foreign Keys in appropriate table fields 10% 0
Many to many you will build a table to joint two other tables in a many to many relationship 15% 0
YourName Task 05 13 of 19
679eb0d5-09a0-4f64-9bbe-23a570ca88ed.xlsx 1/23/2012
Skills Specifications Subtask Grade Possible Points Points Earned
Lookup tables you will use the Lookup Wizard to create a Combo Box to enter Foreign Keys 15% 0
values into their respective tables
Relationships you will create relationships between tables and enforce Referential Integrity 20% 0
Relationships skills 100% 0
Forms (to enter data into the tables)
frmAuthor you will use a specific layout style 5% 0
you will modify the automatically generated form 5% 0
frmPublisher you will use a specific layout style 5% 0
you will modify the automatically generated form 5% 0
frmBook you will use a specific layout style 5% 0
you will modify the form created by the Form Wizard 5% 0
you will include a subform by using the Form Wizard 15% 0
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 5% 0
you will include the lookup boxes that point to other fields in other tables 25% 0
you will modify the header area of the form 5% 0
General you will pay attention to the professional appearance of all forms 20% 0
Appearance of
Forms
Forms skills 100% 0
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 2% 0
qry02 simple single table, multiple criteria select query with sort and parameters 4% 0
qry03 simple single table, multiple criteria select query with sort and wildcards 4% 0
qry04 simple single table, single criteria select query that meets a partial, but not a 4% 0
total match
YourName Task 05 14 of 19
679eb0d5-09a0-4f64-9bbe-23a570ca88ed.xlsx 1/23/2012
Skills Specifications Subtask Grade Possible Points Points Earned
qry05 simple multiple table, multiple criteria select query that meets an AND match 8% 0
on similar data types
qry06 simple multiple table, multiple criteria select query that meets an AND match 8% 0
on different data types
qry07: simple multiple table, multiple criteria select query that meets an OR match on 8% 0
different data types
qry08 single table simple select query with a two criteria parameter 8% 0
qry09 simple multiple table select query that requires a COUNT on one of the criteria 8% 0
qry10 simple multiple table select query that requires a calculated field in the query 8% 0
qry11 simple multiple table select query that requires several calculated field in the 8% 0
query
qry12 simple multiple table select query with bounding criteria on several fields 9% 0
qry13 simple multiple table select query with a parameter and a SUM or COUNT 10% 0
function applied to multiple fields
qry14 simple multiple table select query with several calculated fields in the query 11% 0
and a NULL criteria
Query skills 100% 0
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 30% 0
report object you will modify the header area of the report 10% 0
control
report object you will modify the footer area of the reoert with a calculated field formula 20% 0
control
General you will display your control over object properties by ensuring that the report 40% 0
Appearance of prints out in a professional manner
Reports
Reports Skills 100% 0
YourName Task 05 15 of 19
679eb0d5-09a0-4f64-9bbe-23a570ca88ed.xlsx 1/23/2012
Skills Specifications Subtask Grade Possible Points Points Earned
Points for Task 5 0
Grade for Task 5 F
YourName Task 05 16 of 19
679eb0d5-09a0-4f64-9bbe-23a570ca88ed.xlsx 1/23/2012
last updated on: Thursday, December 18, 2008 0
Skills Specifications Subtask Grade Possible Points Points Earned
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
15% 0
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 points for each
one.
Master Slides you will create a personal logo and apply it to the master 15% 0
you will modify the title master to include an automatically updated date as a
Master Slides 10% 0
footer component.
Include an overview slide that lays out where your presentation is going to go.
Organization 5% 0
You may use a bullet slide format if you wish.
Include a summary slide that wraps up your presentation with the message you
Organization want the audience to go away remembering. Here too you may use a bullet 5% 0
slide format if you wish.
At least one slide should have a different background from the rest of the slides
Templates 10% 0
(it could be the hidden slide)
Using your overview slide as a guide, include some sort of visible transition
device throughout the presentation so the viewer understands where he or she
Organization 40% 0
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 100% 0
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
20% 0
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
10% 0
using a text box or a similar device)
YourName Task 06 17 of 19
679eb0d5-09a0-4f64-9bbe-23a570ca88ed.xlsx 1/23/2012
Skills Specifications Subtask Grade Possible Points Points Earned
you will demonstrate facility with custom animation by making objects seem to
20% 0
move
you will demonstrate facility with custom animation by making objects appear on
15% 0
command
you will demonstrate facility with the drawing tools 20% 0
you will demonstrate facility with charts in a presentation 15% 0
Format & Design skills 100% 0
Presentation
you will have at least one visual slide transition device 10% 0
you will add a sound effect to at least one slide transition 10% 0
you will hide at least one slide 10% 0
you will have a way to get to the hidden slide and back to the presentation
10% 0
from the hidden slide
you will link at least one object to something outside of the presentation 10% 0
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 30% 0
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
particular tool.
Use the Package for CD tool to bundle all your visuals and associated files into a
20% 0
single directory that can be downloaded and used.
Presentation skills 100% 0
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.
YourName Task 06 18 of 19
679eb0d5-09a0-4f64-9bbe-23a570ca88ed.xlsx 1/23/2012
Skills Specifications Subtask Grade Possible Points Points Earned
This will be a subjective judgement on the part of the viewer of the presentation
100% 0
(in this case, it will be my judgement)
Esthetics skills 100% 0
Formatting Decisions - the criteria for this section include:
Use the speaker's notes feature to discuss the creative decisions that you used
to decide on the features to use on the slides in the presentation.
The discussion needs to be as long as necessary to 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
100% 0
indicate that you understand the PowerPoint tools you are using.
Formatting decisions skills 100% 0
Points for Task 6 0
Grade for Task 6 F
YourName Task 06 19 of 19