Teacher's Desk: About Me

Computer Applications Assignments

Week 1

Date	Plan	Assignment
Wednesday, January 20	Welcome & Introductions Introduction Slide Show File Management; Introduction to DocuShare and eDisk, Set Favorites for Schropfer Computer Applications Class Folder Computer Use Guidelines MicroType Pro Setup & Initial Speed Timing Printing, Saving, Header/Footer Demos First Intro Assignment	Computer Guidelines Signature Form First Intro Assignment File Management; Introduction to DocuShare and eDisk, Set Favorites for Schropfer Computer Applications Class Folder Setup Microtype Account & Begin Lessons 18 Lessons assigned - Due end of the term
Thursday, January 21	Correct Seating Chart & Class Roster Day 2 Slide Show More File Management Demo on Printing Reduced, Saving, and Handout and Handin Folders on DocuShare Introduce Screen Parts Introduce Word - Unit A	DocuShare - more File Management MicroType -18 Lessons Due at the end of the term Screen Parts Activity Word Unit A - Skills Review #2 and #6- page Word 19 - 20
Friday, January 22	Day 2 Slide Show Demo on Printing Review DocuShare - Uploading Files & File Management Demo Selecting Text' Autocomplete/correct; MiniToolbar - Formatting; Templates; Word Unit A - Practice; Assign Skills Review #2 and #6 - pages Word A, 19-20 Assign Visual Workshop	Demo on Printing Review DocuShare - Uploading Files & File Management Word Unit A - Skills Review #2 and #6- page Word 19 - 20 Word Unit A - Visual Workshop (page Word 24) Staple Unit A together--hand in Teacher Demo on Unit B
Monday, January 25	Listening Quiz Finish Unit A Assignments Word - Unit B Demo Skills Cut & Paste, Copy/Paste, Office Clipboard, Drag & Drop, Find & Replace, Keyboard Shortcuts, Autocorrect, Research Information - Word Count, Thesaurus, Hyperlinks, Preparing Document for Distribution Assign Word B Skills Review - pages 43 & 44 Assign Visual Workshop - page 48 Extra Credit Opportunity - Harry Potter Excerpt	MicroType Listening Quiz Finish Unit A Assignments Teacher Demo - Unit B Skills Cut & Paste, Copy/Paste, Office Clipboard, Drag & Drop, Find & Replace, Keyboard Shortcuts, Autocorrect, Research Information - Word Count, Thesaurus, Hyperlinks, Preparing Document for Distribution Assign Word B Skills Review - pages 43 & 44 Assign Visual Workshop - page 48 Extra Credit Opportunity - Harry Potter Excerpt
Tuesday, January 26	Finish Word B Skills Review & Visual Workshop Handout - Harry Potter Excerpt	Finish Word B Skills Review & Visual Workshop Handout - Harry Potter Excerpt

Week 2

