Portland Public Schools
Portland, Oregon

Franklin High School at Marshall Campus

Home of the Quakers

3905 SE 91st Ave | Portland, OR 97266
Phone: (503) 916-5140 | Fax: (503) 916-2694

Clara Cook

Advanced Accounting and Spreadsheets

Period 7

Syllabus

Automated Accounting

Automated accounting lessons not completed first semester, must be turned in before March18th to qualify for grade change.

Second Semester

Microsoft Excel - Lessons 1-22

Excel Packet of Projects

File needed for last project

PR D - 1.xlsx


Accounting 1-2

Period 3 and 4

Syllabus

Second Semester

TSA Portfolio Project - Medical Services Company

Financial Statements:  Worksheet, Income Statement and Balance Sheet

Open the financial statements file and save to your Y drive.

  • Complete the Worksheet, balance your trial balance before you complete the rest of your worksheet...(Your ledgers must be in balance)
  • Complete the income Statement, make sure you are carefully reading the notations...(Your Income statement balance should match your worksheet).
  • Complete the Balance sheet (pay attention where your numbers are coming from)
  • Print each financial statement, landscape format and scale to one page.
  • Hole punch each statement and properly place within your journal portfolio booklet
  • Complete all directions on your instruction sheet to complete the accounting cycle.

*****Calendar for on time completion*****

Medical Services Company Financial Statement Template


    Computer Applications

Periods 1, 5 and 6

    Syllabus

Computer App 2, Word 2010

Final Files

PR A-1.docx

EX Project 24.xlsx

Publisher File lesson 2

William.tif

New Classes.doc

Project 2-2

Flyer

Publisher.doc

Lesson 7

Lesson 7 Assignment Sheet

Diet 2.docx

References.docx

Sales.docx

Lesson 8

Lesson 8 assignment sheet

Checking.docx

Bank Customer.docx

Bank letter.docx

Subscription

Projects

Word Projects Assignment Sheet

Properties.docx

Tenses.docx

Menu.docx

Microsoft Excel

Lesson 1 Assignment Sheet

Project 1-1

Frog Census


Lesson 2 Assignment Sheet

Cassidy.xlsx

Central.xlsx

Project 2.1

Birds.xlsx

Shop.xlsx


Lesson 3 assignment sheet

Project 3.1

Chemistry.xlsx

Club.xlsx

Utilities.xlsx


Lesson 4 Assignment Sheet

Project 4.1

Formula.xlsx

Juice.xlsx

Zoo.xlsx


Lesson 5 Assignment Sheet

Functions.xlsx

Exam.xlsx

Reynolds.xlsx


Lesson 6 Assignment Sheet

Salary.xlsx

Titus.xlsx

Beautiful.xlsx

Tulips.jpg

Logo.docx

Tax.xlsx

Travel.xlsx


Lesson 7 Assignment Sheet

Crystal

Annual

March


Lesson 8 assignment sheet

Education.xlsx

Great.xlsx

Coronado.xlsx

Red.xlsx

Largest.xlsx

Concession.xlsx

Cash.xlsx

Study.xlsx


Excel Projects Assignment Sheet

Gas.xlsx

Organic.xlsx

Club.xlsx

Compnet.xlsx


Access Lessons

Lesson 1 Assignment sheet

Employees.accdb

Members.accdb

Restaurants.accdb

Lesson 2 Assignment sheet

No files needed, you will create your own.

Lesson 3 Assignment Sheet

Product.accdb

Agents.accdb

Lesson 4 Assignment Sheet

Broker.accdb

Recreation.accdb

Lesson 5 Assignment Sheet

Staff.accdb

Sales.accdb

Teacher.gif


Computer Applications 1, Word 2013

Unit A Assignment Sheet

WDA-1.docx

Unit B Assignment Sheet

WDB-1

WDB-2

Unit C Assignment Sheet

WDC-1

WDC-3

Unit D Assignment Sheet

WDD-1

WDD-2

FHS Career Pathway & Dual Credit Information