BCIS II

Home ]

First Semester

August  24  25  26  27  28  29  30  31

September  1 2  3  4  5  8  9  10  11  12  15  16  17  18  19 22  23  24  25  26  29  30

October    1  2  3  6  7  8  9  10  13  14  15  16  17  20  21  22  23  24  27  28  29  30  31

November    3  4  5  6  7  10  11  12  13  14  17  18  19  20  21  24  25  26  27  28

December  1  2  3  4  5  8  9  10  11  12  15  16  17  18  19 

January  5  6  7  8  9  12  13  14  15  16

 

Second Semester 

January  19  20  21  22  23  26  27  28  29  30

February  2  3  4  5  6  9  10  11  12  13  16  17  18  19  20  23  24  25  26  27

March  2  3  4  5  6  9  10  11  12  13  23  24  25  26  27  30  31

April    1  2  3  6  7  8  9  10  13  14  15  16  17  20  21  22  23  24  27  28  29  30

May    1  4  5  6  7  8  11  12  13  14  15  18  19  20  21  22  25  26  27  28  29

 

Classroom Assignments

January 14

Objectives:

  • Plan projects considering time and available resources

Assignment:

  1. Prepare a PowerPoint presentation from the information in your report.
  2. You have 2 class periods o complete this presentation
January 15

Objectives:

  • Meet deadlines

Assignment:

  1. Complete PowerPoint presentation
January 16

Objectives:

  • Exhibit correct telecommunications ethics and etiquette

Assignment:

  1. You are an employee of Business Technology Consultants (BTC).
  2. Check your email for further instructions.
  3. Find your notebook
    Use a colored sheet of paper as a divider and start a section for the unit introduction
January 17

Objectives:

  • Select operating systems, environments, and utilities appropriate to specific hardware and software;

Assignment:

  1. Check your email for additional information
  2. Start a section in your notebook for International Travel Services
January 18

Objectives:

  • identify a business problem, determine alternative solutions, and defend a recommendation

Assignment:

  1. check your email for message from Ronald
  2. Complete the job log and email it to chs.c103@gmail.com. Do not start working on the job until you have completed the Job Log
January 22

Objectives:

  • identify a business problem, determine alternative solutions, and defend a recommendation

Assignment:

  1. check your email for message from Ronald
  2. There were two times last week that you had instructions in your email to perform a specific task. These are graded activities. Be sure to read and follow instrunctions.
  3. Complete the job log and email it to chs.c103@gmail.com. Do not start working on the job until you have completed the Job Log

 

January 23

Objectives:

  • Review assignments for January 16-22

Assignment:

  1. Review procedures for this unit by working with Mrs. Douglas
  2. Examine the email with the unit introduction subject. The January 16 assignment was to read this information. If necessary, print this and file it in your notebook for review and reference. This document includes:
    Information about the company you work for - Business Technology Consultants
    Information about your position
    A listing of skills you will use
    A listing of resources you will use
    Explanation of procedures and documents you will see
    Suggestions for completing projects
    An example of a completed Job Planning Form
  3. Examine the email with the Job Planning Form subject. You received this email on January 17 with instructions to:
    create a BTC folder
    save the form in the new folder
    reply to the email
  4. Examine the email with the overview subject. This document describes the client company; International Travel Services. You may want to print this document and file it in your notebook. You received this email on January 17 with instructions to:
    read and define the highlighted words
    reply to the email
  5. Examine the email with the ITS letter subject. You received this letter on January 18 with instructions to read the attachment
  6. Examine the email with the project 1, job 1 subject received on January 22. You are instructed to:
    read the email
    examine the attached document
    complete a Student Log and Job Training Form
    reply with the completed Student Log and Job Training Form attached
    start work on the job
     
January 24

Objectives:

  • demonstrate characteristics for successful working relationships, for example, give and receive criticism, and exercise self-control.

Assignment:

  1. Check your email for feedback
  2. When you have completed the letter to Rhonda (Project 1, Job 1) attach the document to an email for Ronald at chs.c103@gmail.com. Ronald will review your work and reply with suggestions/corrections.
January 25

Objectives:

  • Select and apply appropriate technology as tools to address business needs

Assignment:

  1. Check your email for feedback
January 28

Objectives:

  • Identify a business problem, determine alternative solutions, and defend a recommendation.

Assignment:

  1. Check your email for your next job (Project 1, Job 2)
January 29

Objectives:

Assignment:

  1. Check your email for feedback

 

