1. Load and set up the spreadsheet program. (I) 2. Create a properly-formatted worksheet file. (II) 3. Organize a problem for solution with spreadsheet software. (III) 4. Apply the principles of effective worksheet and database layout in building a spreadsheet template, using labels, numbers, and formulas. (III) 5. Enter, delete, and alter spreadsheet data. (IV) 6. Save a spreadsheet to disk and retrieve it. (V) 7. Print a spreadsheet on the printer and on disk, using spreadsheet print capabilities to enhance printed output. (VI) 8. Sort a spreadsheet in a variety of ways. (VII) 9. Use spreadsheet functions to prepare and print graphs. (VIII) 10. Create and use complex spreadsheet macros. (IX) 11. Use the spreadsheet's database techniques to locate, link, extract, and combine data from multiple spreadsheets. (X) 12. Use built-in statistical analysis features of spreadsheet software. (XI) 13. Manipulate matrices with spreadsheet software. (XII) 14. Design and implement a spreadsheet project which includes multiple, integrated spreadsheets. (XIII) Scoring: Within the course content noted below, the following points can be earned: Start Here Activities Complete the “Start Here Activities” in Canvas. 10 Assignments - Chapters 1-8 Textbook Case Problem - 20 SAM 2013 Training – 20 SAM 2013 Project - 100 SAM 2013 Exam – 100 Canvas Discussion - 10 250 points x 8 chapters = 2,000 points 2,000 End of Course Assignments SAM 2013 Final Exam – 50 points Personal Spreadsheet - 50 points 100 TOTAL NOTE: The of 2,110 points includes 110 points of extra credit, however your final grade will be based on 2,000 points, not on the percentage as calculated in Canvas. 2,110 Grading: Grading will be as follows: Points Earned Grade Earned 1,800 or more "A" 1,600 – 1,799 "B"
1,400 – 1,599 "C" 1,200 – 1,399 "D" 0 – 1,199 "W" Other possible grades: "W" - Withdrawn, Passing - Awarded if a student initiates the withdrawal, or if the student is withdrawn for failure to submit work on a regular basis. "W" is also given at the end of the semester if a student has not earned a passing grade. "I" - Incomplete - (per GCC General Catalog) Students who are doing acceptable work may request an incomplete grade "I" if they are unable to complete the course requirements by their individual End Date. There must be extenuating circumstances, such as illness, military deployment, or other valid reason. The instructor has the sole discretion to grant, or deny, a request for an Incomplete. "Acceptable work" means that the student must have completed two-thirds (2/3) of the work. Here Activities: Complete the tasks listed in the “Start Here Activities” in Canvas. A student who fails to start the “Start Here Activities” within the first five (5) days will be withdrawn as a "No Show". NOTE: Sending the instructor an e-mail will retain the student in the class. Chapters 1-8 Assignments: Each Textbook Chapter is called a “Tutorial”, thus “Chapter” and “Tutorial” are used interchangeably. Textbook Tutorial Sessions – Read and complete the instructions in the Textbook Tutorials Sessions. Textbook Case Problems - Scored with points deducted for errors. SAM Training – Can be repeated as many as you wish. Training is very important since each skill corresponds 1-for-1 with each question on the corresponding Exam. SAM Projects – If you reach the threshold of 80% or better, you will earn 100%. You have five (5) attempts per Project, however if you reach this maximum: Contact me and I will give you an additional five attempts. SAM Exams – Each Exam is timed, and you may re-take it once if you wish. Your highest score will be counted. SAM Names – SAM names follow these examples: Training 1 Project 1 Exam 1 End of Course Assignments: