Introduction to Spreadsheets

Introduction to spreadsheet

What is a spreadsheet? 

A spreadsheet is an electronic grid that is used to arrange date and sometimes also numerical information, spreadsheets include many rows and columns where you inserts your needed data.What spreadsheets do is that it helps you to make that easier for yourself to record data and in certain situations calculate certain problems or sometimes even data.Most of the people use it for business, financial reasons and also sometimes for surveys or other needs in their daily lives.Spreadsheets have many types of uses people can use it also fro certain projects that students can use it in to be able to record information, calculate problems and many other things.Lastly many different jobs use spreadsheets as their daily life which makes it a common thing that adults use.

What are the various types of spreadsheets? 

There are various types of spreadsheets that people use. Some of the types that are available are like Microsoft excel, Google sheets, Open office calc, VisiCalc, Lotus 1-2-3, Numbers, Quattro pro, Gnumeric, Multiplan, Luibre office, Super Calc, Calligra sheets, Lotus Improv, Infromix Wingz, GNU Oleo, Sheetsster, RExcel, Boeing Calc and finally 3D Calc.All these types of spreadsheets include most of the main features that are commonly used in almost all types of spreadsheets as they all have the same function however some different spreadsheets may include extra features that are not included in every spreadsheet  

Who would use spreadsheets?

There actually many different people that may use spreadsheets however it is mainly used by adults rather than kids as kids or teenagers may not necessarily need it in school as much as adults in their jobs.Some of the people that use spreadsheets would be accountants, the reason they would use them is that they will always need to calculate money that is coming in and even profits for the staff in the business but also as a service for someone else.Another person that can use them are teachers, the way they can use them is that they may need it to keep record of students, their marks and also their homework.Other people that can also use them are engineers as the need to calculate many numerical data as their jobs include a lot  of mathematics as they need to design different projects according to measurements and many other features. Next are sales people as most of their tasks and jobs are based on finance which causes them to deal eight many numerical data in terms o felling and buying too.Other people that also use spreadsheets are scientists ad they perform lots of experiments and always need to record different results to use for research and for studies that they necessarily need as a main peer of their job.

How is it beneficial to students, adults and businesses?

There are many different ways that spreadsheets are beneficial to students and adults however, it is more useful and generally beneficial to adults that work.The reason for so is that it ism required for adults in jobs a little bit more than students in a school as they are still in school and being in a school does not really require much use of spreadsheets as we (as students) do not meet as much situations where we need to use spreadsheets as much as adults use it in their daily lives but students still need it in school for certain subjects that we study.The first reason it is beneficial to adults is that in a job like engineering it requires lots of measuring and calculating  data and measurements for them to be able to create building projects and create a design for the project they are creating.A way it can also be useful to an adult is that if the adult works in finance or even any kind of business they usually deal with many calculation and especially in finance they deal with a lot of money calculations as calculating money is one of the most main things you have to do in finance especially if you work in a bank.So for adults it is beneficial for them as it helps them in their daily lives in their jobs however in certain fields more than the others.For students one of the reasons it is beneficial for them os that there are certain subjects that they study where they would need it.One of these subjects are science, the way it is beneficial is that when the student performs and experiment they then have to record data and calculate results so spreadsheets will help them so then they can calculate and record data easily.The second subject that makes spreadsheets helpful for them is maths as sometimes in certain topics in maths like probability where they actually perform experiments and record numerical results so using spreadsheets may help them record data and also calculate results from their experiment.

What is the Global Context?

I believe that the global text for this topic would be scientific and technological developments.The reason I believe so is that as we are studying excel spreadsheet the software itself was a technological development created for our society to use today.Another reason is that using the creation of spreadsheets many developments are mad to our digital society due to spreadsheets and one of it are scientific developments too.

ATL skills you would require for this topic?

The first ATL skill I will choose for this topic is Communication.The reason I believe so is that as we study spreadsheets we will be suing it to record data and to perform different calculation and also we will have to communicate data and ewsults through it which gives us the need to use communication.The second ATL skill I will include is research skills.The reason I chose this is that we will be needing lots of research as we will need to learn more about spreadsheets through this topic.My final ATL skill is Collaboration.The reason I chose this is that I believe the in certain situations of any of us need help we will need to collaborate to be able to learn.

Research on 10 features of spreadsheets and take screen shots of what you learnt?

Here are 10 features that I learn about spreadsheets 

