Wednesday, February 20, 2019

Spreadsheets - Data Validation


Objective:

To be able to
define data validation.
apply data validation checks in a spreadsheet

Task 1:


  1. Observe the demonstration carefully.
  2. Download the activity file from HERE.
  3. Save the file in your folder in D drive.



Task 2 (2 Activities)

Activity 1:


  • Apply the data validation checks as demonstrated.


Activity 2:


  • Explore data validation dialogue box and apply the required data validation checks yourself.

Saturday, February 16, 2019

Spreadsheets - Reinforcement



February Week 3 

Objectives:

To be able to use a digital spreadsheet software to solve real life problems.

Task 1:

Open Class Register Activity File.
Apply Conditional Formatting to highlight absenteeism.

Task 2:

Download Task 2 File.
SAVE file in your folder.
Read and follow instructions carefully.
SAVE again before closing.




Task 3:

Student Feedback

Tuesday, February 12, 2019

Spreadsheets - Applications in real life problem solving.


February Week 1 and 2 

Objectives:

To be able to use a digital spreadsheet software to create/format calculation based reports.

Task 1:

Download Task 1 File.
Read and follow instructions carefully.
SAVE file in your folder.

Task 2:

Download Task 2 File.
Read and follow instructions carefully.
SAVE file in your folder.

Task 3:

Download Task 2 File.
Read and follow instructions carefully.
SAVE file in your folder.

Saturday, January 19, 2019

Spreadsheets - Formulas and Functions


Activity 1:
Reading Task (Page No.1 to 5)
10 minutes


Activity 2:
Open the Activity File (Previously downloaded and saved in your folder in D: drive)

  1. Find out 
  • how many students will need a support class? 
          (If marks obtained are less than 50% then support class will be provided.)
  • how many students will get the distinction certificate?
         (If % is 90 or above then the student will receive a distinction certificate.)

Saturday, January 12, 2019

Introduction to Spreadsheets



Introduction to spreadsheets (Video)

Download the Activity File
Complete the Activity and save in your folder in D drive of your computer system.


ACTIVITY FILE




Wednesday, November 21, 2018

SAMPLE for CALCULATOR Project

Please compare your calculator app with the following App.

SAMPLE CALCULATOR APP

Also explore the commands used in Grocery List App
GROCERY LIST