20 likes | 248 Views
BIM IF Quiz Game Project. Begin collecting photos for our If Quiz Game!! Collect 50 photos and paste them all into an Excel spreadsheet 3. Set-up your Excel Worksheet, with Functions and Formatting.
E N D
BIM IF Quiz Game Project Begin collecting photos for our If Quiz Game!! Collect 50 photos and paste them all into an Excel spreadsheet 3. Set-up your Excel Worksheet, with Functions and Formatting. -Sample statement: =IF(G198="Mulan","Wow, you’re a Princess.",IF(G198="","","Back to the Dungeon!")) -Perform CountIf functions to count number of Correct values, and Nested If Statements to clear contents of Cells if Necessary. Number Correct =COUNTIF(D15:K214,"Wow, you’re a Princess.") Number of correct possibilities: 52 Percent Correct: =L5/L7
Use Excel to create a form for people to fill out as they view your quiz to provide feedback to make it even better or tell you what they really like. • Protect worksheet so users cannot change formulas or see answers in formulas. • Provide feedback to classmates by taking part of their quizzes. • Touch up your quiz for final turn in Grade.(MAJOR)