Numbers-These  numbers are out on a spread to be able to represent the rows so then when you use spreadsheets you may be able to easily identify them 

Alphabet-These letters from the alphabet are put to represent the columns so when you use it you can easily identify the columns

Formula Bar-This is where it shows you what you have out into your selected cell, you can also use it to type what you want in the selected cell

Cell address-This tells you which cell you are selecting at the time and the address of the cell that you are selecting.

Cell-A cell is one of the squares in the spreadsheet grid where you can insert anything you would like

Quick toolbar-The quick toolbar is where you have a quick access to certain options like undo and redo and some several other options

Drag and fill handle-This is on the cell and is used to increase the amount of cells selected or to fill in a cell

Worksheet tabs-This is a small line that is on the bottom however not the lowest line and it tells you which sheet you are on 

Status bar-This is the lowest bar on the page, this holds different options like zooming and many other control for the spreadsheet.

File name-This allows you to be able to identify which excel sheet this is and it is set in the title bar on the top of the page

Here are additional five things that I have also learnt:

Conditional formating:

Sort and Filter:

Header:

View-Showing format box:

AutoSum:

Watch window

Arrange windows:

Freeze panes:

Zoom 100%:

Options for selected cells:

I have managed to learn 20 features from Excel until now.I have a variety of different features I have simple formats and complex formats.Another subject I believe this would be useful in is science as we conduct many experiments and we ca  use this to take down our results.The way to will help is that it will make it easier for us to out the data into a table or a graph  for our results.I believe I have used my time wisely as I was able to use excel in a more advance way now as I was able to learn many features that can help me use it in amore advance way that can help me use it in a correct way to enable me to use it well.To conclude I have learnt a lot of features that will enable me to improve my skills in excel to make myself better at using excel to be bale to use it well.

Criteria D reflection

Criteria D reflection ICT:

This tech fair my partner Kiyara  have worked on creating Webtoons which are online comics that are originated from Korea.We decided for our Webtoons to be based on daily school days and their different happenings.I believe that our project is actually a very good tech fair project, a reason I believe so is that were able to successfully use technology in a correct ad proper manner, we were able to use it when we used the Wacom Intuos ( a device used to display whatever you draw on that board onto a laptop) to be able to draw it onto a software ( in this case Autodesk) on my laptop and iPad  for us to be able to create our comics.I believe that the end results were good and that we were able to complete them successfully and overall I believe that it is a very good project but could use some improvements in terms of artistic techniques however in general for the whole project it is very good and the final are quite good and much better than what I expected but it could still use some improvements.

For this project we had a targeted audience which was 9-13 year olds as they would have been able to experience the happenings used in the comics as me and my partner basically based the comic on our daily experiences in school.I believe that it is actually beneficial for this audience as they are not very old for it, one way that this is useful is that maybe inspire some other children in that age to make Webtoons like these as a hobby or just for their desire.It could also help them as sometimes people in school in that age could dislike school and that may lead to other issues this comic can help them as maybe it can help them think off school with a different perspective maybe in a more positive or funnier which can help them look at school in a different and better way.Those are two ways that it can be useful and helpful to our chosen targeted audience.

For this project I believe we were able to complete and compose it successfully and correctly and that the end we were able to have a good end result that is very good but could still be improved.For this project I believe a suitable grade for the project overall would be an 8 or 7 out of 10, the reason I would give us that mark is that the final result was very good however I believe that I could have improved in my artistic skills and maybe I could have improved in terms of using color.For Kiyara I believe that she did extremely well and her use of color was very good but she could still use a much smaller amount of improvement than me.So I believe that the mark would be 8 out of 10 due to the amount of effort we put, the use of technology we had and our artistic skills.

As for the tech fair we would love to be in the fair as it is something incredibly honorable  to be able to be chosen in the fair.I believe that our project is worthy to enter the fair but also not extremely worthy.I think it is worthy because it is a good project overall and we were able to successfully cooperate art and technology together to create and compose this project.the second reason I believe it is worthy is that it is a useful and entertaining project that could affect the audience well.A reason why I think it may no be worthy is that it is not a very high quality project.

Peer evaluation ICT Tech Fair presentations

Peer assessment

