Office 2 Assignments

Remember -- these should be on My Documents and your C drive. Your Network drive(Z drive) is where I will grade them.

See Instructions

Application

Chapter

P, A, L

Check work against this reference

New Filename (Example - Your quarter, block, and name will be different)

Common

All

0

Common

 

See common assignments

Common

All

0

Objectives

 

ChapterNotes (Word - do with every chapter)

Objectives

All

0

Goals

 

Goals&Effort (Excel - do at end of every day)

To come

All

0

Final

 

Final

To come

All

0

Evaluation

 

Evaluation

 

 

 

 

Word

 

 

 

 

 

 

Word

4

Project

WD227

Charity Auction Title Page

 

Word

4

Project

WD227

Charity Auction Proposal

 

Word

4

Apply Knowledge

WD292

Awesome Antiques Modified

 

Word

4

Lab 1

WD297

Clean Fleet Auto Proposal

 

Word

5

Project

WD307

Total Fitness (any time you are told to print, SAVE AND ADD MERGED TO FILE NAME)

 

Word

5

Project

WD307

Health Club Member Directory, Directory Merged
Mailing Labels, Labels Merged, Envelopes, Envelopes Merged

 

Word

5

Apply Knowledge

WD371

Green Grove Merged Form Letters

 

Word

5

Lab 1

WD376

Diamond Eye Care, Directory, Mailing Labels and all merged

 

Word

6

Project

WD387

Health Bits Newsletter

 

Word

6

Project

WD387

Hand and Eye Chart Modified

 

Word

6

Apply Knowledge

WD453

Totally Toned Newsletter Modified

 

Word

6

Lab 1

WD457

History Museum Newsletter

Personal Assignments

Word

PA

 

 

Word Personal Assignments

 

 

 

 

 

 

Excel

 

 

 

 

Excel

4

Project

EX267

Braden Mortgage Loan Calculator

Excel

4

Apply Knowledge

EX324

Monthly Loan Payment

Excel

4

Lab 1

EX328

Retirement Planning Sheet

Excel

5

Project

EX339

Silver Photography Accessories Sales Rep Table

Excel

5

Project

EX339

Silver Photography Accessories Sales Rep Table CSV

Excel

5

Apply Knowledge

EX400 

Fritzs Luxury Kennel Guest List

Excel

5

Lab 1

EX405

Whitman Publishing Sales Rep Table

Excel

6

Project

EX419

NextDVR Profit Potential

 

Excel

6

Project

EX419

NextDVR Kansas City Profit Potential

 

Excel

6

Project

EX419

NextDVR Louisville Profit Potential

 

Excel

6

Project

EX419

NextDVR Portland Profit Potential

 

Excel

6

Project

EX419

NextDVR Workspace.xlw

Excel

6

Project

EX419 

NextDVR Profit Potential Template.xltx

Excel

6

Apply Knowledge

EX493 

Annual Payroll Totals

Excel

6

Lab 1

EX497 

Rings and Things Annual Sales Analysis Part 1

 

Excel

6

Lab 1

EX497 

Rings and Things Annual Sales Analysis Part 2

 

 

 

 

 

 

Personal Assignments

Excel

PA

 

 

ExcelPersonalAssignment

 

 

 

Access  - In Access there will only be three files with each part of the program saved in the file. Each item in () below is a separate save but not a separate file.

 

Access

1

Project

 

JSP Recruiters (Client Table)

Access

1

Project

 

JSP Recruiters (Client Form)

Access

1

Project

 

JSP Recruiters (Client Address Form)

 

Access

1

Project

 

JSP Recruiters (Client Financial Report)

 

Access

1

Project

 

JSP Recruiters (Recruiter Table)

 

Access

1

Project

 

JSP Recruiters (Recruiter Address Report)

Access

1

Project

 

JSP Recruiters (Recruiter Financial Report)

 

Access

1

Apply Knowledge

 

The Bike Delivers (Customer Table)

Access

1

Apply Knowledge

 

The Bike Delivers (Balance Due Report)

 

Access

1

Apply Knowledge

 

The Bike Delivers (Courier)

Access

1

Apply Knowledge

 

The Bike Delivers (Courier Table)

Access

1

Lab 1

 

JMS Techwizards (Client Table)

Access

1

Lab 1

 

JMS Techwizards (Client)

 

Access

1

Lab 1

 

JMS Techwizards (Technician Table)

 

Access

1

Lab 1

 

JMS Techwizards (Salary Report)

Access

1

Lab 1

 

JMS Techwizards (Billing Summary Report)

Access

2

Project

 

JSP Recruiters (Client Table)

Access

2

Project

 

JSP Recruiters (Client Recruiter Crosstab)

Access

2

Project

 

JSP Recruiters (Client Query)

Access

2

Project

 

JSP Recruiters (Client-City Query)

 

Access

2

Project

 

JSP Recruiters (Recruiter-Client Query)

 

Access

2

Project

 

JSP Recruiters (Client Form)

 

Access

2

Project

 

JSP Recruiters (Client Address Report)

 

