Introduction to Computers 1: Assignment 1
1
Assignment Description: This assignment will require you to review the terms, concepts and
fundamentals covered in Lesson 5 – Excel Basics. You will be completing one file for this assignment on your computer and then submitting it online through Blackboard.
Obtaining the files needed to complete the assignment:
1. Open the file link in the Assignment 1 folder entitled Assignment 1 – Student Data Files
2. Right click on the file Assignment 1_Document to open the context menu.
3. Depending on the browser you are using, select the option Save link as or Save target as to open the save dialog box.
4. When the save dialog box opens, save the file to a location on your computer where you will be able to locate it again.
You MUST use this file to complete your assignment. Failure to do so may result in a grade of 0.
All the instructions required to complete this assignment are listed below in a step‐by‐step
format. Save your work frequently.
Introduction to Computers 1: Assignment 1
2
Assignment 1 Instructions:
1. Open the Assignment 1_Document file in Excel. In the File tab, save the file with the name
Firstname_Lastname_Assignment1, where Firstname and Lastname are replaced with your
first and last names.
2. Autofit the width of columns A through D.
3. Insert a new row before row 1.
4. Enter the text Music Collection in A1.
5. Merge & Center cells A1 through D1.
6. Apply the Heading 1 cell style to the merged cells.
7. Apply the 60% – Accent 3 cell style to cells A2 through D2.
8. Change the text in cells A2 through D2 to Bold.
9. Change the text in cells A2 through D2 to a font size of 14.
10. Center the text in cells A2 through D2.
11. Change the font colour of the text in cells A2 through D2 to Green
12. Change the fill colour of cells A3 through D13 to Gray, Accent 3, Lighter 80%.
13. Change the font of cells A3 through D13 to Cambria
14. Delete the 2 rows which contain songs by Anne Murray.
15. Fix the error in the name of the last song. It should be Jammin, rather than Jamming.
16. Add your Blackboard username as an author of this workbook.
17. Save the workbook.
Introduction to Computers 1: Assignment 1
3
Rubric: Assignment 1
Rubric Marks
Cell Data 2
Cell Formatting 10
Properties 1
Worksheet Formatting 3
Total 16
File to Submit:
Firstname_Lastname_Assignment1
Total marks available for this assignment = 16 marks worth 6% of your final grade.
How to Submit Files
Once you have completed the file for this assignment on your computer and saved the file with the corresponding filename:
1. In Blackboard, go to the assignment area and select Assignment 1.
2. Click on Assignment 1 File Upload link. Scroll down the page and click the Browse MyComputer button.
3. A window will open asking you to select your file. Locate your assignment file
Firstname_Lastname_Assignment1 on your computer and then click the OPEN button.
4. You should now see the file for submission in the area File Name.
5. Click the Submit button. The Save Draft button does NOT submit assignments to the facilitator.
If you encounter any problems with the assignment or have questions, email your facilitator – include your name, the course title, and section number, along with the assignment number in the email subject line.