Skateboards, Inc. Assignment and Grade Tracking Sheet Name

Skateboards, Inc. Assignment and Grade Tracking Sheet
Name: _______________________________________
Project
#
Project Title
Part 1: Word Projects
W-1
Write a Press Release
“How To” Video & Websites to
Watch and visit before starting
project
Create and Design Letterhead
Date Proofread
and Handed in
Total Points
Earned / 16
Possible Points
Line and Paragraph Spacing
Formatting and Aligning
Text in Word 2010
W-2
Block: __________________
Due Dates
2/24
/ 16
2/24
Insert Page Header and
Page Numbers
/ 16
W-3
W-4
Create and Design an Envelope
Create Price Sticker Labels
Remove Header and
Footer on first page only
What is the "USPS
Address Style" for a Mailing
Address?
2/26
/ 16
Creating Labels in Word
2010
2/26
/ 16
W-5
Create a Business Memo
The Strikethrough Text
Style
Memos versus Letters:
What's the Difference?
3/2
/ 16
Superscript and Subscript
W-6
W-7
W-8
Create a Skateboards Bullet List
Create a Skateboard Terms and
Definitions Two-Column List
Create and Design an Hours of
Operation Sign
3/2
Bullets in Word
How To Make a Numbered
List
/ 16
How to Sort Text, Numbers
and Tables in Word
Convert Text to Columns
/ 16
3/4
Word Tables
3/4
Centering a table
Horizontally and Vertically
on a Page
Merge and Split Cells in a
Table
/ 16
Add Borders to Tables (or
Cells)
Adding Rows and Columns
to a Table
W-9
Create and Design a Waiver and
Release of Liability Form
Using the ‘Draw Table’
feature
/ 16
3/9
Skateboards, Inc. Assignment and Grade Tracking Sheet
Name: _______________________________________
Block: __________________
Part 2: Excel Projects
Project
#
Project Title
“How To” Video & Websites to
Watch and visit before starting
project
Date Proofread
and Handed in
Total Points
Earned / 16
Possible Points
Due Dates
Introduction to Excel: Before you start any Skateboards, Inc. Excel assignments, log into EduCanon and
complete this interactive video. Answer the questions you see in the video as you go. Your id and password is
your first initial and your last name. Brandon J, Anthony C, Sam T. and Dana H, you will have to add
the two digits of your graduation year to the end your id and password in order to log in.
E-1
Create a Vendor Contact List
Creating and Opening
Workbooks
3/11
Modifying Cells, Rows and
Columns
Formatting Cells
/ 16
How to format Numbers as
a Zip Code to display
Leading Zeroes (i.e. 06422)
E-2
E-3
E-4
Create a Lessons Price List
Create a Music List
Create an Employee Average
Age Spreadsheet
Selecting the Print Area in
Excel
Selecting Non Adjacent
Cells (video uses an earlier
version of Excel, but
method still applies)
Format cells as currency
Text Alignment, Video on
How to Align or Center
Text
3/11
/ 16
3/13
/ 16
Sort a Spreadsheet
The Average Function
Custom Headers and
Footers In Excel
Shading / Adding Color to
Cells
3/13
/ 16
Skateboards, Inc. Assignment and Grade Tracking Sheet
Name: _______________________________________
E-5
Create a Projected Revenue
Wrap Text in a Cell
Block: __________________
3/17
Spreadsheet
Change the number of
Decimal Places displayed in
a number
/ 16
Apply Cell Borders
Basic Math formulas in
Excel
More Simple Formulas
Project
#
Project Title
“How To” Video & Websites to
Watch and visit before starting
project
E-6
Create a Pro Shop Equipment
Inventory Report
Modifying Cells, Rows and
Columns
Date Proofread
and Handed in
Total Points
Earned / 16
Possible Points
Due Dates
3/19
Zooming your workbook
Using AutoFill to copy
formulas
/ 16
Selecting Non-Adjacent
Columns (Columns that
aren’t next to each other)
Part 4:Publisher Projects
If appropriate , you may create these publications using an existing template. Be sure to include all the requirements for
each assignment.
Before you start any Publisher assignments, watch and respond to the Introduction to Publisher 2010 video. Use the
Educanon login provided to you earlier.
P-1
Create and Design a Business
Card
Working with Templates in
Publisher
Working with
Text/Textboxes in
Publisher
P-2
Create and Design an Employee
Name Badge
P-3
Create and Design a Bumper
Sticker
Create and Design a Grand
Opening Advertisement
Create and Design a Coupon
Flyer
P-4
P-5
Working with Pictures in
Publisher 2010
Setting pages sizes in
Publisher
/ 16
/ 16
/ 16
/ 16
Using Page Borders in
Publisher
/ 16
Skateboards, Inc. Assignment and Grade Tracking Sheet
Name: _______________________________________
P-6
Create and Design a BookletAdding, Moving and
Style Food Menu
Deleting pages in Publisher
(web page)
Block: __________________
/ 16
Viewing A Multi-Page
publication
Part 5: PowerPoint Projects
Projects
PPT-1
Create a Grand Opening Slide
Show Presentation
Extra Credit Projects
P-7
Create and Design a Three-Panel
(Extra
Brochure
Credit)
P-8
Create and Design a Boarder
(Extra
Birthday Pass
Credit)
PPT-2
Create a Banner Advertising
Campaign (Extra Credit)
P-7
Create and Design a Three-Panel
Brochure (Extra Credit)
/ 16
/ 16
/ 16
/ 16
/ 16