Skills 1 Assignment Calendar- Fall '09

Current Calendar

9/8/09 Week 1 Day 1

 

New Olympians Day

 

 

9/9/09 Day 2

Get to know you!:

  • Login
  • Open Word doc
  • Title (Name-Get to know you)
  • List 5 things you did this summer
  • One sentence- What would you do after school if you could do anything you want
  • Save: last first know you

Discuss T:

  • Make folders- personal and sub
  • Open Excel and practice saving
  • Save to T:!

 

Websites:

  • Show Sprague's and personal
  • Show calendar
  • today, weeks, and Ctrl F
  • Syllabus

Course Syllabus (Homework)

  • Read,, sign and return
    course syllabus

    (both parent and student)
  • COURSE REQUIREMENT

9/11/09 Day 3

Collect Syllabus

  • Discuss class expectations
  • Discuss my website

Review:

  • Local login (to the machine)
  • T: (Thawspace folders)

Google image search

  • Pick a theme
  • (Mine might be football or soccer)
  • Find 10 images online you like (theme!!!)
  • Save them to your images folder
  • Save the largest version of the image

Spraguetech2 server

  • Logging in
  • Local folder
  • Backing up information
  • Back up pictures from last time

Microtype

  • No time...

9/15/09 Week 2 Day 4

Review:

  • Computer login and T:
  • Spraguetech2 login
  • Finding your folder
  • Backing up your work!!

Applications Pre-test

  • Directions will be given in class

Network practice

  • Go to Adkins\files\Word
  • Copy hello.doc
  • Paste into your T: folder
  • Copy paste to your tech2 folder

Microtype

  • Create new user
  • Skills Analysis- hands covered
  • Correct typing position
  • Alphabet keyboarding - lesson 1

9/17/09 Week 2 Day 5

Every day...

  • Login to the local machine (duh!)
  • Login to Spraguetech2 too!!

Network practice- rename this act.

  • Adkins\files to copy
  • Copy rename-this.doc
  • Paste into thawspace folder
  • Rename to last first rename.doc
  • Paste into submissions folder

Applications Pre-test

  • Directions will be given in class

 

Microtype

  • Finding your username
  • Open and continue
  • Finish lesson 1 today HANDS COVERED
  • Start lesson 2??

Excel intro

Should have been done 9/17

Forgot pretest on 9/15

  • Open Excel
  • Rows, Columns, Cells, tab, enter etc
  • Begin "practice" document

 

 

9/21/09 Week 3 Day 6

Rename this review

  • Discuss "graded" folder
  • Fix errors, all files correctly named

Internet Activiy

"Dinner and a Movie"

  • Google tools you might not know
  • Directions will be given in class

Excel Intro

  • Open Excel
  • Rows, Columns, Cells, tab, enter etc
  • Begin "practice" document

Microtype

  • Continue lessons- Finish lesson 3????

9/23/09 Week 3 Day 7

Excel Intro- continued

  • Open Practice spreadsheet
  • Review formulas

Microtype

  • Continue lessons
  • Goal: Finish lesson 4
  • Check progress today for grading

Begin Gradebook project

Gradebook project

  • Complete steps 1 and 2 in sheet 1
  • More if time

 

9/25/09 Day 8

Gradebook (cont)

Gradebook project

  • Steps 3 and 4
  • Copy previous work into sheet 2
  • Add new info in sheet 2

Microtype

  • Continue lessons
  • Goal: Finish lesson 4
  • Check progress today for grading??

 

 

 

9/29/09 Week 4 Day 9

Gradebook (cont)

Gradebook project

  • Copy previous work into sheet 3
  • Rename sheet 3 to "day 2"
  • Rename sheet 1 to "current"
  • Step 4-% and step 6 absolute reference
  • Always work in "current" sheet

Microtype

  • Continue lessons
  • Goal: Finish lesson 5

10/1/09 Day 10

Gradebook (cont)

Gradebook project

  • Insert new worksheet
  • Rename to "day 3"
  • Copy previous work into "day 3"
  • Step 5-
    • First and last names
    • Add more names
    • At least 10 names total
  • Step 7 final gradebook

Microtype

  • Continue lessons
  • (ran out of time... lesson 6 still expectation)

 

 

10/5/09 Week 5 Day 11

Gradebook (cont)

Gradebook project

  • Insert new worksheet
  • Rename to "day 4"
  • Copy previous to day 4
  • Steps 7-8
  • Insert comments and sorting
  • Start grading

Photoshop intro

  • Learn basic editing tools
  • Alter our old tech photo for practice

Microtype

  • No time

 

10/7/09 Week 5 Day 12

Internet Intro

  • Browsers, html code and more
  • Complete the horses part of the activity
  • Add 1 more picture of your choosing

Photoshop

  • Review tools
  • Show a few more!

 

Grading Gradebook!!

Microtype

  • Finish thru lesson 6

10/9/09

Statewide In-service Day

No School for students

 

 

10/12/09 Week 6 Day 13

