Physical Science

Computer Applications

Geology

KYL Seminoles

 

Google

 

 

 

 

Computer Applications

 

Finals Week

Final on June 17. Use Monday's class and the Review period on the 16th to get any old assignments in. NO ASSIGNMENTS WILL BE ACCEPTED AFTER THE FINAL!!!

ABOUT THE FINAL

You will be duplicating a document that I provide to you (you will download it, print it out and then duplicate it as best you can). The document contains tables, graphics, an excel chart, callouts, text boxes and formulas. During the final, you can use any online help or old assignments to help you. The final is worth 300 points.

If you need help, email me at rhp@denovodental.com. Make sure to put the words RHP Help in the subject line of your message and I should get it right away. Include in your email the assignment number and the specific problem. If I'm at my desk, I should get back to you within 5 minutes or so.

Jump to Current Week's Assignments

Week Number (Date)

Assignments
Week 1

Jan. 26-30

 

 

1-0 Check for Adobe Acrobat Install
 
1-1 Your Gaggle email account/sending attachments
1-2 System Components and Windows OS
1-3 How PC's Work
1-4 Navigating Files and Folders
1-5 Cut, Copy and Paste
Week 1 Online Quiz 

** NOTE ABOUT QUIZZES ** - You can use notes, past assignments, or help from the computer during the Quiz. You may not get help from other people. Your score will be emailed to the instructor automatically. The first score will be used, so it does you no good to repeat the test.

Week 2

Feb. 2-6

2-1 Keyboard Shortcuts  2-1A Worksheet

2-2 Introduction to Word for Windows

2A Worksheet

2-3 Selecting & Modifying Text

2-3A Worksheet

2-4 Toolbars, Viewing and Zooming
2-5 Page Setup and Password Protection
 
Week 2 Online Quiz
 
Week 3

Feb. 10-13

(4 day week)

3-1 Intro to Tables
3-2 Tables Part Deux
Read Article on Table Basics (Use for quiz at end of week)
3-3 Designing Forms with Tables
3-4 Search & Replace Text
 
Week 3 Online Quiz
Week 4

Feb. 17-20

(4 day week)

 

4-1 Text Special Effects
4-2 Sections and Breaks
4-3 Formatting Plain Text
4-3a Text Doc mtwash.doc
4-4 Headers and Footers
See what your final document should look like by clicking here
4-5 Thesaurus, Drop Caps and Wizards
 
Week 4 Online Quiz
Week 5

Feb. 23-27

 

 

INTERNET SEARCHING STRATEGIES WEEK
5-1 Intro to Search Engines
5-1a Worksheet for 5-1
5-2 Search Engine Keywords
5-3 Search Engine Problems
5-4 Formulating a Search
 
 
Week 5 Online Quiz
Week 6

Mar. 2-6

6-1 Internet Search Instructions
6-1 Internet Search Quiz
6-2 Internet Search Quiz #2
6-3 Internet Shopping Instructions
6-3a Internet Shopping Form
6-4 Internet Mapping Instructions
6-4 Internet Mapping Quiz
 
6-6 Extra Credit Mensa Test (See how smart you are!)
Week 7

Mar. 16-20

 

** MID-TERM PREP BEGINS **
7-1 Designing Flyers and the Draw Toolbar
7-2 Using Web Graphics in Word
7-3 Callouts and Lines
7-3a Graphics for 7-3
7-4 Intro to Mail Merge
 
Week 7 Online Quiz
 
Week 8

Mar. 23-27

 

8-1 Mail Merge Part Deux
8-2 Editing Graphics and Watermarks
8-2a Clipart for assignment 8-2
8-3 Placing Graphics in Tables
8-3a Graphics for 8-3
8-4 Equation Editor
8-5 Mail Merge Review
 
Week 9

Mar. 30-Apr. 3

< MID-TERM INSTRUCTIONS>>

Download the three (3) documents below. Read the instructions carefully. Good luck!

    1) Mid-Term Instructions

    2) Mid-term Copy

    3) Rabbit Graphic for Mid-Term

** You may use any material (including online help, handouts and past assignments) to help you with the mid-term, but it is due at the end of class Friday**

 
9-1 Making a Calendar and Utilizing Bookmarks
9-2 Hyperlinks in Word
9-3 Simple Math Functions in Word
Week 9 Online Quiz
 
 
Week 10

Apr. 6-9

 

10-1 Intro to Excel
10-1a Worksheet for Assignment 10-1
10-2 Workbooks and Worksheets
10-3 Formulas and Copying Cells
Week 10 Online Quiz
 
Week 11

Apr. 20-24

11-1 Cell Referencing
11-2 Charting in Excel  
11-3 Intermediate Formulas and Formula Auditing
11-4 Linking Excel Objects in Word
 
Week 12

Apr. 27-May 1

 

12-1 Data Validation Part I
12-2 Data Validation Part II
12-3 Designing a Template
12-4 Importing and Sorting in Excel
Week 12 Online Quiz
 
  Week 13

May 4-8

13-1 Building a Worksheet
13-2 Real World Application - Space Travel
13-3 Real World Application - QB Efficiency Ratings
13-4 Real World Application - Finance Charges
 
Week 14

May 11-15

 
14-1 Excel Challenge #1
14-2 Excel Challenge 2
14-3 Conditional Formatting Revisited
14-4 Excel Challenge 3
Week 15

May 18-22

15-1 Background Check
15-2 Google 'X'treme - The Google Calculator
15-3 Google 'X'treme - Finding People
15-4 Google 'X'treme - Advanced Searching
15-Q Internet Advanced Search Quiz (Where the REAL points are earned)
Week 16

May 26-29

 

16-1 Research for Powerpoint Presentation
16-2 Intro to Powerpoint
16-3 Intro to Powerpoint II
 
 
Week 17

June 1-8

17-1 Introduction to Cloud Computing
17-2 Creating Spreadsheets
17-3 Importing Documents and Creating a Presentation
17-3a Download Word Document for 17-3
17-3b Pictures of Inflatable Houses for 17-3
17-Q Cloud Computing Quiz
 
Finals Week

June 17

Final Link

(Download and print - instructions are on the last two pages of the download). The pictures for the final are available in the link below.

1st Trimester Final Pictures

  << MID-TERM INSTRUCTIONS>>

Download the three (3) documents below. Read the instructions carefully. Good luck!

    1) Mid-Term Instructions

    2) Mid-term Copy

    3) Download Rabbit Graphic for Mid-Term

** You may use any material (including online help, handouts and past assignments) to help you with the mid-term, but it is due at the end of class Friday**

 

     
 
Mr. Phil Horton Contact Information
email: phil@denovodental.com - phone: (626) 222-7291