Lab 09: Basics of Excel

Description: We will be covering the basics of the spreadsheet application, Microsoft Excel using one of the numerous tutorials online that cover the basics: columns, rows, cells, data types, using formulas, etc.

Reading: Integrating Tech for Meaningful Learning, pp. 94 – 101.
App/Equip Used: Windows OS, Microsoft Excel, Web Browser.

Links:
Excel Tutorial - from Brad James of the University of South Dakota, TRIO Program.
Google Search for Excel Tutorials - a sample search for excel tutorials finds there is a tremendous number of online tutorials available for self-guided study of Excel.

Lab Procedure:

1. Input the data at the top of this lab into an Excel spreadsheet, then format it as follows:

• Change the font size of the course title into 36, color into white;
• Change the font size of the semester, year into 26, color into white;
• Make cell A1 and A2 span over column J (merge cells A1 through J1, also merge cells A2 through J2). Make the background color green;
• Fill in all the necessary data, letters and formulas;
• Merge cells A22 through J22 and make the background color yellow;
• Create a Pie chart regarding the categories considered for final grade and their corresponding percentages;
• Change the tab names into “Final Grade” and “3-D Pie Chart” respectively.

2. Save your sample data as an Excel spreadsheet appropriately named (jones_lab09.xls) with your last name, email address, and the lab number at the top of the document.
3. Send your word document to my AC230 Digital Dropbox on York’s Blackboard. The subject line should give your name and the lab number (Frank Jones Lab 09).