Day 27

Today we made the final touches on the manual such as table of contents, formatting, editing the header and placing a description under all the pictures in the manual.

Day 26

Due to some set backs, we will not be able to present on Monday 22nd July. Instead, we will be presenting on Monday 29th July.

Day 25

This week I started working on the presentation for Monday 22nd July. This presentation will take the form of a power point presentation.

The dress code I am still working on.

We are all coming in school tomorrow to complete our manual and begin our printing.

Day 24

This week we will be doing the "How to customize your tab" and doing all the short-cuts in Microsoft Excel version 2010.

Day 23

After reviewing some manuals, I have decided that we will do a "How to customize your ribbon" tutorial and a page filled with short cuts. This will take the work in which we have for week 6. I will divide the tasks up evenly and give it to everyone tomorrow morning. (Monday) 

-DRAFT-

Day 22

I am almost finished with the draft just putting on the final touches. It's quite time consuming I must say. I didn't expect to take this long finishing the draft. I am just glad to get it done though.

Day 21

Today is the day before the draft is due, I am currently trying to put on the final touches before I submit it to Ms. Lisa Wharwood. I hope we receive feedback from her within one (1) week so that we can make any changes in which she suggests. However, how I have formatted everything and the way I which I lead my group to execute the work, I am hoping that we have minimal changes.

Day 20

I am finished with the manual in terms of presentation. We will be submitting our first draft on Friday 12th July. I still need to know how Ms. L. Wharwood would like to receive the draft whether is be soft copy of hard copy.

Day 19

I have started working on the presentation, formatting and table of contents. Ensuring that the fonts are all the same size and font type with the exception of headings. I have started thinking about our second presentation on the 22nd and what approach I would take in terms of execution whether it be another power point presentation or some other creative form.

Day 18

So today we had out presentation, I was very nervous, but I managed through it! :D We got full marks (20/20).

Now we must resume to normal work and get our manual finished.

Day 17

Our presentation is ready. It was finished this morning as we had minor changes to make. I have already made the name tags and we have decided to dress formally for the presentation. My only concern is that we don't utilize the full 15 minutes which may cause us to loss marks.

Day 16

Yay! So I have finished my part of the project, and I'm doing the power-point presentation as well. Today it should be finished and I also have to remember to make the name tags. The dress code however has change since Miss told me on Tuesday that we don't have to wear a suite. instead we will all try to colour code out outfits so we can achieve some degree of formality as a group. I have no yet decided what colour we should wear.

Day 15

We are almost complete with our manual, we just need to finish out the work for this week and fix the presentation of it and submit a draft. The power-point presentation is coming along well, it entitles our time line, time frame in which we worked in, who was assigned the various tasks, how we explain everything and any difficulties in which we have had thus far. Most likely I will be in school on Friday doing some work for the manual to ensure that everything is finished on time.

Day 14

Today I have started doing the power-point presentation in which we have to do on July 1st. It will show how we got the tasks done, whom were given the tasks, what time frame we worked with and show how the wording of the manual is. It gives details as to some to the extra hours we put in after school. It shows an example of how it was done and the presentation in which it will be shown. I have start my week 3's work. I am trying to manage doing out my work for the manual and also getting the power-point done on time. Everyone in my group is required to dress professional, ladies a black skirt suite outfit with a white inner piece top and gentlemen a black soft pants with a white shirt and a black tie. Dress shoes and ballet flats. I still have to verify about the dress code with Ms. Lisa Wharwood. I will be making name tags for them as part of the presentation purposes. They will be given the final presentation either on Friday or Saturday in which I will be giving them flash cards with their parts as to what they have to say in the presentation. They are to read through the presentation and understand their parts well and be able to fully describe the part in which has been assigned to them. Hopefully we use all 15 minutes.

Day 13

Yesterday Ronel and I met in school to finish up the Formula tab. We started around 12 pm and finished 4 pm. We were able to complete out the Formula tab as well as begin our tasks for week 3. So far everyone has met their deadlines and we are able to submit a draft in a bit sooner than we expected, which is a great thing.

Day 12

During this week I was able to complete the two tasks in which I was given.

