Excel Grade Book Assignment Directions 2007

Excel Grade Book Assignment Directions 2007 - Excel Grade...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Excel Grade Book Assignment (for MS 2007) Page 1 of 15 Introduction to Spreadsheets Using Microsoft Excel 2007 Overview This Project is designed as a beginner’s introduction to using spreadsheets and to some of the features of Microsoft Excel. We will cover topics such as the spreadsheet layout, entering and editing data, calculating using operators and functions, and graphing. We will explore spreadsheets by developing a simple grade sheet, demonstrating a spreadsheet’s power both as a formatting and as a calculating tool. Introduction Spreadsheets are commonly used to do automatic calculations of rows and columns of numerical data, much like the accounting ―spreadsheets‖ used by the financial community. But spreadsheets can also be used to arrange various types of data for neatly formatted display. It’s time to learn how useful spreadsheet programs like Microsoft Excel can be in your classroom. This program can help you perform calculations and create charts and graphs based on your data. Teachers can use Excel to calculate student averages and automatically assign letter grades, to collect and analyze information, including student records, lesson notes, school activity budgets, professional organization information, and data. Students may use Excel for scientific data, weather journals, financial reports, nutritional diaries, and legislative voting records. By the end of this activity, you will have learned: How to input/format/organize data into a spreadsheet How Excel can perform basic calculations and functions (averages, sums, and more) Microsoft Excel is one of many spreadsheet applications currently available. Most of these applications have adapted the syntax and functions of VisiCalc , the original spreadsheet program. By learning Excel you will also be learning to use the basic procedures at the heart of any spreadsheet program. Pay particular attention to the underlined terms. They are part of the vocabulary for using spreadsheets in general or Excel in particular.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Page 2 of 15 Screen Layout When you start working in Microsoft Excel, you begin using a workbook that contains screens called worksheets. They are identified as Sheet1, Sheet2, and so on. Here is the initial screen you see when you open Excel: Sample Excel Window The worksheet is divided into a grid consisting of columns , which are named by letters at the top in the column heading , and row s, which are named by numbers at their left end in the row heading . Column letters go from A to Z. If more than 26 columns are needed, they are named AA, AB, … AZ, BA, BB, etc. At the top of the window are the Menus . The Menus contain the Tools , which contain buttons for instant access to frequently used menu commands. Scroll Bars , which allow you to move your view of the worksheet, are at the right and bottom of the window. Below the worksheet are Worksheet or Chart Names . Use them to switch between worksheets, several of which can be incorporated into a workbook . Menus
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 15

Excel Grade Book Assignment Directions 2007 - Excel Grade...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online