Exam
The next few Excel Exams will be Youtube Exams. See Exam List
The Exam list will show 8 of these Exams. However, there will only be 5, as I had the Excel Table Exam at Classmarker. I am also adding both regression exams back to Classmarker.
What is a Youtube Exam?
You will complete your Exam (See Questions Below) on excel using a computer. You will record your completion of the assignment by using Screencast-O-matic (See FAQ Tab on Course Blog). You will then post your recording either on your free Screencast-O-matic account or on your Youtube account.
You can setup a free Screencast-O-Matic account. The online interface was recently updated. If you have any questions, watch all 3 videos, related to Screencast-O-matic, located at the FAQ Tab. Video #8 under that tab discusses the new interface.
You can setup a free Screencast-O-Matic account. The online interface was recently updated. If you have any questions, watch all 3 videos, related to Screencast-O-matic, located at the FAQ Tab. Video #8 under that tab discusses the new interface.
Once your video is uploaded, paste the video URL in the form located below. You must submit the form by the due date of the exam.
Excel HW#4 - Pivot Tables.
Excel HW#4 - Pivot Tables.
Create two pivot tables using the download data here (or the class blog post). After it opens go up to the menu and click File>Download, to download this Excel file on to your computer. Then open it in your Excel.
Question #1 - Create a Pivot Table showing the average price per house in each city and include the number of houses sold in the next column.
Question #2 - Create a Pivot Table the number of homes in each city that sold for $1M or more.
You can create one video showing me how you created both pivot tables or you can create two videos. One video per question. You should have enough time to answer both questions in one video. Buy its up to you.
Excel HW#5 - Charts
Create one chart for each Pivot Table you created in HW#4. The chart will be graded based on your graph/chart having titles (Top, X-axis & Y-axis), chart is easy to read and makes sense. Do not just make a quick chart without showing you learned to add additional attributes to the charts. The more you can show me, the higher your grade.
Question #1 - Create a Pivot Table showing the average price per house in each city and include the number of houses sold in the next column.
Question #2 - Create a Pivot Table the number of homes in each city that sold for $1M or more.
You can create one video showing me how you created both pivot tables or you can create two videos. One video per question. You should have enough time to answer both questions in one video. Buy its up to you.
Excel HW#5 - Charts
Create one chart for each Pivot Table you created in HW#4. The chart will be graded based on your graph/chart having titles (Top, X-axis & Y-axis), chart is easy to read and makes sense. Do not just make a quick chart without showing you learned to add additional attributes to the charts. The more you can show me, the higher your grade.
No comments:
Post a Comment