Week #8 – Excel SpreadsheeT

The task for this week

To create a grade book in Microsoft Office Excel.

·  To become familiar with the different features in Microsoft Office Excel.

·  To learn how to create a formula for finding the average of grades.

To complete the first task I had to:

1.   Open Microsoft Office Excel.

2.   Identify the names of the features below indicated by letters.  

Answer Key: 

A- File Tab       B- Undo Button   C- Cell Address          D- Ribbon Tab

E- Formula Bar   F- Title Bar       G- Column Heading    H-Vertical Scroll Bar

I- Status Bar     J- Sheet Tab       K- Row Heading     L- Cell Pointer

M- Horizontal Scroll Bar

My second task was to:

 Create a grade book with a heading of Student’s Name, Assignments and Grades total 

- Fill in the relevant information in each space provided

-Then highlight the entire content and right click

- When the options pop up, click on  'Format cells'                                  

                                                         

Then :

 Under the heading 'border' choose the type of border that you would prefer to use around the rows and columns.

- Repeat steps 3 and 4.

-Under the heading 'Font' choose a preferred colour & this changes the font colour.

-Repeat steps 3 and 4

-Under heading  Fill, choose a colour; this  will change the cell to the colour of your choice

Next was off to Averaging Spreadsheet

- Click the cell under the heading named 'Average'.

- Click fx in the Formula Bar

- Choose the option 'Average'

- Fill in the number of cells you want to average

 To complete the rest of the sheet without going through that long process, you can just drag down the first average cell.

Challenges

My challenges in completing this tasks is that I had difficulties in naming some of the features because was pretty new to me and maneuvering through  spreadsheet to complete all my tasks.

Overcoming my challenges

I stopped and ask my classmates for assistance whom explained it much better so I could have a better & clearer understanding and also I had to google some of the information.

The instructor also sent an excel tutorial on google docs which had some valid information  to complete tasks.

At the end of this week’s lesson, i’ve learnt a whole lot of interesting ways to formulate my grades and average  for my  grade book and classes. It was a great and learning experience for me , that when i get back into the classroom I can utilize this information and be better organised.