Business Computer Applications II

BCA II  Homepage  > Excel Unit 1

EXCEL UNIT 1

ALL DATES ON THE WEBSITE ARE TARGETS OR BENCHMARKS
AND MAY/WILL BE CHANGED.  

IF YOU FINISH BEFORE A GIVEN DATE, YOU ARE TO CONTINUE WORKING
 ON THE NEXT SET OF ASSIGNMENTS! 

Chapter 1  |  Chapter 2  |  Chapter 3  |  Web Feature | Chapter 4
 

Monday Tuesday Wednesday Thursday Friday
4/4
No School
 4/5
Chapter 1

Download Files -- instructions on inside of back cover

Chapter 1
4/6
Start Chapter 2

4/7
 Chapter 2

 4/8
 Chapter 2
4/11
Finish Chapter 2
Start Chapter 3
 4/12
Chapter 3
 4/13
Late Arrival
Chapter 3
 4/14
Chapter 3
 4/15
Finish
Chapter 3
4/18
 Web Feature
Start Chapter 4
 4/19
Bubble in Day!
Senior Assembly!

4/20
Chapter 4

 4/21
Chapter 4

 4/22
No School
Good Friday.
4/25
Chapter 4
 4/26
Chapter 4
 4/27
PSAE/ACT Day
 4/28
PSAE/ACT Day

4/29
Chapter 4
5/1
Drop Unit Files.
Turn in all Practice Tests.
Review for Test.
 5/2
Objecticve Test
Problem Test
      
  1. Review of BCA I Excel work.
  2. Create Spreadsheet
  3. Format Cells
  4. Cell Alignment
  5. Formulas: +, -, *, /, ^, ( )  Order of operation?
  6. Functions: SUM, AVERAGE, MAX, MIN, IF and PMT.
  7. Page Setup:  header/footer, gridlines, row and column headings, page orientation, fit to 1 X 1.
Chapter 1--Microsoft Office Excel 2007
                Creating a Worksheet and an Embedded Chart.

1-Complete Chapter 1 Practices.

2-Downloading your data files.

  1. Create a folder on your U:/Drive named BCA II Excel Data Files.
  2. Follow the instructions on the back inside cover of your textbook.
  3. Be sure to download and unzip the data files for all of the excel chapters. 
  4. Browse to your U:/ drive and select your new folder.
3-Practice Test:  Answer questions.  When you achieve at least an 80%, key in your first and last name and print the results.  You may repeat this for your own benefit.  Different questions will appear.

*Things you should know!*

  • Page layout, Landscape  (Changes orientation of page.)
  • File, Page Setup, Page, Fit to 1 X 1  (Makes spreadsheet Fit to 1 page.)
  • CTRL + ` to display formulas.
  • File, Print Preview (To avoid printing multiple times.)
Chapter 2--Microsoft Office Excel 2007
                 Formulas, Functions, Formatting and Web Queries.

1-Complete Chapter 2 Practices. 

2-Practice Test:  Answer questions.  When you achieve at least an 80%, key in your first and last name and print the results.  You may repeat this for your own benefit.  Different questions will appear.

3-In The Lab 1 (Facade Importers)
Pages EX 149--EX151

4-In The Lab 2 (Jackson's Bright Ideas)
Pages EX151-EX153

5 - In The Lab 3 (Equity Web Queries)
Pages Ex 154-155

Staple in order and turn in chapter 2 work printouts.

Chapter 3--Microsoft Office Excel 2007
                 What-If Analysis, Charting and Working with Large
                 Worksheets.

1-Complete Extend Your Knowledge pp. Ex 230-231

2-Complete Lab 1: Eight-Year Financial Projection

3-Complete Lab 3: Analysis of INdirect Expense Allocations

4-Practice Test:  Answer questions.  When you achieve at least an 80%, key in your first and last name and print the results.  You may repeat this for your own benefit.  Different questions will appear.

Staple in order and turn in chapter 3 work (?? Printouts!) in normal and formula view.

Web Feature--Microsoft Office Excel 2007
                 Creating Static and Dynamic Web Pages Using Excel.

1-Complete Web Feature Practices.

2-In The Lab 1

3-In the Lab 2

Drop a folder named loginname Excel Unit 1 Files.  Make sure all files from projects 1, 2, 3 and web feature are in the folder.

Chapter 4--Microsoft Office Excel 2007

Financial Functions, Data Tables, and Amortization Tables.

1-Complete Chapter Practices.

2-Compete Practice Test

3-Apply Your Knoweledge

4-Make It Right

5-In the Lab 1, 2 and 3