WEEK 13- Microsoft Excel

Assalamualaikum...

For week 13, we will focus on microsoft Excel because as a "teacher to-be" it is important to learn and to now the simple basic on how to used Microsoft Excel.

Our first task was to create our own monthly financial plan for a year using microsoft excel. Below are the process on how I did my monthly financial plan.

The step:

1. Create a column for date and also make a column of the list of what you spend the most during the month for example, food, other necessities, top-up, educational book and etc.

2. Then, we add the column for 'Total Spending' And for this column we need to create a formula to make the column for 'total spending' to calculate automatically the sum of our spending for a day.

To create a formula, first we need to set put the symbol '=' in the cell column and then we can proceed in creating the formula by clicking on the symbol *fx* and then choose the formula that we want, for example in this case, we want to add up all the total of our spending for that particular one day, so we need to choose the formula *SUM* and then click the cell that we want to include in the formula for example: (C5+D5+E5+F5). So, the overall of the formula will look like this =SUM(C5+D5+E5+F5)

Next, after we have created the formula that we want, we can scroll the formula down until it reach the position of the cell that we want.

3. Make a column for our 'Allowance' and also 'Last Month Saving' where in this section, we will focus 'money coming in' during the month.

Same as we did previously, after we have put all the data of our 'allowance' and also our 'last month saving', we also need to create a formula to calculate the total of our saving for that particular day.

When we want to total up our savings for that particular day, we also need to create a formula. For this case, we also need to use the formula 'SUM' because we want to total up all our savings from our allowance and also from our last month saving. However this is for the first column.

Then we scroll the formula down until it reach to the cell that we want.

4.Then for the finally, we need to create a column for our total saving (money going in - money going out)

The formula for this column would be *=SUM(I3-G3)* that is *money going in - total spending*

Then, after we have finished all the column, our monthly financial plan will look something like this:

Below, are the link of my monthly financial plan on google doc.

https://docs.google.com/spreadsheet/ccc?key=0AlmBDRwOiM9GdE05SUo2MV9FQWx4S3NlQmhvMUk3Mmc#gid=1

Our 2nd task for this week was to create a students grade also by using Microsoft Excel. First of all, we need to create a table for 'Student names' , 'Subjects' , 'Marks' , and the 'Grades' as below:

Then, we need to create a grade table for the student marks.The grade table will look something like this:

To add the students grade into the column, first we need to define this grade table by highlighting the Grade Table and clicking on *Insert - Name - Define* and name the grade table as Grade . Then, after we have define the Grade Table, we can proceed in adding the students grade in the *Grade* column by creating a formula.

The formula that we used for the student grade will be *=VLOOKUP(marks,grade,2) for example as the picture below:

Then we can just drag the grade column until it reach the cell that we want. Then we continue to do the same method for the rest of the subjects.

Then we can add another table for *Average* , *Standard Deviation*, *Minimum* and *Maximum* . After we have create the table, it look something like this:

Then to fill in the Average, Standard Deviation, Minimum and Maximum column, we need to define the column for all the subject marks and the subject grades.

Then, we create the formula for:

Average : * =AVERAGE(Marks_bm) *

Standard Deviatior : * =STDEV(Marks_bm)*

Minimum : * =MIN(Marks_bm) *

Maximum : * =MAX(Marks_bm) *

After we had have create all the formula, the table will look something like this:

When we have finish will all of the tables, the overall sheet will look like this:

Below are the link of my Student grade Sheet from my google doc:

https://docs.google.com/spreadsheet/ccc?key=0AlmBDRwOiM9GdFFCc2RGc0I2bllEcWNuWU13NkUzNUE&hl=en_US#gid=1

WEEkK 11 and WEEK 12 - Multimedia Presentation (Portfolio)

Assalamualaikum to all.

This week me and my classmates have been asked to do a multimedia presentation and also to create a showcase portfolio for the assignments that we have done so far.

First, we were asked to create a powerpoint about our topic from Assignment 1 (Original and Licensed Software) with our own creativity. In this powerpoint, we must include all the information that we have learn for our topic. After we have finished creating our powerpoint, we were asked to present and share it to the rest of the classmates.

