Teacher's Desk: About Me

Computer Applications Assignments

Week 1

Computer Applications URL's-

DocuShare URL:

http://docshare3.lps.org/docushare/dsweb/View/Collection-369

SAM Assessment Software URL:

http://sam2007.course.com/LoginSAM2007.aspx

 

Date
Plan
Assignment

Monday, March 18

  • 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
  • 16 Lessons assigned - Due end of the term
  • CA PreTest on SAM Software

Tuesday, March 19

  • 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 -16 Lessons Due at the end of the term
  • Screen Parts Activity
  • CA Pretest on Word Units A & B on SAM Software
  • Word Unit A - Teacher Demo
  • Demo on Zipping and Uploading Folders to DocuShare

Wednesday, March 20

  • 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 Visual Workshop
    • Lyrics Activity - DocuShare
  • Demo on Printing
  • Review DocuShare - Uploading Files & File Management
  • Word Unit A - Visual Workshop (page Word 24)
  • Lyrics Activity - DocuShare & Handout

Thursday, March 21

  • 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
  • MicroType
  • 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

Friday, March 22

  • Word - Unit B Visual Workshop
  • SAM Online - Word Units A and B Quiz
  • Harry Potter Activity - DocuShare
  • Word - Unit B Visual Workshop
  • SAM Online - Word Units A and B Quiz
  • Harry Potter Activity - DocuShare

Week 2

Date
Plan
Assignment

Monday, March 25

  • Introduce Word 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 Word Unit C Assignments
  • Word Unit C Skills Demo
  • Assign Unit C
    • Skills Review - pg. 69-71
    • Tabulation Handout
    • Visual Workshop - pg. 76

Tuesday, March 26

  • Finish Unit C Assignments
  • Skills Review and Visual Workshop; Tabulation Handout
  • Finish Unit C Assignments
  • Skills Review and Visual Workshop; Tabulation Handout
Wednesday, March 27
  • Assign 22Prize and 23Client (found on Handout Folder on Docushare).  Use Hard Copy Handout for Formatting guidelines
  • SAM - Unit C Quiz
  • Introduce Tables - Teacher Demo and Tables Assignment Handout
  • Assign 22Prize and 23Client (found on Handout Folder on Docushare).  Use Hard Copy Handout for Formatting guidelines
  • Sam - Unit C Quiz
  • Tables - Teacher Demo
  • Tables Assignment Handout

Thursday, March 28

  • Finish Tables
  • Teacher Demo - Unit D Skills and Assignments
  • Finish Tables
  • Teacher Demo - Unit D Skills
  • Assign Unit D - Visual Workshop
  • Assign Oh Canada Handout - DocuShare

Friday, March 29

No School
  • Finish Unit D Assignments
  • SAM Online Unit C and D Quiz
  • Finish Unit D Assignments
  • SAM Online - Unit C and D Quiz

Week 3

Date
Plan
Assignment

Monday, April 1

No School

  • Word Unit - Practice Performance Test and SAM Online Practice Test
  • Word Unit - Practice Performance Test and SAM Online Practice Test
Tuesday, April 2
  • Word Unit Test - Performance
  • Word Unit Test - SAM
  • Word Unit Test - Performance
  • Word Unit Test - SAM

Wednesday, April 3

  • Introduce Mail Merge
  • Mail Merge #1 Assignment
  • Introduce Mail Merge
  • Mail Merge #1 Assignment

Thursday, April 4

  • Mail Merge #2 Assignment
  • Mail Merge #2 Assignment

Friday, April 5

  • Introduce Excel - Unit A Skills
  • Assign Bowling SS Handout & Chart
  • Excel Unit A - Teacher Demo
  • Bowling SS & Chart Handout
  • Excel Unit A - Visual Workshop Assignment

Week 4

Date
Plan
Assignment

Monday, April 8

  • Review Excel Unit A Concepts and Printing
  • Finish Unit A - Visual Workshop and Bowling Handout
  • Assign - Spreadsheet Review Handout

Tuesday, April 9

  • Teacher Demo: Excel Unit B Skills - Absolute Reference Formulas
  • Excel Unit B - Teacher Demo
  • Excel Unit B Assignments:
    • Visual Workshop - pg. 50
    • Stock Broker Handout

Wednesday, April 10
  • Review Absolute Cell Reference Formulas
  • Assign Concerts Handout and Department Expenses Handout
  • Unit B Assignments
  • Concerts Handout - Spreadsheet, Chart, & Questions
  • Department Expenses Handout

Thursday, April 11

  • Finish Unit B Assignments
  • Finish Concerts SS and Department Expenses SS

