Chapter 9: Sample Applications. Outline Spreadsheets Databases Numeric and Symbolic Computations Computer Networks. Social Issues. Applications. Software. Virtual Machine. Hardware. Algorithmic Foundations. Spreadsheets. An electronic spreadsheet combines elements of: a calculator
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Social Issues
Applications
Software
Virtual Machine
Hardware
Algorithmic Foundations
ABCDE
1 Item1Item2Total labels
2 3.255.759.00 numeric values
ABCDEFG
1IDNameAgeRateHoursPay
2101Janet K5116.6094
3 102Adam R188.50185
4 103Fred L4312.35250
5 104John A5317.80245
6 105Butch H176.7053
7
What you enter: (formulas entered)
ABCDEF
1IDNameAgeRateHoursPay
2 101Janet K5116.6094D2*E2
3 102Adam R188.50185 D3*E3
4 103Fred L4312.35250D4*E4
5 104John A5317.80245D5*E5
6 105Butch H176.7053D6*E6
What you see: (values computed)
ABCDEF
1IDNameAgeRateHoursPay
2 101Janet K5116.60941560.40
3 102Adam R188.501851572.50
4 103Fred L4312.352503087.50
5 104John A5317.802454361.00
6 105Butch H176.7053355.10
ABCDEFG
1IDNameAgeRateHoursPayNew Pay
2 101Janet K5116.60941560.401591.61
3 102Adam R188.501851572.501603.95
4 103Fred L4312.352503087.503149.25
5 104John A5317.802454361.004448.22
6 105Butch H176.7053355.10362.20
7
8Base Increase %2
9Totals$10936.50$11155.23
G: new column for increased pay
C8: stores the 2% value
F9 and G9: store the total pay
Field1 (e.g.ID) Field2 (e.g Name) Field3 (e.g. Age) Field4 (e.g. PayRate)
Record1
Record2
Record3
Record4
SELECTID, Name, Age, Payrate, Hours, Pay
FROM Employee
WHERE ID = 123;
SELECT Name, Pay
FROM Employee
WHERE Name = ‘John Kay’;
SELECT *
FROM Employee
ORDERED BY ID;
SELECT *
FROM Employee
WHERE Age > 21;
SELECT Employee.Name, Insurance.PanType
FROM Employee, Insurance
WHERE Employee.Name = ‘Fred James’ AND Employee.ID = Insurance.ID;
e.g. 13.57/1.8897 *sin(1.2*p) – cos(1.34*p)*10-4
1.31346
3.1415926535…52271201909
78865786479050…737472000…00000
12 – 12 x + 5 x2
(-1 + x) (1 + x) (1 – x + x2 - x3 + x4) (1 + x + x2 + x3 + x4)
1 + 4x + 6x2 + 4x3 + x4 + 12y + 36xy + 36x2y + 12x3y + 54y2 + 108xy2 + 54x2y2 + 108y3 + 108xy3 + 81y4
{{x 4} { x 1}}
{{x 0.405465}
{{x 3, y 5}}
{ }
6+ 3x2
1/5 x5 - 2x
1.0
Sum diverges