FSUS Home  
FSUS Picture

Location & Hours:
3000 School House Road
Tallahassee, FL 32311
M-F, 7:30-4:30
Bell Schedule
Location

Contact:
phone number Phone: 850.245.3700
fax number Fax: 850.245.3911
contact us at Personnel


Computing for College and Careers



Teacher: Mrs. Barr - Email address: vbarr@fsu.edu

Syllabus   Class Room Rules


This course covers computer literacy skills and foundations required for today's college and business environments and the students will obtain computer proficiency in an information based society. We will cover computer applications including an introduction to computer concepts, Microsoft Windows, Microsoft Office, Microsoft Word, Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Outlook, creating Web pages, and integration of the applications. We will explore different careers and visit FSU to understand college life and expectations.

Our Textbook


This textbook is specifically designed to engage learners, improve retention and prepare the user for success with a step-by-step, screen-by-screen that encourages the student to expand his or her understanding of the Microsoft Office 2007 software through experimentation, exploration and planning ahead.

Chapter 2
Microsoft Excel
Formulas, Functions, Formatting, and Web Queries


Chapter 2 Documents:


Excel Chapter 2 Objectives:
  1. Enter formulas using the keyboard and Point mode
  2. Apply the AVERAGE, MAX, and MIN function
  3. Verify a formula using Range Finder
  4. Apply a theme to a workbook
  5. Add conditional formatting to cells
  6. Change column width and row height
  7. Check the spelling of a worksheet
  8. set margins, headers and footers in Page Layout View
  9. Use a Web query to get real-time data from a Web sit
  10. Rename sheets in a workbook


In the Lab - workbook using guidelines, concepts, and skills from the chapter:

Problem: You have been asked to build a sales analysis worksheet for Facade Importers that determines the sales quota and percentage of quota met for the sales representatives. The desired worksheet will look like the one on the left.

Instructions:
  1. See the Facade Importers Sales Data Chart on page EX149
  2. Follow instructions on pages EX149-151 to create the report