-Formula (Week 2: 17th - 23rd)
- Data (Week 2: 17th - 23rd)

Everyone has been able to meet all the deadlines and all the meetings. I am very pleased with my group. We work well together as we understand all the tasks clearly and all agree on the due dates of work. We don;t mind staying back extra hours after school to complete the work out to ensure that we are not running behind on our time line as we still have other plans for the manual.

Day 11

On Tuesday we all stayed back after school to start the Formula tab. I have also started my work for the week. It is all coming along quite well. I may finish it out by Monday however. I have also started doing the power point presentation in which we have on do on Monday 1st July, 2013.

Day 10

Today I have started working on the Data tab. I have not yet started on the Formula tab since we are doing that tab together as a group as it is a lot to do and one person cannot do out the entire tab by oneself. This therefore has caused that we do it as a group to divide the work evenly. We will be staying back tomorrow (Tuesday 18th June) after school hours to at least start the work since we have a holiday the next day. We will all start it as a group and we will divide the tasks up evenly to have it completed at the end of the week. I'm not sure if we would be able to finish all of this within the week but we hope we do.

Day 9

Thankfully my tasks for the week are done. I have finished a little before time. I have decided to take this day however to check over for any grammatical errors and ask my mother to follow the steps in which I have made for the users to follow to get the tasks done. I have chosen my mother because she not quite familiar with using a computer and she can help me as to where she does not quite understand and help me re-phrase the wording of the step. This will allow the manual to be clearer and give the end user a better understanding of the steps. I do hope the steps are easy to follow as it took quite some time to explain how to get the task done since I am accustom to using MS Excel, so I tried to put myself as a user who doesn't know how to use the application and not familiar with using a computer on the whole. I will be starting my set of work for week 2 tomorrow.

Day 8

By the looks of it I will be finished with my part of the assignment for week 1 on time! :D I hope my other group members are making good progress and getting through with all their work for the project. Indeed it is a lot but it is do-able. The print screen are taking long to complete, as it requires me to indicate where certain things are so that the user doesn't get confused and feel baffled by everything they will be seeing on the screen. I try to make the steps as short as possible and clear and concise. Some things require some explanation.

Day 7

I have started my part of the project and it is doing well so far. There are a lot of pictures and I never knew that it would have been such a challenge to write a manual. You need to pay attention to details and ensure that the steps are short, clear and precise. My work will be finished by Friday 14th June,2013 in which I will start my week 2 work to ensure I have completed my work on time and help other members in my group who may have difficulty in doing their part of the assignment.

Day 6

Below shows the list of tasks in which I must complete.

-File (Week 1: 10th - 15th)
-Formulas (Week 2: 17th- 23rd)
-Data (Week 2: 17th- 23rd)
-Team (Week 3: 24th- 30th)

Important dates to remember:
1st July - Presentation (15 mins)
12th July - Draft
22nd July - Group presentation
26th July - Project due

Day 5

Timeline -DRAFT- for week 1. (10th June-15th June)
24 Basic tasks.
Basics-Introduction.

Must show step by step process of how the task was accomplished as well as the short cut version on getting the task done. Print screens of everything done must be included as well as print screens of the short cut version as well. One (1) week is given to complete the tasks.

Tasks are to be divided up between Kenny, Ronel, Cherrise and myself.
Six (6) tasks per person.
List of tasks:
1. Printing.
2. Copy & Paste.
3. Selecting multiple data.
4. Moving data.
5. Entering data.
6. Editing existing data.
7. Copy & Pasting data.
8. Undoing mistakes.
9. Undoing multiple at once.
10. Redoing an action.
11. Redoing multiple actions at once.
12. Saving your document.
13. The Save button.
14. Inserting columns.
15. Inserting rows.
16. Deleting columns.
17. Deleting rows.
18. Resizing columns.
19. Resizing rows.
20. Changing font text.
21. Changing font size.
22. Changing font colour.
23. Changing font style.
24. Changing cell alignment.

Day 4

The list below are some of the things in which we must include in our manual:

