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