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://sam.cengage.com/Login.aspx

 

Date
Plan
Assignment

Wednesday, October 16

  • 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

Thursday, October 17

  • 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

Friday, October 18

  • 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

Monday, October 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

Tuesday, October 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

Wednesday, October 23

  • 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

Thursday, October 24

  • Finish Unit C Assignments
  • Skills Review and Visual Workshop; Tabulation Handout
  • Finish Unit C Assignments
  • Skills Review and Visual Workshop; Tabulation Handout
Friday, October 25
  • 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

Monday, October 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

Tuesday, October 29

  • 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

Wednesday, October 30

  • Word Unit - Practice Performance Test and SAM Online Practice Test
  • Word Unit - Practice Performance Test and SAM Online Practice Test
Thursday, October 31
  • Word Unit Test - Performance
  • Word Unit Test - SAM
  • Word Unit Test - Performance
  • Word Unit Test - SAM

Friday, November 1

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

Monday, November 4

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

Tuesday, November 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

Wednesday, November 6

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

Thursday, November 7

  • 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

Friday, November 8

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

Monday, November 11

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

Tuesday, November 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

Wednesday, November 13

  • Finish Excel Unit C Assignments
  • Excel Unit C Quiz - Handout
  • Finish Excel Unit C Assigments
    • Excel Unit C Quiz - Handout

Thursday, November 14

  • 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)
Friday, November 15
  • 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

Monday, November 18

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

Tuesday, November 19

  • Excel Test
  • SAM Online Excel Assessment
  • Excel Test
  • SAM Online Excel Assessment
Wednesday, November 20
  • 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

Thursday, November 21

  • Edit Class Database
  • Teacher Demo - Sort and Filters
  • Get to Know your Classmates Survey
  • Edit Class Database
  • Get to Know your Classmates Survey
Friday, November 22
  • 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

Monday, November 25

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

Tuesday, November 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, December 2

  • 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, December 3

  • Finish Johnson Company Project
  • Finish Johnson Company Project

Wednesday, December 4

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

Thursday, December 5

  • Access Unit Test
  • Access Unit Test

Friday, December 6

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

Week 8 and 9

Date
Plan Assignment

Tuesday, December 10

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

Wednesday, December 11

  • Colleges Power Point
  • Colleges Power Point
Thursday, December 12

  • Colleges PPT Due
  • MicroType due
  • Colleges PPT Due
  • MicroType due

Friday, December 13

  • PPT SAM Test
  • PPT SAM Test

Monday, December 16

  • Review for Final
  • Review for Final
Tuesday, December 17
  • Begin Performance Final
  • Begin Performance Final

Wednesday, December 18

  • Finish Performance Final
  • Finish Performance Final
Thursday/Friday, December 19-20
  • SAM Online Skills Final
  • SAM Online Skills Final