Microtype

  • Finish thru lesson 7
  • Re-check progress today

Internet Intro (no time)

  • Browsers, html code and more
  • Complete the horses part of the activity
  • Add 1 more picture of your choosing

Grading Gradebook!!

Photoshop (if time)

  • Edit the tech page
  • Goal: at least 5 "new" heads
  • Only if you are caught up!

10/14/09 Day 14

 

PSAT schedule

  • Shortened periods today
  • Here is the schedule

 

What is a browser??

  • video and discussion

 

Make sure you have all your work in

 

Microtype

  • Goal: lesson 8
  • Last chance to re-check

 

10/16/09

 

 

1st 6 Weeks Grading 1/2 Day

In-service Day

No School for students

 

10/19/09 Week 7 Day 15

Microtype

  • Thru lesson 9 today

Internet Intro

  • Review "What is a browser"
  • Browsers, html code and more
  • Complete the horses part of the activity
  • Add 1 more picture of your choosing

Photoshop

  • Edit the tech page
  • Goal: at least 5 "new" heads
  • Teach adding text

10/21/09 Day 16

Internet activity (cont)

  • Find 2 more images of your choice
  • Follow the 16 step directions
  • 4 images formatted, tight, square, over and behind
  • Don't forget to insert page breaks

Access Databases

  • Coaches Database- See files to copy
  • Download from the net
  • Intro:
  • Structure
  • Adjust/move columns
  • Sort and filter

Photoshop

  • Saving as a .jpg
  • Make sure you have the .psd too
  • Due Friday... requirements

10/23/09 Day 17

Access Database

Internet Intro Activity

  • Finish the Internet Intro Activity if not done
  • 4 images formatted, tight, square, over and behind

Microtype

  • We are a bit behind...
  • Thru lessons 10 and 11 today

Tech photo due next week

    I'll explain why we are posponing this next week
  • Requirements

 

10/27/09 Week 8 Day 18

Microtype

  • thru 12 lessons
  • Reminder: you don't have to do the review sections unless you need practice

Tech Photo

  • Rename last first tech photo.jpg
  • Submit to submissions folder

Coaches DB questions

  • Discuss questions from last week

Nations Database

  • Copy/paste from files to copy
  • Download from net
  • Review:
  • sort, filter, move columns, adv filter

10/29/09 Day 19

Microtype

  • thru lesson 13

Internet Intro Activity

  • Internet Intro details
  • Are you done??
  • Browser differences
    • IE vs Firefox copy/paste

Nations Database

  • Review sort/filter
  • Discuss records-advanced filter
  • Copy/paste to Word
  • Start Nations questions

 

11/2/09 Week 9 Day 20

Turn in Internet Intro Activity

  • File name is last first internet practice
  • See folder in submissions

Nations Database

  • Review filter/sort
  • Review advanced filter
  • Teach copy/paste to Word
  • Finish Nations questions

Microtype

  • ran out of time

11/4/09 Day 21

Nations Database

Photoshop

  • Add your "sign"

Microtype

  • thru 14"checks"

11/6/09 Day 22

Nations Database

Microtype

  • thru 15"checks"

Get caught up...

  • Nations questions
  • Query questons (see above)
  • Catch up in Microtype

If done with all...

  • Photoshop... add your sign

11/10/09 Week 10 Day 23

Microtype

  • 15 "checks"
  • Work on review sections if 15 complete

Nations Database

  • Review filter sort in the table
  • Quiz on Thursday
  • Review building queries
  • Teach how to build reports
  • Answer query questions #3, #4

Catch up...

If done... Photoshop... add your sign

11/11/09

 

Veteran's Day

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

11/13/09 Day 24

Grades... are you caught up??

  • 1 week to go until grades come out
  • under Adkins\Grades...
    • Check your grade in the PDF file

Start "Joe Sprague" study habits

  • In class activity
  • Graphs in Excel

Nations Database

  • Review sort-filter in table
  • Nations Quiz

Microtype

  • ran out of time

11/17/09 Week 11 Day 25

Microtype

  • Take a timing
  • Check progress
  • 16 "checks"

Joe Sprague (cont)

Formula review

  • Find total hours studied
  • Add "Minutes" column next to hours
  • Find the formula to calculate # of minutes
  • Find the total minutes
  • Add a "check" for your answer
    • We will discuss how!

Formatting Review

Add:

  • Cell color-
    • group like content with like color!
  • borders

11/19/09 Day 26

Joe Sprague (cont)

Additional Graphs

  • Add another bar graph
  • Compare day to minutes
  • Add another column graph
  • Compare day to minutes
  • New graph
  • Add pie graphs comparing
  • Day to hour
  • Day to minutes
  • **All graphs should be in their own sheet
  • **Sheets should be clearly named

Microtype

  • 17 checks

If you are caught up you will be going back and selecting some of the review sections you skipped

 

If you are all caught up...

Photoshop "add your sign"

Grading Day is Monday...

11/23/09 Week 12

 

Grading Day

 

Conferences

 

