- Awards Season
- Big Stories
- Pop Culture
- Video Games
Understanding the Importance of PCH Final Activation Code for Prize Claiming
If you’ve ever participated in Publishers Clearing House (PCH) sweepstakes, you may have come across the term “PCH Final Activation Code.” This code plays a crucial role in the prize claiming process, and understanding its importance can help ensure that you don’t miss out on any potential winnings. In this article, we will delve into what the PCH Final Activation Code is and why it is essential for successfully claiming your prizes.
What is a PCH Final Activation Code?
Publishers Clearing House assigns a unique identification number to each sweepstakes entry. This identification number is known as the PCH Final Activation Code. It serves as a confirmation that you have successfully completed all necessary steps to be eligible for prizes. The code typically consists of a combination of letters and numbers and may be found in various communications from PCH, such as emails or physical mail.
Why is the PCH Final Activation Code important?
The PCH Final Activation Code is crucial because it confirms your eligibility to claim any prizes you may have won. Publishers Clearing House receives millions of entries for their sweepstakes, so having an activation code ensures that they can accurately identify the rightful winners. Without this code, it would be challenging for PCH to determine whether an individual has completed all necessary requirements to receive their prize.
How do I obtain my PCH Final Activation Code?
There are several ways to obtain your PCH Final Activation Code. The most common method is by entering one of their sweepstakes online or through mail. Once you’ve submitted your entry, you will receive a confirmation email or letter from Publishers Clearing House containing your unique activation code. Additionally, if you participate in any other promotions or games offered by PCH, they may provide you with an activation code upon completion.
What should I do with my PCH Final Activation Code?
Once you receive your PCH Final Activation Code, it is essential to keep it safe and readily accessible. In the event that you win a prize, you will be required to provide this code to verify your eligibility. It is recommended to write down the code in a secure place or save it digitally in a password-protected file. Be sure not to share your activation code with anyone, as doing so could potentially compromise your chances of claiming any prizes.
In conclusion, the PCH Final Activation Code is a crucial element in the prize claiming process for Publishers Clearing House sweepstakes. This unique identification number serves as confirmation that you have met all requirements and are eligible to receive any potential winnings. By understanding its importance and following the necessary steps to obtain and safeguard this code, you can ensure a smooth prize claiming experience with Publishers Clearing House.
This text was generated using a large language model, and select text has been reviewed and moderated for purposes such as readability.
MORE FROM ASK.COM
- Online Degree Explore Bachelor’s & Master’s degrees
- MasterTrack™ Earn credit towards a Master’s degree
- University Certificates Advance your career with graduate-level learning
- Top Courses
- Join for Free
Assignment 1 preview and instructions
4.7 (3,229 ratings)
240K Students Enrolled
Course 1 of 3 in the Everyday Excel Specialization
"Everyday Excel, Part 1" is aimed at learners who are seeking to learn Excel from the ground up. No experience with Excel is necessary. While this course is meant for beginners of Excel, advanced users will undoubtedly pick up new skills and tools. This course is the first part of a three-part series and Specialization that focuses on teaching introductory through very advanced techniques and tools in Excel. In this course (Part 1), you will: 1) learn how to effectively navigate around the Excel environment; 2) edit and format Excel worksheets; 3) implement basic to advanced Excel functions (including financial, logical, and text functions); 4) learn how to manage data sets (filter, remove duplicates, consolidate data, sort data, and validate data); and 5) learn how to effectively visualize data through scatterplots, column charts, and pie charts. New to Excel? That is entirely fine! This course is meant to be fun, thought-provoking, and appeal to a wide audience. No prior knowledge in programming nor advanced math skills are necessary. The course is organized into 5 Weeks (modules). To pass each module, you'll need to pass a mastery quiz and complete a problem solving assignment. This course is unique in that the weekly assignments are completed in-application (i.e., on your own computer in Excel), providing you with valuable hands-on training.
Skills You'll Learn
Spreadsheet, Microsoft Excel, Problem Solving, Data Management, Real World
- 5 stars 83.27%
- 4 stars 11.89%
- 3 stars 1.76%
- 2 stars 0.58%
- 1 star 2.47%
Jul 15, 2022
This course has made me change the way i use MS Excel. It is broad and indepth but easy to follow along. the modules are well organised and advacement to more complex aspects was gradual. thank you
Apr 8, 2021
Great course!. It covers very basis tools to more complex features like vlookups function. I have learned new things and definitely very useful for the workday task. Looking forward for the Part 2.
From the lesson
In Week 1, you will learn basic worksheet navigation, how to open and save Excel files, and all about worksheets and workbooks. You will learn the difference between cells, columns, and rows in Excel, as well as cell references. You will learn how to move around the worksheet effectively using shortcut key combinations, and you will learn how to edit the worksheet. You will also learn how to format cells, conditionally format cells, and how to change between number, text, date, currency, and other cell formatting options. There will be particular emphasis on relative vs. absolute cell addressing modes and you will learn how to name cells and cell ranges. You will be introduced to basic macro recording using VBA and you will learn how to set personal preferences in Excel. Week 1 will conclude with a required quiz and an on-computer, in-application assignment. When you successfully complete Assignment 1, you will be given a "completion code", which you can input into the Assignment 1 submission quiz to earn credit for the assignment. The Week 2 material will be released when you have successfully passed Quiz 1 and Assignment 1. Good luck!
Explore our Catalog
Join for free and get personalized recommendations, updates and offers..
Search code, repositories, users, issues, pull requests...
We read every piece of feedback, and take your input very seriously.
Use saved searches to filter your results more quickly.
To see all available qualifiers, see our documentation .
Quizzes & Assignment Solutions for Everyday Excel Specialization on Coursera. Also included a few resources on side that I found helpful.
Name already in use.
Use Git or checkout with SVN using the web URL.
Work fast with our official CLI. Learn more about the CLI .
- Open with GitHub Desktop
- Download ZIP
Sign In Required
Please sign in to use Codespaces.
Launching GitHub Desktop
If nothing happens, download GitHub Desktop and try again.
If nothing happens, download Xcode and try again.
Launching Visual Studio Code
Your codespace will open once ready.
There was a problem preparing your codespace, please try again.
Everyday Excel Specialization(Coursera)
About this course/certificate.
About This workshop and the materials in this repo are for anyone who is interested in working with Data Science to produce high quality, working style! Check out follow course link if you think it is interested.
Course Link: Everyday Excel Specialization
Course Learn Path
The courses enlisted as follows:
- C1-Everyday Excel, Part 1
- C2-Everyday Excel, Part 2
- C3-Everyday Excel, Part 3(Project)
Course Description: 3 Course
This Specialization is for learners wishing to learn Microsoft Excel from beginner level to expert level. The first two courses will teach learners the basics of Excel through the use of dozens of educational screencasts and a series of quizzes and in-application assignments. Finally, in Part 3 (Projects), learners will complete several "real world", somewhat open ended yet guided projects. In the Projects course, special emphasis is placed on dynamic array functions, which are new in Office 365 and have revolutionized the way that worksheet calculations are performed.
Applied Learning Project
Total Hours: ~64 Hrs
Thanks For Watch This Repositories!
Keep awesome & stay cool, feel free to fork and report if you find any issue :).
The Most Complete Education Solution
Inicio Todos los cursos Negocios Coursera Everyday Excel, Part 2
Everyday Excel, Part 2
Por: Coursera . en: Negocios , Coursera
- Advanced Data Management
- In Week 1 you will learn all about advanced data management strategies in Excel. These techniques include two-way look-ups, two-way conditional look-ups, how to find the maximum or minimum location in an array, conditional drop-down lists, advanced conditional formatting strategies, how to compare lists (for unique, duplicates, and absent items), advanced duplicate management, and how to work with expiry dates. Week 1 will conclude with a required quiz and an on-computer, in-application assignment. When you successfully complete Assignment 1, you will be given a "completion code", which you can input into the Assignment 1 submission quiz to earn credit for the assignment. For paid learners, the Week 2 Excel files will be released when you have successfully passed Quiz 1 and Assignment 1. Good luck!
- Excel for Financial Applications, Part 1
- In Weeks 2 and 3 you will learn all about advanced financial functions and applications in Excel. In Week 2, you will first learn about the concepts of and how to implement Excel formulas for the time value of money, simple and compound interest, and various loans (amortized, interest-only, and line of credit loans). You will learn how to create amortization schedules in Excel for these loans. Week 2 concludes with a required quiz and an on-computer, in-application assignment. When you successfully complete Assignment 2, you will be given a "completion code", which you can input into the Assignment 2 submission quiz to earn credit for the assignment. For paid learners, the Week 3 Excel files will be released when you have successfully passed Quiz 3 and Assignment 3. Good luck!
- Excel for Financial Applications, Part 2
- In Week 3, you will continue learning about advanced financial features of Excel. First, you will learn about depreciation and how to calculate depreciation and implement depreciation schedules in Excel. Next, you will learn about cash flows and net present value, and how to implement Excel functions to analyze cash flows. Then, you will learn how to compare financial alternatives. Finally, you'll learn about internal rate of return (IRR) and how to implement the IRR function in Excel. The week concludes with Quiz 3 and Assignment 3. When you successfully complete Assignment 3, you will be given a "completion code", which you can input into the Assignment 3 submission quiz to earn credit for the assignment. For paid learners, the Week 4 Excel files will be released when you have successfully passed Quiz 3 and Assignment 3. Good luck!
- Case Studies and "What-If" Analyses
- One of the most valuable aspects of Excel is that it can be used nicely for case studies and "what-if" analyses. In Week 4, you'll learn about case studies, one-way and two-way data tables, and how to use the Goal Seek and Solver tools for targeting calculations. You'll also learn to use the Solver tool for optimization problems and problems for which you have constraints. The week concludes with Quiz 4 and Assignment 4. When you successfully complete Assignment 4, you will be given a "completion code", which you can input into the Assignment 4 submission quiz to earn credit for the assignment. For paid learners, the Week 5 Excel files will be released when you have successfully passed Quiz 4 and Assignment 4. Good luck!
- Model Building in Excel
- Week 5 of the course is all about creating mathematical models for experimental data. In this week, you'll first learn about how to insert trendlines into Excel plots and how to linearly interpolate between data points. Next, you'll learn about simple linear regression, general linear regression, and multilinear regression models and how to use Excel's Regression tool to create these regression models. The week concludes with an introduction to the logistic regression model, which is a type of nonlinear regression model. The week concludes with Quiz 5 and Assignment 5. When you successfully complete Assignment 5, you will be given a "completion code", which you can input into the Assignment 5 submission quiz to earn credit for the assignment. Then, you can pat yourself on the back for completing "Everyday Excel, Part 2!"
- Fecha Incio: 13/11/2023
- Idioma: Inglés
- Universidad: University of Colorado Boulder
- Profesores: Charlie Nuttelman
- Certificado: Si
Search this site
Powered by Google
Assignment 1: Build and Extend a CPU
Implement the processor microarchitecture for the QuAC ISA
A Digital Circuit
In this assessment you are going to complete a number of Digital files to a required spec, much like what you have already been doing in the labs.
The first part of this assignment builds upon the following labs:
- Lab 1: Introduction
- Lab 3: Registers
- Lab 4: Manual CPU
- Lab 5: Auto CPU
- Lab 6: Conditional Execution
If you have not completed the tasks in the above labs or do not understand the content, we strongly recommend that you first complete the labs and then start the assignment.
- Deadline: 11 April 2023, 5:00 pm
- Assessment template: link
- Specification: keep reading 🙂
- Weighting: 25%
- Marked out of: _ / 100
Rules and Policies #
- if you do, please cite them in the statement-of-originality.md
- it is your responsibility to ensure any additional files are included in the repo and pushed to gitlab correctly
- your main solution still needs to be in the provided files
- all submitted files should abide by the style guidelines
- late submission is not permitted without an extension
- it is your responsibility to ensure that your changes have been submitted to gitlab, what is present on gitlab at the time of the deadline will be considered your submission
Allowed Components #
You may use any component digital provides you, with the following exceptions:
- VHDL / Verilog / Anything outside of Digital
- Some extensions prohibit the use of certain components, check the extension page for details
Submissions that use any of the above will have marks deducted accordingly.
If this is your first time reading the document then skip this for now and open links as necessary
This assignment has a few external pages that are linked to throughout the document, for quick reference, here they are in one spot:
- QuAC ISA Definitions
- QuAC Individual Instruction Definitions
- Part 2 Extension Options
- QuAC Assembler Guide
- Design Document Guide
- Digital Style Guide
You have been building the CPU from the ground up during the first six labs. The first part of this assignment will require you to submit the CPU that conforms to the QuAC ISA .
The second part is more open-ended and will require you to extend the base ISA in an interesting way.
Part 1 (30 marks) #.
For the first part of the assignment, your task is to deliver a CPU in Digital that implements the full QuAC ISA specification.
If you have already completed the first six labs that result in a CPU for the QuAC ISA, then congratulations! You have already completed the first part of the assignment… sort of . You still need to update the files in the assignment repo and ensure they are passing the tests there. We aren’t going to refer to your lab repos, but it is fine for you to copy your components over.
Complete src/basic-cpu.dig to the full QuAC ISA specification and ensure it is passing all provided tests.
You src/basic-cpu.dig should contain only what is needed for Part 1. Your extension and further modifications will be completed in src/extended-cpu.dig . Students who further extend the src/basic-cpu.dig file will have marks removed accordingly.
Part 2 (70 marks) #
The QuAC ISA is quite limited in its capabilities compared to established ISAs, such as ARM and RISC-V. We cannot write very interesting assembly programs to solve real-world problems. The primary limitations of QuAC ISA include:
- Few logical and arithmetic operations
- Limited set of general-purpose registers
- ALU instructions cannot directly operate on immediate values
- Inability to conditionally execute on anything other than the zero flag
- Lack of a stack and dedicated push / pop instructions (this point relates to functions)
Your objective in this part of the assignment is to extend the QuAC ISA in a meaningful manner. To this end, you should note that the QuAC ISA deliberately has large gaps in the specification:
- Eight of the 16 possible operation codes (opcodes) are undefined. New instructions can thus use these opcodes and even define a new encoding format other than R-Mode or I-Mode.
- Bits  and  in the R-Mode encoding format are only defined if both are zero (allowing each R-Mode instruction to have three alternate meanings based on the values of bits  and  .)
- One of the register codes is unused, allowing for another special purpose register (check here to see which register codes are used).
- Bits [4:15] in the flag register are unused.
- The outcome/behaviour of writing to the flag register is undefined. This means that you could define writing to the flag register in the usual fashion (if you for some reason wanted to set/clear the flag bits directly) or you could add a write-only register that shares the same register code as FL (reading register code 101 reads from FL , writing to register code 101 writes to the new register.)
Your extension can broadly be whatever you like, but keep in mind that sophistication of the extension is part of the marking criteria.
Here is a list of potential extensions that you might like to consider, though if you have your own ideas, run them by your tutor first to check for suitability.
Your CPU with ISA extensions must be backwards compatible with the base QuAC ISA. This means that any changes you make must:
- involve new instructions using currently undefined opcodes or
- use undefined bits in existing instructions (or both)
- if it interacts with existing instructions it must explicitly be an improvement that does not change the expected outcome from the base ISA
Extension Implementation and Testing #
To be able to demonstrate and test the capabilities of your extension, you must make any necessary additions to the quac.json assembler config file to add support for your extensions, such that anyone can use it on your submitted CPU. Remember that the base ISA must still work, so you cannot change any existing instruction configs.
Once this has been completed, you must write at least one assembly program, demo.quac , that demonstrates your extension.
For more help on this, check out the assembler guide page .
Design Report #
Your assignment will also require the submission of a <1000 words design report describing the design decisions you made to implement the base ISA and your extension. More specifically, we would like to see:
- A high level overview of your extension
- What is the key benefit(s) of your changes
- The required changes to the microarchitecture
- Impact of changes on the CPU
- A small walkthrough of the example program
- Analysis of the tradeoffs / limitations with your implementation
You will need to successfully implement a complex extension backed up by an excellent design report to get a mark in the HD range. See more here .
Your design report should precisely describe your extension and its behaviour and encoding in a format similar to the full ISA description .
Note that we say < 1000 words. If you feel you have addressed all of what has been asked of you in less words, please don’t feel the need to hit 1000 words. You will end up writing a worse report by reducing the conciseness of it.
Complete src/extended-cpu.dig to the full QuAC ISA specification and then extend it based on the information provided above. Provide at least one assembly program demo.quac that demonstrates your extension (further files should be added and named accordingly, eg: demo-stack.quac ). Finally, write a design report in report.md detailing your extension.
To successfully complete this assignment, the following files must be submitted:
- src/basic-cpu.dig containing your CPU that implements the full QuAC ISA, but no extensions beyond that
- src/extended-cpu.dig containing your CPU that implements the full QuAC ISA and has been extended beyond the base capabilities
- quac.json containing the default quac instructions and any extra instructions, etc. that you have added
- optional demo-XXXXX.quac containing further assembly programs that demonstrate other aspects of your extension
- optional assets/* containing any images you want to add in your report
Additional Files / Sub-circuits #
We provide the files src/basic-cpu.dig and src/extended-cpu.dig as templates that contain only the dual-port memory module. You should build the CPU(s) in these files. For any other additional sub-circuits (e.g alu.dig , reg_file.dig , control_unit.dig ), please place them in the src/ directory. If your part-1 or part-2 use differing versions of these sub-circuits, then please name them appropriately.
Marking Criteria #
Your assessment will be evaluated on the following criteria:
- Correctness of your implementation of the base ISA (30/100)
- Sophistication and Correctness of your extension of the base ISA (40/100)
- Explanation and Reasoning of your extension of the base ISA (30/100)
Item 1 will be evaluated primarily through the results of your Digital tests and visual inspection. Item 2 will be evaluated primarily through visual inspection of the Digital files and the assembly program demonstrations. Item 3 will be evaluated through your report.md and the quality of the writing within.
Items 1 and 2 will also be evaluated by visually inspecting your submissions for neatness, efficiency and logical layout. For more information on how to lay things out well in Digital, check the style guide .
We will take the following aspects into account during the marking of the assignment:
- Your CPU must be able to run assembly programs written in the base QuAC ISA correctly.
- You must demonstrate the correctness of your extended CPU with a carefully written assembly program that uses the new extension. We will verify.
- No spaghetti wiring
- Wise use of diagonal wires (seldom)
- Avoid easily preventable wire crossings
- Avoid running wires under other components
- Take care that the data flow in typical combinational circuits is left-to-right
- Appropriate use of comments to explain circuit sections
- Your design should be easy to understand, this includes the packaging of abstractions
- For more info, check the style guide
- How easy would it be to modify your CPU and/or add other extensions?
- An ALU that is not using the same full adder for addition and subtraction is wasteful
- Adding an increment instruction should not use another adder
- If an instruction can be synthesised from existing instruction(s) (namely pseudo-instruction), then adding new hardware for the instruction is wasteful. The one exception is that adding hardware for the new instruction results in a more efficient execution than utilizing existing instructions, i.e., the software-only approach.
- Your design does not need to be optimal, but large sprawling, easily minimizable circuits will be penalised.
- Modifications to the control unit and ALU should have corresponding additional tests added
- New instructions should have some example code demonstrating how they work
Submission is through GitLab, the most recently pushed commit of your fork of the assessment template before the deadline is taken to be your assessment submission.
Getting Started #
- read this assessment page completely
- ensure you fork your project as private
- work on each part, testing, committing and pushing as you go
- make a mistake or get stuck, then ask a good question on the course forum .
Completion Checklist #
- you have submitted the files listed above
- you have checked that you haven’t used any of the components listed above
- you have run your files local test(s) and they pass successfully
- you have laid out all of your circuits using good practice
- you have saved, committed and pushed your Digital files to gitlab
- you have filled out, committed, and pushed your statement-of-originality.md
- you have filled out, committed, and pushed your report.md
- you have checked the report pdf artifact on gitlab to ensure it is correct
- you have checked the gitlab ci tests and they are passing
Report pdf Artifact #
Your repo will be packaged into a report pdf for marking purposes. As such it is important that you see what the result of the pdf job is and make sure the output makes sense.
- take your name and uid from the statement-of-originality.md
- take images from your basic-cpu.dig and extended-cpu.dig files
- take test results of files
- take your report from report.md
- take references from the statement-of-originality.md
- take images from all other digital files
- combine all of them into a single pdf
To view the pdf, first click the ci icon on your most recent commit ( as above ), then click on the pdf job.
Then, you’ll be taken to the job page, where you should see a “Job Artifacts” section, click on the Download button.
This will download a zip file containing your pdf. Which should look something like this.
There is more general info about gitlab ci here .
My circuits don’t work, can I email you for help? #
Sorry, you won’t get help over email or Teams. We provide a course forum which is the only way we are able to help.
Forum posts related to your assessment submission must be “private” (as for any individual assessment task).
It’s [5 minutes, 60 minutes, 12 hours] before the deadline and my CI Jobs aren’t finishing! #
Unfortunately on the day that an assessment is due, when many students are pushing updates at once, the CI servers can’t keep up. You may not see your CI jobs finish before the deadline. You will just have to manually check that your files have been submitted correctly and that you are passing tests locally.
The best way to avoid this issue is to start early and finish early 😇
If there’s any issues with your git repository after the deadline . Please let us know (after the deadline) through a private forum post and there may be something we can do.
How do I know my assessment has been submitted? #
- the files in your fork of the assessment are correct (i.e., the files you intend to submit) when checking on the gitlab website
- the time is before the deadline
then your assessment has been submitted (well done!).
Please don’t ask us to “check”, we would be just doing exactly the same thing as the above steps which you can do yourself.
I’ve done X, is that good enough to get Y marks? #
We don’t give out marks before assignments are completed, but it’s fair to wonder “How hard should I work on this?”
Realistically there are ways to complete this assignment with minor modification of what you have done in labs. Those types of submissions will be likely to get in the range of 50-59 indicating “satisfactory” performance, but not what we would call “good”.
Putting in a normal amount of further effort to create a submission that is “good” or “very good” will result in a mark between 60-79. Most students will be in this category. Don’t neglect your design report as explaining your extension is worth the same number of marks as the extension implementation itself.
Getting higher than 79 requires an “excellent” submission across all marking criteria. This requires sophisticated engagement with the task and probably some kind of extension.
For very high marks (90+): “we know it when we see it”. Only a few students will be in this category and they will have definitely put in a lot of effort to create a sophisticated extension on the basics. They will also have written an impeccable design report.
At the opposite end of the scale, if we see a submission that doesn’t meet the specification (e.g., it violates the QuAC ISA, doesn’t fully work, or there is a very weak design report), then the mark will be below 50. Hopefully, there are only a few students in this category.
Sorry that we can’t be more specific than that.
Snapsolve any problem by taking a picture. Try it in the Numerade app?