Jan 31

NO SCHOOL

GRADE INSERVICE DAY

Feb 1 Day 1

Intro
Roll - Intro

Syllabus
Read, Print out, Sign and return for points.

Login
Local and Server

Set up
Thawspace folder and Server

Feb 2 Day 2

Syllabus
Collect Syllabus

My Docs vs Thawspace

Excel Review:
Start AJ's Trucking.
Build the basic shell and enter first 3 drivers.

Feb 3 Day 3

Excel Review:
Continue AJ's Trucking.
Pick up where you left off last time.

Feb 4 Day 4

Startup:
Make sure you have a MicroType account - Do Skillbuilder - Lesson 1 - Make sure ACCURACY is selected.

Word Review:
"The Wall" -
Find or create your Wall
Start Word Document

Excel Review:
Continue AJ's Trucking.
Pick up where you left off last time.

Feb 6 Day 5

Typing
Use MicroType, TyperShark - or another Typing program - work on typing for 10 minutes

Excel Review:
AJ's Trucking.
Talk about any issues.
Look over work. Make sure all formulas work. Protection. Change numbers and look at graphs. - Start grading

Word Review:
"The Wall" -
Talk about any issues.
Talk about Text Boxes. Look at some formatting options. What do the steps mean.

Feb 7 Day 6

Image Work
Find 10 images about a theme - we will be making a collage of these.

Excel Review:
AJ's Trucking.
I will start to grade this today

Word Review:
"The Wall" -
We will turn this in Friday - Finish picture and work on paragraph.

Feb 8 Day 7

Typing
Use MicroType, TyperShark - or another Typing program - work on typing for 10 minutes

Excel Review:
AJ's Trucking.
I will finish grading today??

Word Review:
"The Wall" -
We will turn this in Friday

Image Work
Make sure you have 10 images. Demonstrate process of making layers, naming, saving, etc. Create a new "palette" 8 x 10.

Feb 9 Day 8

Image
Work on Collage

Word Review
"The Wall" -
Finish picture and work on paragraph.

Excel Review:
AJ's Trucking.
Look at Data validation

Feb 10 Day 9

Image
Work on Collage -

Word Review
"The Wall" -
Turn this in

Feb 13

NO SCHOOL

FURLOUGH DAY

Feb 14 Day 10

Warmups:
Internet activity :

• Start a Word document
• Save as Last First Internet.doc.
• Go to Google - Select More - then Select Even More
• Describe what you found, why could this be useful?
• You need to find and describe at least 3 items

Word
Look at Page Setup Options.

Feb 15 Day 11

Warmups: Internet activity : Put a new heading in Word Document with today's date. Explain how you found your answers (ie. search terms, engines, etc.)

• Find a map of the middle east
• Find the current leader of Iraq (when did he take power?)
• Find the highest ranking US official that remains in Iraq
• Make sure all maps, names and information are in your Word document. Include a link to sources

Image Editing -
Look at some options to make collage better

Feb 16 Day 12

Image Edit -
Work on Collage

Internet Search
Make sure you have both parts of internet search done

Feb 17 Day 13

Internet Search - Click here for details. Add to current Internet Document

Feb 20

No School

PRESIDENT'S DAY

Feb 21 Day 14

Internet Search - Click here for details. Add to current Internet Document

Image Editing -
Finish up Collage - add text - turn this in today (if not in already)

Feb 22 Day 15

Google Accounts

• Everyone get a Google account
• **This assignment will be worth 0 points until you have your syllabus
• Google docs
• Create a google doc and share with me

Ad Activity in Word

Project info

• Create the structure using your Google doc
• Share finished projects
• Think about what you want to advertise!

Feb 23 Day 16

Ad Activity in Word

Project info

• Create the structure using your Google doc
• Share finished projects
• Think about what you want to advertise!

Feb 24 Day 17

Ad Activity in Word

Project info

• Create the structure using your Google doc
• Share finished projects
• Think about what you want to advertise!

TOP

Feb 27 Day 18

Typing
Record your typing program here

Ad Activity
Work on Ad Activity if not done.

Database
Begin Student Information Database - We will do part 1 today and enter your own information

Feb 28 Day 19

Ad Activity :
Finish up Ad Activity - go look at 2 others students work - edit yours as needed

Database -
Student Information Database. Instruction will be given in class. We will be working on Part 2 today.

Feb 29 Day 20

Ad Activity :
Turn this in tomorrow