Friday, April 12

  • Introduce Excel Unit C - Conditional Formatting
  • Teacher Demo - Rank, Sort, If Spreadsheet
  • Unit C Assignments
  • Excel Unit C - Teacher Demo
  • Assignments:
    • Indep Chall #2 - pg. 74
    • Indep Chall #3 - pg. 75-76
    • Grammy Awards Handout

Week 5

Date Plan Assignment

Monday, April 15 - No School for Students
  • Finish Excel Unit C Assignments
  • Excel Unit C Quiz - Handout
  • Finish Excel Unit C Assigments
    • Excel Unit C Quiz - Handout

Tuesday, April 16

  • Teacher Demo - If Statements
  • Assign Crisis in Big Apple Baseball SS & Tropical T-Shirts SS (Handout)
  • Teacher Demo - If Statements
  • Assign Crisis in Big Apple Baseball SS & Tropical T-Shirts SS (Handout)
Wednesday, April 17
  • Unit D Concepts
  • Moving/Resizing
  • Chart Designs/Layouts
  • Formatting/Annotating
  • Pie Chart
  • Assign Skills Review
  • Assign Independent Challenge
  • Assign Visual Workshop
  • Excel Unit D - Teacher Demo
  • Unit D Assignments
    • Skills Review
    • Independent Challenge
    • Visual Workshop

Thursday, April 18

  • Excel Practice Test and SAM Practice Test - Excel Unit
  • Excel Practice Test and SAM Practice Test - Excel Unit

Friday, April 19

  • Excel Test
  • SAM Online Excel Assessment
  • Excel Test
  • SAM Online Excel Assessment
Monday, April 22
  • Begin Access Unit - Class Database Setup and Input
  • Setup Fields; Input; Edit Class Data, and Create Relationships between Tables
  • Begin Access Unit
  • Class Database Setup and Input
  • Setup Fields; Input; Edit Class Data, and Create Relationships between Tables

Week 6

Date Plan Assignment

Tuesday, April 23

  • Edit Class Database
  • Teacher Demo - Sort and Filters
  • Get to Know your Classmates Survey
  • Edit Class Database
  • Get to Know your Classmates Survey
Wednesday, April 24
  • Class Database - Teacher Demo on Relationships, Queries and Reports
  • Assign Queries & Reports (Handout)
  • Copy/Paste Class Database Queries to Word; Print
  • Assign Apartments Database
  • Class Database -
  • Teacher Demo on Relationship and Queries and Reports
  • Assign Queries & Reports (Handout)
  • Copy/Paste Class Database Queries to Word;Print
  • Begin Apartments Database
    • Relationships and Queries
    • Copy/Paste to Word

Thursday, April 25

  • Finish Apartments Database
  • Assign Insurance Database & 5 Reports and Labels
  • Finish Apartments Database Handout
  • Assign Insurance Database & 5 Reports and Labels

Friday, April 26

  • 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)

Monday, April 29

  • 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

Week 7

Date
 Plan Assignment

Tuesday, April 30 - No School ACT Testing

  • Finish Johnson Company Project
  • Finish Johnson Company Project

Wednesday, May 1

  • Review for Access Test
  • Make-up Work
  • Review for Access Test
  • Make-up Work

Thursday, May 2

  • Access Unit Test
  • Access Unit Test

Friday, May 3

  • Teacher Demo - Power Point Tips
  • Assign "About Me" Power Point & Rubric
  • Power Point Tips
  • Assign "About Me" Power Point
  • Staple with Completed Rubric
Monday, May 6
  • Discuss Final Power Point Project & Rubric
  • Assign Colleges PPT
  • Finish "About Me" Presentations
  • Assign Final Power Point Colleges Project & Rubric

Week 8

Date
 Plan Assignment

Tuesday, May 7

  • Research & Work Day - Colleges Power Point Project
  • Research & Work Day - Colleges Power Point Project

Wednesday, May 8

  • Colleges Power Point
  • Colleges Power Point
Thursday, May 9

  • Colleges PPT Due
  • Colleges PPT Due

Friday, May 10

  • PPT SAM Test
  • PPT SAM Test

Monday, May 13

  • Review for Final
  • Review for Final

Week 9

Date
 Plan Assignment
Tuesday, May 14
  • Begin Performance Final
  • Begin Performance Final
Wednesday, May 15
  • Finish Performance Final
  • Finish Performance Final
Thursday, May 16
  • SAM - Computer Apps Final
  • SAM - Computer Apps Final
Friday, May 17
  • No Class
  • No Class