Computer Applicaitons I

 

 

 

 

Click Here To Skip Down To Current Assignments

To Excel the student files do the following:

1. Go to the Comp Apps Folder in your Network Drive Space

2. Navigate through the files until you locate the Lesson Files Folder

3. Go to the folder for the program you are using i.e., Excel, Excel, etc

4. Go to the folder for the unit you are working on

5. Open the file and follow instructions for saving as described in the book

DVDs are available for a guided walkthrough on how to do the Unit Lessons.

 

To Excel the test files:

1. Go to the Comp Apps Folder in your Network Drive Space

2. Double click the folder for the Program you are using (i.e., Word, Excel, etc.)

3. Go to the folder for the unit you are working on

4. Double Click the file you want

 

COURSE OUTLINE

Assignment Descriptions: 

Assignment Description Turn-In Method
Unit Lesson A project based step-by-step guide to the lessons objectives. Printed after all are completed
Concepts Review Includes screen identification, multiple choice, and matching questions. Online
Vocabulary Review of all vocabulary words, indicated by being blue bolded text, and and words from tables located throughout the lesson Online
Unit Test Review Review of major concepts from the lesson available from the start of the unit Online
Unit Test Available on the specified day and due at the end of the hour Online

 

Assignment Schedule:

 

MICROSOFT WORD: Word Processor

Unit D 
Due Dates:

 October 21 Unit Lesson
October 21 Concepts Review
October 22 Skills Review
October 23 Visual Workshop
October 27 Unit Practice Test
October 28 Unit Test
PACING CALENDAR
Start Date Topic Assignment
October  14 Microsoft Word Unit D: 
Setting Document Margins		 Unit Lesson
October 14 Microsoft Word Unit D: 
Dividing a Document into Sections		 Unit Lesson
October 14 Microsoft Word Unit D: 
Inserting Page Breaks		 Unit Lesson
October 19 Microsoft Word Unit D: 
Formatting Columns		 Unit Lesson
October 19 Microsoft Word Unit D: 
Inserting Page Numbers		 Unit Lesson
October 19 Microsoft Word Unit D: 
Adding Headers and Footers		 Unit Lesson
October 20 Microsoft Word Unit D: 
Editing Headers and Footers		 Unit Lesson
October 20 Microsoft Word Unit D: 
Inserting a Table		 Unit Lesson
October 20 Microsoft Word Unit D: 
Inserting Clip Art		 Unit Lesson
October 21 Microsoft Word Unit D: 
Unit Review		 Concepts Review
October 21 Microsoft Word Unit D: 
Unit Review		 Skills Review
October 22 Microsoft Word Unit D: 
Visual Workshop		 Visual Workshop
October 22 Microsoft Word Unit D:
Unit Practice Test		 Unit Practice Test
October 28 Microsoft Word Unit D:
Unit Test		 Unit Test

 

MICROSOFT Excel: Spreadsheets

Unit A
Due Dates:
 November 4 Unit Lesson
November 5 Concepts Review
November 6 Vocabulary
November 9 Unit Practice Test
November 10 Unit Test
PACING CALENDAR
Start Date Topic Assignment
November 2 Microsoft Excel Unit A: 
Understanding Spreadsheet Software		 Unit Lesson
(READ ONLY)
November 2 Microsoft Excel Unit A: 
Touring the Excel 2007 Window		 Unit Lesson
(Assignment Starts Here)
November 2 Microsoft Excel Unit A: 
Understanding Formulas		 Unit Lesson
November 2 Microsoft Excel Unit A: 
Entering Labels and Values and 
using AutoSum		 Unit Lesson
November 3 Microsoft Excel Unit A: 
Editing Cell Entries		 Unit Lesson
November 3 Microsoft Excel Unit A: 
Entering and Editing a Simple Formula		 Unit Lesson
November 3 Microsoft Excel Unit A: 
Switching Worksheet Views		 Unit Lesson
November 3 Microsoft Excel Unit A: 
Choosing Print Options		 Unit Lesson
November 4 Microsoft Excel Unit A: 
Unit Review		 Concepts Review
November 5 Microsoft Excel Unit A: 
Vocabulary Review		 Vocabulary
November 6 Microsoft Excel Unit A:
Unit Practice Test		 Unit Practice Test
November 10 Microsoft Excel Unit A:
Unit Test		 Unit Test
Unit B
Due Dates:
 November 30 Unit Lesson
December 1 Vocabulary
December 2 Concepts Review
December 3 Unit Practice Test
December 4 Unit Test
PACING CALENDAR
Start Date Topic Assignment
November 30 Microsoft Excel Unit B: 
Creating a Complex Formula		 Unit Lesson
November 30 Microsoft Excel Unit B: 
Inserting a Function		 Unit Lesson
December 1 Microsoft Excel Unit B: 
Typing a Function		 Unit Lesson
December 1 Microsoft Excel Unit B: 
Copying and Moving Cell Entries		 Unit Lesson
December 1 Microsoft Excel Unit B: 
Understanding Relative and Absolute Cell References		 Unit Lesson
READ ONLY
December 2 Microsoft Excel Unit B: 
Copying Formulas with Relative Cell References		 Unit Lesson
December 2 Microsoft Excel Unit B: 
Copying Formulas with Absolute Cell References		 Unit Lesson
December 2 Microsoft Excel Unit B: 
Round a Value with a Function		 Unit Lesson
December 4 Microsoft Excel Unit B: 
Vocabulary Review		 Vocabulary
December 8 Microsoft Excel Unit B: 
Unit Review		 Concepts Review
December 10 Microsoft Excel Unit B:
Unit Practice Test		 Unit Practice Test
December 16 Microsoft Excel Unit B:
Unit Test		 Unit Test
Unit C
Due Dates:
 January 8 Unit Lesson