Internet Search:
Make sure you have all 3 activities done

Database -
Student Information Database. Instruction will be given in class.

Mar 1

NO SCHOOL

SNOW DAY

(WEIRD, HUH?)

Mar 2 Day 21

Ad Activity :
Turn this in

Database -
Student Information Database Instruction will be given in class.

Typing -
Get a timing - record with me - RULE OF 37

Internet
Guts of Computer Crossword Search

Database -
Student Information Database. Instruction will be given in class. Quiz next week.

Mar 6 Day 23

Start up
Do Some Typing

Web 2.0
Create a blog

Database
Make sure all questions/Queries are done

If all done - work on makeup work

Mar 7 Day 24

Warmups:
Get a Timing - Rule of 37

The truth about credit cards
Basic Payoff Spreadsheet

Make up Work
Make sure all work is done

Mar 8 Day 25

What still needs to be done???

Mar 9

No School - Grading

Startup: Student Information Database. Finish Questions on Mr. Adkins Webpage. I will grade the Word Doc and Queries/Forms/Reports next time

Amortization Spreadsheet Activity
Student created and edited. Look a this - how does it work - practice

Internet Search - Make sure you have all internet searches caught up. Turn in document to Tech2 folder.

Mar 13 Day 27

Google
Make sure blog is set up and ready. Do you know how to edit your blog ("pencil" does not always show up...)

Amortization
Work on Questions - Turn this in

Student Info Database
Turn in your Database and Word Doc

Mar 14 Day 28

Startup: Redo Amort if needed

Blogging

• Something I've learned!!
  • Internet Explorer and Google don't mix well
  • When using docs or blogging use Chrome or Firefox
• Review:
  • Posting
  • Followers
  • Archives
  • Comments
    • Post a comment to my blog
    • Controlling comments is very important
    • Be sure HIDE COMMENTS on yours

My Hero - Internet Search Activity. Click here for details.

Mar 15 Day 29

Database - Student Information Database.Talk about filter, search, etc - Quiz Next week

Blogging

• Add Blog post #2
• Read my blog post
• respond by publishing a second post in your own blog.
• Please copy/paste the link to your blog in this form

Make up : Are you all caught up? Have you finished Amort (100%), turned in Internet Search, turned in Student Info Database???

Mar 16 Day 30

My Hero Part 2- Internet Search Activity. Click here for details.

Image search for Picasa project

• Google search for 10 animal images (minimum)
• This can be 1 type of animal or many different ones
• Make sure to save the largest images you can
• Save into a folder called "my-animals" for next week's project

TOP

Mar 19 Day 31

Make sure you have 10 images saved in your Thawspace

Picasa
We will make a Picasa photo album today
Make sure this is Public - click here for instructions

Blogging
We will add the Photo Album to our blog
Add a 2nd gadget (school appropriate) - Click here for instructions

Are the following done?
Amort Questions (100%)
Blog Form
2nd Blog Post
Gadgets

Blogging
"My Superhero"

• Create a 2nd blog
• use "last name-my-superhero
• You get to create your own Superhero!
• Write your first episode
• Introduce your Superhero
• Here is Mr A's example (go to Episode 1)
• See my blog

Mar 21 Day 33

Typing Timing
For those that have not met rule of 37 - take a timing

Ad Activity
Do Ad Activity in Google
Share with Me

When Done:
Make sure Ad Activity is done
Make sure 1st episode is done

NO SCHOOL

SNOW DAY

(VERY WEIRD, HUH?)

Mar 23 Day 34

Quiz
Student Info Database
Copy Combined Database from Files to copy
Take Quiz

Ad Activity
Finish Ad Activity in Google
Share with Me

Mar 26

Sp

Mar 27

ri

Mar 28

ng

Mar 29

Bre

Mar 30

ak

Blogging
SuperHero Episode #2

Web 2.0
Talk about Readers

Fill Out This form
Fill out this form about your superhero blog

.

Apr 3 Day 36

Typing
Rule of 37 Timing - if done - work on Blog or other make up work

Clothing Sales Activity:
1. Copy/paste all data from webpage
2. Demo autofilter/subtotal formula
3. Discuss recording options
4. Begin data collection

Apr 4 Day 37

Clothing Sales Activity:
1. Copy/paste all data from webpage
2. Demo autofilter/subtotal formula
3. Discuss recording options
4. Begin data collection

Make sure all blog work is updated

• Skills 2 Blog (2 posts - gadget - image - etc)
• Superhero (2 posts)