January 30

Objectives:

Assignment:

  1. Check your email for feedback

 

January 31

Objectives:

Assignment:

  1. Check your email for feedback

 

February 1

Objectives:

Assignment:

  1. Check your email for feedback
February 4

Objectives:

  • Review charting skills

Assignment:

  1. Work with Mrs. Douglas in class to copy table from word to excel
  2. Practice creating charts
February 5

Objectives:

  • Brush-up on Excel using multiple sheets

Assignment:

  1. Use the XP book
  2. Read pages 653-663 and complete the exercises on these pages
  3. At the end of class, email the last exercise you completed to chs.c103@gmail.com
February 6

Objectives:

Assignment:

  1. Check your email for feedback
February 7

Objectives:

Assignment:

  1. Working with tables demonstration
February 8

Objectives:

Assignment:

  1. Check your email for feedback
February 11

Objectives:

Assignment:

  1. Check your email for feedback
February 12

Objectives:

Assignment:

  1. Check your email for feedback
February 13

Objectives:

Assignment:

February 14

Objectives:

Assignment:

February 15

Objectives:

Assignment:

February 18

Objectives:

Assignment:

February 19

Objectives:

Assignment:

February 20

Objectives:

Assignment:

February 21

Objectives:

Assignment:

February 22

Objectives:

Assignment:

February 25

Objectives:

Assignment:

February 26

Objectives:

Assignment:

February 27

Objectives:

Assignment:

February 28

Objectives:

Assignment:

February 29

Objectives:

Assignment:

March 3

Objectives:

Assignment:

March 4    

Objectives:

Assignment:

March 5     TAKS testing

Objectives:

Assignment:

March 6

Objectives:

Assignment:

March 7

Objectives:

Assignment:

March 10

Objectives:

Assignment:

March 11

Objectives:

Assignment:

March 12

Objectives:

Assignment:

March 13

Objectives:

Assignment:

March 14

Objectives:

Assignment:

March 24

Objectives:

Assignment:

  1. Veterinarian's Office handout
March 25

Objectives:

Assignment:

  1. Veterinarian's Office handout
March 26

Objectives:

Assignment:

  1. Use the XP book
  2. create a folder on the T: drive
  3. copy Access lesson 1 files to the T: drive
  4. read the Access introduction on pages 995-1007
March 27

Objectives:

Assignment:

  1. Use the XP book
  2. Read and complete the exercises on pages 1007-1020
March 28

Objectives:

Assignment:

  1. Use the XP book
  2. Read and complete the exercises on pages 1020-1032
March 31

Objectives:

Assignment:

April 1

Objectives:

  • adding and deleting records in tables and queries

Assignment:

  1. Use the XP book
  2. Read and complete the exercises on pages 1038-1046
April 2

Objectives:

  • work with forms

Assignment:

  1. Use the XP book
  2. Read and complete the exercises on pages 1046-1065
April 3

Objectives:

  • edit tables

Assignment:

  1. Use the XP book
  2. complete exercise 2-20 on page 1074
  3. complete exercise 2-21 on page 1074-5
  4. complete exercise 2-22 on page 1075-6
April 4

Objectives:

Assignment:

April 7

Objectives:

Assignment:

April 8

Objectives:

Assignment:

April 9

Objectives:

Assignment:

April 10

Objectives:

Assignment:

April 11

Objectives:

Assignment:

April 14

Objectives:

Assignment:

April 15

Objectives:

  • Use Find and Replace in Access
  • Sort records

Assignment:

  1. Use the XP book
  2. Read and complete the exercises on pages 1078-1089
April 16

Objectives:

  • create filters in access

Assignment:

  1. Use the XP book
  2. Read and complete the exercises on pages 1089-1102
April 17

Objectives:

  • Create a query

Assignment:

  1. Use the XP book
  2. Read and complete the exercises on pages 1102-1109
  3. Complete exercise 3-22
  4. complete exercise 3-24
April 18

Objectives:

  • Build a query

Assignment:

  1. Use the XP book
  2. Complete exercise 3-25
April 21

Objectives:

  • prepare for quiz over filter and query

Assignment:

  1. Complete exercise 3-22
  2. complete exercise 3-24
  3. Complete exercise 3-25
April 22   bus evacuation drill

Objectives:

Assignment:

April 23

Objectives:

  • demonstrate skills with access tables and queries

Assignment:

  1. Complete the quiz following the instructions on the handout. You may use the XP book. Quiz must be complete by the end of the class period.
