Lessons and Assignments
  Introduction to Computer Applications
 

Faculty Webs

My Home Page

Computer
Applications

AP
Computer Science

Business
Management

Schedule

The Boys!!!

Useful Links



 

Term II, 2007-08

January   February
Sun Mon Tue Wed Thur Fri Sat   Sun Mon Tue Wed Thur Fri Sat
    1 2 3 4 5             1 2
6 7 8 9 10 11 12   3 4 5 6 7 8 9
13 14 15 16 17 18 19   10 11 12 13 14 15 16
20 21 22 23 24 25 26   17 18 19 20 21 22 23
27 28 29 30 31       24 25 26 27 28 29 30

Color-Coded Legend for Special Schedules:

No School 1:30 Dismissal 1:10 Dismissal
Noon dismissal Class Meetings First Friday/Liturgy
Grades Close Exams Regular Schedule

 

March   April
Sun Mon Tue Wed Thur Fri Sat   Sun Mon Tue Wed Thur Fri Sat
            1       1 2

3

4 5
2

3

4 5 6 7 8   6 7 8 9 10 11 12
9 10 11 12 13 14 15   13 14 15 16 17 18 19
16 17 18 19 20 21 22   20 21 22 23 24 25 26
23 24 25 26 27 28 29   27 28 29 30      
30 31                          

Color-Coded Legend for Special Schedules:

No School 1:30 Dismissal 1:10 Dismissal
Noon dismissal Class Meetings First Friday/Liturgy
Grades Close Exams Regular Schedule
Holiday Hill    

 

May   June
Sun Mon Tue Wed Thur Fri Sat   Sun Mon Tue Wed Thur Fri Sat
        1 2

3

  1 2

3

4 5 6 7
4 5 6 7 8 9 10   8 9 10 11 12 13 14
11 12 13 14 15 16 17   15 16 17 18 19 20 21
18 19 20 21 22 23 24   22 23 24 25 26 27 28
25 26 27 28 29 30     29 30 31        
Date Class Topic Assignment

1/17/08

(C)

Course Introduction and Semester Overview

  • Welcome and Course Overview

  • Students' objectives

  • Syllabus

  • Acceptable use policy at SHA

  • Begin Concert team activity

Semester Goals

1/18/08

(D)

Course Introduction and Semester Overview

  • Welcome and Course Overview

  • Students' objectives

  • Syllabus

  • Acceptable use policy at SHA

  • Begin Concert team activity

Semester Goals

1/22/08

(E)

Intro to Computers

  • Network folders and backing up schoolwork

  • Hand-In folder

  • Hardware and Software

Read pages COM 1-18. 

Test how well you know the Essential Introduction to Computers.

 

QUIZ NEXT CLASS ON READING AND CLASS NOTES

 

1/23/08

(F;1:10)

Intro to Computers

  • Network folders and backing up schoolwork

  • Hand-In folder

  • Hardware and Software

 

Read pages COM 1-18. 

Test how well you know the Essential Introduction to Computers.

 

QUIZ NEXT CLASS ON READING AND CLASS NOTES

 

1/24/08

(A)

Word Processing

  • Quiz (COM 1-18 and notes)

  • Keyboarding review

  • Shortcuts in MS Word

  • MLA Standards for Academic Reports

Word Project 1: Grand Prix Announcement  (pp. WD 4 - WD 52)

* Save to your laptop (at home) and my Hand-In folder (at school).

* Save as: Grand Prix.doc

 

1/25/08

(B)

Word Processing

  • Quiz (COM 1-18 and notes)

  • Keyboarding review

  • Shortcuts in MS Word

  • MLA Standards for Academic Reports

Word Project 1: Grand Prix Announcement  (pp. WD 4 - WD 52)

* Save to your laptop (at home) and my Hand-In folder (at school).

* Save as: Grand Prix.doc

 

1/28/08

(C)

Word Processing

Word Project 2: Biometrics Research Paper (pp. WD 74- WD 121)

 

  • Put YOUR (and my) information as student (and instructor)

  • Save to your laptop (at home) and my Hand-In folder (at school)

  • Save as: Biometrics.doc

 

1/29/08