Apr 5 Day 38

Warmups: Start a new Google Doc - "My Dream Car" - share it with me.
Find 3 websites that will allow you to shop for used cars.
Record the URL in your shared Google doc.

Clothing Sales Activity:
Today you will work on creating a report about your clothing store. This link will take you to more details.

Apr 6 Day 39

Typing
Rule of 37 Timing - if done - work on Blog or other make up work

Clothing Sales Activity: Finish Report - turn this in.

Apr 9 Day 40

Startup

• Go to Prezi.com
• Sign up for a new account
• Click on Students & Teachers
• Select Enjoy Edu
• Follow Instructions from there
• Use your spraguehs email
• You will get a confirmation email you need to access this to finish the process
• Once in - play with prezi and see what you can do

Make Up Work
Make sure all work is done

Apr 10 Day 41

Blogging
Episode 3 -
The conflict
See Adkins Example

Apr 11 Day 42

Dream Car
Use the first entry on our car site list
Find:

• Toyota Tacoma (Truck)
• Within 100 miles of 97302
• Automatic Transmission
• 4 wheel drive
• $15,000 or less
• Image
• Any: year, color, mileage
• ---Record information in "My Dream Car" docs

Apr 12 Day 43

Superhero Episode #4- Continue conflict...
See Mr A's example

Dream Car
For the Tacoma - find the Kelley Blue Book value
Finding relative value
Add this to your "Dream Car" google doc

Apr 13 Day 44

Video

Superhero
Episode #5-
See Mr A's example

TOP

Apr 16

NO SCHOOL

FURLOUGH DAY

Apr 17 Day 45

CarFax Report
What is this?
Why do I want one?
How do I find this?

Used Car Project
Demo the start of this project. See list.
If you need ideas where to look for cars - look here.
For today - just focus on steps 1 - 10.

Apr 18 Day 46

Used Car Project
See information.
If you need ideas where to look for cars - look here.
For today - make sure you have all details for steps 1 - 10. We will work on the last few things tomorrow and Friday.

Apr 19 Day 47

Typing
Rule of 37 timing

Used Car Project
Find a loan today - I will demonstrate
Add this part to your project

Apr 20 Day 48

Used Car Project
By the end of the period - you should have all information (steps 1-12) in your google doc.

Image Project
We will start our Image Merge Project today

Startup
I will let you know if you need a rule of 37 timing -- if not, you can work on Used Car - or work on Image Merge

Used Car Project
How will we present this? What needs to be in presentation?

Used Car Project
Work on finding information and/or putting together presentation

Make up work
Do you have any unfinished projects?

Apr 25 Day 51

Used Car Project
Work on finding information and/or putting together presentation

Used Car Project
This should be ready to turn in today - I will talk about how to turn this in. Work on finding information and/or putting together presentation

Apr 27

No School - Grading

Apr 30 Day 53

Used Car Project

• Make sure you have all 12 items taken care of
• Make sure your google doc is shared with me
• Fill out the form about your Prezi
• Are you google doc and Prezi done?

Photo Merge Project

• Go to Files To Copy - Skills 2
• Copy the merge-images to your Thawspace
• Open GIMP
• Open all 4 images in the bridge-merge folder
• Create a new image (I used 6000 x 2000)
• If you get a warming - click OK
• Save as ... Last First Bridge.psd
• Copy and paste the 4 images into your new image
• Using Layers - (Ctrl-L) move these around so they "line up" (look at bridge - trees, etc.)
• Save often

Startup: Work on Photo Merge - if bridge is "done" - pick one other folder in merge-images

Photo Merge Project
Talk about some ideas
Need to have 2 photos done (one can be your own)
Add other items to Bridge

May 2 Day 55

Photo Merge Project
Talk about some ideas
Need to have 2 photos done (one can be your own)
Add other items to Bridge

Photo Merge Project
Talk about some ideas
Need to have 2 photos done (one can be your own)
Add other items to Bridge

Student Enrollment:
Click on the following link to get the data. Follow instructions to make the spreadsheet.

May 4 Day 57

Photo Merge Project
Talk about some ideas
Need to have 2 photos done (one can be your own)
Add other items to Bridge

Student Enrollment:
Click on the following link to get the data. Follow instructions to make the spreadsheet.

TOP

May 7 Day 58

Student Enrollment:
Click on the following link to get the data. Follow instructions to make the spreadsheet.
* Look at Macros
* Sort/Filter