April 24

Objectives:

Assignment:

April 25

Objectives:

Assignment:

April 28

Objectives:

Assignment:

April 29     TAKS testing

Objectives:

Assignment:

April 30     TAKS testing

Objectives:

Assignment:

May 1     TAKS testing

Objectives:

Assignment:

May 2     TAKS testing

Objectives:

Assignment:

May 5

Objectives:

Assignment:

May 6

Objectives:

Assignment:

May 7

Objectives:

Assignment:

May 8

Objectives:

Assignment:

May 9

Objectives:

Assignment:

May 12

Objectives:

Assignment:

May 13

Objectives:

Assignment:

May 14

Objectives:

Assignment:

May 15

Objectives:

Assignment:

May 16

Objectives:

Assignment:

May 19

Objectives:

Assignment:

May 20

Objectives:

Assignment:

May 21

Objectives:

Assignment:

May 22

Objectives:

Assignment:

May 23

Objectives:

Assignment:

May 26

Objectives:

Assignment:

May 27

Objectives:

Assignment:

   
 
 
August 24

Objectives:

  • Introduction to the class.
  • Establish computer lab rules and procedures.

Assignment:

  1. Introduction.
  2. Distribute syllabus and computer lab procedures
  3. Discuss Computer Lab Procedures.
  4. Discuss syllabus
August 25

Objectives:

  • Understand why computers are connected.

Assignment:

  1. Login and access your file folder
  2. Discuss why computers are connected to each other
    share drives/folders
    share Internet connection
    share printers
  3. Vocabulary - Use the Internet to find definitions for this vocabulary. Record the information using the software of your choice. Save the information in your file folder. Record the address of sites you use.
    Network Interface Card
    Hub
    Switch
    Router
    Firewall
    TCP/IP
    Gateway
    IP address
August 26

Objectives:

  • Understand how computers are connected.

Assignment:

  1. Open the document you saved yesterday and review vocabulary.
  2. If you want to setup a wired network, what do you need? Using the software of your choice, prepare a list of supplies and equipment you need.
  3. Some helpful sites:
    http://www.microsoft.com/windowsxp/using/networking/setup/wired.mspx

    http://www.homenethelp.com/network/ethernet.asp||
    http://www.geekgirls.com/windowsxp_home_network.htm
August 27

Objectives:

  • Understand how to connect computers

Assignment:

  1. Open the documents you prepared during the last two class periods.
  2. Discuss:
    How you would setup a wired network in your home.
    How you would setup a wired network in an office that includes five people in three different rooms.
August 28

Objectives:

  • Select appropriate technology to address business tasks.
  • Complete tasks to meet a deadline.

Assignment:

  1. Discuss how a wireless network changes the network setups we considered last class.
  2. Use the software of your choice to present the information about the why and how of networks. The audience for your presentation is assigned by Mrs. Douglas. You have next class period to complete this task.
    Possible Audiences:
    A group of your peers who do not have computers at home
    A group of elementary school teachers who do not normally use computers in the classroom
    A group of adults who normally use computers
    A group of third graders
August 31

Objectives:

  • Prepare business document.
  • Prioritize to meet a deadline.

Assignment:

  1. Complete the presentation started last class period.
September 1

Objectives:

  • identify standards for multimedia presentations

Assignment:

  1. Work in groups by audience. One person is the 'big boss'. One person is the presenter. All other group members are colleague's of the presenter.
  2. The 'big boss' will go on a coffee break while everyone else views the group's presentations. Pick one presentation to review and improve.  You will present next class.
  3. The 'big boss', while on coffee break with the other 'big bosses' will prepare a list of criteria for evaluating the presentation.
September 2

Objectives:

  • Practice mature working relationships by evaluating colleague's presentation

Assignment:

  1. Open the file of vocabulary words you completed last week. Place your name in a header and print.
  2. Continue working on the presentation you started last class period.
September 3

Objectives:

  • Defend business choices.

Assignment:

  1. Present to the 'big boss'.
  2. Explain how your presentation meets the needs of the audience.
September 4

Objectives:

  • Identify the elements of a good presentation.

Assignment:

  1. Planning
    The Topic
    The Purpose
    The Audience
    Software choice
  2. Research
    accurate information|
    relevant information
    current information
  3. Organize
    Introduction
    Body
    Conclusion
  4. Storyboard
September 9

Objectives:

  • Examine skills tested on the Microsoft Office User certification for PowerPoint

