Integrated Excel task

As you have already seen, Excel is a very useful program since you can create databases and manage
record of the activities you carry out, but not only that, it also has the option to combine your
information to insert formulas, graphs, diagrams. In this task you will apply everything you have seen so far
this moment in this course.
The objective of the task is for you to apply the commands involved in the File, Format, Insert, and View menus.
To do this, you will prepare a grade report for your course. You must consider the following:
o Module 1 accounts for 10% of the final grade.
o Module 2 accounts for 20% of the final grade.
o Module 3 accounts for 20% of the final grade.
o The final exam is worth 50% of the final grade.

Instructions
1. Open ExcelView animation open_excel 3.
2. Save your document with the name grade-list in the path: My documents/Folder with
your name
3. Change the name of Sheet 1 to: Presentation.
4. Change the name of sheet 2 to: Students.
5. Change the name of sheet 3 to: Grades.
6. Position yourself on the sheet: Presentation.

7. Position yourself on cell B4, write: Introduction to Computing.

8. Position yourself over cell B6, write the date.
9. Position yourself on cell B8, write: Virtual University of the State of Guanajuato.
10. Position yourself on cell B10, write: Bachelor's degree in Administration.
11. Position yourself over cell B12, write your name.
12. Position yourself over cell D14, write: Students.
13. Position yourself over cell F14, write: Grades.
14. Position yourself over cell H14, write: Graph.

15. Select from cell B4 to cell J4 and press the Merge and Center )button.
16. Select from cell B6 to cell J6 and press the Merge and Center button.
17. Select from cell B8 to cell J8 and press the Merge and Center button.
18. Select from cell B10 to cell J10 and press the Merge and Center button.
19. Select from cell B12 to cell J12 and press the Merge and Center button.
20. Select from cell B4 to cell J14.
21. Format the text. Font: MS Sans Serif, size: 14, bold, text color: indigo.
22. Select the entire sheet and change the background color to white.
23. Position yourself on the Students sheet.

24. Position yourself on cell B2, write: Number

25. Position yourself over cell C2, write: Name
26. Position yourself over cell D2, write: A. Paterno
27. Position yourself over cell E2, write: A. Maternal
28. Position yourself over cell B3, type: 1
29. Position yourself on cell B4, type: 2
 30. You are going to auto-fill the numbering and to do so, do the following:

o Select cells B3 and B4.

o Place your cursor in the bottom corner of cell B4.

o Your cursor will change to a cross like the following:

o Click in the corner without releasing and drag. You will see a box with numbers appear.
drag to cell [Link] auto-fill animation.
o Now start filling in the students' data, you should have 15 records.

o Select from cell B2 to cell E17.

o Click on the Borders button, select the All Borders option.

o Save your document.

Save your document.

1. (a) Position yourself on the sheet: Grades.

2. (b) Position yourself on cell B2, write: Number

3. (c) Go to cell C2, write: Name

4. (d) Position yourself over cell D2, write: Last Name

5. (e) Position yourself over cell E2, type: Module 1

6. (f)Position yourself over cell F2, type: Module 2

7. (g) Position yourself over cell G2, write: Module 3

8. Position yourself over cell H2, write: Final

9. (i) Position yourself on cell I2, write: Average

10.(j) Position yourself on cell E3, type: 10; select the % button
) from your Bar
format tools.
11.(k) Position yourself on cell F3, type:20; select the % button from your toolbar.
format.
12.(l) Position yourself on cell G3, type: 20; select the % button from your toolbar.
format.
13.(m) Position yourself over cell H3, write:50; select the % button from your Toolbar.
format.
14.(n)Position yourself over cell I3, type:100; select the % button from your toolbar.
format.
15.(o) Select from cell B2 to cell I3.
 16.(p)Format the text. FontType: Tahoma; size: 11, Bold.
17. (q) Click on the Justify center button.
18.(r)Click on the Borders button, select the option: No border
Change the background color: Indigo
20.(t)Change text color: White
21. (u) Position yourself over cell B4, write: 1

22.(v) Position yourself over cell B5, write: 2

23. (w) You are going to auto-fill the numbering and to do so, do the following:

24. (x) Select cell B4 and B5.

