Session Date
Lesson Topic
Spreadsheets. Use of MS Excel program to create an accurate spreadsheet of Test results (similar to a teacher's class) and have Excel auto-calculate the totals and test averages. Basic method of formatting the spreadsheet and correctly labeling key rows and columns.
Lesson Outline
Spreadsheets. Use of MS Excel program to create an accurate spreadsheet of Test results (similar to a teacher's class) and have Excel auto-calculate the totals and test averages. Handout assignment of a printed list of students and data given for several Test Grades. Creation of a "teacher record" of these grades on Excel and student is shown commands/instructions on Excel to compute test score sums and averages for each student.
Assignment
Continue to Work on MS Excel Test Scores Assignment
Session Minutes
45
Minutes Student Attended
45
Lesson Comments
During today's lesson, PJ was given an MS Excel assignment to copy a given list of student test grades andshown how to properly label the Rows and Columns on the Excel spreadsheet. PJ was receptive and attentive to the details required for a properly formatted spreadsheet. The next step will be to show him how Excel will perform "auto-calculations" in summing columns of data and eventually calculating students' test averages.
Session Hours
0.75
Hours Attended
0.75
Entry Status
Review Status
Student Name(s)
Subject
School