Second, after we have finished our first power point, then we were asked to create another presentation using Impress and present about or Mini Research in assignment 5. Here, we must include all the findings that we had found from our research and the methods that we used for the research in week 7-8. The function between microsoft powerpoint and also Impress are almost alike but however impress has more additional functions than powerpoint.

We need to add some animations to our presentations, and also some audio and video to make our slides more lively and creative. For those who have expert in using powerpoint and also impress, it would take less time for them to make a presentations than those who are still learning in using it. As for me, i'm still in a learning process in making a presentation using powerpoint and also impress.

After we have settled creating 2 presentations for original and licensed software, now we can proceed in making our portfolio showcase portfolio. This is the part where we can show our own creativity and skills to our lecturer.

In this showcase portfolio, we need to include all the assignment that we have done that is our assignment from week 1 until week 14. We also need to add animation, audio and video to the presentation so that it will show our creativity.

This presentation will be created using microsoft powerpoint.

When we have finished create our showcase portfolio, we then burn it into CD and create our own CD label. After we have completed everything, we then submit our show portfolio CD to our lecturer.

Below are the process on how i made my own CD label:

WEEK 9 and WEEK 10 - Multimedia In Education

Assalamualaikum....

For this 2 weeks.....we were asked to learn about 2D graphic editing software by using microsoft paint, smart Art powerpoint, google draw, GIMP and openOffice Draw. We also learn about 2D graphic types...which is:

• bitmap and
• vector

Furthermore, we were also learning about 2D graphic format, which is

PEG, GIFF, TIFF, BMP,PNG, WMF.

Then, we create a brochure and a booklet about our topic, Original and Licensed Software.

WEEK 9 - Graphic Editing:

By using the 2D graphic editing software, we can edit and create an image for our brochure and booklet in week 10.

Microsoft Paint (Bitmap):

This software allows us to draw and create an image anyway we want. From microsoft paint, we can also used all different shapes and symbols that we want to create our own graphic image. Below are the example of an image that I create using Microsoft Paint.

smart Art powerpoint (Vector):

This software only allows us to create a graphic image based on shapes and symbols. We can change the size and the dimension of the graphic (2D or 3D). Below are the image that I have created by using smart Art powerpoint (macbook).

Google Draw (Bitmap):

Allow us to freely create our image in anyway we want by using paint, pencil and etc. Below are the example of google draw.

GIMP (Bitmap):

Allow us to edit any picture or images that we want and give some effects on the images. Below are the example of an image that I have edited using GIMP:

WEEK 10- Brochure and Booklet

After we have finish creating our own images for Original and Licensed software, we need to create a brochure and a booklet of our own about our topic, Original and Licensed software. Both me and my partner have discuss on dividing our assigment for this week, and as a overall result, I will be responsible in doing our booklet whereas my partner will be responsible in doing our brochure.

How To Create a Brochure:

To create a brochure, we can used Microsoft Publisher. In Microsoft Publisher, we can create a brochure and choose any template that we want for our brochure. But because my computer is Macbook, I have to used other software to create a brochure. If using my computer to create a brochure, I have to choose *Pages* in order to do it.

Then, from there we can choose any template that we want for our brochure. Below are some of the examples of template that we can choose for our brochure:

In the brochure, me and my partner have agreed to put every information that me and partner know about Original and Licensed Software which is based on What, Why, Where, When, Who and How.

How to create booklet:

To create a booklet, we can use *Microsoft Office*. From Microsoft Office, we can select Booklet, and then we can create our own design for our booklet.

In the booklet, I have put all the findings that me and partner found during our mini research in week 7 and 8.

Below are the link of my booklet that I have uploaded in my Google Doc:

https://docs.google.com/open?id=0B1mBDRwOiM9GZjY4NTZiNTctY2FkMS00MDU5LWE2NTctNWU5MTE2OGNjZjBj

WEEK 7 and WEEK 8 - Survey Analysis Using SPSS and writing a report.

Assalamualaikum to all.

For week 7 and week 8, we are recording all the data that we have collected from our research into SPSS (Statistical Package for Social Science). After we have recorded all the data, we also need to write a report about what method we use for our research, and what is our findings from the research that we have made.

Week 7: Record All The Data From The Research Into SPSS.

First step: Need to download SPSS in our computer.

To download SPSS, I need to search from google to find the software. Then, after I have found the suitable link for me to download the SPSS, I need to install the software into my computer.
When I have finished installing the software, I can start recording all the data that me and my partner have collected from the survey. Below, are the introduction to SPSS.
Introduction To SPSS:

