Home Work Support

Fall 2002

last updated 20 January 2003. 

COMPUTER LITERACY:    Fall Semester

Note:

  • Homework assignments follow the order of the most recent assignments start at the top of the tables.
  • Worksheets are .rtf files and may be read by any version of MS Word, MS Works, Clarisworks or Appleworks
  • Course description
Click here for a reminder of the
proper hand position for keyboarding
 

Finals Week

FINALS: Continue all assignments related to Internet research and work on the Controversial Project paper

Tuesday: period 3

Thursday: period 5

ON MONDAY, JANUARY 27, YOU BEGIN HUMAN INTERACTION CLASSES

16 January

Continue all assignments related to Internet research and work on the Controversial Project paper

14 january

Collect signed parent progress report forms

Continue all assignments related to Internet research and work on the Controversial Project paper

10 January

Send home parent progress reports, with missing assignments attached

Continue all assignments related to Internet research

8 January

Continue work from 6 January
BE SURE THAT YOU HAVE AN APPROVED TOPIC DONE TODAY

6 January

Begin work on Controversial Article Reasearch Activity

  1. Complete Controversial Article topic submission to teacher [10 points]
  2. Begin Preparation by finding the online sources and quotes [22 points]

If time, you may continue work on the Internet Search and Citation assignments

  1. the assignment [20 points]
  2. the Human Interaction Search [18 points]

21 December -
5 January

Winter Break

HAPPY NEW YEAR

19 December

Correct and continue on Search practices

Introduce Controversial Article Research Activity

17 December

Complete Internet Search and Citation assignments
1. the assignment [20 points]
2. the
Human Interaction Search [18 points]

13 December

Continue use of subscription databases
Human Interaction Search [18 points]

11 December

Explore Narrowing search commands and results

Play the Holiday Search Game

9 December

Finish exploring the Casa Grande HS Library Data bases with Ms. Thompson, the Librarian
continue filling out Evidence cards and complete the assignment

5 December

Keyboarding

Exploring the Casa Grande HS Library Data bases with Ms. Thompson, the Librarian

discuss Boolean searches

continue with the assignment

3 December

Keyboarding

Introduction to the Casa Grande HS Library Data bases

finding creditable evidence on-line
1. the
assignment [20 points]
2. use the
Evidence card
3. use the
Online Bibliography format

27 - 30 November

Thanksgiving Holidays

26 November

Internet: Career Day Explorations with Ms. Cloud and Mr. Yagi

22 November

Activities: same as 14 November

Today is the last day work will be accepted for this grade period

20 November

Activities: same as 14 November

22 November is the last day work will be accepted for this grade period

18 November

Activities: same as 14 November

22 November is the last day work will be accepted for this grade period

14 November

Keyboarding for 20 minutes

Continue the assignments listed on 12 November 2002

If the requirted assignments are finished, then continue with the 'Paper Point' assignments
Remember:
a) all the classwork equals 75% of your grade period grade
b) each Paper Point can add 3.5% to your grade period totals, up to a mximum of 7 Paper Points

12 November

Keyboarding for 20 minutes

Finish or improve all assignments:

  • sales spreadsheet
  • Sales charts: pg. 154-162
  • Spreadsheet skill sheets: Mail merges, absolute and relative copy and protection, checking accounts & subtotals

  • Pi spresadsheet
  • Practice charts: borders, weather, Excel to Word

11November

Armistice/Veterans Day Holiday

7 November

Teacher out sick/substitute schedule
For those who are all caught up, there will be a DVD available.
20 minutes keyboarding practice
students may begin substituting classroom or personnal work for keyboard practice
Review and complete prior assignments
 
Begin the Copy and Subtotal activity
you will need to use the file 'Checking Account"

5 November

20 minutes keyboarding practice
students may begin substituting classroom or personnal work for keyboard practice

