Office

Textbook: Computer Literacy Basics ISBN: 1-4239-0431-1

Microsoft Office is the industry standard software productivity suite that includes Word (word processing), Excel (spreadsheets), PowerPoint (visual presentations), and Access (databases).

To Get Started:

  1. Take the Pre-Test in Angel.
  2. Download the Data Files: Office Data Files
  3. Read and work through all of the step-by-step tutorials in each chapter of the book.
  4. Complete ALL of the assignments / projects below.

How to submit assignments:

Upload your finished assignment to the class server using Filezilla (FTP), and submit a link to your work through the Dropbox in Angel (http://Angel.myptc.edu).

Video Training (Optional)

If you need some additional training, check out the following videos on Lynda.com:


Assignments

Chapter 1

  1. First you must have completed the Office 2007 pre-test
  2. Read and follow along with Lesson 1 in the textbook
  3. Complete the Hands-on-Reveiw on page 19, upload your finished assignment to the class server using Filezilla (FTP), submit this work in Angel.

Chapter 2

  1. Read and follow along with Lesson 2 in the textbook
  2. Complete the Hands-on-Review on page 36, upload your finished assignment to the class server using Filezilla (FTP), submit this work in Angel.

Chapter 3

  1. Read and follow along with Lesson 3 in the textbook
  2. Complete the Hands-on-Review on page 64, upload your finished assignment to the class server using Filezilla (FTP), submit this work in Angel.

Chapter 4

  1. Read and follow along with Lesson 4 in the textbook
  2. Complete the Hands-on-Review on page 82, upload your finished assignment to the class server using Filezilla (FTP), submit this work in Angel.

Chapter 5

  1. Read and follow along with Lesson 5 in the textbook
  2. Complete the Hands-on-Review on page 107, upload your finished assignment to the class server using Filezilla (FTP), submit this work in Angel.
  3. Take the test for Microsoft Word.

Project #1

Using Word, create a cover letter for a job you would like to have. Here are examples. Follow their formatting:

Then, duplicate the format of one of these resumes, substituting in all of your information and work history.

Use these action verbs to start your bullets in your resume.

Uupload your finished assignment to the class server using Filezilla (FTP), and submit a link to your work through Angel (http://Angel.myptc.edu).


Chapter 6

  1. Read and follow along with Lesson 6 in the textbook
  2. Complete Project 6-2 on page 133, upload your finished assignment to the class server using Filezilla (FTP), submit this work in Angel.

Chapter 7

  1. Read and follow along with Lesson 7 in the textbook
  2. Complete the Hands-on-Review on page 154, upload your finished assignment to the class server using Filezilla (FTP), submit this work in Angel.

Chapter 8

  1. Read and follow along with Lesson 8 in the textbook
  2. Complete the Hands-on-Review on page 176, upload your finished assignment to the class server using Filezilla (FTP), submit this work in Angel.
  3. Take the test covering Microsoft Excel.

Project #2

Using Excel, duplicate this Invoice. Replace the example logo with the name of your company so that you can use it to bill customers for your services. Upload your finished assignment to the class server using Filezilla (FTP), and submit a link to your work through Angel (http://angel.myptc.edu).


Chapter 9

  1. Read and follow along with Lesson 9 in the textbook
  2. Complete Project 9-2 on page 198, upload your finished assignment to the class server using Filezilla (FTP), submit this work in Angel.

Chapter 10

  1. Read and follow along with Lesson 10 in the textbook
  2. Complete the Hands-on-Review on page 223, upload your finished assignment to the class server using Filezilla (FTP), submit this work in AngelĀ http://Angel.myptc.edu .
  3. Take the Microsoft PowerPoint test.

Chapter 11

  1. Read and follow along with Lesson 11 in the textbook

Chapter 12

  1. Read and follow along with Lesson 12 in the textbook
  2. Complete the Hands-on-Review on page 259, upload your finished assignment to the class server using Filezilla (FTP).
  3. Take the Microsoft Access test.
  4. Take the Microsoft Office Final Exam Test

Project #3

Create a custom PowerPoint presentation for one of the following charities:

Your presentation must include the following:

  1. Explanation of Volunteer Opportunities
  2. Graphics
  3. Bullet points
  4. Slide transitions
  5. Noise/tones
  6. Use one of the templates
  7. Chart
  8. Media Clip
  9. Smart Art Objects
  10. Text

When you have complete the above, upload your finished assignment to the class server using Filezilla (FTP), and submit a link to your work through Angel (http://Angel.myptc.edu)