SPREADSHEET APPLICATION LABORATORY

OBJECTIVE

This activity will equip students with the skills to efficiently use Google Sheets for data management, basic data analysis, and visualization, fostering their ability to apply spreadsheet tools in academic and real-world scenarios. 

Learning Outcomes

By the end of this activity, students will:

1. Understand the interface and basic functionalities of Google Sheets.

2. Be able to enter, organize, and manipulate data within a spreadsheet.

3. Apply basic formulas and functions to perform calculations.

4. Create charts and graphs to visualize data.

5. Collaborate in real-time with peers using Google Sheets' sharing and commenting features.

1. Introduction to Google Sheets 

• Student Task: Log in to your Google accounts, navigate to Google Sheets, and open a new blank spreadsheet.

1. Open your browser and go to Google Sheets.

2. Sign in with your Google account.

3. Click on the Blank sheet option.

4. A new Google Sheet window will open. At the top-left corner, click on Untitled Spreadsheet and rename it to something like “Spreadsheet_Surname"”

3. Using Basic Formulas and Functions 

• Student Task:

  • SUM Function: Calculate the total score for each student using the SUM function. Input the "Total Score" in column F.

  • AVERAGE Function: Determine the student average for all subjects using the AVERAGE function. Input the "Average" in Column G.

  • IF Function: Determine if the student "Passed" or "Failed" if the passing score of the total core is 150. Input the "Passed/Failed" in Column H

4. Data Visualization

• Student Task:

  • Create a Chart: Generate a bar chart that compares the total scores and the average only. 

  • Customize the Chart: Adjust chart elements like:

    1. Chart Title (Section Newton Performance) Font Style (Wide), Font Size (30)

    2. Chart background color (Yellow)

    3. Chart style (3D) 

    4. Series shows (Data Labels)

5. Share your Excel activity in my email maekarrencorreos@gmail.com 

Important Reminder:

When sharing your output, please ensure that the sharing settings are updated to “Anyone with the link can access” and not restricted to only the institution’s Gmail accounts. Additionally, make sure to change the permission settings to Editor so that necessary edits can be made.