SPSS Basics Skills Tutorials:

http://my.ilstu.edu/~mshesso/SPSS/tutorial.html

Introduction to IBM SPSS Statistics 18:

http://spss.co.in/chapters.aspx?id=1

After we have record all the data into SPSS, we can process the data to produce the overall result of our research. The result will be our reference for our research report.

Week 8 - Writing A Report Of Our Research.

On week 8, we were asked to write a report about our research, what methods that we used for our research and our findings from the research. What me and my partner found out from our research is that most of our respondent preferred to used original and licensed software rather than pirated software and they personally recommended their family and friends to use original and licensed software because they believe that original and licensed software is more beneficial than pirated software. We also found out that most of the respondent have a good general knowledge about original and licensed software.

After we have done doing our report, we share it in our google doc and also upload it in our yahoo group files.

Below are the link for my report from google doc:

https://docs.google.com/document/d/1hBmS8g0eVC9c-TJmxncQFSO_hu1DQoCDBGjhbv2y6AY/edit

WEEK 6- Real Research (Questionnaire/Survey Week)

Assalamualaikum, this week is a continuation of last week assignment, where this week we were asked to create a survey or a questionnaire about our sub-topic (in my case, original and licensed software) using survey monkey and google doc.

Each group have to create 10 questions for the survey. So each group have to discuss with their partner about the questions that they want to ask to their classmates. The questions need to be relevant to the topic.

After we have decided the 10 questions that we want to ask, we have to sign up at www.surveymonkey.com. Then we can start creating our own survey using survey monkey.

We need to share the link of our survey into our Facebook group so that other members can answer the survey.

2nd step, proceed on creating a survey using google doc. By creating *new form* we can then start creating our survey.

We need to copy the link of our survey from google doc into our GE1155 computer in education yahoo group by clicking on link *links* on the left side of the yahoo group page. There, we need to copy our survey link into a a folder according to our topics.

We also need to print those survey and distribute it to our friends from other faculties.

Below is the link of our survey using survey monkey:

http://www.surveymonkey.com/s/VYNT7BY

WEEK 5 - Mini Research on Original and Licensed Software

Assalamualaikum to all.

Alhamdulillah now we have come to week 5. Thanks to Allah for helping us along

the journey.This week assignment on computer in education involves doing a research

on our sub-topic from assignment 1 (for my group, Original and Licensed Software)

on UKM subscription research Database, google scholar and also on google books.

We were asked to search 2 journal articles from UKM subscription research Database,

1 journal from google scholar and 1 book that is related to my group sub-topic from

google books.

UKM Research Database:

Google Scholar:

Google Book:

My journey in doing the research above:

I have to admit, this week assignment is a little bit tough and difficult, especially in

finding the journals in UKM research database. It takes me for hours to find any journals

that is relevant to my group's sub-subtopic. There were some articles that need to be

purchase in order to download the journal articles. So, I need to be wise in finding the

journals that is free and relevant to our topic.

Next Step:

After I have find all the important and relevant informations from the journals and

book, I need to share those informations with my partner, my classmates and my lecturer

in my Facebook group. Me, my partner and my classmates need to discuss about the

article journals and books that we have found.

Then, after the discussion had finished, we can now proceed on doing a report about

our sub-topics based on the article journals and books that we have found from the

internet. The report should be done using Open Office Writer. I do not have that

software in my laptop, so I need to download that software first before I can proceed

on doing my report.

To Download Open Office Writer:

• Search on www.google.com = Download Open Office Writer.
• Then, click on the link that you think is relevant to your search. From there, you can automatically start downloading the open office writer to your laptop.
• After finish downloading it to your laptop, you need to install the open office writer in order for you to be able to use that software.
• When you have done installing the software, the open office writer are ready to use.

Write a report about original and licensed software using open office writer based on the article journals and books what you have found in the internet. Then after I have finished writing my report, I convert my report document into PDF. Lastly, I upload my report into my Yahoo Group and I also share my report in my google doc.

Below is the link of my report in my google doc:

https://docs.google.com/openid=0B1mBDRwOiM9GZjljMmZkZjktY2I2NS00YWRmLTgxZjctYmRiYWFmZTk2ZGZj

