Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 128 - logicode 2609 C5
P. 128

    Multiple AssessMents - 1

                      subject enrichMent Activity - 2

                      Excel 2021- An Introduction, Editing in Excel 2021
                      Activity Name: Students Marksheet

                      Objective: To learn how to enter marks in Excel, calculate total marks using a simple

                      formula, and understand rows, columns, and basic formulas.

                      Learning Outcomes

                         Enter numerical data in Excel
                         Use the SUM formula

                         Calculate total marks

                         Format a worksheet neatly

                      Description: Students are introduced to Microsoft Excel, where they learn its purpose,
                      create a new worksheet, and understand basic elements such as rows, columns, and cells.

                      Perform the following actions:

                         Type the following headings in Row 1:

                        o  Student Name
                        o  English

                        o  Maths

                        o  Science

                        o  Total

                         Enter marks for at least three students under each subject.
                         The teacher demonstrates how to calculate Total Marks using a formula.

                      •  Students click on the Total cell (E2) and type the formula.

                      Evaluation Criteria

                         Data Entry

                         Use of Formula

                         Formatting

                      126   Premium Edition-V

| 123 124 125 126 127 128 129 130 |