Date	Plan	Assignment
Wednesday, January 27	Finish Word - Unit B Assignments Assign Word B Skills Review - pages 43 & 44 Assign Visual Workshop - page 48 Extra Credit Opportunity - Harry Potter Excerpt	Finish Word - Unit B Assignments Assign Word B Skills Review - pages 43 & 44 Assign Visual Workshop - page 48 Extra Credit Opportunity - Harry Potter Excerpt - Handout and original file on DocuShare
Thursday, January 28	Introduce Unit C Skills – Teacher Demo ◦Fonts, Drop Caps, Format Painter, Line & Paragraph Spacing, Aligning Paragraphs, Tabs, Indents, Bullets & Numbering, Borders & Shading, Footnotes & Endnotes, Quick Styles Assign Unit C ◦ Skills Review – pg 69-71 Independent Challenge 2 & 3 – pg 73 Visual Workshop – pg 76 Assign 22Prize and 23Client (found on Handout Folder on Docushare). Use Hard Copy Handout for Formatting guidelines	Introduce Unit C Skills – Teacher Demo ◦Fonts, Drop Caps, Format Painter, Line & Paragraph Spacing, Aligning Paragraphs, Tabs, Indents, Bullets & Numbering, Borders & Shading, Footnotes & Endnotes, Quick Styles Assign Unit C Skills Review – pg 69-71 Independent Challenge 2 & 3 – pg 73 Visual Workshop – pg 76 Assign 22Prize and 23Client (found on Handout Folder on Docushare). Use Hard Copy Handout for Formatting guidelines
Friday, January 29	Finish Unit C Skills Review – pg 69-71 Independent Challenge 2 & 3 – pg 73 Visual Workshop – pg 76	Finish Unit C Skills Review – pg 69-71 Independent Challenge 2 & 3 – pg 73 Visual Workshop – pg 76 Assign 22Prize and 23Client (found on Handout Folder on Docushare). Use Hard Copy Handout for Formatting guidelines Extra Credit Opportunity - 5 Tables Assignment
Monday, February 1	Finish Unit C Assignments Group Activity Review of Skills - 22Prize and 23Client (found on Handout Folder on Docushare). Use Hard Copy Handout for Formatting guidelines	Finish Unit C Assignments Group Activity - Review of Skills 22Prize and 23Client (found on Handout Folder on Docushare). Use Hard Copy Handout for Formatting guidelines
Tuesday, February 2	Introduce Tables 5 Tables Assignment Handout Unit D Skills - Teacher Demo Unit D Assignments Visual Workshop - pg 10	Introduce Tables 5 Tables Assignment Handout Unit D Skills - Teacher Demo Unit D Assignments Visual Workshop - pg 104

Week 3

Date	Plan	Assignment
Wednesday, February 3	Introduce Unit D Skills - Teacher Demo Unit D Assignment Visual Workshop - pg 104	Unit D Assignment Visual Workshop - pg 104
Thursday, February 4	Review for Word Test Guitar Heros Practice Test Finish Missing Work	Review for Word Test Guitar Heros Practice Test Finish Missing Work
Friday, February 5	Word Test SAMS Online Word Assessment All Word Assignments Due	Word Test SAMS Online Word Assessment All Word Assignments Due
Monday, February 8	Teacher Demo on Mail Merge Assign Blue Mail Merge Assignment Assign Mail Merge Assignment 2	Assign Blue Mail Merge Assignment Assign Mail Merge Assignment 2
Tuesday, February 9	Begin Excel Teacher Demo Assign - Bowling Handout	Begin Excel Assignment - Bowling Handout

Week 4

Date	Plan	Assignment
Wednesday, February 10	Introduce Excel - Unit A Introduce Basics of Excel Labels, Entries, Formulas Bowling Handout/Assignment	Introduce Excel - Unit A Bowling Handout Visual Workshop - Excel pg. 24
Thursday, February 11 Pep Rally Schedule	Spreadsheet Review Handout Introduce Unit B Work with Forumulas and Functions Cell entries, complex formulas Working with Functions Unit B - Review Functions (complex, inserting, typing) Copying/Moving Cell Entries Absolute Cell References Rounding	Spreadsheet Review & Chart Handout Unit B Assign - Visual Workshop p. 50 and Excel Review Handout
Friday, February 12	Finish Unit B - Visual Workshop Intro to Unit C Format values (decimals, commas, dates) Font/size/alignment/attributes Column width/inserting & deleting rows & columns Border, colors, & patterns Handout - Department Expenses Spreadsheet	Finish Unit B - Visual Workshop Unit C Assignments Skills Review - pages 71-72 Independent Challenge 2 -page 74 Visual Workshop - page78 Assign Department Expenses Spreadsheet & Chart Handout
Monday, February 15	Assign SS/WP Mail Merge and Labels (Handout) Project; Print Letters & Labels for customers w/ Credit (less than 0) Balances	Assign SS/WP Mail Merge and Labels (Handout) Project; Print Letters & Labels for customers w/ Credit (less than 0) Balances
Tuesday, February 16	Finish Unit C Assignments Independent Challenges 1 & 2 Visual Workshop Extra Credit Handout - Car Payments Introduction to Unit D - Charts Planning Moving/Resizing Changing Designs Changing Layouts Formatting Annotations	Finish Department Expenses Worksheet & Chart Finish Big Apple Worksheet & Chart Finish Unit C Assignments Independent Challenges 1 & 2 Visual Workshop Extra Credit Handout - Dynamic Music and Car Payments

