Assignment Files
Submissions
You must submit your completed file(s) through the CS101 Submit Assignments tool.
Due Date
This assignment is due on Thursday, January 30, 2025. For on-campus sections, it is due by the end of class. For online sections, it is due by 11:59:59 PM Eastern Time. Late work will not be accepted.
Grades
This assignment is worth 8 points. A grading rubric is provided at the end of the assignment instructions. Over the entire semester, students must complete at least 20 Participation Projects to earn a maximum of 160 points.
Help & Resources
Video
This video is also available on YouTube [1].
Assignment Notes
Formatting
This project should be pretty simple if you have ever used Word or Powerpoint before, which I'm sure you have. Everything you do in this project will be accessed through the Home ribbon when you open the file. If you're not sure where to find something on the menu bar, if you hover over a button, excel will tell you what the button does.
Formatting using colors
The same thing will happen when you hover over colors in the menus. This is important to know as you will be asked to find specific colors in future projects. This is how you find out what the name of a color is.
Formatting using the Styles Menu
When you are looking at the cell styles menu, you will see the name of the style displayed as the actually formatting of that style will look. For instance, the style named "Good" has dark green text with a green background for the cell.
Formatting borders
The easiest way to add borders to your projects are to select the borders button, and then select Borders and Shading at the bottom.
Formatting Menus
You can get a formatting menu to open when selecting the box with the right slanted downward arrow at the bottom of the ribbon. This will open the dialog box for whatever section of the ribbon you selected it from.
Applying Formatting to multiple cells
To apply formatting to multiple cells, you can click and drag to select multiple cells prior to seleting the formatting, or you may use the cell name box by entering the cell you want to start with, a colon, and then the cell you want to end with before hitting enter.
Associated Learning Objectives
This assignment covers the following course and unit learning objectives:
Number | Learning Objective |
C01 | Build spreadsheets to perform calculations, display data, conduct analysis, and explore what-if scenarios. |
C05 | Identify, access, and evaluate information to solve real world problems. |
C01.ED02 | Create and manage workbooks, worksheets, and their data. |
C01.ED03 | Format worksheets and cells to create professional reports. |
C05.ED01 | Locate and access data and resources necessary to solve problems. |
C05.ED08 | Interpret and analyze spreadsheet data. |
References
- B. M. Powell, Excel: Formatting Participation Project. West Virginia University, 2021. Available: https://www.youtube.com/watch?v=gbunxGs26rY.