MAKING+FORMULAS+IN+SPREADSHEETS

Back to HOME > ICTIA > SPREADSHEETS

=FORMULAS IN SPREADSHEETS=

Your teacher will share with you a Google form asking various questions about the computer you are using.

Fill this in and submit the data. It is probably easier to use a sheet of paper first.

The teacher will then share a spreadsheet with all of the results.

To learn more about the data, we will be using formulas.

These are the questions for the data:
 * What is the ISL code of your computer (label on the bottom)
 * What is the mass in kg of your computer?
 * What are the length, width and height of the computer in cm?
 * How many keys are on each of the rows? (the big vertical keys you should only count once, probably in the row above)
 * What is the percentage of battery charge right now?
 * How many GB are free on the hard drive? (This is in the computer folder (see below)).

Here are the questions which we can solve using a formula:
 * What is the total mass of all of the computers?
 * What is the area of a computer lid in cm 2 ?
 * What is the volume in cm 3 of a computer?
 * What is the total number of keys?
 * What is the average percentage of the batteries?
 * What is the amount of GB used on the hard drive?