Scribd Logo
Upload

Welcome to Scribd!

  • 173 views

    MS Excel Activities I-Hmd

    Uploaded by

    marvz
    This document provides instructions for two Excel activities. Activity 1 involves creating a grade calculation worksheet with formulas to calculate quiz, assignment, and exam averages and grades. Activity 2 involves creating a hotel reservation worksheet with formulas to calculate rates, deposits, number of guests and days, and total billing amounts. Students are asked to complete the activities, saving their work with a specific filename, and submit it to the instructor.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    MS Excel Activities I-Hmd

    Uploaded by

    marvz
    173 views5 pages
    This document provides instructions for two Excel activities. Activity 1 involves creating a grade calculation worksheet with formulas to calculate quiz, assignment, and exam averages and grades. Activity 2 involves creating a hotel reservation worksheet with formulas to calculate rates, deposits, number of guests and days, and total billing amounts. Students are asked to complete the activities, saving their work with a specific filename, and submit it to the instructor.

    Original Description:

    Activities for HRM/Tourism Students in Spreadsheet application

    Original Title

    MS Excel Activities I-hmd

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides instructions for two Excel activities. Activity 1 involves creating a grade calculation worksheet with formulas to calculate quiz, assignment, and exam averages and grades. Activity 2 involves creating a hotel reservation worksheet with formulas to calculate rates, deposits, number of guests and days, and total billing amounts. Students are asked to complete the activities, saving their work with a specific filename, and submit it to the instructor.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    173 views5 pages

    MS Excel Activities I-Hmd

    Uploaded by

    marvz
    This document provides instructions for two Excel activities. Activity 1 involves creating a grade calculation worksheet with formulas to calculate quiz, assignment, and exam averages and grades. Activity 2 involves creating a hotel reservation worksheet with formulas to calculate rates, deposits, number of guests and days, and total billing amounts. Students are asked to complete the activities, saving their work with a specific filename, and submit it to the instructor.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 5

    Cristal e-College

    Tawala, Panglao, Bohol

    COURSE: COMP2 I-HMD


    INSTRUCTOR: BONGO, MARVI

    Computer Laboratory

    ACTIVITY 1
    (Grade Computation)
    Objectives:

    Create and edit a worksheet using MS Excel 2010


    Insert cell content
    Format cell and cell content
    Modify Spreadsheet
    Insert formulas and function

    Instructions:

    Open your workbook with the filename [YourFamilyName,Initial] Excel Activities


    Select and rename Sheet2 into Activity 1
    Select cell A1 and type Name:
    Select cells B1 to E1 and apply bottom border (Home Tab, Font Group)
    Select cell F1 and type Instructor:
    Select cells G1 to J1 and apply bottom border (Home Tab, Font Group)
    Select cell A2 and type Subject:
    Select cells B2 to E2 and apply bottom border (Home Tab, Font Group)
    Select cell A4 and Type PRELIM
    Select cells A4 to J4 and click on MERGE and CENTER command (Home Tab, Alignment
    Group) Align the merged cell to the left
    Input the following text on the cells given:
    A5 Quiz No.
    B5 HPS
    C5 Score
    D5 Ass. No.
    E5 - HPS
    F5 Score
    G5 Major Exam (40%)
    I5 Prelim Grade

    Cristal e-College

    COURSE: COMP2 I-HMD


    INSTRUCTOR: BONGO, MARVI

    Tawala, Panglao, Bohol

    Merge
    the cells
    Computer
    Laboratory

    G5 and H5, and also I5 and J5


    In cells A6 to A10 input numbers 1 to 5. Do the same in cells D6 to

    D10
    Input the following text on the cells given:

    G6 HPS
    G7 Score
    G8 EQ. Grade
    I6 Raw Score

    Select cells G10 and H10, click on MERGE and CENTER command and type Summative
    Ass (60%)
    Select cells A4 to J11 and apply All Borders command (Home Tab, Font Group)
    Type in the following formulas on the specified cells given below:

    B11
    C11
    E11
    F11

    =SUM(B6:B10)
    =SUM(C6:C10)
    =SUM(E6:E10)
    =SUM(F6:F10)

    J6 Point Eq.
    A11 Quiz Total:
    D11 Ass Total:
    G11 AVERAGE (Q & A)

    H8 =(H7/H6)*100
    H11
    =(SUM(C11,F11)/SUM(B11,E11))*100

    Merge the cells I7 and I8 and type the formula =(H8*40%)+(H11*60%)


    Merge the cells J7 and J8 and type the formula
    =IF(I7>=90,"1.0",IF(I7>=80,"1.5",IF(I7>=70,"2.0",IF(I7>=60,"2.5",IF(I7>=50,"3.0","5.0"))))
    )
    Apply cells formatting as shown in the sample output (Cell and Text Color).
    Copies cells A4 to J11 and paste it below prelim table. Change the all the word PRELIM in
    the copied cell and change it into MIDTERM. Do the same for SEMI-FINAL and FINAL.
    (See Sample Output below)
    Input data on the blank cells to get your grades and test your formulas. (Use your Test
    Results for the Prelim and Midterm that was returned to you)
    Save your workbook in your flash drive as [YourFamilyName,Initial] Excel Activities.

    SAMPLE OUTPUT

    ACTIVITY 2
    (Hotel Reservation Data)

    Objectives:

    Create and edit a worksheet using MS Excel 2010


    Insert cell content
    Format cell and cell content
    Modify Spreadsheet
    Create formulas and function

    Instructions:

    Open your workbook with the filename [YourFamilyName,Initial] Excel Activities


    Select Sheet3 and rename it as Activity 2
    Copy the data, formatting and modification as shown in the sample output below.
    For the ABC HOTEL RESERVATION text: use AR JULIAN font style, size 72
    The same font style is used in the GUEST INFORMATION, ROOM INFORMATION, AND
    BILLING STATEMENT, font size will be 14.
    For the remaining text in the cells use Arial font style size 11
    For the No. of Person column in the Billing Statement create a formula that automatically
    calculates the total no. of person (adult and children) from the Room Information table
    For the Deposit, create a formula that would get 50% of the Rate
    For the No. of Days, create a formula that automatically gets the total number of stays
    based on the Check In and Check Out Date information from the Room Information table
    And for the Total Amount, create a formula that would automatically calculate the total
    amount to be paid by the guest. To get the Total Amount multiply the Rate by the No. of
    Days stayed plus the Additional Payment minus the Deposit.
    Save you work and send it to my email marvibongo@hotmail.com with the subject
    [COMPLETE NAME] EXCEL ACTIVITIES.

    SAMPLE OUTPUT

    You might also like