WEEK 3 and WEEK 4 - ASSIGNMENT 1 ( Original and Licensed Software)

Assalamualaikum to all,

This week for my computer in education class, me and classmates have been given our first assignment, where each of us are required to form a pair or a triplet in each group. Then, after we decide who is going to be our partner for thisassignment, each of the group will have to choose one topic each that had been set by our lecturer which is:

1. 21st Century Skills 2. Thinking skills and ICT
3. Internet and Computer Security (Virus, Spam, Phishing)
& Operating System
4. Original and licensed software
5. Open source Software
6. Web 2.0 in education
7. E-Learning & Mobile learning.

Original and licensed software have been to me and partner as
our sub-topic for our1st assignment. As we did before during
the previous week, we were asked to find out some information
about the sub-topic that has been given to us. Through
google, WHAT, WHY, WHERE, WHO and HOW.

Based on my research by using google, below are the informations
that I have found out so far:

What Is The Meaning Of Original And Licensed Software?

For the reader’s information, in order for me to understand the meaning of original and licensed software better, I separate the questions into two parts, which is:
*What is original software? And

*What is licensed software?

Based on Wikipedia definition:
Original Software : is a privately held company providing
automatic software testing products and services.

Licensed Software : a legal instrument (usually by way of
contract law) governing the usage or redistribution of software.

- Allowing an individual or group to use a piece
of software. Nearly all applications are licensed rather than sold.There are a variety of different types of software licenses. Someare based on the number machines onwhich the licensed programcan run whereas others are based on the number of usersthat can use the program. Most personal computer software licenses allow you to run the program on only one machine and to make copies of the software only for backuppurposes. Some licenses also allow you to run the program ondifferent computers as long as you don't use the copies simultaneously.

Thus, by looking at the two definition,

My own definition of Original and Licensed Software: is a software that has been produced by a private company that had a legal licensed by the government in order to make the software to be used legally thesoftware user. These company through the people or company.kinds of software usually have a copyright in order to prevent software piracy by other

Why Used An Original And Licensed Software?

• It has a better quality than piracy software and it is also reliableIt has a warranty from the software company.
• Less risk of viruses.
• Faulty free.

Where Usually An Original And Licensed Software Being Used?

-At home

-Schools

-Offices

-Companies

-Universities.

Who Used Original And Licensed Software?

-Students

-Workers (Offices, Companies)

-Lecturers

-Faculty

-Enterprise

-Commercial

How Does Original And Licensed Software Affect Us as Users and The Private Company?

For users, it is beneficial for them to purchase original and licensed software because it has a better quality and more reliable to use than a piracy software. However, because this kind of software is usually expensive, users tend to go towards buying piracy software because of its cheaper price. Thus, because of this, the company who produced the original and licensed software might experience some profit lost. Therefore, in order to prevent this, they provide a copyright for their software product.

Punishment For Software Piracy Fine: Up to $150,000

Penalty: 5 Years Prison Sentences or $250,000 fine.

NEXT STEP:

After I have collect all the information that I needed for my sub-topic, I have to share my information with my partner and the rest of my classmates whether by using my Facebook group of my partner's facebook group. Then, my partner and my classmates must respond to what I have share with them.

How To Share Informations Through Facebook Group By Using Docs :

To share my informations with my partner and my classmates using facebook group, firstly I have to open the facebook group address that I wanted to used. Then, I need to click *Docs* on top of the facebook group page. After I have put all the informations there, I just simply need to post my document into my Facebook Group.After I have finished sharing my report on CMS in my Facebook group, I also need to share
my report in my google doc.

Then, I need to download my report into PDF and upload it into my Yahoo Group file.


My Personal Experience and Opinion:

From my personal experience in doing this assignment, it was a little bit hard to find the information about my group sub-topic at Google. There were not many relevant informations about Original and Licensed Software that is needed for this assignment.The next option to find more info about this topic, I went to our UKM main library, Perpustakaan Tun Seri Lanang, with my partner. However, there is also no books that are beginning of our research.relevant for our group topic. Because of this, we have experience a slightly difficulties in the

My Original and Licensed software report on google Docs: https://docs.google.com/document/d/1LYYo3auVX0Iv4T1YJmY8la45Mkyri_UEwI762EJH2yU/edit?hl=en_GB