Assignment:

  1. go to microsoft.com
  2. find the information about MOS certification and read the general information.
  3. Follow the links to the specific information about the PowerPoint certification.
  4. Pick up a red notebook, file the handouts, write your name on the first page.
  5. Examine the list of skills and check off the ones you possess.
September 10  exam next class

Objectives:

  • Review PowerPoint basic skills.

Assignment:

  1. Use the Office XP book.
  2. Read Pages 691-694 to familiarize yourself with the topic, purpose, and audience.
  3. Browse pages 696-723 paying special attention to areas on new information.
  4. Study the charts or tables on pages 699, 700, 701, 706, 709, 710, and 719. 
September 11

Objectives:

  • Demonstrate basic PowerPoint skills

Assignment:

  1. Written exam
  2. Computer exam - Exercise 1-23 on page 729
September 12  cut off for Progress Report

Objectives:

  • reinforce basic PowerPoint skills

Assignment:

  1. Finish exam.
  2. Exercise 1-22 on page 728-729.
  3. Complete exam study guide.
September 15

Objectives:

  • reinforce basic PowerPoint skills

Assignment:

  1. Continue working on the exam study guide. You can use the book.
  2. Follow this link http://www.emcp.com/college_resource_centers/index.php?GroupID=5963 and go to the Online Assessments at the Testing Center.
  3. Take the PowerPoint Pretest and take a practice quiz. When you miss a question take time to explore the correct answer in PowerPoint.
  4. Copy the scoring page to Word, add your name, print and turn in.
September 16

Objectives:

  • review and reinforce basic presentation tools

Assignment:

  1. Review the information on pages 732 through 759. Work the exercises as necessary to reinforce rusty skills or acquire new skills.
  2. Be sure you know how to select and edit text. (pages 736-738)
  3. Be sure you can use the spell checker and style checker.
  4. Complete exercise 2-23 0n pages 765-767.
September 17

Objectives:

  • Review creating a presentation

Assignment:

  1. Scan through lesson 3 on pages 770-797. Work the exercises as necessary to reinforce rusty skills or acquire new skills.
  2. Be sure you understand promoting and demoting text. (pages 777-779)
  3. Be sure you can insert slides from another presentation. (pages 776-777)
  4. Be sure you can create speaker's notes. (pages 792-794)
September 18  exam next class period

Objectives:

  • Create a presentation

Assignment:

  1. Complete exercise 3-24 on pages 804-806.
September 19

Objectives:

  • demonstrate use of basic presentation skills to create a presentation

Assignment:

  1. Written exam. Be sure to include your name.
  2. Computer exam - exercise 3-22 on page 801
September 22

Objectives:

  • Work with text in PowerPoint

Assignment:

  1. Review the information in lesson 5. (pages 842-873)
  2. Be sure you understand AutoFit (pages 849-851)
  3. Be sure you can customize bullets and numbers (pages 853-857)
  4. Practice inserting and using a PowerPoint tables (pages 858-863)
  5. Use the master slide to change formatting (pages 866-869)
September 23

Objectives:

  • Use higher level formatting skills in presentations

Assignment:

  1. exercise 5-27 on pages 878-879
  2. exercise 5-28 on pages 880-881
September 24

Objectives:

  • Use drawing tools in PowerPoint
  • Insert clip art into PowerPoint

Assignment:

  1. Read and complete the activities on pages 884-907.
September 25

Objectives:

  • Work with text boxes in PowerPoint
  • Create special effects with word art

Assignment:

  1. Read and complete the activities on pages 907-919
  2. exercise 6-29 on page 923. Print
  3. exercise 6-31 on pages 625-627
September 26

Objectives:

Assignment:

September 29

Objectives:

Assignment:

September 30

Objectives:

Assignment:

October 1  exam next class period

Objectives:

Assignment:

October 2

Objectives:

Assignment:

October 3  end 1st 6 weeks

Objectives:

Assignment:

October 6

Objectives:

Assignment:

  1. PowerPoint exam
October 7

Objectives:

  • create and modify lines, fills, and colors

Assignment:

  1. Work the activities on pages 929-952.
October 8

Objectives:

  • Demonstrate complex skill with lines, fills, and colors

Assignment:

Pick the exercise on pages 955-960 that sounds the most difficult for you. Complete the exercise. Use your care2 account to e-mail your presentation to the class e-mail address. In the e-mail explain why you chose the exercise.

October 9

Objectives:

  • Manipulate Objects in PowerPoint

