Courses/Computer Science/CPSC 203/CPSC 203 2008Winter L03/CPSC 203 2008Winter L03 TimeBoxedAssignments

Spreadsheet (Excel) Skills List
Excel Time Boxed Assignments are in the 2nd tutorial the week of February 11th

Skill List for Excel is:

1.Type in some basic data – used for rest of the quiz

2.Autofill a field(s)

3.Set up appropriate Field formats (Currency, Numbers, Text, etc.)

4.Calculate Basic Statistics (Min, Max, Average, SD, Median)

5.Use Chart Wizard to do a default chart on a data set.

6.Customize a chart according to good chart design principles

7.Do a custom calculation using a formula (possibly in several steps)

8.Use a nested If ... Then statement to define classes.

9.Use a Lookup table to define classes.

10.Summarize data in a Pivot table.

Database (Access) Skills List
Access Time Boxed Assignments are in the 2nd tutorial the week of March 10th

Skill List for Access is:

1.Type in some basic data into several tables

2.Set table field types and default values

3.Define Primary and Foreign keys for each table

4.Do a query selecting fields across tables (setting Join conditions)

5.Do a query with multiple constraints (Where clause)

6.Do an aggregate query including basic statistics (Group By clause)

7.Do an aggregate query with multiple constraints (Having clause)

8.Summarize data via a Crosstab query

9.Do a custom calculation within a query

10.Do an IF ... Then statement within a query.

Word Processing(WORD) Skills List
WORD Time Boxed Assignments are in the 2nd tutorial the week of March 24th.

Skill List for Word is:

1. Copy text information and insert into a Word document.

2. Reorder select words and paragraphs through cut and paste.

3. Search and replace select words and phrases.

4. Create a decorative nameplate (called "masthead" in TAIT lessons).

5. Create Columns

6. Add Character Formats (Fonts and Colours).

7. Add Paragraph formats (type justification, tabs, bullets).

8. Add graphic elements (logos, photos).

9. Create a text box with formatted text information.

10. Create Headers and Footers.

The skills list is drawn entirely from the TAIT modules for Word1/Word2 concentrating on 2A, 2B, 3A, 3B, 4A, 7A, 7B and 9B

Presentation(PowerPoint) Skills List
PowerPoint Time Boxed Assignments are in the 2nd tutorial the week of April 7th.

Format: You will be given instructions for the construction of a presentation in the form of a story-board (sketches and text) which you are to implement in PowerPoint.

A couple of useful storyboard sites are:
 * a simple overview: http://accad.osu.edu/womenandtech/Storyboard%20Resource/
 * an example of a storyboard: http://www2.hawaii.edu/~ricky/etec/example.html
 * Many other examples can be found by typing "storyboard" or "storyboard examples" into Google.

Skill List for PowerPoint is:

1. Create and Delete slides (1a, 2b)

2. Format Slides (3a, all the PowerPoint lessons have some formatting)

3. Modify slide backgrounds and color schemes (3b)

4.Use, modify and create design templates (2a, 8a)

5. Use and modify a Slide Master (3a)

6. Create a slide show, including setting up transitions (6a)

7. Use animation in a slide (3b, 6a)

8. Insert and Modify tables, charts and diagrams (7a, 7b)

9. Use clip art, images, drawings in a slide (4a, 5a)

10. Interpretation of the storyboard.

'''The skills list for 1-9 is drawn entirely from the TAIT modules for PowerPoint1/PowerPoint2. A concordance with specific lessons is in brackets, but you are responsible for the content of ALL lessons in PowerPoint1/PowerPoint2. Skill 10 focusses on your ability to translate simple instructions into a finished presentation '''

A practice example is available in the 203 L04 Website at: http://203lori.pbwiki.com/TBA+Guides+and+Demos
 * The file to download is: Monkey_Pods_Trees.ppt
 * Note that for L03, "including adding notes to slideshow" which is mentioned on the L04 website is not required for skill 10.