Text Box:  
 

 

Microsoft Excel Chapter 1

 

 

 

Topics to be covered in this chapter include:

 

·        Looking at some of the basic formatting features of Excel.

·        Distinguishing between Landscape and Portrait page orientation.

·        Creating a spreadsheet.

·        Opening/saving a spreadsheet.

·        Inserting and deleting rows and columns in a spreadsheet.

·        Using the Average function.

·        Using the Autosum function.

 

 

 

 Table of Contents:

 

Individual Projects:

 

 

 

Excel Chapter 1 Project 1 –Get to Know Excel

 

 

Excel Chapter 1 Project 2 –College Students

 

 

Excel Chapter 1 Project 3 –Working with Sheets

 

 

Excel Chapter 1 Project 4 – All in the Family

 

 

Excel Chapter 1 Project 5 –Purely Leisure

 

 

Excel Chapter 1 Project 6 –Getting Acquainted

 

Excel Chapter 1 Project 7 –Down on the Farm

 

Excel Chapter 1 Project 8 –Test Time

 

 

Excel Chapter 1 Project 9 –Class Size

 

Excel Chapter 1 Project 10 –Grade Point Average

 

Excel Chapter 1 Project 11 –Animal Farm

 

 

Excel Chapter 1 Project 12 –Adjusting to Change

 

 

Excel Chapter 1 Project 13 –Rainfall

 

 

Excel Chapter 1 Project 14 –It’s Getting Hot in Here

 

 

Excel Chapter 1 Project 15 –Degrees

 

Group Projects:

 

 

Excel Chapter 1 Project 16 –Group Information

 

Excel Chapter 1 Project 17 –Expenses

 

 

Excel Chapter 1 Project 18 –My Animals

 

 

Excel Chapter 1 Project 19 –Multilingual

 

 

Excel Chapter 1 Project 20 –Eating Habits

 

 

 

 

 

 

Individual Projects:

 

1)       Get to know Excel

Objective:  To get a feel for the basics of Microsoft Excel.

 

a)      Open Microsoft Excel.

b)      Enter your name in Column A, Row 1.

c)       Preview printable area by selecting Print Preview.

d)      Close Print Preview.

e)      Change Page Setup orientation from Portrait to Landscape.

f)        Notice difference between Portrait page orientation and Landscape page orientation.

g)      Save as “(Your Name) – Exc1Proj1Solution”.

 

Back to top

 

 

 

 

2)       College Students

Objective:  To see how information is entered in Excel.

 

This is a survey of people, their ages, and year in college.  Please reproduce the information.  Save your finished work as “(Your Name) – Exc1Proj2Solution”.

 

 

 

 Back to top

 

 

 

 

3)       Working with Sheets

Objective:  To understand how to switch between sheets.

 

a)      Open Microsoft Excel.

b)      In Column A, Row 1, enter new heading “Names”.

c)      Rename this sheet (Sheet1) to “ID”.

d)      Click on Sheet2.

e)      In Column A, Row 1, enter new heading “Pets”.

f)        Rename this sheet (Sheet2) to “Animals”.

g)      Click on Sheet3.

h)      In Column A, Row 1, enter new heading “Birthplace”.

i)        Rename this sheet (Sheet3) to “Country”.

j)        Change the “ID” worksheet and the “Country” worksheet to Landscape page orientation.

k)      Save as “(Your Name) – Exc1Proj3Solution”.

 

Back to top

 

 

 

 

4)      All in the Family 

Objective:  To reinforce the use of headings and entering information in cells.

 

a)      Open Microsoft Excel.

b)      Compile a list of your family members, your relationship with them, i.e. Father, and their ages.

c)      Enter appropriate headings and change page setup to Landscape orientation.

d)      Save as “(Your Name) – Exc1Proj4Solution”.

 

Back to top

 

 

 

 

5)      Purely Leisure

Objective:  To work with some basic functions of a spreadsheet.

 

a)      Create a spreadsheet of films you have watched and books you have read within the past six months.

b)      Include appropriate headings, rename the sheet (Sheet1) tab, choose a font style, and center the text in the columns.

c)      Save as “(Your Name) – Exc1Proj5Solution”.

 

Back to top

 

 

 

 

 6)   Getting Acquainted

       Objective:  To reproduce given information.

 

It is the first day of class.  The students were asked to introduce themselves to each other.  This spreadsheet contains the information they gave to each other.  Reproduce this spreadsheet.  Save your work as “(Your Name) – Exc1Proj6Solution”.

           

 

