1. Spreadsheet
  2. Copy the supplied spreadsheet to another sheet. Name it MALS-Inc. Use the copy for all following instructions.
  3. Openthe tab containing vendor data

1.Add yourself to the vendor table (this will be called “your company”)

  1. Open the tab containing item data

1.Add an item from your own company

2.Give it a unique code from 1010-1020

  1. Open the tab containing customer data
  2. insert correct zip codes for the cities given
  3. Open the tab containing given sales data

1.Add records for your own item using existing customers

  1. Create the main profit/loss spreadsheet from the assignment instructions using any/all the tabs above

1.Create all necessary formulas

2.Format the sheet

  1. Explain the difficulties you would have in creating a billing for each customer for all his/her purchases from only this spreadsheet
  1. Database
  2. Create database item tables by importing the tabs of your spreadsheet
  3. Create the following queries

1.All items with vendor code “JE”

  1. Xx
  1. Create the following reports
  2. All sales grouped by customer then by item
  3. All items grouped by item, then by sales
  4. Create bills, using mail merge, to send to all the customers
  1. Word processing
  2. Create a “master” document containing 3 “chapters”:
  3. Chapter 1 is a 1 page introduction to your business
  4. Chapter 2 is a 1 page resume of your education, work experience, interests and hobbies
  5. Chapter 3 is a 1 page extension of your education containing 3 sections

a)A 3 column section (1 for each section of your resume). Add any content so the columns are of different lengths

b)A 1 column section describing some project you did

c)A 2 column section of anything you want to put there. Columns must be different lengths.

  1. Project management
  2. Create a project timeline (using ProjectLibre) based on this course, with the following tasks and # of lectures:
  3. Spreadsheets –4
  4. Database–4
  5. Word processing–2
  6. Project mgmt.– 2
  7. Websites & networking– 2
  8. HTML–3
  9. CSS - 3
  10. Websites & networking
  11. HTML
  12. CSS