Rio Hondo Prep

Physical Science 7

Physical Science 9

Computer Applications

Geology

 

Google

 

 

 

 

Welcome to Computer Applications

If you turn in nothing else, make sure to do the Week 15 Assignment. It is worth 100 points!!!

Each week there will be assignments that are due by the end of the week. ALL ASSIGNMENTS FOR A WEEK ARE DUE BY THE LAST CLASS PERIOD FOR THAT WEEK. Late assignments are severely penalized.

Please DO NOT turn in next week's assignments ahead of time. Only turn in assignments for the current week.

When you complete most assignments, you will email it to me for grading. You can check your grade online.

At the end of most weeks there will be a short multiple choice quiz that you will take that is also worth 10 points. Please ONLY TAKE THE QUIZ ONCE! Only your first score will be accepted.

I encourage students to help each other on assignments, but DO NOT DO THE WORK FOR ANOTHER STUDENT or SHARE YOUR WORK (i.e. give your completed assignment to another student).

If you require help  - you can request help by emailing the instructor at phorton@rhprep.org and use the subject line RHP Help. The instructor will get back to you as soon as possible.

2020 Calendar

Week Starting Monday Week Number
Jan 6 1
Jan 13 2
Jan 20 3
Jan 27 4
Feb 3 5
Feb 10 6
Feb 18 7
Feb 24 8
Mar 2 9
Mar 9 10
Mar 16 11
Mar 23 12
Mar 30 13
Apr 6 14
Apr 20 15
Apr 27 Make-up Week
May 4 Make-up Week
May 11-15 Final

 

Week Number

Assignments
Week 1 1-1 Introduction to Computer Apps
1-2 Computer Apps Quiz
1-3 Web Email account - Sending Assignments
1-4 The Clipboard
1-5 Cloud Storage
1-6 Viewing File Extensions  
1-6A Worksheet for 1-6
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

 

2-1 Intro to Word for Windows

2-1A Worksheet

2-2 Selecting and Modifying Text

2-2A Sample Document for Assignment 2-2

2-2B Worksheet for Assignment 2-2

2-3 Text Aligning Options

2-4 Styles and the Undo Command

 
Week 2 Online Quiz
 
 
Week 3 3-1 Additional Options & Pull Down Menus
3-1A Sample Document
3-2 Paragraph Formatting
3-3 The Font Dialog
3-4 General Formatting
3-4A Sample Document
Week 3 Online Quiz
Week 4 4-1 Tabs vs. Tables
4-2 Tables I
4-3 Tables II
4-4 Designing Forms with Tables
Key for Week 4 (what your assignment should look like)
Week 4 Online Quiz
 

Week 5

 

5-1 Sections and Breaks
5-2 Sections and Breaks II
5-3 Sections and Fields
5-4 Headers and Footers
Key for Week 5 Assignment (what your assignment should look like)
Week 5 Online Quiz
Week 6 6-1 The Research Paper
6-2 Inserting Objects
6-3 Inserting Images
6-4 The Bibliography
Sample Week 6 Assignment (what your assignment should look like).
Week 6 Online Quiz
Week 7 7-1 Intro to Mail Merge
7-1A Data File
 
7-2 Mail Merge Continued
7-3 Mail Merge III
7-4 Mail Merge Finale
 
Week 7 Quiz
Week 8 8-1 Image Editing Basics
8-2 Shapes and SmartArt
8-3 Text Boxes
8-4 Making an Index
8-4 Sample Text
 
Week 8 Quiz
 
Week 9 9-1 Introduction to Templates
9-2 Templates II - The Resume`
9-2A Example of Resume`
9-3 Templates III - The Flyer
9-4 Templates IV - Calendars and Bookmarks
Week 9 Quiz
 
Week 10 10-1 Introduction to Excel
10-2 Simple Formulas and Formatting Data
10-3 Data Presentation and Simple Functions
10-4 Adding a Worksheet and ASCII Codes
Week 10 Quiz
 
Week 11 11-1 More Formulas and Internal Referencing
11-1A  Sample Data
11-2 Internal Referencing
11-3 Intro to Charting
11-4 Charting Skills and Sorting Data
Week 11 Quiz
Week 12 12-1 More Functions and Themes
12-1A Data File (for assignment 12-1)
12-2 The Pie Chart
12-3 Conditional Formatting
12-4 Using Excel Objects in Word
Week 12 Quiz
 
  Week 13 13-1 RWA - Calculating Rocket Fuel Consumption
13-2 RWA - Seismic Data Analysis
1999SD.xlsx - Data file for 13-2
13-3 Handling Large Files and Quick Analysis Tools
13-3A.xlsx (Sample Data File for 13-3)
13-4 Summary Tab and the COUNTIF function
Week 13 Quiz
Week 14 14-1 Intro to Powerpoint
14-2 Intro to PowerPoint II
14-3 PowerPoint Part III
The Sneeze Video
14-4 PowerPoint Part IV
 
Week 14 Quiz
Week 15 15-1 Final Prep I
     15-1A.pdf
     15-1B Photo.jpg
15-2 Final Prep II
     FlyingFish.jpg
     FlyingFrog.jpg
     FlyingSquirrel.jpg
15-3 Final Prep III
     15-3 Example
15-4 Final Prep IV
     15-4 Example.pdf
     15-4 Photo.jpg
Weeks 16-17 If you have turned in all of your assignments, you may use the period as a study hall. If you are missing any assignments, now is the time to turn them in.
Final

 

Final Link

This link should take you to a page with pictures of people wearing headphones. If not, hit the refresh button on your browser.

 

Test Out Information Test Out Links (Read instructions below!)

The test-out tests are administered over three days (Tuesday, Wednesday and Thursday). The first day is a basic knowledge quiz. Days 2 and 3 involve the creation of a Word and Excel document.

All work MUST BE DONE IN CLASS ONLY!!!

If you receive a 90% or higher grade in each section, you will receive an 'A' as your final grade for the course.

 

TUESDAY

You CANNOT get help from another student during this quiz, but you CAN search online (Google) or go to the applications (Word, Excel, etc) for answers if you need to. Just make sure you finish on time. Good luck!

 

Day 1 (Tuesday) Multiple Choice Test

 

(Type in your Full Name and email address at the top)

(Results will be emailed to you by tomorrow morning.)

WEDNESDAY

Day 2 Instructions (Wednesday)

Day 2 Document (Example file to reproduce)

Day 2 Graphics for assignment (cut and paste)

 

THURSDAY

Day 3 Instructions (Thursday)

Day 3 Document (Example with all five pages)

 

     
 
Mr. Phil Horton Contact Information
email: pjhorton21@gmail.com