Assigned Homework 2 for LC2.  Due Week 2 Day 1.

Assigned Project for LC2.  Due Week 3 Day 1.

Name it ICT LC2.

Save all of your work to the Z:\.

• Record means to write the word in your notebook.
• Define means to write a one sentence definition of the word in your notebook.

Open the Data File named 4E Research Paper.

Open the Data File named 4F New Zealand Paper.

• Record means to write the word in your notebook.
• Define means to write a one sentence definition of the word in your notebook.

Open a NEW WORD DOCUMENT

(True/False, Multiple Choice, and Completion)

Project 3 Assessment.  Pages 181-182. 

Go to the Online Learning Center at http:\\www.concepts.glencoe.com. 

Choose Enrichment Activities, then Unit 4. 

Complete Enrichment Activity 4.6 

Create Footnotes and Endnotes

Choose Enrichment Activities, then Unit 4.

Complete Enrichment Activity 4.5

Manage Your Printer

Use Styles in Word

Create and Format Tables

Use Reviewing Tools for Working with Partners

Give your teacher your project printed in color.

Project 2 Assessment - Pages 164-165

215-217

Exercise 1-1:  Get to Know Microsoft Excel

Content Covered: Merge and Center, Print Area, Gridlines

[Quiz 2 is postponed to Week 4 Day 1 only for Section 10.05]

Be sure you have reviewed the Excel assignments for Week 3 Day 1 along with particular concentration on Figure 1.1 on page 216 that identifies the basic elements of Excel.  Additionally, you should know how to identify the ACTIVE CELL and ROW and COLUMN.

Unit 4 Worksheet 4D  Ethics Concepts

Unit 4 Worksheet 4E  Worksheet

Open:  Your Name Computer Price Comparison 1-4

Content Covered:  Arithmetic Operators, =, Formula Bar

Open:  Your Name Computer Price Comparison 2-1

Content Covered: 

SUM, AVERAGE, MAX, MIN, COUNT, AUTOSUM

Open:  Your Name Computer Price Comparison 2-2

Content Covered:  relative addressing

Open Your Email or Click, Save, and Open the File

Save your work on your Z:\ Drive in your ICT LC2 folder.

Do NOT email your results to your teacher.  This Pre-Quiz will help you to be more successful on your actual quizzes and tests.  There is NOT anything to send, print, or submit.

Choose Enrichment Activities

Choose Unit 5.

Choose and Complete Enrichment Activity 5.1

Mr. Braswell will check your Notebook for the Completion of Vocabulary Assignments for Week 1 Day 1 and Week 1 Day 2

Mr. Braswell will ask for you to submit several assignments as attachments to an email and to send this email to him.  This important email will have files that count as your participation marks.  This category of marks is worth 20% of your coursework grade.

Make sure your Section Number is in the Subject Line.

Attach or Insert the Following Nine Files from Your Z:\:

1.  Your Name Research Paper 3.6

2.  Your Name New Zealand Paper 3.7

3.  Your Name Newsletter 4.6

4.  Your Name Web Newsletter 4.7

5.  Your Name Digital Music 4.9

6.  Your Name Computer Price Comparison 1-4

7.  Your Name Computer Price Comparison 2-3

8.  Your Name Excel Practice

9.  Your Name Allowance 5.1

IMPORTANT NOTES

• Make sure that you have saved your files with the correct names. 
• If you have not saved your files with the correct names, RENAME your files. 
• Only attach or insert and send the requested files. 
• Do not send files that Mr. B. did not request.
• Naming the file correctly is part of your mark for the assignment.

• If you don't have "Your Name Excel Practice", go to Week 3 Day 2 to see the details.
• If you don't have "Your Name Allowance 5.1" go to Week 4 Day 1 to see the details.

Week 7 Day 1.

Open the email from Mr. B. with the Subject Line LC2 Word Review.

Instructions: 

1. Open the data file called 4G Everest Paper posted at http://sbraswell.com/work/iat/2008-2009/lc2/data_files.htm.
2. Complete the requirements shown in your email with the Subject Line LC2 Word Review.
3. Save your file to the Z:\ Drive as YOUR NAME ID WORD REVIEW

The exam is worth 30 marks.  It will be assessed based on fourteen elements. 

Instructions:

1.     Open the SOURCE FILE that is sent to you in your email for the Word Practical Exam.

2.     Save the file to your Z:\ Drive as YOUR NAME IAT ID.

3.     Complete the fourteen requirements shown on your sheet of instructions.

4.     Raise your hand when you are ready for your teacher to view your exam. 

5.     Your teacher will assist you with printing your exam.  Don’t print without permission.

6.     Staple your sheet of instructions as a cover page for your exam.

1. If you have not submitted your email from Week 6 Day 1 that contains the 9 requested lab files from your Z:\, send the email today for late grades.
2. If you have missing homework (20%) or have not submitted the project (30%), submit this work for late grades.
3. Quiz 3 covering questions from Excel will take place Week 7 Day 1.  Review the work you did for Week 4 Day 1.

• Sort Ascending and Descending (On the Data Menu)
• Filter (On the Data Menu)
• Charts (On the Insert Menu)
• Hide / Unhide Columns and Rows (On the Window Menu)

1. Open your Your Name Computer Price Comparison 2-3 worksheet.
2. Save your File with the New Name.
3. Complete 3-1:  Sort Data
4. Re-Save your File

1. Open the Data File names 5A Computer Systems
2. Save your File with the New Name
3. Complete 3-2:  Filter Data
4. Re-Save your File

1. Open your Your Name Computer Price Comparison 3.1 worksheet.
2. Save the File with the New Name
3. Complete Exercise 3-3:  Filter Data
4. Re-save your File

• If you have not finished your YOUR NAME ID WORD REVIEW assignment from Week 6 Day 2, complete this work.  Mr. B. can check this work at anytime.
• If you have not sent Mr. B. your email of 9 Files, you need to give him this work in order to earn your Participation marks.
• If you are missing Homework or Project or Participation assignments, you need to show this work to Mr. B. in order to earn your marks.  Late Work is always better than No Work!

Primary Instructions:

1. Open Your Name Computer Price Comparison 3.3
2. Save the File with the New Name
3. Complete the 12 Step-by-Step instructions for the Guided Practice on Pages 248-249
4. Re-save your File

Skills Used Today: 

• Hide/Unhide Option
• Sort Data
• Filter Data
• Chart Wizard

With a partner, plan the menu for a party with ten guests.  You have  200 AED to spend.

• RESEARCH:  Gather information about the costs of foods you would serve, such as pizza, sandwiches, drinks, etc.
• CREATE:  Each partner will create a separate menu in a worksheet:
  • Open and save a new worksheet as Your Name Party Budget.  You will use this worksheet later in this unit.
  • Enter the information you gathered.  Include a title.  Include the amounts of the items.  Use formulas to show the total cost and the amount of money remaining after you purchase all items.

Be prepared to print this HOMEWORK 5 file in class at the start of class for Week 8 Day 1.

• If you have not finished your YOUR NAME ID WORD REVIEW assignment from Week 6 Day 2, complete this work.  Mr. B. can check this work at anytime.
• If you have not sent Mr. B. your email of 9 Files, you need to give him this work in order to earn your Participation marks.
• If you are missing Homework or Project or Participation assignments, you need to show this work to Mr. B. in order to earn your marks.  Late Work is always better than No Work!

SEMESTER 1 EXAMS COVER LC1 AND LC2

Review, Study, and PRACTICE for your Computer Concepts Exam!