Personal Assignment Requirements
All Assignments
 | 25 objectives in your chapter notes that are specific to text or a location in the document. For
example, you cannot use Save, Open, or Spell-check. It is a good idea that you
make a few extra so you don't get marked down if it is a general objective. (2
points for each objective) |
| Fill in the fourth column of your objectives document with the location of
the item in your document. Include text or numbers (Word or Excel), a cell
number (Excel), the name of a table and field or report or form (Access).
Click here for starting document and to see
an example for Word 1. |
| Number the objectives in the fourth column in order from 1-25. - 5 points
for numbering (3 points for number at all, 2 points in order) |
| Put proper filename on the document (see below for examples but your name
and block will be different) - 5 points |
| Put proper document ID on all documents - 3 points |
| Spell-check your document. If there are any obvious spelling or grammar
errors, minus 2 points. |
| The document(s) you create have to have a topic and make sense. You can't
just do all the steps without having some subject to tie everything together.
(5 points) |
Office 1
| Access (O1-APA-Q1C-LastNameFI-AccessPersonalAssignment)
 | One table with at least 5 fields and 10 records and 3 properties changed
from the default on at least one field (10 points) |
| A second table with at least 5 fields and 5 records (5 points) |
| A query (5 points) |
| A form (5 points) |
| A report (5 points) |
|
| Word (O1-WPA-Q1C-LastNameFI-WordPersonalAssignment)
| A letter to me that describes your interest and why you chose it (with
formatting similar to page WD3.06) (10 points) |
| In the letter put 3 paragraphs about a subject that interests you (15 points) |
| One title page with graphic (5 points) |
|
| Excel (O1-EPA-Q1C-LastNameFI-ExcelPersonalAssignment)
| An spreadsheet about your interest that mostly fills cells A1:L30 or
more (10 points) |
| Text, numbers, sums, and additional formulas (5 points) |
| A chart on a separate sheet (10 points) |
|
Office 2
| Access (O2-APA-Q1C-LastNameFI-AccessPersonalAssignment)
| A form with a combo box and a hyperlink (10 points) |
| A report with grouping (5 points) |
| A switchboard with at least 2 macros, 2 forms, and 10 options (10
points) |
|
| PowerPoint (O2-PPA-Q1C-LastNameFI-PowerPointPersonalAssignment)
| A PowerPoint document with at least 10 slides in addition to the header
slide (10 points) |
| Graphics, sound, and notes on at least 1 slide (5 points) |
| A chart (5 points) |
| Transitions (5 points) |
|
| Excel (O2-EPA-Q1C-LastNameFI-ExcelPersonalAssignment)
| A data table (chapter 4) - (5 points) |
| A database with at least one criteria and extract range (chapter 5) (10
points) |
| Multiple worksheets in a workbook with a formula that spans more than
one worksheet (chapter 6) (10 points) |
|
Special Note: Candy for those on 1/27/06 if you write a note on a piece of
paper on what the name of your first personal assignment. See above for your
classes.
|