(D)

Word Processing

Word Project 2: Biometrics Research Paper (pp. WD 74- WD 121)

  • Put YOUR (and my) information as student (and instructor)

  • Save to your laptop (at home) and my Hand-In folder (at school)

  • Save as: Biometrics.doc

 

1/30/08

(E)

Word Processing

 

1.  In the Lab #3 (WD 134)

  • Put YOUR (and my) information as student (and instructor)

  • Be sure to correctly apply MLA Standards

  • Save to your laptop (at home) and my Hand-In folder (at school)

  • Save as: Computer Software Paper.doc

 

Complete in-class assignment:

In the Lab #3 (WD 134)

 

1/31/08

(F)

Word Processing

 

1.  In the Lab #3 (WD 134)

  • Put YOUR (and my) information as student (and instructor)

  • Be sure to correctly apply MLA Standards

  • Save to your laptop (at home) and my Hand-In folder (at school)

  • Save as: Computer Software Paper.doc

 

Complete in-class assignment:

In the Lab #3 (WD 134)

Date Class Topic Assignment

2/1/08

(A; First Friday)

Word Processing

  • Acceptable use policy at SHA

  • Lecture and Discussion:  Creating a Resume and Cover Letter

    • Purpose, sections, length

    • Action words

    • Contact information

Save both documents to your Hand-In folder

  1. Resume overview (click the link and answer the questions in a separate Word document!)
     

  2. Web activity:  Best "How-to" sites

  • Save this as a separate Word document

  • Identify (provide the URL) and describe two Web sites that provide useful information on creating a resume and cover letter. 

For each, explain why a student creating her first resume and cover letter would find the site helpful.  (This is NOT a research paper that requires a Works Cited page.  Simply follow the directions.)

2/4/08

(B)

Word Processing

  • Acceptable use policy at SHA

  • Lecture and Discussion:  Creating a Resume and Cover Letter

    • Purpose, sections, length

    • Action words

    • Contact information

Save both documents to your Hand-In folder

  1. Resume overview (click the link and answer the questions in a separate Word document!)
     

  2. Web activity:  Best "How-to" sites

  • Save this as a separate Word document

  • Identify (provide the URL) and describe two Web sites that provide useful information on creating a resume and cover letter. 

For each, explain why a student creating her first resume and cover letter would find the site helpful.  (This is NOT a research paper that requires a Works Cited page.  Simply follow the directions.)

2/5/08

(C)

NO CLASS

Freshman Testing Day

2/6/08

(D; Paraliturgy)

Word Processing

  • Class Work-Through:  Resume

Compose a first draft of your resume.  Be sure to include Education, Experience, Honors and Awards, and Activities sections. 

(Use the sample resume we created in class to help you.)

 

Save all work to your computer--DO NOT PRINT

2/7/08

(E)

Word Processing

  • Class Work-Through:  Resume

Compose a first draft of your resume.  Be sure to include Education, Experience, Honors and Awards, and Activities sections. 

(Use the sample resume we created in class to help you.)

 

Save all work to your computer--DO NOT PRINT

2/8/08

(F)

Word Processing

  • Class Work-Through:  Resume

  • Individual work on resume 

Complete and print one-page resume

Save all work to your laptop and hand-in folder

2/11/08

(A)

Word Processing

  • Class Work-Through:  Resume

  • Individual work on resume 

Complete and print one-page resume

Save all work to your laptop and hand-in folder

2/12/08

(B; Class Mtg)

Word Processing

  • Resume completion and peer review

    • Print two copies of your resume at the start of class.

    • Each student will have two other students mark corrections--including spelling--directly on the printouts.

    • The proofreader must write her name in the top-left corner of the resume.

    • Spelling errors missed by the proofreaders will cause all three students to lose points.

Complete and print CORRECTED one-page resume.  Staple the two proofread copies with the final version.

2/13/08

(C)

Word Processing

  • Resume completion and peer review

    • Print two copies of your resume at the start of class.

    • Each student will have two other students mark corrections--including spelling--directly on the printouts.

    • The proofreader must write her name in the top-left corner of the resume.

    • Spelling errors missed by the proofreaders will cause all three students to lose points.