Assignment:

  1. Look through lesson 8 (pages 962-984) and practice the skills presented. Try to be creative and use the features in new ways.
October 10

Objectives:

  • Demonstrate skills with objects

Assignment:

  1. exercise 8-20 on page 988
October 13  No school

Objectives:

Assignment:

  1. Prepare for the MOS certification exam
    OR
  2. Create a Game show presentation
October 14

Objectives:

Assignment:

  1. follow the instructions for creating an e-mail account at this site
  2. DO NOT provide personal information on the Internet. What is personal information?
    your name
    Your picture
    your address
    the school you attend
    names of anyone; yourself, your friends, your enemies, your family, your neighbors
    places you go
    activities you are involved in
  3. This email account is for school assignments only. Use this only to communicate with your teacher
  4. Discuss the proper form for business electronic communication
  5. practice sending e-mails with attachments to chs.c103@gmail.com by emailing the exercise you completed for lesson 7
  6. Email exercise 8-20
October 15  counts as a simulation grade

Objectives:

  • Use PowerPoint skills to create presentations

Assignment:

  1. follow the instructions on the handout
  2. Required output for ex 3-1:
    print in outline view
    saved design template
    saved presentation
    printed handout
    CD
  3. Required output for ex 3-2
    saved presentation
    printed handout
    printed notes page
    saved design template
    saved web page
October 16

Objectives:

Assignment:

  1. Complete the assignment from last class period
October 17

Objectives:

  • Review Excel Basic Skills

Assignment:

Excel placement
In the XP book
complete exercise 5-25 on page 530-531. E-mail to chs.c103@gmail.com
complete exercise 5-26 on page 531-532. E-mail to chs.c103@gmail.com

October 20

Objectives:

Assignment:

October 21

Objectives:

  • Excel functions

Assignment:

  1. Be sure to include the file name in the subject of your e-mail
  2. Check your e-mail for group number or assignment. You must submit 5-25 before being assigned a group number.
  3. Group 1
    In the XP book
    exercise 1-21 on page 390-391
    exercise 2-22 on page 424-425
  4. Group 2
    in the XP book
    read and complete the exercises on pages 427-451
  5. Group 3
    Review absolute reference
    review functions
  6. Group 4
    in the XP book
    exercise 6-18 on page 555-556
    exercise 6-19 on page 556-557
    exercise 6-20 on page 557
October 22

Objectives:

  • Working with Worksheets

Assignment:

  1. Group 1
    in the XP book
    Review pages 385-386
    exercise 1-18 on page 389
    exercise 1-19 on page 389
    exercise 1-20 on page 390
  2. Group 2
    in the XP book
    exercise 2-19 on page 422-3
    exercise 2-20 on page 423
    exercise 2-21 on pages 423-4
  3. group 3
    open absolute reference an complete the instructions
    in the XP book
    pages 533-546
    exercise 6-18 on page 555
  4. Group 4
    in the XP book
    exercise 6-21 on page 557-558
October 23

Objectives:

Assignment:

  1. group 1
  2. group 2
    check email for 2-21
    open format and formulas from the assignment folder and complete
  3. group 3
    check email for 5-26 - create a formula for Amount Due if every item is purchased
    in the XP book
    read and complete the exercises on pages 458-488
  4. group 4
October 24

Objectives:

Assignment:

  1. group 1
  2. group 2
    check email for formatting and formulas and correct the instructions in red
    exercise 4-28 on page 491-2
    exercise 4-30 on page 492-3
    exercise 4-31 on page 493
  3. group 3
    in the XP book
    read
    and complete the exercises on pages 533-552
    exercise 6-18 on page 555-6
    exercise 6-19 on page 556-7
    exercise 6-20 on page 557
  4. group 4
    in the XP book
    exercise 7-18 on page 580-1
    exercise 7-19 on page 581-2
    read and complete the exercises on pages 560-576
    exercise 8-26 on page 615-7
October 27

Objectives

  • Improve Excel skills

Assignment:

Group 1

  1. In the XP book
    exercise 1-21 on page 390-391
    exercise 2-22 on page 424-425
  2. in the XP book
    Review pages 385-386
    exercise 1-18 on page 389
    exercise 1-19 on page 389
    exercise 1-20 on page 390

Group 2

  1. Check your email for 4-28, correct the file and email it to chs.c103@gmail.com
  2. open the file working with ccr and s and complete the instructions.
  3. Use the Computer Projects Basics book
  4. Complete Project 47 on pages 224-226

