MIME-Version: 1.0 Content-Location: file:///C:/EB26A0D4/ExcelGradProject.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Excel Spread Sheet Project

Excel Spread She= et Project

Grade Keeping

 

 

Purpose:  to create a spread sheet using for= mulas to calculate my science grades.

 

MA Standards:  Technology Standard 1. Grades 5-8

        =             &nb= sp;      Performance Indicators:  1.22, 1.23, 1.24

 

Materials:  Paper copy of student’s science assignment grades

                   Comp= uter with excel software

        =           Science website for links and files

 

Procedure:     1. U= se the Excel web link tutor= ial for self help here or on the technology

            =             &nb= sp;           page of the science website

            =             2= .  Use the Excel File on my technolog= y page to help you create the

            =             &nb= sp;           same spread sheet.

            =             3= .  Open Excel and duplicate the Excel= file spread sheet using formulas.

            =             &nb= sp;           Save your spread sheet is My Practice Grades in My Documents. =

            =             4. Open Excel and create a spread sheet for your science grades and=

                =             &nb= sp;       save in my documents as My Science Grades.

            =             5. Remember:  ask the teacher when commands are = not working to give

            =             &nb= sp;           the results expected in the spread sheet.

 

Data:  Making a spread sheet data table f= or printing is easy.

            1.  Highlight the section of the spread sheet that will be part of the data table.

            2.  in the File pull down menu, click = on print preview.

            3.  Click on Set Up.=

            4.  Click on Sheet.<= /p>

            5.  Click on Grid Lines

            6.  Click on OK

            7.  The spread sheet should now look l= ike a data table

            8.  Show your teacher and receive perm= ission to print or close.

 

Analysis/Conclusion:  =

 

Ø      Can you fo= rmat a column?

Ø      Can you fo= rmat a row?

Ø      Can you fo= rmat text in a cell?

Ø      Can you id= entify a cell position?

Ø      Can you in= sert an average formula in the correct cell?

Ø      Can you in= sert a percent formula in the correct cell?

Ø      Can you se= lect, drag, copy and paste in the correct cells?

 <= span style=3D'mso-spacerun:yes'> 

Error Analysis:  A discussion of items= that were difficult and an explanation of the

            =             <= span style=3D'mso-spacerun:yes'>    problems encountered w= ith the project.  This is a written narrative

            =             <= span style=3D'mso-spacerun:yes'>    with complete sentence= s in paragraph style writing. 

            =             <= o:p>