Complete and print CORRECTED one-page resume.  Staple the two proofread copies with the final version.

2/14/08

(D)

Word Processing

  • Lecture:  Cover Letters

  • Class Work-Through:  Project 3 Cover Letter (pp. 175-189)

Read the directions below.  You are NOT creating a resume for this assignment.

 

All cover letters should be in block style (see your class notes and Page WD 175 for a review of what this means). 

 

Do not exceed one page per cover letter.  Read the earlier pages in Project 3 for instructions on how to create the letterhead.  Do NOT include ClipArt.

 

Complete the cover letter we started in class (Project 3, Benjamin Kane Okamoto).  Save to your student folder AND PRINT.

 

You are NOT creating a resume for this assignment.

 

You will submit a printed copy of the letter next class and save the letter to your hand-in folder.  The letter should contain the sender's information as listed in the book. 

 

Remember:  You are the typist, not the sender.

2/15/08

(E)

Word Processing

  • Lecture:  Cover Letters

  • Class Work-Through:  Project 3 Cover Letter (pp. 175-189)

Read the directions below.  You are NOT creating a resume for this assignment.

 

All cover letters should be in block style (see your class notes and Page WD 175 for a review of what this means). 

 

Do not exceed one page per cover letter.  Read the earlier pages in Project 3 for instructions on how to create the letterhead.  Do NOT include ClipArt.

 

Complete the cover letter we started in class (Project 3, Benjamin Kane Okamoto).  Save to your student folder AND PRINT.

 

You are NOT creating a resume for this assignment.

 

You will submit a printed copy of the letter next class and save the letter to your hand-in folder.  The letter should contain the sender's information as listed in the book. 

 

Remember:  You are the typist, not the sender.

  WINTER BREAK (February 18-22)  

2/25/08

(F)

Word Processing

  • Review Activity:  Cover Letter

    • Read Part 1

    • Complete the bold directions for Part 2

    • SKIP Part 3

  • Examine your friend Matthew's cover letter, and retype a corrected version

    • There are SEVERAL mistakes in Matthew's letter.  You must revise the letter so that no mistakes remain.

    • You may revise the letter in any way you think is appropriate.

    • You are the typist.  Matthew is the sender.

    • Matthew is applying for a job at Milk Magnet Enterprises.

Review the formatting rules for block-style business letters

 

Complete the two in-class assignments

  • Cover letter blunders

  • Corrected cover letter

Save all assignments to the Hand-In folder.

 

Print only the corrected cover letter.

 

2/26/08

(A)

Word Processing

  • Review Activity:  Cover Letter

    • Read Part 1

    • Complete the bold directions for Part 2

    • SKIP Part 3

  • Examine your friend Matthew's cover letter, and retype a corrected version

    • There are SEVERAL mistakes in Matthew's letter.  You must revise the letter so that no mistakes remain.

    • You may revise the letter in any way you think is appropriate.

    • You are the typist.  Matthew is the sender.

    • Matthew is applying for a job at Milk Magnet Enterprises.

Review the formatting rules for block-style business letters

 

Complete the two in-class assignments

  • Cover letter blunders

  • Corrected cover letter

Save all assignments to the Hand-In folder.

 

Print only the corrected cover letter.

 

2/27/08

(B; Noon)

Word Processing

Read the Favorites assignment and gather all the necessary information.  You may choose a topic other than sports. 

 

View the samples (movies, sports) for a more complete picture of what the finished assignment will look like.  Be sure to have all the necessary information.  We will complete the assignment in class.

2/28/08

(C)

Word Processing

  • Review Activity:  Cover Letter

  • The cover letter in context

  • Lecture: Multi-column documents

  • Class work-through

Read the Favorites assignment and gather all the necessary information.  You may choose a topic other than sports. 

 

View the samples (movies, sports) for a more complete picture of what the finished assignment will look like.  Be sure to have all the necessary information.  We will complete the assignment in class.

2/29/08

(D)

Word Processing

  • Review: Block-style business letter

  • Class Work-Through:  Mail Merge

  • Group Activity: Mail merge

  • Intro: Multi-column documents

  • Complete the Favorites assignment

