excell projest

9/7/21, 11:45 PM Excel Project #1 - IFSM 201 6381 Concepts and Applications of Information Technology (2218) - UMGC Learning Management S…

https://learn.umgc.edu/d2l/lms/dropbox/user/folder_submit_files.d2l?db=1159847&grpid=0&isprv=0&bp=0&ou=611912 1/11

Excel Project #1 Course: IFSM 201 6381 Concepts and Applications of Information Technology (2218)

Criteria Exemplary Accomplished Satisfactory Developing Partially complete or not completed

Criterion Score

Data Entry

(includes

copying

data, Excel

Table

creation,

creating

worksheets)

/ 1

Excel

Operations

including

Computatio

ns and

Formulas

/ 4

1 point

All data

required is

imported with

100%

accuracy as an

Excel Table.

All worksheets

created as

required in

prescribed

order. No

extraneous

worksheets.

0.85 points

1 error

identified

0.7 points

2 errors

identified

0.55 points

3-4 errors

identified

0 points

5+ errors, not

sufficiently

complete to

assess or not

completed

4 points

100% use of

correct,

applicable

formulas as

required.

Secondary:

prescribed

ranges are

created and

utilized

correctly.

3.4 points

1 error

identified

2.8 points

2 errors

identified

2.2 points

3-4 errors

identified

0 points

5+ errors, not

sufficiently

complete to

assess or not

completed

Paragraph

Lato (Recom…

19px …

9/7/21, 11:45 PM Excel Project #1 - IFSM 201 6381 Concepts and Applications of Information Technology (2218) - UMGC Learning Management S…

https://learn.umgc.edu/d2l/lms/dropbox/user/folder_submit_files.d2l?db=1159847&grpid=0&isprv=0&bp=0&ou=611912 2/11

Criteria Exemplary Accomplished Satisfactory Developing Partially complete or not completed

Criterion Score

Graphs/Cha

rts

/ 22 points

Graphs/Charts

required for

the project

were correct.

All required

elements were

depicted.

Graphs

depicted

required

contents and

were given an

accurate,

descriptive

title.

1.7 points

1 error

identified

1.4 points

2 errors

identified

1.1 points

3-4 errors

identified

0 points

5+ errors, not

sufficiently

complete to

assess or not

completed

9/7/21, 11:45 PM Excel Project #1 - IFSM 201 6381 Concepts and Applications of Information Technology (2218) - UMGC Learning Management S…

https://learn.umgc.edu/d2l/lms/dropbox/user/folder_submit_files.d2l?db=1159847&grpid=0&isprv=0&bp=0&ou=611912 3/11

Total / 10

Criteria Exemplary Accomplished Satisfactory Developing Partially complete or not completed

Criterion Score

Organizatio

n,

Formatting,

Visual

Appearance

/ 2

Questions/R

esponses

/ 1

2 points

Information is

very well

organized

using

advanced

formatting,

including

shading,

alignment

tools, borders,

fonts,

appropriate

labels,

appropriate

column/row

height and

width.

Spreadsheet is

easy to read

and all

required

information is

visible

(nothing cut

off or

truncated).

1.7 points

1 error

identified

1.4 points

2 errors

identified

1.1 points

3-4 errors

identified

0 points

5+ errors, not

sufficiently

complete to

assess or not

completed

1 point

Responses are

accurate and

on point.

Grammar and

punctuation

are correct.

0.85 points

1 error

identified

0.7 points

2 errors

identified

0.55 points

3-4 errors

identified

0 points

5+ errors, not

sufficiently

complete to

assess or not

completed

9/7/21, 11:45 PM Excel Project #1 - IFSM 201 6381 Concepts and Applications of Information Technology (2218) - UMGC Learning Management S…

https://learn.umgc.edu/d2l/lms/dropbox/user/folder_submit_files.d2l?db=1159847&grpid=0&isprv=0&bp=0&ou=611912 4/11

Overall Score

Level 5 9 points minimum

Level 4 8 points minimum

Level 3 7 points minimum

Level 2 6 points minimum

Level 1 0 points minimum

9/7/21, 11:45 PM Excel Project #1 - IFSM 201 6381 Concepts and Applications of Information Technology (2218) - UMGC Learning Management S…

https://learn.umgc.edu/d2l/lms/dropbox/user/folder_submit_files.d2l?db=1159847&grpid=0&isprv=0&bp=0&ou=611912 5/11

9/7/21, 11:45 PM Excel Project #1 - IFSM 201 6381 Concepts and Applications of Information Technology (2218) - UMGC Learning Management S…

https://learn.umgc.edu/d2l/lms/dropbox/user/folder_submit_files.d2l?db=1159847&grpid=0&isprv=0&bp=0&ou=611912 6/11

9/7/21, 11:45 PM Excel Project #1 - IFSM 201 6381 Concepts and Applications of Information Technology (2218) - UMGC Learning Management S…

https://learn.umgc.edu/d2l/lms/dropbox/user/folder_submit_files.d2l?db=1159847&grpid=0&isprv=0&bp=0&ou=611912 7/11

9/7/21, 11:45 PM Excel Project #1 - IFSM 201 6381 Concepts and Applications of Information Technology (2218) - UMGC Learning Management S…

https://learn.umgc.edu/d2l/lms/dropbox/user/folder_submit_files.d2l?db=1159847&grpid=0&isprv=0&bp=0&ou=611912 8/11

9/7/21, 11:45 PM Excel Project #1 - IFSM 201 6381 Concepts and Applications of Information Technology (2218) - UMGC Learning Management S…

https://learn.umgc.edu/d2l/lms/dropbox/user/folder_submit_files.d2l?db=1159847&grpid=0&isprv=0&bp=0&ou=611912 9/11

9/7/21, 11:45 PM Excel Project #1 - IFSM 201 6381 Concepts and Applications of Information Technology (2218) - UMGC Learning Management S…

https://learn.umgc.edu/d2l/lms/dropbox/user/folder_submit_files.d2l?db=1159847&grpid=0&isprv=0&bp=0&ou=611912 10/11

9/7/21, 11:45 PM Excel Project #1 - IFSM 201 6381 Concepts and Applications of Information Technology (2218) - UMGC Learning Management S…

https://learn.umgc.edu/d2l/lms/dropbox/user/folder_submit_files.d2l?db=1159847&grpid=0&isprv=0&bp=0&ou=611912 11/11