Saturday, 6 June 2015

END OF YEAR REFLECTION

Term 1 - Sportsgear Magazine:

During the course of term 1, I inquired about sports gear and magazine/brochure types. I settled with an armband which would be featured on a magazine after the design task. I think that my inquiry and design work was very detailed and well supported with information. I documented every step I took to plan my final creation task and it had reflections, varieties, links, pictures etc. For the creation, I used photoshop adobe to layer pictures that I had found and finally, place it on the magazine cover of an athlete that I had created as well. I was quite happy with this work but I felt as though I didn't do my creation as well as I could have. The layering was slightly off in one section as it was obvious. However, in general, I feel that I did a good job as I posted all the parts needed, and to improve, I need to work on my photoshop skill as the layering was not correctly placed. 



Term 2 - Tech Fair Unit

This unit was my favourite as I had the opportunity to create a project with my friends to showcase our work. The inquiry section was very detailed and I included pictures and demonstrations. I worked with Seema, Eman and Aline to create a detailed map of the school with pinpoints to show the classrooms. When the mouse skims over each pinpoint, a picture of the classroom with the teacher and room number appears. Even though it was quite simple to create, we needed several people as it was a long process to take the pictures, insert them, and to create and paint an arcade box to bring attention to our project. It also had an excellent real life application as new students who do not know where the rooms are can easily access the map using a link. Also, this was a major success as Mr.Burgess used our map to show the KHDA representatives here for the inspection around our school. I am very happy with my work for this term as it was very successful and useful to our community. To improve, I could also add the basement as we did not have enough time to complete this floor. 



Term 3 - Excel Spreadsheets

This term was based on learning several functions from Ms.Shalini and creating spreadsheets. As our inquiry task, we were provided with 4 spreadsheets and we had to apply the formulas and functions to it. This prepared me to create my own spreadsheet, which calculates different thing at an art store. This unit is very useful as the functions will help us later in life as well. I think my final creation in very successful as it includes many aspects and functions. I also used 2 extra functions, one of them is the rank function and the other is conditional formating. Overall, I'm very happy with my work for this unit as I think my work was done to the best of my ability. To improve, I need to add more of my own functions that I find by research.


FORMULA VIEW OF EXCEL CREATION

Checkout counter for customers:





Stock Database (including graph representation)




Worker's Salary (sum of fixed salary and commission):


Thursday, 4 June 2015

TERM 3 EXCEL SPREADSHEET CREATION



  • Checkout counter for customers: 





  • Stock Database (including graph representation)





  • Worker's salary (sum of fixed salary and commission)




Wednesday, 3 June 2015

PLANNING CREATION TASK

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

  • Retailer stock database including a graph representation
  • Art store checkout of a customer
  • Worker's salary including commission
I will be using one unfamiliar function that we have not yet learnt at school. It is used to rank values in a desired order, ascending or descending. 

The syntax for the rank function is:
 RANK (number, array, [order])


Meanings:

Number: The number to find the rank for.
Array: A range of numbers to use for ranking purposes
Order: It specifies how to rank the numbers, but it is only optional
  • Order = 0 means descending order
  • Order = not 0 means ascending order

Saturday, 9 May 2015

Investigation Task- Excel Spreadsheet

FLOSSIE'S BILLS






SURINDER'S BILLS:






COMFORT'S BILLS






MY BILLS






FINAL PRODUCT