Week 2

june 12

google sheets review

classwork

    • add conditional formatting to your grades assignment
    • gadgets invoice part 1 & 2 starting on page 188
      • Part 1 - no formatting for the photo - skip that part
      • part 2 step 4 just save as normal
        • instead of saving as a template which sheets cannot do you will go to file make a copy
        • rename the copy firstinitiallastname_yssupplies
      • do step 6 in part 2
    • ex 2 -Balance Sheet on page 205
      • stop after you save for part j
      • make sure you use formulas for total assets, total liabilities and total stockholder's equity
    • ex 8 - income statement on page 211
      • row 10, 17 and 18 are not merged, just filled with the paint bucket
      • makes sure you use formulas for total revenues, total expenses and net income/loss
    • ex 10 - budget on page 212
    • ex 13 (project 12 in the black book) - Mileage log, April Mileage log on page 215
      • step c subtract the start from the finish
      • step f - make a copy and rename it April Mileage log
      • steps g-j are done in april mileage log
    • ex 7 - personal finance on page 210
      • HINT: for step E you must be able to use the fill handle and remember just because a cell is empty doesn't mean it can't be in the formula
      • stop at step i.


Excel review - steaks.pdf

sheet review 1


june 11

crp peer REVIEW.pdf

crp peer evaluation

I will put you in pairs to help each other out with your career research papers.

after our CRP - we will start google sheets!

due by the end of class -

classwork file with the work from today

grades parts 1-3

any missing work - remember to upload it to a missing work folder on our shared drive and email me when done

june 10

word group test

due tomorrow before class:


word test to give to students.docx

download and open in word

save it to not book work folder

save often

word test finished.pdf

make it look like this


word group test directions.pdf

tips


Career Research Paper - google doc - 2019.pdf

career research paper


RESEARCH TABLE EXAMPLE.pdf

crp graduate example


MLA works Cited for Web Pages.pdf

works cited


june 9

typing.com

work on any chapter 4 exercises you hvae not yet completed. When done upload to our drive and type.

All remaining chapter 4 exercises are due by the start of class tomorrow.

word review_ansel to give to students.docx

download and open in word


jcollins_word review_ansel.pdf

make it look like this

use the tip pdf below for help


word review_ansel_tips.pdf

tips


june 8

typing.com

chapter 4

  • styles
  • TOC
  • tables

Work on volcanoes parts 1-3 - once finished upload to the google drive - make a new chapter 4 folder

then work on

  1. tutoring on page 140
  2. space transmissions on page 146
  3. ex. 2 - saturn on page 154
  4. ex 10 - backpacking list on page 157
  5. ex 17 Hawaiian Islands on page 161
    1. You will use Hawaiian Islands from chapter 3 but save as and put it in chapter 4 so you will have two files.

Volcanoes is due by the end of class.

Tutoring and space transmissions due by start of class tomorrow.


word review 2_unedited.docx

download and open in word


word review 2.pdf

make it look like this

change normal, heading 1, heading 2 to century gothic. Heading 1 and 2 are also red.