Excel

profileevan11
SC_EX16_6a_JesusMojica_1.xlsx
Home>Information Systems homework help>Excel

Documentation

Shelly Cashman Excel 2016 | Module 6: SAM Project 1a
Fish Chips Electronics
CREATING, SORTING, AND QUERYING A TABLE
Author: Jesus Mojica
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.

SystemsTable

System ID System Name Processor Speed RAM Power Source USB Ports Bluetooth Wi-Fi Ready
1000 Fish Chip Classic 300 MHz 500 Mb 1.0 Amp 2 No No
2013 Fish Chip 2 600 MHz 1 GB 1.5 Amp 3 No No
3013 Fish Chip 2+ 600 MHz 2 GB 1.5 Amp 3 Yes No
3014 Fish Chip 2 Vinegar 900 MHz 2 GB 1.5 Amp 3 Yes Yes
4034 Fish Chip 3 Mod A 900 MHz 1 GB 2.0 Amp 3 No Yes
4035 Fish Chip 3 Mod B 1.2 MHz 2 GB 2.0 Amp 4 Yes Yes
4036 Fish Chip 3 Mod C 1.2 MHz 2 GB 2.5 Amp 4 Yes Yes
4037 Fish Chip 3 Mod C+ 1.5 MHz 2 GB 2.5 Amp 4 Yes Yes

Sensors

Sensor ID Sensor Name Fish Chip Classic Compatible Fish Chip 2 Compatible Fish Chip 3 Compatible Cost
S378 Light Sensor (Photo Transistor) No Yes Yes $1.25
S397 Microphone (Omnidirectional) No Yes Yes $2.00
S103 Roger Temperature Sensor Yes Yes Yes $5.50
S487 Adi Humidity Sensor Yes Yes No $5.50
S321 Luminosity Sensor No Yes No $6.00
S203 Humidity Sensor (wired) Yes Yes No $8.00
S357 Double-Axis Accelerometer Yes Yes Yes $8.50
S399 UV Index/IR/Visible Light Sensor (Digital) No No Yes $9.95
S345 Triple-Axis Accelerometer No Yes Yes $10.50
S304 Temperature-Humidity Sensor No No Yes $14.95
S402 Marcos Ultrasonic Rangefinder Yes Yes No $20.95
S400 Venti Muscle Sensor No Yes Yes $40.50
S414 Boraks Ultrasonic Rangefinder No Yes Yes $50.95
S401 Barcode Scanner No Yes Yes $65.95
Fish Chip 3 Compatible Sensors
Sensor ID Sensor Name Fish Chip Classic Compatible Fish Chip 2 Compatible Fish Chip 3 Compatible Cost
Yes
Sensor ID Sensor Name Fish Chip Classic Compatible Fish Chip 2 Compatible Fish Chip 3 Compatible Cost
S378 Light Sensor (Photo Transistor) No Yes Yes $1.25
S397 Microphone (Omnidirectional) No Yes Yes $2.00
S103 Roger Temperature Sensor Yes Yes Yes $5.50
S357 Double-Axis Accelerometer Yes Yes Yes $8.50
S399 UV Index/IR/Visible Light Sensor (Digital) No No Yes $9.95
S345 Triple-Axis Accelerometer No Yes Yes $10.50
S304 Temperature-Humidity Sensor No No Yes $14.95
S400 Venti Muscle Sensor No Yes Yes $40.50
S414 Boraks Ultrasonic Rangefinder No Yes Yes $50.95
S401 Barcode Scanner No Yes Yes $65.95

Displays

Display ID Display Name Size Type Fish Chip Classic Compatible Fish Chip 2 Compatible Fish Chip 3 Compatible Cost
D4431 1.3" OLED - Monochrome 1.3" OLED Yes Yes Yes $ 24.50
D1116 1.3" LED - Green on Black 0.96" LED Yes Yes Yes $ 5.50
D7500 1.3" Touchscreen 3.5" Touchscreen No Yes Yes $ 40.95
D4132 1.4" LED - Square - Backlit 1.4" LED Yes Yes Yes $ 10.95
D9124 1.4" LED - Blue on White 1.4" LED Yes Yes Yes $ 12.95
D9651 1.8" Touchscreen 1.8" Touchscreen No Yes Yes $ 20.95
D9770 1.4" LED - Backlit 1.4" LED Yes Yes Yes $ 10.95
D2305 1.4" LED - Square - Green on Black 1.4" LED Yes Yes Yes $ 8.95
D7554 10.1" HDMI (No Touchscreen) 10.1" HDMI No No Yes $ 150.00
D1809 7" HDMI (No Touchscreen) 7" HDMI No No Yes $ 45.50
D1519 7" HDMI + Touchscreen 7" HDMI - Touchscreen No No Yes $ 175.00

Cases Subtotal

