WEEK TWO - OFFICE APPLICATIONS

LECTURE

Today's lecture explained different applications there are in a PC and task that these applications help us with. The skills that we need to preform these tasks are as follows,
Microsoft Word
Microsoft Excel
Microsoft Power Point
We learnt the importance of them and what they are used for.

We were also intorduced to many other applications such as Windows Media Player, Photo Shop and paint. These programs are used for many different things. To name a few, playing and editing music, playing videos and editing photos.

Internet browsers and search engines were also introduced to us in this lecture.

Overall the lecture outlined the tasks and applications we need to help throughout this course.

WORD EXERCISE

Todays task required us to copy text from black board, then we had to follow instructions to change the text.

The tasks are as follows:
Adjust the type face
Adjust the margins and alignment
Adjust line spacing
Create headings
Keep heading with text
Include a header/footer
A online tutorial call 'Using Microsoft Word' was provided which went into detail how the different functions in word work.

*

The second task in the Word exercises was to copy and paste references and alphabetise them.

*

The last task we were required to do in word was create a table of contents using the reference option and selecting 'table of contents'

*

EXCEL EXERCISES

Today we were required to use Microsoft excel to create a chart on the hours we spend doing various activities each day. We had a template to follow which required us to use different functions in Excel. We had to fill some cells with colour, border the chart with a variety of different boarders and centre align all the text.

Once the chart was completed formulas needed to be created for the two total cells and the average cells. There is a icon on the tool bar called 'SUM', this is what creates the formulas for your spread sheet. Once the 'SUM' button has been selected the cells which are to be involved in the equation will need to be entered. Once the formula has been set it can be copied along the row or down the column by dragging the boarder to the last cell in the chart.

*

From the chart we can create a pie graph showing average hours spent on each activity during the week. Another chart was created only showing the average hours spent on each activity. The chart is then highlighted and the graph option is selected followed by pie chart, specificall 2D. The graph was finished once a title and borders had been added. The same steps were followed to create a column graph on the hours spent socialising every day.

*