Week 5

Date	Plan	Assignment
Wednesday, February 17	Unit D Concepts Moving/Resizing Chart Designs/Layouts Formatting/Annotating Pie Charts Assign Skills Review (in class) Assign Independent Challenge Assign Visual Workshop	Unit D Assign Skills Review (in class) Assign Independent Challenge Assign Visual Workshop
Thursday, Feburary 18	Review - Fill Series/Rank, Working with non-adjacent data and formulas Assign Crisis in Big Apple Baseball SS & Tropical T-Shirts SS (Handout)	Review - Fill Series/Rank, Working with non-adjacent data and formulas Assign Crisis in Big Apple Baseball SS & Tropical T-Shirts SS (Handout)
Friday, February 19	Make-Up Day Review Excel Practice Test Excel Assignments Due	Make-Up Day Review Excel Practice Test Excel Assignments Due
Monday, February 22	Excel Test SAMS Online Excel Assessment	Excel Test SAMS Online Excel Assessment
Tuesday, February 23	Begin Access Begin Class Database	Begin Access Begin Class Database

Week 6

Date	Plan	Assignment
Wednesday, February 24	Class Database Input Setup Fields; Input; Edit Class Data, and Create Relationships between Tables	Class Database Input Setup Fields; Input; Edit Class Data, and Create Relationships between Tables
Thursday, February 25	Get to Know your Classmates Survey	Get to Know your Classmates Survey
Friday, February 26	Class Database - Teacher Demo on Queries and Reports Assign Queries & Reports (Handout) Print Class Database Reports	Class Database - Teacher Demo on Queries and Reports Assign Queries & Reports (Handout) Print Class Database Reports
Monday, March 1	Assign Insurance Database & 5 Reports and Labels Class Database Reports Due	Assign Insurance Database & 5 Reports and Labels Class Database Reports Due
Tuesday, March 2	Teacher Demo on Letterheads - Word Art, Paint, Clip Art Assign Access/Word Form Letter and Letterhead Assignment Due (Handout)	Teacher Demo on Letterheads - Word Art, Paint, Clip Art Assign Access/Word Form Letter and Letterhead Assignment Due (Handout)

Week 7

Date	Plan	Assignment
Wednesday, March 3	Introduce Report Wizard Assign Johnson Company Database Audit Quiz, Reports, Mail Merge w/ Paint Letterhead	Introduce Report Wizard Assign Johnson Company Database Audit Quiz, Reports, Mail Merge w/ Paint Letterhead
Thursday, March 4	Finish Johnson Company Project	Finish Johnson Company Project
Friday, March 5	Review for Access Test Make-up Work	Review for Access Test Make-up Work
Monday, March 8	Access Unit Test	Access Unit Test
Tuesday, March 9	Teacher Demo - Power Point Tips Assign "About Me" Power Point & Rubric	Power Point Tips Assign "About Me" Power Point When finished, give Power Point to two Classmates; Classmates fill out Rubric; Print Power Point (Handout - 6 slides/page) and Staple with Completed Rubric

Week 8

Date	Plan	Assignment
Wednesday, March 10	Finish "About Me" Presentations Discuss Final Power Point Project & Rubric Divide class members into teams & draw topics	Finish "About Me" Presentations Assign Final Power Point Project & Rubric
Thursday, March 11	Research & Work Day - Final Power Point Project	Research & Work Day - Final Power Point Project
Friday, March 12	Research & Work Day - Final Power Point Project 18 MicroType Lessons Due	Research & Work Day - Final Power Point Project 18 MicroType Lessons Due
Monday, March 15	Power Point Presentations	Power Point Presentations
Tuesday, March 16	Review for Final	Review for Final

Week 9

Date	Plan	Assignment
Wednesday, March 17	Finish Review Start Final	Finish Review Start Final
Thursday, March 18	18 MicroType Lessons Due Computer Apps Final	Computer Apps Final
Friday, March 19	Computer Apps Final	Computer Apps Final