Excel Spreadsheet
Warner's Sample Four Year Plan <---That is a link to a sample; click it
Requirements
1. You need to have a title cell that
A. says the major
B. says the name of the school
C. is formatted in your school's colors
2. You need to set up a table for each school year, starting with the first year you will be in college. Each table needs to have the following:
A. A column for each term (quarter or semester)
i. Each class listed under each term needs to include a Course Code (i.e. Math 10A) and a Course Title (Calculus).
ii. Next to each list of courses, there needs to be a column that lists the number of units the student will earn with each course.
iii. Students will need to insert a formula to add up the units taken during each term.
B. Students will then need to insert a formula to add up the total units taken each year.
3. Students will need to create a table that shows the total units required for graduation as compared to the units scheduled on the four year plan. Students will need to insert a formula to total up all of the year totals to find a sum for the total units taken upon graduation.
4. Students will need to create a key for their document. They will need to color code their courses in the following manner:
A. General Education Requirements
B. Major Requirements
C. Courses that satisfy both GE and Major Requirements
D. (Optional) Courses that satisfy Minor Requirements
A. says the major
B. says the name of the school
C. is formatted in your school's colors
2. You need to set up a table for each school year, starting with the first year you will be in college. Each table needs to have the following:
A. A column for each term (quarter or semester)
i. Each class listed under each term needs to include a Course Code (i.e. Math 10A) and a Course Title (Calculus).
ii. Next to each list of courses, there needs to be a column that lists the number of units the student will earn with each course.
iii. Students will need to insert a formula to add up the units taken during each term.
B. Students will then need to insert a formula to add up the total units taken each year.
3. Students will need to create a table that shows the total units required for graduation as compared to the units scheduled on the four year plan. Students will need to insert a formula to total up all of the year totals to find a sum for the total units taken upon graduation.
4. Students will need to create a key for their document. They will need to color code their courses in the following manner:
A. General Education Requirements
B. Major Requirements
C. Courses that satisfy both GE and Major Requirements
D. (Optional) Courses that satisfy Minor Requirements
Instructions
To Get Text to Fit in Cells:
1. Press Ctrl+A. This will highlight all cells, so the changes you make apply to all cells.
2. Go to the Format menu.
3. Click on Cells.
4. Click on the Alignment Tab.
5. Mark the box that says Wrap Text.
2. Go to the Format menu.
3. Click on Cells.
4. Click on the Alignment Tab.
5. Mark the box that says Wrap Text.
To Merge Cells:
1. Highlight the cells you wish to merge
2. Click the Merge and Center Icon
2. Click the Merge and Center Icon
To Insert a Formula:
1. Click on the cell where you would like the answer to appear.
2. Type your formula in the Function bar (Fx)
A. For a sum with consecutive cells type =SUM(First Cell:Last Cell) =SUM(E4:E11)
B. For a sum with cells from different areas type =SUM(First cell,next cell,next cell...) =SUM(E:12,H12,L12)
C. Remember that there are no spaces in the formulas
2. Type your formula in the Function bar (Fx)
A. For a sum with consecutive cells type =SUM(First Cell:Last Cell) =SUM(E4:E11)
B. For a sum with cells from different areas type =SUM(First cell,next cell,next cell...) =SUM(E:12,H12,L12)
C. Remember that there are no spaces in the formulas
To change the cell background:
1. Highlight the cell.
2. Press the Fill Color icon and choose the color you want.
2. Press the Fill Color icon and choose the color you want.
To change font color:
1. Highlight the text you would like to change.
2. Click the Font Color icon and choose the color you want.
2. Click the Font Color icon and choose the color you want.
To insert cells:
1. Highlight the cells either above or to the right of where you would like a cell inserted.
2. Choose whether you want individual cells or whole rows or columns added.
2. Choose whether you want individual cells or whole rows or columns added.