May 8 Day 59

Student Enrollment:
Click on the following link to get the data. Follow instructions to make the spreadsheet.
* Make Buttons

May 9 Day 60

Student Enrollment:
Click on the following link to get the data. Follow instructions to make the spreadsheet.

Be ready to get this graded

May 10 Day 61

School Enrollment spreadsheet
I will start grading this next time. Make sure you have Buttons:
1. Total descending
2. Alphabetize school
3. 1 of your choice
4. 9th grade descending
5. Total greater than 1800
6. Filter on/off

May 11 Day 62

School Enrollment spreadsheet
I will start grading this today. Make sure you have Buttons:
1. Total descending
2. Alphabetize school
3. 1 of your choice
4. 9th grade descending
5. Total greater than 1800
6. Filter on/off

May 14 Day 63

School Enrollment spreadsheet
I will finish grading this today.

• Go to google docs
• Create a form...
  • think of something you want to ask your fellow students
  • Or, just ask some silly questions...
• Goals:
  • Learn how to make and use Google forms
  • Create a meaningful "poll" we might use on Sprague's site

Add your form to your blog

• Use the first blog (not Superhero... separate purpose)
• Follow instructions in Mr. A's post on his blog

May 15 Day 64

Google Forms...
Make sure you have created a form and added it to your blog

Go to Google Docs
Create a New Drawing

• Add a least 4 shapes
• Add an image
• Change Fill color of shapes
• Change line color
• Add Text
• Rotate at least one shape
• Figure out how to use format painter
• Create a fun image
• Change title to "Last name drawing"
• Share with me

May 16 Day 65

Discount spreadsheet
Create a spreadsheet that looks just like the picture.

After you create the "structure" you can begin the process of building formulas.

May 17 Day 66

Google Forms
Talk about forms and publishing to blog

Discount spreadsheet
Open the spreadsheet you made last time. We will talk about VLookUp today - then you can apply this idea to the spreadsheet.

May 18 Day 67

Google Forms
You will take at least 5 polls today (I will give instructions)

Period 3 blogs
Period 5 blogs

Discount Spreadsheet -
We will continue work on this.
Talk about protecting the sheet
What is data validation?

May 21 Day 68

Google Forms
Add Responses to Form
Talk about some issues
Take my Survey

Discount Spreadsheet
We will continue work on this.
You need to add at least 3 buttons to this. You decide what they do.

May 22 Day 69

Discount Spreadsheet
Continue working on this.
Protection
Validation
Buttons/Macros
What else?

May 23 Day 70

Google Forms
Add Gadgets to Form

Discount Spreadsheet
Continue working on this.
Protection
Validation
Buttons/Macros
What else?

May 24 Day 71

Google Bookmarks
What is it?
How to use?
Why is this?

Discount Spreadsheet
Continue working on this.
Protection
Validation
Buttons/Macros
What else?
Upload to google docs - does everything transfer?

May 25 Day 72

Google Forms
Add Gadgets to Form
Calculate average, median
Share it with me

Discount Spreadsheet
Continue working on this.
Protection
Validation
Buttons/Macros
What else?
Finish and turn in

TOP

May 28

No School

MEMORIAL DAY

May 29 Day 73

Final Exam Review
Access review today

Start talking about final and last couple of weeks

May 30 Day 74

Google or Web 2.0
FInd a fun Google Gadget or Web 2.0 tools - make a blog post about what you found (include links) and why this might be useful.

May 31 Day 75

Final Exam Review
Excel review today, parts 1 - 9

June 1 Day 76

LAST DAY FOR MAKE UP WORK

Final Exam Review
Excel review today, parts 1 - 9

June 4 Day 77

Chrome Capture

• This is so cool!
• Google Chrome has an image capture tool!
• Follow these instructions
  • Open Google Chrome
  • Open your Excel Review in Google docs
  • Select the Screen Capture tool (see link above)
  • Capture the image of your spreadsheet
  • Save the image
  • Create a google drawing and upload your file
  • Add text explaining store cost is really store cost per item
    • See my example
  • Share you drawing with me

Final Exam Review
Excel review today, parts 10 - 12

June 5 Day 78

Finish Final Review

Talk about any issues

What will the final look like

June 7 Day 80

What do we still need to do to get ready for final?

Finals-1,2,3

June 11

Finals-4,5

June 12

Finals-7,8

June 13

No School - Grading

June 14

No School

June 15

No School