Your worksheets should be in the following order: LookUp, Books, your 3 pivots and then your 2 filter worksheets.Once a user enters a new Book Code in the LookUp worksheet, all the data and chart should automatically change.Check your worksheet and be sure there are no errors or error symbols in your finished worksheet. If you don’t have this featurecome into the lab to do this step. Check your formatting – currency should have a $ and 2 decimal places, percentages should be formatted with a % sign and 1 decimal place. Check your formulas, be sure they are correct and make sense. For example, if you are subtracting 2 numbers don’t use the SUM formulas (sum is for adding). Excel may figure out what you mean, but we want the formulas to be used correctly (show that you understand how to use them). Project Submission Instructions / Notes:Office/online hours get busy as deadlines approach. If you procrastinate and wait until the last days to work on your project, youmay not be able to get all the help you want. The only way we can fairly grade the projects is if we check for each requirement. Please go through the instructions before you submit & be sure you have done each one correctly, so you don’t miss out on points. Compare your solution to the project overview.Submitting: oRemember to leave all of the internal file properties intact for your project, if they are modified or deleted, you project won’t be accepted (see syllabus for more on this).
oRead and follow the instructions in the Assignments section of Canvas on uploading and checking your upload. If you follow these instructions, you can ensure that your project is uploaded correctly (and is the correct project). Be sure that Access / Excel are closed before you try to upload your project files. oIf your project doesn’t upload correctly before the due date, it will be considered late and be assessed the late penalty –even it was finished on time. This is the only way we can ensure that students check their Canvas submissions. Technology problems relating to your home computer (Windows based or Mac), internet connection or slow Canvas access are not valid excuses for late/missing work, unless Canvas is down for 6+ hours on the due date. Computers at USF computer labs and the library are available; leave enough time to access them as needed. Also give yourself enough time that if a TA can’t answer a question, you’ll have time to contact me during office hours or online hours & I can either help you or make an allowance in your grade. If you wait until the last weekend, I may not be able to do either.