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