Chapter 1 Assignments

Targets: The Introduction to Microsoft Word and various formatting skills

Main Targets:
  1. Using Fonts and Styles to enhance a document
  2. Using Images and Borders
  3. Using Color Sets
  4. Using Bullets and Lists
  5. Applying Justifications

Assignments for Word Unit A

Assignment # Assignment Name Page Number Link
1. Unit A Chapter Work Part 1 Pages WD-4 to WD32 No Link
2. Unit A Chapter Work Part 2 Pages WD-33 to WD-51 No Link
3. Unit A Apply Your Knowledge Pages WD-63 to WD-64 Click Here
4. Unit A In the Lab 1 Pages WD-67 to WD-68 No Link
5. Unit A In the Lab 2 (Summative) Pages WD-69 to WD-70 No Link
6. Unit A In the Lab 3(Summative) Pages WD-70 to WD-71 No Link

Final Summative

Create a Flyer

You can create any Flyer you want about school. You can choose:

  • Sports Activities
  • A club or organization
  • A class you are taking
  • Homecoming Week--
  • Or you can use the following: A Flyer Introducing the Open House
    1. You need to have the following information: The Date--September 2nd
    2. The Time--6:00 Start
    3. Use Fonts and Styles to enhance the document(under the design tab)
    4. Use Images and Borders
    5. Use Color Sets to enhance the document (under the design tab)

Chapter 2 Assignments

Targets: The creation of Research Reports and Formatting of Reports

Main Targets:
  1. Using Line Spacing
  2. Using Headers and Footers incl. Footnotes
  3. Creation of References and Work Cited Pages
  4. Using Spell Check
  5. Applying correct formatting to a Report

Assignments for Word Unit B

Assignment # Assignment Name Page Number Link
1. Unit B Chapter Work Part 1 Pages WD-78 to WD99 No Link Save as Wireless Communications
2. Unit B Chapter Work Part 2 Pages WD-100 to WD-126 No Link
3. Unit B Apply Your Knowledge Pages WD-133 to WD-134 Click Here
4. Unit B In the Lab 1—Computer Forensics(Summative)
    • When you type this report. there are 3 References; Computer Careers, Renman 52-58, and Turell 44-55. To create these 3 references, you will do the following: • Click the References Tab at the Top of the Microsoft Word Screen • Highlight the Words you want to create a citation with; For Example (Computer Careers) are the words you would select for the first reference • Click the Insert Citation button underneath the word References at the top of the Word Document • Click Add New Source in the list of items under Insert Citation • Now you will Choose the correct Type of Source: For this particular report there are 3 works citied to references: ****For The Computer Careers and the Gary Shelly Reference -- Choose Website in the drop down menu ****For the (Reinman 52-58) Reference -- Choose Article in Periodical in the drop down menu ****For the (Turell 44-55) Reference --Choose Book in the drop down menu • Fill in the information provided in the book • After filling out the information for the reference or work cited, then click OK in the bottom right • When you are finished typing in all 3 works cited or references then we do part 3 • Scroll to the bottom of the report and Double Space • Add the Works Cited Page by clicking References again • Then Find the Insert Bibliography button • Choose Works Cited, Word will automatically add the Works Cited to the bottom of the Report
Pages WD-138 to WD-139 No Link
5. Unit A In the Lab 2--AntiVirus (Summative) Pages WD-140 to WD-141 No Link

Chapter 3 Assignments

Targets: The creation of Resumes and other Business Documents

Main Targets:
  1. Using Word Templates
  2. Using Word Documents to create business documents
  3. Creation of Resumes and Letters of Application
  4. Using Spell Check
  5. Applying correct formatting to a Resume
  6. Printing and Saving Letters of Applications and Resumes
  7. Using Tables and Table Formatting in Word
  8. Applying Proper Formatting for Business Letters

Assignments for Word Unit C

Assignment # Assignment Name Page Number Link
1. Unit C Chapter Work Part 1

On Page 152 it asks for an Image, Click Here to get the image needed to complete the assignment.

Pages WD-150 to WD182 No Link Save
2. Unit C Chapter Work Part 2 Pages WD-183 to WD-202 No Link
3. Unit C Apply Your Knowledge Pages WD-205 to WD-206 Click Here
3. Unit C Extend Your Knowledge Pages WD-206 to WD-207 Click Here
4. Unit C In the Lab 1--Owens Letter
Pages WD-209 to WD-210 No Link
5. Unit A In the Lab 2--March Resume (Summative) Pages WD-210 to WD-211 No Link
6. Unit A In the Lab 3--Kim S. Ling Resume (Summative) Pages WD-212 No Link

Excel (A Spreadsheet Application)

Chapter 1 Assignments

Target: The Introduction of Excel and Basic Formatting and Formulas

Main Targets:
  1. Introduce Excel and the use of a Spreadsheet
  2. Formatting Cells, Rows, Columns and Titles
  3. Applying basic Formulas and using the copy function
  4. Creating simple spreadsheets with Labels and Values