The first group that presented yesterday was Ananya and Rania, their project was a VR headset What they did was that they printed the layout of the headset, stuck onto cardboard and then cut it out to create the headset. For the video, they downloaded a software where they can take screenshots to create a video.In their presentation, they fully explained their project well with all details.They were able to explain how it is made, what are its purposes and the different features included in the project itself.They were also able to show us how they created it themselves and not just that but also they were able to show us how the product actually works and also the final result of the project they created.Other than that they were also able to give us a descriptive and detailed description of what the project is, how it works, the materials used in it and how they were able to use technology for it.I believe their overall presentation was very good however maybe they could have tried to have more communication that may be could be more informative.I think their project is very good however, I don't really find it useful towards the society.

Another project that presented was done by Karim his project, was also a VR headset except Karim created his one movie that is around 25 mins long.His movie was created totally by himself, he created his ow work on Minecraft.On Minecraft, he used the different features to create a full work with many different objects that were set according to his persona desire of choices for objects to create.In his presentation, he presented to us the project in its final stage.He showed us a small video that was a part of the whole movie that showed the camera shown different perspectives of his world.Karim was able to describe all the different features of it and was also able to give us a detailed description of what it is, what were the steps he used and many other details about the project.I believe that Karim’s presentation was very clear and he was also able to informative and project his voice well.One thing I believe he can improve is maybe to add one or two more details like her it is targeted at and how it is useful.I really like his work, however, the only thing that I think should have been thought about was if it is useful in any kind of way but it can be useful as it ma inspires people to use regular software to create something very interesting.

Another project that also presented was made by Ward and Malak, their project is a photo shoot.What they created was that a photo border for people to take pictures using backgrounds and props that they will get.For the backgrounds, they will be using software to create the backgrounds fro people to ba able ton choose a background and have I at the back of them so that they can then use backgrounds when taking a picture with the background of their desire through a software that they will be using.Ward and Malak were able to give a good description with most of their features.I am; give their presentation was good, however, I think the still could have improved in term of communication as they didi not speak too much and did not give much information that would help us be informed fully about the project.Something I think they can improve is that maybe they can show us their very final result next time and also share with us some more information about it.I think it is a very nice project but not very beneficial however it is till beneficial in the way that it could entertain and provide people services in celebrations.

The next day more people presented their projects:

One of the groups that presented were Akshansh and Davide.Their project is a maze rover, this rover was made by the both of them however they used a kit with instructions to be able to build and compose the object but they were still able to independently program the object (rover) and also build the maze using cardboard and tape to build the maze 3D on the floor for people to be able to use it.They were able to give us a very good description of their project.with all the details to describe their project.They were successfully able to describe how it is made, how it is programmed and many other informative details about their projects.I believe their presentation and project were both very good but could still have used some improvements on it.Something they can improve is maybe they should be able to project their voices a little higher for us to hear them a little better and understand them a little better and maybe they can add a little comer details next time.

The next group that presented was Imaan and Gunce su, their project was paper speakers.Their project uses cables/wires and paper to be able to take music and project it with a louder sound.I think their presentation was okay but not very good as I could not really hear them or comprehend them as the handwriting on their slideshow/video was quite small which prevented me from being able to read any of the text on the slides/video.The described their project however it was not very clear and did not include many details and was not that informative so I was actually unable to know any details about their project and when they tried it it was notary successful but when they tried it a second time it didi not work but not well.Their presentation was okay but I was unable to understand much from it.For their project, I think it was good however when they tried doing it did not go very well.I think something they ca improve their presentation I maybe they should make a more detailed description for us to comprehend a little better and for us to be able to know more details about the project.

Another group that also presented was Ashkan and Arthur.Their project was the world that they created a game on their computer.It mainly involved them drawing animals and dinosaurs which as they mentioned was something that they enjoyed which allowed their project to be something fun for them.I think their presentation was good but not very good as they did not give much clear information about the project but could give a somewhat description of it, also their poster was quite unclear and hard to understand a little but I believe that their general project is really good however they need to improve their presentation and their communication skills with the audience.I believe maybe something that they can add to their presentation next time would be extra points about the project and maybe they should give a more detailed description and make a more clear poster for us to be able to understand.

Tech fair 2017 - Webtoon by Kiyara and Monica 8DD Peer evaluation

Criteria C

Here is an image of an action plan that we created and in each lesson we would tick if we finshed the task that we set for ourselves or not.We would record the duration, the materials we needed, what we would do in each lesson and lastly the date.

Here are some images of me and my partner Kiyara completing the project during the lessons and also an image of our comics through the process.