Information Communication Technology ICT – 13 Layout | e-Consult
13 Layout (1 questions)
Login to see all questions.
Click on a question to view the answer
To create the table, the student would:
- Open a new spreadsheet in the chosen program.
- Enter the column headers: In cell A1, type 'Student Name'. In cell B1, type 'Activity'. In cell C1, type 'Frequency'.
- Enter the data for Alice Smith: In cell A2, type 'Alice Smith'. In cell B2, type 'Football'. In cell C2, type 'Weekly'.
- Enter the data for Bob Johnson: In cell A3, type 'Bob Johnson'. In cell B3, type 'Chess'. In cell C3, type 'Bi-Weekly'.
- Enter the data for Charlie Brown: In cell A4, type 'Charlie Brown'. In cell B4, type 'Drama Club'. In cell C4, type 'Monthly'.
- Enter the data for Diana Davis: In cell A5, type 'Diana Davis'. In cell B5, type 'Basketball'. In cell C5, type 'Weekly'.
- (Optional) Format the table: Select the entire table and apply formatting (borders, bold headers, alignment) for clarity.
The resulting table would be structured as follows:
| Student Name | Activity | Frequency |
| Alice Smith | Football | Weekly |
| Bob Johnson | Chess | Bi-Weekly |
| Charlie Brown | Drama Club | Monthly |
| Diana Davis | Basketball | Weekly |
Considerations: Ensure each piece of data is entered into the correct cell. Double-check for typos. Using the 'Enter' key after each data entry will move to the next row. The spreadsheet program will automatically fill in the subsequent rows as the data is entered.