Assignments for Excel Unit A

Assignment # Assignment Name Page Number Link
1. Unit A Chapter Work Part 1 Pages EX-17 to EX-32 No Link Save
2. Unit A Chapter Work Part 2 Pages EX-34 to EX-54 No Link
3. Unit A Apply Your Knowledge Pages EX-70 to EX-71 Click Here
4. Unit A In the Lab 1—Kona Coffee
Pages EX-74 to EX-75 No Link
5. Unit A In the Lab 2—Scissors Supply (Summative) Pages EX-75 to EX-77 No Link
6. Unit A In the Lab 3—College Exp with Charts(Summative) Pages EX-77 to EX-78 No Link

Excel (A Spreadsheet Application)

Excel Formula Examples

Main Targets:
  1. Introduce basic formulas
  2. Formatting Cells, Rows, Columns and Titles
  3. Applying basic Formulas and using the copy function
  4. Creating complex formulas using MIN, MAX, and AVERAGE
  5. Using various methods to create formulas

Assignments for Excel Unit B

SIDE NOTE----If you do not do the formulas you can only receive HALF Credit!!!
Assignment # Assignment Name Page Number Link
1. Unit B Chapter Work Part 1 Pages EX-86 to EX-105 No Link Save
2. Unit B Chapter Work Part 2 Pages EX-106 to EX-136 No Link
4. Unit B In the Lab 1--Car B Clean
Pages EX-145 to EX-146 Click Link
5. Unit B In the Lab 2--Façade Import (Summative) Pages EX-149- to EX-150 No Link
6. Unit B In the Lab 3--Jackson's Bright Ideas (Summative) Pages EX-152 to EX-153 No Link

Excel Chapter 3

Main Targets:
  1. Introduce basic formulas
  2. Formatting Cells, Rows, Columns and Titles
  3. Applying basic Formulas and using the copy function
  4. Creating complex formulas using MIN, MAX, and AVERAGE
  5. Using various methods to create formulas

Assignments for Excel Unit C

SIDE NOTE----If you do not do the formulas you can only receive HALF Credit!!!
Assignment # Assignment Name Page Number Link
1. Unit C Chapter Work Part 1 Pages EX-168 to EX-203 No Link Save
2. Unit C Chapter Work Part 2 Pages EX-204 to EX-217 No Link
3. Unit C In the Lab 1--Salioto Auto Parts (Summative) Pages EX-234 to EX-235 No Link
4. Unit C In the Lab 2--Britney's Music Pages EX-238 to EX-240 Click Here
5. Unit C In the Lab 3--RockieView (Summative) Pages EX-241 to EX-242 No Link

Vacation Assignment November

Vacation Assignment Instructions

What you need to turn into me by Thanksgiving

  1. You need to Create a Spreadsheet with 25 cities including the following information(Example of the Spreadsheet)

  2. Part 1--Find the Names of the 25 Cities around the world you might want to go for your 2 week Vacation
  3. Part 2-- After your find the cities; Find the Airfare From Portland (PDX) to the city your are going to. (Travelocity, or Orbitz, or Priceline). You should choose the month of February for the next year. Use the dates 1st to the 15th is when you will be flying, also you will always fly out of Portland, OR (Airport code: PDX)
  4. --->Example of The Back Up Document for Airfare. Backup Example for Airfare

  5. Part 3 --Find the Hotel Room. (14 nights, use Hotels.com or Travelocity, or hotwire....etc.). Dates are February 1st to the 15th.
  6. --->Example of The Back Up Document for Hotel Room. Backup Example for Hotels

  7. Part 4--Find Car Rentals(Use Avis or Budget or Hertz......) You might also have to look up taxi service in those cities that do not rent cars. Use Google as the source.
  8. Part 5-- Find the Cost of Meals(Examples of a Google Search for this). Here is a Great Website that Fatima Found for Costs for Meals Budget Your Trip Website
  9. Part 6--Find Entertainment-- Find at least 5 places you want to visit in each city and list it or add pics on the backup document.PLEASE make this number up based on Clothes Shopping, Tip Money, coffee, tickets, Presents, etc.....
  10. --->Example of The Back Up Document for Entertainment. Backup Example for Entertainment

  11. Part 7--Use the Sum Function to find the Totals for each city
  12. Due November 20th--90% After this date for Part 1. Then 80% in December and 70% in January.

Vacation Assignment Spreadsheet Examples

