computer_resources

The purpose of this site is for my teaching aids in Computer Studies as well as ICT subjects

Answer for Group 1: Revision on 27 Feb 2012 March 2, 2012

Filed under: Revision,Uncategorized — computer_resources @ 5:45 am

The spreadsheet below shows the result of core subjects of a Year 8 student in a school.

a)     Write down a cell address which contains

            i.            a label: A1 (other answers: A2, B2, A3, A4, A5, A6, A8, A9)

      ii.            a number: B3 (other answers: B4, B5, B6)

b)     Write down the formula/functions used to calculate the following:

             i.            Total Marks in B8: =SUM(B3:B6)    (other answer: =B3+B4+B5+B6)

      ii.     Average in B9: =AVERAGE(B3:B6) (other answer: =(B3+B4+B5+B6)/4)


c)     Give two advantages of spreadsheet.

1. Easier to edit or change data.

2. Formulae for calculation to be done automatically.

d)     List the four items that can be contained in the cell.

1. Text/Label

2. Formulae/Functions

3. Numbers 

4. Date/Time

Advertisements
 

Revision for March Test

Filed under: Revision — computer_resources @ 5:06 am

This is an interactive mind-map that I made in Prezi.com.  Use this for your revision in Spreadsheet topic.  Goodluck for your March Test!!

 

Spreadsheet Project!! February 25, 2012

Filed under: Project — computer_resources @ 5:50 pm

Ask yourselves…. 😀

THEMES FOR YOUR PROJECT: Dessert

AIM: For selling purpose.

Minimum required: 2 desserts.

Maximum required: 4 desserts.

 

 

 

 

TASK 1  (TIME FRAME: 27 Feb –  12 Mar)

  • Search from the Internet and print the chosen recipes.
  • Take the ingredients from the recipes.  (Work it out while you having school’s holiday)

TASK 2 (TIME FRAME: 26 Mar – 2 Apr)

  • Start Microsoft Office Excel
  • Begin with ‘SHEET 1’ and Rename “Things to Buy for 1 Month”
  • Create table for each recipe, with label “ITEMS”, “QUANTITY”, “UNIT PRICE”, “AMOUNT” and “TOTAL EXPENSES”.  Diagram below is just an example:

  • Enter all the data that you have taken from the recipe in TASK 1.
  • Sort the ITEMS in ascending order.
  • Formatting the cell – colours and borders
  • Do appropriate calculation on the table that you created.

FINALIZING

  • Page Setup and Printing –

Adjust your worksheet that fit into single page, Portrait.
Set the margins – Center on page: Both Horizontally and Vertically.
Insert Header: “Spreadsheet Project – Dessert”
Insert Footer: “Your name and class”

  • Save As your project as DESSERT-your name.
  • Give your HARD COPY (printed copy) to teacher.
  • E-mail your SOFT COPY to qistinah.jalil@ripas.moe.edu.bn

***************************

***************************

TASK 3 (TIME FRAME: 2 Apr-9 Apr)

  • Continue your TASK 2 by adding ‘SHEET 2’ and Rename “Total Sales”
  • Create table for month January.  Label the table “ITEMS”, “WEEK 1”, “WEEK 2”, “WEEK 3”, “WEEK 4”, “TOTAL SALES”, and “TOTAL”.  Diagram below is just an example:

  • Formatting the cell – colours and borders
  • Do appropriate calculation on the table that you created.
  • Provide BAR CHART for the JANUARY sales.

FINALIZING

  • Page Setup and Printing –

Adjust your worksheet that fit into single page, Landscape.
Set the margins – Center on page: Both Horizontally and Vertically.
Insert Header: “Spreadsheet Project – Dessert”
Insert Footer: “Your name and class”

  • Save As your project as DESSERT-your name.
  • Give your HARD COPY (printed copy) to teacher.
  • E-mail your SOFT COPY to qistinah.jalil@ripas.moe.edu.bn
 

I just would like you to have your own….. February 20, 2012

Filed under: Uncategorized — computer_resources @ 4:33 am