Read the Favorites assignment and gather all the necessary information.  You may choose a topic other than sports. 

 

View the samples (movies, sports) for a more complete picture of what the finished assignment will look like.  Be sure to have all the necessary information.  We will complete the assignment in class.

Date Class Topic Assignment

3/3/08

(E)

Word Processing

  • Review: Block-style business letter

  • Class Work-Through:  Mail Merge

  • Group Activity: Mail merge

  • Intro: Multi-column documents

  • Complete the Favorites assignment

Read the Favorites assignment and gather all the necessary information.  You may choose a topic other than sports. 

 

View the samples (movies, sports) for a more complete picture of what the finished assignment will look like.  Be sure to have all the necessary information.  We will complete the assignment in class.

3/4/08

(F)

Word Processing

  • Review: Multi-column documents

  • Complete the Favorites assignment

Complete the Favorites assignment

 

Review notes on cover letters and block-style formatting.

3/5/08

(A; 1:10)

Word Processing

  • Review: Multi-column documents

  • Complete the Favorites assignment

Complete the Favorites assignment

 

Review notes on cover letters and block-style formatting.

3/6/08

(B)

Spreadsheet (Rules)

  • Intro to Excel

  • Class work-through

  • Review of Rules

Homework pass

3/7/08

(C; First Friday)

Spreadsheet (Rules)

  • Intro to Excel

  • Class work-through

  • Review of Rules

Homework pass

3/10/08

(D)

 

  • Prepare your cover letter (no wizards allowed)

    • Use block-style business letter formatting

    • Save to your Word Hand-In folder

    • You do NOT need to submit a printed copy

  • Excel tutorial: Formulas

    • In class, turn your volume off

    • Skip the "Practice" page at the end of each section

Complete the cover letter and Excel tutorial.

3/11/08

(E)

 

  • Prepare your cover letter (no wizards allowed)

    • Use block-style business letter formatting

    • Save to your Word Hand-In folder

    • You do NOT need to submit a printed copy

  • Excel tutorial: Formulas

    • In class, turn your volume off

    • Skip the "Practice" page at the end of each section

Complete the cover letter and Excel tutorial.

3/12/08

(F)

Spreadsheet (Rules)

  • Project:  Excel Project 1 (Extreme Blading; see text, starting on p. EX 4)

Complete Extreme Blading.

3/13/08

(A)

Spreadsheet (Rules)

  • Project:  Excel Project 1 (Extreme Blading; see text, starting on p. EX 4)

Complete Extreme Blading.

3/14/08

(B)

Spreadsheet (Rules)

.

3/17/08

(C)

Spreadsheet (Rules)

.

3/18/08

(D)

Spreadsheet (Rules)

Select three stocks to recommend for the class portfolio.  (Use the Yahoo finance site to be sure the companies are publicly traded.)  Your stock choices should be typed in MLA format.  Be sure to include the company name, stock symbol, and a one-paragraph reason for each.

3/19/08

(E; Class Mtg)

Spreadsheet (Rules)

Select three stocks to recommend for the class portfolio.  (Use the Yahoo finance site to be sure the companies are publicly traded.)  Your stock choices should be typed in MLA format.  Be sure to include the company name, stock symbol, and a one-paragraph reason for each.

3/20/08

(F; Noon)

Spreadsheet (Rules)
  • Company Brainstorm and Symbol Lookup

  • Team Research

  • Stock selection for class portfolio

.

3/24/08

(A)

Spreadsheet (Rules)
  • Company Brainstorm and Symbol Lookup

  • Team Research

  • Stock selection for class portfolio

.

3/25/08

(B; Grades Close)

Spreadsheet (Rules)

Quarterly Grade Calculation

3/26/08

(C)

Spreadsheet (Rules)

Quarterly Grade Calculation

3/27/08

(D)

Spreadsheet (Rules)

  • SHA Stock Club
    • Cell referencing
    • Formulas and calculations

.

3/28/08

(E)

Spreadsheet (Rules)

  • SHA Stock Club
    • Cell referencing
    • Formulas and calculations

.

3/31/08

(F)

Spreadsheet (Rules)

.

Date Class Topic