Reflection Week 7

Using Excel to Create Grade Book

In class today we got and activity 

A- File Menu

B-undo

C-Name Box

D-page layout

E-Formular Bar

F-Title Bar

G- Colum Heading

H-Vertical Strool bar

I- Mode Indicator

J-Sheets Tab

K-row heading 

L-cell pointer

M- Horizontal Stroll Bar

Open Microsoft Excel

Create Heading Merge and Centre A-E

Click Enter the type 1-6 going doing down

Highlight entre table and apply border

Highlight and select all border 

Coloum B put insert  Names of colour

Coloum C Names of Palces

Name sheet  Activity 1 and Activity 2 

Creating a simlple gradebook in Excel

1. Open a new Excel file. Make six columns heading for students name and the graded assignment in your course
2. Format cell in row by clicking in 1 and highlighting the cell you'll be working with in the first row.  right click and select the changes you want you may bold the font and change colour
3. Make all column heading visible adjust the column by clicking into top corner square, click on a border between a column this will adjust all columns
4. Enter the names and grade. Add a column for Average
5. Select the first cell in the average coloum Then click the fx key.
6. a pop up box will open select "statistic " in the first box and then choose average in the second. the click OK.
7. A second box will pop up titled" function argument" , Highlight the cells you'll be doing the average on in the first row then click OK.
8. Auto fill the formula to the remaining cells. By dragging the curser at the right edge of the first cell right down to the last cell
9. fill in the students name and grade and excel will automatically calcute the averages

Activity  #3 

Challenges

For the activity i was a bit puzzle since i wasn't familiar with using excel i didn't no most of the and answer but how ever google assisted me. Following the step by step instruction to create a grade it made it easier to work with. 

I will certainly be using excel in the future to calculate and record my class grades. Its easier and more effective than manually writing and calculating my grade in an actual book. Its also better for  record keeping purposes