Back to top

 

 

 

 

7)  Down on the Farm

     Objective:  To understand how to set things up in a table format.

 

Farmers A, B, C, D, E are very competitive with each other.  They constantly boast to each other about the diversity and quantity of animals each one owns.  Here are the animals that each farmer owns.  Reproduce this information.  Save your work as “(Your Name) – Exc1Proj7Solution”.

 

 

Back to top

 

 

 

 

8)   Test Time

Objective:  To notice how the average formula compensates for deleted cells.

 

a)      Open the file, Exc1Proj8Data, in the Data folder under the Projects folder.

b)      In Column E, Row 1, enter new heading “Overall Average”.

c)      Find the average score of the three exams for each student.

d)      In Column A, Row 9, enter new heading “Average Score”.

e)      Find the average score among the students for each exam.

f)        Insert a row between Row 3 and Row 4.

g)      Add new student, Joseph, in the newly created row.  He has test scores of Test 1 - 95, Test 2 - 98, and Final - 98.

h)      Delete Emmanuel’s information from the class.

i)        Notice how the average score for each exam automatically adjusts.

j)        Save as “(Your Name) – Exc1Proj8Solution”.

 

Back to top

 

 

 

 

9)   Class Size

Objective:  To find the average number of students in a class.

 

a)      Create a spreadsheet listing your classes and the number of students in each class.

b)      What is the total number of students in all your classes?

c)      What is the average number of students in a class?

d)      Save as “(Your Name) – Exc1Proj9Solution”.

 

Back to top

 

 

 

 

10)   Grade Point Average (GPA)

        Objective:  To calculate your GPA.

 

This exercise demonstrates how the United States’ grade point average (GPA) is calculated.  The GPA is based on a 4-point scale with 4 being the highest (A’s) and 0 being the lowest (F’s).  Grades are assigned values- A: 4, B: 3, C: 2, D: 1, F: 0.  The values that represent what grades students earned in their classes are averaged to find their grade point averages.  Recall what grades you received in your classes last semester and calculate your GPA.  Record this information in a spreadsheet.  Give the spreadsheet an appropriate title and include headings for the classes, grades, and numerical values of the grades.  Put your GPA under the column for the numerical values.  Save as “(Your Name) – Exc1Proj10Solution”.

 

Back to top

 

 

 

 

11)  Animal Farm

Objective:  To use the Autosum function to help analyze data.

 

a)      Open the file, Exc1Proj11Data, in the Data folder under the Projects folder.

b)      In Column G, Row 2, enter new heading “Total Animals”.

c)      Using the AutoSum function, find the total number of animals that each farmer has.

d)      In Column A, Row 10, enter new heading “Total”.

e)      Using the AutoSum function, find the total number of goats, cows, chickens, sheep, and pigs between all the farmers.

f)        Which farmer has the highest number of total animals on his farm? Put this farmer in bold.

g)      Which type of animal do most farmers own? Put this animal in bold.

h)      Which farmer has the least number of total animals on his farm? Put this farmer in italics.

i)        Which type of animal is least owned by farmers? Put this animal in italics.

j)        Save as “(Your Name) – Exc1Proj11Solution”.

 

Back to top

 

 

 

 

12) Adjusting to Change

Objective:  To notice how the Autosum function adjusts automatically to changes made in the spreadsheet.

 

a)      Open the file, Exc1Proj12Data, in the Data folder that’s under the Projects folder.

b)      Increase the quantity of goats that each farmer has by 2.  What is the new total number of goats owned by all farmers?

c)      Decrease the quantity of cows that each farmer has by 1.  What is the new total number of cows owned by all farmers?

d)      Increase the quantity of chickens that each farmer has by 3.  What is the new total number of chickens owned by all farmers?

e)      Increase the quantity of sheep that each farmer has by 5.  What is the new total number of sheep owned by all farmers?

f)        Decrease the quantity of pigs that each farmer has by 4.  What is the new total number of pigs owned by all farmers?

g)      Which farmer has the highest number of total animals on his farm? Put this farmer in bold.

h)      Which type of animal do most farmers own? Put this animal in bold.

i)        Which farmer has the least number of total animals on his farm? Put this farmer in italics.

j)        Which type of animal is least owned by farmers? Put this animal in italics.

k)      Save as “(Your Name) – Exc1Proj12Solution”.

 

Back to top

 

 

 

 

 13) Rainfall

Objective:  To find the average amount of rainfall over a period of time.

 

a)      Research the yearly amount of rainfall from 1980-1990 in Rwanda.