January 11 Vocabulary
January 12 Concepts Review
January 13 Unit Practice Test
January 15 Unit Test
PACING CALENDAR
Start Date Topic Assignment
January 4 Microsoft Excel Unit C:           page 52
Formatting Values		 Unit Lesson
January 4 Microsoft Excel Unit C:            page 54
Changing Font and Font Sizes		 Unit Lesson
January 4 Microsoft Excel Unit C:            page 56
Changing Attributes and alignment		 Unit Lesson
January 5 Microsoft Excel Unit C:            page 58
Adjusting Column Width		 Unit Lesson
January 5 Microsoft Excel Unit C:            page 60
Inserting and Deleting Rows and Columns		 Unit Lesson
January 5 Microsoft Excel Unit C:            page 62
Applying Colors, Patterns, and Borders		 Unit Lesson
January 6 Microsoft Excel Unit C:            page 64
Applying conditional Formatting		 Unit Lesson
January 6 Microsoft Excel Unit C:            page 66
Name and Move a Sheet		 Unit Lesson
January 6 Microsoft Excel Unit C:            page 68
Check Spelling		 Unit Lesson
January 7 Microsoft Excel Unit C:
Vocabulary Review		 Vocabulary
January 11 Microsoft Excel Unit C:            page 70 
Concepts Review		 Concepts Review
January 11 Microsoft Excel Unit C:
Unit Practice Test		 Unit Practice Test
January 15 Microsoft Excel Unit C:
Unit Test		 Unit Test
Unit D
Due Dates:
 January 21 Unit Lesson
January 21 Concepts Review
January 23 Vocabulary
January 28 Unit Practice Test
January 29 Unit Test
PACING CALENDAR
Start Date Topic Assignment
January 19 Microsoft Excel Unit D:           page 80
Formatting Values		 Unit Lesson
READ ONLY
January 19 Microsoft Excel Unit  D:            page 82
Changing Font and Font Sizes		 Unit Lesson
January 19 Microsoft Excel Unit D:            page 84
Changing Attributes and alignment		 Unit Lesson
January 19 Microsoft Excel Unit D:            page 86
Adjusting Column Width		 Unit Lesson
January 20 Microsoft Excel Unit D:            page 88
Inserting and Deleting Rows and Columns		 Unit Lesson
January 20 Microsoft Excel Unit D:            page 90
Applying Colors, Patterns, and Borders		 Unit Lesson
January 20 Microsoft Excel Unit D:            page 92
Applying conditional Formatting		 Unit Lesson
January 20 Microsoft Excel Unit D:            page 94
Name and Move a Sheet		 Unit Lesson
January 21 Microsoft Excel Unit D:            page 96 
Concepts Review		 Concepts Review
January 22 Microsoft Excel Unit D:       page 80-95
Vocabulary Review		 Vocabulary
January 25 Microsoft Excel Unit D:       page 80-95
Unit Practice Test		 Unit Practice Test
January 26 Microsoft Excel Unit D:       page 80-95
Unit Practice Test		 Study for Test
January 27 Microsoft Excel Unit D:       page 80-95
Unit Practice Test		 Study for Test
January 28 Microsoft Excel Unit D:       page 80-95
Unit Practice Test		 Study for Test
January 29 Microsoft Excel Unit D:
Unit Test		 Unit Test

 

Integrating Word & Excel

Unit A
Due Dates:
 February 3 Unit Lesson
February 4 Concepts Review
February 5 Vocabulary
February 8 Unit Practice Test
February 10 Unit Test
PACING CALENDAR
Start Date Topic Assignment
February 2 Integrating Word & Excel          page 2
Integrating Data		 Unit Lesson
READ ONLY
February 2 Integrating Word & Excel          page 4
Copy Data		 Unit Lesson
February 2 Integrating Word & Excel          page 6
Copy a Chart		 Unit Lesson
February 2 Integrating Word & Excel          page 8
Create Linked Objects		 Unit Lesson
February 2 Integrating Word & Excel        page 10
Embed a Word File		 Unit Lesson
February 3 Integrating Word & Excel       page 12 
Concepts Review		 Concepts Review
February 4 Integrating Word & Excel    page 2-10
Vocabulary Review		 Vocabulary
February 5 Integrating Word & Excel    page 2-10
Unit Practice Test		 Unit Practice Test
February 10 Integrating Word & Excel
Unit Test		 Unit Test

 

Microsoft Access

Unit A
Due Dates:
 February 22 Unit Lesson
February 23 Concepts Review
February 24 Vocabulary
February 25 Unit Practice Test
February 26 Unit Test
PACING CALENDAR
Start Date Topic Assignment
February 16 Microsoft Access                          page 2
Understanding Relational Databases		 Unit Lesson
READ ONLY
February 16 Microsoft Access                          page 4
Opening a Database		 Unit Lesson
February 16 Microsoft Access                          page 6
Entering Data		 Unit Lesson
February 17 Microsoft Access                          page 8
Editing Data		 Unit Lesson
February 17 Microsoft Access                        page 10
Creating a Database		 Unit Lesson
February 18 Microsoft Access                        page 12
Creating a Table		 Unit Lesson
February 18 Microsoft Access                        page 14
Creating Primary Keys		 Unit Lesson
February 19 Microsoft Access                        page 16
Relating Two Tables		 Unit Lesson
February 19 Microsoft Access                        page 18
Printing a Database		 Unit Lesson
February 22 Microsoft Access                   page 20-21
Concepts Review		 Concepts Review
February 23 Microsoft Access                     page 2-19
Vocabulary Review		 Vocabulary
February 24 Microsoft Access                     page 2-19
Unit Practice Test		 Unit Practice Test
February 26 Microsoft Access
Unit Test		 Unit Test