Group 3

  1. Check your email for 6-18, correct the file and email it to chs.c103@gmail.com
  2. open the file function1 and follow the instructions on sheet 2
  3. email function1 to chs.c103@gmail.com
  4. exercise 6-21 on page 557-558

Group 4 

  1. Use the Microsoft Office Applications Advanced book
  2. Complete the tasks on pages Advanced Excel (AE) 46 - 55. Read the purple bar along the right side of the page for more information.

Group 5

  1. open the file working with ccr and s and complete the instructions
  2. Review the information about formulas on pages 496-504
  3. complete exercise 5-23 on pages 528-529

Group 6

  1. Explore Access
  2. Copy the student Access files for the XP book to drive T:.
  3. Unlock (remove the read-only in file properties) the files. You will have to save to drive T:
  4. work through pages 1000-1032 exploring tables and queries. Look for time saving short cuts.
October 28

Objectives:

  • Use formulas and functions

Assignment:

Group 1

  1. In the XP book
    exercise 1-21 on page 390-391
    exercise 2-22 on page 424-425
  2. in the XP book
    Review pages 385-386
    exercise 1-18 on page 389
    exercise 1-19 on page 389
    exercise 1-20 on page 390

Group 2 

  1. Check your email for working with ccr and s, correct the file and email it to chs.c103@gmail.com
  2. Email the Project 47 file you completed yesterday
  3. In the green book, complete tasks on pages IE 49 - 52. Read the information in the column along the right side of the page.
  4. In the green book, complete application 1 on page IE 53 

Group 3

  1. check your email for grading of the file formula1. Follow any instructions.
  2. Use the Microsoft Office Applications Advanced book. Two books on my desk. You will have to share.
  3. Complete the tasks on pages Advanced Excel (AE) 46 - 55. Read the purple bar along the right side of the page for more information.

Group 4

  1. Check your email, correct the file and email it to chs.c103@gmail.com
  2. Use the book Office XP Specialist. The book and a copy of the pages is on my desk
  3. Read and complete the filtering problems on pages 316-322

Group 5

  1. Check your email, correct the file and email it to chs.c103@gmail.com
  2. Review the information about statistical formulas on pages 504-516
  3. complete exercise 5-24 on pages 529-530

Group 6

  1. Continue work in Access
October 29

Objectives:

Assignment:

Group 1

  1. Use the XP book
  2. exercise 4-28 on page 491
  3. email 4-28 to chs.c103@gmail.com

Group 2

  1. Check your email for Project 47, correct the file and email it to chs.c103@gmail.com or follow instructions
  2. Email the census file you completed yesterday
  3. In the green book, complete Application 2 on page IE 54
  4. application 3 on page IE 55

Group 3

  1. email 6-21 to chs.c103@gmail.com
  2. In the XP book read and complete the activities on pages 560-565
  3. exercise 7-18 on page 580-581

Group 4

  1. In the XP book, complete exercise 10-36.
  2. Email this file to chs.c103@gmail.com

Group 5

  1. email exercise 5-24 that you completed yesterday to chs.c103@gmail.com
  2. In the green book, complete Application 2 on page IE 54
  3. application 3 on page IE 55

Group 6 

  1. Continue working on the Access lessons
October 30

Objectives:

Assignment:

Group 1

  1. check your email
  2. exercise 4-30 on pages 491-493
  3. email 4-30 to che.c103@gmail.com

Group 2

  1. check your email
  2. use the basics book
  3. complete Project 50 on pages 233-235
  4. email project 50 to chs.c103@gmail.com

Group 3

  1. check your email
  2. email 6-21 to chs.c103@gmail.com
  3. In the XP book read and complete the activities on pages 560-565
  4. exercise 7-18 on page 580-581

Group 4

  1. check your email
  2. In the XP book
  3. work through pages 653-669 about multiple sheets

Group 5

  1. check your email
  2. in the XP book
  3. complete exercise 5-27 on page 532. This is about using mixed references. The multiplication table in on page 519.
  4. email 5-27 to chs.c103@gmail.com

Group 6

  1. Continue working on the Access lessons
October 31

Objectives:

  • Pie for everyone  --  Working with Charts

Assignment:

  1. Open the file charts1 and follow the instructions
November 3

Objectives:

  • Which chart to use

Assignment:

  1. Explanation of chart types
  2. Practice charting information for specific purposes
November 4

Objectives:

  • making charts that work

