Embedded Files
For this portion of the course we will be using google spreadsheets to manipulate data. To do this we first must become familiar with some basic terminology of spreadsheet setup.
Activity One
Define and provide a photo of each of the following terms:
• columnÂ
• rowÂ
• cellÂ
• cell addressÂ
• cell format
 • merging/splitting cellsÂ
• rangeÂ
• protectÂ
• hideÂ
• groupÂ
Following this website we will discuss how to use Google Sheets to present/manipulate data:
https://zapier.com/blog/google-sheets-tutorial/#quick
Activity Two
Using Google Sheets you must make a spreadsheet that demonstrates the following information:
For this assignment, you will create a spreadsheet for the "Baccalieu Hardware Store". On the first sheet of your spreadsheet, you will label it "Inventory".Â
You must list all the items the store carries, the quantity, and the cost in a manner that makes sense. Below is a list of all the materials the hardware shop carries.
ITEM
Light Bulbs (Case)
Quantity: 10
Price: $86.40
ITEM
Neon Open Sign
Quantity: 1
Price: $ 109.96
ITEM
Shelving Unit
Quantity: 5
Price: $162.95
ITEM
Floor Wax (Gallon)
Quantity: 2
Price: $37.00
ITEM
Office Chair
Quantity: 2
Price: $274.91
ITEM
Filing Cabinet
Quantity: 3
Price: $178.74
When this is completed you will create a sheet 2 and label it "Customer List". You will then list the information below in their own categories.
Name: McCarthy, Taylor
Business Type: Individual
Address: 24 Flagstaff Rd, St. John's
Number: (709) 576-5567
Date of last purchase: 21-Oct
Name: Banks, Wilfred
Business Type: Individual
Address: 108 Delta Crescent, Cornerbrook
(709) 444-8743
Date of last purchase: 4-Feb
Name: Hi-Fly Enterprises
Business Type: Business
Address: 2 Mackenzie Way, Gander
(709) 894-6672
Date of last purchase: 12-Feb
Name: Folstaff, Gavin
Business Type: Individual
Address: 56 Smith Ave, St. John's
(709) 576-1124
Date of last purchase: 13-Jan
Name: ETC Inc.
Business Type: Business
Address: 121 60th Street, St. John's
(709) 487-9903
Date of last purchase: 4-Dec
Name: North Central Pos.
Business Type: Business
Address: South Boulevard, Grand Bay East
(709) 554-5940
Date of last purchase: 12-Dec
Name: MacKenzie, Dylan
Business Type: Individual
Address: 2 Tulley Place, St. John's
(709) 576-3342
Date of last purchase: 16-Feb
Name: Sanchez, Maria
Business Type: Individual
Address: 45 Front Line, St. John's
(709) 576-4432
Date of last purchase: 30-Jan
Name: Goldstein Group
Business Type: Business
Address: 12 Newhook Lane, Avondale
(709) 556-3342
Date of last purchase: 12-Nov
Name: Ho, Lin
Business Type: Individual
Address: 28 McDonald Drive, Gambo
(709) 882-2231
Date of last purchase: 14-Nov
Name: Crystal Springs Corp.
Business Type: Business
Address: 66 Admiral's Ave, St. John's
(709) 576-0045
Date of last purchase: 4-Dec
Name: Goldsworthy, John
Business Type: Individual
Address: 45 Forest Rd, Grand Bank
(709) 435-7926
Date of last purchase: 4-Jan
Name: Druin, Peter
Business Type: Individual
Address: 40 East Paul's Street, St. John's
(709) 483-9953
Date of last purchase: 20-Feb
Name: Quest Solutions
Business Type: Business
Address: 12 Wilson Ave, St. John's
(709) 576-4444
Date of last purchase: 18-Nov
Name: Erwin Brothers
Business Type: Business
Address: 8 Farmer's Cove Rd, Mount Pearl
(709) 354-8858
Date of last purchase: 9-Feb
For privacy reasons, you must hide the cells that have the customer address and number listed
*IMPORTANT: When you post the Google sheet on your website ensure you have shared the sheet with me as well
The information should be formatted so it all fits and is visible
You can bold and outline the information if you choose
Ensure you have renamed your sheets
Name your GoogleSheet file "Baccalieu Hardware Store Inventory"
Please see the following example below:
Activity Three
When you have your Google sheet updated with the information above you will complete the following:
Part 1: Create a filter that will organize your contact list to Business and Individual contacts (make sure your filter does not change just this section or it may alter and impact the information)
Part 2:
Create a formula to calculate the total cost of each itemÂ
Create a formula to calculate the total cost of inventory
Activity Four
Make a copy of the google sheet posted below.
Follow the instructions as posted on the Google Sheets.
Post the updated sheet on your Google Site and make sure you have changed privacy information so I can access the file
https://docs.google.com/spreadsheets/d/1aK_fvFJfYgk9I4tUG82iznxwAIzqApqQ2SojesvnzxQ/edit?usp=sharing
Page updated
Report abuse