Excel

In today lesson we were given the task of removing the option of  dirty data from being put in.  Dirty data is a database record that contains errors. Dirty data can be caused by a number of factors including duplicate records, incomplete or outdated data, and the improper parsing of record fields from disparate systems.
so in other words if I can put numbers in an area of excel where only letters should be put in there. This is also known as dirty data because it is not suppose to happen. 

Here are some screen shoots and steps on of how i removed the dirt data

1) You should be able to see a small icon on the bottom of the left corner.  I then Clicked on it which took me to design view. Here I was able to change the way numbers and letters are typed in.
screen shot :

2) Time to make some changes to remove the dirty data. I then clicked on the the Model and there appeared a drop down list. I selected the text option as shown in the screen shot below

 I then changed the field size to 20. This means that i will not be allowed to type in more than 20 letters ( because I selected TEXT) . screen shot below :

Here is a screen shot of what  will happen when i type in a word more than 20 letters.

It wont let me type because my field size is 20. so Im not allowed to type in more than 20 letters.

 it work !

3) I next changed the Engine capacity section. I changed the engine capacity so it does not allow me to put in more than 0000 zeros. Click on the arrow for the drop down list and choose the number option.  There is  screen shot below :

Now at the bottom of the 

DATA BASE USING EXCEL !

Today we were given a sheet that was made on Microsoft Excel that contained all sorts of cars, the model, engine capacity and much more.

 excel

Task 1

The 5 different websites and their screen shots !
the following sites are :

Site 1

 http://www.emirates.com/english/

site 2 http://gulfnews.com/

In today's lesson we were  to do some research on any 5 

 websites of our choice . Along with that we were given 

the following 2 tasks : 


1) Find 5 different websites that are very well organised 

for the content it presents and screenshot each site.

2) Evaluate each website in your blog (ie discuss what 

each website does or doesn't do well).

 We also had to Consider navigation, button style, 'white

 space' balance around the information it presents,

 the type of content presented (text, images, video,

 audio) colour scheme, ease of use, speed of opening,

 links to social media, 

Adobe Photoshop

In class, we are also using Adobe Photoshop to create our own website. This is how I did it In order to make the main page of my website i will need to have 6 elements : Banner, Footer, and four buttons. this is what my template looks like. Image below Then I went ahead and made my banner. Image below. Do you like it ??? I also saved my work in two different formats. Jpeg and PSD. What is a J peg and PSD ? Jpeg :A format for compressing image files PSDF : PSD, which stands for Photoshop Document, is the default format that Photoshop uses for saving data. PSD is a proprietary file that allows the user to work with the images' individual layers even after the file has been saved. How to save your work into these different format ? J peg : 1 )

2 )

The same method applies to PSD except you have to change the setting to PSD . Next I made my footer.image below

Next I made the 4 buttons. i have also decided to add some lense flare to make the website more attractive and aesthetically pleasing . images are below :

The third one is under construction (: Any space for improvements on my blog ? please comment in the comment section below (:

My Website - HTML!

Hello world

This is my first webpage Visit the Google page

Go to gmail

Visit the You Tube site

What if ??????????????

 What is an if statement ?
The if statement executes a statement if a specified condition is true. If the condition is false, another statement can be executed.

Some examples of the if statements below are from the excel calories counter are below

1) What if a person eats junk all day?
If i eat eat junk all day the calculator counts all the calories (the intake from the whole day) and compares it from the calories that are supposed to be intaken. It then recommends you the calories that you should be having throughout the day to keep fit and healthy. 

screen shot below

2) What if they eat healthy?
If i eat healthy all day the calculator counts all the calories (the intake from the whole day) and compares it from the calories that are supposed to be intaken. It then recommends you the calories that you should be having throughout the day to keep fit and healthy. 

screen shots below 

3) What is the calorie intake ?
your calorie intake is recommended on your BMI and gender.The term BMI stands for body mass index. In order to find someones BMI you have to know the formulas below :

BMR = 10 * weight(kg) + 6.25 * height(cm) - 5 * age(y) + 5         (man)

BMR = 10 * weight(kg) + 6.25 * height(cm) - 5 * age(y) - 161     (woman) Next you have to make an if statement and type in the formula below screen shot provided

Excel colorie counter

The feature that are needed to make complete this quiz are

Spinners
option button
sum formula
the formula used to maintain a man / womens body weight
how have you used these formula to advise someone on their calorie intake

Screen shots are below . I havent really finished making the quiz but i have taken some screen shots of the option button from the calculator spread sheet .

Excel Quiz making