Review feed back from assignments returned today. Today your choices are:

  1. Complete unfinished work, especially
    1. Sales Spreadsheets
    2. Pi test
    3. practice sheets on Charts [pasges 154 - 162] [see Scoring Rubric for Chart #1:]
  2. Redo and improve scores of work returned
  3. Complete Worksheets for Relative and Absolute Copy
    You will need to download these two support files
    1. Computer Points
    2. Family Budget Done
  4. Complete the Merged Letter practice
NOTE: PROGRESS REPORTS WILL BE SENT HOME THURSDAY

1 November

20 minutes keyboarding practice
students may begin substituting classroom or personnal work for keyboard practice
Use the materials from Excel Workshop for Teacher by Janet Caughlin to practice creating merged letters from a spreadsheet list. You will ned to use the following materials to complete the assignment:
* Science Fair letter
* Student Information spreadsheet

30 October

20 minutes keyboarding practice
students may begin substituting classroom or personnal work for keyboard practice
Spreadsheet and Chart features practice [30 point assignment]
* complete practice sheets on Charts [pasges 154 - 162] - [up to 22.5 points]
* complete 'BORDERS' exercise sheet - [up to 2 points]
* complete 'WEATHER' exercise sheet - [up to 2 points]
* complete Excel to Word exercise sheet - [up to 3.5 points]
Scoring Rubric for Chart #1: practice pages 154 - 162

Scoring Rubric for Chart #2: Borders, Weather and Excel to Word sheets

 
Sample of Excel to Word exercise sheet
 
NOTE: Sales Spreadsheets and Pi test sheets may still be redone and returned, but those that arrive after Friday [11/1] will receive a late penalty

28 October

20 minutes keyboarding practice
students may begin substituting classroom or personnal work for keyboard practice
Introduce special WORD features
WordArt
Drawing lines
Autocorrect
Time to review and correct/finish Sales Spreadsheets and Pi test
Finish section on Charts [154-162] and continue PowerPoint section [page 62-95]

24 October

20 minutes keyboarding practice

Do POWERPOINT practice sheets, pages 62 - 95

Catch-up time last 30 minutes

22 October

20 minutes keyboarding practice

Discuss the addition to the Grade Policy for receiving an A or a B grade
In class work and activities...........................................75% of 2nd report period grade
Four 'paper' points........................................................14%
3 'paper'........................................................................11%
Finish or correct Sales Spreadsheets and materials, finishing up to page 154
Discuss and complee the rubric/review sheet for Sales that Mr. Sovel gives you
Complete BM Iworksheets and Pi test form
 
Finish CHARTS practice sheets, pages 154 - 162

18 October

20 minutes keyboarding practice

Finish all Spreadsheet Practice Sheets up to page 154

NOTE:
  • A COMPLETE AND ACCURATE 'SALES' FILE WILL BE GRADED AT THE END OF THIS SECTION
  • IT MUST CONTAIN ACTUAL FORMULAS AND CALCULATIONS IN ALL APPROPRIATE CELLS, NOT JUST NUMBERS TYPED IN!

Begin Spreadsheet Graded Test #1

  1. The first part of the project does not require the computer.
    [Data Gathering Instructions]
  2. Once you have gathered the data, create a spreadsheet
    Use the guidelines and directions shown on the Spreadsheet Test form

20 minutes keyboarding practice

Continue Spreadsheet Practice Sheets pages 145 - 154

Finish Body Mass Index assignment and spresadsheet

14 October

20 minutes keyboarding practice

Continue Spreadsheet Practice Sheets pages 135 - 144

Begin Body Mass Index assignment and spresadsheet

10 October

20 minutes keyboarding practice

Introduce Spreadsheets

Begin workbook practicve sheets pages 120 - 134

8 October

20 minutes keyboarding practice

Continue work from Friday, October 4

Today is the last day of the grading period

Thursday, we begin spreadsheets with Excel

4 October

You may download today's activity sheet that will be used by the class's Substitute Teacher

30 minute keyboarding practice

last Notebook check/collect signed parent letters

Finish graded activity: Advanced Word Practice

Begin Advance Tables Exercise or work on test REDO

Introduce new Computer Literacy workbook

2 October

20 minute keyboarding practice

2nd Notebook check/collect parent letters/introduce grade sheets

Introduce practice materials:

line and page breaks

headers and footers

page previews

Begin graded activity: Advanced Word Practice

Pass out Advance Tables Exercise, for use at a later time

HW:
  • signed parent letters due Friday [Oct. 4]
  • last day to turn in 1st graded test REDO [Oct. 4]
  • last chance for even partial credit for notebook

30 September

20 minute keyboarding practice

Notebook check

Review Test 1 results
Discuss how to improve score up to 70%
 
Introduce Tables and tables activity practice
 
HW:
signed parent letters due Friday [Oct. 4]
last day to turn in 1st graded test REDO [Oct. 4]

26 September

20 minute keyboarding practice

Finish Graded Assignment

Here is a copy of the test scoring rubric
Each student will use the rubric to do a preliminary assessment of their work

Practice sheet: inserting graphics in word

HW:
Each student will bring a notebook to keep all Computer Literacy handouts in an organized manner

24 September

Class meets with Mr. Yagi for freshmen counseling orientation

20 minute keyboarding practice

Begin first formal Graded Assignment
here are the instructions
the goal is not only to match the example, but to
demonstrate knowledge of these features of MS WORD
HW:
The graded assignment is due by the end of class on September 26
Students may work on it during tutorial, both Wednesday and Thursday
It is highly recommended that students assemble all their notes and handouts

20 September

20 minute keyboarding practice

Using the Ruler and Tabs

practice with pages 2 and 10 from UltraKey book

18 September

Log on to Typing Program

Practice using typing/keyboarding program with a focus on

  • posture
  • hand position
  • home row and home keys
  • using the proper findgers
  • finding your practice level and baseline speed/accuracy
  • navigating the program preferences

16 September

Introduce:

spell check

undo changes

fonts

indents and line spacing

align text

drag and drop

Edit Interviews

WRITE A LETTER TO MR. SOVEL, TELLING HIM WHAT HE MISSED OUT ON TODAY

12 September

Introduce logging in process

Introduction and overview of some features of MS WORD

pull down menu glossary

save and save as

highlighting text

cut, paste and dragging text

find and replace

class mate interview

10 September

Assign work stations

Work with partner to familiarize students with basic concepts, i.e,

turning on computer/monitor

desktop properties

opening & using multiple programs

resolution and screen savers

log-on

deleting/recycle bin

START

quick launch

left/right mouse buttons

drop down menus

6 September

Assist instructor in installing new computers to lab [partners]

Computer terms and crossword puzzles

View a portion of War Games video, if time

HW:
Complete crossword puzzle

4 September

Finish review of Computer questionnaire

LCD demonstration of some of the skills to be taught

Attention game

View a portion of War Games video, if time

3 September

Attention Game [if time]

Discuss Course description

1st Day Questionaire

Computer Lit questions

Homewrok:
Computer Lit questions [DUE Wednesday]
 

(return to top of page)

Computer Literacy
return to Home

If you have a question, or feedback, you may contact me by sending an

to Barry Sovel

For more information about Barry Sovel

 

Return to home