Spreadsheet
Calculation and data processing is the first and foremost reason of computer development. Even though computer function has expanded through decades, calculation is always at the heart of it. As a daily and future computer user, students are learning spreadsheet in order to equip themselves against the digitized future.
Unit 2
Learning Materials
Profit and Sales
Students are given certain formula to find Profit and Sales.
They need to write those formula in Excel.
Mean, Median, Mode
Average, median and most occuring data is basic statistics.
Students are learning how to find those using spreadsheet.
If This Then That
If the data is this.. please do that, Spreadsheet.
If is basic programming logical, which is also used very frequently
in data processing.
And n' Or
If A and B is C, D will be E.
If A or B is C, D will be F.
Basic logical equation is also learned in this unit.