Click here to Skip to main content
13,407,974 members (51,266 online)
Click here to Skip to main content
Articles » Web Development » ASP.NET » General » Downloads

Stats

163.5K views
6K downloads
190 bookmarked
Posted 29 May 2011

YouGrade - Asp.NET MVC Multimedia Exam Suite

A multimedia exam suite built on Asp.NET and Youtube
YouGrade
App_Data
YouGrade.mdf
YouGrade_log.LDF
Assemblies
AutoMapper.dll
bin
Content
Images
Buttons.PNG
Buttons2.png
Paper.jpg
ui-bg_diagonals-thick_18_b81900_40x40.png
ui-bg_diagonals-thick_20_666666_40x40.png
ui-bg_flat_10_000000_40x100.png
ui-bg_glass_100_f6f6f6_1x400.png
ui-bg_glass_100_fdf5ce_1x400.png
ui-bg_glass_65_ffffff_1x400.png
ui-bg_gloss-wave_35_f6a828_500x100.png
ui-bg_highlight-soft_100_eeeeee_1x100.png
ui-bg_highlight-soft_75_ffe45c_1x100.png
ui-icons_222222_256x240.png
ui-icons_228ef1_256x240.png
ui-icons_ef8c08_256x240.png
ui-icons_ffd27a_256x240.png
ui-icons_ffffff_256x240.png
YouGrade.PNG
themes
base
images
ui-bg_flat_0_aaaaaa_40x100.png
ui-bg_flat_75_ffffff_40x100.png
ui-bg_glass_55_fbf9ee_1x400.png
ui-bg_glass_65_ffffff_1x400.png
ui-bg_glass_75_dadada_1x400.png
ui-bg_glass_75_e6e6e6_1x400.png
ui-bg_glass_95_fef1ec_1x400.png
ui-bg_highlight-soft_75_cccccc_1x100.png
ui-icons_222222_256x240.png
ui-icons_2e83ff_256x240.png
ui-icons_454545_256x240.png
ui-icons_888888_256x240.png
ui-icons_cd0a0a_256x240.png
Controllers
DBScripts
Dtos
Global.asax
Model
YouGrade.edmx
Models
obj
Debug
Properties
Scripts
Views
Account
Home
Shared
YouGrade.csproj.user
YouGradeService.svc
YouGrade.mdf
YouGrade_log.LDF
AutoMapper.dll
Buttons.PNG
Buttons2.png
Paper.jpg
ui-bg_diagonals-thick_18_b81900_40x40.png
ui-bg_diagonals-thick_20_666666_40x40.png
ui-bg_flat_10_000000_40x100.png
ui-bg_glass_100_f6f6f6_1x400.png
ui-bg_glass_100_fdf5ce_1x400.png
ui-bg_glass_65_ffffff_1x400.png
ui-bg_gloss-wave_35_f6a828_500x100.png
ui-bg_highlight-soft_100_eeeeee_1x100.png
ui-bg_highlight-soft_75_ffe45c_1x100.png
ui-icons_222222_256x240.png
ui-icons_228ef1_256x240.png
ui-icons_ef8c08_256x240.png
ui-icons_ffd27a_256x240.png
ui-icons_ffffff_256x240.png
YouGrade.PNG
ui-bg_flat_0_aaaaaa_40x100.png
ui-bg_flat_75_ffffff_40x100.png
ui-bg_glass_55_fbf9ee_1x400.png
ui-bg_glass_65_ffffff_1x400.png
ui-bg_glass_75_dadada_1x400.png
ui-bg_glass_75_e6e6e6_1x400.png
ui-bg_glass_95_fef1ec_1x400.png
ui-bg_highlight-soft_75_cccccc_1x100.png
ui-icons_222222_256x240.png
ui-icons_2e83ff_256x240.png
ui-icons_454545_256x240.png
ui-icons_888888_256x240.png
ui-icons_cd0a0a_256x240.png
Global.asax
YouGrade.edmx
YouGrade.csproj.user
YouGradeService.svc
DELETE dbo.Answer
DELETE dbo.Alternative
DELETE dbo.QuestionDef
DELETE dbo.ExamTake
DELETE dbo.ExamDef
DELETE dbo.[User]
GO
INSERT dbo.[User](Login, Password, Firstname, Lastname)
	SELECT 'code', 'project', 'John', 'Doe'

DECLARE @ExamDefId INT
DECLARE @QuestionDefId INT
INSERT dbo.ExamDef (Name, Description, MinimumOfCorrectAnswers, Duration)
	SELECT 'English Listening Comprehension Test', 'Show your knowledge on the English language using videos from The Big Bang Theory', 7, CONVERT(DATETIME, '01:00:00')
SET @ExamDefId = @@IDENTITY
INSERT dbo.QuestionDef (ExamId, Text, Url, StartSeconds, Explanation, Mark, IsMultiSelect)
	SELECT
	@ExamDefId, 
	'In this episode, Sheldon proposes to Raj a variation for the classic "Jokempo" game: instead of "rock-paper-scissors", the variation is "rock-paper-scissors-lizard-spock". In his explanation for the game rules, Sheldon points out that paper beats Spock. How can Spock be defeated by paper?',
	'iapcKVn7DdY',
	0,
	'',
	'',
	0