To make a COPY for yourself for all the homework that you done in this BLOG by PRINTING the QUESTIONS POSTED together with YOUR ANSWER

AFTER your teacher marked your answer.

The purpose is for you to refer to for your REVISION!!

 

Homework For Week 7

Filed under: Homework — computer_resources @ 3:57 am

Students,

This homework has to be completed on 24 FEBRUARY 2012, FRIDAY.

You have done a group work on ACTIVITY 5.4, page 65.  I hope you get the positive feedback of doing it collaboratively.

Your homework is focused on ACTIVITY 5.4.1.  Before this you have worked on the FORMULAE.  COMPLETE the activity by ANSWERING ALL THE UNANSWERED QUESTIONS LEFT.

………………………………..

??HOW TO DO??

INSTRUCTION: You must do this activity using ONLY Microsoft Office Excel, no calculator is allowed.

STEP 1 – Continue with your SAVED EXCEL FILE.

STEP 2 – Do calculations by entering the FUNCTION in appropriate cell for all the questions.

STEP 3 – SAVE your work as “Activity 5.4.1 FUNCTION -your name” in pendrive. (for your next class purpose)

STEP 4 – E-mail your work to qistinah.jalil@ripas.moe.edu.bn (It is for my copy to verify your answer)

STEP 5 -Once you figured out the answer,  PRESS “Leave a comment” in THIS POST and start TYPING YOUR ANSWER as format below:

Formulae and functions: “SUM”

1. Total marks for Maths: ‘your answer’

Function for Maths:’your answer’

…………

Total marks for English: ‘your answer’

Function for English: ‘your answer’

………..

……….

……

and the rest of the subjects.

2. Total marks for Angelina Jolie: ‘your answer’

Function for Angelina Jolie: ‘your answer’

…………

Total marks for Brad Pitt: ‘your answer’

Function for Brad Pitt: ‘your answer’

…………

…….

….

and the rest of the students.

Functions: “AVERAGE”

1. Average marks for Maths: ‘your answer’

Function for Maths:’your answer’

…………

Average marks for English: ‘your answer’

Function for English: ‘your answer’

………..

……….

……

and the rest of the subjects.

2. Average marks for Angelina Jolie: ‘your answer’

Function for Angelina Jolie: ‘your answer’

…………

Average marks for Brad Pitt: ‘your answer’

Function for Brad Pitt: ‘your answer’

…………

…….

….

and the rest of the students.

Functions: “MAX, MIN, and COUNT”

1. Maximum marks for Maths: ‘your answer’

Function for Maths:’your answer’

…………

Maximum marks for English: ‘your answer’

Function for English: ‘your answer’

………..

……….

……

and the rest of the subjects.

Minimum marks for Maths: ‘your answer’

Function for Maths:’your answer’

…………

Minimum marks for English: ‘your answer’

Function for English: ‘your answer’

………..

……….

……

and the rest of the subjects.

2.  Count data for Maths: ‘your answer’

Function for Maths:’your answer’

…………

Count data for English: ‘your answer’

Function for English: ‘your answer’

………..

……….

……

and the rest of the subjects.

DUEDATE!! As you can see on the right >>>

 

Answer: Homework For Week 6

Filed under: Homework — computer_resources @ 3:21 am

Students,

Perhaps you did not see the video clearly during our lesson today, here is the video I uploaded that regards with your Homework for Week 6 covering FORMULAE.

 

 

 

One Team, Many ideas….Many Solutions!! February 19, 2012

Filed under: Uncategorized — computer_resources @ 5:58 am

Dear students,

Here are some IMPORTANT information for you to read.  I just would like to share with you all because I believe learning in TEAMWORK or GROUP WORK helps us a lot.  It is an effective way for us to learn in group because you could see different solutions, ways, ideas from others.

http://teacherbootcamp.edublogs.org/2010/11/19/cooperative-learning-effective-team-work-15-resources/

The benefits of cooperative learning. Through cooperative learning students learn effective team work through:

  • Accountability– students realize the contribution of each individual will determine the success of the task.
  • Team building– students learn how to listen to each other, resolve conflicts, delegate tasks, set deadlines and support each other.