 |
|
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:
- Enter formulas using the keyboard and Point mode
- Apply the AVERAGE, MAX, and MIN function
- Verify a formula using Range Finder
- Apply a theme to a workbook
- Add conditional formatting to cells
- Change column width and row height
- Check the spelling of a worksheet
- set margins, headers and footers in Page Layout View
- Use a Web query to get real-time data from a Web sit
- 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:
- See the Facade Importers Sales Data Chart on page EX149
- Follow instructions on pages EX149-151 to create the report
|
 
|
 |
 |