SET @QuestionDefId = @@IDENTITY
INSERT dbo.Alternative (QuestionId, Id, Text, Correct)
	SELECT 
	@QuestionDefId,
	'A', 'A large sheet of paper can wrap Spock, in the same way that it covers rock.', 0 UNION
	SELECT 
	@QuestionDefId,
	'B', 'Spock''s fingers are not as sharp as scissors, and paper can cut his finger deep.', 0 UNION
	SELECT 
	@QuestionDefId,
	'C', 'Being Spock a scientist, a paper (academic research) can refute one of his theories.', 1 UNION
	SELECT 
	@QuestionDefId,
	'D', 'Paper doesn''t beat Spock. In fact, Sheldon points out that Spock against paper ends in a tie.', 0

INSERT dbo.QuestionDef (ExamId, Text, Url,StartSeconds, Explanation, Mark, IsMultiSelect)
	SELECT
	@ExamDefId, 
	'In "The Friendship Algorithm", Sheldon is learning about friendship and draws a flowchart in his white board. He then invites Kripke to go out with him in some activity. Sheldon uses the friendship algorithm, but every activity proposed by Kripke is rejected by Sheldon, and at some point he gets stuck in an infinite loop. How Howard managed to help him get out of the loop?',
	'w7j7E7J3f6E',
	0,
	'',
	'',
	0
SET @QuestionDefId = @@IDENTITY
INSERT dbo.Alternative (QuestionId, Id, Text, Correct)
	SELECT 
	@QuestionDefId,
	'A', 'Howard convinced Sheldon to practice rock climbing with Kripke.', 0 UNION
	SELECT 
	@QuestionDefId,
	'B', 'By drawing a loop counter and an escape to the least objectionable activity.', 1 UNION
	SELECT 
	@QuestionDefId,
	'C', 'In fact, Howard doesn''t help Sheldon at all. Sheldon decides to go rock climbinbg by itself.', 0 UNION
	SELECT 
	@QuestionDefId,
	'D', 'Sheldon doesn''t get out of the infinite loop. He just get a break to do some internet search before finishing the friendship algorithm path.', 0
INSERT dbo.QuestionDef (ExamId, Text, Url, StartSeconds,Explanation, Mark, IsMultiSelect)
	SELECT
	@ExamDefId, 
	'In this video, somebody is auctioning a time machine replica from the "Time Machine" movie. Leonard bid $800, and when the auction ends, Sheldon is surprised that no one else bid, since it''s a piece of sci-fi movie memorabilia. In the end of the video, Sheldon says he understood why no-one else bid. Why he said so?',
	'fRaUVp5DfRk',
	34,
	'',
	'',
	0
SET @QuestionDefId = @@IDENTITY
INSERT dbo.Alternative (QuestionId, Id, Text, Correct)
	SELECT 
	@QuestionDefId,
	'A', 'Because instead of a miniature, Sheldon found the time machine replica to be in fact full-sized and extravagant.', 1 UNION
	SELECT 
	@QuestionDefId,
	'B', 'Because Sheldon saw it wasn''t a real time machine.', 0 UNION
	SELECT 
	@QuestionDefId,
	'C', 'Because it was nothing like the time machine in the movie.', 0 UNION
	SELECT 
	@QuestionDefId,
	'D', 'Because the time machine was damaged.', 0
INSERT dbo.QuestionDef (ExamId, Text, Url, StartSeconds,Explanation, Mark, IsMultiSelect)
	SELECT
	@ExamDefId, 
	'At the University cafeteria, Sheldon is discussing with his friend Leonard the problem with teleportation. At the end, Leonard seems to agree with Sheldon that there is a problem. What problem they are talking about?',
	'PQZzSrAIp-E',
	0,
	'',
	'',
	0
SET @QuestionDefId = @@IDENTITY
INSERT dbo.Alternative (QuestionId, Id, Text, Correct)
	SELECT 
	@QuestionDefId,
	'A', 'Both agreed that it would be a problem if the teletransporter had to disintegrate the original Sheldon in order to create the new Sheldon', 0 UNION
	SELECT 
	@QuestionDefId,
	'B', 'Both agreed that it would be a problem if the new Sheldon created by the teletransporter had no new improvements compared to the old Sheldon.', 0 UNION
	SELECT 
	@QuestionDefId,
	'C', 'Sheldon said it would be a problem if the teletransporter had to disintegrate the original Sheldon in order to create the new Sheldon, and Leonard just pretended to care about it.', 0 UNION
	SELECT 
	@QuestionDefId,
	'D', 'Sheldon said he would never use a teletransporter, because this would disintegrate the original Sheldon in order to create the new Sheldon. Leonard, on the other hand, thought it was a problem if the new Sheldon was exactly the same as the old Sheldon (without improvements), but Sheldon didn''t understand Leonard''s sarcasm.', 1
GO

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author


You may also be interested in...

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.180221.1 | Last Updated 8 Jun 2011
Article Copyright 2011 by Marcelo Ricardo de Oliveira
Everything else Copyright © CodeProject, 1999-2018
Layout: fixed | fluid