Case ID System Compatibility Body Material Body Type Color Mounting Plate 2018 Inventory Cases Sold Cases Available
C9257 Fish Chip Classic Aluminum Unibody Standard No 50 28 22
C2496 Fish Chip Classic Plastic Unibody Clear No 25 17 8
C6235 Fish Chip Classic Plastic 2-Piece Blue No 25 13 12
C7656 Fish Chip Classic Plastic 2-Piece Translucent Green No 25 10 15
Fish Chip Classic Total 125 68 57
C3411 Fish Chip 2 Aluminum Unibody Standard No 75 37 38
C6617 Fish Chip 2 Plastic 2-Piece Smoke Grey Yes 100 36 64
C9894 Fish Chip 2 Plastic Unibody Blue Yes 50 28 22
C4329 Fish Chip 2 Plastic Unibody Green Yes 100 33 67
C9517 Fish Chip 2 Plastic 2-Piece Translucent Smoke Grey Yes 50 28 22
C6557 Fish Chip 2 Plastic Unibody Red Yes 100 53 47
C6247 Fish Chip 2 Plastic 2-Piece Translucent Orange No 50 15 35
Fish Chip 2 Total 525 230 295
C4587 Fish Chip 3 Aluminum Unibody Standard Yes 100 37 63
C9956 Fish Chip 3 Aluminum 2-Piece Standard No 50 31 19
C4241 Fish Chip 3 Aluminum Unibody Standard No 150 58 92
C6882 Fish Chip 3 Aluminum 2-Piece Standard Yes 150 94 56
C2914 Fish Chip 3 Plastic 2-Piece Rainbow Yes 50 37 13
C9494 Fish Chip 3 Plastic 2-Piece Translucent Green Yes 50 35 15
C7697 Fish Chip 3 Plastic Compact Clear Yes 150 106 44
C3765 Fish Chip 3 Plastic Unibody Pink Yes 50 32 18
C8726 Fish Chip 3 Plastic 2-Piece White Yes 100 37 63
C1289 Fish Chip 3 Plastic 2-Piece Translucent Black Yes 75 56 19
C3933 Fish Chip 3 Plastic Unibody Translucent Black Yes 50 36 14
C3418 Fish Chip 3 Plastic Compact Black Yes 200 81 119
Fish Chip 3 Total 1175 640 535
Grand Total 1825 938 887

Cases

Case Types 2018 Inventory Cases Sold Cases Available
Unibody 10 750 359 391
2-Piece 11 725 392 333
Compact 2 350 187 163
Case ID System Compatibility Body Material Body Type Color Mounting Plate 2018 Inventory Cases Sold Cases Available
C9257 Fish Chip Classic Aluminum Unibody Standard No 50 28 22
C6235 Fish Chip Classic Plastic 2-Piece Blue No 25 13 12
C7656 Fish Chip Classic Plastic 2-Piece Translucent Green No 25 10 15
C2496 Fish Chip Classic Plastic Unibody Clear No 25 17 8
C9956 Fish Chip 3 Aluminum 2-Piece Standard No 50 31 19
C6882 Fish Chip 3 Aluminum 2-Piece Standard Yes 150 94 56
C4587 Fish Chip 3 Aluminum Unibody Standard Yes 100 37 63
C4241 Fish Chip 3 Aluminum Unibody Standard No 150 58 92
C2914 Fish Chip 3 Plastic 2-Piece Rainbow Yes 50 37 13
C9494 Fish Chip 3 Plastic 2-Piece Translucent Green Yes 50 35 15
C8726 Fish Chip 3 Plastic 2-Piece White Yes 100 37 63
C1289 Fish Chip 3 Plastic 2-Piece Translucent Black Yes 75 56 19
C7697 Fish Chip 3 Plastic Compact Clear Yes 150 106 44
C3418 Fish Chip 3 Plastic Compact Black Yes 200 81 119
C3765 Fish Chip 3 Plastic Unibody Pink Yes 50 32 18
C3933 Fish Chip 3 Plastic Unibody Translucent Black Yes 50 36 14
C3411 Fish Chip 2 Aluminum Unibody Standard No 75 37 38
C6617 Fish Chip 2 Plastic 2-Piece Smoke Grey Yes 100 36 64
C9517 Fish Chip 2 Plastic 2-Piece Translucent Smoke Grey Yes 50 28 22
C6247 Fish Chip 2 Plastic 2-Piece Translucent Orange No 50 15 35
C9894 Fish Chip 2 Plastic Unibody Blue Yes 50 28 22
C4329 Fish Chip 2 Plastic Unibody Green Yes 100 33 67
C6557 Fish Chip 2 Plastic Unibody Red Yes 100 53 47
Total 1825 938 887

Packages

Package ID System ID Display ID Cost Package Details
P12018 4037 D2305 $ 72.90 Package ID P12687
P12084 4037 D1116 $ 69.45 System Name Fish Chip 3 Mod C System ID 4036
P12085 4037 D9770 $ 74.90 Display Name 1.3" LED - Green on Black Display ID D1116
P12113 4035 D2305 $ 66.45 Cost $66.00
P12167 4034 D4132 $ 65.90
P12292 4035 D4132 $ 68.45 System ID System Name Display ID Display Name
P12367 4036 D2305 $ 69.45 3014 Fish Chip 2 Vinegar D9770 1.4" LED - Backlit
P12381 4034 D2305 $ 63.90 4034 Fish Chip 3 Mod A D2305 1.4" LED - Square - Green on Black
P12382 4034 D9770 $ 65.90 4035 Fish Chip 3 Mod B D4132 1.4" LED - Square - Backlit
P12414 3014 D4132 $ 63.95 4036 Fish Chip 3 Mod C D9124 1.4" LED - Blue on White
P12574 4036 D9770 $ 71.45 4037 Fish Chip 3 Mod C+ D1116 1.3" LED - Green on Black
P12614 4037 D9124 $ 76.90
P12617 4035 D9124 $ 70.45 System Name System ID
P12618 4036 D4132 $ 71.45 Fish Chip 3 Mod C+ 4037
P12687 4036 D1116 $ 66.00 Number of Fish Chip 3 Mod C+ Packages 5
P12777 4035 D9770 $ 68.45 Average Cost of Fish Chip 3 Mod C+ Packages $ 73.81
P12823 4037 D4132 $ 74.90
P12879 4036 D9124 $ 73.45
P12913 4034 D1116 $ 60.45
P12959 4034 D9124 $ 67.90
P12970 4035 D9770 $ 68.45