Assignment:

  1. Open the file charts 2 and follow the instructions. Save in your file folder.
    See page 660 in the XP book for info on adding across sheets
November 5

Objectives:

  • catch up and cleanup

Assignment:

  1. check your email for feedback and assignments
November 6

Objectives:

  • functions that don't use math

Assignment:

  1. work together with Mrs. Douglas
  2. complete the activities
November 7

Objectives:

  • complete a business activity using your function knowledge

Assignment:

  1. complete the handout
November 10

Objectives:

Assignment:

  1. Practice using the following functions
    FIND
    LEN
    RIGHT
    LEFT
    CONCATENATE
November 11

Objectives:

  • use text functions to manipulate text in cells

Assignment:

  1. Treat the like an exam and do your own work
  2. open text functions worksheet from your folder. Complete and save
November 12

Objectives:

  • gather information and present it as a chart

Assignment:

  1. Treat the like an exam and do your own work
  2. In the XP book, complete exercise 8-29. Except - you can use any city.
November 13

Objectives:

  • generate financial reports

Assignment:

  1. Treat the like an exam and do your own work
  2. Complete the instructions on the handout provided
November 14

Objectives:

  • evaluate excel skills

Assignment:

  1. go to this link
  2. Visit the Testing Center
  3. Follow the Online Assessments link
  4. Take the Excel Posttest
  5. Follow the Reported Quiz link
  6. Enter your first name and last initial
  7. Enter chs.c103@gmail for the instructor email
  8. Complete the quiz. You may use the software.
November 17

Objectives:

  • Introduction to PhotoShop

Assignment:

  1. The screen
  2. new document dialog box
  3. color selection
  4. layers
  5. copy and paste
November 18

Objectives:

  • PhotoShop Selection Tools

Assignment:

  1. Marquis
  2. Lassos
  3. Magic Wand
  4. Magic Brush
November 19

Objectives:

Assignment:

November 20

Objectives:

Assignment:

November 21

Objectives:

Assignment:

November 24

Objectives:

  • PhotoShop adjustment tools

Assignment:

  1. open church.jpg
  2. Practice using these tools
    clone
    blur
    dodge
    burn
    smudge
  3. Open stars. Use the tools to remove the lettering so it looks like it was never there
November 25

Objectives:

  • Use selection and adjustment tools to combine pictures

Assignment:

  1. Open coral
  2. Use the 11 fish to populate your coral reef. Some fish will be behind or partially behind the coral
  3. save as coral reef
November 26

Objectives:

  • Use tools to refine documents

Assignment:

  1. Improve your coral reef
  2. Email coral reef to chs.c103@gmail.com
  3. Finish stars
November 27

Objectives:

  • Combining multiple images

Assignment:

  1. Email stars to chs.c103@gmail.com
  2. Using pictures you find on the Internet create a picture of a bouquet
November 28

Objectives:

  • Combining multiple images

Assignment:

  1. Continue the picture you started last class
December 1

Objectives:

  • Use lighting effects
  • Incorporate transparent layers
  • Use blur effects

Assignment:

  1. Complete the Create a Realistic Sunset tutorial at this site.
  2. Complete the Blur tutorial at this site.
  3. Practice using these effects on other photos
December 2

Objectives:

  • Use liquefy effect

Assignment:

  1. Try this tutorial that turns a tree into a human.
December 3

Objectives:

  • text effects

Assignment:

  1. Special text effects tutorial.
  2. Create a starry sky tutorial. Our version does not have all the features used. Use your knowledge of PhotoShop to create the finished picture.
December 4

Objectives:

  • special effects

Assignment:

  1. Try this cute shadow effect
December 5

Objectives:

  • Use Mrs. Douglas' favorite effect - spherize

Assignment:

  1. find your favorite effect or filter
December 8

Objectives:

  • Create realistic picture using at least 5 different sources

Assignment:

  1. Use Photoshop
  2. Pick a topic of your choice (school appropriate)
  3. Create a realistic picture combining elements from at least 5 different sources
  4. You must show your favorite effect or filter to the class by Friday
December 9

Objectives:

  • Create realistic picture using at least 5 different sources

Assignment:

  1. Use Photoshop
  2. Pick a topic of your choice (school appropriate)
  3. Create a realistic picture combining elements from at least 5 different sources
  4. You must show your favorite effect or filter to the class by Frida
December 10

Objectives:

  • Create realistic picture using at least 5 different sources