Below are examples of This Assignment

  • Vacation Assignment Part 2--Due December 4th Open for Directions for Part 2 of the Vacation Assignment
  • --->Example of Vacation Excel Spreadsheet with Part 2 Completed Click here (Courtesy of G.L.M)

  • Vacation Assignment Part 3--Due December 4thOpen for Directions for Part 3 of the Vacation Assignment

  • December 7th 2015

    Buying a Car

    Target(s): Researching a car and buying a car

    1. Find a Car: (Example)
    2. The Make: It is who created the car: Ford
    3. The Model: Name of car brand: Mustang
    4. Year: 2009
    5. Cylinders: (The number of Pistons/cylinders,,,) 6
    6. Body Style: Is it a Coupe, or 4 door, or SUV: Coupe
    7. Exterior Color: Silver
    8. Interior Color: Grey
    9. Doors: 2
    Then you will need to look up 3 different prices on the car using some of the websites out there. You can use Cars.com or AutoTrader.com.

    Access

    Assignment List

    Assignments and Dates

    How to Create a Database

    Assignments for Access

    Assignment # Assignment Name Link(s)
    1. Access Assignment 1— Create JSB Recruiters DataBase Pages AC24-33
    2. Access Assignment 2— Open JSB Pages AC36 – AC 58
    3. Access Assignment 3 -- Open JSB Pages AC78 – AC 96
    4. Access Assignment 4—Open JSB Pages AC105 – AC111
    5. Access Assignment 5—Open JSB Pages AC114 – AC123
    6. Access Assignment 6 – Open JSB Pages AC142 – AC164
    7. Access Assignment 7—Open JSB Pages AC180 – AC 181

    Assignments for Access Friends DataBase

    Assignment # Assignment Name
    1. Friends DataBase -- Part 1 Click on This Link A Friends Database and do the following
    • Click the Options link and Click Enable and OK
    • Click Save
    • Save on your Drive!!! (Your Drive) and Click Save
    • In the Friends Table add information for 25 of your friends
    2. Friends DataBase -- Part 2

    Monday & Tuesday Friends Database Query Assignment #1

    3. Friends DataBase -- Part 3

    Monday & Tuesday Friends Database Query Assignment #2

    Access State Database Assignment

    Instructions

    1. Open the States Database link below
    2. Click "Save as" and save it to your Documents
    3. Click Enable
    4. Fill in the Table with information from ALL 50 States

    A States Database

    The Information for the States assignment
  • Part 2 of States Database--Queries
  • Part 3 of States Database--Reports:
  • Part 4 of States Database--queries & other info:
  • Access Survey and Database Assignment

    Start This on Monday February 23rd

    A Survey Database Assignment

    Part 4 -- Do not forget to do the queries (Part 4)

    Part 4

    Create 5 queries based off your questions

      Examples:
    • • A query based on all the people who answered no on the yes or no question
    • • A query based on all the people who answered True on the True or False question
    • • A query based on all the people who answered C on the multiple choice

    A Survey Database Assignment--Part 5 Excel Graphs

    All Due..................

    PowerPoint Chapter Work

    PowerPoint Assignments March 3rd through March 20th

    • Assignment 1 – March 3rd – Pages PPT 5 to PPT 29 (The first pages 5 – 15 is just reading)
    • Assignment 2 - March 4th – Pages PPT 30 to PPT 53
    • Assignment 3 - March 5th or 6th – Pages PPT 69 to top of PPT 71 (In the Lab 1)
    • Part 2 March 5th or 6th – Pages PPT 71 to PPT 73 (In the Lab 2)
    • Part 3 March 5th or 6th – Pages PPT 74 to PPT 75 (In the Lab 3)
    • Assignment 4 - March 9th - Pages 86 - 96
    • Assignment 5 - March 10th & 11th – Pages PPT 97 to PPT 125
    • Assignment 5 - March 12th or 13th -- Pages PPT 137 to 139 (In the Lab 2)
    • Assignment 6 - March 12 or 13th -- Pages PPT 140 to 141 (In the Lab 3)
    • Assignment 7 - March 17th through March 21st -- Create a presentation based on on your vacation assignment
    • What do You Need to do
      1. Create a Presentation about 20 of the cities that you chose on your Vacation assignment
      2. The First Slide will be the Intro Slide and have this Title: "My Vacation PowerPoint" by (Your Name)
      3. Slides 2 through 21 will be the 20 places of your choice; including pictures, information about the city and interesting places to visit in the city.
        • Ideas:
        • Hotel to stay at in the city
        • History of the city
        • A place to visit in the city
        • When the city was founded or created
        • Places to eat
        • Interesting pictures of the city
        • Example Finals:
      4. Slide 22 will have links of where you found some of the information,,, not all the links,,, just like 4 or 5
      5. Slide 23 will be a "Thank you for watching..." kind of ending slide to conclude the presentation
      6. Make sure you add slide timings, some animations and transitions... if you do not know how to or forgot, please watch the videos: 1. How to set up Slide Timings 2.How to set up Slide Transitions.

    Starting April 11--PowerPoint Final

    1. Interesting Bands and Artists
    2. Disney
    3. Celebrities
    4. Baseball Players
    5. Nintendo
    6. Bands PPT
    The Grading Rubric is here for the Final Presentation Click here for the Grading Scale

    (It will be due April 28th)

    Final

    Newspaper Final for the rest of the year

    Newspaper Final

    Example of Newspaper

    Final

    Who wants to be a Millionaire

    The Final!!!