11/24/09

 

Conferences

Thanksgiving

11/25-11/27

11/30/09 Week 13 Day 27

Microtype

Goal: 18 checks

  • If you are done with all 20...
  • You have some Internet time

Joe Sprague (cont)

More formulas:

  • Find the average for hours and minutes
  • Find the median for both
  • Begin Grading????

Animation PPT

12/2/09 Day 28

Microtype

Goal: 19 checks

  • If you are done with all 20...
  • You have some Internet time

Joe Sprague (cont)

Begin Grading:

  • Data sheet w/
    • total, average, medianand check formulas
  • 7 Graphs:
    • 2 bar, 2 column, 2 pie, 1 your choice

Animation PPT

12/4/09 Day 29

Microtype

Goal: 20 checks

  • If you are done with all 20...
  • You have some Internet time

Joe Sprague (cont)

Begin Grading:

  • Data sheet w/
    • total, average, medianand check formulas
  • 7 Graphs:
    • 2 bar, 2 column, 2 pie, 1 your choice

Animation PPT

 

12/8/09 Week 14 Day 30

Microtype

  • Continue typing
  • Goal: 20 checks... your chance to catch up

Joe Sprague (cont)

Continue Grading:

  • Data sheet w/
    • total, average, medianand check formulas
  • 7 Graphs:
    • 2 bar, 2 column, 2 pie, 1 your choice

Animation PPT

12/10/09 Day 31

Microtype

  • Take a timing
  • Check progress... goal is 20 checks
  • Type while I record progress

Animation PPT

Joe Sprague (cont)

Continue Grading:

  • Data sheet w/
    • total, average, medianand check formulas
  • 7 Graphs:
    • 2 bar, 2 column, 2 pie, 1 your choice

 

 

 

 

 

12/14/09 Week 15 Day 32

Microtype

  • Finish 20 lessons... if you aren't done

Holiday Invitation/Card in Word

Animation PPT

12/16/09 Day 33

Microtype

  • Finish 20 lessons... if you aren't done

Holiday Invitation/Card in Word

Animation PPT

If you are done with all above:

Photoshop Activity

  • Holiday/Winter/Snow image
    • Here is the info for web
    • We will might add it to the Sprague site!

 

12/18/09 Day 34

Microtype

  • Take a timing
  • Check progress... goal is still 20 checks

Holiday Invitation/Card in Word

Animation PPT

If you are done with all above:

Photoshop Activity

  • Holiday/Winter/Snow image
    • Here is the info for web
    • We will might add it to the Sprague site!

 

1/5/10 Week 16 Day 35

Microtype

Start in Skillbuilder today

  • Be sure "speed" is chosen
  • Take Skills Analysis
  • Complete lesson 1

Animation PPT grades

  • Hand back evaluation sheets
  • DON'T LOSE THIS SHEET OF PAPER!
  • Discuss grades/improvements

Address Book project

Making an Address book in Access

1/7/10 Day 36

Microtype

Continue in Skillbuilder

  • Be sure "speed" is chosen
  • Complete lesson 2

Grades

  • See Grades folder on Sprague tech2

Address Book project

Making an Address book in Access

 

 

 

1/11/10 Week 17 Day 37

Microtype

Continue in Skillbuilder

  • Be sure "speed" is chosen
  • Complete lesson 3

Tiny URL activity

Address Book

Project details

  • Review Queries
  • Make Reports

1/13/10 Day 38

Microtype

Continue in Skillbuilder

  • Be sure "speed" is chosen
  • Complete lesson 4

Address Book

Project details

  • Grading Begins today
  • I will grade at your computer
  • Process given in this link

 

1/15/10 Day 39

Microtype

Take a timing...

we will do this as a group

Continue in Skillbuilder

  • Be sure "speed" is chosen
  • Complete lesson 5

URBAN FLAIR VOTING!

Address Book

Project details

Personal Logo Activity

Project details

  • This will be used on the final exam

1/20/10 Week 18 Day 40

Microtype

Progress Check today

  • Skillbuilder thru lesson 5 is the goal

Address Book

Project details

  • Grading continues
  • Process given in this link

Discuss final exam

In 3 parts:

  • Excel
  • Word
  • Microtype

Final Exam Review

Personal Logo Activity

Project details

  • This will be used on the final exam

1/22/10 Day 41

Last Day for Missing Work!!!

 

Microtype

  • Improve a timing if you like
  • Lesson 6 today... this is the final goal!!!

Address Book

Project details

  • Grading continues
  • Process given in this link

Final Exam Review

Begin Word review

 

Personal Logo Activity

Project details

  • This will be used on the final exam

 

 

1/26/10 Week 19 Day 42

All 8 periods today

 

Final Exam rules:

  • No one leaves class once it begins
  • Make sure to take advantage of breaks

Final Exam Review

In 3 parts:

  • Excel
  • Word
  • Microtype

Finish Word Review

Final Exam

 

1/27 Wednesday

 

Period 1 7:50 - 9:15