Reflection

In my excel project, I used the following functions:


MS EXCEL: IF FUNCTION (WS)

This Excel tutorial explains how to use the Excel IF function with syntax and examples.

DESCRIPTION

The Microsoft Excel IF function returns one value if the condition is TRUE, or another value if the condition is FALSE.

SYNTAX

The syntax for the IF function in Microsoft Excel is:

IF( condition, [value_if_true], [value_if_false] )

Parameters or Arguments

condition

The value that you want to test.

value_if_true

Optional. It is the value that is returned if condition evaluates to TRUE.

value_if_false

Optional. It is the value that is return if condition evaluates to FALSE.

MS EXCEL: SUM FUNCTION (WS)

This Excel tutorial explains how to use the Excel SUM function with syntax and examples.

DESCRIPTION

The Microsoft Excel SUM function adds all numbers in a range of cells and returns the result.

SYNTAX

The syntax for the SUM function in Microsoft Excel is:SUM( number1, [number2, ... number_n] )


ORSUM ( cell1:cell2, [cell3:cell4], ... )

Parameters or Arguments

number

A numeric value that you wish to sum.

cell

The range of cells that you wish to sum.


MS EXCEL: COUNTA FUNCTION (WS)

This Excel tutorial explains how to use the Excel COUNTA function with syntax and examples.

DESCRIPTION

The Microsoft Excel COUNTA function counts the number of cells that are not empty as well as the number of arguments that contain values.

SYNTAX

The syntax for the COUNTA function in Microsoft Excel is:COUNTA( argument1, [argument2, ... argument_n] )

Parameters or Arguments

argument1, argument2, ... argument_n

Either ranges of cells or values. There can be up to 30 arguments.

Difference between COUNTA, COUNT AND COUNTIF:

The COUNT function is generally used to count a range of cells containing numbers or dates excluding blanks.

COUNTA, on the other hand will count everything... numbers, dates, text or a range containing a mixture of these items, but does not count blank cells. COUNTA stands for count all.

Although you can use COUNTA to generate the number of clients or employees in a list, it counts each entry, not unique entries. To count unique entries you would have to use the SUM function together with the COUNTIF function.

GRAPH:

I then converted my data into graph format using Microsoft excel. I created a separate table to represent part of my data and then selected it and changed it into a graph. With this, I visually represented the quantity of 'Poptart' brand products Tesco supermarket currently has in stock.

1. Evaluate your performance during criteria A, B , C and D - what did you do well and what did you do badly? Suggest 2 improvements you could make for each criteria?

Criteria A - Inquiring and Analyzing:
I believe I have successfully presented my knowledge in this criteria because I did some background research to find out what a restock excel sheet looks like, what it should include and why it is used. After learning this information, I incorporated the things we learned in class and added one extra formula that I researched by myself out of class to successfully meet this criteria. To improve, I could have added more of the simple formulas such as "MIN" and "MAX".

Criteria B - Design:
For this criteria, I designed a format for my tables and I also designed a logo for the company. I added a bit of simple color to make it aesthetically pleasing however I could have added more.

Criteria C - Planning:
To plan for this excel project, I typed and uploaded a basic plan of what I wanted to do on my blog. I could have gone more in detail by adding sources and references as to where I gathered my information from.

Criteria D - Create:
I have successfully met the criteria because I have created the excel sheet as instructed. I could have gone further by creating more than one sheet and completing every aspect of what was explained in my plan.

FURTHER IMPROVEMENTS:
Having reflected on my work, I have added an extra aspect to my plan and creation to go further than what was asked. I have added the worker's salary and commission in the supermarket as well as a graph to represent this new data. With this, I believe that I have successfully met all the criteria. 

Read More

Planning:

As my final term 3 task for creating a spreadsheet in Excel, I decided to use different functions that would be useful in a supermarket. My creation will be focused on a supermarket in England, Tesco, and it will include:

• Retailer stock database including a graph representation
• Worker's salary including commission
• A custom logo created through Adobe Photoshop 