Access

2

Project

 

JSP Recruiters (Client Financial Report)

 

Access

2

Project

 

JSP Recruiters (Recruiter-Client Report)

 

Access

2

Project

 

JSP Recruiters (Recruiter Table)

 

Access

2

Project

 

JSP Recruiters (Recruiter-Client Query)

 

Access

2

Project

 

JSP Recruiters (Recruiter Address Report)

 

Access

2

Project

 

JSP Recruiters (Recruiter Financial Report)

 

Access

2

Project

 

JSP Recruiters (Recruiter-Client Report)

Access

2

Apply Knowledge

 

The Bike Delivers (Customer Table)

Access

2

Apply Knowledge

 

The Bike Delivers (Courier Parameter Query)

Access

2

Apply Knowledge

 

The Bike Delivers (Courier-Customer Query)

Access

2

Apply Knowledge

 

The Bike Delivers (Customer Query)

Access

2

Apply Knowledge

 

The Bike Delivers (Balance Due Report)

Access

2

Apply Knowledge

 

The Bike Delivers (Courier-Customer Report)

Access

2

Apply Knowledge

 

The Bike Delivers (Courier Table)

Access

2

Apply Knowledge

 

The Bike Delivers (Courier-Customer Query)

Access

2

Apply Knowledge

 

The Bike Delivers (Courier)

Access

2

Apply Knowledge

 

The Bike Delivers (Courier-Customer Report)

Access

2

Lab 1

 

JMS Techwizards (Client Table)

Access

2

Lab 1

 

JMS Techwizards (City-Technician Crosstab)

 

Access

2

Lab 1

 

JMS Techwizards (Client-City Query)

 

Access

2

Lab 1

 

JMS Techwizards (Technician Client Query)

 

Access

2

Lab 1

 

JMS Techwizards (Client)

 

Access

2

Lab 1

 

JMS Techwizards (Billing Summary Report)

 

Access

2

Lab 1

 

JMS Techwizards (Technician Table)

 

Access

2

Lab 1

 

JMS Techwizards (Salary Report)

Access

2

Lab 1

 

JMS Techwizards (Technician Client Query)

Access

3

Project

 

JSP Recruiters (Client Table)

 

Access

3

Project

 

JSP Recruiters (City-Recruiter Crosstab)

 

Access

3

Project

 

JSP Recruiters (Client Query)

 

Access

3

Project

 

JSP Recruiters (Client-City Query)

 

Access

3

Project

 

JSP Recruiters (Recruiter-Client Query)

 

Access

3

Project

 

JSP Recruiters (Client Form)

 

Access

3

Project

 

JSP Recruiters (Client Address Report)

 

Access

3

Project

 

JSP Recruiters (Client Financial Report)

 

Access

3

Project

 

JSP Recruiters (Recruiter-Client Report)

 

Access

3

Project

 

JSP Recruiters (Recruiter Table)

 

Access

3

Project

 

JSP Recruiters (Recruiter-Client Query)

 

Access

3

Project

 

JSP Recruiters (Recruiter Address Report)

 

Access

3

Project

 

JSP Recruiters (Recruiter Financial Report)

 

Access

3

Project

 

JSP Recruiters (Recruiter-Client Report)

Access

3

Apply Knowledge

 

The Bike Delivers (Customer Table)

Access

3

Apply Knowledge

 

The Bike Delivers (Courier Parameter Query)

Access

3

Apply Knowledge

 

The Bike Delivers (Courier-Customer Query)

 

Access

3

Apply Knowledge

 

The Bike Delivers (Customer Query)

 

Access

3

Apply Knowledge

 

The Bike Delivers (Customer Simple Form)

 

Access

3

Apply Knowledge

 

The Bike Delivers (Balance Due Report)

 

Access

3

Apply Knowledge

 

The Bike Delivers (Courier-Customer Report)

 

Access

3

Apply Knowledge

 

The Bike Delivers (Courier Table)

 

Access

3

Apply Knowledge

 

The Bike Delivers (Courier-Customer Query)

 

Access

3

Apply Knowledge

 

The Bike Delivers (Courier)

 

Access

3

Apply Knowledge

 

The Bike Delivers (Courier-Customer Report)

Access

3

Lab 1

 

JMS Techwizards (Client Table)

Access

3

Lab 1

 

JMS Techwizards (City-Technician Crosstab)

Access

3

Lab 1

 

JMS Techwizards (Client-City Query)

Access

3

Lab 1

 

JMS Techwizards (Technician-Client Query)

Access

3

Lab 1

 

JMS Techwizards (Client Type Update Query)

Access

3

Lab 1

 

JMS Techwizards (Client)

Access

3

Lab 1

 

JMS Techwizards (Billing Summary Report)

Access

3

Lab 1

 

JMS Techwizards (Technician Table)

Access

3

Lab 1

 

JMS Techwizards (Technician-Client Query)

Access

3

Lab 1

 

JMS Techwizards (Salary Report)

Personal Assignments

Access

PA

 

 

AccessPersonalAssignment