-File button
-Printing
-Copy and Paste
-Protected View
-Spark-lines
-The quick access tool-bar
-Spreadsheets
-Workbooks
-Locating active cell
-Changing the active cell
-Identifying the active cell
-Selecting multiple cells
-Moving data
-Entering data
-Editing existing data
-Copy and Paste data
-Undoing mistakes
-Undoing multiple mistakes at once
-Redoing an action
-Redoing multiple actions
-Saving your document
-The save button
-Inserting columns
-Inserting rows
-Deleting columns
-Deleting rows
-Resizing columns
-Resizing rows
-Merging cells
-Wrapping text
-Calculating a sum
-Using AutoSum
-Calculating other functions with the AutoSum button
-Constructing your own formula
-MAX function
-MIN function
-How to create charts
-How to change the colour of your chart/ graph
-Customizing your ribbon
-References to other worksheets
-Changing the font text
-Changing the font size
-Changing the style of the text
-Changing the colour of the text
-Adding a cell boarder
-Applying a background colour
-Changing the cell alignment
-Excel help button
-Cell style
-Finding the average
-Copying a formula
-Referencing cells in your formula
-Relative references
-Absolute references
-Mixed references

Some more is be added maybe tomorrow however this is the majority of what Excel can do.

Day 3

Today I looked at MS Excel version 2010 again and noted some more of the features it possess. A list of additional features continuing from my older post (Day 1) is listed below:

- The width of a cell can be adjusted to your likeliness. It can be expanded to the length in which you need  
   your cell to be.
- There is a "Find and Select" feature available that allows you to "Find" text in which you are looking for. It
   will scan the document and highlight the possible answers.
- The "Select" feature will "select" the text and can replace the text for you without you having to scan
   through the document manually and replace it.
- You can format a table with the cells.
- You can change the style of the cells.
- There is a feature that allows you to remove duplicates within the document. This will automatically be done
   once you select this feature and enter the range of cells in which you don't want any duplicates to be
   present.
- There is a feature that allows you to check the accuracy of data. It will circle invalid data for you
   automatically.
- You can sort your work as you please either from ascending order or descending order.
- You can now get a subtotal of your work if you wish by selecting the "Subtotal" feature. Once you select
   the cell range the software will automatically calculate the subtotal for you without the use of a formula.
- Pictures, clip art and shapes can be inserted.
- A background can also be added.
- Page breaks are now available.
- You can protect your sheet or workbook by selecting the feature.
- You can share you workbook if you wish too.
- You can filter the uses whom has access to your workbook.
- You can track any changes in which someone made to your workbook.
- You can now allow users to edit the ranges of data in your workbook.

Some of the other features will be discussed tomorrow. The time line is on its way to being finished. Its not quite yet done however, we are in the process of it. We are trying to assign tasks equally and fairly to everyone.

Day 2

I have started doing the time line today however its taking a little long than I expected since there is so much detail to en -corporate into the project. The time line with span across a 5 week period where everyone will be given a specific task to complete and a time frame to complete such task. If one of the group members fail  to meet the deadline given, it will noted and the rest of the group members will split the task equally amongst themselves. Apart from the 5 week period, 1 week will be assigned to fixing any grammatical errors, presentation, order of work and table of contents etc. I hope to meet the deadline for the time line. Once it is completed, I will upload a copy of it for you to see where I would indicate the task at hand, the group member who is doing it and the expected deadline in which they must try to meet.

Day 1

Today (3rd June, 2013) I looked at some of the aspects of MS Excel (version 2010) and I noted some of the features below:

- You can create charts, graphs, bar graphs, pie charts etc in MS Excel.
- MS Excel can preform mathematical equations such as: addition, subtraction, division and multiplication.
- There is an "Auto-sum" feature that allows the application to automatically add a selected range of fields
   highlighted.
- Columns/Rows can be added and / or deleted quickly.
- Orientation of the page layout can be changed to your needs.
- The font size, type and colour can be changed according to your preference.
- Text boxes can be easily and quickly added.
- Size, orientation, margins and the background of the page can be changed as well.
- Data from other MS applications can be added to a MS Excel document such as MS Access, from the
  Web and other sources.
- You are able to view your work before printing.

I have started to create the time line. It should be finished by Friday 8th June, 2013.
Some more of the features will be looked at tomorrow.