I will be using one unfamiliar function that we have not yet learnt at school. It is used to count the total of the number of cells that are not empty as well as the number of arguments that contain values. You can use it to calculate the total of text items. In my project, I will be using it to total the variety of 'Poptart' brand products Tesco is selling which would prove helpful in the real world when creating stock/retail excel sheets.


The syntax for the counta function is:

=COUNTA( argument1, [argument2, ... argument_n] )

argument1, argument2, ... argument_n

Either ranges of cells or values. There can be up to 30 arguments.

Read More

Investigation task

Comfort's bills:

Surinder's bills:

Flossie's bills:

Read More

Project

 

Read More

excel sheets

Read More

TECH FAIR Inquiry

TECH FAIR PLAN:

Group:
I will be working with Seema, Aline and Kimiya.

IDEA 1:
A soundproofed personal theater booth with stop motion video.
The stop motion video will be played through bass speakers and we will allow people to test and try out the cinema booth itself. We will soundproof it through various methods and evaluate which works best, therefore merging computer technology with physics as well. Our research question will be: Which is the most convenient and reliable way of soundproofing a room? We will do this by finding a variety of ways to soundproof rooms and try to use as many ways and test them out all accordingly and make sure the testing of each method of soundproofing is valid and not bias or not carried out the same way each time. I felt this was a good idea because of the difficulty and experience of creating a large project that will take time and effort, also because I am curious to find out the best technique to soundproof rooms
This has not been created before so we would be the first ones to attempt this project, which makes it very interesting and exciting to create. With the layout of a photobooth and the pleasures of a cinema, it creates a great combination

Music Video
For this project we will create a lyric music video, using visual drawings to show the lyrics. The song is undecided at the moment, and the game is our first priority.

Software:
iMovie
Youtube converter

Hardware:
Laptop
Paper and other materials

IDEA 2:
GPS Application of DUBAI
This is by-far the most difficult that came to mind, but would be incredible and effective if put into action. It will be similar to the Google Maps application.GPS satellites circle the earth twice a day in a very precise orbit and transmit signal information to earth. GPS receivers take this information and use triangulation to calculate the user's exact location. Essentially, the GPS receiver compares the time a signal was transmitted by a satellite with the time it was received. The time difference tells the GPS receiver how far away the satellite is. Now, with distance measurements from a few more satellites, the receiver can determine the user's position and display it on the unit's electronic map.
A GPS receiver must be locked on to the signal of at least three satellites to calculate a 2D position (latitude and longitude) and track movement. With four or more satellites in view, the receiver can determine the user's 3D position (latitude, longitude and altitude). Once the user's position has been determined, the GPS unit can calculate other information, such as speed, bearing, track, trip distance, distance to destination, sunrise and sunset time and more.

Idea 3:

Innovative game based on EIS

Video Game

Seema, Kimiya, Aline and I are planning to create an rpg game of our school, or just any school. There will be quests and other things to do. The objective of the game is to collect 5 stamps from various teachers or students. Once you collect 5 stamps, you will be rewarded with chocolate given by one of our group members.
We will create custom tilesets and sprites for the game to make it a modern day school. We will all watch video tutorials from youtube to understand how the game works, and be fully informed and able to create the game. We were thinking of using the school computers so more than one person can play at a time.

Software:

Rpg maker vx ace
Ms paint

Roles:
Eman-  coding and event triggers
Aline- Poster, powerpoint presentation
Kimiya & Seema- Character and sprite creation/customization

Hardware:

Laptop

Video/resource:http://www.youtube.com/show/rpgmakervxacetutorials

Advantages:      It will be fun to make and we will be making a slideshow and probably a poster so the presentation will be appealing and it will be a fun game for anyone to play.

Disadvantages: We might not be able to be in a group of 4 which would be easier to make the presentation harder and it wont be as appealing if we were a 3

Cardboard box phone, if all else fails because it seemed simple and fun and will be a nice presentation, also to add with it we would make a poster about the history of telephones and have smaller models of them aside each other to spot the differences and in the end there will be a quiz although we are not sure about this idea it would be good if the game and the video doesn't work out. We won’t be using any software except for Power point Presentation and the hardware we will be using is Cardboard and paint etc.

Disadvantages: really simple, not that much technology involved

Read More

EMAIL ETIQUETTE

Read More