Basic spreadsheet commands. (note on powerpoint). These powerpoint slides were made using the following menu options: View -- normal Insert -- new slide Format -- slide format, and choosing the one that allows a title and notes. Before you sit at the computer.
Control or Command (apple) plus
If you plan 10 assignments then in cell M3 type =sum(c3:l3), which will add up the grades for that student
• Now select cell M3 by clicking on it, copy it into the computer’s memory using the copy command, and paste it into cells M4 to the end of the students.
E.g., in O4 you might type
IF (N4<50, “Fail”, “Pass”)
which means if grade (as percentage) is less than 50 the cell O4 will show the word Fail; otherwise it will show Pass. Try it and see.
would explain everything in the preceding show using visual images, not simply text,
and allow animations such as this on this slide (created using Menu option: Slide show, animation, fly in).