25.(y)Place your cursor in the bottom corner of cell B5. Your cursor will change to a cross like the

next:
26. Click in the corner without releasing and drag. You will see a box with numbers, drag until

cell B17. See auto-fill animation

1. You already have the name and surname of each of them on the student sheet.
In the case of requalifications, the first and last name of each one is requested again. To avoid writing it again.
the data, you will bring the information from the "students" sheet to the "grades" sheet; to learn the
way to do it watch the following animation:pull-info animation.
2. (bb) Position yourself over cell C4, press the = sign on your keyboard. Then, click on the sheet
"students" and select the first name; in this case Lucero(B3), then press the Enter key.
(intro).
3. Place yourself on cell D4, press the = sign on your keyboard. Then, click on the sheet
"students" and select the first name, in this case Lucero (C3), then press the Enter key.
(intro)
4. (dd) Position yourself on cell C5, press the = sign on your keyboard. Then, click on the sheet.
"students" and select the first name in this case Lucero (B4), then press the Enter key.
(intro).
5. (ee)Position yourself over cell D5, press the = sign on your keyboard. Then, click on the sheet.
"students" and select the first name, in this case Lucero (C4), then press the Enter key

6. From your "grades" sheet, select the cells C5 and D5.

7. Position your cursor in the bottom corner of cell D5. Your cursor will change to a cross like the

next:
8. (hh) Click in the corner and hold, then drag. You will see a box with numbers, drag it.
up to cell [Link] auto-filling animation

Save your document.

o Begin filling in the grades for Modules 1, 2, 3, and the final for each student.
 o From here, we will begin to work with formulas. When you structure a formula
mathematically, you have a parenthesis assignment to separate and give priority to the
operations: in Excel it works the same. Now you are going to calculate the overall average of each student;
do the following: SeeAnimation formula-grades.

o Select cell I4 and write: =(E4*0.1)+(F4*0.2)+(G4*0.2)+(H4*0.5)

The sign = indicates that an operation will be performed and a result will be displayed in the cell.
In (E4*.10) you are multiplying the grade of module 1 by 10%, which is what it is worth of the final average.
The + sign indicates that you will also add what is inside.
In (F4*0.2) you are multiplying the grade of module 2 by the 20% that it represents of the final average.
The sign + indicates that you are also going to add what is inside.
In (G4*0.2) you are multiplying the grade of module 3 by the 20% that is what it is worth of the final average.
The + sign indicates that you will also add what is inside.
In (H4*0.5) you are multiplying the final exam grade by 50%, which is what it is worth in the average.
final.
Now perform these operations just as you saw in the animation:

o Position yourself over cell I5 and write: =(E5*0.1)+(F5*0.2)+(G5*0.2)+(H5*0.5)

o Select cells I4 and I5.

o Place your cursor in the bottom corner of cell I5. Your cursor will change to a cross like this
next:

o Click in the corner without releasing and drag. You will see a box with numbers, drag it.
up to cell I17.

o Save your document.

o You have already seen the animations of each of the commands in the Insert menu. Now in your
the document adds the following:
o Insert a cell.

o Insert a row.

o Insert a column.

o In the 'presentation' sheet, insert a symbol, a predefined image, and an image.

from file, Insert a hyperlink.
o In the 'students' sheet, insert an image, a shape, and a WordArt.

o In the 'grades' sheet, insert an image, a shape, a WordArt. Insert the

averageFunction. Insert a diagram and insert a chart (see animation insert-chart2).

Each sheet must be configured with the following

characteristics:
o Orientation: Horizontal.

o Paper size: A4

o Top margin: 3 cm.

o Right margin 1.5 cm.

o Bottom margin: 3 cm.

o Left margin: 1.5cm.

Each page must have the following header and footer

page:
o Insert a header that contains: your name and the time.

o Insert a footer that includes: the page number.

o Save the changes you have made.

o Click on the File menu and select the Exit option.

o You can see an example of how your Excel file may look by opening the
readingSupport - Integrated Excel Task, which is found in the contextual menu,
right of your screen.

o As a final step, send your file to your advisor through the link Task 2. Task
Excel integrator located in the contextual menu, in the Resources section that is in
the right side of your screen.

Remember to check the evaluation criteria in the same section where you will submit your
file.