b)      Record this information in a spreadsheet with a column for the year and a column for the amount of rainfall.

c)      Find the average rainfall for the decade.

d)      Save as “(Your Name) – Exc1Proj13Solution”.

 

Back to top

 

 

 

 

14) It’s Getting Hot in Here

Objective:  To analyze weather patterns over a 25 year period.

 

a)      Research the average temperature per year between 1950-1975 in Rwanda.

b)      Record this information in a spreadsheet with a column for the year and a column for the average temperature during that year.

c)      Find the average temperature for the 25-year period.

d)      Save as “(Your Name) – Exc1Proj14Solution”.

 

Back to top

 

 

 

 

15) Degrees

Objective: To find the percentage of professors at the NUR with graduate degrees.

 

a)      Research the professors at the National University of Rwanda to figure out which have graduate degrees.

b)      Record the names of the professors and whether they have a graduate degree (1=yes they do have a graduate degree, 0=no they do not have a graduate degree) in a spreadsheet.

c)      What is the average percentage of professors with graduate degrees? (Multiply the average by 100 to find the average percentage of professors with graduate degrees.)

d)      Save as “(Your Name) – Exc1Proj15Solution”.

 

Back to top

 

 

 

 

Group Projects:

 

16) Group Information

Objective:  To find out and organize information about your group members.

 

a)      Start with a blank worksheet.

b)      In Column A, Row 1, enter new heading “Names”.

c)      Enter the names of everyone in the group in Column A under the heading.

d)      In Column B, Row 1, enter new heading “Age”.

e)      Enter the ages of everyone in the group in Column B under the heading.

f)        In Column C, Row 1, enter new heading “Siblings”.

g)      Enter the number of siblings each person has in the group in Column C under the heading.

h)      In Column D, Row 1, enter new heading “Height”.

i)        Enter the height of each person under Column D under the heading.

j)        In Column A, Row 9, enter new heading “Averages”.

k)      Find the average age for the group (Put this value in Column B, Row 9).

l)        Find the average number of siblings for the group (Put this value in Column C, Row 9).

m)    Find the average height for the group (Put this value in Column D, Row 9).

n)      Save as “(Your Name) – Exc1Proj16Solution”.

 

Back to top

 

 

 

 

17) Expenses

Objective:  To record expenses for members in the group.

 

a)      Start with a blank worksheet.

b)      In Column A, Row 1, enter new heading “Name”.

c)      In Column B, Row 1, enter new heading “Books”.

d)      In Column C, Row 1, enter new heading “Food”.

e)      In Column D, Row 1, enter new heading “Shoes”.

f)        Enter the names of the group members under Column A.

g)      Under Column B, have group members enter how much they spent on books this semester.

h)      Under Column C, have group members enter how much they spent on food in the past 3 days.

i)        Under Column D, have group members enter how much they spent on their last pair of shoes.

j)        In Column E, Row 1, enter new heading “Total Expenses”.

k)      In Column A, Row 9, enter new heading “Sum”.

l)        In Column A, Row 10, enter new heading “Average”.

m)    Find the total expenses for each group member.

n)      Find the sum expenses for books, food, and shoes.

o)      Find the average amount spent on books, food, and shoes.

p)      Save as “(Your Name) – Exc1Proj17Solution”.

 

Back to top

 

 

 

 

 18) My Animals

Objective: To discover the average number of animals/pets owned by group members.

 

a)      Create a spreadsheet with the names and number of animals/pets that each member in your group owns.

b)      What is the total number of animals/pets owned?

c)      What is the average number of animals/pets that each group member owns?

d)      What is the average number of each type of animal/pet owned?

e)      Save as “(Your Name) – Exc1Proj18Solution”.

 

Back to top

 

 

 

  

19) Multilingual

Objective: To find the average number of languages spoken by a random survey of people.

 

a)      Each group member should ask five people other than your group members how many languages they can speak.

b)      Record your findings in a spreadsheet with each group member's name and the names of the five people they asked, as well as how many

      languages each person interviewed can speak.

c)      What is the average number of languages spoken?

d)      Save as “(Your Name) – Exc1Proj19Solution”.

 

Back to top

 

 

 

 

20) Eating Habits

Objective: To create a daily log of your eating habits.

 

a)      Each member should record what he/she eats for the next week.

b)      Create a spreadsheet where each member logs what he/she ate for the week.

c)      Save as “(Your Name) – Exc1Proj20Solution”.

 

 Back to top

 Back to Menu