Assignment:

  1. Use Photoshop
  2. Pick a topic of your choice (school appropriate)
  3. Create a realistic picture combining elements from at least 5 different sources
  4. You must show your favorite effect or filter to the class by Frida
December 11

Objectives:

  • Create realistic picture using at least 5 different sources

Assignment:

  1. Use Photoshop
  2. Pick a topic of your choice (school appropriate)
  3. Create a realistic picture combining elements from at least 5 different sources
  4. You must show your favorite effect or filter to the class by Frida
December 12

Objectives:

  • Create realistic picture using at least 5 different sources

Assignment:

  1. Use Photoshop
  2. Pick a topic of your choice (school appropriate)
  3. Create a realistic picture combining elements from at least 5 different sources
  4. You must show your favorite effect or filter to the class by Frida
December 15

Objectives:

Assignment:

  1. Practice PhotoShop skills
December 16

Objectives:

Assignment:

  1. Practice PhotoShop skills
December 17

Objectives:

Assignment:

  1. Practice PhotoShop skills
December 18

Objectives:

  • demonstrate PhotoShop skills

Assignment:

  1. Complete the candy tutorial. This is a Word document located in your file folder.
  2. Save as a .jpg file and email to chs.c103@gmail.com
December 19

Objectives:

  • create business documents

Assignment:

  1. Use software of your choice
  2. create a Christmas card that includes the image you created yesterday.
  3. Print your Christmas card
January 5

Objectives:

  • Research information for a business project
  • Prepare a report

Assignment:

  1. Prepare a report about the Stock Market. Include the following information:
    What is the stock market?
    What is a stock?
    What is a stock symbol?
    What determines stock prices?
    How can you purchase stock
    What type of jobs are available working with stocks or the stock market?
    What type of training is required for these positions?
  2. In your report include:
    a cover page
    a short quotation
    a long quotation
    a table to organize information
    footnotes
  3. In your report do not include:
    plagiarized information
    erroneous information
  4. Business Report Format
    Top margin - 1 1/2"
    Side margin - 1"
    Bottom margin - 1" - 1 1/2"
    Body - Blocked on left margin, single spaced, double space between paragraphs
    Title - centered in all caps
    Subtitle - double spaced below title, followed by quadruple space
    Second and subsequent pages - 1" top margin, page number in upper right corner
    Short Quotations - in quotation marks
    Long Quotations - indented 1/2", single spaced, proceeded and followed by a blank line
    Side Heading - block on left margin, double space before and after, underline
    Paragraph Heading - first sentence in paragraph, underline, upper/lowercase
    Footnotes - superscript number, at bottom of page separated by 1 1/2"-2" horizontal line, double space before and after line, indent, single space
  5. A minimum three page report including information from the workbook you create next week is due January 15.
January 6

Objectives:

  • Research information for a business project
  • Prepare a report

Assignment:

  1. Continue work on your report
January 7

Objectives:

  • Research information for a business project
  • Prepare a report

Assignment:

  1. Continue work on your report
January 8

Objectives:

  • Research information
  • Prepare report of financial information

Assignment:

  1. At the open of the Market on January 2, 2008 you made the following purchases:
    200 shares of Intel
    225 shares of Merck
    150 shares of General Motors
    325 shares of ConocoPhillips
    100 shares of Dow Chemical
    175 shares of Amazon
    250 shares of Bank of America
    275 shares of Wal mart
    125 shares of Ebay
    300 shares of Archer Daniels Midland
  2. All shares were sold at the close of market on December 31, 2008.
  3. Prepare a spreadsheet to track your investment. Include:
    Initial investment (think carefully about what date to use)
    Sale proceeds
    Change
    Percent change
  4. Save as stock performance

http://stocks.tradingcharts.com/stocks/symbols/
http://bigcharts.marketwatch.com/historical

January 9

Objectives:

  • Use graphic display to present information

Assignment:

  1. Add charts to your workbook to demonstrate the investing results.
  2. Combine the workbook information in your report.
  3. Due at the end of class on January 13
January 12

Objectives:

  • Preparing projects on timely basis

Assignment:

  1. Continue work on your workbook and report.
January 13

Objectives:

  • Combine information from multiple sources to prepare business documents

Assignment:

  1. Print your report and turn it in before the end of class.
January 14

Objectives:

  • Demonstrate your skills with Word and Excel

Assignment:

January 15

Objectives:

  • Demonstrate your skills with Word and Excel

Assignment:

 

January 16

Objectives:

  • Demonstrate your skills with Word and Excel

Assignment: